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

[DukeeH]

bump /\

 

[DukeeH]

bump, fix medal.

 

[DukeeH]

bump, medal pleaaaaaaase.

 

[H4CK3R]

Its working perfectly.

-- Vip medal by Kekox
function onUse(cid, item, fromPosition, itemEx, toPosition)
         if getPlayerVipDays(cid) > 365 then
            doPlayerSendCancel(cid, "You can only have 1 year of vip account or less.")
         else
            doAddVipDays(cid, 30)
            doCreatureSay(cid, "VIP")
            doPlayerPopupFYI(cid, "We have added 30 vip days to your account!\nEnjoy it!.")
            doRemoveItem(item.uid)
         end
        return true
end

<action itemid="2112" event="script" value="vipmedal.lua"/>

Try to put in the correct place
Also, check on your functions if u have

function doAddVipDays(cid, days)
    db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` + " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end
 
function doRemoveVipDays(cid, days)
    db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` - " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end

change it with

function doAddVipDays(cid, days)
    db.query("UPDATE `accounts` SET `vipdays` = `vipdays` + " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end
 
function doRemoveVipDays(cid, days)
    db.query("UPDATE `accounts` SET `vipdays` = `vipdays` - " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end

Regards,
H4CK3R

 

[DukeeH]

	<item id="116" article="a" name="Vip Medal">
	    <attribute key="description" value="One month of vip if you use it." />
		<attribute key="weight" value="3500" />
	</item>

Actions:

 <action itemid="116" script="vipmedal.lua"/>

vipmedal.lua

function onUse(cid, item, fromPosition, itemEx, toPosition)
         if getPlayerVipDays(cid) > 365 then
            doPlayerSendCancel(cid, "You can only have 1 year of vip account or less.")
         else
            doAddVipDays(cid, 30)
            doPlayerPopupFYI(cid, "We have added 30 vip days to your account!\nEnjoy it!.")
            doRemoveItem(item.uid)
         end
        return true
end

functions:

function doAddVipDays(cid, days)
    db.executeQuery("UPDATE `accounts` SET `vip_time` = `vip_time` + " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end
 
function doRemoveVipDays(cid, days)
    db.executeQuery("UPDATE `accounts` SET `vip_time` = `vip_time` - " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end

yeah, my table is "vip_time" cuz i already have it.

 

[DukeeH]

bump.

 

[xubeiga]

I'm trying to use your vip system, but an error just keeps coming up:
smth like that a "=" is missing near the doaddplayer...in line 17 or 18 or 19...please help

 

[cremes]

i dont see vip days when i log in, i do all right like in tutorial. some1 know why ?

i use that distro : http://otland.net/f18/8-60-forgotten-server-0-3-6-crying-damson-v5-147913/

 

[cremes]

bump

 

[elking]

Plz This vip Effect Don't work Help

[26/10/2012 07:14:01] data/globalevents/scripts/vipEffect.lua:4: attempt to call global 'getPlayerVipDays' (a nil value)
[26/10/2012 07:14:01] stack traceback:
[26/10/2012 07:14:01] data/globalevents/scripts/vipEffect.lua:4: in function <data/globalevents/scripts/vipEffect.lua:1>
[26/10/2012 07:14:01] [Error - GlobalEvents::think] Couldn't execute event: vipEffect

 

[G4BB3R]

An fucking waste of time.
I always liked to use the normal PACC for "VIP".
But obviously all spells were to FACC

 

[addz]

I have no idea of what I am doing but im trying to add this to [9.60/9.61] The Forgotten Server v0.2.14 (Mystic Spirit) I guess it's not the same "type" of code but it fails at "attempt to call field 'executeQuery' (a nil value)" when trying to add days ingame.
So im guessing that "db.executeQuery" doesn't exist so what is the correct way to call the database on this ot?

function doAddVipDays(cid, days)
     db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` + " .. days .. " WHERE `id` = " .. getPlayerGUID(cid) .. ";")
end

This fails.

 

[xx Kami xx]

lol vip item dont work... i tried using it with vip medal....

 

[Futlend]

I get an error that doesn't let me use vip systems?

[07/02/2013 00:46:37] [Error - TalkAction Interface]
[07/02/2013 00:46:37] data/talkactions/scripts/VIP/addvipp.luanSay
[07/02/2013 00:46:38] Description:
[07/02/2013 00:46:38] data/talkactions/scripts/VIP/addvipp.lua:13: attempt to index global 'vip' (a nil value)
[07/02/2013 00:46:38] stack traceback:
[07/02/2013 00:46:38] data/talkactions/scripts/VIP/addvipp.lua:13: in function <data/talkactions/scripts/VIP/addvipp.lua:1>

always routes back to attempt to index global vip I have tried your system and a few others why?

 

[XPRIMEX]

says that 'vip' dosent exist and the function in addvip.lua dosent work, ill take a look at the system and try to fix it.

edit: i believe part of the system is missing lol

 

[Futlend]

And this is with another one but i got this error message also leading back to index global

[07/02/2013 01:00:06] [Error - CreatureScript Interface]
[07/02/2013 01:00:06] data/creaturescripts/scripts/vip.luanLogin
[07/02/2013 01:00:06] Description:
[07/02/2013 01:00:06] data/creaturescripts/scripts/vip.lua:4: attempt to index global 'vip' (a nil value)
[07/02/2013 01:00:06] stack traceback:
[07/02/2013 01:00:06] data/creaturescripts/scripts/vip.lua:4: in function <data/creaturescripts/scripts/vip.lua:2>

- - - Updated - - -

I redid all the steps of this one and NOW i am getting this error

[07/02/2013 01:08:02] [Error - Action Interface]
[07/02/2013 01:08:02] buffernUse
[07/02/2013 01:08:02] Description:
[07/02/2013 01:08:02] [string "--- Vip functions by Kekox..."]:13: attempt to call field 'query' (a nil value)
[07/02/2013 01:08:02] stack traceback:
[07/02/2013 01:08:02] [string "--- Vip functions by Kekox..."]:13: in function 'doAddVipDays'
[07/02/2013 01:08:02] [string "loadBuffer"]:9: in function <[string "loadBuffer"]:4>

 

[drama4day]

for tfs4 http://otland.net/f163/mods-vip-sysytem-forgotten-server-4-100-work-tested-180815/


and no bug

 

[kinglewey1st]

Thanks for this. Will definatly use this in the near future!

 

[Tobbz]

Help double "VIP" text and spamming as hell?

 

[GhostX]

Just edit in the interval lol