if ($_SERVER["HTTP_HOST"] != "demo.clubsandwich.com") {
Header("Location: http://www.clubsandwich.com/refonte1.htm");
}
if (!isset($GLOBALS["dbname"])) {
if (!$PHPSESSID) session_start; else session_start($PHPSESSID);
include ("=Admin=/_host.inc");
include ($GLOBALS["root_directory"]."/=Admin=/admin_function.inc");
include ($GLOBALS["root_directory"]."/=Admin=/_fonctions.inc");
include ($GLOBALS["root_directory"]."/=Admin=/class_links_links.inc");
include ($GLOBALS["root_directory"]."/=Admin=/class_links_categories.inc");
$debug = "";
$zetarget = "_blank"; # _top ou _blank
# Valeurs par défaut
if (!isset($page)) $page=1;
if (!isset($rub)) $rub=1;
$categories = new links_categories();
$categories->get_db($rub);
# On vérifie les paramètres, ˆ tout hasard
if ($categories->id == -1) {
$rub = 1;
$categories->get_db($rub);
$page = 1;
}
# Les constantes
$percolumn = 17 ; # 17 liens
$nbcolumn = 3 ; # sur 3 colonnes
$linksresults = $percolumn * $nbcolumn;
$maxipages = 17; # Le nombre maximum de pages pour la barre de nav
$current_color_page = sprintf("fond_%02d.gif", $current_page);
$sql = "SELECT l.id, l.title
FROM links_links as l,
links_categories as c
WHERE actif = 'Y'
AND l.cid = c.id
AND ( ((c.id = '". $rub ."') and (c.sid = 0))
OR ((c.sid = '". $rub ."'))
)
ORDER BY c.sid, l.title ";
$result = mysql_db_query($GLOBALS["dbname"], $sql );
$nrows = mysql_num_rows($result);
$nbpages = ( $nrows / $linksresults) ;
# Vérification du nombre de page...
if ($page > ($nbpages +1)) $page = 1;
$min = ($page * $linksresults) - $linksresults ;
if (!isset($min)) $min=0;
if (!isset($max)) $max=$min+$linksresults;
$current_page = $page ;
$cp = sprintf("%02d", ((($current_page -1) % 6) +1) );
$icono = "/Img_Links/Icono/". sprintf("%02d.gif", $rub) ;
$resultbonus = mysql_db_query($GLOBALS["dbname"], $sql . " LIMIT ". (($min + ($percolumn * 3))-$linksresults) .", ". $linksresults);
$bonus_keywords = "";
while ($r= mysql_fetch_array($resultbonus)) {
$bonus_keywords.= ", ". $r["title"] ;
}
// print "WORK IN PROGRESS : ". $bonus_keywords ."
";
}
?>