Previous Thread
Next Thread
Print Thread
Hop To
Joined: May 2006
Posts: 169
Member
Member
Joined: May 2006
Posts: 169
Here's a fun one............ is there a way to adjust a members post count without having to do it for all the members. I know you can do a rebuild of post counts for everyone but I don't want to do that.

I've made an area of the forum that requires x amount of posts before granting access and a few new members have made garbage posts to try to circumvent the process. I do not want to allow that type of behavior because that defeats the purpose of the intent.

Quality posts not bs posts with one word.

Joined: Jun 2006
Posts: 16,289
Likes: 115
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,289
Likes: 115
Well, you could just set their post count manually through a database query:
SQL Query
UPDATE `ubbt_USER_PROFILE` SET `USER_TOTAL_POSTS` = 'numberofposts' WHERE `ubbt_USER_PROFILE`.`USER_ID` = 'uid';


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
1 member likes this: Morgan
Joined: May 2006
Posts: 169
Member
Member
Joined: May 2006
Posts: 169
Thank You, I figured out what to do with that and it worked. You da man !

Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Originally Posted by Gizmo
Well, you could just set their post count manually through a database query:
SQL Query
UPDATE `ubbt_USER_PROFILE` SET `USER_TOTAL_POSTS` = 'numberofposts' WHERE `ubbt_USER_PROFILE`.`USER_ID` = 'uid';

Gizmo do I change numberofposts and uid As in user I’d only in that query?


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Correct , lets say you want member number 666 to have 1500 posts.

SQL Query
UPDATE `ubbt_USER_PROFILE` SET `USER_TOTAL_POSTS` = '1500' WHERE `ubbt_USER_PROFILE`.`USER_ID` = '666';

I have used this in the past where say I pruned a lot of posts and then ran the re-builders.
This will cause the members of the posts to loose some on their post count.
So usually the most active members complain.
Like "Hey I used to have 4500 posts now it shows 2500 posts".
So I appease them by modifying their post count back to what it was.
Of course it would be crazy to do say 6000 members one at a time.
Let alone know what there were supposed to be.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
1 member likes this: Morgan
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Update queries are very useful for a lot of things like changing to https.
https://www.ubbcentral.com/forums/u...transition-your-forum-from-http-to-https

Or maybe you totally changed the paths due to moving the site from a sub folder to the root.
Where paths may break for such as links to other posts in the forum.
Or you decide to move or rename the folders for attachments and or avatars.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,289
Likes: 115
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,289
Likes: 115
One must be careful manually running database queries as if you mess up and don't have a backup, there is nothing we can offer by way of support.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Of course!
You should make a backup anytime you make changes.
That should be SOP


Blue Man Group
There is no such thing as stupid questions. Just stupid answers

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Forum Privacy Policy
by ECNet - 02/26/2024 11:58 AM
Who's Online Now
2 members (Geoff, domspeak), 353 guests, and 190 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 20230217)