Hi ich benutze das Ultimate Script.
Plötzlich ist dieser
ERROR: ultimate/register_login/register_login_server.lua:169: attempt to index field '?' (a nil value) aufgetaucht.Die Funktion aus dem Script ist folgende:
Code
function register_func ( player, passwort, bday, bmon, byear, geschlecht )
if player == client then
local pname = getPlayerName ( player )
if vioGetElementData ( player, "loggedin" ) == 0 and not isRegistered ( pname ) and player == client then
setPlayerLoggedIn ( pname )
dbExec ( handler, "DELETE FROM players WHERE Name LIKE '"..pname.."'" )
dbExec ( handler, "DELETE FROM userdata WHERE Name LIKE '"..pname.."'" )
toggleAllControls ( player, true )
vioSetElementData ( player, "loggedin", 1 )
triggerClientEvent ( source, "DisableRegisterGui", source )
local ip = getPlayerIP ( player )
if geschlecht == nil then
geschlecht = 1
end
local regtime = getRealTime()
local year = regtime.year + 1900
local month = regtime.month + 1
local day = regtime.monthday
local hour = regtime.hour
local minute = regtime.minute
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" )
end
local result = dbExec ( handler, "INSERT INTO bonustable (UID, Lungenvolumen, Muskeln, Kondition, Boxen, KungFu, Streetfighting, CurStyle, PistolenSkill, DeagleSkill, ShotgunSkill, AssaultSkill) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)", id, 'none', 'none', 'none', 'none', 'none', 'none', '4', 'none', 'none', 'none', 'none' )
if not result then
outputDebugString ( "[register_func 5] Error executing the query" )
end
local result = dbExec ( handler, "INSERT INTO statistics ( UID ) VALUES (?)", id )
if not result then
outputDebugString ( "[register_func 6] Error executing the query" )
end
local result = dbExec ( handler, "INSERT INTO skills ( UID ) VALUES (?)", id )
if not result then
outputDebugString ( "[register_func 7] Error executing the query" )
end
vioSetElementData ( player, "money", 15000 )
vioSetElementData ( player, "points", 0 )
vioSetElementData ( player, "packages", "90000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000" )
local Spawnpos_X = -1969.730
vioSetElementData ( player, "spawnpos_x", Spawnpos_X )
local Spawnpos_Y = 116.0128
vioSetElementData ( player, "spawnpos_y", Spawnpos_Y )
local Spawnpos_Z = 28
vioSetElementData ( player, "spawnpos_z", Spawnpos_Z )
local Spawnrot_X = 0
vioSetElementData ( player, "spawnrot_x", Spawnrot_X )
local SpawnInterior = 0
vioSetElementData ( player, "spawnint", SpawnInterior )
local SpawnDimension = 0
vioSetElementData ( player, "spawndim", SpawnDimension )
vioSetElementData ( player, "fraktion", 0 )
vioSetElementData ( player, "rang", 0 )
vioSetElementData ( player, "adminlvl", 0 )
vioSetElementData ( player, "playingtime", 0 )
vioSetElementData ( player, "curcars", 0 )
vioSetElementData ( player, "maxcars", 5 )
for i=1, 20 do
vioSetElementData ( player, "carslot"..i, 0 )
end
vioSetElementData ( player, "deaths", 0 )
vioSetElementData ( player, "kills", 0 )
vioSetElementData ( player, "gangwarwins", 0 )
vioSetElementData ( player, "gangwarlosses", 0 )
vioSetElementData ( player, "jailtime", 0 )
vioSetElementData ( player, "prison", 0 )
vioSetElementData ( player, "bail", 0 )
vioSetElementData ( player, "heaventime", 0 )
vioSetElementData ( player, "housekey", 0 )
vioSetElementData ( player, "bizkey", 0 )
vioSetElementData ( player, "bankmoney", 35000 )
vioSetElementData ( player, "drugs", 0 )
local Skinid = getRandomRegisterSkin ( player, geschlecht )
vioSetElementData ( player, "skinid", Skinid )
vioSetElementData ( player, "carlicense", 0 )
vioSetElementData ( player, "bikelicense", 0 )
vioSetElementData ( player, "lkwlicense", 0 )
vioSetElementData ( player, "helilicense", 0 )
vioSetElementData ( player, "planelicensea", 0 )
vioSetElementData ( player, "planelicenseb", 0 )
vioSetElementData ( player, "motorbootlicense", 0 )
vioSetElementData ( player, "segellicense", 0)
vioSetElementData ( player, "fishinglicense", 0)
vioSetElementData ( player, "wanteds", 0 )
vioSetElementData ( player, "stvo_punkte", 0 )
vioSetElementData ( player, "gunlicense", 0 )
vioSetElementData ( player, "perso", 0 )
vioSetElementData ( player, "boni", 1000 )
vioSetElementData ( player, "pdayincome", 0 )
vioSetElementData ( player, "hitglocke", 0 )
vioSetElementData ( player, "medikits", 0 )
vioSetElementData ( player, "repairkits", 0 )
local run = 1
while true do
if run >= 20 then
break
else
run = run + 1
end
local tnr = math.random ( 1000, 9999999 )
local result = dbPoll ( dbQuery ( handler, "SELECT ?? FROM ?? WHERE ??=?", "Telefonnr", "userdata", "Telefonnr", tnr ), -1 )
if not result or not result[1] then
if tonumber ( tnr ) ~= 911 and tonumber ( tnr ) ~= 333 and tonumber ( tnr ) ~= 400 and tonumber (tnr ) ~= 666666 then
Telefonnr = tnr
break
end
end
end
if Telefonnr == nil then
Telefonnr = math.random ( 1000, 9999999 )
end
vioSetElementData ( player, "telenr", Telefonnr )
vioSetElementData ( player, "warns", 0 )
vioSetElementData ( player, "gunboxa", "0|0" )
vioSetElementData ( player, "gunboxb", "0|0" )
vioSetElementData ( player, "gunboxc", "0|0" )
vioSetElementData ( player, "job", "none" )
vioSetElementData ( player, "jobtime", 0 )
vioSetElementData ( player, "club", "none" )
vioSetElementData ( player, "favchannel", 0 )
vioSetElementData ( player, "bonuspoints", 0 )
vioSetElementData ( player, "truckerlvl", 1 )
vioSetElementData ( player, "airportlvl", 1 )
vioSetElementData ( player, "bauarbeiterLVL", 0 )
vioSetElementData ( player, "farmerLVL", 0 )
vioSetElementData ( player, "contract", 0 )
vioSetElementData ( player, "socialState", "Flüchtling" )
vioSetElementData ( player, "streetCleanPoints", 0 )
vioSetElementData ( player, "handyType", 1 )
vioSetElementData ( player, "handyCosts", 0 )
_G[pname.."paydaytime"] = setTimer ( playingtime, 60000, 0, player )
vioSetElementData ( player, "loggedin", 1 )
vioSetElementData ( player, "muted", 0 )
vioSetElementData ( player, "curplayingtime", 0 )
vioSetElementData ( player, "housex", 0 )
vioSetElementData ( player, "housey", 0 )
vioSetElementData ( player, "housez", 0 )
vioSetElementData ( player, "house", "none" )
vioSetElementData ( player, "handystate", "on" )
vioSetElementData ( player, "object", 0 )
vioSetElementData ( player, "ammoTyp", 0 )
vioSetElementData ( player, "curAmmoTyp", 0 )
vioSetElementData ( player, "nodmzone", 0 )
vioSetElementData ( player, "coins", 0 )
bindKey ( source, "r", "down", reload )
setPlayerWantedLevel ( player, 0 )
vioSetElementData ( player, "call", false )
packageLoad ( player )
achievload ( player )
inventoryload ( player )
elementDataSettings ( player )
bonusLoad ( player )
skillDataLoad ( player )
createPlayerAFK ( player )
loadPlayerStatisticsMySQL ( player )
allPrivateCars[pname] = {}
local result = dbExec ( handler, "INSERT INTO userdata ( UID,Name,Skinid,Telefonnr) VALUES(?,?,?,?)", id, pname, Skinid, Telefonnr)
if not result then
outputDebugString ( "[register_func 8] Error executing the query" )
else
outputDebugString ("Daten für Spieler "..pname.." wurden angelegt!")
end
outputChatBox ( "Drücke F1, um das Hilfemenü zu öffnen!", player, 200, 200, 0 )
vioSetElementData ( player, "gameboy", 0 )
loadAddictionsForPlayer ( player )
spawnchange_func ( player, "", "noobspawn", "" )
triggerJoinedPlayerTheTrams ( player )
syncInvulnerablePedsWithPlayer ( player )
playerLoginGangMembers ( player )
spawnPlayer ( player, Spawnpos_X, Spawnpos_Y, Spawnpos_Z+5000, Spawnrot_X, Skinid, SpawnInterior, 0 )
setElementFrozen ( player, true )
toggleAllControls ( player, false )
triggerClientEvent ( player, "starttutorial", player, Skinid )
setPlayerHudComponentVisible ( player, "all", false )
insertPlayerIntoLoggedIn ( pname, getPlayerIP(player), getPlayerSerial(player) )
end
end
end
addEvent ( "register", true )
addEventHandler ( "register", getRootElement(), register_func)
addEvent ( "tutorialended", true )
addEventHandler ( "tutorialended", root, function ( )
setElementPosition ( client, -2000.2779541016, 196.17945861816, 27.577531051636 )
setCameraTarget ( client, client )
setElementFrozen ( client, false )
toggleAllControls ( client, true )
end )
addEvent ( "setPlayerTutorialMoney", true )
addEventHandler ( "setPlayerTutorialMoney", root, function ( )
vioSetElementData ( client, "money", vioGetElementData ( client, "money" ) + 10000 )
end )Danke 