GTAONLINE.PL :: Logowanie nie działa

Zaloguj się by uzyskać pełen dostęp. Nie masz jeszcze konta? Założ je już teraz w kilka sekund.

witam jestem zielony i zainstalowalem paczke psrpg i wyskakuje mi takie co?: ERROR:[nanky]/psrpg-logging/s_logging.lua:22 call: failed to call 'pystories-db:dbGet' [string"?"]

w??cz zas?b pystories-db

no niestety jest w??czony i pisze POLACZONO POMYSLNIE

Poka? funkcj? dbGet(strona serwera) oraz mete tego zasobu

"Shuffle" napisał/a:

Poka? funkcj? dbGet(strona serwera) oraz mete tego zasobu

nie wiem o co chodzi ze strona serwera ale przesylam meta:
<meta>

<export function="dbSet" type="server" />
<export function="dbGet" type="server" />


<script src="s_db.lua" type="server" />
</meta>
i tutaj dbGet
function dbGet(...)
if not {...} then return end
local stringe=dbPrepareString(DBHandler,...)
local query=dbQuery(DBHandler, stringe)
local result,num_affected_rows, last_insert_id =dbPoll(query, -1)
return result
end

Poka? teraz zas?b "s_logging.lua"

"Shuffle" napisał/a:

Poka? teraz zas?b "s_logging.lua"

Kod:

--[[

     Panel Logowania by Kurianusz @2016 . 

	 Regulamin /Licencja

	 Korzystanie z tego kodu tylko je?eli posiadasz tzw. copyrights. Zakaz usuwania tej notatki!

	 Pami?taj ?e nielegalne korzystanie z kodu podpada pod kodeks karny :> Tak samo jak usuni?cie tej notatki!

]]

function sprawdzorganizacje(plr)

local x = exports['pystories-db']:dbGet("SELECT spawn from pystories_organization_list join pystories_organizations on pystories_organizations.code = pystories_organization_list.id WHERE sid=? and not(spawn=?)",getElementData(plr,"player:sid"),"0,0,0")

if x and #x > 0 then

local t = split(x[1].spawn, ",")

	return t

end

return false

end

addEvent("logging:checkAccount", true)

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

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

	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, "Zaaktualizowano twoj profil! Zaloguj sie ponownie!.","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, "Zaaktualizowano twoj profil! Zaloguj sie ponownie!.","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, "Zaaktualizowano twoj profil! Zaloguj sie ponownie!.","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, "Kto? jest zalogowany na to konto!!!!!.","blad")

				return

			end

			end

			--local result2=exports['pystories-db']:dbGet("SELECT login2 from pystories_users where id=?",result[1].id)

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

			setPlayerName(client, result[1].login2)

			outputChatBox("Wykupiono us?uge zmiana pseudonimu, tw?j nick to: "..result[1].login2.."", client, 255, 255, 255)

			else

			setPlayerName(client, login)

			end

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

			exports['pystories-core']:loadPlayerData(client)

			triggerClientEvent(client, "logging:result", resourceRoot, true, "Zalogowa?e? si? pomyslnie","git")

			triggerEvent("SprawdzDom",root,client)

			setElementData(client,"player:organization:spawn",sprawdzorganizacje(client))

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

			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, "Podane dane s? nieprawid?owe.","blad")

		end

	else

		triggerClientEvent(client, "logging:result", resourceRoot, false, "Podany login nie istnieje w bazie.","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 login = escapeStrings(login)

    local pass = escapeStrings(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, "Na ten serial zostala utworzona maksymalna ilosc kont.","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, "Podany login ju? istnieje w bazie.","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, "Pomy?lnie zarejestrowa?e?(a?) si?","git")

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

		end

	end

end)

function escapeStrings(str)

    local String = string.gsub(tostring(str),"'","")

    String = string.gsub(String, '"', "")

    String = string.gsub(String, ';', "")

    String = string.gsub(String, "\\", "")

    String = string.gsub(String, "/*", "")

    String = string.gsub(String, "*/", "")

    String = string.gsub(String, "'", "")

    String = string.gsub(String, "`", "")

    String = string.gsub(String, " ", "")

    String = string.gsub(String, " ", "")

    return String

