Server : Apache System : Linux ks5.tuic.fr 6.1.0-18-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.76-1 (2024-02-01) x86_64 User : pragmatice ( 1003) PHP Version : 8.2.24 Disable Function : NONE Directory : /home/pragmatice/public_html/lesite/tmp/cache/skel/ |
<?php
/*
* Squelette : squelettes/inclure/inc-elements_recherche.html
* Date : Sun, 01 Jan 2023 17:24:41 GMT
* Compile : Wed, 13 Mar 2024 21:17:26 GMT
* Boucles : _articles, _rubriques, _mots, _breves, _messages, _sites
*/
function BOUCLE_articleshtml_453462712e8d374e12dfb32a3cdf8437(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
$in = array();
$in[]= 1;
$in[]= 2;
$in[]= 3;
// RECHERCHE
{
$prepare_recherche = charger_fonction('prepare_recherche', 'inc');
list($rech_select, $rech_where) = $prepare_recherche((isset($Pile[0]["recherche"])?$Pile[0]["recherche"]:(isset($GLOBALS["recherche"])?$GLOBALS["recherche"]:"")), "articles", "","",array (
),"id_article");
}
$command['pagination'] = array((isset($Pile[0]['debut_articles']) ? $Pile[0]['debut_articles'] : null), 10);if (!defined('_DIR_PLUGIN_ACCESRESTREINT')) {
$link_empty = generer_url_ecrire('admin_vider'); $link_plugin = generer_url_ecrire('admin_plugin');
$message_fr = 'La restriction d\'accès a ete desactivée. <a href="'.$link_plugin.'">Corriger le problème</a> ou <a href="'.$link_empty.'">vider le cache</a> pour supprimer les restrictions.';
$message_en = 'Acces Restriction is now unusable. <a href="'.$link_plugin.'">Correct this trouble</a> or <a href="'.generer_url_ecrire('admin_vider').'">empty the cache</a> to finish restriction removal.';
die($message_fr.'<br />'.$message_en);
}
if (!isset($command['table'])) {
$command['table'] = 'articles';
$command['id'] = '_articles';
$command['from'] = array('articles' => 'spip_articles','resultats' => 'spip_resultats');
$command['type'] = array();
$command['groupby'] = array();
$command['orderby'] = array('resultats.points DESC');
$command['join'] = array('resultats' => array('articles','id','id_article'));
$command['limit'] = '';
$command['having'] =
array();
}
$command['select'] = array("articles.id_article",
"$rech_select",
"resultats.points",
"articles.titre",
"articles.id_secteur",
"articles.id_rubrique",
"articles.id_article",
"articles.lang");
$command['where'] =
array(
quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), $rech_where?$rech_where:'', sql_in('articles.id_secteur', $in,'NOT'), sql_in('articles.id_article', accesrestreint_liste_objets_exclus('articles', !test_espace_prive()), 'NOT'), sql_in('articles.id_rubrique', accesrestreint_liste_rubriques_exclues(!test_espace_prive()), 'NOT'));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = IterFactory::create(
"SQL",
$command,
array('squelettes/inclure/inc-elements_recherche.html','html_453462712e8d374e12dfb32a3cdf8437','_articles',9,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
// COMPTEUR
$Numrows['_articles']['compteur_boucle'] = 0;
$Numrows['_articles']['command'] = $command;
$Numrows['_articles']['total'] = @intval($iter->count());
$debut_boucle = isset($Pile[0]['debut_articles']) ? $Pile[0]['debut_articles'] : _request('debut_articles');
if ($debut_boucle && $debut_boucle[0] === '@') {
$debut_boucle = $Pile[0]['debut_articles'] = quete_debut_pagination('id_article',$Pile[0]['@id_article'] = substr($debut_boucle,1),10,$iter);
$iter->seek(0);
}
$debut_boucle = intval($debut_boucle);
$debut_boucle = (($tout=($debut_boucle == -1))?0:($debut_boucle));
$debut_boucle = max(0,min($debut_boucle,floor(($Numrows['_articles']['total']-1)/(10))*(10)));
$debut_boucle = intval($debut_boucle);
$fin_boucle = min(($tout ? $Numrows['_articles']['total'] : $debut_boucle + 9), $Numrows['_articles']['total'] - 1);
$Numrows['_articles']['grand_total'] = $Numrows['_articles']['total'];
$Numrows['_articles']["total"] = max(0,$fin_boucle - $debut_boucle + 1);
if ($debut_boucle>0 AND $debut_boucle < $Numrows['_articles']['grand_total'] AND $iter->seek($debut_boucle,'continue'))
$Numrows['_articles']['compteur_boucle'] = $debut_boucle;
lang_select($GLOBALS['spip_lang']);
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
$Numrows['_articles']['compteur_boucle']++;
if ($Numrows['_articles']['compteur_boucle'] <= $debut_boucle) continue;
if ($Numrows['_articles']['compteur_boucle']-1 > $fin_boucle) break;
lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']);
$t0 .= (
'
<li><a href="' .
vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))) .
'">' .
interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) .
'</a> <em>(' .
interdire_scripts(generer_objet_info($Pile[$SP]['id_secteur'], 'rubrique', 'titre', '', [])) .
')</em></li>
');
lang_select();
}
lang_select();
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_articles @ squelettes/inclure/inc-elements_recherche.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_rubriqueshtml_453462712e8d374e12dfb32a3cdf8437(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
// RECHERCHE
{
$prepare_recherche = charger_fonction('prepare_recherche', 'inc');
list($rech_select, $rech_where) = $prepare_recherche((isset($Pile[0]["recherche"])?$Pile[0]["recherche"]:(isset($GLOBALS["recherche"])?$GLOBALS["recherche"]:"")), "rubriques", "","",array (
),"id_rubrique");
}
$command['pagination'] = array((isset($Pile[0]['debut_rubriques']) ? $Pile[0]['debut_rubriques'] : null), 5);if (!defined('_DIR_PLUGIN_ACCESRESTREINT')) {
$link_empty = generer_url_ecrire('admin_vider'); $link_plugin = generer_url_ecrire('admin_plugin');
$message_fr = 'La restriction d\'accès a ete desactivée. <a href="'.$link_plugin.'">Corriger le problème</a> ou <a href="'.$link_empty.'">vider le cache</a> pour supprimer les restrictions.';
$message_en = 'Acces Restriction is now unusable. <a href="'.$link_plugin.'">Correct this trouble</a> or <a href="'.generer_url_ecrire('admin_vider').'">empty the cache</a> to finish restriction removal.';
die($message_fr.'<br />'.$message_en);
}
if (!isset($command['table'])) {
$command['table'] = 'rubriques';
$command['id'] = '_rubriques';
$command['from'] = array('rubriques' => 'spip_rubriques','resultats' => 'spip_resultats');
$command['type'] = array();
$command['groupby'] = array();
$command['orderby'] = array('resultats.points DESC');
$command['join'] = array('resultats' => array('rubriques','id','id_rubrique'));
$command['limit'] = '';
$command['having'] =
array();
}
$command['select'] = array("rubriques.id_rubrique",
"$rech_select",
"resultats.points",
"rubriques.titre",
"rubriques.id_rubrique",
"rubriques.lang");
$command['where'] =
array(
quete_condition_statut('rubriques.statut','!','publie',''), $rech_where?$rech_where:'', sql_in('rubriques.id_rubrique', accesrestreint_liste_rubriques_exclues(!test_espace_prive()), 'NOT'));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = IterFactory::create(
"SQL",
$command,
array('squelettes/inclure/inc-elements_recherche.html','html_453462712e8d374e12dfb32a3cdf8437','_rubriques',23,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
// COMPTEUR
$Numrows['_rubriques']['compteur_boucle'] = 0;
$Numrows['_rubriques']['command'] = $command;
$Numrows['_rubriques']['total'] = @intval($iter->count());
$debut_boucle = isset($Pile[0]['debut_rubriques']) ? $Pile[0]['debut_rubriques'] : _request('debut_rubriques');
if ($debut_boucle && $debut_boucle[0] === '@') {
$debut_boucle = $Pile[0]['debut_rubriques'] = quete_debut_pagination('id_rubrique',$Pile[0]['@id_rubrique'] = substr($debut_boucle,1),5,$iter);
$iter->seek(0);
}
$debut_boucle = intval($debut_boucle);
$debut_boucle = (($tout=($debut_boucle == -1))?0:($debut_boucle));
$debut_boucle = max(0,min($debut_boucle,floor(($Numrows['_rubriques']['total']-1)/(5))*(5)));
$debut_boucle = intval($debut_boucle);
$fin_boucle = min(($tout ? $Numrows['_rubriques']['total'] : $debut_boucle + 4), $Numrows['_rubriques']['total'] - 1);
$Numrows['_rubriques']['grand_total'] = $Numrows['_rubriques']['total'];
$Numrows['_rubriques']["total"] = max(0,$fin_boucle - $debut_boucle + 1);
if ($debut_boucle>0 AND $debut_boucle < $Numrows['_rubriques']['grand_total'] AND $iter->seek($debut_boucle,'continue'))
$Numrows['_rubriques']['compteur_boucle'] = $debut_boucle;
lang_select($GLOBALS['spip_lang']);
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
$Numrows['_rubriques']['compteur_boucle']++;
if ($Numrows['_rubriques']['compteur_boucle'] <= $debut_boucle) continue;
if ($Numrows['_rubriques']['compteur_boucle']-1 > $fin_boucle) break;
lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']);
$t0 .= (
'
<li><a href="' .
vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_rubrique'], 'rubrique', '', '', true))) .
'">' .
interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) .
'</a></li>
');
lang_select();
}
lang_select();
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_rubriques @ squelettes/inclure/inc-elements_recherche.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_motshtml_453462712e8d374e12dfb32a3cdf8437(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
// RECHERCHE
{
$prepare_recherche = charger_fonction('prepare_recherche', 'inc');
list($rech_select, $rech_where) = $prepare_recherche((isset($Pile[0]["recherche"])?$Pile[0]["recherche"]:(isset($GLOBALS["recherche"])?$GLOBALS["recherche"]:"")), "mots", "","",array (
),"id_mot");
}
$command['pagination'] = array((isset($Pile[0]['debut_mots']) ? $Pile[0]['debut_mots'] : null), 5);
if (!isset($command['table'])) {
$command['table'] = 'mots';
$command['id'] = '_mots';
$command['from'] = array('mots' => 'spip_mots','resultats' => 'spip_resultats');
$command['type'] = array();
$command['groupby'] = array();
$command['orderby'] = array('resultats.points DESC');
$command['join'] = array('resultats' => array('mots','id','id_mot'));
$command['limit'] = '';
$command['having'] =
array();
}
$command['select'] = array("mots.id_mot",
"$rech_select",
"resultats.points",
"mots.titre");
$command['where'] =
array($rech_where?$rech_where:'');
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = IterFactory::create(
"SQL",
$command,
array('squelettes/inclure/inc-elements_recherche.html','html_453462712e8d374e12dfb32a3cdf8437','_mots',37,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
// COMPTEUR
$Numrows['_mots']['compteur_boucle'] = 0;
$Numrows['_mots']['command'] = $command;
$Numrows['_mots']['total'] = @intval($iter->count());
$debut_boucle = isset($Pile[0]['debut_mots']) ? $Pile[0]['debut_mots'] : _request('debut_mots');
if ($debut_boucle && $debut_boucle[0] === '@') {
$debut_boucle = $Pile[0]['debut_mots'] = quete_debut_pagination('id_mot',$Pile[0]['@id_mot'] = substr($debut_boucle,1),5,$iter);
$iter->seek(0);
}
$debut_boucle = intval($debut_boucle);
$debut_boucle = (($tout=($debut_boucle == -1))?0:($debut_boucle));
$debut_boucle = max(0,min($debut_boucle,floor(($Numrows['_mots']['total']-1)/(5))*(5)));
$debut_boucle = intval($debut_boucle);
$fin_boucle = min(($tout ? $Numrows['_mots']['total'] : $debut_boucle + 4), $Numrows['_mots']['total'] - 1);
$Numrows['_mots']['grand_total'] = $Numrows['_mots']['total'];
$Numrows['_mots']["total"] = max(0,$fin_boucle - $debut_boucle + 1);
if ($debut_boucle>0 AND $debut_boucle < $Numrows['_mots']['grand_total'] AND $iter->seek($debut_boucle,'continue'))
$Numrows['_mots']['compteur_boucle'] = $debut_boucle;
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
$Numrows['_mots']['compteur_boucle']++;
if ($Numrows['_mots']['compteur_boucle'] <= $debut_boucle) continue;
if ($Numrows['_mots']['compteur_boucle']-1 > $fin_boucle) break;
$t0 .= (
'
<li><a href="' .
vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_mot'], 'mot', '', '', true))) .
'">' .
interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) .
'</a></li>
');
}
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_mots @ squelettes/inclure/inc-elements_recherche.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_breveshtml_453462712e8d374e12dfb32a3cdf8437(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
// RECHERCHE
{
$prepare_recherche = charger_fonction('prepare_recherche', 'inc');
list($rech_select, $rech_where) = $prepare_recherche((isset($Pile[0]["recherche"])?$Pile[0]["recherche"]:(isset($GLOBALS["recherche"])?$GLOBALS["recherche"]:"")), "breves", "","",array (
),"id_breve");
}
$command['pagination'] = array((isset($Pile[0]['debut_breves']) ? $Pile[0]['debut_breves'] : null), 5);if (!defined('_DIR_PLUGIN_ACCESRESTREINT')) {
$link_empty = generer_url_ecrire('admin_vider'); $link_plugin = generer_url_ecrire('admin_plugin');
$message_fr = 'La restriction d\'accès a ete desactivée. <a href="'.$link_plugin.'">Corriger le problème</a> ou <a href="'.$link_empty.'">vider le cache</a> pour supprimer les restrictions.';
$message_en = 'Acces Restriction is now unusable. <a href="'.$link_plugin.'">Correct this trouble</a> or <a href="'.generer_url_ecrire('admin_vider').'">empty the cache</a> to finish restriction removal.';
die($message_fr.'<br />'.$message_en);
}
if (!isset($command['table'])) {
$command['table'] = 'breves';
$command['id'] = '_breves';
$command['from'] = array('breves' => 'spip_breves','resultats' => 'spip_resultats');
$command['type'] = array();
$command['groupby'] = array();
$command['orderby'] = array('resultats.points DESC');
$command['join'] = array('resultats' => array('breves','id','id_breve'));
$command['limit'] = '';
$command['having'] =
array();
}
$command['select'] = array("breves.id_breve",
"$rech_select",
"resultats.points",
"breves.titre",
"breves.id_rubrique",
"breves.id_breve",
"breves.lang");
$command['where'] =
array(
quete_condition_statut('breves.statut','publie,prop','publie',''), $rech_where?$rech_where:'', sql_in('breves.id_breve', accesrestreint_liste_objets_exclus('breves', !test_espace_prive()), 'NOT'), sql_in('breves.id_rubrique', accesrestreint_liste_rubriques_exclues(!test_espace_prive()), 'NOT'));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = IterFactory::create(
"SQL",
$command,
array('squelettes/inclure/inc-elements_recherche.html','html_453462712e8d374e12dfb32a3cdf8437','_breves',51,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
// COMPTEUR
$Numrows['_breves']['compteur_boucle'] = 0;
$Numrows['_breves']['command'] = $command;
$Numrows['_breves']['total'] = @intval($iter->count());
$debut_boucle = isset($Pile[0]['debut_breves']) ? $Pile[0]['debut_breves'] : _request('debut_breves');
if ($debut_boucle && $debut_boucle[0] === '@') {
$debut_boucle = $Pile[0]['debut_breves'] = quete_debut_pagination('id_breve',$Pile[0]['@id_breve'] = substr($debut_boucle,1),5,$iter);
$iter->seek(0);
}
$debut_boucle = intval($debut_boucle);
$debut_boucle = (($tout=($debut_boucle == -1))?0:($debut_boucle));
$debut_boucle = max(0,min($debut_boucle,floor(($Numrows['_breves']['total']-1)/(5))*(5)));
$debut_boucle = intval($debut_boucle);
$fin_boucle = min(($tout ? $Numrows['_breves']['total'] : $debut_boucle + 4), $Numrows['_breves']['total'] - 1);
$Numrows['_breves']['grand_total'] = $Numrows['_breves']['total'];
$Numrows['_breves']["total"] = max(0,$fin_boucle - $debut_boucle + 1);
if ($debut_boucle>0 AND $debut_boucle < $Numrows['_breves']['grand_total'] AND $iter->seek($debut_boucle,'continue'))
$Numrows['_breves']['compteur_boucle'] = $debut_boucle;
lang_select($GLOBALS['spip_lang']);
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
$Numrows['_breves']['compteur_boucle']++;
if ($Numrows['_breves']['compteur_boucle'] <= $debut_boucle) continue;
if ($Numrows['_breves']['compteur_boucle']-1 > $fin_boucle) break;
lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']);
$t0 .= (
'
<li><a href="' .
vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_breve'], 'breve', '', '', true))) .
'">' .
interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) .
'</a></li>
');
lang_select();
}
lang_select();
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_breves @ squelettes/inclure/inc-elements_recherche.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_messageshtml_453462712e8d374e12dfb32a3cdf8437(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
// RECHERCHE
{
$prepare_recherche = charger_fonction('prepare_recherche', 'inc');
list($rech_select, $rech_where) = $prepare_recherche((isset($Pile[0]["recherche"])?$Pile[0]["recherche"]:(isset($GLOBALS["recherche"])?$GLOBALS["recherche"]:"")), "forum", "","",array (
),"id_forum");
}
$command['pagination'] = array((isset($Pile[0]['debut_messages']) ? $Pile[0]['debut_messages'] : null), 5);if (!defined('_DIR_PLUGIN_ACCESRESTREINT')) {
$link_empty = generer_url_ecrire('admin_vider'); $link_plugin = generer_url_ecrire('admin_plugin');
$message_fr = 'La restriction d\'accès a ete desactivée. <a href="'.$link_plugin.'">Corriger le problème</a> ou <a href="'.$link_empty.'">vider le cache</a> pour supprimer les restrictions.';
$message_en = 'Acces Restriction is now unusable. <a href="'.$link_plugin.'">Correct this trouble</a> or <a href="'.generer_url_ecrire('admin_vider').'">empty the cache</a> to finish restriction removal.';
die($message_fr.'<br />'.$message_en);
}
if (!isset($command['table'])) {
$command['table'] = 'forum';
$command['id'] = '_messages';
$command['from'] = array('forum' => 'spip_forum','resultats' => 'spip_resultats');
$command['type'] = array();
$command['groupby'] = array();
$command['orderby'] = array('resultats.points DESC');
$command['join'] = array('resultats' => array('forum','id','id_forum'));
$command['limit'] = '';
$command['having'] =
array();
}
$command['select'] = array("forum.id_forum",
"$rech_select",
"resultats.points",
"forum.texte",
"forum.titre",
"forum.id_forum");
$command['where'] =
array(
quete_condition_statut('forum.statut','publie,prop','publie',''),
array('=', 'forum.id_parent', 0), $rech_where?$rech_where:'', array('IN','forum.id_forum','(SELECT * FROM('.sql_get_select('zzzf.id_forum','spip_forum as zzzf',array(array('OR',array('OR',array('OR',array('AND','zzzf.objet=\'rubrique\'',sql_in('zzzf.id_objet', accesrestreint_liste_rubriques_exclues(!test_espace_prive()), 'NOT')),array('AND','zzzf.objet=\'article\'',array('AND', array('NOT IN','zzzf.id_objet','(SELECT * FROM('.sql_get_select('zzza.id_article','spip_articles as zzza',sql_in('zzza.id_rubrique', accesrestreint_liste_rubriques_exclues(!test_espace_prive()), ''), '', '', '', '',$connect).') AS subquery)'), sql_in('zzzf.id_objet', accesrestreint_liste_objets_exclus('articles', !test_espace_prive()), 'not')))),array('AND','zzzf.objet=\'breve\'',array('AND', array('NOT IN','zzzf.id_objet','(SELECT * FROM('.sql_get_select('zzzb.id_breve','spip_breves as zzzb',sql_in('zzzb.id_rubrique', accesrestreint_liste_rubriques_exclues(!test_espace_prive()), ''), '', '', '', '',$connect).') AS subquery)'), sql_in('zzzf.id_objet', accesrestreint_liste_objets_exclus('breves', !test_espace_prive()), 'not')))),sql_in('zzzf.objet',array('rubrique','article','breve'),'NOT',$connect))),'','','','',$connect).') AS subquery)'));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = IterFactory::create(
"SQL",
$command,
array('squelettes/inclure/inc-elements_recherche.html','html_453462712e8d374e12dfb32a3cdf8437','_messages',65,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
// COMPTEUR
$Numrows['_messages']['compteur_boucle'] = 0;
$Numrows['_messages']['command'] = $command;
$Numrows['_messages']['total'] = @intval($iter->count());
$debut_boucle = isset($Pile[0]['debut_messages']) ? $Pile[0]['debut_messages'] : _request('debut_messages');
if ($debut_boucle && $debut_boucle[0] === '@') {
$debut_boucle = $Pile[0]['debut_messages'] = quete_debut_pagination('id_forum',$Pile[0]['@id_forum'] = substr($debut_boucle,1),5,$iter);
$iter->seek(0);
}
$debut_boucle = intval($debut_boucle);
$debut_boucle = (($tout=($debut_boucle == -1))?0:($debut_boucle));
$debut_boucle = max(0,min($debut_boucle,floor(($Numrows['_messages']['total']-1)/(5))*(5)));
$debut_boucle = intval($debut_boucle);
$fin_boucle = min(($tout ? $Numrows['_messages']['total'] : $debut_boucle + 4), $Numrows['_messages']['total'] - 1);
$Numrows['_messages']['grand_total'] = $Numrows['_messages']['total'];
$Numrows['_messages']["total"] = max(0,$fin_boucle - $debut_boucle + 1);
if ($debut_boucle>0 AND $debut_boucle < $Numrows['_messages']['grand_total'] AND $iter->seek($debut_boucle,'continue'))
$Numrows['_messages']['compteur_boucle'] = $debut_boucle;
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
$Numrows['_messages']['compteur_boucle']++;
if ($Numrows['_messages']['compteur_boucle'] <= $debut_boucle) continue;
if ($Numrows['_messages']['compteur_boucle']-1 > $fin_boucle) break;
$t0 .= (
'
' .
(($t1 = strval(interdire_scripts(couper(liens_nofollow(safehtml(propre(interdit_html($Pile[$SP]['texte']), $connect, $Pile[0]))),'80'))))!=='' ?
(( '<li><a href="' .
vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_forum'], 'forum', '', '', true))) .
'"' .
(($t2 = strval(interdire_scripts(couper(attribut_html(liens_nofollow(safehtml(typo(interdit_html($Pile[$SP]['titre']), "TYPO", $connect, $Pile[0])))),'80'))))!=='' ?
(' title="' . $t2 . '"') :
'') .
'>') . $t1 . '</a></li>') :
'') .
'
');
}
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_messages @ squelettes/inclure/inc-elements_recherche.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_siteshtml_453462712e8d374e12dfb32a3cdf8437(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
// RECHERCHE
{
$prepare_recherche = charger_fonction('prepare_recherche', 'inc');
list($rech_select, $rech_where) = $prepare_recherche((isset($Pile[0]["recherche"])?$Pile[0]["recherche"]:(isset($GLOBALS["recherche"])?$GLOBALS["recherche"]:"")), "syndic", "","",array (
),"id_syndic");
}
$command['pagination'] = array((isset($Pile[0]['debut_sites']) ? $Pile[0]['debut_sites'] : null), 5);
if (!isset($command['table'])) {
$command['table'] = 'syndic';
$command['id'] = '_sites';
$command['from'] = array('syndic' => 'spip_syndic','resultats' => 'spip_resultats');
$command['type'] = array();
$command['groupby'] = array();
$command['orderby'] = array('resultats.points DESC');
$command['join'] = array('resultats' => array('syndic','id','id_syndic'));
$command['limit'] = '';
$command['having'] =
array();
}
$command['select'] = array("syndic.id_syndic",
"$rech_select",
"resultats.points",
"syndic.url_site",
"syndic.nom_site");
$command['where'] =
array(
quete_condition_statut('syndic.statut','publie,prop','publie',''), $rech_where?$rech_where:'');
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = IterFactory::create(
"SQL",
$command,
array('squelettes/inclure/inc-elements_recherche.html','html_453462712e8d374e12dfb32a3cdf8437','_sites',79,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
// COMPTEUR
$Numrows['_sites']['compteur_boucle'] = 0;
$Numrows['_sites']['command'] = $command;
$Numrows['_sites']['total'] = @intval($iter->count());
$debut_boucle = isset($Pile[0]['debut_sites']) ? $Pile[0]['debut_sites'] : _request('debut_sites');
if ($debut_boucle && $debut_boucle[0] === '@') {
$debut_boucle = $Pile[0]['debut_sites'] = quete_debut_pagination('id_syndic',$Pile[0]['@id_syndic'] = substr($debut_boucle,1),5,$iter);
$iter->seek(0);
}
$debut_boucle = intval($debut_boucle);
$debut_boucle = (($tout=($debut_boucle == -1))?0:($debut_boucle));
$debut_boucle = max(0,min($debut_boucle,floor(($Numrows['_sites']['total']-1)/(5))*(5)));
$debut_boucle = intval($debut_boucle);
$fin_boucle = min(($tout ? $Numrows['_sites']['total'] : $debut_boucle + 4), $Numrows['_sites']['total'] - 1);
$Numrows['_sites']['grand_total'] = $Numrows['_sites']['total'];
$Numrows['_sites']["total"] = max(0,$fin_boucle - $debut_boucle + 1);
if ($debut_boucle>0 AND $debut_boucle < $Numrows['_sites']['grand_total'] AND $iter->seek($debut_boucle,'continue'))
$Numrows['_sites']['compteur_boucle'] = $debut_boucle;
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
$Numrows['_sites']['compteur_boucle']++;
if ($Numrows['_sites']['compteur_boucle'] <= $debut_boucle) continue;
if ($Numrows['_sites']['compteur_boucle']-1 > $fin_boucle) break;
$t0 .= (
'
<li><a href="' .
generer_url_entite($Pile[$SP]['id_syndic'],'site','','',($connect ? $connect : NULL)) .
'">' .
interdire_scripts(typo(supprimer_numero(calculer_url($Pile[$SP]['url_site'],$Pile[$SP]['nom_site'], 'titre', $connect, false)), "TYPO", $connect, $Pile[0])) .
'</a></li>
');
}
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_sites @ squelettes/inclure/inc-elements_recherche.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
//
// Fonction principale du squelette squelettes/inclure/inc-elements_recherche.html
// Temps de compilation total: 6.785 ms
//
function html_453462712e8d374e12dfb32a3cdf8437($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 = (
'<div class="aplat3 rounded shadow">
' .
(($t1 = BOUCLE_articleshtml_453462712e8d374e12dfb32a3cdf8437($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
(( '
<div class="pave_autre">
' .
filtre_pagination_dist($Numrows["_articles"]["grand_total"],
'_articles',
isset($Pile[0]['debut_articles'])?$Pile[0]['debut_articles']:intval(_request('debut_articles')),
10, false, '', '', array()) .
'
<h2>' .
_T('public|spip|ecrire:articles') .
' (' .
($Numrows['_articles']['grand_total'] ?? $Numrows['_articles']['total'] ?? 0) .
')</h2>
<ul class="spip">
') . $t1 . ( '
</ul>
' .
(($t3 = strval(filtre_pagination_dist($Numrows["_articles"]["grand_total"],
'_articles',
isset($Pile[0]['debut_articles'])?$Pile[0]['debut_articles']:intval(_request('debut_articles')),
10, true, '', '', array())))!=='' ?
('<p class="pagination">' . $t3 . '</p>') :
'') .
'
</div>
')) :
'') .
'
' .
(($t1 = BOUCLE_rubriqueshtml_453462712e8d374e12dfb32a3cdf8437($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
(( '
<div class="pave_autre">
' .
filtre_pagination_dist($Numrows["_rubriques"]["grand_total"],
'_rubriques',
isset($Pile[0]['debut_rubriques'])?$Pile[0]['debut_rubriques']:intval(_request('debut_rubriques')),
5, false, '', '', array()) .
'
<h2>' .
_T('public|spip|ecrire:rubriques') .
' (' .
($Numrows['_rubriques']['grand_total'] ?? $Numrows['_rubriques']['total'] ?? 0) .
')</h2>
<ul class="spip">
') . $t1 . ( '
</ul>
' .
(($t3 = strval(filtre_pagination_dist($Numrows["_rubriques"]["grand_total"],
'_rubriques',
isset($Pile[0]['debut_rubriques'])?$Pile[0]['debut_rubriques']:intval(_request('debut_rubriques')),
5, true, '', '', array())))!=='' ?
('<p class="pagination">' . $t3 . '</p>') :
'') .
'
</div>
')) :
'') .
'
' .
(($t1 = BOUCLE_motshtml_453462712e8d374e12dfb32a3cdf8437($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
(( '
<div class="pave_autre">
' .
filtre_pagination_dist($Numrows["_mots"]["grand_total"],
'_mots',
isset($Pile[0]['debut_mots'])?$Pile[0]['debut_mots']:intval(_request('debut_mots')),
5, false, '', '', array()) .
'
<h2>' .
_T('public|spip|ecrire:mots_clefs') .
' (' .
($Numrows['_mots']['grand_total'] ?? $Numrows['_mots']['total'] ?? 0) .
')</h2>
<ul class="spip">
') . $t1 . ( '
</ul>
' .
(($t3 = strval(filtre_pagination_dist($Numrows["_mots"]["grand_total"],
'_mots',
isset($Pile[0]['debut_mots'])?$Pile[0]['debut_mots']:intval(_request('debut_mots')),
5, true, '', '', array())))!=='' ?
('<p class="pagination">' . $t3 . '</p>') :
'') .
'
</div>
')) :
'') .
'
' .
(($t1 = BOUCLE_breveshtml_453462712e8d374e12dfb32a3cdf8437($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
(( '
<div class="pave_autre">
' .
filtre_pagination_dist($Numrows["_breves"]["grand_total"],
'_breves',
isset($Pile[0]['debut_breves'])?$Pile[0]['debut_breves']:intval(_request('debut_breves')),
5, false, '', '', array()) .
'
<h2>' .
_T('breves:breves') .
' (' .
($Numrows['_breves']['grand_total'] ?? $Numrows['_breves']['total'] ?? 0) .
')</h2>
<ul class="spip">
') . $t1 . ( '
</ul>
' .
(($t3 = strval(filtre_pagination_dist($Numrows["_breves"]["grand_total"],
'_breves',
isset($Pile[0]['debut_breves'])?$Pile[0]['debut_breves']:intval(_request('debut_breves')),
5, true, '', '', array())))!=='' ?
('<p class="pagination">' . $t3 . '</p>') :
'') .
'
</div>
')) :
'') .
'
' .
(($t1 = BOUCLE_messageshtml_453462712e8d374e12dfb32a3cdf8437($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
(( '
<div class="pave_autre">
' .
filtre_pagination_dist($Numrows["_messages"]["grand_total"],
'_messages',
isset($Pile[0]['debut_messages'])?$Pile[0]['debut_messages']:intval(_request('debut_messages')),
5, false, '', '', array()) .
'
<h2>' .
_T('public|spip|ecrire:messages_forum') .
' (' .
($Numrows['_messages']['grand_total'] ?? $Numrows['_messages']['total'] ?? 0) .
')</h2>
<ul class="spip">
') . $t1 . ( '
</ul>
' .
(($t3 = strval(filtre_pagination_dist($Numrows["_messages"]["grand_total"],
'_messages',
isset($Pile[0]['debut_messages'])?$Pile[0]['debut_messages']:intval(_request('debut_messages')),
5, true, '', '', array())))!=='' ?
('<p class="pagination">' . $t3 . '</p>') :
'') .
'
</div>
')) :
'') .
'
' .
(($t1 = BOUCLE_siteshtml_453462712e8d374e12dfb32a3cdf8437($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
(( '
<div class="pave_autre">
' .
filtre_pagination_dist($Numrows["_sites"]["grand_total"],
'_sites',
isset($Pile[0]['debut_sites'])?$Pile[0]['debut_sites']:intval(_request('debut_sites')),
5, false, '', '', array()) .
'
<h2>' .
_T('public|spip|ecrire:sites_web') .
' (' .
($Numrows['_sites']['grand_total'] ?? $Numrows['_sites']['total'] ?? 0) .
')</h2>
<ul class="spip">
') . $t1 . ( '
</ul>
' .
(($t3 = strval(filtre_pagination_dist($Numrows["_sites"]["grand_total"],
'_sites',
isset($Pile[0]['debut_sites'])?$Pile[0]['debut_sites']:intval(_request('debut_sites')),
5, true, '', '', array())))!=='' ?
('<p class="pagination">' . $t3 . '</p>') :
'') .
'
</div>
')) :
'') .
'
</div><!-- fin du div aplat rounded shadow -->
');
return analyse_resultat_skel('html_453462712e8d374e12dfb32a3cdf8437', $Cache, $page, 'squelettes/inclure/inc-elements_recherche.html');
}
?>