The best VIP system ever! [Action/Movevent/Globalevent]

[Amiroslo]

LoL
GoodWork

 

[ctf76]

but, how can i put this part on sqlitestudio

ALTER TABLE `accounts` ADD
`vipdays` int(11) NOT NULL DEFAULT 0;

 

[HamTheKratos]

ty rep

 

[josehhhxx]

Men u rock
rep++

 

[josehhhxx]

how i execute phpmyadmin?

 

[zieworski denero]

I'm gonna use this, thanks

rep

 

[one guy]

omgh

[04/06/2010 13:37:36] mysql_real_query(): SELECT `vipdays` FROM `accounts` WHERE `id` = 2 LIMIT 1 - MYSQL ERROR: Unknown column 'vipdays' in 'field list' (1054)

[04/06/2010 13:37:36] [Error - GlobalEvent Interface]
[04/06/2010 13:37:36] data/globalevents/scripts/vipEffect.luanThink
[04/06/2010 13:37:36] Description:
[04/06/2010 13:37:36] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[04/06/2010 13:37:36] stack traceback:
[04/06/2010 13:37:36] [C]: in function 'error'
[04/06/2010 13:37:36] data/lib/004-database.lua:60: in function 'getDataInt'
[04/06/2010 13:37:36] data/lib/050-function.lua:667: in function 'getPlayerVipDays'
[04/06/2010 13:37:36] data/globalevents/scripts/vipEffect.lua:4: in function <data/globalevents/scripts/vipEffect.lua:1>
[04/06/2010 13:37:36] [Error - GlobalEvents::think] Couldn't execute event: vipEffect
[04/06/2010 13:37:39] mysql_real_query(): SELECT `vipdays` FROM `accounts` WHERE `id` = 2 LIMIT 1 - MYSQL ERROR: Unknown column 'vipdays' in 'field list' (1054)


wtf , what i did wrong?
I have version 0.3.6 (Crying Damson).

 

[chojrak]

[04/06/2010 13:37:36] mysql_real_query(): SELECT `vipdays` FROM `accounts` WHERE `id` = 2 LIMIT 1 - MYSQL ERROR: Unknown column 'vipdays' in 'field list' (1054)

[04/06/2010 13:37:36] [Error - GlobalEvent Interface]
[04/06/2010 13:37:36] data/globalevents/scripts/vipEffect.luanThink
[04/06/2010 13:37:36] Description:
[04/06/2010 13:37:36] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[04/06/2010 13:37:36] stack traceback:
[04/06/2010 13:37:36] [C]: in function 'error'
[04/06/2010 13:37:36] data/lib/004-database.lua:60: in function 'getDataInt'
[04/06/2010 13:37:36] data/lib/050-function.lua:667: in function 'getPlayerVipDays'
[04/06/2010 13:37:36] data/globalevents/scripts/vipEffect.lua:4: in function <data/globalevents/scripts/vipEffect.lua:1>
[04/06/2010 13:37:36] [Error - GlobalEvents::think] Couldn't execute event: vipEffect
[04/06/2010 13:37:39] mysql_real_query(): SELECT `vipdays` FROM `accounts` WHERE `id` = 2 LIMIT 1 - MYSQL ERROR: Unknown column 'vipdays' in 'field list' (1054)


wtf , what i did wrong?
I have version 0.3.6 (Crying Damson).

Missing column vipdays in accounts table.

 

[one guy]

how i can fix it?

 

[chojrak]

ALTER TABLE `accounts` ADD `vipdays` INT(11);

 

[one guy]

ALTER TABLE `accounts` ADD `vipdays` INT(11);

where i add this?:d

 

[chojrak]

Execute in phpMyAdmin, SQL Tab.

 

[one guy]

Tnx Man
I got 2 problem -.-
If i click on medal of honour it says : We added 30 days vip...
And if i try to open vip door , it says : ONLY VIP account can go there.
But im vip ? :O
Second problem
If i log in i don't see how much vip days left.
How i can fix this problem?

 

[CyCu91]

I have 1 question for you. When off server ( i have debian system and kill proces) in days reset herself ? And where save informations in days for all players. Ohh and sorry have additional questions. Is the days run away even as you are not logged in. Sorry in my bad English.

 

[semary]

Use premuim system...

 

[CyCu91]

How ? Y have tutorial ?

 

[one guy]

I got 2 problem -.-
If i click on medal of honour it says : We added 30 days vip...
And if i try to open vip door , it says : ONLY VIP account can go there.
But im vip ? :O
Second problem
If i log in i don't see how much vip days left.
How i can fix this problem?

 

[nightshade]

This is normal?? appear when character login, but all is perfect, only have this dude

[05/06/2010 14:04:09] mysql_real_query(): SELECT `vip_time` FROM `accounts` WHERE `name` = 'Nightshae'; - MYSQL ERROR: Unknown column 'vip_time' in 'field list' (1054)
[05/06/2010 14:04:09] mysql_real_query(): SELECT `vip_time` FROM `accounts` WHERE `name` = 'Nightshade'; - MYSQL ERROR: Unknown column 'vip_time' in 'field list' (1054)
[05/06/2010 14:04:09] mysql_real_query(): SELECT `vip_time` FROM `accounts` WHERE `name` = 'Nighsthade'; - MYSQL ERROR: Unknown column 'vip_time' in 'field list' (1054)

 

[Kekox]

lol that must be another script that you installed, I did not made a script with a query with column 'vip_time'

 

[goleto]

Is there any way to add vip days on an offline player?