Mercurial > defr > DualBlog

annotate index.php @ 37:5eb974b45cb1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Deplacement de la feed atom vers le nouveau code.
author Franck Deroche <webmaster@defr.org>
date Mon, 05 Nov 2007 10:44:07 +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 ?>