by
Gms0012
» 31 Jul 2015, 15:40
USE lif_1;
DELIMITER $$
CREATE
DEFINER = 'YOURDBUSER'@'localhost'
TRIGGER lif_1.character_after_insert
AFTER INSERT
ON lif_1.`character`
FOR EACH ROW
BEGIN
SET @backpack = f_createContainer(NEW.RootContainerID, 458, 0);
SET @temp = f_insertNewItemInventory(@backpack, 1060, 50, 100, 50000, 50000, '', ''); /* silver coins */
SET @temp = f_insertNewItemInventory(@backpack, 974, 50, 25, 50000, 50000, '', ''); /* 25x q50 Apple Buns */
SET @temp = f_insertNewItemInventory(@backpack, 38, 50, 1, 50000, 50000, '', ''); /* torch */
SET @temp = f_insertNewItemInventory(@backpack, 1059, 50, 100, 50000, 50000, '', ''); /* copper coins */
END
$$
DELIMITER ;