Napisa?em funkcj? do logowania przez gui.
Problem w tym, ?e nie potrafi? por?wna? loginu z gui z tym co jest w bazie.
Z clienta przesy?am login i has?o z gui
[lua]
function loginReq(login,password)
local login = guiGetText(editLogin)
local password = guiGetText(editPassword)
triggerServerEvent("loginReq",root,login,password)
end
addEvent("loginReq",true)
addEventHandler("loginReq",root, loginReq)
[/lua]
A na serwerze wykonuje tak
[lua]
SQL = dbConnect("mysql", "dbname=test;host=localhost", "","","share=1")
addEvent("loginReq",true)
addEventHandler("loginReq",getRootElement(), function (login,password)
local loginDb = dbQuery(SQL,"SELECT * FROM konto WHERE login =?",login)--wyszuka rekordy z takim samym nickiem
local resultLogin = dbPoll(loginDb,-1)
local passwordDb = dbQuery(SQL,"SELECT * FROM konto WHERE password=?",password)
local resultPassword = dbPoll(passwordDb,-1)
if #resultLogin then
if #resultLogin == login then
if resultPassword == password then
triggerClientEvent("closeGui",source)
outputDebugString("zalogowales")
else
outputDebugString("ne")
end
outputDebugString("loginy zgadzaja sie&q... |