[Znote] !shop error for tfs 1.0

xx Kami xx · Apr 30, 2015

Hello and im trying to use !shop for znote account, when i do !shop i get this error

This is my script

Code:

-- Znote Shop v1.0 for Znote AAC on TFS 0.2.13+ Mystic Spirit.
function onSay(cid, words, param)
    local storage = 39672 -- Make sure to select non-used storage. This is used to prevent SQL load attacks.
    local cooldown = 15 -- in seconds.

    if getPlayerStorageValue(cid, storage) <= os.time() then
        setPlayerStorageValue(cid, storage, os.time() + cooldown)
        local accid = getAccountNumberByPlayerName(getCreatureName(cid))
  
        -- Create the query
        local orderQuery = db.storeQuery("SELECT `id`, `itemid`, `count` FROM `znote_shop_orders` WHERE `account_id` = " .. accid .. " AND `type` = 1 LIMIT 1;")
  
        -- Detect if we got any results
        if orderQuery ~= false then
            -- Fetch order values
            local q_id = result.getDataInt(orderQuery, "id")
            local q_itemid = result.getDataInt(orderQuery, "itemid")
            local q_count = result.getDataInt(orderQuery, "count")
            result.free(orderQuery)

            local playerCap = getPlayerFreeCap(cid)
            local itemweight = getItemWeight(q_itemid, q_count)
                if playerCap >= itemweight then
                    db.query("DELETE FROM `znote_shop_orders` WHERE `id` = " .. q_id .. ";")
                    doPlayerAddItem(cid, q_itemid, q_count)
                    doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Congratulations! You have recieved ".. q_count .." "..getItemName(q_itemid).."(s)!")
                else
                    doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, "Need more CAP!")
                end
        else
            doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, "You have no orders.")
        end
  
    else
        doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Can only be executed once every "..cooldown.." seconds. Remaining cooldown: ".. getPlayerStorageValue(cid, storage) - os.time())
    end
    return false
end

WibbenZ · May 1, 2015

Don't center the text <,<
Also don't bump a thread if you have already created a thread.
Tag me when you have removed the centering of the text.

xx Kami xx · May 1, 2015

WibbenZ said:
Don't center the text <,<
Also don't bump a thread if you have already created a thread.
Tag me when you have removed the centering of the text.

ok i un-centered it, now what?

WibbenZ · May 1, 2015

Code:

-- Znote Shop v1.0 for Znote AAC on TFS 0.2.13+ Mystic Spirit.
function onSay(cid, words, param)
    local storage = 39672 -- Make sure to select non-used storage. This is used to prevent SQL load attacks.
    local cooldown = 15 -- in seconds.

    if getPlayerStorageValue(cid, storage) <= os.time() then
        setPlayerStorageValue(cid, storage, os.time() + cooldown)
        local accid = getAccountNumberByPlayerName(getCreatureName(cid))
        -- Create the query
        local orderQuery = db.storeQuery("SELECT `id`, `itemid`, `count` FROM `znote_shop_orders` WHERE `account_id` = " .. accid .. " AND `type` = 1 LIMIT 1;")
        -- Detect if we got any results
        if orderQuery ~= false then
            -- Fetch order values
            local q_id = result.getNumber(orderQuery, "id")
            local q_itemid = result.getNumber(orderQuery, "itemid")
            local q_count = result.getNumber(orderQuery, "count")
            result.free(orderQuery)

            local playerCap = getPlayerFreeCap(cid)
            local itemweight = getItemWeight(q_itemid, q_count)
                if playerCap >= itemweight then
                    db.query("DELETE FROM `znote_shop_orders` WHERE `id` = " .. q_id .. ";")
                    doPlayerAddItem(cid, q_itemid, q_count)
                    doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Congratulations! You have recieved ".. q_count .." "..getItemName(q_itemid).."(s)!")
                else
                    doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, "Need more CAP!")
                end
        else
            doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, "You have no orders.")
        end
    else
        doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Can only be executed once every "..cooldown.." seconds. Remaining cooldown: ".. getPlayerStorageValue(cid, storage) - os.time())
    end
    return false
end

xx Kami xx · May 1, 2015

WibbenZ said:

Code:

