Server : Apache System : Linux webd348.cluster026.gra.hosting.ovh.net 5.15.148-ovh-vps-grsec-zfs-classid #1 SMP Thu Feb 8 09:41:04 UTC 2024 x86_64 User : hednacluml ( 122243) PHP Version : 8.3.9 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl Directory : /home/hednacluml/aides/tmp/cache/skel/ |
<?php /* * Squelette : plugins/auto/escal/inclusions/inc-menuart.html * Date : Thu, 10 Oct 2024 10:23:21 GMT * Compile : Thu, 10 Oct 2024 10:42:54 GMT * Boucles : _exclure_ssrub_menu, _exclure_rub_menu, _exclure_art_menu, _testrub1, _articles_racineC, _testchrono, _articles_racine, _testrub2, _articles_rubrique1C, _testchrono1, _articles_rubrique1, _testrub3, _articles_rubrique2C, _testchrono2, _articles_rubrique2, _testrub4, _articles_rubrique3C, _testchrono3, _articles_rubrique3, _testrub5, _articles_rubrique4C, _testchrono4, _articles_rubrique4, _testrub6, _articles_rubrique5C, _testchrono5, _articles_rubrique5, _rubriques5, _rubriques4, _rubriques3, _rubriques2, _rubriques1, _secteur */ function BOUCLE_exclure_ssrub_menuhtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'rubriques'.'rubriques'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_exclure_ssrub_menu'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("rubriques.id_rubrique"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_parent', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('rubriques.id_rubrique', $doublons[$doublons_index[]= ('rubriques'.'rubriques')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_exclure_ssrub_menu',20,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_rubrique']; // doublons } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_exclure_ssrub_menu @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_exclure_rub_menuhtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); $in = array(); $in[]= 'pas-au-menu'; $in[]= 'invisible'; // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'rubriques'.'rubriques'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_exclure_rub_menu'; $command['from'] = array('rubriques' => 'spip_rubriques','L1' => 'spip_mots_liens','L2' => 'spip_mots'); $command['type'] = array(); $command['groupby'] = array("rubriques.id_rubrique"); $command['select'] = array("rubriques.id_rubrique", "rubriques.lang", "rubriques.titre"); $command['join'] = array('L1' => array('rubriques','id_objet','id_rubrique','L1.objet='.sql_quote('rubrique')), 'L2' => array('L1','id_mot')); $command['limit'] = ''; $command['having'] = array(); } $command['orderby'] = array(((!$zqv=sql_quote($in) OR $zqv==="''") ? 0 : ('FIELD(L2.titre,' . $zqv . ')'))); $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('rubrique')), sql_in('L2.titre', $in), array(sql_in('rubriques.id_rubrique', $doublons[$doublons_index[]= ('rubriques'.'rubriques')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_exclure_rub_menu',19,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_rubrique']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' ' . BOUCLE_exclure_ssrub_menuhtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_exclure_rub_menu @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_exclure_art_menuhtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); $in = array(); $in[]= 'pas-au-menu'; $in[]= 'invisible'; // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_exclure_art_menu'; $command['from'] = array('articles' => 'spip_articles','L1' => 'spip_mots_liens','L2' => 'spip_mots'); $command['type'] = array(); $command['groupby'] = array("articles.id_article"); $command['select'] = array("articles.id_article"); $command['join'] = array('L1' => array('articles','id_objet','id_article','L1.objet='.sql_quote('article')), 'L2' => array('L1','id_mot')); $command['limit'] = ''; $command['having'] = array(); } $command['orderby'] = array(((!$zqv=sql_quote($in) OR $zqv==="''") ? 0 : ('FIELD(L2.titre,' . $zqv . ')'))); $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('article')), sql_in('L2.titre', $in), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'articles')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_exclure_art_menu',24,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_article']; // doublons $t0 .= ' '; } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_exclure_art_menu @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testrub1html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_testrub1'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("1"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = '0,1'; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_parent', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\''))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_testrub1',39,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $Numrows['_testrub1']['command'] = $command; $Numrows['_testrub1']['total'] = @intval($iter->count()); $SP++; // RESULTATS $t0 = str_repeat('<span class="flechesecteur">▼</span>', $Numrows['_testrub1']['total']); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_testrub1 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_racineChtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_articles_racineC'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("articles.date", "articles.id_article", "articles.id_rubrique", "articles.descriptif", "articles.titre", "articles.lang"); $command['orderby'] = array('articles.date DESC'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'articles')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_articles_racineC',45,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_article']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_article'], 'id_article', $Pile[0], $Pile[$SP]['id_rubrique'], 'id_article', '') ? 'on' : '') . ' article"> <a href="' . interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))))) . '" title="' . interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_articles_racineC @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testchronohtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_testchrono'; $command['from'] = array('rubriques' => 'spip_rubriques','L1' => 'spip_mots_liens','L2' => 'spip_mots'); $command['type'] = array(); $command['groupby'] = array("rubriques.id_rubrique"); $command['select'] = array("rubriques.id_rubrique", "rubriques.lang", "rubriques.titre"); $command['orderby'] = array(); $command['join'] = array('L1' => array('rubriques','id_objet','id_rubrique','L1.objet='.sql_quote('rubrique')), 'L2' => array('L1','id_mot')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL AUTO_INCREMENT')), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('rubrique')), array('=', 'L2.titre', "'chrono'")); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_testchrono',44,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' ' . BOUCLE_articles_racineChtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_testchrono @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_racinehtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_articles_racine'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("CASE ( 0+articles.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "0+articles.titre AS num1", "articles.titre", "articles.id_article", "articles.id_rubrique", "articles.descriptif", "articles.lang"); $command['orderby'] = array('sinum', 'sinum, num1', 'articles.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'articles')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_articles_racine',51,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_article']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_article'], 'id_article', $Pile[0], $Pile[$SP]['id_rubrique'], 'id_article', '') ? 'on' : '') . ' article"> <a href="' . interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))))) . '" title="' . interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_articles_racine @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testrub2html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_testrub2'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("1"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = '0,1'; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_parent', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\''))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_testrub2',62,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $Numrows['_testrub2']['command'] = $command; $Numrows['_testrub2']['total'] = @intval($iter->count()); $SP++; // RESULTATS $t0 = str_repeat('<span class="flecherub">►</span>', $Numrows['_testrub2']['total']); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_testrub2 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique1Chtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_articles_rubrique1C'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("articles.date", "articles.id_article", "articles.id_rubrique", "articles.descriptif", "articles.titre", "articles.lang"); $command['orderby'] = array('articles.date DESC'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'articles')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_articles_rubrique1C',68,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_article']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_article'], 'id_article', $Pile[0], $Pile[$SP]['id_rubrique'], 'id_article', '') ? 'on' : '') . ' article"> <a href="' . interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))))) . '" title="' . interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_articles_rubrique1C @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testchrono1html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_testchrono1'; $command['from'] = array('rubriques' => 'spip_rubriques','L1' => 'spip_mots_liens','L2' => 'spip_mots'); $command['type'] = array(); $command['groupby'] = array("rubriques.id_rubrique"); $command['select'] = array("rubriques.id_rubrique", "rubriques.lang", "rubriques.titre"); $command['orderby'] = array(); $command['join'] = array('L1' => array('rubriques','id_objet','id_rubrique','L1.objet='.sql_quote('rubrique')), 'L2' => array('L1','id_mot')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL AUTO_INCREMENT')), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('rubrique')), array('=', 'L2.titre', "'chrono'")); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_testchrono1',67,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' ' . BOUCLE_articles_rubrique1Chtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_testchrono1 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique1html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_articles_rubrique1'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("CASE ( 0+articles.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "0+articles.titre AS num1", "articles.titre", "articles.id_article", "articles.id_rubrique", "articles.descriptif", "articles.lang"); $command['orderby'] = array('sinum', 'sinum, num1', 'articles.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'articles')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_articles_rubrique1',74,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_article']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_article'], 'id_article', $Pile[0], $Pile[$SP]['id_rubrique'], 'id_article', '') ? 'on' : '') . ' article"> <a href="' . interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))))) . '" title="' . interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_articles_rubrique1 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testrub3html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_testrub3'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("1"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = '0,1'; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_parent', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\''))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_testrub3',85,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $Numrows['_testrub3']['command'] = $command; $Numrows['_testrub3']['total'] = @intval($iter->count()); $SP++; // RESULTATS $t0 = str_repeat('<span class="flecherub">►</span>', $Numrows['_testrub3']['total']); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_testrub3 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique2Chtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_articles_rubrique2C'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("articles.date", "articles.id_article", "articles.id_rubrique", "articles.descriptif", "articles.titre", "articles.lang"); $command['orderby'] = array('articles.date DESC'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'articles')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_articles_rubrique2C',91,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_article']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_article'], 'id_article', $Pile[0], $Pile[$SP]['id_rubrique'], 'id_article', '') ? 'on' : '') . ' article"> <a href="' . interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))))) . '" title="' . interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_articles_rubrique2C @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testchrono2html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_testchrono2'; $command['from'] = array('rubriques' => 'spip_rubriques','L1' => 'spip_mots_liens','L2' => 'spip_mots'); $command['type'] = array(); $command['groupby'] = array("rubriques.id_rubrique"); $command['select'] = array("rubriques.id_rubrique", "rubriques.lang", "rubriques.titre"); $command['orderby'] = array(); $command['join'] = array('L1' => array('rubriques','id_objet','id_rubrique','L1.objet='.sql_quote('rubrique')), 'L2' => array('L1','id_mot')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL AUTO_INCREMENT')), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('rubrique')), array('=', 'L2.titre', "'chrono'")); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_testchrono2',90,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' ' . BOUCLE_articles_rubrique2Chtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_testchrono2 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique2html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_articles_rubrique2'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("CASE ( 0+articles.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "0+articles.titre AS num1", "articles.titre", "articles.id_article", "articles.id_rubrique", "articles.descriptif", "articles.lang"); $command['orderby'] = array('sinum', 'sinum, num1', 'articles.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'articles')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_articles_rubrique2',97,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_article']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_article'], 'id_article', $Pile[0], $Pile[$SP]['id_rubrique'], 'id_article', '') ? 'on' : '') . ' article"> <a href="' . interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))))) . '" title="' . interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_articles_rubrique2 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testrub4html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_testrub4'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("1"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = '0,1'; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_parent', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\''))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_testrub4',108,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $Numrows['_testrub4']['command'] = $command; $Numrows['_testrub4']['total'] = @intval($iter->count()); $SP++; // RESULTATS $t0 = str_repeat('<span class="flecherub">►</span>', $Numrows['_testrub4']['total']); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_testrub4 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique3Chtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_articles_rubrique3C'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("articles.date", "articles.id_article", "articles.id_rubrique", "articles.descriptif", "articles.titre", "articles.lang"); $command['orderby'] = array('articles.date DESC'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'articles')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_articles_rubrique3C',114,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_article']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_article'], 'id_article', $Pile[0], $Pile[$SP]['id_rubrique'], 'id_article', '') ? 'on' : '') . ' article"> <a href="' . interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))))) . '" title="' . interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_articles_rubrique3C @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testchrono3html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_testchrono3'; $command['from'] = array('rubriques' => 'spip_rubriques','L1' => 'spip_mots_liens','L2' => 'spip_mots'); $command['type'] = array(); $command['groupby'] = array("rubriques.id_rubrique"); $command['select'] = array("rubriques.id_rubrique", "rubriques.lang", "rubriques.titre"); $command['orderby'] = array(); $command['join'] = array('L1' => array('rubriques','id_objet','id_rubrique','L1.objet='.sql_quote('rubrique')), 'L2' => array('L1','id_mot')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL AUTO_INCREMENT')), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('rubrique')), array('=', 'L2.titre', "'chrono'")); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_testchrono3',113,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' ' . BOUCLE_articles_rubrique3Chtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_testchrono3 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique3html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_articles_rubrique3'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("CASE ( 0+articles.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "0+articles.titre AS num1", "articles.titre", "articles.id_article", "articles.id_rubrique", "articles.descriptif", "articles.lang"); $command['orderby'] = array('sinum', 'sinum, num1', 'articles.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'articles')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_articles_rubrique3',120,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_article']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_article'], 'id_article', $Pile[0], $Pile[$SP]['id_rubrique'], 'id_article', '') ? 'on' : '') . ' article"> <a href="' . interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))))) . '" title="' . interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_articles_rubrique3 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testrub5html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_testrub5'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("1"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = '0,1'; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_parent', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\''))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_testrub5',131,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $Numrows['_testrub5']['command'] = $command; $Numrows['_testrub5']['total'] = @intval($iter->count()); $SP++; // RESULTATS $t0 = str_repeat('<span class="flecherub">►</span>', $Numrows['_testrub5']['total']); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_testrub5 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique4Chtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_articles_rubrique4C'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("articles.date", "articles.id_article", "articles.id_rubrique", "articles.descriptif", "articles.titre", "articles.lang"); $command['orderby'] = array('articles.date DESC'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'articles')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_articles_rubrique4C',137,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_article']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_article'], 'id_article', $Pile[0], $Pile[$SP]['id_rubrique'], 'id_article', '') ? 'on' : '') . ' article"> <a href="' . interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))))) . '" title="' . interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_articles_rubrique4C @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testchrono4html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_testchrono4'; $command['from'] = array('rubriques' => 'spip_rubriques','L1' => 'spip_mots_liens','L2' => 'spip_mots'); $command['type'] = array(); $command['groupby'] = array("rubriques.id_rubrique"); $command['select'] = array("rubriques.id_rubrique", "rubriques.lang", "rubriques.titre"); $command['orderby'] = array(); $command['join'] = array('L1' => array('rubriques','id_objet','id_rubrique','L1.objet='.sql_quote('rubrique')), 'L2' => array('L1','id_mot')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL AUTO_INCREMENT')), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('rubrique')), array('=', 'L2.titre', "'chrono'")); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_testchrono4',136,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' ' . BOUCLE_articles_rubrique4Chtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_testchrono4 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique4html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_articles_rubrique4'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("CASE ( 0+articles.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "0+articles.titre AS num1", "articles.titre", "articles.id_article", "articles.id_rubrique", "articles.descriptif", "articles.lang"); $command['orderby'] = array('sinum', 'sinum, num1', 'articles.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'articles')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_articles_rubrique4',143,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_article']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_article'], 'id_article', $Pile[0], $Pile[$SP]['id_rubrique'], 'id_article', '') ? 'on' : '') . ' article"> <a href="' . interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))))) . '" title="' . interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_articles_rubrique4 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testrub6html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_testrub6'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("1"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = '0,1'; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_parent', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\''))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_testrub6',154,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $Numrows['_testrub6']['command'] = $command; $Numrows['_testrub6']['total'] = @intval($iter->count()); $SP++; // RESULTATS $t0 = str_repeat('<span class="flecherub">►</span>', $Numrows['_testrub6']['total']); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_testrub6 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique5Chtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_articles_rubrique5C'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("articles.date", "articles.id_article", "articles.id_rubrique", "articles.descriptif", "articles.titre", "articles.lang"); $command['orderby'] = array('articles.date DESC'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'articles')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_articles_rubrique5C',160,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_article']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_article'], 'id_article', $Pile[0], $Pile[$SP]['id_rubrique'], 'id_article', '') ? 'on' : '') . ' article"> <a href="' . interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))))) . '" title="' . interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_articles_rubrique5C @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testchrono5html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_testchrono5'; $command['from'] = array('rubriques' => 'spip_rubriques','L1' => 'spip_mots_liens','L2' => 'spip_mots'); $command['type'] = array(); $command['groupby'] = array("rubriques.id_rubrique"); $command['select'] = array("rubriques.id_rubrique", "rubriques.lang", "rubriques.titre"); $command['orderby'] = array(); $command['join'] = array('L1' => array('rubriques','id_objet','id_rubrique','L1.objet='.sql_quote('rubrique')), 'L2' => array('L1','id_mot')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL AUTO_INCREMENT')), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('rubrique')), array('=', 'L2.titre', "'chrono'")); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_testchrono5',159,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' ' . BOUCLE_articles_rubrique5Chtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_testchrono5 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique5html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_articles_rubrique5'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("CASE ( 0+articles.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "0+articles.titre AS num1", "articles.titre", "articles.id_article", "articles.id_rubrique", "articles.descriptif", "articles.lang"); $command['orderby'] = array('sinum', 'sinum, num1', 'articles.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'articles')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_articles_rubrique5',166,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_article']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_article'], 'id_article', $Pile[0], $Pile[$SP]['id_rubrique'], 'id_article', '') ? 'on' : '') . ' article"> <a href="' . interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))))) . '" title="' . interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_articles_rubrique5 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_rubriques5html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'rubriques'.'rubriques'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_rubriques5'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("rubriques.id_rubrique", "CASE ( 0+rubriques.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "0+rubriques.titre AS num1", "rubriques.titre", "rubriques.descriptif", "rubriques.lang"); $command['orderby'] = array('sinum', 'sinum, num1', 'rubriques.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_parent', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('rubriques.id_rubrique', $doublons[$doublons_index[]= ('rubriques'.'rubriques')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_rubriques5',151,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_rubrique']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_rubrique'], 'id_rubrique', $Pile[0], 0, 'id_rubrique', '') ? 'on' : '') . ' rubrique"> <a href="' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclusions/inc-triurlrubrique') . ', array_merge('.var_export($Pile[0],1).',array(\'id_rubrique\' => ' . argumenter_squelette($Pile[$SP]['id_rubrique']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . ')), array("compil"=>array(\'plugins/auto/escal/inclusions/inc-menuart.html\',\'html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb\',\'\',153,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'>"' . (calcul_exposer($Pile[$SP]['id_rubrique'], 'id_rubrique', $Pile[0], 0, 'id_rubrique', '') ? (' class="' . 'on' . '"') : '') . ' ' . (($t1 = strval(interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0]))))))!=='' ? ('title="' . $t1 . '"') : '') . '>' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . ' ' . BOUCLE_testrub6html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' </a> <ul> <!-- affichage des articles des sous-rubriques de niveau 5 --> ' . (($t1 = BOUCLE_testchrono5html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . BOUCLE_articles_rubrique5html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' '))) . ' </ul> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_rubriques5 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_rubriques4html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'rubriques'.'rubriques'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_rubriques4'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("rubriques.id_rubrique", "CASE ( 0+rubriques.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "0+rubriques.titre AS num1", "rubriques.titre", "rubriques.descriptif", "rubriques.lang"); $command['orderby'] = array('sinum', 'sinum, num1', 'rubriques.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_parent', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('rubriques.id_rubrique', $doublons[$doublons_index[]= ('rubriques'.'rubriques')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_rubriques4',128,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_rubrique']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_rubrique'], 'id_rubrique', $Pile[0], 0, 'id_rubrique', '') ? 'on' : '') . ' rubrique"> <a href="' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclusions/inc-triurlrubrique') . ', array_merge('.var_export($Pile[0],1).',array(\'id_rubrique\' => ' . argumenter_squelette($Pile[$SP]['id_rubrique']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . ')), array("compil"=>array(\'plugins/auto/escal/inclusions/inc-menuart.html\',\'html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb\',\'\',130,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'>"' . (calcul_exposer($Pile[$SP]['id_rubrique'], 'id_rubrique', $Pile[0], 0, 'id_rubrique', '') ? (' class="' . 'on' . '"') : '') . ' ' . (($t1 = strval(interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0]))))))!=='' ? ('title="' . $t1 . '"') : '') . '>' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . ' ' . BOUCLE_testrub5html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' </a> <ul> <!-- affichage des articles des sous-rubriques de niveau 4 --> ' . (($t1 = BOUCLE_testchrono4html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . BOUCLE_articles_rubrique4html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' '))) . ' <!-- affichage des sous-rubriques de niveau 5 --> ' . BOUCLE_rubriques5html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' </ul> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_rubriques4 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_rubriques3html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'rubriques'.'rubriques'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_rubriques3'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("rubriques.id_rubrique", "CASE ( 0+rubriques.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "0+rubriques.titre AS num1", "rubriques.titre", "rubriques.descriptif", "rubriques.lang"); $command['orderby'] = array('sinum', 'sinum, num1', 'rubriques.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_parent', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('rubriques.id_rubrique', $doublons[$doublons_index[]= ('rubriques'.'rubriques')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_rubriques3',105,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_rubrique']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_rubrique'], 'id_rubrique', $Pile[0], 0, 'id_rubrique', '') ? 'on' : '') . ' rubrique"> <a href="' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclusions/inc-triurlrubrique') . ', array_merge('.var_export($Pile[0],1).',array(\'id_rubrique\' => ' . argumenter_squelette($Pile[$SP]['id_rubrique']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . ')), array("compil"=>array(\'plugins/auto/escal/inclusions/inc-menuart.html\',\'html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb\',\'\',107,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'>"' . (calcul_exposer($Pile[$SP]['id_rubrique'], 'id_rubrique', $Pile[0], 0, 'id_rubrique', '') ? (' class="' . 'on' . '"') : '') . ' ' . (($t1 = strval(interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0]))))))!=='' ? ('title="' . $t1 . '"') : '') . '>' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . ' ' . BOUCLE_testrub4html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' </a> <ul> <!-- affichage des articles des sous-rubriques de niveau 3 --> ' . (($t1 = BOUCLE_testchrono3html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . BOUCLE_articles_rubrique3html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' '))) . ' <!-- affichage des sous-rubriques de niveau 4 --> ' . BOUCLE_rubriques4html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' </ul> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_rubriques3 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_rubriques2html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'rubriques'.'rubriques'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_rubriques2'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("rubriques.id_rubrique", "CASE ( 0+rubriques.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "0+rubriques.titre AS num1", "rubriques.titre", "rubriques.descriptif", "rubriques.lang"); $command['orderby'] = array('sinum', 'sinum, num1', 'rubriques.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_parent', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('rubriques.id_rubrique', $doublons[$doublons_index[]= ('rubriques'.'rubriques')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_rubriques2',82,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_rubrique']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_rubrique'], 'id_rubrique', $Pile[0], 0, 'id_rubrique', '') ? 'on' : '') . ' rubrique"> <a href="' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclusions/inc-triurlrubrique') . ', array_merge('.var_export($Pile[0],1).',array(\'id_rubrique\' => ' . argumenter_squelette($Pile[$SP]['id_rubrique']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . ')), array("compil"=>array(\'plugins/auto/escal/inclusions/inc-menuart.html\',\'html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb\',\'\',84,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'>"' . (calcul_exposer($Pile[$SP]['id_rubrique'], 'id_rubrique', $Pile[0], 0, 'id_rubrique', '') ? (' class="' . 'on' . '"') : '') . ' ' . (($t1 = strval(interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0]))))))!=='' ? ('title="' . $t1 . '"') : '') . '>' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . ' ' . BOUCLE_testrub3html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' </a> <ul> <!-- affichage des articles des sous-rubriques de niveau 2 --> ' . (($t1 = BOUCLE_testchrono2html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . BOUCLE_articles_rubrique2html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' '))) . ' <!-- affichage des sous-rubriques de niveau 3 --> ' . BOUCLE_rubriques3html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' </ul> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_rubriques2 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_rubriques1html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'rubriques'.'rubriques'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_rubriques1'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("rubriques.id_rubrique", "CASE ( 0+rubriques.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "0+rubriques.titre AS num1", "rubriques.titre", "rubriques.descriptif", "rubriques.lang"); $command['orderby'] = array('sinum', 'sinum, num1', 'rubriques.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_parent', sql_quote($Pile[$SP]['id_rubrique'], '','bigint NOT NULL DEFAULT \'0\'')), array(sql_in('rubriques.id_rubrique', $doublons[$doublons_index[]= ('rubriques'.'rubriques')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_rubriques1',59,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_rubrique']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_rubrique'], 'id_rubrique', $Pile[0], 0, 'id_rubrique', '') ? 'on' : '') . ' rubrique"> <a href="' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclusions/inc-triurlrubrique') . ', array_merge('.var_export($Pile[0],1).',array(\'id_rubrique\' => ' . argumenter_squelette($Pile[$SP]['id_rubrique']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . ')), array("compil"=>array(\'plugins/auto/escal/inclusions/inc-menuart.html\',\'html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb\',\'\',61,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'>"' . (calcul_exposer($Pile[$SP]['id_rubrique'], 'id_rubrique', $Pile[0], 0, 'id_rubrique', '') ? (' class="' . 'on' . '"') : '') . ' ' . (($t1 = strval(interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0]))))))!=='' ? ('title="' . $t1 . '"') : '') . '>' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . ' ' . BOUCLE_testrub2html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' </a> <ul> <!-- affichage des articles des sous-rubriques de niveau 1 --> ' . (($t1 = BOUCLE_testchrono1html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . BOUCLE_articles_rubrique1html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' '))) . ' <!-- affichage des sous-rubriques de niveau 2 --> ' . BOUCLE_rubriques2html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' </ul> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_rubriques1 @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_secteurhtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'rubriques'.'rubriques'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_secteur'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("rubriques.id_rubrique", "CASE ( 0+rubriques.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "0+rubriques.titre AS num1", "rubriques.titre", "rubriques.descriptif", "rubriques.lang"); $command['orderby'] = array('sinum', 'sinum, num1', 'rubriques.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), array('=', 'rubriques.id_parent', 0), array('=', 'rubriques.lang', sql_quote($GLOBALS['spip_lang'], '','varchar(10) NOT NULL DEFAULT \'\'')), array(sql_in('rubriques.id_rubrique', $doublons[$doublons_index[]= ('rubriques'.'rubriques')], 'NOT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','_secteur',29,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_rubrique']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="' . (calcul_exposer($Pile[$SP]['id_rubrique'], 'id_rubrique', $Pile[0], 0, 'id_rubrique', '') ? 'on' : '') . ' rubrique rubrique' . $Pile[$SP]['id_rubrique'] . ' secteur"> <a href="' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclusions/inc-triurlrubrique') . ', array_merge('.var_export($Pile[0],1).',array(\'id_rubrique\' => ' . argumenter_squelette($Pile[$SP]['id_rubrique']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . ')), array("compil"=>array(\'plugins/auto/escal/inclusions/inc-menuart.html\',\'html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb\',\'\',31,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'>"' . (calcul_exposer($Pile[$SP]['id_rubrique'], 'id_rubrique', $Pile[0], 0, 'id_rubrique', '') ? (' class="' . 'on' . '"') : '') . ' ' . (($t1 = strval(interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0]))))))!=='' ? ('title="' . $t1 . '"') : '') . '> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/logorubmenu',null,false):'') == 'oui')) ?' ' :''))))!=='' ? ($t1 . ( ' ' . ((quete_html_logo(quete_logo('id_rubrique', 'ON', $Pile[$SP]['id_rubrique'], quete_parent($Pile[$SP]['id_rubrique'])), '', '')) ? (' ' . filtrer('image_graver',filtrer('image_reduire',quete_html_logo(quete_logo('id_rubrique', 'ON', $Pile[$SP]['id_rubrique'], quete_parent($Pile[$SP]['id_rubrique'])), '', ''),'0',sinon(table_valeur($Pile["vars"]??[], (string)'taillelogo', null), '20')))) : '') . ' ' . (!(quete_html_logo(quete_logo('id_rubrique', 'ON', $Pile[$SP]['id_rubrique'], quete_parent($Pile[$SP]['id_rubrique'])), '', '')) ? (' ' . ( filtrer('image_graver',filtrer('image_reduire',filtre_balise_img_dist(find_in_path((string)'images/transparent2.png'),'transparent','spip_logos menutransparent'),'0',sinon(table_valeur($Pile["vars"]??[], (string)'taillelogo', null), '20'))) . ' ')) : '') . ' ')) : '') . ' ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/texterubmenu',null,false):'') == 'non')) ?'' :' '))))!=='' ? ($t1 . ( ' ' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . ' ')) : '') . ' ' . BOUCLE_testrub1html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' </a> <ul> <!-- affichage des articles du secteur --> ' . (($t1 = BOUCLE_testchronohtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . BOUCLE_articles_racinehtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' '))) . ' <!-- affichage des sous-rubriques de niveau 1 --> ' . BOUCLE_rubriques1html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' </ul> </li> '); lang_select(); } lang_select(); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_secteur @ plugins/auto/escal/inclusions/inc-menuart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } // // Fonction principale du squelette plugins/auto/escal/inclusions/inc-menuart.html // Temps de compilation total: 46.490 ms // function html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons = array(), $Numrows = array(), $SP = 0) { if (isset($Pile[0]["doublons"]) AND is_array($Pile[0]["doublons"])) $doublons = nettoyer_env_doublons($Pile[0]["doublons"]); $connect = ''; $page = ( '<div class="menudesktop"> <nav class="menu"> <ul id="menu"> ' . vide($Pile['vars'][$_zzz=(string)'taillelogo'] = interdire_scripts((include_spip('inc/config')?lire_config('escal/config/taillelogorubmenu',null,false):''))) . '<li class="item-accueil"> <a href="' . interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(spip_htmlspecialchars(sinon($GLOBALS['meta']['adresse_site'],'.')),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):spip_htmlspecialchars(sinon($GLOBALS['meta']['adresse_site'],'.')))) . '" title="' . _T('public|spip|ecrire:accueil_site') . '"> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/logoaccueil',null,false):'') == 'oui')) ?' ' :''))))!=='' ? ($t1 . ( ' ' . filtrer('image_graver',filtrer('image_reduire',filtre_balise_img_dist(find_in_path((string)'images/accueil2.png'),'accueil','spip_logos'),'0',sinon(table_valeur($Pile["vars"]??[], (string)'taillelogo', null), '20'))) . ' ')) : '') . ' ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/texteaccueil',null,false):'') == 'non')) ?'' :' '))))!=='' ? ($t1 . ( _T('public|spip|ecrire:accueil_site') . ' ')) : '') . ' </a> </li> ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclusions/inc-liens') . ', array(\'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . '), array("compil"=>array(\'plugins/auto/escal/inclusions/inc-menuart.html\',\'html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb\',\'\',13,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'> <!-- exclusion des rubriques avec le mot-clé "pas-au-menu" ou "invisible" et de ses sous-rubriques --> ' . BOUCLE_exclure_rub_menuhtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' <!-- exclusion des articles avec le mot-clé "pas-au-menu" ou "invisible" --> ' . BOUCLE_exclure_art_menuhtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' <!-- affichage des secteurs--> ' . BOUCLE_secteurhtml_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb($Cache, $Pile, $doublons, $Numrows, $SP) . ' <li> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/formrecherche',null,false):'') == 'menuH')) ?' ' :''))))!=='' ? ($t1 . executer_balise_dynamique('FORMULAIRE_RECHERCHE', array(), array('plugins/auto/escal/inclusions/inc-menuart.html','html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb','',18,$GLOBALS['spip_lang']))) : '') . ' </li> </ul><!-- fin menu --> </nav> </div> '); return analyse_resultat_skel('html_ca59ab2ec8bf1cc43ee10f2e6ca4a1fb', $Cache, $page, 'plugins/auto/escal/inclusions/inc-menuart.html'); }