[AJUDA] Liberar store para rooker

-- Please don't edit those information!
GameStore = {
    ModuleName = "GameStore",
    Developer = "Cjaker",
    Version = "0.3",
    LastUpdated = "24-09-2016 07:15PM"
}

--== Enums ==--
GameStore.OfferTypes = {
    OFFER_TYPE_NONE = 0, -- (this will disable offer)
    OFFER_TYPE_ITEM = 1,
    OFFER_TYPE_STACKABLE = 2,
    OFFER_TYPE_OUTFIT = 3,
    OFFER_TYPE_OUTFIT_ADDON = 4,
    OFFER_TYPE_MOUNT = 5,
    OFFER_TYPE_NAMECHANGE = 6,
    OFFER_TYPE_SEXCHANGE = 7,
    OFFER_TYPE_PROMOTION = 8,
    OFFER_TYPE_HOUSE = 9,
    OFFER_TYPE_EXPBOOST = 10,
    OFFER_TYPE_PREYSLOT = 11,
    OFFER_TYPE_PREYBONUS = 12,
    OFFER_TYPE_TEMPLE = 13,
    OFFER_TYPE_BLESSINGS = 14,
    OFFER_TYPE_PREMIUM = 15
}

GameStore.ClientOfferTypes = {
    CLIENT_STORE_OFFER_OTHER = 0,
    CLIENT_STORE_OFFER_NAMECHANGE = 1
}

GameStore.HistoryTypes = {
    HISTORY_TYPE_NONE = 0,
    HISTORY_TYPE_GIFT = 1,
    HISTORY_TYPE_REFUND = 2
}

GameStore.States = {
    STATE_NONE = 0,
    STATE_NEW = 1,
    STATE_SALE = 2,
    STATE_TIMED = 3
}

GameStore.StoreErrors = {
    STORE_ERROR_PURCHASE = 0,
    STORE_ERROR_NETWORK = 1,
    STORE_ERROR_HISTORY = 2,
    STORE_ERROR_TRANSFER = 3,
    STORE_ERROR_INFORMATION = 4
}

GameStore.ServiceTypes = {
    SERVICE_STANDERD = 0,
    SERVICE_OUTFITS = 3,
    SERVICE_MOUNTS = 4,
    SERVICE_BLESSINGS = 5
}

GameStore.SendingPackets = {
    S_CoinBalance = 0xDF, -- 223
    S_StoreError = 0xE0, -- 224
    S_RequestPurchaseData = 0xE1, -- 225
    S_CoinBalanceUpdating = 0xF2, -- 242
    S_OpenStore = 0xFB, -- 251
    S_StoreOffers = 0xFC, -- 252
    S_OpenTransactionHistory = 0xFD, -- 253
    S_CompletePurchase = 0xFE  -- 254
}

GameStore.RecivedPackets = {
    C_StoreEvent = 0xE9, -- 233
    C_TransferCoins = 0xEF, -- 239
    C_OpenStore = 0xFA, -- 250
    C_RequestStoreOffers = 0xFB, -- 251
    C_BuyStoreOffer = 0xFC, -- 252
    C_OpenTransactionHistory = 0xFD, -- 253
    C_RequestTransactionHistory = 0xFE, -- 254
}

GameStore.DefaultValues = {
    DEFAULT_VALUE_ENTRIES_PER_PAGE    = 16
}

GameStore.DefaultDescriptions = {
    OUTFIT = {"This outfit looks nice. Only high-class people are able to wear it!",
        "An outfit that was created to suit you. We are sure you'll like it.",
        "Legend says only smart people should wear it, otherwise you will burn!"},
    MOUNT = {"This is a fantastic mount that helps to become faster, try it!",
        "The first rider of this mount became the leader of his country! legends say that."},
    NAMECHANGE = {"Are you hunted? Tired of that? Get a new name, a new life!",
        "A new name to suit your needs!"},
    SEXCHANGE = {"Bored of your character's sex? Get a new sex for him now!!"},
    EXPBOOST = {"Are you tired of leveling slow? try it!"},
    PREYSLOT = {"It's hunting season! Activate a prey to gain a bonus when hunting a certain monster. Every character can purchase one Permanent Prey Slot, which enables the activation of an additional prey. \nIf you activate a prey, you can select one monster out of nine. The bonus for your prey will be selected randomly from one of the following: damage boost, damage reduction, bonus XP, improved loot. The bonus value may range from 5% to 50%. Your prey will be active for 2 hours hunting time: the duration of an active prey will only be reduced while you are hunting."},
    PREYBONUS = {"You activated a prey but do not like the randomly selected bonus? Roll for a new one! Here you can purchase five Prey Bonus Rerolls! \nA Bonus Reroll allows you to get a bonus with a higher value (max. 50%). The bonus for your prey will be selected randomly from one of the following: damage boost, damage reduction, bonus XP, improved loot. The 2 hours hunting time will start anew once you have rolled for a new bonus. Your prey monster will stay the same."},
    TEMPLE = {"Need a quick way home? Buy this transportation service to get instantly teleported to your home temple. \n\nNote, you cannot use this service while having a battle sign or a protection zone block. Further, the service will not work in no-logout zones or close to your home temple."}
}

