Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Mar 2000
Posts: 21,080
Likes: 3
I type like Navaho
I type like Navaho
Joined: Mar 2000
Posts: 21,080
Likes: 3
Did you import a second forum or something equally unusual and now have thousands of posts assigned to someone anonymous?

Well, then, apply these commands to assign them to an actual name if you want them to appear a little more friendly:

Code

UPDATE ubbt_POSTS SET USER_ID = "981" WHERE USER_ID = "1"

Code

UPDATE ubbt_POSTS SET POST_POSTER_NAME = "The Team" WHERE USER_ID = "981"

That takes care of the posts, now to the topics:

Code

UPDATE ubbt_TOPICS SET USER_ID ="981" WHERE USER_ID = "1"

Code

UPDATE ubbt_TOPICS SET USER_ID ="981" WHERE TOPIC_LAST_POSTER_ID = "1"

Code

UPDATE ubbt_TOPICS SET TOPIC_LAST_POSTER_NAME ="The Team" WHERE TOPIC_LAST_POSTER_NAME = "Anonymous"

Cleans it up a bit smile


- Allen wavey
- What Drives You?
Sponsored Links
Entire Thread
Subject Posted By Posted
Useful Threads 7.x Queries Gizmo 07/14/2007 4:34 AM
Re: Useful Threads 7.x Queries sirdude 07/14/2007 4:45 AM
Re: Useful Threads 7.x Queries Gizmo 07/14/2007 4:50 AM
Re: Useful Threads 7.x Queries AllenAyres 10/28/2007 5:52 AM
Re: Useful Threads 7.x Queries sirdude 10/28/2007 9:19 AM
Re: Useful Threads 7.x Queries AllenAyres 10/28/2007 5:46 PM
Re: Useful Threads 7.x Queries AllenAyres 10/28/2007 6:51 PM
Re: Useful Threads 7.x Queries blaaskaak 10/28/2007 7:58 PM
Re: Useful Threads 7.x Queries Gizmo 10/28/2007 11:11 PM
Re: Useful Threads 7.x Queries sirdude 10/29/2007 1:51 AM
Re: Useful Threads 7.x Queries AllenAyres 10/29/2007 4:49 AM
Re: Useful Threads 7.x Queries Gizmo 10/29/2007 7:01 AM
Re: Useful Threads 7.x Queries Ian_W 11/27/2007 3:24 PM
Re: Useful Threads 7.x Queries blaaskaak 11/27/2007 3:57 PM
Re: Useful Threads 7.x Queries sirdude 11/27/2007 6:01 PM
Re: Useful Threads 7.x Queries Ian_W 11/27/2007 7:58 PM
Re: Useful Threads 7.x Queries AllenAyres 03/26/2008 8:54 PM
Re: Useful Threads 7.x Queries AllenAyres 03/26/2008 9:09 PM
Re: Useful Threads 7.x Queries blaaskaak 03/27/2008 5:56 PM
Re: Useful Threads 7.x Queries AllenAyres 03/27/2008 6:26 PM
Re: Useful Threads 7.x Queries blaaskaak 03/28/2008 8:53 AM

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
• Shock Hosting
• Stable Host
• bluehost
• InterServer
Visit us on Facebook
Member Spotlight
Bill B
Bill B
Issaquah, WA
Posts: 87
Joined: December 2001
Forum Statistics
Forums63
Topics37,583
Posts293,955
Members13,825
Most Online151,614
Nov 14th, 2025
Today's Statistics
Currently Online 6968
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 7
Top Posters
AllenAyres 21,080
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,834
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2026 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20260108)