OUT OF DATE"; } else { $cache_status = "Cache Status: OK"; } $filter2 = "ORDER BY member_name"; if (isset($_REQUEST["sort_by"])){ $sort_by = $_REQUEST["sort_by"]; if ($sort_by == "member"){$filter2="ORDER BY member_name";} if ($sort_by == "memberdesc"){$filter2="ORDER BY member_name DESC";} if ($sort_by == "class"){$filter2="ORDER BY member_class";} if ($sort_by == "classdesc"){$filter2="ORDER BY member_class DESC";} if ($sort_by == "att_1"){$filter2="ORDER BY per_1";} if ($sort_by == "att_1desc"){$filter2="ORDER BY per_1 DESC";} if ($sort_by == "att_2"){$filter2="ORDER BY per_2";} if ($sort_by == "att_2desc"){$filter2="ORDER BY per_2 DESC";} if ($sort_by == "att_3"){$filter2="ORDER BY per_3";} if ($sort_by == "att_3desc"){$filter2="ORDER BY per_3 DESC";} } ?>
Class
Total Raid Sessions / Player Sessions (Raided / Listed)
Member"; } else { echo ""; } if($sort_by == "class") { echo ""; } else { echo ""; } if($sort_by == "att_1desc") { echo ""; } else { echo ""; } if($sort_by == "att_2desc") { echo ""; } else { echo ""; } if($sort_by == "att_3desc") { echo ""; } else { echo ""; } $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 ""; $i++; } } echo "
  MemberClassClassLast 30 DaysLast 30 DaysLast 60 DaysLast 60 DaysLast 90 DaysLast 90 Days
$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% 
 
$number Members
"; include_once("footer.php"); ?>