chamilo / chamilo-lms

     * @param int $urlId

     * @return int

     */

    public static function addUserGroupToUrl($userGroupId, $urlId)

    {

        $urlRelUserGroupTable = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USERGROUP);

        $sql = "INSERT INTO $urlRelUserGroupTable

                SET

                usergroup_id = '".intval($userGroupId)."',

                access_url_id = ".intval($urlId);

        Database::query($sql);

        return Database::insert_id();

    }

    /**

     * @param int $categoryId

     *

     * @return bool

     */

    public static function session_name_exists($name)

    {

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

        $sql = "SELECT COUNT(*) as count FROM " . Database::get_main_table(TABLE_MAIN_SESSION) . "

                WHERE name = '$name'";

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

        return $result['count'] > 0;

    }

    /**

     * @param string $where_condition

     * @param int  $category_id

     * @return int course id

     */

    public static function get_course_by_category($category_id)

    {

        $category_id = intval($category_id);

        $info = Database::fetch_array(

            Database::query('SELECT c_id FROM ' . Database::get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY) . '

            WHERE id=' . $category_id), 'ASSOC'

        );

        return $info ? $info['c_id'] : false;

    }

    /**

     * This function gets all the courses that are not in a session