I'm wondering if there is any way to make any one of these options work as a trigger?
Option 1- There is a certain amount of items that always spawn in there inventory upon death. Example: Bastard Sword and Backpack spawn in inventory upon death.
Option 2- They keep there current loot that was in the inventory before death.
Option 3-Certain items always spawn in there inventory upon Homecoming. Example: Bastard Sword and Backpack spawn in inventory upon homecoming
Modify this trigger perhaps? So instead of just spawning items on character creation upon respawn from death items are spawned?
- Code: Select all
DELIMITER //
CREATE TRIGGER `character_after_insert` AFTER INSERT ON `character` FOR EACH ROW BEGIN
SET @backpack = f_createContainer(NEW.RootContainerID, 458, 0);
SET @temp = f_insertNewItemInventory(@backpack, 555, 50, 1, 50000, 50000, '', 0,0,0,0, 0,0);
END//