Reputation comment in post - karma for 3.5 [Archive]

l3vi

12-15-2005, 10:00 PM

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!

dieselpowered

12-16-2005, 12:11 AM

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

YOimYO

12-16-2005, 01:07 AM

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

jk :D

sounds nice :)

Ill test it out :D

thx ;)

Ravage1

12-16-2005, 01:34 AM

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

l3vi

12-16-2005, 01:45 AM

Thanks guys,

first time around on all this. ;p

Its been updated!

l3vi

12-16-2005, 01:46 AM

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

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.

Reeve of shinra

12-16-2005, 03:46 AM

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

rb290

12-16-2005, 04:08 AM

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 ?

rb290

12-16-2005, 04:23 AM

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

l3vi

12-16-2005, 05:51 AM

l3vi

12-16-2005, 05:55 AM

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

12-16-2005, 06:03 AM

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

12-16-2005, 07:12 AM

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

Paul M

12-16-2005, 08:06 AM

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 (https://vborg.vbsupport.ru/showthread.php?s=&threadid=91685)" hack which you obviously must have installed.

Enthonia Tech

12-16-2005, 10:43 AM

Thanks A Lot! :)

l3vi

12-16-2005, 03:03 PM

hehe thanks Paul,

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

Skitzzo

12-16-2005, 03:41 PM

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

12-27-2005, 10:52 PM

awesome !!!! :D

zylstra

01-02-2006, 03:42 AM

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

02-03-2006, 01:52 AM

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

-vissa

Lord Brar

02-05-2006, 12:03 PM

Excellent work! Thanks :)

HHU

03-08-2006, 09:10 PM

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

Borgs8472

03-08-2006, 09:17 PM

^ ^
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.

realraptor

07-22-2006, 10:40 PM

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.

l3vi

07-22-2006, 10:57 PM

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.

realraptor

07-22-2006, 11:06 PM

Chicago_VLNU_4s

07-28-2006, 05:12 AM

realraptor

08-01-2006, 01:18 PM

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.

apokphp

08-14-2006, 10:52 PM

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

dxguru

08-15-2006, 06:34 AM

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

Partsking

08-25-2006, 07:15 PM

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

xtrass

11-11-2006, 03:14 AM

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 :)

Bullibeisser

01-26-2007, 09:22 AM

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

is there something wrong ?

TO INSTALL:

Step 1; in postbit template;

Find: 

ADD THIS AFTER IT:


<if condition="$show['post_reputation_gv']">
<br>
<fieldset class="fieldset" style="border-color:#DDDDDD;">
<legend>Comments on this post</legend>
<div style="padding:12px">
$post_rep_gv
</div>
</fieldset>
</if>

jimbocook

02-12-2007, 01:00 AM

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.

JulianWolf

06-05-2007, 10:15 PM

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!

steve71

07-04-2007, 04:06 AM

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.

JulianWolf

07-04-2007, 05:33 AM

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

ColdSpirit

07-14-2007, 12:18 AM

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

Piccante

07-19-2007, 07:42 PM

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

Atwal

07-19-2007, 08:04 PM

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

ColdSpirit

07-19-2007, 08:07 PM

there is any mod/hack similar to this one?

Atwal

07-19-2007, 08:10 PM

I just added it as a test and it works fine

music legend

07-29-2007, 10:59 PM

i got it working on 3.6.8

Stifler

09-02-2007, 06:32 AM

i got it working on 3.6.8
care to share how?

rayphua

09-02-2007, 09:22 AM

Works on 3.67 as well. Cheers.

jmurrayhead

11-23-2007, 07:32 PM

care to share how?

I was able to get it to work for 3.6.8 just by following the directions in the INSTALLING.txt file.

hunter88

01-19-2008, 09:35 AM

Hm..., i use 3.6.8, but it dont work :(

Piccante

03-15-2008, 04:16 PM

This works in 3.7.0 b6

docvader

05-13-2008, 09:34 AM

It works just fine in 3.7 Gold.

Now if it can only be reworked a bit so that it doesn't require template edits.

Madmark

04-29-2009, 09:38 PM

This is cool. Is there a way to add the +/- rep points following the comment?

For example, have it display as:

"User 1 agrees: Wow! Amazing! +2"

Madmark

04-29-2009, 10:08 PM

Does anyone know how to change the font style on the comment? And got this installed on 3.6.9 with no problem at all. Thanks!

IGLV

09-05-2009, 12:12 AM

I see this is old and now unsupported ... does anyone know if it will work with the newest 3.8 version?

Thanks :)

jmurrayhead

09-05-2009, 02:45 PM

I see this is old and now unsupported ... does anyone know if it will work with the newest 3.8 version?

Thanks :)
It works fine for me...

IGLV

09-05-2009, 05:52 PM

It works fine for me...
Great thanks; I will give it a shot :)

One more question ... umm ... where can I find "postbit template"?

IGLV

09-05-2009, 06:20 PM

Great thanks; I will give it a shot :)

One more question ... umm ... where can I find "postbit template"?
OK, I think I found it in the Style Manager via the admincp, but the mod doesn't appear to be working.

IGLV

09-05-2009, 06:46 PM

OK, I think I found it in the Style Manager via the admincp, but the mod doesn't appear to be working.
OK, I got it to work ... thanks :)

InfoNirvana

04-13-2011, 10:01 PM

This is a wonderful idea. Nice MOD.

Pisces

03-17-2014, 02:21 PM

We used to have this mod installed but due to technical issuea had to upgrade to vB 4.2.
But now i does not work anymore and my users are crying for rep comments in posts as it was an easy solution for short answers for a specific post without cluttering a thread.
I looked for alternatives or a setting but really could not find anything. Does anybody know a solution? Are there plans to upgrade the plugin?