$notvalidxhtml = false;
$date_update_page = "27-05-2012";
$titre = "Top des sites visités sur ROFFET.com/go ces derniers mois";
$dirroot = "../../";
$linkup = "../";
$nav_section="go";
include "../../rc04/php/rc04-page.php";
rc04_top();
// constantes:
$taillelim = 120;
$npp = 30;
// variables
$offset = $_GET["offset"];
if ($offset=="")
$offset=0;
include("../mysql_func.php");
?>
Top des sites les plus visités ces derniers mois :
if ($gdblk=gconnect())
{
// Compute day, month, year, hour and min.
$today = getdate();
$day = $today["mday"];
if ($day < 10) {
$day = "0$day";
}
if (($day==31) || ($day==30) || ($day==29)) {
$day = 28;
}
$year = $today["year"];
$month = ($today["mon"]-8);
if ($month<=0) {
$month = $month + 12;
$year--;
}
if ($month < 10) {
$month = "0$month";
}
$dateCible = $year."-".$month."-".$day." 01:01:01";
$result=gsend_sql($MySQL_gTableName,"SELECT url, COUNT(*) as c FROM goto WHERE date>'".$dateCible."' GROUP BY url ORDER BY c DESC LIMIT ".$offset.", ".$npp."");
//LAST: $result=gsend_sql($MySQL_gTableName,"SELECT url, date as mydate FROM goto ORDER BY mydate DESC LIMIT ".$offset.", ".$npp."");
echo "\n
\n";
$i=0;
// un à un tous les mots du sens donné dans la langue donnée.
while ($row=mysql_fetch_array($result,MYSQL_ASSOC))
{
$i++;
$tpp="";
if (strlen($row["url"])>$taillelim)
$tpp="...";
echo "\n";
echo "\t| ".($offset + $i)." | \n";
echo "\t".substr($row["url"],0,$taillelim).$tpp." | \n";
echo "\t".$row["c"]." | \n";
//LAST: echo "".$row["mydate"]." | ";
echo "
";
}
echo "\n
";
}
else
{
echo "Liste non-disponible";
}
if (($offset-$npp)>=0) {
echo "
";
?>
Précédente
}
echo "
";
?>
Suivante
rc04_end();