Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard

Reply
 
Thread Tools
Top xx Posters List Details »»
Top xx Posters List
Version: 3.16, by Paul M Paul M is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Version: 3.5.x Rating:
Released: 07-13-2005 Last Update: 07-07-2006 Installs: 281
 
No support by the author.

This modification is no longer available or supported.

The 3.5 version of my Top (10) Posters hack.

This has now been re-vamped for the release of version 3.xx - the hack no longer uses a seperate topposters.php file.

This hack displays a page with the Top Forum Posters for a given set of periods. Two periods are fixed ('This Month' & 'Overall') but can be turned off in the options. The other three periods are user definable (in days) - the default values are 1 day (24 hours), 7 days & 28 days. These three columns cannot be turned off.

The number of posters to be shown can also be set, the default is the top 10 posters. You can also select which usergroups are included in the count, so members in banned groups etc are not shown.

To upgrade (if you want to) uninstall version 2.xx and re-install this version. Note the url to display the page has changed.


History:

v3.01 - First public version 3
v3.02 - Fixed display error reported in post 59
v3.03 - Fixed display error reported in post 84
v3.11 - Series of additions, upgrades and settings added.
v3.12 - Updated install code to check for existing index.
v3.13 - Fixed uncached templates added in v3.11
v3.14 : Changes to display layout.
v3.15 : Minor changes, no update necessary.
v3.16 : Fixed bug in monthly totals caculation.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #72  
Old 11-07-2005, 08:12 PM
lazytown lazytown is offline
 
Join Date: Feb 2004
Posts: 503
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is a great mod! Why are you complaining?

-vissa
Reply With Quote
  #73  
Old 11-07-2005, 08:13 PM
lazytown lazytown is offline
 
Join Date: Feb 2004
Posts: 503
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I was thinking I would write a little cronjob that would run this every hour and save it as html. That way it won't hammer the server every time a user requests it. Do you think that would be a good way to reduce the load this puts on a server?

-vissa
Reply With Quote
  #74  
Old 11-07-2005, 08:28 PM
lazytown lazytown is offline
 
Join Date: Feb 2004
Posts: 503
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

One thing that would be cool is if it had another table that showed top reputations per period of time (is that even possible?)... For example, top user reputation overall, top reputation points earned in last 30 days, etc... Perhaps even a ratio between posts and reputation earned over that period of time. Is that a wacko idea? I think that would make this the ultimate top user mod.

-vissa
Reply With Quote
  #75  
Old 11-07-2005, 08:44 PM
lazytown lazytown is offline
 
Join Date: Feb 2004
Posts: 503
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Last question from me (promise). How would I remove certain forums from the postcount? I'm assuming I could change the SQL querry - but I might need a little help.

Thanks
-vissa
Reply With Quote
  #76  
Old 11-07-2005, 08:57 PM
mojahudba mojahudba is offline
 
Join Date: Oct 2005
Location: Slovakia
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i instal but dunno where its gone ? ? anyway love all your hacks
Reply With Quote
  #77  
Old 11-07-2005, 09:42 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Aftermath
Gah that's sad...
That's life I'm afraid. vB is a hobby, not a career.

I just about have time to do, and support, the stuff I do for free, and a few small paid jobs every now and then.
Reply With Quote
  #78  
Old 11-07-2005, 09:47 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by vissa
This is a great mod! Why are you complaining?
Thank you.


Quote:
Originally Posted by vissa
I was thinking I would write a little cronjob that would run this every hour and save it as html. That way it won't hammer the server every time a user requests it. Do you think that would be a good way to reduce the load this puts on a server?
I think that sounds like overkill. Unless you have a huge forum (> 1000 posts a day) and people are viewing this all the time, then the load is not going to worry you.

Quote:
Originally Posted by vissa
One thing that would be cool is if it had another table that showed top reputations per period of time (is that even possible?)... For example, top user reputation overall, top reputation points earned in last 30 days, etc... Perhaps even a ratio between posts and reputation earned over that period of time. Is that a wacko idea? I think that would make this the ultimate top user mod.
That would be a whole different hack.

Quote:
Originally Posted by vissa
Last question from me (promise). How would I remove certain forums from the postcount? I'm assuming I could change the SQL querry - but I might need a little help.
Yes, you would need to add some code to the SQL WHERE lines.
Reply With Quote
  #79  
Old 11-07-2005, 09:47 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by mojahudba
i instal but dunno where its gone ? ? anyway love all your hacks
Erm, where has what gone ?
Reply With Quote
  #80  
Old 11-08-2005, 03:52 AM
lazytown lazytown is offline
 
Join Date: Feb 2004
Posts: 503
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Paul M
I think that sounds like overkill. Unless you have a huge forum (> 1000 posts a day) and people are viewing this all the time, then the load is not going to worry you.
Well I guess we have a huge forum since we get over 1500 posts per day (sometimes 2000 or more). I guess it does depend how often it is clicked though. Mine takes about 2.5 secs when I run the top 10 posters, according to ministats.

Quote:
Originally Posted by Paul M
Yes, you would need to add some code to the SQL WHERE lines.
Any specifics?

Thanks
-vissa
Reply With Quote
  #81  
Old 11-08-2005, 04:07 AM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by vissa
Well I guess we have a huge forum since we get over 1500 posts per day (sometimes 2000 or more). I guess it does depend how often it is clicked though. Mine takes about 2.5 secs when I run the top 10 posters, according to ministats.
Yeah, that's quite slow, but my guess it that's only a small number os times pre hour, it's not a page people keep viewing minute after minute.

Quote:
Originally Posted by vissa
Any specifics?
No at the moment, but thinking about it, it will add extra joins to the queries, as well as the extra 'where' logic. Not recommended - esp on a forum your size - it would drive that 2.5 seconds up significantly.
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:19 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04638 seconds
  • Memory Usage 2,311KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (10)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete