function ancien_rewrite_rub($id, $lang = 1) { $rub = new Rubrique(); $rub->charger($id); $chem = chemin_rub($id); if (!empty($chem)) { $rubriquedesc = new Rubriquedesc(); $listrub = ""; if (!$rubriquedesc->charger($chem[count($chem) - 1]->rubrique, $lang)) { return ""; } $listrub .= $rubriquedesc->titre . "_"; $rubriquedesc->charger($chem[0]->rubrique, $lang); $listrub .= $rubriquedesc->rubrique . "_"; for ($i = count($chem) - 2; $i >= 0; $i--) { $rubriquedesc->charger($chem[$i]->rubrique, $lang); $listrub .= $rubriquedesc->titre . "_"; } $listrub .= ".html"; return eregurl($listrub); } else { return ""; } }
function boucleRubrique($texte, $args) { global $id_rubrique; // récupération des arguments $id = lireTag($args, "id", "int_liste"); $parent = lireTag($args, "parent", "int_liste"); $courante = lireTag($args, "courante", "int"); $pasvide = lireTag($args, "pasvide", "int"); $ligne = lireTag($args, "ligne", "int"); $lien = lireTag($args, "lien", "string+\\/-\\s\\.\\,;"); $classement = lireTag($args, "classement", "string"); $aleatoire = lireTag($args, "aleatoire", "int"); $exclusion = lireTag($args, "exclusion", "int_liste"); $deb = lireTag($args, "deb", "int"); $num = lireTag($args, "num", "int"); $niveau = lireTag($args, "niveau", "int"); $res = ""; $search = ""; $limit = ""; if (!$deb) { $deb = 0; } $rubrique = new Rubrique(); $rubriquedesc = new Rubriquedesc(); // preparation de la requete if ($ligne == "") { $ligne = "1"; } $search .= " and {$rubrique->table}.ligne=\"{$ligne}\""; if ($id != "") { $search .= " and {$rubrique->table}.id in ({$id})"; } if ($parent != "") { $search .= " and {$rubrique->table}.parent in ({$parent})"; } if ($courante == "1") { $search .= " and {$rubrique->table}.id='{$id_rubrique}'"; } else { if ($courante == "0") { $search .= " and {$rubrique->table}.id!='{$id_rubrique}'"; } } if ($num != "") { $limit .= " limit {$deb},{$num}"; } if ($exclusion != "") { $search .= " and {$rubrique->table}.id not in({$exclusion})"; } if ($lien != "") { $search .= " and {$rubrique->table}.lien in ({$lien})"; } if ($niveau != "" && $parent != "") { if ($id_rubrique == "") { return ""; } $tab = chemin_rub($id_rubrique); $trouve = 0; for ($i = 0; $i < count($tab); $i++) { if ($parent == $tab[$i]->rubrique) { $trouve = 1; } } if (!$trouve) { return ""; } } if (ActionsLang::instance()->get_action_si_trad_absente() == ActionsLang::UTILISER_LANGUE_INDIQUEE) { // On retourne uniquement les rubriques traduites $search .= " and {$rubriquedesc->table}.id is not null"; } if ($aleatoire) { $order = "order by " . " RAND()"; } else { if ($classement == "alpha") { $order = "order by {$rubriquedesc->table}.titre"; } else { if ($classement == "alphainv") { $order = "order by {$rubriquedesc->table}.titre desc"; } else { if ($classement == "inverse") { $order = "order by {$rubrique->table}.classement desc"; } else { $order = "order by {$rubrique->table}.classement"; } } } } $query = "\n\t\t\tselect\n\t\t\t\t{$rubrique->table}.id\n\t\t\tfrom\n\t\t\t\t{$rubrique->table}\n\t\t\tleft join\n\t\t\t\t{$rubriquedesc->table} on ({$rubrique->table}.id={$rubriquedesc->table}.rubrique and {$rubriquedesc->table}.lang=" . ActionsLang::instance()->get_id_langue_courante() . ")\n\t\t\twhere\n\t\t\t\t1 {$search}\n\t\t\t{$order}\n\t\t\t{$limit}"; $resul = CacheBase::getCache()->query($query); $compt = 1; if (empty($resul)) { return ""; } else { $nbres = count($resul); } foreach ($resul as $row) { $rubrique = new Rubrique(); $rubrique->charger($row->id); $nbenfant = 0; if ($pasvide != "") { $rec = arbreBoucle($rubrique->id); $rec = rtrim($rec, ","); if ($rec) { $virg = ","; } else { $virg = ""; } $tmprod = new Produit(); $query4 = "select count(id) as nbres from {$tmprod->table} where rubrique in('" . $rubrique->id . "'{$virg}{$rec}) and ligne='1'"; $resul4 = CacheBase::getCache()->query($query4); if (!$resul4[0]->nbres) { continue; } } $rubriquedesc = new Rubriquedesc(); $rubriquedesc->charger($rubrique->id); $query3 = "select count(id) as nbres from {$rubrique->table} where 1 and parent=\"{$rubrique->id}\""; $resul3 = CacheBase::getCache()->query($query3); if ($resul3[0]->nbres) { $nbenfant = $resul3[0]->nbres; } else { $nbenfant = 0; } $temp = str_replace("#TITRE", "{$rubriquedesc->titre}", $texte); $temp = str_replace("#STRIPTITRE", strip_tags($rubriquedesc->titre), $temp); $temp = str_replace("#CHAPO", "{$rubriquedesc->chapo}", $temp); $temp = str_replace("#STRIPCHAPO", strip_tags($rubriquedesc->chapo), $temp); $temp = str_replace("#DESCRIPTION", "{$rubriquedesc->description}", $temp); $temp = str_replace("#POSTSCRIPTUM", "{$rubriquedesc->postscriptum}", $temp); $temp = str_replace("#PARENT", "{$rubrique->parent}", $temp); $temp = str_replace("#ID", "{$rubrique->id}", $temp); $temp = str_replace("#URL", $rubriquedesc->getUrl(), $temp); $temp = str_replace("#REWRITEURL", $rubriquedesc->getUrl(), $temp); $temp = str_replace("#LIEN", "{$rubrique->lien}", $temp); $temp = str_replace("#COMPT", "{$compt}", $temp); $temp = str_replace("#NBRES", "{$nbres}", $temp); $temp = str_replace("#NBENFANT", "{$nbenfant}", $temp); $compt++; if (trim($temp) != "") { $res .= $temp; } } return $res; }
<a href="accueil.php" class="lien04"><?php echo trad('Accueil', 'admin'); ?> </a> <img src="gfx/suivant.gif" width="12" height="9" border="0" /> <a href="parcourir.php" class="lien04"><?php echo trad('Gestion_catalogue', 'admin'); ?> </a> <?php $parentdesc = new Rubriquedesc(); $parentdesc->charger($parent); $parentnom = $parentdesc->titre; $res = chemin_rub($parent); $tot = count($res) - 1; ?> <?php if ($parent) { ?> <img src="gfx/suivant.gif" width="12" height="9" border="0" /> <?php } while ($tot--) { ?> <a href="#" onclick="document.getElementById('formulaire').submit()"></a> <a href="parcourir.php?parent=<?php echo $res[$tot + 1]->rubrique; ?> " class="lien04"> <?php
require_once "entete.php"; ?> <div id="contenu_int"> <p><a href="accueil.php" class="lien04"><?php echo trad('Accueil', 'admin'); ?> </a><img src="gfx/suivant.gif" width="12" height="9" border="0" alt="-" /><a href="parcourir.php" class="lien04"><?php echo trad('Gestion_catalogue', 'admin'); ?> </a> <?php $parentdesc = new Rubriquedesc(); $parentdesc->charger($rubrique); $parentnom = $parentdesc->titre; $res = chemin_rub($rubrique); $tot = count($res) - 1; ?> <?php if ($rubrique) { ?> <img src="gfx/suivant.gif" width="12" height="9" border="0" alt="-" /> <?php } while ($tot--) { ?> <a href="parcourir.php?parent=<?php echo $res[$tot + 1]->rubrique; ?> " class="lien04"><?php
public function getBreadcrumbList($parent) { $tab = array_reverse(chemin_rub($parent)); if ($tab[0]->id == '') { return array(); } return $tab; }
function modifier($id, $parent, $lang, $titre, $chapo, $description, $postscriptum, $lien, $ligne, $urlsuiv, $urlreecrite) { $rubrique = new Rubrique(); $rubriquedesc = new Rubriquedesc(); $rubrique->charger($id); $res = $rubriquedesc->charger($id, $lang); if (!$res) { CacheBase::getCache()->reset_cache(); $temp = new Rubriquedesc(); $temp->rubrique = $rubrique->id; $temp->lang = $lang; $lastid = $temp->add(); $rubriquedesc = new Rubriquedesc(); $rubriquedesc->charger_id($lastid); } $parent_tmp = $rubrique->parent; if ($parent != $parent_tmp) { $trouve = 0; $test = chemin_rub($parent); for ($i = 0; $i < count($test); $i++) { if ($test[$i]->rubrique == $id) { $trouve = 1; break; } } if (!$trouve) { $rubrique->parent = $parent; $rubrique->classement = $rubrique->prochain_classement(); } } $rubrique->lien = $lien; $rubriquedesc->titre = $titre; $rubriquedesc->chapo = $chapo; $rubriquedesc->description = $description; $rubriquedesc->postscriptum = $postscriptum; if ($ligne != "") { $rubrique->ligne = 1; } else { $rubrique->ligne = 0; } $rubrique->maj(); $rubriquedesc->maj(); if ($parent_tmp != $parent) { $queryclass = "select * from {$rubrique->table} where parent={$parent_tmp} order by classement"; $resclass = $rubrique->query($queryclass); if ($rubrique->num_rows($resclass) > 0) { $i = 1; while ($rowclass = $rubrique->fetch_object($resclass)) { $rub = new Rubrique(); $rub->charger($rowclass->id); $rub->classement = $i; $rub->maj(); $i++; } } } $rubriquedesc->reecrire($urlreecrite); ActionsModules::instance()->appel_module("modrub", $rubrique); if ($urlsuiv) { redirige("parcourir.php?parent=" . $rubrique->parent); } else { redirige("" . $_SERVER['PHP_SELF'] . "?id=" . $rubrique->id . "&lang=" . $lang); } exit; }