Can someone please help me... I'm almost finished with this script, but there is one problem.
Right now this script is for a referral system on my forum and the problem is that it is listing the leaders in descending order by their total number of referrals no matter if who they referred as a member is a verified member or not...
I do want it to list the leaders in descending order, but only by the number of verified / registerd referred members they sent to the board. I have attached the sctipt below and tried to explain each bit of coding to help everyone understand what I'm trying to do. Any help would be greatly appreciated..
error_reporting(7);
$templatesused='reflistbit,reflist';
require('./global.php');
$max=4; //This number decides how many users to display
//start listing the total numbers of referrals by member.
$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
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT $max");
// show all verified referred members by members username.
while ($referrer=$DB_site->fetch_array($referrers)) {
$referreds = $DB_site->query("SELECT username FROM user WHERE referrerid = '$referrer[userid]' AND user.usergroupid=2");
while ($referred = $DB_site->fetch_array($referreds)){
if ($referrerlist) {
$referrerlist.=", $referred[username] ";
} else {
$referrerlist = "$referred[username]";
}
}
//end show.
//start show number of verified referred members for each member script
$referredstest = $DB_site->query("SELECT COUNT('username') AS username FROM user WHERE referrerid = '$referrer[userid]' AND user.usergroupid=2");
while ($referred11 = $DB_site->fetch_array($referredstest)){
if ($referreractual) {
$referreractual.=", $referred11[username] ";
} else {
$referreractual = "$referred11[username]";
}
//end actual verified reffered # of members script
}
eval("\$reflistbits .= \"".gettemplate("reflistbit")."\";");
$referrerlist="";
$referreractual="";
}
eval("dooutput(\"".gettemplate("reflist")."\");");
