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