diff options
Diffstat (limited to 'sql')
9 files changed, 81 insertions, 0 deletions
diff --git a/sql/updates/world/2013_01_19_00_world_creature_text.sql b/sql/updates/world/2013_01_19_00_world_creature_text.sql new file mode 100644 index 00000000000..ed52fe13b29 --- /dev/null +++ b/sql/updates/world/2013_01_19_00_world_creature_text.sql @@ -0,0 +1 @@ +UPDATE `creature_text` SET `sound`=5802 WHERE `entry`=4832 AND `groupid`=0; diff --git a/sql/updates/world/2013_01_19_01_world_creature_text.sql b/sql/updates/world/2013_01_19_01_world_creature_text.sql new file mode 100644 index 00000000000..4fb6bc55c87 --- /dev/null +++ b/sql/updates/world/2013_01_19_01_world_creature_text.sql @@ -0,0 +1,2 @@ +UPDATE `creature_text` SET `text`='Just...Dust…',`sound`=5803 WHERE `entry`=4832 AND `groupid`=2; +UPDATE `creature_text` SET `text`='Who dares disturb my meditation!' WHERE `entry`=4832 AND `groupid`=0; diff --git a/sql/updates/world/2013_01_19_02_world_conditions.sql b/sql/updates/world/2013_01_19_02_world_conditions.sql new file mode 100644 index 00000000000..744029f4fa0 --- /dev/null +++ b/sql/updates/world/2013_01_19_02_world_conditions.sql @@ -0,0 +1,3 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=35475; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 7, 35475, 0, 0, 27, 0, 80, 2, 0, 0, 0, 0, '', 'Drums of War - level restriction'); diff --git a/sql/updates/world/2013_01_19_03_world_creature_text.sql b/sql/updates/world/2013_01_19_03_world_creature_text.sql new file mode 100644 index 00000000000..d9a15f4da7a --- /dev/null +++ b/sql/updates/world/2013_01_19_03_world_creature_text.sql @@ -0,0 +1 @@ +UPDATE `creature_text` SET `text`='Just...Dust...' WHERE `entry`=4832 AND `groupid`=2; diff --git a/sql/updates/world/2013_01_19_04_world_creature_addon.sql b/sql/updates/world/2013_01_19_04_world_creature_addon.sql new file mode 100644 index 00000000000..fbe99d8edf2 --- /dev/null +++ b/sql/updates/world/2013_01_19_04_world_creature_addon.sql @@ -0,0 +1,29 @@ +UPDATE `creature_addon` SET `auras`='' WHERE `guid` IN ( +9785,9784,9771, -- Devotion Aura On Dragonmaw Swamprunner, Centurion, Bonewarder +5056, -- Unholy Shield on Morbent Fel +16707,16719,16733,16735,16737,16751,16754,16771,16796,16863,16962,16963,16987,17004,17005,17006,17010,17013,17017,17018,17021,17028, -- Stealth on Syndicate Spy +16709,16880,16881,16882,16883,16901,16985,17031,17032,17044,17047,17048,17051,17097, -- Stealth on Syndicate Assassin +11547,11550,11577,11608,11612,11654,11696,11812,11976,12904,12910,12912,13251,13303,13304,13310,13311,13313,13315, -- Stealth on Syndicate Highwayman +14652, -- Shadow Channeling on Marez Cowl +13594,13598, -- Defensive Stance on Bael'dun Excavator +14055, -- Stealth on Mad Magglish +33157,33158,33159,33160,33161,33162, -- Stealth on Felmusk Shadowstalker +34187,34189,34191, -- Bear form on Cenarion Protector +32349, -- Sleep visual on Relara Whitemoon +40101,40087,40055,40050,40042,40030,40012,40001, -- Inner Fire on Scarlet Chaplain +31208,31214,31360,31385,31387,31390,31391,31393,31463,31473,31607,31608,31617,31619,31622, -- Fire Shield on Fireman Scalebane +81447,81446,81444,81440,43695,42624,42622,42607,42605, -- Demon Skin on Sandfury Shadowcaster +91931,92324,92513,92665,92670,92671, -- Disease Cloud on Stiched Golem +48477,48563,48585,48761,48765,48768,48769,48772,48809,48816,48818,48827,48832,48836,48837,48921,48922,48923,48924,48926,48983,48987,48993,48999,91411,91412,91415, -- Disease Cloud on Diseased Ghoul +81927,81931,81940,81987,81995,82301,82316,82341,82355,82378,82394,82396,82397,82413,82426,82479,82510,82611,82612,82613,82615,82662,82763,82771, -- Draining Touch on Vampiric Mistbat +61856,61928,61931,61940, -- Thorns on Barbed Crawler +67462,67465,67468,67469, -- Arcane Shield on Warp Aberration +74883, -- Freeze Anim on Legion Hold Fel Reaver +132572, -- Shroud of Death on Time-Lost Skettis High Priest +76348,76349,76351,76353,76355,76356,76358,76359,76360,76362,76363,76364,76365,76366,76368,76369,76370,76371,76372,76373,76374,76376, -- Ghostly Facade on Cleric of Karabor +12803,12802,12801,12800,12799,12798, -- Lightning Shield on Ashtongue Stormcaller +132849,132850,132852,132853,132855,132851,132854,132856,132857, -- Phasing Invisibility on Blackwind Warp Chaser +32943, -- Cat form on Becanna Edune +132863, -- Oil coat on Oil-Stained Wolf +126539,126542,126553,126556,126562,126564,126567,126568,126569,126572,126574,126579,126582, -- Arcane Missiles on Crazed Mana-Wraith +127067); -- Head Crack on Drakkari Earthhshaker diff --git a/sql/updates/world/2013_01_19_04_world_creature_text.sql b/sql/updates/world/2013_01_19_04_world_creature_text.sql new file mode 100644 index 00000000000..c14cf5c149a --- /dev/null +++ b/sql/updates/world/2013_01_19_04_world_creature_text.sql @@ -0,0 +1 @@ +UPDATE `creature_text` SET `text`='Who dares disturb my meditation?' WHERE `entry`=4832 AND `groupid`=0; diff --git a/sql/updates/world/2013_01_19_05_world_creature_addon.sql b/sql/updates/world/2013_01_19_05_world_creature_addon.sql new file mode 100644 index 00000000000..0a384501e36 --- /dev/null +++ b/sql/updates/world/2013_01_19_05_world_creature_addon.sql @@ -0,0 +1,2 @@ +-- delete 31 creature_addon data that contain no information (bytes2=1 is the default) +DELETE FROM `creature_addon` WHERE `guid` IN (132572,126539,126542,126553,126556,126562,126564,126567,126568,126569,126572,126574,126579,126582,127067,132849,132850,132851,132852,132853,132854,132855,132856,132857,132863,108034,108035,108036,108037,203372,203373); diff --git a/sql/updates/world/2013_01_19_06_world_misc.sql b/sql/updates/world/2013_01_19_06_world_misc.sql new file mode 100644 index 00000000000..55d9777a71c --- /dev/null +++ b/sql/updates/world/2013_01_19_06_world_misc.sql @@ -0,0 +1,14 @@ +UPDATE `quest_template` SET `PrevQuestId`=12872 WHERE `Id` IN (12871,12885); +UPDATE `quest_template` SET `PrevQuestId`=12928 WHERE `Id` IN (12929,13273); + +UPDATE `gameobject_template` SET `flags`=`flags`|4 WHERE `entry` IN +(188364,188501,188502,188503,186684,186390,186950,186954,186955,186912,186662,186618,186587,186595,186607,186938,187027,186427,187026,187022,187023,188702,188703,188705,189983,186632,186619,186591,186397, +186640,186679,186828,186830,186832,186885,186886,187033,187381,187577,187683,187684,187685,187686,187687,187885,187886,188015,188016,188017,188066,188120,188462,188489,188646,188650,188658,188659,189288, +189293,189295,189298,189306,190127,190189,190354,190483,190484,190578,190612,190613,190614,190623,190624,190625,190643,190696,190720,191179,191567,191814,191815,192058,192171,192172,192556,192676,192693, +193091,193092,193196,193197,193404,193560,193561,193767,193792,193793,193943,193945,193946,194158,194159,194238,194340,194341,194423,194424,195022,195037,195274,195344,201367,201384,201794,201937); + +UPDATE `gameobject_template` SET `flags`=`flags`|16 WHERE `entry` IN +(193603,193905,193967,194158,194159,195046,195047,195323,195324,195374,195375,195631,195632,195633,195635,195709,195710,201710,201959); + +UPDATE `gameobject_template` SET `faction`=94 WHERE `entry` IN (195046,195047,195631,195632,195633,195635); +UPDATE `gameobject_template` SET `faction`=35 WHERE `entry` IN (201710,201959); diff --git a/sql/updates/world/2013_01_19_06_world_trinity_string.sql b/sql/updates/world/2013_01_19_06_world_trinity_string.sql new file mode 100644 index 00000000000..322d43a7720 --- /dev/null +++ b/sql/updates/world/2013_01_19_06_world_trinity_string.sql @@ -0,0 +1,28 @@ +DELETE FROM `trinity_string` WHERE `entry` BETWEEN 820 AND 842; +INSERT INTO `trinity_string`(`entry`,`content_default`) VALUES +(820,'* has gossip (%u)'), +(821,'* is quest giver (%u)'), +(822,'* is class trainer (%u)'), +(823,'* is profession trainer(%u)'), +(824,'* is ammo vendor (%u)'), +(825,'* is food vendor(%u)'), +(826,'* is poison vendor (%u)'), +(827,'* is reagent vendor (%u)'), +(828,'* can repair (%u)'), +(829,'* is flight master (%u)'), +(830,'* is spirit healer (%u)'), +(831,'* is spirit guide (%u)'), +(832,'* is innkeeper (%u)'), +(833,'* is banker (%u)'), +(834,'* is petitioner (%u)'), +(835,'* is tabard designer (%u)'), +(836,'* is battle master (%u)'), +(837,'* is auctioneer (%u)'), +(838,'* is stable master (%u)'), +(839,'* is guild banker (%u)'), +(840,'* has spell click (%u)'), +(841,'* is mailbox (%u)'), +(842,'* is player vehicle (%u)'); + +UPDATE `trinity_string` SET `content_default`='* is vendor (%u)' WHERE `entry`=545; +UPDATE `trinity_string` SET `content_default`='* is trainer (%u)' WHERE `entry`=546; |