chamilo / chamilo-lms

     * @return bool True if attribute was successfully updated,

     * false if course was not found or attribute name is invalid

     */

    public static function update_attribute($id, $name, $value)

    {

        $id = (int)$id;

        $table = Database::get_main_table(TABLE_MAIN_COURSE);

        $sql = "UPDATE $table SET $name = '" . Database::escape_string($value) . "'

                WHERE id = '$id';";

        return Database::query($sql);

    }

    /**

     * Update course attributes. Will only update attributes with a non-empty value.

     * @param int/string $id            The id (an integer number) of the corresponding database record.

     * @return bool                     Returns TRUE on success or FALSE on failure.

     */

    public static function delete_course_request($id)

    {

        $id = (int)$id;

        $sql = "DELETE FROM ".Database :: get_main_table(TABLE_MAIN_COURSE_REQUEST)."

                WHERE id = ".$id;

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

        return $result !== false;

    }

    /**

     * @param null $status

     * @param int/string $id            The database primary id of the given request.

     * @return bool                     Returns TRUE if additional information has been asked or FALSE otherwise.

     */

    public static function additional_info_asked($id)

    {

        $id = (int)$id;

        $sql = "SELECT id FROM ".Database :: get_main_table(TABLE_MAIN_COURSE_REQUEST)."

                WHERE (id = ".$id." AND info > 0)";

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

        return !empty($result);

    }

}

     * @param Integer The language id

     * @return void()

     */

    public static function make_unavailable_language($language_id)

    {

        $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);

        $sql = "UPDATE $tbl_admin_languages SET available='0'

                WHERE id = " . intval($language_id) . "";

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

        return $result !== false; //only return false on sql error

    }

    /**

     * Make available the language

     * @param Integer The language id

     * @return void

     */

    public static function make_available_language($language_id)

    {

        $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);

        $sql = "UPDATE $tbl_admin_languages SET available='1'

                WHERE id = " . intval($language_id) . "";

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

        return $result !== false; //only return false on sql error

    }

    /**

     * Set platform language