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/recherchesecteur1.html * Date : Sun, 01 Jan 2023 17:24:09 GMT * Compile : Thu, 14 Mar 2024 18:03:32 GMT * Boucles : _nbartrub1, _mc1, _gp1, _mc_2, _gp2, _mc1bis, _mc2bis, _mcdusite, _lesmc1, _lesmc2, _lesart */ function BOUCLE_nbartrub1html_b0dc7dca1b7ae19050bb4fe0c287597b(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = '';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'] = '_nbartrub1'; $command['from'] = array('articles' => 'spip_articles'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("articles.id_rubrique", "articles.id_article"); $command['orderby'] = array(); $command['where'] = array( quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''), array('=', 'articles.id_rubrique', "1"), 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')); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/recherchesecteur1.html','html_b0dc7dca1b7ae19050bb4fe0c287597b','_nbartrub1',2,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $Numrows['_nbartrub1']['command'] = $command; $Numrows['_nbartrub1']['total'] = @intval($iter->count()); $SP++; // RESULTATS $t0 = str_repeat(' ', $Numrows['_nbartrub1']['total']); $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_nbartrub1 @ squelettes/recherchesecteur1.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_mc1html_b0dc7dca1b7ae19050bb4fe0c287597b(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'mots'; $command['id'] = '_mc1'; $command['from'] = array('mots' => 'spip_mots'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("mots.titre", "mots.id_mot"); $command['orderby'] = array('mots.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( array('=', 'mots.id_groupe', sql_quote($Pile[$SP]['id_groupe'], '','bigint(21) NOT NULL DEFAULT 0'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/recherchesecteur1.html','html_b0dc7dca1b7ae19050bb4fe0c287597b','_mc1',33,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( '<li><a id="mc_' . $Pile[$SP]['id_mot'] . '" href="' . interdire_scripts(parametre_url(parametre_url(generer_url_public('videos-classe', ''),'mc-g1',$Pile[$SP]['id_mot']),'mc-g2',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'mc-g2', null),true)))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . ' ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclure/inc-nb_art_mot') . ', array(\'id_mot\' => ' . argumenter_squelette($Pile[$SP]['id_mot']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . '), array("compil"=>array(\'squelettes/recherchesecteur1.html\',\'html_b0dc7dca1b7ae19050bb4fe0c287597b\',\'\',33,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'></a></li>'); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_mc1 @ squelettes/recherchesecteur1.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_gp1html_b0dc7dca1b7ae19050bb4fe0c287597b(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'groupes_mots'; $command['id'] = '_gp1'; $command['from'] = array('groupes_mots' => 'spip_groupes_mots'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("groupes_mots.id_groupe", "groupes_mots.descriptif"); $command['orderby'] = array(); $command['where'] = array( array('=', 'groupes_mots.id_groupe', "1")); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/recherchesecteur1.html','html_b0dc7dca1b7ae19050bb4fe0c287597b','_gp1',28,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( ' <h5>' . interdire_scripts(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0]))) . '</h5> <div class="pave_contenu"> <ul> <li><a href="' . interdire_scripts(parametre_url(parametre_url(generer_url_public('videos-classe', ''),'mc-g1',($Pile[0]['id_mot'] ?? null)),'mc-g2',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'mc-g2', null),true)))) . '">Tous les cycles ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclure/inc-nb_art_gpe') . ', array(\'id_groupe\' => ' . argumenter_squelette($Pile[$SP]['id_groupe']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . '), array("compil"=>array(\'squelettes/recherchesecteur1.html\',\'html_b0dc7dca1b7ae19050bb4fe0c287597b\',\'\',32,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'></a></li> ' . BOUCLE_mc1html_b0dc7dca1b7ae19050bb4fe0c287597b($Cache, $Pile, $doublons, $Numrows, $SP) . ' </ul> </div> '); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_gp1 @ squelettes/recherchesecteur1.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_mc_2html_b0dc7dca1b7ae19050bb4fe0c287597b(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'mots'; $command['id'] = '_mc_2'; $command['from'] = array('mots' => 'spip_mots'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("mots.titre", "mots.id_mot"); $command['orderby'] = array('mots.titre'); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( array('=', 'mots.id_groupe', sql_quote($Pile[$SP]['id_groupe'], '','bigint(21) NOT NULL DEFAULT 0'))); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/recherchesecteur1.html','html_b0dc7dca1b7ae19050bb4fe0c287597b','_mc_2',50,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( '<a href="' . interdire_scripts(parametre_url(parametre_url(generer_url_public('videos-classe', ''),'mc-g2',$Pile[$SP]['id_mot']),'mc-g1',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'mc-g1', null),true)))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . ' ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclure/inc-nb_art_mot') . ', array(\'id_mot\' => ' . argumenter_squelette($Pile[$SP]['id_mot']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . '), array("compil"=>array(\'squelettes/recherchesecteur1.html\',\'html_b0dc7dca1b7ae19050bb4fe0c287597b\',\'\',50,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'></a> - '); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_mc_2 @ squelettes/recherchesecteur1.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_gp2html_b0dc7dca1b7ae19050bb4fe0c287597b(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'groupes_mots'; $command['id'] = '_gp2'; $command['from'] = array('groupes_mots' => 'spip_groupes_mots'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("groupes_mots.id_groupe", "groupes_mots.descriptif"); $command['orderby'] = array(); $command['where'] = array( array('=', 'groupes_mots.id_groupe', "2")); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/recherchesecteur1.html','html_b0dc7dca1b7ae19050bb4fe0c287597b','_gp2',40,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( ' <h5>' . interdire_scripts(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0]))) . '</h5> <div class="pave_contenu"> <ul> <div style="text-align:center; margin:10px"> <a href="#" data-modal="#modal_choix_mc' . ($Pile[0]['id_rubrique'] ?? null) . '" class="btn btn-small module2">Choisir une catégorie</a> <div class="modal span9" id="modal_choix_mc' . ($Pile[0]['id_rubrique'] ?? null) . '"> <div class="modal-title"><h5>Choisir une catégorie de situation</h5> <div class="close">×</div></div> <div class="modal-content pave_forum"> <a href="' . interdire_scripts(parametre_url(parametre_url(generer_url_public('videos-classe', ''),'mc-g2',($Pile[0]['id_mot'] ?? null)),'mc-g1',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'mc-g1', null),true)))) . '">Toutes les catégories ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclure/inc-nb_art_gpe') . ', array(\'id_groupe\' => ' . argumenter_squelette($Pile[$SP]['id_groupe']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . '), array("compil"=>array(\'squelettes/recherchesecteur1.html\',\'html_b0dc7dca1b7ae19050bb4fe0c287597b\',\'\',49,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'></a> - ' . BOUCLE_mc_2html_b0dc7dca1b7ae19050bb4fe0c287597b($Cache, $Pile, $doublons, $Numrows, $SP) . ' </div> </div> </div> </ul> </div> '); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_gp2 @ squelettes/recherchesecteur1.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_mc1bishtml_b0dc7dca1b7ae19050bb4fe0c287597b(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'mots'; $command['id'] = '_mc1bis'; $command['from'] = array('mots' => 'spip_mots'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("mots.titre", "mots.id_mot"); $command['orderby'] = array('mots.titre'); $command['where'] = array( array('=', 'mots.id_groupe', "1")); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/recherchesecteur1.html','html_b0dc7dca1b7ae19050bb4fe0c287597b','_mc1bis',74,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( '<a href="' . interdire_scripts(parametre_url(parametre_url(generer_url_public('videos-classe', ''),'mc-g1',$Pile[$SP]['id_mot']),'mc-g2',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'mc-g2', null),true)))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . ' ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclure/inc-nb_art_mot') . ', array(\'id_mot\' => ' . argumenter_squelette($Pile[$SP]['id_mot']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . '), array("compil"=>array(\'squelettes/recherchesecteur1.html\',\'html_b0dc7dca1b7ae19050bb4fe0c287597b\',\'\',74,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'></a> - '); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_mc1bis @ squelettes/recherchesecteur1.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_mc2bishtml_b0dc7dca1b7ae19050bb4fe0c287597b(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'mots'; $command['id'] = '_mc2bis'; $command['from'] = array('mots' => 'spip_mots'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("mots.titre", "mots.id_mot"); $command['orderby'] = array('mots.titre'); $command['where'] = array( array('=', 'mots.id_groupe', "2")); $command['join'] = array(); $command['limit'] = ''; $command['having'] = array(); } if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/recherchesecteur1.html','html_b0dc7dca1b7ae19050bb4fe0c287597b','_mc2bis',76,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( '<a href="' . interdire_scripts(parametre_url(parametre_url(generer_url_public('videos-classe', ''),'mc-g2',$Pile[$SP]['id_mot']),'mc-g1',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'mc-g1', null),true)))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . ' ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclure/inc-nb_art_mot') . ', array(\'id_mot\' => ' . argumenter_squelette($Pile[$SP]['id_mot']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . '), array("compil"=>array(\'squelettes/recherchesecteur1.html\',\'html_b0dc7dca1b7ae19050bb4fe0c287597b\',\'\',76,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'></a> - '); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_mc2bis @ squelettes/recherchesecteur1.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_mcdusitehtml_b0dc7dca1b7ae19050bb4fe0c287597b(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'mots'; $command['id'] = '_mcdusite'; $command['from'] = array('mots' => 'spip_mots','L1' => 'spip_mots_liens'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("mots.titre", "mots.descriptif", "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[$SP]['id_article'], '','bigint(21) NOT NULL DEFAULT 0')), array('=', 'L1.objet', sql_quote('article')), array('=', 'mots.type', "'site-source'")); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/recherchesecteur1.html','html_b0dc7dca1b7ae19050bb4fe0c287597b','_mcdusite',115,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( '<a target="_blank" title="' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '" href="' . interdire_scripts(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0]))) . '">' . filtrer('image_graver',filtrer('image_reduire',inserer_attribut(quete_html_logo(quete_logo('id_mot', 'ON', $Pile[$SP]['id_mot'],'', 0), '', ''),'style','margin:0 10px 0 0'),'0','24')) . '</a>'); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_mcdusite @ squelettes/recherchesecteur1.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_lesmc1html_b0dc7dca1b7ae19050bb4fe0c287597b(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'mots'; $command['id'] = '_lesmc1'; $command['from'] = array('mots' => 'spip_mots','L1' => 'spip_mots_liens'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("mots.titre", "mots.id_mot"); $command['orderby'] = array('mots.titre'); $command['join'] = array('L1' => array('mots','id_mot')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( array('=', 'L1.id_objet', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL DEFAULT 0')), array('=', 'L1.objet', sql_quote('article')), array('=', 'mots.id_groupe', "1")); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/recherchesecteur1.html','html_b0dc7dca1b7ae19050bb4fe0c287597b','_lesmc1',126,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( '<a class="btn btn-small module1" style="margin-bottom:1px" href="' . interdire_scripts(parametre_url(generer_url_public('videos-classe', ''),'mc-g1',$Pile[$SP]['id_mot'])) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> '); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_lesmc1 @ squelettes/recherchesecteur1.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_lesmc2html_b0dc7dca1b7ae19050bb4fe0c287597b(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; if (!isset($command['table'])) { $command['table'] = 'mots'; $command['id'] = '_lesmc2'; $command['from'] = array('mots' => 'spip_mots','L1' => 'spip_mots_liens'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("mots.titre", "mots.id_mot"); $command['orderby'] = array('mots.titre'); $command['join'] = array('L1' => array('mots','id_mot')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( array('=', 'L1.id_objet', sql_quote($Pile[$SP]['id_article'], '','bigint(21) NOT NULL DEFAULT 0')), array('=', 'L1.objet', sql_quote('article')), array('=', 'mots.id_groupe', "2")); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/recherchesecteur1.html','html_b0dc7dca1b7ae19050bb4fe0c287597b','_lesmc2',127,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( '<a class="btn btn-small module2" style="margin-bottom:1px" href="' . interdire_scripts(parametre_url(generer_url_public('videos-classe', ''),'mc-g2',$Pile[$SP]['id_mot'])) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> '); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_lesmc2 @ squelettes/recherchesecteur1.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_lesarthtml_b0dc7dca1b7ae19050bb4fe0c287597b(&$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"]:"")), "articles", "","",array ( ),"id_article"); } $command['pagination'] = array((isset($Pile[0]['debut_lesart']) ? $Pile[0]['debut_lesart'] : null), 10); $command['pagination'] = array((isset($Pile[0]['debut_lesart']) ? $Pile[0]['debut_lesart'] : 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'] = 'articles'; $command['id'] = '_lesart'; $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.chapo", "articles.titre", "articles.surtitre", "articles.soustitre", "articles.descriptif", "articles.date", "articles.ps", "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:'', array('=', 'articles.id_secteur', "1"), 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/recherchesecteur1.html','html_b0dc7dca1b7ae19050bb4fe0c287597b','_lesart',86,$GLOBALS['spip_lang']) ); if (!$iter->err()) { // COMPTEUR $Numrows['_lesart']['compteur_boucle'] = 0; $Numrows['_lesart']['command'] = $command; $Numrows['_lesart']['total'] = @intval($iter->count()); $debut_boucle = isset($Pile[0]['debut_lesart']) ? $Pile[0]['debut_lesart'] : _request('debut_lesart'); if ($debut_boucle && $debut_boucle[0] === '@') { $debut_boucle = $Pile[0]['debut_lesart'] = quete_debut_pagination('id_article',$Pile[0]['@id_article'] = 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['_lesart']['total']-1)/(5))*(5))); $debut_boucle = intval($debut_boucle); $fin_boucle = min(($tout ? $Numrows['_lesart']['total'] : $debut_boucle + 4), $Numrows['_lesart']['total'] - 1); $Numrows['_lesart']['grand_total'] = $Numrows['_lesart']['total']; $Numrows['_lesart']["total"] = max(0,$fin_boucle - $debut_boucle + 1); if ($debut_boucle>0 AND $debut_boucle < $Numrows['_lesart']['grand_total'] AND $iter->seek($debut_boucle,'continue')) $Numrows['_lesart']['compteur_boucle'] = $debut_boucle; lang_select($GLOBALS['spip_lang']); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $Numrows['_lesart']['compteur_boucle']++; if ($Numrows['_lesart']['compteur_boucle'] <= $debut_boucle) continue; if ($Numrows['_lesart']['compteur_boucle']-1 > $fin_boucle) break; lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']); $t0 .= ( ' <div class="pave_video"> <div class="video_temps">' . interdire_scripts(textebrut(propre($Pile[$SP]['chapo'], $connect, $Pile[0]))) . '</div> <a title="Partager ou exploiter cette vidéo" href="#" data-modal="#modal_partage' . $Pile[$SP]['id_article'] . '"><img style="float:right" src="' . find_in_path((string)'images/info_partage.png') . '" /></a> <div class="modal span9" id="modal_partage' . $Pile[$SP]['id_article'] . '"> <div class="modal-title"><h5>Partager ou exploiter cette vidéo</h5> <div class="close">×</div></div> <div class="modal-content pave_forum"> <div> <p style="text-align:right; font-weight:bold; font-style:italic"><a href="' . vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))) . '">Voir la vidéo et ses ressources... >>></a></p> <h2 style="margin:0 0 5px 0">Partager cette vidéo</h2> <div style="float:right; margin-left:10px">' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclure/inc-boutons-partage') . ', array(\'id_article\' => ' . argumenter_squelette($Pile[$SP]['id_article']) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . '), array("compil"=>array(\'squelettes/recherchesecteur1.html\',\'html_b0dc7dca1b7ae19050bb4fe0c287597b\',\'\',96,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'></div> <p style="font-weight:bold">Lien vers "<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>"</p> </div> <input type="text" style="width:100%" onfocus="this.select();" onclick="this.select();" value="' . spip_htmlspecialchars(sinon($GLOBALS['meta']['adresse_site'],'.')) . '/' . vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true))) . '" /> <h2 style="margin:10px 0 5px 0">Référence de la vidéo : <span class="ref_video"> ' . $Pile[$SP]['id_article'] . ' </span></h2> <p>Ce numéro peut être saisi dans l\'onglet "<a target="_parent" href="spip.php?rubrique1#tabs-1">Rechercher</a>" pour accéder à la page de la vidéo.</p> </div> </div> <div class="video_logo"> ' . (($t1 = strval(interdire_scripts(((typo($Pile[$SP]['surtitre'], "TYPO", $connect, $Pile[0])) ?' ' :''))))!=='' ? ($t1 . ( ' <a title="Consulter la vidéo ' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '" href="' . interdire_scripts(textebrut(typo($Pile[$SP]['surtitre'], "TYPO", $connect, $Pile[0]))) . '" class=\'mediabox boxIframe boxWidth-720px boxHeight-500px boxOverlayClose-false\'>' . inserer_attribut(quete_html_logo(quete_logo('id_article', 'on', $Pile[$SP]['id_article'],'', 0), '', ''),'class','pale') . '</a> ')) : '') . ' ' . (($t1 = strval(interdire_scripts(((typo($Pile[$SP]['surtitre'], "TYPO", $connect, $Pile[0])) ?'' :' '))))!=='' ? ($t1 . ( ' ' . inserer_attribut(quete_html_logo(quete_logo('id_article', 'ON', $Pile[$SP]['id_article'],'', 0), '', ''),'class','tres_pale') . ' ')) : '') . ' </div> <div class="video_descriptif"> <h5> ' . BOUCLE_mcdusitehtml_b0dc7dca1b7ae19050bb4fe0c287597b($Cache, $Pile, $doublons, $Numrows, $SP) . ' <a title="Consulter la vidéo sur le site source" target="_blank" href="' . interdire_scripts(textebrut(typo($Pile[$SP]['soustitre'], "TYPO", $connect, $Pile[0]))) . '">' . interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) . '</a> </h5> <div class="info1"> ' . interdire_scripts(textebrut(target(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) . ' ' . (($t1 = strval(interdire_scripts(affdate(normaliser_date($Pile[$SP]['date'])))))!=='' ? ('<span class="affdate">(réf. ' . $t1 . ')</span>') : '') . ' ' . (($t1 = strval(interdire_scripts(((propre($Pile[$SP]['ps'], $connect, $Pile[0])) ?' ' :''))))!=='' ? ($t1 . ( ' <span class="plier_deplier_brut lien_afficher_objectifs">Objectifs</span> <div class="afficher_objectifs">' . interdire_scripts(propre($Pile[$SP]['ps'], $connect, $Pile[0])) . '</div> ')) : '') . ' </div> <div> ' . BOUCLE_lesmc1html_b0dc7dca1b7ae19050bb4fe0c287597b($Cache, $Pile, $doublons, $Numrows, $SP) . ' ' . BOUCLE_lesmc2html_b0dc7dca1b7ae19050bb4fe0c287597b($Cache, $Pile, $doublons, $Numrows, $SP) . ' </div> </div> <div style="clear:left"></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_lesart @ squelettes/recherchesecteur1.html","profiler"._LOG_AVERTISSEMENT); return $t0; } // // Fonction principale du squelette squelettes/recherchesecteur1.html // Temps de compilation total: 9.641 ms // function html_b0dc7dca1b7ae19050bb4fe0c287597b($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 = ( ' ' . (($t1 = BOUCLE_nbartrub1html_b0dc7dca1b7ae19050bb4fe0c287597b($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? ($t1 . vide($Pile['vars'][$_zzz=(string)'nbartrub1'] = ( '<span class="info2">(' . ($Numrows['_nbartrub1']['total'] ?? 0) . ')</span>'))) : '') . ' <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <!--[if lt IE 7 ]> <html dir="' . lang_dir(($Pile[0]['lang'] ?? null), 'ltr','rtl') . '" lang="' . spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang']) . '" xmlns="http://www.w3.org/1999/xhtml" xml:lang="' . spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang']) . '" class="' . lang_dir(($Pile[0]['lang'] ?? null), 'ltr','rtl') . (($t1 = strval(spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang'])))!=='' ? (' ' . $t1) : '') . ' no-js ie ie6"> <![endif]--> <!--[if IE 7 ]> <html dir="' . lang_dir(($Pile[0]['lang'] ?? null), 'ltr','rtl') . '" lang="' . spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang']) . '" xmlns="http://www.w3.org/1999/xhtml" xml:lang="' . spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang']) . '" class="' . lang_dir(($Pile[0]['lang'] ?? null), 'ltr','rtl') . (($t1 = strval(spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang'])))!=='' ? (' ' . $t1) : '') . ' no-js ie ie7"> <![endif]--> <!--[if IE 8 ]> <html dir="' . lang_dir(($Pile[0]['lang'] ?? null), 'ltr','rtl') . '" lang="' . spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang']) . '" xmlns="http://www.w3.org/1999/xhtml" xml:lang="' . spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang']) . '" class="' . lang_dir(($Pile[0]['lang'] ?? null), 'ltr','rtl') . (($t1 = strval(spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang'])))!=='' ? (' ' . $t1) : '') . ' no-js ie ie8"> <![endif]--> <!--[if IE 9 ]> <html dir="' . lang_dir(($Pile[0]['lang'] ?? null), 'ltr','rtl') . '" lang="' . spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang']) . '" xmlns="http://www.w3.org/1999/xhtml" xml:lang="' . spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang']) . '" class="' . lang_dir(($Pile[0]['lang'] ?? null), 'ltr','rtl') . (($t1 = strval(spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang'])))!=='' ? (' ' . $t1) : '') . ' no-js ie ie9"> <![endif]--> <!--[if (gt IE 9)|!(IE)]><!--> <html dir="' . lang_dir(($Pile[0]['lang'] ?? null), 'ltr','rtl') . '" lang="' . spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang']) . '" xmlns="http://www.w3.org/1999/xhtml" xml:lang="' . spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang']) . '" class="' . lang_dir(($Pile[0]['lang'] ?? null), 'ltr','rtl') . (($t1 = strval(spip_htmlentities(($Pile[0]['lang'] ?? null) ? ($Pile[0]['lang'] ?? null) : $GLOBALS['spip_lang'])))!=='' ? (' ' . $t1) : '') . ' no-js"> <!--<![endif]--> <head> <script type=\'text/javascript\'>/*<![CDATA[*/(function(H){H.className=H.className.replace(/\\bno-js\\b/,\'js\')})(document.documentElement);/*]]>*/</script> <title>' . _T('public|spip|ecrire:resultats_recherche') . ' - ' . interdire_scripts(textebrut(typo($GLOBALS['meta']['nom_site'], "TYPO", $connect, $Pile[0]))) . '</title> ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclure/head') . ', array(\'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . '), array("compil"=>array(\'squelettes/recherchesecteur1.html\',\'html_b0dc7dca1b7ae19050bb4fe0c287597b\',\'\',13,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'> <meta name="robots" content="none" /> </head> <body class="with-top-bar"> ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclure/header_accueil') . ', array_merge('.var_export($Pile[0],1).',array(\'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . ')), array("compil"=>array(\'squelettes/recherchesecteur1.html\',\'html_b0dc7dca1b7ae19050bb4fe0c287597b\',\'\',19,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'> <div class="container"> <div class="row ligne_principale"><!-- ligne principale --> <div class="span3 colonne_laterale"><!-- colonne latérale --> <div class="pave_lateral cadre1"> ' . BOUCLE_gp1html_b0dc7dca1b7ae19050bb4fe0c287597b($Cache, $Pile, $doublons, $Numrows, $SP) . ' </div> <div class="pave_lateral cadre2"> ' . BOUCLE_gp2html_b0dc7dca1b7ae19050bb4fe0c287597b($Cache, $Pile, $doublons, $Numrows, $SP) . ' </div> ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclure/inc-menu_portails') . ', array_merge('.var_export($Pile[0],1).',array(\'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . ')), array("compil"=>array(\'squelettes/recherchesecteur1.html\',\'html_b0dc7dca1b7ae19050bb4fe0c287597b\',\'\',34,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'> <script>$("#portail1").addClass("on");</script> </div><!-- fin colonne latérale --> <div class="span9 colonne_principale"><!-- colonne principale --> <div class="aplat2 rounded shadow bloc_titre" style="margin-bottom:20px"> <div style="float:right">' . executer_balise_dynamique('FORMULAIRE_RECHERCHESECTEUR1', array(), array('squelettes/recherchesecteur1.html','html_b0dc7dca1b7ae19050bb4fe0c287597b','',42,$GLOBALS['spip_lang'])) . '</div> ' . (($t1 = strval(entites_html(_request("recherche"))))!=='' ? ('<div class="letitre">A propos de « <span class="mot_selectionne">' . $t1 . '</span> »</div>') : '') . ' <div style="clear:both"></div> <div class="fleche_bas lien_afficher_mc"><a href="#">Afficher les mots-clés</a></div> <div class="afficher_mc"> <div><a href="' . interdire_scripts(generer_url_public('videos-classe', '')) . '">Toutes les vidéos ' . table_valeur($Pile["vars"]??[], (string)'nbartrub1', null) . '</a></div> <div class="choisir1">Choisir un cycle</div> ' . BOUCLE_mc1bishtml_b0dc7dca1b7ae19050bb4fe0c287597b($Cache, $Pile, $doublons, $Numrows, $SP) . ' <div class="choisir2">Choisir une catégorie de situation</div> ' . BOUCLE_mc2bishtml_b0dc7dca1b7ae19050bb4fe0c287597b($Cache, $Pile, $doublons, $Numrows, $SP) . ' </div> <div style="clear:both"></div> </div> ' . (($t1 = BOUCLE_lesarthtml_b0dc7dca1b7ae19050bb4fe0c287597b($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? (( ' <div class="pave_autre" style="margin-bottom:10px"><h2>Vidéos de "Les TICE en classe"</h2></div> ' . filtre_pagination_dist($Numrows["_lesart"]["grand_total"], '_lesart', isset($Pile[0]['debut_lesart'])?$Pile[0]['debut_lesart']:intval(_request('debut_lesart')), 5, false, '', '', array()) . ' ' . vide($Pile['vars'][$_zzz=(string)'nb_video12'] = ($Numrows['_lesart']['grand_total'] ?? $Numrows['_lesart']['total'] ?? 0))) . $t1 . ( ' <p class="pagination">' . filtre_pagination_dist($Numrows["_lesart"]["grand_total"], '_lesart', isset($Pile[0]['debut_lesart'])?$Pile[0]['debut_lesart']:intval(_request('debut_lesart')), 5, true, '', '', array()) . '</p> ')) : (( ' <div class="aplat rounded shadow bloc_titre" style="margin-bottom:20px; text-align:center"> <p>Mauvaise pioche ;o)</p> <img src="' . find_in_path((string)'images/desole.png') . '" /> </div> '))) . ' </div><!-- fin colonne principale --> </div><!-- fin ligne principale --> </div><!-- fin container --> ' . '<'.'?php echo recuperer_fond( ' . argumenter_squelette('inclure/footer') . ', array_merge('.var_export($Pile[0],1).',array(\'self\' => ' . argumenter_squelette(self()) . ', \'lang\' => ' . argumenter_squelette($GLOBALS["spip_lang"]) . ')), array("compil"=>array(\'squelettes/recherchesecteur1.html\',\'html_b0dc7dca1b7ae19050bb4fe0c287597b\',\'\',63,$GLOBALS[\'spip_lang\'])), _request(\'connect\') ?? \'\'); ?'.'> </body> <html>'); return analyse_resultat_skel('html_b0dc7dca1b7ae19050bb4fe0c287597b', $Cache, $page, 'squelettes/recherchesecteur1.html'); } ?>