Normal [Ajuda]Vip system Error

[SirGhaz 9]

Pessoal ta dando esse erro e não consigo logar no meu char.

 

[4:2:47.777] [Error - CreatureScript Interface]

[4:2:47.777] data/creaturescripts/scripts/expvip.lua:onLogin

[4:2:47.777] Description:

[4:2:47.777] data/lib/vipAccount.lua:69: attempt to perform arithmetic on local 'vipTime' (a boolean value)

[4:2:47.777] stack traceback:

[4:2:47.777]    data/lib/vipAccount.lua:69: in function 'getVipDaysByAccount'

[4:2:47.777]    data/lib/vipAccount.lua:74: in function <data/lib/vipAccount.lua:73>

[4:2:47.777]    (tail call): ?

[4:2:47.777]    data/creaturescripts/scripts/expvip.lua:7: in function <data/creaturescripts/scripts/expvip.lua:1>

[4:2:47.778] Sir Ghaz has logged out.

[4:3:12.277] Sir Ghaz has logged in.

[4:3:12.278] mysql_real_query(): SELECT `viptime` FROM `accounts` WHERE `id` = 3899467; - MYSQL ERROR: Unknown column 'viptime' in 'field list' (1054)

[Vip System] Account not found!

 

[TsplayerT 83]

Poste os aquivos encontrado em data/creaturescripts/scripts/expvip.lua e o outro em data/lib/vipAccount.lua

[SirGhaz 9]

Poste os aquivos encontrado em data/creaturescripts/scripts/expvip.lua e o outro em data/lib/vipAccount.lua

 

Expvip.lua

function onLogin(cid)

local rate = 1.3 -- 30%

local config = {

welvip = "você tem "..((rate - 1)*100).."% de exp a mais agora!",

not_vip = "Compre seus dias de VIP ACC e dispare no ranking.",

vip = isVip(cid)

}

if (config.vip == TRUE) then

doPlayerSetExperienceRate(cid, rate)

doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, config.welvip)

else

doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, config.not_vip)

end

return TRUE

end

 

vipaccount.lua

--[[

Name: Vip System by Account

Version: 1.0

Author: Kydrai

[Functions]

-- Install

installVip()

-- By Account

doTeleportPlayersByAccount(acc, topos)

getVipTimeByAccount(acc)

setVipTimeByAccount(acc, time)

getVipDaysByAccount(acc)

isVipAccount(acc)

addVipDaysByAccount(acc, days)

doRemoveVipDaysByAccount(acc, days)

getVipDateByAccount(acc)

-- By Player

doTeleportPlayers(cid, topos)

getVipTime(cid)

setVipTime(cid, time)

getVipDays(cid)

isVip(cid)

addVipDays(cid, days)

doRemoveVipDays(cid, days)

getVipDate(cid)

]]--

-- Install

function installVip()

if db.executeQuery("ALTER TABLE `accounts` ADD viptime INT(15) NOT NULL DEFAULT 0;") then

print("[Vip System] Vip System instalado com sucesso!")

return TRUE

end

print("[Vip System] Não foi possível instalar o Vip System!")

return FALSE

end

-- By Account

function doTeleportPlayersByAccount(acc, topos)

if db.executeQuery("UPDATE `players` SET `posx` = "..topos.x..", `posy` = "..topos.y..", `posz` = "..topos.z.." WHERE `account_id` = "..acc..";") then

return TRUE

end

return FALSE

end

function getVipTimeByAccount(acc)

local vip = db.getResult("SELECT `viptime` FROM `accounts` WHERE `id` = "..acc..";")

if vip:getID() == -1 then

print("[Vip System] Account not found!")

return FALSE

end

return vip:getDataInt("viptime")

end

function setVipTimeByAccount(acc, time)

if db.executeQuery("UPDATE `accounts` SET `viptime` = "..time.." WHERE `id` = "..acc..";") then

return TRUE

end

return FALSE

end

function getVipDaysByAccount(acc)

local vipTime = getVipTimeByAccount(acc)

local timeNow = os.time()

local days = math.ceil((vipTime - timeNow)/(24 * 60 * 60))

return days <= 0 and 0 or days

end

function isVipAccount(acc)

return getVipDaysByAccount(acc) > 0 and TRUE or FALSE

end

function addVipDaysByAccount(acc, days)

if days > 0 then

local daysValue = days * 24 * 60 * 60

local vipTime = getVipTimeByAccount(acc)

local timeNow = os.time()

local time = getVipDaysByAccount(acc) == 0 and (timeNow + daysValue) or (vipTime + daysValue)

setVipTimeByAccount(acc, time)

return TRUE

end

return FALSE

end

function doRemoveVipDaysByAccount(acc, days)

if days > 0 then

local daysValue = days * 24 * 60 * 60

local vipTime = getVipTimeByAccount(acc)

local time = vipTime - daysValue

setVipTimeByAccount(acc, (time <= 0 and 1 or time))

return TRUE

end

return FALSE

end

function getVipDateByAccount(acc)

if isVipAccount(acc) then

local vipTime = getVipTimeByAccount(acc)

return os.date("%d/%m/%y %X", vipTime)

end

return FALSE

end

-- By Player

function doTeleportPlayers(cid, topos)

doTeleportPlayersByAccount(getPlayerAccountId(cid), topos)

end

function getVipTime(cid)

return getVipTimeByAccount(getPlayerAccountId(cid))

end

function setVipTime(cid, time)

return setVipTimeByAccount(getPlayerAccountId(cid), time)

end

function getVipDays(cid)

return getVipDaysByAccount(getPlayerAccountId(cid))

end

function isVip(cid)

return isVipAccount(getPlayerAccountId(cid))

end

function addVipDays(cid, days)

return addVipDaysByAccount(getPlayerAccountId(cid), days)

end

function doRemoveVipDays(cid, days)

return doRemoveVipDaysByAccount(getPlayerAccountId(cid), days)

end

function getVipDate(cid)

return getVipDateByAccount(getPlayerAccountId(cid))

end

Editado Julho 20, 2015 por Wakon
Site concorrente. (veja o histórico de edições)

[Wakon 912]

Faça um backup da sua database e tente executar o comando:

ALTER TABLE accounts ADD viptime int(11) default(0)

Para executar, abra o SQLeditor, aperte ALT+E, cole o código e aperte F9.

 

---

@SirGhaz, é divulgar link sobre a concorrencia, preste mais atenção!
Leia as regras: http://www.tibiaking.com/forum/topic/1281-regras-gerais/

2.13 - Propagandas:
É extremamente proibido realizar divulgações de sites não vinculados a este fórum, não será permitido divulgar links de sites concorrentes (ou seja, de sites de Tibia, OTServ e Bots que não seja o TibiaKing), de produtos que estão a venda, de PTC (Pay To Click) ou qualquer outro tipo de propaganda não autorizada por nossa equipe..