Tunestiga Pastebin

Wasteland Stats

From Masa, 9 Years ago, written in PHP, viewed 535 times.
URL https://paste.tunestiga.com/view/22766e0c Shorturl Error: Input provided by user is not valid Embed
Download Paste or View Raw
  1. <html>
  2. <head>
  3.         <meta charset="utf-8">
  4.         <title>arma3.ddaygaming.com:2302 Wasteland stats</title>
  5.        
  6.         <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
  7. </head>
  8.  
  9. <body>
  10.     <div class="container">
  11. <?php
  12. $dbaddress = "server_ip_here";
  13. $dbusername = "database_username";
  14. $dbpassword = "database_password";
  15. $dbname = "database_name";
  16. $con=mysqli_connect("$dbaddress","$dbusername","$dbpassword","$dbname");  //server address, username, password, dbname// Check connection
  18. {
  19. echo "Failed to connect to MySQL: " . mysqli_connect_error();
  20. }
  21.         //check order ascending or descending
  22.         if (isset($_GET["order"])) {
  23.                 $sort = $_GET["order"];
  24.                 if ($_GET["order"] == "asc"){
  25.                         $sort = "desc";
  26.                         $order = "asc";
  27.                 }
  28.                 else{
  29.                         $sort = "asc";
  30.                         $order = "desc";
  31.                 }
  32.         }
  33.        
  34.         //check filter
  35.         if (isset($_GET["name"])) {
  36.                 $name = $_GET["name"];
  37.                 }
  38.                         else {
  39.                         $name = "Name";
  40.                                 }
  41. $list=array('Name', 'BankMoney', 'CaptureCount', 'PlayerKills', 'AIKills', 'ReviveCount', 'DeathCount');
  42. if (in_array($name,$list))
  43. {
  44.         //variable ok
  45. }
  46.         else
  47.         {
  48.                 $name = "name";
  49.         }
  50.        
  51.        
  52.  
  53. $query = mysqli_query($con,"SELECT * FROM playerinfo a INNER JOIN playerstats p ON a.UID = p.PlayerUID ORDER BY $name $order");
  54.  
  55. ?><!--//echo "<table border='1'>-->
  56. <table class="table">
  57. <tr>
  58. <?php echo "<th><a href=\"?order=$sort&name=Name\">Player Name</a></th>";?>
  59. <?php echo "<th><a href=\"?order=$sort&name=BankMoney\">Money</a></th>";?>
  60. <?php echo "<th><a href=\"?order=$sort&name=CaptureCount\">Capture Count</a></th>";?>
  61. <?php echo "<th><a href=\"?order=$sort&name=PlayerKills\">Player Kills</a></th>";?>
  62. <?php echo "<th><a href=\"?order=$sort&name=AIKills\">AI Kills</a></th>";?>
  63. <?php echo "<th><a href=\"?order=$sort&name=ReviveCount\">Revives</a></th>";?>
  64. <?php echo "<th><a href=\"?order=$sort&name=DeathCount\">Deaths</a></th>";?>
  65. </tr>
  66. <!--//";-->
  67. <?php
  68.  
  69. while($row = mysqli_fetch_array($query))
  70. {
  71. ?><tr class="success"><?php
  72. echo "<td>" . $row['Name'] . "</td>";
  73. echo "<td>" . $row['BankMoney'] . "</td>";
  74. echo "<td>" . $row['CaptureCount'] . "</td>";
  75. echo "<td>" . $row['PlayerKills'] . "</td>";
  76. echo "<td>" . $row['AIKills'] . "</td>";
  77. echo "<td>" . $row['ReviveCount'] . "</td>";
  78. echo "<td>" . $row['DeathCount'] . "</td>";
  79. echo "</tr>";
  80. }
  81. echo "</table>";
  82.  
  84. ?>
  85. <a href="http://ddaygaming.com">©ddaygaming.com</a>
  86. </div>
  87. </body>
  88. </html>
  89.  

Reply to "Wasteland Stats"

Here you can reply to the paste above

Powered by Stikked