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 "

$rec_balance

"; 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