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

Diff of /contributions/modules/nmoderation/nmoderation.module

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

revision 1.27, Tue May 2 04:44:23 2006 UTC revision 1.28, Tue May 30 13:20:38 2006 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: nmoderation.module,v 1.26 2006/05/02 04:42:46 eaton Exp $  // $Id: nmoderation.module,v 1.27 2006/05/02 04:44:23 eaton Exp $
3    
4  /**  /**
5   * @file   * @file
# Line 551  function nmoderation_list_unvoted($conte Line 551  function nmoderation_list_unvoted($conte
551    );    );
552    $cols = 2;    $cols = 2;
553    $title = t('my unmoderated nodes');    $title = t('my unmoderated nodes');
554    $types = implode("','", variable_get('nmoderation_node_types', node_get_types()));    $types = implode("','", variable_get('nmoderation_node_types', array_flip(node_get_types())));
555    $sql = "SELECT n.nid, n.created, u.name, n.title, n.uid FROM {node} n INNER JOIN {users} u ON n.uid = u.uid LEFT JOIN {votingapi_vote} v ON n.nid = v.content_id AND v.content_type = '$content_type' AND v.uid = $user->uid WHERE n.type IN ('$types') AND n.status = 1 AND ISNULL(v.vote_id)";    $sql = "SELECT n.nid, n.created, u.name, n.title, n.uid FROM {node} n INNER JOIN {users} u ON n.uid = u.uid LEFT JOIN {votingapi_vote} v ON n.nid = v.content_id AND v.content_type = '$content_type' AND v.uid = $user->uid WHERE n.type IN ('$types') AND n.status = 1 AND ISNULL(v.vote_id)";
556    $min = time()-24*3600*variable_get('nmoderation_vote_interval', 7);    $min = time()-24*3600*variable_get('nmoderation_vote_interval', 7);
557    $sql .= " AND n.created > $min";    $sql .= " AND n.created > $min";
Legend:
Removed from v.1.27  
changed lines
  Added in v.1.28
  ViewVC Help
Powered by ViewVC 1.1.2