DATE_SUB(NOW(), INTERVAL $duree SECOND) AND type='article' GROUP BY id_objet"; $res = spip_query($query); while ($row = @spip_fetch_array($res)) { $count_article[$row['count']] .= ','.$row['id_objet']; // l'objet a count visites } foreach($count_article as $count => $articles) { $query = "UPDATE spip_articles SET maj=maj, 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 = @spip_fetch_array($res)) { $count_article[$row['count']] .= ','.$row['id_objet']; // l'objet a count referers } foreach($count_article as $count => $articles) { $query = "UPDATE spip_articles SET maj=maj, popularite = GREATEST(1,popularite) + $b * $count WHERE id_article IN (0$articles)"; spip_query($query); } // et enregistrer les metas... list($maxpop, $totalpop) = spip_fetch_array(spip_query("SELECT MAX(popularite), SUM(popularite) FROM spip_articles")); ecrire_meta("popularite_max", $maxpop); ecrire_meta("popularite_total", $totalpop); ecrire_metas(); } ?>