diff options
author | TDB Release <tdb-release@build.bot> | 2021-10-15 08:45:54 +0000 |
---|---|---|
committer | TDB Release <tdb-release@build.bot> | 2021-10-15 08:45:54 +0000 |
commit | ae9e5830bf759e5174e30cb28b7dda048dead971 (patch) | |
tree | 3bfcd49685cf57f76cb05830cb9883851a54216a /sql/old | |
parent | 9e78329c8b8294f3d4bc6e6ca4e6abfe6d53b917 (diff) |
TDB 335.21101 - 2021/10/15TDB335.21101
Diffstat (limited to 'sql/old')
26 files changed, 875 insertions, 0 deletions
diff --git a/sql/old/3.3.5a/auth/21091_2021_10_15/2021_09_28_00_auth.sql b/sql/old/3.3.5a/auth/21091_2021_10_15/2021_09_28_00_auth.sql new file mode 100644 index 00000000000..59d08fb98b4 --- /dev/null +++ b/sql/old/3.3.5a/auth/21091_2021_10_15/2021_09_28_00_auth.sql @@ -0,0 +1,2 @@ +-- TDB 335.21091 auth +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/characters/21091_2021_10_15/2021_09_28_00_characters.sql b/sql/old/3.3.5a/characters/21091_2021_10_15/2021_09_28_00_characters.sql new file mode 100644 index 00000000000..b8f2d6228f7 --- /dev/null +++ b/sql/old/3.3.5a/characters/21091_2021_10_15/2021_09_28_00_characters.sql @@ -0,0 +1,2 @@ +-- TDB 335.21091 characters +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_09_28_01_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_09_28_01_world.sql new file mode 100644 index 00000000000..59569c06bf9 --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_09_28_01_world.sql @@ -0,0 +1,3 @@ +-- TDB 335.21091 world +UPDATE `version` SET `db_version`='TDB 335.21091', `cache_id`=21091 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_09_28_02_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_09_28_02_world.sql new file mode 100644 index 00000000000..7b6cb00f1a7 --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_09_28_02_world.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_deathwhisper_dark_reckoning'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(69483,'spell_deathwhisper_dark_reckoning'); diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_00_world.sql new file mode 100644 index 00000000000..a32f8532e3f --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_00_world.sql @@ -0,0 +1,272 @@ +-- +DROP TABLE IF EXISTS `creature_movement_info`; +CREATE TABLE `creature_movement_info` ( + `MovementID` int(8) unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template.movementId value', + `WalkSpeed` float unsigned DEFAULT NULL, + `RunSpeed` float unsigned DEFAULT NULL, + PRIMARY KEY (`MovementID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO `creature_movement_info` (`MovementID`, `WalkSpeed`, `RunSpeed`) VALUES +(1,0,5), +(41,0.4,0), +(42,0.5,0), +(43,1,0), +(44,1.5,0), +(45,2,0), +(46,2.25,0), +(47,2.5,0), +(48,3,0), +(49,3.3,0), +(50,3.5,0), +(51,4,0), +(52,4.5,0), +(53,5,0), +(54,6,0), +(55,7,0), +(56,NULL,NULL), +(57,8,0), +(58,10,0), +(59,20,0), +(60,0.01,0.01), +(61,0.5,0.5), +(62,0.7,0.7), +(63,0,1), +(64,1,1), +(65,1,1.5), +(66,1.5,1.5), +(67,1.75,1.75), +(68,0,2), +(69,1,2), +(70,2,2), +(71,0,2.5), +(72,2.5,2.5), +(73,0,3), +(74,2,3), +(75,2.5,3), +(76,3,3), +(77,3.3,3.3), +(78,0,3.5), +(79,3.5,3.5), +(80,0,4), +(81,1.6,4), +(82,2,4), +(83,3,4), +(84,4,4), +(85,0,4.4), +(86,4.5,4.5), +(87,4,4.75), +(88,0,5), +(89,1,5), +(90,2,5), +(91,3,5), +(92,3.5,5), +(93,4,5), +(94,5,5), +(95,NULL,5.3), +(96,0,5.5), +(97,3,5.5), +(98,5.5,5.5), +(99,5.8,5.8), +(100,0,6), +(101,1.8,6), +(102,2,6), +(103,3,6), +(104,4,6), +(105,5,6), +(106,6,6), +(107,NULL,NULL), +(108,0,6.2), +(109,0,6.25), +(110,0,6.5), +(111,5,6.5), +(112,3,6.9), +(113,0,7), +(114,2,7), +(115,3,7), +(116,4,7), +(117,5,7), +(118,7,7), +(119,2.7,7.2), +(120,4,7.5), +(121,0,8), +(122,1,8), +(123,2,8), +(124,3,8), +(125,4,8), +(126,4.5,8), +(127,5,8), +(128,6,8), +(129,8,8), +(130,0,8.5), +(131,4,8.5), +(132,5,8.5), +(133,0,9), +(134,4,9), +(135,5,9), +(136,6,9), +(137,7,9), +(138,9,9), +(139,30,9), +(140,0,9.7), +(141,4,9.7), +(142,5,9.7), +(143,NULL,NULL), +(144,0,10), +(145,1,10), +(146,2.4,10), +(147,3,10), +(148,3.2,10), +(149,3.5,10), +(150,4,10), +(151,5,10), +(152,6,10), +(153,6.5,10), +(154,7,10), +(155,8,10), +(156,10,10), +(157,0,11), +(158,3,11), +(159,4,11), +(160,6,11), +(161,7,11), +(162,11,11), +(163,0,11.5), +(164,0,12), +(165,3,12), +(166,3.75,12), +(167,4,12), +(168,4.5,12), +(169,5,12), +(170,6,12), +(171,7,12), +(172,8,12), +(173,10,12), +(174,12,12), +(175,30,12), +(176,0,13), +(177,4,13), +(178,5,13), +(179,8,13), +(180,0,14), +(181,2,14), +(182,3,14), +(183,4,14), +(184,5,14), +(185,6,14), +(186,7,14), +(187,8,14), +(188,0,15), +(189,3,15), +(190,4,15), +(191,5,15), +(192,6,15), +(193,7,15), +(194,8,15), +(195,9,15), +(196,10,15), +(197,15,15), +(198,30,15), +(199,0,16), +(200,4,16), +(201,5,16), +(202,6,16), +(203,7,16), +(204,8,16), +(205,12,16), +(206,16,16), +(207,0,17), +(208,5,17), +(209,9,17), +(210,0,18), +(211,3.5,18), +(212,4,18), +(213,6,18), +(214,7,18), +(215,8,18), +(216,10,18), +(217,18,18), +(218,0,19), +(219,8,19), +(220,0,20), +(221,4,20), +(222,5,20), +(223,6,20), +(224,7,20), +(225,8,20), +(226,9,20), +(227,10,20), +(228,12,20), +(229,15,20), +(230,16,20), +(231,20,20), +(232,0,21), +(233,10,21), +(234,20,21), +(235,30,21), +(236,0,22), +(237,6,22), +(238,NULL,22), +(239,12,22), +(240,15,22), +(241,0,24), +(242,8,24), +(243,10,24), +(244,12,24), +(245,24,24), +(246,0,25), +(247,3,25), +(248,9,25), +(249,10,25), +(250,12,25), +(251,25,25), +(252,NULL,26), +(253,0,27), +(254,10,28), +(255,14,28), +(256,15,28), +(257,16,28), +(258,20,28), +(259,0,30), +(260,10,30), +(261,12,30), +(262,15,30), +(263,18,30), +(264,NULL,NULL), +(265,30,30), +(266,20,33), +(267,3,35), +(268,12,35), +(269,0,40), +(270,20,40), +(271,0,45), +(272,50,50), +(273,0,60), +(274,1.25,0), +(301,NULL,NULL), +(321,7,12), +(341,7,12), +(361,NULL,NULL), +(381,5,10), +(401,0,7), +(421,4.5,7), +(441,0,10), +(461,NULL,NULL), +(481,6.5,6.5), +(501,0,7), +(521,NULL,NULL), +(541,0,10), +(561,NULL,NULL), +(581,NULL,NULL), +(601,NULL,NULL), +(602,0,80), +(641,7,20), +(661,4,10), +(681,NULL,NULL), +(701,3,6.5), +(721,3,10), +(741,5,12), +(761,0,10), +(781,NULL,NULL), +(801,4,4), +(821,2,2); diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_01_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_01_world.sql new file mode 100644 index 00000000000..217ca50bfb0 --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_01_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `flags_extra` = `flags_extra` | 0x00200000 WHERE `entry` IN (20869,21586); diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_02_world_335.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_02_world_335.sql new file mode 100644 index 00000000000..6bf71977a15 --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_02_world_335.sql @@ -0,0 +1,221 @@ +-- 10567 Crear el colgante +-- https://es.tbc.wowhead.com/quest=10567 +SET @ID := 10567; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', 'En cuanto el presagista perciba tu ataque, responderá rápidamente.', 0), +(@ID, 'esMX', 'En cuanto el presagista perciba tu ataque, responderá rápidamente.', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¡Lo tienes!$B$BCon este colgante, podré acercarte a los arakkoa de Grishnath tanto que hasta podrás entender su idioma.$B$BCon esto, comprenderemos mejor a los arakkoa y la naturaleza del Cuervo. Voy a necesitar tu ayuda.', 0), +(@ID, 'esMX', '¡Lo tienes!$B$BCon este colgante, podré acercarte a los arakkoa de Grishnath tanto que hasta podrás entender su idioma.$B$BCon esto, comprenderemos mejor a los arakkoa y la naturaleza del Cuervo. Voy a necesitar tu ayuda.', 0); +-- Las tablillas de Baa'ri +-- 10568, 10683 +-- https://es.tbc.wowhead.com/quest=10568 +DELETE FROM `quest_request_items_locale` WHERE `id` IN(10568, 10683) AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(10568, 'esES', '¿Has encontrado las tablillas, $n?', 0), +(10683, 'esES', '¿Has encontrado las tablillas, $n?', 0), +(10568, 'esMX', '¿Has encontrado las tablillas, $n?', 0), +(10683, 'esMX', '¿Has encontrado las tablillas, $n?', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` IN(10568, 10683) AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(10568, 'esES', '¡Las tablillas Baa\'ri! Sí, gracias a ellas podríamos conseguir información muy útil.', 0), +(10683, 'esES', '¡Las tablillas Baa\'ri! Sí, gracias a ellas podríamos conseguir información muy útil.', 0), +(10568, 'esMX', '¡Las tablillas Baa\'ri! Sí, gracias a ellas podríamos conseguir información muy útil.', 0), +(10683, 'esMX', '¡Las tablillas Baa\'ri! Sí, gracias a ellas podríamos conseguir información muy útil.', 0); +-- 10569 Las Ruinas de Sketh'lon +-- https://es.tbc.wowhead.com/quest=10569 +SET @ID := 10569; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¿Qué has descubierto?', 0), +(@ID, 'esMX', '¿Qué has descubierto?', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '<Kieran hojea las páginas del diario.>$B$BLa mayoría es ininteligible, pero más o menos habla de preparaciones para un hechizo que salió mal, víctimas y de situación que se deteriora. También hay una curiosa nota sobre un \'desertor\'.', 0), +(@ID, 'esMX', '<Kieran hojea las páginas del diario.>$B$BLa mayoría es ininteligible, pero más o menos habla de preparaciones para un hechizo que salió mal, víctimas y de situación que se deteriora. También hay una curiosa nota sobre un \'desertor\'.', 0); +-- 10570 Perder la cabeza... por unos cardos +-- https://es.tbc.wowhead.com/quest=10570 +SET @ID := 10570; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', 'Sé breve, $gmuchacho:muchacha;.', 0), +(@ID, 'esMX', 'Sé breve, $gmuchacho:muchacha;.', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '<Borak toma la misiva que le das y empieza a leerla.>$B$B¡Vaya unos listillos! Es una directiva de Illidan que ordena dónde hay que ocultar la clave después. Al parecer, la trasladan constantemente. Y no nos dice su ubicación actual... Si pudiéramos entregar la misiva ahora que conocemos la siguiente ubicación.$B$BLástima que el sello esté roto, ahora es inservible.$B$BMmm... Aunque...', 0), +(@ID, 'esMX', '<Borak toma la misiva que le das y empieza a leerla.>$B$B¡Vaya unos listillos! Es una directiva de Illidan que ordena dónde hay que ocultar la clave después. Al parecer, la trasladan constantemente. Y no nos dice su ubicación actual... Si pudiéramos entregar la misiva ahora que conocemos la siguiente ubicación.$B$BLástima que el sello esté roto, ahora es inservible.$B$BMmm... Aunque...', 0); +-- 10571 Oronu el Anciano +-- https://es.tbc.wowhead.com/quest=10571 +SET @ID := 10571; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¿Alguna novedad, $n? El tiempo apremia.', 0), +(@ID, 'esMX', '¿Alguna novedad, $n? El tiempo apremia.', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', 'Es la mismísima letra de Akama. Es una verdadera pena lo que le ha ocurrido a alguien tan sabio y querido como él.', 0), +(@ID, 'esMX', 'Es la mismísima letra de Akama. Es una verdadera pena lo que le ha ocurrido a alguien tan sabio y querido como él.', 0); +-- 10572 Preparación de la bomba +-- https://es.tbc.wowhead.com/quest=10572 +SET @ID := 10572; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '<Le das los materiales al comandante del aire.>', 0), +(@ID, 'esMX', '<Le das los materiales al comandante del aire.>', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '<El comandante del aire inserta la batería en las placas de armadura y sella el dispositivo, asintiendo.>$B$BAquello debería funcionar. También debería provocar una explosión bastante grande, si se me permite decirlo.', 0), +(@ID, 'esMX', '<El comandante del aire inserta la batería en las placas de armadura y sella el dispositivo, asintiendo.>$B$BAquello debería funcionar. También debería provocar una explosión bastante grande, si se me permite decirlo.', 0); +-- 10573 La Forja Muerta +-- https://es.tbc.wowhead.com/quest=10573 +SET @ID := 10573; +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '<El enano asiente con la cabeza.>$B$BEstará bien contar con ese respaldo. Hemos reunido información sobre lo que puede estar tramando el Consejo de la Sombra allí pero estaré más tranquilo si podemos empezar ya a tomar represalias.', 0), +(@ID, 'esMX', '<El enano asiente con la cabeza.>$B$BEstará bien contar con ese respaldo. Hemos reunido información sobre lo que puede estar tramando el Consejo de la Sombra allí pero estaré más tranquilo si podemos empezar ya a tomar represalias.', 0); +-- 10574 Los corruptores Lengua de Ceniza +-- https://es.tbc.wowhead.com/quest=10574 +SET @ID := 10574; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¿Has conseguido los 4 trozos del medallón, $n?', 0), +(@ID, 'esMX', '¿Has conseguido los 4 trozos del medallón, $n?', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¡Eso es! Los 4 trozos del medallón. Ahora a unirlos...', 0), +(@ID, 'esMX', '¡Eso es! Los 4 trozos del medallón. Ahora a unirlos...', 0); +-- 10575 La Jaula de la Guardiana +-- https://es.tbc.wowhead.com/quest=10575 +SET @ID := 10575; +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', 'Te esperábamos, $n. Akama dijo que vendrías tarde o temprano.', 0), +(@ID, 'esMX', 'Te esperábamos, $n. Akama dijo que vendrías tarde o temprano.', 0); +-- 10576 Revuelo en Sombraluna +-- https://es.tbc.wowhead.com/quest=10576 +SET @ID := 10576; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', 'Es demasiado complicado, $r. No lo entenderías.', 0), +(@ID, 'esMX', 'Es demasiado complicado, $r. No lo entenderías.', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', 'Muy bien, $n. Espero que como actor seas igual de excelente. ¡El próximo paso de mi gran plan va a requerir algo de teatro!', 0), +(@ID, 'esMX', 'Muy bien, $n. Espero que como actor seas igual de excelente. ¡El próximo paso de mi gran plan va a requerir algo de teatro!', 0); +-- 10577 Lo que Illidan quiere, lo consigue... +-- https://es.tbc.wowhead.com/quest=10577 +SET @ID := 10577; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', 'El disfraz es delicado. Casi cualquier acción, además de caminar, interrumpirá la magia que lo mantiene unido.', 0), +(@ID, 'esMX', 'El disfraz es delicado. Casi cualquier acción, además de caminar, interrumpirá la magia que lo mantiene unido.', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', 'Ahora solo tienes que conseguir el código. Fácil, ¿no?', 0), +(@ID, 'esMX', 'Ahora solo tienes que conseguir el código. Fácil, ¿no?', 0); +-- 10578 La Clave de Condenación: La carga de Borak +-- https://es.tbc.wowhead.com/quest=10578 +SET @ID := 10578; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¡Debes actuar sin perder un minuto!', 0), +(@ID, 'esMX', '¡Debes actuar sin perder un minuto!', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¡Por fin! ¡El fragmento del código es nuestro!$B$B<Borak coloca el fragmento en una caja.>', 0), +(@ID, 'esMX', '¡Por fin! ¡El fragmento del código es nuestro!$B$B<Borak coloca el fragmento en una caja.>', 0); +-- 10579 La Clave de Condenación: Tercer trozo recuperado +-- https://es.tbc.wowhead.com/quest=10579 +SET @ID := 10579; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¡$n!', 0), +(@ID, 'esMX', '¡$n!', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', 'En cuanto los 3 fragmentos de la clave se junten, se conocerán las antiguas palabras.$B$BRecuperar este fragmento ha tenido que ser todo un reto. Mereces una recompensa por semejante heroísmo.', 0), +(@ID, 'esMX', 'En cuanto los 3 fragmentos de la clave se junten, se conocerán las antiguas palabras.$B$BRecuperar este fragmento ha tenido que ser todo un reto. Mereces una recompensa por semejante heroísmo.', 0); +-- 10580 ¿Dónde se han metido esos malditos gnomos? +-- https://es.wowhead.com/quest=10580 +SET @ID := 10580; +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¿SYLVANAAR? ¿EL COMANDANTE CIELOSOMBRA?$B$B¡ESTO NO COMPUTA!$B$B¡VETE ANTES DE QUE ME VEA OBLIGADO A TOCARTE SONIDOS ALTOS!', 0), +(@ID, 'esMX', '¿SYLVANAAR? ¿EL COMANDANTE CIELOSOMBRA?$B$B¡ESTO NO COMPUTA!$B$B¡VETE ANTES DE QUE ME VEA OBLIGADO A TOCARTE SONIDOS ALTOS!', 0); +-- 10581 Sigue el rastro +-- https://es.wowhead.com/quest=10581 +SET @ID := 10581; +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', 'Vale, ¿conque quieres echar una mano? Bien, tengo justo lo que te hace falta para demostrar tu valía.$B$BCreo que te gustará.', 0), +(@ID, 'esMX', 'Vale, ¿conque quieres echar una mano? Bien, tengo justo lo que te hace falta para demostrar tu valía.$B$BCreo que te gustará.', 0); +-- 10582 Esbirros del Consejo de la Sombra +-- https://es.wowhead.com/quest=10582 +SET @ID := 10582; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¿Ya abriste un camino hacia la Forja Muerta?', 0), +(@ID, 'esMX', '¿Ya abriste un camino hacia la Forja Muerta?', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¡Ojalá hubiera podido ir contigo! Echo de menos algo de acción con mi martillo pero mi misión es observar, no matar.$B$BAhora que has abierto un hueco en sus defensas, nos concentraremos en cerrar su línea de producción de La Forja Muerta.', 0), +(@ID, 'esMX', '¡Ojalá hubiera podido ir contigo! Echo de menos algo de acción con mi martillo pero mi misión es observar, no matar.$B$BAhora que has abierto un hueco en sus defensas, nos concentraremos en cerrar su línea de producción de La Forja Muerta.', 0); +-- 10583 El destino de Flanis +-- https://es.tbc.wowhead.com/quest=10583 +SET @ID := 10583; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¿Has encontrado algún rastro de Flanis en La Forja Muerta?', 0), +(@ID, 'esMX', '¿Has encontrado algún rastro de Flanis en La Forja Muerta?', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '<Ewan sacude la cabeza al tomar la talega que le entregas.>$B$BNo creo que Flanis se diera cuenta de lo fuertemente vigilada que estaría La Forja Muerta. Ahora que sabemos a qué se dedican allí, no me extraña. Ojalá Flanis lo hubiera sabido cuando entró.$B$BSolo espero que aquí dentro haya algo que nos ayude a cerrar La Forja Muerta de una vez por todas.', 0), +(@ID, 'esMX', '<Ewan sacude la cabeza al tomar la talega que le entregas.>$B$BNo creo que Flanis se diera cuenta de lo fuertemente vigilada que estaría La Forja Muerta. Ahora que sabemos a qué se dedican allí, no me extraña. Ojalá Flanis lo hubiera sabido cuando entró.$B$BSolo espero que aquí dentro haya algo que nos ayude a cerrar La Forja Muerta de una vez por todas.', 0); +-- 10584 Recoger transformadores de energía +-- https://es.tbc.wowhead.com/quest=10584 +SET @ID := 10584; +UPDATE `quest_template_locale` SET `ObjectiveText1` = 'Electromentales recolectados', `VerifiedBuild` = 0 WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¡Esta línea de investigación que seguimos con los electromentales es interesantísima! Imagínate... criaturas eléctricas inteligentes que podemos crear a nuestro antojo ¡y que obedecerán todas nuestras órdenes!$B$B¿Qué podría salir mal?', 0), +(@ID, 'esMX', '¡Esta línea de investigación que seguimos con los electromentales es interesantísima! Imagínate... criaturas eléctricas inteligentes que podemos crear a nuestro antojo ¡y que obedecerán todas nuestras órdenes!$B$B¿Qué podría salir mal?', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¡Excelente! Con todo este poder que has recuperado podremos mantener la maquinaria funcionando una temporada.$B$B¡El Cefirium Capacitorium es una auténtica ruina en cuanto al consumo!$B$BEspero que no fuera demasiado difícil ocuparte de esos electromentales. Estoy pensando en otra cosa de la que podrías encargarte y me parece que podría ser un poco más peligroso.', 0), +(@ID, 'esMX', '¡Excelente! Con todo este poder que has recuperado podremos mantener la maquinaria funcionando una temporada.$B$B¡El Cefirium Capacitorium es una auténtica ruina en cuanto al consumo!$B$BEspero que no fuera demasiado difícil ocuparte de esos electromentales. Estoy pensando en otra cosa de la que podrías encargarte y me parece que podría ser un poco más peligroso.', 0); +-- 10585 La cámara de invocación +-- https://es.wowhead.com/quest=10585 +SET @ID := 10585; +UPDATE `quest_template_locale` SET `ObjectiveText1` = 'Acaba con el ritual de invocacin infernal', `VerifiedBuild` = 0 WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', 'No podemos permitir que sigan con la producción. ¿Has puesto fin al ritual de invocación?', 0), +(@ID, 'esMX', 'No podemos permitir que sigan con la producción. ¿Has puesto fin al ritual de invocación?', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', 'Muy bien, $n. Al interrumpir la invocación del Consejo de la Sombra nos acercamos al cierre de La Forja Muerta.', 0), +(@ID, 'esMX', 'Muy bien, $n. Al interrumpir la invocación del Consejo de la Sombra nos acercamos al cierre de La Forja Muerta.', 0); +-- 10586 ¡Tumba al belisario! +-- https://es.wowhead.com/quest=10586 +SET @ID := 10586; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¿Qué noticias traes de La Forja Muerta?', 0), +(@ID, 'esMX', '¿Qué noticias traes de La Forja Muerta?', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '<Informas al comandante del aire y le entregas las órdenes interceptadas.>$B$BLa derrota del belisario Razuun debería suponer el final de nuestros problemas con la Legión pero según estas órdenes, su plan tiene mucho más alcance de lo que pensaba. Me temo que aún nos queda trabajo.', 0), +(@ID, 'esMX', '<Informas al comandante del aire y le entregas las órdenes interceptadas.>$B$BLa derrota del belisario Razuun debería suponer el final de nuestros problemas con la Legión pero según estas órdenes, su plan tiene mucho más alcance de lo que pensaba. Me temo que aún nos queda trabajo.', 0); +-- 10587 Patio de Armas de Karabor +-- https://es.tbc.wowhead.com/quest=10587 +SET @ID := 10587; +DELETE FROM `quest_request_items_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_request_items_locale` (`id`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES +(@ID, 'esES', '¿Has completado la tarea que te encargué, $n?', 0), +(@ID, 'esMX', '¿Has completado la tarea que te encargué, $n?', 0); +DELETE FROM `quest_offer_reward_locale` WHERE `id` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `quest_offer_reward_locale` (`id`, `locale`, `RewardText`, `VerifiedBuild`) VALUES +(@ID, 'esES', 'Examinemos estas armas, $n. Mmmm... Esto es bastante preocupante.', 0), +(@ID, 'esMX', 'Examinemos estas armas, $n. Mmmm... Esto es bastante preocupante.', 0); diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_03_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_03_world.sql new file mode 100644 index 00000000000..6562030f709 --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_03_world.sql @@ -0,0 +1,2 @@ +-- +DELETE FROM `creature_loot_template` WHERE `Entry` = 10647 AND `Item` = 5461; diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_04_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_04_world.sql new file mode 100644 index 00000000000..49929bb8f1c --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_04_world.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `command` WHERE `name` IN ('group repair','group level','group revive'); +INSERT INTO `command` (`name`,`help`) VALUES +('group repair', 'Syntax: .group repair [$charactername] Repair the given character and his group. Repair only online group characters but original selected group member can be offline. If no character is selected and name not provided, it will repair yourself.'), +('group level', 'Syntax: .group level [$charactername] Set the level of the given character and his group to #numberoflevels (only positive values 1+). Modify only online group characters level but original selected group member can be offline. All stats and dependent values are not recalculated. At level decrease talents can be reset if need. Also at level decrease equipped items with greater level requirement can be lost. If no character is selected and name not provided, it will modify your level.'), +('group revive', 'Syntax: .group revive [$charactername] Revive the given character and his group. Revive only online group characters but original selected group member can be offline. If no character is selected and name not provided, it will revive yourself.'); diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_05_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_05_world.sql new file mode 100644 index 00000000000..3de765d5bee --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_05_world.sql @@ -0,0 +1,6 @@ +-- +ALTER TABLE `creature_addon` ADD COLUMN `mountEntry` mediumint(8) unsigned NOT NULL AFTER `mount`; +ALTER TABLE `creature_template_addon` ADD COLUMN `mountEntry` mediumint(8) unsigned NOT NULL AFTER `mount`; + +UPDATE `creature_template_addon` SET `mountEntry` = 25187 WHERE `entry` = 23346; +UPDATE `creature_template_addon` SET `mountEntry` = 25182 WHERE `entry` = 23344; diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_06_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_06_world.sql new file mode 100644 index 00000000000..a85c978bdce --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_01_06_world.sql @@ -0,0 +1,3 @@ +-- +ALTER TABLE `creature_addon` CHANGE `mountEntry` `MountCreatureID` int(10) unsigned NOT NULL; +ALTER TABLE `creature_template_addon` CHANGE `mountEntry` `MountCreatureID` int(10) unsigned NOT NULL; diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_02_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_02_00_world.sql new file mode 100644 index 00000000000..71c4ce7f89b --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_02_00_world.sql @@ -0,0 +1,3 @@ +-- +UPDATE `creature_movement_info` SET `WalkSpeed` = 0 WHERE `MovementID` = 119; +UPDATE `creature_movement_info` SET `WalkSpeed` = 2.5 WHERE `MovementID` = 421; diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_00_world.sql new file mode 100644 index 00000000000..baa42f5590f --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_00_world.sql @@ -0,0 +1,42 @@ +-- +UPDATE `creature_template_addon` SET `MountCreatureID` = 24217 WHERE `entry` = 23580; +UPDATE `creature_template_addon` SET `MountCreatureID` = 3574 WHERE `entry` = 28743; +UPDATE `creature_template_addon` SET `MountCreatureID` = 14330 WHERE `entry` = 13144; +UPDATE `creature_template_addon` SET `MountCreatureID` = 14333 WHERE `entry` = 13143; +UPDATE `creature_template_addon` SET `MountCreatureID` = 25185 WHERE `entry` = 23340; +UPDATE `creature_template_addon` SET `MountCreatureID` = 19280 WHERE `entry` = 20159; +UPDATE `creature_addon` SET `MountCreatureID` = 19280 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 20159) AND `mount` = 18696; +UPDATE `creature_template_addon` SET `MountCreatureID` = 14544 WHERE `entry` = 40192; +UPDATE `creature_template_addon` SET `MountCreatureID` = 14332 WHERE `entry` IN (12783,13138,13296,13300,15541,15542,19855,21390,30231,31036); +UPDATE `creature_addon` SET `MountCreatureID` = 14332 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (12783,13138,13296,13300,15541,15542,19855,21390,30231,31036)) AND `mount` = 14337; +UPDATE `creature_template_addon` SET `MountCreatureID` = 14335 WHERE `entry` IN (13297,13318,15862,19907,25816); +UPDATE `creature_addon` SET `MountCreatureID` = 14335 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (13297,13318,15862,19907,25816)) AND `mount` = 14577; +UPDATE `creature_template_addon` SET `MountCreatureID` = 14331 WHERE `entry` IN (19905,23998,27028,27367,29302,31651); +UPDATE `creature_addon` SET `MountCreatureID` = 14331 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (19905,23998,27028,27367,29302,31651)) AND `mount` = 10719; +UPDATE `creature_template_addon` SET `MountCreatureID` = 33416 WHERE `entry` IN (33739,35330); +UPDATE `creature_template_addon` SET `MountCreatureID` = 33298 WHERE `entry` IN (33738,35332); +UPDATE `creature_template_addon` SET `MountCreatureID` = 33414 WHERE `entry` IN (33384,33749,35327); +UPDATE `creature_template_addon` SET `MountCreatureID` = 14553 WHERE `entry` IN (26907,33629); +UPDATE `creature_addon` SET `MountCreatureID` = 14553 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (26907,33629)) AND `mount` = 14374; +UPDATE `creature_template_addon` SET `MountCreatureID` = 14563 WHERE `entry` = 33558; +UPDATE `creature_template_addon` SET `MountCreatureID` = 14540 WHERE `entry` IN (15700,28613); +UPDATE `creature_template_addon` SET `MountCreatureID` = 33408 WHERE `entry` IN (33743,35329); +UPDATE `creature_template_addon` SET `MountCreatureID` = 33300 WHERE `entry` IN (33748,35325); +UPDATE `creature_template_addon` SET `MountCreatureID` = 33409 WHERE `entry` IN (33520,33521,33744,35314); +UPDATE `creature_addon` SET `MountCreatureID` = 33409 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (31564)) AND `mount` = 29260; +UPDATE `creature_template_addon` SET `MountCreatureID` = 33299 WHERE `entry` IN (33745,35323,39173,39654,40391); +UPDATE `creature_template_addon` SET `MountCreatureID` = 33418 WHERE `entry` IN (33746,35326); +UPDATE `creature_template_addon` SET `MountCreatureID` = 35148 WHERE `entry` = 35589; +UPDATE `creature_template_addon` SET `MountCreatureID` = 35362 WHERE `entry` IN (26007); +UPDATE `creature_addon` SET `MountCreatureID` = 35362 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (26007)) AND `mount` = 29794; +UPDATE `creature_template_addon` SET `MountCreatureID` = 39938 WHERE `entry` = 39103; +UPDATE `creature_template_addon` SET `MountCreatureID` = 39973 WHERE `entry` = 39837; +UPDATE `creature_template_addon` SET `MountCreatureID` = 40057 WHERE `entry` = 39271; +UPDATE `creature_template_addon` SET `MountCreatureID` = 40415 WHERE `entry` = 40416; +UPDATE `creature_template_addon` SET `MountCreatureID` = 34156 WHERE `entry` IN (11701,11702); +UPDATE `creature_addon` SET `MountCreatureID` = 34156 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (11701,11702)) AND `mount` = 29102; +UPDATE `creature_template_addon` SET `MountCreatureID` = 34017 WHERE `entry` = 33561; +UPDATE `creature_template_addon` SET `MountCreatureID` = 22000 WHERE `entry` IN (21719,22006,22197,22274,23321,23440,23441); +UPDATE `creature_addon` SET `MountCreatureID` = 22000 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (21719,22006,22197,22274,23321,23440,23441)) AND `mount` = 20684; +UPDATE `creature_template_addon` SET `MountCreatureID` = 21627 WHERE `entry` IN (19806,22018); +UPDATE `creature_addon` SET `MountCreatureID` = 21627 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (19806,22018)) AND `mount` = 20937; diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_01_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_01_world.sql new file mode 100644 index 00000000000..dc31b2c5ced --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_01_world.sql @@ -0,0 +1,48 @@ +-- Sky Terror +UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 28246; +DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 28246); +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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(28246, 0, 0, 0, 0, 0, 100, 0, 5000, 10000, 10000, 15000, 0, 11, 31273, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Terror - In Combat - Cast 'Screech'"); + +-- Carrion Eater +UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 28022; +DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 28022); +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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(28022, 0, 0, 0, 0, 0, 100, 0, 5000, 10000, 9000, 16000, 0, 11, 54387, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Carrion Eater - In Combat - Cast 'Ravenous Claw'"); + +-- Drakkari Native +UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 29211; +DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 29211); +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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(29211, 0, 0, 0, 2, 0, 100, 0, 0, 30, 30000, 35000, 0, 11, 51307, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Drakkari Native - In Combat - Cast 'Unwavering Will'"); + +-- Hath'ar Skimmer +UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 28258; +DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 28258); +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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(28258, 0, 0, 0, 0, 0, 100, 0, 3000, 6000, 6000, 12000, 0, 11, 54487, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Hath'ar Skimmer - In Combat - Cast 'Jump Attack'"); + +-- Decomposed Ghoul +UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 31812; +DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 31812); +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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(31812, 0, 0, 0, 2, 0, 100, 1, 0, 30, 0, 0, 0, 11, 15716, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Decomposed Ghoul - Between 0-30% Health - Cast 'Enrage'"), +(31812, 0, 1, 0, 0, 0, 100, 0, 3000, 12000, 3000, 12000, 0, 11, 12097, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Decomposed Ghoul - In Combat - Cast 'Pierce Armor'"); + +-- Frostskull Magus +UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 31813; +DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 31813); +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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(31813, 0, 0, 0, 0, 0, 100, 0, 0, 6000, 6000, 10000, 0, 11, 20297, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Frostskull Magus - In Combat - Cast 'Frostbolt'"); + +-- Myst Leecher +UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 17523; +DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 17523); +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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(17523, 0, 0, 0, 0, 0, 100, 0, 3000, 9000, 10000, 18000, 0, 11, 31288, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Myst Leecher - In Combat - Cast 'Leech Poison'"); + +-- Skoll (Oops ,seems this rare in wotlk had just pounce) +DELETE FROM `smart_scripts` WHERE (`entryorguid` = 35189) AND (`source_type` = 0) AND (`id` IN (1)); + +-- Loque'nahak (Oops ,same) +DELETE FROM `smart_scripts` WHERE (`entryorguid` = 32517) AND (`source_type` = 0) AND (`id` IN (1)); diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_02_world_335.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_02_world_335.sql new file mode 100644 index 00000000000..72b57300516 --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_04_02_world_335.sql @@ -0,0 +1,7 @@ +-- +UPDATE `gameobject` a INNER JOIN `gameobject_addon` b ON a.`guid` = b.`guid` SET +`rotation0` = `parent_rotation0`, +`rotation1` = `parent_rotation1`, +`rotation2` = `parent_rotation2`, +`rotation3` = `parent_rotation3` WHERE a.`id` IN (19569,19570,19571); +DELETE FROM `gameobject_addon` WHERE `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` IN (19569,19570,19571)); diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_07_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_07_00_world.sql new file mode 100644 index 00000000000..fe6cc6dddcc --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_07_00_world.sql @@ -0,0 +1,21 @@ +-- +DELETE FROM `spell_script_names` WHERE `spell_id` IN (19548,19674,19687,19688,19689,19692,19693,19694,19696,19697,19699,19700,30646,30653,30654,30099,30102,30105) AND `ScriptName` = 'spell_quest_taming_the_beast'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(19548,'spell_quest_taming_the_beast'), +(19674,'spell_quest_taming_the_beast'), +(19687,'spell_quest_taming_the_beast'), +(19688,'spell_quest_taming_the_beast'), +(19689,'spell_quest_taming_the_beast'), +(19692,'spell_quest_taming_the_beast'), +(19693,'spell_quest_taming_the_beast'), +(19694,'spell_quest_taming_the_beast'), +(19696,'spell_quest_taming_the_beast'), +(19697,'spell_quest_taming_the_beast'), +(19699,'spell_quest_taming_the_beast'), +(19700,'spell_quest_taming_the_beast'), +(30646,'spell_quest_taming_the_beast'), +(30653,'spell_quest_taming_the_beast'), +(30654,'spell_quest_taming_the_beast'), +(30099,'spell_quest_taming_the_beast'), +(30102,'spell_quest_taming_the_beast'), +(30105,'spell_quest_taming_the_beast'); diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_00_world.sql new file mode 100644 index 00000000000..f848ee97abb --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_00_world.sql @@ -0,0 +1,5 @@ +-- +UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 29753; +DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 29753); +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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(29753, 0, 0, 0, 0, 0, 100, 0, 3000, 6000, 9000, 12000, 0, 11, 57833, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Stormpeak Wyrm - In Combat - Cast 'Frost Spit'"); diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_01_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_01_world.sql new file mode 100644 index 00000000000..89697c6468a --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_01_world.sql @@ -0,0 +1,7 @@ +-- Fix Quest 308 "Distracting Jarven" +UPDATE `smart_scripts` SET `action_param1`=0, `action_param2`=0 WHERE `entryorguid`=1373 AND `source_type`=0 AND `id`=3; +UPDATE `smart_scripts` SET `action_param1`=46,`action_param2`=0 WHERE `entryorguid`=1373 AND `source_type`=0 AND `id`=4; +UPDATE `smart_scripts` SET `target_type`=8, `target_o`=0.977384 WHERE `entryorguid`=1373 AND `source_type`=0 AND `id`=11; +DELETE FROM `smart_scripts` WHERE `entryorguid`=1373 AND `source_type`=0 AND `id`=12; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`event_type`,`event_chance`,`event_param1`,`action_type`,`action_param1`,`action_param2`,`target_type`,`comment`) VALUES +(1373,0,12,40,100,13,133,1,1037,1, "Jarven Thunderbrew - On WP 13 Reached - Respawn Closest Gameobject 'Guarded Thunder Ale Barrel'"); diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_02_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_02_world.sql new file mode 100644 index 00000000000..59b306e96ea --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_08_02_world.sql @@ -0,0 +1,3 @@ +-- Add script to 3 revealers outside Ironforge +UPDATE `creature` SET `ScriptName` = "npc_brewfest_reveler_2" WHERE `guid` IN (47648,86731,84899); +UPDATE `creature_addon` SET `emote` = 0 WHERE `guid` IN (47648,86731); diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_09_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_09_00_world.sql new file mode 100644 index 00000000000..052636740a8 --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_09_00_world.sql @@ -0,0 +1,4 @@ +-- Stormwind graveyard for the Alliance +UPDATE `graveyard_zone` SET `ID`=106, `Comment`='Elwynn Forest, Goldshire - Stormwind' WHERE `ID`=107 AND `GhostZone`=1519; +-- Champions' Hall is no longer a separate zone +DELETE FROM `graveyard_zone` WHERE `ID`=107 AND `GhostZone`=2918; diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_09_01_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_09_01_world.sql new file mode 100644 index 00000000000..136f32181c5 --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_09_01_world.sql @@ -0,0 +1,11 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid` = 2491600 AND `source_type` = 9; +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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(2491600,9,0,0,0,0,100,0,0,0,0,0,0,11,44943,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Flare - Action list - cast"), +(2491600,9,1,0,0,0,100,0,0,0,0,0,0,3,24958,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Flare - Action list - morph"), +(2491600,9,2,0,0,0,100,0,0,0,0,0,0,28,44880,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Flare - Action list - Remove aura"), +(2491600,9,3,0,0,0,100,0,0,0,0,0,0,11,46196,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Flare - Action list - Add aura"), +(2491600,9,4,0,0,0,100,0,0,0,0,0,0,69,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Flare - Action list - Hackily stop follow movement"), +(2491600,9,5,0,0,0,100,0,1000,1000,0,0,0,53,1,24916,0,0,500,3,1,0,0,0,0,0,0,0,0,"Flare - Action list - Start way point"); + +UPDATE `creature_template` SET `unit_flags` = 33536 WHERE `entry` = 24937; diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_10_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_10_00_world.sql new file mode 100644 index 00000000000..306f3ca200f --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_10_00_world.sql @@ -0,0 +1,3 @@ +-- +ALTER TABLE `creature_addon` MODIFY COLUMN `MountCreatureID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template_addon` MODIFY COLUMN `MountCreatureID` int(10) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_12_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_12_00_world.sql new file mode 100644 index 00000000000..bd8cb88174a --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_12_00_world.sql @@ -0,0 +1,9 @@ +-- +UPDATE `creature` SET `position_x` = 6561.05 WHERE `guid` = 137720 AND `id` = 30407; +UPDATE `creature` SET `position_x` = 6580.62, `position_y` = 599.204, `position_z` = 419.185, `orientation` = 0.523599 WHERE `guid` = 137723 AND `id` = 30407; +UPDATE `creature` SET `position_x` = 6596.29, `position_y` = 636.413, `position_z` = 407.354, `orientation` = 4.50295 WHERE `guid` = 137721 AND `id` = 30407; +UPDATE `creature` SET `position_y` = 654.944 WHERE `guid` = 137722 AND `id` = 30407; + +DELETE FROM `creature` WHERE `guid` = 83065 AND `id` = 30407; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES +(83065,30407,571,0,0,1,2,0,0,6599.8,569.418,401.956,4.43314,300,0,0,1,0,0,0,0,0,'',0); diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_12_01_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_12_01_world.sql new file mode 100644 index 00000000000..c215e20599c --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_12_01_world.sql @@ -0,0 +1,94 @@ +-- +DELETE FROM `waypoints` WHERE `entry` = 20129; +DELETE FROM `waypoints` WHERE `entry` BETWEEN 2012900 AND 2012905; +INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`point_comment`) VALUES +(2012900,1,-8383.2,-4244.22,-206.636,0,0,"Custodian of Time"), +(2012900,2,-8401.54,-4229.18,-206.776,0,0,"Custodian of Time"), +(2012900,3,-8431.32,-4205.24,-209.299,0,0,"Custodian of Time"), +(2012900,4,-8446.2,-4199.22,-211.198,0,0,"Custodian of Time"), + +(2012901,1,-8458.11,-4211.28,-213.04,0,0,"Custodian of Time"), +(2012901,2,-8474.04,-4211.07,-214.483,0,0,"Custodian of Time"), +(2012901,3,-8496.17,-4213.95,-214.466,0,0,"Custodian of Time"), +(2012901,4,-8535.09,-4218.91,-213.081,0,0,"Custodian of Time"), +(2012901,5,-8570.05,-4231.13,-211.343,0,0,"Custodian of Time"), +(2012901,6,-8598.16,-4247.17,-210.842,0,0,"Custodian of Time"), +(2012901,7,-8627.35,-4268.63,-210.4,0,0,"Custodian of Time"), + +(2012902,1,-8621.29,-4292.29,-210.653,0,0,"Custodian of Time"), +(2012902,2,-8607.38,-4337.51,-211.931,0,0,"Custodian of Time"), + +(2012903,1,-8577.15,-4359.43,-214.543,0,0,"Custodian of Time"), +(2012903,2,-8561.28,-4380.34,-215.375,0,0,"Custodian of Time"), +(2012903,3,-8540.86,-4399.46,-216.243,0,0,"Custodian of Time"), +(2012903,4,-8523.85,-4407.74,-216.447,0,0,"Custodian of Time"), + +(2012904,1,-8488.36,-4429.71,-215.938,0,0,"Custodian of Time"), +(2012904,2,-8443.82,-4427.04,-213.414,0,0,"Custodian of Time"), +(2012904,3,-8409.72,-4412.88,-211.283,0,0,"Custodian of Time"), +(2012904,4,-8379.64,-4393.75,-208.275,0,0,"Custodian of Time"), +(2012904,5,-8359.08,-4369.81,-208.167,0,0,"Custodian of Time"), +(2012904,6,-8358.58,-4360.84,-208.144,0,0,"Custodian of Time"), + +(2012905,1,-8363,-4342.1,-208.549,0,0,"Custodian of Time"), +(2012905,2,-8367.57,-4306.75,-209.519,0,0,"Custodian of Time"), +(2012905,3,-8374,-4286.13,-208.73,0,0,"Custodian of Time"); + +DELETE FROM `smart_scripts` WHERE `entryorguid` = 20129 AND `source_type` = 0; +DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN 2012900 AND 2012906 AND `source_type` = 9; +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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(20129,0,0,0,11,0,100,0,0,0,0,0,0,80,2012900,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Spawn - Run Script"), +(20129,0,1,0,58,0,100,0,0,2012900,0,0,0,80,2012901,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Waypoint Finished - Run Script"), +(20129,0,2,0,58,0,100,0,0,2012901,0,0,0,80,2012902,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Waypoint Finished - Run Script"), +(20129,0,3,0,58,0,100,0,0,2012902,0,0,0,80,2012903,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Waypoint Finished - Run Script"), +(20129,0,4,0,58,0,100,0,0,2012903,0,0,0,80,2012904,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Waypoint Finished - Run Script"), +(20129,0,5,0,58,0,100,0,0,2012904,0,0,0,80,2012905,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Waypoint Finished - Run Script"), +(20129,0,6,0,58,0,100,0,0,2012905,0,0,0,80,2012906,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Waypoint Finished - Run Script"), + +(2012900,9,0,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Set Orientation Owner"), +(2012900,9,1,0,0,0,100,0,0,0,0,0,0,11,17321,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Cast 'Spirit Spawn-in'"), +(2012900,9,2,0,0,0,100,0,2000,2000,0,0,0,1,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 0"), +(2012900,9,3,0,0,0,100,0,10000,10000,0,0,0,1,1,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 1"), +(2012900,9,4,0,0,0,100,0,15000,15000,0,0,0,1,2,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 2"), +(2012900,9,5,0,0,0,100,0,11000,11000,0,0,0,1,3,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 3"), +(2012900,9,6,0,0,0,100,0,2000,2000,0,0,0,53,0,2012900,0,0,0,3,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Start Waypoint"), + +(2012901,9,1,0,0,0,100,0,2000,2000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Set Orientation Owner"), +(2012901,9,2,0,0,0,100,0,1000,1000,0,0,0,1,4,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 4"), +(2012901,9,3,0,0,0,100,0,10000,10000,0,0,0,1,5,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 5"), +(2012901,9,4,0,0,0,100,0,15000,15000,0,0,0,1,6,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 6"), +(2012901,9,5,0,0,0,100,0,10000,10000,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0,1.46607,"Custodian of Time - On Script - Set Orientation"), +(2012901,9,6,0,0,0,100,0,1000,1000,0,0,0,1,7,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 7"), +(2012901,9,7,0,0,0,100,0,6000,6000,0,0,0,5,25,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Play Emote 25"), +(2012901,9,8,0,0,0,100,0,12000,12000,0,0,0,1,8,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 8"), +(2012901,9,9,0,0,0,100,0,7000,7000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Set Orientation Owner"), +(2012901,9,10,0,0,0,100,0,1000,1000,0,0,0,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Play Emote 1"), +(2012901,9,11,0,0,0,100,0,14000,14000,0,0,0,1,3,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 3"), +(2012901,9,12,0,0,0,100,0,6000,6000,0,0,0,53,0,2012901,0,0,0,3,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Start Waypoint"), + +(2012902,9,1,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0,2.58308,"Custodian of Time - On Script - Set Orientation"), +(2012902,9,2,0,0,0,100,0,2000,2000,0,0,0,5,25,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Play Emote 25"), +(2012902,9,3,0,0,0,100,0,2000,2000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Set Orientation Owner"), +(2012902,9,4,0,0,0,100,0,1000,1000,0,0,0,1,9,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 9"), +(2012902,9,5,0,0,0,100,0,10000,10000,0,0,0,1,3,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 3"), +(2012902,9,6,0,0,0,100,0,6000,6000,0,0,0,53,0,2012902,0,0,0,3,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Start Waypoint"), + +(2012903,9,1,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0,3.92699,"Custodian of Time - On Script - Set Orientation"), +(2012903,9,2,0,0,0,100,0,1000,1000,0,0,0,1,10,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 10"), +(2012903,9,3,0,0,0,100,0,3000,3000,0,0,0,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Play Emote 1"), +(2012903,9,4,0,0,0,100,0,6000,6000,0,0,0,53,0,2012903,0,0,0,3,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Start Waypoint"), + +(2012904,9,1,0,0,0,100,0,1000,1000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Set Orientation Owner"), +(2012904,9,2,0,0,0,100,0,2000,2000,0,0,0,1,11,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 11"), +(2012904,9,3,0,0,0,100,0,20000,20000,0,0,0,1,3,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 3"), +(2012904,9,4,0,0,0,100,0,6000,6000,0,0,0,53,0,2012904,0,0,0,3,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Start Waypoint"), + +(2012905,9,1,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0,0.19198,"Custodian of Time - On Script - Set Orientation"), +(2012905,9,2,0,0,0,100,0,1000,1000,0,0,0,1,12,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 12"), +(2012905,9,3,0,0,0,100,0,10000,10000,0,0,0,1,3,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 3"), +(2012905,9,4,0,0,0,100,0,6000,6000,0,0,0,53,0,2012905,0,0,0,3,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Start Waypoint"), + +(2012906,9,0,0,0,0,100,0,1000,1000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Set Orientation Owner"), +(2012906,9,1,0,0,0,100,0,1000,1000,0,0,0,1,13,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 13"), +(2012906,9,2,0,0,0,100,0,0,0,0,0,0,11,34883,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Cast 'QID 10277'"), +(2012906,9,3,0,0,0,100,0,6000,6000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Despawn"); diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_13_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_13_00_world.sql new file mode 100644 index 00000000000..190ed06a9a9 --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_13_00_world.sql @@ -0,0 +1,7 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid`=26261 AND `source_type`=0 AND `id` IN(0,4); +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 +(26261, 0, 0, 4, 8, 0, 100, 1, 47394, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Grizzly Hills Giant - On Spellhit \'Kurun\'s Blessing\' - Store Target'), +(26261, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, 2626100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grizzly Hills Giant - On Spellhit \'Kurun\'s Blessing\' - Run Script'); + +UPDATE `smart_scripts` SET `target_type`=12, `target_param1`=1 WHERE `entryorguid`=2626100 AND `source_type`=9 AND `id`=0 AND `link`=0; diff --git a/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_14_00_world.sql b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_14_00_world.sql new file mode 100644 index 00000000000..03e46e4e8bf --- /dev/null +++ b/sql/old/3.3.5a/world/21091_2021_10_15/2021_10_14_00_world.sql @@ -0,0 +1,88 @@ +-- +DELETE FROM `creature_equip_template` WHERE `CreatureID` = 18794; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 18794 AND `source_type` = 0; +DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN 1879400 AND 1879403 AND `source_type` = 9; +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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(18794,0,0,0,25,0,100,0,0,0,0,0,0,11,32958,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cabal Ritualist - On Reset - Cast 'Crystal Channel'"), +(18794,0,1,0,11,0,100,0,0,0,0,0,0,88,1879400,1879403,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cabal Ritualist - On Spawn - Run Random Script"), +(18794,0,2,0,4,0,10,0,0,0,0,0,0,1,0,0,1,0,0,0,7,0,0,0,0,0,0,0,0,"Cabal Ritualist - On Aggro - Say Line 0"), + +(18794,0,3,0,0,1,100,2,0,0,3400,4500,0,11,15497,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Cabal Ritualist - In Combat CMC - Cast 'Frostbolt' (Normal Dungeon) (Phase 1)"), +(18794,0,4,0,0,1,100,4,0,0,3400,4500,0,11,12675,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Cabal Ritualist - In Combat CMC - Cast 'Frostbolt' (Heroic Dungeon) (Phase 1)"), +(18794,0,5,0,0,1,100,2,10000,18000,12100,16900,0,11,15532,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cabal Ritualist - In Combat - Cast 'Frost Nova' (Normal Dungeon) (Phase 1)"), +(18794,0,6,0,0,1,100,4,10000,18000,12100,16900,0,11,15063,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cabal Ritualist - In Combat - Cast 'Frost Nova' (Normal Dungeon) (Phase 1)"), + +(18794,0,7,0,0,2,100,2,0,0,5000,5000,0,11,33832,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Cabal Ritualist - In Combat CMC - Cast 'Arcane Missiles' (Normal Dungeon) (Phase 2)"), +(18794,0,8,0,0,2,100,4,0,0,5000,5000,0,11,38263,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Cabal Ritualist - In Combat CMC - Cast 'Arcane Missiles' (Heroic Dungeon) (Phase 2)"), +(18794,0,9,0,0,2,100,0,2400,14300,5200,21700,0,11,33487,0,0,0,0,0,5,0,0,0,0,0,0,0,0,"Cabal Ritualist - In Combat - Cast 'Addle Humanoid' (Phase 2)"), + +(18794,0,10,0,0,4,100,0,3600,6200,4800,11200,0,11,9574,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Cabal Ritualist - In Combat - Cast 'Flame Buffet' (Phase 3)"), +(18794,0,11,0,0,4,100,2,6100,20200,8400,22900,0,11,20795,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Cabal Ritualist - In Combat - Cast 'Fire Blast' (Normal Dungeon) (Phase 3)"), +(18794,0,12,0,0,4,100,4,6100,20200,8400,22900,0,11,14145,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Cabal Ritualist - In Combat - Cast 'Fire Blast' (Heroic Dungeon) (Phase 3)"), + +(18794,0,13,0,0,8,100,0,10000,15000,12100,19300,0,11,12540,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Cabal Ritualist - In Combat - Cast 'Gouge' (Phase 4)"), + +(18794,0,14,0,15,0,100,4,15,15000,20000,0,0,11,17201,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Cabal Ritualist - Friendly Crowd Controlled - Cast 'Dispel Magic' (Heroic Dungeon)"), +(18794,0,15,0,2,0,100,1,0,15,0,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Cabal Ritualist - Between 0-15% Health - Flee For Assist (No Repeat)"), + +(1879400,9,0,0,0,0,100,0,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cabal Ritualist - On Script - Set Event Phase 1"), +(1879400,9,1,0,0,0,100,0,0,0,0,0,0,71,0,1,12421,0,0,0,1,0,0,0,0,0,0,0,0,"Cabal Ritualist - On Script - Set Mainhand Item"), + +(1879401,9,0,0,0,0,100,0,0,0,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cabal Ritualist - On Script - Set Event Phase 2"), +(1879401,9,1,0,0,0,100,0,0,0,0,0,0,71,0,1,14618,0,0,0,1,0,0,0,0,0,0,0,0,"Cabal Ritualist - On Script - Set Mainhand Item"), + +(1879402,9,0,0,0,0,100,0,0,0,0,0,0,22,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cabal Ritualist - On Script - Set Event Phase 3"), +(1879402,9,1,0,0,0,100,0,0,0,0,0,0,71,0,1,13718,0,0,0,1,0,0,0,0,0,0,0,0,"Cabal Ritualist - On Script - Set Mainhand Item"), + +(1879403,9,0,0,0,0,100,0,0,0,0,0,0,22,4,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cabal Ritualist - On Script - Set Event Phase 4"), +(1879403,9,1,0,0,0,100,0,0,0,0,0,0,71,0,1,19980,0,0,0,1,0,0,0,0,0,0,0,0,"Cabal Ritualist - On Script - Set Mainhand Item"), +(1879403,9,2,0,0,0,100,0,0,0,0,0,0,71,0,2,0,19980,0,0,1,0,0,0,0,0,0,0,0,"Cabal Ritualist - On Script - Set Offhand Item"); + +-- +DELETE FROM `creature_equip_template` WHERE `CreatureID` = 19167 AND `ID` BETWEEN 2 AND 5; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 19167 AND `source_type` = 0; +DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN 1916700 AND 1916703 AND `source_type` = 9; +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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(19167,0,0,0,11,0,100,0,0,0,0,0,0,11,35191,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Spawn - Cast 'Arcane Explosion Proc'"), +(19167,0,1,0,4,0,100,0,0,0,0,0,0,88,1916700,1916703,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Aggro - Run Random Script"), +(19167,0,2,0,0,3,100,0,7200,10600,12100,22900,0,11,35189,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - In Combat - Cast 'Solar Strike' (Phase 1, 2)"), +(19167,0,3,0,0,12,100,0,7700,7700,10900,21700,0,11,15708,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - In Combat - Cast 'Mortal Strike' (Phase 3, 4)"), +(19167,0,4,0,0,0,100,0,9800,22900,10900,26500,0,11,13736,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - In Combat - Cast 'Whirlwind'"), + +(1916700,9,0,0,0,0,100,0,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Set Event Phase 1"), +(1916700,9,1,0,0,0,100,0,0,0,0,0,0,71,0,1,29407,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Set Mainhand Item"), +(1916700,9,2,0,0,0,100,0,0,0,0,0,0,28,35191,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Remove Aura 'Arcane Explosion Proc'"), +(1916700,9,3,0,0,0,100,0,0,0,0,0,0,11,35192,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Cast 'Melt Armor Proc'"), + +(1916701,9,0,0,0,0,100,0,0,0,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Set Event Phase 2"), +(1916701,9,1,0,0,0,100,0,0,0,0,0,0,71,0,1,29408,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Set Mainhand Item"), +(1916701,9,2,0,0,0,100,0,0,0,0,0,0,28,35191,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Remove Aura 'Arcane Explosion Proc'"), +(1916701,9,3,0,0,0,100,0,0,0,0,0,0,11,35193,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Cast 'Seed of Corruption Proc'"), + +(1916702,9,0,0,0,0,100,0,0,0,0,0,0,22,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Set Event Phase 3"), +(1916702,9,1,0,0,0,100,0,0,0,0,0,0,71,0,1,29409,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Set Mainhand Item"), +(1916702,9,2,0,0,0,100,0,0,0,0,0,0,28,35191,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Remove Aura 'Arcane Explosion Proc'"), +(1916702,9,3,0,0,0,100,0,0,0,0,0,0,11,35188,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Cast 'Chilling Touch'"), + +(1916703,9,0,0,0,0,100,0,0,0,0,0,0,22,4,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Set Event Phase 4"), +(1916703,9,1,0,0,0,100,0,0,0,0,0,0,71,0,1,29410,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Slayer - On Script - Set Mainhand Item"); + +-- +DELETE FROM `creature_equip_template` WHERE `CreatureID` = 19510 AND `ID` BETWEEN 2 AND 5; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 19510 AND `source_type` = 0; +DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN 1951000 AND 1951003 AND `source_type` = 9; +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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(19510,0,0,0,4,0,100,0,0,0,0,0,0,88,1951000,1951003,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Centurion - On Aggro - Run Random Script"), +(19510,0,1,0,0,0,100,0,6200,19300,12100,16900,0,11,35178,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Bloodwarder Centurion - In Combat - Cast 'Shield Bash'"), + +(1951000,9,0,0,0,0,100,0,0,0,0,0,0,71,0,1,29403,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Centurion - On Script - Set Mainhand Item"), +(1951000,9,1,0,0,0,100,0,0,0,0,0,0,11,35186,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Centurion - On Script - Cast 'Melt Armor Proc'"), + +(1951001,9,0,0,0,0,100,0,0,0,0,0,0,71,0,1,29404,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Centurion - On Script - Set Mainhand Item"), +(1951001,9,1,0,0,0,100,0,0,0,0,0,0,11,35187,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Centurion - On Script - Cast 'Arcane Explosion Proc'"), + +(1951002,9,0,0,0,0,100,0,0,0,0,0,0,71,0,1,29405,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Centurion - On Script - Set Mainhand Item"), +(1951002,9,1,0,0,0,100,0,0,0,0,0,0,11,35188,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Centurion - On Script - Cast 'Chilling Touch'"), + +(1951003,9,0,0,0,0,100,0,0,0,0,0,0,71,0,1,29406,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Centurion - On Script - Set Mainhand Item"), +(1951003,9,1,0,0,0,100,0,0,0,0,0,0,11,35184,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bloodwarder Centurion - On Script - Cast 'Unstable Affliction Proc'"); |