UltraBB Forums Home 
Home Search search Menu menu Not logged in - Login | Register
UltraBB Forums > WowBB > Software Assistance > SQL code used to activate a new user?

 Moderated by: Jim
New Topic Reply Printer Friendly
SQL code used to activate a new user?  Rate Topic 
AuthorPost
 Posted: Sat Feb 16th, 2013 12:19 am
  PM Quote Reply
1st Post
alfalfa
Member
 

Joined: Fri Feb 15th, 2013
Location:  
Posts: 2
Name: 
Occupation: 
Interests: 
Status: 
Offline
Mana: 
User Gallery
I'm trying to activate the account of a new user on my WowBB forum who isn't receiving the activation emails.  I recall that there is an SQL query that I used in the past to manually activate a user's account, but I can't remember what it is.

Can any of the mods help me out with this?

RJ


Edited to add that I'm using WowBB 1.7

Last edited on Sat Feb 16th, 2013 12:22 am by alfalfa

Back To Top PM Quote Reply  

 Posted: Sat Feb 16th, 2013 12:53 am
  PM Quote Reply
2nd Post
Marty
Helpy Helper


Joined: Mon May 7th, 2007
Location: Chicago, Illinois USA
Posts: 1632
Name: 
Occupation: Insurance
Interests: 
Status: 
Offline
Mana: 
User Gallery
This is it.

Replace the word example with the username of the person. It must be used exactly this way. Including the single quotes.
UPDATE wowbb_users SET user_activation_key='' WHERE user_name='example' 

Back To Top PM Quote Reply

 Posted: Sat Feb 16th, 2013 02:04 am
  PM Quote Reply
3rd Post
alfalfa
Member
 

Joined: Fri Feb 15th, 2013
Location:  
Posts: 2
Name: 
Occupation: 
Interests: 
Status: 
Offline
Mana: 
User Gallery
Thanks, Marty!  That did the trick!

RJ

Back To Top PM Quote Reply  

 Posted: Sat Feb 16th, 2013 06:23 pm
  PM Quote Reply
4th Post
Jim
Head Cheese


Joined: Wed Apr 11th, 2007
Location:  
Posts: 8241
Name: Jim
Occupation: Programmer
Interests: Software
Status: 
Offline
Mana: 
User Gallery
In Ultra you select them from a list and click the activate button. Just sayin...

Back To Top PM Quote Reply

Current time is 02:22 pm  
UltraBB Forums > WowBB > Software Assistance > SQL code used to activate a new user? Top



Hosting

UltraBB 1.17 Copyright © 2007-2012 Data 1 Systems, INC.
Page processed in 0.1508 seconds (8% database + 92% PHP). 24 queries executed.