Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <style>
- #customers {
- font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
- width: 100%;
- border-collapse: collapse;
- background-color: white;
- }
- #customers td, #customers th {
- font-size: 1em;
- border: 1px solid #98bf21;
- padding: 3px 7px 2px 7px;
- }
- #customers th {
- font-size: 1.1em;
- text-align: left;
- padding-top: 5px;
- padding-bottom: 4px;
- background-color: #A7C942;
- color: #ffffff;
- }
- #customers tr.alt td {
- color: #000000;
- background-color: green;
- }
- </style>
- </head>
- <body>
- <?
- //DATABASE LOGIN
- $host = '';
- $username = 'root';
- $password = '';
- $database = 'skyblock';
- mysql_connect($host,$username,$password);
- mysql_select_db($database);
- echo "<div>
- <table style='width: 100%;' border='1'; id='customers'>
- <tbody>
- <tr>
- <td><center>#</center></td>
- <td><center>Player Name</center></td>
- <td><center>Quests Completed</center></td>
- <td><center>Island Level</center></td>
- </tr>";
- $number = 1;
- while($number < 50) {
- $sor = mysql_query("SELECT * FROM `user-data` ORDER BY challenges DESC LIMIT 0,100");
- while($yaz=mysql_fetch_array($sor)){
- $isim=$yaz['username'];
- $oldurme=$yaz['challenges'];
- $moboldurme=$yaz['islandLevel'];
- echo "
- <tr>
- <td><center>$number</font></td>
- <td><center>$isim</font></td>
- <td><center>";echo (number_format($oldurme, 0, ".", ",") ); echo "</font></td>
- <td><center>";echo (number_format($moboldurme, 0, ".", ",") ); echo "</font></td>
- </tr>
- ";
- $number++;
- }}
- echo"</tbody></table><br>
- </div>";
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement