Mercurial > defr > DualBlog

comparison index.php @ 44:f6552a610bfd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Les titres pour les tags et le calendrier sont plus parlant.
author Franck Deroche <webmaster@defr.org>
date Wed, 14 Nov 2007 17:41:32 +0100
parents a6c3716cab6a
children 2a03eac5e9ca
comparison
equal deleted inserted replaced
43:1cdb1a68634b 44:f6552a610bfd
1 <?php 1 <?php
2 require_once("classes.php"); 2 require_once("classes.php");
3 $sk = Factory::getSkeleton(); 3 $sk = Factory::getSkeleton();
4 $sk->setTitle('Dual { v10 : OS Edition } Blog');
5 // Détermination de la requête à exécuter 4 // Détermination de la requête à exécuter
6 if(!array_key_exists('mode', $_GET)) { 5 if(!array_key_exists('mode', $_GET)) {
7 $query = " 6 $query = "
8 SELECT * 7 SELECT *
9 FROM Mess 8 FROM Mess
10 WHERE num_version='Version 10' 9 WHERE num_version='Version 10'
11 ORDER BY num_mess DESC 10 ORDER BY num_mess DESC
12 LIMIT 10 11 LIMIT 10
13 "; 12 ";
13 $sk->setTitle('Dual { v10 : OS Edition } Blog');
14 } elseif($_GET['mode'] == 'cal') { 14 } elseif($_GET['mode'] == 'cal') {
15 $sk->showCalendar(true); 15 $sk->showCalendar(true);
16 $year = intval($_GET['year']); 16 $year = intval($_GET['year']);
17 $month = intval($_GET['month']); 17 $month = intval($_GET['month']);
18 $sk->setCalendarMonth($month, $year); 18 $sk->setCalendarMonth($month, $year);
19 $sk->setTitle(TextUtils::getMonthName($month) . " $year - Dual Blog");
19 $query = " 20 $query = "
20 SELECT * 21 SELECT *
21 FROM Mess 22 FROM Mess
22 WHERE 23 WHERE
23 YEAR(DatePost) = $year AND 24 YEAR(DatePost) = $year AND
25 ORDER BY num_mess DESC 26 ORDER BY num_mess DESC
26 LIMIT 10 27 LIMIT 10
27 "; 28 ";
28 } elseif($_GET['mode'] == 'tag') { 29 } elseif($_GET['mode'] == 'tag') {
29 $tag = $_GET['tag']; 30 $tag = $_GET['tag'];
31 $sk->setTitle("Tag: $tag - Dual Blog");
30 $query = " 32 $query = "
31 SELECT * 33 SELECT *
32 FROM Mess m 34 FROM Mess m
33 LEFT JOIN Lien_Tags_Posts l ON m.num_mess=l.idMess 35 LEFT JOIN Lien_Tags_Posts l ON m.num_mess=l.idMess
34 LEFT JOIN Tags t ON l.idTag = t.idTag 36 LEFT JOIN Tags t ON l.idTag = t.idTag