end

Komentarz Shuffle dodany 2021-04-16, 16:27Przypominam, że kod wstawiamy w [code] badz [lua]

Dziwne, w kodzie wszystko jest w porz?dku, spr?buj zatem zrestartowac najpierw pystories-db a potem zasob z logowaniem.

"Shuffle" napisał/a:

Dziwne, w kodzie wszystko jest w porz?dku, spr?buj zatem zrestartowac najpierw pystories-db a potem zasob z logowaniem.

dobrze

[ Dodano: 2021-04-16, 16:34 ]

"Shuffle" napisał/a:

Dziwne, w kodzie wszystko jest w porz?dku, spr?buj zatem zrestartowac najpierw pystories-db a potem zasob z logowaniem.

hmmmm przy restarcie znajduje blad

Kod:

Loading script failed:[bazadanych]/pystories-db/s_db.lua:6: unfinished string near "137.74.6.118"

Poka? kod pystories-db

"satan_" napisał/a:

Poka? kod pystories-db

Kod:

-- Settings

DBHandler=nil

DBName="db_69435"

DBUser="db_69435"

DBPass="***"

DBHost="137.74.6.118

-- Functions

-- Functions

function dbSet(...)

	if not {...} then return end

	local qh = dbQuery(DBHandler, ...)

	if not qh then return false end

	local result, num_affected_rows, last_insert_id = dbPoll(qh, -1)

	return result, num_affected_rows, last_insert_id

end

function dbGet(...)

	if not {...} then return end

	local stringe=dbPrepareString(DBHandler,...)

	local query=dbQuery(DBHandler, stringe)

	local result,num_affected_rows, last_insert_id =dbPoll(query, -1)

	return result

end

addEventHandler("onResourceStart", resourceRoot, function()

	DBHandler=dbConnect("mysql", "dbname="..DBName..";host="..DBHost.."", DBUser, DBPass, "share=1")

	if DBHandler then

		outputDebugString("* Connect to server MYSQL...")

	else

		outputDebugString("* No Connecting to server MYSQL..")

	end

end)


-- Settings
DBHandler=nil
DBName="db_69435"
DBUser="db_69435"
DBPass="***"
DBHost="137.74.6.118"

-- Functions
-- Functions
function dbSet(...)
if not {...} then return end
local qh = dbQuery(DBHandler, ...)
if not qh then return false end
local result, num_affected_rows, last_insert_id = dbPoll(qh, -1)
return result, num_affected_rows, last_insert_id
end

function dbGet(...)
if not {...} then return end
local stringe=dbPrepareString(DBHandler,...)
local query=dbQuery(DBHandler, stringe)
local result,num_affected_rows, last_insert_id =dbPoll(query, -1)
return result
end

addEventHandler("onResourceStart", resourceRoot, function()
DBHandler=dbConnect("mysql", "dbname="..DBName..";host="..DBHost.."", DBUser, DBPass, "share=1")
if DBHandler then
outputDebugString("* Connect to server MYSQL...")
else
outputDebugString("* No Connecting to server MYSQL..")
end
end)

"ddasasd" napisał/a:

"satan_" napisał/a:

Poka? kod pystories-db

Kod:

-- Settings

DBHandler=nil

DBName="db_69435"

DBUser="db_69435"

DBPass="***"

DBHost="137.74.6.118

-- Functions

-- Functions

function dbSet(...)

	if not {...} then return end

	local qh = dbQuery(DBHandler, ...)

	if not qh then return false end

	local result, num_affected_rows, last_insert_id = dbPoll(qh, -1)

	return result, num_affected_rows, last_insert_id

end

function dbGet(...)

	if not {...} then return end

	local stringe=dbPrepareString(DBHandler,...)

	local query=dbQuery(DBHandler, stringe)

	local result,num_affected_rows, last_insert_id =dbPoll(query, -1)

	return result

