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!

[l3vi]

Originally Posted by rb290

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;

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.

[l3vi]

Originally Posted by Reeve of shinra

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

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

[rb290]

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

[Paul M]

Originally Posted by l3vi

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']

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.

[Enthonia Tech]

Thanks A Lot!

[l3vi]

hehe thanks Paul,

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

[Skitzzo]

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.

[YOimYO]

awesome !!!!

[zylstra]

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!

[lazytown]

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

-vissa