Mercurial > defr > DualBlog
annotate index.php @ 86:2a03eac5e9ca
index.php: Refactor pour utiliser Requete
author | Franck Deroche <franck@defr.org> |
---|---|
date | Sun, 02 Dec 2018 21:30:47 +0100 |
parents | f6552a610bfd |
children |
rev | line source |
---|---|
webmaster@0 | 1 <?php |
webmaster@11 | 2 require_once("classes.php"); |
webmaster@11 | 3 $sk = Factory::getSkeleton(); |
franck@86 | 4 $request = Factory::getRequete(); |
franck@86 | 5 $db = Factory::getDB(); |
franck@86 | 6 |
webmaster@11 | 7 // Détermination de la requête à exécuter |
franck@86 | 8 if(!$request->varSet('mode', 'GET')) { |
webmaster@11 | 9 $query = " |
webmaster@11 | 10 SELECT * |
webmaster@11 | 11 FROM Mess |
webmaster@6 | 12 WHERE num_version='Version 10' |
webmaster@6 | 13 ORDER BY num_mess DESC |
webmaster@6 | 14 LIMIT 10 |
webmaster@11 | 15 "; |
webmaster@44 | 16 $sk->setTitle('Dual { v10 : OS Edition } Blog'); |
franck@86 | 17 } elseif($request->get('mode') == 'cal') { |
webmaster@11 | 18 $sk->showCalendar(true); |
franck@86 | 19 $year = intval($request->get('year')); |
franck@86 | 20 $month = intval($request->get('month')); |
webmaster@11 | 21 $sk->setCalendarMonth($month, $year); |
webmaster@44 | 22 $sk->setTitle(TextUtils::getMonthName($month) . " $year - Dual Blog"); |
webmaster@11 | 23 $query = " |
webmaster@6 | 24 SELECT * |
webmaster@11 | 25 FROM Mess |
webmaster@11 | 26 WHERE |
webmaster@11 | 27 YEAR(DatePost) = $year AND |
webmaster@11 | 28 MONTH(DatePost) = $month |
webmaster@6 | 29 ORDER BY num_mess DESC |
webmaster@11 | 30 LIMIT 10 |
webmaster@11 | 31 "; |
franck@86 | 32 } elseif($request->get('mode') == 'tag') { |
franck@86 | 33 $tag = $request->get('tag'); |
webmaster@44 | 34 $sk->setTitle("Tag: $tag - Dual Blog"); |
webmaster@11 | 35 $query = " |
webmaster@11 | 36 SELECT * |
webmaster@11 | 37 FROM Mess m |
webmaster@11 | 38 LEFT JOIN Lien_Tags_Posts l ON m.num_mess=l.idMess |
webmaster@11 | 39 LEFT JOIN Tags t ON l.idTag = t.idTag |
franck@86 | 40 WHERE t.Tag='{$tag}' |
webmaster@11 | 41 ORDER BY num_mess DESC |
webmaster@11 | 42 "; |
webmaster@0 | 43 } |
webmaster@27 | 44 $db->query($query); |
webmaster@11 | 45 while($row = $db->GetRow()) { |
webmaster@11 | 46 $post = new Post($row); |
webmaster@11 | 47 $sk->addBlogPost($post->format()); |
webmaster@36 | 48 $sk->checkUpdateTime(strtotime($row['DatePost'])); |
webmaster@0 | 49 } |
webmaster@11 | 50 echo $sk; |
webmaster@0 | 51 ?> |