3B00DG4MER Posted December 19, 2014 Posted December 19, 2014 Hi Guys, i need help with triggering Event with a table from Server to Client ! i need really help !!
3B00DG4MER Posted December 19, 2014 Author Posted December 19, 2014 Show your code please 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
3B00DG4MER Posted December 19, 2014 Author Posted December 19, 2014 What's the problem? Plz before trying to help read my request i need help with triggering Event with a table from Server to Client !
Anubhav Posted December 19, 2014 Posted December 19, 2014 What's getting wrong in it? You're doing it correct
3B00DG4MER Posted December 19, 2014 Author Posted December 19, 2014 What's getting wrong in it? You're doing it correct i need help with triggering Event with a table from Server to Client ! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now