diff options
| author | Meji <alvaro.megias@outlook.com> | 2024-04-04 21:51:48 +0200 |
|---|---|---|
| committer | Meji <alvaro.megias@outlook.com> | 2024-04-04 21:51:48 +0200 |
| commit | 4d690f65c116d1e9eb31e9938407161a6d71f40f (patch) | |
| tree | 1716ed5b39dd87083de7d547b2600bed65d88998 | |
| parent | 2a7efcc818af9dae89cd9e4e541c621958c2b9c4 (diff) | |
DB/DunMorogh: Add missing spawn groups for Operation: Gnomeregan
| -rw-r--r-- | sql/updates/world/3.3.5/2024_04_04_06_world.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_04_04_06_world.sql b/sql/updates/world/3.3.5/2024_04_04_06_world.sql new file mode 100644 index 00000000000..278de048900 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_04_04_06_world.sql @@ -0,0 +1,27 @@ +SET @CGUID := 208509; + +DELETE FROM `spawn_group` WHERE `spawnType`=0 AND `spawnId` BETWEEN 207174 AND 207209; +DELETE FROM `spawn_group` WHERE `spawnType`=0 AND `spawnId` IN (130847, 130848, 130849, 130853, 130855, 130906, 130907, 130908, 130971); +DELETE FROM `spawn_group` WHERE `spawnType`=0 AND `spawnId` BETWEEN @CGUID+0 AND @CGUID+54; +INSERT INTO `spawn_group` (`groupId`, `spawnType`, `spawnId`) VALUES +(2, 0, @CGUID+34), +(2, 0, @CGUID+35), +(2, 0, @CGUID+36), +(2, 0, @CGUID+37), +(2, 0, @CGUID+38), +(2, 0, @CGUID+39), +(2, 0, @CGUID+40), +(2, 0, @CGUID+41), +(2, 0, @CGUID+42), +(2, 0, @CGUID+43), +(2, 0, @CGUID+44), +(2, 0, @CGUID+45), +(2, 0, @CGUID+46), +(2, 0, @CGUID+47), +(2, 0, @CGUID+48), +(2, 0, @CGUID+49), +(2, 0, @CGUID+50), +(2, 0, @CGUID+51), +(2, 0, @CGUID+52), +(2, 0, @CGUID+53), +(2, 0, @CGUID+54); |