Advertisement
Guest User

Untitled

a guest
Oct 4th, 2018
639
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.86 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = "Changeme";
  5. $dbname = "unturned";
  6.  
  7. // Create connection
  8. $conn = new mysqli($servername, $username, $password, $dbname);
  9. // Check connection
  10. if ($conn->connect_error) {
  11.     die("Connection failed: " . $conn->connect_error);
  12. }
  13.  
  14. $sql = "SELECT PlayerId, Balance, LastUpdate FROM pvp_economybankaccount";
  15.        "SELECT SteamID, SteamName FROM pvp_playerinfo";
  16.        "ORDER BY Balance DESC";
  17. $result = $conn->query($sql);
  18. ?>
  19. <!DOCTYPE html>
  20. <html>
  21.     <head>
  22.         <title>Balance</title>
  23.         <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script>
  24.         <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" />
  25.         <link rel="stylesheet" href="https://cdn.datatables.net/1.10.12/css/dataTables.bootstrap.min.css" />
  26.         <script type="text/javascript" src="https://cdn.datatables.net/r/bs-3.3.5/jqc-1.11.3,dt-1.10.8/datatables.min.js"></script>
  27.     </head>
  28.     <body>
  29.         <br /><br />
  30.         <div class="container">
  31.             <h3 aligen="center">Balance on all Spoder PvP servers.</h3>
  32.             <br />
  33.             <div class="table-responsive">
  34.                 <table id="pvp_economybankaccount" class="table table-striped table-bordered">
  35.                     <thead>
  36.                         <tr>
  37.                             <td>Player</td>
  38.                             <td>Balance</td>
  39.                             <td>LastUpdate</td>
  40.                         </tr>
  41.                     </thead>
  42.                     <?php
  43.                     while($row = mysqli_fetch_array($result))
  44.                     {
  45.                         echo '
  46.                         <tr>
  47.                             <td><a href=http://steamcommunity.com/profiles/'.$row["PlayerId"]. "\>".$row['PlayerId'].'</a></td>
  48.                             <td>'.$row['Balance'].'</td>
  49.                             <td>'.$row['LastUpdate'].'</td>
  50.                         </tr>
  51.                         ';
  52.                     }
  53.            
  54.                     ?>
  55.                 </table>
  56.             </div>
  57.         </div>
  58.     </body>
  59. </html>
  60.  
  61.  
  62.  
  63. <script>
  64. $(document).ready(function(){
  65.     $('#pvp_economybankaccount').DataTable();
  66.     $('#pvp_economytransaction').DataTable();
  67. });
  68. </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement