• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Problem with gesior shop system

phern

phern

alysiaots.com
Joined
Nov 2, 2008
Messages
195
Reaction score
2
Location
Poland
Hello.
I got problem with gesior's sms shop system, when I am buying anything, it should give me only one item, and it keeps giving me it all the time. Its spamming items to my backpack 'till I erase
Code: 
6	Forum Tester	login	give_item	2160	2	 	 	item	1x cc	 	1
from database...
This is console error:
It keeps spamming this message (i dont have space, becouse loads of items keeps spamming into my backpack, this message should appear every 30 sec, not every 1ms)
Code: 
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on the website couldnt be added. Han error has ocurred, please wait 30 seconds.. Shop ID: 9
16:40 >> The item 1x Amulet << that you just bought on

Code: 
[16:17:56.262] [Error - GlobalEvent Interface]
[16:17:56.262] data/globalevents/scripts/shop.lua:onThink
[16:17:56.262] Description:
[16:17:56.262] data/globalevents/scripts/shop.lua:56: attempt to call field 'exe                                                                                      cuteQuery' (a nil value)
[16:17:56.262] stack traceback:
[16:17:56.262]  data/globalevents/scripts/shop.lua:56: in function <data/globale                                                                                      vents/scripts/shop.lua:7>
[16:17:56.262] [Error - GlobalEvents::think] Couldn't execute event: shop
and here is script
Code: 
-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "global.lua")
SHOP_MSG_TYPE = 19
-- time (in seconds) between connections to SQL database by shop script
SQL_interval = 30
-- ### END OF CONFIG ###
function onThink(interval, lastExecution)
    local result_plr = db.getResult("SELECT * FROM z_ots_comunication WHERE `type` = 'login';")
    if(result_plr:getID() ~= -1) then
        while(true) do
            id = tonumber(result_plr:getDataInt("id"))
            action = tostring(result_plr:getDataString("action"))
            delete = tonumber(result_plr:getDataInt("delete_it"))
            cid = getCreatureByName(tostring(result_plr:getDataString("name")))
            if isPlayer(cid) == TRUE then
                local itemtogive_id = tonumber(result_plr:getDataInt("param1"))
                local itemtogive_count = tonumber(result_plr:getDataInt("param2"))
                local container_id = tonumber(result_plr:getDataInt("param3"))
                local container_count = tonumber(result_plr:getDataInt("param4"))
                local add_item_type = tostring(result_plr:getDataString("param5"))
                local add_item_name = tostring(result_plr:getDataString("param6"))
                local received_item = 0
                local full_weight = 0
                if add_item_type == 'container' then
                    container_weight = getItemWeightById(container_id, 1)
                    if isItemRune(itemtogive_id) == TRUE then
                        items_weight = container_count * getItemWeightById(itemtogive_id, 1)
                    else
                        items_weight = container_count * getItemWeightById(itemtogive_id, itemtogive_count)
                    end
                    full_weight = items_weight + container_weight
                else
                    full_weight = getItemWeightById(itemtogive_id, itemtogive_count)
                    if isItemRune(itemtogive_id) == TRUE then
                        full_weight = getItemWeightById(itemtogive_id, 1)
                    else
                        full_weight = getItemWeightById(itemtogive_id, itemtogive_count)
                    end
                end
                local free_cap = getPlayerFreeCap(cid)
                if full_weight <= free_cap then
                    if add_item_type == 'container' then
                        local new_container = doCreateItemEx(container_id, 1)
                        local iter = 0
                        while iter ~= container_count do
                            doAddContainerItem(new_container, itemtogive_id, itemtogive_count)
                            iter = iter + 1
                        end
                        received_item = doPlayerAddItemEx(cid, new_container)
                    else
                        local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
                        received_item = doPlayerAddItemEx(cid, new_item)
                    end
                    if received_item == RETURNVALUE_NOERROR then
                        doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'You received >> '.. add_item_name ..' << from OTS shop.')
                        db.executeQuery("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
                        db.executeQuery("UPDATE `z_shop_history_item` SET `trans_state`='realized', `trans_real`=" .. os.time() .. " WHERE id = " .. id .. ";")
                    else
                        doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. Please make place for this item in your backpack/hands and wait about '.. SQL_interval ..' seconds to get it.')
                    end
                else
                    doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. It weight is '.. full_weight ..' oz., you have only '.. free_cap ..' oz. free capacity. Put some items in depot and wait about '.. SQL_interval ..' seconds to get it.')
                end
            end
            if not(result_plr:next()) then
                break
            end
        end
        result_plr:free()
    end
    return TRUE
end

TFS 0.4, debian.
 
Sort by date Sort by votes
Lua: 
-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "global.lua")
SHOP_MSG_TYPE = 19
-- time (in seconds) between connections to SQL database by shop script
SQL_interval = 30
-- ### END OF CONFIG ###
function onThink(interval, lastExecution)
    local result_plr = db.getResult("SELECT * FROM z_ots_comunication WHERE `type` = 'login';")
    if(result_plr:getID() ~= -1) then
        while(true) do
            id = tonumber(result_plr:getDataInt("id"))
            action = tostring(result_plr:getDataString("action"))
            delete = tonumber(result_plr:getDataInt("delete_it"))
            cid = getCreatureByName(tostring(result_plr:getDataString("name")))
            if isPlayer(cid) == TRUE then
                local itemtogive_id = tonumber(result_plr:getDataInt("param1"))
                local itemtogive_count = tonumber(result_plr:getDataInt("param2"))
                local container_id = tonumber(result_plr:getDataInt("param3"))
                local container_count = tonumber(result_plr:getDataInt("param4"))
                local add_item_type = tostring(result_plr:getDataString("param5"))
                local add_item_name = tostring(result_plr:getDataString("param6"))
                local received_item = 0
                local full_weight = 0
                if add_item_type == 'container' then
                    container_weight = getItemWeightById(container_id, 1)
                    if isItemRune(itemtogive_id) == TRUE then
                        items_weight = container_count * getItemWeightById(itemtogive_id, 1)
                    else
                        items_weight = container_count * getItemWeightById(itemtogive_id, itemtogive_count)
                    end
                    full_weight = items_weight + container_weight
                else
                    full_weight = getItemWeightById(itemtogive_id, itemtogive_count)
                    if isItemRune(itemtogive_id) == TRUE then
                        full_weight = getItemWeightById(itemtogive_id, 1)
                    else
                        full_weight = getItemWeightById(itemtogive_id, itemtogive_count)
                    end
                end
                local free_cap = getPlayerFreeCap(cid)
                if full_weight <= free_cap then
                    if add_item_type == 'container' then
                        local new_container = doCreateItemEx(container_id, 1)
                        local iter = 0
                        while iter ~= container_count do
                            doAddContainerItem(new_container, itemtogive_id, itemtogive_count)
                            iter = iter + 1
                        end
                        received_item = doPlayerAddItemEx(cid, new_container)
                    else
                        local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
                        received_item = doPlayerAddItemEx(cid, new_item)
                    end
                    if received_item == RETURNVALUE_NOERROR then
                        doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'You received >> '.. add_item_name ..' << from YOUROT.')
                        db.executeQuery("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
                        db.executeQuery("UPDATE `z_shop_history_item` SET `trans_state`='realized', `trans_real`=" .. os.time() .. " WHERE id = " .. id .. ";")
                    else
                        doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. Please make place for this item in your backpack/hands and wait about '.. SQL_interval ..' seconds to get it.')
                    end
                else
                    doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. It weight is '.. full_weight ..' oz., you have only '.. free_cap ..' oz. free capacity. Put some items in depot and wait about '.. SQL_interval ..' seconds to get it.')
                end
            end
            if not(result_plr:next()) then
                break
            end
        end
        result_plr:free()
    end
    return TRUE
end
 
Upvote 0 Downvote
out of all the threads i found talking about this issue, this one showed most promise for a fix but you just switched to a older distro, dont think thats possible for my case.

Anyone figure it out yet, t keeps spamming a item i didnt even originally try to buy XD

Rep+ to helpful posts
 
Upvote 0 Downvote

Similar threads

G
  • Question
erro script shop
Replies
0
Views
284
Gaber Zen
G
Czorcik
  • Question
Gesior sms shop spaming items
Replies
1
Views
253
Czorcik
Czorcik
Back
Top