Как собрать классы игроков в MU Online и других играх?

[Sweng]

Рэйтинг игроков, с сортировкой по классам, гильдией и статусом с кросс табличными запросами.

функция

Код Выделить Развернуть

function char_class($class) {
if($class == 0){$class_row1 = array('off'=>'DW','full'=>'Dark Wizard');}
elseif($class == 1){$class_row1 = array('off'=>'SM','full'=>'Soul Master');}
elseif($class == 2 or $class == 3){$class_row1 = array('off'=>'GrM','full'=>'Grand Master');}
elseif($class == 16){$class_row1 = array('off'=>'DK','full'=>'Dark Knight');}
elseif($class == 17){$class_row1 = array('off'=>'BK','full'=>'Blade Knight');}
elseif($class == 18 or $class == 19){$class_row1 = array('off'=>'BM','full'=>'Blade Master');}
elseif($class == 32){$class_row1 = array('off'=>'Elf','full'=>'Fairy Elf');}
elseif($class == 33){$class_row1 = array('off'=>'ME','full'=>'Muse Elf');}
elseif($class == 34 or $class == 35){$class_row1 = array('off'=>'HE','full'=>'High Elf');}
elseif($class == 48){$class_row1 = array('off'=>'MG','full'=>'Magic Gladiator');}
elseif($class == 49 or $class == 50){$class_row = array('off'=>'DM','full'=>'Duel Master');}
elseif($class == 64){$class_row1 = array('off'=>'DL','full'=>'Dark Lord');}
elseif($class == 65 or $class == 66){$class_row1 = array('off'=>'LE','full'=>'Lord Emperor');}
elseif($class == 80){$class_row1 = array('off'=>'Sum','full'=>'Summoner');}
elseif($class == 81){$class_row1 = array('off'=>'Bsum','full'=>'Bloody Summoner');}
elseif($class == 82 or $class == 83){$class_row1 = array('off'=>'Dim','full'=>'Dimension Master');}
else{$class_row1 = array('off'=>'Unknow','full'=>'Unknow');}
return $class_row1;
}
скрипт

Код Выделить Развернуть