--==Parsing==--
GameStore.isItsPacket = function(byte)
    for k, v in pairs(GameStore.RecivedPackets) do
        if v == byte then
            return true
        end
    end
    return false
end

function onRecvbyte(player, msg, byte)
    if not configManager.getBoolean(STOREMODULES) then return true end
    if player:getVocation():getId() == 0 and not GameStore.haveCategoryRook() then
        return player:sendCancelMessage("Store don't have offers for rookgaard citizen.")
    end

    if byte == GameStore.RecivedPackets.C_StoreEvent then
        -- Not Used!
    elseif byte == GameStore.RecivedPackets.C_TransferCoins then
        parseTransferCoins(player:getId(), msg)
    elseif byte == GameStore.RecivedPackets.C_OpenStore then
        parseOpenStore(player:getId(), msg)
    elseif byte == GameStore.RecivedPackets.C_RequestStoreOffers then
        parseRequestStoreOffers(player:getId(), msg)
    elseif byte == GameStore.RecivedPackets.C_BuyStoreOffer then
        parseBuyStoreOffer(player:getId(), msg)
    elseif byte == GameStore.RecivedPackets.C_OpenTransactionHistory then
        parseOpenTransactionHistory(player:getId(), msg)
    elseif byte == GameStore.RecivedPackets.C_RequestTransactionHistory then
        parseRequestTransactionHistory(player:getId(), msg)
    end
    return true
end

function parseTransferCoins(playerId, msg)
    local player = Player(playerId)
    if not player then
        return false
    end

    local reciver = msg:getString()
    local amount = msg:getU32()

    if (player:getCoinsBalance() < amount) then
        return addPlayerEvent(sendStoreError, 350, playerId, GameStore.StoreErrors.STORE_ERROR_TRANSFER, "You don't have this amount of coins.")
    end

    if reciver:lower() == player:getName():lower() then
        return addPlayerEvent(sendStoreError, 350, playerId, GameStore.StoreErrors.STORE_ERROR_TRANSFER, "You can't transfer coins to yourself.")
    end

    local resultId = db.storeQuery("SELECT `account_id` FROM `players` WHERE `name` = " .. db.escapeString(reciver:lower()) .. "")
    if not resultId then
        return addPlayerEvent(sendStoreError, 350, playerId, GameStore.StoreErrors.STORE_ERROR_TRANSFER, "We couldn't find that player.")
    end

    local accountId = result.getDataInt(resultId, "account_id")
    if accountId == player:getAccountId() then
        return addPlayerEvent(sendStoreError, 350, playerId, GameStore.StoreErrors.STORE_ERROR_TRANSFER, "You cannot transfer coin to a character in the same account.")
    end

    db.query("UPDATE `accounts` SET `coins` = `coins` + " .. amount .. " WHERE `id` = " .. accountId)
    player:removeCoinsBalance(amount)
    addPlayerEvent(sendStorePurchaseSuccessful, 550, playerId, "You have transfered " .. amount .. " coins to " .. reciver .. " successfully")

    -- Adding history for both reciver/sender
    GameStore.insertHistory(accountId, GameStore.HistoryTypes.HISTORY_TYPE_NONE, player:getName() .. " transfered you this amount.", amount)
    GameStore.insertHistory(player:getAccountId(), GameStore.HistoryTypes.HISTORY_TYPE_NONE, "You transfered this amount to " .. reciver, -1 * amount) -- negative
end

function parseOpenStore(playerId, msg)
    openStore(playerId)

    local serviceType = msg:getByte()
    local category = GameStore.Categories and GameStore.Categories[1] or nil

    local servicesName = {
        [GameStore.ServiceTypes.SERVICE_OUTFITS] = "outfits",
        [GameStore.ServiceTypes.SERVICE_MOUNTS] = "mounts",
        [GameStore.ServiceTypes.SERVICE_BLESSINGS] = "blessings"
    }

    if servicesName[serviceType] then
        category = GameStore.getCategoryByName(servicesName[serviceType])
    end

    if category then
        addPlayerEvent(sendShowStoreOffers, 350, playerId, category)
    end
end

function parseRequestStoreOffers(playerId, msg)
    local player = Player(playerId)
    if not player then
        return false
    end

    local serviceType = GameStore.ServiceTypes.SERVICE_STANDERD
    if player:getClient().version >= 1092 then
        serviceType = msg:getByte()
    end

    local categoryName = msg:getString()

    local category = GameStore.getCategoryByName(categoryName)
    if category then
        addPlayerEvent(sendShowStoreOffers, 350, playerId, category)
    end
end

