Advertisement
Guest User

Untitled

a guest
Apr 15th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.77 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <style>
  5. #customers {
  6. font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
  7. width: 100%;
  8. border-collapse: collapse;
  9. background-color: white;
  10.  
  11. }
  12.  
  13. #customers td, #customers th {
  14. font-size: 1em;
  15. border: 1px solid #98bf21;
  16. padding: 3px 7px 2px 7px;
  17. }
  18.  
  19. #customers th {
  20. font-size: 1.1em;
  21. text-align: left;
  22. padding-top: 5px;
  23. padding-bottom: 4px;
  24. background-color: #A7C942;
  25. color: #ffffff;
  26. }
  27.  
  28. #customers tr.alt td {
  29. color: #000000;
  30. background-color: green;
  31. }
  32. </style>
  33. </head>
  34. <body>
  35.  
  36. <?
  37.  
  38. //DATABASE LOGIN
  39. $host = '';
  40. $username = 'root';
  41. $password = '';
  42. $database = 'skyblock';
  43. mysql_connect($host,$username,$password);
  44. mysql_select_db($database);
  45. echo "<div>
  46. <table style='width: 100%;' border='1'; id='customers'>
  47. <tbody>
  48. <tr>
  49. <td><center>#</center></td>
  50. <td><center>Player Name</center></td>
  51. <td><center>Quests Completed</center></td>
  52. <td><center>Island Level</center></td>
  53. </tr>";
  54. $number = 1;
  55. while($number < 50) {
  56.  
  57.  
  58. $sor = mysql_query("SELECT * FROM `user-data` ORDER BY challenges DESC LIMIT 0,100");
  59. while($yaz=mysql_fetch_array($sor)){
  60. $isim=$yaz['username'];
  61. $oldurme=$yaz['challenges'];
  62. $moboldurme=$yaz['islandLevel'];
  63. echo "
  64. <tr>
  65. <td><center>$number</font></td>
  66. <td><center>$isim</font></td>
  67. <td><center>";echo (number_format($oldurme, 0, ".", ",") ); echo "</font></td>
  68. <td><center>";echo (number_format($moboldurme, 0, ".", ",") ); echo "</font></td>
  69. </tr>
  70. ";
  71.  
  72. $number++;
  73. }}
  74. echo"</tbody></table><br>
  75. </div>";
  76. ?>
  77.  
  78. </body>
  79. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement