vb.org Archive
Page 5 of 8 « First 34 5 67 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Referrers On Forumhome v.1.3 (https://vborg.vbsupport.ru/showthread.php?t=101324)

kurtbarker 12-03-2005 09:21 PM
maybe i'm missing it aye, but that 'edit' looks like it's for a different error?

cbr929rrerion 12-04-2005 02:18 AM
It shows the wrong date for "Date Joined". It has the same date for everyone..

Can this be fixed?

tnguy3n 12-04-2005 02:43 AM
Quote:
Originally Posted by cbr929rrerion
It shows the wrong date for "Date Joined". It has the same date for everyone..

Can this be fixed?
I think I missed out the joindate field in my query.

In the plugin,

FIND:

PHP Code:
    $referrers = $db->query_read("SELECT user.userid, user.username, user.referrerid, users.username AS refname FROM " . TABLE_PREFIX . "user AS users LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.referrerid = users.userid) WHERE user.referrerid = '" . intval($vbulletin->GPC['referrerid']) . "' ORDER BY user.username DESC LIMIT 0, $count"); 
REPLACE WITH:
PHP Code:
    $referrers = $db->query_read("SELECT user.userid, user.username, user.referrerid, users.username AS refname, user.joindate FROM " . TABLE_PREFIX . "user AS users LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.referrerid = users.userid) WHERE user.referrerid = '" . intval($vbulletin->GPC['referrerid']) . "' ORDER BY user.username DESC LIMIT 0, $count"); 
[high]* tnguy3n updated hack.[/high]

cbr929rrerion 12-04-2005 03:02 AM
Done.. Awesome.. fixed.. Thanks

smokering 12-04-2005 04:12 AM
excellent hack thank you

Developer 12-06-2005 06:39 AM
v.nice hack

NoCo7 12-18-2005 02:06 PM
An alternative fix I found for the mysql 'usergroup' table related errors is to adding 'AS usergroup' on the second LEFT JOIN in the initial $referrals query resolves the problem and allows the group markup to work.

Code:
$referrals = $db->query_read("SELECT COUNT(*) AS totalref, user.username, user.userid, user.usergroupid, usergroup.usergroupid, usergroup.opentag, usergroup.closetag
    FROM " . TABLE_PREFIX . "user AS users
    LEFT JOIN " . TABLE_PREFIX . "user AS user ON (users.referrerid = user.userid)
    LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)
    WHERE users.referrerid != 0
        GROUP BY users.referrerid
        ORDER BY totalref
        DESC LIMIT 0,$num");

tnguy3n 12-19-2005 11:04 PM
thanks for pointing that out, NoCo7.

update the hack!

neutek 01-06-2006 07:48 PM
thanks :)
+install

cbr929rrerion 01-13-2006 06:38 PM
when I click on the members name it takes me to a page but it dont list them, you can see where they should be but they are not there..

www.crotchrocketracing.com

Its at the bottom.. any idea?


All times are GMT. The time now is 10:37 PM.
Page 5 of 8 « First 34 5 67 Last »
Show 40 post(s) from this thread on one page

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.01083 seconds
  • Memory Usage 1,743KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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