function _datereminder_enable_all_nodes in Date Reminder 6

Same name and namespace in other branches

1. 7 includes/db7.inc \_datereminder_enable_all_nodes()

Set enabled for all nodes of the given type.

Parameters

type $type: Node type.

1 call to _datereminder_enable_all_nodes()

_datereminder_form_submit_node_type in ./datereminder.module

Processing on a node type submit. This does the enable of reminders in existing nodes, if requested.

File

./datereminder.module, line 414

Support for reminders for nodes with dates.

Code

function _datereminder_enable_all_nodes($type) {
  $s = 'SELECT nid, r.enabled FROM {node} n LEFT JOIN {datereminder_enable} r ';
  $s .= 'USING(nid) WHERE n.type = \'%s\' AND r.enabled != %d';
  $rs = db_rewrite_sql($s);
  $q = db_query($rs, array(
    $type,
    DATEREMINDER_TYPE_ON,
  ));
  while ($rec = db_fetch_object($q)) {
    if (!isset($rec->enabled) || $rec->enabled != DATEREMINDER_TYPE_ON) {
      _datereminder_set_nid_enabled($rec->nid, DATEREMINDER_TYPE_ON);
    }
  }
}