Corriger le problème ou vider le cache pour supprimer les restrictions.';
$message_en = 'Acces Restriction is now unusable. Correct this trouble or empty the cache to finish restriction removal.';
die($message_fr.'
'.$message_en);
}
static $table = 'documents';
static $id = '_documents_article';
static $from = array('documents' => 'spip_documents','L1' => 'spip_documents_liens','L2' => 'spip_documents_liens','L3' => 'spip_types_documents');
static $type = array();
static $groupby = array("documents.id_document");
static $select = array("0+documents.titre AS num",
"documents.id_document",
"documents.titre",
"L3.titre AS type_document",
"documents.taille",
"documents.descriptif",
"L3.mime_type",
"documents.id_document");
static $orderby = array('num', 'documents.id_document');
$where =
array('((documents.statut = "publie"))',
array('<', 'documents.date_publication', sql_quote(quete_date_postdates())),
array('(documents.taille > 0 OR documents.distant=\'oui\')'), (!(is_array($Pile[0]['id_article'])?count($Pile[0]['id_article']):strlen($Pile[0]['id_article'])) ? '' : ((is_array($Pile[0]['id_article'])) ? sql_in('L1.id_objet',sql_quote($in)) :
array('=', 'L1.id_objet', sql_quote($Pile[0]['id_article'])))), (!$Pile[0]['id_article'] ? '' :
array('=', 'L1.objet', sql_quote('article'))), (!(is_array($Pile[0]['id_rubrique'])?count($Pile[0]['id_rubrique']):strlen($Pile[0]['id_rubrique'])) ? '' : ((is_array($Pile[0]['id_rubrique'])) ? sql_in('L2.id_objet',sql_quote($in1)) :
array('=', 'L2.id_objet', sql_quote($Pile[0]['id_rubrique'])))), (!$Pile[0]['id_rubrique'] ? '' :
array('=', 'L2.objet', sql_quote('rubrique'))), sql_in('documents.extension',sql_quote($in2),'NOT'),
array('=', 'documents.mode', "'document'"),
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('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)'))),array('AND','zzzd.objet=\'breve\'',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)'))),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',sql_in('zzzf.id_rubrique', accesrestreint_liste_rubriques_exclues(!test_espace_prive()), 'NOT'),array('NOT IN','zzzf.id_article','(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)')),array('NOT IN','zzzf.id_breve','(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)'))),'','','','',$connect).') AS subquery)'))),sql_in('zzzd.objet',"'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)')
));
static $join = array('L1' => array('documents','id_document'), 'L2' => array('documents','id_document'), 'L3' => array('documents','extension'));
static $limit = '';
static $having =
array();
$t0 = "";
// REQUETE
$result = calculer_select($select, $from, $type, $where, $join, $groupby, $orderby, $limit, $having, $table, $id, $connect,
array('plugins/auto/sarkaspip_31_dev/noisettes/document/inc_documents_joints.html','html_0319efb3dabdf5386f36a0177cf77db4','_documents_article',9,$GLOBALS['spip_lang']));
if ($result) {
$l1 = _T('public/spip/ecrire:bouton_telecharger');$SP++;
// RESULTATS
while ($Pile[$SP] = @sql_fetch($result)) {
$t0 .= (
'
' .
vide($Pile['vars']['titre'] = interdire_scripts(((($a = texte_backend(typo(supprimer_numero($Pile[$SP]['titre']), "TYPO", $connect))) OR (!is_array($a) AND strlen($a))) ? $a : ( (($t3 = strval(interdire_scripts($Pile[$SP]['type_document'])))!=='' ?
($t3 . ' - ') :
'') .
interdire_scripts(taille_en_octets($Pile[$SP]['taille'])))))) .
'
' .
vide($Pile['vars']['descr'] = interdire_scripts(PtoBR(propre($Pile[$SP]['descriptif'], $connect)))) .
'