How to put multiples values from database in one variable?

[VictorOtInfinit]

I need to get all Tibia Coins that we have in the server and save in one variable, how i do that?

I tryed:

local allCoins = db.storeQuery("SELECT `coins` FROM `accounts` LIMIT 0;")
doPlayerPopupFYI(cid, "total coins: ".. allCoins.."")

Got this error:



Also tryed:

function onSay(cid, words, param)
    local allCoins = db.storeQuery("SELECT `coins` FROM `accounts` LIMIT 9999;")
    local list = {}
    if allCoins:getID() == -1 then
        return true
    end
    repeat
        local coins = allCoins:getDataString("coins")
        table.insert(list, coins)
    until not allCoins:next()
    doPlayerPopupFYI(cid, "total coins: ".. table.concat(list,"\n") .."")
end

Got this error. Why god is so hard to get a simple data information from database in lua?

 

[zbizu]

SELECT SUM(`coins`) FROM `accounts`;

hints:

MySQL SUM Function

This tutorial shows you how to use the MySQL SUM function to calculate the sum of a set of values or an expression.

www.mysqltutorial.org

 

[VictorOtInfinit]

SELECT SUM(`coins`) FROM `accounts`;

hints:

MySQL SUM Function

This tutorial shows you how to use the MySQL SUM function to calculate the sum of a set of values or an expression.

www.mysqltutorial.org

local allCoins = db.storeQuery("SELECT SUM(coins) FROM accounts LIMIT 0;") , still same boolean error
local allCoins = db.storeQuery("SELECT SUM(coins) FROM accounts;") , returns a number that increase with usage(?) like image below.

Post automatically merged: Dec 8, 2020

Solved using this code:

function onSay(cid, words, param)
    if getPlayerGroupId(cid) ~= 6 then
        return true
    end
    local sumCoins = 0
    local allCoins = db.storeQuery("SELECT `coins` FROM `accounts`")
    if allCoins ~= false then
        repeat
            local task1 = result.getString(allCoins, 'coins')
            sumCoins = tonumber(task1)+sumCoins
        until not result.next(allCoins)  
        result.free(allCoins)
    end
    doPlayerPopupFYI(cid, "Total Coins: ".. sumCoins.. "")
return true
end

 

[oen432]

Faster.

function onSay(cid, words, param)
    if getPlayerGroupId(cid) ~= 6 then
        return true
    end
    local sumCoins = 0
    local allCoins = db.storeQuery("SELECT SUM(`coins`) AS `coins` FROM `accounts`")
    if allCoins ~= false then
        sumCoins = result.getNumber(allCoins, 'coins')
        result.free(allCoins)
    end
    doPlayerPopupFYI(cid, "Total Coins: ".. sumCoins.. "")
    return true
end

 

[VictorOtInfinit]

Faster.

function onSay(cid, words, param)
    if getPlayerGroupId(cid) ~= 6 then
        return true
    end
    local sumCoins = 0
    local allCoins = db.storeQuery("SELECT SUM(`coins`) AS `coins` FROM `accounts`")
    if allCoins ~= false then
        sumCoins = result.getNumber(allCoins, 'coins')
        result.free(allCoins)
    end
    doPlayerPopupFYI(cid, "Total Coins: ".. sumCoins.. "")
    return true
end

better, ty