diff options
Diffstat (limited to 'sql')
16 files changed, 86 insertions, 0 deletions
diff --git a/sql/updates/world/2014_01_26_08_world_creature_template.sql b/sql/updates/world/2014_01_26_08_world_creature_template.sql new file mode 100644 index 00000000000..8adaaa07a50 --- /dev/null +++ b/sql/updates/world/2014_01_26_08_world_creature_template.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `flags_extra`=130 WHERE `entry`=34174; diff --git a/sql/updates/world/2014_01_26_09_world_spell_script_names_335.sql b/sql/updates/world/2014_01_26_09_world_spell_script_names_335.sql new file mode 100644 index 00000000000..664ff0f8228 --- /dev/null +++ b/sql/updates/world/2014_01_26_09_world_spell_script_names_335.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (53407,20271,53408); +INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES +(53407,'spell_pal_judgement_of_justice'), +(20271,'spell_pal_judgement_of_light'), +(53408,'spell_pal_judgement_of_wisdom'); diff --git a/sql/updates/world/2014_01_27_00_world_creature_queststarter.sql b/sql/updates/world/2014_01_27_00_world_creature_queststarter.sql new file mode 100644 index 00000000000..d77ae243d5d --- /dev/null +++ b/sql/updates/world/2014_01_27_00_world_creature_queststarter.sql @@ -0,0 +1,2 @@ +-- +INSERT INTO `creature_queststarter` (`id`,`quest`) VALUES (16271,9617); diff --git a/sql/updates/world/2014_01_27_01_world_creature.sql b/sql/updates/world/2014_01_27_01_world_creature.sql new file mode 100644 index 00000000000..06383902c49 --- /dev/null +++ b/sql/updates/world/2014_01_27_01_world_creature.sql @@ -0,0 +1,2 @@ +-- +DELETE FROM `creature` WHERE `guid`=86933; diff --git a/sql/updates/world/2014_01_27_02_world_creature_template.sql b/sql/updates/world/2014_01_27_02_world_creature_template.sql new file mode 100644 index 00000000000..3f8a5288f38 --- /dev/null +++ b/sql/updates/world/2014_01_27_02_world_creature_template.sql @@ -0,0 +1,3 @@ +-- +UPDATE `creature_template` SET `spell1`=32982 WHERE `entry`=15439; +UPDATE `creature_template` SET `spell1`=33663 WHERE `entry`=15430; diff --git a/sql/updates/world/2014_01_27_03_world_quest.sql b/sql/updates/world/2014_01_27_03_world_quest.sql new file mode 100644 index 00000000000..b431d304bb2 --- /dev/null +++ b/sql/updates/world/2014_01_27_03_world_quest.sql @@ -0,0 +1,23 @@ +-- Fix taking of 6962/7025 Treats for Great-father Winter +-- Horde +UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=6962; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) and `SourceEntry`IN(6962); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(20, 0, 6962, 0, 0, 8, 0, 7021, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(19, 0, 6962, 0, 0, 8, 0, 7021, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(20, 0, 6962, 0, 1, 8, 0, 7024, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(19, 0, 6962, 0, 1, 8, 0, 7024, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(20, 0, 6962, 0, 2, 8, 0, 6961, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(19, 0, 6962, 0, 2, 8, 0, 6961, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'); + +-- Alliance +UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=7025; +UPDATE `creature_queststarter` SET `id`='13433' WHERE `id`='13429' and`quest`='7022'; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) and `SourceEntry`IN(7025); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(20, 0, 7025, 0, 0, 8, 0, 7022, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(19, 0, 7025, 0, 0, 8, 0, 7022, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(20, 0, 7025, 0, 1, 8, 0, 7023, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(19, 0, 7025, 0, 1, 8, 0, 7023, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'); diff --git a/sql/updates/world/2014_01_27_04_world_conditions.sql b/sql/updates/world/2014_01_27_04_world_conditions.sql new file mode 100644 index 00000000000..1ca0da434f3 --- /dev/null +++ b/sql/updates/world/2014_01_27_04_world_conditions.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceGroup`=29501 AND `SourceEntry`=54575; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(18, 29501, 54575, 0, 0, 15, 0, 32, 0, 0, 0, 0, 0, '', 'Spellclick only for dks'); diff --git a/sql/updates/world/2014_01_27_05_world_spell_target_position.sql b/sql/updates/world/2014_01_27_05_world_spell_target_position.sql new file mode 100644 index 00000000000..4dfb0ae26a4 --- /dev/null +++ b/sql/updates/world/2014_01_27_05_world_spell_target_position.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `spell_target_position` WHERE `id`=26448; +INSERT INTO `spell_target_position` (`id`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`) VALUES +(26448,1,7581.01,-2225.35,473.64,1.80); diff --git a/sql/updates/world/2014_01_27_06_world_gameobject.sql b/sql/updates/world/2014_01_27_06_world_gameobject.sql new file mode 100644 index 00000000000..80b613e7603 --- /dev/null +++ b/sql/updates/world/2014_01_27_06_world_gameobject.sql @@ -0,0 +1,17 @@ +-- By Darkman1983 +SET @GUID =11995; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(@GUID+0, 300058, 1, 0, 0, 1983.464966, -4255.527344, 31.897110, 0.526572, 0, 0, 0, 0, 300, 0, 1), +(@GUID+1, 300058, 1, 0, 0, -1031.407349, -230.353455, 160.180954, 3.209599, 0, 0, 0, 0, 300, 0, 1), +(@GUID+2, 300058, 1, 0, 0, 10150.500000, 2602.330078, 1330.829956, 4.751910, 0, 0, 0, 0, 300, 0, 1), +(@GUID+3, 300058, 0, 0, 0, 1642.353760, 239.186249, 62.591576, 5.267044, 0, 0, 0, 0, 300, 0, 1), +(@GUID+4, 300058, 0, 0, 0, -4663.466797, -955.900879, 500.377686, 5.617465, 0, 0, 0, 0, 300, 0, 1), +(@GUID+5, 300058, 0, 0, 0, -8747.168945, 1073.401367, 90.419289, 5.551456, 0, 0, 0, 0, 300, 0, 1); + +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(7, @GUID+0), +(7, @GUID+1), +(7, @GUID+2), +(7, @GUID+3), +(7, @GUID+4), +(7, @GUID+5); diff --git a/sql/updates/world/2014_01_27_07_world_creature_template.sql b/sql/updates/world/2014_01_27_07_world_creature_template.sql new file mode 100644 index 00000000000..6da1a479c5e --- /dev/null +++ b/sql/updates/world/2014_01_27_07_world_creature_template.sql @@ -0,0 +1,3 @@ +-- +UPDATE `creature_template` SET `faction_A` = 83, `faction_H` = 83 WHERE `entry` = 38095; -- Sniffs confirm 37034 faction 83. +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80, `faction_A`=83, `faction_H`=83 WHERE `entry`=35407; -- Sniffs confirm 34918 faction 83, copy level from normal mode. diff --git a/sql/updates/world/2014_01_27_08_world_creature_template.sql b/sql/updates/world/2014_01_27_08_world_creature_template.sql new file mode 100644 index 00000000000..d5818d2c979 --- /dev/null +++ b/sql/updates/world/2014_01_27_08_world_creature_template.sql @@ -0,0 +1,6 @@ +-- +UPDATE `creature_template` SET `faction_A` = 1770, `faction_H` = 1770 WHERE `entry` = 37809; -- Sniff shows faction 1770 for mob 37774 +UPDATE `creature_template` SET `faction_A` = 1214, `faction_H` = 1214 WHERE `entry` = 37296; -- Sniff shows faction 1214 for mob 14282 +UPDATE `creature_template` SET `faction_A` = 1594, `faction_H` = 1594 WHERE `entry` = 37240; -- Sniff shows faction 1594 for mob 14187 +UPDATE `creature_template` SET `faction_A` = 1334, `faction_H` = 1334 WHERE `entry` = 37416; -- Sniff shows faction 1334 for mob 11997 +UPDATE `creature_template` SET `faction_A` = 877, `faction_H` = 877 WHERE `entry` = 37370; -- Sniff shows faction 877 for mob 14185 diff --git a/sql/updates/world/2014_01_27_09_world_gameobject.sql b/sql/updates/world/2014_01_27_09_world_gameobject.sql new file mode 100644 index 00000000000..0d4a56a1045 --- /dev/null +++ b/sql/updates/world/2014_01_27_09_world_gameobject.sql @@ -0,0 +1,2 @@ +-- +UPDATE `gameobject` SET `spawnMask` = 1, `phaseMask` = 1 WHERE `id` = 300058; diff --git a/sql/updates/world/2014_01_27_10_world_creature_model_info.sql b/sql/updates/world/2014_01_27_10_world_creature_model_info.sql new file mode 100644 index 00000000000..adb94260fb9 --- /dev/null +++ b/sql/updates/world/2014_01_27_10_world_creature_model_info.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_model_info` SET `modelid_other_gender`=0 WHERE `modelid` IN (1812, 3441); diff --git a/sql/updates/world/2014_01_27_10_world_creature_template.sql b/sql/updates/world/2014_01_27_10_world_creature_template.sql new file mode 100644 index 00000000000..6a47eb02805 --- /dev/null +++ b/sql/updates/world/2014_01_27_10_world_creature_template.sql @@ -0,0 +1,5 @@ +-- +UPDATE `creature_template` SET `faction_A` = 534, `faction_H` = 534 WHERE `entry` IN (37497,37603,37604); -- Sniff shows faction 534 for mobs 37496,37497 +UPDATE `creature_template` SET `faction_A` = 57, `faction_H` = 57 WHERE `entry` = 37281; -- Sniff shows faction 57 for mob 14188 +UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21 WHERE `entry` = 37638; -- Sniff shows faction 21 for mob 36830 +UPDATE `creature_template` SET `faction_A` = 74, `faction_H` = 74 WHERE `entry` IN (19897,19899); -- Sniff shows faction 74 for mobs 18176, 18179 diff --git a/sql/updates/world/2014_01_27_12_world_creature_template.sql b/sql/updates/world/2014_01_27_12_world_creature_template.sql new file mode 100644 index 00000000000..7e88de7d20d --- /dev/null +++ b/sql/updates/world/2014_01_27_12_world_creature_template.sql @@ -0,0 +1,3 @@ +-- +UPDATE `creature_template` SET `faction_A` = 1215, `faction_H` = 1215 WHERE `entry` IN (37486,37318,37373,37485,37399,37401,37479,37320,37305); +UPDATE `creature_template` SET `faction_A` = 1217, `faction_H` = 1217 WHERE `entry` IN (37480,37483,37484); diff --git a/sql/updates/world/2014_01_27_13_world_creature_template.sql b/sql/updates/world/2014_01_27_13_world_creature_template.sql new file mode 100644 index 00000000000..e7e6edf8ed5 --- /dev/null +++ b/sql/updates/world/2014_01_27_13_world_creature_template.sql @@ -0,0 +1,3 @@ +-- +UPDATE `creature_template` SET `faction_A` = 1217, `faction_H` = 1217 WHERE `entry` IN (37242,37349,37344,37427,37348,37420,37315); +UPDATE `creature_template` SET `faction_A` = 1534, `faction_H` = 1534 WHERE `entry` IN (37285,37287,37327); |