Reputation comment in post - karma for 3.5
 

This is my first hack for vbulletin that will show user comments in the post that they gave reputation for. Very popular with the users, they eat it up.

no one ever ported the first one from 3.0. so I wrote a new one just for 3.5.

Download, unzip and read install.txt

Don't forget to click installed if you installed it!

This hack makes each post's reputation visible to everyone. please see screen shots for examples

Modifications: add a little code to postbit template and install the xml file.

Install Time: 2 minutes max

Difficulty: Easy

Screenshot attached of a post with reputation comments!

Probably would be a good idea to give a better description as well as a screenshot. I am sure you will be asked anyway :)

Hi, could i get a better description as well as a screenshot :P


jk :D

sounds nice :)


Ill test it out :D



thx ;)

it is okay, not very impressive, but it works.....

Thanks guys,

first time around on all this. ;p

Its been updated!

What where you expecting? its the same style of mod for 3.0 that no one could get around to porting, so when I moved to VB and seen no one had done it I wrote a new one.

How is it with queries? I found that the 3.0 one ran way too many extra queries so I had to remove it.

few questions

for everyone that gets commented in the thread, does it show for them all ? or does it only show the comments for the thread creator. also, can everyone see the comments or only your own ?

and when I went into a thread It gave me this:


Database error in vBulletin 3.5.2:

Invalid SQL:

SELECT user.username, reputation.reputation, reputation.reason
FROM reputation AS reputation
LEFT JOIN user AS user ON(user.userid = reputation.whoadded)
WHERE postid = 4096
ORDER BY reputation.dateline LIMIT;

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 '' at line 5
Error Number : 1064
Date : Friday, December 16th 2005 @ 01:23:14 AM
Script : http://thugonline.net/showthread.php?p=4096#post4096
Referrer : http://thugonline.net/index.php
IP Address : 69.158.161.4
Username : DOPE.MAN
Classname : vb_database

everyone can see it.

Its missing the end of the query after LIMIT should have a number.


replace: in manage plugins > edit plugin

$post_reputations_bit = $this->registry->db->query_read("
SELECT user.username, reputation.reputation, reputation.reason
FROM " . TABLE_PREFIX . "reputation AS reputation
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = reputation.whoadded)
WHERE postid = ".$post['postid']."
ORDER BY reputation.dateline LIMIT ".$this->registry->options['maxrepgv']
);

with:

$post_reputations_bit = $this->registry->db->query_read("
SELECT user.username, reputation.reputation, reputation.reason
FROM " . TABLE_PREFIX . "reputation AS reputation
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = reputation.whoadded)
WHERE postid = ".$post['postid']."
ORDER BY reputation.dateline"
);

As this is my first mod for vbull I would have to find someone with more exp to be able to tell us why your board is not getting $this->registry->options['maxrepgv']

Unless its not set in admin under reputation options.

It will run a query on each post, with one join. I have not noticed any big or small dif on my boards.

what do the queries do ?
make it run slower or ???

The answer to that is quite simple - 'maxrepgv' does not exist in default vbulletin.

It is a setting added by my "Display Reputation Given" hack which you obviously must have installed.

Thanks A Lot! :)

hehe thanks Paul,

I have updated the script so that it has no limit, should run in a standard board now. ;p

I wish I had seen this earlier... I just paid a guy for porting over a different version of this... oh well... nice hack anyway.

awesome !!!! :D

Can you add the functionality to turn the system on/off per forum?

Thanks.

On second thought forget my ridiculous comment, I don't know why I suggested it. I like the mod!

Can this be made anonymous (unless the user chooses to write their handle in the comment)?

-vissa

Excellent work! Thanks :)

Would be great to be able to turn it on / off for specific forums... other then that nice owrk

^ ^
I have the ported 3.0 version that I paid for which you can turn off by forum. PM me if you want it. Just $5.

Anyone got this working for 3.5.4? I'm using vB 3.5.4 and for some reason, only myself (Admin) seem to be able to have full functionality. Other users have their comment posted, but their usernames and "disagree/agree" do not appear.

I just ran into this bug the other week, and wrote a fix for it. I just updated it today.

The problem was that some users do not have reputation points to give so their user name was not showing. As noted it is fixed now.

Thanks for the fix!

can some1 explain this so that a total begginner like me can understand? where do i find all this other stuff at? i uploaded the .xml file, easy, now i gotta find all this other stuff? where is it at?

AdminCP > Styles & Templates > Style Manager > [your vB style] > Under "Your Style Options" select "Edit Templates" > Scroll to "Postbit Templates" and click it > Edit (click) either Postbit or Postbit Legacy or both depending on which one you are using.

Postbit legacy is where you have the username, location, postcount etc. stuff on the left of a post.

Postbit is when the poster details is on the top of a post.

will this be updated for 3.6? I really enjoyed this hack, but it doesn't work properly on an upgraded forum.

I just upgraded to 3.6, redid the template change and reinstalled the product ... works fine :)

Anyone else having issues with people injecting html code in the comments?

I'm stuck on this...

Step 2.

Upload the product via the Product Manager using the supplied XML file.

where is the Product Manager?

Newbie here on latest version.

pls provide step by step for a complete noob thx!

oK i FOUND IT!

that was easy :)

in 3.6.4 it doesnt work, Im using german version of vbull 3.6.4.

is there something wrong ?

Anyway to mod this so that the rep comments appear immediately on the page in 3.6x? As it is now, since the rep comments are added via AJAX it takes a page refresh to see them.

An easy question, that drives me mad:

Where does the word "agrees" come from? I run this Hack in german langague, so I just hardcodet the sentence "comments" in the template-change.

But I can´t find "agrees" in the langague and I can´t find it in the templates. Where can I change it?

Best wishes, Julian!

My guess would be check the XML file that comes with this hack.

Oh ... that´s a good Idea. Thx!

this work in vb3.6.7? or there is any mod like this for 3.6.7??
thanks in advance!!

Doesn't work in 3.6.7PL :(

Shame, I've just upgraded from 3.5.4 where this was one of my members' favourite features.......

it works on 3.6.7PL i've seeen it on some sites