Jump to content

Trigger Table


3B00DG4MER

Recommended Posts

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 

Link to comment

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...