Function: nornix_site.save_block

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

Save block

CREATE DEFINER=`root`@`localhost` FUNCTION `save_block`(vBlock VARCHAR(16),
 vContentTypeNo INTEGER, vData BLOB, vResponseType INTEGER) RETURNS int(11)
    MODIFIES SQL DATA
    COMMENT 'Save block'
BEGIN
 DECLARE blockExists INTEGER;
 SELECT COUNT(*) INTO blockExists FROM block WHERE `Name` = vBlock;
 IF blockExists THEN
  UPDATE block SET `Data` = vData, ContentTypeNo = vContentTypeNo
   WHERE `Name` = vBlock;
 ELSE
  INSERT block (Name, ContentTypeNo, Data)
   VALUES (vBlock, vContentTypeNo, vData);
 END IF;
 DELETE FROM documentcache;
 DELETE FROM cache WHERE `Type` = vResponseType;
 RETURN 1;
END