vb.org Archive - Who have you given Reputation to?

Page 2 of 3

Show 40 post(s) from this thread on one page

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)

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?

All times are GMT. The time now is 08:03 PM.

Page 2 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01115 seconds Memory Usage 1,740KB 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 (2)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: