• 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!

Solved Item Shop Problem

Daniel Kopeć

Member
Joined
Dec 8, 2018
Messages
125
Solutions
4
Reaction score
12
Location
Poland
When i order item after doing that it says

00:38 >> Outfit Doll << from OTS shop is waiting for you. Please make place for this item in your backpack/hands and wait about 30 seconds to get it.

and i have a open empty bp, can someone help me please?

TFS vesrion 0.4
No errors in console.

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 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


is problem.pngis baza.pngis baza 2.png
 
Last edited:
You need to provide enough information in order to increase your chances of getting a response.

1. TFS version? ( 0.3.6, 0.4, 1.0, 1.1 etc.. )
2. Which script are you using?
3. errors in console?
 
You need to provide enough information in order to increase your chances of getting a response.

1. TFS version? ( 0.3.6, 0.4, 1.0, 1.1 etc.. )
2. Which script are you using?
3. errors in console?

Ok I edited the post and added any information.

very sorry i'm new here
 
This LUA script delivers only 'item' or 'container'. It cannot deliver 'outfit', so it tries to add item with ID as outfit ID (probably) and it's impossible.

I cannot view screenshots. I see their names, but when I click 'open in new tab', it says I have no permission. Did you copy it from some private forum conversation or is Otland bugged?
 
This LUA script delivers only 'item' or 'container'. It cannot deliver 'outfit', so it tries to add item with ID as outfit ID (probably) and it's impossible.

I cannot view screenshots. I see their names, but when I click 'open in new tab', it says I have no permission. Did you copy it from some private forum conversation or is Otland bugged?

So what shop.lua script should I add?
Post automatically merged:

This LUA script delivers only 'item' or 'container'. It cannot deliver 'outfit', so it tries to add item with ID as outfit ID (probably) and it's impossible.

I cannot view screenshots. I see their names, but when I click 'open in new tab', it says I have no permission. Did you copy it from some private forum conversation or is Otland bugged?
Yes, I copied these screenshots from another post.
I'm throwing them in here again

is problem.pngis baza.pngis baza 2.png
 
Last edited:
Last edited:
Back
Top