counter_del.php

<?php
    exit("Function disabled.");
    $root = $_SERVER['DOCUMENT_ROOT'];
    $root .= "/connect/config.php";
    include($root);

    @$db = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

    $action   = mysqli_real_escape_string($db, $_GET['action']);
    $code     = mysqli_real_escape_string($db, $_GET['code']);

    if($action == "delete" AND $code == "geheim"){
        if($db == true){

            ////Variabeln
            $tag       = date("d");
            $monat     = date("m");
            $jahr      = date("Y");
            $timenow   = mktime(0,0,0,$monat,$tag,$jahr);
            $gestern   = strtotime("-1 day");
            $alter_tag = date("d.m.Y",$gestern);
            $ip        = $_SERVER['HTTP_X_FORWARDED_FOR'];

            /// MySQL Abfragen
            $counter_del = $db->query("SELECT * FROM `counter` WHERE `timed` < '" . $timenow . "' ORDER BY id DESC");
            $sownloader_web_downloads_today_query = $db->query("SELECT * FROM `sownloader_web_urls_today` WHERE `timed` < '" . $timenow . "' ORDER BY id DESC");

            /// Ergebnisse
            //Guests
            $total_day_guests = $counter_del->num_rows;
            $get_total_array  = $counter_del->fetch_array();
            $get_total        = $get_total_array['id'];
            $get_time         = $get_total_array['timed'];
            $datum_abfrage_db = date("d.m.Y",$get_time);

            //Sownloader Web
            $sownloader_web_downloads_today = $sownloader_web_downloads_today_query->num_rows;
            $sownloader_web_downloads_today_array = $sownloader_web_downloads_today_query->fetch_array();
            $sownloader_web_urls_today_time = $sownloader_web_downloads_today_array['timed'];
            $sownloader_web_urls_today_datum_abfrage_db = date("d.m.Y",$sownloader_web_urls_today_time);

            if($total_day_guests > 0)
            {
                $db->query("INSERT INTO `counter_stats` (`date`,`guests`,`total`) VALUES ('$alter_tag', '$total_day_guests', '$get_total')");
                $db->query("DELETE FROM `counter` WHERE timed < '$timenow'");
                echo "Guests database was successfully updated.";
            }
            else
            {
                echo"No entries in guests database!";
            }

            if($sownloader_web_downloads_today > 0)
            {
                $db->query("INSERT INTO `sownloader_web_urls_stats` (`date`,`downloads`) VALUES ('$alter_tag', '$sownloader_web_downloads_today')");
                $db->query("DELETE FROM `sownloader_web_urls_today` WHERE timed < '$timenow'");
                echo "Sownloader Web databases were successfully updated.";
            }
            else
            {
                echo "No entries in sownloader_web_urls_today database!";
            }
            mysqli_close($db);
        }
        else{
            echo "Connection failed!";
        }

    }
    elseif($action == "test"){
        ////Variabeln
        $tag       = date("d");
        $monat     = date("m");
        $jahr      = date("Y");
        $timenow   = mktime(0,0,0,$monat,$tag,$jahr);
        $gestern   = strtotime("-1 day");
        $alter_tag = date("d.m.Y",$gestern);
        $ip        = $_SERVER['HTTP_X_FORWARDED_FOR'];

        /// MySQL Abfragen
        $counter_del = $db->query("SELECT * FROM `counter` WHERE `timed` < '" . $timenow . "'");

        /// Ergebnisse
        $total_day_guests = $counter_del->num_rows;
        $get_total_array  = $counter_del->fetch_array();

        $get_total        = $get_total_array['id'];
        $get_time         = $get_total_array['timed'];
        $datum_abfrage_db = date("d.m.Y",$get_time);

        echo"Variabeln:<br />Tag: " . $tag . "<br />Monat: " . $monat . "<br />Jahr: " . $jahr . "<br />Timenow: " . $timenow . "<br />Gestern: " . $gestern . "<br />Alter Tag: " . $alter_tag . "<br >IP: " . $ip . "<br />Total: " . $total_day_guests . "<br />Datum Abfrage DB: " . $datum_abfrage_db . "<br />";

        while($row = $counter_del->fetch_array()){
            echo $row['id'] . " - " . round($row['ip'], 4) . " - " . $row['browser'] . " - " . $row['woher'] . " - " . $row['ort'] . " - " . $row['timed'] . "<br />";
        }

    }

?>