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évrier",
"Mars",
"Avril",
"Mai",
"Juin",
"Juillet",
"Aout",
"Septembre",
"Octobre",
"Novembre",
"Dé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 "
$noms[$this_month] $this_year
Di |
Lu |
Ma |
Me |
Je |
Ve |
Sa |
";
for ($i=0; $i\n";
}
for ($num="1"; $num<=$mois[$this_month]; $num++)
{
if (($i % 7) == 0) { echo "
\n\n"; }
echo "\t";
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 "$num";
}
else { echo "$num"; }
echo " | ";
$i++;
}
echo "
";
if ($this_year < 2005) {
echo "
$this_year »
";
}
else
{ echo "
« $this_year »
"; }
echo "
";
for ($i=1;$i<7;$i++)
{
echo "
0$i ";
}
echo "
";
for ($i=6;$i<13;$i++)
{
if ($i<10) { echo "
0$i "; }
else { echo "
$i "; }
}
$query = "SELECT distinct(section) FROM mp_blog WHERE pseudo='".$owner."'ORDER BY section";
$result = mysql_query($query) or die(mysql_error());
echo "
Catégories
";
if (mysql_num_rows($result) == 0) { echo "- Aucune
"; }
while($row = mysql_fetch_assoc($result))
{
echo "- ".$row['section']."
\n";
}
echo "
";
?>
// 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 "
Le $regs[3]/$regs[2]/$regs[1] à $regs[4]:$regs[5]:$regs[6]:
[".$row['section']."] : ".$row{'titre'}." (";
print "".$arr[0]." com.)";
print "
\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()."
$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()."
$query");
if (mysql_num_rows($result) == 0) { die("Il n'y a aucun élé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 "
Le $regs[3]/$regs[2]/$regs[1] à $regs[4]:$regs[5]:$regs[6]:
[".$row['section']."] : ".$row{'titre'}."";
print "
";
affichage($row{'contenu'},0,0);
}
if ($id)
{
$query = "SELECT * FROM mp_commentaires WHERE ref='".$id."' and pseudo='".$owner."'";
$result = mysql_query($query);
print "
Commentaires
";
if (mysql_num_rows($result) > 0)
{
print "
";
$i=1;
while($row = mysql_fetch_assoc($result))
{
$i++;
$class= ($i % 2 ==0 ? "noir" : "gris");
print "
\n";
ereg("([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",$row{'date'},$regs);
print "
".$row{'nick'}.", le $regs[3]/$regs[2]/$regs[1] à $regs[4]:$regs[5]:$regs[6]:
".$row{'titre'}."
";
affichage($row{'contenu'},0,0);
echo "
\n";
}
print "
";
}
else { print "
Pas de commentaires pour l'instant.
"; }
if (empty($_POST['titre']) or empty($_POST['nick']) or empty($_POST['contenu']))
{
if (!empty($_POST)) { echo "
Veuillez remplir les champs nick, titre et contenu.
"; }
print "
";
}
}
}
?>