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/petits/tmp/cache/skel/ |
<?php
/*
* Squelette : plugins/auto/escal/inclusions/inc-une_derniers.html
* Date : Mon, 08 May 2023 19:03:37 GMT
* Compile : Mon, 08 May 2023 22:18:46 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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d($Cache, $Pile, $doublons, $Numrows, $SP) .
'
' .
BOUCLE_exclure_rub2html_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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','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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d\',\'\',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_212eb2a23de4457b825f8f9aa83b0d4d\',\'\',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), '', ''),'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_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
$t1 :
(( '
' .
BOUCLE_image_althtml_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d(&$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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_comment',221,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
$l1 = _T('escal:commentaires');$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
$t0 .= (
'
' .
(($t1 = BOUCLE_nbre_commhtml_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d(&$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','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 = IterFactory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-une_derniers.html','html_212eb2a23de4457b825f8f9aa83b0d4d','_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_212eb2a23de4457b825f8f9aa83b0d4d\',\'\',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), '', ''),'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_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d($Cache, $Pile, $doublons, $Numrows, $SP) .
'
<br />
<div class="nettoyeur"></div>
<!-- affichage descriptif -->
' .
BOUCLE_descriptif_arthtml_212eb2a23de4457b825f8f9aa83b0d4d($Cache, $Pile, $doublons, $Numrows, $SP) .
'
<!-- affichage descriptif -->
' .
BOUCLE_chapo_arthtml_212eb2a23de4457b825f8f9aa83b0d4d($Cache, $Pile, $doublons, $Numrows, $SP) .
'
<!-- affichage texte article -->
' .
BOUCLE_textearthtml_212eb2a23de4457b825f8f9aa83b0d4d($Cache, $Pile, $doublons, $Numrows, $SP) .
'
<br />
<!-- affichage nombre de commentaires -->
' .
BOUCLE_commenthtml_212eb2a23de4457b825f8f9aa83b0d4d($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.295 ms
//
function html_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d($Cache, $Pile, $doublons, $Numrows, $SP) .
'
' .
BOUCLE_exclure_arthtml_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d($Cache, $Pile, $doublons, $Numrows, $SP) .
'
' .
BOUCLE_exclure_annonce2html_212eb2a23de4457b825f8f9aa83b0d4d($Cache, $Pile, $doublons, $Numrows, $SP) .
'
' .
BOUCLE_exclure_annonce3html_212eb2a23de4457b825f8f9aa83b0d4d($Cache, $Pile, $doublons, $Numrows, $SP) .
'
' .
BOUCLE_exclure_annoncedef1html_212eb2a23de4457b825f8f9aa83b0d4d($Cache, $Pile, $doublons, $Numrows, $SP) .
'
' .
BOUCLE_exclure_annoncedef2html_212eb2a23de4457b825f8f9aa83b0d4d($Cache, $Pile, $doublons, $Numrows, $SP) .
'
' .
BOUCLE_exclure_annoncedef3html_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d($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_212eb2a23de4457b825f8f9aa83b0d4d($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
('
<ul class="anchors">
' . $t1 . '
</ul>
') :
'') .
'
</nav><!-- fin laune -->
');
return analyse_resultat_skel('html_212eb2a23de4457b825f8f9aa83b0d4d', $Cache, $page, 'plugins/auto/escal/inclusions/inc-une_derniers.html');
}
?>