<?php
/*======================================================================*\
|| #################################################################### ||
|| # eGamers of Tomorrow Battlefield 3 Leaderboard                    # ||
|| # ---------------------------------------------------------------- # ||
|| # Dieses Copyright darf nicht entfernt werden                      # ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------Teil des Bf3 Leaderboards von EoT-----------------# ||
|| #                      http://eot-clan.net                         # ||
|| #################################################################### ||
\*======================================================================*/

require_once ('../inc/config.php');
require_once ('../language/'.$row['language'].'.php');

$EoT = new eGamersofTomorrow;

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
          "http://www.w3.org/TR/html4/loose.dtd">
        <title>BF3 LB / Vehicles</title>
        <?php echo $styleSettings; ?>
          <div class="body_bfLB" style="width:<?php echo $style['IndexDivWidth']; ?>px;">   
	           <?php echo $Banner; ?>
        <ul id="statstabs" class="shadetabs" style="margin-top:10px;margin-bottom:-10px;">
        <li><a href="../index.php">Leaderboard</a></li>
        <li><a href="class.php"><?php echo LANG_CLANSTATS_TAB_KITS; ?></a></li>
        <li><a href="skill.php"><?php echo LANG_CLANSTATS_TAB_SKILL; ?></a></li>
        <li><a href="teamplay.php">Teamplay</a></li>
        <li><a href="vehicles.php" class="selected"><?php echo LANG_CLANSTATS_TAB_VEHICLES; ?></a></li>
        <li><a href="weaponstats.php"><?php echo LANG_CLANSTATS_TAB_WEAPONS; ?></a></li>
        <li><a href="ribbonsstats.php">Ribbons</a></li>
        <li><a href="medalsstats.php">Medals</a></li>
        <li><a href="events.php">Events</a></li>
        <li><a href="serverHistory.php">S.History</a></li>
      </ul>
				<table class="default" style="width:<?php echo $style['IndexTableWidth']; ?>px;">
        <td class="head" colspan="10" cellspacing="0"><?php echo LANG_CLANSTATS_TITLE; ?></td>
        <tr>
        	<td class="result" width="60px" style="border-right:<?php echo $style['result_border']; ?>"><img src="<?php echo $domain;?>/img/fav/big/tank.png" title="Tank" alt="Tank" width="40px"/><br /><?php echo LANG_CLANSTATS_TANK; ?></td>
        	<?php
        	$qry = "SELECT soldiername, mbtT90_kills+mbtM1A_kills AS tankkills FROM ".DBPrefix."generalStats LEFT JOIN ".DBPrefix."vehicles on stats_pid = pid  ORDER by tankkills DESC LIMIT 5 ";
            $result = mysql_query($qry);
            while(($data = mysql_fetch_assoc($result)) !== FALSE ) {
	         ?> 
	         <td class="result" style="font-size:11px;"><a href="../stats.php?name=<?php echo rawurlencode($data['soldiername']); ?>" target="_self"><b><?php echo $EoT->nameTrimchars($data['soldiername']); ?></b></a><br /><br /><div class="text" style="width:<?php echo $textwidth; ?>px"><?php echo $EoT->points($data['tankkills']); ?></div></td>
	         <?php
           }
         ?>
         <tr>
        	<td class="result" width="20px" style="border-right:<?php echo $style['result_border']; ?>"><img src="<?php echo $domain;?>/img/fav/big/light_tank.png" title="Light Tank" alt="Light Tank" width="40px"/><br /><?php echo LANG_CLANSTATS_LIGHT_TANK; ?></td>
        	<?php
        	$qry = "SELECT soldiername, ifvLAV_kills+ifvBMP_kills+ifvBTR90_kills AS lighttankkills FROM ".DBPrefix."generalStats LEFT JOIN ".DBPrefix."vehicles on stats_pid = pid  ORDER by lighttankkills DESC LIMIT 5 ";
            $result = mysql_query($qry);
            while(($data = mysql_fetch_assoc($result)) !== FALSE ) {
	         ?> 
	         <td class="result"  style="font-size:11px;"><a href="../stats.php?name=<?php echo rawurlencode($data['soldiername']); ?>" target="_self"><b><?php echo $EoT->nameTrimchars($data['soldiername']); ?></b></a><br /><br /><div class="text" style="width:<?php echo $textwidth; ?>px"><?php echo $EoT->points($data['lighttankkills']); ?></div></td>
	         <?php
           }
         ?>
         <tr>
        	<td class="result" width="20px" style="border-right:<?php echo $style['result_border']; ?>"><img src="<?php echo $domain;?>/img/fav/big/airdefense.png" title="AIR DEFENSE" alt="AIR DEFENSE" width="40px"/><br /><?php echo LANG_CLANSTATS_LIGHT_AIR_DEFENSE; ?></td>
        	<?php
        	$qry = "SELECT soldiername, aa9k22_kills+aaLAV_kills AS airdefense FROM ".DBPrefix."generalStats LEFT JOIN ".DBPrefix."vehicles on stats_pid = pid  ORDER by airdefense DESC LIMIT 5 ";
            $result = mysql_query($qry);
            while(($data = mysql_fetch_assoc($result)) !== FALSE ) {
	         ?> 
	         <td class="result" style="font-size:11px;"><a href="../stats.php?name=<?php echo rawurlencode($data['soldiername']); ?>" target="_self"><b><?php echo $EoT->nameTrimchars($data['soldiername']); ?></b></a><br /><br /><div class="text" style="width:<?php echo $textwidth; ?>px"><?php echo $EoT->points($data['airdefense']); ?></div></td>
	         <?php
           }
       ?>
         <tr>
        	<td class="result" width="20px" style="border-right:<?php echo $style['result_border']; ?>"><img src="<?php echo $domain;?>/img/fav/big/heliscout.png" title="Scout Heli" alt="Scout Heli" width="40px"/><br /><?php echo LANG_CLANSTATS_LIGHT_AIR_HELI; ?></td>
        	<?php
        	$qry = "SELECT soldiername, shAH6_kills+shz11_kills AS heliscout FROM ".DBPrefix."generalStats LEFT JOIN ".DBPrefix."vehicles on stats_pid = pid  ORDER by heliscout DESC LIMIT 5 ";
            $result = mysql_query($qry);
            while(($data = mysql_fetch_assoc($result)) !== FALSE ) {
	         ?> 
	         <td class="result"  style="font-size:11px;"><a href="../stats.php?name=<?php echo rawurlencode($data['soldiername']); ?>" target="_self"><b><?php echo $EoT->nameTrimchars($data['soldiername']); ?></b></a><br /><br /><div class="text" style="width:<?php echo $textwidth; ?>px"><?php echo $EoT->points($data['heliscout']); ?></div></td>
	         <?php
           }
        ?>
         <tr>
        	<td class="result" width="20px" style="border-right:<?php echo $style['result_border']; ?>"><img src="<?php echo $domain;?>/img/fav/big/jet.png" title="Jet" alt="Jet" width="40px"/><br /><?php echo LANG_CLANSTATS_LIGHT_AIR_JET; ?></td>
        	<?php
        	$qry = "SELECT soldiername, jaSU25_kills+jfF18_kills+jfSu35_kills+jaA10_kills+jfx1F35JSF_kills AS jet FROM ".DBPrefix."generalStats LEFT JOIN ".DBPrefix."vehicles on stats_pid = pid  ORDER by jet DESC LIMIT 5 ";
            $result = mysql_query($qry);
            while(($data = mysql_fetch_assoc($result)) !== FALSE ) {
	         ?> 
	         <td class="result" style="font-size:11px;"><a href="../stats.php?name=<?php echo rawurlencode($data['soldiername']); ?>" target="_self"><b><?php echo $EoT->nameTrimchars($data['soldiername']); ?></b></a><br /><br /><div class="text" style="width:<?php echo $textwidth; ?>px"><?php echo $EoT->points($data['jet']); ?></div></td>
	         <?php
           }
        ?>
         <tr>
        	<td class="result" width="20px" style="border-right:<?php echo $style['result_border']; ?>"><img src="<?php echo $domain;?>/img/fav/big/heliattack.png" title="Heliattack" alt="Heliattack" width="40px"/><br /><?php echo LANG_CLANSTATS_LIGHT_AIR_ATTACK_HELI; ?></td>
        	<?php
        	$qry = "SELECT soldiername, ahAH1Z_kills+ahMi28_kills AS heliattack FROM ".DBPrefix."generalStats LEFT JOIN ".DBPrefix."vehicles on stats_pid = pid  ORDER by heliattack DESC LIMIT 5 ";
            $result = mysql_query($qry);
            while(($data = mysql_fetch_assoc($result)) !== FALSE ) {
	         ?> 
	         <td class="result" style="font-size:11px;"><a href="../stats.php?name=<?php echo rawurlencode($data['soldiername']); ?>" target="_self"><b><?php echo $EoT->nameTrimchars($data['soldiername']); ?></b></a><br /><br /><div class="text" style="width:<?php echo $textwidth; ?>px"><?php echo $EoT->points($data['heliattack']); ?></div></td>
	         <?php
           }
           ?>
         <tr>
        	<td class="result" width="20px" style="border-right:<?php echo $style['result_border']; ?>"><img src="<?php echo $domain;?>/img/fav/big/other.png" title="Other" alt="Other" width="40px"/><br /><?php echo LANG_CLANSTATS_OTHER; ?></td>
        	<?php
        	$qry = "SELECT soldiername, trHum_kills+trVDV_kills+trVod_kills+trUH1_kills+trITV_kills+sKorn_kills+atTOW_kills+trRIB_kills+saaCRAM_kills+saaPant_kills+trDpv_kills+trSkid_kills AS other FROM ".DBPrefix."generalStats LEFT JOIN ".DBPrefix."vehicles on stats_pid = pid  ORDER by other DESC LIMIT 5 ";
            $result = mysql_query($qry);
            while(($data = mysql_fetch_assoc($result)) !== FALSE ) {
	         ?> 
	         <td class="result" style="font-size:11px;"><a href="../stats.php?name=<?php echo rawurlencode($data['soldiername']); ?>" target="_self"><b><?php echo $EoT->nameTrimchars($data['soldiername']); ?></b></a><br /><br /><div class="text" style="width:<?php echo $textwidth; ?>px"><?php echo $EoT->points($data['other']); ?></div></td>
	         <?php
           }
?>
      </td> 
		  </tr>
	</table>
	
	<?php  include_once '../inc/footer.php';
	        echo '</div>';


