Witam. Mam kod na zapis aut w SQL, ale chcia?bym aby zapisywa?o te? zepsute cz??ci auta (np. maska itp). Pr?bowa?em ju? to robi? ale si? nie uda?o. Bardzo prosi?bym o dodanie do kodu odpowiedniej funkcji. Z g?ry dzi?kuje.
Kod:
[lua]
test_db = dbConnect( "sqlite", "auta.db" )
function save()
dbQuery( test_db,"DROP TABLE auta")
dbQuery( test_db,"CREATE TABLE auta (VehicleID INTEGER,ID INTEGER, px REAL, py REAL, pz REAL, rx REAL, ry REAL, rz REAL, Color1 INTEGER, Color2 INTEGER, Health REAL, upgrades TEXT, paintjob INTEGER, PALIWO TEXT, PRZEBIEG TEXT, Zarejstrowany TEXT, NaKogo1 TEXT, NaKogo2 TEXT)")
for i, vehicle in pairs (getElementsByType("vehicle")) do
if getElementData(vehicle,"Pojazd_zapis") == true then
local px, py, pz = getElementPosition(vehicle)
local rx, ry, rz = getElementRotation(vehicle)
local color1, color2, color3, color4 = getVehicleColor(vehicle)
local model = getElementModel(vehicle)
local health = getElementHealth (vehicle)
local tableUpgrades = getVehicleUpgrades(vehicle)
local upgrades = table.concat(tableUpgrades, ",")
local paintjob = getVehiclePaintjob(vehicle)
local id1 = tostring(getElementData(vehicle,"id"))
local paliwo = tostring(getElementData(vehicle,"fuel"))
local przebieg = tostring(getElementData(vehicle,"przebieg"))
local zarejstrowany = tostring(getElementData(vehicle,"Zarejstrowany&qu... |