Guten Abend Community
ich bekomme ständig den selben Fehler und ich schaffe es nicht ihn zu fixen.
Wäre Lieb wenn ich eure Hilfe bekommen könnte.
Fehlercode:
Bash
[2016-11-17 22:58:07] ERROR: register_login_server.lua:782: attempt to index local 'dsatz' (a nil value)
[2016-11-17 22:58:07] WARNING: register_login_server.lua:186: dbExec failed; (1364) Field 'Spezial' doesn't have a default value
[2016-11-17 22:58:07] WARNING: register_login_server.lua:778: dbExec failed; (1364) Field 'Spezial' doesn't have a default value
[2016-11-17 22:58:16] QUIT: exiLe left the game [Quit]
[2016-11-17 22:58:16] ERROR: data_server.lua:31: attempt to concatenate a boolean value
Zeilen: (register_login)
Lua
local result = dbExec ( handler, "INSERT INTO inventar (UID) VALUES (?)", id )
if not result then
outputDebugString ( "[register_func 3] Error executing the query" )
end
Lua
function inventoryload ( player )
local pname = getPlayerName ( player )
vioSetElementData ( player, "playerid", playerUID[pname] )
local dsatz
local result = dbPoll ( dbQuery ( handler, "SELECT * from inventar WHERE UID = ?", playerUID[pname] ), -1 )
if not result or not result[1] then
dbExec ( handler, "INSERT INTO inventar (UID) VALUES (?)", playerUID[pname] )
result = dbPoll ( dbQuery ( handler, "SELECT * from inventar WHERE UID = ?", playerUID[pname] ), -1 )
end
dsatz = result[1]
if dsatz["Wuerfel"] then
vioSetElementData ( player, "dice", tonumber ( dsatz["Wuerfel"] ) )
else
vioSetElementData ( player, "dice", 0 )
end
vioSetElementData ( player, "flowerseeds", tonumber ( dsatz["Blumensamen"] ) )
vioSetElementData ( player, "food1", tonumber ( dsatz["Essensslot1"] ) )
vioSetElementData ( player, "food2", tonumber ( dsatz["Essensslot2"] ) )
vioSetElementData ( player, "food3", tonumber ( dsatz["Essensslot3"] ) )
vioSetElementData ( player, "zigaretten", tonumber ( dsatz["Zigaretten"] ) )
vioSetElementData ( player, "mats", tonumber ( dsatz["Materials"] ) )
vioSetElementData ( player, "benzinkannister", tonumber ( dsatz["Benzinkanister"] ) )
vioSetElementData ( player, "fruitNotebook", tonumber ( dsatz["FruitNotebook"] ) )
vioSetElementData ( player, "casinoChips", tonumber ( dsatz["Chips"] ) )
vioSetElementData ( player, "gameboy", tonumber ( dsatz["Gameboy"] ) )
vioSetElementData ( player, "medikits", tonumber ( dsatz["Medikit"] ) )
vioSetElementData ( player, "repairkits", tonumber ( dsatz["Repairkit"] ) )
-- X-MAS --
-- vioSetElementData ( player, "presents", tonumber ( dsatz["Geschenke"] ) )
-- X-MAS --
end
Alles anzeigen
Zeilen (data_server)
Lua
function saveAddictionsForPlayer ( player )
local pname = getPlayerName ( player )
local dataString1 = vioGetElementData ( player, "cigarettFlushPoints" ).."|"..vioGetElementData ( player, "alcoholFlushPoints" ).."|"..vioGetElementData ( player, "drugFlushPoints" ).."|"
local dataString2 = vioGetElementData ( player, "cigarettAddictPoints" ).."|"..vioGetElementData ( player, "alcoholAddictPoints" ).."|"..vioGetElementData ( player, "drugAddictPoints" ).."|"
dbExec ( handler, "UPDATE ?? SET ??=?, ??=? WHERE ??=?", "userdata", "Rausch", dataString1, "Sucht", dataString2, "UID", playerUID[pname] )
end
Über eure Hilfe freue ich mich.
LG exiLe