Whats the sql code to make everyone vip? R63?

[willboy100]

Whats the sql code to make everyone vip? R63?
Please i need this simple sql code!

 

[Expiry]

UPDATE users SET vip = '1'

Then click users, goto design table, find vip, and set the default to 1.

If you're using phpmyadmin, I have no clue I've only used navicat.

 

[willboy100]

thx

 

[Khalil]

If you're using PMA or Navicat, this query will work on both:

UPDATE `users` SET `vip` = '1';

 

[Ecko]

If you're using PMA or Navicat, this query will work on both:

ALTER TABLE `users`
UPDATE `users` SET `vip` = '1';

what's the point of the alter table?

 

[Khalil]

what's the point of the alter table?

Shit sorry, thought i was executing an Add/Drop query. Fixed.

 

[Aldane]

can someone tell me the sql to run when you update when you change the default look?

 

[Aruthra]

can someone tell me the sql to run when you update when you change the default look?

Do you mean set default look for everyone?
Run this.

UPDATE users SET look = "lg-3116-110-62.ch-215-92.hd-209-1.hr-3163-61"

 

[Aldane]

Thanks mate, Aruthra small world its YoungDane from Facebook