Referrers On Forumhome v.1.3

Top XX Referrers In FORUMHOME
Author: tnguy3n
Support Site: www.vbviet.org

This plugin pulls out XX top referrers in your database and display it on your FORUMHOME. When you click on the referrer's name, it shows the list of users that the member referred in a popup window.
To change number of referrers to show, open the plugin, and change $num to your own value.

INSTALLTION: 2-3 mins
- plugin: 2
- template mod: 1
- new template: 1

CHANGES SINCE v.1.0
- show lists of users the member referred in a popup window

UPLOAD plugin-referrer.xml in your Plugin Manager, then apply template mod as in top_referrers_on_forumhome.txt file. For those who want to upgrade to version 1.2, follow instructions in upgrade.txt file.

Pls click on "INSTALL" buttons if you use it.

[kurtbarker]

maybe i'm missing it aye, but that 'edit' looks like it's for a different error?

[cbr929rrerion]

It shows the wrong date for "Date Joined". It has the same date for everyone..

Can this be fixed?

[tnguy3n]

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]

Done.. Awesome.. fixed.. Thanks

[smokering]

excellent hack thank you

[Developer]

v.nice hack

[NoCo7]

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.

$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]

thanks for pointing that out, NoCo7.

update the hack!

[neutek]

thanks
+install

[cbr929rrerion]

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?