This will NOT work!Find "permissions_vip" and set everything from '0' to '1'
This will NOT work!
If you want to give free VIP in your settings make everyones default rank "2" If you set the Permissions for VIP it won't give free VIP it will just change the permissions users get when they are VIP.
For what I have found, no. Maybe someone will know where to edit that in the database/emulator but I know for a fact that my way will work.Is there any other way where I can make users rank stay #1 ? my mate done this for me many times but he quit the retro world
@JayTouch How Rude. This will work, You dont have to change the default rank..This will NOT work!
If you want to give free VIP in your settings make everyones default rank "2" If you set the Permissions for VIP it won't give free VIP it will just change the permissions users get when they are VIP.
UPDATE users SET vip = '1'
@JayTouch How Rude. This will work, You dont have to change the default rank.. Do this code AFTER you do those steps I provided. Then run this query UPDATE users SET vip = '1'
@Raptar The Answer to your question lied really simple. I Provided you a code.
Go to query (navicat) or where you run your sqls.
Apply the Following Code:
Code:UPDATE users SET vip = '1'
Your done
I made the provided code for you.
Pink it will not work. If you go into the table for VIP_Permissions and change it to one, that is saying that everyone with VIP will get that, that doesn't give them VIP and UPDATE users SET vip = '1' that changes Current users to VIP but I know how to do it now, ok go into your Design Table after you run that SQL and just set the default to 1 instead of 0 for VIP. Done.@JayTouch How Rude. This will work, You dont have to change the default rank..
@Raptar The Answer to your question lied really simple. I Provided you a code.
Go to query (navicat) or where you run your sqls.
Apply the Following Code:
Code:UPDATE users SET vip = '1'
Your done
I made the provided code for you.
Pink it will not work. If you go into the table for VIP_Permissions and change it to one, that is saying that everyone with VIP will get that, that doesn't give them VIP and UPDATE users SET vip = '1' that changes Current users to VIP but I know how to do it now, ok go into your Design Table after you run that SQL and just set the default to 1 instead of 0 for VIP. Done.
Or in default rank.. Right click on users > Design Table > Look for VIP > once you come across vip click it change the Default from 0 and make it 1.... then If you want them to stay as rank one then go to queries and run this code:
UPDATE users SET vip = '1' so then every current user has VIP for free.
@Pink What you said make all the users VIP, but when they register they are not going to have the VIP Commands so you gotta run that code again. But atleast its part of the step :3
ALTER TABLE `users`
MODIFY COLUMN `vip` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1' AFTER `mail_verified`;
UPDATE users SET vip = '1'