vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Show Thread Enhancements - Post Ranking System (https://vborg.vbsupport.ru/showthread.php?t=203801)

FullyTested 01-31-2009 10:00 PM

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)

Jon Tolzien 02-01-2009 05:59 AM

no files are their... Did i miss something?

rob01 02-01-2009 06:12 AM

i will tag it, but how much resources this mod uses (queries, and so on)?

Andyrew 02-01-2009 06:36 AM

I'm getting database errors when i click on any of the high or low ranked options in ACP

Invalid SQL:

SELECT lowest, postranktotals.userid, user.username
FROM vb3_postranktotals
INNER JOIN vb3_user AS user ON(postranktotals.userid = user.userid)
WHERE lowest > 0
ORDER BY lowest DESC, user.username
LIMIT 0, 50;

MySQL Error : Unknown column 'postranktotals.userid' in 'field list'

Also if i click on the ranked numbers on some ones profile page i get

Invalid User specified. If you followed a valid link, please notify the administrator

Would be good to put an option to turn this mod on or off in settings.

I have disabled the product for the moment.

tranceup 02-01-2009 08:38 AM

run 3.7 ?

adhmwagde 02-01-2009 10:24 AM

Hello man ... nice work but README File is empaty " Mac OS X 2 y ? SMLdSMUL ATTR ء ? œ œ com.apple.TextEncoding UTF-8;134217984 "

also the ranking come without images ... i upload the images in misc but i didn't see in the posts ..

and we have

PHP Code:

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 hide_post = 0, highlight_post = 0' at l
Error Number  
1064 

this come if you want to change " Post Rank Hide Post " in profile also if i try to ranking in the subject i didn't see the numbers changed in the profile or in the post look my screen

thanks

FullyTested 02-01-2009 01:11 PM

I have changed the attached zip file to one created on a Windows OS.
Previous version was by a Mac.

I hope this will solve the problem.

adhmwagde 02-01-2009 02:09 PM

Quote:

Originally Posted by FullyTested (Post 1730844)
I have changed the attached zip file to one created on a Windows OS.
Previous version was by a Mac.

I hope this will solve the problem.


thanks to change the attach .. but still i have the same problem ... :(

TalkTemplate 02-01-2009 02:21 PM

looks nice i will try it!

Vaupell 02-01-2009 03:41 PM

tagging this, but waiting for some succes stories. ;)

furst 02-01-2009 04:54 PM

Quote:

Originally Posted by Vaupell (Post 1730995)
tagging this, but waiting for some succes stories. ;)

Likewise.

Andyrew 02-01-2009 04:58 PM

I'm still getting the same errors with new download. :(

AzzidReign 02-01-2009 05:43 PM

Sorry man, I still haven't tested it out yet :( I've been really busy but hopefully can get to it this week. Is this an updated version or should I still use the one you sent me?

FullyTested 02-01-2009 05:46 PM

Quote:

Originally Posted by AzzidReign (Post 1731116)
Sorry man, I still haven't tested it out yet :( I've been really busy but hopefully can get to it this week. Is this an updated version or should I still use the one you sent me?

The one I sent you is too old. Please use this one.

FullyTested 02-01-2009 05:48 PM

Quote:

Originally Posted by Andyrew (Post 1731074)
I'm still getting the same errors with new download. :(

Hi Andyrew,

I've made a couple of small changes which I hope will solve the problem.
Please re-FTP the files and re-import the product.

Thanks.

Ryuk 02-01-2009 05:49 PM

i will keep an eye on this.

FullyTested 02-01-2009 05:50 PM

Quote:

Originally Posted by adhmwagde (Post 1730759)
this come if you want to change " Post Rank Hide Post " in profile also if i try to ranking in the subject i didn't see the numbers changed in the profile or in the post look my screen

Anyone else getting this error?

Andyrew 02-01-2009 06:22 PM

Quote:

Originally Posted by FullyTested (Post 1731121)
Hi Andyrew,

I've made a couple of small changes which I hope will solve the problem.
Please re-FTP the files and re-import the product.

Thanks.

There are duplicate files in the zip many start with ._

FullyTested 02-01-2009 06:39 PM

Quote:

Originally Posted by Andyrew (Post 1731154)
There are duplicate files in the zip many start with ._

How about now?

Andyrew 02-01-2009 06:44 PM

Quote:

Originally Posted by FullyTested (Post 1731174)
How about now?

Fine now. :up: and all my errors have gone. :)

Just have to wait for users to start ranking and see what happens. ;)

FullyTested 02-01-2009 06:47 PM

Please keep me posted.
Thanks.

Cryo 02-01-2009 06:50 PM

I've been looking for something like this for sometime. Going to try it out, we'll see how it goes.

/me installs.

Cryo 02-01-2009 08:16 PM

OK, I installed it and everything seems to work well, however I have encountered a bug. Ever since installing the AJAX on quick reply no longer works. When I make a post, it goes to a redirect page instead of instantly updating the thread. I disabled the ranking system just to see if it was the mod causing the issue, and as soon as I did quick reply worked correctly again.

Any ideas?

furst 02-01-2009 08:43 PM

Any idea if it works on 3.7?

FullyTested 02-01-2009 10:01 PM

Quote:

Originally Posted by Cryo (Post 1731281)
Ever since installing the AJAX on quick reply no longer works.

Thanks for reporting the problem.
Version 1.2 should fix this issue.

FullyTested 02-01-2009 10:02 PM

Quote:

Originally Posted by furst (Post 1731313)
Any idea if it works on 3.7?

It should work just fine, but have not yet tested it on 3.7

sasukewuff 02-01-2009 10:12 PM

Working perfectly fine in vB 3.8.1... Thanks

KevinL 02-01-2009 10:16 PM

I am going to have to keep a close eye on this one :)

Vaupell 02-01-2009 11:11 PM

eek the readme is just one long line.. wtb formating.

Attachment 93890

i got a few extra enter keys if you need one :p JK
howewer suggest u make ur readme as a html file
like many others then you dont have to worry about
how it looks for others, always the same then :D

really hard to see / read modifications :P

got it installed, testing it out for a few days ;)

PamelaE 02-01-2009 11:32 PM

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.

tefon 02-02-2009 12:56 AM

hi pls help me.

ERROR :
https://vborg.vbsupport.ru/

Cryo 02-02-2009 02:53 AM

Quote:

Originally Posted by FullyTested (Post 1731364)
Thanks for reporting the problem.
Version 1.2 should fix this issue.

Fixed it, thanks!

Quote:

Originally Posted by PamelaE (Post 1731431)
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.

FullyTested 02-02-2009 03:42 AM

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.

JermaineBelgard 02-02-2009 06:50 AM

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

Vaupell 02-02-2009 08:07 AM

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.. :(

FullyTested 02-02-2009 08:25 AM

Quote:

Originally Posted by Vaupell (Post 1731676)
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.

FullyTested 02-02-2009 08:26 AM

Quote:

Originally Posted by JermaineBelgard (Post 1731644)
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?

Leo Brazil 02-02-2009 08:36 AM

It looks very promissing.

I'm tagging this for future.

Thanks

Edited: Installed and working great.

JermaineBelgard 02-02-2009 09:42 AM

Quote:

Originally Posted by FullyTested (Post 1731685)
What version of MySQL are you using?

4.0.27.

FullyTested 02-02-2009 09:53 AM

JermaineBelgard, I'm afraid you will have to upgrade to MySQL 4.1.0 in order to use this mod.


All times are GMT. The time now is 07:13 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01474 seconds
  • Memory Usage 1,839KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (15)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete