<?php
    require_once("classes.php");
    $sk = Factory::getSkeleton();
    $request = Factory::getRequete();
    $db = Factory::getDB();

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