Mercurial > defr > DualBlog

annotate index.php @ 39:876d42d93e5b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Suppression du mode RSS, l'ancienne url pointe maintenant vers le flux Atom. Vu la facon dont est concu RSS, il n'y a pas vraiment moyen pour proprement intégré le XML des posts là dedans... En conséquence, il n'y aura qu'un flux Atom 1.0.
author Franck Deroche <webmaster@defr.org>
date Mon, 05 Nov 2007 14:20:58 +0100
parents a6c3716cab6a
children f6552a610bfd
rev   line source
webmaster@0 1 <?php
webmaster@11 2 require_once("classes.php");
webmaster@11 3 $sk = Factory::getSkeleton();
webmaster@11 4 $sk->setTitle('Dual { v10 : OS Edition } Blog');
webmaster@11 5 // Détermination de la requête à exécuter
webmaster@11 6 if(!array_key_exists('mode', $_GET)) {
webmaster@11 7 $query = "
webmaster@11 8 SELECT *
webmaster@11 9 FROM Mess
webmaster@6 10 WHERE num_version='Version 10'
webmaster@6 11 ORDER BY num_mess DESC
webmaster@6 12 LIMIT 10
webmaster@11 13 ";
webmaster@11 14 } elseif($_GET['mode'] == 'cal') {
webmaster@11 15 $sk->showCalendar(true);
webmaster@11 16 $year = intval($_GET['year']);
webmaster@11 17 $month = intval($_GET['month']);
webmaster@11 18 $sk->setCalendarMonth($month, $year);
webmaster@11 19 $query = "
webmaster@6 20 SELECT *
webmaster@11 21 FROM Mess
webmaster@11 22 WHERE
webmaster@11 23 YEAR(DatePost) = $year AND
webmaster@11 24 MONTH(DatePost) = $month
webmaster@6 25 ORDER BY num_mess DESC
webmaster@11 26 LIMIT 10
webmaster@11 27 ";
webmaster@11 28 } elseif($_GET['mode'] == 'tag') {
webmaster@11 29 $tag = $_GET['tag'];
webmaster@11 30 $query = "
webmaster@11 31 SELECT *
webmaster@11 32 FROM Mess m
webmaster@11 33 LEFT JOIN Lien_Tags_Posts l ON m.num_mess=l.idMess
webmaster@11 34 LEFT JOIN Tags t ON l.idTag = t.idTag
webmaster@11 35 WHERE t.Tag='{$_GET['tag']}'
webmaster@11 36 ORDER BY num_mess DESC
webmaster@11 37 ";
webmaster@0 38 }
webmaster@11 39 $db = Factory::getDB();
webmaster@27 40 $db->query($query);
webmaster@11 41 while($row = $db->GetRow()) {
webmaster@11 42 $post = new Post($row);
webmaster@11 43 $sk->addBlogPost($post->format());
webmaster@36 44 $sk->checkUpdateTime(strtotime($row['DatePost']));
webmaster@0 45 }
webmaster@11 46 echo $sk;
webmaster@0 47 ?>