aboutsummaryrefslogtreecommitdiff
path: root/gamemode/core/database/sv_setup.lua
diff options
context:
space:
mode:
authorAlexander Pickering <alexandermpickering@gmail.com>2017-05-20 11:37:23 -0400
committerAlexander Pickering <alexandermpickering@gmail.com>2017-05-20 11:37:23 -0400
commitc6698dad925e75ffd2ca2f2e30a595d4ce48d240 (patch)
tree226338dc7ee26a6316951554cf953112ba072c76 /gamemode/core/database/sv_setup.lua
parent9e0537b0aa417e88a6a61238484ddcef74080ae0 (diff)
downloadartery-c6698dad925e75ffd2ca2f2e30a595d4ce48d240.tar.gz
artery-c6698dad925e75ffd2ca2f2e30a595d4ce48d240.tar.bz2
artery-c6698dad925e75ffd2ca2f2e30a595d4ce48d240.zip
Massive changes I guess
Diffstat (limited to 'gamemode/core/database/sv_setup.lua')
-rw-r--r--gamemode/core/database/sv_setup.lua44
1 files changed, 22 insertions, 22 deletions
diff --git a/gamemode/core/database/sv_setup.lua b/gamemode/core/database/sv_setup.lua
index 2cb69d1..fd44174 100644
--- a/gamemode/core/database/sv_setup.lua
+++ b/gamemode/core/database/sv_setup.lua
@@ -30,15 +30,15 @@ end
local function connect()
- print("Connecting to the database...")
+ --print("Connecting to the database...")
MySQLite.initialize(config)
end
hook.Add("DatabaseInitialized","setup_table",function()
assert(MySQLite.isMySQL(),"Database wasn't mysqloo, something is probably wrong!")
local setup_success = function(res,li)
- print("Set up connection to db")
+ --print("Set up connection to db")
end
- print("Setup query:",setup_db)
+ --print("Setup query:",setup_db)
MySQLite.query(setup_db,setup_success,q_fai)
end)
@@ -52,56 +52,56 @@ function sql.GetPlayerData(ply)
local s64 = ply:SteamID64()
local q_str = q.s_fmt(fetch_player_query,s64)
local q_suc = function(res,li)
- print("Got player's data:",res,type(res))
+ --print("Got player's data:",res,type(res))
if res == nil then
- print("Was nil, createing player data")
+ --print("Was nil, createing player data")
sql.CreatePlayerTable(ply)
else
- PrintTable(res)
+ --PrintTable(res)
assert(#res == 1,"Not unique!")
- print("Was unique!")
+ --print("Was unique!")
local meta = res[1].MetaData
local plyd = res[1].PlayerData
local mtbl = util.JSONToTable(meta)
- print("About to check if we are on the right server")
+ --print("About to check if we are on the right server")
if mtbl.lastserver ~= game.GetIPAddress() then
- print("Connecting player to ", mtbl.lastserver, " was on ", game.GetIPAddress())
+ --print("Connecting player to ", mtbl.lastserver, " was on ", game.GetIPAddress())
ply:ConCommand("connect " .. mtbl.lastserver)
return
end
- print("We were on the right server")
+ --print("We were on the right server")
- print("Before finding data in the metatable, mtbl was ")
- PrintTable(mtbl)
- print(type(mtbl.lastlocation))
+ --print("Before finding data in the metatable, mtbl was ")
+ --PrintTable(mtbl)
+ --print(type(mtbl.lastlocation))
local _,_,x,y,z = string.find(mtbl.lastlocation,"([-%d%.]+) ([-%d%.]+) ([-%d%.]+)")
local vec = {x,y,z}
for k,v in pairs(vec) do vec[k] = tonumber(v) end
- print("setting player pos to")
- PrintTable(vec)
+ --print("setting player pos to")
+ --PrintTable(vec)
ply:SetPos(Vector(unpack(vec)))
q.deserialize_player(ply,plyd)
end
end
- print("doing query",q_str)
+ --print("doing query",q_str)
MySQLite.query(q_str,q_suc,q_fai)
end
function sql.CreatePlayerTable(ply)
- print("Createing player table....")
+ --print("Createing player table....")
local s64 = ply:SteamID64()
- print("steamid was", s64)
+ --print("steamid was", s64)
local plytbl = data.newdata()
local plymet = data.newmeta()
local plydata = util.TableToJSON(plytbl)
local metdata = util.TableToJSON(plymet)
local q_str = q.s_fmt(create_player_query,s64,plydata,metdata)
local q_suc = function(res,li)
- print("Inserted new player",ply)
+ --print("Inserted new player",ply)
sql.GetPlayerData(ply)
end
- print("doing query", q_str)
+ --print("doing query", q_str)
MySQLite.query(q_str,q_suc,q_fai)
end
@@ -114,7 +114,7 @@ function sql.SendPlayerToInstance(ply,ls,ll)
})
local q_str = q.s_fmt(save_player_query,plymeta,plydata,s64)
local q_suc = function(res,li)
- print("Successfully saved player data")
+ --print("Successfully saved player data")
end
MySQLite.query(q_str,q_suc,q_fai)
end
@@ -131,6 +131,6 @@ concommand.Add("DoQuery",function(ply,cmd,args)
end
end)
-print("In sv_setup.lua, sql before returning is", sql)
+--print("In sv_setup.lua, sql before returning is", sql)
return sql