<?php
include("module/stat-menu.php");
  $result = mysql_query("SELECT clan_data.*,char_name,csum,ccount,cavg FROM clan_data INNER JOIN characters ON clan_data.leader_id=characters.charId LEFT JOIN (SELECT clanid, SUM(level) AS csum, count(level) AS ccount, AVG(level) AS cavg FROM characters WHERE clanid GROUP BY clanid) AS levels ON clan_data.clan_id=levels.clanid ORDER BY clan_level DESC, csum DESC", $link)
    or die ("Error: ".mysql_error());

print '<table>
<caption><br><b>..:: Clans Top ::..</b><br><br><hr></caption>
<thead>
<tr style="vertical-align: bottom;">
<th>|Clan Name| </th>
<th> Leader|</th>
<th class="sortedColumn"> Level|</th>
<th> Castle|</th>
<th> Soma de lv|</th>
<th> Membros|</th>
<th>Media lv|</th>
</tr>
</thead>
<tfoot>
<tr><td colspan="10" style="text-align: right;">'.$L2JBS_lang["clantop_total"].': '.mysql_num_rows($result).'</td></tr>
</tfoot>
<tbody id="TblBdy">
';

  $i=1;
  while ($row=mysql_fetch_array($result))
  {
    switch ($row["hasCastle"])
    {
      case 1: $row["hasCastle"]=$L2JBS_lang["clantop_gludiocastle"]; break;
      case 2: $row["hasCastle"]=$L2JBS_lang["clantop_dioncastle"]; break;
      case 3: $row["hasCastle"]=$L2JBS_lang["clantop_girancastle"]; break;
      case 4: $row["hasCastle"]=$L2JBS_lang["clantop_orencastle"]; break;
      case 5: $row["hasCastle"]=$L2JBS_lang["clantop_adencastle"]; break;
      case 6: $row["hasCastle"]=$L2JBS_lang["clantop_innadrilcastle"]; break;
      default: $row["hasCastle"]=$L2JBS_lang["clantop_nocastle"]; 
    }
    print "<tr". (($i++ % 2) ? "" : " class=\"alternateRow\"") ."><td><a href=\"index.php?d=module&p=clanview&clan_name=". $row["clan_name"]."\">". htmlspecialchars($row["clan_name"]). "</a></td><td>". $row["char_name"]. "</td><td class=\"numeric sortedColumn\">".$row["clan_level"]. "</td><td>".$row["hasCastle"]. "</td><td class=\"numeric\">".$row["csum"]. "</td><td class=\"numeric\">".$row["ccount"]. "</td><td class=\"numeric\">".$row["cavg"]. "</td></tr>\n";
  }
  print "</tbody>\n</table>\n";
  mysql_close($link);
?>

<?php
include("module/stat-menu.php");
?> 
<center><br><b>..:: Clan ::..</b><br><br><hr></center>
<?php
  $result = mysql_query("SELECT clan_data.*,char_name FROM clan_data,characters WHERE clan_name='".@mysql_escape_string($_REQUEST["clan_name"])."' AND leader_id=characters.charId", $link)
    or die ("Error: ".mysql_error());
$show=mysql_fetch_array($result);
$result = mysql_query("SELECT characters.*,classname FROM characters,char_templates WHERE clanid='".$show['clan_id']."' AND char_templates.ClassId=characters.classid AND clanid ORDER BY exp DESC", $link)
    or die ("Error: ".mysql_error());
    
  switch ($show["hasCastle"])
  {
    case 1: $show["hasCastle"]=$L2JBS_lang["clantop_gludiocastle"]; break;
    case 2: $show["hasCastle"]=$L2JBS_lang["clantop_dioncastle"]; break;
    case 3: $show["hasCastle"]=$L2JBS_lang["clantop_girancastle"]; break;
    case 4: $show["hasCastle"]=$L2JBS_lang["clantop_orencastle"]; break;
    case 5: $show["hasCastle"]=$L2JBS_lang["clantop_adencastle"]; break;
    case 6: $show["hasCastle"]=$L2JBS_lang["clantop_innadrilcastle"]; break;
    default: $show["hasCastle"]=$L2JBS_lang["clantop_nocastle"];
  }

  @eval('print "<table>\n<caption>".'.$L2JBS_lang["clanview_captiontemplate"].'."</caption>";');
  include("module/_table.php");
 $result2 = mysql_query("SELECT clan_id,clan_name FROM clan_data", $link)
    or die ("Error: ".mysql_error());
  while ($row2=mysql_fetch_row($result2))
    $clans_array[$row2[0]]=$row2[1];
  $clans_array[0]="";
print '
<thead>
<tr style="vertical-align: bottom;">
<th class="sortedColumn">'.$L2JBS_lang["_table_position"].' </th>
<th>Èìÿ</th><th>
 ';if (($ms22)==1) { echo ' Óðîâåíü'; } print'
 </th> 
 <th>Ïîë</th>
 <th>Ðàñà</th>
 <th>Êëàññ</th><th>
 ';if (($ms25)==1) { echo 'ÏâÏ'; }  print'
 </th><th>
 ';if (($ms26)==1) { echo 'ÏK'; }  print'
 </th>
 <th>Êëàí</th>
</tr>
</thead>
<tfoot>
 <tr><td colspan="8" style="text-align:right;"><br>Èãðîêîâ â ýòîì êëàíå: '.mysql_num_rows($result).'</td></tr>
</tfoot>
<tbody id="TblBdy">
';

$i=1;
while ($row=mysql_fetch_array($result))
{
  $row["sex"] = ($row["sex"]) ? Æ : Ì;
  switch ($row["race"])
  {
    case 1: $row["race"]=ºëüô; break;
    case 2: $row["race"]=äàðê; break;
    case 3: $row["race"]=îðê; break;
    case 4: $row["race"]=ãíîì; break;
    case 5: $row["race"]=êàìàåëü; break;	
    default: $row["race"]=÷åë;
  }

  if ($i%2)
  {
    $rowstyle='';
    if (@$row["online"])
      $rowstyle=' class="online"';
  }

  else
  {
    $rowstyle=' class="alternateRow"';
    if (@$row["online"])
      $rowstyle=' class="alternateRow online"';
  }
  print ' <tr'. $rowstyle .'><td class="numeric sortedColumn">'. $i++ . '</td><td>'. $row["char_name"].'</td><td>
  '; if (($ms22)==1) { print $row["level"]; } print'
  </td><td>'. $row["sex"]. '</td><td>'.$row["race"]. '</td><td>'.$row["classname"]. '</td><td class="numeric">
'; if (($ms25)==1) { print $row["pvpkills"]; } print'
</td><td class="numeric">
'; if (($ms26)==1) { print $row["pkkills"]; } print'
</td><td>
  ';
  if ($clan=$clans_array[$row["clanid"]])
    print '<a href="?id=clantop">'.$clan.'</a>';
  print "</td></tr>\n";
}
print "</tbody>\n</table>\n";
mysql_close($link);
?>