diff options
| author | Machiavelli <machiavelli.trinity@gmail.com> | 2011-10-29 14:56:01 +0200 |
|---|---|---|
| committer | Machiavelli <machiavelli.trinity@gmail.com> | 2011-10-29 14:56:01 +0200 |
| commit | 2575b50b0507379e3dab9204f42b8940af191408 (patch) | |
| tree | 55f08828579df8ca9e4eb5b891b1f02c555f88c8 | |
| parent | 4f039841e80fb27dc05e80ee90eb1bd791dce2f0 (diff) | |
DB/Templates: Add missing templates for variations of Freya's Chest. This will allow them to actually spawn on death.
| -rw-r--r-- | sql/updates/world/2011_10_29_01_world_gameobject_template.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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); + |