-- Znote Shop v1.0 for Znote AAC on TFS 0.2.13+ Mystic Spirit.
function onSay(cid, words, param)
    local storage = 39672 -- Make sure to select non-used storage. This is used to prevent SQL load attacks.
    local cooldown = 15 -- in seconds.

    if getPlayerStorageValue(cid, storage) <= os.time() then
        setPlayerStorageValue(cid, storage, os.time() + cooldown)
        local accid = getAccountNumberByPlayerName(getCreatureName(cid))
        -- Create the query
        local orderQuery = db.storeQuery("SELECT `id`, `itemid`, `count` FROM `znote_shop_orders` WHERE `account_id` = " .. accid .. " AND `type` = 1 LIMIT 1;")
        -- Detect if we got any results
        if orderQuery ~= false then
            -- Fetch order values
            local q_id = result.getNumber(orderQuery, "id")
            local q_itemid = result.getNumber(orderQuery, "itemid")
            local q_count = result.getNumber(orderQuery, "count")
            result.free(orderQuery)

            local playerCap = getPlayerFreeCap(cid)
            local itemweight = getItemWeight(q_itemid, q_count)
                if playerCap >= itemweight then
                    db.query("DELETE FROM `znote_shop_orders` WHERE `id` = " .. q_id .. ";")
                    doPlayerAddItem(cid, q_itemid, q_count)
                    doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Congratulations! You have recieved ".. q_count .." "..getItemName(q_itemid).."(s)!")
                else
                    doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, "Need more CAP!")
                end
        else
            doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, "You have no orders.")
        end
    else
        doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Can only be executed once every "..cooldown.." seconds. Remaining cooldown: ".. getPlayerStorageValue(cid, storage) - os.time())
    end
    return false
end

same problem it says [C]: in function 'getNumber'

WibbenZ · May 1, 2015

Take another screen in that case, it isen't the same error you posted above.
As you can see here: https://github.com/otland/forgottenserver/blob/master/data/lib/compat/compat.lua#L4
The function was renamed.

xx Kami xx · May 1, 2015

WibbenZ said:
Take another screen in that case, it isen't the same error you posted above.
As you can see here: https://github.com/otland/forgottenserver/blob/master/data/lib/compat/compat.lua#L4
The function was renamed.

tried this and got like 1000 errors. ill just wait till halfaway has time to help me in teamviewer :\

imback1 · May 1, 2015

@xx Kami xx
Don't be so rude LoL!! @WibbenZ was trying to help you and now you are answering with **ill just wait till halfaway has time to help me in teamviewer :\** lol! really suck.

xx Kami xx · May 2, 2015

imback1 said:
@xx Kami xx
Don't be so rude LoL!! @WibbenZ was trying to help you and now you are answering with **ill just wait till halfaway has time to help me in teamviewer :\** lol! really suck.

not trying to be rude, its just my server is already online and i have players asking me to fix it so they can get there items, i think its kinda sad nowadays to get something fixed you have to pay for it, there is no such thing as "support" anymore :\

WibbenZ · May 2, 2015

There actually is, if this was a paid job I would not ask you to test it..
The error you wrote about is not the same as above, that is why I asked you to take another ss of it.
I hope you know more then to just add the compat.lua file into your talkactions file.

Once again, show me the error.
Depending on your server version that should be the fix, since they got renamed from getDataInt to getNumber.

Tarek · May 2, 2015

WibbenZ said:
There actually is, if this was a paid job I would not ask you to test it..
The error you wrote about is not the same as above, that is why I asked you to take another ss of it.
I hope you know more then to just add the compat.lua file into your talkactions file.

Once again, show me the error.
Depending on your server version that should be the fix, since they got renamed from getDataInt to getNumber.

Lol, I got getDataInt error on TFS 1.1 but Halfaway fixed it for me

, but the sad thing is i moved every file to my friend hosting the server. :/, So maybe tomorow morning i can post it see if it works.

imback1 · May 2, 2015

xx Kami xx said:
not trying to be rude, its just my server is already online and i have players asking me to fix it so they can get there items, i think its kinda sad nowadays to get something fixed you have to pay for it, there is no such thing as "support" anymore :\

And i think @WibbenZ didn't give up and told you to show him ss about another error to help you, i think in all this time he might make it work for you.

xx Kami xx · May 2, 2015

i gave up on fixing the problem, just gonna go to gesior since its the only way to fix it.

this thread can be closed.

Znote · May 4, 2015

https://github.com/Znote/ZnoteAAC/issues/200

xx Kami xx · May 4, 2015

Znote said:
https://github.com/Znote/ZnoteAAC/issues/200

none for 1.0? :\

Evil Puncker · May 4, 2015

everyone should use 1.2 by now

[Znote] !shop error for tfs 1.0

xx Kami xx

Retired.

WibbenZ

Global Moderator

xx Kami xx

Retired.

WibbenZ

Global Moderator

xx Kami xx

Retired.

WibbenZ

Global Moderator

xx Kami xx

Retired.

imback1

Unknown member

xx Kami xx

Retired.

WibbenZ

Global Moderator

Tarek

Premium User

imback1

Unknown member

xx Kami xx

Retired.

Znote

<?php echo $title; ?>

xx Kami xx

Retired.

Evil Puncker

Guest

Similar threads