3 /***************************************************************************\
4 * SPIP, Systeme de publication pour l'internet *
6 * Copyright (c) 2001-2014 *
7 * Arnaud Martin, Antoine Pitrou, Philippe Riviere, Emmanuel Saint-James *
9 * Ce programme est un logiciel libre distribue sous licence GNU/GPL. *
10 * Pour plus de details voir le fichier COPYING.txt ou l'aide en ligne. *
11 \***************************************************************************/
14 if (!defined('_ECRIRE_INC_VERSION')) return;
16 include_spip('inc/statistiques');
17 // moyenne glissante sur 30 jours
18 define('MOYENNE_GLISSANTE_JOUR', 30);
19 // moyenne glissante sur 12 mois
20 define('MOYENNE_GLISSANTE_MOIS', 12);
21 include_spip('inc/referenceurs');
23 function inc_stats_referers_to_array_dist($limit, $jour, $id_article, $options = array()) {
26 $table = "spip_referers";
30 if (in_array($jour,array('jour','veille'))){
32 $where[] = "$visites>0";
34 //$res = $referenceurs (0, "SUM(visites_$jour)", 'spip_referers', "visites_$jour>0", "referer", $limit);
37 $table = "spip_referers_articles";
38 $where[] = "id_article=".intval($id_article);
41 $where = implode(" AND ",$where);
42 $limit = $limit?
"0,".intval($limit):'';
44 $result = sql_select("referer_md5, referer, $visites AS vis", $table, $where, '', "maj DESC", $limit,'',$serveur);
47 $trivisites = array(); // pour le tri
48 while ($row = sql_fetch($result,$serveur)) {
49 $referer = interdire_scripts($row['referer']);
50 $buff = stats_show_keywords($referer, $referer);
53 $refhost = $buff["hostname"];
54 $visites = $row['vis'];
55 $host = $buff["scheme"]."://".$buff["host"];
57 $referers[$refhost]['referer_md5'] = $row['referer_md5'];
59 if (!isset($referers[$refhost]['liens'][$referer]))
60 $referers[$refhost]['liens'][$referer] = 0;
61 if (!isset($referers[$refhost]['hosts'][$host]))
62 $referers[$refhost]['hosts'][$host] = 0;
64 if (!isset($referers[$refhost]['visites']))
65 $referers[$refhost]['visites'] = 0;
66 if (!isset($referers[$refhost]['visites_racine']))
67 $referers[$refhost]['visites_racine'] = 0;
68 if (!isset($referers[$refhost]['referers']))
69 $referers[$refhost]['referers'] = array();
71 $referers[$refhost]['hosts'][$host]++
;
72 $referers[$refhost]['liens'][$referer]++
;
73 $referers[$refhost]['visites'] +
= $visites;
74 $trivisites[$refhost] = $referers[$refhost]['visites'];
80 'referes'=>$id_article?
'':referes($row['referer_md5'])
82 if (isset($buff["keywords"])
83 AND $c = $buff["keywords"]) {
84 if (!isset($referers[$refhost]['keywords'][$c])) {
85 $referers[$refhost]['keywords'][$c] = true;
86 $set['keywords'] = $c;
92 $tmp .= "?".$buff['query'];
94 $set['path'] = "/$tmp";
96 if (isset($set['path']) OR isset($set['keywords']))
97 $referers[$refhost]['referers'][] = $set;
99 $referers[$refhost]['visites_racine'] +
= $visites;
103 // trier les liens pour trouver le principal
104 foreach($referers as $k=>$r){
105 arsort($referers[$k]['liens']);
106 $referers[$k]['liens'] = array_keys($referers[$k]['liens']);
107 arsort($referers[$k]['hosts']);
108 $referers[$k]['hosts'] = array_keys($referers[$k]['hosts']);
109 $referers[$k]['url'] = reset($referers[$k]['hosts']);
112 if (count($trivisites)){
113 array_multisort($trivisites, SORT_DESC
,$referers);