Sim Compro no shop Do site e ele entrega altomaticamente no jogo

up

up

 

usa o meu

function onThink(interval, lastExecution, thinkInterval)

local result = db.getResult("SELECT * FROM shop_history WHERE `processed` = 0;")

  if(result:getID() ~= -1) then

   while(true) do

    cid = getCreatureByName(tostring(result:getDataString("player")))

    product = tonumber(result:getDataInt("product"))

    itemr = db.getResult("SELECT * FROM shop_offer WHERE `id` = "..product..";")

     if isPlayer(cid) then

      local id = tonumber(itemr:getDataInt("item"))

      local tid = tonumber(result:getDataInt("id"))

      local count = tonumber(itemr:getDataInt("count"))

      local tipe = tonumber(itemr:getDataInt("type"))

      local productn = tostring(itemr:getDataString("name"))

       if isInArray({5,8},tipe) then

        if getPlayerFreeCap(cid) >= getItemWeightById(id, count) then

         if isContainer(getPlayerSlotItem(cid, 3).uid) then

          received = doAddContainerItem(getPlayerSlotItem(cid, 3).uid, id,count)

          if received then

           doPlayerSendTextMessage(cid,19, "You have received >> "..productn.." << from our shop HPO")

           db.executeQuery("UPDATE `shop_history` SET `processed`='1' WHERE id = " .. tid .. ";")

          else

           doPlayerSendTextMessage(cid,19, "Sorry, you don't have enough space on container to receive >> "..productn.." <<")

          end

         else

          doPlayerSendTextMessage(cid,19, "Sorry, you don't have a container to receive >> "..productn.." <<")

         end

        else

         doPlayerSendTextMessage(cid,19, "Sorry, you don't have enough capacity to receive >> "..productn.." << (You need: "..getItemWeightById(id, count).." Capacity)")

        end

       elseif isInArray({6,7},tipe) then

         if tipe == 6 then

          bcap = 8

          bid = 1987

         elseif tipe == 7 then

          bcap = 20

          bid = 1988

         end

         if isItemRune(id) then

          count = 1

         end

         if getPlayerFreeCap(cid) >= (getItemWeightById(1987, 1) + getItemWeightById(id,count * bcap)) then

          local bag = doCreateItemEx(bid, 1)

           for i = 1,bcap do

            doAddContainerItem(bag, id, count)

           end

          received = doPlayerAddItemEx(getPlayerSlotItem(cid, 3).uid, bag)

          if received == RETURNVALUE_NOERROR then

           doPlayerSendTextMessage(cid,19, "You have received >> "..productn.." << from our shop HPO")

           db.executeQuery("UPDATE `shop_history` SET `processed`='1' WHERE id = " .. tid .. ";")

          else

           doPlayerSendTextMessage(cid,19, "Sorry, you don't have enough space to receive >> "..productn.." <<")

          end

         else

          doPlayerSendTextMessage(cid,19, "Sorry, you don't have enough capacity to receive >> "..productn.." << (You need: "..getItemWeightById(id, count).." Capacity)")

         end

       end

     end

    itemr:free()

    if not(result:next()) then

     break

    end

   end

   result:free()

  end

return true

end

 

<globalevent name="shop" interval="230000" script="shop.lua"/>

Nao funcionou 

que erro mostra no seu distro ? altera essa linha  <globalevent name="shop" interval="1000" script="shop.lua"/ > agora mostra o erro se caso tiver!

Editado Julho 20, 2014 11 anos por alexxxxxxx (veja o histórico de edições)

Nao mostra nenhum erro na distro simplesmente nao entre os itens vo testar esse ai

e Pra por essa ultima linha tamben ? 

 

-- Volcar la base de datos para la tabla `shop_donation_history`

de um /reload globalevents   rsrs pra que vc n precise reiniciar o servidor! vc usa modern acc ou gesior ?

Editado Julho 20, 2014 11 anos por alexxxxxxx (veja o histórico de edições)