/[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.24, Thu Apr 13 15:49:31 2006 UTC revision 1.25, Fri Apr 28 18:38:55 2006 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: nmoderation.module,v 1.23 2006/04/07 04:46:16 eaton Exp $  // $Id: nmoderation.module,v 1.24 2006/04/13 15:49:31 unconed Exp $
3    
4  /**  /**
5   * @file   * @file
# Line 550  function nmoderation_list_unvoted($conte Line 550  function nmoderation_list_unvoted($conte
550    $cols = 2;    $cols = 2;
551    $title = t('my unmoderated nodes');    $title = t('my unmoderated nodes');
552    $types = implode("','", variable_get('nmoderation_node_types', node_get_types()));    $types = implode("','", variable_get('nmoderation_node_types', node_get_types()));
553    $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 v.value_type = '".NMODERATION_VOTE_TYPE."' 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)";
554    $min = time()-24*3600*variable_get('nmoderation_vote_interval', 7);    $min = time()-24*3600*variable_get('nmoderation_vote_interval', 7);
555    $sql .= " AND n.created > $min";    $sql .= " AND n.created > $min";
556    if (!user_access('administer node moderation votes')) {    if (!user_access('administer node moderation votes')) {

Legend:
Removed from v.1.24  
changed lines
  Added in v.1.25

  ViewVC Help
Powered by ViewVC 1.1.2