NoKill1997
Online
Wiek: 28 Na forum: 3224 dni Posty: 183
Nick w MP: Mefedroniarz.PDW
Piwa : 778
Witam, mam pewien problem z zapisem pojazd?w.. Wszystko dzia?a?o pinknie, a p??niej cu? si? *****?o i przesta?o. Niestety, aleee nie wiem co jest nie tak.. Dlatego, jakby m?g?by mnie kto? naprowadzi? i wskaza? b??d by?bym wtedy bardzo wdzi?czny i odwdzi?czy? bym si? zimnym piwkiem
B??d z DB3:
Linijka kodu:
local query = exports [ "CRPG-db" ]: dbSet ( string . format ( "UPDATE pojazdy SET model='%d', pos='%.2f,%.2f,%.2f,%.2f,%.2f,%.2f', rent='%d',text='%s', health='%d', fuel='%d', mileage='%d', frozen='%d', driver='%s', color='%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d', panelstates='%s', paintjob='%d', tuning='%s', headlights='%d,%d,%d', ownedPlayer='%d' , mk1='%d' , mk2='%d' , mk3='%d', blokada='%s' WHERE id=%d" , model , x , y , z , rx , ry , rz , "0" , desc , health , fuel , mileage , frozen , driver , c1 , c2 , c3 , c4 , c5 , c6 , c7 , c8 , c9 , c10 , c11 , c12 , panelstates , paintjob , Tuning , h1 , h2 , h3 , player , mk1 , mk2 , mk3 , tostring ( blokada ), id ))
Ca?a funkcja:
function onSaveVehicle ( vehicle )
if getElementData ( vehicle , "vehicle:spawn" ) then
-- Setting
local panelstates ={}
local model = getElementModel ( vehicle )
local health = getElementHealth ( vehicle )
local x , y , z = getElementPosition ( vehicle )
local rx , ry , rz = getElementRotation ( vehicle )
local engine = tostring ( calculateNumber ( tonumber ( getElementData ( vehicle , "Pojemnosc:silnika" ))))
local desc = getElementData ( vehicle , "vehicle:desc" ) or ""
local id = getElementData ( vehicle , "vehicle:id" )
local fuel = getElementData ( vehicle , "vehicle:fuel" )
local mileage = getElementData ( vehicle , "vehicle:mileage" )
local c1 , c2 , c3 , c4 , c5 , c6 , c7 , c8 , c9 , c10 , c11 , c12 = getVehicleColor ( vehicle , true )
local driver = getElementData ( vehicle , "vehicle:driver" ) or ""
local rent = getElementData ( vehicle , "vehicle:rent" )
local player = getElementData ( vehicle , "vehicle:ownedPlayer" )
local group = getElementData ( vehicle , "vehicle:ownedGroup" )
local blokada = getElementData ( vehicle , "vehicle:block" )
local mk1 = getElementData ( vehicle , "mk1" ) or ""
local mk2 = getElementData ( vehicle , "mk2" ) or ""
local mk3 = getElementData ( vehicle , "mk3" ) or ""
local h1 , h2 , h3 = getVehicleHeadLightColor ( vehicle )
local paintjob = getVehiclePaintjob ( vehicle )
local rear = "Brak"
local frozen = isElementFrozen ( vehicle ) and 1 or 0
local upgrades = getElementData ( vehicle , "vehicle:upgrades" ) or {}
local headlights = ( '%d,%d,%d' ): format ( h1 , h2 , h3 )
local panelstates ={}
for i = 0 , 6 do
table . insert ( panelstates , getVehiclePanelState ( vehicle , i ))
end
panelstates = table . concat ( panelstates , "," )
--for i = 0 , 6 do table . insert ( panelstates , getVehiclePanelState ( vehicle , i )) end
-- panelstates = table . concat ( panelstates , "," )
Tuning = getVehicleUpgrades ( vehicle )
if not Tuning then Tuning ={} end
Tuning = table . concat ( Tuning , "," )
local visualTuning = getElementData ( vehicle , "visualTuning" ) or {
innerSize = 1 ,
wheelTilt = 0 ,
wheelResize = 1 ,
}
-- Query
local query = exports [ "CRPG-db" ]: dbSet ( string . format ( "UPDATE pojazdy SET model='%d', pos='%.2f,%.2f,%.2f,%.2f,%.2f,%.2f', rent='%d',text='%s', health='%d', fuel='%d', mileage='%d', frozen='%d', driver='%s', color='%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d', panelstates='%s', paintjob='%d', tuning='%s', headlights='%d,%d,%d', ownedPlayer='%d' , mk1='%d' , mk2='%d' , mk3='%d', blokada='%s' WHERE id=%d" , model , x , y , z , rx , ry , rz , "0" , desc , health , fuel , mileage , frozen , driver , c1 , c2 , c3 , c4 , c5 , c6 , c7 , c8 , c9 , c10 , c11 , c12 , panelstates , paintjob , Tuning , h1 , h2 , h3 , player , mk1 , mk2 , mk3 , tostring ( blokada ), id ))
if ( type ( rent ) == "table" ) then
local rr = string . format ( "%s" , table . concat ( rent , ',' ) )
-- outputDebugString ( rr )
local query2 = exports [ 'CRPG-db' ]: dbSet ( "UPDATE pojazdy SET rent=? WHERE id=?" , rr , id )
end
if ( type ( upgrades ) == "table" ) then
local up = string . format ( "%s" , table . concat ( upgrades , ',' ) )
outputDebugString ( up )
local query2 = exports [ 'CRPG-db' ]: dbSet ( "UPDATE pojazdy SET upgrades=? WHERE id=?" , toJSON ( upgrades ), id )
end
if ( type ( visualTuning ) == "table" ) then
local up = string . format ( "%s" , table . concat ( visualTuning , ',' ) )
outputDebugString ( up )
local query2 = exports [ 'CRPG-db' ]: dbSet ( "UPDATE pojazdy SET visualTuning=? WHERE id=?" , serpent . dump ( visualTuning ), id )
end
end
end
Podpis
Aktualny projekt: LSgame
Na scenie MTA od: 2015 roku.
Discord: Chwilowoo, brak