<?
include "cnn.php";
?><title><?=titulo?></title></tr>
<h1>
  <?=$nomedomu?>
</h1>
<div class='quadros'><strong>&Uacute;ltimas Not&iacute;cias</strong>
<table width='100%'>
<?
$Query = mssql_query("select top 10 data,tipo,titulo,id from noticias order by id desc");
for($i=0;$i<mssql_num_rows($Query);$i++) {
$Array=mssql_fetch_row($Query);
?>
<tr>
<td width='75%' bgcolor='#F3F3F3'> - <a href="index.php?go=noticia&amp;id=<?=$Array[3]?>"><strong><?=$Array[2]?></strong></a></td>
<td width='75%' bgcolor='#F3F3F3'> - <strong>
  <?=$Array[0]?>
</strong></td>
</tr>
<? } ?>
<tr>
<td bgcolor='#F3F3F3'></td>
<td bgcolor='#F3F3F3' align="right"><a href="?go=todas">Ver Todas</a> </td>
</tr>
</table>
</div>
<br />
<div class='quadros'>
  <?
  $Query_Dados = mssql_query("select top 1 G_Name,G_Score,G_Mark,G_Banner FROM Guild order by G_Score desc");
  for($i=0;$i<mssql_num_rows($Query_Dados);$i++) {
  $rank = $i+1;
  $dados = mssql_fetch_row($Query_Dados);
		$logo = urlencode(bin2hex($dados['2']));
?>
  <tr>
    <td height="14" valign="middle"><table width="363" border="0" cellpadding="0" cellspacing="0">
        <tr>
<div style='float: right;'><img src='images/banner_promocoes.png' width='140' height='280' style='border:0px'></div>
          <td><div class="header13px">Top 1 Ranking</div></td>
          <td><div class="header13px" align="right"><a href="index.php?go=ginfo&guild=<?=$dados[0]?>"><?=$dados[0]?></a> (<?=$dados[1]?> Scores)</div></td>
        </tr>
        <tr>
          <center><td align=center><img src='modulos/outros/decode.php?decode=<?=$logo?>' height=85 width=85 border="0"></td>
                  <td align=center><img src="images/guildbanner/<?=$dados[3]?>"/ width="270" height="85" border="0"></td>  
		</tr>
      </table></td>
  </tr>
<? } ?>
  <tr>
    <td height="14" valign="middle">&nbsp;</td>
  </tr>
  <tr>



<div class='' style='float: left;'>  <?
  $Query_Dados = mssql_query("select top 1 name,resetao,accountid,foto FROM Character order by resetao desc");
  for($i=0;$i<mssql_num_rows($Query_Dados);$i++) {
  $rank = $i+1;
  $dados = mssql_fetch_row($Query_Dados);		
?>
  <tr>
          <div class="header13px">Top MR's</div>
    <td height="0" valign="middle"><table width="0" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td><div class="header13px" align="center"><a href="index.php?go=csearch&char=<?=$dados[0]?>"><?=$dados[0]?></a>
       <tr>
         <td align=center><img src="images/chars/<?=$dados[3]?>"/ width="87" height="105" border="0"></td>    

        <tr>

          <td><div class="header13px" align="center">(<?=$dados[1]?> MR's)</div></td><div></div></div></div></div></div>
        </tr>


		</tr><tr>
      </table></td>

<? } ?></div>


<br>


<div class='' style='float: left;'>  <?
  $Query_Dados = mssql_query("select top 1 name,resets,accountid,foto FROM Character order by resets desc");
  for($i=0;$i<mssql_num_rows($Query_Dados);$i++) {
  $rank = $i+1;
  $dados = mssql_fetch_row($Query_Dados);		
?>
  <tr>
          <div class="header13px">Top Resets</div>
    <td height="0" valign="middle"><table width="0" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td><div class="header13px" align="center"><a href="index.php?go=csearch&char=<?=$dados[0]?>"><?=$dados[0]?></a>
       <tr>
         <td align=center><img src="images/chars/<?=$dados[3]?>"/ width="87" height="105" border="0"></td>    

        <tr>

          <td><div class="header13px" align="center">(<?=$dados[1]?> Resets)</div></td><div></div></div></div></div></div>
        </tr>


		</tr>
      </table></td>

<? } ?></div>







<div class='' style='float: left;'>  <?
  $Query_Dados = mssql_query("select top 1 name,PkLevel,accountid,foto from Character order by PkLevel desc");
  for($i=0;$i<mssql_num_rows($Query_Dados);$i++) {
  $rank = $i+1;
  $dados = mssql_fetch_row($Query_Dados);		
?>
  <tr>
          <div class="header13px">Top Pks</div>
    <td height="0" valign="middle"><table width="0" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td><div class="header13px" align="center"><a href="index.php?go=csearch&char=<?=$dados[0]?>"><?=$dados[0]?></a>
       <tr>
         <td align=center><img src="images/chars/<?=$dados[3]?>"/ width="87" height="105" border="0"></td>       

        <tr>

          <td><div class="header13px" align="center">(<?=$dados[1]?> Kill's)</div></td><div></div></div></div></div></div>
        </tr>


		</tr>
      </table></td>

<? } ?></div>









  <?
  $Query_Dados = mssql_query("SELECT TOP 1 name,PkCount,accountid,foto from Character order by PkCount desc"); 
  for($i=0;$i<mssql_num_rows($Query_Dados);$i++) {
  $rank = $i+1;
  $dados = mssql_fetch_row($Query_Dados);		
?>
  <tr>
          <div class="header13px" align="left"> Top Hero</div>
<td height="0" valign="middle"><table width="0" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td><div class="header13px" align="center"><a href="index.php?go=csearch&char=<?=$dados[0]?>"><?=$dados[0]?></a>
       <tr>
         <td align=center><img src="images/chars/<?=$dados[3]?>"/ width="87" height="105" border="0"></td>     
        <tr>
	<tr>
          <td><div class="header13px" align="center">(-<?=$dados[1]?> Kill's)</div></td><div></div></div></div></div></div>
        </tr>


		</tr>
      </table></td>

<? } ?>




        </tr>
    </table>
    </td>
  </tr>
</div>
  <p>
<?
include "cnn.php";
?>

  