gergo150

Shit, bad name -> database = Lock, Lua = lock Thank you!!!!!!!!

Hi all! I need help: WARNING: @...:110: dbFree failed; (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lock, upg1, upg2, upg3, upg4, upg5, upg6, upg7, upg8, upg9, upg10, upg11, upg12' at line 1 Why is it? function beszallaskor(player) konnekt = dbConnect("mysql", "dbname=meetlife;host=127.0.0.1;port=3306;", "", "") outputChatBox(getVehicleType(getPedOccupiedVehicle(player))) end function carsave(player) vehicle = getPedOccupiedVehicle(player) if(vehicle) then local x, y, z = getElementPosition(vehicle) local col1, col2, col3, col4 = getVehicleColor(vehicle) if(isVehicleLocked(vehicle)) then lock = 1 else lock = 0 end --alap upgrades0 = 0 upgrades1 = 0 upgrades2 = 0 upgrades3 = 0 upgrades4 = 0 upgrades5 = 0 upgrades6 = 0 upgrades7 = 0 upgrades8 = 0 upgrades9 = 0 upgrades10 = 0 upgrades11 = 0 upgrades12 = 0 upgrades13 = 0 upgrades14 = 0 upgrades15 = 0 upgrades16 = 0 --számok beiratása, 4 karakter hosszúságúak. Bővebben: [url=https://wiki.multitheftauto.com/wiki/Vehicle_Upgrades]https://wiki.multitheftauto.com/wiki/Vehicle_Upgrades[/url] if(getVehicleUpgradeOnSlot(vehicle, 0)) then upgrades0 = getVehicleUpgradeOnSlot(vehicle, 0) end if(getVehicleUpgradeOnSlot(vehicle, 1)) then upgrades1 = getVehicleUpgradeOnSlot(vehicle, 1) end if(getVehicleUpgradeOnSlot(vehicle, 2)) then upgrades2 = getVehicleUpgradeOnSlot(vehicle, 2) end if(getVehicleUpgradeOnSlot(vehicle, 3)) then upgrades3 = getVehicleUpgradeOnSlot(vehicle, 3) end if(getVehicleUpgradeOnSlot(vehicle, 4)) then upgrades4 = getVehicleUpgradeOnSlot(vehicle, 4) end if(getVehicleUpgradeOnSlot(vehicle, 5)) then upgrades5 = getVehicleUpgradeOnSlot(vehicle, 5) end if(getVehicleUpgradeOnSlot(vehicle, 6)) then upgrades6 = getVehicleUpgradeOnSlot(vehicle, 6) end if(getVehicleUpgradeOnSlot(vehicle, 7)) then upgrades7 = getVehicleUpgradeOnSlot(vehicle, 7) end if(getVehicleUpgradeOnSlot(vehicle, -- s8) -->) then upgrades8 = getVehicleUpgradeOnSlot(vehicle, -- s8) --> end if(getVehicleUpgradeOnSlot(vehicle, 9)) then upgrades9 = getVehicleUpgradeOnSlot(vehicle, 9) end if(getVehicleUpgradeOnSlot(vehicle, 10)) then upgrades10 = getVehicleUpgradeOnSlot(vehicle, 10) end if(getVehicleUpgradeOnSlot(vehicle, 11)) then upgrades11 = getVehicleUpgradeOnSlot(vehicle, 11) end if(getVehicleUpgradeOnSlot(vehicle, 12)) then upgrades12 = getVehicleUpgradeOnSlot(vehicle, 12) end if(getVehicleUpgradeOnSlot(vehicle, 13)) then upgrades13 = getVehicleUpgradeOnSlot(vehicle, 13) end if(getVehicleUpgradeOnSlot(vehicle, 14)) then upgrades14 = getVehicleUpgradeOnSlot(vehicle, 14) end if(getVehicleUpgradeOnSlot(vehicle, 15)) then upgrades15 = getVehicleUpgradeOnSlot(vehicle, 15) end if(getVehicleUpgradeOnSlot(vehicle, 16)) then upgrades16 = getVehicleUpgradeOnSlot(vehicle, 16) end local carhealth = getElementHealth(vehicle) local engineState = 1 if(getVehicleEngineState(vehicle)) then engineState = 1 else engineState = 0 end local id = getElementModel(vehicle) local vehicleID = id local szov = "INSERT INTO cars (user, posX, posY, posZ, Door1, Door2, Door3, Door4, Door5, Door6, Light, LightState1, LightState2, LightState3, LightState4, Engine, Color1, Color2, Color3, Color4, lock, upg1, upg2, upg3, upg4, upg5, upg6, upg7, upg8, upg9, upg10, upg11, upg12, upg13, upg14, upg15, upg16, upg17, Health, ModelID) VALUES ('"..getPlayerName(player).."', '"..x.."', '"..y.."', '"..z.."', "..getVehicleDoorState(vehicle, 0)..", "..getVehicleDoorState(vehicle, 1)..", "..getVehicleDoorState(vehicle, 2)..", "..getVehicleDoorState(vehicle, 3)..", "..getVehicleDoorState(vehicle, 4)..", "..getVehicleDoorState(vehicle, 5)..", "..getVehicleOverrideLights(vehicle)..", "..getVehicleLightState(vehicle, 0)..", "..getVehicleLightState(vehicle, 1)..", "..getVehicleLightState(vehicle, 2)..", "..getVehicleLightState(vehicle, 3)..", "..engineState..", "..col1..", "..col2..", "..col3..", "..col4..", "..lock..", "..upgrades0..", "..upgrades1..", "..upgrades2..", "..upgrades3..", "..upgrades4..", "..upgrades5..", "..upgrades6..", "..upgrades7..", "..upgrades8..", "..upgrades9..", "..upgrades10..", "..upgrades11..", "..upgrades12..", "..upgrades13..", "..upgrades14..", "..upgrades15..", "..upgrades16..", '"..carhealth.."', "..vehicleID..");" local er = fileOpen("car.txt") fileWrite(er, szov, "\n") fileClose(er) konnekt = dbConnect("mysql", "dbname=meetlife;host=127.0.0.1;port=3306;", "", "") query = dbQuery(konnekt, szov) er = dbFree(query) if(er) then outputChatBox("Autó lespawnolási helye megváltoztatva!", source) else outputChatBox("Hiba történt! Próbáld újra!", source) end else outputChatBox("A lekötéshez gépjárműben kell lenned!", source) end end addCommandHandler("carpos", carsave) addEventHandler("onVehicleEnter", getRootElement(), beszallaskor)