webmaster@0: <?php
webmaster@11:     require_once("classes.php");
webmaster@11:     $sk = Factory::getSkeleton();
franck@86:     $request = Factory::getRequete();
franck@86:     $db = Factory::getDB();
franck@86: 
webmaster@11:     // Détermination de la requête à exécuter
franck@86:     if(!$request->varSet('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@44:     	$sk->setTitle('Dual { v10 : OS Edition } Blog');
franck@86:     } elseif($request->get('mode') == 'cal') {
webmaster@11:         $sk->showCalendar(true);
franck@86:         $year = intval($request->get('year'));
franck@86:         $month = intval($request->get('month'));
webmaster@11:         $sk->setCalendarMonth($month, $year);
webmaster@44:         $sk->setTitle(TextUtils::getMonthName($month) . " $year - Dual Blog");
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:         ";
franck@86:     } elseif($request->get('mode') == 'tag') {
franck@86:         $tag = $request->get('tag');
webmaster@44:         $sk->setTitle("Tag: $tag - Dual Blog"); 
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 
franck@86:         WHERE t.Tag='{$tag}'
webmaster@11:         ORDER BY num_mess DESC
webmaster@11:         ";
webmaster@0:     }
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: ?>