SQL if exist

[Jimmy.]

I check or row is exist, but always got " Wrong username" even username is in database. Where can be a mistake?

function loginHandler(username,password) 
    local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=?", username) 
    local result = dbPoll( query, -1 ) 
    if result == true then 
        local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=? AND password=?",username,password) 
        local result = dbPoll( query, -1 ) 
        if result then 
            if (client) then 
                spawnPlayer(client, 1959.55, -1714.46, 10) 
                fadeCamera(client, true) 
                setCameraTarget(client, client) 
                outputDebugString("Welcome to My Server.") 
            end 
        else 
            outputDebugString("Wrong password.") 
        end 
    else 
        outputDebugString("Wrong username.") 
    end 
end 
addEvent("SubmitLogin",true) 
addEventHandler("SubmitLogin",root,loginHandler) 
  

[GTX]

dbPoll doesn't return boolean value.

function loginHandler(username,password) 
    local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=?", username) 
    local result = dbPoll( query, -1 ) 
    if result then 
        local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=? AND password=?",username,password) 
        local result = dbPoll( query, -1 ) 
        if result then 
            if (client) then 
                spawnPlayer(client, 1959.55, -1714.46, 10) 
                fadeCamera(client, true) 
                setCameraTarget(client, client) 
                outputDebugString("Welcome to My Server.") 
            end 
        else 
            outputDebugString("Wrong password.") 
        end 
    else 
        outputDebugString("Wrong username.") 
    end 
end 
addEvent("SubmitLogin",true) 
addEventHandler("SubmitLogin",root,loginHandler) 

[Jimmy.]

dbPoll doesn't return boolean value.

function loginHandler(username,password) 
    local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=?", username) 
    local result = dbPoll( query, -1 ) 
    if result then 
        local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=? AND password=?",username,password) 
        local result = dbPoll( query, -1 ) 
        if result then 
            if (client) then 
                spawnPlayer(client, 1959.55, -1714.46, 10) 
                fadeCamera(client, true) 
                setCameraTarget(client, client) 
                outputDebugString("Welcome to My Server.") 
            end 
        else 
            outputDebugString("Wrong password.") 
        end 
    else 
        outputDebugString("Wrong username.") 
    end 
end 
addEvent("SubmitLogin",true) 
addEventHandler("SubmitLogin",root,loginHandler) 

But now always show: "Welcome to My Server." Or wrong username or no.

[GTX]

Oh, use this:

function loginHandler(username,password) 
    local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=?", username) 
    local result = dbPoll( query, -1 ) 
    if #result == 1 then 
        local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=? AND password=?",username,password) 
        local result = dbPoll( query, -1 ) 
        if #result == 1 then 
            if (client) then 
                spawnPlayer(client, 1959.55, -1714.46, 10) 
                fadeCamera(client, true) 
                setCameraTarget(client, client) 
                outputDebugString("Welcome to My Server.") 
            end 
        else 
            outputDebugString("Wrong password.") 
        end 
    else 
        outputDebugString("Wrong username.") 
    end 
end 
addEvent("SubmitLogin",true) 
addEventHandler("SubmitLogin",root,loginHandler) 

[Jimmy.]

Again always "Wrong username".

[GTX]

Then you're entering wrong username. Debug the code like:

function loginHandler(username,password) 
    local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=?", username) 
    local result = dbPoll( query, -1 ) 
    outputChatBox(#result) 
    if #result == 1 then 
        local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=? AND password=?",username,password) 
        local result = dbPoll( query, -1 ) 
        if #result == 1 then 
            if (client) then 
                spawnPlayer(client, 1959.55, -1714.46, 10) 
                fadeCamera(client, true) 
                setCameraTarget(client, client) 
                outputDebugString("Welcome to My Server.") 
            end 
        else 
            outputDebugString("Wrong password.") 
        end 
    else 
        outputDebugString("Wrong username.") 
    end 
end 
addEvent("SubmitLogin",true) 
addEventHandler("SubmitLogin",root,loginHandler) 

Also, don't forget to use dbFree.

[Jimmy.]

outputChatBox shows "0"

[GTX]

It's wrong username. What username did you enter exactly?

[Jimmy.]

It's wrong username. What username did you enter exactly?

The same "0". Maybe something can be wrong with clientside?

[GTX]

Maybe. Output username and then compare to the row in the table.

function loginHandler(username,password) 
    local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=?", username) 
    outputChatBox(username) 
    local result = dbPoll( query, -1 ) 
    outputChatBox(#result) 
    if #result == 1 then 
        local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=? AND password=?",username,password) 
        local result = dbPoll( query, -1 ) 
        if #result == 1 then 
            if (client) then 
                spawnPlayer(client, 1959.55, -1714.46, 10) 
                fadeCamera(client, true) 
                setCameraTarget(client, client) 
                outputDebugString("Welcome to My Server.") 
            end 
        else 
            outputDebugString("Wrong password.") 
        end 
    else 
        outputDebugString("Wrong username.") 
    end 
end 
addEvent("SubmitLogin",true) 
addEventHandler("SubmitLogin",root,loginHandler) 

[Jimmy.]

Maybe. Output username and then compare to the row in the table.

function loginHandler(username,password) 
    local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=?", username) 
    outputChatBox(username) 
    local result = dbPoll( query, -1 ) 
    outputChatBox(#result) 
    if #result == 1 then 
        local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=? AND password=?",username,password) 
        local result = dbPoll( query, -1 ) 
        if #result == 1 then 
            if (client) then 
                spawnPlayer(client, 1959.55, -1714.46, 10) 
                fadeCamera(client, true) 
                setCameraTarget(client, client) 
                outputDebugString("Welcome to My Server.") 
            end 
        else 
            outputDebugString("Wrong password.") 
        end 
    else 
        outputDebugString("Wrong username.") 
    end 
end 
addEvent("SubmitLogin",true) 
addEventHandler("SubmitLogin",root,loginHandler) 

outputChatBox(username) here it is okay, what i wrote, output show the same.

I send PM my all clientside file.

[GTX]

There is no problem in client-sided file.

Try:

function loginHandler(username,password) 
    local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=`??`", username) 
    local result = dbPoll( query, -1 ) 
    outputChatBox(#result) 
    if #result == 1 then 
        local query = dbQuery(handler,"SELECT * FROM accounts WHERE username=`??` AND password=`??`",username,password) 
        local result = dbPoll( query, -1 ) 
        if #result == 1 then 
            if (client) then 
                spawnPlayer(client, 1959.55, -1714.46, 10) 
                fadeCamera(client, true) 
                setCameraTarget(client, client) 
                outputDebugString("Welcome to My Server.") 
            end 
        else 
            outputDebugString("Wrong password.") 
        end 
    else 
        outputDebugString("Wrong username.") 
    end 
end 
addEvent("SubmitLogin",true) 
addEventHandler("SubmitLogin",root,loginHandler) 

[Jimmy.]

[Jimmy.]

PROBLEM SOLVED.