Function: nornix_site.add_setting

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

Add or change site setting, returns success (0/1)

CREATE DEFINER=`root`@`localhost` FUNCTION `add_setting`(vClass VARCHAR(32), vAttribute VARCHAR(48),
vValue VARCHAR(255)) RETURNS int(11)
    MODIFIES SQL DATA
    COMMENT 'Add or change site setting, returns success (0/1)'
BEGIN
 DECLARE success INTEGER DEFAULT 1;
 DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' SET success = 0;
 REPLACE INTO setting (`Class`, `Attribute`, `Value`)
 VALUES (vClass, vAttribute, vValue);
 RETURN success;
END