Show Thread Enhancements - Post Ranking System

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)

[FullyTested]

Originally Posted by vbboarder

#1: The option to search users who have voted up/down X% of the time still does not work in version 2.0,

I think I know why this is. The value for minimum posts ranked by the user is currently compared against the total 'up' votes and total 'down' votes separately instead of the combined total. Will try and fix it for next update.

Originally Posted by vbboarder

#2: The statistics page works and looks awesome! However, there's 2 minor bugs relating to the Display Stats in Navbar Link. It should be hooked to parse_templates so that the link shows up in non-forum pages, and sessionurl should be used instead of sessionurl_q since you have the '?' query character in the url.

Thanks for letting me know. I shall change that accordingly.

Originally Posted by vbboarder

#3: Clicking on the "# rank" link still does not change it to "+upvote / -downvote" in IE7 (works fine in FF3).

Originally Posted by inciarco

Only One Observation (Little Bug), and it's that on Internet Explorer 6 (I don't know if on other Higher Versions Too), the "+ X rank" Link don't Change to the "+Y / -Z" Text, but on FireFox and on Chrome it does.

I think this is a well known bug with IE that has to do with display:none; and display:block; in spans
I don't have IE on my Mac but will see what I can do. Suggestions are most welcome.

Originally Posted by vbboarder

#4: There are no date or version number for the templates so VB may not be notifying users that templates need to be reverted when updating. Can you include these info in your templates xml so that we'll know if templates need to be reverted?

Will fix that.

Originally Posted by vbboarder

Provide an option to force only unregistered users for post highlighting and post hiding. I don't want to force members since they can specify their own settings, but I want to force guests since they don't have their own settings.

Will try and fix it for next update.


Thank you for the feedback and for all of you who have voted for this mod.
While this mod is far from being perfect I think it has some potential.

[vbboarder]

Feature Request: Provide a "User Votes" js-enabled link that will show the names of the users who voted up and who voted down. The userinfo area in postbit is probably too small or congested to show all the names, so you may want to use the postbit_end template hook. If not implementing by ajax, provide an option to limit the usergroups whose posts would have this feature to limit the # of extra queries.

[Teresa]

Originally Posted by vbboarder

Feature Request: Provide a "User Votes" js-enabled link that will show the names of the users who voted up and who voted down. The userinfo area in postbit is probably too small or congested to show all the names, so you may want to use the postbit_end template hook. If not implementing by ajax, provide an option to limit the usergroups whose posts would have this feature to limit the # of extra queries.

I like that idea, but would also request that that feature be secured by usergroup. Our members are really liking the fact that the voting is anonymous--which is a big distinction from the Thanks Mod. I would only want Mods/Admin to see who voted on any given post. But I would LOVE to be able to see that easily on any given post.

Feature Request: I like the Top 10 Stats. It's a good start, but we need more. We really need the ability to see ALL posts that have been voted on--that is any voting activity. Instead of hard-coded top-10, I'd like a pull-down option of how many to display or 'all' with paging. Also, with all the columns you have in the stats, we would like those columns to be sortable.

Feature Request: I'd really prefer to see a distinction between, Neutral (WITH VOTES) and Neutral (NO VOTES). Actually, "Neutral WITH VOTES" is of great interest to me, especially the higher the vote count, because those would be our controversial posts. I would prefer to have ONE MORE Category of post, called NEUTRAL, with a score of high-1 through low+1 with ANY voting activity. That way, in the member profile, members can click on their NEUTRAL total post count and go see which posts are getting any votes at all, even though they haven't moved up or down enough to trip a threshold. For example, my thresholds are 10, 5, -5, -10. I would like ALL posts with any votes and a score (including zero) between 4 and -4 to be counted as neutral. So, in addition, it should be clearer on a post when a post moves to NEUTRAL versus NO VOTES. And of course have those titles phrased as well.

Then I wouldn't need the additional report of finding all voted upon posts by user, because it would be there by default in their profile and postbit.

Thanks so much!! Loving this mod.

[Teresa]

Feature Request: We still also would like the ability for a member to change their vote. They are making some mistakes with the icons being so close together.

[FullyTested]

Hello Folks,

I will try and find the time to add features to this mod, however, while some features are relatively easy to incorporate, others are code heavy and require a lot more time to write and test.

Version 2.1 is out.
The following files have changed:
- admincp->postrank.php (please re-FTP to your server)
- clientscript->vbulletin_ajax_postrank.js (please re-FTP to your server)
- product_postrank.xml (please re-import with 'Allow Overwrite' selected)

1). Added the ability to force Un-Registered users to have posts highlighted/hidden, while keeping the Registered users' option separate
2). Added the ability to display the detailed post score (+10/-5) on the same line as the total score (+5)
3). Added the phrase 'Not Ranked' which now shows instead of 'Neutral' for posts that have no votes
4). Fixed the % search function
5). Moved the statistics page link to the 'parse_templates' hook
6). Added date and version numbers to all templates

[Teresa]

Originally Posted by FullyTested

Hello Folks,

I will try and find the time to add features to this mod, however, while some features are relatively easy to incorporate, others are code heavy and require a lot more time to write and test.

You are awesome!! I can't wait to get this uploaded! Whoohoo!

Update: Worked Great. Thanks! Looking forward to more enhancements when you can. Cheers.

[FullyTested]

Teresa,

I've just changed the score of 0 (+0/-0) to just 0 so that it looks better.
Just download again and re-import product.

[sensimilla]

I va installed latest version and now i get this error from db

MySQL Error   : Table 'mydatabase_stylwolny2.postrank' doesn't exist
Error Number  : 1146
Request Date  : Thursday, March 5th 2009 @ 10:47:59 AM
Error Date    : Thursday, March 5th 2009 @ 10:47:59 AM
Classname     : vB_Database
MySQL Version :

[FullyTested]

When do you get the error? When installing or when voting?

[inciarco]

Great Update, FullyTested. :up:

Nice New Features.

Idea For Update: As the SQL Queries of the Mod for the Top Ranking Stats cause Load to the Server, I think It'd be Nice to be able to Set What Usergroups Can See the Post Ranking Stats Page, and the other Usergroups will see a "Don't Have Permissions" Page.

I think a Field to Set the Usergroups Separated by Comma on the Mod's Options, (or the other way you are doing it for the other Options on the Mod), and an If Logic Sentence to Compare List of Authorized Usergroups with the Usergroup of the User trying to access the Top Ranking Stats would do it.

I Always Like to Save the Intensive Server Search Queries of Installes Mods for Registered Users and Not for Guests that Will Only Toy/Play with the Features and cause Unnecessary Loads on the Server.

Edit: Other Idea: It'd also be Nice to Allow Users to Select the Number (X) of Top X Ranked Posts to be Displayed on the Top Ranked Posts Page; I think that a Field can be Included on the Mod's Options to Set the Number's (X) Options of Ranked Posts, separated with commas, (like the way Admins Set the Options for Number of Posts to be Displayed on Thread's Page on vBulletin's Options), and those Options to Appear on a DropDown Field, and when Selecting the Field Browsing to Display the Page with the Top X Ranked Posts, and/or Provide a "Go" Button. (It's like on the Cybernetec's Advanced Statistics Page ).

I Hope You Can Include This Features on Your Next Update, (at least the First One of Usergroups Permissions). :up:

My Best Regards.