addvar('controle_forum', $action);
$link->addvar('id_controle_forum', $id);
$link = $link->geturl() . "#id$id";
if ($but)
$link = $but . "&retour=ecrire/" . urlencode($link);
return icone($texte,
$link,
$fond,
$fonction,
"right",
'non');
}
// tous les boutons de controle d'un forum
function boutons_controle_forum($id_forum, $forum_stat, $forum_id_auteur=0, $ref, $forum_ip) {
$controle = '';
// selection du logo et des boutons correspondant a l'etat du forum
switch ($forum_stat) {
# forum sous un article dans l'espace prive
case "prive":
$logo = "forum-interne-24.gif";
$valider = false;
$valider_repondre = false;
$supprimer = 'supp_forum_priv';
break;
# forum des administrateurs
case "privadmin":
$logo = "forum-admin-24.gif";
$valider = false;
$valider_repondre = false;
$supprimer = false;
break;
# forum de l'espace prive, supprime (non revalidable,
# d'ailleurs on ne sait plus a quel type de forum il appartenait)
case "privoff":
$logo = "forum-interne-24.gif";
$valider = false;
$valider_repondre = false;
$supprimer = false;
break;
# forum general de l'espace prive
case "privrac":
$logo = "forum-interne-24.gif";
$valider = false;
$valider_repondre = false;
$supprimer = 'supp_forum_priv';
break;
# forum publie sur le site public
case "publie":
$logo = "forum-public-24.gif";
$valider = false;
$valider_repondre = false;
$supprimer = 'supp_forum';
break;
# forum supprime sur le site public
case "off":
$logo = "forum-public-24.gif";
$valider = 'valid_forum';
$valider_repondre = false;
$supprimer = false;
$message = "
"._T('info_message_supprime')." $forum_ip";
if($forum_id_auteur)
$message .= " - " ._T('lien_voir_auteur'). "";
break;
# forum propose (a moderer) sur le site public
case "prop":
$logo = "forum-public-24.gif";
$valider = 'valid_forum';
$valider_repondre = true;
$supprimer = 'supp_forum';
break;
default:
return;
}
if ($message)
$controle .= $message;
if ($supprimer)
$controle .= controle_cache_forum($supprimer,
$id_forum,
_T('icone_supprimer_message'),
$logo,
"supprimer.gif");
if ($valider)
$controle .= controle_cache_forum($valider,
$id_forum,
_T('icone_valider_message'),
$logo,
"creer.gif");
if ($valider_repondre) {
$controle .= controle_cache_forum($valider,
$id_forum,
_T('icone_valider_message') . " & " .
_T('lien_repondre_message'),
$logo,
"creer.gif",
"../forum.php3?$ref&id_forum=$id_forum"
);
}
return $controle;
}
// Selon ce qu'on veut suivre depuis ecrire/controle_forum, retourner le SQL
function critere_statut_controle_forum($page) {
switch ($page) {
case 'public':
$query_forum = "statut IN ('publie', 'off', 'prop') AND texte!=''";
break;
case 'prop':
$query_forum = "statut='prop'";
break;
case 'interne':
$query_forum = "statut IN ('prive', 'privrac', 'privoff', 'privadm') AND texte!=''";
break;
case 'vide':
$query_forum = "statut IN ('publie', 'off', 'prive', 'privrac', 'privoff', 'privadm') AND texte=''";
break;
default:
$query_forum = "0=1";
break;
}
return $query_forum;
}
// Index d'invalidation des forums
function calcul_index_forum($id_article, $id_breve, $id_rubrique, $id_syndic) {
if ($id_article) return 'a'.$id_article;
if ($id_breve) return 'b'.$id_breve;
if ($id_rubrique) return 'r'.$id_rubrique;
if ($id_syndic) return 's'.$id_syndic;
}
//
// Recalculer tous les threads
//
function calculer_threads() {
// fixer les id_thread des debuts de discussion
spip_query("UPDATE spip_forum SET id_thread=id_forum
WHERE id_parent=0");
// reparer les messages qui n'ont pas l'id_secteur de leur parent
do {
$discussion = "0";
$precedent = 0;
$r = spip_query("SELECT fille.id_forum AS id,
maman.id_thread AS thread
FROM spip_forum AS fille, spip_forum AS maman
WHERE fille.id_parent = maman.id_forum
AND fille.id_thread <> maman.id_thread
ORDER BY thread");
while (list($id, $thread) = spip_fetch_array($r)) {
if ($thread == $precedent)
$discussion .= ",$id";
else {
if ($precedent)
spip_query("UPDATE spip_forum SET id_thread=$precedent
WHERE id_forum IN ($discussion)");
$precedent = $thread;
$discussion = "$id";
}
}
spip_query("UPDATE spip_forum SET id_thread=$precedent
WHERE id_forum IN ($discussion)");
} while ($discussion != "0");
}
// Calculs des URLs des forums (pour l'espace public)
function racine_forum($id_forum){
if (!$id_forum = intval($id_forum)) return;
$query = "SELECT id_parent, id_rubrique, id_article, id_breve FROM spip_forum WHERE id_forum=".$id_forum;
$result = spip_query($query);
if($row = spip_fetch_array($result)){
if($row['id_parent']) {
return racine_forum($row['id_parent']);
}
else {
if($row['id_rubrique']) return array('rubrique',$row['id_rubrique'], $id_forum);
if($row['id_article']) return array('article',$row['id_article'], $id_forum);
if($row['id_breve']) return array('breve',$row['id_breve'], $id_forum);
}
}
}
function generer_url_forum_dist($id_forum, $show_thread=false) {
list($type, $id, $id_thread) = racine_forum($id_forum);
if ($id_thread>0 AND $show_thread)
$id_forum = $id_thread;
switch($type) {
case 'article':
return generer_url_article($id)."#forum$id_forum";
break;
case 'breve':
return generer_url_breve($id)."#forum$id_forum";
break;
case 'rubrique':
return generer_url_rubrique($id)."#forum$id_forum";
break;
case 'site':
return generer_url_site($id)."#forum$id_forum";
break;
default:
return "forum.php3?id_forum=".$id_forum;
}
}
// Recuperer le reglage des forums publics de l'article x
function get_forums_publics($id_article=0) {
$forums_publics = lire_meta("forums_publics");
if ($id_article) {
$query = "SELECT accepter_forum FROM spip_articles WHERE id_article=$id_article";
$res = spip_query($query);
if ($obj = spip_fetch_array($res))
$forums_publics = $obj['accepter_forum'];
} else { // dans ce contexte, inutile
$forums_publics = substr(lire_meta("forums_publics"),0,3);
}
return $forums_publics;
}
// Modifier le reglage des forums publics de l'article x
function modifier_forums_publics($id_article, $forums_publics) {
spip_query ("UPDATE spip_articles
SET accepter_forum='$forums_publics'
WHERE id_article=".intval($id_article));
if ($forums_publics == 'abo') {
ecrire_meta('accepter_visiteurs', 'oui');
ecrire_metas();
}
include_ecrire('inc_invalideur.php3');
suivre_invalideur("id='id_forum/a$id_article'");
}
// Cree le formulaire de modification du reglage des forums de l'article
function formulaire_modification_forums_publics($id_article, $forums_publics) {
global $spip_lang_right;
$r = "\n