Rev 7 | Blame | Last modification | View Log | RSS feed
<?php
/***************************************************************************\
* SPIP, Systeme de publication pour l'internet *
* *
* Copyright (c) 2001-2005 *
* Arnaud Martin, Antoine Pitrou, Philippe Riviere, Emmanuel Saint-James *
* *
* Ce programme est un logiciel libre distribue sous licence GNU/GPL. *
* Pour plus de details voir le fichier COPYING.txt ou l'aide en ligne. *
\***************************************************************************/
include ("inc.php3");
include_ecrire ("inc_logos.php3");
include_ecrire ("inc_mots.php3");
include_ecrire ("inc_sites.php3");
include_ecrire ("inc_date.php3");
include_ecrire ("inc_abstract_sql.php3");
include_ecrire ("inc_config.php3");
$proposer_sites = lire_meta("proposer_sites");
function calculer_droits() {
global $connect_statut, $statut, $id_rubrique, $id_rubrique_depart, $proposer_sites, $new;
global $flag_editable, $flag_administrable;
$flag_administrable = ($connect_statut == '0minirezo' AND acces_rubrique($id_rubrique));
if ($id_rubrique_depart > 0)
$flag_administrable &= acces_rubrique($id_rubrique_depart);
$flag_editable = ($flag_administrable OR ($proposer_sites > 0 AND ($statut == 'prop' OR $new == 'oui')));
}
//
// Creation d'un site
//
if ($new == 'oui') {
calculer_droits();
if ($flag_editable) {
$id_rubrique = intval($id_rubrique);
$mydate = date("YmdHis", time() - 12 * 3600);
$query = "DELETE FROM spip_syndic WHERE (statut = 'refuse') && (maj < $mydate)";
$result = spip_query($query);
$moderation = (lire_meta("moderation_sites") == "oui")? 'oui' : 'non';
$id_syndic = spip_abstract_insert("spip_syndic",
"(nom_site, id_rubrique, id_secteur, date, date_syndic, statut, syndication, moderation)",
"('"._T('avis_site_introuvable')."', $id_rubrique, $id_rubrique, NOW(), NOW(), 'refuse', 'non', '$moderation')");
}
} else $id_syndic = intval($id_syndic);
$result = spip_query("SELECT statut, id_rubrique FROM spip_syndic
WHERE id_syndic=$id_syndic");
if ($row = spip_fetch_array($result)) {
$statut = $row["statut"];
$id_rubrique_depart = $row["id_rubrique"];
if (!$id_rubrique) $id_rubrique = $id_rubrique_depart;
}
if ($new == 'oui') $statut = 'prop';
calculer_droits();
//
// Analyse automatique d'une URL
//
if ($analyser_site == 'oui' AND $flag_editable) {
$v = analyser_site($url);
if ($v) {
$nom_site = addslashes($v['nom_site']);
$url_site = addslashes($v['url_site']);
if (!$nom_site) $nom_site = $url_site;
$url_syndic = addslashes($v['url_syndic']);
$descriptif = addslashes($v['descriptif']);
$syndication = $v[syndic] ? 'oui' : 'non';
$result = spip_query("UPDATE spip_syndic ".
"SET nom_site='$nom_site', url_site='$url_site',
url_syndic='$url_syndic', descriptif='$descriptif',
syndication='$syndication', statut='$statut'
WHERE id_syndic=$id_syndic");
if ($syndication == 'oui') syndic_a_jour($id_syndic);
$link = new Link('sites.php3');
$link->addVar('id_syndic');
$link->addVar('redirect');
$redirect = $link->getUrl();
$redirect_ok = 'oui';
}
}
//
// Ajout et suppression syndication
//
if ($nouveau_statut AND $flag_administrable) {
$statut = $nouveau_statut;
$result = spip_query("UPDATE spip_syndic SET statut='$statut'
WHERE id_syndic=$id_syndic");
if ($statut == 'publie')
spip_query("UPDATE spip_syndic SET date=NOW() WHERE
id_syndic=$id_syndic");
calculer_rubriques();
if ($statut == 'publie') {
if (lire_meta('activer_moteur') == 'oui') {
include_ecrire ("inc_index.php3");
marquer_indexer('syndic', $id_syndic);
}
}
}
if ($nom_site AND $modifier_site == 'oui' AND $flag_editable) {
$nom_site = addslashes($nom_site);
$url_site = addslashes($url_site);
$descriptif = addslashes($descriptif);
if (strlen($url_syndic) < 8) $syndication = "non";
$url_syndic = addslashes($url_syndic);
// recoller les champs du extra
if ($champs_extra) {
include_ecrire("inc_extra.php3");
$add_extra = ", extra = '".addslashes(extra_recup_saisie("sites", $id_secteur))."'";
} else
$add_extra = '';
spip_query("UPDATE spip_syndic SET id_rubrique='$id_rubrique',
nom_site='$nom_site', url_site='$url_site', url_syndic='$url_syndic',
descriptif='$descriptif', syndication='$syndication', statut='$statut'
$add_extra WHERE id_syndic=$id_syndic");
if ($syndication_old != $syndication OR $url_syndic != $old_syndic)
$reload = "oui";
if ($syndication_old != $syndication AND $syndication == "non")
spip_query("DELETE FROM spip_syndic_articles
WHERE id_syndic=$id_syndic");
calculer_rubriques();
// invalider et reindexer
if ($statut == 'publie') {
if ($invalider_caches) {
include_ecrire ("inc_invalideur.php3");
suivre_invalideur("id='id_syndic/$id_syndic'");
}
if (lire_meta('activer_moteur') == 'oui') {
include_ecrire ("inc_index.php3");
marquer_indexer('syndic', $id_syndic);
}
}
$link = new Link('sites.php3');
$link->addVar('id_syndic');
$link->addVar('redirect');
$link->addVar('reload', $reload);
$redirect = $link->getUrl();
$redirect_ok = 'oui';
}
if ($jour AND $flag_administrable) {
if ($annee == "0000") $mois = "00";
if ($mois == "00") $jour = "00";
spip_query("UPDATE spip_syndic SET date='$annee-$mois-$jour'
WHERE id_syndic=$id_syndic");
calculer_rubriques();
}
if ($redirect AND $redirect_ok == 'oui') {
redirige_par_entete($redirect);
}
//
// reload
//
if ($reload) {
$result = spip_query ("SELECT * FROM spip_syndic WHERE id_syndic=$id_syndic
AND syndication IN ('oui', 'sus', 'off')");
if ($result AND spip_num_rows($result)>0)
$erreur_syndic = syndic_a_jour ($id_syndic);
}
//
// Afficher la page
//
calculer_droits();
$result = spip_query("SELECT * FROM spip_syndic WHERE id_syndic=$id_syndic");
if ($row = spip_fetch_array($result)) {
$id_syndic = $row["id_syndic"];
$id_rubrique = $row["id_rubrique"];
$nom_site = $row["nom_site"];
$url_site = $row["url_site"];
$url_syndic = $row["url_syndic"];
$descriptif = $row["descriptif"];
$syndication = $row["syndication"];
$statut = $row["statut"];
$date_heure = $row["date"];
$date_syndic = $row['date_syndic'];
$mod = $row['moderation'];
$extra=$row["extra"];
}
if ($nom_site)
$titre_page = "« $nom_site »";
else
$titre_page = _T('info_site');
debut_page("$titre_page","documents","sites");
//////// parents
debut_grand_cadre();
afficher_hierarchie($id_rubrique);
fin_grand_cadre();
debut_gauche();
debut_boite_info();
echo "<center>";
echo "<font face='Verdana,Arial,Sans,sans-serif' size=1><b>"._T('titre_site_numero')."</b></font>";
echo "<br><font face='Verdana,Arial,Sans,sans-serif' size=6><b>$id_syndic</b></font>\n";
voir_en_ligne ('site', $id_syndic, $statut);
echo "</center>";
fin_boite_info();
echo "<p><center>";
icone (_T('icone_voir_sites_references'), "sites_tous.php3", "site-24.gif","rien.gif");
echo "</center>";
if ($id_syndic AND $flag_administrable)
afficher_boite_logo('site', 'id_syndic', $id_syndic, _T('logo_site')." ".aide ("rublogo"), _T('logo_survol'), 'site');
debut_droite();
debut_cadre_relief("site-24.gif");
echo "<center>";
if ($syndication == 'off' OR $syndication == 'sus') {
$logo_statut = "puce-orange-anim.gif";
}
else if ($statut == 'publie') {
$logo_statut = "puce-verte.gif";
}
else if ($statut == 'prop') {
$logo_statut = "puce-blanche.gif";
}
else if ($statut == 'refuse') {
$logo_statut = "puce-rouge.gif";
}
echo "\n<table cellpadding=0 cellspacing=0 border=0 width='100%'>";
echo "<tr width='100%'><td width='100%' valign='top'>";
gros_titre($nom_site, $logo_statut);
$url_affichee = $url_site;
if (strlen($url_affichee) > 40) $url_affichee = substr($url_affichee, 0, 30)."...";
echo "<a href='$url_site'><b>$url_affichee</b></a>";
if (strlen($descriptif) > 1) {
echo "<p><div align='left' style='padding: 5px; border: 1px dashed #aaaaaa; background-color: #e4e4e4;'>";
echo "<font size=2 face='Verdana,Arial,Sans,sans-serif'>";
echo "<b>"._T('info_descriptif')."</b> ";
echo propre($descriptif);
echo " ";
echo "</font>";
echo "</div>";
}
echo "</td>";
if ($flag_editable) {
$link = new Link('sites_edit.php3');
$link->addVar('id_syndic');
$link->addVar('target', $clean_link->getUrl());
echo "<td>". http_img_pack('rien.gif', " ", "width='5'") . "</td>\n";
echo "<td align='right'>";
icone(_T('icone_modifier_site'), $link->getUrl(), "site-24.gif", "edit.gif");
echo "</td>";
}
echo "</tr></table>\n";
if ($flag_editable AND ($options == 'avancees' OR $statut == 'publie')) {
if ($statut == 'publie') {
echo "<p>";
if (ereg("([0-9]{4})-([0-9]{2})-([0-9]{2})", $date_heure, $regs)) {
$mois = $regs[2];
$jour = $regs[3];
$annee = $regs[1];
}
debut_cadre_enfonce();
echo afficher_formulaire_date("sites.php3?id_syndic=$id_syndic&options=$options", _T('info_date_referencement'), $jour, $mois, $annee);
fin_cadre_enfonce();
}
else {
echo "<BR><FONT FACE='Verdana,Arial,Sans,sans-serif' SIZE=3>"._T('info_site_propose')." <B>".affdate($date_heure)." </B></FONT><P>";
}
}
if ($flag_editable AND $options == 'avancees') {
formulaire_mots('syndic', $id_syndic, $nouv_mot, $supp_mot, $cherche_mot, $flag_editable);
}
if ($flag_administrable) {
$link = $GLOBALS['clean_link'];
$link->delVar('new');
echo $link->getForm('GET');
debut_cadre_relief("racine-site-24.gif");
echo "\n<center>";
echo "<b>"._T('info_statut_site_1')."</b> \n";
echo "<select name='nouveau_statut' size=1 class='fondl'>\n";
echo my_sel("publie",_T('info_statut_site_2'),$statut);
echo my_sel("prop",_T('info_statut_site_3'),$statut);
echo my_sel("refuse",_T('info_statut_site_4'),$statut);
echo "</select>\n";
echo " <input type='submit' name='Valider' value='"._T('bouton_valider')."' class='fondo'>\n</center>\n";
fin_cadre_relief();
echo "</form>\n";
}
if ($syndication == "oui" OR $syndication == "off" OR $syndication == "sus") {
echo "<p><font size=3 face='Verdana,Arial,Sans,sans-serif'><b>"._T('info_site_syndique')."</b></font>";
if ($erreur_syndic)
echo "<p><font color=red><b>$erreur_syndic</b></font>";
if ($syndication == "off" OR $syndication=="sus") {
debut_boite_info();
echo _T('avis_site_syndique_probleme', array('url_syndic' => $url_syndic));
echo "<center><b>";
echo "<a href='sites.php3?id_syndic=$id_syndic&reload=oui'>";
echo _T('lien_nouvelle_recuperation')."</a></b></center>\n";
fin_boite_info();
}
afficher_syndic_articles(_T('titre_articles_syndiques'),
"SELECT * FROM spip_syndic_articles WHERE id_syndic=$id_syndic
ORDER BY date DESC");
echo "<font face='verdana,arial,helvetica' size=2>";
// afficher la date de dernier acces a la syndication
if ($date_syndic)
echo "<p><div align='left'>"._T('info_derniere_syndication').' '.affdate_heure($date_syndic)
.".</div>\n";
echo "<div align='right'>\n"
. "<form method='post' action='sites.php3?id_syndic=$id_syndic'>"
. "<input type='submit' name='reload' value=\""
. attribut_html(_T('lien_mise_a_jour_syndication'))
. "\" class='fondo' style='font-size:9px;' /></form></div>\n";
// Options
if ($flag_administrable && $options=='avancees') {
debut_cadre_relief();
echo "<u>"._T('syndic_options')."</u>"
. aide('artsyn')."\n"
. "<form method='POST' action='sites.php3?id_syndic=$id_syndic' class='verdana2'>\n";
// modifier la moderation
if ($moderation == 'oui' OR $moderation == 'non')
spip_query("UPDATE spip_syndic SET moderation='$moderation'
WHERE id_syndic=$id_syndic");
else
$moderation = $mod;
if ($moderation != 'oui') $moderation='non';
echo "<p><div align='$spip_lang_left'>"
. _T('syndic_choix_moderation') . "<br />\n";
afficher_choix('moderation', $moderation,
array(
'non' => _T('info_publier')
.' ('._T('bouton_radio_modere_posteriori').')',
'oui' => _T('info_bloquer')
.' ('._T('bouton_radio_modere_priori').')'
));
// Oublier les vieux liens ?
# appliquer les choix
if ($miroir == 'oui' OR $miroir == 'non')
spip_query("UPDATE spip_syndic SET miroir='$miroir'
WHERE id_syndic=$id_syndic");
if ($oubli == 'oui' OR $oubli == 'non')
spip_query("UPDATE spip_syndic SET oubli='$oubli'
WHERE id_syndic=$id_syndic");
echo "<p><div align='left'>"._T('syndic_choix_oublier');
echo "<ul>\n";
# miroir
if (!$miroir AND !$miroir = $row['miroir']) $miroir = 'non';
echo "<li>"._T('syndic_option_miroir').' ';
afficher_choix('miroir', $miroir,
array('oui' => _T('item_oui'), 'non' => _T('item_non')),
" ");
echo "</li>\n";
# oubli
if (!$oubli AND !$oubli = $row['oubli']) $oubli = 'non';
echo "<li>"._T('syndic_option_oubli', array('mois' => 2)).' ';
afficher_choix('oubli', $oubli,
array('oui' => _T('item_oui'), 'non' => _T('item_non')),
" ");
echo "</li>\n";
echo "</ul>\n";
// Bouton "Valider"
echo "<div style='text-align:$spip_lang_right'><INPUT TYPE='submit' NAME='Valider' VALUE='"._T('bouton_valider')."' CLASS='fondo'></div>";
fin_cadre_relief();
}
echo "</font>";
}
// Cas d'un site ayant un feedfinder detecte
else if (preg_match(',^select: (.*),', $url_syndic, $regs)) {
echo "<br /><br />\n";
echo "<form method='post' action='sites.php3?id_syndic=$id_syndic'>";
foreach (
array('id_rubrique', 'nom_site', 'url_site', 'descriptif', 'statut')
as $var) {
echo "<input type='hidden' name='$var' value=\"".entites_html($$var)."\" />";
}
echo debut_cadre_relief();
echo "<div align='$spip_lang_left'>\n";
echo "<INPUT TYPE='radio' NAME='syndication' VALUE='non' id='syndication_non' CHECKED>";
echo " <b><label for='syndication_non'>"._T('bouton_radio_non_syndication')."</label></b><p>";
echo "<INPUT TYPE='radio' NAME='syndication' VALUE='oui' id='syndication_oui'>";
echo " <b><label for='syndication_oui'>"._T('bouton_radio_syndication')."</label></b> ";
$feeds = explode(' ',$regs[1]);
echo "<select name='url_syndic'>\n";
foreach ($feeds as $feed) {
echo '<option value="'.entites_html($feed).'">'.$feed."</option>\n";
}
echo "</select>\n";
echo aide("rubsyn");
echo '<input type="hidden" name="modifier_site" value="oui" />';
echo '<input type="hidden" name="reload" value="oui" />';
echo "<div align='$spip_lang_right'><input type='submit' name='Valider' value='"._T('bouton_valider')."' class='fondo'></div>\n";
echo fin_cadre_relief();
echo "</div></form>\n";
}
if ($champs_extra AND $extra) {
include_ecrire("inc_extra.php3");
extra_affichage($extra, "sites");
}
fin_cadre_relief();
//////////////////////////////////////////////////////
// Forums
//
echo "<br><br>\n";
$forum_retour = "sites.php3?id_syndic=$id_syndic";
$link = new Link('forum_envoi.php3');
$link->addVar('statut', 'prive');
$link->addVar('adresse_retour', $forum_retour);
$link->addVar('id_syndic');
$link->addVar('titre_message', $nom_site);
echo "<div align='center'>";
icone (_T('icone_poster_message'), $link->getUrl(), "forum-interne-24.gif", "creer.gif");
echo "</div>";
echo "<p align='left'>\n";
$result_forum = spip_query("SELECT * FROM spip_forum WHERE statut='prive'
AND id_syndic=$id_syndic AND id_parent=0 ORDER BY date_heure DESC LIMIT 0,20");
afficher_forum($result_forum, $forum_retour);
fin_page();
?>