| 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/cp-admin/ |
Upload File : |
<?PHP
include_once('includes/header.php');
$id_volet ="53";
include('includes/volet.php');
/****************************/
?>
<div class="container">
<div class="row">
<div class="span12">
<div class="page-header">
<h1>
Statistique - Visiteurs
</h1>
</div>
</div>
</div>
<div class="row">
<div class="middle">
<h3>Top 10 Sources</h3>
<table width="100%" border="0" cellpadding="5" cellspacing="0">
<tr>
<td width="30"><strong>N°</strong></td>
<td width="280"><strong>Source</strong></td>
<td width="120"><strong>Pourcentage</strong></td>
</tr>
<?PHP
// gesammt Referrer
$abfrage=$bdd->query("SELECT sum(view) as sumViews from stats_referer");
$result = $abfrage->fetch();
$ges_referer=$result['sumViews'];
// Top Refferrer
$nr = 1;
$abfrage=$bdd->query("SELECT referer, SUM(view) AS views from stats_referer GROUP BY referer ORDER BY views DESC LIMIT 0, 10");
while($row=$abfrage->fetch())
{
$referer=htmlspecialchars($row['referer']);
if(strlen($referer) > 35){$shortreferer=substr($referer,0,30)."<a href=\"#\" title=\"$referer\">...</a>";}
else {$shortreferer=$referer;}
$views=$row['views'];
$prozent = (100/$ges_referer)*$views;
if ($prozent < 0.1 ) $prozent = round($prozent,2);
else $prozent = round($prozent,1);
$bar_width = round((100/$ges_referer)*$views);
echo" <tr>\n";
echo" <td>$nr</td>\n";
echo" <td>$shortreferer</td>\n";
echo" <td nowrap><div class=\"vbar\" style=\"width:".$bar_width."px;\" title=\"$views Visiteur(s)\" > $prozent%</div></td>\n";
echo" </tr>\n";
$nr++;
}
?>
</table>
</div>
<div class="middle">
<h3>Top 10 Pages</h3>
<table width="100%" cellpadding="5" cellspacing="0">
<tr>
<td width="30"><strong>N°</strong></td>
<td width="280"><strong>Page</strong></td>
<td width="120"><strong>Pourcentage</strong></td>
</tr>
<?PHP
// gesammt Pages
$abfrage=$bdd->query("SELECT sum(view) as sumViews from stats_page");
$result = $abfrage->fetch();
$ges_page=$result['sumViews'];
// Top Pages
$nr = 1;
$abfrage=$bdd->query("SELECT page, SUM(view) AS views from stats_page GROUP BY page ORDER BY views DESC LIMIT 0, 10");
while($row=$abfrage->fetch())
{
$page=htmlspecialchars($row['page']);
if(strlen($page) > 35){$shortpage="<a href=\"#\" title=\"$page\">...</a>".substr($page,strlen($page)-30,strlen($page)); }
else {$shortpage=$page;}
$views=$row['views'];
$prozent = (100/$ges_page)*$views;
if ($prozent < 0.1 ) $prozent = round($prozent,2);
else $prozent = round($prozent,1);
$bar_width = round((100/$ges_page)*$views);
echo" <tr>\n";
echo" <td>$nr</td>\n";
echo" <td>$shortpage</td>\n";
echo" <td nowrap><div class=\"vbar\" style=\"width:".$bar_width."px;\" title=\"$views Visite(s)\" > $prozent%</div></td>\n";
echo" </tr>\n";
$nr++;
}
?>
</table>
</div>
<div style="clear:both"></div>
<div class="middle">
<h3>Top 10 Mot Clés</h3>
<table width="100%" border="0" cellpadding="5" cellspacing="0">
<tr>
<td width="30"><strong>N°</strong></td>
<td width="280"><strong>Mot Clé</strong></td>
<td width="120"><strong>Pourcentage</strong></td>
</tr>
<?PHP
// gesammt keywords
$abfrage=$bdd->query("SELECT sum(view) as sumViews from stats_keyword");
$result = $abfrage->fetch();
$ges_keyword=$result['sumViews'];
// Top Keywords
$nr = 1;
$abfrage=$bdd->query("SELECT keyword, SUM(view) AS views from stats_keyword GROUP BY keyword ORDER BY views DESC LIMIT 0, 10");
while($row=$abfrage->fetch())
{
$keyword=urldecode($row['keyword']);
if(strlen($keyword) > 35){$shortkeyword=substr($keyword,0,30)."<a href=\"#\" title=\"$keyword\">...</a>";}
else {$shortkeyword=$keyword;}
$views=$row['views'];
$prozent = (100/$ges_keyword)*$views;
if ($prozent < 0.1 ) $prozent = round($prozent,2);
else $prozent = round($prozent,1);
$bar_width = round((100/$ges_keyword)*$views);
echo" <tr>\n";
echo" <td>$nr</td>\n";
echo" <td>$shortkeyword</td>\n";
echo" <td nowrap><div class=\"vbar\" style=\"width:".$bar_width."px;\" title=\"$views Visiteur(s)\" > $prozent%</div></td>\n";
echo" </tr>\n";
$nr++;
}
?>
</table>
</div>
<!--
<div class="middle">
<h3>Top 10 Languages</h3>
<table width="100%" border="0" cellpadding="5" cellspacing="0">
<tr>
<td width="30"><strong>N°</strong></td>
<td width="280"><strong>Language</strong></td>
<td width="120"><strong>Pourcentage</strong></td>
</tr>
<?PHP
// gesammt Languages
$abfrage=$bdd->query("SELECT sum(view) as sumViews from stats_language");
$result = $abfrage->fetch();
$ges_language=$result['sumViews'];
// Code to Language
$code2lang = array(
'ar'=>'Arabe',
'bn'=>'Bengali',
'bg'=>'Bulgare',
'zh'=>'Chinois',
'cs'=>'Tchèque',
'da'=>'Danois',
'en'=>'Anglais',
'et'=>'Estonien',
'fi'=>'Finlandais',
'fr'=>'Français',
'de'=>'Allemand',
'el'=>'Grecque',
'hi'=>'Indien',
'id'=>'Indonésien',
'it'=>'Italien',
'ja'=>'Japonais',
'kg'=>'Coréen',
'nb'=>'Norvègien',
'nl'=>'NĂ©erlandais',
'pl'=>'Polonais',
'pt'=>'Portuguais',
'ro'=>'Roumain',
'ru'=>'Russe',
'sr'=>'Serbe',
'sk'=>'Slovaque',
'es'=>'Espagnole',
'sv'=>'Suédois',
'th'=>'Thailandais',
'tr'=>'Turque',
''=>'');
// Top Languages
$nr = 1;
$abfrage=$bdd->query("SELECT language, SUM(view) AS views from stats_language GROUP BY language ORDER BY views DESC LIMIT 0, 10");
while($row=$abfrage->fetch())
{
$language=$row['language'];
if (array_key_exists($language,$code2lang)) $language=$code2lang[$language];
$views=$row['views'];
$prozent = (100/$ges_language)*$views;
if ($prozent < 0.1 ) $prozent = round($prozent,2);
else $prozent = round($prozent,1);
$bar_width = round((100/$ges_language)*$views);
echo" <tr>\n";
echo" <td>$nr</td>\n";
echo" <td>$language</td>\n";
echo" <td nowrap><div class=\"vbar\" style=\"width:".$bar_width."px;\" title=\"$views Visiteur(s)\" > $prozent%</div></td>\n";
echo" </tr>\n";
$nr++;
}
?>
</table>
</div>
<div style="clear:both"></div>
-->
<div class="middle">
<h3>Top 10 Villes</h3>
<table width="100%" border="0" cellpadding="5" cellspacing="0">
<tr>
<td width="30"><strong>N°</strong></td>
<td width="280"><strong>Ville</strong></td>
<td width="120"><strong>Pourcentage</strong></td>
</tr>
<?PHP
// gesammt Referrer
$abfrage=$bdd->query("SELECT COUNT(*) as num from stats_ips");
$result = $abfrage->fetch();
$nbIps=$result['num'];
// Top Refferrer
$nr = 1;
$abfrage=$bdd->query("SELECT COUNT(*) AS cities, city, country FROM stats_ips GROUP BY city ORDER BY cities DESC LIMIT 0 , 10");
while($row=$abfrage->fetch())
{
$country=htmlspecialchars($row['country']);
$city=htmlspecialchars($row['city']);
if(strlen($city) > 35) {
$shortcity=substr($referer,0,30)."<a href=\"#\" title=\"$referer\">...</a>";
} else {
$shortcity=$city;
}
$cities=$row['cities'];
$prozent = (100/$nbIps)*$cities;
if ($prozent < 0.1 )
$prozent = round($prozent,2);
else
$prozent = round($prozent,1);
$bar_width = round((100/$nbIps)*$cities);
echo" <tr>\n";
echo" <td>$nr</td>\n";
if($country == 'FR')
{
echo"<td>$shortcity</td>\n";
}
else
{
echo"<td>$shortcity ($country)</td>\n";
}
echo" <td nowrap><div class=\"vbar\" style=\"width:".$bar_width."px;\" title=\"$cities Visiteur(s)\" > $prozent%</div></td>\n";
echo" </tr>\n";
$nr++;
}
?>
</table>
</div>
</div>
</div>
<?php
include_once('includes/footer.php');
?>