Tfe

Old stuff/old_sites/portail/include/pigeonnier.php

<div class="calendrier"><?
if ($_GET['id']) 
{
    ereg("^([0-9]{4})\/([0-9]{2})",$_GET['id'],$regs);
}

    
    
    
$mois  = array(0,31,28,31,30,31,30,31,31,30,31,30,31);
$noms = array(0,
	"Janvier",
	"F&eacute;vrier",
	"Mars",
	"Avril",
	"Mai",
	"Juin",
	"Juillet",
	"Aout",
	"Septembre",
	"Octobre",
	"Novembre",
	"D&eacute;cembre");
	
$this_month = (empty($regs[2]) ? date(n) : $regs[2]);
$this_year = (empty($regs[2]) ? date(Y) : $regs[1]);




$time = mktime(0,0,0,$this_month,1,$this_year);
$this_month = preg_replace("/0([0-9])/","$1",$this_month);


echo "
<h4>$noms[$this_month] $this_year</h4>
<table border=\"1\">
<tr>
    <th>Di</th>
    <th>Lu</th>
    <th>Ma</th>
    <th>Me</th>
    <th>Je</th>    
    <th>Ve</th>
    <th>Sa</th>
</tr>
<tr>
";
for ($i=0; $i<date(w,$time); $i++)
{
    echo "\t<td></td>\n";
}
for ($num="1"; $num<=$mois[$this_month]; $num++)
{

    if (($i % 7) == 0) { echo "</tr>\n<tr>\n"; }
    echo "\t<td>";
    if ($num<10 and $this_month <10) {  $athis_month="0".$this_month; $anum = "0".$num; }
    elseif ($num<10) {  $anum = "0".$num; $athis_mont = $this_month; }
    else{ $anum = $num; $athis_mont = $this_month; }
    $query = "SELECT * FROM  mp_blog WHERE date like '".$this_year.$athis_month.$anum."%' and pseudo='".$owner."' LIMIT 1"; 
    $result = mysql_query($query);
    if (mysql_num_rows($result) != 0)
    {     
	echo "<a href=\"index.php?page=pigeonnier&amp;id=".$this_year."/".$athis_month."/".$anum."\">$num</a>"; 
    }
    else { echo "$num"; }
    echo "</td>";
    $i++;    
}
echo "</tr>

</table>";

if ($this_year < 2005) {
echo "<h4>&nbsp;&nbsp;$this_year <a href=\"index.php?page=pigeonnier&amp;id=".($this_year+1)."/01\">&raquo;</a></h4>";
}
else 
{ echo "<h4><a href=\"index.php?page=pigeonnier&amp;id=".($this_year-1)."/12\">&laquo;</a> $this_year <a href=\"index.php?page=pigeonnier&amp;id=".($this_year+1)."/01\">&raquo;</a></h4>"; }
echo "<div>";
for ($i=1;$i<7;$i++)
{
    echo "<a href=\"index.php?page=pigeonnier&amp;id=$this_year/0$i\">0$i</a>&nbsp;&nbsp;";
}
echo "<br />";
for ($i=6;$i<13;$i++)
{
    if ($i<10) {     echo "<a href=\"index.php?page=pigeonnier&amp;id=$this_year/0$i\">0$i</a> "; }
    else  {     echo "<a href=\"index.php?page=pigeonnier&amp;id=$this_year/$i\">$i</a> "; }
}

$query = "SELECT distinct(section) FROM mp_blog WHERE pseudo='".$owner."'ORDER BY section";
$result = mysql_query($query) or die(mysql_error());
echo "<h4>Cat&eacute;gories</h4><ul>";

if (mysql_num_rows($result) == 0) { echo "<li>Aucune</li>"; }
while($row = mysql_fetch_assoc($result))
{
    echo "<li><a href=\"index.php?page=pigeonnier&amp;id=".$row['section']."\">".$row['section']."</a></li>\n"; 
}
echo "</ul>";


?>
</div>
</div>



<div class="blog">











<? // Parce que mcedit fait chier sinon 


