Changeset 697 for trunk/include

Timestamp:

Jan 16, 2005, 6:27:34 PM (20 years ago)

Author:

plg

Message:

• calendar : use MySQL instead of PHP to find the day of the week

File:

• trunk/include/category_calendar.inc.php (modified) (2 diffs)

trunk/include/category_calendar.inc.php

@@ -321 +321 @@
     $query = '
 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'].'
@@ -332 +333 @@
 
     list($year,$month,$day) = explode('-', $calendar_day);
-    $unixdate = mktime(0,0,0,$month,$day,$year);
-    $name = $lang['day'][date("w", $unixdate)];
+    $name = $lang['day'][$row['dow']-1];
     $name.= ' '.$day;
     $name.= ' ('.$nb_pics.')';