| 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 |
| 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')) { |