Believe me. It would have taken ME longer to do that and then fix what I screwed up doing that...right now I'm a bit gun shy. I knew that I couldn't screw things up too bad this way. Me and sleep deprivation are a dangerous mix. Stupidity abounds! Thanks anyway!

What query would I need to find out who all belongs to a certain group?

oops... Never mind.... lol Figured out I could do it from the AP..... <img src="http://www.ubbdev.com/forum/images/graemlins/laugh.gif" alt="" />

I'd like to know that question. I demoted a moderator and it still showed him in group "2" and he could still read the forums in the admin section. I ran a querie to make his groups right but I can't seem to figure out the correct querie to see if anyone else is in that group that isn't supposed to be.

SELECT `U_Username` , `U_Groups` <br />FROM `w3t_Users` <br />WHERE `U_Groups` <br />LIKE "%-2-%" <br /> <br />change the FROM `w3t_Users` <br /> to your table extension, mine's w3t_ <br />also change the %-2-% to whichever group your looking for.

<img src="http://www.ubbdev.com/forum/images/graemlins/waytogo.gif" alt="" /> Thanks!

My glasses need cleaning again? Is there a query to run that I can input an IP and find out who all (Username or Login Name) has been using that particular IP? <br /> <br />Thanks...

SELECT `U_Username`, `U_Group`, `U_RegIP`, `B_IP`, `B_PosterId`<br />FROM `w3t_Posts`, `w3t_Users`<br />WHERE (((`B_IP` = '192.168.1.1') AND (`B_PosterId` = `U_Number`)) OR (`B_IP` = '192.168.1.1'))<br /><br />change I192.168.1.1 to what your loking for<br />and then stand back cause on large boards this MAY time out since it will go through all the posts looking for IP addresses of the poster and matching that up where it can to the User and if an anon it won;t spit out a Username.

I ran this query and it came up with errors:<br /><br />SELECT `U_Username`, `U_Group`, `U_RegIP`, `B_IP`, `B_PosterId`<br />FROM `w3t_Posts`, `w3t_Users`<br />WHERE (((`B_IP` = '199.253.23.1') AND (`B_PosterId` = `U_Number`)) OR (`B_IP` = '199.253.23.1'))<br /><br />The IP listed is the one in question from my site.<br /><br />Here are the errors that were returned:<br /><br />SQL ERROR: Unable to do_query: SELECT `U_Username`, `U_Group`, `U_RegIP`, `B_IP`, `B_PosterId` FROM `w3t_Posts`, `w3t_Users` WHERE (((`B_IP` = '199.253.23.1') AND (`B_PosterId` = `U_Number`)) OR (`B_IP` = '199.253.23.1'))<br />Unknown column 'U_Group' in 'field list'<br />Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/smoknz28/public_html/ubbthreads/mysql.inc.php on line 167<br /><br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/smoknz28/public_html/ubbthreads/mysql.inc.php on line 133

SELECT `U_Username`, `U_Groups`, `U_RegIP`, `B_IP`, `B_PosterId` <br />FROM `w3t_Posts`, `w3t_Users` <br />WHERE (((`B_IP` = '199.253.23.1') AND (`B_PosterId` = `U_Number`)) OR (`B_IP` = '199.253.23.1')) <br /> <br /> <br />sorry I typoed.. U_Group should be U_Groups

I've got a question:<br /><br />I imported a ubb.classic to threads. Because of an issue with custom forum headers I needed to empty the posts table and re-import them. Now all posts have the person who posted the message as 'unregistered':<br /><br />http://www.praisecafe.org/forum/ubbthreads.php<br /><br />Is there a way to re-associate the poster within the post with the actual user profile?<br /><br />note: this is a test forum, we plan to do this actually on a live site for someone else...

<img src="http://www.ubbdev.com/forum/images/graemlins/crazy.gif" alt="" /><br />Not sure how that can be done on a large scale. But to do it individually to a post - this is the query to use:<br /><br />UPDATE w3t_Posts<br />SET B_Reged = 'y',<br />B_PosterId = number<br /><br /><br />B_Reged is set to 'y' for "yes" meaning they are registered and B_PosterId is the user number.<br /><br />The name is being stored in the B_AnonName field - I'm not sure if there's a way to do a query which matches them up and would let you update the whole thing at a time. <img src="http://www.ubbdev.com/forum/images/graemlins/crazy.gif" alt="" />

Allen - untested, but name the attached .php and put it in your threads directory - and give it a run. See if it updates the posts to match the user database.

Done! 3 post records updated!<br /><br /><img src="http://www.ubbdev.com/forum/images/graemlins/tongue.gif" alt="" /> Thanks, not sure why it's only fixing 3 <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> Maybe the posters aren't 'anon', just unregged, sorta like someone who gets banned or deleted?

OK - so it kinda worked but didn't update everything. Let me tweak it a bit. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

Allen - alter the first query to be like this:<br /><br /><br /><br />See if that does more. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

Done! 29763 post records updated!<br /><br /><img src="http://www.ubbdev.com/forum/images/graemlins/yay.gif" alt="" /><br /><br />OK, it works... if I try it on the other site with 400k posts it might kill the server, I'll give it a shot late at night <img src="http://www.ubbdev.com/forum/images/graemlins/tongue.gif" alt="" />

he he<br />Yeah, it's not exactly "efficient" - but it works. <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" /><br /><br />If the above times out - it shouldn't hurt to simply run it again - as each time it's grabbing anonymous posts and processing them. So if you have to rerun it, it'll just keep picking anonymous posts and looking up the user.<br /><br /><br />Also - the last little tidbit will be to update post counts (counting up all their posts) so that their profile is correct. I'll make you a separate little script for that. So that after you're done, you can run that and then the user's post counts will be correct. <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" />

Allen - try this script (untested) to update everyone's post counts. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

sweet, worked real well <img src="http://www.ubbdev.com/forum/images/graemlins/peace.gif" alt="" />