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/chretien/tmp/cache/skel/ |
<?php
/*
* Squelette : plugins/auto/escal/inclusions/inc-nav_mots.html
* Date : Thu, 27 Jun 2024 20:34:20 GMT
* Compile : Thu, 27 Jun 2024 21:14:51 GMT
* Boucles : _test, _mots2, _groupe, _mots
*/
function BOUCLE_testhtml_350f22455658b9be70ae82cb8e6485b9(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
$doublons_index = array();
$in = array();
$in[]= 'affichage';
$in[]= 'trombino';
$in[]= 'type_rubrique';
$in[]= 'type_article';
$in[]= 'Agenda_couleur';
$in1 = array();
if (!(is_array($a = (($Pile[0]['id_mot'] ?? null)))))
$in1[]= $a;
else $in1 = array_merge($in1, $a);
// Initialise le(s) critère(s) doublons
if (!isset($doublons[$d = 'mots'])) { $doublons[$d] = ''; }
if (!isset($command['table'])) {
$command['table'] = 'mots';
$command['id'] = '_test';
$command['from'] = array('mots' => 'spip_mots','L1' => 'spip_mots_liens');
$command['type'] = array();
$command['groupby'] = array();
$command['select'] = array("mots.id_mot");
$command['orderby'] = array();
$command['join'] = array('L1' => array('mots','id_mot'));
$command['limit'] = '';
$command['having'] =
array();
}
$command['where'] =
array(
array('=', 'L1.id_objet', sql_quote(($Pile[0]['id_article'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')),
array('=', 'L1.objet', sql_quote('article')), sql_in('mots.type', $in,'NOT'), (!is_whereable(($Pile[0]['id_mot'] ?? null)) ? '' : ((is_array(($Pile[0]['id_mot'] ?? null))) ? sql_in('mots.id_mot', $in1) :
array('=', 'mots.id_mot', sql_quote(($Pile[0]['id_mot'] ?? null), '','bigint(21) NOT NULL AUTO_INCREMENT')))),
array(sql_in('mots.id_mot', $doublons[$doublons_index[]= ('mots')], '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-nav_mots.html','html_350f22455658b9be70ae82cb8e6485b9','_test',3,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_mot']; // doublons
$t0 .= '
';
}
$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-nav_mots.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_mots2html_350f22455658b9be70ae82cb8e6485b9(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
if (!isset($command['table'])) {
$command['table'] = 'mots';
$command['id'] = '_mots2';
$command['from'] = array('mots' => 'spip_mots','L1' => 'spip_mots_liens');
$command['type'] = array();
$command['groupby'] = array();
$command['select'] = array("0+mots.titre AS num",
"CASE ( 0+mots.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum",
"mots.titre",
"mots.id_mot");
$command['orderby'] = array('sinum, num', 'mots.titre');
$command['join'] = array('L1' => array('mots','id_mot'));
$command['limit'] = '';
$command['having'] =
array();
}
$command['where'] =
array(
array('=', 'mots.id_groupe', sql_quote($Pile[$SP]['id_groupe'], '','bigint(21) NOT NULL DEFAULT \'0\'')),
array('=', 'L1.id_objet', sql_quote(($Pile[0]['id_article'] ?? null), '','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-nav_mots.html','html_350f22455658b9be70ae82cb8e6485b9','_mots2',21,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
$l1 = _T('escal:articles_associes');$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
$t0 .= (
'
' .
(($t1 = strval(interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0])))))!=='' ?
(( '<a href="' .
parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_mot'], 'mot', '', '', true))),'lang',spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang'])) .
'" ' .
(($t2 = strval(interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0])))))!=='' ?
(( 'title="' .
$l1) . $t2 . '"') :
'') .
'>') . $t1 . '</a>') :
'') .
'
');
}
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_mots2 @ plugins/auto/escal/inclusions/inc-nav_mots.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_groupehtml_350f22455658b9be70ae82cb8e6485b9(&$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 = 'groupes_mots'])) { $doublons[$d] = ''; }
if (!isset($command['table'])) {
$command['table'] = 'groupes_mots';
$command['id'] = '_groupe';
$command['from'] = array('groupes_mots' => 'spip_groupes_mots');
$command['type'] = array();
$command['groupby'] = array();
$command['select'] = array("groupes_mots.id_groupe",
"groupes_mots.titre");
$command['orderby'] = array();
$command['join'] = array();
$command['limit'] = '';
$command['having'] =
array();
}
$command['where'] =
array(
array('=', 'groupes_mots.id_groupe', sql_quote($Pile[$SP]['id_groupe'], '','bigint(21) NOT NULL AUTO_INCREMENT')),
array(sql_in('groupes_mots.id_groupe', $doublons[$doublons_index[]= ('groupes_mots')], '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-nav_mots.html','html_350f22455658b9be70ae82cb8e6485b9','_groupe',19,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_groupe']; // doublons
$t0 .= (
'
' .
(($t1 = strval(interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0])))))!=='' ?
('<div class="titre-groupe">' . $t1 . ' :</div>') :
'') .
'
' .
BOUCLE_mots2html_350f22455658b9be70ae82cb8e6485b9($Cache, $Pile, $doublons, $Numrows, $SP) .
'
');
}
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_groupe @ plugins/auto/escal/inclusions/inc-nav_mots.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_motshtml_350f22455658b9be70ae82cb8e6485b9(&$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 = 'mots'])) { $doublons[$d] = ''; }
if (!isset($command['table'])) {
$command['table'] = 'mots';
$command['id'] = '_mots';
$command['from'] = array('mots' => 'spip_mots','L1' => 'spip_mots_liens');
$command['type'] = array();
$command['groupby'] = array();
$command['select'] = array("mots.id_groupe",
"mots.id_mot");
$command['orderby'] = array();
$command['join'] = array('L1' => array('mots','id_mot'));
$command['limit'] = '';
$command['having'] =
array();
}
$command['where'] =
array(
array('=', 'L1.id_objet', sql_quote(($Pile[0]['id_article'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')),
array('=', 'L1.objet', sql_quote('article')),
array(sql_in('mots.id_mot', $doublons[('mots')], '')));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = Spip\Compilateur\Iterateur\Factory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-nav_mots.html','html_350f22455658b9be70ae82cb8e6485b9','_mots',18,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_mot']; // doublons
$t0 .= (
'
' .
BOUCLE_groupehtml_350f22455658b9be70ae82cb8e6485b9($Cache, $Pile, $doublons, $Numrows, $SP) .
'
');
}
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_mots @ plugins/auto/escal/inclusions/inc-nav_mots.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
//
// Fonction principale du squelette plugins/auto/escal/inclusions/inc-nav_mots.html
// Temps de compilation total: 1.665 ms
//
function html_350f22455658b9be70ae82cb8e6485b9($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 = (
'<!-- on teste s\'il y a un mot-cle associé à l\'article
en excluant les mots des groupes de mot "techniques" utilises dans Escal-->
' .
(($t1 = BOUCLE_testhtml_350f22455658b9be70ae82cb8e6485b9($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
($t1 . ( '
<!-- si la boucle ne renvoie rien, rien ne s\'affiche
et si elle renvoie quelque chose, on affiche le cadre avec les groupes de mots et les mots -->
<nav>
<h1 class="cadre nav-mots">
' .
(($t3 = strval(interdire_scripts((((include_spip('inc/config')?lire_config('escal/config/titrenavmot',null,false):'')) ?' ' :''))))!=='' ?
($t3 . ( '
' .
interdire_scripts(PtoBR(_T_ou_typo(propre((include_spip('inc/config')?lire_config('escal/config/titrenavmot',null,false):''))))) .
'
')) :
'') .
'
' .
(($t3 = strval(interdire_scripts((((include_spip('inc/config')?lire_config('escal/config/titrenavmot',null,false):'')) ?'' :' '))))!=='' ?
($t3 . ( '
' .
_T('escal:mots_clefs_associes') .
'
')) :
'') .
'
</h1>
<div class="texte nav-mots" >
' .
BOUCLE_motshtml_350f22455658b9be70ae82cb8e6485b9($Cache, $Pile, $doublons, $Numrows, $SP) .
'
</div>
</nav>
')) :
'') .
'
');
return analyse_resultat_skel('html_350f22455658b9be70ae82cb8e6485b9', $Cache, $page, 'plugins/auto/escal/inclusions/inc-nav_mots.html');
}