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/genius/tmp/cache/skel/ |
<?php
/*
* Squelette : plugins/auto/escal/inclusions/inc-top.html
* Date : Wed, 30 Aug 2023 22:26:43 GMT
* Compile : Wed, 30 Aug 2023 22:29:07 GMT
* Boucles : _extract, _extract2, _exclure_rub2, _exclure_rub, _exclure_art, _affichage_articles
*/
function BOUCLE_extracthtml_0b984ef701feb7c80a32bf7ab93a6b15(&$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-top.html','html_0b984ef701feb7c80a32bf7ab93a6b15','_extract',15,$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-top.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_extract2html_0b984ef701feb7c80a32bf7ab93a6b15(&$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-top.html','html_0b984ef701feb7c80a32bf7ab93a6b15','_extract2',18,$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-top.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_exclure_rub2html_0b984ef701feb7c80a32bf7ab93a6b15(&$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-top.html','html_0b984ef701feb7c80a32bf7ab93a6b15','_exclure_rub2',17,$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_0b984ef701feb7c80a32bf7ab93a6b15($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-top.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_exclure_rubhtml_0b984ef701feb7c80a32bf7ab93a6b15(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
$in = array();
$in[]= 'forum';
$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-top.html','html_0b984ef701feb7c80a32bf7ab93a6b15','_exclure_rub',14,$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_0b984ef701feb7c80a32bf7ab93a6b15($Cache, $Pile, $doublons, $Numrows, $SP) .
'
' .
BOUCLE_exclure_rub2html_0b984ef701feb7c80a32bf7ab93a6b15($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-top.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_exclure_arthtml_0b984ef701feb7c80a32bf7ab93a6b15(&$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'] = '_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['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', "'invisible'"),
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-top.html','html_0b984ef701feb7c80a32bf7ab93a6b15','_exclure_art',22,$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-top.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_affichage_articleshtml_0b984ef701feb7c80a32bf7ab93a6b15(&$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'] = '_affichage_articles';
$command['from'] = array('articles' => 'spip_articles');
$command['type'] = array();
$command['groupby'] = array();
$command['select'] = array("articles.visites",
"articles.id_article",
"articles.descriptif",
"articles.titre",
"articles.lang");
$command['orderby'] = array('articles.visites DESC');
$command['join'] = array();
$command['having'] =
array();
}
$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')], 'NOT')));
$command['limit'] = '0'.','.intval(table_valeur($Pile["vars"]??[], (string)'nombretop', 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-top.html','html_0b984ef701feb7c80a32bf7ab93a6b15','_affichage_articles',28,$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>
<a href="' .
interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))))) .
'" title="' .
interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) .
'">' .
interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) .
'</a>
<div class="popularite"> (' .
_T('escal:vu') .
' <strong>' .
interdire_scripts($Pile[$SP]['visites']) .
'</strong> ' .
_T('escal:fois') .
')</div>
</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_affichage_articles @ plugins/auto/escal/inclusions/inc-top.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
//
// Fonction principale du squelette plugins/auto/escal/inclusions/inc-top.html
// Temps de compilation total: 0.927 ms
//
function html_0b984ef701feb7c80a32bf7ab93a6b15($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 = (
'<aside>
<h1 class="cadre top">
' .
(($t1 = strval(interdire_scripts((((include_spip('inc/config')?lire_config('escal/config/titretop',null,false):'')) ?' ' :''))))!=='' ?
($t1 . ( '
' .
interdire_scripts(PtoBR(_T_ou_typo(propre((include_spip('inc/config')?lire_config('escal/config/titretop',null,false):''))))) .
'
')) :
'') .
'
' .
(($t1 = strval(interdire_scripts((((include_spip('inc/config')?lire_config('escal/config/titretop',null,false):'')) ?'' :' '))))!=='' ?
($t1 . ( '
' .
_T('escal:articles_plus_vus') .
'
')) :
'') .
'
</h1>
<div class="texte top ' .
(($t1 = strval(interdire_scripts(((((include_spip('inc/config')?lire_config('escal/config/toggletop',null,false):'') == 'oui')) ?' ' :''))))!=='' ?
($t1 . 'toggle') :
'') .
'" >
<!-- exclusion des articles avec le mot-clé"invisible" -->
' .
BOUCLE_exclure_rubhtml_0b984ef701feb7c80a32bf7ab93a6b15($Cache, $Pile, $doublons, $Numrows, $SP) .
'
' .
BOUCLE_exclure_arthtml_0b984ef701feb7c80a32bf7ab93a6b15($Cache, $Pile, $doublons, $Numrows, $SP) .
'
' .
vide($Pile['vars'][$_zzz=(string)'nombretop'] = interdire_scripts((include_spip('inc/config')?lire_config('escal/config/nombretop','5',false):''))) .
(($t1 = BOUCLE_affichage_articleshtml_0b984ef701feb7c80a32bf7ab93a6b15($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
('
<ul>
' . $t1 . '
</ul>
') :
'') .
'
</div>
</aside> ');
return analyse_resultat_skel('html_0b984ef701feb7c80a32bf7ab93a6b15', $Cache, $page, 'plugins/auto/escal/inclusions/inc-top.html');
}