Previous Thread
Next Thread
Print Thread
Hop To
Joined: May 2006
Posts: 133
FREAK Offline OP
Member
OP Offline
Member
Joined: May 2006
Posts: 133
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: 15,992
Likes: 45
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,992
Likes: 45
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: 133
FREAK Offline OP
Member
OP Offline
Member
Joined: May 2006
Posts: 133
Thank You, I figured out what to do with that and it worked. You da man !

Joined: Jun 2006
Posts: 823
Likes: 11
Old Hand
Offline
Old Hand
Joined: Jun 2006
Posts: 823
Likes: 11
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
http://www.britbike.com/forums/ubbthreads.php
Joined: Dec 2003
Posts: 6,248
Likes: 35
Online Yawn
Joined: Dec 2003
Posts: 6,248
Likes: 35
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,248
Likes: 35
Online Yawn
Joined: Dec 2003
Posts: 6,248
Likes: 35
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: 15,992
Likes: 45
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,992
Likes: 45
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,248
Likes: 35
Online Yawn
Joined: Dec 2003
Posts: 6,248
Likes: 35
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 Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
MySQL 5.6 upgrade to 5.7
by Morgan - 10/19/2020 6:19 AM
Errror log issues ea day
by Morgan - 10/18/2020 7:28 AM
Custom islands error
by Morgan - 10/18/2020 7:25 AM
Saved Member Searches Enhancement
by Ruben - 10/10/2020 1:17 PM
RSS Feeds
by Mors - 10/06/2020 6:44 PM
Who's Online Now
2 members (JAISP, 1 invisible), 68 guests, and 58 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5
(Snapshot build 20201014)