vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Who have you given Reputation to? (https://vborg.vbsupport.ru/showthread.php?t=61518)

vbmechanic 02-12-2004 10:00 PM
Who have you given Reputation to?
 
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
Quote:
Originally Posted by achtungbaby
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
Quote:
Originally Posted by AxelF
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
Quote:
Originally Posted by AxelF
.. 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:

PHP Code:
$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
Quote:
Originally Posted by vbmechanic
Sorry, it has to do with the TABLE_PREFIX you're using. The query needs some adjustment.. try:

PHP Code:
$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 ;)
[high]* ChuanSE clicks install[/high]

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!

[high]* turbidblue clicks install[/high]

TTG 07-27-2004 10:08 AM
Quote:
Originally Posted by TTG
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
Quote:
Originally Posted by Loxias
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.

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

add
$lastclicks = '';
It would of been nicer to know why it is running five times.


All times are GMT. The time now is 02:57 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01573 seconds
  • Memory Usage 1,768KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (25)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete