local config = {
        levelRequiredToAdd = 8,
        maxOffersPerPlayer = 5,
        SendOffersOnlyInPZ = false,
        blocked_items = {2165, 2152, 2148, 2160, 2166, 2167, 2168, 2169, 2202, 2203, 2204, 2205, 2206, 2207, 2208, 2209, 2210, 2211, 2212, 2213, 2214, 2215, 2343, 2433, 2640, 6132, 6300, 6301, 9932, 9933}
        }

local Sudden_Death = 2268
local Ultimate_Healing = 2273
local Great_Fireball = 2304
local Explosion = 2313
local Heavy_Magic_Missile = 2268
local backpack, rune, charges

function onSay(cid, words, param, channel)
	if(param == '') then
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Command requires parameters.")
		return true
	end

	local t = string.explode(param, ",")
	if(t[1] == "add") then
		if((not t[2]) or (not t[3]) or (not t[4])) then
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Command requires parameters.")
			return false
		end

		if(not tonumber(t[3]) or (not tonumber(t[4]))) then
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You don't set valid price or items count.")
			return false
		end

		if(string.len(t[3]) > 7 or (string.len(t[4]) > 3)) then
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "This price or item count is too high.")
			return false
		end

		local item = getItemIdByName(t[2])
		if(not item) then
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Item with such name does not exists.")
			return false
		end

		if(getPlayerLevel(cid) < config.levelRequiredToAdd) then
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You don't have required (" .. config.levelRequiredToAdd .. ") level.")
			return false
		end

		if(getPlayerVocation(cid) == 0) then
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You don't have the profession to do that action!")
			return false
		end

		if(isInArray(config.blocked_items, item)) then
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "This item is blocked.")
			return false
		end

		if(getPlayerItemCount(cid, item) < (tonumber(t[4]))) then
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Sorry, you don't have this item(s).")
			return false
		end

		local check = db.getResult("SELECT `id` FROM `auction_system` WHERE `player` = " .. getPlayerGUID(cid) .. ";")
		if(check:getID() == -1) then
		elseif(check:getRows(true) >= config.maxOffersPerPlayer) then
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Sorry you can't add more offers (max. " .. config.maxOffersPerPlayer .. ")")
			return false
		end

		if(config.SendOffersOnlyInPZ) then
			if(not getTilePzInfo(getPlayerPosition(cid))) then
				doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You must be in PZ area when you add offer to market.")
				return false
			end
		end

		if(tonumber(t[4]) < 1 or (tonumber(t[3]) < 1)) then
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You have to type a number higher than 0.")
			return false
		end

		local itemcount, costgp = math.floor(t[4]), math.floor(t[3])
		doPlayerRemoveItem(cid, item, itemcount)
		db.executeQuery("INSERT INTO `auction_system` (`player`, `item_name`, `item_id`, `count`, `cost`, `date`) VALUES (" .. getPlayerGUID(cid) .. ", \"" .. t[2] .. "\", " .. getItemIdByName(t[2]) .. ", " .. itemcount .. ", " .. costgp ..", " .. os.time() .. ")")
		doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You successfully add " .. itemcount .." " .. t[2] .." for " .. costgp .. " gold coins to market.")
		return false
	end

	if(t[1] == "buy") then
		if(not tonumber(t[2])) then
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Wrong ID.")
			return false
		end

		local buy = db.getResult("SELECT * FROM `auction_system` WHERE `id` = " .. (tonumber(t[2])) .. ";")
		if(buy:getID() ~= -1) then
			if(getPlayerMoney(cid) < buy:getDataInt("cost")) then
				doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You don't have enough gold coins.")
				buy:free()
				return tfalse
			end

			if(getPlayerName(cid) == getPlayerNameByGUID(buy:getDataInt("player"))) then
				doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Sorry, you can't buy your own items.")
				buy:free()
				return false
			end

			if(getPlayerFreeCap(cid) < getItemWeightById(buy:getDataInt("item_id"), buy:getDataInt("count")))then
				doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You try to buy a " .. buy:getDataString("item_name") .. ". It weight " .. getItemWeightById(buy:getDataInt("item_id"), buy:getDataInt("count")) .. " cap oz. and you have only " .. getPlayerFreeCap(cid) .. " oz. free capacity.")
				buy:free()
				return false
			end

			if(getPlayerVocation(cid) == 0) then
				doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You don't have the profession to do that action!")
				return false
			end

			if(isItemStackable((buy:getDataInt("item_id")))) then
				doPlayerAddItem(cid, buy:getDataInt("item_id"), buy:getDataInt("count"))
			else
				for i = 1, buy:getDataInt("count") do
					doPlayerAddItem(cid, buy:getDataInt("item_id"), 1)
				end
			end

			-- Reserved for the code of Runes inside backpacks


			doPlayerRemoveMoney(cid, buy:getDataInt("cost"))
			db.executeQuery("DELETE FROM `auction_system` WHERE `id` = " .. t[2] .. ";")
			doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You bought " .. buy:getDataInt("count") .. " ".. buy:getDataString("item_name") .. " for " .. buy:getDataInt("cost") .. " gold coins!")
			db.executeQuery("UPDATE `players` SET `auction_balance` = `auction_balance` + " .. buy:getDataInt("cost") .. " WHERE `id` = " .. buy:getDataInt("player") .. ";")
			buy:free()
			return false
		else
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Wrong Auction ID.")
		end
	end

	if(t[1] == "remove") then
		if((not tonumber(t[2]))) then
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Wrong Auction ID.")
		return false
	end

	if(config.SendOffersOnlyInPZ) then
		if(not getTilePzInfo(getPlayerPosition(cid))) then
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You must be in PZ area when you remove offers from market.")
			return false
		end
	end

	local delete = db.getResult("SELECT * FROM `auction_system` WHERE `id` = " .. (tonumber(t[2])) .. ";")
	if(delete:getID() ~= -1) then
		if(getPlayerGUID(cid) == delete:getDataInt("player")) then
			db.executeQuery("DELETE FROM `auction_system` WHERE `id` = " .. t[2] .. ";")
			if(isItemStackable(delete:getDataInt("item_id"))) then
				doPlayerAddItem(cid, delete:getDataInt("item_id"), delete:getDataInt("count"))
			else
				for i = 1, delete:getDataInt("count") do
					doPlayerAddItem(cid, delete:getDataInt("item_id"), 1)
				end
			end
			doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Your offer has been deleted from market.")
			return false
		else
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "This is not your offer!")
			return false
		end
		delete:free()
	else
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Wrong Auction ID.")
		return false
	end
	end

	if(t[1] == "withdraw") then
		local balance = db.getResult("SELECT `auction_balance` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. ";")
		if(balance:getDataInt("auction_balance") < 1) then
			doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You don't have money on your auction balance.")
			balance:free()
			return false
		end

		doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You got " .. balance:getDataInt("auction_balance") .. " gold coins from market!")
		doPlayerAddMoney(cid, balance:getDataInt("auction_balance"))
		db.executeQuery("UPDATE `players` SET `auction_balance` = '0' WHERE `id` = " .. getPlayerGUID(cid) .. ";")
		balance:free()
		return false
	end
	return true
end