diff options
| author | Killyana <morphone1@gmail.com> | 2017-10-30 20:06:42 +0100 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-01-21 22:30:40 +0100 |
| commit | f738bb3fec00ee9b3c51802516b72a5c61dbe1df (patch) | |
| tree | 89d692f0232513451ebe7f9b2067cd67531838fd | |
| parent | 1adc47cdc207cb0d305c8be5d1f9f4cfa6e6e6d1 (diff) | |
DB: Fix Some DBerrors
Updates #18542
(cherry picked from commit 9c4ae465909f1075bdd56fc5ee47c07c95c9fca3)
| -rw-r--r-- | sql/updates/world/master/2021_01_18_00_world_2017_10_30_00_world_335.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_01_18_00_world_2017_10_30_00_world_335.sql b/sql/updates/world/master/2021_01_18_00_world_2017_10_30_00_world_335.sql new file mode 100644 index 00000000000..55099e3efcd --- /dev/null +++ b/sql/updates/world/master/2021_01_18_00_world_2017_10_30_00_world_335.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `spawn_group` WHERE `groupId`=2 AND `spawnType`=0 AND `spawnId` IN (66695,66697,69726,69728,70352,76446,76508,76509,76510,81862,81868,86483,86554,86555,86556,86557,107116,107253,107560,132708); +-- DELETE FROM `spawn_group` WHERE `groupId`=2 AND `spawnType`=1 AND `spawnId` IN (30587,30593,30594,45042,45043,45157,45194,45195,45196,45197,45198,45200,45201); +-- DELETE FROM `spawn_group` WHERE `spawnId` IN (409,412,414,420,424,426,432,492,509,513,601,610,612,617,646,660,665,669,672,718,750,763,787,791,796,802,813,828,833,836,853,859) AND `spawnType`=1 AND `groupId`=2; +-- INSERT INTO `spawn_group` (`groupId`, `spawnType`, `spawnId`) VALUES +-- (2,1,409),(2,1,412),(2,1,414),(2,1,420),(2,1,424),(2,1,426),(2,1,432),(2,1,492),(2,1,509),(2,1,513),(2,1,601),(2,1,610),(2,1,612),(2,1,617),(2,1,646),(2,1,660),(2,1,665),(2,1,669),(2,1,672),(2,1,718),(2,1,750),(2,1,763),(2,1,787),(2,1,791),(2,1,796),(2,1,802),(2,1,813),(2,1,828),(2,1,833),(2,1,836),(2,1,853),(2,1,859); |