SELECT trove_cat_id,fullname
FROM trove_cat
WHERE parent=$1
- AND trove_cat_id!=0;", array($mynode), -1, 0, 'DB_TROVE');
+ AND trove_cat_id!=0;", array($mynode), -1, 0, 'SYS_DB_TROVE');
while ($row_child = db_fetch_array($res_child)) {
trove_genfullpaths($row_child['trove_cat_id'],
SELECT trove_cat_id
FROM trove_cat
WHERE parent=$1
- AND trove_cat_id!=0;", array($mynode), -1, 0, 'DB_TROVE');
+ AND trove_cat_id!=0;", array($mynode), -1, 0, 'SYS_DB_TROVE');
while ($row_child = db_fetch_array($res_child)) {
trove_updaterootparent($row_child['trove_cat_id'],$rootnode);
$res_verifycat = db_query_params("
SELECT trove_cat_id,fullpath_ids
FROM trove_cat
- WHERE trove_cat_id=$1", array($trove_cat_id), -1, 0, 'DB_TROVE');
+ WHERE trove_cat_id=$1", array($trove_cat_id), -1, 0, 'SYS_DB_TROVE');
if (db_numrows($res_verifycat) != 1) return 1;
$row_verifycat = db_fetch_array($res_verifycat);
for ($i=0;$i<count($subnodeids);$i++) {
if ($subnodeids[$i] == $row_checksubs['trove_cat_id']) {
// then delete subnode
- db_query_params("DELETE FROM trove_group_link WHERE
+ db_query_params("DELETE FROM trove_group_link WHERE
group_id=$1 AND trove_cat_id=$2",
array($group_id, $subnodeids[$i]));
}