| 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/litsolide.com/ODLDDD_2/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
// 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
}
// Language
$language = substr($_SERVER['HTTP_ACCEPT_LANGUAGE'],0,2);
//
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
//
// insert a new day nouveau jour
$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 day='$day' 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, day) values ('$ip', '$time', '$time', '$city', '$country', '$day')");
$GLOBALS['bdd']->exec("UPDATE stats_day set user=user+1, view=view+1 where day='$day'");
}
else
{
// reload visitor
$time_reload = time();
$gesperrtID=$gesperrt[0];
$GLOBALS['bdd']->exec("UPDATE stats_ips set online='$time_reload' where ip='$ip' and day='$day'");
$GLOBALS['bdd']->exec("UPDATE stats_day set view=view+1 where day='$day'");
}
//
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
//
// 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 id='$pageid'");
}
}
// 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 id='$refererid'");
}
}
// 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'");
}
}
?>