vb.org Archive - Display full list of referrers and referrals

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> &gt; 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>

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01272 seconds Memory Usage 1,841KB 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 (8)bbcode_php_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
Messages: