rendered paste body$result_08 = mysql_query("SELECT * FROM `fsr_user_sites` WHERE referred_by_id='$user_site_id'");
while ($row_08 = mysql_fetch_assoc($result_08)) {
$ref_user_id = $row_08['id'];
$result_10 = mysql_query("SELECT * FROM `fsr_user_sites` WHERE user_id='$ref_user_id'");
while ($row_10 = mysql_fetch_assoc($result10)) {
$ref_user_site_id = $row_10['id'];
$result_09 = mysql_query("SELECT * FROM `fsr_offer_credits` WHERE user_site_id='$ref_user_site_id'");
$completionTotal_Refs = 0;
$totalActiveRefs = 0;
while ($row_09 = mysql_fetch_assoc($result_09)) {
$any_credit = $row_09['credit_value'];
$completion = explode("/", $any_credit);
if($completion[1] < 1)
{
$completion[1] = 1;
}
$completionCount = ($completion[0] / $completion[1]);
$completionTotal_Refs = $completionTotal_Refs + $completionCount;
}
if($completionTotal_Refs >= 1) {
$totalActiveRefs = ($totalActiveRefs + 1);
}
else
{
$totalActiveRefs = $totalActiveRefs;
}
}
}
print '<br />Referrals: ' .$totalActiveRefs. ' / ' .$refRequirement. ' ';
}