diff options
| author | runningnak3d <runningnak3d@gmail.com> | 2011-02-11 15:48:24 -0700 |
|---|---|---|
| committer | runningnak3d <runningnak3d@gmail.com> | 2011-02-11 15:48:24 -0700 |
| commit | 01a80ec8d62706f8f869629a2c93aedd5aa1eae7 (patch) | |
| tree | 76404ecc188d27bb9e91b5b630ffa06f06f2aa53 /sql/old | |
| parent | 84cf9c593abc60b873952a5fb3f698dc2da21ba9 (diff) | |
SQL: move all SQL that is now included in the latest full DB to the
"old" dir.
Diffstat (limited to 'sql/old')
63 files changed, 2027 insertions, 0 deletions
diff --git a/sql/old/3.3.5a/2011_02_03_0_world_instance_encounters.sql b/sql/old/3.3.5a/2011_02_03_0_world_instance_encounters.sql new file mode 100644 index 00000000000..e35e09f1403 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_03_0_world_instance_encounters.sql @@ -0,0 +1,638 @@ +-- +-- Table structure for table `instance_encounters` +-- + +DROP TABLE IF EXISTS `instance_encounters`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `instance_encounters` ( + `entry` int(10) unsigned NOT NULL COMMENT 'Unique entry from DungeonEncounter.dbc', + `creditType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `creditEntry` int(10) unsigned NOT NULL DEFAULT '0', + `lastEncounterDungeon` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'If not 0, LfgDungeon.dbc entry for the instance it is last encounter in', + `comment` varchar(255) NOT NULL DEFAULT '', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `instance_encounters` +-- + +LOCK TABLES `instance_encounters` WRITE; +/*!40000 ALTER TABLE `instance_encounters` DISABLE KEYS */; +INSERT INTO `instance_encounters` VALUES +(161,0,644,0, 'Rhahk''zor'), +(162,0,643,0, 'Sneed'), +(163,0,1763,0, 'Gilnid'), +(164,0,646,0, 'Mr. Smite'), +(165,0,645,0, 'Cookie'), +(166,0,647,0, 'Captain Greenskin'), +(167,0,639,6, 'Edwin VanCleef'), +(201,0,18371,0, 'Shirrak the Dead Watcher'), +(202,0,18373,149, 'Exarch Maladaar'), +(203,0,18341,0, 'Pandemonius'), +(204,0,18343,0, 'Tavarok'), +(205,0,18344,148, 'Nexus-Prince Shaffar'), +(206,0,18472,0, 'Darkweaver Syth'), +(207,0,18473,150, 'Talon King Ikiss'), +(208,0,18731,0, 'Ambassador Hellmaw'), +(209,0,18667,0, 'Blackheart the Inciter'), +(210,0,18732,0, 'Grandmaster Vorpil'), +(211,0,18708,151, 'Murmur'), +(212,0,29309,0, 'Elder Nadox'), +(213,0,29308,0, 'Prince Taldaram'), +(214,0,29310,0, 'Jedoga Shadowseeker'), +(215,0,29311,218, 'Herald Volazj'), +(216,0,28684,0, 'Krik''thir the Gatewatcher'), +(217,0,28921,0, 'Hadronox'), +(218,0,29120,204, 'Anub''arak'), +(219,0,4887,0, 'Ghamoo-ra'), +(220,0,4831,0, 'Lady Sarevess'), +(221,0,6243,0, 'Gelihast'), +(222,0,12902,0, 'Lorgus Jett'), +(224,0,4830,0, 'Old Serra''kis'), +(225,0,4832,0, 'Twilight Lord Kelris'), +(226,0,4829,10, 'Aku''mai'), +(227,0,9018,30, 'High Interrogator Gerstahn'), +(228,0,9025,0, 'Lord Roccor'), +(229,0,9319,0, 'Houndmaster Grebmar'), +(230,0,10096,0, 'Ring of Law'), +(231,0,9024,0, 'Pyromancer Loregrain'), +(232,0,9017,0, 'Lord Incendius'), +(233,0,9041,0, 'Warder Stilgiss'), +(234,0,9056,0, 'Fineous Darkvire'), +(235,0,9016,0, 'Bael''Gar'), +(236,0,9033,0, 'General Angerforge'), +(237,0,8983,0, 'Golem Lord Argelmach'), +(238,0,9537,0, 'Hurley Blackbreath'), +(239,0,9502,0, 'Phalanx'), +(240,0,9543,0, 'Ribbly Screwspigot'), +(241,0,9499,0, 'Plugger Spazzring'), +(242,0,9156,0, 'Ambassador Flamelash'), +(243,0,9035,0, 'The Seven'), +(244,0,9938,0, 'Magmus'), +(245,0,9019,276, 'Emperor Dagran Thaurissan'), +(246,0,18371,0, 'Shirrak the Dead Watcher'), +(247,0,18373,178, 'Exarch Maladaar'), +(248,0,18341,0, 'Pandemonius'), +(249,0,18343,0, 'Tavarok'), +(250,0,22930,0, 'Yor'), +(251,0,18344,179, 'Nexus-Prince Shaffar'), +(252,0,18472,0, 'Darkweaver Syth'), +(253,0,23035,0, 'Anzu'), +(254,0,18473,180, 'Talon King Ikiss'), +(255,0,18731,0, 'Ambassador Hellmaw'), +(256,0,18667,0, 'Blackheart the Inciter'), +(257,0,18732,0, 'Grandmaster Vorpil'), +(258,0,18708,181, 'Murmur'), +(259,0,29309,0, 'Elder Nadox'), +(260,0,29308,0, 'Prince Taldaram'), +(261,0,29310,0, 'Jedoga Shadowseeker'), +(262,0,30258,0, 'Amanitar'), +(263,0,29311,219, 'Herald Volazj'), +(264,0,28684,0, 'Krik''thir the Gatewatcher'), +(265,0,28921,0, 'Hadronox'), +(266,0,29120,241, 'Anub''arak'), +(267,0,9196,0, 'Highlord Omokk'), +(268,0,9236,0, 'Shadow Hunter Vosh''gajin'), +(269,0,9237,0, 'War Master Voone'), +(270,0,10596,0, 'Mother Smolderweb'), +(271,0,10584,0, 'Urok Doomhowl'), +(272,0,9736,0, 'Quartermaster Zigris'), +(273,0,10268,0, 'Gizrul the Slavener'), +(274,0,10220,0, 'Halycon'), +(275,0,9568,32, 'Overlord Wyrmthalak'), +(276,0,9816,0, 'Pyroguard Emberseer'), +(277,0,10264,0, 'Solakar Flamewreath'), +(278,0,10429,0, 'Warchief Rend Blackhand'), +(279,0,10430,0, 'The Beast'), +(280,0,10363,44, 'General Drakkisath'), +(281,0,18096,170, 'Epoch Hunter'), +(282,0,18096,183, 'Epoch Hunter'), +(283,0,17862,0, 'Captain Skarloc'), +(284,0,17862,0, 'Captain Skarloc'), +(285,0,17848,0, 'Lieutenant Drake'), +(286,0,17848,0, 'Lieutenant Drake'), +(287,0,17879,0, 'Chrono Lord Deja'), +(288,0,17879,0, 'Chrono Lord Deja'), +(289,0,17880,0, 'Temporus'), +(290,0,17880,0, 'Temporus'), +(291,0,17881,171, 'Aeonus'), +(292,0,17881,182, 'Aeonus'), +(293,0,26529,0, 'Meathook'), +(294,0,26530,0, 'Salram the Fleshcrafter'), +(295,0,26532,0, 'Chrono-Lord Epoch'), +(296,1,58630,209, 'Mal''ganis'), +(297,0,26529,0, 'Meathook'), +(298,0,26530,0, 'Salram the Fleshcrafter'), +(299,0,26532,0, 'Chrono-Lord Epoch'), +(300,1,58630,210, 'Mal''ganis'), +(301,0,17941,0, 'Mennu the Betrayer'), +(302,0,17991,0, 'Rokmar the Crackler'), +(303,0,17942,140, 'Quagmirran'), +(304,0,17941,0, 'Mennu the Betrayer'), +(305,0,17991,0, 'Rokmar the Crackler'), +(306,0,17942,184, 'Quagmirran'), +(314,0,17797,0, 'Hydromancer Thespia'), +(315,0,17797,0, 'Hydromancer Thespia'), +(316,0,17796,0, 'Mekgineer Steamrigger'), +(317,0,17796,0, 'Mekgineer Steamrigger'), +(318,0,17798,147, 'Warlord Kalithresh'), +(319,0,17798,185, 'Warlord Kalithresh'), +(320,0,17770,0, 'Hungarfen'), +(321,0,17770,0, 'Hungarfen'), +(322,0,18105,0, 'Ghaz''an'), +(323,0,18105,0, 'Ghaz''an'), +(329,0,17826,0, 'Swamplord Musel''ek'), +(330,0,17826,0, 'Swamplord Musel''ek'), +(331,0,17882,146, 'The Black Stalker'), +(332,0,17882,186, 'The Black Stalker'), +(334,1,68572,0, 'Grand Champions'), +(336,1,68572,0, 'Grand Champions'), +(338,1,68574,0, 'Argent Champion'), +(339,1,68574,0, 'Argent Champion'), +(340,1,68663,245, 'The Black Knight'), +(341,1,68663,249, 'The Black Knight'), +(343,0,11490,0, 'Zevrim Thornhoof'), +(344,0,13280,0, 'Hydrospawn'), +(345,0,14327,0, 'Lethtendris'), +(346,0,11492,34, 'Alzzin the Wildshaper'), +(347,0,11488,0, 'Illyanna Ravenoak'), +(348,0,11487,0, 'Magister Kalendris'), +(349,0,11496,0, 'Immol''thar'), +(350,0,11489,0, 'Tendris Warpwood'), +(361,0,11486,36, 'Prince Tortheldrin'), +(362,0,14326,0, 'Guard Mol''dar'), +(363,0,14322,0, 'Stomper Kreeg'), +(364,0,14321,0, 'Guard Fengus'), +(365,0,14323,0, 'Guard Slip''kik'), +(366,0,14325,0, 'Captain Kromcrush'), +(367,0,14324,0, 'Cho''Rush the Observer'), +(368,0,11501,38, 'King Gordok'), +(369,0,26630,0, 'Trollgore'), +(370,0,26630,0, 'Trollgore'), +(371,0,26631,0, 'Novos the Summoner'), +(372,0,26631,0, 'Novos the Summoner'), +(373,0,27483,0, 'King Dred'), +(374,0,27483,0, 'King Dred'), +(375,1,61863,214, 'The Prophet Tharon''ja'), +(376,1,61863,215, 'The Prophet Tharon''ja'), +(378,0,7079,0, 'Viscous Fallout'), +(379,0,7361,0, 'Grubbis'), +(380,0,6235,0, 'Electrocutioner 6000'), +(381,0,6229,0, 'Crowd Pummeler 9-60'), +(382,0,7800,14, 'Mekgineer Thermaplugg'), +(383,0,29304,0, 'Slad''ran'), +(384,0,29304,0, 'Slad''ran'), +(385,0,29573,0, 'Drakkari Colossus'), +(386,0,29573,0, 'Drakkari Colossus'), +(387,0,29305,0, 'Moorabi'), +(388,0,29305,0, 'Moorabi'), +(389,0,29932,0, 'Eck the Ferocious'), +(390,0,29306,216, 'Gal''darah'), +(391,0,29306,217, 'Gal''darah'), +(392,0,17306,0, 'Watchkeeper Gargolmar'), +(393,0,17306,0, 'Watchkeeper Gargolmar'), +(394,0,17308,0, 'Omor the Unscarred'), +(395,0,17308,0, 'Omor the Unscarred'), +(396,0,17537,136, 'Vazruden the Herald'), +(397,0,17537,188, 'Vazruden the Herald'), +(401,0,17381,0, 'The Maker'), +(402,0,17381,0, 'The Maker'), +(403,0,17380,0, 'Broggok'), +(404,0,17380,0, 'Broggok'), +(405,0,17377,137, 'Keli''dan the Breaker'), +(406,0,17377,187, 'Keli''dan the Breaker'), +(407,0,16807,0, 'Grand Warlock Nethekurse'), +(408,0,16807,0, 'Grand Warlock Nethekurse'), +(409,0,20923,0, 'Blood Guard Porung'), +(410,0,16809,0, 'Warbringer O''mrogg'), +(411,0,16809,0, 'Warbringer O''mrogg'), +(412,0,16808,138, 'Warchief Kargath Bladefist'), +(413,0,16808,189, 'Warchief Kargath Bladefist'), +(414,0,24723,0, 'Selin Fireheart'), +(415,0,24723,0, 'Selin Fireheart'), +(416,0,24744,0, 'Vexallus'), +(417,0,24744,0, 'Vexallus'), +(418,0,24560,0, 'Priestess Delrissa'), +(419,0,24560,0, 'Priestess Delrissa'), +(420,0,24664,198, 'Kael''thas Sunstrider'), +(421,0,24664,201, 'Kael''thas Sunstrider'), +(422,0,13282,0, 'Noxxion'), +(423,0,12258,26, 'Razorlash'), +(424,0,12236,272, 'Lord Vyletongue'), +(425,0,12225,0, 'Celebras the Cursed'), +(426,0,12203,0, 'Landslide'), +(427,0,13601,0, 'Tinkerer Gizlock'), +(428,0,13596,0, 'Rotgrip'), +(429,0,12201,273, 'Princess Theradras'), +(430,0,11517,0, 'Oggleflint'), +(431,0,11520,4, 'Taragaman the Hungerer'), +(432,0,11518,0, 'Jergosh the Invoker'), +(433,0,11519,0, 'Bazzalan'), +(434,0,7355,0, 'Tuten''kash'), +(435,0,7357,0, 'Mordresh Fire Eye'), +(436,0,8567,0, 'Glutton'), +(437,0,7358,20, 'Amnennar the Coldbringer'), +(438,0,6168,0, 'Roogug'), +(439,0,4424,0, 'Aggem Thorncurse'), +(440,0,4428,0, 'Death Speaker Jargba'), +(441,0,4420,0, 'Overlord Ramtusk'), +(443,0,4421,16, 'Charlga Razorflank'), +(444,0,3983,0, 'Interrogator Vishas'), +(445,0,4543,18, 'Bloodmage Thalnos'), +(446,0,3974,0, 'Houndmaster Loksey'), +(447,0,6487,165, 'Arcanist Doan'), +(448,0,3975,163, 'Herod'), +(449,0,4542,0, 'High Inquisitor Fairbanks'), +(450,0,3977,164, 'High Inquisitor Whitemane'), +(451,0,10506,0, 'Kirtonos the Herald'), +(452,0,10503,0, 'Jandice Barov'), +(453,0,11622,0, 'Rattlegore'), +(454,0,10433,0, 'Marduk Blackpool'), +(455,0,10432,0, 'Vectus'), +(456,0,10508,0, 'Ras Frostwhisper'), +(457,0,10505,0, 'Instructor Malicia'), +(458,0,11261,0, 'Doctor Theolen Krastinov'), +(459,0,10901,0, 'Lorekeeper Polkelt'), +(460,0,10507,0, 'The Ravenian'), +(461,0,10504,0, 'Lord Alexei Barov'), +(462,0,10502,0, 'Lady Illucia Barov'), +(463,0,1853,2, 'Darkmaster Gandling'), +(464,0,3914,0, 'Rethilgore'), +(465,0,3886,0, 'Razorclaw the Butcher'), +(466,0,3887,0, 'Baron Silverlaine'), +(467,0,4278,0, 'Commander Springvale'), +(468,0,4279,0, 'Odo the Blindwatcher'), +(469,0,4274,0, 'Fenrus the Devourer'), +(470,0,3927,0, 'Wolf Master Nandos'), +(471,0,4275,8, 'Archmage Arugal'), +(472,0,10516,0, 'The Unforgiven'), +(473,0,10558,0, 'Hearthsinger Forresten'), +(474,0,10808,0, 'Timmy the Cruel'), +(475,0,10997,0, 'Cannon Master Willey'), +(476,0,11032,0, 'Malor the Zealous'), +(477,0,10811,0, 'Archivist Galford'), +(478,0,10813,40, 'Balnazzar'), +(479,0,10436,0, 'Baroness Anastari'), +(480,0,10437,0, 'Nerub''enkan'), +(481,0,10438,0, 'Maleki the Pallid'), +(482,0,10435,0, 'Magistrate Barthilas'), +(483,0,10439,0, 'Ramnstein the Gorger'), +(484,0,10440,274, 'Baron Rivendare'), +(485,0,8580,0, 'Atal''alarion'), +(486,0,5721,0, 'Dreamscythe'), +(487,0,5720,0, 'Weaver'), +(488,0,5710,0, 'Jammal''an the Prophet'), +(490,0,5719,0, 'Morphaz'), +(491,0,5722,0, 'Hazzas'), +(492,0,8443,0, 'Avatar of Hakkar'), +(493,0,5709,28, 'Shade of Eranikus'), +(494,0,20870,0, 'Zereketh the Unbound'), +(495,0,20870,0, 'Zereketh the Unbound'), +(496,0,20885,0, 'Dalliah the Doomsayer'), +(497,0,20885,0, 'Dalliah the Doomsayer'), +(498,0,20886,0, 'Wrath-Scryer Soccothrates'), +(499,0,20886,0, 'Wrath-Scryer Soccothrates'), +(500,0,20912,174, 'Harbinger Skyriss'), +(501,0,20912,190, 'Harbinger Skyriss'), +(502,0,17976,0, 'Commander Sarannis'), +(504,0,17976,0, 'Commander Sarannis'), +(505,0,17975,0, 'High Botanist Freywinn'), +(506,0,17975,0, 'High Botanist Freywinn'), +(507,0,17978,0, 'Thorngrin the Tender'), +(508,0,17978,0, 'Thorngrin the Tender'), +(509,0,17980,0, 'Laj'), +(510,0,17980,0, 'Laj'), +(511,0,17977,173, 'Warp Splinter'), +(512,0,17977,191, 'Warp Splinter'), +(513,0,19219,0, 'Mechano-Lord Capacitus'), +(514,0,19219,0, 'Mechano-Lord Capacitus'), +(515,0,19221,0, 'Nethermancer Sepethrea'), +(516,0,19221,0, 'Nethermancer Sepethrea'), +(517,0,19220,172, 'Pathaleon the Calculator'), +(518,0,19220,192, 'Pathaleon the Calculator'), +(519,0,26796,0, 'Frozen Commander'), +(520,0,26731,0, 'Grand Magus Telestra'), +(521,0,26731,0, 'Grand Magus Telestra'), +(522,0,26763,0, 'Anomalus'), +(523,0,26763,0, 'Anomalus'), +(524,0,26794,0, 'Ormorok the Tree-Shaper'), +(525,0,26794,0, 'Ormrok the Tree-Shaper'), +(526,0,26723,225, 'Keristrasza'), +(527,0,26723,226, 'Keristrasza'), +(528,0,27654,0, 'Drakos the Interrogator'), +(529,0,27654,0, 'Drakos the Interrogator'), +(530,0,27447,0, 'Varos Cloudstrider'), +(531,0,27447,0, 'Varos Cloudstrider'), +(532,0,27655,0, 'Mage-Lord Urom'), +(533,0,27655,0, 'Mage-Lord Urom'), +(534,0,27656,206, 'Ley-Guardian Eregos'), +(535,0,27656,211, 'Ley-Guardian Eregos'), +(536,0,1696,0, 'Targorr the Dread'), +(537,0,1666,0, 'Kam Deepfury'), +(538,0,1717,0, 'Hamhock'), +(539,0,1716,0, 'Bazil Thredd'), +(540,0,1663,12, 'Dextren Ward'), +(541,0,29315,0, 'First Prisoner'), +(542,0,29315,0, 'First Prisoner'), +(543,0,29316,0, 'Second Prisoner'), +(544,0,29316,0, 'Second Prisoner'), +(545,0,31134,220, 'Cyanigosa'), +(546,0,31134,221, 'Cyanigosa'), +(547,0,6910,0, 'Revelosh'), +(548,0,6906,0, 'The Lost Dwarves'), +(549,0,7228,0, 'Ironaya'), +(551,0,7206,0, 'Ancient Stone Keeper'), +(552,0,7291,0, 'Galgann Firehammer'), +(553,0,4854,0, 'Grimlok'), +(554,0,2748,22, 'Archaedas'), +(555,0,28586,0, 'General Bjarngrim'), +(556,0,28586,0, 'General Bjarngrim'), +(557,0,28587,0, 'Volkhan'), +(558,0,28587,0, 'Volkhan'), +(559,0,28546,0, 'Ionar'), +(560,0,28546,0, 'Ionar'), +(561,0,28923,207, 'Loken'), +(562,0,28923,212, 'Loken'), +(563,0,27977,0, 'Krystallus'), +(564,0,27977,0, 'Krystallus'), +(565,0,27975,0, 'Maiden of Grief'), +(566,0,27975,0, 'Maiden of Grief'), +(567,1,59046,0, 'Tribunal of Ages'), +(568,1,59046,0, 'Tribunal of Ages'), +(569,0,27978,208, 'Sjonnir the Ironshaper'), +(570,0,27978,213, 'Sjonnir the Ironshaper'), +(571,0,23953,0, 'Prince Keleseth'), +(572,0,23953,0, 'Prince Keleseth'), +(573,0,24201,0, 'Skarvold & Dalronn'), +(574,0,24201,0, 'Skarvold & Dalronn'), +(575,0,23954,202, 'Ingvar the Plunderer'), +(576,0,23954,242, 'Ingvar the Plunderer'), +(577,0,26668,0, 'Svala Sorrowgrave'), +(578,0,26668,0, 'Svala Sorrowgrave'), +(579,0,26687,0, 'Gortok Palehoof'), +(580,0,26687,0, 'Gortok Palehoof'), +(581,0,26693,0, 'Skadi the Ruthless'), +(582,0,26693,0, 'Skadi the Ruthless'), +(583,0,26861,203, 'King Ymiron'), +(584,0,26861,205, 'King Ymiron'), +(585,0,3671,0, 'Lady Anacondra'), +(586,0,3669,0, 'Lord Cobrahn'), +(587,0,3653,0, 'Kresh'), +(588,0,3670,0, 'Lord Pythas'), +(589,0,3674,0, 'Skum'), +(590,0,3673,0, 'Lord Serpentis'), +(591,0,5775,0, 'Verdan the Everliving'), +(592,0,3654,1, 'Mutanus the Devourer'), +(593,0,7795,0, 'Hydromancer Velratha'), +(594,0,7273,0, 'Ghaz''rilla'), +(595,0,8127,0, 'Antu''sul'), +(596,0,7272,0, 'Theka the Martyr'), +(597,0,7271,0, 'Witch Doctor Zum''rah'), +(598,0,7796,0, 'Nekrum Gutchewer'), +(599,0,7275,0, 'Shadowpriest Sezz''ziz'), +(600,0,7267,24, 'Chief Ukorz Sandscalp'), +(601,0,22887,0, 'High Warlord Naj''entus'), +(602,0,22898,0, 'Supremus'), +(603,0,22841,0, 'Shade of Akama'), +(604,0,22871,0, 'Teron Gorefiend'), +(605,0,22948,0, 'Gurtogg Bloodboil'), +(606,0,23420,0, 'Reliquary of Souls'), +(607,0,22947,0, 'Mother Shahraz'), +(608,0,23426,0, 'The Illidari Council'), +(609,0,22917,196, 'Illidan Stormrage'), +(610,0,12435,0, 'Razorgore the Untamed'), +(611,0,13020,0, 'Vaelastrasz the Corrupt'), +(612,0,12017,0, 'Broodlord Lashlayer'), +(613,0,11983,0, 'Firemaw'), +(614,0,14601,0, 'Ebonroc'), +(615,0,11981,0, 'Flamegor'), +(616,0,14020,0, 'Chromaggus'), +(617,0,11583,50, 'Nefarian'), +(618,0,17767,0, 'Rage Winterchill'), +(619,0,17808,0, 'Anetheron'), +(620,0,17888,0, 'Kaz''rogal'), +(621,0,17842,0, 'Azgalor'), +(622,0,17968,195, 'Archimonde'), +(623,0,21216,0, 'Hydross the Unstable'), +(624,0,21217,0, 'The Lurker Below'), +(625,0,21215,0, 'Leotheras the Blind'), +(626,0,21214,0, 'Fathom-Lord Karathress'), +(627,0,21213,0, 'Morogrim Tidewalker'), +(628,0,21212,194, 'Lady Vashj'), +(629,0,34797,0, 'Northrend Beasts'), +(630,0,34797,0, 'Northrend Beasts'), +(631,0,34797,0, 'Northrend Beasts'), +(632,0,34797,0, 'Northrend Beasts'), +(633,0,34780,0, 'Lord Jaraxxus'), +(634,0,34780,0, 'Lord Jaraxxus'), +(635,0,34780,0, 'Lord Jaraxxus'), +(636,0,34780,0, 'Lord Jaraxxus'), +(637,1,68184,0, 'Faction Champions'), +(638,1,68184,0, 'Faction Champions'), +(639,1,68184,0, 'Faction Champions'), +(640,1,68184,0, 'Faction Champions'), +(641,0,34496,0, 'Val''kyr Twins'), +(642,0,34496,0, 'Val''kyr Twins'), +(643,0,34496,0, 'Val''kyr Twins'), +(644,0,34496,0, 'Val''kyr Twins'), +(645,0,34564,246, 'Anub''arak'), +(646,0,34564,248, 'Anub''arak'), +(647,0,34564,247, 'Anub''arak'), +(648,0,34564,250, 'Anub''arak'), +(649,0,18831,0, 'High King Maulgar'), +(650,0,19044,177, 'Gruul the Dragonkiller'), +(651,0,17257,176, 'Magtheridon'), +(652,0,15550,0, 'Attumen the Huntsman'), +(653,0,15687,0, 'Moroes'), +(654,0,16457,0, 'Maiden of the Virtue'), +(655,0,16812,0, 'Opera Event'), +(656,0,15691,0, 'The Curator'), +(657,0,15688,0, 'Terestian Illhoof'), +(658,0,16524,0, 'Shade of Aran'), +(659,0,15689,0, 'Netherspite'), +(660,0,22520,0, 'Chess Event'), +(661,0,15690,175, 'Prince Malchezaar'), +(662,0,17225,0, 'Nightbane'), +(663,0,12118,0, 'Lucifron'), +(664,0,11982,0, 'Magmadar'), +(665,0,12259,0, 'Gehennas'), +(666,0,12057,0, 'Garr'), +(667,0,12264,0, 'Shazzrah'), +(668,0,12056,0, 'Baron Geddon'), +(669,0,12098,0, 'Sulfuron Harbinger'), +(670,0,11988,0, 'Golemagg the Incinerator'), +(671,0,12018,0, 'Majordomo Executus'), +(672,0,11502,48, 'Ragnaros'), +(673,0,15956,0, 'Anub''Rekhan'), +(674,0,15956,0, 'Anub''Rekhan'), +(677,0,15953,0, 'Grand Widow Faerlina'), +(678,0,15953,0, 'Grand Widow Faerlina'), +(679,0,15952,0, 'Maexxna'), +(680,0,15952,0, 'Maexxna'), +(681,0,15954,0, 'Noth the Plaguebringer'), +(682,0,15954,0, 'Noth the Plaguebringer'), +(683,0,15936,0, 'Heigan the Unclean'), +(684,0,15936,0, 'Heigan the Unclean '), +(685,0,16011,0, 'Loatheb'), +(686,0,16011,0, 'Loatheb'), +(687,0,16061,0, 'Instructor Razuvious'), +(689,0,16061,0, 'Instructor Razuvious'), +(690,0,16060,0, 'Gothik the Harvester'), +(691,0,16060,0, 'Gothik the Harvester'), +(692,1,59450,0, 'The Four Horsemen'), +(693,1,59450,0, 'The Four Horsemen'), +(694,0,16028,0, 'Patchwerk'), +(695,0,16028,0, 'Patchwerk '), +(696,0,15931,0, 'Grobbulus'), +(697,0,15931,0, 'Grobbulus'), +(698,0,15932,0, 'Gluth'), +(699,0,15932,0, 'Gluth'), +(700,0,15928,0, 'Thaddius'), +(701,0,15928,0, 'Thaddius'), +(702,0,15989,0, 'Sapphiron'), +(703,0,15989,0, 'Sapphiron'), +(704,0,15990,159, 'Kel''Thuzad'), +(706,0,15990,227, 'Kel''Thuzad'), +(707,0,10184,46, 'Onyxia'), +(708,0,10184,257, 'Onyxia'), +(709,0,15263,0, 'The Prophet Skeram'), +(710,0,15544,0, 'Silithid Royalty'), +(711,0,15516,0, 'Battleguard Sartura'), +(712,0,15510,0, 'Fankriss the Unyielding'), +(713,0,15299,0, 'Viscidus'), +(714,0,15509,0, 'Princess Huhuran'), +(715,0,15275,0, 'Twin Emperors'), +(716,0,15517,0, 'Ouro'), +(717,0,15727,161, 'C''thun'), +(718,0,15348,0, 'Kurinnaxx'), +(719,0,15341,0, 'General Rajaxx'), +(720,0,15340,0, 'Moam'), +(721,0,15370,0, 'Buru the Gorger'), +(722,0,15369,0, 'Ayamiss the Hunter'), +(723,0,15339,160, 'Ossirian the Unscarred'), +(724,0,24892,0, 'Kalecgos'), +(725,0,24882,0, 'Brutallus'), +(726,0,25038,0, 'Felmyst'), +(727,0,25165,0, 'Eredar Twins'), +(728,0,25840,0, 'M''uru'), +(729,0,25315,199, 'Kil''jaeden'), +(730,0,19514,0, 'Al''ar'), +(731,0,19516,0, 'Void Reaver'), +(732,0,18805,0, 'High Astromancer Solarian'), +(733,0,19622,193, 'Kael''thas Sunstrider'), +(734,0,28859,223, 'Malygos'), +(735,0,28859,237, 'Malygos'), +(736,0,30452,0, 'Tenebron'), +(737,0,30452,0, 'Tenebron'), +(738,0,30451,0, 'Shadron'), +(739,0,30451,0, 'Shadron'), +(740,0,30449,0, 'Vesperon'), +(741,0,30449,0, 'Vesperon'), +(742,0,28860,224, 'Sartharion'), +(743,0,28860,238, 'Sartharion'), +(744,0,33113,0, 'Flame Leviathan'), +(745,0,33118,0, 'Ignis the Furnace Master'), +(746,0,33186,0, 'Razorscale'), +(747,0,33293,0, 'XT-002 Deconstructor'), +(748,1,65195,0, 'The Iron Council'), +(749,0,32930,0, 'Kologarn'), +(750,0,33515,0, 'Auriaya'), +(751,1,64899,0, 'Hodir'), +(752,1,64985,0, 'Thorim'), +(753,1,65074,0, 'Freya'), +(754,0,33432,0, 'Mimiron'), +(755,0,33271,0, 'General Vezax'), +(756,0,33288,0, 'Yogg-Saron'), +(757,0,32871,243, 'Algalon the Observer'), +(758,0,33113,0, 'Flame Leviathan'), +(759,0,33118,0, 'Ignis the Furnace Master'), +(760,0,33186,0, 'Razorscale'), +(761,0,33293,0, 'XT-002 Deconstructor'), +(762,1,65195,0, 'The Iron Council'), +(763,0,32930,0, 'Kologarn'), +(764,0,33515,0, 'Auriaya'), +(765,1,64899,0, 'Hodir'), +(766,1,64985,0, 'Thorim'), +(767,1,65074,0, 'Freya'), +(768,0,33432,0, 'Mimiron'), +(769,0,33271,0, 'General Vezax'), +(770,0,33288,0, 'Yogg-Saron'), +(771,0,32871,244, 'Algalon the Observer'), +(772,0,31125,0, 'Archavon the Stone Watcher'), +(773,0,31125,0, 'Archavon the Stone Watcher'), +(774,0,33993,0, 'Emalon the Storm Watcher'), +(775,0,33993,0, 'Emalon the Storm Watcher'), +(776,0,35013,0, 'Koralon the Flame Watcher'), +(777,0,35013,0, 'Koralon the Flame Watcher'), +(778,0,23574,0, 'Akil''zon'), +(779,0,23576,0, 'Nalorakk'), +(780,0,23578,0, 'Jan''alai'), +(781,0,23577,0, 'Halazzi'), +(782,0,24239,0, 'Hex Lord Malacrass'), +(783,0,23863,197, 'Zul''jin'), +(784,0,14507,0, 'High Priest Venoxis'), +(785,0,14517,0, 'High Priestess Jeklik'), +(786,0,14510,0, 'High Priestess Mar''li'), +(787,0,11382,0, 'Bloodlord Mandokir'), +(788,0,15083,0, 'Edge of Madness'), +(789,0,14509,0, 'High Priest Thekal'), +(790,0,15114,0, 'Gahz''ranka'), +(791,0,14515,0, 'High Priestess Arlokk'), +(792,0,11380,0, 'Jin''do the Hexxer'), +(793,0,14834,42, 'Hakkar'), +(829,0,36497,0, 'Bronjahm'), +(830,0,36497,0, 'Bronjahm '), +(831,0,36502,251, 'Devourer of Souls'), +(832,0,36502,252, 'Devourer of Souls'), +(833,0,36494,0, 'Forgemaster Garfrost'), +(834,0,36494,0, 'Forgemaster Garfrost'), +(835,0,36476,0, 'Krick'), +(836,0,36476,0, 'Krick'), +(837,0,36658,253, 'Overlord Tyrannus'), +(838,0,36658,254, 'Overlord Tyrannus'), +(839,0,38113,0, 'Marwyn'), +(840,0,38113,0, 'Marwyn'), +(841,0,38112,0, 'Falric'), +(842,0,38112,0, 'Falric'), +(843,1,72830,255, 'Escaped from Arthas'), +(844,1,72830,256, 'Escaped from Arthas'), +(845,0,36612,0, 'Lord Marrowgar'), +(846,0,36855,0, 'Lady Deathwhisper'), +(847,1,72959,0, 'Icecrown Gunship Battle'), +(848,0,37813,0, 'Deathbringer Saurfang'), +(849,0,36626,0, 'Festergut'), +(850,0,36627,0, 'Rotface'), +(851,0,36678,0, 'Professor Putricide'), +(852,0,37970,0, 'Blood Council'), +(853,0,37955,0, 'Queen Lana''thel'), +(854,1,72706,0, 'Valithria Dreamwalker'), +(855,0,36853,0, 'Sindragosa'), +(856,0,36597,279, 'The Lich King'), +(857,0,36612,0, 'Lord Marrowgar'), +(858,0,36855,0, 'Lady Deathwhisper'), +(859,1,72959,0, 'Icecrown Gunship Battle'), +(860,0,37813,0, 'Deathbringer Saurfang'), +(861,0,36626,0, 'Festergut'), +(862,0,36627,0, 'Rotface'), +(863,0,36678,0, 'Professor Putricide'), +(864,0,37970,0, 'Blood Council'), +(865,0,37955,0, 'Queen Lana''thel'), +(866,1,72706,0, 'Valithria Dreamwalker'), +(867,0,36853,0, 'Sindragosa'), +(868,0,36597,280, 'The Lich King'), +(883,0,4422,0, 'Agathelos the Raging'), +(885,0,38433,239, 'Toravon the Ice Watcher'), +(886,0,38433,240, 'Toravon the Ice Watcher'), +(887,0,39863,293, 'Halion'), +(888,0,39863,294, 'Halion'), +(889,0,39751,0, 'Baltharus the Warborn'), +(890,0,39751,0, 'Baltharus the Warborn'), +(891,0,39747,0, 'Saviana Ragefire'), +(892,0,39747,0, 'Saviana Ragefire'), +(893,0,39746,0, 'General Zarithrian'), +(894,0,39746,0, 'General Zarithrian'); +/*!40000 ALTER TABLE `instance_encounters` ENABLE KEYS */; +UNLOCK TABLES; diff --git a/sql/old/3.3.5a/2011_02_03_1_world_command.sql b/sql/old/3.3.5a/2011_02_03_1_world_command.sql new file mode 100644 index 00000000000..8902097fb06 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_03_1_world_command.sql @@ -0,0 +1 @@ +DELETE FROM `command` WHERE `name`='reload lfg_dungeon_encounters'; diff --git a/sql/old/3.3.5a/2011_02_03_2_world_lfg_dungeon_encounters.sql b/sql/old/3.3.5a/2011_02_03_2_world_lfg_dungeon_encounters.sql new file mode 100644 index 00000000000..9820317ccf1 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_03_2_world_lfg_dungeon_encounters.sql @@ -0,0 +1 @@ +DROP TABLE IF EXISTS `lfg_dungeon_encounters`; diff --git a/sql/old/3.3.5a/2011_02_03_3_world_spell_dbc.sql b/sql/old/3.3.5a/2011_02_03_3_world_spell_dbc.sql new file mode 100644 index 00000000000..0d26399cf42 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_03_3_world_spell_dbc.sql @@ -0,0 +1,18 @@ +DELETE FROM `spell_dbc` WHERE `Id` IN (58630,68572,68574,59046,68184,59450,65195,64899,64985,65074); +INSERT INTO `spell_dbc` (`Id`,`Dispel`,`Mechanic`,`Attributes`,`AttributesEx`,`AttributesEx2`,`AttributesEx3`,`AttributesEx4`,`AttributesEx5`,`Stances`,`StancesNot`,`Targets`,`CastingTimeIndex`,`AuraInterruptFlags`,`ProcFlags`,`ProcChance`,`ProcCharges`, +`MaxLevel`,`BaseLevel`,`SpellLevel`,`DurationIndex`,`RangeIndex`,`StackAmount`,`EquippedItemClass`,`EquippedItemSubClassMask`,`EquippedItemInventoryTypeMask`,`Effect1`,`Effect2`,`Effect3`,`EffectDieSides1`,`EffectDieSides2`,`EffectDieSides3`, +`EffectRealPointsPerLevel1`,`EffectRealPointsPerLevel2`,`EffectRealPointsPerLevel3`,`EffectBasePoints1`,`EffectBasePoints2`,`EffectBasePoints3`,`EffectMechanic1`,`EffectMechanic2`,`EffectMechanic3`,`EffectImplicitTargetA1`,`EffectImplicitTargetA2`,`EffectImplicitTargetA3`, +`EffectImplicitTargetB1`,`EffectImplicitTargetB2`,`EffectImplicitTargetB3`,`EffectRadiusIndex1`,`EffectRadiusIndex2`,`EffectRadiusIndex3`,`EffectApplyAuraName1`,`EffectApplyAuraName2`,`EffectApplyAuraName3`,`EffectAmplitude1`,`EffectAmplitude2`,`EffectAmplitude3`, +`EffectMultipleValue1`,`EffectMultipleValue2`,`EffectMultipleValue3`,`EffectMiscValue1`,`EffectMiscValue2`,`EffectMiscValue3`,`EffectMiscValueB1`,`EffectMiscValueB2`,`EffectMiscValueB3`,`EffectTriggerSpell1`,`EffectTriggerSpell2`,`EffectTriggerSpell3`, +`EffectSpellClassMaskA1`,`EffectSpellClassMaskA2`,`EffectSpellClassMaskA3`,`EffectSpellClassMaskB1`,`EffectSpellClassMaskB2`,`EffectSpellClassMaskB3`,`EffectSpellClassMaskC1`,`EffectSpellClassMaskC2`,`EffectSpellClassMaskC3`,`MaxTargetLevel`,`SpellFamilyName`, +`SpellFamilyFlags1`,`SpellFamilyFlags2`,`SpellFamilyFlags3`,`MaxAffectedTargets`,`DmgClass`,`PreventionType`,`DmgMultiplier1`,`DmgMultiplier2`,`DmgMultiplier3`,`AreaGroupId`,`SchoolMask`,`Comment`) VALUES +(58630,0,0,536870912,0,0,0,0,0,0,0,0,1,0,0,101,0,0,0,0,0,1,0,-1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,16,0,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'Mal''ganis credit marker'), +(68572,0,0,536870912,0,0,0,0,0,0,0,0,1,0,0,101,0,0,0,0,0,1,0,-1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,16,0,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'Grand Champions credit marker'), +(68574,0,0,536870912,0,0,0,0,0,0,0,0,1,0,0,101,0,0,0,0,0,1,0,-1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,16,0,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'Argent Champion credit marker'), +(59046,0,0,536870912,0,0,0,0,0,0,0,0,1,0,0,101,0,0,0,0,0,1,0,-1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,16,0,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'Tribunal of Ages credit marker'), +(68184,0,0,536870912,0,0,0,0,0,0,0,0,1,0,0,101,0,0,0,0,0,1,0,-1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,16,0,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'Faction Champions credit marker'), +(59450,0,0,536870912,0,0,0,0,0,0,0,0,1,0,0,101,0,0,0,0,0,1,0,-1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,16,0,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'The Four Horsemen credit marker'), +(65195,0,0,536870912,0,0,0,0,0,0,0,0,1,0,0,101,0,0,0,0,0,1,0,-1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,16,0,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'The Iron Council credit marker'), +(64899,0,0,536870912,0,0,0,0,0,0,0,0,1,0,0,101,0,0,0,0,0,1,0,-1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,16,0,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'Hodir credit marker'), +(64985,0,0,536870912,0,0,0,0,0,0,0,0,1,0,0,101,0,0,0,0,0,1,0,-1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,16,0,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'Thorim credit marker'), +(65074,0,0,536870912,0,0,0,0,0,0,0,0,1,0,0,101,0,0,0,0,0,1,0,-1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,16,0,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'Freya credit marker'); diff --git a/sql/old/3.3.5a/2011_02_04_0_world_battleground_isle_of_conquest.sql b/sql/old/3.3.5a/2011_02_04_0_world_battleground_isle_of_conquest.sql new file mode 100644 index 00000000000..368f2db97c3 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_battleground_isle_of_conquest.sql @@ -0,0 +1,78 @@ +-- Alliance Gunship Cannon +UPDATE `creature_template` SET `spell1`=69495,`VehicleId`=452 WHERE `entry`=34929; +-- Horde Gunship Cannon +UPDATE `creature_template` SET `spell1`=68825,`VehicleId`=453 WHERE `entry`=34935; +-- Keep Cannon +UPDATE `creature_template` SET `VehicleId`=160,`spell1`=67452,`spell2`=68169 WHERE `entry`=34944; +-- Catapult +UPDATE `creature_template` SET `VehicleId`=438,`spell1`=66218,`spell2`=66296 WHERE `entry`=34793; +-- Demolisher +UPDATE `creature_template` SET `VehicleId`=509,`spell1`=67442,`spell2`=68068 WHERE `entry`=34775; +-- Siege Engine +UPDATE `creature_template` SET `VehicleId`=447,`spell1`=67816,`spell2`=69502 WHERE `entry`=34776; +-- Siege Engine +UPDATE `creature_template` SET `VehicleId`=436,`spell1`=67816,`spell2`=69502 WHERE `entry`=35069; +-- Glaive Thrower +UPDATE `creature_template` SET `VehicleId`=447,`spell1`=68827,`spell2`=69515 WHERE `entry`=34802; +-- Glaive Thrower +UPDATE `creature_template` SET `VehicleId`=447,`spell1`=68827,`spell2`=69515 WHERE `entry`=35273; +-- Flame Turret +UPDATE `creature_template` SET `spell1`=68832 WHERE `entry`=34778; +-- Flame Turret +UPDATE `creature_template` SET `spell1`=68832 WHERE `entry`=36356; +-- Siege Turret +UPDATE `creature_template` SET `spell1`=67462,`spell2`=69505 WHERE `entry`=34777; +-- Siege Turret +UPDATE `creature_template` SET `spell1`=67462,`spell2`=69505 WHERE `entry`=36355; +-- Catapult speed +UPDATE `creature_template` SET `speed_run`=2.428571,`speed_walk`=2.8 WHERE `entry`=34793; + +-- Update alliance boss faction +UPDATE `creature_template` SET `faction_A`=84, `faction_H`=84 WHERE `entry`=34924; +-- Update horde boss faction +UPDATE `creature_template` SET `faction_A`=83, `faction_H`=83 WHERE `entry`=34922; +-- Update Kor Kron Guard faction +UPDATE `creature_template` SET `faction_A`=83, `faction_H`=83 WHERE `entry`=34918; +-- Update Npc Seven TH Legion Infantry faction +UPDATE `creature_template` SET `faction_A`=84, `faction_H`=84 WHERE `entry`=34919; + +-- those doors are not selectables +UPDATE `gameobject_template` SET `flags`=0x00000021 WHERE `entry` IN (195223,195703,195491,195451,195452,195437,195436); + +-- alliance bombs, they can be only used by the horde +UPDATE `gameobject_template` SET `faction`=1995 WHERE `entry`=195332; +-- horde bombs, they can be only used by the alliance +UPDATE `gameobject_template` SET `faction`=1997 WHERE `entry`=195333; + +-- horde teleporters +UPDATE `gameobject_template` SET `faction`=1995 WHERE `entry` IN (195314,195313); +-- alliance teleporters +UPDATE `gameobject_template` SET `faction`=1997 WHERE `entry` IN (195315,195316); + +-- Achievement Glaive Grave +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=12183; + +-- Achievement Mowed Down +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry` IN (12068,12114); + +-- Refinery's and Quarry's spells. +DELETE FROM `spell_area` WHERE `spell` IN (68719,68720); +INSERT INTO `spell_area` (`spell`,`area`) VALUES +(68719,4741), +(68719,4747), +(68719,4748), +(68719,4749), +(68719,4750), +(68719,4751), +(68719,4752), +(68719,4753), +(68719,4710), +(68720,4741), +(68720,4747), +(68720,4748), +(68720,4749), +(68720,4750), +(68720,4751), +(68720,4752), +(68720,4710), +(68720,4753); diff --git a/sql/old/3.3.5a/2011_02_04_0_world_conditions.sql b/sql/old/3.3.5a/2011_02_04_0_world_conditions.sql new file mode 100644 index 00000000000..504835cd8b9 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_conditions.sql @@ -0,0 +1,5 @@ +DELETE FROM `conditions` WHERE `SourceEntry` IN (62521,62524,62525); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,0,62524,0,18,1,32906,0,0,'','Attuned to Nature 2 Dose Reduction'), +(13,0,62525,0,18,1,32906,0,0,'','Attuned to Nature 10 Dose Reduction'), +(13,0,62521,0,18,1,32906,0,0,'','Attuned to Nature 25 Dose Reduction'); diff --git a/sql/old/3.3.5a/2011_02_04_0_world_creature_631.sql b/sql/old/3.3.5a/2011_02_04_0_world_creature_631.sql new file mode 100644 index 00000000000..c9db3f6a929 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_creature_631.sql @@ -0,0 +1,70 @@ +SET @GUID := 151761; +DELETE FROM `creature` WHERE `guid` BETWEEN @GUID AND @GUID+64; +INSERT INTO creature + (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) +VALUES +(@GUID,37122,631,15,1,0,0,4365.98,2672.63,349.271,4.67748,604800,0,0,130330,4081,0,0,0,0,0), -- Captain Arnath +(@GUID+1,37123,631,15,1,0,0,4361.32,2675.74,349.389,4.64258,604800,0,0,130330,61215,0,0,0,0,0), -- Captain Brandon +(@GUID+2,37124,631,15,1,0,0,4349.95,2677.52,349.306,4.83962,604800,0,0,130330,0,0,0,0,0,0), -- Captain Grondel +(@GUID+3,37125,631,15,1,0,0,4347.03,2673.68,349.37,4.85202,604800,0,0,130330,0,0,0,0,0,0), -- Captain Rupert +(@GUID+4,37127,631,15,1,0,0,4346.72,2607.9,351.101,3.23426,7200,0,0,453600,8814,0,0,0,0,0), -- Ymirjar Frostbinder +(@GUID+5,37127,631,15,1,0,0,4371.41,2570.52,351.101,0.0808906,7200,0,0,453600,8814,0,0,0,0,0), -- Ymirjar Frostbinder +(@GUID+6,37129,631,15,1,0,0,4356.9,2673.27,349.47,4.76475,604800,0,0,278900,0,0,0,0,0,0), -- Crok Scourgebane +(@GUID+7,37132,631,15,1,0,0,4347.2,2637.91,351.1,1.34068,7200,0,0,567000,0,0,0,0,0,0), -- Ymirjar Battle-Maiden +(@GUID+8,37132,631,15,1,0,0,4367.9,2638.14,351.1,1.77657,7200,0,0,567000,0,0,0,0,0,0), -- Ymirjar Battle-Maiden +(@GUID+9,37132,631,15,1,0,0,4345.88,2577.64,351.101,1.52995,7200,0,0,567000,0,0,0,0,0,0), -- Ymirjar Battle-Maiden +(@GUID+10,37132,631,15,1,0,0,4368.03,2578.97,351.101,1.69096,7200,0,0,567000,0,0,0,0,0,0), -- Ymirjar Battle-Maiden +(@GUID+11,37132,631,15,1,0,0,4369.26,2525.06,358.433,1.78913,7200,0,0,567000,0,0,0,0,0,0), -- Ymirjar Battle-Maiden +(@GUID+12,37132,631,15,1,0,0,4343.78,2525.43,358.433,1.26291,7200,0,0,567000,0,0,0,0,0,0), -- Ymirjar Battle-Maiden +(@GUID+13,37133,631,15,1,0,0,4356.85,2636.39,351.101,1.56922,7200,0,0,630000,0,0,0,0,0,0), -- Ymirjar Warlord +(@GUID+14,37133,631,15,1,0,0,4346.98,2512.75,358.441,1.35716,7200,0,0,630000,0,0,0,0,0,0), -- Ymirjar Warlord +(@GUID+15,37133,631,15,1,0,0,4356.77,2524.27,358.433,1.50246,7200,0,0,630000,0,0,0,0,0,0), -- Ymirjar Warlord +(@GUID+16,37134,631,15,1,0,0,4351.66,2642.95,351.1,1.40351,7200,0,0,441000,3994,0,0,0,0,0), -- Ymirjar Huntress +(@GUID+17,37134,631,15,1,0,0,4362.18,2642.97,351.1,1.5331,7200,0,0,441000,3994,0,0,0,0,0), -- Ymirjar Huntress +(@GUID+18,37134,631,15,1,0,0,4363.48,2585.09,351.101,1.58493,7200,0,0,441000,3994,0,0,0,0,0), -- Ymirjar Huntress +(@GUID+19,37134,631,15,1,0,0,4349.36,2584.54,351.101,1.60849,7200,0,0,441000,3994,0,0,0,0,0), -- Ymirjar Huntress +(@GUID+20,37134,631,15,1,0,0,4350.65,2528.31,358.433,1.52995,7200,0,0,441000,3994,0,0,0,0,0), -- Ymirjar Huntress +(@GUID+21,37134,631,15,1,0,0,4362.76,2527.67,358.433,1.48282,7200,0,0,441000,3994,0,0,0,0,0), -- Ymirjar Huntress +(@GUID+22,37531,631,15,1,0,0,4362.85,2514.43,203.383,0.541144,7200,0,0,1134000,0,0,0,0,0,0), -- Frostwarden Handler +(@GUID+23,37531,631,15,1,0,0,4360.96,2454.38,203.384,5.7719,7200,0,0,1134000,0,0,0,0,0,0), -- Frostwarden Handler +(@GUID+24,37532,631,15,1,0,0,4389.66,2533.88,203.387,1.49305,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+25,37532,631,15,1,0,0,4379.52,2517.11,203.383,1.55823,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+26,37532,631,15,1,0,0,4379.45,2510.21,203.382,2.77324,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+27,37532,631,15,1,0,0,4377.98,2511.69,203.384,0.0361331,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+28,37532,631,15,1,0,0,4376.07,2508.98,203.384,0.95662,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+29,37532,631,15,1,0,0,4371.45,2514.37,203.383,3.35915,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+30,37532,631,15,1,0,0,4377.53,2519.25,203.384,5.76561,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+31,37532,631,15,1,0,0,4385.71,2530.45,203.387,3.85552,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+32,37532,631,15,1,0,0,4374.05,2457.47,203.382,4.73831,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+33,37532,631,15,1,0,0,4373.95,2461.52,203.382,3.47539,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+34,37532,631,15,1,0,0,4375.93,2455.54,203.383,4.69512,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+35,37532,631,15,1,0,0,4383.62,2529.27,203.386,5.19698,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+36,37532,631,15,1,0,0,4389.28,2528.94,203.386,6.22428,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+37,37532,631,15,1,0,0,4380.05,2456.41,203.382,0.00314776,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+38,37532,631,15,1,0,0,4376.26,2462.41,203.382,2.58318,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+39,37532,631,15,1,0,0,4378.17,2462.99,203.381,4.13827,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+40,37532,631,15,1,0,0,4383.05,2523.33,203.387,4.35504,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+41,37532,631,15,1,0,0,4372.52,2452.47,203.384,3.70002,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+42,37532,631,15,1,0,0,4381.59,2533.12,203.386,3.60734,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+43,37532,631,15,1,0,0,4386.49,2535.52,203.386,3.07248,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+44,37532,631,15,1,0,0,4385.64,2512.62,203.384,4.82235,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+45,37532,631,15,1,0,0,4373.77,2438.67,203.386,4.50819,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+46,37532,631,15,1,0,0,4370.54,2441.32,203.386,2.44731,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+47,37532,631,15,1,0,0,4376.09,2442.12,203.386,0.133524,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+48,37532,631,15,1,0,0,4379.22,2439.67,203.386,5.39491,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+49,37532,631,15,1,0,0,4380.51,2434.97,203.387,4.65585,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+50,37532,631,15,1,0,0,4382.9,2439.76,203.387,1.10506,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+51,37532,631,15,1,0,0,4381.45,2444.52,203.386,3.39057,7200,0,0,126000,3994,0,0,0,0,0), -- Frostwing Whelp +(@GUID+52,38125,631,15,1,0,0,4369.75,2606.94,351.101,6.24627,7200,0,0,567000,3994,0,0,0,0,0), -- Ymirjar Deathbringer +(@GUID+53,38125,631,15,1,0,0,4340.83,2572.01,351.101,3.14394,7200,0,0,567000,3994,0,0,0,0,0), -- Ymirjar Deathbringer +(@GUID+54,38154,631,15,1,0,0,4360.11,2644.49,351.1,1.58808,7200,0,0,315000,0,0,0,0,0,0), -- Warhawk +(@GUID+55,38154,631,15,1,0,0,4355.22,2644.43,351.1,1.58415,7200,0,0,315000,0,0,0,0,0,0), -- Warhawk +(@GUID+56,38154,631,15,1,0,0,4359.36,2587.74,351.101,1.64776,7200,0,0,315000,0,0,0,0,0,0), -- Warhawk +(@GUID+57,38154,631,15,1,0,0,4354.53,2587.01,351.101,1.64383,7200,0,0,315000,0,0,0,0,0,0), -- Warhawk +(@GUID+58,38229,631,15,1,2177,0,4358.06,2608.39,351.184,2.86266,604800,5,0,13,0,0,1,0,0,0), -- Frozen Insect +(@GUID+59,38229,631,15,1,9829,0,4352.01,2664.59,350.18,6.12231,604800,0,0,13,0,0,0,0,0,0), -- Frozen Insect +(@GUID+60,38229,631,15,1,2177,0,4356.72,2408.48,358.432,4.04586,604800,0,0,13,0,0,0,0,0,0), -- Frozen Insect +(@GUID+61,38229,631,15,1,7511,0,4359.53,2656.51,351.101,0.198085,604800,0,0,13,0,0,0,0,0,0), -- Frozen Insect +(@GUID+62,38229,631,15,1,7511,0,4351.09,2488.49,358.441,1.93736,604800,0,0,13,0,0,0,0,0,0), -- Frozen Insect +(@GUID+63,38229,631,15,1,2177,0,4356.68,2525.39,358.432,1.69568,604800,0,0,13,0,0,0,0,0,0), -- Frozen Insect +(@GUID+64,38229,631,15,1,2177,0,4352.72,2610.13,351.101,2.82663,604800,5,0,13,0,0,1,0,0,0); -- Frozen Insect diff --git a/sql/old/3.3.5a/2011_02_04_0_world_creature_questrelation.sql b/sql/old/3.3.5a/2011_02_04_0_world_creature_questrelation.sql new file mode 100644 index 00000000000..b00304dc6eb --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_creature_questrelation.sql @@ -0,0 +1,2 @@ +-- Fix starting NPC for quest "Scrying Goggles? No Problem!" +DELETE FROM `creature_questrelation` WHERE `quest`=8578; -- Delete existing incorrect start point diff --git a/sql/old/3.3.5a/2011_02_04_0_world_creature_template.sql b/sql/old/3.3.5a/2011_02_04_0_world_creature_template.sql new file mode 100644 index 00000000000..6a90ac98761 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_creature_template.sql @@ -0,0 +1,2 @@ +-- Remove XP at kill from Flesh Eating Worm +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|64 WHERE `entry`=2462; diff --git a/sql/old/3.3.5a/2011_02_04_0_world_game_event.sql b/sql/old/3.3.5a/2011_02_04_0_world_game_event.sql new file mode 100644 index 00000000000..1e84cce9883 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_game_event.sql @@ -0,0 +1,15 @@ +-- Update start date of game event for 2011 +-- Based on retail IG calendar +UPDATE `game_event` SET `start_time` = '2011-06-21 00:01:00' WHERE `entry`=1; -- Midsummer Fire Festival +UPDATE `game_event` SET `start_time` = '2011-12-15 06:00:00' WHERE `entry`=2; -- Winter Veil +UPDATE `game_event` SET `start_time` = '2011-02-06 00:01:00' WHERE `entry`=3; -- Darkmoon Faire - Terrokkar Forest +UPDATE `game_event` SET `start_time` = '2011-03-06 00:01:00' WHERE `entry`=4; -- Darkmoon Faire - Elwynn Forest +UPDATE `game_event` SET `start_time` = '2011-01-02 00:01:00' WHERE `entry`=5; -- Darkmoon Faire - Mulgore +UPDATE `game_event` SET `start_time` = '2011-01-23 00:01:00' WHERE `entry`=7; -- Lunar Festival +UPDATE `game_event` SET `start_time` = '2011-02-06 00:01:00' WHERE `entry`=8; -- Love is in the Air +UPDATE `game_event` SET `start_time` = '2011-04-24 00:01:00' WHERE `entry`=9; -- Noblegarden +UPDATE `game_event` SET `start_time` = '2011-05-01 00:01:00' WHERE `entry`=10; -- Childrens Week +UPDATE `game_event` SET `start_time` = '2011-09-06 00:01:00' WHERE `entry`=11; -- Harvest Festival +UPDATE `game_event` SET `start_time` = '2011-10-18 01:00:00' WHERE `entry`=12; -- Hallow's End +UPDATE `game_event` SET `start_time` = '2011-03-03 00:01:00' WHERE `entry`=23; -- Darkmoon Faire Building - Elwynn Forest +UPDATE `game_event` SET `start_time` = '2011-09-19 00:01:00' WHERE `entry`=52; -- Pirates Day diff --git a/sql/old/3.3.5a/2011_02_04_0_world_gameobject_questrelation.sql b/sql/old/3.3.5a/2011_02_04_0_world_gameobject_questrelation.sql new file mode 100644 index 00000000000..480d7f63295 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_gameobject_questrelation.sql @@ -0,0 +1,3 @@ +-- Fix starting NPC for quest "Scrying Goggles? No Problem!" +DELETE FROM `gameobject_questrelation` WHERE `quest`=8578; -- Delete any existing values for this quest +INSERT INTO `gameobject_questrelation` (`id`,`quest`) VALUES (180642,8578); -- Insert correct values for start point of quest diff --git a/sql/old/3.3.5a/2011_02_04_0_world_instance_pit_of_saron.sql b/sql/old/3.3.5a/2011_02_04_0_world_instance_pit_of_saron.sql new file mode 100644 index 00000000000..8e4584618ee --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_instance_pit_of_saron.sql @@ -0,0 +1,129 @@ +DELETE FROM `creature` WHERE `id` IN (36610,36731,36477,36658,31260); -- Delete Temp Trigger Spawns + +-- DB Data (souce: SNIFF) +UPDATE `creature_template` SET `exp`=2,`minlevel`=80,`maxlevel`=80,`unit_flags`=0x02008000,`faction_A`=14,`faction_H`=14,`flags_extra`=`flags_extra`|0x80 WHERE `entry`=37670; -- Frostblade +UPDATE `creature_template` SET `exp`=2,`minlevel`=80,`maxlevel`=80,`flags_extra`=`flags_extra`|0x80 WHERE `entry`=36610; -- Exploding Orb +UPDATE `creature_template` SET `exp`=2,`minlevel`=80,`maxlevel`=80,`scale`=1.1,`flags_extra`=`flags_extra`|0x80 WHERE `entry`=36731; -- Icy Blast +UPDATE `creature_template` SET `speed_run`=1.857143,`speed_walk`=3.2,`unit_flags`=0x00000040,`faction_A`=14,`faction_H`=14,`baseattacktime`=2000,`equipment_id`=1872 WHERE `entry` IN (36658,36938); -- Scourgelord Tyrannus +UPDATE `creature_template` SET `speed_run`=1.5873,`speed_walk`=2,`unit_flags`=0x00000040 WHERE `entry`=36661; -- Rimefang +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|0x80 WHERE `entry`=36495; -- Forgemaster Putridus Invisible Stalker +UPDATE `creature_template` SET `VehicleId`=560 WHERE `entry`=37626; -- Iceborn Protodrake (1) + +-- SAI for Plagueborn Horror +SET @ENTRY := 36879; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,5000,5000,10000,10000,11,69581,0,0,0,0,0,5,0,0,0,0,0,0,0, 'Cast Pustulant Flesh on Random Target (Non-Heroic)'), +(@ENTRY,0,1,0,0,0,100,4,5000,5000,10000,10000,11,70273,0,0,0,0,0,5,0,0,0,0,0,0,0, 'Cast Pustulant Flesh on Random Target (Heroic)'), +(@ENTRY,0,2,0,0,0,100,6,8000,8000,8000,8000,11,70274,0,0,0,0,0,5,0,0,0,0,0,0,0, 'Cast Toxic Waste on Random Target'), +(@ENTRY,0,3,0,2,0,100,6,15,15,0,0,11,69582,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Cast Blight Bomb self at 15pct Health'); + +-- SAI for Hungering Ghoul +SET @ENTRY := 37711; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,6,4000,6000,8000,12000,11,70393,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Devour Flesh on current Target'); + +-- SAI for Deathwhisper Shadowcaster +SET @ENTRY := 37712; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,100,100,3000,3000,11,70386,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Shadow Bolt on current Target (Non-Heroic)'), +(@ENTRY,0,1,0,0,0,100,4,100,100,3000,3000,11,70387,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Shadow Bolt on current Target (Heroic)'); + +-- SAI for Deathwhisper Torturer +SET @ENTRY := 37713; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,6,10000,10000,10000,10000,11,70392,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Black Brand on current Target'), +(@ENTRY,0,1,0,0,0,100,6,6000,6000,13000,13000,11,70391,0,0,0,0,0,5,0,0,0,0,0,0,0, 'Cast Curse of Agony on Random Target'); + +-- SAI for Ymirjar Wrathbringer +SET @ENTRY := 36840; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,7000,7000,8000,8000,11,69603,0,0,0,0,0,5,0,0,0,0,0,0,0, 'Cast Blight on Random Target (Non-Heroic)'), +(@ENTRY,0,1,0,0,0,100,4,7000,7000,8000,8000,11,70285,0,0,0,0,0,5,0,0,0,0,0,0,0, 'Cast Blight on Random Target (Heroic)'); + +-- SAI for Stonespine Gargoyle +SET @ENTRY := 36896; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,1000,1000,5000,5000,11,69520,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Gargoyle Strike on current Target (Non-Heroic)'), +(@ENTRY,0,1,0,0,0,100,4,1000,1000,5000,5000,11,70275,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Gargoyle Strike on current Target (Heroic)'), +(@ENTRY,0,2,0,2,0,100,6,10,10,0,0,11,69575,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Cast Stoneform self at 10pct Health'); + +-- SAI for Wrathbone Sorcerer +SET @ENTRY := 37728; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,3000,3000,8000,8000,11,75330,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Shadow Bolt on current Target (Non-Heroic)'), +(@ENTRY,0,1,0,0,0,100,4,3000,3000,8000,8000,11,75331,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Shadow Bolt on current Target (Heroic)'); + +-- SAI for Wrathbone Coldwraith +SET @ENTRY := 36842; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,100,100,3000,3000,11,69573,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Frostbolt on current Target (Non-Heroic)'), +(@ENTRY,0,1,0,0,0,100,4,100,100,3000,3000,11,70277,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Frostbolt on current Target (Heroic)'), +(@ENTRY,0,2,0,0,0,100,2,9000,9000,15000,15000,11,69574,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Freezing Circle on current Target (Non-Heroic)'), +(@ENTRY,0,3,0,0,0,100,4,9000,9000,15000,15000,11,70276,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Freezing Circle on current Target (Heroic)'); + +-- SAI for Deathwhisper Necrolyte +SET @ENTRY := 36788; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,100,100,3000,3000,11,69577,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Shadow Bolt on current Target (Non-Heroic)'), +(@ENTRY,0,1,0,0,0,100,4,100,100,3000,3000,11,70270,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Shadow Bolt on current Target (Heroic)'), +(@ENTRY,0,2,0,0,0,100,2,9000,9000,24000,24000,11,69578,0,0,0,0,0,5,0,0,0,0,0,0,0, 'Cast Conversion Beam on Random Target (Non-Heroic)'), +(@ENTRY,0,3,0,0,0,100,4,9000,9000,24000,24000,11,70269,0,0,0,0,0,5,0,0,0,0,0,0,0, 'Cast Conversion Beam on Random Target (Heroic)'); + +-- SAI for Fallen Warrior +SET @ENTRY := 36841; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,6,5000,5000,7000,8000,11,69579,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Arcing Slice to current Target'), +(@ENTRY,0,1,0,0,0,100,6,15000,15000,22000,22000,11,61044,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Cast Demoralizing Shout'), +(@ENTRY,0,2,0,0,0,100,6,22000,22000,25000,25000,11,69580,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Cast Shield Block'); + +-- SAI for Fallen Warrior 2 +SET @ENTRY := 38487; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,6,5000,5000,7000,8000,11,69579,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Arcing Slice to current Target'), +(@ENTRY,0,1,0,0,0,100,6,15000,15000,22000,22000,11,61044,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Cast Demoralizing Shout'), +(@ENTRY,0,2,0,0,0,100,6,22000,22000,25000,25000,11,69580,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Cast Shield Block'); + +-- SAI for Ymirjar Skycaller +SET @ENTRY := 31260; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,6,4000,4000,8000,8000,11,70292,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Glacial Strike on current Target'), +(@ENTRY,0,1,0,2,0,100,6,50,50,0,0,11,70291,0,0,0,0,0,5,0,0,0,0,0,0,0, 'Cast Frostblade on Random Target at 50pct Health'); + +-- SAI for Frostblade +SET @ENTRY := 37670; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,6,1000,1000,0,0,11,70306,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Cast Frostblade self'); + +-- SAI for Ymirjar Deathbringer +SET @ENTRY := 36892; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`="" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,2,4000,4000,8000,8000,11,69528,0,0,0,0,0,5,0,0,0,0,0,0,0, 'Cast Empowered Shadow Bolt on Random Target (Non-Heroic)'), +(@ENTRY,0,1,0,0,0,100,4,4000,4000,8000,8000,11,70281,0,0,0,0,0,5,0,0,0,0,0,0,0, 'Cast Empowered Shadow Bolt on Random Target (Heroic)'); diff --git a/sql/old/3.3.5a/2011_02_04_0_world_item_loot_template.sql b/sql/old/3.3.5a/2011_02_04_0_world_item_loot_template.sql new file mode 100644 index 00000000000..aac759b58ed --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_item_loot_template.sql @@ -0,0 +1,7 @@ +-- Derrok's Wand Case +DELETE FROM `item_loot_template` WHERE `entry`=30650; +INSERT INTO `item_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(30650,30651,100,1,1,1,1), -- Dertrok's First Wand +(30650,30652,100,1,2,1,1), -- Dertrok's Second Wand +(30650,30653,100,1,3,1,1), -- Dertrok's Third Wand +(30650,30654,100,1,4,1,1); -- Dertrok's Fourth Wand diff --git a/sql/old/3.3.5a/2011_02_04_0_world_mail_loot_template.sql b/sql/old/3.3.5a/2011_02_04_0_world_mail_loot_template.sql new file mode 100644 index 00000000000..2e07a483473 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_mail_loot_template.sql @@ -0,0 +1,34 @@ +-- Reward from Treats for Greatfather Winter (horde) +SET @MAIL:=118; -- Set in DBC +UPDATE `quest_template` SET `RewMailTemplateId`=@MAIL, `RewMailDelaySecs`=86400 WHERE `entry` IN (6962); -- Set mail delivery +DELETE FROM `mail_loot_template` WHERE `entry`=@MAIL; +INSERT INTO `mail_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(@MAIL,17685,100,1,0,1,1); -- Attach item to mail + +-- Reward from Treats for Greatfather Winter (alliance) +SET @MAIL:=102; -- Set in DBC +UPDATE `quest_template` SET `RewMailTemplateId`=@MAIL, `RewMailDelaySecs`=86400 WHERE `entry` IN (7025); -- Set mail delivery +DELETE FROM `mail_loot_template` WHERE `entry`=@MAIL; +INSERT INTO `mail_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(@MAIL,17685,100,1,0,1,1); -- Attach item to mail + +-- Reward from Stolen Winter Veil Treats (alliance) +SET @MAIL:=117; -- Set in DBC +UPDATE `quest_template` SET `RewMailTemplateId`=@MAIL, `RewMailDelaySecs`=86400 WHERE `entry` IN (7042); -- Set mail delivery +DELETE FROM `mail_loot_template` WHERE `entry`=@MAIL; +INSERT INTO `mail_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(@MAIL,17712,100,1,0,1,1); -- Attach item to mail + +-- Reward from Metzen the Reindeer (alliance) +SET @MAIL:=161; -- Set in DBC +UPDATE `quest_template` SET `RewMailTemplateId`=@MAIL, `RewMailDelaySecs`=86400 WHERE `entry` IN (8762); -- Set mail delivery +DELETE FROM `mail_loot_template` WHERE `entry`=@MAIL; +INSERT INTO `mail_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(@MAIL,21216,100,1,0,1,1); -- Attach item to mail + +-- Reward from Metzen the Reindeer (horde) +SET @MAIL:=122; -- Set in DBC +UPDATE `quest_template` SET `RewMailTemplateId`=@MAIL, `RewMailDelaySecs`=86400 WHERE `entry` IN (8746); -- Set mail delivery +DELETE FROM `mail_loot_template` WHERE `entry`=@MAIL; +INSERT INTO `mail_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(@MAIL,21216,100,1,0,1,1); -- Attach item to mail }}} diff --git a/sql/old/3.3.5a/2011_02_04_0_world_quest_template.sql b/sql/old/3.3.5a/2011_02_04_0_world_quest_template.sql new file mode 100644 index 00000000000..bff1b9a6f2a --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_quest_template.sql @@ -0,0 +1,2 @@ +-- Fix missing Previous Quest Requirement for They Grow Up So Fast +UPDATE `quest_template` SET `prevquestid`=13887 WHERE `entry`=13906; diff --git a/sql/old/3.3.5a/2011_02_04_0_world_sai.sql b/sql/old/3.3.5a/2011_02_04_0_world_sai.sql new file mode 100644 index 00000000000..559774e0a04 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_sai.sql @@ -0,0 +1,5 @@ +-- Heldgarr Steelbeard "Valiance Keep" SAI (tested) +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=25281; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (25281); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(25281,0,0,0,1,0,100,0,6000,6000,6000,6000,11,45425,2,0,0,0,0,10,103993,24921,0,0,0,0,0,'Fire at target every 6 sec'); diff --git a/sql/old/3.3.5a/2011_02_04_0_world_spell_script_names.sql b/sql/old/3.3.5a/2011_02_04_0_world_spell_script_names.sql new file mode 100644 index 00000000000..645be0e6083 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_spell_script_names.sql @@ -0,0 +1,17 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_dungeon_credit'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(58630,'spell_gen_dungeon_credit'), +(59046,'spell_gen_dungeon_credit'), +(59450,'spell_gen_dungeon_credit'), +(61863,'spell_gen_dungeon_credit'), +(64899,'spell_gen_dungeon_credit'), +(64985,'spell_gen_dungeon_credit'), +(65074,'spell_gen_dungeon_credit'), +(65195,'spell_gen_dungeon_credit'), +(68184,'spell_gen_dungeon_credit'), +(68572,'spell_gen_dungeon_credit'), +(68574,'spell_gen_dungeon_credit'), +(68663,'spell_gen_dungeon_credit'), +(72706,'spell_gen_dungeon_credit'), +(72830,'spell_gen_dungeon_credit'), +(72959,'spell_gen_dungeon_credit'); diff --git a/sql/old/3.3.5a/2011_02_04_0_world_spell_target_position.sql b/sql/old/3.3.5a/2011_02_04_0_world_spell_target_position.sql new file mode 100644 index 00000000000..ba4e4160dfa --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_0_world_spell_target_position.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_target_position` WHERE `id`=49305; +INSERT INTO `spell_target_position` VALUES +(49305,578,983.108,1054.513,359.967,3.354); diff --git a/sql/old/3.3.5a/2011_02_04_1_world_game_event.sql b/sql/old/3.3.5a/2011_02_04_1_world_game_event.sql new file mode 100644 index 00000000000..0d668a4e429 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_1_world_game_event.sql @@ -0,0 +1,2 @@ +-- Winter Veil: Gifts had wrong duration. It should be 8 days and 3 hours in minutes (25 Dec -> 2 Jan) +UPDATE `game_event` SET `length`=11700 WHERE `entry`=54; diff --git a/sql/old/3.3.5a/2011_02_04_1_world_quest_template.sql b/sql/old/3.3.5a/2011_02_04_1_world_quest_template.sql new file mode 100644 index 00000000000..3ace7e379dc --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_1_world_quest_template.sql @@ -0,0 +1,2 @@ +-- Update Return to Angrathar (A/H) prevquestid. Requires On Ruby Wings +UPDATE `quest_template` SET `PrevQuestId`=12498 WHERE `entry` IN (12499,12500); diff --git a/sql/old/3.3.5a/2011_02_04_1_world_sai.sql b/sql/old/3.3.5a/2011_02_04_1_world_sai.sql new file mode 100644 index 00000000000..9e968dcedfa --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_1_world_sai.sql @@ -0,0 +1,5 @@ +-- Ferlynn Windsong "Valiance Keep" SAI (tested) +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=25282; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (25282); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(25282,0,0,0,1,0,100,0,6000,6000,6000,6000,11,42611,2,0,0,0,0,10,103994,24921,0,0,0,0,0,'Fire at target every 6 sec'); diff --git a/sql/old/3.3.5a/2011_02_04_2_world_quest_template.sql b/sql/old/3.3.5a/2011_02_04_2_world_quest_template.sql new file mode 100644 index 00000000000..0d153bca7d0 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_2_world_quest_template.sql @@ -0,0 +1,2 @@ +-- Correct PreQuestId for the quest The Amphitheater of Anguish: Tuskarrmagedon +UPDATE `quest_template` SET `PrevQuestId`=12934 WHERE `entry`=12935; diff --git a/sql/old/3.3.5a/2011_02_04_2_world_sai.sql b/sql/old/3.3.5a/2011_02_04_2_world_sai.sql new file mode 100644 index 00000000000..3bc95ce04e6 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_2_world_sai.sql @@ -0,0 +1,12 @@ +-- Argent Stand Defender "guid 107662 throwing mace at target" SAI (Tested) +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=28801; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-107662); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(-107662,0,0,0,1,0,100,0,12000,18000,12000,18000,11,54423,2,0,0,0,0,10,117888,29416,0,0,0,0,0,'Fire at target every 12-18 sec'); +-- Spell condition for "Hammer of the Righteous" +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=54423; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,0,54423,0,18,1,29416,0,0,'','Spell 54423 targets Argent Stand Dummy'); +-- Fix Argent Stand Dummy InhabitType and movement +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=29416; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0 WHERE `id`=29416; diff --git a/sql/old/3.3.5a/2011_02_04_3_world_quest_template.sql b/sql/old/3.3.5a/2011_02_04_3_world_quest_template.sql new file mode 100644 index 00000000000..015633c1214 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_3_world_quest_template.sql @@ -0,0 +1,3 @@ +-- Fix nonexisting required races for Hungry Hungry Hatching +UPDATE `quest_template` SET `RequiredRaces`=`RequiredRaces`|512|2 WHERE `entry`=13889; -- Orc and Blood Elf (2+512) +UPDATE `quest_template` SET `RequiredRaces`=`RequiredRaces`|128|32|16 WHERE `entry`=13915; -- Undead, Tauren, Troll (16+32+128) diff --git a/sql/old/3.3.5a/2011_02_04_3_world_sai.sql b/sql/old/3.3.5a/2011_02_04_3_world_sai.sql new file mode 100644 index 00000000000..be51bfd4c70 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_3_world_sai.sql @@ -0,0 +1,28 @@ +-- Honor Hold Archer fixup (tested) +-- Console no longer spamming waypoint script errors in Honor Hold +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=16896; +-- Honor Hold Archer "guid 58449 shoot at Honor Hold Target Dummy Right" SAI "Tested" +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-58449); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(-58449,0,0,0,1,0,100,0,6000,6000,6000,6000,11,29120,2,0,0,0,0,10,58457,16898,0,0,0,0,0,'Fire at target every 6 sec'); +-- Honor Hold Archer "guid 58450 shoot at Honor Hold Target Dummy Left" SAI "Tested" +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-58450); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(-58450,0,0,0,1,0,100,0,4000,4000,6000,6000,11,29120,2,0,0,0,0,10,58461,16899,0,0,0,0,0,'Fire at target every 6 sec'); +-- Honor Hold Archer "guid 58451 shoot at Honor Hold Target Dummy Middle" SAI "Tested" +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-58451); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(-58451,0,0,0,1,0,100,0,2000,2000,6000,6000,11,29120,2,0,0,0,0,10,58455,16897,0,0,0,0,0,'Fire at target every 6 sec'); +-- Fix Honor Hold Target Dummies InhabitType +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (16897,16898,16899); +-- Remove path data and scripts from Honor Hold Archers +DELETE FROM `waypoint_data` WHERE `id` IN (584490,584500,584510); +DELETE FROM `waypoint_scripts` WHERE `id` BETWEEN 52 AND 65; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0 WHERE `guid` IN (58449,58450,58451); +UPDATE `creature_addon` SET `path_id`=0 WHERE `guid` IN (58449,58450,58451); +-- Fix Spell condition for Spell 29120 to target either 16897,16898,16899 +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=29120; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,0,29120,1,18,1,16897,0,0,'','Spell 29120 targets Honor Hold Target Dummy Middle'), +(13,0,29120,1,18,1,16898,0,0,'','Spell 29120 targets Honor Hold Target Dummy Right'), +(13,0,29120,1,18,1,16899,0,0,'','Spell 29120 targets Honor Hold Target Dummy Left'); diff --git a/sql/old/3.3.5a/2011_02_04_4_world_quest_template.sql b/sql/old/3.3.5a/2011_02_04_4_world_quest_template.sql new file mode 100644 index 00000000000..240cb23c3c1 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_4_world_quest_template.sql @@ -0,0 +1,3 @@ +-- Fix nonexisting required races for Gorishi Grub +UPDATE `quest_template` SET `RequiredRaces`=`RequiredRaces`|512|2 WHERE `entry`=13903; -- Orc and Blood Elf (2+512) +UPDATE `quest_template` SET `RequiredRaces`=`RequiredRaces`|128|32|16 WHERE `entry`=13917; -- Undead, Tauren, Troll (16+32+128) diff --git a/sql/old/3.3.5a/2011_02_04_4_world_sai.sql b/sql/old/3.3.5a/2011_02_04_4_world_sai.sql new file mode 100644 index 00000000000..b6709bb4c52 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_04_4_world_sai.sql @@ -0,0 +1,37 @@ +-- Conversation between Highlord Tirion Fordring & The Ebon Watcher +-- SAI +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=30377; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (30377,3037700); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(30377,0,0,0,1,0,100,0,30000,60000,240000,240000,80,3037700,0,0,0,0,0,0,0,0,0,0,0,0,0,'Load script every 4 min ooc'), +(3037700,9,0,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,9,28179,0,10,0,0,0,0,'Highlord Tirion Fordring Say text 0'), +(3037700,9,1,0,0,0,100,0,6000,6000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'The Ebon Watcher Say text 0'), +(3037700,9,2,0,0,0,100,0,12000,12000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'The Ebon Watcher Say text 1'), +(3037700,9,3,0,0,0,100,0,12000,12000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'The Ebon Watcher Say text 2'), +(3037700,9,4,0,0,0,100,0,5000,5000,0,0,1,1,0,0,0,0,0,9,28179,0,10,0,0,0,0,'Highlord Tirion Fordring Say text 1'), +(3037700,9,5,0,0,0,100,0,6000,6000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,'The Ebon Watcher Say text 3'), +(3037700,9,6,0,0,0,100,0,9000,9000,0,0,1,2,0,0,0,0,0,9,28179,0,10,0,0,0,0,'Highlord Tirion Fordring Say text 2'), +(3037700,9,7,0,0,0,100,0,9000,9000,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0,'The Ebon Watcher Say text 4'), +(3037700,9,8,0,0,0,100,0,3000,3000,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0,'The Ebon Watcher Say text 5'), +(3037700,9,9,0,0,0,100,0,9000,9000,0,0,1,6,0,0,0,0,0,1,0,0,0,0,0,0,0,'The Ebon Watcher Say text 6'), +(3037700,9,10,0,0,0,100,0,7000,7000,0,0,1,7,0,0,0,0,0,1,0,0,0,0,0,0,0,'The Ebon Watcher Say text 7'), +(3037700,9,11,0,0,0,100,0,11000,11000,0,0,1,8,0,0,0,0,0,1,0,0,0,0,0,0,0,'The Ebon Watcher Say text 8'), +(3037700,9,12,0,0,0,100,0,12000,12000,0,0,1,3,0,0,0,0,0,9,28179,0,10,0,0,0,0,'Highlord Tirion Fordring Say text 3'), +(3037700,9,13,0,0,0,100,0,13000,13000,0,0,1,9,0,0,0,0,0,1,0,0,0,0,0,0,0,'The Ebon Watcher Say text 9'); +-- TEXT +DELETE FROM `creature_text` WHERE `entry` IN (28179,30377); +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES +(28179,0,0,'The Lich King reacted swiftly to the breach. Faster than I anticipated.',0,0,100,1,0,0,'Highlord Tirion Fordring'), +(28179,1,0,'What would you have me do, Darion?',0,0,100,6,0,0,'Highlord Tirion Fordring'), +(28179,2,0,'Choose your words wisely, death knight. You stand amidst the company of the devoted.',0,0,100,1,0,0,'Highlord Tirion Fordring'), +(28179,3,0,'We will do this with honor, Darion. We will not sink to the levels of the Scourge to be victorious. To do so would make us no better than the monster that we fight to destroy!',0,0,100,1,0,0,'Highlord Tirion Fordring'), +(30377,0,0,'You are dealing with a being that holds within it the consciousness of the most cunning, intelligent, and ruthless individuals to ever live.',0,0,100,1,0,0,'The Ebon Watcher'), +(30377,1,0,'The Lich King is unlike any foe that you have ever faced, Highlord. Though you bested him upon the holy ground of Light\'s Hope Chapel, you tread now upon his domain.',0,0,100,1,0,0,'The Ebon Watcher'), +(30377,2,0,'You cannot win. Not like this...',0,0,100,274,0,0,'The Ebon Watcher'), +(30377,3,0,'Nothing. There is nothing that you can do while the Light binds you. It controls you wholly, shackling you to the ground with its virtues.',0,0,100,274,0,0,'The Ebon Watcher'), +(30377,4,0,'%s shakes his head.','2',0,100,0,0,0,'The Ebon Watcher'), +(30377,5,0,'Look upon the field, Highlord. The Lich King has halted your advance completely and won the upper hand!',0,0,100,25,0,0,'The Ebon Watcher'), +(30377,6,0,'The breach you created was sealed with Nerubian webbing almost as quickly as it was opened.',0,0,100,1,0,0,'The Ebon Watcher'), +(30377,7,0,'Your soldiers are being used as living shields to stave off artillery fire in the Valley of Echoes, allowing the forces of the Lich King to assault your base without impediment.',0,0,100,1,0,0,'The Ebon Watcher'), +(30377,8,0,'The Lich King knows your boundaries, Highlord. He knows that you will not fire on your own men. Do you not understand? He has no boundaries. No rules to abide.',0,0,100,1,0,0,'The Ebon Watcher'), +(30377,9,0,'Then you have lost, Highlord.',0,0,100,1,0,0,'The Ebon Watcher'); diff --git a/sql/old/3.3.5a/2011_02_05_0_world_sai.sql b/sql/old/3.3.5a/2011_02_05_0_world_sai.sql new file mode 100644 index 00000000000..f68f044e2f1 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_05_0_world_sai.sql @@ -0,0 +1,109 @@ +SET @GUID = 208787; -- creature.guid (need 2) + +SET @Diver=31689; -- Gnome Diver +UPDATE `creature_template` SET `AIName`='SmartAI',`vehicleid`=0,`InhabitType`=4 WHERE `entry`=@Diver; -- Gnome Diver +UPDATE `creature_template` SET `InhabitType`=7 WHERE `entry` IN (31719,31768,31769); -- Cosmetic Frenzy, Stabled Hunter Pet -- flying +-- Model data +UPDATE `creature_model_info` SET `bounding_radius`=0.3519,`combat_reach`=1,`gender`=0 WHERE `modelid`=27657; -- Gnome Diver +UPDATE `creature_model_info` SET `bounding_radius`=0.09,`combat_reach`=1,`gender`=2 WHERE `modelid`=23514; -- Stabled Hunter Pet +UPDATE `creature_model_info` SET `bounding_radius`=0.245,`combat_reach`=1,`gender`=2 WHERE `modelid`=23513; -- Stabled Hunter Pet +UPDATE `creature_model_info` SET `bounding_radius`=0.35,`combat_reach`=0,`gender`=2 WHERE `modelid`=2955; -- Cosmetic Albino Snake +UPDATE `creature_model_info` SET `bounding_radius`=0.374,`combat_reach`=0,`gender`=2 WHERE `modelid`=27718; -- Cosmetic Smolderweb Hatchling +UPDATE `creature_model_info` SET `bounding_radius`=0.35,`combat_reach`=0,`gender`=2 WHERE `modelid`=2954; -- Cosmetic Ribbon Snake +UPDATE `creature_model_info` SET `bounding_radius`=0.25,`combat_reach`=0,`gender`=2 WHERE `modelid`=5555; -- Cosmetic Cat Set 2/2 +UPDATE `creature_model_info` SET `bounding_radius`=0.35,`combat_reach`=0,`gender`=2 WHERE `modelid`=1206; -- Cosmetic Black Kingsnake +UPDATE `creature_model_info` SET `bounding_radius`=0.3519,`combat_reach`=1,`gender`=1 WHERE `modelid`=25791; -- Breanni +UPDATE `creature_model_info` SET `bounding_radius`=0.35,`combat_reach`=0,`gender`=2 WHERE `modelid`=2957; -- Cosmetic Brown Snake +UPDATE `creature_model_info` SET `bounding_radius`=0.15,`combat_reach`=1,`gender`=2 WHERE `modelid`=3233; -- Cosmetic Cockroach +UPDATE `creature_model_info` SET `bounding_radius`=0.3,`combat_reach`=0,`gender`=2 WHERE `modelid`=27719; -- Cosmetic Worg Pup +UPDATE `creature_model_info` SET `bounding_radius`=0,`combat_reach`=1,`gender`=2 WHERE `modelid`=1141; -- Cosmetic Rat +UPDATE `creature_model_info` SET `bounding_radius`=0.6,`combat_reach`=0,`gender`=2 WHERE `modelid`=27682; -- Cosmetic Pig +UPDATE `creature_model_info` SET `bounding_radius`=0.25,`combat_reach`=0,`gender`=2 WHERE `modelid`=5586; -- Cosmetic Cat Set 1/2 +UPDATE `creature_model_info` SET `bounding_radius`=0.2,`combat_reach`=0,`gender`=2 WHERE `modelid`=27881; -- Cosmetic Turtle +UPDATE `creature_model_info` SET `bounding_radius`=0.2749995,`combat_reach`=0,`gender`=2 WHERE `modelid`=23519; -- Stabled Hunter Pet +UPDATE `creature_model_info` SET `bounding_radius`=0.28,`combat_reach`=0,`gender`=2 WHERE `modelid`=27690; -- Stabled Hunter Pet +UPDATE `creature_model_info` SET `bounding_radius`=0.45,`combat_reach`=1,`gender`=2 WHERE `modelid`=4636; -- Stabled Hunter Pet +UPDATE `creature_model_info` SET `bounding_radius`=1.122,`combat_reach`=0,`gender`=2 WHERE `modelid`=2540; -- Stabled Hunter Pet +UPDATE `creature_model_info` SET `bounding_radius`=0.383,`combat_reach`=1,`gender`=1 WHERE `modelid`=25607; -- Tassia Whisperglen + +-- Addon data +DELETE FROM `creature_template_addon` WHERE `entry` IN (@Diver,28951,28690,31719,31742,31709,31795,31714,31729,31710,31711,31733,31796,31732,31735,31728,31740,31741,31755,31756,31757,31758,31768,31769); +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(@Diver,0,33554432,1,0, '59562 0'), -- Gnome Diver +(28951,0,0,257,0, '60913 0 61354 0'), -- Breanni +(28690,0,0,257,0, NULL), -- Tassia Whisperglen +(31719,0,0,1,0, NULL), -- Cosmetic Frenzy +(31742,0,0,1,0, NULL), -- Cosmetic Prairie Dog +(31709,0,0,1,0, NULL), -- Cosmetic Albino Snake +(31795,0,0,1,0, NULL), -- Cosmetic Smolderweb Hatchling +(31714,0,0,1,0, NULL), -- Cosmetic Ribbon Snake +(31729,0,0,1,0, NULL), -- Cosmetic Cat Set 2/2 +(31710,0,0,1,0, NULL), -- Cosmetic Black Kingsnake +(31711,0,0,1,0, NULL), -- Cosmetic Brown Snake +(31733,0,0,1,0, NULL), -- Cosmetic Cockroach +(31796,0,0,1,0, NULL), -- Cosmetic Worg Pup +(31732,0,0,1,0, NULL), -- Cosmetic Rat +(31735,0,0,1,0, NULL), -- Cosmetic Pig +(31728,0,0,1,0, NULL), -- Cosmetic Cat Set 1/2 +(31740,0,0,1,0, NULL), -- Cosmetic Turtle +(31741,0,0,1,0, NULL), -- Cosmetic Rabbit +(31755,0,0,1,0, NULL), -- Stabled Hunter Pet +(31756,0,0,1,0, NULL), -- Stabled Hunter Pet +(31757,0,0,1,0, NULL), -- Stabled Hunter Pet +(31758,0,0,1,0, NULL), -- Stabled Hunter Pet +(31768,0,0,1,0, NULL), -- Stabled Hunter Pet +(31769,0,0,1,0, NULL); -- Stabled Hunter Pet + +-- Random movement for two of the Stabled Hunter Pets +UPDATE `creature` SET `spawndist`=5, `MovementType`=1 WHERE `guid` IN (97556,97653); + +-- Aura used by all Cosmetic* npcs in Dalaran +-- DELETE FROM `spell_dbc` WHERE `Id`=28782; +-- INSERT INTO `spell_dbc` (`Id`,`Comment`) VALUES (28782, 'Dalaran Cosmetic Aura - Unknown effect'); + +-- SAI/Gnome Diver: reply to emotes +DELETE FROM `smart_scripts` WHERE `entryorguid`=@Diver AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`)VALUES +(@Diver,0,0,0,22,0,100,0,78,5000,5000,0,5,66,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Gnome Diver: Salute - Salute'), +(@Diver,0,1,0,22,0,100,0,21,5000,5000,0,5,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Gnome Diver: Cheer - Bow'), +(@Diver,0,2,0,22,0,100,0,101,5000,5000,0,5,3,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Gnome Diver: Wave - Wave'), +(@Diver,0,3,0,22,0,100,0,34,5000,5000,0,5,94,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Gnome Diver: Dance - Dance'), +(@Diver,0,4,0,22,0,100,0,328,5000,5000,0,5,11,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Gnome Diver: Flirt - Laugh'), +(@Diver,0,5,0,22,0,100,0,58,5000,5000,0,5,23,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Gnome Diver: Kiss - Flex'), +(@Diver,0,6,0,22,0,100,0,77,5000,5000,0,5,14,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Gnome Diver: Rude - Rude'); + +-- Waypoints for flying birds +DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (31768,31769)); +DELETE FROM `creature` WHERE `id` IN (31768,31769); +INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES +(@GUID+0,31768,571,1,1,0,0,5864.76025,561.5035,656.350159,3.38593864,120,0,0,1,0,0,2,0,0,0), +(@GUID+1,31769,571,1,1,0,0,5871.1377,556.659363,660.738953,1.44698894,120,0,0,1,0,0,2,0,0,0); +INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES +(@GUID+0,(@GUID+0)*10), +(@GUID+1,(@GUID+1)*10); +DELETE FROM `waypoint_data` WHERE `id` IN ((@GUID+0)*10,(@GUID+1)*10); +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +((@GUID+0)*10,00,5865.73,561.7454,656.3502), +((@GUID+0)*10,01,5864.76,561.5035,656.3502), +((@GUID+0)*10,02,5865.858,545.6048,657.8221), +((@GUID+0)*10,03,5856.59,546.2563,657.8221), +((@GUID+0)*10,04,5851.967,553.7063,657.8221), +((@GUID+0)*10,05,5848.848,559.3509,657.8221), +((@GUID+0)*10,06,5855.463,567.5033,657.8221), +((@GUID+0)*10,07,5861.43,566.0272,657.8221), +((@GUID+0)*10,08,5870.177,562.2965,657.8221), +((@GUID+0)*10,09,5872.478,553.6407,657.8221), +((@GUID+0)*10,10,5864.64,545.9483,657.8221), +((@GUID+0)*10,11,5856.267,546.3598,657.8221), +((@GUID+0)*10,12,5851.878,553.7315,657.8221), +((@GUID+0)*10,13,5848.888,559.2279,657.8221), +((@GUID+0)*10,14,5848.888,559.2279,657.8221), +((@GUID+1)*10,0,5856.941,550.4024,656.2946), +((@GUID+1)*10,1,5856.993,551.4011,656.2946), +((@GUID+1)*10,2,5852.679,558.0845,660.739), +((@GUID+1)*10,3,5852.628,548.4319,660.739), +((@GUID+1)*10,4,5862.95,547.2537,660.739), +((@GUID+1)*10,5,5871.105,556.4464,660.739), +((@GUID+1)*10,6,5866.302,565.8504,660.739), +((@GUID+1)*10,7,5857.606,565.6177,660.739), +((@GUID+1)*10,8,5857.606,565.6177,660.739); diff --git a/sql/old/3.3.5a/2011_02_05_1_world_quest_template.sql b/sql/old/3.3.5a/2011_02_05_1_world_quest_template.sql new file mode 100644 index 00000000000..64cdd977cb8 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_05_1_world_quest_template.sql @@ -0,0 +1,9 @@ +-- Fix nonexisting required races for Hungry Hungry Hatching +UPDATE `quest_template` SET `requiredraces`=514 WHERE `entry`=13889; -- Orc and Blood Elf (2+512) +UPDATE `quest_template` SET `requiredraces`=176 WHERE `entry`=13915; -- Undead, Tauren, Troll (16+32+128) +-- Fix nonexisting required races for Poached, Scrambled, Or Raw? +UPDATE `quest_template` SET `requiredraces`=514 WHERE `entry`=13904; -- Orc and Blood Elf (2+512) +UPDATE `quest_template` SET `requiredraces`=176 WHERE `entry`=13916; -- Undead, Tauren, Troll (16+32+128) +-- Fix nonexisting required races for Searing Roc Feathers +UPDATE `quest_template` SET `requiredraces`=514 WHERE `entry`=13905; -- Orc and Blood Elf (2+512) +UPDATE `quest_template` SET `requiredraces`=176 WHERE `entry`=13914; -- Undead, Tauren, Troll (16+32+128) diff --git a/sql/old/3.3.5a/2011_02_05_2_world_creature_template.sql b/sql/old/3.3.5a/2011_02_05_2_world_creature_template.sql new file mode 100644 index 00000000000..d193a81eb79 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_05_2_world_creature_template.sql @@ -0,0 +1,2 @@ +-- Update Trainertype where unit is NOT a trainer: +UPDATE `creature_template` SET `trainer_type`=0 WHERE entry IN (1300,1703,2855,2870,5749,5750,5753,5815,6027,6328,6373,6374,6376,6382,11048,11050,11051,15494,12776,16639,16649,16703,16727,16746,23535); diff --git a/sql/old/3.3.5a/2011_02_05_3_world_creature_template.sql b/sql/old/3.3.5a/2011_02_05_3_world_creature_template.sql new file mode 100644 index 00000000000..b899286a090 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_05_3_world_creature_template.sql @@ -0,0 +1,7 @@ +-- Saving to instance for difficulty entries +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|1 WHERE `entry` IN ( +34566,35615,35616, -- Anub arak +35347,35348,35349, -- Eydis Darkbane +35350,35351,35352, -- Fjola Lightbane +35216,35268,35269, -- Lord Jaraxxus +35447,35448,35449); -- Icehowl diff --git a/sql/old/3.3.5a/2011_02_05_4_world_game_event.sql b/sql/old/3.3.5a/2011_02_05_4_world_game_event.sql new file mode 100644 index 00000000000..eb8db804358 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_05_4_world_game_event.sql @@ -0,0 +1,42 @@ +-- Update Quest_conditions for Quest: The Lunar Festival +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry`IN(8870,8871,8872,8873,8874,8875); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +-- Alliance +(19,0,8871,0,4,1519,0,0,0,0,'The Lunar Festival: Stormwind'), +(19,0,8872,0,4,1657,0,0,0,0,'The Lunar Festival: Darnassus'), +(19,0,8870,0,4,1537,0,0,0,0,'The Lunar Festival: Ironforge'), +-- Horde +(19,0,8873,0,4,1637,0,0,0,0,'The Lunar Festival: Orgrimmar'), +(19,0,8874,0,4,1497,0,0,0,0,'The Lunar Festival: Undercity'), +(19,0,8875,0,4,1638,0,0,0,0,'The Lunar Festival: Thunder Bluff'); +-- Quest: Lunar Fireworks +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (15872,15873,15874,15879,15880,15882); +DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (15872,15873,15874,15879,15880,15882); -- Cleanup +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (15872,15873,15874,15879,15880,15882); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +-- small fireworks +-- blue firework +(15879,0,0,0,1,0,100,1,0,0,0,0,11,26344,2,0,0,0,0,1,0,0,0,0,0,0,0, 'cast fireworks'), +-- green firework +(15880,0,0,0,1,0,100,1,0,0,0,0,11,26345,2,0,0,0,0,1,0,0,0,0,0,0,0, 'cast fireworks'), +-- red firework +(15882,0,0,0,1,0,100,1,0,0,0,0,11,26347,2,0,0,0,0,1,0,0,0,0,0,0,0, 'cast fireworks'), +-- big fireworks +-- blue firework +(15872,0,0,0,1,0,100,1,0,0,0,0,11,26344,2,0,0,0,0,1,0,0,0,0,0,0,0, 'cast fireworks'), +-- red firework +(15873,0,0,0,1,0,100,1,0,0,0,0,11,26347,2,0,0,0,0,1,0,0,0,0,0,0,0, 'cast fireworks'), +-- green firework +(15874,0,0,0,1,0,100,1,0,0,0,0,11,26345,2,0,0,0,0,1,0,0,0,0,0,0,0, 'cast fireworks'); +-- remove useless quests: (as of patch 3.0 they where removed) +DELETE FROM `creature_questrelation` WHERE `quest` IN (8876,8877,8878,8879,8880,8881,8882,8862,8863,8864,8865); + +-- Elune's Blessing +DELETE FROM `gameobject_template` WHERE `entry` IN (180876,180877); +INSERT INTO `gameobject_template` (`entry`,`type`,`displayId`,`name`,`IconName`,`castBarCaption`,`unk1`,`faction`,`flags`,`size`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`questItem5`,`questItem6`,`data0`,`data1`,`data2`,`data3`,`data4`,`data5`,`data6`,`data7`,`data8`,`data9`,`data10`,`data11`,`data12`,`data13`,`data14`,`data15`,`data16`,`data17`,`data18`,`data19`,`data20`,`data21`,`data22`,`data23`,`AIName`,`ScriptName`,`WDBVerified`) VALUES +(180876,6,327, 'Elune''s Blessing TRAP BUFF', '', '', '',14,0,0.01,0,0,0,0,0,0,0,255,8,26393,0,1,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,'','',1), +(180877,6,327, 'Elune''s Blessing TRAP QUESTCREDIT', '', '', '',14,0,0.01,0,0,0,0,0,0,0,255,8,26394,0,1,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,'','',1); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=26393; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,0,26393,0,18,1,0,0,0, '', 'Elune''s Blessing'); diff --git a/sql/old/3.3.5a/2011_02_05_5_world_sai.sql b/sql/old/3.3.5a/2011_02_05_5_world_sai.sql new file mode 100644 index 00000000000..24278716679 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_05_5_world_sai.sql @@ -0,0 +1,17 @@ +-- Scourge Flamespitter SAI +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=25582; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-118407,-118408,-118425,-118421,-118422,-118426,-118427,-118375,-118405,-118409,-118423,-118428,-118429); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(-118407,0,0,0,1,0,100,0,1000,1000,8000,8000,11,45863,2,0,0,0,0,1,0,0,0,0,0,0,0,'Fire at random target every 8 sec'), +(-118408,0,0,0,1,0,100,0,1000,1000,8000,8000,11,45863,2,0,0,0,0,1,0,0,0,0,0,0,0,'Fire at random target every 8 sec'), +(-118425,0,0,0,1,0,100,0,1000,1000,8000,8000,11,45863,2,0,0,0,0,1,0,0,0,0,0,0,0,'Fire at random target every 8 sec'), +(-118421,0,0,0,1,0,100,0,7000,7000,8000,8000,11,45863,2,0,0,0,0,1,0,0,0,0,0,0,0,'Fire at random target every 8 sec'), +(-118422,0,0,0,1,0,100,0,7000,7000,8000,8000,11,45863,2,0,0,0,0,1,0,0,0,0,0,0,0,'Fire at random target every 8 sec'), +(-118426,0,0,0,1,0,100,0,4000,4000,8000,8000,11,45863,2,0,0,0,0,1,0,0,0,0,0,0,0,'Fire at random target every 8 sec'), +(-118427,0,0,0,1,0,100,0,4000,4000,8000,8000,11,45863,2,0,0,0,0,1,0,0,0,0,0,0,0,'Fire at random target every 8 sec'), +(-118375,0,0,0,1,0,100,0,2000,2000,8000,8000,11,45863,2,0,0,0,0,1,0,0,0,0,0,0,0,'Fire at random target every 8 sec'), +(-118405,0,0,0,1,0,100,0,2000,2000,8000,8000,11,45863,2,0,0,0,0,1,0,0,0,0,0,0,0,'Fire at random target every 8 sec'), +(-118409,0,0,0,1,0,100,0,2000,2000,8000,8000,11,45863,2,0,0,0,0,1,0,0,0,0,0,0,0,'Fire at random target every 8 sec'), +(-118423,0,0,0,1,0,100,0,8000,8000,8000,8000,11,45863,2,0,0,0,0,1,0,0,0,0,0,0,0,'Fire at random target every 8 sec'), +(-118428,0,0,0,1,0,100,0,8000,8000,8000,8000,11,45863,2,0,0,0,0,1,0,0,0,0,0,0,0,'Fire at random target every 8 sec'), +(-118429,0,0,0,1,0,100,0,8000,8000,8000,8000,11,45863,2,0,0,0,0,1,0,0,0,0,0,0,0,'Fire at random target every 8 sec'); diff --git a/sql/old/3.3.5a/2011_02_05_6_world_waypoint_data.sql b/sql/old/3.3.5a/2011_02_05_6_world_waypoint_data.sql new file mode 100644 index 00000000000..61dbc81d9b4 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_05_6_world_waypoint_data.sql @@ -0,0 +1,2 @@ +-- remove waypoint script spamming from 2 Dawnblade Blood Knight's +UPDATE `waypoint_data` SET `action`=0 WHERE `id` IN (943090,943250) AND `point`=2; diff --git a/sql/old/3.3.5a/2011_02_05_7_world_sai.sql b/sql/old/3.3.5a/2011_02_05_7_world_sai.sql new file mode 100644 index 00000000000..b746893890b --- /dev/null +++ b/sql/old/3.3.5a/2011_02_05_7_world_sai.sql @@ -0,0 +1,80 @@ +-- Fix Quest 11460 "Trust is Earned" +-- UPDATE Hidalgo the Master Falconer "Add Excelsior to vehicle and add gossip flag" +UPDATE `creature_template` SET `npcflag`=`npcflag`|1 WHERE `entry` IN (24750,24752); +DELETE FROM `vehicle_accessory` WHERE `entry`=24750; +INSERT INTO `vehicle_accessory` (`entry`,`accessory_entry`,`seat_id`,`minion`,`description`) VALUES +(24750,24751,0,1, 'Excelsior rides Hidalgo the Master Falconer'); +DELETE FROM `creature` WHERE `guid`=88103; +-- add missing text to Hidalgo the Master Falconer and Rock Falcon +DELETE FROM `gossip_menu` WHERE `entry` IN (8998,9007) AND `text_id` IN (12153,12168); +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES +(8998,12153),(9007,12168); +-- Add gossip_menu condition for 8998 and 9007 +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup` IN (8998,9007); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9007; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`) VALUES +(14,8998,12185,8,11460,0), -- Must have Quest 11460 rewarded +(14,9007,12168,9,11460,0), -- Must have quest 11460 taken not complete +(15,9007,0,2,34102,1), -- Must have at least 1 count of item 34102 +(15,9007,0,9,11460,0); -- Must have quest 11460 taken not complete +-- Creature Gossip_menu_option Update +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (9007) AND `id` IN (0); +INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`action_script_id`,`box_coded`,`box_money`,`box_text`) VALUES +(9007,0,0, 'Feed the grub to the Rock Falcon.',1,1,0,0,0,0,0, ''); +SET @ENTRY := 24752; -- Rock Falcon SAI +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,1,62,0,100,0,9007,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'On gossip option Close Gossip'), -- Player needs to cast this on self "not working" +(@ENTRY,0,1,0,61,0,100,0,100,100,100,100,86,44363,0,7,0,0,0,7,0,0,0,0,0,0,0,'Player selfcast spell'); + +-- Maiden of Winter's Breath Lake SAI For Quest "The Edge Of Winter" +SET @ENTRY := 33303; -- NPC entry +SET @ERROR1 := 1334; -- Error Message 1 +SET @ERROR2 := 1335; -- Error Message 2 +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@ENTRY*100; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,75,45776,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Apply aura on spawn'), +(@ENTRY,0,1,0,8,0,100,0,62767,0,0,0,80,@ENTRY*100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'On spell hit run script'), +(@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,28,45776,0,0,0,0,0,1,0,0,0,0,0,0,0,'Remove aura'), +(@ENTRY*100,9,1,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Face Player'), +(@ENTRY*100,9,2,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Say text 0'), +(@ENTRY*100,9,3,0,0,0,100,0,6000,6000,6000,6000,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Say text 1'), +(@ENTRY*100,9,4,0,0,0,100,0,5000,5000,5000,5000,66,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Reset Orientation'), +(@ENTRY*100,9,5,0,0,0,100,0,0,0,0,0,75,45776,0,0,0,0,0,1,0,0,0,0,0,0,0,'Replace Aura'); +-- NPC talk text insert from sniff +DELETE FROM `creature_text` WHERE `entry`=33303; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(33303,0,0, 'Thank you, mortal, for freeing me from this curse. I beg you, take this blade.',0,0,100,1,0,0, 'Maiden of Winter''s Breath Lake'), +(33303,1,0, 'It has brought me naught but ill. Mayhap you can find someone who will contain its power.',0,0,100,1,0,0, 'Maiden of Winter''s Breath Lake'); +-- Condition Target for Spell Break Curse of Ice must be npc 33303 with aura 45776 +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=62767; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`COMMENT`) VALUES +(17,62767,19,33303,0,0,@ERROR1, 'Break Curse of Ice Required Target Maiden of Winter''s Breath Lake'), +(17,62767,1,45776,0,1,@ERROR2, 'Break Curse of Ice Required Target Needs Aura Ice Block'); +-- Add Error Strings +DELETE FROM `trinity_string` WHERE `entry` IN (@ERROR1,@ERROR2); +INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES +(@ERROR1, 'Requires Maiden of Winter''s Breath Lake'), +(@ERROR2, 'You can''t use that right now'); + +-- Conversation between Crusader Lord Dalfors & Crusader Sunborn, Argent Vangard "Crusader Lord Dalfors Envoker" +SET @ENTRY := 30224; +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@ENTRY; +UPDATE `smart_scripts` SET `target_type`=1, `comment`= 'The Ebon Watcher: Load script every 4 min ooc' WHERE `entryorguid`=30377 AND `source_type` =0 AND `id`=0; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@ENTRY*100; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,0,30000,60000,150000,150000,80,@ENTRY*100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Load script every 2.5 min ooc'), +(@ENTRY*100,9,0,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Crusader Lord Dalfors text 0'), +(@ENTRY*100,9,1,0,0,0,100,0,6000,6000,0,0,1,0,0,0,0,0,0,9,30225,0,10,0,0,0,0,'Crusader Sunborn Say text 0'), +(@ENTRY*100,9,2,0,0,0,100,0,4000,4000,0,0,5,14,0,0,0,0,0,9,30225,0,10,0,0,0,0,'Crusader Sunborn emote'); +-- NPC talk text insert from sniff +DELETE FROM `creature_text` WHERE `entry` IN (30224,30225); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(30224,0,0, 'What''s on yer mind, lad?',0,0,100,6,0,0, 'Crusader Lord Dalfors'), +(30225,0,0, 'Eversong Woods, Dalfors. I''m thinking about how beautiful it was before Arthas cut a swathe of death through it...',0,0,100,1,0,0, 'Crusader Sunborn'); + diff --git a/sql/old/3.3.5a/2011_02_05_8_world_sai.sql b/sql/old/3.3.5a/2011_02_05_8_world_sai.sql new file mode 100644 index 00000000000..be2e11b4178 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_05_8_world_sai.sql @@ -0,0 +1,75 @@ +-- Quest "The Denouncement" (12273) (Converted&tweaked to SAI by Nay) +SET @Goodman := 27234; -- Blacksmith Goodman +SET @Zierhut := 27235; -- Lead Cannoneer Zierhut (npc) +SET @Mercer := 27236; -- Stable Master Mercer (npc) +SET @Jordan := 27237; -- Commander Jordan (npc) +SET @Rod := 37438; -- Rod of Compulsion (item) +SET @Compelled := 48714; -- Compelled (spell) +SET @DeathJordan := 48724; -- The Denouncement: Commander Jordan On Death +SET @DeathZierhut := 48726; -- The Denouncement: Lead Cannoneer Zierhut On Death +SET @DeathGoodman := 48728; -- The Denouncement: Blacksmith Goodman On Death +SET @DeathMercer := 48730; -- The Denouncement: Stable Master Mercer On Death +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry` IN (@Goodman,@Zierhut,@Mercer,@Jordan); +-- Spell scripts: Give kill credit through spell +DELETE FROM `spell_scripts` WHERE `id` IN (@DeathJordan,@DeathZierhut,@DeathGoodman,@DeathMercer); +INSERT INTO `spell_scripts`(`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES +(@DeathJordan,0,15,48723,1,0,0,0,0,0), -- cast "The Denouncement: Commander Jordan Kill Credit" on player +(@DeathZierhut,0,15,48725,1,0,0,0,0,0), -- cast "The Denouncement: Lead Cannoneer Zierhut Kill Credit" on player +(@DeathGoodman,0,15,48727,1,0,0,0,0,0), -- cast "The Denouncement: Blacksmith Goodman Kill Credit" on player +(@DeathMercer,0,15,48729,1,0,0,0,0,0); -- cast "The Denouncement: Stable Master Mercer Kill Credit" on player +-- Spell targets for spells that give quest credit through effect 77 +DELETE FROM `conditions` where `SourceEntry` IN (@DeathJordan,@DeathZierhut,@DeathGoodman,@DeathMercer) AND `SourceTypeOrReferenceId`=13; +DELETE FROM `conditions` where `SourceEntry`=@Rod AND `SourceTypeOrReferenceId`=18; +INSERT INTO `conditions`(`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`Comment`) VALUES +(13,0,@DeathJordan,0,18,1,@Jordan,0,0, 'The Denouncement: Jordan target'), +(13,0,@DeathZierhut,0,18,1,@Zierhut,0,0, 'The Denouncement: Zierhut target'), +(13,0,@DeathGoodman,0,18,1,0,0,0, 'The Denouncement: Goodman target'), +(13,0,@DeathMercer,0,18,1,@Mercer,0,0, 'The Denouncement: Mercer'), +(18,0,@Rod,0,24,1,@Goodman,0,0, 'The Denouncement: Rod - Goodman target'), +(18,0,@Rod,0,24,1,@Zierhut,0,0, 'The Denouncement: Rod - Zierhut target'), +(18,0,@Rod,0,24,1,@Mercer,0,0, 'The Denouncement: Rod - Mercer target'), +(18,0,@Rod,0,24,1,@Jordan,0,0, 'The Denouncement: Rod - Jordan target'); +DELETE FROM `creature_text` WHERE `entry` IN (@Goodman,@Zierhut,@Mercer,@Jordan); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(@Goodman,0,0, 'You are being misled! The Onslaught is all lies! The Scourge and the Forsaken are not our enemies! Wake up!',1,0,100,5,0,0, 'Blacksmith Goodman'), +(@Jordan,0,0, 'High general Abbendis personally told me that it was a mistake to come north and that we''re doomed! I urge you all to lay down your weapons and leave before it''s too late!',1,0,100,5,0,0, 'Commander Jordan'), +(@Zierhut,0,0, 'Renounce the Scarlet Onslaught! Don''t listen to the lies of the high general and the grand admiral any longer!',1,0,100,5,0,0, 'Lead Cannoneer Zierhut'), +(@Mercer,0,0, 'Abbendis is nothing but a harlot and Grand Admiral Westwind is selling her cheap like he sold us out!',1,0,100,5,0,0, 'Stable Master Mercer'); +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (@Goodman,@Zierhut,@Mercer,@Jordan); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@Goodman,0,0,0,8,0,100,0,@Compelled,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Goodman: On spellhit set phase 2'), +(@Goodman,0,1,0,6,2,100,0,0,0,0,0,85,@DeathGoodman,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Goodman: On death in phase 2 cast spell'), +(@Goodman,0,2,0,25,0,100,0,0,0,0,0,28,@Compelled,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Goodman: On reset remove Compelled aura'), +(@Goodman,0,3,0,25,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Goodman: On reset set phase 0'), +(@Goodman,0,4,0,6,2,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Goodman: On death in phase 2 yell'), +(@Mercer,0,0,0,8,0,100,0,@Compelled,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Mercer: On spellhit set phase 2'), +(@Mercer,0,1,0,6,2,100,0,0,0,0,0,85,@DeathMercer,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Mercer: On death in phase 2 cast spell'), +(@Mercer,0,2,0,25,0,100,0,0,0,0,0,28,@Compelled,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Mercer: On reset remove Compelled aura'), +(@Mercer,0,3,0,25,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Mercer: On reset set phase 0'), +(@Mercer,0,4,0,6,2,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Mercer: On death in phase 2 yell'), +(@Zierhut,0,0,0,8,0,100,0,@Compelled,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Goodman: On spellhit set phase 2'), +(@Zierhut,0,1,0,6,2,100,0,0,0,0,0,85,@DeathZierhut,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Zierhut: On death in phase 2 cast spell'), +(@Zierhut,0,2,0,25,0,100,0,0,0,0,0,28,@Compelled,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Zierhut: On reset remove Compelled aura'), +(@Zierhut,0,3,0,25,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Zierhut: On reset set phase 0'), +(@Zierhut,0,4,0,6,2,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Zierhut: On death in phase 2 yell'), +(@Jordan,0,0,0,8,0,100,0,@Compelled,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Jordan: On spellhit set phase 2'), +(@Jordan,0,1,0,6,2,100,0,0,0,0,0,85,@DeathJordan,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Jordan: On death in phase 2 cast spell'), +(@Jordan,0,2,0,25,0,100,0,0,0,0,0,28,@Compelled,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Jordan: On reset remove Compelled aura'), +(@Jordan,0,3,0,25,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Jordan: On reset set phase 0'), +(@Jordan,0,4,0,6,2,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Denouncement/Jordan: On death in phase 2 yell'); + +-- Kill a unrelated console DB error +DELETE FROM `creature_addon` WHERE `guid`=88103; + +-- Valiance Keep Footman SAI (by Malcrom) +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=25253; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-111383,-111377,-111378,-111382,-111379,-111380); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(-111383,0,0,0,1,0,100,0,1000,2000,4000,5000,5,36,0,0,0,0,0,1,0,0,0,0,0,0,0,'Attack emote every 4-5 sec'), +(-111377,0,0,0,1,0,100,0,3000,4000,4000,5000,5,36,0,0,0,0,0,1,0,0,0,0,0,0,0,'Attack emote every 4-5 sec'), +(-111378,0,0,0,1,0,100,0,8000,8000,16000,16000,10,4,5,21,0,0,0,1,0,0,0,0,0,0,0,'Random cheer emote every 16 sec'), +(-111382,0,0,0,1,0,100,0,16000,16000,16000,16000,10,4,5,21,0,0,0,1,0,0,0,0,0,0,0,'Random cheer emote every 16 sec'), +(-111379,0,0,0,1,0,100,0,2000,2000,5000,5000,5,36,0,0,0,0,0,1,0,0,0,0,0,0,0,'Attack emote every 5 sec'), +(-111379,0,1,0,1,0,100,0,4000,4000,7000,7000,5,36,0,0,0,0,0,10,111376,25253,0,0,0,0,0,'Attack emote dueler 2 sec later sec'), +(-111380,0,0,0,1,0,100,0,5000,5000,5000,5000,5,36,0,0,0,0,0,1,0,0,0,0,0,0,0,'Attack emote every 5 sec'), +(-111380,0,1,0,1,0,100,0,7000,7000,7000,7000,5,36,0,0,0,0,0,10,111381,25253,0,0,0,0,0,'Attack emote dueler 2 sec later sec'); diff --git a/sql/old/3.3.5a/2011_02_06_0_world_instance_sindragosa_lair.sql b/sql/old/3.3.5a/2011_02_06_0_world_instance_sindragosa_lair.sql new file mode 100644 index 00000000000..a52ed4f9859 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_06_0_world_instance_sindragosa_lair.sql @@ -0,0 +1,73 @@ +-- Creature templates +UPDATE `creature_template` SET `difficulty_entry_1`=38139 WHERE `entry`=37531; +UPDATE `creature_template` SET `difficulty_entry_1`=38151 WHERE `entry`=37532; +UPDATE `creature_template` SET `difficulty_entry_2`=0,`difficulty_entry_3`=0 WHERE `entry`=37533; +UPDATE `creature_template` SET `difficulty_entry_2`=0,`difficulty_entry_3`=0 WHERE `entry`=37534; +UPDATE `creature_template` SET `difficulty_entry_1`=38320,`difficulty_entry_2`=38321,`difficulty_entry_3`=38322 WHERE `entry`=36980; +UPDATE `creature_template` SET `minlevel`=82,`maxlevel`=82,`unit_class`=1,`faction_A`=14,`faction_H`=14,`unit_flags`=`unit_flags`|33554432,`baseattacktime`=2000,`flags_extra`=`flags_extra`|128 WHERE `entry`=38223; -- Icy Blast +UPDATE `creature_template` SET `minlevel`=80,`maxlevel`=80,`unit_class`=1,`faction_A`=2209,`faction_H`=2209,`dynamicflags`=8,`baseattacktime`=2000,`equipment_id`=523,`speed_walk`=1,`speed_run`=1.42857 WHERE `entry` IN (37531,38139); -- Frostwarden Handler +UPDATE `creature_template` SET `minlevel`=80,`maxlevel`=80,`unit_class`=2,`faction_A`=16,`faction_H`=16,`dynamicflags`=8,`baseattacktime`=2000,`speed_run`=1 WHERE `entry` IN (37532,38151); -- Frostwing Whelp +UPDATE `creature_template` SET `minlevel`=82,`maxlevel`=82,`unit_class`=2,`faction_A`=21,`faction_H`=21,`unit_flags`=`unit_flags`|64,`baseattacktime`=2000,`speed_walk`=2,`speed_run`=1.5873,`MovementType`=2,`InhabitType`=5 WHERE `entry` IN (37533,38220); -- Rimefang +UPDATE `creature_template` SET `minlevel`=82,`maxlevel`=82,`unit_class`=2,`faction_A`=21,`faction_H`=21,`unit_flags`=`unit_flags`|64,`baseattacktime`=2000,`speed_walk`=2,`speed_run`=1.5873,`MovementType`=2,`InhabitType`=5 WHERE `entry` IN (37534,38219); -- Spinestalker +UPDATE `creature_template` SET `minlevel`=83,`maxlevel`=83,`unit_class`=1,`faction_A`=2068,`faction_H`=2068,`unit_flags`=0,`baseattacktime`=1500,`speed_walk`=4.8,`speed_run`=4.28571 WHERE `entry` IN (36853,38265,38266,38267); -- Sindragosa +UPDATE `creature_template` SET `minlevel`=80,`maxlevel`=80,`unit_class`=2,`faction_A`=14,`faction_H`=14,`unit_flags`=`unit_flags`|33554944,`baseattacktime`=2000,`flags_extra`=`flags_extra`|128 WHERE `entry`=37186; -- Frost Bomb +UPDATE `creature_template` SET `minlevel`=80,`maxlevel`=80,`unit_class`=1,`faction_A`=14,`faction_H`=14,`baseattacktime`=2000,`speed_run`=1 WHERE `entry` IN (36980,38320,38321,38322); -- Ice Tomb + +-- Linked respawns +SET @GUID := 151761; +SET @SPINESTALKER := 207211; +SET @RIMEFANG := 207210; +DELETE FROM `linked_respawn` WHERE guid IN (@SPINESTALKER,@RIMEFANG) OR `guid` BETWEEN @GUID+22 AND @GUID+51; +INSERT INTO `linked_respawn` (`guid`,`linkedGuid`,`linkType`) VALUES +(@SPINESTALKER,@SPINESTALKER,0), -- Spinestalker +(@RIMEFANG,@RIMEFANG,0), -- Rimefang +(@GUID+22,@SPINESTALKER,0), -- Frostwarden Handler +(@GUID+23,@RIMEFANG,0), -- Frostwarden Handler +(@GUID+24,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+25,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+26,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+27,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+28,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+29,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+30,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+31,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+32,@RIMEFANG,0), -- Frostwing Whelp +(@GUID+33,@RIMEFANG,0), -- Frostwing Whelp +(@GUID+34,@RIMEFANG,0), -- Frostwing Whelp +(@GUID+35,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+36,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+37,@RIMEFANG,0), -- Frostwing Whelp +(@GUID+38,@RIMEFANG,0), -- Frostwing Whelp +(@GUID+39,@RIMEFANG,0), -- Frostwing Whelp +(@GUID+40,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+41,@RIMEFANG,0), -- Frostwing Whelp +(@GUID+42,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+43,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+44,@SPINESTALKER,0), -- Frostwing Whelp +(@GUID+45,@RIMEFANG,0), -- Frostwing Whelp +(@GUID+46,@RIMEFANG,0), -- Frostwing Whelp +(@GUID+47,@RIMEFANG,0), -- Frostwing Whelp +(@GUID+48,@RIMEFANG,0), -- Frostwing Whelp +(@GUID+49,@RIMEFANG,0), -- Frostwing Whelp +(@GUID+50,@RIMEFANG,0), -- Frostwing Whelp +(@GUID+51,@RIMEFANG,0); -- Frostwing Whelp + +-- Creature addon +UPDATE `creature_addon` SET `bytes1`=0 WHERE `guid` IN (@SPINESTALKER,@RIMEFANG); + +-- Creature model data +UPDATE `creature_model_info` SET `gender`=1 WHERE `modelid`=30362; + +-- Gameobject templates +UPDATE `gameobject_template` SET `flags`=33,`faction`=114 WHERE `entry`=202396; -- Ice Wall +UPDATE `gameobject_template` SET `flags`=32,`faction`=114 WHERE `entry`=201722; -- Ice Block + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `id`=202396; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(121712,202396,631,15,1,4309.686,2491.27441,211.170792,0.209439442,0,0,0,0,120,0,0); -- Ice Wall + +-- Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=70598; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`Comment`) VALUES +(13,70598,18,1, 'Sindragosa''s Fury - player targets'); diff --git a/sql/old/3.3.5a/2011_02_06_1_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_02_06_1_world_creature_loot_template.sql new file mode 100644 index 00000000000..295bb76a261 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_06_1_world_creature_loot_template.sql @@ -0,0 +1,2 @@ +-- Fragment of the Nightmare's Corruption drops 100% as of patch 3.0.2 +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `item` IN (21146,21147,21148,21149); diff --git a/sql/old/3.3.5a/2011_02_06_2_world_item_loot_template.sql b/sql/old/3.3.5a/2011_02_06_2_world_item_loot_template.sql new file mode 100644 index 00000000000..e77a40def02 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_06_2_world_item_loot_template.sql @@ -0,0 +1,4 @@ +-- Insert loot for Gently Shaken Gift +DELETE FROM `item_loot_template` WHERE `entry`=21271; +INSERT INTO `item_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(21271,21241,100,1,0,5,5); diff --git a/sql/old/3.3.5a/2011_02_07_0_world_achievement_criteria_data.sql b/sql/old/3.3.5a/2011_02_07_0_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..c73e90d161d --- /dev/null +++ b/sql/old/3.3.5a/2011_02_07_0_world_achievement_criteria_data.sql @@ -0,0 +1,18 @@ +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (12822,12996,12972,12989,12758,12955,13049,13060,13102,13133,13134,13135); +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES +(12822,11,0,0, 'achievement_all_you_can_eat'), -- All You Can Eat (10 player) +(12822,12,0,0, ''), -- All You Can Eat (10 player) +(12996,11,0,0, 'achievement_all_you_can_eat'), -- All You Can Eat (10 player) Heroic +(12996,12,2,0, ''), -- All You Can Eat (10 player) Heroic +(12972,11,0,0, 'achievement_all_you_can_eat'), -- All You Can Eat (25 player) +(12972,12,1,0, ''), -- All You Can Eat (25 player) +(12989,11,0,0, 'achievement_all_you_can_eat'), -- All You Can Eat (25 player) Heroic +(12989,12,3,0, ''), -- All You Can Eat (25 player) Heroic +(12758,12,0,0, ''), -- The Frostwing Halls (10 player) Sindragosa +(12955,12,1,0, ''), -- The Frostwing Halls (25 player) Sindragosa +(13049,12,2,0, ''), -- Heroic: The Frostwing Halls (10 player) Sindragosa +(13060,12,3,0, ''), -- Heroic: The Frostwing Halls (25 player) Sindragosa +(13102,12,0,0, ''), -- Sindragosa kills (Icecrown 10 player) +(13133,12,1,0, ''), -- Sindragosa kills (Icecrown 25 player) +(13134,12,2,0, ''), -- Sindragosa kills (Heroic Icecrown 10 player) +(13135,12,3,0, ''); -- Sindragosa kills (Heroic Icecrown 25 player) diff --git a/sql/old/3.3.5a/2011_02_07_0_world_areatrigger_scripts.sql b/sql/old/3.3.5a/2011_02_07_0_world_areatrigger_scripts.sql new file mode 100644 index 00000000000..6fba267fe1b --- /dev/null +++ b/sql/old/3.3.5a/2011_02_07_0_world_areatrigger_scripts.sql @@ -0,0 +1,3 @@ +DELETE FROM `areatrigger_scripts` WHERE `entry`=5604; +INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES +(5604,'at_sindragosa_lair'); diff --git a/sql/old/3.3.5a/2011_02_07_0_world_creature_template.sql b/sql/old/3.3.5a/2011_02_07_0_world_creature_template.sql new file mode 100644 index 00000000000..216adb1c52a --- /dev/null +++ b/sql/old/3.3.5a/2011_02_07_0_world_creature_template.sql @@ -0,0 +1,5 @@ +UPDATE `creature_template` SET `minlevel`=80,`maxlevel`=80,`dynamicflags`=0,`VehicleId`=591,`minrangedmg`=345,`maxrangedmg`=509,`rangedattackpower`=103,`mindmg`=422,`maxdmg`=586,`attackpower`=642,`dmg_multiplier`=7.5,`spell3`=70542,`spell6`=71516 WHERE `entry` IN (37672,38285,38605,38786,38787,38788,38789,38790); +UPDATE `creature_template` SET `spell1`=70360,`spell2`=70539 WHERE `entry` IN (38605,38786,38787); +UPDATE `creature_template` SET `spell1`=72527,`spell2`=72457 WHERE `entry` IN (38788,38789,38790); +UPDATE `creature_template` SET `difficulty_entry_1`=38605,`difficulty_entry_2`=38786,`difficulty_entry_3`=38787 WHERE `entry`=37672; +UPDATE `creature_template` SET `difficulty_entry_1`=38788,`difficulty_entry_2`=38789,`difficulty_entry_3`=38790 WHERE `entry`=38285; diff --git a/sql/old/3.3.5a/2011_02_07_0_world_creature_text.sql b/sql/old/3.3.5a/2011_02_07_0_world_creature_text.sql new file mode 100644 index 00000000000..e4d570bb7fa --- /dev/null +++ b/sql/old/3.3.5a/2011_02_07_0_world_creature_text.sql @@ -0,0 +1,14 @@ +DELETE FROM `creature_text` WHERE `entry`=36853; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(36853,0,0, 'You are fools to have come to this place! The icy winds of Northrend will consume your souls!',1,0,0,0,0,17007, 'Sindragosa - SAY_AGGRO'), +(36853,1,0, 'Suffer, mortals, as your pathetic magic betrays you!',1,0,0,0,0,17014, 'Sindragosa - SAY_UNCHAINED_MAGIC'), +(36853,2,0, '%s prepares to unleash a wave of blistering cold!',3,0,0,0,0,0, 'Sindragosa - EMOTE_WARN_BLISTERING_COLD'), +(36853,3,0, 'Can you feel the cold hand of death upon your heart?',1,0,0,0,0,17013, 'Sindragosa - SAY_BLISTERING_COLD'), +(36853,4,0, 'Aaah! It burns! What sorcery is this?!',1,0,0,0,0,17015, 'Sindragosa - SAY_RESPITE_FOR_A_TORMENTED_SOUL'), +(36853,5,0, 'Your incursion ends here! None shall survive!',1,0,0,0,0,17012, 'Sindragosa - SAY_AIR_PHASE'), +(36853,6,0, 'Now feel my master''s limitless power and despair!',1,0,0,0,0,17016, 'Sindragosa - SAY_PHASE_2'), +(36853,7,0, '%s fires a frozen orb towards $N!',3,0,0,0,0,0, 'Sindragosa - EMOTE_WARN_FROZEN_ORB'), +(36853,8,0, 'Perish!',1,0,0,0,0,17008, 'Sindragosa - SAY_KILL 1'), +(36853,8,1, 'A flaw of mortality...',1,0,0,0,0,17009, 'Sindragosa - SAY_KILL 2'), +(36853,9,0, 'Enough! I tire of these games!',1,0,0,0,0,17011, 'Sindragosa - SAY_BERSERK'), +(36853,10,0, 'Free...at last...',1,0,0,0,0,17010, 'Sindragosa - SAY_DEATH'); diff --git a/sql/old/3.3.5a/2011_02_07_0_world_scriptname.sql b/sql/old/3.3.5a/2011_02_07_0_world_scriptname.sql new file mode 100644 index 00000000000..d6b290c48ab --- /dev/null +++ b/sql/old/3.3.5a/2011_02_07_0_world_scriptname.sql @@ -0,0 +1,5 @@ +UPDATE `creature_template` SET `ScriptName`='boss_sindragosa' WHERE `entry`=36853; +UPDATE `creature_template` SET `ScriptName`='npc_ice_tomb' WHERE `entry`=36980; +UPDATE `creature_template` SET `ScriptName`='npc_spinestalker' WHERE `entry`=37534; +UPDATE `creature_template` SET `ScriptName`='npc_rimefang_icc' WHERE `entry`=37533; +UPDATE `creature_template` SET `ScriptName`='npc_sindragosa_trash' WHERE `entry` IN (37531,37532); diff --git a/sql/old/3.3.5a/2011_02_07_0_world_spell_linked_spell.sql b/sql/old/3.3.5a/2011_02_07_0_world_spell_linked_spell.sql new file mode 100644 index 00000000000..0839e256fb3 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_07_0_world_spell_linked_spell.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (70117,70157); +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES +(70117,70122,1, 'Sindragosa - Icy Grip'), +(70157,69700,2, 'Sindragosa - Ice Tomb resistance'); diff --git a/sql/old/3.3.5a/2011_02_07_0_world_spell_script_names.sql b/sql/old/3.3.5a/2011_02_07_0_world_spell_script_names.sql new file mode 100644 index 00000000000..7fc30c64a07 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_07_0_world_spell_script_names.sql @@ -0,0 +1,30 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_frostwarden_handler_order_whelp'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_frostwarden_handler_focus_fire'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_rimefang_icy_blast'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_s_fury'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_unchained_magic'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_instability'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_frost_beacon'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_ice_tomb'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_ice_tomb_dummy'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_ice_tomb_trap'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_collision_filter'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(71357,'spell_frostwarden_handler_order_whelp'), +(71350,'spell_frostwarden_handler_focus_fire'), +(71376,'spell_rimefang_icy_blast'), +(70598,'spell_sindragosa_s_fury'), +(69762,'spell_sindragosa_unchained_magic'), +(69766,'spell_sindragosa_instability'), +(70126,'spell_sindragosa_frost_beacon'), +(69712,'spell_sindragosa_ice_tomb'), +(69675,'spell_sindragosa_ice_tomb_dummy'), +(70157,'spell_sindragosa_ice_tomb_trap'), +(69845,'spell_sindragosa_collision_filter'), +(71053,'spell_sindragosa_collision_filter'), +(71054,'spell_sindragosa_collision_filter'), +(71055,'spell_sindragosa_collision_filter'), +(70127,'spell_sindragosa_collision_filter'), +(72528,'spell_sindragosa_collision_filter'), +(72529,'spell_sindragosa_collision_filter'), +(72530,'spell_sindragosa_collision_filter'); diff --git a/sql/old/3.3.5a/2011_02_07_1_world_creature_questrelation.sql b/sql/old/3.3.5a/2011_02_07_1_world_creature_questrelation.sql new file mode 100644 index 00000000000..4aeb7a70775 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_07_1_world_creature_questrelation.sql @@ -0,0 +1,12 @@ +-- Missing relation for quest You've Been Served +DELETE FROM `creature_questrelation` WHERE `id`=38208 AND `quest`=14488; +DELETE FROM `creature_involvedrelation` WHERE `id`=36296 AND `quest`=14488; +INSERT INTO `creature_questrelation`(`id`,`quest`) VALUES (38208,14488); +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES (36296,14488); + +-- Missing loot form Standard Apothecary Serving Kit request for quest You've Been Served +DELETE FROM `item_loot_template` WHERE `entry`=49631 AND `item` IN (49352,49351,49635); +INSERT INTO `item_loot_template`(`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(49631,49352,100,1,0,1,1), +(49631,49351,100,1,0,1,1), +(49631,49635,100,1,0,1,1); diff --git a/sql/old/3.3.5a/2011_02_07_2_world_sai.sql b/sql/old/3.3.5a/2011_02_07_2_world_sai.sql new file mode 100644 index 00000000000..1af21f5d048 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_07_2_world_sai.sql @@ -0,0 +1,58 @@ +-- SAI for quest 10345 "The Flesh Lies..." +-- Spell script target for Protectorate Igniter (quest The Flesh Lies...) +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=35372; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,0,35372,1,18,1,20561,0,0,'', 'Protectorate Igniter'); +-- Withered Corpse SAI. +SET @ENTRY:=20561; +UPDATE `creature_template` SET `unit_flags`=`unit_flags`&~2 WHERE `entry`=@ENTRY; +UPDATE `creature_template` SET `unit_flags`=`unit_flags`|256 WHERE `entry`=@ENTRY; +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@ENTRY*100; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,22,1,0,0,0,0,0,0,0,0,0,0,0,0,0,'On spawn set phase 1'), +(@ENTRY,0,1,0,8,1,100,0,35372,0,0,0,80,@ENTRY*100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'On spell hit run script'), +(@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,22,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 'set phase 0'), +(@ENTRY*100,9,1,0,0,0,100,0,1000,1000,0,0,33,20561,0,0,0,0,0,7,0,0,0,0,0,0,0,'give quest credit'), +(@ENTRY*100,9,2,0,0,0,100,0,1000,1000,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'despawn'); + +-- SAI for quest 11607 "The Lost Spirits" +-- Kaskala Craftman SAI. +SET @ENTRY:=25321; +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@ENTRY*100; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,22,1,0,0,0,0,0,0,0,0,0,0,0,0,0,'On spawn set phase 1'), +(@ENTRY,0,1,0,8,1,100,0,45504,0,0,0,80,@ENTRY*100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'On spell hit run script'), +(@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,22,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 'set phase 0'), +(@ENTRY*100,9,1,0,0,0,100,0,1000,2000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say Text 0 random'), +(@ENTRY*100,9,2,0,0,0,100,0,1000,1000,0,0,33,25321,0,0,0,0,0,7,0,0,0,0,0,0,0,'give quest credit'), +(@ENTRY*100,9,3,0,0,0,100,0,1000,1000,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'despawn'); +-- Add texts for this NPC. +DELETE FROM `creature_text` WHERE `entry`=25321; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(25321,0,0, 'Thank you for freeing me! May the tides always favor you.',0,0,100,1,0,0, 'Kaskala Craftman'), +(25321,0,1, 'Do not allow Kaskala to forget what has happened here.',0,0,100,1,0,0, 'Kaskala Craftman'); +-- Kaskala Shaman SAI. +SET @ENTRY:=25322; +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@ENTRY*100; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,22,1,0,0,0,0,0,0,0,0,0,0,0,0,0, 'On spawn set phase 1'), +(@ENTRY,0,1,0,8,1,100,0,45504,0,0,0,80,@ENTRY*100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'On spell hit run script'), +(@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,22,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 'set phase 0'), +(@ENTRY*100,9,1,0,0,0,100,0,1000,2000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say Text 0 random'), +(@ENTRY*100,9,2,0,0,0,100,0,1000,1000,0,0,33,25322,0,0,0,0,0,7,0,0,0,0,0,0,0, 'give quest credit'), +(@ENTRY*100,9,3,0,0,0,100,0,1000,1000,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'despawn'); +-- Add texts for this NPC. +DELETE FROM `creature_text` WHERE `entry`=25322; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(25322,0,0, 'May the ancestors always aid you, $n, as you have aided me.',0,0,100,1,0,0, 'Kaskala Shaman'), +(25322,0,1, 'Thank you, $n. May the winds and seas always deliver you safely.',0,0,100,1,0,0, 'Kaskala Shaman'); +-- Delete the old EAI script. +DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (25321,25322); +-- Delete the EAI texts. +DELETE FROM `creature_ai_texts` WHERE entry IN (-899,-898,-900,-901); diff --git a/sql/old/3.3.5a/2011_02_08_0_world_areatrigger_scripts.sql b/sql/old/3.3.5a/2011_02_08_0_world_areatrigger_scripts.sql new file mode 100644 index 00000000000..c7a29e0428d --- /dev/null +++ b/sql/old/3.3.5a/2011_02_08_0_world_areatrigger_scripts.sql @@ -0,0 +1,4 @@ +DELETE FROM `areatrigger_scripts` WHERE `entry` IN (5698,5649); +INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES +(5698,'at_icc_saurfang_portal'), +(5649,'at_icc_shutdown_traps'); diff --git a/sql/old/3.3.5a/2011_02_08_0_world_instance_saurfang_traps.sql b/sql/old/3.3.5a/2011_02_08_0_world_instance_saurfang_traps.sql new file mode 100644 index 00000000000..2f3450e61d4 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_08_0_world_instance_saurfang_traps.sql @@ -0,0 +1,18 @@ +UPDATE `creature_template` SET `minlevel`=80,`maxlevel`=80,`faction_A`=14,`faction_H`=14,`unit_flags`=0x02000000,`flags_extra`=128,`InhabitType`=7 WHERE `entry`=37744; +UPDATE `creature_template` SET `RegenHealth`=0 WHERE `entry` IN (36980,38320,38321,38322); -- Ice Tomb health regen + +SET @GUID := 137731; +DELETE FROM `creature` WHERE `id`=37744; +INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES +(@GUID+00,37744,631,15,1,0,0,4135.74658,2781.60156,353.163574,4.729,120,0,0,1,0,0,0,0,0,0), +(@GUID+01,37744,631,15,1,0,0,4156.65100,2781.51831,353.001343,4.729,120,0,0,1,0,0,0,0,0,0), +(@GUID+02,37744,631,15,1,0,0,4159.71300,2735.11279,355.224200,6.248,120,0,0,1,0,0,0,0,0,0), +(@GUID+03,37744,631,15,1,0,0,4159.79900,2804.18848,355.288116,0.017,120,0,0,1,0,0,0,0,0,0), +(@GUID+04,37744,631,15,1,0,0,4160.11200,2788.29419,352.943756,6.260,120,0,0,1,0,0,0,0,0,0), +(@GUID+05,37744,631,15,1,0,0,4183.78467,2751.65723,353.090027,3.124,120,0,0,1,0,0,0,0,0,0), +(@GUID+06,37744,631,15,1,0,0,4192.59700,2733.27954,355.288116,4.712,120,0,0,1,0,0,0,0,0,0), +(@GUID+07,37744,631,15,1,0,0,4193.00700,2829.08423,355.361328,4.694,120,0,0,1,0,0,0,0,0,0), +(@GUID+08,37744,631,15,1,0,0,4201.84900,2750.52612,353.001343,0.017,120,0,0,1,0,0,0,0,0,0), +(@GUID+09,37744,631,15,1,0,0,4224.70557,2804.10864,355.288100,3.140,120,0,0,1,0,0,0,0,0,0), +(@GUID+10,37744,631,15,1,0,0,4224.83500,2735.23600,355.288116,3.140,120,0,0,1,0,0,0,0,0,0), +(@GUID+11,37744,631,15,1,0,0,4225.13800,2788.18848,353.032745,3.141,120,0,0,1,0,0,0,0,0,0); diff --git a/sql/old/3.3.5a/2011_02_08_0_world_scriptname.sql b/sql/old/3.3.5a/2011_02_08_0_world_scriptname.sql new file mode 100644 index 00000000000..79dff902f24 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_08_0_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='npc_frost_freeze_trap' WHERE `entry`=37744; diff --git a/sql/old/3.3.5a/2011_02_08_1_world_creature_template.sql b/sql/old/3.3.5a/2011_02_08_1_world_creature_template.sql new file mode 100644 index 00000000000..3663532ac0c --- /dev/null +++ b/sql/old/3.3.5a/2011_02_08_1_world_creature_template.sql @@ -0,0 +1,2 @@ +-- Add quest relations flag to npc 36296 "Apothecary Hummel <Crown Chemical Co.>" +UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=36296; diff --git a/sql/old/3.3.5a/2011_02_08_2_world_waypoint_scripts.sql b/sql/old/3.3.5a/2011_02_08_2_world_waypoint_scripts.sql new file mode 100644 index 00000000000..485380af928 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_08_2_world_waypoint_scripts.sql @@ -0,0 +1,2 @@ +-- Remove obsolete waypoint scripts +DELETE FROM `waypoint_scripts` WHERE `id` IN (448,450); diff --git a/sql/old/3.3.5a/2011_02_10_0_world_sai.sql b/sql/old/3.3.5a/2011_02_10_0_world_sai.sql new file mode 100644 index 00000000000..a83124d7631 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_10_0_world_sai.sql @@ -0,0 +1,131 @@ +-- QUEST 9663 "The Kessel Run" +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry` IN (17116,17240,17440); +UPDATE `creature_template` SET `gossip_menu_id`=7983 WHERE `entry`=17440; +-- Smart AI +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (17116,17240,17440); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(17116,0,0,0,64,0,100,0,0,0,0,0,33,17116,0,0,0,0,0,7,0,0,0,0,0,0,0, 'On gossip hello credit for quest 9663'), +(17240,0,0,0,64,0,100,0,0,0,0,0,33,17240,0,0,0,0,0,7,0,0,0,0,0,0,0, 'On gossip hello credit for quest 9663'), +(17440,0,0,0,64,0,100,0,0,0,0,0,33,17440,0,0,0,0,0,7,0,0,0,0,0,0,0, 'On gossip hello credit for quest 9663'); +-- Add Gossip menu items +DELETE FROM `gossip_menu` WHERE `entry`=7399 AND `text_id`=9038; +DELETE FROM `gossip_menu` WHERE `entry`=7983 AND `text_id`=8994; +DELETE FROM `gossip_menu` WHERE `entry`=7983 AND `text_id`=9039; +DELETE FROM `gossip_menu` WHERE `entry`=7370 AND `text_id`=9040; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES +(7399,9038),(7983,8994),(7983,9039),(7370,9040); +-- Gossip conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup` IN (7399,7983,7370); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(14,7399,9038,0,9,9663,0,0,0,'','Show gossip text 9038 if player has quest 9663'), +(14,7983,9039,0,9,9663,0,0,0,'','Show gossip text 9039 if player has quest 9663'), +(14,7370,9040,0,9,9663,0,0,0,'','Show gossip text 9040 if player has quest 9663'); + +-- QUEST What The Dragons Know (horde & alliance) +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=27990; +UPDATE `creature_template` SET `gossip_menu_id`=10192 WHERE `entry`=26917; +UPDATE `creature_template` SET `gossip_menu_id`=10199 WHERE `entry`=27990; + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=10199; +INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`action_script_id`,`box_coded`,`box_money`,`box_text`) VALUES +(10199,0,0,'What do you know of ancient swords?',1,1,0,0,0,0,0,''), +(10199,1,0,'What do you know of ancient swords?',1,1,0,0,0,0,0,''); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10199; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,10199,0,0,9,14444,0,0,0,'','Show gossip option 0 if player has quest 14444 (Alliance)'), +(15,10199,1,0,9,24555,0,0,0,'','Show gossip option 1 if player has quest 24555 (Horde)'); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (27990,2799000,2799001); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(27990,0,0,0,62,0,100,0,10199,0,0,0,80,2799001,0,0,0,0,0,1,0,0,0,0,0,0,0, 'On gossip option select run script'), +(27990,0,1,0,62,0,100,0,10199,1,0,0,80,2799000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'On gossip option select run script'), +-- horde quest script +(2799000,9,0,0,0,0,100,0,0,0,0,0,81,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Turn off Gossip & Questgiver flags'), +(2799000,9,1,0,0,0,100,0,0,0,0,0,81,0,0,0,0,0,0,9,26917,0,10,0,0,0,0, 'Turn of Gossip & Questgiver flags for Alexstrasza'), +(2799000,9,2,0,0,0,100,0,2000,2000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 0'), +(2799000,9,3,0,0,0,100,0,4000,4000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 1'), +(2799000,9,4,0,0,0,100,0,0,0,0,0,45,0,1,0,0,0,0,9,38017,0,30,0,0,0,0, 'Kalecgos start path'), +(2799000,9,5,0,0,0,100,0,4000,4000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 2'), +(2799000,9,6,0,0,0,100,0,4000,4000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 3'), +(2799000,9,7,0,0,0,100,0,4000,4000,0,0,1,0,0,0,0,0,0,9,38017,0,30,0,0,0,0, 'Kalecgos Say text 0'), +(2799000,9,8,0,0,0,100,0,4000,4000,0,0,1,1,0,0,0,0,0,9,38017,0,30,0,0,0,0, 'Kalecgos Say text 1'), +(2799000,9,9,0,0,0,100,0,4000,4000,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 4'), +(2799000,9,10,0,0,0,100,0,4000,4000,0,0,1,2,0,0,0,0,0,9,38017,0,30,0,0,0,0, 'Kalecgos Say text 2'), +(2799000,9,11,0,0,0,100,0,3000,3000,0,0,45,0,1,0,0,0,0,9,26917,0,10,0,0,0,0, 'Turn Alexstrasza'), +(2799000,9,12,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,9,26917,0,10,0,0,0,0, 'Alexstrasza Say text 0'), +(2799000,9,13,0,0,0,100,0,4000,4000,0,0,1,3,0,0,0,0,0,9,38017,0,30,0,0,0,0, 'Kalecgos Say text 3'), +(2799000,9,14,0,0,0,100,0,3000,3000,0,0,45,0,2,0,0,0,0,9,38017,0,30,0,0,0,0, 'Kalecgos resume path'), +(2799000,9,15,0,0,0,100,0,0,0,0,0,45,0,2,0,0,0,0,9,26917,0,10,0,0,0,0, 'Turn Alexstrasza back'), +(2799000,9,16,0,0,0,100,0,1000,1000,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 5'), +(2799000,9,17,0,0,0,100,0,4000,4000,0,0,1,6,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 6'), +(2799000,9,18,0,0,0,100,0,4000,4000,0,0,33,36715,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Give quest credit'), +(2799000,9,19,0,0,0,100,0,4000,4000,0,0,81,3,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Turn on Gossip & Questgiver flags'), +(2799000,9,20,0,0,0,100,0,0,0,0,0,81,3,0,0,0,0,0,9,26917,0,10,0,0,0,0, 'Turn on Gossip & Questgiver flags for Alexstrasza'), +-- alliance quest script +(2799001,9,0,0,0,0,100,0,0,0,0,0,81,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Turn off Gossip & Questgiver flags'), +(2799001,9,1,0,0,0,100,0,0,0,0,0,81,0,0,0,0,0,0,9,26917,0,10,0,0,0,0, 'Turn of Gossip & Questgiver flags for Alexstrasza'), +(2799001,9,2,0,0,0,100,0,2000,2000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 0'), +(2799001,9,3,0,0,0,100,0,4000,4000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 1'), +(2799001,9,4,0,0,0,100,0,0,0,0,0,45,0,1,0,0,0,0,9,38017,0,30,0,0,0,0, 'Kalecgos start path'), +(2799001,9,5,0,0,0,100,0,4000,4000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 2'), +(2799001,9,6,0,0,0,100,0,4000,4000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 3'), +(2799001,9,7,0,0,0,100,0,4000,4000,0,0,1,0,0,0,0,0,0,9,38017,0,30,0,0,0,0, 'Kalecgos Say text 0'), +(2799001,9,8,0,0,0,100,0,4000,4000,0,0,1,1,0,0,0,0,0,9,38017,0,30,0,0,0,0, 'Kalecgos Say text 1'), +(2799001,9,9,0,0,0,100,0,4000,4000,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 4'), +(2799001,9,10,0,0,0,100,0,4000,4000,0,0,1,2,0,0,0,0,0,9,38017,0,30,0,0,0,0, 'Kalecgos Say text 2'), +(2799001,9,11,0,0,0,100,0,3000,3000,0,0,45,0,1,0,0,0,0,9,26917,0,10,0,0,0,0, 'Turn Alexstrasza'), +(2799001,9,12,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,9,26917,0,10,0,0,0,0, 'Alexstrasza Say text 0'), +(2799001,9,13,0,0,0,100,0,4000,4000,0,0,1,3,0,0,0,0,0,9,38017,0,30,0,0,0,0, 'Kalecgos Say text 3'), +(2799001,9,14,0,0,0,100,0,3000,3000,0,0,45,0,2,0,0,0,0,9,38017,0,30,0,0,0,0, 'Kalecgos resume path'), +(2799001,9,15,0,0,0,100,0,0,0,0,0,45,0,2,0,0,0,0,9,26917,0,10,0,0,0,0, 'Turn Alexstrasza back'), +(2799001,9,16,0,0,0,100,0,1000,1000,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 5'), +(2799001,9,17,0,0,0,100,0,4000,4000,0,0,1,7,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Say text 7'), +(2799001,9,18,0,0,0,100,0,4000,4000,0,0,33,36715,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Give quest credit'), +(2799001,9,19,0,0,0,100,0,4000,4000,0,0,81,3,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Turn on Gossip & Questgiver flags'), +(2799001,9,20,0,0,0,100,0,0,0,0,0,81,3,0,0,0,0,0,9,26917,0,10,0,0,0,0, 'Turn on Gossip & Questgiver flags for Alexstrasza'); + +DELETE FROM `creature_text` WHERE `entry` IN (26917,27990,38017); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(26917,0,0,'Mortal champions have long used these weapons to combat evil. I see no reason to keep the swords from them in this battle.',0,0,100,1,0,0,'Alexstrasza the Life-Binder'), +(27990,0,0,'You''re too late, $n. Another visitor from Dalaran came asking after information about the same prismatic dragon blades.',0,0,100,1,0,0,'Krasus'), +(27990,1,0,'From your description, I''m certain the book I loaned our visitor could allow you to easily identify the weapon.',0,0,100,25,0,0,'Krasus'), +(27990,2,0,'I''m afraid you''ll have to ask the -- Well, perhaps Kalecgos can help.',0,0,100,1,0,0,'Krasus'), +(27990,3,0,'$n may have found the remains of a prismatic blade, Kalecgos. Will you offer your help to our visitor?',0,0,100,1,0,0,'Krasus'), +(27990,4,0,'You believe our allies will not be able to control the power of the swords?',0,0,100,1,0,0,'Krasus'), +(27990,5,0,'As will we all.',0,0,100,25,0,0,'Krasus'), +(27990,6,0,'Please, mortal, speak with Arcanist Tybalin in Dalaran. He may be able to negotiate with the Sunreavers for access to the book.',0,0,100,1,0,0,'Krasus'), +(27990,7,0,'Please, mortal, seek out Magister Hathorel in Dalaran. He might be able to negotiate with the Silver Covenant for access to the book.',0,0,100,1,0,0,'Krasus'), +(38017,0,0,'Are you certain you should be helping these mortals in their quest for the sword?',0,0,100,1,0,0,'Kalecgos'), +(38017,1,0,'These blades, Krasus... They were made long ago, when things were... different.',0,0,100,1,0,0,'Kalecgos'), +(38017,2,0,'Our enemies once turned our strongest weapon against us. What makes you think the prismatic blades will be any different?',0,0,100,1,0,0,'Kalecgos'), +(38017,3,0,'As you wish, my queen. I will not stand in their way, but I will keep a close watch.',0,0,100,16,0,0,'Kalecgos'); + +-- waypoints for Kalecgos +DELETE FROM `waypoints` WHERE `entry`=38017; +INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES +(38017,1,3541.156,276.041,342.721,'talk point'), +(38017,2,3545.989,287.278,342.721,'home point'); + +-- SAI for Kalecgos +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=38017; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=38017; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid` IN (3801700,3801701); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(38017,0,0,1,38,0,100,0,0,1,0,0,80,3801700,0,0,0,0,0,1,0,0,0,0,0,0,0, 'On dataset 0 1 run script'), +(38017,0,1,1,38,0,100,0,0,2,0,0,80,3801701,0,0,0,0,0,1,0,0,0,0,0,0,0, 'On dataset 0 2 run script'), +(38017,0,2,3,40,0,100,0,1,38017,0,0,54,30000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Pause at wp 1'), +(38017,0,3,0,61,0,100,0,0,0,0,0,66,0,0,0,0,0,0,9,27990,0,15,0,0,0,0, 'turn to Krasus'), +(38017,0,4,5,40,0,100,0,2,38017,0,0,55,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Stop at wp 2'), +(38017,0,5,0,61,0,100,0,0,0,0,0,66,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'turn to pos'), +(3801700,9,0,0,0,0,100,0,0,0,0,0,45,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'dataset 0 0'), +(3801700,9,1,0,0,0,100,0,0,0,0,0,53,0,38017,0,0,0,0,1,0,0,0,0,0,0,0, 'wp start'), +(3801701,9,0,0,0,0,100,0,0,0,0,0,45,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'dataset 0 0'), +(3801701,9,1,0,0,0,100,0,0,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'wp resume'); + +-- SAI for Alexstrasza +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=26917; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=26917; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(26917,0,0,1,38,0,100,0,0,1,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,1.6049, 'On dataset 0 1 turn'), +(26917,0,1,1,38,0,100,0,0,2,0,0,66,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'On dataset 0 2 turn'); diff --git a/sql/old/3.3.5a/2011_02_10_1_world_sai.sql b/sql/old/3.3.5a/2011_02_10_1_world_sai.sql new file mode 100644 index 00000000000..b8149880d08 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_10_1_world_sai.sql @@ -0,0 +1,50 @@ +-- Conversation between Sabetta Ward & Gavin Ward, Fort Wildervar "Sabetta Ward Envoker" +SET @ENTRY := 24532; +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@ENTRY*100; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,0,10000,30000,150000,150000,80,@ENTRY*100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Load script every 2.5 min ooc'), +(@ENTRY*100,9,0,0,0,0,100,0,5000,5000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sabetta Ward Say text 0'), +(@ENTRY*100,9,1,0,0,0,100,0,5000,5000,0,0,1,0,0,0,0,0,0,9,24531,0,10,0,0,0,0,'Gavin Ward Say text 0'), +(@ENTRY*100,9,2,0,0,0,100,0,5000,5000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sabetta Ward Say text 1'), +(@ENTRY*100,9,3,0,0,0,100,0,5000,5000,0,0,1,1,0,0,0,0,0,9,24531,0,10,0,0,0,0,'Gavin Ward Say text 1'), +(@ENTRY*100,9,4,0,0,0,100,0,5000,5000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sabetta Ward Say text 2'), +(@ENTRY*100,9,5,0,0,0,100,0,5000,5000,0,0,1,2,0,0,0,0,0,9,24531,0,10,0,0,0,0,'Gavin Ward Say text 2'); +-- NPC talk text insert from sniff +DELETE FROM `creature_text` WHERE `entry` IN (24531,24532); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(24532,0,0, 'And I don''t want our land to have any of those horrible wolves, or giants, or ugly rams!',0,7,100,1,0,0, 'Sabetta Ward'), +(24531,0,0, 'Yes, darling. You realize you''ll be eating dire ram mutton for dinner until the crops are planted...',0,7,100,1,0,0, 'Gavin Ward'), +(24532,1,0, 'I''d sooner butcher that mule of yours! Why did you bring that beast in here, anyway?',0,7,100,5,0,0, 'Sabetta Ward'), +(24531,1,0, 'I''d rather listen to his braying than yours, dear.',0,7,100,0,0,0, 'Gavin Ward'), +(24532,2,0, 'Remember, honey, we need to get a plot of land with a nice hot spring.',0,7,100,1,0,0, 'Sabetta Ward'), +(24531,2,0, 'Of course, darling.',0,7,100,1,0,0, 'Gavin Ward'); + +-- Conversation between Brune Grayblade & Eldrim Mounder <Blacksmith>, Fort Wildervar "Brune Grayblade Envoker" +SET @ENTRY := 24528; +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@ENTRY*100; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,0,30000,60000,150000,150000,80,@ENTRY*100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Load script every 2.5 min ooc'), +(@ENTRY*100,9,0,0,0,0,100,0,5000,5000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Brune Grayblade Say text 0'), +(@ENTRY*100,9,1,0,0,0,100,0,5000,5000,0,0,1,0,0,0,0,0,0,9,24052,0,10,0,0,0,0,'Eldrim Mounder Say text 0'), +(@ENTRY*100,9,2,0,0,0,100,0,5000,5000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Brune Grayblade Say text 1'), +(@ENTRY*100,9,3,0,0,0,100,0,5000,5000,0,0,1,1,0,0,0,0,0,9,24052,0,10,0,0,0,0,'Eldrim Mounder Say text 1'), +(@ENTRY*100,9,4,0,0,0,100,0,5000,5000,0,0,1,2,0,0,0,0,0,9,24052,0,10,0,0,0,0,'Eldrim Mounder Say text 2'), +(@ENTRY*100,9,5,0,0,0,100,0,5000,5000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Brune Grayblade Say text 2'); +-- NPC talk text insert from sniff "5 sec between text 2 min between restart" +DELETE FROM `creature_text` WHERE `entry` IN (24528,24052); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(24528,0,0, 'How much''ll it cost me to get my mules shod?',0,7,100,6,0,0, 'Brune Grayblade'), +(24052,0,0, 'We don''t shoe no mules here. ''Sides, it''s strictly expedition business right now.',0,7,100,1,0,0, 'Eldrim Mounder'), +(24528,1,0, 'You don''t understand! If I''m not ready to go soon, all the good homesteading land will be taken!',0,7,100,1,0,0, 'Brune Grayblade'), +(24052,1,0, 'Not my problem! If yer so antsy to get yerself a house built, do it ''ere in the fort and quit yer whinin''!',0,7,100,274,0,0, 'Eldrim Mounder'), +(24052,2,0, 'Now, if you''d be so kind as to get your ass away from my forge...',0,7,100,25,0,0, 'Eldrim Mounder'), +(24528,2,0, 'That, sir, is a mule!',0,7,100,25,0,0, 'Brune Grayblade'); +-- Creature Template Addon info +DELETE FROM `creature_template_addon` WHERE `entry` IN (24528,24052); +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(24528,0,0,256,0, ''), +(24052,0,0,257,0, ''); diff --git a/sql/old/3.3.5a/2011_02_10_2_world_instance_oculus.sql b/sql/old/3.3.5a/2011_02_10_2_world_instance_oculus.sql new file mode 100644 index 00000000000..db52b3310fa --- /dev/null +++ b/sql/old/3.3.5a/2011_02_10_2_world_instance_oculus.sql @@ -0,0 +1,33 @@ +-- planar anomaly +DELETE FROM creature_template_addon WHERE entry=30879; +INSERT INTO creature_template_addon (`entry`,`auras`) VALUES (30879,'57971 0'); +UPDATE `creature_template` SET `InhabitType`=5 WHERE `entry`=30879; + +-- spell script target +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=57963; +INSERT INTO `conditions` (SourceTypeOrReferenceId, SourceGroup, SourceEntry, ElseGroup, ConditionTypeOrReference, ConditionValue1, ConditionValue2, ConditionValue3, ErrorTextId, ScriptName, COMMENT) VALUES +(13,0,57963,0,18,1,27656,0,0,'',NULL); + +-- not sure about this, execute at your own risk +-- DELETE FROM `creature_addon` WHERE `guid` IN (SELECT guid FROM creature WHERE `id`=28276); +-- DELETE FROM `creature` WHERE `id`=28276; + +-- here we handle which spells are usable depending on Urom's event state. +DELETE FROM `conditions` WHERE SourceTypeOrReferenceId=21 AND `SourceGroup` IN (27756,27755,27692); +INSERT INTO `conditions` (SourceTypeOrReferenceId,SourceGroup,SourceEntry,ConditionTypeOrReference,ConditionValue1,ConditionValue2) VALUES +(21,27756,50253,13,2,3), -- Ruby Drake +(21,27755,49592,13,2,3), -- Amber Drake +(21,27692,50344,13,2,3); -- Esmerald Drake + +-- correcting vehicles +UPDATE `creature_template` SET `spell1`=50232,`spell2`=50248,`spell3`=50240,`spell4`=50253,`spell5`=0 WHERE `entry`=27756; +UPDATE `creature_template` SET `spell1`=49840,`spell2`=49838,`spell3`=49592,`spell4`=0 WHERE `entry`=27755; +UPDATE `creature_template` SET `spell1`=50328,`spell2`=50341,`spell3`=50344 WHERE `entry`=27692; +UPDATE `creature_template` SET `InhabitType`=5,`speed_run`=1,`speed_walk`=1.2 WHERE `entry` IN (27756,27755,27692); + +-- eregos texts +DELETE FROM `creature_text` WHERE `entry`=27656; +INSERT INTO `creature_text` (entry,groupid,id,text,type,comment) VALUES +(27656,0,0,'You brash interlopers are out of your element! I will ground you!',1,'Boss Eregos - Aggro'), +(27656,1,0,'Such insolence... such arrogance... must be PUNISHED!',1,'Boss Eregos - Enrage'), +(27656,2,0,'Savor this small victory, foolish little creatures. You and your dragon allies have won this battle. But we will win... the Nexus War.',1,'Boss Eregos - Death'); diff --git a/sql/old/3.3.5a/2011_02_10_3_world_creature_template.sql b/sql/old/3.3.5a/2011_02_10_3_world_creature_template.sql new file mode 100644 index 00000000000..1bcf6d69dc3 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_10_3_world_creature_template.sql @@ -0,0 +1,2 @@ +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|0x00008000,`npcflag`=`npcflag`&~0x10000000 WHERE `npcflag` & 0x10000000; +UPDATE `creature_template` SET `npcflag`=`npcflag`&~0x20000000 WHERE `npcflag` & 0x20000000;
\ No newline at end of file diff --git a/sql/old/3.3.5a/2011_02_10_4_world_scriptname.sql b/sql/old/3.3.5a/2011_02_10_4_world_scriptname.sql new file mode 100644 index 00000000000..9745c5a3b0a --- /dev/null +++ b/sql/old/3.3.5a/2011_02_10_4_world_scriptname.sql @@ -0,0 +1,2 @@ +UPDATE `creature_template` SET `ScriptName`='' WHERE `ScriptName` LIKE 'guard_generic' AND (`spell1`=0 AND `spell2`=0); +UPDATE `creature_template` SET `ScriptName`='guard_generic' WHERE `ScriptName`='guard_stormwind' OR `ScriptName`='guard_orgrimmar';
\ No newline at end of file diff --git a/sql/old/3.3.5a/2011_02_11_0_world_coredevdata.sql b/sql/old/3.3.5a/2011_02_11_0_world_coredevdata.sql new file mode 100644 index 00000000000..70d360c1689 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_11_0_world_coredevdata.sql @@ -0,0 +1,45 @@ +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=29598; +INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`quest_end`,`cast_flags`) VALUES +(29598,54768,0,1,12856,1); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=54798; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`Comment`) VALUES +(13,54798,18,1,29351,1,'FLAMING Arrow Triggered Effect'), +(13,54798,18,1,29358,1,'FLAMING Arrow Triggered Effect'); + +-- Not the Blizzlike waypoints, Malcrom has those, but these are temporary +DELETE FROM `script_waypoint` WHERE `entry`=29602; +INSERT INTO `script_waypoint` (entry,pointid,location_x,location_y,location_z,waittime) VALUES +(29602,1,7085.374,-1938.052,773.318,0), +(29602,2,7085.374,-1938.052,773.318,0), +(29602,3,7065.382,-1988.499,768.9483,0), +(29602,4,7079.698,-2033.11,764.2703,0), +(29602,5,7068.746,-2081.637,758.4695,0), +(29602,6,7065.993,-2130.804,756.0863,0), +(29602,7,7088.311,-2173.474,759.4193,0), +(29602,8,7124.069,-2207.86,758.3796,0), +(29602,9,7152.243,-2248.376,759.6431,0), +(29602,10,7196.352,-2265.138,756.9138,0), +(29602,11,7234.013,-2297.475,752.4849,0), +(29602,12,7255.404,-2341.076,751.6851,0), +(29602,13,7297.881,-2368.091,751.6649,0), +(29602,14,7304.306,-2416.368,752.8918,0), +(29602,15,7320.821,-2463.647,750.8485,0), +(29602,16,7362.996,-2490.504,749.8151,0), +(29602,17,7409.486,-2475.066,751.9595,0), +(29602,18,7422.454,-2427.556,752.5062,0), +(29602,19,7407.287,-2380.342,753.0123,0), +(29602,20,7366.268,-2303.298,756.0569,0), +(29602,21,7318.561,-2301.531,754.494,0), +(29602,22,7280.997,-2270.392,756.3792,0), +(29602,23,7237.944,-2246.72,756.4333,0), +(29602,24,7193.829,-2231.046,757.992,0), +(29602,25,7159.348,-2195.307,760.6475,0), +(29602,26,7122.389,-2164.836,760.5703,0), +(29602,27,7112.455,-2116.784,759.8074,0), +(29602,28,7117.603,-2040.713,767.7001,0), +(29602,29,7107.043,-2011.189,770.1815,0), +(29602,30,7103.942,-1985.653,771.1707,0), +(29602,31,7079.7,-1966.68,769.305,0), +(29602,32,7080.018,-1948.492,771.6097,0), +(29602,33,7087.928,-1931.903,773.8726,0); diff --git a/sql/old/3.3.5a/2011_02_11_1_world_command.sql b/sql/old/3.3.5a/2011_02_11_1_world_command.sql new file mode 100644 index 00000000000..407699d6d7d --- /dev/null +++ b/sql/old/3.3.5a/2011_02_11_1_world_command.sql @@ -0,0 +1,3 @@ +UPDATE `command` SET `help` = 'Syntax: .reload all gossips\nReload gossip_menu, gossip_menu_option, gossip_scripts, points_of_interest tables.' WHERE `name` = 'reload all gossips'; +UPDATE `command` SET `help` = 'Syntax: .reload all npc\nReload npc_option, npc_trainer, npc vendor, points of interest tables.' WHERE `name` = 'reload all npc'; +DELETE FROM `command` WHERE `name` = 'reload npc_gossip'; diff --git a/sql/old/3.3.5a/2011_02_11_1_world_coredevdata.sql b/sql/old/3.3.5a/2011_02_11_1_world_coredevdata.sql new file mode 100644 index 00000000000..4f225d8c984 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_11_1_world_coredevdata.sql @@ -0,0 +1,36 @@ +DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id`=28239); +DELETE FROM `creature` WHERE `id`=28239; + +UPDATE `creature` SET `position_x`=1357.86,`position_y`=1055.26,`position_z`=463.02 WHERE `guid`=101498; +UPDATE `creature` SET `position_x`=1210.38,`position_y`=1118.57,`position_z`=471.41 WHERE `guid`=100931; + +UPDATE `creature_template` SET `flags_extra`=130 WHERE `entry`=28183; +UPDATE `creature_template` SET `scale`=1 WHERE `entry`=28183; + +DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id`=28183); +DELETE FROM `creature` WHERE `id`=28183; +-- this guids were used by the old spawns. +INSERT INTO `creature` (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType) VALUES +(100227, 28183, 578, 3, 1, 0, 0, 1242.73267, 1079.592, 439.232849, 6.108652, 120, 0, 0, 1, 0, 0, 0), +(100228, 28183, 578, 3, 1, 0, 0, 1246.566, 1051.25171, 439.232849, 0.5061455, 120, 0, 0, 1, 0, 0, 0), +(100229, 28183, 578, 3, 1, 0, 0, 1265.30212, 1109.22742, 439.232849, 5.18362761, 120, 0, 0, 1, 0, 0, 0), +(100230, 28183, 578, 3, 1, 0, 0, 1277.07471, 1027.78992, 439.232849, 1.37881, 120, 0, 0, 1, 0, 0, 0), +(100231, 28183, 578, 3, 1, 0, 0, 1293.79858, 1113.18054, 439.232849, 4.485496, 120, 0, 0, 1, 0, 0, 0), +(100232, 28183, 578, 3, 1, 0, 0, 1305.63025, 1031.75171, 439.232849, 2.042035, 120, 0, 0, 1, 0, 0, 0), +(100233, 28183, 578, 3, 1, 0, 0, 1324.38538, 1089.79688, 439.232849, 3.59537816, 120, 0, 0, 1, 0, 0, 0), +(100234, 28183, 578, 3, 1, 0, 0, 1328.00171, 1061.15283, 439.232849, 2.8972466, 120, 0, 0, 1, 0, 0, 0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (54069,56251); +INSERT INTO `conditions` (SourceTypeOrReferenceId, SourceGroup, SourceEntry, ElseGroup, ConditionTypeOrReference, ConditionValue1, ConditionValue2, ConditionValue3, ErrorTextId, ScriptName, COMMENT) VALUES +(13,0,54069,0,18,1,28183,0,0,'',NULL), +(13,0,56251,0,18,1,28183,0,0,'',NULL); + +DELETE FROM `creature_template_addon` WHERE `entry`=28183; +INSERT INTO `creature_template_addon` (entry,auras) VALUE (28183,'50798 0'); + +DELETE FROM `creature_text` WHERE `entry`=27447; +INSERT INTO `creature_text` (entry,groupid,id,TEXT,TYPE,LANGUAGE,sound) VALUES +(27447,0,0,'There will be no mercy!',1,0,13649), +(27447,1,1,'Blast them! Destroy them!',1,0,13650), +(27447,2,2,'%s calls an Azure Ring Captain!',3,0,0), +(27447,3,3,'They are... too strong! Underestimated their... fortitude.',1,0,13655); diff --git a/sql/old/3.3.5a/2011_02_11_2_world_npc_gossip.sql b/sql/old/3.3.5a/2011_02_11_2_world_npc_gossip.sql new file mode 100644 index 00000000000..18739ed1be6 --- /dev/null +++ b/sql/old/3.3.5a/2011_02_11_2_world_npc_gossip.sql @@ -0,0 +1 @@ +DROP TABLE `npc_gossip`; diff --git a/sql/old/3.3.5a/2011_02_11_3_creature_involvedrelation.sql b/sql/old/3.3.5a/2011_02_11_3_creature_involvedrelation.sql new file mode 100644 index 00000000000..c98af05803d --- /dev/null +++ b/sql/old/3.3.5a/2011_02_11_3_creature_involvedrelation.sql @@ -0,0 +1,2 @@ +-- Update quest-link turn in for quest The Call to Command (Bragor Bloodfist, not Varimathras) +UPDATE `creature_involvedrelation` SET `id`=36273 WHERE `quest`=6144; |