rendered paste body<?phpinclude_once("./itemstats/generic_itemstats.php");include_once("./functions.php");?><?php//Worldwide ranking$query_rs_Top10 = "SELECT * FROM armory_ranking ORDER BY character_level DESC LIMIT 10";$rs_Top10 = mysql_query($query_rs_Top10, $link) or die(mysql_error());$row_rs_Top10 = mysql_fetch_assoc($rs_Top10);$totalRows_rs_Top10 = mysql_num_rows($rs_Top10);//EU Rankings$query_rs_EUTop10 = "SELECT * FROM armory_ranking WHERE character_region = 'EU' ORDER BY character_level DESC LIMIT 10";$rs_EUTop10 = mysql_query($query_rs_EUTop10, $link) or die(mysql_error());$row_rs_Top10 = mysql_fetch_assoc($rs_EUTop10);$totalRows_rs_EUTop10 = mysql_num_rows($rs_EUTop10);//US Rankings$query_rs_USTop10 = "SELECT * FROM armory_ranking WHERE character_region = 'US' ORDER BY character_level DESC LIMIT 10";$rs_USTop10 = mysql_query($query_rs_USTop10, $link) or die(mysql_error());$row_rs_Top10 = mysql_fetch_assoc($rs_USTop10);$totalRows_rs_USTop10 = mysql_num_rows($rs_USTop10);?><html><head><link rel="stylesheet" href="itemstats/templates/itemstats.css" type="text/css"\><script type="text/javascript" src="itemstats/overlib/overlib.js"><!-- overLIB (c) Erik Bosrup --></script><link rel="stylesheet" type="text/css" href="css/style.css" /></head><body><div id="main"><div id="heading"> <div align="center">Top 10 Worldwide</div></div><br><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <th width="20%"><div align="left">Name</div></th> <th width="20%"><div align="center">Region</div></th> <th width="20%"><div align="center">Realm</div></th> <th width="20%"><div align="center">Item Level </div></th> <th width="20%"><div align="right">Average </div></th> </tr> <?php do { ?> <tr> <td><div align="left"><?php echo '<a href="index.php?region=' .$row_rs_Top10['character_region'] .'&n='.$row_rs_Top10['character_name'] .'&r='.$row_rs_Top10['character_realm'] .'&items=1">'.$row_rs_Top10['character_name'] .'</a>'; ?></div></td> <td><div align="center"><?php echo '<a href="#'.$row_rs_Top10['character_region'].'">'.$row_rs_Top10['character_region'].'</a>'; ?></div></td> <td><div align="center"><?php echo $row_rs_Top10['character_realm']; ?></div></td> <td><div align="center"><?php echo $row_rs_Top10['character_level']; ?></div></td> <td><div align="right"><?php echo $row_rs_Top10['character_average']; ?></div> <div align="right"></div></td> </tr> <?php } while ($row_rs_Top10 = mysql_fetch_assoc($rs_Top10)); ?> <tr> <td colspan="5">Rows: <?php echo $totalRows_rs_Top10;?> </td> </tr></table><br><div id="heading"> <div align="center"><a name="EU"></a>Top 10 EU</div></div><br><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <th width="20%"><div align="left">Name</div></th> <th width="20%"><div align="center">Region</div></th> <th width="20%"><div align="center">Realm</div></th> <th width="20%"><div align="center">Item Level </div></th> <th width="20%"><div align="right">Average </div></th> </tr> <?php while ($row_rs_EUTop10 = mysql_fetch_assoc($rs_EUTop10)){ ?> <tr> <td><div align="left"><?php echo '<a href="index.php?region='.$row_rs_EUTop10['character_region'] .'&n='.$row_rs_EUTop10['character_name'] .'&r='.$row_rs_EUTop10['character_realm'] .'&items=1">'.$row_rs_EUTop10['character_name'] .'</a>'; ?></div></td> <td><div align="center"><?php echo '<a href="#'.$row_rs_EUTop10['character_region'] .'">'.$row_rs_EUTop10['character_region'] .'</a>'; ?></div></td> <td><div align="center"><?php echo $row_rs_EUTop10['character_realm']; ?></div></td> <td><div align="center"><?php echo $row_rs_EUTop10['character_level']; ?></div></td> <td><div align="right"><?php echo $row_rs_EUTop10['character_average']; ?></div> <div align="right"></div></td> </tr> <?php }; ?> <tr> <td colspan="5">Rows: <?php echo $totalRows_rs_EUTop10;?> </td> </tr></table><br><div id="heading"> <div align="center"><a name="US"></a>Top 10 US</div></div><br><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <th width="20%"><div align="left">Name</div></th> <th width="20%"><div align="center">Region</div></th> <th width="20%"><div align="center">Realm</div></th> <th width="20%"><div align="center">Item Level </div></th> <th width="20%"><div align="right">Average </div></th> </tr> <?php while ($row_rs_USTop10 = mysql_fetch_assoc($rs_USTop10)){ ?> <tr> <td><div align="left"><?php echo '<a href="index.php?region='.$row_rs_USTop10['character_region'].'&n='.$row_rs_USTop10['character_name'].'&r='.$row_rs_USTop10['character_realm'].'&items=1">'.$row_rs_USTop10['character_name'].'</a>'; ?></div></td> <td><div align="center"><?php echo '<a href="#'.$row_rs_USTop10['character_region'].'">'.$row_rs_USTop10['character_region'].'</a>'; ?></div></td> <td><div align="center"><?php echo $row_rs_USTop10['character_realm']; ?></div></td> <td><div align="center"><?php echo $row_rs_USTop10['character_level']; ?></div></td> <td><div align="right"><?php echo $row_rs_USTop10['character_average']; ?></div> <div align="right"></div></td> </tr> <?php }; ?> <tr> <td colspan="5">Rows: <?php echo $totalRows_rs_USTop10;?> </td> </tr></table></div></body></html><?phpmysql_free_result($rs_Top10);mysql_free_result($rs_EUTop10);mysql_free_result($rs_USTop10);?>