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

Diff of /contributions/modules/stumble/stumble.module

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

revision 1.2.4.7, Sat Dec 13 20:44:12 2008 UTC revision 1.2.4.8, Wed Dec 24 14:13:46 2008 UTC
# Line 95  function _stumble_get_random_nid($node_t Line 95  function _stumble_get_random_nid($node_t
95    $unread = $uid && stumble_var('stumble_prefer_unread');    $unread = $uid && stumble_var('stumble_prefer_unread');
96    
97    $placeholders = db_placeholders($node_types, 'varchar');    $placeholders = db_placeholders($node_types, 'varchar');
   $sql = "SELECT COUNT(n.nid) AS count, MAX(n.nid) AS max, MIN(n.nid) AS min FROM {node} n WHERE n.status = 1 AND n.nid NOT IN ($subquery_sql) AND n.type IN ($placeholders)";  
   
98    $subquery_sql = $unread ? "SELECT h.nid FROM {history} h WHERE h.uid = %d" : '%d';    $subquery_sql = $unread ? "SELECT h.nid FROM {history} h WHERE h.uid = %d" : '%d';
99      $sql = "SELECT COUNT(n.nid) AS count, MAX(n.nid) AS max, MIN(n.nid) AS min FROM {node} n WHERE n.status = 1 AND n.nid NOT IN ($subquery_sql) AND n.type IN ($placeholders)";
100    $args = array_merge(array($unread ? $uid : $nid), $node_types);    $args = array_merge(array($unread ? $uid : $nid), $node_types);
101    
102    $nodes = db_fetch_object(db_query(db_rewrite_sql($sql), $args));    $nodes = db_fetch_object(db_query(db_rewrite_sql($sql), $args));
Legend:
Removed from v.1.2.4.7  
changed lines
  Added in v.1.2.4.8
  ViewVC Help
Powered by ViewVC 1.1.2