From 5865079907e0f2bfa2ee3e5b840929fefe361fc5 Mon Sep 17 00:00:00 2001
From: plegall <plg@piwigo.org>
Date: Thu, 23 Feb 2006 21:38:00 +0000
Subject: bug 278 fixed: calendar on date_available could not work because
 date_available has a datetime MySQL column format while date_creation has a
 date MySQL column format. We use DATE_FORMAT MySQL function to resolv this
 issue.

git-svn-id: http://piwigo.org/svn/branches/branch-1_5@1054 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 include/category_calendar.inc.php  | 9 ++++++---
 include/functions_category.inc.php | 2 +-
 2 files changed, 7 insertions(+), 4 deletions(-)

diff --git a/include/category_calendar.inc.php b/include/category_calendar.inc.php
index a355a9339..f4eb87359 100644
--- a/include/category_calendar.inc.php
+++ b/include/category_calendar.inc.php
@@ -187,7 +187,8 @@ elseif (isset($page['calendar_day']))
 SELECT category_id AS category, COUNT(id) AS count
   FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id
   '.$page['where'].'
-    AND '.$conf['calendar_datefield'].' = \''.$page['calendar_date'].'\'
+    AND DATE_FORMAT('.$conf['calendar_datefield'].', \'%Y-%c-%e\')'
+    .' = \''.$page['calendar_date'].'\'
   GROUP BY category_id
 ;';
   $result = pwg_query($query);
@@ -337,7 +338,8 @@ SELECT file,tn_ext,'.$conf['calendar_datefield'].',path
        , DAYOFWEEK(\''.$calendar_day.'\') AS dow
   FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id
   '.$page['where'].'
-    AND '.$conf['calendar_datefield'].' = \''.$calendar_day.'\'
+    AND DATE_FORMAT('.$conf['calendar_datefield'].', \'%Y-%m-%d\')'
+      .' = \''.$calendar_day.'\'
   ORDER BY RAND()
   LIMIT 0,1
 ;';
@@ -405,7 +407,8 @@ elseif (isset($page['calendar_day']))
 SELECT file,tn_ext,'.$conf['calendar_datefield'].',path
   FROM '.IMAGES_TABLE.', '.IMAGE_CATEGORY_TABLE.'
   '.$page['where'].'
-    AND '.$conf['calendar_datefield'].' = \''.$page['calendar_date'].'\'';
+    AND DATE_FORMAT('.$conf['calendar_datefield'].', \'%Y-%c-%e\')'
+      .' = \''.$page['calendar_date'].'\'';
     if ($calendar_category != 0)
     {
       $query.= '
diff --git a/include/functions_category.inc.php b/include/functions_category.inc.php
index ad118a905..fc2bb3c25 100644
--- a/include/functions_category.inc.php
+++ b/include/functions_category.inc.php
@@ -487,7 +487,7 @@ function initialize_category( $calling_page = 'category' )
           $key = $datefield;
           if (isset($search['fields'][$key]))
           {
-            $local_clause = $datefield." = '";
+            $local_clause = 'DATE_FORMAT('.$datefield.", '%Y-%m-%d') = '";
             $local_clause.= str_replace('.', '-',
                                         $search['fields'][$key]['words'][0]);
             $local_clause.= "'";
-- 
cgit v1.2.3