Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $username = 'bansyste_owcheck';
- $db = 'bansyste_owchecker';
- $hb = '127.0.0.1'; //localhost
- $pass = '';
- $connection = new mysqli($hb, $username, $pass, $db);
- if ($connection->connect_error) {
- die($connection->connect_error);
- }
- ?>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Banned Accounts</title>
- <link rel="stylesheet" type="text/css" href="dashboard/bootstrap/css/bootstrap.min.css" />
- <link rel="stylesheet" type="text/css" href="dashboard/font-awesome/css/font-awesome.min.css" />
- <link rel="stylesheet" type="text/css" href="dashboard/css/local.css" />
- <link rel="stylesheet" type="text/css" href="dashboard/css/util.css">
- <link rel="stylesheet" type="text/css" href="dashboard/vendor/animate/animate.css">
- <!--===============================================================================================-->
- <link rel="stylesheet" type="text/css" href="dashboard/vendor/select2/select2.min.css">
- <!--===============================================================================================-->
- <link rel="stylesheet" type="text/css" href="dashboard/vendor/perfect-scrollbar/perfect-scrollbar.css">
- <script type="text/javascript" src="dashboard/js/jquery-1.10.2.min.js"></script>
- <script type="text/javascript" src="dashboard/bootstrap/js/bootstrap.min.js"></script>
- <script type="text/javascript" src="dashboard/vendor/bootstrap/js/popper.js"></script>
- <script src="dashboard/vendor/select2/select2.min.js"></script>
- <script src="dashboard/vendor/perfect-scrollbar/perfect-scrollbar.min.js"></script>
- </head>
- <body>
- <div>
- <div id="page-wrapper">
- <div class="row">
- <div class="col-lg-12">
- <h3>Banned Accounts</h3>
- </div>
- </div>
- <div class="row">
- <div class="col-lg-12">
- <div class="table100 ver3 m-b-110">
- <div class="table100-head">
- <table>
- <thead>
- <tr class="row100 head">
- <th class="cell100 column1">Name</th>
- <th class="cell100 column2">Ban Date</th>
- <th class="cell100 column3">Profile</th>
- <th class="cell100 column4">Status</th>
- </tr>
- </thead>
- </table>
- </div>
- <?php
- $query = "SELECT SteamID, steamName, Avatar, BanDate FROM steamaccount WHERE banDate IS NOT NULL ORDER BY banDate DESC";
- $stmt = $connection->prepare($query);
- $stmt->bind_result($steamid, $name, $avatar, $BanDate);
- $stmt->execute();
- $content = [];
- $tempi = 0;
- while ($stmt->fetch()) {
- $content[$tempi]['steamID'] = $steamid;
- $content[$tempi]['steamName'] = $name;
- $content[$tempi]['avatarLink'] = $avatar;
- $content[$tempi]['banState'] = 1;
- $content[$tempi]['banDate'] = $BanDate;
- $tempi++;
- }
- displayAccounts($content);
- function displayAccounts($data)
- {
- $output = "<div class=\"table100-body js-pscroll\">
- <div class=\"table100-body js-pscroll\">
- <div class=\"table100-body js-pscroll\">
- <table>
- <tbody>";
- foreach ($data as $key => $var) {
- $output .= "<tr class=\"row100 body\">";
- $output .= "<td class=\"cell100 column1\"><img src=\"" . $var['avatarLink'] . "\" height=64 width=64 ></img> " . $var['steamName'] . "</td>";
- $output .= "<td class=\"cell100 column2\">" . $var['banDate'] . "</td>";
- $output .= "<td class=\"cell100 column3\"><a href=\"https://steamcommunity.com/profiles/" . $var['steamID'] . "\">" . $var['steamID'] . "</a></td>";
- $output .= "<td class=\"cell100 column4\" " . ($var['banState'] == 0 ? 'id="notbanned"' : 'id="banned"') .">" . ($var['banState'] == 0 ? 'Not banned' : 'Banned') . "</td>";
- $output .= "</tr>";
- }
- $output .= "</tbody>";
- $output .= "</table>";
- $output .= "</div>";
- $output .= "</div>";
- $output .= "</div>";
- echo $output;
- }
- ?>
- </div>
- </div>
- </div>
- </div>
- </div>
- <!-- /#wrapper -->
- </body>
- <script src="dashboard/js/main.js"></script>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement