s0wh4t?'s ranking with pirates

Kars · Mar 20, 2009

PHP:

<?php
include ("top.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, reborns, 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 = 0 AND accountid = accounts.id AND banned = 0 ".$show." GROUP BY characters.id DESC ORDER BY $order reborns 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 % 4);
  }
}

$result = mysql_query("SELECT level, exp, characters.name name, meso, job, reborns, 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 = 0 AND accountid = accounts.id AND banned = 0".$show." GROUP BY characters.id DESC ORDER BY $order reborns DESC, level DESC, exp DESC LIMIT $start, 4")
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(images/bg_search_box.gif);
}
#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 == 'Character Search') { this.value=''; }' onblur='if (this.value == '') { this.value='Character Search'; }' value='Character Search' 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='images/btn_search_box.gif' width='27' height='24' id='go' alt='Search' title='Search' />
                </form>
            </div>
        </td>
        <td>      </td>";
        echo "<td><a BORDER=0 href='ranking.php?order=". $_GET['order'] ."'><img BORDER=0 src='job_class/job_all.gif'></td>
              <td><a BORDER=0 href='ranking.php?order=". $_GET['order'] ."&job=0'><img BORDER=0 src='job_class/job_beginner.gif'></td>
              <td><a BORDER=0 href='ranking.php?order=". $_GET['order'] ."&job=1'><img BORDER=0 src='job_class/job_warrior.gif'></td>
              <td><a BORDER=0 href='ranking.php?order=". $_GET['order'] ."&job=2'><img BORDER=0 src='job_class/job_magician.gif'></td>
              <td><a BORDER=0 href='ranking.php?order=". $_GET['order'] ."&job=3'><img BORDER=0 src='job_class/job_bowman.gif'></td>
              <td><a BORDER=0 href='ranking.php?order=". $_GET['order'] ."&job=4'><img BORDER=0 src='job_class/job_thief.gif'></td>
              <td><a BORDER=0 href='ranking.php?order=". $_GET['order'] ."&job=5'><img BORDER=0 src='job_class/job_pirate.gif'></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> reborns </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='guild.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['reborns'];
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_pirate.gif'>";
if($row['job'] >= 900 && $row['job'] < 999)
echo "<img src='job_class/job_gm.gif'>";
echo "<br>";

if ($row['job']=="510")
echo "Gunslinger";
if ($row['job']=="900")
echo "GM";
if ($row['job']=="910")
echo "Super GM";
if ($row['job']=="520")
echo "Brawler";
if ($row['job']=="511")
echo "Outlaw";
if ($row['job']=="512")
echo "Corsair";
if ($row['job']=="521")
echo "Marauder";
if ($row['job']=="522")
echo "Buccaneer";
if ($row['job']=="500")
echo "Pirate";
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'] ."'>First</a> | <a href='ranking.php?start=". ($start - 5) ."&order=". $_GET['order'] ."&job=". $_GET['job'] ."'>Previous</a> | ";
else
echo "First | Previous | ";
if($num_players % 4)
$num_players = $num_players - ($num_players % 4);
else
$num_players -= 5;
if($start <= $num_players - 4)
echo "<a href='ranking.php?start=". ($start + 4) ."&order=". $_GET['order'] ."&job=". $_GET['job'] ."'>Next</a> | <a href='ranking.php?start=".($num_players) ."&order=". $_GET['order'] ."&job=". $_GET['job'] ."'>Last</a>";
else
echo "Next | Last";

echo "</b></td><td>    </td><td align ='center'><b>";

if($_GET['order'] == "reborns")
echo "<a href='ranking.php?order=level&job=". $_GET['job'] ."'>Level</a> | reborns | <a href='ranking.php?order=wins&job=". $_GET['job'] ."'>FoJ Wins</a> ";
elseif($_GET['order'] == "wins")
echo "<a href='ranking.php?order=level&job=". $_GET['job'] ."'>Level</a> | <a href='ranking.php?order=reborns&job=". $_GET['job'] ."'>reborns</a> | FoJ Wins ";
else
echo "Level | <a href='ranking.php?order=reborns&job=". $_GET['job'] ."'>reborns</a> | <a href='ranking.php?order=wins&job=". $_GET['job'] ."'>FoJ Wins</a> ";

echo "</b></td>\n<td>    </td><td><b>Page:</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>".($int + 1)."</b></option>\n";
  else
    echo "<option value='". ($int * 5) ."'><b>".($int + 1)."</b></option>\n";
}
echo "</select>";

echo "</td></tr></table></body>";
?>

<?php include ("end.php"); ?>

Edited a bit, make sure to add the pirate image named job_pirate.gif to the folder job_class.

Image:

ProGamerForLife · Mar 20, 2009

lol any 1 with half a brain would have this updated by nao
but
gj?~

bluepiexD · Mar 20, 2009

Finally someone added it, now all the noobs can leech. :]

Kars · Mar 20, 2009

ProGamerForLife said:
lol any 1 with half a brain would have this updated by nao
but
gj?~

so, this is for every1 with < half brain.

bluepiexD said:
Finally someone added it, now all the noobs can leech. :]

exactly.

josho192837 · Mar 20, 2009

You suck....

Everyone uses Cype =]

Kars · Mar 20, 2009

josho192837 said:
You suck....

Everyone uses Cype =]

i don't use a cms, don't even have a server.

rotmensen91 · Mar 20, 2009

Kars said:
i don't use a cms, don't even have a server.

win win win win

josho192837 · Mar 20, 2009

Kars said:
i don't use a cms, don't even have a server.

That makes no sense.

I was saying this is useless, everyone seems to use Cype.

Horizon · Mar 20, 2009

This has been released like, what, 5 times?

Ehab · Mar 20, 2009

lol @ what's in the spoiler

:

rotmensen91 · Mar 20, 2009

Ehab said:
lol @ what's in the spoiler :

it's like looking in the mirror, isn't it noob

Kars · Mar 20, 2009

josho192837 said:
Says the pro.

Please tell me what the conflict is so i can choose sides and participate.

rotmensen91 · Mar 20, 2009

Murawd said:
Lol, did you just call Josh, of all people, a noob?

i don't see him releasing anything of value other than his half finished CMS.
enlighten me.

Horizon · Mar 20, 2009

rotmensen91 said:
i don't see him releasing anything of value other than his half finished CMS.
enlighten me.

He coded Cype, dumbass. I was nothing but the designer for over 150 revisions.

Kars · Mar 20, 2009

Murawd said:
He coded Cype, dumbass. I was nothing but the designer for over 150 revisions.

wow, mustn't that hurt.

rotmensen91 · Mar 20, 2009

Murawd said:
He coded Cype, dumbass. I was nothing but the designer for over 150 revisions.

then I stand corrected.

my apologies josho

grbnike2 · Mar 20, 2009

lol u released this i tought u made it private for me f3

Kars · Mar 20, 2009

grbnike2 said:
lol u released this i tought u made it private for me f3

lol, it isn't very special.

YaNdAoGM · Mar 21, 2009

The only part to add is add the job ids and remove the images as you don't have the images for pirates

DevilOverLord · Mar 21, 2009

imma extract the character images soon.
EDIT:got no time for pirate images T.T

s0wh4t?'s ranking with pirates

Smoke & Fly

Elite Diviner

Elite Diviner

Smoke & Fly

🚫

Smoke & Fly

Junior Spellweaver

🚫

:)

Xephizion Development

Junior Spellweaver

Smoke & Fly

Junior Spellweaver

:)

Smoke & Fly

Junior Spellweaver

Junior Spellweaver

Smoke & Fly

Elite Diviner

Junior Spellweaver

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners