CreatureEvent Perfect Vip System 100%

[Elgenady]

[21/02/2013 10:52:42] Error during getDataInt(vip_time).
[21/02/2013 10:52:42] Error during getDataInt(vip_time).
[21/02/2013 10:52:47] Error during getDataInt(vip_time).
[21/02/2013 10:52:47] Error during getDataInt(vip_time).
[21/02/2013 10:53:12] Error during getDataInt(vip_time).
[21/02/2013 10:53:12] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: vip_time (UPDATE "accounts" SET "vip_time" = '1362700392' WHERE "accounts"."name" =''
[21/02/2013 10:53:17] Error during getDataInt(vip_time).
[21/02/2013 10:53:17] Error during getDataInt(vip_time).

 

[Limos]

Execute SQL:

If you are using sqlite then

ALTER TABLE `accounts` ADD `vip_time` INTEGER;

 

[AnarchGov]

WHen i try to use the item to add vip days i get this error:

[21/02/2013 04:46:52] data/lib/049-vipsys.lua:102: attempt to call field 'executequery' (a nil value)
[21/02/2013 04:46:52] stack traceback:
[21/02/2013 04:46:52] data/lib/049-vipsys.lua:102: in function <data/lib/049-vipsys.lua:98>
[21/02/2013 04:46:52] (tail call): ?
[21/02/2013 04:46:52] data/actions/scripts/other/vipmedal.lua:5: in function <data/actions/scripts/other/vipmedal.lua:3>

 

[Naxtie]

Is this for the whole account or just the character?

 

[Cornex]

Is this for the whole account or just the character?

vip.addVipByAccount <-- think it is for the whole account ;p

 

[AnarchGov]

It happens when i try to use the item running off of that script.

 

[wikutag]

I am using Sqlite and when i go to put in the account vip_time intger than ok. Than it goes to "" Table 'players' references table 'accounts'. Please remove foreign key reference to table before editing it.

 

[markim1986]

Man, when vip_time player ends, not the player logs in, is in conect world, and appears on the terminal, player logged in, and soon after, player logged out!
Already tried everything and can not fix, I have to change the VipFim.lua?