Mercurial > defr > DualBlog

annotate index.php @ 76:55582b82c43d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Leger changement sur les tags, tag1 |tag2 => tag1 | tag2. Techniquement, on stocke desormais un array des tags. Accessoirement, en bonus, on vire les quelques tabs qui se trouvaient dans ce fichier pour les remplacer par des espaces.
author Franck Deroche <webmaster@defr.org>
date Sun, 29 Jun 2008 22:34:01 +0200
parents f6552a610bfd
children 2a03eac5e9ca
rev   line source
webmaster@0 1 <?php
webmaster@11 2 require_once("classes.php");
webmaster@11 3 $sk = Factory::getSkeleton();
webmaster@11 4 // Détermination de la requête à exécuter
webmaster@11 5 if(!array_key_exists('mode', $_GET)) {
webmaster@11 6 $query = "
webmaster@11 7 SELECT *
webmaster@11 8 FROM Mess
webmaster@6 9 WHERE num_version='Version 10'
webmaster@6 10 ORDER BY num_mess DESC
webmaster@6 11 LIMIT 10
webmaster@11 12 ";
webmaster@44 13 $sk->setTitle('Dual { v10 : OS Edition } Blog');
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@44 19 $sk->setTitle(TextUtils::getMonthName($month) . " $year - Dual Blog");
webmaster@11 20 $query = "
webmaster@6 21 SELECT *
webmaster@11 22 FROM Mess
webmaster@11 23 WHERE
webmaster@11 24 YEAR(DatePost) = $year AND
webmaster@11 25 MONTH(DatePost) = $month
webmaster@6 26 ORDER BY num_mess DESC
webmaster@11 27 LIMIT 10
webmaster@11 28 ";
webmaster@11 29 } elseif($_GET['mode'] == 'tag') {
webmaster@11 30 $tag = $_GET['tag'];
webmaster@44 31 $sk->setTitle("Tag: $tag - Dual Blog");
webmaster@11 32 $query = "
webmaster@11 33 SELECT *
webmaster@11 34 FROM Mess m
webmaster@11 35 LEFT JOIN Lien_Tags_Posts l ON m.num_mess=l.idMess
webmaster@11 36 LEFT JOIN Tags t ON l.idTag = t.idTag
webmaster@11 37 WHERE t.Tag='{$_GET['tag']}'
webmaster@11 38 ORDER BY num_mess DESC
webmaster@11 39 ";
webmaster@0 40 }
webmaster@11 41 $db = Factory::getDB();
webmaster@27 42 $db->query($query);
webmaster@11 43 while($row = $db->GetRow()) {
webmaster@11 44 $post = new Post($row);
webmaster@11 45 $sk->addBlogPost($post->format());
webmaster@36 46 $sk->checkUpdateTime(strtotime($row['DatePost']));
webmaster@0 47 }
webmaster@11 48 echo $sk;
webmaster@0 49 ?>