Public Display of Affection (reputation display)

Allow your users to easily "agree" or "disagree" with a post-- rather than having them make a whole new post, you can simply use the existing reputation system.. which is meant for exactly this purpose.

Purpose: This hack makes each post's reputation visible to everyone. You can turn this on and off per forum.

Modifications: 2 additions to admincp/forum.php, 2 template additions, 1 query

Install Time: 10 minutes

Difficulty: Easy

Screenshot attached of a post with reputation comments!


cheers,

vBMechanic




EDIT: changed functions_showthread.php edit, file changed 5:49PM PST

[Borgs8472]

^ ^
thanks a lot!

[IceFanatic]

Would there be any way to alter this hack so that users can turn it on or off for their posts/comments? So if one user doesn't want their rep (given or received) shown publically they can turn it off. Any way to do that easily? Or would that be too difficult...

[subnet_rx]

this is a great hack, I'd love to see it updated with some of the features listed here.

[nintendo]

With this hack, members can now post HTML in the reputation. Great way to generate abuse.

[Citizen E]

Has anyone gotten this mod to work for 3.0.7?

[johnn]

Datenbankfehler in vBulletin 3.0.2:

Ungueltige SQL-Abfrage: SELECT reputation.reputation,reputation.whoadded,reputati on.reason,user.username
FROM vb_reputation
LEFT JOIN vb_user ON reputation.whoadded=user.userid
WHERE reputation.reputation!=0 AND postid='22'
mysql error: Unknown table 'reputation' in field list

mysql error number: 1109

I'm getting pretty much the same problem. Could someone be so kind as to please tell me how to fix this?

[johnn]

Nevermind. I figured it out on my own, but I figured I'd go ahead and post the solution here as some other person had the same problem and no one answered them.

if ($reps = $DB_site->query("SELECT reputation.reputation,reputation.whoadded,reputati on.reason,user.username
FROM " . vb3_ . "reputation AS reputation
LEFT JOIN " . vb3_ . "user AS user ON reputation.whoadded=user.userid
WHERE reputation.reputation!=0 AND postid='".$post['postid']."'"))

Use that, and where it has the 2 instances of "vb3_" put your own table prefix there, if you have one (which you likely do). You can find what your table prefix is, if you don't know it, in your "includes/config.php" file.

That should work.

[Citizen E]

Anyone get this to work with 3.0.8?

[Noodles24]

Originally Posted by Citizen E

Anyone get this to work with 3.0.8?

Yup, if you're using the legacy display, you need to add the
<div>$post[affection]</div> in the legacy postbit too (took me a while to find)

[Jedi Blaze]

Will this work with 3.5 or does it need code changes.