| |
Member";
} else {
echo "Member | ";
}
if($sort_by == "class") {
echo "Class | ";
} else {
echo "Class | ";
}
if($sort_by == "att_1desc") {
echo "Last 30 Days | ";
} else {
echo "Last 30 Days | ";
}
if($sort_by == "att_2desc") {
echo "Last 60 Days | ";
} else {
echo "Last 60 Days | ";
}
if($sort_by == "att_3desc") {
echo "Last 90 Days | ";
} else {
echo "Last 90 Days | ";
}
$query = "SELECT
*
FROM
tbl_member
INNER JOIN
tbl_cache_att ON tbl_cache_att.member_id = tbl_member.id
WHERE
tbl_member.deleted = 0
$filter1
$filter2";
$result = mysql_query($query);
if($result){$number = mysql_numrows($result);} else {$number=0;}
if ($number!=0){
$i=0;
while ($i < $number){
$rec_id = mysql_result($result,$i,"tbl_member.id");
$rec_name = mysql_result($result,$i,"member_name");
$rec_class = mysql_result($result,$i,"member_class");
$rec_raid_1 = mysql_result($result,$i,"raid_1");
$rec_list_1 = mysql_result($result,$i,"list_1");
$rec_att_1 = mysql_result($result,$i,"att_1");
$rec_per_1 = mysql_result($result,$i,"per_1");
$rec_raid_2 = mysql_result($result,$i,"raid_2");
$rec_list_2 = mysql_result($result,$i,"list_2");
$rec_att_2 = mysql_result($result,$i,"att_2");
$rec_per_2 = mysql_result($result,$i,"per_2");
$rec_raid_3 = mysql_result($result,$i,"raid_3");
$rec_list_3 = mysql_result($result,$i,"list_3");
$rec_att_3 = mysql_result($result,$i,"att_3");
$rec_per_3 = mysql_result($result,$i,"per_3");
$rec_total_1 = $rec_raid_1 + $rec_list_1;
$rec_total_2 = $rec_raid_2 + $rec_list_2;
$rec_total_3 = $rec_raid_3 + $rec_list_3;
if ($rec_per_2 >= 60){
$current_status = "•";
}
if ($rec_per_2 < 60 && $rec_per_2 >= 30){
$current_status = "•";
}
if ($rec_per_2 < 30){
$current_status = "•";
}
echo "
 |
$current_status$rec_name |
$rec_class |
$rec_att_1/$rec_total_1 ($rec_raid_1/$rec_list_1) |
$rec_per_1% |
$rec_att_2/$rec_total_2 ($rec_raid_2/$rec_list_2) |
$rec_per_2% |
$rec_att_3/$rec_total_3 ($rec_raid_3/$rec_list_3) |
$rec_per_3% |
";
$i++;
}
}
echo "
|