The Arcive of Official vBulletin Modifications Site.

Post Ranking System · **Released**: 01-31-2009

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:

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.
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'.
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)

Macindy · #**252** 03-22-2009, 08:21 AM

Quote:

Originally Posted by FullyTested

pete_brady,

if you have MySQL 4.1.0 or higher:

INSERT INTO postrank_useroptions (userid, highlight_post, hide_post) SELECT userid,1,1 FROM user ON DUPLICATE KEY UPDATE highlight_post = 1, hide_post = 1

Why must be the values set by sql-entries. Can not the default be to hide posts/hightlight posts?
What is with new registered users?

Great plugin!!

webuser00 · #**253** 03-28-2009, 01:13 AM

Is there a way to show how many ups and down votes there are on forumdisplay? that way a user can see if the thread was highly/low rated

let me know

FullyTested · #**254** 03-28-2009, 11:36 AM

Quote:

Originally Posted by Macindy

Why must be the values set by sql-entries. Can not the default be to hide posts/hightlight posts?

Because it saves creating a table entry for every user.

Quote:

Originally Posted by webuser00

Is there a way to show how many ups and down votes there are on forumdisplay? that way a user can see if the thread was highly/low rated

No such option at the moment I'm afraid

peyman.nt · #**255** 03-31-2009, 06:51 AM

Is it possible to add rating system like "thread rating" with five stars for each post?

AzzidReign · #**256** 03-31-2009, 11:50 PM

Can this be integrated into the reputation system? If so, can you make it so we can manually change the values for each + or - ?

paul41598 · #**257** 04-02-2009, 03:54 PM

When doing a search by rank:

PHP Code:


			
Database error in vBulletin 3.8.1:



Invalid SQL:



        SELECT COUNT(DISTINCT(userid)) AS count

        FROM postranktotals AS postranktotals

        INNER JOIN user AS user using(userid)

        WHERE postranktotals. high > 0

        LIMIT 1;



MySQL Error   : Column 'userid' in field list is ambiguous

Error Number  : 1052

Request Date  : Thursday, April 2nd 2009 @ 12:54:33 PM

Error Date    : Thursday, April 2nd 2009 @ 12:54:33 PM

pete_brady · #**258** 04-02-2009, 07:35 PM

suggestion: An option to disemvowel low score posts?

dutchbb · #**259** 04-03-2009, 08:42 AM

Doesn't seem to be working... when I click + or - it turns grey and nothing is counted?

I'm using 3.8.1 Patch Level 1.

dutchbb · #**260** 04-04-2009, 08:31 AM

bump?

Macindy · #**261** 04-06-2009, 11:21 AM

Quote:

Originally Posted by dutchbb

bump?

I found another bug:
If you deactivate statistics in the profile/postbit the horizontal line is away.
Is there a conditional false?

and have a wish:
Can you also set the the settings "hightlight/hide posts" per default (without query) - if we give the user the option to decide by himself in the cp.

Thanks macindy

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05707 seconds Memory Usage 2,320KB 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 (1)bbcode_php (4)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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!