<div class="col-3">
<div class="boxes-top">&nbsp;</div>
<?php
include("login.inc.php");
require("include/config.inc.php");
  $sqlHp = mysql_connect(SQL_HP_HOST, SQL_HP_USER, SQL_HP_PASS);
  $sqlServ = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS);
?>
<div class="boxes-middle">&nbsp;</div>
<div class="modul-box modul-box-2">
<div class="modul-box-bg">
<div class="modul-box-bg-bottom">
<h3>Live Chat!</h3>
<a href="index.php?s=chat" class="btn chat-btn"></a> </div>
</div>
</div>
<div class="boxes-middle">&nbsp;</div>
<div class="modul-box modul-box-2">
<div class="modul-box-bg">
<div class="modul-box-bg-bottom">
<h3>Servidor</h3>
<center><div class="form-score"><div class="select-replacement">
<select>
<option value="1" selected="selected"><?PHP echo $serverSettings['titel']; ?></option>
</select></div></div>
</center>						
<h3 style="margin-top:0">Personajes.</h3>
<div class="form-score">
<div id="highscore-player">
<?PHP
  $sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player_index.empire,guild.name AS guild_name 
  FROM player.player 
  LEFT JOIN player.player_index 
  ON player_index.id=player.account_id 
  LEFT JOIN player.guild_member 
  ON guild_member.pid=player.id 
  LEFT JOIN player.guild 
  ON guild.id=guild_member.guild_id
  INNER JOIN account.account 
  ON account.id=player.account_id
  WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
  ORDER BY player.level DESC, player.exp DESC 
  LIMIT 0,10";
  //echo $sqlCmd;
  $sqlQry = mysql_query($sqlCmd,$sqlServ);
  $i=0;
  while($getPlayers = mysql_fetch_object($sqlQry)) {
$i = $i + 1;
$zF = ($i%2==0) ? "light" : "";
    echo"<div align=\"left\">
	<ul>
    <li class =\"$zF\"><strong>". $i ."</strong> - <a href=\"index.php?s=players\" class=\"first\">".$getPlayers->name." ".$gReiche[$getPlayers->empire]."</a></li></ul></div>";
  }
?>
</div>
<br/>
<div align="left"><a href="index.php?s=players" class="btn" rel="nofollow">Iop 100</a><br/></div>
</div>                       
<h3 style="margin-top:0">Gremios.</h3>								
<div class="form-score">                               
 <div id="highscore-guild">
<?PHP
  $sqlCmd2 = "SELECT guild.name, guild.ladder_point 
  FROM player.guild 
  ORDER BY ladder_point DESC
  LIMIT 0,10";
  //echo $sqlCmd;
  $sqlQry = mysql_query($sqlCmd2,$sqlServ);
  $i=0;
  while($getGuilds = mysql_fetch_object($sqlQry)) {
$i = $i + 1;
$zF = ($i%2==0) ? "light" : "";
    echo"<div align=\"left\">
	<ul>
    <li class =\"$zF\"><strong>". $i ."</strong> - <a href=\"index.php?s=guilds\" class=\"first\">".$getGuilds->name."</a></li></ul></div>";
	}
?>
                      
</div>						
<br/>                       
<div align="left">
<a href="index.php?s=guilds" class="btn" rel="nofollow">Iop 100</a></div><br/>   
</div>							
</div>			
</div>				
</div>					
<div class="boxes-bottom"></div>		
</div>	
</div>	
</div>
</div>