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;
}
