Habe hier einmal ein Ranking, dass deinem Wunsch möglicherweise gerecht werden könnte. Es handelt sich dabei um eine kleinere Modifizierung des Rankings, dass du aus
[Only registered and activated users can see links. Click Here To Register...] Thread entnehmen kannst.
Es setzt sich aus 2 php-Dateien zusammen, einmal der func_ranking.php sowie der "richtigen" ranking.php sowie den Icons für Jobklasse, Master/Hero (Download:
[Only registered and activated users can see links. Click Here To Register...] (Virustotal ist derzeit nicht erreichbar, Virentest folgt in 'nem Edit, solltest du mir nicht vertrauen)).
func_ranking.php
PHP Code:
<?php
// Mastericons
function mastericon($lvl) {
if($lvl >= '60' && $lvl <= '69') {return "<img src='./graphics/ranking/m1.png' alt='MASTER' title='Master' />";}
else if($lvl >= '70' && $lvl <= '79') {return "<img src='./graphics/ranking/m2.png' alt='MASTER' title='Master' />";}
else if($lvl >= '80' && $lvl <= '89') {return "<img src='./graphics/ranking/m3.png' alt='MASTER' title='Master' />";}
else if($lvl >= '90' && $lvl <= '99') {return "<img src='./graphics/ranking/m4.png' alt='MASTER' title='Master' />";}
else if($lvl >= '100' && $lvl <= '109') {return "<img src='./graphics/ranking/m5.png' alt='MASTER' title='Master' />";}
else if($lvl >= '110' && $lvl <= '120') {return "<img src='./graphics/ranking/m6.png' alt='MASTER' title='Master' />";}
}
// Jobbilchen
function getjob($job) {
if ($job == '0') {return "<img src='./graphics/ranking/vagrant.png' alt='Vagrant' title='Vagrant' />";}
if ($job == '1') {return "<img src='./graphics/ranking/mercenary.png' alt='Mercenary' title='Mercenary' />";}
if ($job == '2') {return "<img src='./graphics/ranking/acrobat.png' alt='Acrobat' title='Acrobat' />";}
if ($job == '3') {return "<img src='./graphics/ranking/assist.png' alt='Assist' title='Assist' />";}
if ($job == '4') {return "<img src='./graphics/ranking/magican.png' alt='Magican' title='Magican' />";}
if ($job == '5') {return "Puppeter";}
if ($job == '6') {return "<img src='./graphics/ranking/knight.png' alt='Knight' title='Knight' />";}
if ($job == '7') {return "<img src='./graphics/ranking/blade.png' alt='Blade' title='Blade' />";}
if ($job == '8') {return "<img src='./graphics/ranking/jester.png' alt='Jester' title='Jester' />";}
if ($job == '9') {return "<img src='./graphics/ranking/ranger.png' alt='Ranger' title='Ranger' />";}
if ($job == '10'){return "<img src='./graphics/ranking/ringmaster.png' alt='Ringmaster' title='Ringmaster' />";}
if ($job == '11'){return "<img src='./graphics/ranking/billposter.png' alt='Billposter' title='Billposter' />";}
if ($job == '12'){return "<img src='./graphics/ranking/psykeeper.png' alt='Psykeeper' title='Psykeeper' />";}
if ($job == '13'){return "<img src='./graphics/ranking/elementor.png' alt='Elementor' title='Elementor' />";}
if ($job == '14'){return "Gatekeeper";}
if ($job == '15'){return "Doppler";}
if ($job == '16'){return "<img src='./graphics/ranking/knight.png' alt='Knight' title='Knight' />";}
if ($job == '17'){return "<img src='./graphics/ranking/blade.png' alt='Blade' title='Blade' />";}
if ($job == '18'){return "<img src='./graphics/ranking/jester.png' alt='Jester' title='Jester' />";}
if ($job == '19'){return "<img src='./graphics/ranking/ranger.png' alt='Ranger' title='Ranger' />";}
if ($job == '20'){return "<img src='./graphics/ranking/ringmaster.png' alt='Ringmaster' title='Ringmaster' />";}
if ($job == '21'){return "<img src='./graphics/ranking/billposter.png' alt='Billposter' title='Billposter' />";}
if ($job == '22'){return "<img src='./graphics/ranking/psykeeper.png' alt='Psykeeper' title='Psykeeper' />";}
if ($job == '23'){return "<img src='./graphics/ranking/elementor.png' alt='Elementor' title='Elementor' />";}
if ($job == '24'){return "<img src='./graphics/ranking/knight.png' alt='Hero-Knight' title='Knight' />";}
if ($job == '25'){return "<img src='./graphics/ranking/blade.png' alt='Hero-Blade' title='Blade' />";}
if ($job == '26'){return "<img src='./graphics/ranking/jester.png' alt='Hero-Jester' title='Jester' />";}
if ($job == '27'){return "<img src='./graphics/ranking/ranger.png' alt='Hero-Ranger' title='Ranger' />";}
if ($job == '28'){return "<img src='./graphics/ranking/ringmaster.png' alt='Hero-Ringmaster' title='Ringmaster' />";}
if ($job == '29'){return "<img src='./graphics/ranking/billposter.png' alt='Hero-Billposter' title='Billposter' />";}
if ($job == '30'){return "<img src='./graphics/ranking/psykeeper.png' alt='Hero-Psykeeper' title='Psykeeper' />";}
if ($job == '31'){return "<img src='./graphics/ranking/elementor.png' alt='Hero-Elementor' title='Elementor' />";}
}
// Namen der Orte
function getlocation($map) {
if ($map == '1') {return 'Madrigal';}
if ($map == '2') {return 'Azria';}
if ($map == '3') {return 'Koralleninsel';}
if ($map == '4') {return 'Rartesia';}
if ($map == '21') {return 'Tower (Ebene 1)';}
if ($map == '22') {return 'Tower (Ebene 2)';}
if ($map == '23') {return 'Tower (Ebene 3)';}
if ($map == '24') {return 'Tower (Ebene 4)';}
if ($map == '25') {return 'Tower (Ebene 5)';}
if ($map == '151') {return 'Secret room 0';}
if ($map == '152') {return 'Secret room 1';}
if ($map == '153') {return 'Secret room 2';}
if ($map == '154') {return 'Secret room 3';}
if ($map == '155') {return 'Secret room 4';}
if ($map == '156') {return 'Secret room 5';}
if ($map == '157') {return 'Secret room 6';}
if ($map == '158') {return 'Secret room 7';}
if ($map == '159') {return 'Secret room 8';}
if ($map == '160') {return 'Secret room 9';}
if ($map == '161') {return 'Secret room 10';}
if ($map == '162') {return 'Secret room 11';}
if ($map == '163') {return 'Secret room 12';}
if ($map == '164') {return 'Secret room 13';}
if ($map == '165') {return 'Secret room 14';}
if ($map == '166') {return 'Secret room 15';}
if ($map == '167') {return 'Secret room 16';}
if ($map == '200') {return 'Numazu Dungeon';}
if ($map == '201') {return 'Dekane Mine';}
if ($map == '202') {return 'Guild Siege Territory';}
if ($map == '203') {return 'Volcano';}
if ($map == '204') {return 'Ivillis Temple';}
if ($map == '205') {return 'Ivillis Temple Boss';}
if ($map == '206') {return 'Volkane RED';}
if ($map == '207') {return 'Volkane YELLOW';}
if ($map == '208') {return 'PvP-Arena';}
if ($map == '209') {return 'House';}
if ($map == '211') {return 'O/X Quiz zone';}
if ($map == '212') {return 'Guild House';}
if ($map == '213') {return 'Guild Hall';}
if ($map == '214') {return 'Guild Mansion';}
if ($map == '210') {return 'Boss Monster: Big Muscle';}
if ($map == '220') {return 'Boss Monster: Krrr';}
if ($map == '230') {return 'Boss Monster: Mushmoot';}
if ($map == '121') {return 'Aminuskypta';}
if ($map == '122') {return 'Aminuskypta (Hero)';}
if ($map == '123') {return 'Catacombs of Anguish';}
if ($map == '124') {return 'The Wilds';}
if ($map == '125') {return 'The Savage Wilds';}
}
// Spielzeit
function gettime($seconds) {
$Stunden = floor($seconds / 3600);
$Rest1 = (($seconds / 3600) - $Stunden);
$Minuten = floor($Rest1 * 60);
return $Stunden.'h '.$Minuten.'m';}
// Auswahl der jeweiligen Top x Anzeige
function cleaninput($input) {$output = ereg_replace("[^0-9]", "", $input); return $output;}
if (isset($_GET['top'])){
$show_top = cleaninput($_GET['top']);
} else {
$show_top = "25";}
if (isset($_GET['top'])) {$show_top = cleaninput($_GET['top']);}
else {$show_top = "25";}
// Auswahl der jeweiligen Sortierung
if(isset($_GET['a1'])) {
$order = 'm_szName ASC';
$snumber = '&a1';
} else if(isset($_GET['a2'])) {
$order = 'm_nLevel DESC, m_nExp1 DESC';
$snumber = '&a2';
} else if (isset($_GET['a3'])){
$order = 'm_nJob DESC, m_nLevel DESC';
$snumber = '&a3';
} else if (isset($_GET['a4'])){
$order = 'TotalPlayTime DESC, CreateTime ASC';
$snumber = '&a4';
} else if (isset($_GET['a5'])) {
$order = 'MultiServer ASC, CreateTime ASC';
$snumber = '&a5';
} else if (isset($_GET['a6'])) {
$order = 'dwWorldID ASC';
$snumber = '&a6';
} else {
$order = 'm_nLevel DESC, m_nExp1 DESC';
$snumber = '';}
// Onlinestatusauswahl
if(isset($_GET['a'])) {
$online = "AND MultiServer > '0'";
$showonline = "&a";
} else {
$online = "";
$showonline = "";}
?>
ranking.php
PHP Code:
// Anmerkung: Dieser Teil gehört dann in den Contentbereich deiner Homepage. Beachte, dass der Pfad zu der func_ranking.php stimmt und dass die Datenbankangaben exakt sind.
<?php include("func_ranking.php");?>
<?php
$link = @mssql_connect("MSSQL HOST", "MSSQL USERNAME", "MSSQL PASSWORD") ;
$db = @mssql_select_db("CHARACTER_01_DBF");
$crown = mssql_fetch_array(mssql_query("SELECT TOP 1 m_szGuild FROM tblCombatJoinGuild JG LEFT JOIN tblCombatInfo CI ON JG.CombatID = CI.CombatID LEFT JOIN GUILD_TBL G ON JG.GuildID = G.m_idGuild WHERE CI.[Status] = '30' ORDER BY JG.CombatID DESC, Point DESC"));
$mvp = mssql_fetch_array(mssql_query("SELECT TOP 1 m_szName FROM tblCombatJoinPlayer JP LEFT JOIN tblCombatInfo CI ON JP.CombatID = CI.CombatID LEFT JOIN CHARACTER_TBL C ON JP.PlayerID = C.m_idPlayer WHERE CI.[Status] = '30' ORDER BY JP.CombatID DESC, Point DESC"));
$result = mssql_query("SELECT TOP $show_top m_idPlayer, m_szName, m_nJob, m_nLevel, TotalPlayTime, CreateTime, MultiServer, m_nExp1, dwWorldID FROM CHARACTER_TBL WHERE m_chAuthority = 'F' AND isblock = 'F' $online ORDER BY $order");
$rank=1;
echo ' <table cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="700" align="center" valign="top">
| <a href="?top='.$show_top.''.$snumber.'">Show all players</a> | <a href="?top='.$show_top.'&a'.$snumber.'">Show only online players</a> |<br />
| <a href="?top=25'.$snumber.''.$showonline.'">Top 25</a> | <a href="?top=50'.$snumber.''.$showonline.'">Top 50</a> | <a href="?top=100'.$snumber.''.$showonline.'">Top 100</a> | <a href="?top=250'.$snumber.''.$showonline.'">Top 250</a> | <a href="?top=500'.$snumber.''.$showonline.'">Top 500</a> | <a href="?top=1000'.$snumber.''.$showonline.'">Top 1000</a> |
<br /><br />
</td>
</tr>
<tr>
<td align="center" valign="top">
<table align="center" style="border-width:1px; border-color:#000000; border-style:solid; background-image:url(./graphics/misc/misc_background.png);" cellpadding="0" cellspacing="0">
<tr>
<td class="ranking" valign="center" height="25" align="center" style="width: 30px; background-image:url(../graphics/ranking/030.png);">Rank</td>
<td class="ranking" valign="center" height="25" align="center" style="width:150px; background-image:url(../graphics/ranking/150.png);"><a style="color:#FFFFFF; font-size:11px; font-family:Arial, sans-serif; font-style:normal; text-shadow: black 1px 1px 1px; border-width:0px 0px 1px 0px;" href="?top='.$show_top.$showonline.'&a1'.$showonline.'" title="Sort servers Top '.$show_top.' by first letter">Nickname</a></td>
<td class="ranking" valign="center" height="25" align="center" style="width: 70px; background-image:url(../graphics/ranking/070.png);"><a style="color:#FFFFFF; font-size:11px; font-family:Arial, sans-serif; font-style:normal; text-shadow: black 1px 1px 1px; border-width:0px 0px 1px 0px;" href="?top='.$show_top.$showonline.'&a3'.$showonline.'" title="Sort servers Top '.$show_top.' by jobclasses">Title</a></td>
<td class="ranking" valign="center" height="25" align="center" style="width: 50px; background-image:url(../graphics/ranking/050.png);"><a style="color:#FFFFFF; font-size:11px; font-family:Arial, sans-serif; font-style:normal; text-shadow: black 1px 1px 1px; border-width:0px 0px 1px 0px;" href="?top='.$show_top.$showonline.'&a2'.$showonline.'" title="Sort servers Top '.$show_top.' by level">Level</a></td>
<td class="ranking" valign="center" height="25" align="center" style="width:150px; background-image:url(../graphics/ranking/160.png);">Guild</td>
<td class="ranking" valign="center" height="25" align="center" style="width:150px; background-image:url(../graphics/ranking/150.png);"><a style="color:#FFFFFF; font-size:11px; font-family:Arial, sans-serif; font-style:normal; text-shadow: black 1px 1px 1px; border-width:0px 0px 1px 0px;" href="?top='.$show_top.$showonline.'&a6'.$showonline.'" title="Sort servers Top '.$show_top.' by location">Location</a></td>
<td class="ranking" valign="center" height="25" align="center" style="width: 80px; background-image:url(../graphics/ranking/080.png);"><a style="color:#FFFFFF; font-size:11px; font-family:Arial, sans-serif; font-style:normal; text-shadow: black 1px 1px 1px; border-width:0px 0px 1px 0px;" href="?top='.$show_top.$showonline.'&a5'.$showonline.'" title="Sort servers Top '.$show_top.' by channel">Channel</a></td>
<td class="ranking" valign="center" height="25" align="center" style="width: 80px; background-image:url(../graphics/ranking/080.png);"><a style="color:#FFFFFF; font-size:11px; font-family:Arial, sans-serif; font-style:normal; text-shadow: black 1px 1px 1px; border-width:0px 0px 1px 0px;" href="?top='.$show_top.$showonline.'&a4'.$showonline.'" title="Sort servers Top '.$show_top.' by playtime">Playtime</a></td>
</tr>';
while($consulta = mssql_fetch_array($result)) {
$lordabf = mssql_fetch_array(mssql_query("SELECT TOP 1 m_szName FROM tblLord a LEFT JOIN CHARACTER_TBL b ON RIGHT('0000000' + CONVERT(VARCHAR(7),a.idLord),7)= b.m_idPlayer ORDER BY s_date DESC"));
$guildabf = $consulta['m_idPlayer'];
$query1 = mssql_fetch_array(mssql_query("SELECT * FROM GUILD_MEMBER_TBL WHERE m_idPlayer = '$guildabf'"));
$gid = $query1['m_idGuild'];
$query2 = mssql_fetch_array(mssql_query("SELECT * FROM GUILD_TBL WHERE m_idGuild = '$gid' "));
$guildname= $query2['m_szGuild'];
if($consulta['m_nJob'] >= '24') {$icon = '<img src="http://www.elitepvpers.com/forum/graphics/ranking/hero.png"/>';}
else if($consulta['m_nJob'] >= '16' && $consulta['m_nJob'] <= '23') {$icon = mastericon($consulta['m_nLevel']);}
else {$icon = '<img src=""/>';}
if ($consulta['MultiServer'] != '0') {$channel = '<b>#0'.$consulta['MultiServer'].'</b>'; $status = '<img src="graphics/misc/online.png" width="12">';}
else {$channel = '<i>Offline</i>'; $status = '<img src="graphics/misc/offline.png" width="12">';}
if ($lordabf['m_szName'] == $consulta['m_szName']) {$lord = '<img src="http://www.elitepvpers.com/forum/graphics/ranking/lord.png" height="16" title="::: Lord. :::">';}
else {$lord = '';}
if ($mvp['m_szName'] != $consulta['m_szName']) {$mvptitel = '';}
else {$mvptitel = '<img src="http://www.elitepvpers.com/forum/graphics/ranking/mvp.png" height="16" title="::: Best player in the last Guildsiege :::">';}
if ($crown['m_szGuild'] != $guildname) {$krone = '';}
else {$krone = '<img src="http://www.elitepvpers.com/forum/graphics/ranking/krone.gif" height="16" title="::: Member of '.$guildname.' ::: '.$guildname.' won the last Guildsiege :::">';}
echo ' <tr>
<td valign="center" align="center" style="border-width:0px 0px 0px 0px; border-color:#707070; border-style:solid;">'.$rank.'</td>
<td valign="center" align="left" style="border-width:0px 0px 0px 1px; border-color:#707070; border-style:solid; padding-left: 2px;">'.$status.' <b>'.$consulta['m_szName'].'</b></td>
<td valign="center" align="left" style="border-width:0px 0px 0px 1px; border-color:#707070; border-style:solid; padding-left: 2px;">'.getjob($consulta['m_nJob']).''.$icon.''.$krone.''.$mvptitel.''.$lord .'</td>
<td valign="center" align="center" style="border-width:0px 0px 0px 1px; border-color:#707070; border-style:solid;">'.$consulta['m_nLevel'].'</td>
<td valign="center" align="center" style="border-width:0px 0px 0px 1px; border-color:#707070; border-style:solid;">'.$guildname.'</td>
<td valign="center" align="center" style="border-width:0px 0px 0px 1px; border-color:#707070; border-style:solid;">'.getlocation($consulta['dwWorldID']).'</td>
<td valign="center" align="center" style="border-width:0px 0px 0px 1px; border-color:#707070; border-style:solid;">'.$channel.'</td>
<td valign="center" align="center" style="border-width:0px 0px 0px 1px; border-color:#707070; border-style:solid;">'.gettime($consulta['TotalPlayTime']).'</td>
</tr>';
$rank++;}
mssql_close();
echo '
</tr>
</table>';?>
Wie ich gerade sehe, sind einige <img>-Tags etwas abgewandelt worden: Einfach jedes
"http://www.elitepvpers.com/forum/[...] mit einem
". ersetzen.
Außerdem kannst du die Sortierungseigenschaften in der func_ranking.php - schaue in den Abschnitt
"// Auswahl der jeweiligen Sortierung" - selbst einstellen:
$result = mssql_query("SELECT TOP $show_top m_idPlayer, m_szName, m_nJob, m_nLevel, TotalPlayTime, CreateTime, MultiServer, m_nExp1, dwWorldID FROM CHARACTER_TBL WHERE m_chAuthority = 'F' AND isblock = 'F' $online
ORDER BY $order");
(siehe Zeile 9)
Hier der VT-Test:
File name: graphics.rar
Submission date: 2011-08-04 14:30:02 (UTC)
Current status: finished
Result: 0/ 43 (0.0%)
Ausführliche Informationen
Antivirus Version Last Update Result
AhnLab-V3 2011.08.04.00 2011.08.04 -
AntiVir 7.11.12.214 2011.08.04 -
Antiy-AVL 2.0.3.7 2011.08.04 -
Avast 4.8.1351.0 2011.08.04 -
Avast5 5.0.677.0 2011.08.04 -
AVG 10.0.0.1190 2011.08.04 -
BitDefender 7.2 2011.08.04 -
CAT-QuickHeal 11.00 2011.08.04 -
ClamAV 0.97.0.0 2011.08.04 -
Commtouch 5.3.2.6 2011.08.04 -
Comodo 9627 2011.08.04 -
DrWeb 5.0.2.03300 2011.08.04 -
Emsisoft 5.1.0.8 2011.08.04 -
eSafe 7.0.17.0 2011.08.03 -
eTrust-Vet 36.1.8483 2011.08.04 -
F-Prot 4.6.2.117 2011.08.03 -
F-Secure 9.0.16440.0 2011.08.04 -
Fortinet 4.2.257.0 2011.08.04 -
GData 22 2011.08.04 -
Ikarus T3.1.1.104.0 2011.08.04 -
Jiangmin 13.0.900 2011.08.03 -
K7AntiVirus 9.109.4973 2011.08.02 -
Kaspersky 9.0.0.837 2011.08.04 -
McAfee 5.400.0.1158 2011.08.04 -
McAfee-GW-Edition 2010.1D 2011.08.04 -
Microsoft 1.7104 2011.08.04 -
NOD32 6349 2011.08.04 -
Norman 6.07.10 2011.08.04 -
nProtect 2011-08-04.01 2011.08.04 -
Panda 10.0.3.5 2011.08.04 -
PCTools 8.0.0.5 2011.08.04 -
Prevx 3.0 2011.08.04 -
Rising 23.69.03.03 2011.08.04 -
Sophos 4.67.0 2011.08.04 -
SUPERAntiSpyware 4.40.0.1006 2011.08.04 -
Symantec 20111.2.0.82 2011.08.04 -
TheHacker 6.7.0.1.269 2011.08.03 -
TrendMicro 9.200.0.1012 2011.08.04 -
TrendMicro-HouseCall 9.200.0.1012 2011.08.04 -
VBA32 3.12.16.4 2011.08.04 -
VIPRE 10062 2011.08.04 -
ViRobot 2011.8.4.4605 2011.08.04 -
VirusBuster 14.0.151.1 2011.08.03 -
Post
Scriptum: Sollte irgendetwas nicht klappen, so kannst du mich anschreiben - habe ohnehin nichts zu tun, da kommt jede Beschäftigung nur recht. Und bevor ich es vergesse, möchte ich dich darauf hinweisen, dass ich nicht mit 100% behaupten kann, dass dieses Skript sicher ist.