UltraBB Forums Home 
Search     Members Calendar Help Home
Search by username
Not logged in - Login | Register 

The new pages are almost completed and have pricing/leasing info for UltraBB V 1.17.
www.ultrabb.com
www.ultrabb.net
And of course the public support forums at:
www.ultrabb.net/forum

Hope to see you there!


 Moderated by: Jim
New Topic Reply Printer Friendly
SQL Help - Troubleshooting - UltraBB - UltraBB Forums
AuthorPost
 Posted: Mon Sep 1st, 2008 02:50 am
PMQuoteReply  
1st Post
ZTUnlimited
License Holder
 

Joined: Mon Jun 18th, 2007
Location:  
Posts: 115
Status: 
Offline
Mana: 
Hi there!

I want to move members into new groups based on a variety of things, and I'd prefer not to go through all 7000 members "by hand" Is there something I can do in order to pull up - for example - all members who have over 26-100 posts and move them into a new group? 

Back To Top PMQuoteReply

 Posted: Mon Sep 1st, 2008 04:13 am
PMQuoteReply  
2nd Post
Jim
Administrator


Joined: Wed Apr 11th, 2007
Location:  
Posts: 1963
Status: 
Offline
Mana: 
Yes. Since SQL queries can be dangerous explain to me in PM the specifics (between X and X posts get moved to group X) and I can give you an exact query.

Also there are probably groups you want to exclude (like admin) even if post criteria matches. Make sure to include that!

Jim

Back To Top PMQuoteReply

Current time is 11:43 am  
UltraBB Forums > UltraBB > Troubleshooting > SQL Help



WowUltra 1.15 Copyright © 2007-2008 by Jim Hale
Page processed in 0.1472 seconds (10% database + 90% PHP). 19 queries executed.