From 2575b50b0507379e3dab9204f42b8940af191408 Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Sat, 29 Oct 2011 14:56:01 +0200 Subject: DB/Templates: Add missing templates for variations of Freya's Chest. This will allow them to actually spawn on death. --- sql/updates/world/2011_10_29_01_world_gameobject_template.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/2011_10_29_01_world_gameobject_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_10_29_01_world_gameobject_template.sql b/sql/updates/world/2011_10_29_01_world_gameobject_template.sql new file mode 100644 index 00000000000..983f92027c9 --- /dev/null +++ b/sql/updates/world/2011_10_29_01_world_gameobject_template.sql @@ -0,0 +1,8 @@ +-- Size adjustment on a hand-made template +UPDATE `gameobject_template` SET `size`=2, `WDBVerified`=-1 WHERE `entry`=194328; +-- Add some missing templates, need WDB data (data1/lootId is guessed based on logic sequence, rest is copied based on other templates of the chest) +INSERT INTO `gameobject_template` (`entry`,`type`,`displayId`,`name`,`size`,`data0`,`data1`,`data3`,`data11`,`data13`,`data15`,`WDBVerified`) VALUES +(194326,3,8628,'Freya\'s Gift',2,1634,27080,1,1,1,1,-1), +(194329,3,8628,'Freya\'s Gift',2,1634,27082,1,1,1,1,-1), +(194330,3,8628,'Freya\'s Gift',2,1634,27083,1,1,1,1,-1); + -- cgit v1.2.3