Saints Anathema
Old School Doleran
Ive searched all around Otland, so just wanted to clear it up before someone says use the search function
im using tfs 0.4 and Gesiors 0.3.6
a found a similar thread to someone having the same issue
but the discontinued the topic, because he just reinstalled to a previous distro.
Anyone have any suggestions
REP+ to positive posts
im using tfs 0.4 and Gesiors 0.3.6
a found a similar thread to someone having the same issue
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 erasefrom database...Code:6 Forum Tester login give_item 2160 2 item 1x cc 1
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
and here is scriptCode:[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
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.
but the discontinued the topic, because he just reinstalled to a previous distro.
Anyone have any suggestions
REP+ to positive posts