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/universe/tmp/cache/skel/ |
<?php /* * Squelette : plugins/auto/escal/inclusions/inc-une_derniers.html * Date : Wed, 30 Aug 2023 22:36:08 GMT * Compile : Thu, 31 Aug 2023 11:36:12 GMT * Boucles : _extract, _extract2, _exclure_rub2, _exclure_rub, _exclure_art, _exclure_annonce1, _exclure_annonce2, _exclure_annonce3, _exclure_annoncedef1, _exclure_annoncedef2, _exclure_annoncedef3, _selection, _auteurs, _test, _auteurs_art, _image, _image_alt, _dernier_endate, _testauteur, _auteurs_art2, _Rub_suite, _descriptif_art, _chapo_art, _texteart, _nbre_comm, _comment, _autres_articles_une */ function BOUCLE_extracthtml_101d8c2bfc052560e5fb0b951f33b111(&$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'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_extract'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("articles.id_article"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint(21) NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('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-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_extract',21,$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_extract @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_extract2html_101d8c2bfc052560e5fb0b951f33b111(&$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'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_extract2'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("articles.id_article"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), array('=', 'articles.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint(21) NOT NULL DEFAULT \'0\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('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-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_extract2',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_extract2 @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_exclure_rub2html_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_exclure_rub2'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("rubriques.id_rubrique", "rubriques.lang", "rubriques.titre"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('rubriques.statut','!','publie',''), sql_in('rubriques.id_rubrique', calcul_branche_in(sql_quote($Pile[$SP]['id_rubrique'], '', 'int NOT NULL')))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_exclure_rub2',23,$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_extract2html_101d8c2bfc052560e5fb0b951f33b111($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_rub2 @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_exclure_rubhtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $in = array(); $in[]= 'pas-a-la-une'; $in[]= 'invisible'; if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_exclure_rub'; $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)); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_exclure_rub',20,$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_extracthtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' ' . BOUCLE_exclure_rub2html_101d8c2bfc052560e5fb0b951f33b111($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 @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_exclure_arthtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); $in = array(); $in[]= 'pas-a-la-une'; $in[]= 'invisible'; // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_exclure_art'; $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',''), quete_condition_postdates('articles.date',''), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('article')), sql_in('L2.titre', $in), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('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-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_exclure_art',29,$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 @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_exclure_annonce1html_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/blocune1',null,false):'') == 'annonce')) ?' ' :'')); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'annonce'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_exclure_annonce1'; $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['orderby'] = array(); $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['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('article')), array('=', 'L2.titre', "'annonce'"), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'annonce')], '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-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_exclure_annonce1',35,$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_annonce1 @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_exclure_annonce2html_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/blocune2',null,false):'') == 'annonce')) ?' ' :'')); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'annonce'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_exclure_annonce2'; $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['orderby'] = array(); $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['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('article')), array('=', 'L2.titre', "'annonce'"), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'annonce')], '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-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_exclure_annonce2',37,$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_annonce2 @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_exclure_annonce3html_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/blocune3',null,false):'') == 'annonce')) ?' ' :'')); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'annonce'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_exclure_annonce3'; $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['orderby'] = array(); $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['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('article')), array('=', 'L2.titre', "'annonce'"), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'annonce')], '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-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_exclure_annonce3',39,$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_annonce3 @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_exclure_annoncedef1html_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/blocune1',null,false):'') == 'annonce_defilant')) ?' ' :'')); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'annonce'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_exclure_annoncedef1'; $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['orderby'] = array(); $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['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('article')), array('=', 'L2.titre', "'annonce-defilant'"), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'annonce')], '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-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_exclure_annoncedef1',42,$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_annoncedef1 @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_exclure_annoncedef2html_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/blocune2',null,false):'') == 'annonce_defilant')) ?' ' :'')); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'annonce'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_exclure_annoncedef2'; $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['orderby'] = array(); $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['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('article')), array('=', 'L2.titre', "'annonce-defilant'"), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'annonce')], '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-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_exclure_annoncedef2',44,$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_annoncedef2 @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_exclure_annoncedef3html_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/blocune3',null,false):'') == 'annonce_defilant')) ?' ' :'')); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'annonce'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_exclure_annoncedef3'; $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['orderby'] = array(); $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['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), 'JOIN-L1' => array('=', 'L1.objet', sql_quote('article')), array('=', 'L2.titre', "'annonce-defilant'"), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'annonce')], '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-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_exclure_annoncedef3',46,$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_annoncedef3 @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_selectionhtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); static $champs__selection = array('id_article','surtitre','titre','soustitre','id_rubrique','descriptif','chapo','texte','ps','date','statut','id_secteur','maj','export','date_redac','visites','referers','popularite','accepter_forum','date_modif','lang','langue_choisie','id_trad','nom_site','url_site','virtuel','microblog','pouet'); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'selection2'])) { $doublons[$d] = ''; } if (!isset($doublons[$d = 'articles'.'selection1'])) { $doublons[$d] = ''; } if (!isset($doublons[$d = 'articles'])) { $doublons[$d] = ''; } if (!isset($doublons[$d = 'articles'.'annonce'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_selection'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("rand() AS hasard", "articles.id_article"); $command['join'] = array(); $command['having'] = array(); } $command['orderby'] = array((($x = preg_replace("/\W/",'', interdire_scripts((include_spip('inc/config')?lire_config('escal/config/ordrealaune','date',false):'')))) ? (in_array($x, $champs__selection) ? ('articles.' . $x) :($x)) : '') . ' DESC'); $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), array('=', 'articles.lang', sql_quote($GLOBALS['spip_lang'], '','varchar(10) NOT NULL DEFAULT \'\'')), array(sql_in('articles.id_article', $doublons[$doublons_index[]= ('articles'.'selection2')] . $doublons[$doublons_index[]= ('articles'.'selection1')] . $doublons[$doublons_index[]= ('articles')] . $doublons[$doublons_index[]= ('articles'.'annonce')], 'NOT'))); $command['limit'] = '0'.','.intval(table_valeur($Pile["vars"]??[], (string)'nombrealaune', null)); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_selection',51,$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_selection @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_auteurshtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'auteurs'; $command['id'] = '_auteurs'; $command['from'] = array('auteurs' => 'spip_auteurs','L1' => 'spip_auteurs_liens'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("auteurs.nom", "auteurs.lang"); $command['orderby'] = array(); $command['join'] = array('L1' => array('auteurs','id_auteur')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('auteurs.statut','!5poubelle','!5poubelle',''), array('=', 'L1.id_objet', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL DEFAULT \'0\'')), array('=', 'L1.objet', sql_quote('article'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_auteurs',75,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { lang_select_public($Pile[$SP]['lang'], 'oui'); $t1 = interdire_scripts(textebrut(safehtml(supprimer_numero(typo($Pile[$SP]['nom'], "TYPO", $connect, $Pile[0]))))); $t0 .= ((strlen($t1) && strlen($t0)) ? ', ' : '') . $t1; 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_auteurs @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testhtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/auteurune',null,false):'') == 'non')) ?'' :' ')); if (!isset($command['table'])) { $command['table'] = 'auteurs'; $command['id'] = '_test'; $command['from'] = array('auteurs' => 'spip_auteurs','L1' => 'spip_auteurs_liens'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("count(*)"); $command['orderby'] = array(); $command['join'] = array('L1' => array('auteurs','id_auteur')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('auteurs.statut','!5poubelle','!5poubelle',''), array('=', 'L1.id_objet', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL DEFAULT \'0\'')), array('=', 'L1.objet', sql_quote('article'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_test',84,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $Numrows['_test']['command'] = $command; $Numrows['_test']['total'] = @intval($iter->count()); $SP++; // RESULTATS $t0 = str_repeat(' ', $Numrows['_test']['total']); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_test @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_auteurs_arthtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'auteurs'; $command['id'] = '_auteurs_art'; $command['from'] = array('auteurs' => 'spip_auteurs','L1' => 'spip_auteurs_liens'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("auteurs.id_auteur", "auteurs.nom", "auteurs.lang"); $command['orderby'] = array(); $command['join'] = array('L1' => array('auteurs','id_auteur')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('auteurs.statut','!5poubelle','!5poubelle',''), array('=', 'L1.id_objet', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL DEFAULT \'0\'')), array('=', 'L1.objet', sql_quote('article'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_auteurs_art',88,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { lang_select_public($Pile[$SP]['lang'], 'oui'); $t1 = ( ' <a class="auteur" href="' . interdire_scripts(parametre_url(parametre_url(generer_url_public('auteur', ''),'id_auteur',$Pile[$SP]['id_auteur']),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true)))) . '" title="' . _T('escal:page_auteur') . '">' . interdire_scripts(safehtml(supprimer_numero(typo($Pile[$SP]['nom'], "TYPO", $connect, $Pile[0])))) . '</a> '); $t0 .= ((strlen($t1) && strlen($t0)) ? ', ' : '') . $t1; 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_auteurs_art @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_imagehtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/imageune',null,false):'') == 'non')) ?'' :' ')); if (!isset($command['table'])) { $command['table'] = 'documents'; $command['id'] = '_image'; $command['from'] = array('documents' => 'spip_documents','L1' => 'spip_documents_liens'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("CASE ( 0+documents.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "0+documents.titre AS num1", "documents.titre", "documents.fichier"); $command['orderby'] = array('sinum', 'sinum, num1', 'documents.titre'); $command['join'] = array('L1' => array('documents','id_document')); $command['limit'] = '0,1'; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('documents.statut','publie,prop,prepa','publie',''), quete_condition_postdates('documents.date_publication',''), array('IN', 'documents.mode', '(\'image\',\'document\')'), array('(documents.taille > 0 OR documents.distant=\'oui\')'), array('=', 'L1.id_objet', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL DEFAULT \'0\'')), array('=', 'L1.objet', sql_quote('article')), array('REGEXP', 'documents.extension', "'jpg|png|gif'"), array('REGEXP', 'documents.titre', "'^[0-9]+\\.'")); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_image',112,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( ' <img src="' . interdire_scripts(extraire_attribut(filtrer('image_graver', filtrer('image_reduire',get_spip_doc($Pile[$SP]['fichier']),interdire_scripts((include_spip('inc/config')?lire_config('escal/config/taillelogoimgexergue','150',false):'')))),'src')) . '" alt="' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '" title="' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '" /> '); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_image @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_image_althtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/imageune',null,false):'') == 'non')) ?'' :' ')); if (!isset($command['table'])) { $command['table'] = 'documents'; $command['id'] = '_image_alt'; $command['from'] = array('documents' => 'spip_documents','L1' => 'spip_documents_liens'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("documents.fichier", "documents.titre"); $command['orderby'] = array(); $command['join'] = array('L1' => array('documents','id_document')); $command['limit'] = '0,1'; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('documents.statut','publie,prop,prepa','publie',''), quete_condition_postdates('documents.date_publication',''), array('IN', 'documents.mode', '(\'image\',\'document\')'), array('(documents.taille > 0 OR documents.distant=\'oui\')'), array('=', 'L1.id_objet', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL DEFAULT \'0\'')), array('=', 'L1.objet', sql_quote('article')), array('REGEXP', 'documents.extension', "'jpg|png|gif'")); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_image_alt',115,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( ' <img src="' . interdire_scripts(extraire_attribut(filtrer('image_graver', filtrer('image_reduire',get_spip_doc($Pile[$SP]['fichier']),interdire_scripts((include_spip('inc/config')?lire_config('escal/config/taillelogoimgexergue','150',false):'')))),'src')) . '" alt="' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '" title="' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '" /> '); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_image_alt @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_dernier_endatehtml_101d8c2bfc052560e5fb0b951f33b111(&$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'.'selection1'])) { $doublons[$d] = ''; } $senstri = ''; $tri = (($t=(isset($Pile[0]['tri'.'_dernier_endate']))?$Pile[0]['tri'.'_dernier_endate']:((strncmp('_dernier_endate','session',7)==0 AND session_get('tri'.'_dernier_endate'))?session_get('tri'.'_dernier_endate'):interdire_scripts((include_spip('inc/config')?lire_config('escal/config/ordrealaune','date',false):''))))?tri_protege_champ($t):''); if ($tri){ $senstri = ((intval($t=(isset($Pile[0]['sens'.'_dernier_endate']))?$Pile[0]['sens'.'_dernier_endate']:((strncmp('_dernier_endate','session',7)==0 AND session_get('sens'.'_dernier_endate'))?session_get('sens'.'_dernier_endate'):(is_array($s='inverse')?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_dernier_endate']))?$Pile[0]['tri'.'_dernier_endate']:((strncmp('_dernier_endate','session',7)==0 AND session_get('tri'.'_dernier_endate'))?session_get('tri'.'_dernier_endate'):interdire_scripts((include_spip('inc/config')?lire_config('escal/config/ordrealaune','date',false):''))))?tri_protege_champ($t):'')])?$s[$st]:reset($s)):$s)))==-1 OR $t=='inverse')?-1:1); $senstri = ($senstri<0)?' DESC':''; }; if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_dernier_endate'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['select'] = array("articles.id_article", "".tri_champ_select($tri)."", "articles.id_rubrique", "articles.surtitre", "articles.lang", "articles.date", "articles.titre", "articles.soustitre", "articles.date_modif", "articles.descriptif", "articles.chapo", "articles.texte"); $command['orderby'] = array(tri_champ_order($tri,$command['from'],$senstri)); $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), array(sql_in('articles.id_article', $doublons[('articles'.'selection1')], ''))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_dernier_endate',57,$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 .= ( ' <div id="section-' . $Pile[$SP]['id_article'] . '" class="fragment art-exergue"> <!-- affichage mots-clés associés --> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/motsclesune',null,false):'') == 'oui')) ?' ' :''))))!=='' ? ($t1 . ( ' ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclusions/inc-mots_cles') . ', array(\'id_article\' => ' . argumenter_squelette($Pile[$SP]['id_article']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . '), array("compil"=>array(\'plugins/auto/escal/inclusions/inc-une_derniers.html\',\'html_101d8c2bfc052560e5fb0b951f33b111\',\'\',61,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'> ')) : '') . ' <!-- affichage rubrique --> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/rubriqueune',null,false):'') == 'oui')) ?' ' :''))))!=='' ? ($t1 . ( ' ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclusions/inc-rubrique_article') . ', array(\'id_rubrique\' => ' . argumenter_squelette($Pile[$SP]['id_rubrique']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . '), array("compil"=>array(\'plugins/auto/escal/inclusions/inc-une_derniers.html\',\'html_101d8c2bfc052560e5fb0b951f33b111\',\'\',63,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'>')) : '') . ' <!-- affichage logo --> ' . filtrer('image_graver',filtrer('image_reduire',quete_html_logo(quete_logo('id_article', 'ON', $Pile[$SP]['id_article'], $Pile[$SP]['id_rubrique']), '', ''),'0',interdire_scripts((include_spip('inc/config')?lire_config('escal/config/taillelogoartexergue','100',false):'')))) . ' <!-- affichage surtitre --> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/surtitreune',null,false):'') == 'non')) ?'' :' '))))!=='' ? ($t1 . ( ' <div class="surtitre-article ">' . interdire_scripts(typo($Pile[$SP]['surtitre'], "TYPO", $connect, $Pile[0])) . '</div> ')) : '') . ' <!-- affichage titre --> <div class="titre "> <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="' . (!((spip_htmlentities($Pile[$SP]['lang'] ? $Pile[$SP]['lang'] : $GLOBALS['spip_lang']) == 'ja')) ? (' ' . _T('public|spip|ecrire:par_auteur')) : '') . ' ' . BOUCLE_auteurshtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' ' . (((spip_htmlentities($Pile[$SP]['lang'] ? $Pile[$SP]['lang'] : $GLOBALS['spip_lang']) == 'ja')) ? (' ' . _T('public|spip|ecrire:par_auteur')) : '') . ' ' . _T('escal:le') . ' ' . interdire_scripts(affdate(normaliser_date($Pile[$SP]['date']))) . '"> ' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . ' </a> </div> <!-- affichage soustitre --> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/soustitreune',null,false):'') == 'non')) ?'' :' '))))!=='' ? ($t1 . ( ' <div class="soustitre-article ">' . interdire_scripts(typo($Pile[$SP]['soustitre'], "TYPO", $connect, $Pile[0])) . '</div> ')) : '') . ' <!-- affichage auteur --> ' . (($t1 = BOUCLE_testhtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? ($t1 . ( ' <div class="auteur-articles-rubrique"> ' . (!((spip_htmlentities($Pile[$SP]['lang'] ? $Pile[$SP]['lang'] : $GLOBALS['spip_lang']) == 'ja')) ? (' ' . _T('public|spip|ecrire:par_auteur')) : '') . ' ' . BOUCLE_auteurs_arthtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' ' . (((spip_htmlentities($Pile[$SP]['lang'] ? $Pile[$SP]['lang'] : $GLOBALS['spip_lang']) == 'ja')) ? (' ' . _T('public|spip|ecrire:par_auteur')) : '') . ' </div> ')) : '') . ' <!-- affichage date de publication --> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/datepubune',null,false):'') == 'non')) ?'' :' '))))!=='' ? ($t1 . ( ' <div class="date-articles-rubrique">' . (($t2 = strval(interdire_scripts(affdate(normaliser_date($Pile[$SP]['date'])))))!=='' ? (( _T('escal:article_mise_en_ligne') . ' <span class="majuscules">') . $t2 . '</span>') : '') . ' </div> ')) : '') . ' <!-- affichage date derniere modification --> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/datemodifune',null,false):'') == 'non')) ?'' :' '))))!=='' ? ($t1 . ( ' <div class="date-articles-rubrique">' . ((affdate(normaliser_date($Pile[$SP]['date_modif'])) !== interdire_scripts(affdate(normaliser_date($Pile[$SP]['date'])))) ? (($t3 = strval(affdate(normaliser_date($Pile[$SP]['date_modif']))))!=='' ? (( _T('escal:article_modifie') . ' ') . $t3) : ''):'') . '</div> ')) : '') . ' <!-- affichage descriptif --> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/descriptifune',null,false):'') == 'non')) ?'' :' '))))!=='' ? ($t1 . ( ' <div class="descriptif-article ">' . interdire_scripts(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])) . '</div> ')) : '') . ' <!-- affichage chapeau --> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/chapeauune',null,false):'') == 'non')) ?'' :' '))))!=='' ? ($t1 . ( ' <div class="chapo ">' . interdire_scripts(propre($Pile[$SP]['chapo'], $connect, $Pile[0])) . '</div> ')) : '') . ' <!-- affichage premiere image --> <div class="image-une" > ' . (($t1 = BOUCLE_imagehtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . BOUCLE_image_althtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' '))) . ' </div> <!-- affichage texte --> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/texteune',null,false):'') == 'non')) ?'' :' '))))!=='' ? ($t1 . ( ' <div class="texte "> ' . (($t2 = strval(interdire_scripts(((filtre_info_plugin_dist("COUTEAU_SUISSE", "est_actif")) ?'' :' '))))!=='' ? ($t2 . ( ' ' . interdire_scripts(propre(couper(propre($Pile[$SP]['texte'], $connect, $Pile[0]),interdire_scripts((include_spip('inc/config')?lire_config('escal/config/tailletexteune','300',false):''))))) . ' ')) : '') . ' ' . (($t2 = strval(interdire_scripts(((filtre_info_plugin_dist("COUTEAU_SUISSE", "est_actif")) ?' ' :''))))!=='' ? ($t2 . ( ' ' . interdire_scripts(propre(couper(appliquer_filtre($Pile[$SP]['texte'],'cs_traitements','TEXTE','articles','sommaire_d_article'),interdire_scripts((include_spip('inc/config')?lire_config('escal/config/tailletexteune','300',false):''))))) . ' ')) : '') . ' </div> ')) : '') . ' <div class="nettoyeur"></div> <div class="suite"> <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])))) . '" aria-label="' . _T('escal:lire_tout') . ' \'' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '\'"> <strong> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/texteune',null,false):'') == 'non')) ?'' :' '))))!=='' ? ($t1 . _T('escal:lire_suite')) : '') . ' ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/texteune',null,false):'') == 'non')) ?' ' :''))))!=='' ? ($t1 . _T('escal:lire_article')) : '') . ' </strong> </a> </div> </div> '); 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_dernier_endate @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_testauteurhtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/auteuruneautres',null,false):'') == 'non')) ?'' :' ')); if (!isset($command['table'])) { $command['table'] = 'auteurs'; $command['id'] = '_testauteur'; $command['from'] = array('auteurs' => 'spip_auteurs','L1' => 'spip_auteurs_liens'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("count(*)"); $command['orderby'] = array(); $command['join'] = array('L1' => array('auteurs','id_auteur')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('auteurs.statut','!5poubelle','!5poubelle',''), array('=', 'L1.id_objet', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL DEFAULT \'0\'')), array('=', 'L1.objet', sql_quote('article'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_testauteur',173,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $Numrows['_testauteur']['command'] = $command; $Numrows['_testauteur']['total'] = @intval($iter->count()); $SP++; // RESULTATS $t0 = str_repeat(' ', $Numrows['_testauteur']['total']); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_testauteur @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_auteurs_art2html_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'auteurs'; $command['id'] = '_auteurs_art2'; $command['from'] = array('auteurs' => 'spip_auteurs','L1' => 'spip_auteurs_liens'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("auteurs.nom", "auteurs.lang"); $command['orderby'] = array(); $command['join'] = array('L1' => array('auteurs','id_auteur')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('auteurs.statut','!5poubelle','!5poubelle',''), array('=', 'L1.id_objet', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL DEFAULT \'0\'')), array('=', 'L1.objet', sql_quote('article'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_auteurs_art2',177,$GLOBALS['spip_lang']) ); if (!$iter->err()) { lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { lang_select_public($Pile[$SP]['lang'], 'oui'); $t1 = interdire_scripts(safehtml(supprimer_numero(typo($Pile[$SP]['nom'], "TYPO", $connect, $Pile[0])))); $t0 .= ((strlen($t1) && strlen($t0)) ? ', ' : '') . $t1; 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_auteurs_art2 @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_Rub_suitehtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/affichrubrique',null,false):'') == 'non')) ?'' :' ')); if (!isset($command['table'])) { $command['table'] = 'rubriques'; $command['id'] = '_Rub_suite'; $command['from'] = array('rubriques' => 'spip_rubriques'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("rubriques.titre", "rubriques.lang"); $command['orderby'] = array(); $command['join'] = array(); $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(21) NOT NULL AUTO_INCREMENT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_Rub_suite',183,$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 .= ( ' <span class="rubrique-autres"> ' . _T('public|spip|ecrire:rubrique') . ' : ' . interdire_scripts(couper(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0])),'30')) . ' </span> <br /> '); 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_Rub_suite @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_descriptif_arthtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/affichdescriptif',null,false):'') == 'oui')) ?' ' :'')); if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_descriptif_art'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("articles.descriptif", "articles.lang", "articles.titre"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), array('=', 'articles.id_article', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL AUTO_INCREMENT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_descriptif_art',192,$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 .= ( ' ' . (($t1 = strval(interdire_scripts(propre($Pile[$SP]['descriptif'], $connect, $Pile[0]))))!=='' ? ('<span class="descriptif-autres"> ' . $t1 . ' </span>') : '') . ' '); 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_descriptif_art @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_chapo_arthtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/affichchapo',null,false):'') == 'oui')) ?' ' :'')); if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_chapo_art'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("articles.chapo", "articles.lang", "articles.titre"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), array('=', 'articles.id_article', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL AUTO_INCREMENT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_chapo_art',198,$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 .= ( ' ' . (($t1 = strval(interdire_scripts(propre($Pile[$SP]['chapo'], $connect, $Pile[0]))))!=='' ? ('<span class="chapo-autres"> ' . $t1 . ' </span>') : '') . ' '); 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_chapo_art @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_textearthtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/affichtextederniersart',null,false):'') == 'oui')) ?' ' :'')); if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_texteart'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("articles.texte", "articles.lang", "articles.titre"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), array('=', 'articles.id_article', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL AUTO_INCREMENT'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_texteart',204,$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 .= ( ' <span class="texte-autres"> ' . (($t1 = strval(interdire_scripts(((filtre_info_plugin_dist("COUTEAU_SUISSE", "est_actif")) ?' ' :''))))!=='' ? ($t1 . ( ' ' . interdire_scripts(couper(appliquer_filtre($Pile[$SP]['texte'],'cs_traitements','TEXTE','articles','sommaire_d_article'),interdire_scripts((include_spip('inc/config')?lire_config('escal/config/nbrecaracttexte','150',false):'')))) . ' ')) : '') . ' ' . (($t1 = strval(interdire_scripts(((filtre_info_plugin_dist("COUTEAU_SUISSE", "est_actif")) ?'' :' '))))!=='' ? ($t1 . ( ' ' . interdire_scripts(couper(propre($Pile[$SP]['texte'], $connect, $Pile[0]),interdire_scripts((include_spip('inc/config')?lire_config('escal/config/nbrecaracttexte','150',false):'')))) . ' ')) : '') . ' </span> '); 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_texteart @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_nbre_commhtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'forum'; $command['id'] = '_nbre_comm'; $command['from'] = array('forum' => 'spip_forum'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("count(*)"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('forum.statut','publie,prop','publie',''), array('=', 'forum.id_objet', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL DEFAULT \'0\'')), array('=', 'forum.objet', sql_quote('article'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_nbre_comm',222,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $Numrows['_nbre_comm']['command'] = $command; $Numrows['_nbre_comm']['total'] = @intval($iter->count()); $SP++; // RESULTATS $t0 = str_repeat(' ', $Numrows['_nbre_comm']['total']); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_nbre_comm @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_commenthtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($si_init)) { $command['si'] = array(); $si_init = true; } $command['si'][] = interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/affichcomm',null,false):'') == 'oui')) ?' ' :'')); if (!isset($command['table'])) { $command['table'] = 'forum'; $command['id'] = '_comment'; $command['from'] = array('forum' => 'spip_forum'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("forum.id_objet AS id_article"); $command['orderby'] = array(); $command['join'] = array(); $command['limit'] = '0,1'; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('forum.statut','publie,prop','publie',''), array('=', 'forum.id_parent', 0), array('=', 'forum.id_objet', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL DEFAULT \'0\'')), array('=', 'forum.objet', sql_quote('article'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_comment',221,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $l1 = _T('escal:commentaires');$SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( ' ' . (($t1 = BOUCLE_nbre_commhtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? ($t1 . ( ' <span class="commentaires"> ' . ($Numrows['_nbre_comm']['total'] ?? 0) . ' ' . $l1 . ' </span> ')) : '') . ' '); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_comment @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_autres_articles_unehtml_101d8c2bfc052560e5fb0b951f33b111(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); static $champs__autres_articles_une = array('id_article','surtitre','titre','soustitre','id_rubrique','descriptif','chapo','texte','ps','date','statut','id_secteur','maj','export','date_redac','visites','referers','popularite','accepter_forum','date_modif','lang','langue_choisie','id_trad','nom_site','url_site','virtuel','microblog','pouet'); // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'articles'.'selection2'])) { $doublons[$d] = ''; } if (!isset($command['table'])) { $command['table'] = 'articles'; $command['id'] = '_autres_articles_une'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("articles.id_article", "articles.id_rubrique", "rand() AS hasard", "articles.id_secteur", "articles.titre", "articles.date_modif", "articles.date", "articles.lang"); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['orderby'] = array((($x = preg_replace("/\W/",'', interdire_scripts((include_spip('inc/config')?lire_config('escal/config/ordrealaune','date',false):'')))) ? (in_array($x, $champs__autres_articles_une) ? ('articles.' . $x) :($x)) : '') . ' DESC'); $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), quete_condition_postdates('articles.date',''), array(sql_in('articles.id_article', $doublons[('articles'.'selection2')], ''))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = Spip\Compilateur\Iterateur\Factory::create( "SQL", $command, array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_101d8c2bfc052560e5fb0b951f33b111','_autres_articles_une',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_article']; // doublons lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <li class="rub' . $Pile[$SP]['id_rubrique'] . ' secteur' . $Pile[$SP]['id_secteur'] . '"> <!-- affichage mots-clés associés --> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/motsclesune',null,false):'') == 'oui')) ?' ' :''))))!=='' ? ($t1 . ( ' ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclusions/inc-mots_cles') . ', array(\'id_article\' => ' . argumenter_squelette($Pile[$SP]['id_article']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . '), array("compil"=>array(\'plugins/auto/escal/inclusions/inc-une_derniers.html\',\'html_101d8c2bfc052560e5fb0b951f33b111\',\'\',158,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'> ')) : '') . ' <a href="' . spip_htmlspecialchars(sinon($GLOBALS['meta']['adresse_site'],'.')) . '#section-' . $Pile[$SP]['id_article'] . '" tabindex="' . $Pile[$SP]['id_article'] . '" title="' . _T('escal:article_une') . '" onclick="javascript:self.location.assign(\'#onglet\')"> <!-- affichage logo --> ' . filtrer('image_graver',filtrer('image_reduire',quete_html_logo(quete_logo('id_article', 'ON', $Pile[$SP]['id_article'], $Pile[$SP]['id_rubrique']), '', ''),'0',interdire_scripts((include_spip('inc/config')?lire_config('escal/config/taillelogoartune','80',false):'')))) . ' <!-- affichage titre --> <span class="titre-autres">' . interdire_scripts(couper(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0])),interdire_scripts((include_spip('inc/config')?lire_config('escal/config/nbrecaracttitre','27',false):'')))) . '</span><br /> <!-- affichage date de publication ou de derniere modification --> ' . (($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/dateuneautres',null,false):'') == 'non')) ?'' :' '))))!=='' ? ($t1 . ( ' <span class="date-autres"> ' . ((affdate(normaliser_date($Pile[$SP]['date_modif'])) !== interdire_scripts(affdate(normaliser_date($Pile[$SP]['date'])))) ? affdate(normaliser_date($Pile[$SP]['date_modif'])):interdire_scripts(affdate(normaliser_date($Pile[$SP]['date'])))) . ' <br /> </span> ')) : '') . ' <!-- affichage auteur --> ' . (($t1 = BOUCLE_testauteurhtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? ($t1 . ( ' <span class="auteur-autres"> ' . (!((spip_htmlentities($Pile[$SP]['lang'] ? $Pile[$SP]['lang'] : $GLOBALS['spip_lang']) == 'ja')) ? (' ' . _T('public|spip|ecrire:par_auteur')) : '') . ' ' . BOUCLE_auteurs_art2html_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' ' . (((spip_htmlentities($Pile[$SP]['lang'] ? $Pile[$SP]['lang'] : $GLOBALS['spip_lang']) == 'ja')) ? (' ' . _T('public|spip|ecrire:par_auteur')) : '') . ' <br /> </span> ')) : '') . ' <!-- affichage rubrique --> ' . BOUCLE_Rub_suitehtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' <br /> <div class="nettoyeur"></div> <!-- affichage descriptif --> ' . BOUCLE_descriptif_arthtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' <!-- affichage descriptif --> ' . BOUCLE_chapo_arthtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' <!-- affichage texte article --> ' . BOUCLE_textearthtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' <br /> <!-- affichage nombre de commentaires --> ' . BOUCLE_commenthtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' </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_autres_articles_une @ plugins/auto/escal/inclusions/inc-une_derniers.html","profiler"._LOG_AVERTISSEMENT); return $t0; } // // Fonction principale du squelette plugins/auto/escal/inclusions/inc-une_derniers.html // Temps de compilation total: 5.635 ms // function html_101d8c2bfc052560e5fb0b951f33b111($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 = ( '<script src="' . find_in_path((string)'scripts/jquery.tabs.pack.js') . '"></script> <script src="https://code.jquery.com/jquery-migrate-3.3.2.js"></script> <script> $(document).ready(function(){ // La une $(\'.launemov\').tabs({ fxSlide: true, fxFade: true, fxSpeed: \'slow\' }); }); </script> <nav class="laune launemov one" > <!-- on extrait tous les articles des rubriques a qui un a donné le mot-cle "pas-a-la-une" ou "invisible" on les stocke dans "doublons" on n\'affiche rien ici --> ' . BOUCLE_exclure_rubhtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' ' . BOUCLE_exclure_arthtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' <!-- si le bloc "Annonce" ou "Annonces défilantes" sont activés on extrait tous les articles a qui on a donné le mot-cle "annonce" ou "annonce-defilant" on les stocke dans "doublons annonce" pour qu\'ils ne s\'affichent pas en exergue et on n\'affiche rien ici --> ' . BOUCLE_exclure_annonce1html_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' ' . BOUCLE_exclure_annonce2html_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' ' . BOUCLE_exclure_annonce3html_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' ' . BOUCLE_exclure_annoncedef1html_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' ' . BOUCLE_exclure_annoncedef2html_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' ' . BOUCLE_exclure_annoncedef3html_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' <!-- On selectionne les 11 articles les + recents --> ' . vide($Pile['vars'][$_zzz=(string)'nombrealaune'] = interdire_scripts((include_spip('inc/config')?lire_config('escal/config/nombrealaune','11',false):''))) . BOUCLE_selectionhtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' <!-- On affiche les 11 articles selectionnes et seul le premier est affiche les autres sont masques par un javascript --> ' . BOUCLE_dernier_endatehtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP) . ' <hr /> <!-- On affiche les 10 autres articles celui sélectionné ne s\'affiche pas sauf au premier affichage de la page --> ' . (($t1 = BOUCLE_autres_articles_unehtml_101d8c2bfc052560e5fb0b951f33b111($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? (' <ul class="anchors"> ' . $t1 . ' </ul> ') : '') . ' </nav><!-- fin laune --> '); return analyse_resultat_skel('html_101d8c2bfc052560e5fb0b951f33b111', $Cache, $page, 'plugins/auto/escal/inclusions/inc-une_derniers.html'); }