Вход Регистрация
Файл: spammer-logs.php
Строк: 59
<?php
require_once "core.php";
head();

if (isset(
$_GET['delete-id'])) {
    
$id    = (int) $_GET["delete-id"];
    
$table $prefix 'logs';
    
$query $mysqli->query("DELETE FROM `$table` WHERE id='$id'");
}

if (isset(
$_GET['delete-all'])) {
    
$table $prefix 'logs';
    
$query $mysqli->query("DELETE FROM `$table` WHERE type='Spammer'");
}
?>
<div class="content-wrapper">

            <!--CONTENT CONTAINER-->
            <!--===================================================-->
            <div class="content-header">
                
                <div class="container-fluid">
                  <div class="row mb-2">
                    <div class="col-sm-6">
                      <h1 class="m-0 "><i class="fas fa-align-justify"></i> Spammer Logs</h1>
                    </div>
                    <div class="col-sm-6">
                      <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item"><a href="dashboard.php"><i class="fas fa-home"></i> Admin Panel</a></li>
                        <li class="breadcrumb-item active">Spammer Logs</li>
                      </ol>
                    </div>
                  </div>
                </div>
            </div>

                <!--Page content-->
                <!--===================================================-->
                <div class="content">
                <div class="container-fluid">

                <div class="row">
                <div class="col-md-12">
                    
                    <div class="card card-primary card-outline">
                        <div class="card-header">
                            <h3 class="card-title">Spammer Logs</h3>
                            <a href="?delete-all" class="btn btn-flat btn-danger btn-sm float-sm-right" data-toggle="tooltip" title="Delete all Spammer logs"><i class="fas fa-trash"></i> Delete All</a>
                        </div>
                        <div class="card-body">

<table id="dt-basic" class="table table-bordered table-hover table-sm">
                                    <thead class="<?php echo $thead?>">
                                        <tr>
                                          <th>IP Address</th>
                                          <th>Date</th>
                                          <th>Browser</th>
                                          <th>OS</th>
                                          <th>Country</th>
                                          <th>Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
<?php
$table 
$prefix 'logs';
$sql   $mysqli->query("SELECT id, ip, date, time, browser, browser_code, os, os_code, country, country_code, type FROM `$table` WHERE type='Spammer' ORDER by id DESC");
while (
$row mysqli_fetch_assoc($sql)) {
    echo 
'
                                        <tr>
                                          <td>' 
$row['ip'] . '</td>
                                          <td data-sort="' 
strtotime($row['date']) . '">' $row['date'] . ' at ' $row['time'] . '</td>
                                          <td><img src="assets/img/icons/browser/' 
$row['browser_code'] . '.png" /> ' $row['browser'] . '</td>
                                          <td><img src="assets/img/icons/os/' 
$row['os_code'] . '.png" /> ' $row['os'] . '</td>
                                          <td><img src="assets/plugins/flags/blank.png" class="flag flag-' 
strtolower($row['country_code']) . '" alt="' $row['country'] . '" /> ' $row['country'] . '</td>
                                          <td>
                                            <a href="log-details.php?id=' 
$row['id'] . '" class="btn btn-flat btn-primary btn-sm"><i class="fas fa-tasks"></i> Details</a>
                                            <a href="?delete-id=' 
$row['id'] . '" class="btn btn-flat btn-danger btn-sm"><i class="fas fa-trash"></i> Delete</a>
                                          </td>
                                        </tr>
'
;
}
?>
                                    </tbody>
                                    </table>

                        </div>
                     </div>
                </div>
                    
                </div>
                    
                </div>
                </div>
                <!--===================================================-->
                <!--End page content-->

            </div>
            <!--===================================================-->
            <!--END CONTENT CONTAINER-->
</div>
<script>
$(document).ready(function() {

    $('#dt-basic').dataTable( {
        "responsive": true,
        "order": [[ 1, "desc" ]],
        "language": {
            "paginate": {
              "previous": '<i class="fas fa-angle-left"></i>',
              "next": '<i class="fas fa-angle-right"></i>'
            }
        }
    } );
} );
</script>    
<?php
footer
();
?>
Онлайн: 2
Реклама