chamilo / chamilo-lms

        $sql = "SELECT iid FROM $table_group

                WHERE c_id = $course_id AND category_id='".$cat_id."'";

        $res = Database::query($sql);

        if (Database::num_rows($res) > 0) {

            while ($group = Database::fetch_object($res)) {

                $groupInfo = self::get_group_properties($group->iid, true);

                self::delete_groups($groupInfo, $course_code);

            }

        }

        $sql = "DELETE FROM $table_group_cat

                WHERE c_id = $course_id  AND id='".$cat_id."'";

        Database::query($sql);

                apcu_clear_cache();

                apcu_store($apc_var, $count, 60);

            }

        } else {

            $rs = Database::query($sql);

            if (Database::num_rows($rs) > 0) {

                $row = Database::fetch_object($rs);

                $count = $row->count_connections;

            }

        }

        return $count;

    }