GTAONLINE.PL :: Wyświetlanie kasy przechowywanej w banku

function getPlayerBankMoney(player) local uid = getElementData(player, "player:sid") local result=exports["gl-db"]:dbGet("SELECT * from users where id=?", uid) if result and #result > 0 then return result[1].bank_money end return 0 end

Here you go!

function loadPlayerData(plr)
    local result=exports["gl-db"]:dbGet("SELECT * FROM gl_users WHERE id=?", getElementData(plr,"player:sid"))
    if result and #result > 0 then
        local v=result[1]
        setPlayerMoney(plr,v.money)
        setElementModel(plr,v.skin)
        setElementData(plr,"status","Aktywny")
        setElementData(plr,"player:logged",true)
        setElementData(plr,"player:mandate",v.mandate)
        setElementData(plr,"player:license:pjA",v.pjA)
        setElementData(plr,"player:license:pjB",v.pjB)
        setElementData(plr,"player:license:pjC",v.pjC)
        setElementData(plr,"player:license:pjL",v.pjL)
        setElementData(plr,"player:license:licS",v.licS)
        setElementData(plr,"player:srp",v.srp)
        setElementData(plr,"player:workinjob",v.worker)
        setElementData(plr,"player:registerdate",v.registered)
        setElementData(plr,"player:hours",v.hours)
        setElementData(plr,"player:skin",v.skin)
        setElementData(plr,"player:bank", v.bank_money)
        
        local queryA=string.format("SELECT * FROM gl_users WHERE id=%d AND premiumdate>NOW() LIMIT 1", getElementData(plr,"player:sid"))
        local resultA=exports["gl-DB2"]:pobierzWyniki(queryA)
        if (resultA) then
            setElementData(plr,"player:premium",true)
            setElementData(plr,"player:premiumdate",v.premiumdate)
            setPlayerName(plr,"#C0FF00"..getPlayerName(plr))
            setElementData(plr,"premium:level",1)
        else
            setElementData(plr,"player:premium",false)
        end
        
        local org=exports["gl-db"]:dbGet("SELECT * FROM ogrpg_organizations WHERE code=? AND uid=? LIMIT 1", getElementData(plr,"player:organization"), getElementData(plr,"player:sid")) -- pobieramy tylko JEDEN rekord
        local name = getPlayerName(plr):gsub("#%x%x%x%x%x%x","")
        if org and #org > 0 then
            setElementData(plr,"player:organization",org[1].code)
            outputChatBox("* Jeste? w organizacji, kt?ra nosi nazwe: "..org[1].code.."", plr)
            exports['gl-db']:dbSet("UPDATE ogrpg_organizations SET actived=curdate() WHERE uid=?", getElementData(plr,"player:sid"))
        end
        
        return true
    end
    return false
end

function stopzera( ... ) local money = convertNumber(getPlayerMoney(getLocalPlayer())) local player = getLocalPlayer() local bank = "W trakcie prac!"--.." PLN" local nick = getPlayerName(localPlayer) or "--" local id = getElementData(getLocalPlayer(), "id") or "0" local exp = getElementData(getLocalPlayer(), "player:srp") or 0 exports["bp_Blur"]:dxDrawBluredRectangle(screenW * 0.6849, screenH * 0.0074, screenW * 0.3099, screenH * 0.0870, tocolor(255, 255, 255, 255)) dxDrawRectangle(screenW * 0.6849, screenH * 0.0074, screenW * 0.3099, screenH * 0.0870, tocolor(255, 255, 255, 0), false) dxDrawImage(screenW * 0.5760, screenH * -0.0630, screenW * 0.4380, screenH * 0.7880, "files/images/alpha.png", 0, 0, 0, tocolor(255, 255, 255, 255), false) dxDrawText(money.." PLN", screenW * 0.7672, screenH * 0.0500, screenW * 0.8542, screenH * 0.0694, tocolor(255, 255, 255, 255), 1.00, dxfont1, "left", "center", false, false, false, false, false) dxDrawText(bank, screenW * 0.8938, screenH * 0.0500, screenW * 0.9807, screenH * 0.0694, tocolor(255, 255, 255, 255), 1.00, dxfont1, "left", "center", false, false, false, false, false) dxDrawText("RP: "..exp, screenW * 0.6849, screenH * 0.0731, screenW * 0.9948, screenH * 0.0944, tocolor(255, 255, 255, 255), 1.00, dxfont2, "center", "center", false, false, false, false, false) dxDrawText(getPlayerName(localPlayer):gsub("#%x%x%x%x%x%x",""), screenW * 0.7995, screenH * 0.0148, screenW * 0.9323, screenH * 0.0333, tocolor(255, 255, 255, 255), 1.00, dxfont4, "center", "center", false, false, false, false, false) local players = getElementsByType( "player" ) end