Guest User

Untitled

a guest
Jul 17th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.25 KB | None | 0 0
  1. <?php
  2. require_once('inc/config.inc.php');
  3. require_once('inc/functions.inc.php');
  4. ?>
  5. <head>
  6. <style type="text/css">
  7. .rank {
  8. background-color: #363636
  9. }
  10. </style>
  11. <title>Ranking</title>
  12. <link href="style.css" rel="stylesheet" type="text/css"/>
  13. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  14. </head>
  15. <body><center>
  16. <h2 style="font-weight: normal; margin-top: 5px; margin-bottom: 0px;">Top 50 Player Ranking</h2>
  17. <br>
  18. <table style="border: 0px solid blue; font-size: 12px;" cellpadding="0" cellspacing="0" class="rank" margin-top:"-20px">
  19. <tr style="color: #dcdcdc;">
  20. <td style="border-right: 1px solid #363636; background-color: #4074bf; width: 50px; height: 30px;" align="center">Rang</td>
  21. <td style="border-right: 1px solid #363636; background-color: #4074bf; width: 100px; height: 30px;" align="center">Name</td>
  22. <td style="border-right: 1px solid #363636; background-color: #4074bf; width: 100px; height: 30px;" align="center">Level</td>
  23. <td style="border-right: 1px solid #363636; background-color: #4074bf; width: 100px; height: 30px;" align="center">Klasse</td>
  24. </tr>
  25. <?php
  26. $verbindung = mysql_connect ("localhost",
  27. "root", "1234")
  28. or die ("keine Verbindung möglich.
  29. Benutzername oder Passwort sind falsch");
  30.  
  31. mysql_select_db("flyff")
  32. or die ("Die Datenbank existiert nicht.");
  33.  
  34. $abfrage = "SELECT charname, level, class, sex FROM characters ORDER BY level DESC LIMIT 50";
  35. $ergebnis = mysql_query($abfrage);
  36. while($row = mysql_fetch_object($ergebnis))
  37. {
  38. if ($row->class == 0) { $row->class = '<img src="img/0.png">';}
  39. if ($row->class == 1) { $row->class = '<img src="img/1.png">';}
  40. if ($row->class == 2) { $row->class = '<img src="img/2.png">';}
  41. if ($row->class == 3) { $row->class = '<img src="img/3.png">';}
  42. if ($row->class == 4) { $row->class = '<img src="img/4.png">';}
  43. if ($row->class == 6) { $row->class = '<img src="img/6.png">';}
  44. if ($row->class == 7) { $row->class = '<img src="img/7.png">';}
  45. if ($row->class == 8) { $row->class = '<img src="img/8.png">';}
  46. if ($row->class == 9) { $row->class = '<img src="img/9.png">';}
  47. if ($row->class == 10) { $row->class = '<img src="img/10.png">';}
  48. if ($row->class == 11) { $row->class = '<img src="img/11.png">';}
  49. if ($row->class == 12) { $row->class = '<img src="img/12.png">';}
  50. if ($row->class == 13) { $row->class = '<img src="img/13.png">';}
  51. if ($row->class == 16) { $row->class = '<img src="img/6.png">';}
  52. if ($row->class == 17) { $row->class = '<img src="img/7.png">';}
  53. if ($row->class == 18) { $row->class = '<img src="img/8.png">';}
  54. if ($row->class == 19) { $row->class = '<img src="img/9.png">';}
  55. if ($row->class == 20) { $row->class = '<img src="img/10.png">';}
  56. if ($row->class == 21) { $row->class = '<img src="img/11.png">';}
  57. if ($row->class == 22) { $row->class = '<img src="img/12.png">';}
  58. if ($row->class == 23) { $row->class = '<img src="img/13.png">';}
  59. if ($row->class == 24) { $row->class = '<img src="img/6.png">';}
  60. if ($row->class == 25) { $row->class = '<img src="img/7.png">';}
  61. if ($row->class == 26) { $row->class = '<img src="img/8.png">';}
  62. if ($row->class == 27) { $row->class = '<img src="img/9.png">';}
  63. if ($row->class == 28) { $row->class = '<img src="img/10.png">';}
  64. if ($row->class == 29) { $row->class = '<img src="img/11.png">';}
  65. if ($row->class == 30) { $row->class = '<img src="img/12.png">';}
  66. if ($row->class == 31) { $row->class = '<img src="img/13.png">';}
  67. if ($row->level == 2 && $row->class == 6) { $row->level = '<img src="img/m1.png">';}
  68. ?>
  69. <tr>
  70. <td style="border-right: 1px solid #4074bf; width: 20px; height: 30px;" align="center"><?php
  71. for ($i=1; $i++;)
  72. echo "" . $i . "";
  73. ?></td>
  74. <td style="border-right: 1px solid #4074bf; width: 50px; height: 30px;" align="center"><?php echo $row->charname; ?></td>
  75. <td style="border-right: 1px solid #4074bf; width: 100px; height: 30px;" align="center"><?php echo $row->level; ?></td>
  76. <td style="border-right: 1px solid #4074bf; width: 100px; height: 30px;" align="center"><?php echo $row->class;?></td>
  77. </tr>
  78. <?php
  79. }
  80. ?>
Add Comment
Please, Sign In to add comment