<?php include "antet.php"; include "func.php";
$gen_stats=gen_stats(48);
?>
<html>
<?php echo "<link rel='stylesheet' type='text/css' href='".$imgs.$fimgs."default.css'>"; ?>
<head>
<title><?php echo $title; ?> - Rank</title>
</head>
<body class="q_body">
<div align="center">
<?php echo $top_ad; ?>
<table class="q_table trevana">
<tr>
<td colspan="2" class="td_logo">
<?php logo($title); ?></td>
</tr>
<tr>
<td colspan="2" class="td_top_menu"><?php menu_up(); ?></td>
</tr>
<tr>
<td class="q_table trevana" style="border-collapse: collapse" border="1">
<center><img height= '29' src= 'img/medals/medals.png'><b> I Villaggi piu popolati di TRAVLAND</b></center>
<table style="font-size=75%">
<tr>
<td class="q_table trevana" style="border-collapse: collapse" border="1"><strong>10 Villi importanti</strong></td><td> </td><td style="border-collapse: collapse" border="1" align="right"><strong>Giocatore</strong></td>
</tr>
<?php
$dbres=mysql_query("SELECT owner,population,name,id FROM towns WHERE level != '1' ORDER BY population DESC LIMIT 15");
$counter = 1;
while ($rank=mysql_fetch_object($dbres)){
$dbres2=mysql_query("SELECT x,y from map where type='3' and subtype='$rank->id'");
$dbres3=mysql_query("SELECT name FROM users WHERE id='$rank->owner'");
$location=mysql_fetch_object($dbres2);
$owner=mysql_fetch_object($dbres3);
?>
<tr>
<td><i><b><?php if ($counter==1)echo "<img src='img/medals/1.png'>"; if ($counter==2)echo "<img src='img/medals/2.png'>"; if ($counter==3)echo "<img src='img/medals/3.png'>"; if ($counter==4)echo "<img src='img/medals/4.png'>"; if ($counter==5)echo "<img src='img/medals/5.png'>"; if ($counter==6)echo "<img src='img/medals/6.png'>"; if ($counter==7)echo "<img src='img/medals/7.png'>"; if ($counter==8)echo "<img src='img/medals/8.png'>"; if ($counter==9)echo "<img src='img/medals/9.png'>"; if ($counter==10)echo "<img src='img/medals/10.png'>"; echo $counter; ?></b></i> <a class='q_link' href=map.php?x=<?php echo $location->x ?>&y=<?php echo $location->y ?>><?php echo $rank->name ?></a></td><td><?php echo $rank->population ?></td><td align="right"><?php echo $owner->name ?></td>
</tr>
<?php
$counter ++;
} ?>
</table>
</td>
<td class="q_table trevana" style="border-collapse: collapse" border="1">
<center><img height= '29' src= 'img/medals/medals.png'><b> I Player piu forti di TRAVLAND</b></center>
<table style="font-size=75%">
<tr>
<td class="q_table trevana" style="border-collapse: collapse" border="1"><strong>10 Giocatori importanti</strong></td><td> </td><td style="border-collapse: collapse" border="1" align="right"><strong>Villaggi</strong></td>
</tr>
<?php
$dbres=mysql_query("SELECT owner, SUM(population) as pop FROM towns WHERE level != '1' GROUP BY owner ORDER BY pop DESC LIMIT 15") or die(mysql_error());
$counter = 1;
while ($rank=mysql_fetch_array($dbres)){
$dbres2=mysql_query("SELECT name FROM users WHERE id='$rank[owner]'");
$name=mysql_fetch_array($dbres2);
$dbres3=mysql_query("SELECT id FROM towns WHERE owner='$rank[owner]'");
$number=mysql_numrows($dbres3);
?>
<tr>
<td><i><b><?php if ($counter==1)echo "<img src='img/medals/1.png'>"; if ($counter==2)echo "<img src='img/medals/2.png'>"; if ($counter==3)echo "<img src='img/medals/3.png'>"; if ($counter==4)echo "<img src='img/medals/4.png'>"; if ($counter==5)echo "<img src='img/medals/5.png'>"; if ($counter==6)echo "<img src='img/medals/6.png'>"; if ($counter==7)echo "<img src='img/medals/7.png'>"; if ($counter==8)echo "<img src='img/medals/8.png'>"; if ($counter==9)echo "<img src='img/medals/9.png'>"; if ($counter==10)echo "<img src='img/medals/10.png'>"; echo $counter; ?></b></i> <a class='q_link' href=profile_view.php?id=<?php echo $rank['owner'] ?>><?php echo $name['name'] ?></a></td><td><?php echo $rank['pop'] ?></td><td align="right"><?php echo $number ?></td?
</tr>
<?php
$counter ++;
} ?>
</table>
</td>
</tr>
<tr>
<td colspan=2>
<hr>
<center><img height= '29' src= 'img/medals/medals.png'><b> Le attuali Alleanze su TRAVLAND</b></center>
<table style="font-size=75%" align="center">
<tr>
<td class="q_table trevana" style="border-collapse: collapse" border="1"><strong>Alleanze </strong></td><td><strong>Popolazioni </strong></td><td><strong>Membri </strong></td>
</tr>
<?php
$dbres=mysql_query("SELECT name,id FROM alliances");
$pop=0;
while ($alliance = mysql_fetch_object($dbres)){
$dbres2=mysql_query("SELECT id FROM users WHERE alliance='$alliance->id'");
$members=mysql_num_rows($dbres2);
while ($isal = mysql_fetch_object($dbres2)){
$dbres3=mysql_query("SELECT owner, SUM(population) as pop FROM towns WHERE owner='$isal->id' GROUP BY owner ORDER BY pop DESC LIMIT 50") or die(mysql_error());
$popsum=mysql_fetch_object($dbres3);
$pop = ($pop+$popsum->pop);
}
?>
<tr><td><?php echo "<a class='q_link' href=a_view.php?id=" .$alliance->id.">".$alliance->name."</a>"; ?></td><td align=right><?php echo $pop ?></td><td align=right><?php echo $members ?></td></tr>
<?php
$pop=0;
}
?>
</table>
</td>
</tr>
<td>
<center><img height= '29' src= 'img/medals/medals.png'><b> Top 10 Attaccanti</b></center>
<table style="font-size=75%" align="center">
<tr>
<td class="q_table trevana" style="border-collapse: collapse" border="1"><strong>Attaccante</strong></td><td><strong>Punteggio</strong></td>
</tr>
<?php
$dbres=mysql_query("SELECT id,name,attPoint from users ORDER BY attPoint DESC LIMIT 10") or die(mysql_error());
$counter = 1;
while ($rank=mysql_fetch_array($dbres)){
$dbres3=mysql_query("SELECT id FROM towns WHERE owner='$rank[id]'");
$number=mysql_num_rows($dbres3);
?>
<tr>
<td><i><b><?php if ($counter==1)echo "<img src='img/medals/1.png'>"; if ($counter==2)echo "<img src='img/medals/2.png'>"; if ($counter==3)echo "<img src='img/medals/3.png'>"; if ($counter==4)echo "<img src='img/medals/4.png'>"; if ($counter==5)echo "<img src='img/medals/5.png'>"; if ($counter==6)echo "<img src='img/medals/6.png'>"; if ($counter==7)echo "<img src='img/medals/7.png'>"; if ($counter==8)echo "<img src='img/medals/8.png'>"; if ($counter==9)echo "<img src='img/medals/9.png'>"; if ($counter==10)echo "<img src='img/medals/10.png'>"; echo $counter; ?></b></i> <a class='q_link' href="profile_view.php?id=<?php echo $rank['id'] ?>"><?php echo $rank['name'] ?></a></td><td align='right'><?php echo $rank['attPoint'] ?></td>
</tr>
<?php
$counter ++;
} ?>
</table>
</td>
<td>
<center><img height= '29' src= 'img/medals/medals.png'><b> Top 10 Difensori</b></center>
<table style="font-size=75%" align="center">
<tr>
<td class="q_table trevana" style="border-collapse: collapse" border="1"><strong>Difensore</strong></td><td><strong>Punteggio</strong></td>
</tr>
<?php
$dbres=mysql_query("SELECT id,name,defPoint from users ORDER BY defPoint DESC LIMIT 10") or die(mysql_error());
$counter = 1;
while ($rank=mysql_fetch_array($dbres)){
$dbres3=mysql_query("SELECT id FROM towns WHERE owner='$rank[id]'");
$number=mysql_num_rows($dbres3);
?>
<tr>
<td><i><b><?php if ($counter==1)echo "<img src='img/medals/1.png'>"; if ($counter==2)echo "<img src='img/medals/2.png'>"; if ($counter==3)echo "<img src='img/medals/3.png'>"; if ($counter==4)echo "<img src='img/medals/4.png'>"; if ($counter==5)echo "<img src='img/medals/5.png'>"; if ($counter==6)echo "<img src='img/medals/6.png'>"; if ($counter==7)echo "<img src='img/medals/7.png'>"; if ($counter==8)echo "<img src='img/medals/8.png'>"; if ($counter==9)echo "<img src='img/medals/9.png'>"; if ($counter==10)echo "<img src='img/medals/10.png'>"; echo $counter; ?></b></i> <a class='q_link' href="profile_view.php?id=<?php echo $rank['id'] ?>"><?php echo $rank['name'] ?></a></td><td align='right'><?php echo $rank['defPoint'] ?></td>
</tr>
<?php
$counter ++;
} ?>
</table>
</td>
<tr>
<td colspan="2" class="td_bottom_menu">
<?php menu_down(); ?>
</td>
</tr>
</table>
<?php echo $bottom_ad; ?>
<p><?php about(); ?></div>
</body>
</html>
