<?
$url=$_GET['url'];
mysql_connect ("localhost","legag","rooperyp");
mysql_select_db ("legag");

echo $url . "</p>";

if(substr($url, -1) == '/') {
    $url = substr($url, 0, -1);
    }
    
echo $url;

// Stockage du hit
if($url) {
$SQL = "SELECT * FROM hits WHERE url='$url'";
$result = mysql_query($SQL);
if(!$val = mysql_fetch_array($result)) {
echo "document.write(\"$SQL\")";
echo "document.write(\"$val\")";
 
// Si param url n'existe pas
$result2 = mysql_query("INSERT INTO hits(url,url_hits) values('$url',1)");
$result2 = 1;
$url_hits = 1;
} elseif($store=="") {

// Sinon si pas en lecture seule
$result2 = mysql_query("UPDATE hits set url_hits=url_hits+1 WHERE url='$url'");
$url_hits = $val["url_hits"]+1;
} else $url_hits = $val["url_hits"];

// Mise à jour éventuelle du groupe
if($gpe) $result2 = mysql_query("UPDATE hits set groupe='$gpe' WHERE url='$url'");
}

// Retour JavaScript
switch($aff) {
case "1" : $JVS = $url_hits; break;
case "2" :
if($gpe) {
$SQL = "SELECT sum(url_hits) FROM hits WHERE groupe='$gpe'";
$result = mysql_query($SQL);
if($val = mysql_fetch_array($result)) $JVS=$val[0];
}
}
if($JVS) echo "document.write(\"$JVS\")";
// Déconnnexion
mysql_close();
?>