Getting Data From MySQL

[xXMADEXx]

Hello all, im making VIP system, and im not sure how to get the data from my SQL when the player logs in....

Here is my code:

addEventHandler("onPlayerJoin", root, 
    function () 
        dbQuery(loadPlayersVIP, dbConnection, "SELECT * FROM Freeroam_VIP_Players", source) 
    end 
) 
  
function loadPlayersVIP(hand,who) 
    sql = dbPoll(hand, 0) 
    for i,v in ipairs (sql) do 
        if (v["account"]==getAccountName(getPlayerAccount(who))) then 
            setElementData(who, "VIP", v["level"], true) 
        end 
    end 
end 

and here is an image of the MySQL

[Castillo]

Instead of looping every single row, just select the one that matches his account.

[xXMADEXx]

Instead of looping every single row, just select the one that matches his account.

lol, sorry, but im noob at MySQL, how do i find it?

[Castillo]

addEventHandler ( "onPlayerLogin", root, 
    function ( _, account ) 
        dbQuery ( loadPlayersVIP, { source }, dbConnection, "SELECT level FROM Freeroam_VIP_Players WHERE account = ? LIMIT 1", getAccountName ( account ) ) 
    end 
) 
  
function loadPlayersVIP ( query, who ) 
    local sql, numrows, errmsg = dbPoll ( query, 0 ) 
    if ( type ( sql ) == "table" and numrows > 0 ) then 
        setElementData ( who, "VIP", sql [ 1 ] [ "level" ] ) 
    end 
end 

[xXMADEXx]

addEventHandler ( "onPlayerLogin", root, 
    function ( _, account ) 
        dbQuery ( loadPlayersVIP, { source }, dbConnection, "SELECT level FROM Freeroam_VIP_Players WHERE account = ? LIMIT 1", getAccountName ( account ) ) 
    end 
) 
  
function loadPlayersVIP ( query, who ) 
    local sql, numrows, errmsg = dbPoll ( query, 0 ) 
    if ( type ( sql ) == "table" and numrows > 0 ) then 
        setElementData ( who, "VIP", sql [ 1 ] [ "level" ] ) 
    end 
end 

Didn't work...

[Castillo]

That's weird, it should work.

[xXMADEXx]

fixed.

[Castillo]

You're welcome.