SQL code used to activate a new user? - Software Assistance - WowBB

Home

Not logged in - Login | Register

UltraBB Forums > WowBB > Software Assistance > SQL code used to activate a new user?

Moderated by: Jim

New Topic

Printer Friendly

SQL code used to activate a new user?

Rate Topic

Author	Post

Posted: Sat Feb 16th, 2013 12:19 am

Quote

1^st 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

Quote

Posted: Sat Feb 16th, 2013 12:53 am

Quote

2^nd 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'

Quote

Posted: Sat Feb 16th, 2013 02:04 am

Quote

3^rd 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

Quote

Posted: Sat Feb 16th, 2013 06:23 pm

Quote

4^th 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...

Quote

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