· 7 years ago · Feb 08, 2019, 01:20 PM
1require("mysqloo")
2
3EL_MINE.db = mysqloo.connect( "127.0.0.1", "root", "root", "gmod", 3306 )
4
5function EL_MINE:onDataBaseConnected()
6 print("[EL MINE] RUN ALL QUERY")
7
8 local q = EL_MINE.db:query([[
9 CREATE TABLE IF NOT EXISTS `el_mine_config` (
10 `data` TEXT NOT NULL
11 )
12 ]])
13
14 function q:onSuccess( data, sql )
15 print( "[EL MINE] Query: " .. sql )
16 PrintTable(data)
17 end
18
19 function q:onError( err )
20 print("[EL MINE] ERROR")
21 end
22
23 function q:onAbort()
24 print("[EL MINE] ABORT")
25 end
26
27 q:start()
28end
29
30--EL_MINE:onDataBaseConnected()
31
32function EL_MINE:SaveConfig()
33 return {}
34end
35
36function EL_MINE:RetrievePlayer()
37 return {}
38end
39
40function EL_MINE:SavePlayer( ply )
41 ply.shouldSave = false
42end
43
44function EL_MINE.db:onConnected()
45 print("[EL MINE] DB Connected")
46 EL_MINE:onDataBaseConnected()
47end
48EL_MINE.db:connect()