Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "Changeme";
- $dbname = "unturned";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "SELECT PlayerId, Balance, LastUpdate FROM pvp_economybankaccount";
- "SELECT SteamID, SteamName FROM pvp_playerinfo";
- "ORDER BY Balance DESC";
- $result = $conn->query($sql);
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <title>Balance</title>
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script>
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" />
- <link rel="stylesheet" href="https://cdn.datatables.net/1.10.12/css/dataTables.bootstrap.min.css" />
- <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>
- </head>
- <body>
- <br /><br />
- <div class="container">
- <h3 aligen="center">Balance on all Spoder PvP servers.</h3>
- <br />
- <div class="table-responsive">
- <table id="pvp_economybankaccount" class="table table-striped table-bordered">
- <thead>
- <tr>
- <td>Player</td>
- <td>Balance</td>
- <td>LastUpdate</td>
- </tr>
- </thead>
- <?php
- while($row = mysqli_fetch_array($result))
- {
- echo '
- <tr>
- <td><a href=http://steamcommunity.com/profiles/'.$row["PlayerId"]. "\>".$row['PlayerId'].'</a></td>
- <td>'.$row['Balance'].'</td>
- <td>'.$row['LastUpdate'].'</td>
- </tr>
- ';
- }
- ?>
- </table>
- </div>
- </div>
- </body>
- </html>
- <script>
- $(document).ready(function(){
- $('#pvp_economybankaccount').DataTable();
- $('#pvp_economytransaction').DataTable();
- });
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement