UltraBB Forums Home 
Search     Members Calendar Help Home
Search by username
Not logged in - Login | Register 
UltraBB Forums > UltraBB > Software Assistance > Unactivated accounts

Come on over and join us at the new place- www.ultrabb.net/forum
Same log in as this board but you will have to log in. If you have any problems doing so shoot us an e-mail support@ultrabb.net and we will help you get in.


 Moderated by: Jim
New Topic Reply Printer Friendly
Unactivated accounts - Software Assistance - UltraBB - UltraBB Forums
AuthorPost
 Posted: Sat Jul 5th, 2008 09:59 pm
PMQuoteReply  
1st Post
Mag
License Holder


Joined: Thu Jan 31st, 2008
Location: England, United Kingdom
Posts: 396
Status: 
Offline
Mana: 
 Is there somewhere where you can see when someone registered but hasn't activated their accounts?  We usually give people 48 hours to do so and then zap them but I can't see the date that they registered.

Mag

Last edited on Sat Jul 5th, 2008 09:59 pm by Mag
Back To Top PMQuoteReply

 Posted: Sat Jul 5th, 2008 11:07 pm
PMQuoteReply  
2nd Post
Jim
Administrator


Joined: Wed Apr 11th, 2007
Location:  
Posts: 1963
Status: 
Offline
Mana: 
 Sure. Admin panel/users tab, Highlight the unactivated row and click users list. :)
Back To Top PMQuoteReply

 Posted: Sun Jul 6th, 2008 12:21 am
PMQuoteReply  
3rd Post
TVDinner
Getting Fatter By The Minute


Joined: Wed May 9th, 2007
Location: North Carolina USA
Posts: 602
Status: 
Offline
Mana: 
 Jim wrote: Sure. Admin panel/users tab, Highlight the unactivated row and click users list. :)
not sure if I mentioned that I love this feature. So much better then the old days of running multiple sql queries to see unactivated and the another to activate them, etc etc etc. Great feature.
Back To Top PMQuoteReply

 Posted: Sun Jul 6th, 2008 12:49 am
PMQuoteReply  
4th Post
Jim
Administrator


Joined: Wed Apr 11th, 2007
Location:  
Posts: 1963
Status: 
Offline
Mana: 
 One of the most requested features in the old days. I've tried to address a number of them.
Back To Top PMQuoteReply

 Posted: Sun Jul 6th, 2008 10:09 am
PMQuoteReply  
5th Post
Mag
License Holder


Joined: Thu Jan 31st, 2008
Location: England, United Kingdom
Posts: 396
Status: 
Offline
Mana: 
 Sorry Jim I didn't make myself clear. I saw the list but can't see anywhere that gives the date of registering.
Back To Top PMQuoteReply

 Posted: Sun Jul 6th, 2008 04:12 pm
PMQuoteReply  
6th Post
wingnutter
Forever Learning


Joined: Wed May 14th, 2008
Location: Ireland
Posts: 867
Status: 
Offline
Mana: 
 Here is the sql query Mag, for seeing unactivated members by date joined;

SELECT user_name, user_email, user_joined FROM wowbb_users WHERE user_activation_key'' ORDER BY user_joined DESC
Back To Top PMQuoteReply

 Posted: Sun Jul 6th, 2008 04:15 pm
PMQuoteReply  
7th Post
TVDinner
Getting Fatter By The Minute


Joined: Wed May 9th, 2007
Location: North Carolina USA
Posts: 602
Status: 
Offline
Mana: 
 wingnutter wrote: Here is the sql query Mag, for seeing unactivated members by date joined;

SELECT user_name, user_email, user_joined FROM wowbb_users WHERE user_activation_key'' ORDER BY user_joined DESC

when doing sql queries be very careful..................
Back To Top PMQuoteReply

 Posted: Sun Jul 6th, 2008 04:36 pm
PMQuoteReply  
8th Post
TheSnowHorse
Esistenza รจ futile
 

Joined: Mon May 14th, 2007
Location:  
Posts: 173
Status: 
Offline
Mana: 
 TVDinner wrote: wingnutter wrote: Here is the sql query Mag, for seeing unactivated members by date joined;

SELECT user_name, user_email, user_joined FROM wowbb_users WHERE user_activation_key'' ORDER BY user_joined DESC

when doing sql queries be very careful..................

May I ask why?  We do them all the time at work and nothing bad ever happens....
Back To Top PMQuoteReply

 Posted: Sun Jul 6th, 2008 04:39 pm
PMQuoteReply  
9th Post
Jim
Administrator


Joined: Wed Apr 11th, 2007
Location:  
Posts: 1963
Status: 
Offline
Mana: 
 SELECT user_name, user_email, user_joined FROM wowbb_users WHERE user_activation_key='' ORDER BY user_joined DESC

Needs the equals sign to work.

Since Ultra puts unactivated in group 1 you could use that in the where clause also. Example:

SELECT user_name, user_email, user_joined FROM wowbb_users WHERE user_group_id=1 ORDER BY user_joined DESC
Back To Top PMQuoteReply

 Posted: Sun Jul 6th, 2008 04:52 pm
PMQuoteReply  
10th Post
TVDinner
Getting Fatter By The Minute


Joined: Wed May 9th, 2007
Location: North Carolina USA
Posts: 602
Status: 
Offline
Mana: 
 TheLoneStoner wrote: TVDinner wrote: wingnutter wrote: Here is the sql query Mag, for seeing unactivated members by date joined;

SELECT user_name, user_email, user_joined FROM wowbb_users WHERE user_activation_key'' ORDER BY user_joined DESC

when doing sql queries be very careful..................

May I ask why?  We do them all the time at work and nothing bad ever happens....


Because YOU are not a beginner. But most/many forum owner ARE beginners or have no experience at all with SQL and you can completely screw up your entire board by messing up SQL quries.

Back To Top PMQuoteReply

 Posted: Sun Jul 6th, 2008 04:52 pm
PMQuoteReply  
11th Post
Jim
Administrator


Joined: Wed Apr 11th, 2007
Location:  
Posts: 1963
Status: 
Offline
Mana: 
 SELECT is never dangerous unless you try to return all records in a very large table, it can bring MySQL to a screeching halt. If you were to ***DO NOT RUN THIS EXAMPLE***    "SELECT * FROM wowbb_search_index" on wingers board it would require a reboot.

SELECT is generally not dangerous but be careful with DELETE FROM or TRUNCATE or UPDATE. One little slip and you will have to say "Jim I need a backup" :)
Back To Top PMQuoteReply

 Posted: Sun Jul 6th, 2008 06:19 pm
PMQuoteReply  
12th Post
Mag
License Holder


Joined: Thu Jan 31st, 2008
Location: England, United Kingdom
Posts: 396
Status: 
Offline
Mana: 
 SELECT user_name, user_email, user_joined FROM wowbb_users WHERE user_group_id=1 ORDER BY user_joined DESC

Thanks folks  I did this one and it worked a treat.
Back To Top PMQuoteReply

 Posted: Sun Jul 6th, 2008 07:20 pm
PMQuoteReply  
13th Post
wingnutter
Forever Learning


Joined: Wed May 14th, 2008
Location: Ireland
Posts: 867
Status: 
Offline
Mana: 
 I should have said that the sql's I have are from the WOW days and might need to be checked by Jim first. I've been using them without problems, but you never know.
Back To Top PMQuoteReply

Current time is 05:39 am  
UltraBB Forums > UltraBB > Software Assistance > Unactivated accounts


WowUltra 1.15 Copyright © 2007-2008 by Jim Hale
Page processed in 0.2292 seconds (15% database + 85% PHP). 26 queries executed.