function vip.getVip(cid)
	assert(tonumber(cid), 'Parameter must be a number')
	if not isPlayer(cid) then error('Player don\'t find') end;
	ae = db.getResult("SELECT `vip_time` FROM `accounts` WHERE `name` = '" .. getPlayerAccount(cid) .. "';")
	if ae:getID() == -1 then
		return 0
	end
	
	local retee = ae:getDataInt("vip_time") or 0
	ae:free()
	return retee
end

function vip.getVipByAccount(acc)
	assert(acc, 'Account is nil')
	local a = db.getResult("SELECT `vip_time` FROM `accounts` WHERE `name` = '" .. acc .. "';")
	if a:getID() ~= -1 then
		return a:getDataInt("vip_time") or 0, a:free()
	else
		error('Account don\'t find.')
	end
end

function vip.setVip(cid, time)
	dofile("config.lua")
	assert(tonumber(cid), 'Parameter must be a number')
	assert(tonumber(time), 'Parameter must be a number')
	if not isPlayer(cid) then error('Player don\'t find') end
	local days = vip.getVip(cid)
	days = os.difftime(days, os.time())
	if days < 0 then days = 0 end
	days = days + vip.getDays(time)
	db.query("UPDATE `accounts` SET `vip_time` = '" .. (os.time() + days) .. "' WHERE `accounts`.`name` = '" ..  getPlayerAccount(cid) .. "';")
end

function vip.hasVip(cid)
	assert(tonumber(cid), 'Parameter must be a number')
	if not isPlayer(cid) then return end
	local t = vip.getVip(cid) or 0
	if os.time(day) < t then
		return true
	else
		return false
	end
end

function vip.accountHasVip(acc)
	assert(acc, 'Account is nil')
	if os.time() < vip.getVipByAccount(acc) then
		return true
	else
		return false
	end
end

function vip.getDays(days)
	return (3600 * 24 * days)
end

function vip.addVipByAccount(acc, time)
	assert(acc, 'Account is nil')
	assert(tonumber(time), 'Parameter must be a number')
	local a = vip.getVipByAcc(acc)
	a = os.difftime(a, os.time())
	if a < 0 then a = 0 end
	a = a + vip.getDays(time)
	return vip.setVipByAccount(acc, a)
end

function vip.setVipByAccount(acc, time)
	dofile("config.lua")
	assert(acc, 'Account is nil')
	assert(tonumber(time), 'Parameter must be a number')
	db.query("UPDATE `accounts` SET `vip_time` = '" .. (os.time() + time) .. "' WHERE `accounts`.`name` = '" .. acc .. "';")
	return true
end

function vip.returnVipString(cid)
	assert(tonumber(cid), 'Parameter must be a number')
	if isPlayer(cid) then
		return os.date("%d/%m/%Y %X", vip.getVip(cid))
	end
end

local dias = 30 -- dias que serão adicionados

function onUse(cid, item, fromPosition, itemEx, toPosition)
    vip.setVip(cid, dias)
    doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Foram adicionados " .. dias .. " dias de VIP na sua account.")
    doSendMagicEffect(getPlayerPosition(cid), math.random(28, 30))
    doRemoveItem(item.uid, 1)
    return true
end

local tileConfig = {
    kickMsg = "You need to be a vip player to access this area.",
    kickEffect = CONST_ME_POFF,
    enterMsg = "Welcome to vip area!",
    enterEffect = CONST_ME_MAGIC_RED,
}

function onStepIn(cid, item, position, fromPosition)    
    if not isPlayer(cid) then return false end
    if not vip.hasVip(cid) then
        doTeleportThing(cid, fromPosition)
        doSendMagicEffect(fromPosition, tileConfig.kickEffect)
        doPlayerSendCancel(cid, tileConfig.kickMsg)
        return false
    end

    doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, tileConfig.enterMsg)
    doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Sua VIP Account acaba em: " .. vip.returnVipString(cid) .. ".")
    doSendMagicEffect(position, tileConfig.enterEffect)
    return true
end