Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once('inc/config.inc.php');
- require_once('inc/functions.inc.php');
- ?>
- <head>
- <style type="text/css">
- .rank {
- background-color: #363636
- }
- </style>
- <title>Ranking</title>
- <link href="style.css" rel="stylesheet" type="text/css"/>
- <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
- </head>
- <body><center>
- <h2 style="font-weight: normal; margin-top: 5px; margin-bottom: 0px;">Top 50 Player Ranking</h2>
- <br>
- <table style="border: 0px solid blue; font-size: 12px;" cellpadding="0" cellspacing="0" class="rank" margin-top:"-20px">
- <tr style="color: #dcdcdc;">
- <td style="border-right: 1px solid #363636; background-color: #4074bf; width: 50px; height: 30px;" align="center">Rang</td>
- <td style="border-right: 1px solid #363636; background-color: #4074bf; width: 100px; height: 30px;" align="center">Name</td>
- <td style="border-right: 1px solid #363636; background-color: #4074bf; width: 100px; height: 30px;" align="center">Level</td>
- <td style="border-right: 1px solid #363636; background-color: #4074bf; width: 100px; height: 30px;" align="center">Klasse</td>
- </tr>
- <?php
- $verbindung = mysql_connect ("localhost",
- "root", "1234")
- or die ("keine Verbindung möglich.
- Benutzername oder Passwort sind falsch");
- mysql_select_db("flyff")
- or die ("Die Datenbank existiert nicht.");
- $abfrage = "SELECT charname, level, class, sex FROM characters ORDER BY level DESC LIMIT 50";
- $ergebnis = mysql_query($abfrage);
- while($row = mysql_fetch_object($ergebnis))
- {
- if ($row->class == 0) { $row->class = '<img src="img/0.png">';}
- if ($row->class == 1) { $row->class = '<img src="img/1.png">';}
- if ($row->class == 2) { $row->class = '<img src="img/2.png">';}
- if ($row->class == 3) { $row->class = '<img src="img/3.png">';}
- if ($row->class == 4) { $row->class = '<img src="img/4.png">';}
- if ($row->class == 6) { $row->class = '<img src="img/6.png">';}
- if ($row->class == 7) { $row->class = '<img src="img/7.png">';}
- if ($row->class == 8) { $row->class = '<img src="img/8.png">';}
- if ($row->class == 9) { $row->class = '<img src="img/9.png">';}
- if ($row->class == 10) { $row->class = '<img src="img/10.png">';}
- if ($row->class == 11) { $row->class = '<img src="img/11.png">';}
- if ($row->class == 12) { $row->class = '<img src="img/12.png">';}
- if ($row->class == 13) { $row->class = '<img src="img/13.png">';}
- if ($row->class == 16) { $row->class = '<img src="img/6.png">';}
- if ($row->class == 17) { $row->class = '<img src="img/7.png">';}
- if ($row->class == 18) { $row->class = '<img src="img/8.png">';}
- if ($row->class == 19) { $row->class = '<img src="img/9.png">';}
- if ($row->class == 20) { $row->class = '<img src="img/10.png">';}
- if ($row->class == 21) { $row->class = '<img src="img/11.png">';}
- if ($row->class == 22) { $row->class = '<img src="img/12.png">';}
- if ($row->class == 23) { $row->class = '<img src="img/13.png">';}
- if ($row->class == 24) { $row->class = '<img src="img/6.png">';}
- if ($row->class == 25) { $row->class = '<img src="img/7.png">';}
- if ($row->class == 26) { $row->class = '<img src="img/8.png">';}
- if ($row->class == 27) { $row->class = '<img src="img/9.png">';}
- if ($row->class == 28) { $row->class = '<img src="img/10.png">';}
- if ($row->class == 29) { $row->class = '<img src="img/11.png">';}
- if ($row->class == 30) { $row->class = '<img src="img/12.png">';}
- if ($row->class == 31) { $row->class = '<img src="img/13.png">';}
- if ($row->level == 2 && $row->class == 6) { $row->level = '<img src="img/m1.png">';}
- ?>
- <tr>
- <td style="border-right: 1px solid #4074bf; width: 20px; height: 30px;" align="center"><?php
- for ($i=1; $i++;)
- echo "" . $i . "";
- ?></td>
- <td style="border-right: 1px solid #4074bf; width: 50px; height: 30px;" align="center"><?php echo $row->charname; ?></td>
- <td style="border-right: 1px solid #4074bf; width: 100px; height: 30px;" align="center"><?php echo $row->level; ?></td>
- <td style="border-right: 1px solid #4074bf; width: 100px; height: 30px;" align="center"><?php echo $row->class;?></td>
- </tr>
- <?php
- }
- ?>
Add Comment
Please, Sign In to add comment