Hello There, Guest! Register

Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Change Membership For A Lot Of Registered Members
06-15-2013, 03:56 AM
Post: #1
Change Membership For A Lot Of Registered Members
Is there a way to change membership from e.g. Standard to Pioneer via SQL statement?

I dont want to click into every member and do it manually.
Visit this user's website Find all posts by this user
Quote this message in a reply
06-15-2013, 12:44 PM
Post: #2
RE: Change Membership For A Lot Of Registered Members
This will change ALL standard users into pioneer users
Code:
UPDATE tb_users SET account = 'pioneer' WHERE account = 'standard'
This will do the same as above, but will set them as pioneer if the upgrade to golden and then is degraded again, they will become pioneer instead of standard (i think you'll use this one):
Code:
UPDATE tb_users SET account = 'pioneer', account_pioneer = 1 WHERE account = 'standard'
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)