<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'referals'); // change this depending on your filename
// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array(
);
// get special data templates from the datastore
$specialtemplates = array(
'reflist',
);
// pre-cache templates used by all actions
$globaltemplates = array(
'reflist',
);
// pre-cache templates used by specific actions
$actiontemplates = array(
);
// ######################### REQUIRE BACK-END ############################
require_once('./global.php');
// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################
$navbits = array();
$navbits[$parent] = 'Referal Summary';
$navbits = construct_navbits($navbits);
//start referral script//
$max=3; //This number decides how many users to display
$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.usergroupid=2
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT $max");
while ($referrer=$DB_site->fetch_array($referrers)) {
$referreds = $DB_site->query("SELECT username FROM user WHERE referrerid = '$referrer[userid]' AND user.usergroupid=2
GROUP BY username
ORDER BY username ASC");
while ($referred = $DB_site->fetch_array($referreds)){
$enc_username = urlencode($referred[username]);//get username for href link info below
if ($referrerlist) {
$referrerlist.=", <A HREF=member.php?action=getinfo&username=$enc_username>$referred[username]</A>";//make referred members clickable to user info.
} else {
$referrerlist ="<A HREF=member.php?action=getinfo&username=$enc_username>$referred[username]</A>"; //make referred members clickable to user info.
}
}
//show actual number of verified/registered members script
$referredstest = $DB_site->query("SELECT COUNT(*) AS username FROM user WHERE referrerid = '$referrer[userid]' AND user.usergroupid=2
GROUP BY user.usergroupid
ORDER BY referrerid DESC");
while ($referred11 = $DB_site->fetch_array($referredstest)){
if ($referreractual) {
$referreractual.=", $referred11[username] ";
} else {
$referreractual = "$referred11[username]";
}
//end actual # script
}
}
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('reflist') . '");');
?>
