Function: nornix_site.save_block_template

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

Update data in block template

CREATE DEFINER=`root`@`localhost` FUNCTION `save_block_template`(vScript TEXT,
 vBlock VARCHAR(16), vResponseType INTEGER) RETURNS int(11)
    MODIFIES SQL DATA
    COMMENT 'Update data in block template'
BEGIN
 UPDATE blocktemplate SET Script = vScript WHERE Block = vBlock;
 DELETE FROM documentcache;
 DELETE FROM `cache` WHERE `Type` = vResponseType;
 RETURN 1;
END