diff options
Diffstat (limited to 'modules')
| -rw-r--r-- | modules/archive.module | 3 | ||||
| -rw-r--r-- | modules/archive/archive.module | 3 |
2 files changed, 2 insertions, 4 deletions
diff --git a/modules/archive.module b/modules/archive.module index 0853bfdee..c2bde631b 100644 --- a/modules/archive.module +++ b/modules/archive.module @@ -72,8 +72,7 @@ function archive_calendar($original = 0) { $nextmonth = mktime(23, 59, 59, $month + 1, 1, $year); $next = mktime(23, 59, 59, $month + 1, min(date('t', $nextmonth), $day), $year); - - $result = db_query("SELECT created FROM {node} WHERE status = 1 AND created > $start_of_month AND created < $end_of_month"); + $result = db_query('SELECT DISTINCT(n.nid), n.created FROM {node} n '. node_access_join_sql() .' WHERE n.status = 1 AND n.created > %d AND n.created < %d AND '. node_access_where_sql() .' ORDER BY n.created', $start_of_month, $end_of_month); $days_with_posts = array(); while ($day_with_post = db_fetch_object($result)) { diff --git a/modules/archive/archive.module b/modules/archive/archive.module index 0853bfdee..c2bde631b 100644 --- a/modules/archive/archive.module +++ b/modules/archive/archive.module @@ -72,8 +72,7 @@ function archive_calendar($original = 0) { $nextmonth = mktime(23, 59, 59, $month + 1, 1, $year); $next = mktime(23, 59, 59, $month + 1, min(date('t', $nextmonth), $day), $year); - - $result = db_query("SELECT created FROM {node} WHERE status = 1 AND created > $start_of_month AND created < $end_of_month"); + $result = db_query('SELECT DISTINCT(n.nid), n.created FROM {node} n '. node_access_join_sql() .' WHERE n.status = 1 AND n.created > %d AND n.created < %d AND '. node_access_where_sql() .' ORDER BY n.created', $start_of_month, $end_of_month); $days_with_posts = array(); while ($day_with_post = db_fetch_object($result)) { |