Previous Thread
Next Thread
Print Thread
Hop To
Top Posters Island #223491 03/03/2009 4: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

Express Hosting
Re: Top Posters Island [Re: Softrak] #223492 03/03/2009 4:41 PM
Joined: Dec 2003
Posts: 5,898
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,898
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 5: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 5:18 PM
Joined: Dec 2003
Posts: 5,898
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,898
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 5:20 PM
Joined: Jun 2006
Posts: 15,834
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,834
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? [virtualnightclub.net]
Forums: A Gardeners Forum [agardenersforum.com] Scouters World [scoutersworld.com]
UBB.threads: UBBWiki [ubbwiki.com], UBB Styles [virtualnightclub.net], UBB.Sitemaps [virtualnightclub.net]
Longtime Supporter & Resident Post-A-Holic
VNC Web Services [virtualnightclub.net]: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Top Posters Island [Re: Gizmo] #223502 03/03/2009 5: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 6:22 PM
Joined: Dec 2003
Posts: 5,898
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,898
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 6:32 PM
Joined: Jun 2006
Posts: 15,834
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,834
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? [virtualnightclub.net]
Forums: A Gardeners Forum [agardenersforum.com] Scouters World [scoutersworld.com]
UBB.threads: UBBWiki [ubbwiki.com], UBB Styles [virtualnightclub.net], UBB.Sitemaps [virtualnightclub.net]
Longtime Supporter & Resident Post-A-Holic
VNC Web Services [virtualnightclub.net]: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Top Posters Island [Re: Gizmo] #223515 03/03/2009 7:03 PM
Joined: Apr 2007
Posts: 3,944
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,944
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 2:33 PM
Joined: Jan 2007
Posts: 72
Softrak Offline OP
journeyman
OP Offline
journeyman
Joined: Jan 2007
Posts: 72
Ok great thanks a lot.


Additional Community Resources
UBB Developers
UBB Wiki
ShoutChat Box
Recent Topics
Error Messages - What to do???
by Daryl Fawcett - 06/20/2019 9:05 AM
Forum - Left Alignment / Margin?
by keysolutns - 06/19/2019 9:58 AM
Forum Not Working after Cpanel upgrade.
by doug - 06/14/2019 2:35 PM
YouTube does not display?
by BlackMale - 06/09/2019 6:34 AM
Removing a redirect?
by Baldeagle - 06/01/2019 4:50 PM
Who's Online Now
2 registered members (isaac, JAISP), 48 guests, and 264 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
M4TT
M4TT
Canada, SK
Posts: 87
Joined: March 2015
Show All Member Profiles 
Forum Statistics
Forums35
Topics35,304
Posts192,587
Members11,855
Most Online978
Jun 24th, 2007
Random Gallery Image
Latest Photos
The Sky
Land Rocks
Cozy Places
Trees
Powered by UBB.threads™ PHP Forum Software 7.7.2
(Snapshot build 20190623)