50) $nom_url = substr($nom_url, 0, 48) . "...";
$buffer = " ".$nom_url."\n";
if ($keywords != '')
{
$buffer .= "(" .trim(htmlspecialchars(stripslashes($keywords))).")\n";
}
return( $buffer );
}
//
// Compiler les statistiques temporaires : visites et referers (si active)
//
function calculer_referers($date) {
// Referers sur tout le site
$query = "SELECT COUNT(DISTINCT ip) AS visites, referer, HEX(referer_md5) AS md5 ".
"FROM spip_referers_temp GROUP BY referer_md5";
$result = spip_query($query);
$referer_insert = "";
$referer_update = "";
while ($row = @mysql_fetch_array($result)) {
$visites = $row['visites'];
$referer = addslashes($row['referer']);
$referer_md5 = '0x'.$row['md5'];
$referer_update[$visites][] = $referer_md5;
$referer_insert[] = "('$date', '$referer', $referer_md5, $visites)";
}
// Mise a jour de la base
if (is_array($referer_update)) {
while (list($visites, $referers) = each($referer_update)) {
$query = "UPDATE spip_referers SET visites = visites + $visites ".
"WHERE referer_md5 IN (".join(', ', $referers).")";
$result = spip_query($query);
}
}
if (is_array($referer_insert)) {
$query_insert = "INSERT DELAYED IGNORE INTO spip_referers ".
"(date, referer, referer_md5, visites) VALUES ".join(', ', $referer_insert);
$result_insert = spip_query($query_insert);
}
// Referers par article
$query = "SELECT COUNT(DISTINCT ip) AS visites, id_objet, referer, HEX(referer_md5) AS md5 ".
"FROM spip_referers_temp WHERE type='article' GROUP BY id_objet, referer_md5";
$result = spip_query($query);
$referer_insert = "";
$referer_update = "";
while ($row = @mysql_fetch_array($result)) {
$id_article = $row['id_objet'];
$visites = $row['visites'];
$referer = addslashes($row['referer']);
$referer_md5 = '0x'.$row['md5'];
$referer_update[$visites][] = "(id_article=$id_article AND referer_md5=$referer_md5)";
$referer_insert[] = "('$date', '$referer', $referer_md5, $id_article, $visites)";
}
// Mise a jour de la base
if (is_array($referer_update)) {
while (list($visites, $where) = each($referer_update)) {
$query = "UPDATE spip_referers_articles SET visites = visites + $visites ".
"WHERE ".join(' OR ', $where);
$result = spip_query($query);
}
}
if (is_array($referer_insert)) {
$query_insert = "INSERT DELAYED IGNORE INTO spip_referers_articles ".
"(date, referer, referer_md5, id_article, visites) VALUES ".join(', ', $referer_insert);
$result_insert = spip_query($query_insert);
}
$query_effacer = "DELETE FROM spip_referers_temp";
$result_effacer = spip_query($query_effacer);
}
function calculer_visites($date = "") {
// calculer les popularites avant d'effacer les donnees
calculer_popularites();
// Date par defaut = hier
if (!$date) $date = date("Y-m-d", time() - 24 * 3600);
// Sur tout le site, nombre de visiteurs uniques pendant la journee
$query = "SELECT COUNT(DISTINCT ip) AS total_visites FROM spip_visites_temp";
$result = spip_query($query);
if ($row = @mysql_fetch_array($result))
$total_visites = $row['total_visites'];
else
$total_visites = 0;
$query_insert = "INSERT INTO spip_visites (date, visites) VALUES ('$date', $total_visites)";
$result_insert = spip_query($query_insert);
// Nombre de visiteurs uniques par article
$query = "SELECT COUNT(DISTINCT ip) AS visites, id_objet FROM spip_visites_temp ".
"WHERE type='article' GROUP BY id_objet";
$result = spip_query($query);
$visites_insert = "";
$visites_update = "";
while ($row = @mysql_fetch_array($result)) {
$id_article = $row['id_objet'];
$visites = $row['visites'];
$visites_update[$visites][] = $id_article;
$visites_insert[] = "('$date', $id_article, $visites)";
}
$query_effacer = "DELETE FROM spip_visites_temp";
$result_effacer = spip_query($query_effacer);
// Mise a jour de la base
if (is_array($visites_insert)) {
$query_insert = "INSERT DELAYED IGNORE INTO spip_visites_articles (date, id_article, visites) ".
"VALUES ".join(', ', $visites_insert);
$result_insert = spip_query($query_insert);
}
if (is_array($visites_update)) {
while (list($visites, $articles) = each($visites_update)) {
$query = "UPDATE spip_articles SET visites = visites + $visites ".
"WHERE id_article IN (".join(', ', $articles).")";
$result = spip_query($query);
}
}
if (lire_meta('activer_statistiques_ref') != 'non') {
calculer_referers($date);
}
}
//
// Optimiser les informations liees aux referers
//
function supprimer_referers($type = "") {
$table = 'spip_referers';
if ($type) {
$table .= '_'. $type . 's';
$col_id = 'id_' . $type;
$query = "SELECT COUNT(DISTINCT $col_id) AS count FROM $table";
$result = spip_query($query);
if ($row = @mysql_fetch_array($result)) {
$count = $row['count'];
}
}
if (!$count) $count = 1;
$query = "SELECT visites FROM $table ".
"ORDER BY visites LIMIT ".intval($count * 100).",1";
$result = spip_query($query);
$visites_min = 1;
if ($row = @mysql_fetch_array($result)) {
$visites_min = $row['visites'];
}
$query = "DELETE FROM $table WHERE (date < DATE_SUB(NOW(),INTERVAL 7 DAY) AND visites <= $visites_min) OR (date < DATE_SUB(NOW(),INTERVAL 30 DAY)";
$result = spip_query($query);
}
//
// Popularite, modele logarithmique
//
function calculer_popularites() {
$date = lire_meta('date_stats_popularite');
include_ecrire("inc_meta.php3");
ecrire_meta("date_stats_popularite", time());
ecrire_metas(); // il faut le marquer de suite pour eviter les acces concurrents
$duree = time() - $date;
// duree de demi-vie d'une visite dans le calcul de la popularite (en jours)
$demivie = 1;
// periode de reference en jours
$periode = 1;
// $a est le coefficient d'amortissement depuis la derniere mesure
$a = pow(2, - $duree / ($demivie * 24 * 3600));
// $b est la constante multiplicative permettant d'avoir
// une visite par jour (periode de reference) = un point de popularite
// (en regime stationnaire)
// or, magie des maths, ca vaut log(2) * duree journee/demi-vie
// si la demi-vie n'est pas trop proche de la seconde ;)
$b = log(2) * $periode / $demivie;
// oublier un peu le passe
spip_query("UPDATE spip_articles SET popularite = popularite * $a");
// ajouter les points visites
$count_article = Array();
$query = "SELECT COUNT(*) as count,id_objet FROM spip_visites_temp WHERE maj > DATE_SUB(NOW(), INTERVAL $duree SECOND) AND type='article' GROUP BY id_objet";
$res = spip_query($query);
while ($row = @mysql_fetch_array($res)) {
$count_article[$row['count']] .= ','.$row['id_objet']; // l'objet a count visites
}
reset ($count_article);
while (list($count,$articles) = each($count_article)) {
$query = "UPDATE spip_articles
SET popularite = GREATEST(1,popularite) + $b * $count
WHERE id_article IN (0$articles)";
spip_query($query);
}
// ajouter les points referers
$count_article = Array();
$query = "SELECT COUNT(*) as count,id_objet FROM spip_referers_temp WHERE maj > DATE_SUB(NOW(), INTERVAL $duree SECOND) AND type='article' GROUP BY id_objet";
$res = spip_query($query);
while ($row = @mysql_fetch_array($res)) {
$count_article[$row['count']] .= ','.$row['id_objet']; // l'objet a count referers
}
reset ($count_article);
while (list($count,$articles) = each($count_article)) {
$query = "UPDATE spip_articles
SET popularite = GREATEST(1,popularite) + $b * $count
WHERE id_article IN (0$articles)";
spip_query($query);
}
// et enregistrer les metas...
list($maxpop, $totalpop) = mysql_fetch_array(spip_query("SELECT MAX(popularite), SUM(popularite) FROM spip_articles"));
ecrire_meta("popularite_max", $maxpop);
ecrire_meta("popularite_total", $totalpop);
ecrire_metas();
}
?>