dbtXfiqA

1/*
2	Please Double check you have MySQL and mysqloo modules are installed.
3	You can get mysqloo module at here. http://facepunch.com/showthread.php?t=1220537
4	You should have database called ' 3dcardealer '. if not, make it
5	
6	And also you need datatable called ' cardealer_inventory '. if not make it with this code.
7	
8DROP TABLE IF EXISTS `cardealer_inventory`;
9CREATE TABLE `cardealer_inventory` (
10 `ID` char(64) NOT NULL,
11 `JSONData` text NOT NULL,
12 PRIMARY KEY (`ID`)
13) ENGINE=MyISAM DEFAULT CHARSET=latin1
14
15*/
16
17
18
19
20
21
22
23-- MySQLoo
24require( "mysqloo" )
25local mysql_hostname = '127.0.0.1' -- Your MySQL server address.
26local mysql_username = 'root' -- Your MySQL username.
27local mysql_password = 'Private' -- Your MySQL password.
28local mysql_database = 'dbK' -- Your MySQL database.
29local mysql_port = 3306 -- Your MySQL port. Most likely is 3306.
30
31local db = mysqloo.connect(mysql_hostname, mysql_username, mysql_password, mysql_database, mysql_port)
32db:connect()
33
34function RXCar_Provider_GetSQL()
35	return db
36end
37
38function RXCar_Provider_GetInventory(PlySID,CallBackfunc)
39	PlySID = string.gsub(PlySID,"_",":")
40
41	local q = db:query( "SELECT * FROM cardealer_inventory WHERE ID = '" .. PlySID .."'" ) -- 데이터 삽입
42	function q:onSuccess(data)
43		if data and data[1] then
44			CallBackfunc(util.JSONToTable(data[1].JSONData))
45		else
46			CallBackfunc({})
47		end
48	end
49	function q:onError(err, sql)
50		MsgN('3D Car dealer 2 : There is error on MySQL Module')
51	end
52	q:start()
53end
54
55function RXCar_Provider_SaveInventory(PlySID,InventoryData,CallBackfunc)
56	PlySID = string.gsub(PlySID,"_",":")
57
58	-- Existing Check
59	local q = db:query( "SELECT * FROM cardealer_inventory WHERE ID = '" .. PlySID .."'" ) -- 데이터 삽입
60	function q:onSuccess(data)
61		if data and data[1] then
62			-- HAS DATA
63			local QUERY = "UPDATE "
64			QUERY = QUERY .. "cardealer_inventory "
65			QUERY = QUERY .. "SET JSONData = '" .. util.TableToJSON(InventoryData) .."'"
66			QUERY = QUERY .. " WHERE ID = '" .. PlySID .. "'"
67			
68			local q = db:query( QUERY ) -- 데이터 삽입
69			function q:onError(err, sql)
70				MsgN('3D Car dealer 2 : There is error on MySQL Module')
71			end
72			function q:onSuccess()
73				CallBackfunc(InventoryData)
74			end
75			q:start()
76		else
77			local QUERY = "INSERT INTO "
78			QUERY = QUERY .. "cardealer_inventory "
79			QUERY = QUERY .. "(`ID`,`JSONData`) "
80			QUERY = QUERY .. "VALUES ('"..PlySID.."' ,'"..util.TableToJSON( InventoryData ).."')"
81			local q = db:query( QUERY ) -- 데이터 삽입
82			function q:onSuccess(data)
83				CallBackfunc(InventoryData)
84			end
85			function q:onError(err, sql)
86				MsgN('3D Car dealer 2 : There is error on MySQL Module')
87			end
88			q:start()
89			
90		end
91	end
92	function q:onError(err, sql)
93		MsgN('3D Car dealer 2 : There is error on MySQL Module')
94	end
95	q:start()
96	
97	
98
99end