referrerlist.php:
PHP Code:
<?php
error_reporting(7);
$templatesused='referrer_listbit,referrer_list,referrer_top';
require('./global.php');
// Top Referrer List Hack ############################################
// Hacked by: FireFly with help from dwh,unixman,Freddie,Bane
// Config #######################################################
$max=100; //This number decides how many users to display
$userx=0; //Users to exclude from top referrer Seperate with , (0 for none)
$userl=0; //Users to exclude from top referrer list Seperate with , (0 for none)
// Get Top List ###################################################
$referrers = $DB_site->query("SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0 AND
user.userid NOT IN ($userl)
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT $max");
while ($referrer=$DB_site->fetch_array($referrers)) {
$referreds = $DB_site->query("SELECT username,userid FROM user WHERE referrerid = '$referrer[userid]'");
$referrerlist = "<SELECT NAME='newLoc' onChange='jumpPage(this.form.newLoc)' style='font-size: 7pt; background-color: #dfdfdf; font-family: Arial, Tahoma;' maxlength='25'><OPTION VALUE='#'>------------Select------------</OPTION>";
while ($referred = $DB_site->fetch_array($referreds)){
if ($referrerlist) {
$referrerlist.="<OPTION VALUE='member.php?s=$session[sessionhash]&action=getinfo&userid=$referred[userid]'>$referred[username]</OPTION>";
}
}
$referrerlist.="</select>";
eval("\$reflistbits .= \"".gettemplate("referrer_listbit")."\";");
$referrerlist="";
}
// Get Top referrer #################################################
if ($usereferrer) {
$ref = $DB_site->query_first("SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0 AND
user.userid NOT IN ($userx)
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 1");
eval("\$topreferrer = \"".gettemplate('referrer_top')."\";");
}
eval("\$reflistbits .= \"".gettemplate("referrer_listbit")."\";");
$referrerlist="";
// ############################################################
makeforumjump();
eval("dooutput(\"".gettemplate("referrer_list")."\");");
?>
referrer_list:
PHP Code:
{htmldoctype}
<HTML>
<HEAD><TITLE>$bbtitle Top Referrer List</title>
$headinclude
</head>
<body>
$header
<!-- breadcrumb -->
<table border="0" width="100%" cellpadding="0" cellspacing="0"><tr>
<td width="100%"><img src="{imagesfolder}/vb_bullet.gif" align="absmiddle"> <normalfont><b><a href="index.php?s=$session[sessionhash]">$bbtitle</a> > Top Referrers</b></normalfont></TD></tr></table>
<!-- /breadcrumb -->
<!--Begin-->
<br>
<table cellpadding="{tableouterborderwidth}" cellspacing="0" border="0" bgcolor="{tablebordercolor}" {tableouterextra} width="{contenttablewidth}" align="center"><tr><td>
<table cellpadding="4" cellspacing="{tableinnerborderwidth}" border="0" {tableinnerextra} width="100%">
<tr align="center">
<td bgcolor="{secondaltcolor}"><smallfont><a href="memberlist.php?s=$session[sessionhash]&action=search"><b>Advanced Search</b></a></smallfont></td>
<td bgcolor="{secondaltcolor}"><smallfont><a href="memberlist.php?s=$session[sessionhash]&what=topposters&perpage=$memberlisttopposters"><b>Top $memberlisttopposters Posters</b></a></smallfont></td>
<td bgcolor="{secondaltcolor}"><smallfont><a href="memberlist.php?s=$session[sessionhash]"><b>List Alphabetically</b></a></smallfont></td>
<td bgcolor="{secondaltcolor}"><smallfont><a href="memberlist.php?s=$session[sessionhash]&what=datejoined"><b>List by Date Joined</b></a></smallfont></td>
<!-- Begin Referrals -->
<td bgcolor="{firstaltcolor}"><smallfont><a href="referrerlist.php?s=$session[sessionhash]"><b>Referrals</b></a></smallfont></td>
<!-- End Referrals -->
<!-- Begin Forum Leaders -->
<td bgcolor="{secondaltcolor}"><smallfont><a href="showmods.php?s=$session[sessionhash]"><b>Forum Leaders</b></a></smallfont></td>
<!-- End Forum Leaders -->
</tr>
</table>
</td></tr></table>
<br>
<!--End-->
<!-- main -->
<!--
<table cellpadding="{tableouterborderwidth}" cellspacing="0" border="0" {tableouterextra} width="250" align="center"><tr>
<td><div align="center">$topreferrer</div></td>
</tr></table>
-->
<p align="center">$topreferrer</p>
<table cellpadding="{tableouterborderwidth}" cellspacing="0" border="0" bgcolor="{tablebordercolor}" {tableouterextra} width="275" align="center"><tr><td>
<table cellpadding="4" cellspacing="{tableinnerborderwidth}" border="0" {tableinnerextra} width="275">
<tr align="center">
<td bgcolor="{tableheadbgcolor}" align="center" width="100"><smallfont color="{tableheadtextcolor}"><b>Member</b></smallfont></td>
<td bgcolor="{tableheadbgcolor}" align="center" width="50"><smallfont color="{tableheadtextcolor}"><b>Referrals</b></smallfont></td>
<td bgcolor="{tableheadbgcolor}" align="center" width="125"><smallfont color="{tableheadtextcolor}"><b>Members Referred</b></smallfont></td>
</tr>
$reflistbits
</table>
</td></tr></table>
<p align="center">$forumjump</p>
<!-- /main -->
$footer
</body></html>
referrer_listbit:
PHP Code:
<tr align="center">
<td bgcolor="{firstaltcolor}"><smallfont><b><a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$referrer[userid]">$referrer[username]</a></b></smallfont></td>
<td bgcolor="{firstaltcolor}"><smallfont>$referrer[referrals]</smallfont></td>
<form><td bgcolor="{firstaltcolor}">$referrerlist</td></form>
</tr>