View Source: /source/hof.php
Click here for the source, OR
Other files that you may wish to view the source of:
<?
require_once "common.php";
page_header("Hall of Fame");
$sql = "SELECT name,dragonkills FROM accounts WHERE dragonkills > 0 ORDER BY dragonkills DESC";
output("`c`b`&Heroes of the realm`b`c");
output("<table cellspacing=0 cellpadding=2 align='center'><tr><td>`bName`b</td><td>`bKills`b</td></tr>",true);
$result = db_query($sql) or die(db_error(LINK));
if (db_num_rows($result)==0){
output("<tr><td colspan=2 align='center'>`&There are no heroes in the land`0</td></tr>",true);
}
for ($i=0;$i<db_num_rows($result);$i++){
$row = db_fetch_assoc($result);
output("<tr><td>$row[name]</td><td>$row[dragonkills]</td></tr>",true);
}
output("</table>",true);
addnav("Return to the village","village.php");
page_footer();
?>