Preciso de Ajuda com shop do Gesior

[lokkitto 4]

Seguinte, instalei um site no styller dai foi tudo bem está funcionando corretamente só que quando fui comprar um item no shop, ele fica enviando aquele item sem parar até cap acabar e quando surge mais cap ele manda mais e fica dando tal erro no console olhe

 

 

 

preciso mt de ajuda =\

[luanluciano93 1994]

Qual script tu ta usando? Poste aqui.

[lokkitto 4]

amigo esté e o script lua do shop que estou usando

-- ### 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.Query("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")

                        db.Query("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

[luanluciano93 1994]

qual a versão do tfs usado no seu servidor?

[lokkitto 4]

amigo estou usando um styller yurots esse http://www.tibiaking.com/forum/topic/24283-original-styller-yourots-edited-premium-site-860-war-system/

 

não sei bem lhe informar qual é a versão pois sou meio que novo nestas versões de ot.

 

 

@edit aqui, Venho a lembrar que não tenho o arquivo Global.lua será que isto influencia em algo? pois vi falando sobre ele dentro do script shop.lua.

Editado Outubro 20, 2014 por lokkitto (veja o histórico de edições)

[luanluciano93 1994]

É porque aquele script é do tfs 1.0, use este: 

- ### CONFIG ###
-- message send to player by script "type" (types you can check in "data/lib/000-constants.lua")
SHOP_MSG_TYPE = MESSAGE_STATUS_CONSOLE_BLUE
-- time (in seconds) between queries to MySQL 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)
						doItemSetAttribute(new_container, "description", 'Bought by ' .. getCreatureName(cid) .. ' [ID:' .. id .. '].')
						doItemSetAttribute(new_container, "tid", id)
                        local iter = 0
                        while iter ~= container_count do
							local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
							doItemSetAttribute(new_item, "description", 'Bought by ' .. getCreatureName(cid) .. ' [ID:' .. id .. '].')
							doItemSetAttribute(new_item, "tid", id)
							doAddContainerItemEx(new_container, new_item)
                            iter = iter + 1
                        end
                        received_item = doPlayerAddItemEx(cid, new_container)
                    else
                        local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
						doItemSetAttribute(new_item, "description", 'Bought by ' .. getCreatureName(cid) .. ' [ID:' .. id .. '].')
						doItemSetAttribute(new_item, "tid", id)
                        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.')
						doPlayerSave(cid)
                        db.query("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
                        db.query("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

[lokkitto 4]

parou de dar o erro porem o item nao é entrege, e da este outro




E DA ESTE OUTRO ERRO NO COMEÇO

amigo parabéns seu script funcionou está resolvido. era só tirar essa coisa do shop.lua (        - ### CONFIG ###           )

retirei isso salvei ai passou a funcionar

Editado Outubro 21, 2014 por lokkitto (veja o histórico de edições)

[lokkitto 4]

pode fechar o topico

[luanluciano93 1994]

Diga como resolveu, alguem pode estar com a mesma dúvida ...

[lokkitto 4]

amigo eu falei ali em cima é pq ficou meio ruim de ver mas é so fazer isso.

 

 

USE O CHAT DO FACEBOOK PARA UPLOAD DE FOTOS É MELHOR