function nodehierarchy_add_default_parents in Node Hierarchy 5
Same name and namespace in other branches
- 6 nodehierarchy.install \nodehierarchy_add_default_parents()
2 calls to nodehierarchy_add_default_parents()
File
- ./
nodehierarchy.install, line 31
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;
}