GLOBALEVENTS SHOP.LUA TFS 1.0

[sxeinjected 31]

Bom galera,quero ver se alguem me ajuda,estou usando o 

 

http://www.tibiaking.com/forum/topic/36403-global-full-10371051-e-1053-tfs-10-completo-atualiza%C3%A7%C3%A3o-v4/

,a database que está no topico tmb.

 

 

Porém ,os itens do shopping,não para de chegar no char,verifiquei no phpmyadmin ,na tabela,z_ots_comunication,o registro do

item fica lá,pelo que vi no shop.lua,tem uma função que após ele receber o item,ele apaga do z_ots_comunication.mas não está

apagando e também no z_shop_history_item,ele continua no modo "wait",como se n tivesse recebido o item.

 

Ajuda!! Urgente

 

•  

 

•  
•  
•  
•  

 

[buddha 47]

Poste o script do shop e fale a versão do seu TFS/OT

[sxeinjected 31]

 

-- ### CONFIG ###

-- message send to player by script "type" (types you can check in "global.lua")

SHOP_MSG_TYPE = 18

-- 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.storeQuery("SELECT * FROM z_ots_comunication")

  if(result_plr ~= false) then

  repeat

  local id = tonumber(result.getDataInt(result_plr, "id"))

  local action = tostring(result.getDataString(result_plr, "action"))

  local delete = tonumber(result.getDataInt(result_plr, "delete_it"))

  local cid = getPlayerByName(tostring(result.getDataString(result_plr, "name")))

  if(cid) then

  local itemtogive_id = tonumber(result.getDataInt(result_plr, "param1"))

  local itemtogive_count = tonumber(result.getDataInt(result_plr, "param2"))

  local container_id = tonumber(result.getDataInt(result_plr, "param3"))

  local container_count = tonumber(result.getDataInt(result_plr, "param4"))

  local add_item_type = tostring(result.getDataString(result_plr, "param5"))

  local add_item_name = tostring(result.getDataString(result_plr, "param6"))

  local received_item = 0

  local full_weight = 0

  if(add_item_type == 'container') then

  container_weight = getItemWeight(container_id, 1)

  if(isItemRune(itemtogive_id)) then

  items_weight = container_count * getItemWeight(itemtogive_id, 1)

  else

  items_weight = container_count * getItemWeight(itemtogive_id, itemtogive_count)

  end

  full_weight = items_weight + container_weight

  else

  full_weight = getItemWeight(itemtogive_id, itemtogive_count)

  if(isItemRune(itemtogive_id)) then

  full_weight = getItemWeight(itemtogive_id, 1)

  else

  full_weight = getItemWeight(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(type(received_item) == "number" and 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

  until not result.next(result_plr)

  result.free(result_plr)

  end

  return true

end

Uso tfs 1.0 (10.53) pelo que fiquei sabendo,tem que mudar algumas funções pq na versão 10.53 mudou,agora só não sei quais =/

[buddha 47]

Parece perfeitamente correto. Algum erro no distro?

[sxeinjected 31]

Pois é.. nenhum erro no distro.

 

somente fica enviando itens sem parar para o char.

 

o que deve ter algo de errado é na parte

 

 

  if(type(received_item) == "number" and 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

onde se o player recebeu o item,ele se comunica com a tabela z_ots_comunication,e deleta o registro de envio do item dela,que é o que faz parar de enviar o item pro char.

 

Tá complicado rs.

[Liane 32]

amigo esse erro ai é porque a database que você esta usando nao é compativel com a versao 10.53, temos que atualizar algums Bites Codigos e fontes... Se  minha resposta foi O Suficiente para sua duvida da um Rep++ ai Vlw.

[sxeinjected 31]

Tem previsão para que saia,a nova database então ?,to precisando muito....

 

Após todas duvidas sanadas,irei dar rep++

[sxeinjected 31]

Corrigido.

 

 

-- ### CONFIG ###

-- 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.storeQuery('SELECT * FROM z_ots_comunication')

        if result_plr ~= false then

                repeat

                        local id = tonumber(result.getDataInt(result_plr, 'id'))

                        local action = tostring(result.getDataString(result_plr, 'action'))

                        local delete = tonumber(result.getDataInt(result_plr, 'delete_it'))

                        local player = Player(tostring(result.getDataString(result_plr, 'name')))

                        if player then

                                local itemtogive_id = tonumber(result.getDataInt(result_plr, 'param1'))

                                local itemtogive_count = tonumber(result.getDataInt(result_plr, 'param2'))

                                local container_id = tonumber(result.getDataInt(result_plr, 'param3'))

                                local container_count = tonumber(result.getDataInt(result_plr, 'param4'))

                                local add_item_type = tostring(result.getDataString(result_plr, 'param5'))

                                local add_item_name = tostring(result.getDataString(result_plr, 'param6'))

                                local received_item = 0

                                local full_weight = 0

                                local itemType = ItemType(itemtogive_id)

                                if add_item_type == 'container' then

                                        if itemType:isRune() then

                                                full_weight = container_count * itemType:getWeight()

                                        else

                                                full_weight = container_count * itemType:getWeight(itemtogive_count)

                                        end

                                        full_weight = full_weight + ItemType(container_id):getWeight()

                                else

                                        if itemType:isRune() then

                                                full_weight = itemType:getWeight()

                                        else

                                                full_weight = itemType:getWeight(itemtogive_count)

                                        end

                                end

 

                                local free_cap = player:getFreeCapacity()

                                if full_weight <= free_cap then

                                        if add_item_type == 'container' then

                                                local new_container = Game.createItem(container_id, 1)

                                                local iter = 0

                                                while iter ~= container_count do

                                                        new_container:addItem(itemtogive_id, itemtogive_count)

                                                        iter = iter + 1

                                                end

                                                received_item = player:addItemEx(new_container)

                                        else

                                                local new_item = Game.createItem(itemtogive_id, itemtogive_count)

                                                received_item = player:addItemEx(new_item)

                                        end

 

                                        if type(received_item) == 'number' and received_item == 0 then

                                                player:sendTextMessage(MESSAGE_STATUS_CONSOLE_BLUE, '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

                                                player:sendTextMessage(MESSAGE_STATUS_CONSOLE_BLUE, '>> ' .. 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

                                        player:sendTextMessage(MESSAGE_STATUS_CONSOLE_BLUE, '>> ' .. 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

                until not result.next(result_plr)

                result.free(result_plr)

        end

        return true

end

[elli 36]

ae cara como vc arrumou?

to com um problema tbm no meu shop D;