function parseBuyStoreOffer(playerId, msg)
    local player = Player(playerId)
    if not player then
        return false
    end

    local offerId = msg:getU32()
    local productType = msg:getByte()
    local offer = GameStore.getOfferById(offerId)

    if (player:getVocation():getId() == 0) then
        if (not GameStore.haveOfferRook(offerId)) then
            return addPlayerEvent(sendStoreError, 350, playerId, GameStore.StoreErrors.STORE_ERROR_TRANSFER, "The offer is either fake or corrupt.")
        end
    end

    if offer then
        -- If we don't add type, or offer type is fake
        if not offer.type or offer.type == GameStore.OfferTypes.OFFER_TYPE_NONE then
            return addPlayerEvent(sendStoreError, 250, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "The offer is either fake or corrupt.")
        end

        -- If no thing id,
        if offer.type ~= GameStore.OfferTypes.OFFER_TYPE_NAMECHANGE and 
            offer.type ~= GameStore.OfferTypes.OFFER_TYPE_EXPBOOST and 
            offer.type ~= GameStore.OfferTypes.OFFER_TYPE_PREYBONUS and 
            offer.type ~= GameStore.OfferTypes.OFFER_TYPE_PREYSLOT and
            offer.type ~= GameStore.OfferTypes.OFFER_TYPE_TEMPLE and
            offer.type ~= GameStore.OfferTypes.OFFER_TYPE_SEXCHANGE and
            not offer.thingId then
            return addPlayerEvent(sendStoreError, 250, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "The offer is either fake or corrupt.")
        end

        -- We remove coins before doing everything, if it fails, we add coins back!
        if not player:canRemoveCoins(offer.price) then
            return addPlayerEvent(sendStoreError, 250, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "We couldn't remove coins from your account, try again later.")
        end

        -- count is used in type(item), so we need to show (i.e 10x crystal coins)
        local offerCountStr = offer.count and (offer.count .. "x ") or ""
        -- The message which we will send to player!
        local message = "You have purchased " .. offerCountStr .. offer.name .. " for " .. offer.price .. " coins."

        -- If offer is item.
        if offer.type == GameStore.OfferTypes.OFFER_TYPE_ITEM then
            if player:getFreeCapacity() < ItemType(offer.thingId):getWeight(offer.count) then
                return addPlayerEvent(sendStoreError, 250, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "Please make sure you have free capacity to hold this item.")
            end

            local inbox = player:getSlotItem(CONST_SLOT_STORE_INBOX)
            if inbox and inbox:getEmptySlots() > offer.count then
                for t = 1,offer.count do
                    inbox:addItem(offer.thingId, offer.count or 1)
                end
            else
                return addPlayerEvent(sendStoreError, 250, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "Please make sure you have free slots in your store inbox.")
            end
        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_BLESSINGS then
            player:addBlessing(offer.thingId, 1)
        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_PREMIUM then
            player:addPremiumDays(offer.thingId)
        -- If offer is Stackable.
        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_STACKABLE then
            if player:getFreeCapacity() < ItemType(offer.thingId):getWeight(offer.count) then
                return addPlayerEvent(sendStoreError, 250, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "Please make sure you have free capacity to hold this item.")
            end

            local inbox = player:getSlotItem(CONST_SLOT_STORE_INBOX)
            if inbox and inbox:getEmptySlots() > 0 then
                local function isKegItem(itemId)
                    return itemId>=ITEM_KEG_START and itemId <= ITEM_KEG_END
                end

                if(isKegItem(offer.thingId)) then
                    if(offer.count > 500) then
                        local parcel = Item(inbox:addItem(2596, 1):getUniqueId())
                        local function changeParcel(parcel)
                            local packagename = ''.. offer.count..'x '.. offer.name ..' package.'
                            if parcel then
                                parcel:setAttribute(ITEM_ATTRIBUTE_NAME, packagename)
                                local pendingCount=  offer.count
                                while(pendingCount>0) do
                                    local pack
                                    if(pendingCount>500) then
                                        pack = 500
                                    else
                                        pack = pendingCount
                                    end
                                    local kegItem = parcel:addItem(offer.thingId, 1)
                                    kegItem:setAttribute(ITEM_ATTRIBUTE_CHARGES, pack)
                                    pendingCount=pendingCount-pack
                                end
                            end
                        end
                        addEvent(function() changeParcel(parcel) end, 250)
                    else
                        local kegItem = inbox:addItem(offer.thingId,1)
                        kegItem:setAttribute(ITEM_ATTRIBUTE_CHARGES, pack)
                    end
                elseif (offer.count > 100) then
                    local parcel = Item(inbox:addItem(2596, 1):getUniqueId())
                    local function changeParcel(parcel)
                        local packagename = ''.. offer.count..'x '.. offer.name ..' package.'
                        if parcel then
                            parcel:setAttribute(ITEM_ATTRIBUTE_NAME, packagename)
                            local pendingCount=  offer.count
                            while(pendingCount>0) do
                                local pack
                                if(pendingCount>100) then
                                    pack = 100
                                else
                                    pack = pendingCount
                                end
                                parcel:addItem(offer.thingId, pack)
                                pendingCount=pendingCount-pack
                            end
                        end
                    end
                    addEvent(function() changeParcel(parcel) end, 250)
                else
                    inbox:addItem(offer.thingId, offer.count)
                end
            else
                return addPlayerEvent(sendStoreError, 250, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "Please make sure you have free slots in your store inbox.")
            end
        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_HOUSE then
            local function isCaskItem(itemId)
                return (itemId >= ITEM_HEALTH_CASK_START and itemId <= ITEM_HEALTH_CASK_END) or 
                    (itemId >= ITEM_MANA_CASK_START and itemId <= ITEM_MANA_CASK_END) or 
                    (itemId >= ITEM_SPIRIT_CASK_START and itemId <= ITEM_SPIRIT_CASK_END)
            end

            local inbox = player:getSlotItem(CONST_SLOT_STORE_INBOX)
            if inbox and inbox:getEmptySlots() > 0 then
                local decoKit = inbox:addItem(26054, 1)
                local function changeKit(kit)
                    local decoItemName = ItemType(offer.thingId):getName()
                    if kit then
                        kit:setAttribute(ITEM_ATTRIBUTE_DESCRIPTION, "You bought this item in the Store.\nUnwrap it in your own house to create a <" ..decoItemName..">.")
                        kit:setActionId(offer.thingId)

                        if isCaskItem(offer.thingId) then
                            kit:setAttribute(ITEM_ATTRIBUTE_DATE, offer.count)
                         end
                    end
                end
                addEvent(function() changeKit(decoKit) end, 250)
            else
                return addPlayerEvent(sendStoreError, 250, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "Please make sure you have free slots in your store inbox.")
            end
        -- If offer is outfit/addon
        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_OUTFIT or offer.type == GameStore.OfferTypes.OFFER_TYPE_OUTFIT_ADDON then
            local outfitLookType
            if player:getSex() == PLAYERSEX_MALE then
                outfitLookType = offer.thingId.male
            else
                outfitLookType = offer.thingId.female
            end
            if not outfitLookType then
                return addPlayerEvent(sendStoreError, 250, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "This outfit seems not to suit your sex, we are sorry for that!")
            end

            player:addOutfitAddon(outfitLookType, offer.addon or 0)
        -- If offer is mount
        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_MOUNT then
            player:addMount(offer.thingId)
        -- If offer is name change
        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_NAMECHANGE then
            -- If player typed name yet!
            if productType == GameStore.ClientOfferTypes.CLIENT_STORE_OFFER_NAMECHANGE then
                local newName = msg:getString()

                local tile = Tile(player:getPosition())
                if (tile) then
                    if (not tile:hasFlag(TILESTATE_PROTECTIONZONE)) then
                        return addPlayerEvent(sendStoreError, 650, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "You can change name only in Protection Zone.")
                    end
                end

                local resultId = db.storeQuery("SELECT * FROM `players` WHERE `name` = " .. db.escapeString(newName) .. "")
                if resultId ~= false then
                    return addPlayerEvent(sendStoreError, 650, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "This name is already used, please try again!")
                end

                local result = GameStore.canChangeToName(newName)
                if not result.ability then
                    return addPlayerEvent(sendStoreError, 650, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, result.reason)
                end

                newName = newName:lower():gsub("(%l)(%w*)", function(a, b) return string.upper(a) .. b end)
                db.query("UPDATE `players` SET `name` = " .. db.escapeString(newName) .. " WHERE `id` = " .. player:getGuid())
                message =  "You have successfully changed you name, relogin!"
                addEvent(function()
                    local player = Player(playerId)
                    if not player then
                        return false
                    end

                    player:remove()
                end, 500)
            -- If not, we ask him to do!
            else
                return addPlayerEvent(sendRequestPurchaseData, 250, playerId, offer.id, GameStore.ClientOfferTypes.CLIENT_STORE_OFFER_NAMECHANGE)
            end
        -- If offer is sex change
        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_SEXCHANGE then
            player:toggleSex()
        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_EXPBOOST then
            local currentExpBoostTime = player:getExpBoostStamina()

            player:setStoreXpBoost(50)
            player:setStaminaXpBoost(currentExpBoostTime + 60)
        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_PREYSLOT then
            local unlockedColumns = player:getPreySlots()
            if (unlockedColumns == 2) then
                return addPlayerEvent(sendStoreError, 250, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "You already have 3 slots released.")
            end

            player:addPreySlot()
        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_PREYBONUS then
            player:addBonusReroll(offer.count)
        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_TEMPLE then
            if (player:getCondition(CONDITION_INFIGHT) or
                player:isPzLocked()) then
                return addPlayerEvent(sendStoreError, 250, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "You can't use temple teleport in fight!")
            end

            player:teleportTo(player:getTown():getTemplePosition())
        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_PROMOTION then
            if not GameStore.addPromotionToPlayer(playerId, offer.thingId) then
                return false
            end
        -- You can add whatever offer types to suit your needs!
        else
            -- ToDo :: implement purchase function
            return addPlayerEvent(sendStoreError, 250, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "This offer is fake, please contact admin.")
        end
        -- Removing coins
        player:removeCoinsBalance(offer.price)
        -- We add this purchase to history!
        GameStore.insertHistory(player:getAccountId(), GameStore.HistoryTypes.HISTORY_TYPE_NONE, offerCountStr .. offer.name, offer.price * -1)
        -- Send to client that purchase is successful!
        return addPlayerEvent(sendStorePurchaseSuccessful, 650, playerId, message)
    end

    -- If we didn't found the offer or error happened
    addPlayerEvent(sendStoreError, 350, playerId, GameStore.StoreErrors.STORE_ERROR_INFORMATION, "We couldn't locate this offer, please try again later.")
