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/documents.html * Date : Sun, 01 Jan 2023 17:24:38 GMT * Compile : Sun, 07 Apr 2024 15:29:00 GMT * Boucles : _documents_portfolio, _afficher_document, _documents_decompte, _documents_joints */ function BOUCLE_documents_portfoliohtml_508639439f2f9c8d29cd7b789753ed82(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $doublons_index = array(); $in = array(); $in[]= 'png'; $in[]= 'jpg'; $in[]= 'gif'; // Initialise le(s) critère(s) doublons if (!isset($doublons[$d = 'documents'])) { $doublons[$d] = ''; } 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'] = 'documents'; $command['id'] = '_documents_portfolio'; $command['from'] = array('documents' => 'spip_documents','L1' => 'spip_documents_liens','L2' => 'spip_types_documents'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("0+documents.titre AS num", "CASE ( 0+documents.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "documents.date", "documents.id_document", "L2.mime_type", "L1.id_objet AS id_article", "documents.titre", "documents.fichier", "documents.id_document"); $command['orderby'] = array('sinum, num', 'documents.date'); $command['join'] = array('L1' => array('documents','id_document'), 'L2' => array('documents','extension')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('documents.statut','publie,prop,prepa','publie',''), array('(documents.taille > 0 OR documents.distant=\'oui\')'), array('=', 'L1.id_objet', sql_quote(($Pile[0]['id_article'] ?? null), '','bigint(21) NOT NULL DEFAULT 0')), array('=', 'L1.objet', sql_quote('article')), array('=', 'documents.mode', "'document'"), sql_in('documents.extension', $in), array('=', 'L1.vu', "'non'"), array(sql_in('documents.id_document', $doublons[$doublons_index[]= ('documents')], 'NOT')), array('OR', array('IN','documents.id_document','(SELECT * FROM('.sql_get_select('zzzd.id_document','spip_documents_liens as zzzd',array(array('OR',array('OR',array('OR',array('OR',array('AND','zzzd.objet=\'rubrique\'',sql_in('zzzd.id_objet', accesrestreint_liste_rubriques_exclues(!test_espace_prive()), 'NOT')),array('AND','zzzd.objet=\'article\'',array('AND', array('NOT IN','zzzd.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('zzzd.id_objet', accesrestreint_liste_objets_exclus('articles', !test_espace_prive()), 'not')))),array('AND','zzzd.objet=\'breve\'',array('AND', array('NOT IN','zzzd.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('zzzd.id_objet', accesrestreint_liste_objets_exclus('breves', !test_espace_prive()), 'not')))),array('AND','zzzd.objet=\'forum\'',array('IN','zzzd.id_objet','(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)'))),sql_in('zzzd.objet',array('rubrique','article','breve','forum'),'NOT',$connect))),'','','','',$connect).') AS subquery)'), array('NOT IN','documents.id_document','(SELECT * FROM('.sql_get_select('zzzd.id_document','spip_documents_liens as zzzd','','','','','',$connect).') AS subquery)') )); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/inclure/documents.html','html_508639439f2f9c8d29cd7b789753ed82','_documents_portfolio',6,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { foreach($doublons_index as $k) $doublons[$k] .= "," . $Pile[$SP]['id_document']; // doublons $t0 .= (($t1 = strval(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_document'], 'document', '', '', true)))))!=='' ? (' <li><a href="' . $t1 . ( '" type="' . interdire_scripts($Pile[$SP]['mime_type']) . '" onclick="location.href=\'' . ancre_url(parametre_url(url_absolue(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_article'], 'article', '', '', true)))),'id_document',$Pile[$SP]['id_document']),'documents_portfolio') . '\';return false;"' . (($t2 = strval(interdire_scripts(($Pile[0]['exposer'] ?? null))))!=='' ? (' class="' . $t2 . '"') : '') . (($t2 = strval(interdire_scripts(couper(attribut_html(traiter_doublons_documents($doublons, supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0])))),'80'))))!=='' ? (' title="' . $t2 . '"') : '') . '>' . interdire_scripts(inserer_attribut(inserer_attribut(filtrer('image_graver', filtrer('image_recadre',filtrer('image_passe_partout',get_spip_doc($Pile[$SP]['fichier']),'90','90'),'90','90')),'class','spip_logos'),'alt',interdire_scripts(couper(attribut_html(traiter_doublons_documents($doublons, supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0])))),'80')))) . '</a></li> ')) : ''); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_documents_portfolio @ squelettes/inclure/documents.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_afficher_documenthtml_508639439f2f9c8d29cd7b789753ed82(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $in = array(); $in[]= 'png'; $in[]= 'jpg'; $in[]= 'gif';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'] = 'documents'; $command['id'] = '_afficher_document'; $command['from'] = array('documents' => 'spip_documents','L1' => 'spip_documents_liens'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("documents.id_document", "documents.id_document"); $command['join'] = array('L1' => array('documents','id_document')); $command['limit'] = ''; $command['having'] = array(); } $command['orderby'] = array(((!$zqv=sql_quote($in) OR $zqv==="''") ? 0 : ('FIELD(documents.extension,' . $zqv . ')'))); $command['where'] = array( quete_condition_statut('documents.statut','publie,prop,prepa','publie',''), array('(documents.taille > 0 OR documents.distant=\'oui\')'), array('=', 'documents.id_document', sql_quote(($Pile[0]['id_document'] ?? null), '','bigint(21) NOT NULL AUTO_INCREMENT')), array('=', 'L1.id_objet', sql_quote(($Pile[0]['id_article'] ?? null), '','bigint(21) NOT NULL DEFAULT 0')), array('=', 'L1.objet', sql_quote('article')), array('=', 'documents.mode', "'document'"), sql_in('documents.extension', $in), array('OR', array('IN','documents.id_document','(SELECT * FROM('.sql_get_select('zzzd.id_document','spip_documents_liens as zzzd',array(array('OR',array('OR',array('OR',array('OR',array('AND','zzzd.objet=\'rubrique\'',sql_in('zzzd.id_objet', accesrestreint_liste_rubriques_exclues(!test_espace_prive()), 'NOT')),array('AND','zzzd.objet=\'article\'',array('AND', array('NOT IN','zzzd.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('zzzd.id_objet', accesrestreint_liste_objets_exclus('articles', !test_espace_prive()), 'not')))),array('AND','zzzd.objet=\'breve\'',array('AND', array('NOT IN','zzzd.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('zzzd.id_objet', accesrestreint_liste_objets_exclus('breves', !test_espace_prive()), 'not')))),array('AND','zzzd.objet=\'forum\'',array('IN','zzzd.id_objet','(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)'))),sql_in('zzzd.objet',array('rubrique','article','breve','forum'),'NOT',$connect))),'','','','',$connect).') AS subquery)'), array('NOT IN','documents.id_document','(SELECT * FROM('.sql_get_select('zzzd.id_document','spip_documents_liens as zzzd','','','','','',$connect).') AS subquery)') )); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/inclure/documents.html','html_508639439f2f9c8d29cd7b789753ed82','_afficher_document',24,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( ' ' . filtrer('image_graver',filtrer('image_reduire', ((($recurs=(isset($Pile[0]['recurs'])?$Pile[0]['recurs']:0))>=5)? '' : recuperer_fond('modeles/emb', array('lien' => vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_document'], 'document', '', '', true))) , 'lang' => $GLOBALS["spip_lang"] , 'id_document'=>$Pile[$SP]['id_document'], 'id'=>$Pile[$SP]['id_document'], 'recurs'=>(++$recurs)), array('compil'=>array('squelettes/inclure/documents.html','html_508639439f2f9c8d29cd7b789753ed82','_afficher_document',25,$GLOBALS['spip_lang']), 'trim'=>true), '')) ,'500','*')) . ' '); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_afficher_document @ squelettes/inclure/documents.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_documents_decomptehtml_508639439f2f9c8d29cd7b789753ed82(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $in = array(); $in[]= 'gif'; $in[]= 'jpg'; $in[]= 'png';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'] = 'documents'; $command['id'] = '_documents_decompte'; $command['from'] = array('documents' => 'spip_documents','L1' => 'spip_documents_liens','L2' => 'spip_forum'); $command['type'] = array(); $command['groupby'] = array("documents.id_document"); $command['select'] = array("documents.id_document", "documents.id_document"); $command['orderby'] = array(); $command['join'] = array('L1' => array('documents','id_document'), 'L2' => array('documents','id_objet','id_document','L2.objet='.sql_quote('document'))); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('documents.statut','publie,prop,prepa','publie',''), array('(documents.taille > 0 OR documents.distant=\'oui\')'), array('=', 'L1.id_objet', sql_quote(($Pile[0]['id_article'] ?? null), '','bigint(21) NOT NULL DEFAULT 0')), array('=', 'L1.objet', sql_quote('article')), array('=', 'documents.mode', "'document'"), 'JOIN-L2' => array('=', 'L2.objet', sql_quote('document')), array('=', 'L2.texte', "''"), sql_in('documents.extension', $in,'NOT'), array('=', 'L1.vu', "'non'"), array('OR', array('IN','documents.id_document','(SELECT * FROM('.sql_get_select('zzzd.id_document','spip_documents_liens as zzzd',array(array('OR',array('OR',array('OR',array('OR',array('AND','zzzd.objet=\'rubrique\'',sql_in('zzzd.id_objet', accesrestreint_liste_rubriques_exclues(!test_espace_prive()), 'NOT')),array('AND','zzzd.objet=\'article\'',array('AND', array('NOT IN','zzzd.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('zzzd.id_objet', accesrestreint_liste_objets_exclus('articles', !test_espace_prive()), 'not')))),array('AND','zzzd.objet=\'breve\'',array('AND', array('NOT IN','zzzd.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('zzzd.id_objet', accesrestreint_liste_objets_exclus('breves', !test_espace_prive()), 'not')))),array('AND','zzzd.objet=\'forum\'',array('IN','zzzd.id_objet','(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)'))),sql_in('zzzd.objet',array('rubrique','article','breve','forum'),'NOT',$connect))),'','','','',$connect).') AS subquery)'), array('NOT IN','documents.id_document','(SELECT * FROM('.sql_get_select('zzzd.id_document','spip_documents_liens as zzzd','','','','','',$connect).') AS subquery)') )); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/inclure/documents.html','html_508639439f2f9c8d29cd7b789753ed82','_documents_decompte',33,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $Numrows['_documents_decompte']['command'] = $command; $Numrows['_documents_decompte']['total'] = @intval($iter->count()); $SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( ' ' . ((($Numrows['_documents_decompte']['total'] ?? 0) == '1') ? trim(recuperer_fond( 'modeles/emb' , array('id_document' => $Pile[$SP]['id_document'] ), array('compil'=>array('squelettes/inclure/documents.html','html_508639439f2f9c8d29cd7b789753ed82','_documents_decompte',35,$GLOBALS['spip_lang'])), _request('connect') ?? '')):'')); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_documents_decompte @ squelettes/inclure/documents.html","profiler"._LOG_AVERTISSEMENT); return $t0; } function BOUCLE_documents_jointshtml_508639439f2f9c8d29cd7b789753ed82(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) { static $command = array(); static $connect; $command['connect'] = $connect = ''; $in = array(); $in[]= 'gif'; $in[]= 'jpg'; $in[]= 'png';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'] = 'documents'; $command['id'] = '_documents_joints'; $command['from'] = array('documents' => 'spip_documents','L1' => 'spip_documents_liens','L2' => 'spip_types_documents'); $command['type'] = array(); $command['groupby'] = array(); $command['select'] = array("0+documents.titre AS num", "CASE ( 0+documents.titre ) WHEN 0 THEN 1 ELSE 0 END AS sinum", "documents.date", "documents.id_document", "L2.mime_type", "documents.extension", "documents.titre", "documents.fichier", "L2.titre AS type_document", "documents.taille", "documents.descriptif", "documents.id_document"); $command['orderby'] = array('sinum, num', 'documents.date'); $command['join'] = array('L1' => array('documents','id_document'), 'L2' => array('documents','extension')); $command['limit'] = ''; $command['having'] = array(); } $command['where'] = array( quete_condition_statut('documents.statut','publie,prop,prepa','publie',''), array('IN', 'documents.mode', '(\'image\',\'document\')'), array('(documents.taille > 0 OR documents.distant=\'oui\')'), 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('documents.extension', $in,'NOT'), array('=', 'L1.vu', "'non'"), array('OR', array('IN','documents.id_document','(SELECT * FROM('.sql_get_select('zzzd.id_document','spip_documents_liens as zzzd',array(array('OR',array('OR',array('OR',array('OR',array('AND','zzzd.objet=\'rubrique\'',sql_in('zzzd.id_objet', accesrestreint_liste_rubriques_exclues(!test_espace_prive()), 'NOT')),array('AND','zzzd.objet=\'article\'',array('AND', array('NOT IN','zzzd.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('zzzd.id_objet', accesrestreint_liste_objets_exclus('articles', !test_espace_prive()), 'not')))),array('AND','zzzd.objet=\'breve\'',array('AND', array('NOT IN','zzzd.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('zzzd.id_objet', accesrestreint_liste_objets_exclus('breves', !test_espace_prive()), 'not')))),array('AND','zzzd.objet=\'forum\'',array('IN','zzzd.id_objet','(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)'))),sql_in('zzzd.objet',array('rubrique','article','breve','forum'),'NOT',$connect))),'','','','',$connect).') AS subquery)'), array('NOT IN','documents.id_document','(SELECT * FROM('.sql_get_select('zzzd.id_document','spip_documents_liens as zzzd','','','','','',$connect).') AS subquery)') )); if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime(); $t0 = ""; // REQUETE $iter = IterFactory::create( "SQL", $command, array('squelettes/inclure/documents.html','html_508639439f2f9c8d29cd7b789753ed82','_documents_joints',46,$GLOBALS['spip_lang']) ); if (!$iter->err()) { $l1 = _T('public|spip|ecrire:info_document');$SP++; // RESULTATS while ($Pile[$SP]=$iter->fetch()) { $t0 .= ( (($t1 = strval(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_document'], 'document', '', '', true)))))!=='' ? (' <li> <a href="' . $t1 . ( '" type="' . interdire_scripts($Pile[$SP]['mime_type']) . '" class="spip_doc' . (($t2 = strval(interdire_scripts(attribut_html($Pile[$SP]['extension']))))!=='' ? (' ' . $t2) : '') . '"><strong class="titre">' . interdire_scripts(((($a = traiter_doublons_documents($doublons, supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0])))) OR (is_string($a) AND strlen($a))) ? $a : interdire_scripts(couper(basename(get_spip_doc($Pile[$SP]['fichier'])),'80')))) . '</strong> <small class="info_document">(' . (($t2 = strval(interdire_scripts(strtoupper($Pile[$SP]['extension']))))!=='' ? (( '<abbr title="' . $l1 . ' ' . interdire_scripts($Pile[$SP]['type_document']) . '" class="ext">') . $t2 . '</abbr> - ') : '') . (($t2 = strval(interdire_scripts(taille_en_octets($Pile[$SP]['taille']))))!=='' ? ('<span>' . $t2 . '</span>') : '') . ')</small></a> ' . (($t2 = strval(interdire_scripts(traiter_doublons_documents($doublons, propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))))!=='' ? (( '<div class="descriptif">') . $t2 . '</div>') : '') . ' ')) : '') . '</li> '); } $iter->free(); } if (defined("_BOUCLE_PROFILER") AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER) spip_log(intval(1000*$timer)."ms BOUCLE_documents_joints @ squelettes/inclure/documents.html","profiler"._LOG_AVERTISSEMENT); return $t0; } // // Fonction principale du squelette squelettes/inclure/documents.html // Temps de compilation total: 9.038 ms // function html_508639439f2f9c8d29cd7b789753ed82($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_documents_portfoliohtml_508639439f2f9c8d29cd7b789753ed82($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? (( ' <div class="bloc clearfix" id="documents_portfolio"> <h2>' . _T('medias:info_portfolio') . '</h2> <ul> ') . $t1 . ' </ul> </div><!--#documents_portfolio--> ') : '') . ' ' . BOUCLE_afficher_documenthtml_508639439f2f9c8d29cd7b789753ed82($Cache, $Pile, $doublons, $Numrows, $SP) . ' ' . (($t1 = BOUCLE_documents_decomptehtml_508639439f2f9c8d29cd7b789753ed82($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? $t1 : (( ' ' . (($t2 = BOUCLE_documents_jointshtml_508639439f2f9c8d29cd7b789753ed82($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ? (' <div class="doc_joint" id="documents_joints"> <h2>Ressources complĂ©mentaires</h2> <ul> ' . $t2 . ' </ul> </div><!--#documents_joints--> ') : '') . ' ')))); return analyse_resultat_skel('html_508639439f2f9c8d29cd7b789753ed82', $Cache, $page, 'squelettes/inclure/documents.html'); } ?>