Hey leute ich benutze ein angefangenes Reallife Script.
Problem ist jetzt das das Fahrzeug nicht erstellt wird.
Lua
function createMysqlVehicle ( besitzer, model, x, y, z, rx, ry, rz, c1, c2, c3, c4, c5, c6, paintjob )
if besitzer and model and x and y and z and rx and ry and rz and c1 and c2 and c3 and c4 and c5 and c6 and paintjob then
local sql = dbQuery(handler,"SELECT * FROM `vehicles` WHERE Besitzer = ?", besitzer)
local result, rowindex = dbPoll(sql,-1)
for i, row in ipairs(result) do
if i ~= tonumber(row["Slot"]) then
local time = getRealTime()
local stamp = time.timestamp
math.randomseed(stamp)
local serie
for i = 1,10 do
local number = math.random(65,90)
local ascii = string.format("%c",number)
serie = serie..""..ascii
end
local query = "INSERT INTO `vehicles` (`Besitzer`,`Slot`,`Model`,`SpawnX`,`SpawnY`,`SpawnZ`,`RotX`,`RotY`,`RotZ`,`C1`,`C2`,`C3`,`C4`,`C5`,`C6`,`Paintjob`,`Seriennummer`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"
dbExec(handler,query,besitzer,i,model,x,y,z,rx,ry,rz,c1,c2,c4,c4,c5,c6,paintjob,serie)
local vehicle = createVehicle(model,x,y,z,rx,ry,rz,besitzer)
setVehicleColor(vehicle,c1,c2,c3,c4,c5,c6)
setVehiclePaintjob(vehicle,paintjob)
setElementData(vehicle,"Besitzer",besitzer)
setElementData(vehicle,"Seriennummer",serie)
setElementData(vehicle,"Slot",i)
setElementData(vehicle,"SpawnX",x)
setElementData(vehicle,"SpawnY",y)
setElementData(vehicle,"SpawnZ",z)
setElementData(vehicle,"RotX",rx)
setElementData(vehicle,"RotY",ry)
setElementData(vehicle,"RotZ",rz)
setElementData(vehicle,"C1",c1)
setElementData(vehicle,"C2",c2)
setElementData(vehicle,"C3",c3)
setElementData(vehicle,"C4",c4)
setElementData(vehicle,"C5",c5)
setElementData(vehicle,"C6",c6)
setElementData(vehicle,"Paintjob",paintjob)
setElementData(vehicle,"Totalschaden",0)
setElementData(vehicle,"Enginestate",false)
setVehicleLocked(vehicle,true)
addEventHandler("onVehicleEnter",vehicle,function(element)
if getElementData(source,"Enginestate") == false then
setVehicleEngineState(source,false)
else
setVehicleEngineState(source,true)
end
end)
addEventHandler("onVehicleExplode",vehicle,function()
local sql = dbQuery(handler,"SELECT * FROM `vehicles` WHERE Slot = ? AND Besitzer = ?",getElementData(source,"Slot"),getElementData(source,"Besitzer"))
local result, row = dbPoll(sql,-1)
if row ~= 0 then
local x,y,z = getElementPosition(source)
local rx,ry,rz = getElementRotation(source)
dbExec(handler,"UPDATE `vehicles` SET Totalschaden = ?, SpawnX = ?, SpawnY = ?, SpawnZ = ?, RotX = ?, RotY = ?, RotZ = ? WHERE Besitzer = ? AND Slot = ?","1",x,y,z,rx,ry,rz,getElementData(source,"Besitzer"),getElementData(source,"Slot"))
setElementData(source,"Totalschaden",1)
setElementData(source,"SpawnX",x)
setElementData(source,"SpawnY",y)
setElementData(source,"SpawnZ",z)
setElementData(source,"RotX",rx)
setElementData(source,"RotY",ry)
setElementData(source,"RotZ",rz)
local besitzer = getPlayerFromName(getElementData(source,"Besitzer"))
if besitzer then
outputChatBox("Dein Fahrzeug in Slot "..getElementData(source,"Slot").." ist explodiert!",besitzer,255,0,0)
outputChatBox("Solange du eine Vollkaskoversicherung besitzt kannst du dieses Auto zurückerstatten. Rufe hierfür deine Versicherung an!",besitzer,255,0,0)
end
end
end)
break
end
end
else
outputDebugString("Ein Fehler beim Erstellen eines Fahrzeugs!")
end
end
Alles anzeigen
Script kommt bist zur 1. if abfrage. Danach kommt folgender output -> "Ein Fehler beim Erstellen eines Fahrzeugs!"