Previous Thread
Next Thread
Print Thread
Hop To
Top Posters Island #223491 03/03/2009 3:31 PM
Joined: Jan 2007
Posts: 72
Softrak Offline OP
journeyman
OP Offline
journeyman
Joined: Jan 2007
Posts: 72
Hi,

Is it possible to reset the count on the top posters island?

Thanks

Re: Top Posters Island [Re: Softrak] #223492 03/03/2009 3:41 PM
Joined: Dec 2003
Posts: 5,994
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,994
I guess it depends on why?
The island just shows how many posts a user has made.
If you deleted a lot of posts and it still is counting them you could run the cp>> content rebuilder>>Rebuild post count


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Top Posters Island [Re: Ruben] #223493 03/03/2009 4:13 PM
Joined: Jan 2007
Posts: 72
Softrak Offline OP
journeyman
OP Offline
journeyman
Joined: Jan 2007
Posts: 72
Ok.

See the top posters on the left in this forum... it says (30 Days) how do I do that?

Re: Top Posters Island [Re: Softrak] #223495 03/03/2009 4:18 PM
Joined: Dec 2003
Posts: 5,994
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,994
That is a new feature island as of version 7.4


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Top Posters Island [Re: Softrak] #223496 03/03/2009 4:20 PM
Joined: Jun 2006
Posts: 15,848
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,848
I think it was added in 7.4; it'd be:
CP -> Portal -> Portal Layout -> Enable the "Top Posters (last 30 days) " option.


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.
Need to Upgrade?
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!
Re: Top Posters Island [Re: Gizmo] #223502 03/03/2009 4:47 PM
Joined: Jan 2007
Posts: 72
Softrak Offline OP
journeyman
OP Offline
journeyman
Joined: Jan 2007
Posts: 72
Ok. Thanks.

Back to my original question how do I reset the post count to zero? I'm assuming the count right now is from all time.

Re: Top Posters Island [Re: Softrak] #223506 03/03/2009 5:22 PM
Joined: Dec 2003
Posts: 5,994
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,994
Never tried it so don't know how it impacts to operation of the forum. But the top poster list just pulls total posts from the user_profile table, It is not just a special field for the island. So resetting the field to zero will impact the total posts when displaying a profile as well as when viewing the user list and total posts when viewing a topic.

Maybe someone else will chime in.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Top Posters Island [Re: Softrak] #223509 03/03/2009 5:32 PM
Joined: Jun 2006
Posts: 15,848
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,848
I think the users total posts are stored in the db; so you'd update the "USER_TOTAL_POSTS" value in the "USER_PROFILE" table.


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.
Need to Upgrade?
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!
Re: Top Posters Island [Re: Gizmo] #223515 03/03/2009 6:03 PM
Joined: Apr 2007
Posts: 3,938
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,938
SQL Query
update ubbt_USER_PROFLE set USER_TOTAL_POSTS=0


zeroes them all out..

but MAKE SURE THAT IS WHAT YOU WANT!!! cuz it makes everyone have 0 posts from that point on..

they they start counting up from there..

Re: Top Posters Island [Re: SD] #223565 03/04/2009 1:33 PM
Joined: Jan 2007
Posts: 72
Softrak Offline OP
journeyman
OP Offline
journeyman
Joined: Jan 2007
Posts: 72
Ok great thanks a lot.


Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
UBB Dev
by JAISP - 11/03/2019 11:01 AM
Exceeded Number of attachments
by rbrtgrmn - 11/02/2019 9:57 PM
Forum New User Registration
by kf6zpl - 10/25/2019 10:45 AM
Having issue with redirects to UBB classic URLs
by amciotola - 10/16/2019 12:11 AM
Who's Online Now
2 registered members (isaac, JAISP), 44 guests, and 347 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)