dbQuery

[ednatmp]

Hey guys , well, I 'm scripting a database to store passwords , money, among other things, and I get error " espected near ' =' " and not to do , probe thousand things and nothing, any help?

Sorry for my bad English , I'm Spanish .

Image: http://imgur.com/GWZVaA6

My code, copy and paste so full error numbers match .

local dataconnection = exports.CCS_db:getPlayersDatabase() 
  
function clientWantToCheckHisState() 
    triggerClientEvent(source, "onServerWantIniteteLoginPanel", getRootElement(), colorCode) 
end 
addEvent("onClientWantCheckHisState", true) 
addEventHandler("onClientWantCheckHisState", getRootElement(), clientWantToCheckHisState) 
  
function onRequestRegister(usernameregister, passwordregister) 
    regusername = string.lower(usernameregister) 
    reguserplayernickname = getPlayerName(source) 
    if (selectqq = dbQuery(dataconnection, "SELECT * FROM dbPlayersData WHERE username=? LIMIT 1", regusername)) then 
        displayServerMessage(source, "El nombre de usuario elegido ya existe!", "warning") 
        dbFree(selectqq) 
    else 
        if (dbExec(dataconnection, "INSERT INTO dbPlayersData (username, password, name, isonline, dms, wins, loses, cash, points, kills, deaths, level, rank, gametime, carcolor) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", regusername, passwordregister, reguserplayernickname, "false", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "none")) 
            displayServerMessage(source, "Éxito al crear  la nueva cuenta. Ahora Inicia sesión!") 
            triggerClientEvent(source, "onClientSuccessfullyRegisterNewAccount", getRootElement()) 
        end 
    end  
end 
addEventHandler("onRequestRegister", getRootElement(), onRequestRegister) 
addEvent("onRequestRegister", true) 
  
function onRequestLogin(usernamelogin, passwordlogin) 
    logusername = string.lower(usernamelogin) 
    if (selectq = dbQuery(dataconnection, "SELECT * FROM dbPlayersData WHERE username=? LIMIT 1", logusername)) then 
        dbFree(selectq) 
        local accountData = dbQuery(dataconnection, "SELECT isonline FROM dbPlayersData WHERE username=? AND password=?",logusername, passwordlogin) 
        if (accountData == "false") then 
            displayServerMessage(source, "Has iniciado sesión correctamente.", "warning") 
            setElementData(source, "gametime", getTickCount()) 
            triggerClientEvent(source, "onClientIsLoggedIn", getRootElement()) 
            triggerClientEvent(source, "onClientSuccessfullyLogIn", getRootElement()) 
            dbQuery(dataconnection, "UPDATE dbPlayersData SET isonline=? WHERE username=? AND password=?", "true", logusername, passwordlogin) 
            dbFree(accountData) 
        else 
            displayServerMessage(source, "Nombre de usuario o contraseña incorrecta!", "warning") 
        end 
    else 
        displayServerMessage(source, "Nombre de usuario o contraseña incorrecta!", "warning") 
    end 
end 
addEventHandler("onRequestLogin", getRootElement(), onRequestLogin) 
addEvent("onRequestLogin", true) 
  
function displayServerMessage(thePlayer, message, type) 
    triggerClientEvent(thePlayer, "createNotification", getRootElement(), message, type) 
end 

[G-Stefan]

Try to replace

if (selectqq = dbQuery(dataconnection, "SELECT * FROM dbPlayersData WHERE username=? LIMIT 1", regusername)) then 

with

selectqq = dbQuery(dataconnection,...) 
result = dbPoll(selectqq,-1) 
if result then ... 

Edit:You always must get the result of dbQuery using dbPoll

[ednatmp]

I thinks is working right now, thank you very much dude!

[G-Stefan]

I thinks is working right now, thank you very much dude!

my pleasure