OUT OF DATE"; } else { $cache_status = "Cache Status: OK"; } ?>
"; } else { $query = "SELECT * FROM tbl_pool where deleted=0 ORDER BY pool_name"; $result = MYSQL_QUERY($query); if($result) {$number = MYSQL_NUMROWS($result);} else {$number = 0;} if ($number!=0){ $i=0; echo ""; } } ?>
DKP Pool Class
Member"; } else { echo ""; } if($sort_by == "class") { echo ""; } else { echo ""; } if($sort_by == "earneddesc") { echo ""; } else { echo ""; } if($sort_by == "spentdesc") { echo ""; } else { echo ""; } if($sort_by == "adjdesc") { echo ""; } else { echo ""; } if($sort_by == "balancedesc") { echo ""; } else { echo ""; } if($sort_by == "raiddesc") { echo ""; } else { echo ""; } echo ""; $query = "SELECT * FROM tbl_member INNER JOIN tbl_cache ON tbl_cache.member_id = tbl_member.id AND tbl_cache.pool_id = $dkp_pool $filter1 $filter2"; $result = mysql_query($query); if($result){$number = mysql_numrows($result);} else {$number=0;} if ($number!=0){ $i=0; $bgcolour = "#FFFFFF"; 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_earned = mysql_result($result,$i,"earned"); $rec_spent = mysql_result($result,$i,"spent"); $rec_adjustment = mysql_result($result,$i,"adjustment"); $rec_balance = mysql_result($result,$i,"balance"); $rec_last_raid = mysql_result($result,$i,"last_raid"); if ($rec_last_raid !="" && $rec_last_raid != "0000-00-00 00:00:00"){ $dt_elements = explode(" " ,$rec_last_raid); $date_elements = explode("-" ,$dt_elements[ 0]); $rec_last_raid = $date_elements[2]."-".$date_elements[1]."-".$date_elements[0]; } else { $rec_last_raid = " "; } echo ""; if ($bgcolour == "#FFFFFF"){ $bgcolour = "#F5F5FF"; } else { $bgcolour = "#FFFFFF"; } $i++; } } echo "
  MemberClassClassEarnedEarnedSpentSpentAdjustmentAdjustmentBalanceBalanceLast RaidLast Raid
$rec_name $rec_class $rec_earned  $rec_spent  $rec_adjustment  $rec_balance  $rec_last_raid 
"; while($i<$number){ $rec_name = mysql_result($result,$i,"pool_name"); echo ""; $i++; } echo ""; } $query = "SELECT * FROM tbl_member INNER JOIN tbl_cache ON tbl_cache.member_id = tbl_member.id INNER JOIN tbl_pool on tbl_cache.pool_id = tbl_pool.id WHERE tbl_pool.deleted=0 $filter1 ORDER BY member_name,pool_name"; $result = mysql_query($query); if($result){$number = mysql_numrows($result);} else {$number=0;} if ($number!=0){ $i=0; $current_member = ""; $members = 0; $bgcolour = "#FFFFFF"; 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_earned = mysql_result($result,$i,"earned"); $rec_spent = mysql_result($result,$i,"spent"); $rec_adjustment = mysql_result($result,$i,"adjustment"); $rec_balance = mysql_result($result,$i,"balance"); $rec_pool = mysql_result($result,$i,"pool_name"); if ($rec_name != $current_member){ if ($current_member != ""){echo "";} echo ""; $current_member = $rec_name; if ($bgcolour == "#FFFFFF"){ $bgcolour = "#F5F5FF"; } else { $bgcolour = "#FFFFFF"; } $members++; } echo ""; $i++; } $number = $members; echo "
  Member Class$rec_name DKP
$rec_name $rec_class$rec_pool DKP For $rec_name

Earned: $rec_earned

Spent: $rec_spent

Adjustment: $rec_adjustment

Balance: $rec_balance

')\">$rec_balance
 
Members