MTA mySQL Error

xDavid

Hallo,
Ja da bin ich wieder mit meinen schönen Fahrzeug Problem.
Und zwar das Problem ist
wenn ich diese Function aktiviert habe

Lua

outputChatBox("Vehicle INFO: X:"..tostring(dt["spawn_x"]).." Y:"..tostring(dt["spawn_y"]).." and Z:"..tostring(dt["spawn_z"]))

Spawnt das auto mit Gear, aber auch an der Stelle wo es explodiert.
Error code ist
ERROR: [DayZ]/DayZ/mysql.lua:1030: attempt to index global 'dt' (a nil value)#

Ohne diese Function spawnt das Auto mit 0 Slots, aber wo es normaler wiese spawnen soll.
Aber mit der Rotation :/.
Welche eig auf 0 Sein sollte

Lua

vehiclesDBSQLh = {}
function rebornVehicles()
        if not (source == getResourceRootElement()) then return end
---
qh = dbQuery(dbConnection, "SELECT id FROM vehicles")
local id = dbPoll(qh, -1)
local id = table.getn(id)
outputDebugString(id)
for i = 1, id do
                qrb = dbQuery(dbConnection, "SELECT * FROM vehicles WHERE id ="..i.."")
                resdasdult = dbPoll(qrb, -1)   
                local vehicle = createVehicle(tonumber(resdasdult[1]['vehicle_ID']),tonumber(resdasdult[1]['x']),tonumber(resdasdult[1]['y']),tonumber(resdasdult[1]['z']),tonumber(resdasdult[1]['rx']),tonumber(resdasdult[1]['ry']),tonumber(resdasdult[1]['rz']))
                setElementData(vehicle,"id",resdasdult[1]['id'])
                setElementData(vehicle,"MYSQLVEHICLE",true)
                vehicleCol = createColSphere(resdasdult[1]['x'],resdasdult[1]['y'],resdasdult[1]['z'], 2)
                attachElements(vehicleCol, vehicle, 0, 0, 0)
                setElementData(vehicleCol, "parent", vehicle)
                setElementData(vehicle, "parent", vehicleCol)
                setElementData(vehicleCol, "vehicle", true)
                setElementData(vehicleCol, "MAX_Slots", tonumber(resdasdult[1]['MAX_Slots']))
				table.insert(vehiclesDBSQLh,{resdasdult[1]['id'],tonumber(resdasdult[1]['spawn_x']),tonumber(resdasdult[1]['spawn_y']),tonumber(resdasdult[1]['spawn_z'])})
                setElementData(vehicleCol, "spawn", {
                  tonumber(resdasdult[1]['vehicle_ID']),
                  tonumber(resdasdult[1]['spawn_x']),
                  tonumber(resdasdult[1]['spawn_y']),
                  tonumber(resdasdult[1]['spawn_z'])
                })
                for i, datensatzb in ipairs(vehicleDataTable) do
                        local datensatzx = tonumber(resdasdult[1][datensatzb[2]])
                        setElementData(vehicleCol,datensatzb[1],datensatzx)
                end
        end
end


function onvehicleexplode()
id = getElementData(source,"id")
for index, all in ipairs(vehiclesDBSQLh) do
	if all[1] == id then
		outputChatBox("Vehicle INFO: X:"..tostring(dt["spawn_x"]).." Y:"..tostring(dt["spawn_y"]).." and Z:"..tostring(dt["spawn_z"]))
		outputChatBox("Vehicle INFO: X:"..all[2].." Y:"..all[3].." and Z:"..all[4])
		dbExec(dbConnection,"UPDATE vehicles SET x='"..all[2].."' WHERE id='"..id.."'")
		dbExec(dbConnection,"UPDATE vehicles SET y='"..all[3].."' WHERE id='"..id.."'")
		dbExec(dbConnection,"UPDATE vehicles SET z='"..all[4].."' WHERE id='"..id.."'")
		for i, allx in ipairs(vehicleDataTable) do
			dbExec(dbConnection,"UPDATE vehicles SET ??=0 WHERE id='"..id.."'",allx[2])
		end
		dbExec(dbConnection,"UPDATE vehicles SET MAX_Slots=? WHERE id='"..id.."'",getElementData(source,"MAX_Slots"))
        local tires,engine,parts = getVehicleAddonInfos (getElementModel(source))			
		dbExec(dbConnection,"UPDATE vehicles SET Tire_inVehicle=? WHERE id='"..id.."'",math.random(0,tires))
		dbExec(dbConnection,"UPDATE vehicles SET Engine_inVehicle=? WHERE id='"..id.."'",math.random(0,engine))
		dbExec(dbConnection,"UPDATE vehicles SET Parts_inVehicle=? WHERE id='"..id.."'",math.random(0,parts))
		setElementData(source,"exploded",true)
	end
end
end
addEventHandler("onVehicleExplode",getRootElement(),onvehicleexplode)

Alles anzeigen

Die obere Function war dabei, glaube aber nicht das die Functioniert.

Bis auf den einen Error hab ich keine Probleme

Jetzt mitmachen!