Previous Thread
Next Thread
Print Thread
Hop To
#43364 12/04/2004 7:06 AM
Joined: Aug 2004
Posts: 460
Addict
Addict
Joined: Aug 2004
Posts: 460
Is there a reason why member titles aren't showing up for all users? Seems like newer users have the titles properly assigned while users registered before the import from UBBC don't have anything displayed.

Is there a simple MySQL command to reset this so that the proper titles show up for all users?

#43365 12/06/2004 11:11 AM
Joined: Jun 2006
Posts: 58
M
journeyman
journeyman
M Offline
Joined: Jun 2006
Posts: 58
You would have to manually update the user titles based on their post totals. The option to cascade this through the database was removed with 6.5.

UPDATE w3t_Users SET U_Title='bob' WHERE U_Totalposts > 100

Start with your lowest post title, and work to the largest. You will need to run this SQL command for each title you use. That should fix the blank title problems.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Who's Online Now
2 members (Ruben, ahmed047), 799 guests, and 143 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240501)