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.

[tnguy3n]

Originally Posted by hIBEES

Great stuff..before I install is there a way it can EXCLUDE admins ??

You can add in the query:

PHP Code:

AND user.usergroupid != 6 


For multiple groups:

PHP Code:

AND user.usergroupid NOT IN(6,7,8,9) 


[Deimos]

Great hack, installed aok, but one small problem

On the bar which shows who's the top referrers, i've got this

Flutter (22) Queen Mum (12) Epona (6) Tukaram (6) (6)

As you can see, there's 2 (6)'s after "Tukaram", as if there's another user, but it isn't showing their name?

[midaph]

Installed.

[Bounce]

Originally Posted by Deimos

Great hack, installed aok, but one small problem

On the bar which shows who's the top referrers, i've got this



As you can see, there's 2 (6)'s after "Tukaram", as if there's another user, but it isn't showing their name?

maybe if you lengthen how many it pulls from the db

// number of top xx referrers to show :ninja:

in the plugin file

[Bounce]

Originally Posted by tnguy3n

You can add in the query:

PHP Code:

AND user.usergroupid != 6 


For multiple groups:

PHP Code:

AND user.usergroupid NOT IN(6,7,8,9) 


forgive my non knowledge,where does that go in the query :nervous: :disappointed: :surprised: :surprised:

[G-Force 199]

I got this error :
Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT COUNT(*) AS totalref, user.username, user.userid, user.usergroupid, usergroup.usergroupid, usergroup.opentag, usergroup.closetag FROM vbb_user AS users LEFT JOIN vbb_user AS user ON (users.referrerid = user.userid) LEFT JOIN vbb_usergroup ON (usergroup.usergroupid = user.usergroupid) WHERE users.referrerid != 0 GROUP BY users.referrerid ORDER BY totalref DESC LIMIT 0,5;

MySQL Error  : Unknown column 'usergroup.usergroupid' in 'field list'
Error Number : 1054
Date         : Sunday, November 27th 2005 @ 08:25:24 PM
Script       : http://localhost/forum/
Referrer     : 
IP Address   : 127.0.0.1
Username     : 1st
Classname    : vB_Database

[tnguy3n]

Originally Posted by hIBEES

forgive my non knowledge,where does that go in the query :nervous: :disappointed: :surprised: :surprised:

something like the following:

PHP 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 ON (usergroup.usergroupid = user.usergroupid) WHERE users.referrerid != 0 AND user.usergroupid != 6 GROUP BY users.referrerid ORDER BY totalref DESC LIMIT 0,$num"); 


[tnguy3n]

Originally Posted by G-Force 199

I got this error :
Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT COUNT(*) AS totalref, user.username, user.userid, user.usergroupid, usergroup.usergroupid, usergroup.opentag, usergroup.closetag FROM vbb_user AS users LEFT JOIN vbb_user AS user ON (users.referrerid = user.userid) LEFT JOIN vbb_usergroup ON (usergroup.usergroupid = user.usergroupid) WHERE users.referrerid != 0 GROUP BY users.referrerid ORDER BY totalref DESC LIMIT 0,5;

MySQL Error  : Unknown column 'usergroup.usergroupid' in 'field list'
Error Number : 1054
Date         : Sunday, November 27th 2005 @ 08:25:24 PM
Script       : http://localhost/forum/
Referrer     : 
IP Address   : 127.0.0.1
Username     : 1st
Classname    : vB_Database

G-Force 199,
usergroupid is the first field in usergroup table, existing in both vb 3.0.x and vb 3.5.x. Unless you drop the field by accident or conflict with other hacks.

[Bounce]

Originally Posted by tnguy3n

something like the following:

PHP 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 ON (usergroup.usergroupid = user.usergroupid) WHERE users.referrerid != 0 AND user.usergroupid != 6 GROUP BY users.referrerid ORDER BY totalref DESC LIMIT 0,$num"); 


thank you sir

[high]* Bounce installed and working 100% [/high]

[Boofo]

Hey, college boy. How's it going?

Any way to have the number of referrals after each name be clickable with a window and a list of the names? Or maybe take you to another page that has a referral listing of some kind for the site?