NoKill1997
Online
Wiek: 28 Na forum: 3224 dni Posty: 183
Nick w MP: Mefedroniarz.PDW
Piwa : 778
Witam, mam malutki problem z systemem pojazd?w. Mianowicie chodzi o to, ?e w exporcie do bazy danych podczas zapisu, wywala mi jaki? z?y argument
Prosi?bym o nakierowanie mnie jak owy b??d naprawi?.
Linijka z b??dem:
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', zawieszenie='%d', deluxomode='%d', awd='%d' , neon='%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 , upgrades , h1 , h2 , h3 , player , mk1 , mk2 , mk3 , zawieszenie , deluxomode , awd , neon , tostring ( blokada ), id ))
Ca?a dana 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 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 neon = getElementData ( vehicle , "neony" )
local mk1 = getElementData ( vehicle , "mk1" )
local mk2 = getElementData ( vehicle , "mk2" )
local mk3 = getElementData ( vehicle , "mk3" )
local zawieszenie = getElementData ( vehicle , "zawieszenie" )
local deluxomode = getElementData ( vehicle , "deluxomode" )
local awd = getElementData ( vehicle , "awd" )
local h1 , h2 , h3 = getVehicleHeadLightColor ( vehicle )
local paintjob = getVehiclePaintjob ( vehicle )
local rear = "Brak"
local frozen = isElementFrozen ( vehicle ) and 1 or 0
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 , "," )
upgrades = getVehicleUpgrades ( vehicle )
if not upgrades then upgrades ={} end
upgrades = table . concat ( upgrades , "," )
-- 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', zawieszenie='%d', deluxomode='%d', awd='%d' , neon='%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 , upgrades , h1 , h2 , h3 , player , mk1 , mk2 , mk3 , zawieszenie , deluxomode , awd , neon , 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
end
end
Podpis
Aktualny projekt: LSgame
Na scenie MTA od: 2015 roku.
Discord: Chwilowoo, brak