addEvent("logging:checkAccount", true)
addEventHandler("logging:checkAccount", resourceRoot, function(login,pass,save)
local result=exports["tiyl-db"]:dbGet("SELECT * FROM tiyl_gracze WHERE login=?", login)
if result and #result > 0 then
serial=getPlayerSerial(client)
if result[1].register_serial~=serial then
tak=true
for i,v in ipairs(split(result[1].seriale,",")) do
if v==serial then tak=false end
end
if tak then
return triggerClientEvent(client, "logging:result", resourceRoot, false, "Error: Wykryto inny serial logowania konta. Napisz na forum","nope")
end
end
if result[1].login == login and result[1].pass == md5(pass) then
local query=exports["tiyl-db"]:dbSet("UPDATE tiyl_gracze SET pass=? WHERE login=?",teaEncode(pass,"Trujeczka321321"),login)
triggerClientEvent(client, "logging:result", resourceRoot, false, "Trwa logowanie do konta...","git")
return
end
if result[1].login == login and result[1].pass == teaEncode(pass,"dafgudhg63268") then
local query=exports["tiyl-db"]:dbSet("UPDATE tiyl_gracze SET pass=? WHERE login=?",teaEncode(pass,"Trujeczka1233213"),login)
triggerClientEvent(client, "logging:result", resourceRoot, false, "Trwa logowanie do konta...","git")
return
end
if result[1].login == login and result[1].pass == teaEncode(pass,"gdfdcvhj") then
local query=exports["tiyl-db"]:dbSet("UPDATE tiyl_gracze SET pass=? WHERE login=?",teaEncode(pass,"*****"),login)
triggerClientEvent(client, "logging:result", resourceRoot, false, "Trwa logowanie do konta...","git")
return
end
if result[1].login == login and result[1].pass == teaEncode(pass,"Ryjek") then
local query=exports["tiyl-db"]:dbSet("UPDATE tiyl_gracze SET pass=? WHERE login=?",teaEncode(pass,"Trujeczka"),login)
triggerClientEvent(client, "logging:result", resourceRoot, false, "Trwa logowanie do konta...","git")
return
end
if result[1].login == login and result[1].pass == teaEncode(pass,"Trujeczka") then
local query=exports["tiyl-db"]:dbSet("UPDATE tiyl_gracze SET pass=? WHERE login=?",teaEncode(pass,"*****"),login)
triggerClientEvent(client, "logging:result", resourceRoot, false, "Trwa logowanie do konta...","git")
return
end
if result[1].login == login and result[1].pass == teaEncode(pass,"*****") then
local query=exports["tiyl-db"]:dbSet("UPDATE tiyl_gracze SET pass=? WHERE login=?",teaEncode(pass,"wypierdalacchuje"),login)
triggerClientEvent(client, "logging:result", resourceRoot, false, "Trwa logowanie do konta...","git")
return
end
if result[1].login == login and result[1].pass == teaEncode(pass,"wypierdalacchuje") then
for i,player in pairs(getElementsByType("player")) do
if getElementData(player,"player:uid") == result[1].id then
triggerClientEvent(client, "logging:result", resourceRoot, false, "Podane konto jest juz zalogowane na serwerze.","blad")
return
end
end
--local result2=exports['ogrpg-db']:dbGet("SELECT login2 from ogrpg_users where id=?",result[1].id)
if result[1].login2 == false then
setPlayerName(client, login)
else
setPlayerName(client, result[1].login2)
triggerClientEvent(client, "iyw_notifications:send", client, "info", "Wykupiono us?uge zmiana pseudonimu, tw?j nick to: "..result[1].login2.."")
end
--q=exports["ogrpg-db"]:dbGet("select logowania_nagroda from ogrpg_users where id=? limit 1",result[1].id)
--exports["ogrpg-db"]:dbSet("update ogrpg_users set logowania_nagroda=logowania_nagroda+1 WHERE DATE(ostatnio_online) = DATE(NOW() - INTERVAL 1 DAY) and id=? limit 1",result[1].id)
--q3=exports["ogrpg-db"]:dbGet("select logowania_nagroda from ogrpg_users where id=? limit 1",result[1].id)
--if(tonumber(q[1].logowania_nagroda)<q3[1].logowania_nagroda)then
--nagrody[q3[1].logowania_nagroda](client)
--if(q3[1].logowania_nagroda==7)then
--exports["ogrpg-db"]:dbSet("update ogrpg_users set logowania_nagroda=0 WHERE DATE(ostatnio_online) = DATE(NOW() - INTERVAL 1 DAY) and id=? limit 1",result[1].id)
--end
--else
--exports["ogrpg-db"]:dbSet("update ogrpg_users set logowania_nagroda=0 WHERE DATE(ostatnio_online)<DATE(NOW() - INTERVAL 1 DAY) and id=? limit 1",result[1].id)
--end
--if(save) then
--triggerClientEvent(client, "createsaved:login",client,login,pass)
--else
--triggerClientEvent(client, "deletesaved:login",client)
--end
--exports["ogrpg-db"]:dbSet("update ogrpg_users set ostatnio_online=NOW() where id=?", result[1].id)
setElementData(client, "player:uid", result[1].id)
triggerClientEvent(client, "logging:result", resourceRoot, true, "Baza danych laczy z twoim kontem. Zalogowano!","git")
triggerEvent("SprawdzDom",root,client)
--setElementData(client,"player:organization:spawn",sprawdzorganizacje(client))
--setElementData(client,"p:title",result[1].rp_tytul)
if result[1].register_serial == false then
--local query=exports["ogrpg-db"]:dbSet("UPDATE ogrpg_users SET register_serial=? WHERE login=?",getPlayerSerial(client),login)
end
local logs=exports["tiyl-db"]:dbSet("INSERT INTO ogrpg_logs_login (name,serial,data) VALUES (?,?,NOW())", string.format(login.."("..result[1].id..")"),getPlayerSerial(client))
else
triggerClientEvent(client, "logging:result", resourceRoot, false, "Podane dane s? nieprawid?owe.","blad")
end
else
triggerClientEvent(client, "logging:result", resourceRoot, false, "Podane konto nie istnieje w bazie danych serwera.","blad")
end
end)
local maks_ilosc_kont = 2 -- Maksymalna ilosc kont do rejestracji
addEvent("logging:newAccount", true)
addEventHandler("logging:newAccount", resourceRoot, function(login,pass)
local result=exports["tiyl-db"]:dbGet("SELECT * FROM tiyl_gracze WHERE register_serial=?", getPlayerSerial(client))
if result and #result >= maks_ilosc_kont then
triggerClientEvent(client, "logging:result", resourceRoot, false, "Na ten serial zostala utworzona maksymalna ilosc kont.","blad")
return end
local result=exports["tiyl-db"]:dbGet("SELECT * FROM tiyl_gracze WHERE login=?", login)
if result and #result > 0 then
triggerClientEvent(client, "logging:result", resourceRoot, false, "Podane konto istnieje juz w bazie danych.","blad")
else
local query=exports["tiyl-db"]:dbSet("INSERT INTO tiyl_gracze (login,pass,register_serial,changedpw) VALUES (?,?,?,?)", login, teaEncode(pass,"*****"),getPlayerSerial(client),1)
if query then
triggerClientEvent(client, "logging:result", resourceRoot, false, "Konto zostalo utworzone pomyslnie. Zaloguj sie!","git")
setElementData(client, "player:logged", true)
end
end
end)
addEvent("sprawdzBana", true)
addEventHandler("sprawdzBana", root, function()
local query=string.format("SELECT * FROM tiyl_bany WHERE type=%q AND active=1 AND serial=%q AND time>NOW() LIMIT 1","ban", getPlayerSerial(source))
local result=exports["tiyl-db"]:pobierzWyniki(query)
if (result) then
outputConsole("---------",source)
outputConsole("| Wydruk bana z serwera Your Advneture",source)
outputConsole(string.format("| Zosta?e? zbanowany z powodu: "..result["reason"]),source)
outputConsole(string.format("| Wa?ny ban do: "..result["time"]),source)
outputConsole("---------",source)
triggerClientEvent(client, "oknoZbanowany", root)
triggerClientEvent(client, "bShowedLogin", root)
else
exports["tiyl-db"]:dbSet("DELETE FROM tiyl_bany WHERE type=? AND active=1 AND serial=?", "ban", getPlayerSerial(source))
end
end)
addEvent("banWyrzuc", true)
addEventHandler("banWyrzuc", root, function()
kickPlayer(source, "Zosta?e? zbanowany na serwerze Your Adventure!")
end)
Piwa: 6070
