+ $sql = "SELECT * FROM ".TB_PREF."chart_types";
+
+ if (!$all)
+ $sql .= " WHERE !inactive";
+ if ($class_id != false)
+ $sql .= " AND class_id=".db_escape($class_id);
+ if ($parent == -1)
+ $sql .= " AND parent <= 0";
+ elseif ($parent != false)
+ $sql .= " AND parent=".db_escape($parent);
+ $sql .= " ORDER BY class_id, id";