diff options
| author | Killyana <morphone1@gmail.com> | 2016-11-02 18:14:11 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2016-11-02 18:14:11 +0100 |
| commit | 7e07d9930827e25d79e1c398d4363ca8cad93f07 (patch) | |
| tree | f6496bf6c84b6e41fb85a98dd1142b01c9543f62 | |
| parent | 322f1910fcf2596b14b05b7654da3ab23e1bb018 (diff) | |
DB/Gameobject: Add two missing game object
Closes #18187
| -rw-r--r-- | sql/updates/world/3.3.5/2016_11_02_01_world.sql (renamed from sql/updates/world/3.3.5/2016_11_08_01_world.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/world/3.3.5/2016_11_02_02_world.sql | 9 |
2 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_11_08_01_world.sql b/sql/updates/world/3.3.5/2016_11_02_01_world.sql index d0d4b78c0c3..d0d4b78c0c3 100644 --- a/sql/updates/world/3.3.5/2016_11_08_01_world.sql +++ b/sql/updates/world/3.3.5/2016_11_02_01_world.sql diff --git a/sql/updates/world/3.3.5/2016_11_02_02_world.sql b/sql/updates/world/3.3.5/2016_11_02_02_world.sql new file mode 100644 index 00000000000..7002536a162 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_11_02_02_world.sql @@ -0,0 +1,9 @@ +-- +DELETE FROM `gameobject_template` WHERE `entry` IN (4,129); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `AIName`, `ScriptName`, `VerifiedBuild`) VALUES +(4, 6, 0, "Bonfire Damage", "", "", "", 1, 0, 1, 3, 7902, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", 0), +(129, 6, 0, "Naxx Teleporter trap", "", "", "", 1, 0, 1, 0, 64446, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", 0); + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (4); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `mingold`, `maxgold`) VALUES +(4, 14, 0, 0, 0); |