Problem With Data Base (Premium).Read This Post.

[mike]

Hi I have a question. They know that I have an assistant in my OT and it turns out gave a promotion that gave him 6 days premium to all players and it turns out that the time to give the 6 days do not end. Just do not fall of 6 can someone tell me a code for all accounts that have 6 days left vip what to 0 days?

All players have 6 days :S!

 

[DX~]

Paste this code in your SQL

UPDATE `accounts` SET `premdays`=1

Change 1 to whatever premdays that you want to set

GoodLook
DX~

 

[mike]

Hey and the premdays is all to 1 day? And the players vip with 23 days go to 1 day?

 

[DX~]

If you use this code yes, edite the "1" to whatever days that you want to set.

 

[EvulMastah]

UPDATE accounts SET premdays = premdays - 6;