if (empty($_GET['id']))
{
    $result = mysql_query("SELECT id,date,section,titre,contenu FROM mp_blog WHERE pseudo='".$owner."'ORDER BY id DESC LIMIT 10");
    while ($row = mysql_fetch_assoc($result))
    {
        $rquery = "SELECT count(id) FROM mp_commentaires WHERE ref='".$row{'id'}."'  and pseudo='".$owner."'";
        $rresult = mysql_query($rquery) or die(mysql_error());
        $arr = mysql_fetch_array($rresult); // $arr[0] contient le nbre de comm
    
    
        ereg("([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",$row{'date'},$regs);
        print "
	<h4>Le $regs[3]/$regs[2]/$regs[1] &agrave; $regs[4]:$regs[5]:$regs[6]: <span class=\"normal\">
    	     [<a href=\"index.php?page=pigeonnier&amp;id=".$row{'section'}."\">".$row['section']."</a>] : ".$row{'titre'}." (";
	print "<a href=\"index.php?page=pigeonnier&amp;id=$regs[1]/$regs[2]/$regs[3]/".$row{'id'}."-".$row{'titre'}."\">".$arr[0]." com.</a>)";
	     
    print "</span></h4>\n";
	affichage($row{'contenu'},0,0);
    }
}    
else {
    ereg("([0-9]{4})\/([0-9]{2})\/([0-9]{2})(\/([0-9]{1,5}))?.*",$_GET['id'],$regs);
    if (!empty($regs[5])) { $id = $regs[5];     } else { unset($id); }
    if ($id and !empty($_POST['titre']) and !empty($_POST['nick']) and  !empty($_POST['contenu']))    
    {
	echo "Ajout de commentaire... ";
	$nick = htmlentities($_POST['nick']);
	$titre= htmlentities($_POST['titre']);
	$site = htmlentities($_POST['site']);
	$contenu = text2html($_POST['contenu']);
	$query = "INSERT INTO mp_commentaires (ref,nick,site,titre,contenu,pseudo) VALUES ('".$id."','".$nick."','".$site."','".$titre."','".$contenu."','".$owner."')";
	mysql_query($query) or die(mysql_error()."<br>$query");
	echo "ok";
    }




    if (! empty($regs[5]))
    {
	$query = "SELECT id,date,section,titre,contenu FROM mp_blog WHERE id='".$regs[5]."'  and pseudo='".$owner."'AND date LIKE '".$regs[1].$regs[2].$regs[3]."%' ORDER BY id DESC"    ;
    }
    elseif (! empty($regs[3])) {$query = "SELECT id,date,section,titre,contenu FROM mp_blog WHERE pseudo='".$owner."' and date LIKE '".$regs[1].$regs[2].$regs[3]."%' ORDER BY id DESC"; }
    elseif (ereg("^([0-9]{4})\/([0-9]{2})$",$_GET['id'],$regs))
    {
	$query = "SELECT id,date,section,titre,contenu FROM mp_blog WHERE  pseudo='".$owner."' and date LIKE '".$regs[1].$regs[2]."%' ORDER BY id DESC"    ;	
    }
    else
    { $cat = htmlentities($_GET['id']); 
      $query = "SELECT * FROM mp_blog WHERE section LIKE '".$cat."' and  pseudo='".$owner."' LIMIT 20";
      
    }
    $result = mysql_query($query) or die(mysql_error()."<br>$query");
    if (mysql_num_rows($result) == 0) { die("Il n'y a aucun &eacute;l&eacute;ment pour cette date. Utilisez le menu !"); }
    while ($row = mysql_fetch_assoc($result))
    {
	$real_titre = $row{'titre'};
    
        ereg("([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",$row{'date'},$regs);
        print "
	<h4>Le $regs[3]/$regs[2]/$regs[1] &agrave; $regs[4]:$regs[5]:$regs[6]: <span class=\"normal\">
    	     [<a href=\"index.php?page=pigeonnier&amp;id=".$row{'section'}."\">".$row['section']."</a>] : <a href=\"index.php?page=pigeonnier&amp;id=".$regs[1]."/".$regs[2]."/".$regs[3]."/".$row{'id'}."\">".$row{'titre'}."</a>";
	     
	print "     </span></h4>
        ";
	affichage($row{'contenu'},0,0);
    }
    if ($id)
    {
    $query = "SELECT * FROM mp_commentaires WHERE ref='".$id."'  and pseudo='".$owner."'";
    $result = mysql_query($query);
    print "<h4>Commentaires</h4>";
    if (mysql_num_rows($result) > 0)
    {
	print "<div>";
	$i=1;
	while($row = mysql_fetch_assoc($result))
	{
	$i++;
	$class= ($i % 2 ==0 ? "noir" : "gris");
	print "<div class=\"$class\">\n";
        ereg("([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",$row{'date'},$regs);
        print "
	<h5><a href=\"".$row{'site'}."\">".$row{'nick'}."</a><span class=\"normal\">, le $regs[3]/$regs[2]/$regs[1] &agrave; $regs[4]:$regs[5]:$regs[6]:
    	     ".$row{'titre'}."     </span></h5>";
	     
	affichage($row{'contenu'},0,0);     
	echo "</div>\n";
	}	     
	print "</div>";
    }
    else { print "<p>Pas de commentaires pour l'instant.</p>"; }
    if (empty($_POST['titre']) or empty($_POST['nick']) or empty($_POST['contenu']))    
    {
	if (!empty($_POST)) { echo "<p>Veuillez remplir les champs nick, titre et contenu.</p>"; }
        print "
	<form action=\"index.php?page=pigeonnier&amp;id=".$_GET['id']."\" method=\"post\">
        <dl>
        <dt>Pseudo</dt><dd><input name=\"nick\" type=\"text\" value=\"".$_POST['nick']."\" /></dd>
            <dt>Site Internet <sup>*</sup> facultatif</dt><dd><input name=\"site\" type=\"text\" value=\"".$_POST['site']."\" /></dd>
        <dt>Titre</dt><dd><input name=\"titre\" type=\"text\" value=\"Re: ".$real_titre."\" /></dd>    
        <dt>Message</dt><dd><textarea name=\"contenu\" rows=\"5\" cols=\"25\">".$_POST['contenu']."</textarea></dd>
        <dt></dt><dd><input type=\"submit\" class=\"button\" value=\"Envoyer\" /></dd>
        </dl>
        </form>
	";
    }
    }
}







    
?>
</div>