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 = 'syndic_articles'; static $id = '_articles_syndiques'; static $from = array('syndic_articles' => 'spip_syndic_articles','L1' => 'spip_syndic'); static $type = array(); static $groupby = array(); static $select = array("syndic_articles.date", "syndic_articles.id_syndic_article", "syndic_articles.id_syndic", "L1.url_site", "L1.nom_site", "syndic_articles.titre", "syndic_articles.url", "syndic_articles.descriptif", "syndic_articles.id_syndic_article"); static $orderby = array('syndic_articles.date DESC'); $where = array( array('=', 'syndic_articles.statut', '\'publie\''), (!(is_array($Pile[0]['id_syndic'])?count($Pile[0]['id_syndic']):strlen($Pile[0]['id_syndic'])) ? '' : ((is_array($Pile[0]['id_syndic'])) ? sql_in('syndic_articles.id_syndic',sql_quote($in)) : array('=', 'syndic_articles.id_syndic', sql_quote($Pile[0]['id_syndic'],'','int')))), array('NOT', array('REGEXP', 'L1.id_rubrique', sql_quote(calcul_rubrique_specialisee("galerie",branche,"not_in")))), array('<', 'LEAST((UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(syndic_articles.date))/86400, TO_DAYS(NOW())-TO_DAYS(syndic_articles.date), DAYOFMONTH(NOW())-DAYOFMONTH(syndic_articles.date)+30.4368*(MONTH(NOW())-MONTH(syndic_articles.date))+365.2422*(YEAR(NOW())-YEAR(syndic_articles.date)))', sql_quote(interdire_scripts(entites_html((@$Pile[0]['nb_jours']),true)))), array('NOT IN','syndic_articles.id_syndic_article','(SELECT * FROM('.sql_get_select('zzzs.id_syndic','spip_syndic as zzzs',sql_in('zzzs.id_rubrique', accesrestreint_liste_rubriques_exclues(!test_espace_prive()), ''),'','','','',$connect).') AS subquery)'), array('=', 'L1.statut', '\'publie\'')); static $join = array('L1' => array('syndic_articles','id_syndic')); 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/site/inc_site_articles_syndiques.html','html_078d2b6db27b256450390fb5fce19f10','_articles_syndiques',10,$GLOBALS['spip_lang'])); if ($result) { // COMPTEUR $Numrows['_articles_syndiques']['compteur_boucle'] = 0; $Numrows['_articles_syndiques']['total'] = @intval(sql_count($result)); $debut_boucle = isset($Pile[0]['debut_articles_syndiques']) ? $Pile[0]['debut_articles_syndiques'] : _request('debut_articles_syndiques'); if(substr($debut_boucle,0,1)=='@'){ $debut_boucle = $Pile[0]['debut_articles_syndiques'] = quete_debut_pagination('id_syndic_article',$Pile[0]['@id_syndic_article'] = substr($debut_boucle,1),(($a = intval(interdire_scripts(lire_config('sarkaspip_site/pas_pagination_site','50',false)))) ? $a : 10),$result,''); if (!sql_seek($result,0,'')){ @sql_free($result,''); $result = calculer_select($select, $from, $type, $where, $join, $groupby, $orderby, $limit, $having, $table, $id, $connect); } } $debut_boucle = intval($debut_boucle); $debut_boucle = (($tout=($debut_boucle == -1))?0:($debut_boucle)); $debut_boucle = max(0,min($debut_boucle,floor(($Numrows['_articles_syndiques']['total']-1)/((($a = intval(interdire_scripts(lire_config('sarkaspip_site/pas_pagination_site','50',false)))) ? $a : 10)))*((($a = intval(interdire_scripts(lire_config('sarkaspip_site/pas_pagination_site','50',false)))) ? $a : 10)))); $fin_boucle = min(($tout ? $Numrows['_articles_syndiques']['total'] : $debut_boucle+(($a = intval(interdire_scripts(lire_config('sarkaspip_site/pas_pagination_site','50',false)))) ? $a : 10) - 1), $Numrows['_articles_syndiques']['total'] - 1); $Numrows['_articles_syndiques']['grand_total'] = $Numrows['_articles_syndiques']['total']; $Numrows['_articles_syndiques']["total"] = max(0,$fin_boucle - $debut_boucle + 1); if ($debut_boucle>0 AND $debut_boucle < $Numrows['_articles_syndiques']['grand_total'] AND sql_seek($result,$debut_boucle,'','continue')) $Numrows['_articles_syndiques']['compteur_boucle'] = $debut_boucle; $SP++; // RESULTATS while ($Pile[$SP] = @sql_fetch($result)) { $Numrows['_articles_syndiques']['compteur_boucle']++; if ($Numrows['_articles_syndiques']['compteur_boucle'] <= $debut_boucle) continue; if ($Numrows['_articles_syndiques']['compteur_boucle']-1 > $fin_boucle) break; $t0 .= ( ' ' . (($t1 = strval(interdire_scripts(((unique(affdate(normaliser_date($Pile[$SP]['date'])))) ?' ' :''))))!=='' ? ($t1 . ( ' ' . (($t2 = strval(interdire_scripts((((affdate(normaliser_date($Pile[$SP]['date'])) != (is_array($a = ($Pile["vars"])) ? $a['date_courante'] : ""))) ?' ' :''))))!=='' ? ($t2 . ( ' ' . (((is_array($a = ($Pile["vars"])) ? $a['date_courante'] : "")) ? (' ' . '') : '') . ' ')) : '') . '

' . interdire_scripts(nom_jour(normaliser_date($Pile[$SP]['date']))) . (($t2 = strval(interdire_scripts(affdate(normaliser_date($Pile[$SP]['date'])))))!=='' ? (' ' . $t2) : '') . '

' . (($t3 = strval(interdire_scripts((match(lire_config('sarkaspip_site/position_pagination_site','3',false),'^(2|3)$') ? ' ':''))))!=='' ? ($t3 . ( ' ' . (($t4 = strval(filtre_pagination_dist($Numrows["_articles_syndiques"]["grand_total"], '_articles_syndiques', isset($Pile[0]['debut_articles_syndiques'])?$Pile[0]['debut_articles_syndiques']:intval(_request('debut_articles_syndiques')), (($a = intval(interdire_scripts(lire_config('sarkaspip_site/pas_pagination_site','50',false)))) ? $a : 10), true, interdire_scripts(lire_config('sarkaspip_site/modele_pagination_site',null,false)), '', array('lang' => $GLOBALS["spip_lang"] ))))!=='' ? ('') : '') . ' ')) : '') . ' ')) : '') . ' '); return analyse_resultat_skel('html_078d2b6db27b256450390fb5fce19f10', $Cache, $page, 'plugins/auto/sarkaspip_31_dev/noisettes/site/inc_site_articles_syndiques.html'); } ?>