shop

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"))
            idTransaction = tonumber(result:getDataInt("id"))
            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 = doPlayerGiveItemSHOP(cid, id, count, 0, idTransaction)
                        --received = doAddContainerItem(getPlayerSlotItem(cid, 3).uid, id,count)
                        if received == true then
                            doPlayerSendTextMessage(cid,19, "You have received >> "..productn.." << from our shop system")
                            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 tipe == 20 then
                    doPlayerAddMount(cid, id)
                    doSendMagicEffect(getThingPos(cid), 14)
                    doPlayerSendTextMessage(cid, 19, "You have received >> "..productn.." << from your shop system.")

                elseif tipe == 21 then
                    doPlayerAddOutfit(cid, id, 3)
                    doSendMagicEffect(getThingPos(cid), 14)
                    doPlayerSendTextMessage(cid, 19, "You have received >> "..productn.." << from your shop system.")

                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 = doPlayerGiveItemContainer(cid, 1988, id, count, 0)
                        --received = doPlayerAddItemEx(getPlayerSlotItem(cid, 3).uid, bag)
                        if received == true then
                            doPlayerSendTextMessage(cid,19, "You have received >> "..productn.." << from our shop system")
                            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