• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • New resources must be posted under Resources tab. A discussion thread will be created automatically, you can't open threads manually anymore.

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

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!
 
[31/03/2015 20:03:32] Error during getDataInt(vipdays).
and its spawning it whole time using tfs 0.3.6
and got ideas?
 
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;)
 
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
Code:
ALTER TABLE `accounts` ADD
`vipdays` int(11) NOT NULL DEFAULT 0;
 
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!
 
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
Code:
--- 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
 
Last edited:
try this one
tile.lua
Code:
--- 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! :D
 
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?
 
execute this in your phpmyadmin and change X, for some number.
Code:
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!
 
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:
Code:
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:
Code:
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.
 
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?
 
Any1 got a exp and double loot script? And for gessior 2012 a check vip stats in character.php can any1 help me?
 
Back
Top