Re: [Release]GM Staff Script.
<?php
include ("invoker.php");
include('config.php');
if($_GET['job'] != NULL)
$show=" AND job LIKE '".$_GET['job']."%'";
else
$show="";
if($_GET['start'])
$start=$_GET['start'];
else
$start=0;
if($_GET['order'])
$order= $_GET['order']." DESC,";
else
$order="";
$search = $_GET['search'];
$result2 = mysql_query("SELECT level, exp, characters.name name, meso, job, rebirth, logo, logoColor, guilds.name guildname, logoBG, logoBGColor, COUNT(eventstats.characterid) wins FROM accounts, characters LEFT JOIN guilds ON guilds.guildid = characters.guildid LEFT JOIN eventstats ON characters.id=eventstats.characterid WHERE characters.gm = 1 AND accountid = accounts.id AND banned = 0 ".$show." GROUP BY characters.id DESC ORDER BY $order rebirth DESC, level DESC, exp DESC")
or die(mysql_error());
$num_players=mysql_num_rows($result2);
if($search)
{
$row_number = 0;
$int = 0;
while(($row = mysql_fetch_array( $result2 )) && !$row_number)
{
if(strtolower($row['name']) == strtolower($search))
{
$row_number = $int;
}
$int++;
}
if($row_number)
{
$start = $row_number - ($row_number % 10);
}
}
$result = mysql_query("SELECT level, exp, characters.name name, meso, job, rebirth, logo, logoColor, guilds.name guildname, logoBG, logoBGColor, COUNT(eventstats.characterid) wins FROM accounts, characters LEFT JOIN guilds ON guilds.guildid = characters.guildid LEFT JOIN eventstats ON characters.id=eventstats.characterid WHERE characters.gm = 1 AND accountid = accounts.id AND banned = 0".$show." GROUP BY characters.id DESC ORDER BY $order rebirth DESC, level DESC, exp DESC LIMIT $start, 10")
or die(mysql_error());
//
//Display Page
//
echo "<head>
<style type='text/css'>
A:link {text-decoration: none; color: #3a3a3a;}
A:visited {text-decoration: none; color: #3a3a3a;}
A:active {text-decoration: none; color:#3a3a3a;}
A:hover {text-decoration: none; color: #777777;}
#search_box {
width: 201px;
height: 31px;
background: url();
}
#search_box #s {
float: left;
padding: 0;
margin: 6px 0 0 6px;
border: 0;
width: 159px;
background: none;
}
#search_box #go {
float: right;
margin: 3px 4px 0 0;
}
</style>
</head>
<body>
<table border='0' width='100%' bordercolor='#ffffff' cellspacing=0 style='dashed thin'>
<tr valign='bottom'>
<td align ='center'>
<div id='search_box'>
<form id='search_form' method='get' action='ranking.php'>
<input type='text' name='search' id='s' onfocus='if (this.value == '') { this.value=''; }' onblur='if (this.value == '') { this.value='GMs && Dev's of LeviathanStory'; }' value='GMs && Dev's of LeviathanStory' class='swap_value' />
<input type='hidden' name='start' value='".$_GET['start']."'>
<input type='hidden' name='order' value='".$_GET['order']."'>
<input type='hidden' name='job' value='".$_GET['job']."'>
<input type='image' src='' width='27' height='24' id='go' alt='' title='' />
</form>
</div>
</td>
<td> </td>";
echo "<td><a BORDER=0 href='ranking.php?order=". $_GET['order'] ."'><img BORDER=0 src='job_class/'></td>
<td><a BORDER=0 href='ranking.php?order=". $_GET['order'] ."&job=0'><img BORDER=0 src=''></td>
<td><a BORDER=0 href='ranking.php?order=". $_GET['order'] ."&job=1'><img BORDER=0 src=''></td>
<td><a BORDER=0 href='ranking.php?order=". $_GET['order'] ."&job=2'><img BORDER=0 src=''></td>
<td><a BORDER=0 href='ranking.php?order=". $_GET['order'] ."&job=3'><img BORDER=0 src=''></td>
<td><a BORDER=0 href='ranking.php?order=". $_GET['order'] ."&job=4'><img BORDER=0 src=''></td>
</tr>
</table>";
echo "<table border='0' width='100%' bordercolor='#ffffff' cellspacing=0 style='dashed thin'>";
echo "<tr valign='bottom'>
<td align ='center' bgcolor='#333333'>
<font color='#CCCCCC'><b> Rank </b></font>
</td>
<td align ='center' bgcolor='#333333'>
<font color='#CCCCCC'><b> Character </b></font>
</td>
<td align ='center' bgcolor='#333333' width = 100>
<font color='#CCCCCC'><b> Name </b></font>
</td>
<td align ='center' bgcolor='#333333'>
<font color='#CCCCCC'><b> rebirth </b></font>
</td>
<td align ='center' bgcolor='#333333'>
<font color='#CCCCCC'><b> FoJ </b></font>
</td>
<td align ='center' bgcolor='#333333'>
<font color='#CCCCCC'><b> Job Class </b></font>
</td>
<td align ='center' bgcolor='#333333' width = 100>
<font color='#CCCCCC'><b> Level </b></font>
</td>
</tr>";
echo "<tr valign='bottom' height=5>
<td align ='center' bgcolor='#00b0db'></td>
<td align ='center' bgcolor='#00b0db'></td>
<td align ='center' bgcolor='#00b0db' width = 100></td>
<td align ='center' bgcolor='#00b0db'></td>
<td align ='center' bgcolor='#00b0db'></td>
<td align ='center' bgcolor='#00b0db'></td>
<td align ='center' bgcolor='#00b0db' width = 100></td> </tr>";
$ranking=$start;
$backcolor="f4f4f4";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
if($backcolor2=="f4f4f4")
$backcolor2="b6baba";
else
$backcolor2="f4f4f4";
if($row_number == $ranking && $search)
{
$backcolor="33ADCC";
}
else
{
$backcolor=$backcolor2;
}
$ranking++;
// Print out the contents of each row into a table
echo " <td align ='center' bgcolor='#".$backcolor."'> <b>";
echo "$ranking";
echo " </b></td><td align ='center' bgcolor='#".$backcolor."'> <b>";
echo "<img src='ranking/character/characterdisplay.php?char=".$row['name']."'>";
echo " </b></td><td align ='center' bgcolor='#".$backcolor."'> <b>";
echo $row['name']."<br>";
if($row['guildname'])
echo "<img src='guildicon.php?back=".$row['logoBG']."&backcolor=".$row['logoBGColor']."&top=".$row['logo']."&topcolor=".$row['logoColor']."'>".$row['guildname'];
echo " </b></td><td align ='center' bgcolor='#".$backcolor."'> <b>";
echo $row['rebirth'];
echo " </b></td><td align ='center' bgcolor='#".$backcolor."'> <b>";
echo $row['wins'];
echo " </b></td><td align ='center' bgcolor='#".$backcolor."'> <b>";
if($row['job'] == 0)
echo "<img src='job_class/job_beginner.gif'>";
if($row['job'] >= 100 && $row['job'] < 200)
echo "<img src='job_class/job_warrior.gif'>";
if($row['job'] >= 200 && $row['job'] < 300)
echo "<img src='job_class/job_magician.gif'>";
if($row['job'] >= 300 && $row['job'] < 400)
echo "<img src='job_class/job_bowman.gif'>";
if($row['job'] >= 400 && $row['job'] < 500)
echo "<img src='job_class/job_thief.gif'>";
if($row['job'] >= 500 && $row['job'] < 600)
echo "<img src='job_class/job_gm.gif'>";
echo "<br>";
if ($row['job']=="510")
echo "SuperGM";
if ($row['job']=="500")
echo "GM";
if ($row['job']=="000")
echo "Beginner";
if ($row['job']=="100")
echo "Warrior";
if ($row['job']=="110")
echo "Fighter";
if ($row['job']=="120")
echo "Page";
if ($row['job']=="130")
echo "Spearman";
if ($row['job']=="111")
echo "Crusader";
if ($row['job']=="121")
echo "White Knight";
if ($row['job']=="131")
echo "Dragon Knight";
if ($row['job']=="112")
echo "Hero";
if ($row['job']=="122")
echo "Paladin";
if ($row['job']=="132")
echo "Dark Knight";
if ($row['job']=="200")
echo "Magician";
if ($row['job']=="210")
echo "Wizard";
if ($row['job']=="220")
echo "Wizard";
if ($row['job']=="230")
echo "Cleric";
if ($row['job']=="211")
echo "Mage";
if ($row['job']=="221")
echo "Mage";
if ($row['job']=="231")
echo "Priest";
if ($row['job']=="212")
echo "Arch Mage";
if ($row['job']=="222")
echo "Arch Mage";
if ($row['job']=="232")
echo "Bishop";
if ($row['job']=="300")
echo "Bowman";
if ($row['job']=="310")
echo "Hunter";
if ($row['job']=="320")
echo "Crossbowman";
if ($row['job']=="311")
echo "Ranger";
if ($row['job']=="321")
echo "Sniper";
if ($row['job']=="312")
echo "Bow Master";
if ($row['job']=="322")
echo "Crossbow Master";
if ($row['job']=="400")
echo "Thief";
if ($row['job']=="410")
echo "Assassin";
if ($row['job']=="420")
echo "Bandit";
if ($row['job']=="411")
echo "Hermit";
if ($row['job']=="421")
echo "Chief Bandit";
if ($row['job']=="412")
echo "Night Lord";
if ($row['job']=="422")
echo "Shadower";
echo "</b></td>";
echo " </b></td><td align = 'center' bgcolor='#".$backcolor."'> <b>";
echo $row['level']." <font size='-1'><br>(".$row['exp'].")</font></b></td></tr>";
}
echo "</table><br><table border='0' width='100%' bordercolor='#ffffff' cellspacing=0 style='dashed thin'><tr valign='top'> <td align ='center'><b>";
if($start)
echo "<a href='ranking.php?start=0&order=". $_GET['order'] ."&job=". $_GET['job'] ."'></a><a href='ranking.php?start=". ($start - 5) ."&order=". $_GET['order'] ."&job=". $_GET['job'] ."'></a>";
else
echo "";
if($num_players % 10)
$num_players = $num_players - ($num_players % 10);
else
$num_players -= 5;
if($start <= $num_players - 10)
echo "<a href='ranking.php?start=". ($start + 10) ."&order=". $_GET['order'] ."&job=". $_GET['job'] ."'></a><a href='ranking.php?start=".($num_players) ."&order=". $_GET['order'] ."&job=". $_GET['job'] ."'></a>";
else
echo "GMs of SadistStory";
echo "</b></td><td> </td><td align ='center'><b>";
if($_GET['order'] == "rebirth")
echo "<a href='ranking.php?order=level&job=". $_GET['job'] ."'></a><a href='ranking.php?order=wins&job=". $_GET['job'] ."'></a> ";
elseif($_GET['order'] == "wins")
echo "<a href='ranking.php?order=level&job=". $_GET['job'] ."'></a><a href='ranking.php?order=rebirth&job=". $_GET['job'] ."'></a> ";
else
echo "<a href='ranking.php?order=rebirth&job=". $_GET['job'] ."'></a><a href='ranking.php?order=wins&job=". $_GET['job'] ."'></a> ";
echo "</b></td>\n<td> </td><td><b>GM/Dev's</b><select id=\"p_op\" onchange=\"document.location.href='ranking.php?start='+document.getElementById('p_op').value+'&order=".$_GET['order']."&job=".$_GET['job']."';\">";
for( $int = 0; $int <= floor($num_players / 5); $int++)
{
if( $start == ($int * 5))
echo "<option SELECTED value='". ($int * 5) ."'><b>".AdminCough-Owner."</b></option>\n";
else
echo "<option value='". ($int * 5) ."'><b>".($int + 1)."</b></option>\n";
}
echo "</select>";
echo "</td></tr></table></body>";
?>