Wysłany: 2016-02-16, 00:37
EseJax
Wiek: 31 Na forum: 4086 dni Posty: 67
Nick w MP: Toffy.
Piwa : 982
Cze??, robie komende na zabieranie prawka lecz mam pewien problem..
Kod:
addCommandHandler ( "zabierz.prawko" , function( plr , cmd , cel ,...)
if onCheckAdmin ( plr , 1 ) or onCheckAdmin ( plr , 2 ) or onCheckAdmin ( plr , 3 ) then
local reason = table . concat ({...}, " " )
if not cel or not reason then
outputChatBox ( "* U?ycie: /zabierz.prawko <nick/ID> <pow?d>" , plr )
return
end
local target = exports [ "og-core" ]: findPlayer ( plr , cel )
local target2 = getPlayerName ( target )
if not target then
outputChatBox ( "* Nie znaleziono podanego gracza." , plr , 255 , 0 , 0 )
return
end
if isPedInVehicle ( target ) then
removePedFromVehicle ( target )
end
outputChatBox ( "Gracz " .. getPlayerName ( target ).. " otrzyma?/a zakaz prowadzenia pojazd?w od " .. getPlayerName ( plr ).. " za " .. reason .. "" )
outputChatBox ( "Prawo jazdy mo?esz zda? na nowo w urz?dzie" , target )
exports [ "og-db" ]: setRekord ( "UPDATE 'og_users' SET 'pjC' = 0 WHERE 'login' = '" .. target2 .. "'" )
exports [ "og-db" ]: setRekord ( "UPDATE 'og_users' SET 'pjB' = 0 WHERE 'login' = '" .. target2 .. "'" )
exports [ "og-db" ]: setRekord ( "UPDATE 'og_users' SET 'pjA' = 0 WHERE 'login' = '" .. target2 .. "'" )
end
end )
DB3:
Kod:
dbExec failed; (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''og_users' SET 'pjC' = 0 WHERE 'login' = 'PrzemeK'' at line 1
Funkcje mysql:
function setRekord (...)
if not {...} then return end
local query = dbExec ( SQL_HANDLER , ...)
return query
end
function getRekord (...)
if not {...} then return end
local query = dbQuery ( SQL_HANDLER , ...)
local result = dbPoll ( query , - 1 )
return result
end
function zapytanie (...)
local h = dbQuery ( SQL_HANDLER ,...)
local result , numrows = dbPoll ( h ,- 1 )
return numrows
end
Licz? na pomoc.
Wysłany: 2016-02-16, 11:41
Wittx
8===D
Wiek: 26 Na forum: 4794 dni Posty: 121
Nick w MP: wittula
Piwa : 1905
exports [ "og-db" ]: setRekord ( "UPDATE 'og_users' SET 'pjC' = 0 WHERE 'login' = '" .. target2 .. "'" )
exports [ "og-db" ]: setRekord ( "UPDATE 'og_users' SET 'pjB' = 0 WHERE 'login' = '" .. target2 .. "'" )
exports [ "og-db" ]: setRekord ( "UPDATE 'og_users' SET 'pjA' = 0 WHERE 'login' = '" .. target2 .. "'" )
Zamie? na:
exports [ "og-db" ]: setRekord ( "UPDATE `og_users` SET `pjA`=?, `pjB`=?, `pjC`=? WHERE `login`=?" , 0 , 0 , 0 , target2 )
Wysłany: 2016-02-16, 12:58
EseJax
Wiek: 31 Na forum: 4086 dni Posty: 67
Nick w MP: Toffy.
Piwa : 982
Dzia?a, dzi?ki.. Masz piwko
Tagi: mysql :: zabieranie :: prawka
Anonymous
Na forum: 245 dni
Posty: 1
Anonymous Koniecznie zajrzyj na: