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

 

•  

 

•  
•  
•  
•  

 

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

  Citar

 

-- ### 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 =/

Parece perfeitamente correto. Algum erro no distro?

Pois é.. nenhum erro no distro.

 

somente fica enviando itens sem parar para o char.

 

o que deve ter algo de errado é na parte

 

  Citar

 

  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.