PDA

View Full Version : Who have you given Reputation to?

vbmechanic
02-12-2004, 10:00 PM
Filling request: https://vborg.vbsupport.ru/showthread.php?t=61512


Goal: Show who has received your reputation clicks.

Files to edit: usercp.php

Templates to edit: usercp

Queries added: 1

Time to install: 5 minutes


Screenshot attached, cheers!
Link14716
02-13-2004, 03:35 PM
Installed. :)

Nice work! Here's an HTL installer for anyone who wants/needs it.
gmarik
02-13-2004, 03:35 PM
Nice one. Could you conver the point system to 5 star system?
vbmechanic
02-13-2004, 03:52 PM
Thanks..

Describe how you'd want a 5 star system to work.

To me, doesn't seem like it would be any different from changing the green dots to stars and limiting the # output to 5.
Oblivion Knight
02-13-2004, 06:46 PM
Installed, nifty mod :)
AxelF
02-13-2004, 06:51 PM
Installed this hack, would it be possible to make an enhancement to this hack so it shows, the comments you have posted, thread and date and time etc, a table just like the comments you have received etc? :)
msimplay
02-13-2004, 07:35 PM
what about who gave u clicks ?
achtungbaby
02-13-2004, 08:41 PM
Excellent work! Wow, was this created in response to my request? If so, you guys are responsive...!

Anyway, wanted to also ask: is there a way to display the reputation given in the same manner as received? That is, to be able to view your own comments, how much you gave, etc...
AxelF
02-14-2004, 07:29 AM
Excellent work! Wow, was this created in response to my request? If so, you guys are responsive...!

Anyway, wanted to also ask: is there a way to display the reputation given in the same manner as received? That is, to be able to view your own comments, how much you gave, etc...

That is more or less what I was suggesting in my post. It would be a great enhancement to this hack. ;)
Frank
02-21-2004, 11:37 PM
Installed this hack, would it be possible to make an enhancement to this hack so it shows, the comments you have posted, thread and date and time etc, a table just like the comments you have received etc? :)
That's what I'd really be interested in :)
jcr
05-04-2004, 02:47 PM
.. would it be possible to make an enhancement to this hack so it shows, the comments you have posted, thread and date and time etc, a table just like the comments you have received etc? :)

Signing this!
Anette
06-10-2004, 12:44 PM
Nice work! Well done! But I have one problem. In my test baord this working just fine. But when I put it in my board and when I click to usercp I get SQL error! Can you please help me? Maybe you now what is wrong?

Thank you! :D
SaN-DeeP
06-10-2004, 08:11 PM
same here
i am getting this

Database error in vBulletin 3.0.0:

Invalid SQL: SELECT reputation.userid,user.username FROM vb3_reputation
LEFT JOIN vb3_user ON user.userid=reputation.userid
WHERE reputation.whoadded='2' ORDER BY dateline DESC LIMIT 0,10
mysql error: Unknown table 'reputation' in field list

mysql error number: 1109
Anette
06-11-2004, 03:46 PM
Nobody can help us? :(
Anette
06-13-2004, 12:34 PM
Bump!
vbmechanic
06-13-2004, 02:19 PM
Sorry, it has to do with the TABLE_PREFIX you're using. The query needs some adjustment.. try:


$recipients=$DB_site->query("SELECT reputation.userid,user.username FROM " . TABLE_PREFIX . "reputation AS reputation
LEFT JOIN " . TABLE_PREFIX ."user AS user ON user.userid=reputation.userid
WHERE reputation.whoadded='".$bbuserinfo['userid']."' ORDER BY dateline DESC LIMIT 0,10");
SaN-DeeP
06-14-2004, 12:32 PM
Sorry, it has to do with the TABLE_PREFIX you're using. The query needs some adjustment.. try:


$recipients=$DB_site->query("SELECT reputation.userid,user.username FROM " . TABLE_PREFIX . "reputation AS reputation
LEFT JOIN " . TABLE_PREFIX ."user AS user ON user.userid=reputation.userid
WHERE reputation.whoadded='".$bbuserinfo['userid']."' ORDER BY dateline DESC LIMIT 0,10");

this thing works :)

thnx.
Sandy...
Anette
06-18-2004, 04:59 PM
Thanks! :D
ChuanSE
07-04-2004, 06:46 AM
Good one, should come standard with vB ;)
* ChuanSE clicks install
Loxias
07-05-2004, 11:26 PM
I tried to re-install this for vb 3.0.3 and get a weird result. The 10 people last listed repeat probably 50+ times, ordered 1-10. Ideas?
TTG
07-12-2004, 08:22 AM
Installed on 3.0.1 and have the last 10 keep repeating .. now up to 30 and all the same. I've stopped giving reputation credits !?
turbidblue
07-20-2004, 12:38 AM
so damn easy to install :)

thanks so much!

* turbidblue clicks install
TTG
07-27-2004, 10:08 AM
Installed on 3.0.1 and have the last 10 keep repeating .. now up to 30 and all the same. I've stopped giving reputation credits !?

Anyone solved this problem ?
Tipi
10-04-2004, 06:25 PM
I can't get this to work. I did everything the file told me to do, but it's no changes in the userCP. :(
DalaiLamaBob
12-03-2004, 07:54 AM
I tried to re-install this for vb 3.0.3 and get a weird result. The 10 people last listed repeat probably 50+ times, ordered 1-10. Ideas?

I had the same problem but couldn't find an answer so I did a kludge myself.

It appears that the hack is ran five times since it shows 50 entries with 1-10 repeated 5 times. So in order to limit the effects I made it so only the last one stuck.


above
while ($recipient=$DB_site->fetch_array($recipients))

add
$lastclicks = '';

It would of been nicer to know why it is running five times.