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

[JoSePh15_]

it's not a big deal...

 

[raul123]

I got this error :S:S
[16/12/2010 17:08:24] [Error - Action Interface]
[16/12/2010 17:08:24] data/actions/scripts/vipmedal.luanUse
[16/12/2010 17:08:24] Description:
[16/12/2010 17:08:24] data/lib/050-function.lua:12: attempt to call field 'executeQuery' (a nil value)
[16/12/2010 17:08:24] stack traceback:
[16/12/2010 17:08:24] data/lib/050-function.lua:12: in function 'doAddVipDays'
[16/12/2010 17:08:24] data/actions/scripts/vipmedal.lua:5: in function <data/actions/scripts/vipmedal.lua:1>


And for remove vip days too! :S

where i need to put this lines? i think my error is becouse of this :S:S::
getPlayerVipDays(cid) --- Use it to check how many vip days the player have.
doAddVipDays(cid, days) --- Use it to add vip days to someone.
doRemoveVipDays(cid, days) --- Use it to remove vip days to someone.

 

[Stewie]

Nice

@raul123

u have add querys in ur DB

 

[raul123]

yes i have added de viptime query in my database! but i got this error too

 

[Kekox]

Thats because in 0.4 sources, executeQuery changed, I dont remember how it works now.. xd

 

[demonz]

--- Script by Kekox
function onTimer()
db.executeQuery("UPDATE accounts SET vipdays = vipdays - 1 WHERE vipdays > 0;")
return true
end

i got a bug in TFS 8.6,
the error is dont found function ontimer

and dont remove the vip days =/
you know why?

 

[Kekox]

Please post the complete error. Copy and paste it.

 

[G4BB3R]

Awesome script...
But I don't understand why not use the real premmium account system, because you don't need to waste time for a new VIP SYSTEM and the vip system may contain a few bugs...
The Vip system have more advantages than real PACC ??!

 

[Cotizado]

function onTimer()
db.query("UPDATE accounts SET vipdays = vipdays - 1 WHERE vipdays > 0;")
return true
end

this one should work

 

[jorgeaor]

OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "DELETEON": syntax error (CREATE TRIGGER "ondelete_accounts"BEFORE DELETEON "accounts"FOR EACH ROWBEGIN DELETE FROM "players" WHERE "account_id" = OLD."id"; DELETE FROM "account_viplist" WHERE "account_id" = OLD."id"; DELETE FROM "bans" WHERE "type" IN (3, 4) AND "value" = OLD."id";END

I have this error in the console? :S

edit: i repair the error only create funcion.lua in data/lib and already now thx

 

[Keiro]

daysremover not working, all is ok setup ,any idea? tfs 0.3.6pl1

 

[Pyromaniack]

same here

 

[Peacy]

[10/04/2011 20:13:18] Lua Script Error: [Action Interface] 
[10/04/2011 20:13:18] data/actions/scripts/vipmedal.lua:onUse
[10/04/2011 20:13:18] data/actions/scripts/vipmedal.lua:3: attempt to call global 'getPlayerVipDays' (a nil value)
[10/04/2011 20:13:18] stack traceback:
[10/04/2011 20:13:18]     [C]: in function 'getPlayerVipDays'
[10/04/2011 20:13:18]     data/actions/scripts/vipmedal.lua:3: in function <data/actions/scripts/vipmedal.lua:2>

Could you help me with this? tfs 0.2.10

 

[Kekox]

Do you added the functions to the libs?

 

[GarneT]

Great , Work Very Perfect For Me

 

[GarneT]

i have error >>>>>>>

[12/04/2011 11:26:10] [Error - TalkAction Interface]
[12/04/2011 11:26:10] data/talkactions/scripts/removedays.luanSay
[12/04/2011 11:26:10] Description:
[12/04/2011 11:26:10] (luaDoPlayerSendTextMessage) Player not found

[12/04/2011 11:26:10] [Error - TalkAction Interface]
[12/04/2011 11:26:10] data/talkactions/scripts/removedays.luanSay
[12/04/2011 11:26:10] Description:
[12/04/2011 11:26:10] data/talkactions/scripts/removedays.lua:32: attempt to concatenate global 'sender' (a nil value)
[12/04/2011 11:26:10] stack traceback:
[12/04/2011 11:26:10] data/talkactions/scripts/removedays.lua:32: in function <data/talkactions/scripts/removedays.lua:1>


how i fix it? !!!

 

[Peacy]

Do you added the functions to the libs?

well I put it in global.lua so that should work the same?

So could you help me?

 

[Peacy]

bump

 

[Pheenix]

onTimer should be onTime in removedays.lua and make sure you dont get any unwanted linebreaks when you copy this codes cus it can screw up your sql queries pretty bad and will probably give you an error in the console. Just make sure ur lua files looks like the code posted here. Also, registerCreatureEvent(cid, "VipCheck") must be before the last end in login.lua

 

[GarneT]

I copied it like the post but i still have this error :-(