query to add 30 days vip to put on a "vip ticket"

[oblinez]

hello ppl,

 

can someone help me? 

I need a query to add vip days in an account 

this query will put in a ticket, the person purchasing the ticket and uses to add vip days your account 

after using the item will disappear 

my vip system works with 2 main tables "diasvip", "levelvip" 

 

I use svro vip system 

 

with these tables: 

 

- Login table: 

ALTER TABLE `login` ADD `diasvip` INT NOT NULL;

 

is possible to make an alert popup after using a item? i'll use an item in-game like a ticket and an window appears with some alerts about the item....

 

like ... if the person already has vip 

and the person buying another card and use, a message will appear saying that he already has vip, and a button appears to close this message

 

 

 

Solved!

Edited July 10, 2014 by oblinez