Mysql Query

[Crosshair]

I got a marker and:

function biroutranzactii(element) 
    if getElementType(element) == "player" and (element == localPlayer) then 
        build_Banca() 
        guiSetText( sold, "Sold: "..getElementData( localPlayer, "cash") ) 
        showCursor(true) 
    end 
end 
addEventHandler("onClientMarkerHit", marker2, biroutranzactii) 

in server file i got

function banca() 
    for _,v in ipairs(getElementsByType("player")) do 
        local banca = mysql_query(handler, "SELECT * FROM accounts WHERE username = 'Crosshair';") 
        if (banca) then 
            local bancarow = mysql_fetch_assoc(banca) 
            local bank = bancarow.bank 
            setElementData( v, "cash", bank) 
        end 
        mysql_free_result(banca) 
    end 
end 
setTimer(banca, 1000,0) 

on mysql_query function i want to change "Crosshair" with getPlayerName(source) but i don`t know how to define source. I get the error Bed argument data.

if i put function banca(source) still nothing. How can i define it ?

[Castillo]

I really don't recommend using a 1 second timer to loop all players and do a MySQL query.

[Crosshair]

Do you have any suggestion instead ?

[Castillo]

You can do the following:

On login: Set the element data of his "banca" and when you update it.

On logout/quit: Get that element data and update the MySQL table.

[Crosshair]

like this ?

function banca() 
        local banca = mysql_query(handler, "SELECT * FROM accounts WHERE username = '"..getPlayerName(source).."';") 
        if (banca) then 
            local bancarow = mysql_fetch_assoc(banca) 
            local bank = bancarow.bank 
            setElementData(source, "cash", bank) 
        end 
    mysql_free_result(banca) 
end 
addEventHandler ( "onPlayerJoin", getRootElement(), banca) 

and when i exit the marker to trrigger an event that runs the function again ?

[Castillo]

Yeah, and now when you enter the marker, it'll get that element data.

Now instead of updating the table when you want to change the "bank", you update the element data of the player and when logout/quit, you get that element data and then update the MySQL.

[Crosshair]

you update the element data of the player

Is there a function that does that or how do i do it?

[Castillo]

I meant when you want to change the "bank" value, you change the element data instead of the MySQL row.