Given Reputations Trackback

Hello, this if my first mini-hack, and I hope it could help out somebody. I did not do a thorough search if anyone has posted something exactly like this (which is quite likely since this is a fairly simple hack), so please forgive me if it already exists. I just thought I could share my codes for those who need it.


Introduction:
I was originally trying the hack at https://vborg.vbsupport.ru/showthread.php?t=61518 , which was released by vbmechanic. Ran into some weird looping problems like how someone mentioned at the second page, but manage to fix it anyway. While fixing the error, and thinking of adding more info to the trackback, I came out with my own version.

This is completely independent of vbmechanic's hack however.


What it does
This hack adds another list for the Latest Reputation Given to other members by yourself that is identical to the original Latest Reputation Received table. You can have a look at the screenshot included and it will explain everything much better.


Changes to your vBulletin:
1 extra query on usercp.php
1 template change
1 new small template
1 new phrase

This would take only a maximum of 5 mins to finish installing.


Installation:
Instruction is included as a text attachment.


Changes Log:
05-11-2004 Found a bug in the link that points to the profiles of the recipients of the given points. Fixed with instructions posted below. The existing instruction text file has also been replaced with an updated version.

01-11-2004 Changed the header of "Posted By" to "Posted To" under template USERCP for the Latest Reputation Given table. It's located at step 4, line 139 of the textfile included.

31-10-2004 I have completely re-done this hack to separate the listing of reputations received and given as requested

30-10-2004 Added the simple hack here.

[rex_b]

*installed

[Jing]

thank you rex_b.

sorry wordforge, I don't think I am going to change my hack to extend the list. Maybe someone else can help you.

[Loxias]

Originally Posted by Jing

Loxias: You can see the reputations given to other members, as well as reputations received from other members.

I don't suppose there's a condition I could add to have who you've given rep to visible to only yourself and not others? I have my forum setup to hide who gives reputation from members to avoid conflict and this hack would negate that setting, but my members would really like to be able to see who they've last given rep to.

[Jing]

Nope, this would not negate that setting. It would not change any of your current settings because this hack adds additional lines to the script for its own function and do not borrow the current codes or interfere with the existings codes, and thus will not mess up the original settings.

[Paul M]

Originally Posted by wordforge.net

^ ^
nah, I'm interested in more complete listings with comments, not just the last 10 of them...

In this version, or my version (see above), just change the LIMIT part of the SQL statement to LIMIT 0, nn where nn is the number of comments you want to see. Jing's currently uses the ACP option as it's limit, mine is hard coded to 10.

[Roms]

<i>*installed</i>

[Jing]

thank you infantrymen.

wordforge: yup, you can do it like Paul M suggested. Or you can just change from ACP to include a large number so it would show up every one of them. Just that I do not think that vBulletin included a "page" feature for reputations, so I don't think it's a good idea.

[Jing]

I have found a bug with the link of the nicknames not pointing at members' profile, but to self's profile instead. Here's a fix. Only two words are changed here, so it shouldn't be hard. This is not a security fix so you can skip it if you do not wish to go thru the tiny bit of hassle. I apologize for any inconvenience caused.



At usercp.php, look up for...

	// START REPUTATION HACK
	$reputations2 = $DB_site->query("
		SELECT
			user.username, reputation.whoadded,
			reputation.postid as postid,
			reputation.reputation, reputation.reason,
			post.threadid as threadid,
.
.
.

change the bolded and underlined text to the following

	// START REPUTATION HACK
	$reputations2 = $DB_site->query("
		SELECT
			user.username, reputation.userid,
			reputation.postid as postid,
			reputation.reputation, reputation.reason,
			post.threadid as threadid,

At template usercp_reputationbits2, look up for

<tr>
	<td class="alt2"><img src="$stylevar[imgdir_reputation]/reputation_$posneg2.gif" border="0" alt="" /></td>
	<td class="alt1Active" id="p$reputation2[postid]" width="50%"><a class="smallfont" href="showthread.php?$session[sessionurl]p=$reputation2[postid]#post$reputation2[postid]">$reputation2[title]</a></td>
	<td class="alt2" nowrap="nowrap"><span class="smallfont">$reputation2[dateline] <span class="time">$reputation2[timeline]</span></span></td>
	<if condition="$vboptions['showuserraters']">
	<td class="alt1" nowrap="nowrap"><a class="smallfont" href="member.php?$session[sessionurl]u=$reputation2[whoadded]">$reputation2[username]</a></td>
	</if>
	<td class="$reputationbgclass2" width="50%"><span class="smallfont">$reputation2[reason]</span></td>
</tr>

and change to the following...

<tr>
	<td class="alt2"><img src="$stylevar[imgdir_reputation]/reputation_$posneg2.gif" border="0" alt="" /></td>
	<td class="alt1Active" id="p$reputation2[postid]" width="50%"><a class="smallfont" href="showthread.php?$session[sessionurl]p=$reputation2[postid]#post$reputation2[postid]">$reputation2[title]</a></td>
	<td class="alt2" nowrap="nowrap"><span class="smallfont">$reputation2[dateline] <span class="time">$reputation2[timeline]</span></span></td>
	<if condition="$vboptions['showuserraters']">
	<td class="alt1" nowrap="nowrap"><a class="smallfont" href="member.php?$session[sessionurl]u=$reputation2[userid]">$reputation2[username]</a></td>
	</if>
	<td class="$reputationbgclass2" width="50%"><span class="smallfont">$reputation2[reason]</span></td>
</tr>

That's all. An updated text file has been uploaded to replace the current one, so new users will not be affected.

[DjTaz]

Thanks for this - works a treat. One of my members was looking for it as well

[Jing]

welcome