Wysłany: 2018-06-14, 17:43
OchIAch
Wiek: 26 Na forum: 3114 dni Posty: 144
Nick w MP: OchIAch
Piwa : 1311
Witam, jak pobra? warto?? AUTO INCREMENT?
Moja tabela: av_pojazdy
Auto Increment: cid
Pr?bowa?em tak:
Kod: q1 = exports['ar-db']:query("SELECT `AUTO_INCREMENT` FROM av_pojazdy")
if #q1 > 0 then
kupione = q1
end
Lecz to nie dzia?a. Nagradzam piwem.
Wysłany: 2018-06-14, 19:24
Grace
Kierowca Pralki
Wiek: 24 Na forum: 3437 dni Posty: 168
Nick w MP: Grace
Piwa : 1031
to twoje 'AUTO INCREMENT' to jest nadawanie numeracji w bazach danych.
Np tworzysz tabele konta, w ktorej masz ID konta, login i haslo.
Teraz zamiast pobiera? ostatni numer ID z bazy danych, wystarczy w niej da? autoinceremt, wtedy numeracja b?dzie od 1 - niesko?czono?ci.
Ni?ej masz przyk?ad zastosowania wyj?ty z paczki ogrpg. Oczywi?cie funkcja wykonywana przy startcie zasobu.
function onRespawnVehicles ( _ , id , poss )
-- Settings ( QUERY )
if id then
result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_vehicles WHERE parking=1 AND id=?" , id )
query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_vehicles SET parking=0 WHERE id=?" , id )
else
result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_vehicles WHERE parking=0" )
end
-- Pairs
for ile , vehicle in pairs ( result ) do
vehicles = ile
if id then pos ={ poss [ 1 ], poss [ 2 ], poss [ 3 ], poss [ 4 ], poss [ 5 ], poss [ 6 ]}
else pos = split ( vehicle [ "pos" ], "," ) end
local color = split ( vehicle [ "color" ], "," )
local lights = split ( vehicle [ "headlights" ], "," )
local veh = createVehicle ( vehicle [ "model" ], pos [ 1 ], pos [ 2 ], pos [ 3 ], pos [ 4 ], pos [ 5 ], pos [ 6 ])
setVehicleColor ( veh , color [ 1 ], color [ 2 ], color [ 3 ], color [ 4 ])
setVehicleHeadLightColor ( veh , lights [ 1 ], lights [ 2 ], lights [ 3 ])
setVehiclePlateText ( veh , vehicle [ "plateText" ] or vehicle [ "id" ])
setElementFrozen ( veh , ( vehicle [ "frozen" ]) > 0 )
setVehiclePaintjob ( veh , vehicle [ "paintjob" ])
setElementHealth ( veh , vehicle [ "health" ])
setElementData ( veh , "vehicle:spawn" , true )
setElementData ( veh , "vehicle:id" , vehicle [ "id" ])
setElementData ( veh , "vehicle:fuel" , vehicle [ "fuel" ])
setElementData ( veh , "vehicle:desc" , vehicle [ "desc" ])
setElementData ( veh , "vehicle:mileage" , vehicle [ "mileage" ])
setElementData ( veh , "vehicle:driver" , vehicle [ "driver" ])
setElementData ( veh , "vehicle:ownedGroup" , vehicle [ "ownedGroup" ])
setElementData ( veh , "vehicle:ownedPlayer" , vehicle [ "ownedPlayer" ])
setElementData ( veh , "vehicle:ownedFaction" , vehicle [ "ownedFaction" ])
for i , v in ipairs ( split ( vehicle [ "tuning" ], "," )) do addVehicleUpgrade ( veh , v ) end
for i , v in ipairs ( split ( vehicle [ "panelstates" ], "," )) do setVehiclePanelState ( veh , i , tonumber ( v )) end
end
outputDebugString ( "[og-vehicles] Loaded " .. vehicles .. " vehicles." )
end
Wysłany: 2018-06-14, 19:59
OchIAch
Wiek: 26 Na forum: 3114 dni Posty: 144
Nick w MP: OchIAch
Piwa : 1311
"Grace" napisał/a :to twoje 'AUTO INCREMENT' to jest nadawanie numeracji w bazach danych.
Np tworzysz tabele konta, w ktorej masz ID konta, login i haslo.
Teraz zamiast pobiera? ostatni numer ID z bazy danych, wystarczy w niej da? autoinceremt, wtedy numeracja b?dzie od 1 - niesko?czono?ci.
Ni?ej masz przyk?ad zastosowania wyj?ty z paczki ogrpg. Oczywi?cie funkcja wykonywana przy startcie zasobu.
function onRespawnVehicles ( _ , id , poss )
-- Settings ( QUERY )
if id then
result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_vehicles WHERE parking=1 AND id=?" , id )
query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_vehicles SET parking=0 WHERE id=?" , id )
else
result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_vehicles WHERE parking=0" )
end
-- Pairs
for ile , vehicle in pairs ( result ) do
vehicles = ile
if id then pos ={ poss [ 1 ], poss [ 2 ], poss [ 3 ], poss [ 4 ], poss [ 5 ], poss [ 6 ]}
else pos = split ( vehicle [ "pos" ], "," ) end
local color = split ( vehicle [ "color" ], "," )
local lights = split ( vehicle [ "headlights" ], "," )
local veh = createVehicle ( vehicle [ "model" ], pos [ 1 ], pos [ 2 ], pos [ 3 ], pos [ 4 ], pos [ 5 ], pos [ 6 ])
setVehicleColor ( veh , color [ 1 ], color [ 2 ], color [ 3 ], color [ 4 ])
setVehicleHeadLightColor ( veh , lights [ 1 ], lights [ 2 ], lights [ 3 ])
setVehiclePlateText ( veh , vehicle [ "plateText" ] or vehicle [ "id" ])
setElementFrozen ( veh , ( vehicle [ "frozen" ]) > 0 )
setVehiclePaintjob ( veh , vehicle [ "paintjob" ])
setElementHealth ( veh , vehicle [ "health" ])
setElementData ( veh , "vehicle:spawn" , true )
setElementData ( veh , "vehicle:id" , vehicle [ "id" ])
setElementData ( veh , "vehicle:fuel" , vehicle [ "fuel" ])
setElementData ( veh , "vehicle:desc" , vehicle [ "desc" ])
setElementData ( veh , "vehicle:mileage" , vehicle [ "mileage" ])
setElementData ( veh , "vehicle:driver" , vehicle [ "driver" ])
setElementData ( veh , "vehicle:ownedGroup" , vehicle [ "ownedGroup" ])
setElementData ( veh , "vehicle:ownedPlayer" , vehicle [ "ownedPlayer" ])
setElementData ( veh , "vehicle:ownedFaction" , vehicle [ "ownedFaction" ])
for i , v in ipairs ( split ( vehicle [ "tuning" ], "," )) do addVehicleUpgrade ( veh , v ) end
for i , v in ipairs ( split ( vehicle [ "panelstates" ], "," )) do setVehiclePanelState ( veh , i , tonumber ( v )) end
end
outputDebugString ( "[og-vehicles] Loaded " .. vehicles .. " vehicles." )
end
?le mnie zrozumia?e?, nie chce nadawa? pojazdowi CIDu tylko chce zrobi? ?e:
Gracz kupuje auto to daje cid auta na AUTO INCREMENT czyli: setElementData(kupiony.pojazd, "CID", i tutaj AUTO INCREMENT)
za pomoc dam piwo i respekt
[ Dodano : 2018-07-04, 09:28 ]
Do zamkniecia
)))))))))))))))))))))))))))))))))))))))
Tagi: auto :: increment
Anonymous
Na forum: 245 dni
Posty: 1
Anonymous Koniecznie zajrzyj na: