--[[
    A script to move the player to a different map
]]
local fn = nrequire("utility/fn.lua")
local q = nrequire("core/database/sv_queries.lua")
nrequire("sv_mysqlite.lua")
local mapname = game.GetMap()
local mapareasstr = file.Read("artery/maps/" .. mapname .. "/mapareas.txt")

local function SavePlayerData(ply)
	local query
	local pdat = q.serialize_player(ply)
    if dontupdatedisconnect[ply] then
        dontupdatedisconnect[ply] = nil
		query = [[
		UPDATE playerdata SET PlayerData='%s' WHERE SteamID=%.0f
		]]
		query = q.s_fmt(query,pdat,ply:SteamID64())
    else
		query = [[
		UPDATE playerdata SET PlayerData='%s' MetaData='%s' WHERE SteamID=%.0f
		]]
		local pmet = util.TableToJSON({
			lastserver = game.GetIPAddress(),
			lastlocation = ply:GetPos()
		})
		query = q.s_fmt(query,pdat,pmet,ply:SteamID64())
    end
	MySQLite.query(query,function(data)
		
	end,function(err,sql)
		print("Query error:")
		print("Query",sql)
		print("Error",err)
	end)
end

hook.Add("PlayerDisconnected","SavePlayerData",SavePlayerData)