as much as i hate to use a hack, it makes sense in some situations. i _believe_ that enabling notification of unpublished nodes (as opposed to unpublished comments) on the Drupal 5 version of the module requires replacing this code:
// Fetch all new nodes and 'load' it to get proper body, etc.
$nresult = db_query(db_rewrite_sql('SELECT n.nid FROM {node} n WHERE (n.status = 1 OR n.moderate = 1) AND n.created > %d AND n.created <= %d ORDER BY n.created'), $period, time());
with this:
// Fetch all new nodes and 'load' it to get proper body, etc.
$nresult = db_query(db_rewrite_sql('SELECT n.nid FROM {node} n WHERE n.created > %d AND n.created <= %d ORDER BY n.created'), $period, time());
essentially, just remove the WHERE (n.status = 1 OR n.moderate = 1) condition from the database query
similar hack works for enabling notify on unpublished NODES
thanks very much for this helpful post!
as much as i hate to use a hack, it makes sense in some situations. i _believe_ that enabling notification of unpublished nodes (as opposed to unpublished comments) on the Drupal 5 version of the module requires replacing this code:
// Fetch all new nodes and 'load' it to get proper body, etc.
$nresult = db_query(db_rewrite_sql('SELECT n.nid FROM {node} n WHERE (n.status = 1 OR n.moderate = 1) AND n.created > %d AND n.created <= %d ORDER BY n.created'), $period, time());
with this:
// Fetch all new nodes and 'load' it to get proper body, etc.
$nresult = db_query(db_rewrite_sql('SELECT n.nid FROM {node} n WHERE n.created > %d AND n.created <= %d ORDER BY n.created'), $period, time());
essentially, just remove the WHERE (n.status = 1 OR n.moderate = 1) condition from the database query