Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if SERVER then
- require("mysqloo")
- function connectToDatabase()
- databaseObject = mysqloo.connect("highvoltage-rp.com", "highvoltage", "nono", "highvoltage_darkrptimes", 3306)
- databaseObject.onConnected = function() print("Database linked!") end
- databaseObject.onConnectionFailed = function() print("Failed to connect to the database.") end
- databaseObject:connect()
- end
- connectToDatabase()
- function DisconnectMysql( ply )
- time = os.time()
- local query1 = databaseObject:query("UPDATE times SET money="..ply:GetMoney()..", last_online="..time..", rank='"..ply:GetUserGroup().."', time_connected='"..ply:TimeConnected().."'' WHERE steamid='"..ply:SteamID().."'")
- query1.onSuccess = function(q)
- if not checkQuery(q) then
- local query2 = databaseObject:query("INSERT INTO times (steamid, username, time_connected, money, last_online, rank) VALUES ('" .. ply:SteamID() .. "', '" .. ply:Name() .. "', '".. ply:TimeConnected() .."', '" .. ply:GetMoney() .. "', ".. time .. ", '"..ply:GetUserGroup().."')")
- query2.onSuccess = function(q) print("Created you!") end
- query2.onError = function(q,e) print("something went wrong") end
- query2:start()
- else
- print("You are already created!")
- end
- end
- query1.onError = function(q,e)
- if not checkQuery(q) then
- local query3 = databaseObject:query("INSERT INTO times (steamid, username, time_connected, money, last_online, rank) VALUES ('" .. ply:SteamID() .. "', '" .. ply:Name() .. "', '".. ply:TimeConnected() .."', '" .. ply:GetMoney() .. "', ".. time .. ", '"..ply:GetUserGroup().."')")
- query3.onSuccess = function(q) print("Created you!") end
- query3.onError = function(q,e) print("something went wrong") end
- query3:start()
- else
- print("You are already created!")
- end
- end
- query1:start()
- local query1 = db:query("INSERT INTO times (steamid, username, time_connected, money, last_online, rank) VALUES ('" .. ply:SteamID() .. "', '" .. ply:Name() .. "', '".. ply:TimeConnected() .."', '" .. ply:GetMoney() .. "', ".. time .. ", '"..ply:GetUserGroup().."')");
- end
- hook.Add( "PlayerInitialSpawn", "pInitialSpawn", DisconnectMysql )
- end
Advertisement
Add Comment
Please, Sign In to add comment