end

addEventHandler("onResourceStart", resourceRoot, function()

	DBHandler=dbConnect("mysql", "dbname="..DBName..";host="..DBHost.."", DBUser, DBPass, "share=1")

	if DBHandler then

		outputDebugString("* Connect to server MYSQL...")

	else

		outputDebugString("* No Connecting to server MYSQL..")

	end

end)

Na pewno masz wszystko dobrze pod??czone? Masz tabele w MySQL?

Znajdź mnie na:
Steamie
GitHubie

"satan_" napisał/a:


-- Settings
DBHandler=nil
DBName="db_69435"
DBUser="db_69435"
DBPass="***"
DBHost="137.74.6.118"

-- Functions
-- Functions
function dbSet(...)
if not {...} then return end
local qh = dbQuery(DBHandler, ...)
if not qh then return false end
local result, num_affected_rows, last_insert_id = dbPoll(qh, -1)
return result, num_affected_rows, last_insert_id
end

function dbGet(...)
if not {...} then return end
local stringe=dbPrepareString(DBHandler,...)
local query=dbQuery(DBHandler, stringe)
local result,num_affected_rows, last_insert_id =dbPoll(query, -1)
return result
end

addEventHandler("onResourceStart", resourceRoot, function()
DBHandler=dbConnect("mysql", "dbname="..DBName..";host="..DBHost.."", DBUser, DBPass, "share=1")
if DBHandler then
outputDebugString("* Connect to server MYSQL...")
else
outputDebugString("* No Connecting to server MYSQL..")
end
end)

na przysz?o??, nie podawaj has?a tylko je zacenzuruj czy co?.

ok, serwer jest na haslo tylko dla znaj

[ Dodano: 2021-04-16, 16:43 ]

"xyzzz^" napisał/a:

"ddasasd" napisał/a:

"satan_" napisał/a:

Poka? kod pystories-db

Kod:

-- Settings

DBHandler=nil

DBName="db_69435"

DBUser="db_69435"

DBPass="***"

DBHost="137.74.6.118

-- Functions

-- Functions

function dbSet(...)

	if not {...} then return end

	local qh = dbQuery(DBHandler, ...)

	if not qh then return false end

	local result, num_affected_rows, last_insert_id = dbPoll(qh, -1)

	return result, num_affected_rows, last_insert_id

end

function dbGet(...)

	if not {...} then return end

	local stringe=dbPrepareString(DBHandler,...)

	local query=dbQuery(DBHandler, stringe)

	local result,num_affected_rows, last_insert_id =dbPoll(query, -1)

	return result

end

addEventHandler("onResourceStart", resourceRoot, function()

	DBHandler=dbConnect("mysql", "dbname="..DBName..";host="..DBHost.."", DBUser, DBPass, "share=1")

	if DBHandler then

		outputDebugString("* Connect to server MYSQL...")

	else

		outputDebugString("* No Connecting to server MYSQL..")

	end

end)

Na pewno masz wszystko dobrze pod??czone? Masz tabele w MySQL?

tak

[ Dodano: 2021-04-16, 16:53 ]
[quote="satan_"]


-- Settings
DBHandler=nil
DBName="db_69435"
DBUser="db_69435"
DBPass="***"
DBHost="137.74.6.118"

-- Functions
-- Functions
function dbSet(...)
if not {...} then return end
local qh = dbQuery(DBHandler, ...)
if not qh then return false end
local result, num_affected_rows, last_insert_id = dbPoll(qh, -1)
return result, num_affected_rows, last_insert_id
end

function dbGet(...)
if not {...} then return end
local stringe=dbPrepareString(DBHandler,...)
local query=dbQuery(DBHandler, stringe)
local result,num_affected_rows, last_insert_id =dbPoll(query, -1)
return result
end

addEventHandler("onResourceStart", resourceRoot, function()
DBHandler=dbConnect("mysql", "dbname="..DBName..";host="..DBHost.."", DBUser, DBPass, "share=1")
if DBHandler then
outputDebugString("* Connect to server MYSQL...")
else
outputDebugString("* No Connecting to server MYSQL..")
end
end)

