chamilo / chamilo-lms

     * if the course code doest not exist in the DB the same course code will be returned

     * @return string    wanted unused code

     */

    public static function generate_nice_next_course_code($wanted_code)

    {

        $course_code_ok = !self::course_code_exists($wanted_code);

        if (!$course_code_ok) {

            $wanted_code = CourseManager::generate_course_code($wanted_code);

            $table = Database::get_main_table(TABLE_MAIN_COURSE);

            $wanted_code = Database::escape_string($wanted_code);

            $sql = "SELECT count(id) as count

                    FROM $table

                    WHERE code LIKE '$wanted_code%'";

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

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

                $row = Database::fetch_array($result);

                $count = $row['count'] + 1;

                $wanted_code = $wanted_code . '_' . $count;

                $result = api_get_course_info($wanted_code);

                if (empty($result)) {

                    return $wanted_code;

                }

            }

            return false;

        }

        return $wanted_code;

    }

    /**

     * Gets the status of the users agreement in a course course-session

     * </code>

     * @return string	wanted unused code

     */

    public static function generateNextSessionName($session_name)

    {

        $session_name_ok = !self::session_name_exists($session_name);

        if (!$session_name_ok) {

            $table = Database::get_main_table(TABLE_MAIN_SESSION);

            $session_name = Database::escape_string($session_name);

            $sql = "SELECT count(*) as count FROM $table

                    WHERE name LIKE '$session_name%'";

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

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

                $row = Database::fetch_array($result);

                $count = $row['count'] + 1;

                $session_name = $session_name . '_' . $count;

                $result = self::session_name_exists($session_name);

                if (!$result) {

                    return $session_name;

                }

            }

            return false;

        }

        return $session_name;

    }

    /**