PDA

View Full Version : Reputation comment in post - karma for 3.5

l3vi
16 Dec 2005, 01:08
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
16 Dec 2005, 02:11
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
16 Dec 2005, 03:07
Hi, could i get a better description as well as a screenshot :P


jk :D

sounds nice :)


Ill test it out :D



thx ;)
Ravage1
16 Dec 2005, 03:34
it is okay, not very impressive, but it works.....
l3vi
16 Dec 2005, 03:45
Thanks guys,

first time around on all this. ;p

Its been updated!
l3vi
16 Dec 2005, 03:46
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
16 Dec 2005, 05:46
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
16 Dec 2005, 06:08
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
16 Dec 2005, 06:23
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
16 Dec 2005, 07:51
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 ?


everyone can see it.
l3vi
16 Dec 2005, 07:55
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
16 Dec 2005, 08:03
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
16 Dec 2005, 09:12
what do the queries do ?
make it run slower or ???
Paul M
16 Dec 2005, 10:06
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 (http://www.vbulletin.org/forum/showthread.php?s=&threadid=91685)" hack which you obviously must have installed.
Enthonia Tech
16 Dec 2005, 12:43
Thanks A Lot! :)
l3vi
16 Dec 2005, 17:03
hehe thanks Paul,

I have updated the script so that it has no limit, should run in a standard board now. ;p
Skitzzo
16 Dec 2005, 17:41
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
28 Dec 2005, 00:52
awesome !!!! :D
zylstra
02 Jan 2006, 05:42
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!
vissa
03 Feb 2006, 03:52
Can this be made anonymous (unless the user chooses to write their handle in the comment)?

-vissa
Lord Brar
05 Feb 2006, 14:03
Excellent work! Thanks :)
HHU
08 Mar 2006, 23:10
Would be great to be able to turn it on / off for specific forums... other then that nice owrk
Borgs8472
08 Mar 2006, 23:17
^ ^
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
23 Jul 2006, 00:40
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
23 Jul 2006, 00:57
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
23 Jul 2006, 01:06
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!
Chicago_VLNU_4s
28 Jul 2006, 07:12
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?
realraptor
01 Aug 2006, 15:18
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
15 Aug 2006, 00:52
will this be updated for 3.6? I really enjoyed this hack, but it doesn't work properly on an upgraded forum.
dxguru
15 Aug 2006, 08:34
I just upgraded to 3.6, redid the template change and reinstalled the product ... works fine :)
Partsking
25 Aug 2006, 21:15
Anyone else having issues with people injecting html code in the comments?
xtrass
11 Nov 2006, 05:14
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
26 Jan 2007, 11:22
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: <!-- / message -->

ADD THIS AFTER IT:

<!-- #### SHOW REPUTATION GIVEN IN POST START - BY LEVI THORNTON #### -->
<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>
<!-- #### SHOW REPUTATION GIVEN IN POST END - BY LEVI THORNTON #### -->
jimbocook
12 Feb 2007, 03:00
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 Jun 2007, 00:15
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
04 Jul 2007, 06:06
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
04 Jul 2007, 07:33
Oh ... thatīs a good Idea. Thx!
ColdSpirit
14 Jul 2007, 02:18
this work in vb3.6.7? or there is any mod like this for 3.6.7??
thanks in advance!!
Piccante
19 Jul 2007, 21:42
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
19 Jul 2007, 22:04
it works on 3.6.7PL i've seeen it on some sites
ColdSpirit
19 Jul 2007, 22:07
there is any mod/hack similar to this one?
Atwal
19 Jul 2007, 22:10
I just added it as a test and it works fine
music legend
30 Jul 2007, 00:59
i got it working on 3.6.8
Stifler
02 Sep 2007, 08:32
i got it working on 3.6.8
care to share how?
rayphua
02 Sep 2007, 11:22
Works on 3.67 as well. Cheers.
jmurrayhead
23 Nov 2007, 21:32
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
19 Jan 2008, 11:35
Hm..., i use 3.6.8, but it dont work :(
Piccante
15 Mar 2008, 18:16
This works in 3.7.0 b6
docvader
13 May 2008, 11:34
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
29 Apr 2009, 23:38
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
30 Apr 2009, 00:08
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
05 Sep 2009, 02:12
I see this is old and now unsupported ... does anyone know if it will work with the newest 3.8 version?

Thanks :)
jmurrayhead
05 Sep 2009, 16:45
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
05 Sep 2009, 19:52
It works fine for me...
Great thanks; I will give it a shot :)

One more question ... umm ... where can I find "postbit template"?
IGLV
05 Sep 2009, 20:20
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
05 Sep 2009, 20:46
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
14 Apr 2011, 00:01
This is a wonderful idea. Nice MOD.