GTAONLINE.PL :: OGRPG Zabiera prawko na stałe

Ciastuu?, Witam ju? daje kody

ZPJ

Kod:

addCommandHandler("zpj", function(plr,cmd,cel,time,rodzaj,...)

	if getAdmin(plr,4) or getAdmin(plr,3) or getAdmin(plr,2) or getAdmin(plr,1) then

		local reason = table.concat({...}, " ")

		if not cel or not tonumber(time) or not rodzaj or not reason then

			outputChatBox("* U?ycie: /zpj <nick/ID> <czas> <jednostka: m/h/d/w> <pow?d>", plr)

			return

		end

		local target = exports["ogrpg-core"]:findPlayer(plr,cel)

		if not target then

			triggerClientEvent(plr, "iyw_notifications:send", plr, "error", "Nie znaleziono podanego gracza.")

			return

		end

		local v = getPedOccupiedVehicle(target)

		local vid = getElementData(v,"vehicle:id")

		local query = string.format("SELECT * FROM ogrpg_punish WHERE type = %q AND active = 1 AND serial = %q AND time>NOW() LIMIT 1","prawko", getPlayerSerial(target))

		local result = exports["DB2"]:pobierzWyniki(query)

		if (result) then

			return outputChatBox(" Gracz Posiada zawieszone prawo jazdy do "..result["time"]..", za: "..result["reason"], plr, 255, 0, 0)

		else

			exports["ogrpg-db"]:dbSet("DELETE FROM ogrpg_punish WHERE type = ? AND active = 1 AND serial = ?", "prawko", getPlayerSerial(plr))

		end

		if isPedInVehicle(target) then

			if not getElementData(v, "vehicle:duty") then

				removePedFromVehicle(target)

				exports["ogrpg-db"]:dbSet("UPDATE ogrpg_vehicles SET parking = 1,tp_to_parking = ? WHERE id = ?","ZPJ", vid)

				exports["iyw_vehicles"]:onSaveVehicle(v)

				destroyElement(v)

			else

				removePedFromVehicle(target)

				respawnVehicle(v)

			end

		end

		if tonumber(time) <= 0 then return end

		reason = reason..""

		if rodzaj == "m" then

		exports["ogrpg-db"]:dbSet("INSERT INTO ogrpg_punish (serial,reason,time,type) VALUES (?,?,NOW() + INTERVAL ? minute,?)", getPlayerSerial(target),reason, time, "prawko")

		elseif rodzaj == "h" then

		exports["ogrpg-db"]:dbSet("INSERT INTO ogrpg_punish (serial,reason,time,type) VALUES (?,?,NOW() + INTERVAL ? hour,?)", getPlayerSerial(target),reason, time, "prawko")

		elseif rodzaj == "d" then

		exports["ogrpg-db"]:dbSet("INSERT INTO ogrpg_punish (serial,reason,time,type) VALUES (?,?,NOW() + INTERVAL ? day,?)", getPlayerSerial(target),reason, time, "prawko")

		elseif rodzaj == "w" then

		exports["ogrpg-db"]:dbSet("INSERT INTO ogrpg_punish (serial,reason,time,type) VALUES (?,?,NOW() + INTERVAL ? week,?)", getPlayerSerial(target),reason, time, "prawko")

		end

		exports["ogrpg-db"]:dbSet("insert into kartoteka (typ,karajacy,data,powod,ofiara) VALUES(?,?,NOW(),?,?)", "ZPJ", plr.name:gsub("#%x%x%x%x%x%x",""), reason, getElementData(target, "player:uid"))

		triggerClientEvent(root, "adminRender", root, "Gracz "..getPlayerName(target).." otrzyma? zakaz prowadzenia pojazd?w od "..plr.name..", pow?d: "..reason.." ("..time .. rodzaj..")")

		--setElementData(target, "player:license:pjB", false)

		--local query = exports['ogrpg-db']:dbSet("UPDATE ogrpg_users SET pjB = 0 WHERE id = ?",getElementData(target,"player:uid"))

		--triggerEvent("save:player",root,target)

		--local query = string.format("INSERT INTO ogrpg_punish (serial,reason,time,type) VALUES ('%s','%s',%s,'%s')", getPlayerSerial(target), reason, result, prawko)

		--exports["ogrpg-db"]:dbSet(query)

		--outputChatBox("* Dodanych rekord", plr)

	end

end)

OPJ

Kod:

addCommandHandler("opj", function(plr,cmd,cel)

	if getAdmin(plr,4) or getAdmin(plr,3) or getAdmin(plr,2) or getAdmin(plr,1) then

		if not cel then

			outputChatBox("* U?ycie: /opj <nick/ID> ", plr)

			return

		end

		local target = exports["ogrpg-core"]:findPlayer(plr,cel)

		if not target then

			triggerClientEvent(plr, "iyw_notifications:send", plr, "error", "Nie znaleziono podanego gracza.")

			return

		end

		local query = string.format("SELECT * FROM ogrpg_punish WHERE type = %q AND active = 1 AND serial = %q AND time>NOW() LIMIT 1","prawko", getPlayerSerial(target))

		local result = exports["ogrpg-db"]:pobierzWyniki(query)

		if (result) then

			exports["ogrpg-db"]:dbSet("DELETE FROM ogrpg_punish WHERE type = ? AND active = 1 AND serial = ?", "prawko", getPlayerSerial(target))

			outputChatBox("* Gracz "..getPlayerName(target):gsub("#%x%x%x%x%x%x","").." odzyskal swoje prawo jazdy!", plr, 0, 255, 0)

			outputChatBox("* "..plr.name:gsub("#%x%x%x%x%x%x","").." oddal Twoje prawo jazdy!", target, 0, 255, 0)

		else

			outputChatBox("* Gracz "..getPlayerName(target):gsub("#%x%x%x%x%x%x","").." nie posiada zabranego prawka!", plr, 0, 255, 0)

		end

		exports["ogrpg-db"]:dbSet("INSERT INTO ogrpg_prawka_logs (komu_oddali,kto_oddal,typ) VALUES (?,?,?)", getPlayerName(target):gsub("#%x%x%x%x%x%x",""), plr.name:gsub("#%x%x%x%x%x%x",""), "prawo jazdy")

	end

end)

a powinno zapisywa? tutaj ale nie zapisuje

https://imgur.com/a/A03TPap