"); // exit(); //} if (isset($_REQUEST["page"])){ $page = $_REQUEST["page"]; } else { $page=0; } $query = "SELECT * FROM tbl_loot INNER JOIN tbl_member ON tbl_loot.member_id = tbl_member.id INNER JOIN tbl_pool ON tbl_loot.pool = tbl_pool.id WHERE tbl_loot.deleted=0 ORDER BY loot_date DESC, tbl_loot.id DESC $my_adj"; $result = mysql_query($query); if ($result) {$number = mysql_numrows($result);} else {$number=0;} echo "

Loot Items

"; if ($number == 0){ echo ""; } else { $bgcolour = "#FFFFFF"; $i = ($page * $recs_per_page); $rec_to = (($page+1) * $recs_per_page); if($rec_to > $number) {$rec_to = $number;} while ($i < $rec_to){ $rec_id = mysql_result($result,$i,"tbl_loot.id"); $rec_date = mysql_result($result,$i,"loot_date"); $rec_item = stripslashes(mysql_result($result,$i,"description")); $rec_member = mysql_result($result,$i,"member_name"); $rec_dkp_value = mysql_result($result,$i,"dkp"); $rec_dkp_pool = mysql_result($result,$i,"tbl_pool.pool_name"); $rec_dkp = "$rec_dkp_value $rec_dkp_pool"; if ($rec_date !="" && $rec_date != "0000-00-00 00:00:00"){ $dt_elements = explode(" " ,$rec_date); $date_elements = explode("-" ,$dt_elements[ 0]); $rec_date = $date_elements[2]."-".$date_elements[1]."-".$date_elements[0]; } else { $rec_date = "-- -- --"; } echo ""; if ($bgcolour == "#FFFFFF"){ $bgcolour = "#F5F5FF"; } else { $bgcolour = "#FFFFFF"; } $i++; } } echo "

Date	Item	Member	DKP
NO DATA
$rec_date	$rec_item	$rec_member	$rec_dkp
"; $i=$page-15; if($i<1){$i=1;} $x=$page+15; if($x > (intval($number/$recs_per_page)+1)){$x=intval($number/$recs_per_page)+1;} if ($page > 0 ) { echo "Prev  "; } else { echo "Prev "; } while ($i <= $x){ if (($i-1) != $page) { echo " $i"; } else { echo " $i"; } $i++; } if (($page+1) < $x ) { echo "  Next"; } else { echo " Next"; } echo "

"; include ("footer.php"); ?>