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 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?

Hey boofy, how is it down there in Des Moines? School is getting more tensed now as it's getting closer to finals.

A popup that lists all of the names is cool, but maybe I'll add another query to get the list since the other one is way too big aleady.

[Boofo]

Originally Posted by tnguy3n

Hey boofy, how is it down there in Des Moines? School is getting more tensed now as it's getting closer to finals.

A popup that lists all of the names is cool, but maybe I'll add another query to get the list since the other one is way too big aleady.

A new page with how many and the names, too?

Make sure you let me know when you get some free time and we'll hook up since you are this close.

[MThornback]

Database error in vBulletin 3.5.1:

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

MySQL Error : Unknown table 'usergroup' in field list
Error Number : 1109
Date : Monday, November 28th 2005 @ 02:01:26 PM
Script : http://www.webcadets.com/forum/index.php
Referrer : http://www.webcadets.com/forum/arcade.php?&act=Arcade
IP Address :
Username : MThornback
Classname : vb_database

Help, Please?

[Dead End Society]

Yeah I get the same error when I install the plugin....when I uninstall it I can access my forums again. So this means it's conflicting with another hack right?

[MThornback]

Originally Posted by Dead End Society

Yeah I get the same error when I install the plugin....when I uninstall it I can access my forums again. So this means it's conflicting with another hack right?

I'm thinking it means that we have another hack that dropped that row for some reason, or replaced it with something else...but I wanted to ask to be sure..

[tnguy3n]

Originally Posted by Boofo

A new page with how many and the names, too?

Done as requested. Just download and install new release of the hack.

Make sure you let me know when you get some free time and we'll hook up since you are this close.

We definitely should. My semester will end on the 22nd of December, then I'll have 4 weeks off. If you have chance going to down to IC, give me me a call.

[tnguy3n]

Originally Posted by MThornback

I'm thinking it means that we have another hack that dropped that row for some reason, or replaced it with something else...but I wanted to ask to be sure..

Frankly, I got no idea what caused that bug, but there's a work-around (posted in first post) to fix this bug.

[Boofo]

Originally Posted by tnguy3n

Done as requested. Just download and install new release of the hack.

Thank you, sir.

Originally Posted by tnguy3n

We definitely should. My semester will end on the 22nd of December, then I'll have 4 weeks off. If you have chance going to down to IC, give me me a call.

Sounds like a plan.

How long do you have left then?

[kurtbarker]

hey mate, i'm getting:

Database error in vBulletin 3.5.1:

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

MySQL Error  : Unknown table 'usergroup' in field list
Error Number : 1109
Date         : Saturday, December 3rd 2005 @ 04:16:21 PM
Script       : http://commodorelife.com/forums/
Referrer     : 
IP Address   : 220.101.20.174
Username     : kurtbarker
Classname    : vb_database

any suggestions?

[tnguy3n]

pls read first post for the alternative.