";
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 "
";
}
else {
if ($frame+1 < $nb_col)
echo "
";
else echo "
";
}
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 "
";
}
}
}
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 "
";
}
$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 "
";
}
}
}
echo "
";
echo "