diff options
| -rw-r--r-- | sql/updates/world/master/2023_12_26_00_world.sql | 69 |
1 files changed, 69 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_12_26_00_world.sql b/sql/updates/world/master/2023_12_26_00_world.sql new file mode 100644 index 00000000000..5e6785d8588 --- /dev/null +++ b/sql/updates/world/master/2023_12_26_00_world.sql @@ -0,0 +1,69 @@ +-- Serverside spells (now clientside) +DELETE FROM `serverside_spell` WHERE `Id` IN (1629, 35729); +DELETE FROM `serverside_spell_effect` WHERE `SpellID` IN (1629, 35729); + +-- Creature template +UPDATE `creature_template_addon` SET `SheathState`=0 WHERE `entry` IN (11280,32643,34045,46406,46417); +UPDATE `creature_template_addon` SET `SheathState`=1 WHERE `entry`=11316; +UPDATE `creature_template_addon` SET `auras`='' WHERE `entry` IN (15071,59480); +UPDATE `creature_template_addon` SET `meleeAnimKit`=0 WHERE `entry`=180803; + +-- Creature +DELETE FROM `creature` WHERE `guid`=53940; + +UPDATE `creature` SET `spawnDifficulties`='9' WHERE `guid` IN (85786,128903); +UPDATE `creature` SET `spawnDifficulties`='1,2' WHERE `guid` IN (83090,83092,83098,83099,83100,83101); +UPDATE `creature` SET `wander_distance`=0 WHERE `guid` IN (314390,450056,450062,450072,450074,450089,450091,450094,450095,450096,450184,450229,450237,450241,450248,450251,450256,450268,450287,450298,650536,650545,650548,651363,651371,651409,651414,651429,651430,651442,651444,651453,651459,651737,651739,850638,1051338,5000007,9000245,9001278,9001289,9001663,9003979); +UPDATE `creature` SET `wander_distance`=10 WHERE `guid` IN (6000724,6000788,6000822,9003880,9003900); +UPDATE `creature` SET `MovementType`=1 WHERE `guid` IN (9001784); +UPDATE `creature` SET `MovementType`=0 WHERE `guid` IN (6000060,9000232,9000656,9001278,9001289); +UPDATE `creature` SET `terrainSwapMap`=-1 WHERE `guid` IN (5000014); + +UPDATE `creature` SET `equipment_id`=6 WHERE `id` IN (44966,44954) AND `equipment_id`=5; +UPDATE `creature` SET `equipment_id`=0 WHERE `id` IN (102325,102327,186361,186362,186468,180803); + +UPDATE `creature` SET `guid`=397105 WHERE `guid`=3000463 AND `id`=45455; +UPDATE `creature` SET `guid`=397106 WHERE `guid`=3000464 AND `id`=45455; +UPDATE `creature` SET `guid`=397107 WHERE `guid`=3000465 AND `id`=45455; +UPDATE `creature` SET `guid`=397108 WHERE `guid`=3000466 AND `id`=45455; +UPDATE `creature` SET `guid`=397109 WHERE `guid`=3000467 AND `id`=45504; +UPDATE `creature` SET `guid`=397110 WHERE `guid`=3000468 AND `id`=45455; +UPDATE `creature` SET `guid`=397111 WHERE `guid`=3000469 AND `id`=45455; +UPDATE `creature` SET `guid`=397112 WHERE `guid`=3000470 AND `id`=45455; +UPDATE `creature` SET `guid`=397113 WHERE `guid`=3000471 AND `id`=45455; +UPDATE `creature` SET `guid`=397114 WHERE `guid`=3000472 AND `id`=45455; +UPDATE `creature` SET `guid`=397115 WHERE `guid`=3000473 AND `id`=45455; +UPDATE `creature` SET `guid`=397116 WHERE `guid`=3000474 AND `id`=45504; +UPDATE `creature` SET `guid`=397117 WHERE `guid`=3000475 AND `id`=45455; + +UPDATE `creature` SET `spawnDifficulties`='1,2' WHERE `guid` BETWEEN 397105 AND 397117; + +UPDATE `spawn_group` SET `spawnId`=397105 WHERE `groupId`=1038 AND `spawnId`=3000463; +UPDATE `spawn_group` SET `spawnId`=397106 WHERE `groupId`=1038 AND `spawnId`=3000464; +UPDATE `spawn_group` SET `spawnId`=397107 WHERE `groupId`=1038 AND `spawnId`=3000465; +UPDATE `spawn_group` SET `spawnId`=397108 WHERE `groupId`=1038 AND `spawnId`=3000466; +UPDATE `spawn_group` SET `spawnId`=397109 WHERE `groupId`=1038 AND `spawnId`=3000467; +UPDATE `spawn_group` SET `spawnId`=397110 WHERE `groupId`=1039 AND `spawnId`=3000468; +UPDATE `spawn_group` SET `spawnId`=397111 WHERE `groupId`=1039 AND `spawnId`=3000469; +UPDATE `spawn_group` SET `spawnId`=397112 WHERE `groupId`=1039 AND `spawnId`=3000470; +UPDATE `spawn_group` SET `spawnId`=397113 WHERE `groupId`=1039 AND `spawnId`=3000471; +UPDATE `spawn_group` SET `spawnId`=397114 WHERE `groupId`=1039 AND `spawnId`=3000472; +UPDATE `spawn_group` SET `spawnId`=397115 WHERE `groupId`=1039 AND `spawnId`=3000473; +UPDATE `spawn_group` SET `spawnId`=397116 WHERE `groupId`=1039 AND `spawnId`=3000474; +UPDATE `spawn_group` SET `spawnId`=397117 WHERE `groupId`=1040 AND `spawnId`=3000475; + +UPDATE `creature_addon` SET `SheathState`=1 WHERE `guid` IN (8143,8146,8147,63387,78195,78196,78197,78198,82292,112378); +UPDATE `creature_addon` SET `StandState`=0, `SheathState`=0 WHERE `guid`=135230; + +-- Gameobject +DELETE FROM `gameobject` WHERE `guid` IN (76871,76872,76873,76874,76875,76876,76877,76878,76879,76880,76881,76882,76883,76884,76885,76886,76887,76888,76889,76890,76891,76892,76893,76894,76895,76896,76897,76898,76899,76900,76901,76902,76903,76904,76905,76906,76907,76908,76909,76910,76911,76912,76913,76914,76915,76916,76917,76918,76919,76920); + +UPDATE `gameobject` SET `terrainSwapMap`=-1 WHERE `guid` IN (5000030); + +DELETE FROM `gameobject_addon` WHERE `guid` IN (76871,76872,76873,76874,76875,76876,76877,76878,76879,76880,76881,76882,76883,76884,76885,76886,76887,76888,76889,76890,76891,76892,76893,76894,76895,76896,76897,76898,76899,76900,76901,76902,76903,76904,76905,76906,76907,76908,76909,76910,76911,76912,76913,76914,76916,76917,76918,76919,76920,37671,37686,224905,224906,224907,224908,224909,224910,224911,224912,224913,224914,224915,224916,224917,224918,224919,224920,224921,224922,224923,224924,224925,224926,224927,224928,224929,224945,224946,224947,224948,224949,224950,224951,224952,224953,224954,224955,224956,224957,224958,224959,224960,224961,224962,224963,224964,224965,224966,224967,224968,224969,224970,224971,224972,224973,224974,224975,224976,224977,224978,224979,224980,224981,224982,224983,224984,224985,224986,224987,224988,224989,224990); + +-- Quests +INSERT INTO `quest_template_addon` (`ID`, `ProvidedItemCount`) +(SELECT qt.`ID`, 1 FROM `quest_template` qt +LEFT JOIN `quest_template_addon` qta ON qta.`ID` = qt.`ID` +WHERE qt.`StartItem`!=0 AND qta.`ProvidedItemCount` IS NULL); |