Server :
function onLogin(username,password,checkboxState)
local query = dbQuery(getSQLConnection( ), "SELECT `??` FROM `??` WHERE `??` = '??' LIMIT 1", "id", "accounts", "username", username)
if (query) then
local result, num_affected_rows, errmsg = dbPoll(query, -1)
if (num_affected_rows > 0) then
local query = dbQuery(getSQLConnection( ), "SELECT * FROM `??` WHERE `??` = '??' AND `??` = '??' LIMIT 1", "accounts", "username", username, "password", sha256(string.upper(password)))
if (query) then
local result, num_affected_rows = dbPoll(query, -1) -- Here is the table (Result)
if (num_affected_rows > 0) then
triggerClientEvent(source,"showCharecters",getRootElement(),result) -- Here i would trigger it !
end
else
triggerClientEvent(source,"changeMessage",getRootElement(),"1","Wrong username and/or password", "red")
outputServerLog("Error: " .. getPlayerName(source) .. " tried to log in, but failed due to an unknown username and/or password.")
end
else
outputServerLog("Error: MySQL query failed (" .. getPlayerName(source) .. ").")
end
else
triggerClientEvent(source,"changeMessage",getRootElement(),"1","The Username you're trying to login with,Doesn't Exist", "red")
outputServerLog("Error: " .. getPlayerName(source) .. " tried to log in, but failed due to an unknown username and/or password.")
end
end
end