1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
|
--[[
A script to move the player to a different map
]]
local fn = nrequire("utility/fn.lua")
local q = nrequire("core/database/queries.lua")
nrequire("sv_mysqlite.lua")
local mapname = game.GetMap()
local mapareasstr = file.Read("artery/maps/" .. mapname .. "/mapareas.txt")
--[=[
local dontupdatedisconnect = {}
hook.Add("InitPostEntity", "LoadMapChangePoints", function()
local transfers = string.Explode("\r?\n\r?\n",mapareasstr,true)
for k,v in pairs(transfers) do
local parts = string.Explode("\r?\n",v,true)
local vectortxt = string.Explode(" ",parts[1],false)
local svec = Vector(vectortxt[1],vectortxt[2],vectortxt[3])
local name = parts[2]
local server = parts[3]
local model = parts[4]
local tvt = string.Explode(" ",parts[5],false)
local sch = ents.Create("art_serverchanger")
sch.Model = model
sch.Pos = svec
sch.OnHit = function(self, coldata,collider)
print("Coldata")
PrintTable(coldata)
print("collider",collider)
if coldata.HitEntity:IsPlayer() then
dontupdatedisconnect[coldata.HitEntity] = true
local qc = table.concat({[[
UPDATE playerdata SET MetaData="]],
tvt[1]," ",
tvt[2]," ",
tvt[3]," ",
[[" WHERE SteamID="]],
coldata.HitEntity:SteamID64(),
'"'})
local query = [[
UPDATE playerdata SET PlayerData='%s',MetaData='%s' WHERE SteamID=%.0f
]]
local pdat = util.TableToJSON(coldata.HitEntity.data)
local pmet = util.TableToJSON({
lastserver = server,
lastlocation = parts[5]
})
print("pdat is", pdat)
print("pmet is", pmet)
local fquery = q.s_fmt(query,pdat,pmet,coldata.HitEntity:SteamID64())
print("fquery was", fquery)
print("Running query:",qc)
MySQLite.query(fquery,function(data)
coldata.HitEntity:ConCommand("connect " .. server)
end,function(err,sql)
print("Query error:")
print("Query",sql)
print("Error",err)
end)
end
end
sch:Spawn()
print("Loading mapchange area",svec)
end
end)
]=]
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",function(ply)
local qc
if dontupdatedisconnect[ply] then
dontupdatedisconnect[ply] = nil
qc = table.concat({
[[UPDATE artery.playerdata SET
Inventory="]],
util.TableToJSON(ply.Inventory),
[[",
Skills="]],
util.TableToJSON(ply.Skills),
[[",
Quests="]],
util.TableToJSON(ply.Quests),
[["
WHERE SteamID = "]],
ply:SteamID64(),
[[";]]
})
else
local pp = ply:GetPos()
qc = table.concat({
[[UPDATE artery.playerdata SET
Inventory="]],
util.TableToJSON(ply.Inventory),
[[",
Skills="]],
util.TableToJSON(ply.Skills),
[[",
Quests="]],
util.TableToJSON(ply.Quests),
[[",
WorldPosition="]],
pp[1]," ",pp[2]," ",pp[3],
[[",
World="]],
game.GetIPAddress(),
[["
WHERE SteamID = "]],
ply:SteamID64(),
[[";]]
})
end
local q = ART.database:query(qc)
function q:onSuccess(data)
print("Saveing player data successful")
PrintTable(data)
end
function q:onError(err, sql)
print("Saveing player data errored!")
print("Query",sql)
error(err)
end
q:start()
end)
]=]
|