"ddasasd" napisał/a:

"satan_" napisał/a:


-- Settings
DBHandler=nil
DBName="db_69435"
DBUser="db_69435"
DBPass="***"
DBHost="137.74.6.118"

-- Functions
-- Functions
function dbSet(...)
if not {...} then return end
local qh = dbQuery(DBHandler, ...)
if not qh then return false end
local result, num_affected_rows, last_insert_id = dbPoll(qh, -1)
return result, num_affected_rows, last_insert_id
end

function dbGet(...)
if not {...} then return end
local stringe=dbPrepareString(DBHandler,...)
local query=dbQuery(DBHandler, stringe)
local result,num_affected_rows, last_insert_id =dbPoll(query, -1)
return result
end

addEventHandler("onResourceStart", resourceRoot, function()
DBHandler=dbConnect("mysql", "dbname="..DBName..";host="..DBHost.."", DBUser, DBPass, "share=1")
if DBHandler then
outputDebugString("* Connect to server MYSQL...")
else
outputDebugString("* No Connecting to server MYSQL..")
end
end)

na przysz?o??, nie podawaj has?a tylko je zacenzuruj czy co?.

ok, serwer jest na haslo tylko dla znaj

[ Dodano: 2021-04-16, 16:43 ]

"xyzzz^" napisał/a:

"ddasasd" napisał/a:

"satan_" napisał/a:

Poka? kod pystories-db

Kod:

-- Settings

DBHandler=nil

DBName="db_69435"

DBUser="db_69435"

DBPass="***"

DBHost="137.74.6.118

-- Functions

-- Functions

function dbSet(...)

	if not {...} then return end

	local qh = dbQuery(DBHandler, ...)

	if not qh then return false end

	local result, num_affected_rows, last_insert_id = dbPoll(qh, -1)

	return result, num_affected_rows, last_insert_id

end

function dbGet(...)

	if not {...} then return end

	local stringe=dbPrepareString(DBHandler,...)

	local query=dbQuery(DBHandler, stringe)

	local result,num_affected_rows, last_insert_id =dbPoll(query, -1)

	return result

end

addEventHandler("onResourceStart", resourceRoot, function()

	DBHandler=dbConnect("mysql", "dbname="..DBName..";host="..DBHost.."", DBUser, DBPass, "share=1")

	if DBHandler then

		outputDebugString("* Connect to server MYSQL...")

	else

		outputDebugString("* No Connecting to server MYSQL..")

	end

end)

Na pewno masz wszystko dobrze pod??czone? Masz tabele w MySQL?

tak

[ Dodano: 2021-04-16, 16:53 ]
[quote="satan_"]


-- Settings
DBHandler=nil
DBName="db_69435"
DBUser="db_69435"
DBPass="***"
DBHost="137.74.6.118"

-- Functions
-- Functions
function dbSet(...)
if not {...} then return end
local qh = dbQuery(DBHandler, ...)
if not qh then return false end
local result, num_affected_rows, last_insert_id = dbPoll(qh, -1)
return result, num_affected_rows, last_insert_id
end

function dbGet(...)
if not {...} then return end
local stringe=dbPrepareString(DBHandler,...)
local query=dbQuery(DBHandler, stringe)
local result,num_affected_rows, last_insert_id =dbPoll(query, -1)
return result
end

addEventHandler("onResourceStart", resourceRoot, function()
DBHandler=dbConnect("mysql", "dbname="..DBName..";host="..DBHost.."", DBUser, DBPass, "share=1")
if DBHandler then
outputDebugString("* Connect to server MYSQL...")
else
outputDebugString("* No Connecting to server MYSQL..")
end
end)

na przysz?o??, nie podawaj has?a tylko je zacenzuruj czy co?.[/quote]
dobra, nie pomoglo masz moze jakas fajna paczke nawet z backdoorami moze byc

zadna paczka z neta nie jest dobra

Znajdź mnie na:
Steamie
GitHubie