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-menumobileart.html * Date : Thu, 10 Oct 2024 10:23:25 GMT * Compile : Thu, 10 Oct 2024 10:42:54 GMT * Boucles : _exclure_ssrub_menu, _exclure_rub_menu, _exclure_art_menu, _articles_racineC, _testchrono, _articles_racine, _articles_rubrique1C, _testchrono1, _articles_rubrique1, _articles_rubrique2C, _testchrono2, _articles_rubrique2, _articles_rubrique3C, _testchrono3, _articles_rubrique3, _articles_rubrique4C, _testchrono4, _articles_rubrique4, _articles_rubrique5C, _testchrono5, _articles_rubrique5, _rubriques5, _rubriques4, _rubriques3, _rubriques2, _rubriques1, _secteur */ function BOUCLE_exclure_ssrub_menuhtml_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_exclure_ssrub_menu',28,$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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_exclure_rub_menuhtml_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_exclure_rub_menu',27,$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_09466a92d1db1884db0521f0786623e3($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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_exclure_art_menuhtml_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_exclure_art_menu',32,$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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_racineChtml_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_articles_racineC',52,$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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testchronohtml_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_testchrono',51,$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_09466a92d1db1884db0521f0786623e3($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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_racinehtml_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_articles_racine',58,$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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique1Chtml_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_articles_rubrique1C',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_rubrique1C @ plugins/auto/escal/inclusions/inc-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testchrono1html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_testchrono1',73,$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_09466a92d1db1884db0521f0786623e3($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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique1html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_articles_rubrique1',80,$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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique2Chtml_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_articles_rubrique2C',96,$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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testchrono2html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_testchrono2',95,$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_09466a92d1db1884db0521f0786623e3($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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique2html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_articles_rubrique2',102,$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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique3Chtml_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_articles_rubrique3C',118,$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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testchrono3html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_testchrono3',117,$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_09466a92d1db1884db0521f0786623e3($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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique3html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_articles_rubrique3',124,$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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique4Chtml_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_articles_rubrique4C',140,$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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testchrono4html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_testchrono4',139,$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_09466a92d1db1884db0521f0786623e3($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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique4html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_articles_rubrique4',146,$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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique5Chtml_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_articles_rubrique5C',162,$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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testchrono5html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_testchrono5',161,$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_09466a92d1db1884db0521f0786623e3($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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_articles_rubrique5html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_articles_rubrique5',168,$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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_rubriques5html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_rubriques5',154,$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-menumobileart.html\',\'html_09466a92d1db1884db0521f0786623e3\',\'\',156,$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]))) . ' </a> <ul> <!-- affichage des articles des sous-rubriques de niveau 5 --> ' . (($t1 = BOUCLE_testchrono5html_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . BOUCLE_articles_rubrique5html_09466a92d1db1884db0521f0786623e3($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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_rubriques4html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_rubriques4',132,$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-menumobileart.html\',\'html_09466a92d1db1884db0521f0786623e3\',\'\',134,$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]))) . ' </a> <ul> <!-- affichage des articles des sous-rubriques de niveau 4 --> ' . (($t1 = BOUCLE_testchrono4html_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . BOUCLE_articles_rubrique4html_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP) . ' '))) . ' <!-- affichage des sous-rubriques de niveau 5 --> ' . BOUCLE_rubriques5html_09466a92d1db1884db0521f0786623e3($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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_rubriques3html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_rubriques3',110,$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-menumobileart.html\',\'html_09466a92d1db1884db0521f0786623e3\',\'\',112,$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]))) . ' </a> <ul> <!-- affichage des articles des sous-rubriques de niveau 3 --> ' . (($t1 = BOUCLE_testchrono3html_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . BOUCLE_articles_rubrique3html_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP) . ' '))) . ' <!-- affichage des sous-rubriques de niveau 4 --> ' . BOUCLE_rubriques4html_09466a92d1db1884db0521f0786623e3($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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_rubriques2html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_rubriques2',88,$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-menumobileart.html\',\'html_09466a92d1db1884db0521f0786623e3\',\'\',90,$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]))) . ' </a> <ul> <!-- affichage des articles des sous-rubriques de niveau 2 --> ' . (($t1 = BOUCLE_testchrono2html_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . BOUCLE_articles_rubrique2html_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP) . ' '))) . ' <!-- affichage des sous-rubriques de niveau 3 --> ' . BOUCLE_rubriques3html_09466a92d1db1884db0521f0786623e3($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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_rubriques1html_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_rubriques1',66,$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-menumobileart.html\',\'html_09466a92d1db1884db0521f0786623e3\',\'\',68,$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]))) . ' </a> <ul> <!-- affichage des articles des sous-rubriques de niveau 1 --> ' . (($t1 = BOUCLE_testchrono1html_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . BOUCLE_articles_rubrique1html_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP) . ' '))) . ' <!-- affichage des sous-rubriques de niveau 2 --> ' . BOUCLE_rubriques2html_09466a92d1db1884db0521f0786623e3($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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_secteurhtml_09466a92d1db1884db0521f0786623e3(&$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-menumobileart.html','html_09466a92d1db1884db0521f0786623e3','_secteur',37,$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-menumobileart.html\',\'html_09466a92d1db1884db0521f0786623e3\',\'\',39,$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',table_valeur($Pile["vars"]??[], (string)'taillelogo', null)))) : '') . ' ' . (!(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',table_valeur($Pile["vars"]??[], (string)'taillelogo', null))) . ' ')) : '') . ' ')) : '') . ' ' . (($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]))) . ' ')) : '') . ' </a> <ul> <!-- affichage des articles du secteur --> ' . (($t1 = BOUCLE_testchronohtml_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . BOUCLE_articles_racinehtml_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP) . ' '))) . ' <!-- affichage des sous-rubriques de niveau 1 --> ' . BOUCLE_rubriques1html_09466a92d1db1884db0521f0786623e3($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-menumobileart.html","profiler"._LOG_AVERTISSEMENT); return $t0; } // // Fonction principale du squelette plugins/auto/escal/inclusions/inc-menumobileart.html // Temps de compilation total: 2.460 ms // function html_09466a92d1db1884db0521f0786623e3($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 = ( '<nav class="main-nav"> <!-- Mobile menu toggle button (hamburger/x icon) --> <input id="main-menu-state" type="checkbox" /> <label class="main-menu-btn" for="main-menu-state"> <span class="main-menu-btn-icon"></span> </label> <h2 class="nav-brand"><a href="#">MENU</a></h2> <ul id="main-menu" class="sm sm-blue"> ' . vide($Pile['vars'][$_zzz=(string)'taillelogo'] = interdire_scripts((include_spip('inc/config')?lire_config('escal/config/taillelogorubmenu','20',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/logorubmenu',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',table_valeur($Pile["vars"]??[], (string)'taillelogo', null))) . ' ')) : '') . ' ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/texterubmenu',null,false):'') == 'non')) ?'' :' '))))!=='' ? ($t1 . ( _T('public|spip|ecrire:accueil_site') . ' ')) : '') . ' </a> </li> <!-- exclusion des rubriques avec le mot-clé "pas-au-menu" ou "invisible" et de ses sous-rubriques --> ' . BOUCLE_exclure_rub_menuhtml_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP) . ' <!-- exclusion des articles avec le mot-clé "pas-au-menu" ou "invisible" --> ' . BOUCLE_exclure_art_menuhtml_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP) . ' <!-- affichage des secteurs--> ' . BOUCLE_secteurhtml_09466a92d1db1884db0521f0786623e3($Cache, $Pile, $doublons, $Numrows, $SP) . ' </ul><!-- fin menu --> </nav> '); return analyse_resultat_skel('html_09466a92d1db1884db0521f0786623e3', $Cache, $page, 'plugins/auto/escal/inclusions/inc-menumobileart.html'); }