VIP Days Remover

[kozmo]

So i finally got VIP added into the server the only issue now is that the script i have seems to not work, It looks like this.

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

And for the XML Part looks like this.

<globalevent name="VipDaysRemover" interval="86395"" event="script" value="daysremover.lua"/>

If someone could help me solve this problem it would be much appreciated thanks.

 

[Korrex]

Alright thanks for everyones help but the one thing no one has yet explained is acutally how to Execute Query
So whoever knows how please let me know.

You should already know how to do this, if you took time learning it. E.g. Google "How to execute queries with PhpMyAdmin".

 

[kozmo]

As you can see i actually already had this in the hole time but is something wrong with it because its still not working, And i don't know if this helps but when it takes away a premium it takes away all 30 days of VIP!

 

[jonathan.dsa]

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

try this

- - - Updated - - -

if dont work, try this:

function onTime()
db.query("UPDATE `accounts` SET `vipdays` = '0' WHERE `vipdays` > 0;")
return true
end

 

[Korrex]

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

try this

- - - Updated - - -

if dont work, try this:

function onTime()
db.query("UPDATE `accounts` SET `vipdays` = '0' WHERE `vipdays` > 0;")
return true
end

Try reading it again.
It will set vipdays to 0.

 

[kozmo]

Thanks to everyone that tried to help i was so close but there's always a problem for example when you create an account you start with 10 days of premium , iv been watching everyday it takes way 1 premium day it then takes all the VIP 30 days away from the account so i am done wasting time on this i will have to make it so once you buy VIP you never loose it..

 

[Korrex]

Thanks to everyone that tried to help i was so close but there's always a problem for example when you create an account you start with 10 days of premium , iv been watching everyday it takes way 1 premium day it then takes all the VIP 30 days away from the account so i am done wasting time on this i will have to make it so once you buy VIP you never loose it..

Uh. Tell me what rev/TFS version you're using. I'll make one for you.

 

[kozmo]

This is the server i am using [9.1] 4Fun Server - XTibia - A sua comunidade de Tibia e OTserv

- - - Updated - - -

Bump