winziger Ausschnitt für Rankingsystem eines aktuellen Systems:
PHP
<table align="center" border="0" width="100%">
<tr>
<th width="15%">Level</th>
<th width="30%">Charakter</th>
<th>Job</th>
<td></td>
</tr>
<?php
global $mssql;
$jobsdef = array(
0 => array('Vargant', '0.png'),
1 => array('Mercenary', '1.png'),
2 => array('Acrobat', '2.png'),
3 => array('Assist', '3.png'),
4 => array('Magician', '4.png'),
6 => array('Knight', '6.png'),
7 => array('Blade', '7.png'),
8 => array('Jester', '8.png'),
9 => array('Ranger', '9.png'),
10 => array('Ringmaster', '10.png'),
11 => array('Billposter', '11.png'),
12 => array('Psykeeper', '12.png'),
13 => array('Elementor', '13.png'),
16 => array('Knight Master', '6.png'),
17 => array('Blade Master', '7.png'),
18 => array('Jester Master', '8.png'),
19 => array('Ranger Master', '9.png'),
20 => array('Ringmaster Master', '10.png'),
21 => array('Billposter Master', '11.png'),
22 => array('Psykeeper Master', '12.png'),
23 => array('Elementor Master', '13.png'),
24 => array('Knight Hero', '6.png'),
25 => array('Blade Hero', '7.png'),
26 => array('Jester Hero', '8.png'),
27 => array('Ranger Hero', '9.png'),
28 => array('Ringmaster Hero', '10.png'),
29 => array('Billposter Hero', '11.png'),
30 => array('Psykeeper Hero', '12.png'),
31 => array('Elementor Hero', '13.png'),
);
$query = $mssql->query("USE [CHARACTER_01_DBF] SELECT TOP 30 * FROM [CHARACTER_TBL] WHERE m_chAuthority = 'F' ORDER BY m_nLevel DESC");
while ($getranking = mssql_fetch_assoc($query))
{
$img = '<img src="./images/jobs/'.$jobsdef[$getranking['m_nJob']][1].'" title="'.$jobsdef[$getranking['m_nJob']][0].'" />';
if ($getranking['m_nJob'] >= 14 && $getranking['m_nJob'] < 24)
{
if ($getranking['m_nLevel'] >= 60 && $getranking['m_nLevel'] < 70)
$img .= '<img src="./images/jobs/m1.png" alt="Master" title="Master Stufe 1" />';
elseif ($getranking['m_nLevel'] >= 70 && $getranking['m_nLevel'] < 80)
$img .= '<img src="./images/jobs/m2.png" alt="Master" title="Master Stufe 2" />';
elseif ($getranking['m_nLevel'] >= 80 && $getranking['m_nLevel'] < 90)
$img .= '<img src="./images/jobs/m3.png" alt="Master" title="Master Stufe 3" />';
elseif ($getranking['m_nLevel'] >= 90 && $getranking['m_nLevel'] < 100)
$img .= '<img src="./images/jobs/m4.png" alt="Master" title="Master Stufe 4" />';
elseif ($getranking['m_nLevel'] >= 100 && $getranking['m_nLevel'] < 110)
$img .= '<img src="./images/jobs/m5.png" alt="Master" title="Master Stufe 5" />';
elseif ($getranking['m_nLevel'] >= 110 && $getranking['m_nLevel'] <= 120)
$img .= '<img src="./images/jobs/m6.png" alt="Master" title="Master Stufe 6" />';
}
elseif ($getranking['m_nJob'] >= 24)
{
$img .= '<img src="./images/jobs/h.png" alt="Hero" title="Hero" />';
}
echo '<tr>';
echo '<td>'.$getranking['m_nLevel'].'</td>';
echo '<td>'.$getranking['m_szName'].'</td>';
echo '<td>'.$jobsdef[$getranking['m_nJob']][0].'</td>';
echo '<td>'.$img.'</td>';
echo '</tr>';
}
?>
</table>
Alles anzeigen