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)

[sensimilla]

Originally Posted by FullyTested

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

No idea it was just sent into my mailbox as an error.. it was the only one so far so might be this will never happen again..

[dazkeirle]

ok, I've got it installed and is great in many areas. Going to give my forum some pizzaz.

my only comments are.

ATM highest ranked and lowest ranked are set to a score. Surely there should only be 1 highest ranked and only 1 lowest ranked on any thread, and that should be the one with the highest and lowest number of points, regardless of that number. That would make way more sense.

I can see the option to delete posts with a certain score, but in the readme you mention soft delete, hard delete etc, i see only 1 option, delete. What sort of delete is this by default?

Finally in the stats section the top query doesn't work for me i.e. "search by rank":

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 highest > 0
LIMIT 1;

MySQL Error : Column 'userid' in field list is ambiguous
Error Number : 1052
Request Date : Thursday, March 5th 2009 @ 11:53:41 AM
Error Date : Thursday, March 5th 2009 @ 11:53:42 AM
Script : http://xxx/forum/admincp/postrank.php?do=search_rank
Referrer : http://xxx/forum/admincp/postrank.php?do=search
IP Address : 81.149.131.168
Username : xxx
Classname : vB_Database
MySQL Version : 4.1.22-standard

Other than that, sweet. Well done, will keep an eye on this.

[zglows]

Thanks for the update!

[DobieGillis?]

works like a charm! Thanks!

[Teresa]

Originally Posted by 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.

Thanks! I also second inciarco's feature requests.

[vbboarder]

Thanks for the update!

Bugs Reports:
1. When a user votes, the # of votes do not update via JS in both IE7 & FF3; also in IE7 the phrase, 'you voted up' or 'you voted down', does not show via JS (but does show in FF3).

2. The stats link does not work for VBA installed in non-forum directory. You need to prepend the url with: $vbulletin->options['bburl'] . '/'

3. The search by percentile function still does not work (I'm sure the new files are uploaded). On my test forum, I have 12 entries in the postrankedby table. 1 user voted 6 times (4 ups, 2 downs) and 1 user voted 6 times (2 ups, 4 downs). In the search, I specified user has voted up (and tested down) at least 60% of the time and ranked at least 1 post. There should be 1 result for each search (voted up/down), but both show no entries.

[morrow]

This modification is now working great for me. I updated my VBSEO and the issues all seem to have gone away.

So far, no bugs found. Thanks for this nice mod.

[Teresa]

Since my last upgrade, my top 10 stats link isn't working. It's directing me to this invalid link:
http://www.guineapigcages.com/forum/...ad.php?p=#post

[FullyTested]

I am currently working on the next upgrade.

Is anyone else having IE issues?
Using IE:
1). Does the score toggle still not work?
2). Does the phrase 'You have voted Up' not show when voting?
3). Can you vote at all?

Thanks.

[inciarco]

I Confirm the Bug I Reported a Few Posts Above, about Not Switching on IE6 between the "+X Score" and the (+Y / -Z), Feature. (On FireFox and Chrome that Feature Works Fine).

When Voting it Shades and the "Alt" Text of the Shaded Voting Images say "You Voted Up" or "You Voted Down", when placing the Cursor Over the Images, on IE6 as well as on FireFox and Chrome. :up:

Also When Voting it Appears on the Left "You Voted Up" or "You Voted Down", when Placing the Vote.

It Allows to Vote Fine on IE6 and on FireFox and Chrome. :up:

The Feature For Changing the Vote Would be Nice on One of the Following Updates.

My Best Regards and Thank You Again For this Great Updates. :up: