"; if ($special == "redac") { $query = "SELECT articles.id_article, articles.titre, articles.statut FROM spip_articles AS articles, spip_auteurs_articles AS lien WHERE articles.statut = 'prepa' AND articles.id_article = lien.id_article AND lien.id_auteur = $connect_id_auteur GROUP BY id_article ORDER BY articles.date DESC"; $result=spip_query($query); if (spip_num_rows($result)>0) { echo "

"._T("info_cours_edition")."

"; echo "

"; while($row=spip_fetch_array($result)){ $id_article=$row['id_article']; $titre = typo($row['titre']); $statut = $row['statut']; echo "$titre"; } echo "

"; } } else if ($special == "valider") { $query = "SELECT articles.id_article, articles.titre, articles.statut FROM spip_articles AS articles WHERE articles.statut = 'prop' ORDER BY articles.date DESC"; $result=spip_query($query); if (spip_num_rows($result)>0) { echo "

"._T("info_articles_proposes")."

"; echo "

"; while($row=spip_fetch_array($result)){ $id_article=$row['id_article']; $titre = typo($row['titre']); $statut = $row['statut']; echo "$titre"; } echo "

"; } $query = "SELECT * FROM spip_breves WHERE statut = 'prop' ORDER BY date_heure DESC LIMIT 0, 20"; $result=spip_query($query); if (spip_num_rows($result)>0) { echo "

"._T("info_breves_valider")."

"; echo "

"; while($row=spip_fetch_array($result)){ $id_breve=$row['id_breve']; $titre = typo($row['titre']); $statut = $row['statut']; $puce = "puce-orange-breve.gif"; echo "$titre"; } echo "

"; } } else { if (isset($id_rubrique) && ($id_rubrique !== '')) { $query = "SELECT * FROM spip_rubriques WHERE id_rubrique='$id_rubrique' ORDER BY 0+titre, titre"; $result=spip_query($query); if ($row=spip_fetch_array($result)){ $ze_rubrique=$row['id_rubrique']; $titre = typo($row['titre']); $id_parent=$row['id_parent']; if ($id_parent == 0) $icone = "secteur-24.gif"; else $icone = "rubrique-24.gif"; echo "

"; icone_horizontale("$titre", "javascript:window.parent.location=\"naviguer.php3?id_rubrique=$id_rubrique\"", "$icone",""); echo "

"; } else if ($frame == 0) { echo "

"; icone_horizontale(_T('info_racine_site'), "javascript:window.parent.location=\"naviguer.php3\"", "racine-site-24.gif",""); echo "

"; } $query = "SELECT * FROM spip_rubriques WHERE id_parent='$id_rubrique' ORDER BY 0+titre, titre"; $result=spip_query($query); while($row=spip_fetch_array($result)){ $ze_rubrique=$row['id_rubrique']; $titre = typo($row['titre']); $id_parent=$row['id_parent']; echo "

"; if ($id_parent == '0') { echo "

$titre

"; } else { if ($frame+1 < $nb_col) echo "

$titre

"; else echo "

$titre

"; } echo "

\n"; } if ($id_rubrique > 0) { if ($connect_statut == "0minirezo") $query = "SELECT articles.id_article, articles.titre, articles.statut FROM spip_articles AS articles WHERE id_rubrique=$id_rubrique ORDER BY date DESC"; else $query = "SELECT articles.id_article, articles.titre, articles.statut FROM spip_articles AS articles, spip_auteurs_articles AS lien WHERE articles.id_rubrique=$id_rubrique AND (articles.statut = 'publie' OR articles.statut = 'prop' OR (articles.statut = 'prepa' AND articles.id_article = lien.id_article AND lien.id_auteur = $connect_id_auteur)) GROUP BY id_article ORDER BY articles.date DESC"; $result=spip_query($query); if (spip_num_rows($result)>0) { echo "

"._T('info_articles')."

"; echo "

"; while($row=spip_fetch_array($result)){ $id_article=$row['id_article']; $titre = typo($row['titre']); $statut = $row['statut']; echo "$titre"; } echo "

"; } $query = "SELECT * FROM spip_breves WHERE id_rubrique=$id_rubrique ORDER BY date_heure DESC LIMIT 0, 20"; $result=spip_query($query); if (spip_num_rows($result)>0) { echo "

"._T('info_breves_02')."

"; echo "

"; while($row=spip_fetch_array($result)){ $id_breve=$row['id_breve']; $titre = typo($row['titre']); $statut = $row['statut']; switch ($statut) { case 'publie': $puce = 'verte'; break; case 'prepa': $puce = 'blanche'; break; case 'prop': $puce = 'orange'; break; case 'refuse': $puce = 'rouge'; break; case 'poubelle': $puce = 'poubelle'; break; } $puce = "puce-$puce-breve.gif"; echo "$titre"; } echo "

"; } $query = "SELECT * FROM spip_syndic WHERE id_rubrique='$id_rubrique' AND statut!='refuse' ORDER BY nom_site"; $result=spip_query($query); if (spip_num_rows($result)>0) { echo "

"._T('icone_sites_references')."

"; while($row=spip_fetch_array($result)){ $id_syndic=$row['id_syndic']; $titre = typo($row['nom_site']); $statut = $row['statut']; switch ($statut) { case 'publie': $puce = 'verte'; break; case 'prepa': $puce = 'blanche'; break; case 'prop': $puce = 'orange'; break; case 'refuse': $puce = 'rouge'; break; case 'poubelle': $puce = 'poubelle'; break; } echo "

$titre

"; } } } if ($frame == 0 AND $id_rubrique==0) { $query = "SELECT articles.id_article, articles.titre, articles.statut FROM spip_articles AS articles, spip_auteurs_articles AS lien WHERE articles.statut = 'prepa' AND articles.id_article = lien.id_article AND lien.id_auteur = $connect_id_auteur GROUP BY id_article ORDER BY articles.date DESC"; $result=spip_query($query); if (spip_num_rows($result)>0) { echo "

"._T("info_cours_edition")."

"; } $query = "SELECT articles.id_article, articles.titre, articles.statut FROM spip_articles AS articles WHERE articles.statut = 'prop' ORDER BY articles.date DESC"; $result = spip_query($query); $total_articles = spip_num_rows($result); $query = "SELECT * FROM spip_breves WHERE statut = 'prop' ORDER BY date_heure DESC LIMIT 0, 20"; $result=spip_query($query); $total_breves = spip_num_rows($result); if ($total_articles + $total_breves > 0) echo "

"._T("info_articles_proposes")." / "._T("info_breves_valider")."

"; } } } echo "