| Server IP : 109.234.164.53 / Your IP : 216.73.216.110 Web Server : Apache System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64 User : computer3 ( 1098) PHP Version : 7.1.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/computer3/lavignotte.com/includes/ |
Upload File : |
<?php
require_once('config.php');
require_once('class/ipapi.class.php');
// Configuration du format de la date
$time=time();
$day=date("Ymd",$time); // DD.MM.YYYY
$dateee = date("Y-m-d");
// Récupération de l'adresse IP du visiteur
$ip=$_SERVER['REMOTE_ADDR'];
// Récupération de la source et de la page vu
if ($_GET["ref"] <> "" )
{
// depuis javascript
$referer = $_GET["ref"];
$page = parse_url($_SERVER['HTTP_REFERER'], PHP_URL_PATH);
}
else
{
// depuis php
$referer=$_SERVER['HTTP_REFERER'];
$page=$_SERVER['PHP_SELF']; // with include via php
}
// Nettoyage
if (basename($page) == basename(__FILE__)) $page="" ; // count not stats.php
$server_host=$_SERVER["HTTP_HOST"]; // Server Host
if (substr($server_host,0,4) == "www.") $server_host=substr($server_host,4); // Server Host without www.
$referer = substr($referer, 1, -1);
$referer_host=parse_url($referer, PHP_URL_HOST); // Referrer Host
if (substr($referer_host,0,4) == "www.") $referer_host=substr($referer_host,4); // Referer Host without www.
// adjust search engines
if (strstr($referer_host, "google."))
{
$referer_query=parse_url($referer, PHP_URL_QUERY);
$referer_query.="&";
preg_match('/q=(.*)&/UiS', $referer_query, $keys);
$keyword=urldecode($keys[1]); // These are the search terms
$referer_host="Google"; // adjust host
}
if (strstr($referer_host, "yahoo."))
{
$referer_query=parse_url($referer, PHP_URL_QUERY);
$referer_query.="&";
preg_match('/p=(.*)&/UiS', $referer_query, $keys);
$keyword=urldecode($keys[1]); // These are the search terms
$referer_host="Yahoo"; // adjust host
}
if (strstr($referer_host, "bing."))
{
$referer_query=parse_url($referer, PHP_URL_QUERY);
$referer_query.="&";
preg_match('/q=(.*)&/UiS', $referer_query, $keys);
$keyword=urldecode($keys[1]); // These are the search terms
$referer_host="Bing"; // adjust host
}
if ($referer_host ==""){
$referer_host="Direct";
}
// Language
$language = substr($_SERVER['HTTP_ACCEPT_LANGUAGE'],0,2);
//
// Counter
//
// delete old IPs
// $anfangGestern = mktime(0, 0, 0, date(n), date(j), date(Y)) - 48*60*60 ; // 48*60*60 => after 48 hours
// $delete=$GLOBALS['bdd']->exec("delete from stats_IPs where time<'$anfangGestern'");
// if (!$delete) {echo"Es ist ein Fehler aufgetreten, möglicherweise ist die Tabelle nicht angelegt."; exit;}
// // delete old page,referrer,language and keywords
// $old_day=date("d.m.Y",mktime(0, 0, 0,date("j")-$oldentries, date("n"), date("Y"))); // delete older than $oldentries(config.php) days
// $delete=$GLOBALS['bdd']->exec("delete from stats_Page where day<='$old_day'");
// $delete=$GLOBALS['bdd']->exec("delete from stats_Referer where day<='$old_day'");
// $delete=$GLOBALS['bdd']->exec("delete from stats_Keyword where day<='$old_day'");
// $delete=$GLOBALS['bdd']->exec("delete from stats_Language where day<='$old_day'");
// if (!$delete) {echo"Es ist ein Fehler aufgetreten, möglicherweise ist die Tabelle nicht angelegt."; exit;}
// insert a new day
$neuerTag=$GLOBALS['bdd']->query("SELECT id from stats_Day where day='$day'");
$neuerTag=$neuerTag->fetchAll();
if (count($neuerTag)==0)
{
$GLOBALS['bdd']->exec("INSERT into stats_Day (day, user, view) values ('$day', '0', '0')");
}
// check reload and set online time
$newuser=0;
$oldreload = $time-$reload;
$gesperrt=$GLOBALS['bdd']->query("SELECT id from stats_IPs where ip='$ip' AND time>'$oldreload' order by id desc limit 1");
$gesperrt=$gesperrt->fetchAll();
if (count($gesperrt)==0)
{
// new visitor
$newuser=1;
$city = IPAPI::query($_SERVER['REMOTE_ADDR'])->city;
$country = IPAPI::query($_SERVER['REMOTE_ADDR'])->countryCode;
$GLOBALS['bdd']->exec("INSERT into stats_IPs (ip, time, online, city, country, dayip, wiewip) values ('$ip', '$time', '$time', '$city', '$country', '$dateee', '1')");
$GLOBALS['bdd']->exec("UPDATE stats_Day set user=user+1, view=view+1 where day='$day'");
}
else
{
// reload visitor
$gesperrtID=$gesperrt[0];
$GLOBALS['bdd']->exec("UPDATE stats_IPs set online='$time' where ip='$ip' AND dayip='$dateee'");
$GLOBALS['bdd']->exec("UPDATE stats_Day set view=view+1 where day='$day'");
$GLOBALS['bdd']->exec("UPDATE stats_IPs set wiewip=wiewip+1 where ip='$ip' AND dayip='$dateee'");
}
////////////////////////////////////////////////////////////////
// Page
if($page <> "") {
$ergebnis = $GLOBALS['bdd']->query("SELECT id from stats_Page WHERE page='$page' AND day='$day'");
$ergebnis = $ergebnis->fetchAll();
if (count($ergebnis)==0)
{
$GLOBALS['bdd']->exec("INSERT into stats_Page (day, page, view) values ('$day', '$page', '1')");
}
else
{
$pageid=$ergebnis[0];
$GLOBALS['bdd']->exec("UPDATE stats_Page set view=view+1 where page='$page' AND day='$day'");
$hrr = date("H:i");
$requete = $GLOBALS['bdd']->query("SELECT id from stats_div WHERE page='$page' AND dat='$dateee' AND hr='$hrr' AND ip='$ip'");
$requete = $requete->fetchAll();
if (count($requete)==0)
{
$GLOBALS['bdd']->exec("INSERT into stats_div (ip, page, dat, hr) values ('$ip', '$page', '$dateee', '$hrr')");
}
}
}
///////////////////////////////////////////////////////////////
// Referer
if(stristr($server_host, $referer_host) === FALSE AND $referer_host<>"" AND $newuser == 1) {
$ergebnis = $GLOBALS['bdd']->query("SELECT id from stats_Referer WHERE referer='$referer_host' AND day='$day'");
$ergebnis = $ergebnis->fetchAll();
if (count($ergebnis)==0)
{
$GLOBALS['bdd']->exec("INSERT into stats_Referer (day, referer, view) values ('$day', '$referer_host', '1')");
}
else
{
$refererid=$ergebnis[0];
$GLOBALS['bdd']->exec("UPDATE stats_Referer set view=view+1 where day='$day' AND referer='$referer_host'");
}
}
////////////////////////////////////////////////////////////////
// keywords
if($keyword<>"" AND $newuser == 1) {
$ergebnis = $GLOBALS['bdd']->query("SELECT id from stats_Keyword WHERE keyword='$keyword' AND day='$day'");
$ergebnis = $ergebnis->fetchAll();
if (count($ergebnis)==0)
{
$GLOBALS['bdd']->exec("INSERT into stats_Keyword (day, keyword, view) values ('$day', '$keyword', '1')");
}
else
{
$keywordid=$ergebnis[0];
$GLOBALS['bdd']->exec("UPDATE stats_Keyword set view=view+1 where id='$keywordid'");
}
}
// Language
if($language<>"" AND $newuser == 1) {
$ergebnis = $GLOBALS['bdd']->query("SELECT id from stats_Language WHERE language='$language'");
$ergebnis = $ergebnis->fetchAll();
if (count($ergebnis)==0)
{
$GLOBALS['bdd']->exec("INSERT into stats_Language (day, language, view) values ('$day', '$language', '1')");
}
else
{
$languageid=$ergebnis[0];
$GLOBALS['bdd']->exec("UPDATE stats_Language set view=view+1 where id='$languageid'");
}
}
?>