You are here

function nodehierarchy_add_default_parents in Node Hierarchy 6

Same name and namespace in other branches
  1. 5 nodehierarchy.install \nodehierarchy_add_default_parents()
2 calls to nodehierarchy_add_default_parents()
nodehierarchy_enable in ./nodehierarchy.install
Implementation of hook_enable().
nodehierarchy_update_1 in ./nodehierarchy.install

File

./nodehierarchy.install, line 63

Code

function nodehierarchy_add_default_parents() {
  $out = array();
  $result = db_query("SELECT n.nid FROM {node} n LEFT JOIN {nodehierarchy} h ON n.nid = h.nid WHERE h.parent IS NULL ORDER BY n.nid");
  $order_by = 1;
  while ($node = db_fetch_object($result)) {
    if (function_exists("update_sql")) {
      $out[] = update_sql("INSERT INTO {nodehierarchy} VALUES ({$node->nid}, 0, {$order_by})");
    }
    else {
      db_query("INSERT INTO {nodehierarchy} VALUES ({$node->nid}, 0, {$order_by})");
    }
    $order_by++;
  }
  return $out;
}