Wysłany: 2016-07-06, 16:12
GamerHD11 Wiek: 24 4402 dni Nick w MP: SzokoHD
Piwa 23
Nie ma teraz ?adnych DB3, i nie zapisuje nic ale pisze update a jakby tak jakos po??czy? dwa kody ? Bo ten od lukiego insertuje auta a ten tw?j powinien updateowac ale chyba nie ma jak bo nie ma stworzonej kolumny od tego pojazdu ?
Wysłany: 2016-07-06, 16:13
luki123luki123 Place Game Wiek: 28 5416 dni Nick w MP: LuKiO
Piwa 6103
Jacob GamerHD11 , local conn = dbConnect ( "sqlite" , "db.db" )
addEventHandler ( "onResourceStart" , resourceRoot , function ()
if conn then
dbExec ( conn , "CREATE TABLE IF NOT EXISTS OP_Vehicles (id INTEGER PRIMARY KEY AUTOINCREMENT, model INTEGER, posx FLOAT, posy FLOAT, posz FLOAT, rotx FLOAT, roty FLOAT, rotz FLOAT, color1 INTEGER, color2 INTEGER, color3 INTEGER, color4 INTEGER, owner VARCHAR, przebieg FLOAT, paliwo FLOAT, bak FLOAT, paintjob INTEGER, hr INTEGER, hg INTEGER, hb INTEGER, felgi INTEGER, t0 INTEGER, t1 INTEGER, t2 INTEGER, t3 INTEGER, t4 INTEGER, t5 INTEGER, t6 INTEGER, t7 INTEGER, t8 INTEGER, t9 INTEGER, t13 INTEGER, t14 INTEGER, t15 INTEGER, t16 INTEGER, tablica TEXT, wariant1 INTEGER, wariant2 INTEGER, vmax FLOAT, acceler FLOAT )" )
local q = dbQuery ( conn , "SELECT * FROM OP_Vehicles" )
local result = dbPoll ( q , - 1 )
for _ , v in pairs ( result ) do
local auto = createVehicle ( v [ "model" ], v [ "posx" ], v [ "posy" ], v [ "posz" ], v [ "rotx" ], v [ "roty" ], v [ "rotz" ] )
setVehicleColor ( auto , v [ "color1" ], v [ "color2" ], v [ "color3" ], v [ "color4" ] )
setElementData ( auto , "vehid" , v [ "id" ])
setElementData ( auto , "owner" , v [ "owner" ])
setElementData ( auto , "przebieg" , v [ "przebieg" ])
setElementData ( auto , "paliwo" , v [ "paliwo" ])
setElementData ( auto , "bak" , v [ "bak" ])
for i = 0 , 9 do
addVehicleUpgrade ( auto , v [ "t" .. i .. "" ])
end
for i = 13 , 16 do
addVehicleUpgrade ( auto , v [ "t" .. i .. "" ])
end
setVehiclePaintjob ( auto , v [ "paintjob" ])
setVehicleVariant ( auto , v [ "wariant1" ], v [ "wariant2" ])
setVehicleHeadLightColor ( auto , v [ "hr" ], v [ "hg" ], v [ "hb" ])
setVehiclePlateText ( auto , v [ "tablica" ])
setVehicleHandling ( auto , "engineAcceleration" , v [ "acceler" ])
setVehicleHandling ( auto , "maxVelocity" , v [ "vmax" ])
setVehicleOverrideLights ( auto , 1 )
end
end
end )
addCommandHandler ( "zapisz" , function ( plr )
acc = getAccountName ( getPlayerAccount ( plr ))
if isObjectInACLGroup ( "user." .. acc , aclGetGroup ( "Admin" )) then
for _ , v in ipairs ( getElementsByType ( "vehicle" ) ) do
if getElementData ( v , "prywatne" ) then
local pojazdID = getElementModel ( v )
local c1 , c2 , c3 , c4 = getVehicleColor ( v )
local x , y , z = getElementPosition ( v )
local rotx , roty , rotz = getElementRotation ( v )
local owner = getElementData ( v , "owner" )
local przebieg = getElementData ( v , "przebieg" )
local paliwo = getElementData ( v , "paliwo" )
local bak = getElementData ( v , "bak" )
local t0 = getVehicleUpgradeOnSlot ( v , 0 )
local t1 = getVehicleUpgradeOnSlot ( v , 1 )
local t2 = getVehicleUpgradeOnSlot ( v , 2 )
local t3 = getVehicleUpgradeOnSlot ( v , 3 )
local t4 = getVehicleUpgradeOnSlot ( v , 4 )
local t5 = getVehicleUpgradeOnSlot ( v , 5 )
local t6 = getVehicleUpgradeOnSlot ( v , 6 )
local t7 = getVehicleUpgradeOnSlot ( v , 7 )
local t8 = getVehicleUpgradeOnSlot ( v , 8 )
local t9 = getVehicleUpgradeOnSlot ( v , 9 )
local t13 = getVehicleUpgradeOnSlot ( v , 13 )
local t14 = getVehicleUpgradeOnSlot ( v , 14 )
local t15 = getVehicleUpgradeOnSlot ( v , 15 )
local t16 = getVehicleUpgradeOnSlot ( v , 16 )
local felgi = getVehicleUpgradeOnSlot ( v , 12 )
local paintjob = getVehiclePaintjob ( v )
local hr , hg , hb = getVehicleHeadLightColor ( v )
local tablica = getVehiclePlateText ( v )
local wariant1 , wariant2 = getVehicleVariant ( v )
local vmax = getVehicleHandling ( v ). maxVelocity
local acceler = getVehicleHandling ( v ). engineAcceleration
local id = getElementData ( v , "vehid" )
if id then
local zapis = dbQuery ( conn , "SELECT * FROM OP_Vehicles WHERE id = ?" , id )
local result = dbPoll ( zapis , - 1 )
dbFree ( zapis )
if #result == 1 then
outputChatBox ( "Twoje auto zosta?o zaktualizowane!" , plr , 255 , 0 , 0 )
local qh = dbQuery ( conn , "UPDATE OP_Vehicles SET model =" .. pojazdID .. ", posx =" .. x .. ", posy =" .. y .. ", posz =" .. z .. ", rotx =" .. rotx .. ", roty =" .. roty .. ", rotz =" .. rotz .. ", color1 =" .. c1 .. ", color2 =" .. c2 .. ", color3 =" .. c3 .. ", color4 =" .. c4 .. ", owner =" .. owner .. ", przebieg =" .. przebieg .. ", paliwo =" .. paliwo .. ", bak =" .. bak .. ", paintjob =" .. paintjob .. ", hr =" .. hr .. ", hg =" .. hg .. ", hb =" .. hb .. ", felgi =" .. felgi .. ", t0 =" .. t0 .. ", t1 =" .. t1 .. ", t2 =" .. t2 .. ", t3 =" .. t3 .. ", t4 =" .. t4 .. ", t5 =" .. t5 .. ", t6 =" .. t6 .. ", t7 =" .. t7 .. ", t8 =" .. t8 .. ", t9 =" .. t9 .. ", t13 =" .. t13 .. ", t14 =" .. t14 .. ", t15 =" .. t15 .. ", t16 =" .. t16 .. ", tablica =" .. tablica .. ", wariant1 =" .. wariant1 .. ", wariant2 =" .. wariant2 .. ", vmax =" .. vmax .. ", acceler =" .. acceler .. " WHERE id =" .. id .. "" ) owner , przebieg , paliwo , bak , paintjob , hr , hg , hb , felgi , t0 , t1 , t2 , t3 , t4 , t5 , t6 , t7 , t8 , t9 , t13 , t14 , t15 , t16 , tablica , wariant1 , wariant2 , vmax , acceler , id )
dbFree ( qh )
elseif #result == 0 then
outputChatBox ( "Twoje auto zosta?o zapisane poraz pierwszy !" , plr , 255 , 0 , 0 )
dbExec ( conn , "INSERT INTO OP_Vehicles (model, posx, posy, posz, rotx, roty, rotz, color1, color2 ,color3, color4, owner, przebieg, paliwo, bak, paintjob, hr, hg, hb, felgi, t0, t1, t2, t3, t4, t5, t6, t7, t8, t9, t13, t14, t15, t16, tablica, wariant1, wariant2, vmax, acceler) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ? ,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" , pojazdID , x , y , z , rotx , roty , rotz , c1 , c2 , c3 , c4 , owner , przebieg , paliwo , bak , paintjob , hr , hg , hb , felgi , t0 , t1 , t2 , t3 , t4 , t5 , t6 , t7 , t8 , t9 , t13 , t14 , t15 , t16 , tablica , wariant1 , wariant2 , vmax , acceler )
end
end
end
end
end
end )
Wysłany: 2016-07-06, 16:16
Jacob Głupiomądry Wiek: 28 5643 dni Nick w MP: Jacob
Piwa 786
Na co dzie? u?ywam OOP, tam si? nie podaj? tych argument?w.
Wysłany: 2016-07-06, 16:17
GamerHD11 Wiek: 24 4402 dni Nick w MP: SzokoHD
Piwa 23
Luki wywala w 75 b??d ?e = jest blisko )
Wysłany: 2016-07-06, 16:20
luki123luki123 Place Game Wiek: 28 5416 dni Nick w MP: LuKiO
Piwa 6103
GamerHD11 , podaj ca?y b??d.
Wysłany: 2016-07-06, 16:20
Jacob Głupiomądry Wiek: 28 5643 dni Nick w MP: Jacob
Piwa 786
Dodaj po zmiennej 'id' outputChatBox(tostring(id))
Wysłany: 2016-07-06, 16:21
GamerHD11 Wiek: 24 4402 dni Nick w MP: SzokoHD
Piwa 23
luki123luki123
Wysłany: 2016-07-06, 16:22
Jacob Głupiomądry Wiek: 28 5643 dni Nick w MP: Jacob
Piwa 786
local conn = dbConnect ( "sqlite" , "db.db" )
addEventHandler ( "onResourceStart" , resourceRoot , function ()
if conn then
dbExec ( conn , "CREATE TABLE IF NOT EXISTS OP_Vehicles(id INTEGER PRIMARY KEY AUTOINCREMENT, model INTEGER, posx FLOAT, posy FLOAT, posz FLOAT, rotx FLOAT, roty FLOAT, rotz FLOAT, color1 INTEGER, color2 INTEGER, color3 INTEGER, color4 INTEGER, owner VARCHAR, przebieg FLOAT, paliwo FLOAT, bak FLOAT, paintjob INTEGER, hr INTEGER, hg INTEGER, hb INTEGER, felgi INTEGER, t0 INTEGER, t1 INTEGER, t2 INTEGER, t3 INTEGER, t4 INTEGER, t5 INTEGER, t6 INTEGER, t7 INTEGER, t8 INTEGER, t9 INTEGER, t13 INTEGER, t14 INTEGER, t15 INTEGER, t16 INTEGER, tablica TEXT, wariant1 INTEGER, wariant2 INTEGER, vmax FLOAT, acceler FLOAT )" )
local q = dbQuery ( conn , "SELECT * FROM OP_Vehicles" )
local result = dbPoll ( q , - 1 )
if #result > 0 then
for _ , v in pairs ( result ) do
local auto = createVehicle ( v [ "model" ], v [ "posx" ], v [ "posy" ], v [ "posz" ], v [ "rotx" ], v [ "roty" ], v [ "rotz" ] )
setVehicleColor ( auto , v [ "color1" ], v [ "color2" ], v [ "color3" ], v [ "color4" ] )
setElementData ( auto , "veh:id" , v [ "id" ])
setElementData ( auto , "owner" , v [ "owner" ])
setElementData ( auto , "przebieg" , v [ "przebieg" ])
setElementData ( auto , "paliwo" , v [ "paliwo" ])
setElementData ( auto , "bak" , v [ "bak" ])
for i = 0 , 9 do
addVehicleUpgrade ( auto , v [ "t" .. i .. "" ])
end
for is = 13 , 16 do
addVehicleUpgrade ( auto , v [ "t" .. is .. "" ])
end
setVehiclePaintjob ( auto , v [ "paintjob" ])
setVehicleVariant ( auto , v [ "wariant1" ], v [ "wariant2" ])
setVehicleHeadLightColor ( auto , v [ "hr" ], v [ "hg" ], v [ "hb" ])
setVehiclePlateText ( auto , v [ "tablica" ])
setVehicleHandling ( auto , "engineAcceleration" , v [ "acceler" ])
setVehicleHandling ( auto , "maxVelocity" , v [ "vmax" ])
setVehicleOverrideLights ( auto , 1 )
end
end
dbFree ( q )
end
end )
addCommandHandler ( "zapisz" , function ( plr )
acc = getAccountName ( getPlayerAccount ( plr ))
if isObjectInACLGroup ( "user." .. acc , aclGetGroup ( "Admin" )) then
for _ , v in ipairs ( getElementsByType ( "vehicle" ) ) do
if getElementData ( v , "prywatne" ) then
local pojazdID = getElementModel ( v )
local c1 , c2 , c3 , c4 = getVehicleColor ( v )
local x , y , z = getElementPosition ( v )
local rotx , roty , rotz = getElementRotation ( v )
local owner = getElementData ( v , "owner" )
local przebieg = getElementData ( v , "przebieg" )
local paliwo = getElementData ( v , "paliwo" )
local bak = getElementData ( v , "bak" )
local t0 = getVehicleUpgradeOnSlot ( v , 0 )
local t1 = getVehicleUpgradeOnSlot ( v , 1 )
local t2 = getVehicleUpgradeOnSlot ( v , 2 )
local t3 = getVehicleUpgradeOnSlot ( v , 3 )
local t4 = getVehicleUpgradeOnSlot ( v , 4 )
local t5 = getVehicleUpgradeOnSlot ( v , 5 )
local t6 = getVehicleUpgradeOnSlot ( v , 6 )
local t7 = getVehicleUpgradeOnSlot ( v , 7 )
local t8 = getVehicleUpgradeOnSlot ( v , 8 )
local t9 = getVehicleUpgradeOnSlot ( v , 9 )
local t13 = getVehicleUpgradeOnSlot ( v , 13 )
local t14 = getVehicleUpgradeOnSlot ( v , 14 )
local t15 = getVehicleUpgradeOnSlot ( v , 15 )
local t16 = getVehicleUpgradeOnSlot ( v , 16 )
local felgi = getVehicleUpgradeOnSlot ( v , 12 )
local paintjob = getVehiclePaintjob ( v )
local hr , hg , hb = getVehicleHeadLightColor ( v )
local tablica = getVehiclePlateText ( v )
local wariant1 , wariant2 = getVehicleVariant ( v )
local vmax = getVehicleHandling ( v ). maxVelocity
local acceler = getVehicleHandling ( v ). engineAcceleration
local id = getElementData ( v , "veh:id" )
if ( id ) then
outputChatBox ( "update" )
local r = dbQuery ( conn , "SELECT * FROM OP_Vehicles WHERE id=?" , id )
local p = dbPoll ( r , - 1 )
if #p > 0 then
dbExec ( conn , "UPDATE OP_Vehicles SET model=?, posx=?, posy=?, posz=?, rotx=?, roty=?, rotz=?, color1=?, color2=?, color3=?, color4=?, owner=?, przebieg=?, paliwo=?, bak=?, paintjob=?, hr=?, hg=?, hb=?, felgi=?, t0=?, t1=?, t2=?, t3=?, t4=?, t5=?, t6=?, t7=?, t8=?, t9=?, t13=?, t14=?, t15=?, t16=?, tablica=?, wariant1=?, wariant2=?, vmax=?, acceler=? WHERE id=?" , pojazdID , x , y , z , rotx , roty , rotz , c1 , c2 , c3 , c4 , owner , przebieg , paliwo , bak , paintjob , hr , hg , hb , felgi , t0 , t1 , t2 , t3 , t4 , t5 , t6 , t7 , t8 , t9 , t13 , t14 , t15 , t16 , tablica , wariant1 , wariant2 , vmax , acceler , id )
end
dbFree ( r )
else
outputChatBox ( "zapis" )
dbExec ( conn , "INSERT INTO OP_Vehicles (model, posx, posy, posz, rotx, roty, rotz, color1, color2, color3, color4, owner, przebieg, paliwo, bak, paintjob, hr, hg, hb, felgi, t0, t1, t2, t3, t4, t5, t6, t7, t8, t9, t13, t14, t15, t16, tablica, wariant1, wariant2, vmax, acceler) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" , pojazdID , x , y , z , rotx , roty , rotz , c1 , c2 , c3 , c4 , owner , przebieg , paliwo , bak , paintjob , hr , hg , hb , felgi , t0 , t1 , t2 , t3 , t4 , t5 , t6 , t7 , t8 , t9 , t13 , t14 , t15 , t16 , tablica , wariant1 , wariant2 , vmax , acceler )
end
outputChatBox ( "* Zapis zako?czony!" , plr , 255 , 255 , 255 )
end
end
end
end )
Wysłany: 2016-07-06, 16:25
GamerHD11 Wiek: 24 4402 dni Nick w MP: SzokoHD
Piwa 23
Teraz zapisuj? si? wszystkie auta ale ju? nie updateuj?
Wysłany: 2016-07-06, 16:26
Jacob Głupiomądry Wiek: 28 5643 dni Nick w MP: Jacob
Piwa 786
Okej, czyli zapis wszystkich aut dzia?a. Jest post?p. Jeszcze posprawdzam.
Wysłany: 2016-07-06, 16:27
luki123luki123 Place Game Wiek: 28 5416 dni Nick w MP: LuKiO
Piwa 6103
GamerHD11 , local conn = dbConnect ( "sqlite" , "db.db" )
addEventHandler ( "onResourceStart" , resourceRoot , function ()
if conn then
dbExec ( conn , "CREATE TABLE IF NOT EXISTS OP_Vehicles (id INTEGER PRIMARY KEY AUTOINCREMENT, model INTEGER, posx FLOAT, posy FLOAT, posz FLOAT, rotx FLOAT, roty FLOAT, rotz FLOAT, color1 INTEGER, color2 INTEGER, color3 INTEGER, color4 INTEGER, owner VARCHAR, przebieg FLOAT, paliwo FLOAT, bak FLOAT, paintjob INTEGER, hr INTEGER, hg INTEGER, hb INTEGER, felgi INTEGER, t0 INTEGER, t1 INTEGER, t2 INTEGER, t3 INTEGER, t4 INTEGER, t5 INTEGER, t6 INTEGER, t7 INTEGER, t8 INTEGER, t9 INTEGER, t13 INTEGER, t14 INTEGER, t15 INTEGER, t16 INTEGER, tablica TEXT, wariant1 INTEGER, wariant2 INTEGER, vmax FLOAT, acceler FLOAT )" )
local q = dbQuery ( conn , "SELECT * FROM OP_Vehicles" )
local result = dbPoll ( q , - 1 )
for _ , v in pairs ( result ) do
local auto = createVehicle ( v [ "model" ], v [ "posx" ], v [ "posy" ], v [ "posz" ], v [ "rotx" ], v [ "roty" ], v [ "rotz" ] )
setVehicleColor ( auto , v [ "color1" ], v [ "color2" ], v [ "color3" ], v [ "color4" ] )
setElementData ( auto , "vehid" , v [ "id" ])
setElementData ( auto , "owner" , v [ "owner" ])
setElementData ( auto , "przebieg" , v [ "przebieg" ])
setElementData ( auto , "paliwo" , v [ "paliwo" ])
setElementData ( auto , "bak" , v [ "bak" ])
for i = 0 , 9 do
addVehicleUpgrade ( auto , v [ "t" .. i .. "" ])
end
for i = 13 , 16 do
addVehicleUpgrade ( auto , v [ "t" .. i .. "" ])
end
setVehiclePaintjob ( auto , v [ "paintjob" ])
setVehicleVariant ( auto , v [ "wariant1" ], v [ "wariant2" ])
setVehicleHeadLightColor ( auto , v [ "hr" ], v [ "hg" ], v [ "hb" ])
setVehiclePlateText ( auto , v [ "tablica" ])
setVehicleHandling ( auto , "engineAcceleration" , v [ "acceler" ])
setVehicleHandling ( auto , "maxVelocity" , v [ "vmax" ])
setVehicleOverrideLights ( auto , 1 )
end
end
end )
addCommandHandler ( "zapisz" , function ( plr )
acc = getAccountName ( getPlayerAccount ( plr ))
if isObjectInACLGroup ( "user." .. acc , aclGetGroup ( "Admin" )) then
for _ , v in ipairs ( getElementsByType ( "vehicle" ) ) do
if getElementData ( v , "prywatne" ) then
local pojazdID = getElementModel ( v )
local c1 , c2 , c3 , c4 = getVehicleColor ( v )
local x , y , z = getElementPosition ( v )
local rotx , roty , rotz = getElementRotation ( v )
local owner = getElementData ( v , "owner" )
local przebieg = getElementData ( v , "przebieg" )
local paliwo = getElementData ( v , "paliwo" )
local bak = getElementData ( v , "bak" )
local t0 = getVehicleUpgradeOnSlot ( v , 0 )
local t1 = getVehicleUpgradeOnSlot ( v , 1 )
local t2 = getVehicleUpgradeOnSlot ( v , 2 )
local t3 = getVehicleUpgradeOnSlot ( v , 3 )
local t4 = getVehicleUpgradeOnSlot ( v , 4 )
local t5 = getVehicleUpgradeOnSlot ( v , 5 )
local t6 = getVehicleUpgradeOnSlot ( v , 6 )
local t7 = getVehicleUpgradeOnSlot ( v , 7 )
local t8 = getVehicleUpgradeOnSlot ( v , 8 )
local t9 = getVehicleUpgradeOnSlot ( v , 9 )
local t13 = getVehicleUpgradeOnSlot ( v , 13 )
local t14 = getVehicleUpgradeOnSlot ( v , 14 )
local t15 = getVehicleUpgradeOnSlot ( v , 15 )
local t16 = getVehicleUpgradeOnSlot ( v , 16 )
local felgi = getVehicleUpgradeOnSlot ( v , 12 )
local paintjob = getVehiclePaintjob ( v )
local hr , hg , hb = getVehicleHeadLightColor ( v )
local tablica = getVehiclePlateText ( v )
local wariant1 , wariant2 = getVehicleVariant ( v )
local vmax = getVehicleHandling ( v ). maxVelocity
local acceler = getVehicleHandling ( v ). engineAcceleration
local id = getElementData ( v , "vehid" )
if id then
local zapis = dbQuery ( conn , "SELECT * FROM OP_Vehicles WHERE id = ?" , id )
local result = dbPoll ( zapis , - 1 )
dbFree ( zapis )
if #result == 1 then
outputChatBox ( "Twoje auto zosta?o zaktualizowane!" , plr , 255 , 0 , 0 )
local qh = dbQuery ( conn , "UPDATE OP_Vehicles SET model=" .. pojazdID .. ", posx=" .. x .. ", posy=" .. y .. ", posz=" .. z .. ", rotx=" .. rotx .. ", roty=" .. roty .. ", rotz=" .. rotz .. ", color1=" .. c1 .. ", color2=" .. c2 .. ", color3=" .. c3 .. ", color4=" .. c4 .. ", owner=" .. owner .. ", przebieg=" .. przebieg .. ", paliwo=" .. paliwo .. ", bak=" .. bak .. ", paintjob=" .. paintjob .. ", hr=" .. hr .. ", hg=" .. hg .. ", hb=" .. hb .. ", felgi=" .. felgi .. ", t0=" .. t0 .. ", t1=" .. t1 .. ", t2=" .. t2 .. ", t3=" .. t3 .. ", t4=" .. t4 .. ", t5=" .. t5 .. ", t6=" .. t6 .. ", t7=" .. t7 .. ", t8=" .. t8 .. ", t9=" .. t9 .. ", t13=" .. t13 .. ", t14=" .. t14 .. ", t15=" .. t15 .. ", t16=" .. t16 .. ", tablica=" .. tablica .. ", wariant1=" .. wariant1 .. ", wariant2=" .. wariant2 .. ", vmax=" .. vmax .. ", acceler=" .. acceler .. " WHERE id=" .. id )
dbFree ( qh )
elseif #result == 0 then
outputChatBox ( "Twoje auto zosta?o zapisane poraz pierwszy !" , plr , 255 , 0 , 0 )
dbExec ( conn , "INSERT INTO OP_Vehicles (model, posx, posy, posz, rotx, roty, rotz, color1, color2 ,color3, color4, owner, przebieg, paliwo, bak, paintjob, hr, hg, hb, felgi, t0, t1, t2, t3, t4, t5, t6, t7, t8, t9, t13, t14, t15, t16, tablica, wariant1, wariant2, vmax, acceler) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ? ,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" , pojazdID , x , y , z , rotx , roty , rotz , c1 , c2 , c3 , c4 , owner , przebieg , paliwo , bak , paintjob , hr , hg , hb , felgi , t0 , t1 , t2 , t3 , t4 , t5 , t6 , t7 , t8 , t9 , t13 , t14 , t15 , t16 , tablica , wariant1 , wariant2 , vmax , acceler )
end
end
end
end
end
end )
Wysłany: 2016-07-06, 16:28
Jacob Głupiomądry Wiek: 28 5643 dni Nick w MP: Jacob
Piwa 786
local conn = dbConnect ( "sqlite" , "db.db" )
addEventHandler ( "onResourceStart" , resourceRoot , function ()
if conn then
dbExec ( conn , "CREATE TABLE IF NOT EXISTS OP_Vehicles(id INTEGER PRIMARY KEY AUTOINCREMENT, model INTEGER, posx FLOAT, posy FLOAT, posz FLOAT, rotx FLOAT, roty FLOAT, rotz FLOAT, color1 INTEGER, color2 INTEGER, color3 INTEGER, color4 INTEGER, owner VARCHAR, przebieg FLOAT, paliwo FLOAT, bak FLOAT, paintjob INTEGER, hr INTEGER, hg INTEGER, hb INTEGER, felgi INTEGER, t0 INTEGER, t1 INTEGER, t2 INTEGER, t3 INTEGER, t4 INTEGER, t5 INTEGER, t6 INTEGER, t7 INTEGER, t8 INTEGER, t9 INTEGER, t13 INTEGER, t14 INTEGER, t15 INTEGER, t16 INTEGER, tablica TEXT, wariant1 INTEGER, wariant2 INTEGER, vmax FLOAT, acceler FLOAT )" )
local q = dbQuery ( conn , "SELECT * FROM OP_Vehicles" )
local result = dbPoll ( q , - 1 )
if #result > 0 then
for _ , v in pairs ( result ) do
local auto = createVehicle ( v [ "model" ], v [ "posx" ], v [ "posy" ], v [ "posz" ], v [ "rotx" ], v [ "roty" ], v [ "rotz" ] )
setVehicleColor ( auto , v [ "color1" ], v [ "color2" ], v [ "color3" ], v [ "color4" ] )
setElementData ( auto , "veh:id" , v [ "id" ])
setElementData ( auto , "owner" , v [ "owner" ])
setElementData ( auto , "przebieg" , v [ "przebieg" ])
setElementData ( auto , "paliwo" , v [ "paliwo" ])
setElementData ( auto , "bak" , v [ "bak" ])
for i = 0 , 9 do
addVehicleUpgrade ( auto , v [ "t" .. i .. "" ])
end
for is = 13 , 16 do
addVehicleUpgrade ( auto , v [ "t" .. is .. "" ])
end
setVehiclePaintjob ( auto , v [ "paintjob" ])
setVehicleVariant ( auto , v [ "wariant1" ], v [ "wariant2" ])
setVehicleHeadLightColor ( auto , v [ "hr" ], v [ "hg" ], v [ "hb" ])
setVehiclePlateText ( auto , v [ "tablica" ])
setVehicleHandling ( auto , "engineAcceleration" , v [ "acceler" ])
setVehicleHandling ( auto , "maxVelocity" , v [ "vmax" ])
setVehicleOverrideLights ( auto , 1 )
end
end
dbFree ( q )
end
end )
addCommandHandler ( "zapisz" , function ( plr )
acc = getAccountName ( getPlayerAccount ( plr ))
if isObjectInACLGroup ( "user." .. acc , aclGetGroup ( "Admin" )) then
for _ , v in ipairs ( getElementsByType ( "vehicle" ) ) do
if getElementData ( v , "prywatne" ) then
local pojazdID = getElementModel ( v )
local c1 , c2 , c3 , c4 = getVehicleColor ( v )
local x , y , z = getElementPosition ( v )
local rotx , roty , rotz = getElementRotation ( v )
local owner = getElementData ( v , "owner" )
local przebieg = getElementData ( v , "przebieg" )
local paliwo = getElementData ( v , "paliwo" )
local bak = getElementData ( v , "bak" )
local t0 = getVehicleUpgradeOnSlot ( v , 0 )
local t1 = getVehicleUpgradeOnSlot ( v , 1 )
local t2 = getVehicleUpgradeOnSlot ( v , 2 )
local t3 = getVehicleUpgradeOnSlot ( v , 3 )
local t4 = getVehicleUpgradeOnSlot ( v , 4 )
local t5 = getVehicleUpgradeOnSlot ( v , 5 )
local t6 = getVehicleUpgradeOnSlot ( v , 6 )
local t7 = getVehicleUpgradeOnSlot ( v , 7 )
local t8 = getVehicleUpgradeOnSlot ( v , 8 )
local t9 = getVehicleUpgradeOnSlot ( v , 9 )
local t13 = getVehicleUpgradeOnSlot ( v , 13 )
local t14 = getVehicleUpgradeOnSlot ( v , 14 )
local t15 = getVehicleUpgradeOnSlot ( v , 15 )
local t16 = getVehicleUpgradeOnSlot ( v , 16 )
local felgi = getVehicleUpgradeOnSlot ( v , 12 )
local paintjob = getVehiclePaintjob ( v )
local hr , hg , hb = getVehicleHeadLightColor ( v )
local tablica = getVehiclePlateText ( v )
local wariant1 , wariant2 = getVehicleVariant ( v )
local vmax = getVehicleHandling ( v ). maxVelocity
local acceler = getVehicleHandling ( v ). engineAcceleration
local id = getElementData ( v , "veh:id" )
if ( id ) then
dbExec ( conn , "UPDATE OP_Vehicles SET model=?, posx=?, posy=?, posz=?, rotx=?, roty=?, rotz=?, color1=?, color2=?, color3=?, color4=?, owner=?, przebieg=?, paliwo=?, bak=?, paintjob=?, hr=?, hg=?, hb=?, felgi=?, t0=?, t1=?, t2=?, t3=?, t4=?, t5=?, t6=?, t7=?, t8=?, t9=?, t13=?, t14=?, t15=?, t16=?, tablica=?, wariant1=?, wariant2=?, vmax=?, acceler=? WHERE id=?" , pojazdID , x , y , z , rotx , roty , rotz , c1 , c2 , c3 , c4 , owner , przebieg , paliwo , bak , paintjob , hr , hg , hb , felgi , t0 , t1 , t2 , t3 , t4 , t5 , t6 , t7 , t8 , t9 , t13 , t14 , t15 , t16 , tablica , wariant1 , wariant2 , vmax , acceler , id )
else
dbExec ( conn , "INSERT INTO OP_Vehicles (model, posx, posy, posz, rotx, roty, rotz, color1, color2, color3, color4, owner, przebieg, paliwo, bak, paintjob, hr, hg, hb, felgi, t0, t1, t2, t3, t4, t5, t6, t7, t8, t9, t13, t14, t15, t16, tablica, wariant1, wariant2, vmax, acceler) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" , pojazdID , x , y , z , rotx , roty , rotz , c1 , c2 , c3 , c4 , owner , przebieg , paliwo , bak , paintjob , hr , hg , hb , felgi , t0 , t1 , t2 , t3 , t4 , t5 , t6 , t7 , t8 , t9 , t13 , t14 , t15 , t16 , tablica , wariant1 , wariant2 , vmax , acceler )
end
end
end
outputChatBox ( "* Zapis zako?czony!" , plr , 255 , 255 , 255 )
end
end )
Wysłany: 2016-07-06, 16:28
GamerHD11 Wiek: 24 4402 dni Nick w MP: SzokoHD
Piwa 23
Jacob jednak nie bo zrobi?es blad w elementDacie bo powinno by? vehid a nie veh:id teraz sprawdzi?em i jest tak jak wczeeniej i z output wywala 1.
Wysłany: 2016-07-06, 16:31
Jacob Głupiomądry Wiek: 28 5643 dni Nick w MP: Jacob
Piwa 786
Specjalnie zmieni?em na veh:id, bo mo?liwe ?e inny skrypt to nadpisuje i dlatego id nie jest puste. Zostaw to veh:id.
Wysłany: 2016-07-06, 16:33
GamerHD11 Wiek: 24 4402 dni Nick w MP: SzokoHD
Piwa 23
Ale auta w salonie maj? nadawane id z elemtnDat? vehid
Ostatnio zmieniony przez GamerHD11 2016-07-06, 16:33, w całości zmieniany 1 raz
Tagi: wszystkie :: auta :: się :: zapisują
Anonymous 245 dni
Anonymous Koniecznie zajrzyj na:
Piwa: 23
