Function: nornix_site.add_theme_resource

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

Add theme resource file, returns success (0/1)

CREATE DEFINER=`root`@`localhost` FUNCTION `add_theme_resource`(vMimeTypeNo INTEGER, vName
VARCHAR(80),
 vData LONGBLOB, vDescription VARCHAR(255), vWidth INTEGER, vHeight INTEGER, vThemeNo INTEGER)
RETURNS int(11)
    MODIFIES SQL DATA
    COMMENT 'Add theme resource file, returns success (0/1)'
BEGIN
 DECLARE vContentTypeNo INTEGER;
 DECLARE success INTEGER DEFAULT 1;
 DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' SET success = 0;
 SELECT `ContentTypeNo` INTO vContentTypeNo FROM `nornix_system`.`mimetype` WHERE
`No`=vMimeTypeNo;
 INSERT INTO themeresource (`Name`, `ThemeNo`, `MimeTypeNo`, `Data`, `TS`, `Description`,
`ContentTypeNo`, `Width`, `Height`)
 VALUES (vName, vThemeNo, vMimeTypeNo, vData, NULL, vDescription, vContentTypeNo, vWidth,
vHeight);
 RETURN success;
END