webmaster@0: <?php
webmaster@11:     require_once("classes.php");
webmaster@11:     $sk = Factory::getSkeleton();
webmaster@11:     $sk->setTitle('Dual { v10 : OS Edition } Blog');
webmaster@11:     // Détermination de la requête à exécuter
webmaster@11:     if(!array_key_exists('mode', $_GET)) {
webmaster@11:         $query = "
webmaster@11:         SELECT * 
webmaster@11:     	FROM Mess 
webmaster@6:         WHERE num_version='Version 10'
webmaster@6:         ORDER BY num_mess DESC
webmaster@6:         LIMIT 10
webmaster@11:         ";
webmaster@11:     } elseif($_GET['mode'] == 'cal') {
webmaster@11:         $sk->showCalendar(true);
webmaster@11:         $year = intval($_GET['year']);
webmaster@11:         $month = intval($_GET['month']);
webmaster@11:         $sk->setCalendarMonth($month, $year);
webmaster@11:         $query = "
webmaster@6:         SELECT * 
webmaster@11:     	FROM Mess 
webmaster@11:         WHERE 
webmaster@11:             YEAR(DatePost) = $year AND
webmaster@11:             MONTH(DatePost) = $month
webmaster@6:         ORDER BY num_mess DESC
webmaster@11:         LIMIT 10
webmaster@11:         ";
webmaster@11:     } elseif($_GET['mode'] == 'tag') {
webmaster@11:         $tag = $_GET['tag'];
webmaster@11:         $query = "
webmaster@11:         SELECT * 
webmaster@11:         FROM Mess m
webmaster@11:         LEFT JOIN Lien_Tags_Posts l ON m.num_mess=l.idMess
webmaster@11:         LEFT JOIN Tags t ON l.idTag = t.idTag 
webmaster@11:         WHERE t.Tag='{$_GET['tag']}'
webmaster@11:         ORDER BY num_mess DESC
webmaster@11:         ";
webmaster@0:     }
webmaster@11:     $db = Factory::getDB();
webmaster@27:     $db->query($query);
webmaster@11:     while($row = $db->GetRow()) {
webmaster@11:       $post = new Post($row);
webmaster@11:       $sk->addBlogPost($post->format());
webmaster@36:       $sk->checkUpdateTime(strtotime($row['DatePost']));
webmaster@0:     }
webmaster@11:     echo $sk;
webmaster@0: ?>