aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-10-30 20:06:42 +0100
committerKillyana <morphone1@gmail.com>2017-10-30 20:06:42 +0100
commit9c4ae465909f1075bdd56fc5ee47c07c95c9fca3 (patch)
treed82c9cf95916d6f0d66ec97c5541e80a87f1ec1a
parent7196907b09cf0d5e5c469c5fb593dbcbe3b6ba77 (diff)
DB: Fix Some DBerrors
Updates #18542
-rw-r--r--sql/updates/world/3.3.5/2017_10_30_00_world_335.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_10_30_00_world_335.sql b/sql/updates/world/3.3.5/2017_10_30_00_world_335.sql
new file mode 100644
index 00000000000..fc1ce205f00
--- /dev/null
+++ b/sql/updates/world/3.3.5/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);