Changeset 896


Ignore:
Timestamp:
Oct 17, 2005, 11:11:19 PM (18 years ago)
Author:
plg
Message:
  • bug 154 fixed: "Calendar category, too precise dates". Bug came from the bigger precision of creation_date and available_date in images tables. Need to retrieve only the year-month-day information.
Location:
trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/doc/ChangeLog

    r894 r896  
    112005-10-17 Pierrick LE GALL
     2
     3        * bug 154 fixed: "Calendar category, too precise dates". Bug came
     4        from the bigger precision of creation_date and available_date in
     5        images tables. Need to retrieve only the year-month-day
     6        information.
     7       
     82005-10-17 volcom
    29
    310        * new: history details by month,day
  • trunk/include/category_calendar.inc.php

    r867 r896  
    158158  // the number of picture for this day : $calendar_days
    159159  $query = '
    160 SELECT DISTINCT('.$conf['calendar_datefield'].') AS day, COUNT(id) AS count
     160SELECT
     161    DISTINCT DATE_FORMAT('.$conf['calendar_datefield'].', \'%Y-%m-%d\') AS day
     162  , COUNT(id) AS count
    161163  FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id
    162164  '.$page['where'].'
Note: See TracChangeset for help on using the changeset viewer.