<?
$sort=$_GET['sort'];
if(empty($sort) or !isset($sort)){
$sort='all';
}
if($sort != 'bk' and $sort != 'sm' and $sort != 'elf' and $sort != 'dl' and $sort != 'mg' and $sort != 'sum' and $sort != 'all'){
$sort='all';
}
if($sort=='bk'){
$query = "SELECT TOP 50 Character.Name,Class,cLevel,Resets, ctlcode, connectstat, GameIDC, G_Name FROM Character full join MEMB_STAT on AccountID=memb___id full join AccountCharacter on memb___id=id full join GuildMember on Character.Name=GuildMember.Name where (Class='17' or Class='18' or Class='19' or Class='16' or Class='20') AND (ctlcode<>1 AND ctlcode<>8 AND ctlcode<>24 AND ctlcode<>32) ORDER by Resets DESC, cLevel DESC";
}elseif($sort=='sm'){
$query = "SELECT TOP 50 Character.Name,Class,cLevel,Resets,ctlcode,connectstat, GameIDC, G_Name FROM Character full join MEMB_STAT on AccountID=memb___id full join AccountCharacter on memb___id=id full join GuildMember on Character.Name=GuildMember.Name where (Class='0' or Class='1' or Class='2' or Class='3' or Class='4') AND (ctlcode<>1 AND ctlcode<>8 AND ctlcode<>24 AND ctlcode<>32) ORDER by Resets DESC, cLevel DESC";
}elseif($sort=='elf'){
$query = "SELECT TOP 50 Character.Name,Class,cLevel,Resets,ctlcode, connectstat, GameIDC, G_Name FROM Character full join MEMB_STAT on AccountID=memb___id full join AccountCharacter on memb___id=id full join GuildMember on Character.Name=GuildMember.Name where (Class='32' or Class='33' or Class='34' or Class='35' or Class='36') AND (ctlcode<>1 AND ctlcode<>8 AND ctlcode<>24 AND ctlcode<>32) ORDER by Resets DESC, cLevel DESC";
}elseif($sort=='mg'){
$query = "SELECT Character.Name,Class,cLevel,Resets,ctlcode,connectstat,GameIDC,G_Name FROM Character full join MEMB_STAT on AccountID=memb___id full join AccountCharacter on memb___id=id full join GuildMember on Character.Name=GuildMember.Name where (Class='48' or Class='49' or Class='50' or Class='51') AND (ctlcode<>1 AND ctlcode<>8 AND ctlcode<>24 AND ctlcode<>32) ORDER by Resets DESC, cLevel DESC";
}else{
$query = "SELECT TOP 50 Character.Name,Class,cLevel,Resets,ctlcode, connectstat, GameIDC, G_Name FROM Character full join MEMB_STAT on AccountID=memb___id full join AccountCharacter on memb___id=id full join GuildMember on Character.Name=GuildMember.Name where (ctlcode<>1 AND ctlcode<>8 AND ctlcode<>24 AND ctlcode<>32) ORDER by Resets DESC, cLevel DESC";
}
$result = mssql_query($query);
$sql = mssql_query("SELECT count(*) FROM CHARACTER");
$results2['char'] = mssql_result($sql, 0, 0);
?>
<center>
<b><a href="tops-char-all.html">Все</a> || <a href="tops-char-bk.html">DK/BK</a> || <a href="tops-char-sm.html">DW/SM</a> || <a href="tops-char-elf.html">Elf</a> || <a href="tops-char-mg.html">MG</a>
</center>
<table border="0" cellspacing="2" width="95%" class="ipbtable" align="center">
<tr>
<td colspan="6" align="left"><b><u>Всего чаров: <? echo $results2['char']; ?></u></b></td>
</tr>
<tr>
<td class="darkrow1" width="50" align="center"><b>Ранг</b></td>
<td class="darkrow1" align="center"><b>Гильдия</b></td>
<td class="darkrow1" align="center"><b>Имя</b></td>
<td class="darkrow1" align="center"><b>Професия</b></td>
<td class="darkrow1" align="center"><b>Уровень</b></td>
<td class="darkrow1" align="center"><b>Ресет</b></td>
<td class="darkrow1" align="center">Статус</td>
</tr>
<?
$i=0;
while($row=mssql_fetch_array($result)){
$i++;
echo'    <tr>
<td class="row2" width="50" align="center"><font color="red">'.$i.'</font></td>
<td class="row2"><b>';
if(empty($row['7'])){
echo "<font color="#999900">Нет гильдии</font>";
}else{
echo "<a href="guild-info-$row[7].html"><font color="#993300">$row[7]</font></a>";
}
echo'</b></td>
<td class="row2"><font color="black"><b><a href="char-info-'.$row['0'].'.html">'.$row['0'].'</a></b></font></td>
<td class="row2"><font color="black">'.char_class($row['1'],"full").'</font></td>
<td class="row2" align="center"><font color="blue"><b>'.$row['2'].'</b></font></td>
<td class="row2" align="center"><font color="green">'.$row['3'].'</font></td>';
if($row['5']==1 and $row['6']==$row['0']){
echo "<td class="row2" align="center"><font color="green"><b>Online</b></font></td>";
}else{
echo "<td class="row2" align="center"><font color="red"><b>Offline</b></font></td>";
}
'</tr>';
}
?>
</table>


[epmak]

эм...а в функцию то зачем было собирать классы игроков? она ж в скрипте встречается 1 раз всего, да и больше нигде не к чему, вроде как Оо

[Sweng]

эм...а в функцию то зачем было собирать классы игроков? она ж в скрипте встречается 1 раз всего, да и больше нигде не к чему, вроде как Оо

Делал для своего Вэба, используется у меня не только в этом скрипте, вот и собирал.

Как есть, так и скопировал, там даже ссылки под мой реврайт сделаны у кого есть элементарные знания сделает под себя и если кому то понадобится это.