Changeset 896
- Timestamp:
- Oct 17, 2005, 11:11:19 PM (18 years ago)
- Location:
- trunk
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/doc/ChangeLog
r894 r896 1 1 2005-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 8 2005-10-17 volcom 2 9 3 10 * new: history details by month,day -
trunk/include/category_calendar.inc.php
r867 r896 158 158 // the number of picture for this day : $calendar_days 159 159 $query = ' 160 SELECT DISTINCT('.$conf['calendar_datefield'].') AS day, COUNT(id) AS count 160 SELECT 161 DISTINCT DATE_FORMAT('.$conf['calendar_datefield'].', \'%Y-%m-%d\') AS day 162 , COUNT(id) AS count 161 163 FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id 162 164 '.$page['where'].'
Note: See TracChangeset
for help on using the changeset viewer.