Secret Experience - [Web Site] Script Top Clan / Membros

nao sei se vai ajudar mas ta aqui o meu!

Código:

<?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);

?>

Código:

<?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);

?>

Se Ajudei Agradeça,:laugh: