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

Reply
 
Thread Tools
Post Ranking System Details »»
Post Ranking System
Version: 2.5, by FullyTested FullyTested is offline
Developer Last Online: Apr 2014 Show Printable Version Email this Page

Category: Show Thread Enhancements - Version: 3.8.x Rating:
Released: 01-31-2009 Last Update: 03-19-2009 Installs: 188
DB Changes Uses Plugins Auto-Templates
Additional Files Translations  
No support by the author.

Post Ranking System
by FullyTested

This product does not modify any VB MySQL tables and thus can be used by all forums regardless of whether they have three thousand posts or three million posts in their database.
Also, no manual template edits.

In A Nutshell:
  1. This product provides the ability to track the quality of post contributions made by your registered members.
    Each member's rank totals may be displayed (and are searchable) via the postbit template and/or public profile page.
  2. Each post may be ranked 'up' (+1 point) or 'down' (-1 point) by your registered members. Each member may only do this once per post.
    This is done via AJAX if the viewer's browser has JavaScript enabled, or via a link, if not.
    Once a post has reached a certain point threshold (value is set via AdminCP), it's rank changes accordingly.
    All posts start as 'Neutral'.
    Positively ranked posts may have their rank changed to 'Highly Ranked' or 'Highest Ranked'.
    Negatively ranked posts may have their rank changed to 'Lowly Ranked' or 'Lowest Ranked'.
  3. Whenever a post has its rank changed, the post creator has his/her rank totals updated accordingly.
Available Options:
  • Rank threshold values may be changed at any time., Rank totals are then updated accordingly.
  • Each rank can have it's own text colour.
  • Each user has the option to have 'Lowest' ranked posts hidden in a collapsed state (same as the ignore postbit). This option is turned on via the User CP thread display options.
  • Each user has the option to have 'Highest' ranked posts highlighted to destinguish them from the rest of the posts in the thread. This option is turned on via the User CP thread display options.
  • Ability to globally force the above highlighted/hidden posts on all users.
  • Option to have extremely lowly ranked posts auto 'soft' deleted. If post is subsequently undeleted, it's rank will revert to 'Neutral'.
  • Ability to email mods upon auto deletion of a post.
  • Selection of usergroups that may not rank posts.
  • Selection of usergroups who's posts cannot be ranked.
  • Exclude specific forums from post ranking.
  • Ability to include/exclude rank name ('Highest Ranked') in postbit
  • Ability to include/exclude rank score (+10/-5) in postbit
  • Display user's post rank totals within the postbit template.
  • Display user's post rank totals within the public profile page.
  • Search for posts of a certain rank, which belong to a specific member, via the postbit or public profile page.
  • Display total count, and search for, posts of a certain rank via the 'Post Ranking System' menu in AdminCP.
  • Manage votes by User or Post via Admin CP.
  • Statistics page where top posts and top posters are displayed. This page may be limited certain usergroups.
  • Ability to set a cut-off date (in days). Posts older than x number of days cannot be ranked.
Accountable Actions
  • Post delete (soft and physical) // rank totals decrement
  • Post undelete // rank totals increment
  • Post mergers // rank totals decrement as post may no longer reflect original content on which it was ranked
  • Thread delete (soft and physical) // rank totals decrement
  • Thread undelete // rank totals increment
  • User mergers // ranks transferred to new user
  • User delete // voted upon post ranks updated., tables cleared of said user
To Install:
Please see the 'ReadMe' file for installation instructions.
Installing this mod should take no longer than 5 minutes.

Version 2.5
Fixed small bug with the stats page.
Added the ability to have the score and rank images display in a separate line when default setting is to not have the thread title in every post.
The following files have changed:
- postrankstats.php (please re-FTP to your server)
- product_postrank.xml (please re-import with 'Allow Overwrite' selected)

Show Your Support

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

Comments
  #32  
Old 02-02-2009, 12:56 AM
tefon tefon is offline
 
Join Date: Aug 2008
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hi pls help me.

ERROR :
Reply With Quote
  #33  
Old 02-02-2009, 02:53 AM
Cryo Cryo is offline
 
