Exec ("SELECT title FROM properties_groups WHERE id = ".$group_id);
$catname = $DB->Fetch ($get_tit);
if ($delq) {
$get_val = $DB->getArray("SELECT id FROM properties_values WHERE propertyid = ".$delq);
if (!empty($get_val)) {
foreach ($get_val as $row) {
$DB->Exec ("DELETE FROM languages_texts WHERE type = 'properties_groups' AND col='value' AND objectid = ".$row['id']);
}
}
$DB->Exec ("DELETE FROM properties_values WHERE propertyid = ".$delq);
$DB->Exec ("DELETE FROM properties_rel WHERE typeid = ".$delq);
$DB->Exec ("DELETE FROM properties WHERE id = ".$delq);
$DB->Exec ("DELETE FROM languages_texts WHERE type = 'properties_groups' AND col='property' AND objectid = ".$delq);
}
if ($movepup||$movepdown) {
$direction = $movepup ? 'up' : 'down';
$id = $movepup?$movepup:$movepdown;
if ($id) {
setOrdering ($id, "properties", "position", $direction," AND groupid=".$group_id);
}
}
$get_q = $DB->Exec ("SELECT * FROM properties WHERE groupid = ".$group_id." ORDER BY position ASC");
$rows = $DB->Count ($get_q);
?>
getArray("SELECT id FROM properties WHERE groupid = ".$delgroup);
if (!empty($get_prop)) {
foreach ($get_prop as $row) {
$id = $row['id'];
$DB->Exec ("DELETE FROM languages_texts WHERE type = 'properties_groups' AND col='property' AND objectid = ".$id);
$get_val = $DB->getArray("SELECT id FROM properties_values WHERE propertyid = ".$id);
if (!empty($get_val)) {
foreach ($get_val as $vrow) {
$DB->Exec ("DELETE FROM languages_texts WHERE type = 'properties_groups' AND col='value' AND objectid = ".$vrow['id']);
$DB -> Exec("DELETE FROM properties_values WHERE id = ".$vrow['id']);
}
}
}
}
$DB->Exec ("DELETE FROM properties_groups WHERE id = ".$delgroup);
$DB->Exec ("DELETE FROM languages_texts WHERE type = 'properties_groups' AND col='title' AND objectid = ".$delgroup);
$DB->Exec ("DELETE FROM properties WHERE groupid = ".$delgroup);
$DB->Exec ("DELETE FROM properties_values WHERE propertyid = ".$delgroup);
$DB->Exec ("DELETE FROM properties_rel WHERE typeid = ".$delgroup);
}
$get = $DB->Exec("SELECT * FROM properties_groups ORDER BY title ASC");
$rows = $DB->Count($get);
?>