<?php
    require_once("classes.php");
    $sk = Factory::getSkeleton();
    $sk->setTitle('Dual { v10 : OS Edition } Blog');
    // Détermination de la requête à exécuter
    if(!array_key_exists('mode', $_GET)) {
        $query = "
        SELECT * 
    	FROM Mess 
        WHERE num_version='Version 10'
        ORDER BY num_mess DESC
        LIMIT 10
        ";
    } elseif($_GET['mode'] == 'cal') {
        $sk->showCalendar(true);
        $year = intval($_GET['year']);
        $month = intval($_GET['month']);
        $sk->setCalendarMonth($month, $year);
        $query = "
        SELECT * 
    	FROM Mess 
        WHERE 
            YEAR(DatePost) = $year AND
            MONTH(DatePost) = $month
        ORDER BY num_mess DESC
        LIMIT 10
        ";
    } elseif($_GET['mode'] == 'tag') {
        $tag = $_GET['tag'];
        $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='{$_GET['tag']}'
        ORDER BY num_mess DESC
        ";
    }
    $db = Factory::getDB();
    $db->query($query);
    while($row = $db->GetRow()) {
      $post = new Post($row);
      $sk->addBlogPost($post->format());
      $sk->checkUpdateTime(strtotime($row['DatePost']));
    }
    echo $sk;
?>