x-MU.net форум

top_list ?

Спойлер

[свернуть]

function top_list($what=NULL,$top=NULL) {
require("config.php");
if($top==NULL) {$top = '5';}
if($what==NULL) {$what = 'char';}
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0'><tr>";
if($mmw[gm]=='no') {$gm_not_show = "WHERE ctlcode !='32' AND ctlcode !='8'";}
if($what=='char') {
$total = mssql_query("SELECT TOP $top Name,cLevel,Reset FROM Character $gm_not_show ORDER BY reset desc, clevel desc");
$first_row = mssql_fetch_row(mssql_query("SELECT TOP 1 Reset FROM Character $gm_not_show ORDER BY reset desc, clevel desc"));
if($first_row[0] <= 0) {$what_of_sort = mmw_lang_level;} else {$what_of_sort = mmw_lang_reset;}
echo "<td width='14'><b>#</b></td><td><b>".mmw_lang_character."</b></td><td align='right' width='10'><b>$what_of_sort</b></td></td>";

for($i=0; $i<$top; ++$i) {
$rank = $i + 1;
$row = mssql_fetch_row($total);
if($first_row[0] <= 0) {$top_stat = $row[1];} else {$top_stat = $row[2];}
echo "</tr>n<tr><td>$rank</td><td><a href=?op=character&character=$row[0]>$row[0]</a></td><td align='center'>$top_stat</td>";
}
}
elseif($what=='pk') {
$total = mssql_query("SELECT TOP $top Name,PKcount FROM Character $gm_not_show ORDER BY pkcount desc");
$first_row = mssql_fetch_row(mssql_query("SELECT TOP 1 Reset FROM Character $gm_not_show ORDER BY reset desc, clevel desc"));
echo "<td width='14'><b>#</b></td><td><b>".mmw_lang_character."</b></td><td align='right' width='10'><b>".mmw_lang_killed."</b></td></td>";

for($i=0; $i<$top; ++$i) {
$rank = $i + 1;
$row = mssql_fetch_row($total);
echo "</tr>n<tr><td>$rank</td><td><a href=?op=character&character=$row[0]>$row[0]</a></td><td align='center'>$row[1]</td>";
}
}
elseif($what=='guild') {
$total = mssql_query("SELECT TOP $top G_Name,G_Score,G_Mark FROM Guild WHERE G_Name!='$mmw[gm_guild]' ORDER BY G_score desc");
echo "<td width='14'><b>#</b></td><td><b>".mmw_lang_guild."</b></td><td align='right' width='10'><b>".mmw_lang_score."</b></td></td>";

for($i=0; $i<$top; ++$i) {
$rank = $i + 1;
$row = mssql_fetch_row($total);
echo "</tr>n<tr><td>$rank</td><td><a href=?op=guild&guild=$row[0]>$row[0]</a></td><td align='center'>$row[1]</td>";
}
}
elseif($what=='ref') {
$total = mssql_query("SELECT TOP $top ref_acc,count(ref_acc) FROM memb_info WHERE ref_acc!=' ' group by ref_acc order by count(ref_acc) desc");
echo "<td width='14'><b>#</b></td><td><b>".mmw_lang_account."</b></td><td align='right' width='10'><b>".mmw_lang_referral."</b></td></td>";

for($i=0; $i<$top; ++$i) {
$rank = $i + 1;
$row = mssql_fetch_row($total);
echo "</tr>n<tr><td>$rank</td><td><a href=?op=profile&profile=$row[0]>$row[0]</a></td><td align='center'>$row[1]</td>";
}
}
elseif($what=='best') {
$strong_result = mssql_query("SELECT TOP 1 Name FROM Character $gm_not_show ORDER BY strength DESC, dexterity DESC, vitality DESC, energy DESC, Leadership DESC");
$strong_row = mssql_fetch_row($strong_result);
if(empty($strong_row[0])) {$strong = '---';}
else {$strong = '<a href="?op=character&character='.$strong_row[0].'">'.$strong_row[0].'</a>';}
echo "<td width='100%'><b>".mmw_lang_very_strong.": $strong</b>";

if($mmw['gm']=='no'){$no_gm_in_top = "AND ctlcode!='32' AND ctlcode!='8'";}
for($i=0;$i<'6';$i++) {
$class = $i * 16;
$strongs_result = mssql_query("SELECT TOP 1 Name FROM Character WHERE class>='$class' AND class<='".($class+15)."' $no_gm_in_top ORDER BY strength DESC, dexterity DESC, vitality DESC, energy DESC, Leadership DESC");
$strongs_row = mssql_fetch_row($strongs_result);
echo '<br>» '.char_class($class,'full').': ';
if(empty($strongs_row[0])) {echo '---';}
else {echo '<a href="?op=character&character='.$strongs_row[0].'">'.$strongs_row[0].'</a>';}
}

$gamer_result = mssql_query("SELECT TOP 1 GameIDC FROM AccountCharacter WHERE Id=(SELECT TOP 1 memb___id FROM MEMB_STAT WHERE ConnectStat='1' ORDER BY ConnectTM ASC)");
$gamer_row = mssql_fetch_row($gamer_result);
$guild_result = mssql_query("SELECT TOP 1 G_Name FROM Guild ORDER BY G_Score DESC");
$guild_row = mssql_fetch_row($guild_result);
if(empty($gamer_row[0])) {$gamer = '---';}
else {$gamer = '<a href="?op=character&character='.$gamer_row[0].'">'.$gamer_row[0].'</a>';}
if(empty($guild_row[0])) {$best_guild = '---';}
else {$best_guild = '<a href="?op=guild&guild='.$guild_row[0].'">'.$guild_row[0].'</a>';}
echo "<br><b>".mmw_lang_best_gamer.": $gamer</b><br><b>".mmw_lang_best_guild.": $best_guild</b></td>";
}
elseif($what=='chart') {

$total = mssql_query("SELECT TOP 2 Name,cLevel,Reset FROM Character $gm_not_show ORDER BY Reset desc, clevel desc");
for($i=0; $i<2; ++$i) {
$rank = $i + 1;
$row = mssql_fetch_row($total);

if ($rank == 2)echo "</tr>n<tr><td>$rank</td><td><a href=?op=character&character=$row[0]>$row[0]</a></td><td align='center'>$row[2]</td>";
}
echo "</tr></table>";
}