/[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.6, Fri Nov 28 19:10:17 2008 UTC revision 1.2.4.7, Sat Dec 13 20:44:12 2008 UTC
# Line 97  function _stumble_get_random_nid($node_t Line 97  function _stumble_get_random_nid($node_t
97    $placeholders = db_placeholders($node_types, 'varchar');    $placeholders = db_placeholders($node_types, 'varchar');
98    $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)";    $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)";
99    
100    $subquery_sql = $unread ? "SELECT h.nid FROM {history} h WHERE h.uid = %d" : $nid;    $subquery_sql = $unread ? "SELECT h.nid FROM {history} h WHERE h.uid = %d" : '%d';
101    $args = array_merge(array($unread ? $uid : $nid), $node_types);    $args = array_merge(array($unread ? $uid : $nid), $node_types);
102    
103    $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.6  
changed lines
  Added in v.1.2.4.7
  ViewVC Help
Powered by ViewVC 1.1.2