Wysłany: 2016-04-23, 20:56
Michaler
Wiek: 26 Na forum: 3798 dni Posty: 77
Piwa : 1009
witam mam problem z systemem pojazd?w og. db jest podpi?te i w konsoli wyskakuj? takie oto b??dy
ERROR : og - vehicles / s_misc . lua : 24 : bad argument #1 to 'pairs' (table expected, got boolean)
ERROR : og - vehicles / s_misc . lua : 20 : call : failed to call 'og-db:getRekord' [ string "?" ] mo?e kto? co? podpowie co mam zrobi? by to ogarn??
Wysłany: 2016-04-28, 22:52
Michaler
Wiek: 26 Na forum: 3798 dni Posty: 77
Piwa : 1009
to mi du?o nie m?wi. mo?e jakie przyk?ady co mo?e by? nie tak?
je?eli trzeba to dodam ca?y kod db
Wysłany: 2016-04-28, 22:57
Emm
***** ***
Wiek: 32 Na forum: 3880 dni Posty: 3191
Nick w MP: Emm
Piwa : 6162
Administrator: Admin ma zawsze rację | REGULAMIN FORUM | REKLAMA/VIP | .
Najlepiej to podaj kod, bo bez kodu nic nie zdzia?amy
Podpis
Użytkownik : 20.10.2015r
GTAO Member : 06.03.2016r
Support-Team : 20.01.2016r
Moderator : 30.03.2016r
Mod-Team : 08.10.2016r
Vice Admin : 04.05.2018r
Administrator : 03.05.2022r
[you]
! Koniecznie zapoznaj się z
regulaminem forum .
Pamiętaj, aby zawsze go przestrzegać, nie mniej ważne są również
regulaminy działów , w których się wypowiadasz!
Zamiast zakładać temat po kilka razy, bo jest usuwany przez
Administrację , przejrzyj regulamin i napisz poprawnie temat!
Sprawy z administracją możesz załatwiać anonimowo w
tym dziale .
Najważniejsze informacje od
Administracji możesz przeczytać
tutaj oraz
tutaj .
Wysłany: 2016-04-28, 23:27
Michaler
Wiek: 26 Na forum: 3798 dni Posty: 77
Piwa : 1009
--[[
Resource : OURGame v2
Developers : Split < split . programista @ gmail . com >
You have no right to use this code without my permission .
( c ) 2015 < split . programista @ gmail . com >. All rights reserved .
]]
-- Settings
DBHandler = nil
DBName = "xxx"
DBUser = "xxx"
DBPass = "xxx"
DBHost = "xxx"
-- Functions
function dbSet (...)
if not {...} then return end
local query = dbExec ( DBHandler , ...)
return query
end
function dbGet (...)
if not {...} then return end
local query = dbQuery ( DBHandler , ...)
local result = dbPoll ( query , - 1 )
return result
end
Podpis
~~~~ NIE ODPOWIADAM NA ŻADNE KOMENTARZE ~~~~
Wysłany: 2016-04-29, 14:32
Kurczak23
Wiek: 32 Na forum: 5032 dni Posty: 30
Piwa : 499
og-vehicles/s_misc.lua w 20 linijce podmien
exports:['og-db']:getRekord na exports["og-db"]:dbGet
Wysłany: 2016-04-30, 13:46
Michaler
Wiek: 26 Na forum: 3798 dni Posty: 77
Piwa : 1009
result = exports [ "og-db" ]: getRekord ( "SELECT * FROM og_vehicles WHERE parking=0" )
tak jest. nic nie zmienia?em.
[ Dodano : 2016-04-30, 13:48 ]
dam ca?y kod og-vehicles mo?e kto? sobie z tym poradzi
--[[
Resource : OURGame v2
Developers : Split < split . programista @ gmail . com >
You have no right to use this code without my permission .
( c ) 2015 < split . programista @ gmail . com >. All rights reserved .
]]
-- ///////////////////////////////////// USTAWIENIA ////////////////////////////////////////
vehicles = 0
root = getRootElement ()
resourceRoot = getResourceRootElement ( getThisResource ())
-- ///////////////////////////////////// WCZYTYWANIE POJAZD?W /////////////////////////////////
function onRespawnVehicles ( _ , id , poss )
-- Settings ( QUERY )
if id then
result = exports [ "og-db" ]: getRekord ( "SELECT * FROM og_vehicles WHERE parking=1 AND id=?" , id )
query = exports [ "og-db" ]: setRekord ( "UPDATE og_vehicles SET parking=0 WHERE id=?" , id )
else
result = exports [ "og-db" ]: getRekord ( "SELECT * FROM og_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
-- ///////////////////////////////////// ZAPISYWANIE POJAZD?W /////////////////////////////////
function onSaveVehicle ( vehicle )
if getElementData ( vehicle , "vehicle:spawn" ) then
-- Settings
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 = getVehicleColor ( vehicle )
local driver = getElementData ( vehicle , "vehicle:driver" ) or ""
local faction = getElementData ( vehicle , "vehicle:ownedFaction" )
local player = getElementData ( vehicle , "vehicle:ownedPlayer" )
local group = getElementData ( vehicle , "vehicle:ownedGroup" )
local h1 , h2 , h3 = getVehicleHeadLightColor ( vehicle )
local paintjob = getVehiclePaintjob ( vehicle )
local frozen = isElementFrozen ( vehicle ) and 1 or 0
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 , "," )
local plate = getVehiclePlateText ( vehicle )
-- Query
local query = exports [ "og-db" ]: setRekord ( string . format ( "UPDATE og_vehicles SET model='%d', pos='%.2f,%.2f,%.2f,%.2f,%.2f,%.2f', text='%s', health='%d', fuel='%d', mileage='%d', frozen='%d', driver='%s', color='%d,%d,%d,%d', panelstates='%s', paintjob='%d', tuning='%s', headlights='%d,%d,%d', plateText='%s', ownedFaction='%s', ownedPlayer='%d', ownedGroup='%d' WHERE id=%d" ,
model , x , y , z , rx , ry , rz , desc , health , fuel , mileage , frozen , driver , c1 , c2 , c3 , c4 , panelstates , paintjob , upgrades , h1 , h2 , h3 , plate , faction , player , group , id ))
end
end
-- ///////////////////////////////////// SPRAWDZANIE USTAWIE? /////////////////////////////////
function getSettings ( plr , code , value )
local uid = getElementData ( plr , "player:uid" )
if not uid then return end
if value == "faction" then
local result = exports [ "og-db" ]: getRekord ( "SELECT * FROM og_factions WHERE code=? AND uid=?" , code , uid )
if result and #result > 0 then
return result [ 1 ]. code
else
return false
end
end
if value == "organization" then
local result = exports [ "og-db" ]: getRekord ( "SELECT * FROM og_organizations WHERE code=? AND uid=?" , code , uid )
if result and #result > 0 then
return result [ 1 ]. code
else
return false
end
end
if value == "owner" then
local result = exports [ "og-db" ]: getRekord ( "SELECT * FROM og_users WHERE id=?" , uid )
if result and #result > 0 then
return result [ 1 ]. id
else
return false
end
end
end
-- ///////////////////////////////////// INNE USTAWIENIA /////////////////////////////////
addEventHandler ( "onVehicleExit" , root , function( _ , seat )
if seat ~= 0 then return end
onSaveVehicle ( source )
setVehicleEngineState ( source , false )
end )
addEventHandler ( "onPlayerQuit" , root , function()
local veh = getPedOccupiedVehicle ( source )
if veh then
onSaveVehicle ( veh )
end
end )
addEventHandler ( "onResourceStop" , resourceRoot , function()
for i , v in ipairs ( getElementsByType ( "vehicle" )) do
onSaveVehicle ( v )
end
outputDebugString ( "[og-vehicles] Saved all vehicles!" )
end )
addEventHandler ( "onVehicleEnter" , root , function( plr , seat )
if seat ~= 0 then return end
setVehicleEngineState ( source , false )
setElementData ( source , "vehicle:driver" , getPlayerName ( plr ))
end )
-- ///////////////////////////////////// SPRAWDZENIE W?A?CICIELA /////////////////////////////////
addEventHandler ( "onVehicleStartEnter" , resourceRoot , function( plr , seat , jacked )
if seat == 0 then
local faction = getElementData ( source , "vehicle:ownedFaction" )
local group = getElementData ( source , "vehicle:ownedGroup" )
local player = getElementData ( source , "vehicle:ownedPlayer" )
local prawko = getElementData ( source , "player:pjA" )
local prawko1 = getElementData ( source , "player:pjB" )
local prawko2 = getElementData ( source , "player:pjC" )
if faction and string . len ( faction ) > 3 then
if faction ~= getSettings ( plr , faction , "faction" ) then
outputChatBox ( "* Nie jeste? zatrudniony/(a) w tej frakcji." , plr , 255 , 0 , 0 )
cancelEvent ()
end
return
end
if group and group ~= 0 then
if group ~= getSettings ( plr , group , "organization" ) then
outputChatBox ( "* Nie jeste? zatrudniony/(a) w tej organizacji." , plr , 255 , 0 , 0 )
cancelEvent ()
end
return
end
if player and player ~= getSettings ( plr , false , "owner" ) then
outputChatBox ( "* Nie masz kluczyk?w do tego pojazdu b?d? nie posiadasz prawajazdy!" , plr , 255 , 0 , 0 )
cancelEvent ()
end
end
end )
addEventHandler ( "onVehicleStartEnter" , root , function( plr , seat , jacked )
if jacked then
cancelEvent ()
end
end )
addEventHandler ( "onResourceStart" , resourceRoot , function() onRespawnVehicles ( _ , false ) end )
Podpis
~~~~ NIE ODPOWIADAM NA ŻADNE KOMENTARZE ~~~~
Tagi: 0g-system :: pojazdów
Anonymous
Na forum: 245 dni
Posty: 1
Anonymous Koniecznie zajrzyj na: