· 7 years ago · Feb 08, 2019, 01:00 PM
1require("mysqloo")
2
3include( "mysqloolib.lua" )
4
5EL_MINE.db = EL_MINE.db
6
7function EL_MINE:onDataBaseConnected()
8 print("[EL MINE] RUN ALL QUERY")
9
10 local trans = EL_MINE.db:CreateTransaction()
11
12 trans:Query([[
13 CREATE TABLE IF NOT EXISTS `el_mine_config` (
14 `data` TEXT NOT NULL
15 )
16 ]])
17
18 trans:Start( function( trans, status, error )
19 print( "Success" )
20 end )
21end
22
23//EL_MINE:onDataBaseConnected()
24
25function EL_MINE:SaveConfig()
26 return {}
27end
28
29function EL_MINE:RetrievePlayer()
30 return {}
31end
32
33function EL_MINE:SavePlayer( ply )
34 ply.shouldSave = false
35end
36
37if ( !EL_MINE.db ) then
38 print("[EL MINE] Connecting to db...")
39 EL_MINE.db = mysqloo.CreateDatabase( "127.0.0.1", "root", "root", "gmod", 3306 )
40 function EL_MINE.db:onConnected()
41 print("[EL MINE] DB Connected")
42 EL_MINE:onDataBaseConnected()
43 end
44end