For some reason… my server just randomly crashes (No errors I have seen), everytime I have multiple queries within each other.
EDIT
Here is the code thats having the problem…
[LUA]
function Test.LoadCharacter(ply, cidnum)
if ((cidnum > ply.NumChars) or (cidnum <= 0)) then
Liquid.Notify(ply, "You don't have that amount of of characters!")
else -- This will load the character that will be used for that time.
local cid = ""
tmysql.query("SELECT cid"..cidnum.." FROM testrp_accounts WHERE steamid='"..ply:SteamID().."'",
function(res,status,error)
if res then
ply.RolePlayData.CID = res[1]["cid1"]
print(ply.RolePlayData.CID)
print(ply.RolePlayData.CID)
PrintTable(res)
tmysql.query("SELECT cid, rpname, money FROM testrp_characters WHERE cid='"..ply.RolePlayData.CID.."'", function(resz)
PrintTable(resz)
ply.RolePlayData.CID = resz[1][1]
ply.RolePlayData.Rpname = resz[1][2]
ply.RolePlayData.Money = resz[1][3]
PrintTable(ply.RoleplayData)
end, 1)
else
Msg("Crazzzzzzzy! its a null table!")
end
end, 1)
end
end
[/LUA]