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

[Hanozy]

It crashes my server, idk why.. No errors, just crashing.

 

[Evil Puncker]

It crashes my server, idk why.. No errors, just crashing.

if you don't give us ANY INFO about which server you are using its hard to help you

 

[imback1]

It crashes my server, idk why.. No errors, just crashing.

Crashes your server? How is it? What is your tfs? and explain your problem please.

 

[Hanozy]

Crashes your server? How is it? What is your tfs? and explain your problem please.

Using TFS 0.3.6, crashes like The Forgotten Server has stopped responding, I eventually fixed it by not using the VIP Tile script!

 

[deryzeen]

[31/03/2015 20:03:32] Error during getDataInt(vipdays).
and its spawning it whole time using tfs 0.3.6
and got ideas?

 

[deryzeen]

Any ideas?
[31/03/2015 20:57:21] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: vipdays (UPDATE "accounts" SET "vipdays" = "vipdays" + 30 WHERE "id" = 22
[31/03/2015 20:57:22] Error during getDataInt(vipdays).
[31/03/2015 20:57:25] Error during getDataInt(vipdays).
[31/03/2015 20:57:28] Error during getDataInt(vipdays).
[31/03/2015 20:57:31] Error during getDataInt(vipdays).
[31/03/2015 20:57:34] Error during getDataInt(vipdays).
[31/03/2015 20:57:37] Error during getDataInt(vipdays).
[31/03/2015 20:57:39] Error during getDataInt(vipdays).
[31/03/2015 20:57:39] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: vipdays (UPDATE "accounts" SET "vipdays" = "vipdays" + 30 WHERE "id" = 22

 

[imback1]

Any ideas?
[31/03/2015 20:57:21] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: vipdays (UPDATE "accounts" SET "vipdays" = "vipdays" + 30 WHERE "id" = 22
[31/03/2015 20:57:22] Error during getDataInt(vipdays).
[31/03/2015 20:57:25] Error during getDataInt(vipdays).
[31/03/2015 20:57:28] Error during getDataInt(vipdays).
[31/03/2015 20:57:31] Error during getDataInt(vipdays).
[31/03/2015 20:57:34] Error during getDataInt(vipdays).
[31/03/2015 20:57:37] Error during getDataInt(vipdays).
[31/03/2015 20:57:39] Error during getDataInt(vipdays).
[31/03/2015 20:57:39] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: vipdays (UPDATE "accounts" SET "vipdays" = "vipdays" + 30 WHERE "id" = 22

Insert this column into your database

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

 

[durassek]

what should i do when i want to change outfit acces only to vip instead premium?

 

[Thorn]

guys, could anyone help me? i want that when the person steps in the tile, the vip tile, there is a message that tells him how many days he has left for vip, is that possible? thanks!

 

[imback1]

guys, could anyone help me? i want that when the person steps in the tile, the vip tile, there is a message that tells him how many days he has left for vip, is that possible? thanks!

try this one
tile.lua

--- Script by Kekox
function onStepIn(cid, item, position, fromPosition)
if getPlayerVipDays(cid) == 0 then
doTeleportThing(cid, fromPosition, FALSE)
else
doPlayerSendTextMessage(cid, 19, "You have ".. getPlayerVipDays(cid) .." vip days left.")
end
return true
end

 

[Thorn]

try this one
tile.lua

--- Script by Kekox
function onStepIn(cid, item, position, fromPosition)
if getPlayerVipDays(cid) == 0 then
doTeleportThing(cid, fromPosition, FALSE)
else
doPlayerSendTextMessage(cid, 19, "You have ".. getPlayerVipDays(cid) .." vip days left.")
end
return true
end

Ir worked perfectly, thanks man!

 

[imback1]

Ir worked perfectly, thanks man!

No problem you are welcome, btw i've made change with it to work better check it and choose one from them .

 

[Thorn]

Guys, any change to get a talkaction that gives X vip days to everyone in the database? not only the ones that are logged in?

 

[_Aion_]

execute this in your phpmyadmin and change X, for some number.

UPDATE `accounts` SET `vipdays`=X

 

[Thorn]

execute this in your phpmyadmin and change X, for some number.

UPDATE `accounts` SET `vipdays`=X

i meant as a talkaction, a command by the GM, but anyway, something more important, how can i add atributes to being vip? like 20% more exp? more healing? things like that?
Thanks!

 

[Thorn]

Plz someone?

 

[Colors]

i meant as a talkaction, a command by the GM, but anyway, something more important, how can i add atributes to being vip? like 20% more exp? more healing? things like that?
Thanks!

I don't really remember the old functions, but should be something like this:

function onLogin(cid)
if getPlayerVipDays(cid) >= 1 then
doPlayerSetExperienceRate(cid, 0.5) --5% extra exp
end
return true
end

as for the more healing you should edit every healing spell or use onstatschange:

function onStatsChange(cid, attacker, type, combat, value)
if getPlayerVipDays(cid) >= 1 then
if type == STATSCHANGE_HEALTHGAIN then
doCreatureAddHealth(cid, value * 0.5) --5% extra healing
end
end
return true
end

Those codes aren't tested and function syntax may be wrong. But at least now you have the idea.

 

[LordVissie]

Works, Really nice but I've a question: How can I set that people see that the person is vip. for example if you Shift-click on him it shows the description of him (Elite Knight name ect.) then under that something like: This player is a VIP player. Something like that.

Anyone has a idea?

 

[slavi]

Well , I need for TFS 1.1

 

[mike.katori]

Any1 got a exp and double loot script? And for gessior 2012 a check vip stats in character.php can any1 help me?