Function: nornix_site.update_theme_resource

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

Update theme resource data

CREATE DEFINER=`root`@`localhost` FUNCTION `update_theme_resource`(vMimeTypeNo INTEGER, vName
VARCHAR(80),
 vData MEDIUMBLOB, vDescription VARCHAR(255), vWidth INTEGER, vHeight INTEGER, vThemeNo INTEGER)
RETURNS int(11)
    MODIFIES SQL DATA
    COMMENT 'Update theme resource data'
BEGIN
 UPDATE themeresource r SET `Data` = vData, Description = vDescription, TS = NULL, `Width` =
vWidth, `Height` = vHeight
 WHERE r.ThemeNo = vThemeNo AND r.MimeTypeNo = vMimeTypeNo AND r.Name = vName;
 RETURN 1;
END