Leute machen einen Account und nach dem reconnecten steht da Spieler existiert nicht:
Fehlercode:
Code
[19:59:04] WARNING: ultimate/register_login/register_login_server.lua:172: dbExec failed; (1364) Field 'ts3uid' doesn't have a default value
Lua
local registerdatum = tostring(day.."."..month.."."..year..", "..hour..":"..minute)
local lastlogin = registerdatum
passwort = hash ( "sha512", passwort )
local lastLoginInt = getSecTime ( 0 )
local id = tonumber ( dbPoll ( dbQuery ( handler, "SELECT ?? FROM ?? WHERE id=id", "id", "idcounter" ), -1 )[1]["id"] )
dbExec ( handler, "UPDATE ?? SET ?? = ?", "idcounter", "id", id+1 )
local result = dbExec ( handler, "INSERT INTO players ( UID, Name, Serial, IP, Last_login, Geburtsdatum_Tag, Geburtsdatum_Monat, Geburtsdatum_Jahr, Passwort, Geschlecht, RegisterDatum, LastLogin) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)", id, pname, getPlayerSerial(player), getPlayerIP ( player ), lastlogin, tonumber ( bday), tonumber ( bmon), tonumber ( byear), passwort, geschlecht, registerdatum, lastLoginInt )
if not result then
outputDebugString ( "[register_func 1] Error executing the query" )
else
triggerClientEvent ( player, "infobox_start", player, "Du hast dich\nerfolgreich registriert!\n\nDeine Daten werden\nnun gespeichert!", 7500, 0, 255, 0 )
playerUID[pname] = id
playerUIDName[id] = pname
end
local result = dbExec ( handler, "INSERT INTO achievments (UID) VALUES (?)", id )
if not result then
outputDebugString ( "[register_func 2] Error executing the query" )
end
local result = dbExec ( handler, "INSERT INTO inventar (UID) VALUES (?)", id )
if not result then
outputDebugString ( "[register_func 3] Error executing the query" )
end
local result = dbExec ( handler, "INSERT INTO packages (UID, Paket1, Paket2, Paket3, Paket4, Paket5, Paket6, Paket7, Paket8, Paket9, Paket10, Paket11, Paket12, Paket13, Paket14, Paket15, Paket16, Paket17, Paket18, Paket19, Paket20, Paket21, Paket22, Paket23, Paket24, Paket25) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", id,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0' )
if not result then
outputDebugString ( "[register_func 4] Error executing the query" )
Alles anzeigen