/[drupal]/contributions/modules/week/week.module
ViewVC logotype

Diff of /contributions/modules/week/week.module

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.21, Tue Nov 10 03:12:13 2009 UTC revision 1.22, Tue Nov 10 03:21:15 2009 UTC
# Line 1  Line 1 
1  <?php  <?php
2  /* $Id: week.module,v 1.19.2.1.2.8 2009/11/07 17:37:30 prometheus6 Exp $ */  /* $Id: week.module,v 1.21 2009/11/10 03:12:13 prometheus6 Exp $ */
3  define('ARCHIVEROOTBEFORETYPE', 1);  define('ARCHIVEROOTBEFORETYPE', 1);
4  define('TYPEBEFOREARCHIVEROOT', 2);  define('TYPEBEFOREARCHIVEROOT', 2);
5    
# Line 184  function week_links_query($node_types) { Line 184  function week_links_query($node_types) {
184      MONTH(FROM_UNIXTIME(created)) AS month      MONTH(FROM_UNIXTIME(created)) AS month
185      FROM {node} n ";      FROM {node} n ";
186    $query .= 'WHERE n.type IN ('. implode(',', $node_types) .') ';    $query .= 'WHERE n.type IN ('. implode(',', $node_types) .') ';
187    $query .= ' AND status = 1 ';    $query .= " AND n.language IN ('','{$GLOBALS['language']->language}')";
188      $query .= ' AND n.status = 1 ';
189    $query .= ' GROUP BY yearweek ORDER BY yearweek ';    $query .= ' GROUP BY yearweek ORDER BY yearweek ';
190    $query .= $week_rev_linksort ? ' ASC' : ' DESC ';    $query .= $week_rev_linksort ? ' ASC' : ' DESC ';
191    return $query;    return $query;
# Line 382  function week_post_query($week_include_n Line 383  function week_post_query($week_include_n
383      WHERE YEAR(FROM_UNIXTIME(n.created)) = '{$year}'      WHERE YEAR(FROM_UNIXTIME(n.created)) = '{$year}'
384      AND WEEK(FROM_UNIXTIME(n.created), $week_option) = '{$week}'";      AND WEEK(FROM_UNIXTIME(n.created), $week_option) = '{$week}'";
385    $query .= ' AND n.type IN ('. implode(',', $node_types) .') ';    $query .= ' AND n.type IN ('. implode(',', $node_types) .') ';
386    $query .= ' AND status = 1 ';    $query .= " AND n.language IN ('','{$GLOBALS['language']->language}')";
387      $query .= ' AND n.status = 1 ';
388    $query .= ' ORDER BY n.created';    $query .= ' ORDER BY n.created';
389    $query .= $week_rev_pagesort ? '' : ' DESC ';    $query .= $week_rev_pagesort ? '' : ' DESC ';
390    return $query;    return $query;
Legend:
Removed from v.1.21  
changed lines
  Added in v.1.22
  ViewVC Help
Powered by ViewVC 1.1.2