|
You last visited: Today at 04:09
Advertisement
Ranking Script
Discussion on Ranking Script within the Flyff Private Server forum part of the Flyff category.
10/17/2012, 20:47
|
#1
|
elite*gold: 0
Join Date: Aug 2012
Posts: 576
Received Thanks: 300
|
Ranking Script
Habe gehört hier gibt es ein Fixxed Ranking Script aber ich find es ned..
Hat es einer wo die Xss lücken weg sind? Will was probieren^^
|
|
|
10/17/2012, 21:06
|
#2
|
elite*gold: 0
Join Date: Jan 2009
Posts: 1,739
Received Thanks: 1,669
|
Kannst du nicht mal einen Thread benutzen, statt im Minutentakt neue zu öffnen?
Bist ja bald wie dieser Shyo, wenn du es nicht sowieso schon bist...
Wahrscheinlich steht der "Fix" in nem Post, statt in einem neuen Thread.
|
|
|
10/17/2012, 21:45
|
#3
|
elite*gold: 18
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,471
|
Du kannst doch schnell selber einen schreiben, so schwer ist es ja nicht.
|
|
|
10/18/2012, 09:00
|
#4
|
elite*gold: 0
Join Date: Aug 2012
Posts: 576
Received Thanks: 300
|
Quote:
Originally Posted by Sedrika
Du kannst doch schnell selber einen schreiben, so schwer ist es ja nicht.
|
Hast du nun eins?
|
|
|
10/18/2012, 13:47
|
#5
|
elite*gold: 10
Join Date: Sep 2010
Posts: 348
Received Thanks: 298
|
Naja wenn es Shyo ist mein Beileid.
Naja will aber nicht so sein, (C) by Surako.
An Sedrika, was los mit dir? Sonst steckst du den Usern doch auch alles in den *nus und releast alles, mh?
Naja was solls...
Greetz
|
|
|
10/18/2012, 18:35
|
#6
|
elite*gold: 51
Join Date: Sep 2012
Posts: 1,141
Received Thanks: 575
|
Code:
<?php include('./inc/header.php'); ?>
<h1>Ranking List</h1>
<?php
if(isset($_GET['guild'])) {
echo '<a href="ranking.php">Player Ranking</a> - <span style="font-weight: bold;">Guild Ranking</span><br /><br />';
$i = 1;
odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
$check = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [GUILD_TBL]');
if(odbc_result($check, 'count') > 0) {
echo '<table style="width: 100%;">
<tr>
<td id="key">#</td>
<td id="key">Guild Name</td>
<td id="key" style="text-align: center;">Level</td>
<td id="key" style="text-align: center;">Win</td>
<td id="key" style="text-align: center;">Lose</td>
<td id="key" style="text-align: center;">Leader</td>
</tr>';
$query = odbc_exec($mssql, 'SELECT TOP 100 * FROM [GUILD_TBL] ORDER BY m_nLevel DESC');
while($result = odbc_fetch_array($query)) {
$leadquery = odbc_exec($mssql, 'SELECT m_idPlayer FROM [GUILD_MEMBER_TBL] WHERE m_idGuild = \''.mssql_escape_string($result['m_idGuild']).'\' AND m_nMemberLv = \'0\'');
$leader = odbc_exec($mssql, 'SELECT * FROM [CHARACTER_TBL] WHERE m_idPlayer=\''.mssql_escape_string(odbc_result($leadquery, 'm_idPlayer')).'\'');
$leadrow = odbc_fetch_array($leader);
if($leadrow['m_chAuthority'] == 'F') {
if($i == 1) {
$rank = '<span style="color: #F30000;">'.$i.'</span>';
} elseif($i == 2) {
$rank = '<span style="color: #F37800;">'.$i.'</span>';
} elseif($i == 3) {
$rank = '<span style="color: #FFFC00;">'.$i.'</span>';
} else {
$rank = $i;
}
echo '<tr>
<td>'.$rank.'</td>
<td>'.$result['m_szGuild'].'</td>
<td style="text-align: center;">'.$result['m_nLevel'].'</td>
<td style="text-align: center;">'.$result['m_nWin'].'</td>
<td style="text-align: center;">'.$result['m_nLose'].'</td>
<td style="text-align: center;">'.$leadrow['m_szName'].'</td>
</tr>';
$i = $i + 1;
}
}
echo '</table>';
} else {
echo '<div class="fail">There are no guilds at the moment!</div>';
}
} else {
echo '<span style="font-weight: bold;">Player Ranking</span> - <a href="ranking.php?guild">Guild Ranking</a><br /><br />';
echo '<form method="get">
<select name="job">';
if(isset($_GET['job']) && !empty($_GET['job'])) {
echo '<option value="'.htmlentities($_GET['job']).'">'.htmlentities(getjob($_GET['job'])).'</option>';
}
echo ' <option value="">All Jobs</option>
<option value="0">Vagrant</option>
<option value="1">Mercenary</option>
<option value="2">Assist</option>
<option value="3">Acrobat</option>
<option value="4">Magician</option>
<option value="6">Knight</option>
<option value="7">Blade</option>
<option value="8">Jester</option>
<option value="9">Ranger</option>
<option value="10">Ringmaster</option>
<option value="11">Billposter</option>
<option value="12">Psykeeper</option>
<option value="13">Elementor</option>
<option value="16">Master Knight</option>
<option value="17">Master Blade</option>
<option value="18">Master Jester</option>
<option value="19">Master Ringmaster</option>
<option value="20">Master Billposter</option>
<option value="21">Master Psykeeper</option>
<option value="22">Master Elementor</option>
<option value="24">Hero Knight</option>
<option value="25">Hero Blade</option>
<option value="26">Hero Jester</option>
<option value="27">Hero Ranger</option>
<option value="28">Hero Ringmaster</option>
<option value="29">Hero Billposter</option>
<option value="30">Hero Psykeeper</option>
<option value="31">Hero Elementor</option>
<option value="32">Lord Templer</option>
<option value="33">Storm Blade</option>
<option value="34">Wind Lurker</option>
<option value="35">Crack Shooter</option>
<option value="36">Florist</option>
<option value="37">Force Master</option>
<option value="38">Mentalist</option>
<option value="39">Arcanist</option>
</select>
<input type="submit" value="Submit" />
</form><br />';
odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
$check = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [CHARACTER_TBL] WHERE m_chAuthority = \'F\'');
if(odbc_result($check, 'count') > 0) {
echo '<table style="width: 100%;">
<tr>
<td id="key">#</td>
<td id="key">Character</td>
<td id="key" style="text-align: center;">Job</td>
<td id="key" style="text-align: center;">Level</td>
<td id="key" style="text-align: center;">Guild</td>
<td id="key" style="text-align: center;">Sex</td>
</tr>';
if(!isset($_GET['job']) || empty($_GET['job'])) {
$i = 1;
$count = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [CHARACTER_TBL] WHERE m_chAuthority = \'F\'');
$query = odbc_exec($mssql, 'SELECT * FROM [CHARACTER_TBL] WHERE m_chAuthority = \'F\' ORDER BY m_nLevel DESC');
$query1 = odbc_exec($mssql, 'SELECT * FROM [CHARACTER_TBL] WHERE m_chAuthority = \'F\' AND
(m_nJob = \'39\' OR m_nJob = \'38\' OR m_nJob = \'37\' OR m_nJob = \'36\' OR m_nJob = \'35\' OR m_nJob = \'34\' OR m_nJob = \'33\' OR m_nJob = \'32\' OR m_nJob = \'31\' OR m_nJob = \'30\' OR m_nJob = \'29\' OR m_nJob = \'28\' OR m_nJob = \'27\' OR m_nJob = \'26\' OR m_nJob = \'25\' OR m_nJob = \'24\' OR m_nJob = \'23\' OR m_nJob = \'22\' OR m_nJob = \'21\' OR m_nJob = \'20\' OR m_nJob = \'19\' OR m_nJob = \'18\' OR m_nJob = \'17\' OR m_nJob = \'16\') ORDER BY m_nLevel DESC'); // 3rd Jobs, Heros, Masters
$query2 = odbc_exec($mssql, 'SELECT * FROM [CHARACTER_TBL] WHERE m_chAuthority = \'F\' AND
(m_nJob = \'15\' OR m_nJob = \'14\' OR m_nJob = \'13\' OR m_nJob = \'12\' OR m_nJob = \'11\' OR m_nJob = \'10\' OR m_nJob = \'9\' OR m_nJob = \'8\' OR m_nJob = \'7\' OR m_nJob = \'6\' OR m_nJob = \'5\' OR m_nJob = \'4\' OR m_nJob = \'3\' OR m_nJob = \'2\' OR m_nJob = \'1\') ORDER BY m_nLevel DESC'); // Normal Jobs
if(odbc_result($count, 'count') > 0) {
while($result = odbc_fetch_array($query1)) {
if($i <= 100) {
$guildquery = odbc_exec($mssql, 'SELECT m_idGuild FROM [GUILD_MEMBER_TBL] WHERE m_idPlayer = \''.mssql_escape_string($result['m_idPlayer']).'\'');
$guildname = odbc_exec($mssql, 'SELECT m_szGuild FROM [GUILD_TBL] WHERE m_idGuild = \''.mssql_escape_string(odbc_result($guildquery, 'm_idGuild')).'\'');
if($result['m_dwSex'] == 1) {
$sex = '<img src="./img/female.png" />';
} else {
$sex = '<img src="./img/male.png" />';
}
if($i == 1) {
$rank = '<span style="color: #F30000;">'.$i.'</span>';
} elseif($i == 2) {
$rank = '<span style="color: #F37800;">'.$i.'</span>';
} elseif($i == 3) {
$rank = '<span style="color: #FFFC00;">'.$i.'</span>';
} else {
$rank = $i;
}
echo '<tr>
<td>'.$rank.'</td>
<td>'.$result['m_szName'].'</td>
<td style="text-align: center;">'.getjob($result['m_nJob']).'</td>
<td style="text-align: center;">'.$result['m_nLevel'].'</td>
<td style="text-align: center;">'.odbc_result($guildname, 'm_szGuild').'</td>
<td style="text-align: center;">'.$sex.'</td>
</tr>';
$i = $i + 1;
}
}
while($result = odbc_fetch_array($query2)) {
if($i <= 100) {
$guildquery = odbc_exec($mssql, 'SELECT m_idGuild FROM [GUILD_MEMBER_TBL] WHERE m_idPlayer = \''.mssql_escape_string($result['m_idPlayer']).'\'');
$guildname = odbc_exec($mssql, 'SELECT * FROM [GUILD_TBL] WHERE m_idGuild = \''.mssql_escape_string(odbc_result($guildquery, 'm_idGuild')).'\'');
if($result['m_dwSex'] == 1) {
$sex = '<img src="./img/female.png" />';
} else {
$sex = '<img src="./img/male.png" />';
}
if($i == 1) {
$rank = '<span style="color: #F30000;">'.$i.'</span>';
} elseif($i == 2) {
$rank = '<span style="color: #F37800;">'.$i.'</span>';
} elseif($i == 3) {
$rank = '<span style="color: #FFFC00;">'.$i.'</span>';
} else {
$rank = $i;
}
echo '<tr>
<td>'.$rank.'</td>
<td>'.$result['m_szName'].'</td>
<td style="text-align: center;">'.getjob($result['m_nJob']).'</td>
<td style="text-align: center;">'.$result['m_nLevel'].'</td>
<td style="text-align: center;">'.odbc_result($guildname, 'm_szGuild').'</td>
<td style="text-align: center;">'.$sex.'</td>
</tr>';
$i = $i + 1;
}
}
} else {
echo '<tr><td colspan="6"><div class="fail">No characters available!</div></td></tr>';
}
} else {
$i = 1;
$count = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [CHARACTER_TBL] WHERE m_chAuthority = \'F\' AND m_nJob=\''.mssql_escape_string($_GET['job']).'\'');
$query = odbc_exec($mssql, 'SELECT * FROM [CHARACTER_TBL] WHERE m_chAuthority = \'F\' AND m_nJob=\''.mssql_escape_string($_GET['job']).'\' ORDER BY m_nLevel DESC');
if(odbc_result($count, 'count') > 0) {
while($result = odbc_fetch_array($query)) {
if($i <= 100) {
$guildquery = odbc_exec($mssql, 'SELECT m_idGuild FROM [GUILD_MEMBER_TBL] WHERE m_idPlayer = \''.mssql_escape_string($result['m_idPlayer']).'\'');
$guildname = odbc_exec($mssql, 'SELECT * FROM [GUILD_TBL] WHERE m_idGuild = \''.mssql_escape_string(odbc_result($guildquery, 'm_idGuild')).'\'');
if($result['m_dwSex'] == 1) {
$sex = '<img src="./img/female.png" />';
} else {
$sex = '<img src="./img/male.png" />';
}
if($i == 1) {
$rank = '<span style="color: #F30000;">'.$i.'</span>';
} elseif($i == 2) {
$rank = '<span style="color: #F37800;">'.$i.'</span>';
} elseif($i == 3) {
$rank = '<span style="color: #FFFC00;">'.$i.'</span>';
} else {
$rank = $i;
}
echo '<tr>
<td>'.$rank.'</td>
<td>'.$result['m_szName'].'</td>
<td style="text-align: center;">'.getjob($result['m_nJob']).'</td>
<td style="text-align: center;">'.$result['m_nLevel'].'</td>
<td style="text-align: center;">'.odbc_result($guildname, 'm_szGuild').'</td>
<td style="text-align: center;">'.$sex.'</td>
</tr>';
$i = $i + 1;
}
}
} else {
echo '<tr><td colspan="6"><div class="fail">No characters available!</div></td></tr>';
}
}
echo '</table>';
} else {
echo '<div class="fail">There are no player at the moment!</div>';
}
}
?>
<?php include('./inc/footer.php'); ?>
|
|
|
|
Similar Threads
|
[Web]Script Ranking
12/27/2011 - Rappelz Private Server - 2 Replies
I Make the Script for Select Ranking TOP Levels
***********************************************
<?php
$host = "(local)"; // your sql instance
$user = "sa"; // username
$pw = ""; // password
|
[Help]Ranking Script
11/14/2011 - Minecraft - 3 Replies
hey,
ich weis das kommt jetzt nen bissl doof aber da ich kein MySQL kann bräuchte ich ein Ranking script, dass von der datenbank jobs die tabelle Name,Job,Level,Expirience entnimmt.Ich habe es schon selber versucht aber ich kriege immer nen mysql_fetch_error; oder so könnte mir da jemand en paar tipps geben ich editiere gleich wieder und füge das script ein.
MfG
Regen.
|
[Help]Shaiya PvP ranking script
12/23/2010 - Shaiya Private Server - 0 Replies
Hello guys.
İ need shaiya pvp ranking script. Any1 have this script?
Ty for help =)
|
Ranking Script v15
06/26/2010 - Flyff Private Server - 4 Replies
Hi,
Hat hier vielleicht wer ne voll funktionstüchtige Ranking script für v15.?
Danke schon mal^^
|
Ranking Script!
01/24/2010 - Metin2 Private Server - 38 Replies
Hallo, ich hab eine Problem bei meiner Rangliste... Ich will, das das Reich auch angezeigt wird jedoch habe ich keine ahnung wie man das macht das dann ein bild kommt und wo das überhaupt stehe in welchem reich man ist.
MfG Drake
|
All times are GMT +2. The time now is 04:09.
|
|