Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include('../../db_connect.php');
- $tablename = "page_load";
- date_default_timezone_set('Europe/Amsterdam');
- $con = mysqli_connect($servername, $username, $password, $dbname);
- if ($con->connect_error) {
- die("Connection failed: " . $con->connect_error);
- }
- if(isset($_POST['load'])){
- if(isset($_POST['togglebots'])){
- $sqlselect = "SELECT * FROM `page_load` WHERE `bot` = 0";
- }else{
- $sqlselect = "SELECT * FROM page_load";
- }
- $resultselect = $con->query($sqlselect);
- if ($resultselect->num_rows > 0) {
- echo '<div style="margin:10px;"><table style="padding:10px">';
- while($row = mysqli_fetch_array($resultselect, MYSQLI_BOTH)) {
- $temp = date('Y-m-d h:i:s',$row['firsttime']);
- $temp2 = date('Y-m-d h:i:s',$row['lasttime']);
- echo '
- <tr >
- <td style="padding:6px; border: 1px solid black;">ID: </td>
- <td style="padding:6px; border: 1px solid black;"> ' . $row['id'] . ' </td>
- <td style="padding:6px; border: 1px solid black;">Useragent:</td>
- <td style="padding:6px; border: 1px solid black;"> ' . $row['useragent'] . ' </td>
- <td style="padding:6px; border: 1px solid black;">REMOTE ADDR:</td>
- <td style="padding:6px; border: 1px solid black;"> ' . $row['ip_address'] . ' </td>
- <td style="padding:6px; border: 1px solid black;">TAG: </td>
- <td style="padding:6px; border: 1px solid black;">' . $row['tag'] . ' </td>
- <td style="padding:6px; border: 1px solid black;">BOT: </td>
- <td style="padding:6px; border: 1px solid black;">' . $row['bot'] . ' </td>
- <td style="padding:6px; border: 1px solid black;">First reload: </td>
- <td style="padding:6px; border: 1px solid black;">' . $temp . ' </td>
- <td style="padding:6px; border: 1px solid black;">Last reload: </td>
- <td style="padding:6px; border: 1px solid black;">' . $temp2 . '</td>
- <td style="padding:6px; border: 1px solid black;">Total reloads: </td>
- <td style="padding:6px; border: 1px solid black;">' . $row['totalreloads'] . '</td>
- </tr>';
- }
- echo '</table></div>';
- } else {
- echo "<p>0 results</p></table></div>";
- }
- $con->close();
- }
- if(isset($_POST['clear'])){
- if(isset($_POST['firstentry'])){
- mysql_connect( $servername, $username, $password ) or die( mysql_error() );
- mysql_select_db( $dbname ) or die( mysql_error() );
- mysql_query( "TRUNCATE TABLE " . $tablename );
- }
- }
- ?>
- <html>
- <head>
- <link rel="shortcut icon" href="../img/site-icon.ico">
- <link href="../css/bootstrap.min.css" rel="stylesheet">
- <link href="../css/clean-blog.min.css" rel="stylesheet">
- <title>Check reloads</title>
- </head>
- <body class="adminpanel">
- <div style='margin:20px;'>
- <form method="post" action="checkreloads.php" >
- <table>
- <tr>
- <td>
- <input class="btnlogin" type="submit" name="load" value="Reload">
- </td>
- <td>
- <div style="padding:0px;" class="slideThree">
- <input type="checkbox" value="None" id="slideThree" name="togglebots" >
- <label for="slideThree"></label>
- </div>
- </td>
- <td>
- <input class="btnlogin" type="submit" name="clear" value="Clear database">
- </td>
- <td>
- <div class="slideThree">
- <input type="checkbox" value="None" id="slideThree" name="firstentry" >
- <label for="slideThree"></label>
- </div>
- </td>
- </tr>
- </table>
- </form>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement