Lua I am not able to query the database

[MorganaSacani]

I have a problem with my script
Whenever I use the !shop command, the result of my Tibia Coins increases.
I don't understand. Maybe some problem getting the value from the database?
For example, when I use the !shop command, trim the value 15 the first time, if I use the command again, 17 appears, and so on.
The script is not returning me the actual value in the database.

local shop = TalkAction("!shop")

function shop.onSay(player, words, param)
    player:registerEvent("ModalShop")
    local getCoins = db.storeQuery("SELECT `coins` FROM `accounts` WHERE `id` = " .. player:getAccountId())
    
    local title = "Game Store"
    local message = "You have ".. getCoins .." Tibia Coins."
 
    local window = ModalWindow(1000, title, message)

    window:addButton(100, "Confirm")
    window:addButton(101, "Cancel")
 
    window:addChoice(1, "Premium Scroll - Price: ".. premiumScrollPrice ..".")
    window:addChoice(2, "Magic Gold Converter - Price: ".. magicGoldConverterPrice ..".")
 
    window:setDefaultEnterButton(100)
    window:setDefaultEscapeButton(101)
 
    window:sendToPlayer(player)
    return true
end

shop:register()

 

[Rombadr]

Check how this script gets the value from the DB

[SQL/Lua] Return storeQuery

TFS VERSION: 1.3 Hey guys, so this question is related to the previous two which I have posted and has to do with the function "storeQuery"... Check this out: function onLogin(player) local res = db.storeQuery("SELECT `blademaster` FROM `players` WHERE `name` = \"Angel\";") print(res)...

otland.net

 

[Dakos]

local shop = TalkAction("!shop")

function shop.onSay(player, words, param)
    player:registerEvent("ModalShop")
    
    local resultId = db.storeQuery("SELECT `coins` FROM `accounts` WHERE `id` = " .. player:getAccountId())
    if not resultId then
       result.free(resultId)
       return true
    end
    
    
    local getCoins = result.getNumber(resultId, "coins")
    result.free(resultId)
    
    local title = "Game Store"
    local message = "You have ".. getCoins .." Tibia Coins."
 
    local window = ModalWindow(1000, title, message)

    window:addButton(100, "Confirm")
    window:addButton(101, "Cancel")
 
    window:addChoice(1, "Premium Scroll - Price: ".. premiumScrollPrice ..".")
    window:addChoice(2, "Magic Gold Converter - Price: ".. magicGoldConverterPrice ..".")
 
    window:setDefaultEnterButton(100)
    window:setDefaultEscapeButton(101)
 
    window:sendToPlayer(player)
    return true
end

shop:register()