end

-- Both functions use same formula!
function parseOpenTransactionHistory(playerId, msg)
    local page = 1
    GameStore.DefaultValues.DEFAULT_VALUE_ENTRIES_PER_PAGE = msg:getByte()
    sendStoreTransactionHistory(playerId, page, GameStore.DefaultValues.DEFAULT_VALUE_ENTRIES_PER_PAGE)
end

function parseRequestTransactionHistory(playerId, msg)
    local page = msg:getU32()
    sendStoreTransactionHistory(playerId, page, GameStore.DefaultValues.DEFAULT_VALUE_ENTRIES_PER_PAGE)
end

local function getCategoriesRook()
    local tmpTable, count = {}, 0
    for i, v in pairs(GameStore.Categories) do
        if (v.rookgaard) then
            tmpTable[#tmpTable+1] = v
            count = count + 1
        end
    end

    return tmpTable, count
end

--==Sending==--
function openStore(playerId)
    local player = Player(playerId)
    if not player then
        return false
    end

    if not GameStore.Categories then
        return false
    end
    local msg = NetworkMessage()
    msg:addByte(GameStore.SendingPackets.S_OpenStore)
    msg:addByte(0x00)

    local GameStoreCategories, GameStoreCount = nil, 0
    if (player:getVocation():getId() == 0) then
        GameStoreCategories, GameStoreCount = getCategoriesRook()
    else
        GameStoreCategories, GameStoreCount = GameStore.Categories, #GameStore.Categories
    end 

    if (GameStoreCategories) then
        msg:addU16(GameStoreCount)
        for k, category in ipairs(GameStoreCategories) do
            msg:addString(category.name)
            msg:addString(category.description)

            if player:getClient().version >= 1093 then
                msg:addByte(category.state or GameStore.States.STATE_NONE)
            end

            msg:addByte(#category.icons)
            for m, icon in ipairs(category.icons) do
                msg:addString(icon)
            end

            msg:addString(category.parentCategory)
        end
        msg:sendToPlayer(player)

        sendCoinBalanceUpdating(playerId, true)
    end
end

function sendShowStoreOffers(playerId, category)
    local player = Player(playerId)
    if not player then
        return false
    end

    local msg = NetworkMessage()
    local haveSaleOffer = 0
    msg:addByte(GameStore.SendingPackets.S_StoreOffers)

    msg:addString(category.name)

    msg:addU16(category.offers and #category.offers or 0x00)

    if category.offers then
        for k, offer in ipairs(category.offers) do
            msg:addU32(offer.id and offer.id or 0xFFFF) -- we later detect this number!

            local name = ""
            if offer.type == GameStore.OfferTypes.OFFER_TYPE_ITEM and offer.count then
                name = offer.count .. "x "
            end

            if offer.type == GameStore.OfferTypes.OFFER_TYPE_STACKABLE and offer.count then
                name = offer.count .. "x "
            end

            name = name .. (offer.name or "Something Special")

            msg:addString(name)
            msg:addString(offer.description or GameStore.getDefaultDescription(offer.type))

            local newPrice = nil
            if (offer.state == GameStore.States.STATE_SALE) then
                local daySub = offer.validUntil-os.date("*t").day
                if (daySub < 0) then
                    newPrice = offer.basePrice
                end
            end

            msg:addU32(newPrice or offer.price or 0xFFFF)
            if (offer.state) then
                if (offer.state == GameStore.States.STATE_SALE) then
                    local daySub = offer.validUntil-os.date("*t").day
                    if (daySub >= 0) then
                        msg:addByte(offer.state)
                        msg:addU32(os.time()+daySub*86400)
                        msg:addU32(offer.basePrice)
                        haveSaleOffer = 1
                    else
                        msg:addByte(GameStore.States.STATE_NONE)
                    end
                else
                    msg:addByte(offer.state)
                end
            else
                msg:addByte(GameStore.States.STATE_NONE)
            end

            local disabled, disabledReason = 0, ""
            if offer.disabled == true or not offer.type then
                disabled = 1
            end

            if offer.type ~= GameStore.OfferTypes.OFFER_TYPE_NAMECHANGE and 
                offer.type ~= GameStore.OfferTypes.OFFER_TYPE_EXPBOOST and 
                offer.type ~= GameStore.OfferTypes.OFFER_TYPE_PREYSLOT and 
                offer.type ~= GameStore.OfferTypes.OFFER_TYPE_PREYBONUS and
                offer.type ~= GameStore.OfferTypes.OFFER_TYPE_TEMPLE and 
                offer.type ~= GameStore.OfferTypes.OFFER_TYPE_SEXCHANGE and 
                not offer.thingId then
                disabled = 1
            end

            if disabled == 1 and offer.disabledReason then -- dynamic disable
                disabledReason = offer.disabledReason
            end

            if disabled ~= 1 then
                if offer.type == GameStore.OfferTypes.OFFER_TYPE_OUTFIT or offer.type == GameStore.OfferTypes.OFFER_TYPE_OUTFIT_ADDON then
                    local outfitLookType
                    if player:getSex() == PLAYERSEX_MALE then
                        outfitLookType = offer.thingId.male
                    else
                        outfitLookType = offer.thingId.female
                    end

                    if outfitLookType then
                        if offer.type == GameStore.OfferTypes.OFFER_TYPE_OUTFIT and player:hasOutfit(outfitLookType) then
                            disabled = 1
                            disabledReason = "You already have this outfit."
                        elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_OUTFIT_ADDON then
                            if player:hasOutfit(outfitLookType) then
                                if player:hasOutfit(outfitLookType, offer.addon) then
                                    disabled = 1
                                    disabledReason = "You already have this addon."
                                end
                            else
                                disabled = 1
                                disabledReason = "You don't have the outfit, you can't buy the addon."
                            end
                        end
                    else
                        disabled = 1
                        disabledReason = "The offer is fake."
                    end
                elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_MOUNT then
                    local hasMount = player:hasMount(offer.thingId)
                    if hasMount == true then
                        disabled = 1
                        disabledReason = "You already have this mount."
                    end
                elseif offer.type == GameStore.OfferTypes.OFFER_TYPE_PROMOTION then
                    if GameStore.canAddPromotionToPlayer(playerId, offer.thingId).ability == false then
                        disabled = 1
                        disabledReason = "You can't get this promotion"
                    end
                end
            end

            msg:addByte(disabled)

            if disabled == 1 and player:getClient().version >= 1093 then
                msg:addString(disabledReason)
            end

            msg:addByte(#offer.icons)
            for k, icon in ipairs(offer.icons) do
                msg:addString(icon)
            end

            msg:addU16(0) -- We still don't support SubOffers!
        end
    end

    player:sendButtonIndication(haveSaleOffer, 1)
    msg:sendToPlayer(player)
end

function sendStoreTransactionHistory(playerId, page, entriesPerPage)
    local player = Player(playerId)
    if not player then
        return false
    end

    local entries = GameStore.retrieveHistoryEntries(player:getAccountId()) -- this makes everything easy!
    if #entries == 0 then
        return addPlayerEvent(sendStoreError, 250, playerId, GameStore.StoreErrors.STORE_ERROR_HISTORY, "You don't have any entries yet.")
    end

    local toSkip = (page - 1) * entriesPerPage
    for i = 1, toSkip do
        table.remove(entries, 1) -- we remove first!
    end

    local msg = NetworkMessage()
    msg:addByte(GameStore.SendingPackets.S_OpenTransactionHistory)
    msg:addU32(page)
    msg:addU32(#entries > entriesPerPage and 0x01 or 0x00)

    msg:addByte(#entries >= entriesPerPage and entriesPerPage or #entries)
    for k, entry in ipairs(entries) do
        if k >= entriesPerPage then break end
        msg:addU32(entry.time)
        msg:addByte(entry.mode)
        msg:addU32(entry.amount)
        msg:addString(entry.description)
    end
    msg:sendToPlayer(player)
end

function sendStorePurchaseSuccessful(playerId, message)
    local player = Player(playerId)
    if not player then
        return false
    end

    local msg = NetworkMessage()
    msg:addByte(GameStore.SendingPackets.S_CompletePurchase)

    msg:addByte(0x00)

    msg:addString(message)
    msg:addU32(player:getCoinsBalance())
    msg:addU32(player:getCoinsBalance())

    msg:sendToPlayer(player)
end

function sendStoreError(playerId, errorType, message)
    local player = Player(playerId)
    if not player then
        return false
    end

    local msg = NetworkMessage()
    msg:addByte(GameStore.SendingPackets.S_StoreError)

    msg:addByte(errorType)
    msg:addString(message)

    msg:sendToPlayer(player)
end

function sendCoinBalanceUpdating(playerId, updating)
    local player = Player(playerId)
    if not player then
        return false
    end

    local msg = NetworkMessage()
    msg:addByte(GameStore.SendingPackets.S_CoinBalanceUpdating)
    msg:addByte(0x00)
    msg:sendToPlayer(player)

    if updating == true then
        sendUpdateCoinBalance(playerId)
    end
end

function sendUpdateCoinBalance(playerId)
    local player = Player(playerId)
    if not player then
        return false
    end

    local msg = NetworkMessage()
    msg:addByte(GameStore.SendingPackets.S_CoinBalanceUpdating)
    msg:addByte(0x01)

    msg:addByte(GameStore.SendingPackets.S_CoinBalance)
    msg:addByte(0x01)

    msg:addU32(player:getCoinsBalance())
    msg:addU32(player:getCoinsBalance())

    msg:sendToPlayer(player)
end

function sendRequestPurchaseData(playerId, offerId, type)
    local player = Player(playerId)
    if not player then
        return false
    end

    local msg = NetworkMessage()
    msg:addByte(GameStore.SendingPackets.S_RequestPurchaseData)
    msg:addU32(offerId)
    msg:addByte(type)
    msg:sendToPlayer(player)
end

--==GameStoreFunctions==--
GameStore.getCategoryByName = function(name)
    for k, category in ipairs(GameStore.Categories) do
        if category.name:lower() == name:lower() then
            return category
        end
    end
    return nil
end

GameStore.getOfferById = function(id)
    for Cat_k, category in ipairs(GameStore.Categories) do
        if category.offers then
            for Off_k, offer in ipairs(category.offers) do
                if offer.id == id then
                    return offer
                end
            end
        end
    end
    return nil
end

GameStore.haveCategoryRook = function()
    for Cat_k, category in ipairs(GameStore.Categories) do
        if category.offers and category.rookgaard then
            return true
        end
    end

    return false
end

GameStore.haveOfferRook = function(id)
    for Cat_k, category in ipairs(GameStore.Categories) do
        if category.offers and category.rookgaard then
            for Off_k, offer in ipairs(category.offers) do
                if offer.id == id then
                    return true
                end
            end
        end
    end
    return nil
end

GameStore.insertHistory = function(accountId, mode, description, amount)
    return db.query(string.format("INSERT INTO `store_history`(`account_id`, `mode`, `description`, `coin_amount`, `time`) VALUES (%s, %s, %s, %s, %s)", accountId, mode, db.escapeString(description), amount, os.time()))
end

GameStore.retrieveHistoryEntries = function(accountId)
    local entries = {}
    local resultId = db.storeQuery("SELECT * FROM `store_history` WHERE `account_id` = " .. accountId .. " ORDER BY `time` DESC LIMIT 15;")
    if resultId ~= false then
        repeat
            local entry = {
                mode = result.getDataInt(resultId, "mode"),
                description = result.getDataString(resultId, "description"),
                amount = result.getDataInt(resultId, "coin_amount"),
                time = result.getDataInt(resultId, "time"),
            }
            table.insert(entries, entry)
        until not result.next(resultId)
        result.free(resultId)
    end
    return entries
end

GameStore.getDefaultDescription = function(offerType)
    local t, descList = GameStore.OfferTypes
    if offerType == t.OFFER_TYPE_OUTFIT or offerType == t.OFFER_TYPE_OUTFIT_ADDON then
        descList = GameStore.DefaultDescriptions.OUTFIT
    elseif offerType == t.OFFER_TYPE_MOUNT then
        descList = GameStore.DefaultDescriptions.MOUNT
    elseif offerType == t.OFFER_TYPE_NAMECHANGE then
        descList = GameStore.DefaultDescriptions.NAMECHANGE
    elseif offerType == t.OFFER_TYPE_SEXCHANGE then
        descList = GameStore.DefaultDescriptions.SEXCHANGE
    elseif offerType == t.OFFER_TYPE_EXPBOOST then
        descList = GameStore.DefaultDescriptions.EXPBOOST
    elseif offerType == t.OFFER_TYPE_PREYSLOT then
        descList = GameStore.DefaultDescriptions.PREYSLOT
    elseif offerType == t.OFFER_TYPE_PREYBONUS then
        descList = GameStore.DefaultDescriptions.PREYBONUS
    elseif offerType == t.OFFER_TYPE_TEMPLE then
        descList = GameStore.DefaultDescriptions.TEMPLE
    else
        return ""
    end

    return descList[math.floor(math.random(1, #descList))] or ""
end

GameStore.canChangeToName = function(name)
    local result = {
        ability = false
    }
    if name:len() < 3 or name:len() > 14 then
        result.reason = "Your new name's length should be lower than 3 or higher than 14."
        return result
    end

    local match = name:gmatch("%s+")
    local count = 0
    for v in match do
        count = count + 1
    end

    local matchtwo = name:match("^%s+")
    if (matchtwo) then
        result.reason = "Your new name can't have whitespace at begin."
        return result
    end

    if (count > 1) then
        result.reason = "Your new name have more than 1 whitespace."
        return result
    end

    -- just copied from znote aac.
    local words = {"owner", "gamemaster", "hoster", "admin", "staff", "tibia", "account", "god", "anal", "ass", "fuck", "sex", "hitler", "pussy", "dick", "rape", "adm", "cm", "gm", "tutor", "counsellor"}
    local split = name:split(" ")
    for k, word in ipairs(words) do
        for k, nameWord in ipairs(split) do
            if nameWord:lower() == word then
                result.reason = "You can't use word \"" .. word .. "\" in your new name."
                return result
            end
        end
    end

    local tmpName = name:gsub("%s+", "")
    for i = 1, #words do
        if (tmpName:lower():find(words)) then
            result.reason = "You can't use word \"" .. words .. "\" with whitespace in your new name."
            return result
        end
    end

    if MonsterType(name) then
        result.reason = "Your new name \"" .. name .. "\" can't be a monster's name."
        return result
    elseif Npc(name) then
        result.reason = "Your new name \"" .. name .. "\" can't be a npc's name."
        return result
    end

    local letters = "{}|_*+-=<>0123456789@#%^&()/*'\\.,:;~!\"$"
    for i = 1, letters:len() do
        local c = letters:sub(i, i)
        for i = 1, name:len() do
            local m = name:sub(i, i)
            if m == c then
                result.reason = "You can't use this letter \"" .. c .. "\" in your new name."
                return result
            end
        end
    end
    result.ability = true
    return result
end

GameStore.canAddPromotionToPlayer = function(playerId, promotion, send)
    local player = Player(playerId)
    if not player then
        return false
    end

    local result = {
        ability = true
    }
    local vocation = player:getVocation()
    -- Working --
    local vocationCopy, baseVocation = vocation, vocation
    vocation = vocation:getDemotion()
    while vocation do
        baseVocation = vocation
        vocation = vocation:getDemotion()
    end

    local baseVocationsCount = GameStore.BaseVocationsCount or 4

    local newVocId = (baseVocationsCount * promotion) + baseVocation:getId()

    if not Vocation(newVocId) then
        if send then
            addPlayerEvent(sendStoreError, 350, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "The offer is fake, please report it!")
        end
        result.ability = false
        return result
    end
    -- If promotion is less than player's voc, or player don't have previous promotion
    if newVocId <= vocationCopy:getId() then
        if send then
            addPlayerEvent(sendStoreError, 350, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "You already have this promotion!")
        end
        result.ability = false
        return result
    end

    if (newVocId - baseVocationsCount) ~= vocationCopy:getId() then
        if send then
            addPlayerEvent(sendStoreError, 350, playerId, GameStore.StoreErrors.STORE_ERROR_NETWORK, "You need higher promotion to get his one.")
        end
        result.ability = false
        return result
    end

    result.vocId = newVocId
    return result
end

GameStore.addPromotionToPlayer = function(playerId, promotion)
    local player = Player(playerId)
    if not player then
        return false
    end

    local result = GameStore.canAddPromotionToPlayer(player, promotion, true)
    if result.ability == false then return false end

    local basics = {
        health = 185,
        mana = 40,
        cap = 500
    }

    player:setVocation(result.vocId)
    local newVoc = player:getVocation()
    player:setMaxHealth(basics.health + (newVoc:getHealthGain() * player:getLevel()))
    player:setMaxMana(basics.mana + (newVoc:getManaGain() * player:getLevel()))
    player:setCapacity(basics.cap + (newVoc:getCapacityGain() * player:getLevel()))

    player:addHealth(player:getMaxHealth())
    player:addMana(player:getMaxMana())

    player:sendTextMessage(MESSAGE_INFO_DESCR, "You have been promoted to " .. newVoc:getName())
    return true
end

--==Player==--
function Player.getCoinsBalance(self)
    resultId = db.storeQuery("SELECT `coins` FROM `accounts` WHERE `id` = " .. self:getAccountId())
    if not resultId then return 0 end
    return result.getDataInt(resultId, "coins")
end

function Player.setCoinsBalance(self, coins)
    db.query("UPDATE `accounts` SET `coins` = " .. coins .. " WHERE `id` = " .. self:getAccountId())
    return true
end

function Player.canRemoveCoins(self, coins)
    if self:getCoinsBalance() < coins then
        return false
    end
    return true
end

function Player.removeCoinsBalance(self, coins)
    if self:canRemoveCoins(coins) then
        return self:setCoinsBalance(self:getCoinsBalance() - coins)
    end

    return false
end

function Player.addCoinsBalance(self, coins, update)
    self:setCoinsBalance(self:getCoinsBalance() + coins)
    if update then sendCoinBalanceUpdating(self, true) end
    return true
end

function Player.sendButtonIndication(self, value1, value2)
    local msg = NetworkMessage()
    msg:addByte(0x19)
    msg:addByte(value1) -- Sale
    msg:addByte(value2) -- New Item
    msg:sendToPlayer(self)
end

function Player.toggleSex(self)
    local currentSex = self:getSex()
    local playerOutfit = self:getOutfit()

    if currentSex == PLAYERSEX_FEMALE then
        self:setSex(PLAYERSEX_MALE)
        playerOutfit.lookType = 128
    else
        self:setSex(PLAYERSEX_FEMALE)
        playerOutfit.lookType = 136
    end
    self:setOutfit(playerOutfit)
end