Join Date: Dec 2003
Location: Buffalo, NY
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by FullyTested View Post
Thanks for reporting the problem.
Version 1.2 should fix this issue.
Fixed it, thanks!

Quote:
Originally Posted by PamelaE View Post
Nice idea and I have just added it to my forums. But its design leaves little for the users to understand without explanation.

The main issue with this for me is that people want instant feedback, the fact the stats remain 0 on a profile is a little confusing.

It would even be nice if the user got a message to tell them that they have voted a post down or up.

It might be a nice idea to have a running tally in the stats, for example:

10 postive votes and 1 negative vote.

The other issue is that there is no room for explanation.

Not sure on this and I will see how it pans out.
Make a quick post and explain it to the members. I did that and everyone got it without problem. The point of this system isn't the individual votes, but the group votes. You have to hit thresholds for those votes to matter. On the flip side, you could make a Digg-like system where it has a "+12 Ranked" or "-2 Ranked" sort of thing instead of Highest Ranked / High Ranked / etc.
Reply With Quote
  #34  
Old 02-02-2009, 03:42 AM
FullyTested FullyTested is offline
 
Join Date: Aug 2007
Posts: 163
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

First of all I assume (we all know what that means ) that if one is capable of installing this mod, then one is also capable of opening the readme file in a text editor to read it. But, none the less, point taken and I shall convert it to html on next update.

As for showing points, I'm afraid that is not what this mod is all about. It is not about gratifying ones gathering instincts but rather a way to find out (and display if you so wish) which members are actually contributing to your forum and which are wasting your bandwidth.

Mr. 'tefon', as I am not fluent in Turkish(?), could you please be so kind as to elaborate just a tad.
Thanks.
Reply With Quote
  #35  
Old 02-02-2009, 06:50 AM
JermaineBelgard JermaineBelgard is offline
 
Join Date: Nov 2006
Location: Bergfeld, Germany
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I still receive a mysql error:

INSERT INTO xxx_postrank
(postid, posterid, rank)
VALUES
(63878, 620, 1)
ON DUPLICATE KEY UPDATE rank = rank + 1;

MySQL-Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE rank = rank + 1' at line 5
Reply With Quote
  #36  
Old 02-02-2009, 08:07 AM
Vaupell's Avatar
Vaupell Vaupell is offline
 
Join Date: Apr 2008
Location: Esbjerg, Denmark
Posts: 1,036
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hmm clicked tons of posts and had a few testers just clicking around + and -
still it says

Attachment 93901

nothind and today when i came back online
i was able to vote the same threads again..
Reply With Quote
  #37  
Old 02-02-2009, 08:25 AM
FullyTested FullyTested is offline
 
Join Date: Aug 2007
Posts: 163
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Vaupell View Post
Hmm clicked tons of posts and had a few testers just clicking around + and -
still it says
This is normal!!!

In the product settings, you can set the number of votes/clicks required before a post moves up/down a rank.
It is not recommended to set this value too low.
Reply With Quote
  #38  
Old 02-02-2009, 08:26 AM
FullyTested FullyTested is offline
 
Join Date: Aug 2007
Posts: 163
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by JermaineBelgard View Post
I still receive a mysql error:

MySQL-Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE rank = rank + 1' at line 5


What version of MySQL are you using?
Reply With Quote
  #39  
Old 02-02-2009, 08:36 AM
Leo Brazil's Avatar
Leo Brazil Leo Brazil is offline
 
Join Date: Dec 2007
Location: Brazil
Posts: 485
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It looks very promissing.

I'm tagging this for future.

Thanks

Edited: Installed and working great.
Reply With Quote
  #40  
Old 02-02-2009, 09:42 AM
JermaineBelgard JermaineBelgard is offline
 
Join Date: Nov 2006
Location: Bergfeld, Germany
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by FullyTested View Post
What version of MySQL are you using?
4.0.27.
Reply With Quote
  #41  
Old 02-02-2009, 09:53 AM
FullyTested FullyTested is offline
 
Join Date: Aug 2007
Posts: 163
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

JermaineBelgard, I'm afraid you will have to upgrade to MySQL 4.1.0 in order to use this mod.
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 12:44 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.10434 seconds
  • Memory Usage 2,301KB
  • 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
  • (5)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