GTAONLINE.PL :: Premium

Kod:
addEvent("logging:checkAccount", true)

addEventHandler("logging:checkAccount", resourceRoot, function(login,pass)

	local result=exports["pystories-db"]:dbGet("SELECT * FROM pystories_users WHERE login=?", login)

	local result2=exports["pystories-db"]:dbGet("SELECT * FROM pystories_users WHERE register_serial=?", getPlayerSerial(client))

	if result[1].register_serial ~= getPlayerSerial(client) then

		triggerClientEvent(client, "logging:result", resourceRoot, false, "Nie masz dost?pu do tego konta!","blad")

	return end

    if not result2 then

        triggerClientEvent(client, "logging:result", resourceRoot, false, "Nie mozesz utworzyc wiecej kont!","blad")

    return end

	if result and #result > 0 then

		if result[1].login == login and result[1].pass == md5(pass) then

			local query=exports["pystories-db"]:dbSet("UPDATE pystories_users SET pass=? WHERE login=?",teaEncode(pass,"Trujeczka"),login)

			triggerClientEvent(client, "logging:result", resourceRoot, false, "Profil zaaktualizowany. Zaloguj sie","git")

			return

		end

		if result[1].login == login and result[1].pass == teaEncode(pass,"Ryjek") then

			local query=exports["pystories-db"]:dbSet("UPDATE pystories_users SET pass=? WHERE login=?",teaEncode(pass,"Trujeczka"),login)

			triggerClientEvent(client, "logging:result", resourceRoot, false, "Profil zaaktualizowany. Zaloguj sie","git")

			return

		end

		if result[1].login == login and result[1].pass == teaEncode(pass,"Trujeczka") then

			local query=exports["pystories-db"]:dbSet("UPDATE pystories_users SET pass=? WHERE login=?",teaEncode(pass,"*****"),login)

			triggerClientEvent(client, "logging:result", resourceRoot, false, "Profil zaaktualizowany. Zaloguj sie","git")

			return

		end

		if result[1].login == login and result[1].pass == teaEncode(pass,"*****") then

			for i,player in pairs(getElementsByType("player")) do

				if getElementData(player,"player:sid") == result[1].id then

				triggerClientEvent(client, "logging:result", resourceRoot, false, "Podany login juz gra!","blad")

				return end

			end

			if not result[1].login2 == false then

			setPlayerName(client, result[1].login2)

			else

			setPlayerName(client, login)

			end

			setElementData(client, "new:sid", result[1].id)

			triggerClientEvent(client, "logging:result", resourceRoot, true, "Pomyslnie zalogowano!","git")

			triggerEvent("SprawdzDom",root,client)

			local spr = exports['pystories-db']:dbGet("SELECT * FROM pystories_users WHERE id=?", getElementData(client,"new:sid"))

			if result[1].register_serial == false then

			local query=exports["pystories-db"]:dbSet("UPDATE pystories_users SET register_serial=? WHERE login=?",getPlayerSerial(client),login)

			end

			local logs=exports["pystories-db"]:dbSet("INSERT INTO pystories_logs_login (name,serial,data) VALUES (?,?,NOW())", string.format(login.."("..result[1].id..")"),getPlayerSerial(client))

		else

			triggerClientEvent(client, "logging:result", resourceRoot, false, "Podajesz zle dane!","blad")

		end

	else

		triggerClientEvent(client, "logging:result", resourceRoot, false, "Taki login juz istnieje, wymysl inny","blad")

	end

end)

local maks_ilosc_kont = 3 -- Maksymalna ilosc kont do rejestracji

addEvent("logging:newAccount", true)

addEventHandler("logging:newAccount", resourceRoot, function(login,pass)

	local result=exports["pystories-db"]:dbGet("SELECT * FROM pystories_users WHERE register_serial=?", getPlayerSerial(client))

	if result and #result >= maks_ilosc_kont then

		triggerClientEvent(client, "logging:result", resourceRoot, false, "Osiagasz limit kont! (2 konta)","blad")

	return end

	local result=exports["pystories-db"]:dbGet("SELECT * FROM pystories_users WHERE login=?", login)

	if result and #result > 0 then

		triggerClientEvent(client, "logging:result", resourceRoot, false, "Taki login juz istnieje, wymysl inny","blad")

	else

		local query=exports["pystories-db"]:dbSet("INSERT INTO pystories_users (login,pass,register_serial,changedpw) VALUES (?,?,?,??)", login, teaEncode(pass,"*****"),getPlayerSerial(client),1)

		if query then

			triggerClientEvent(client, "logging:result", resourceRoot, false, "Rejestracja przebiegla pomyslnie","git")

			setElementData(client, "player:logged", true)

		end

	end

end)
Ca?y kod logowania po stronie serwera.