diff options
| author | Ovahlord <dreadkiller@gmx.de> | 2023-11-25 20:56:54 +0100 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2023-11-25 20:56:54 +0100 |
| commit | 87d88e37884cbae1cdf7110a901b88a9b49915a8 (patch) | |
| tree | 595c2e3046eee068ec35a87cd0d528be273ce86c /sql/updates | |
| parent | d8f87a45ee5be2203a0c9890f5850296cf60cfd2 (diff) | |
DB/GameObjects: fixed inserting gameobject template addons
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/3.4.x/2023_11_25_00_world.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/updates/world/3.4.x/2023_11_25_00_world.sql b/sql/updates/world/3.4.x/2023_11_25_00_world.sql index 88b244263c0..9dcf448ab10 100644 --- a/sql/updates/world/3.4.x/2023_11_25_00_world.sql +++ b/sql/updates/world/3.4.x/2023_11_25_00_world.sql @@ -21574,7 +21574,9 @@ INSERT INTO `gameobject_template`(`entry`,`type`,`displayId`,`name`,`IconName`,` (215419,6,0,'Luck of the Lotus','','','',1,0,0,0,130653,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','',-18019), (244605,6,9958,'Underbelly Hoard Trap','','','',0.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','',22566); -insert into `gameobject_template_addon`(`entry`,`faction`,`flags`,`mingold`,`maxgold`,`artkit0`,`artkit1`,`artkit2`,`artkit3`) values + +TRUNCATE TABLE `gameobject_template_addon`; +INSERT INTO `gameobject_template_addon`(`entry`,`faction`,`flags`,`mingold`,`maxgold`,`artkit0`,`artkit1`,`artkit2`,`artkit3`) VALUES (4,14,0,0,0,0,0,0,0), (31,84,4,0,0,0,0,0,0), (32,12,4,0,0,0,0,0,0), @@ -43075,5 +43077,3 @@ insert into `gameobject_template_addon`(`entry`,`faction`,`flags`,`mingold`,`ma (211067,0,0,0,0,0,0,0,0), (211068,0,0,0,0,0,0,0,0), (211084,0,0,0,0,0,0,0,0); - -DELETE FROM `gameobject_template_addon` WHERE `entry` NOT IN (SELECT `entry` FROM `gameobject_template`); |