diff options
Diffstat (limited to 'sql/old')
31 files changed, 1476 insertions, 0 deletions
diff --git a/sql/old/3.3.5a/auth/20081_2020_08_22/2020_08_15_00_auth.sql b/sql/old/3.3.5a/auth/20081_2020_08_22/2020_08_15_00_auth.sql new file mode 100644 index 00000000000..9a33bcc953f --- /dev/null +++ b/sql/old/3.3.5a/auth/20081_2020_08_22/2020_08_15_00_auth.sql @@ -0,0 +1,2 @@ +-- TDB 335.20081 auth +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/characters/20081_2020_08_22/2020_08_15_00_characters.sql b/sql/old/3.3.5a/characters/20081_2020_08_22/2020_08_15_00_characters.sql new file mode 100644 index 00000000000..156854247e1 --- /dev/null +++ b/sql/old/3.3.5a/characters/20081_2020_08_22/2020_08_15_00_characters.sql @@ -0,0 +1,2 @@ +-- TDB 335.20081 characters +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_15_06_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_15_06_world.sql new file mode 100644 index 00000000000..139364a07b5 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_15_06_world.sql @@ -0,0 +1,3 @@ +-- TDB 335.20081 world +UPDATE `version` SET `db_version`='TDB 335.20081', `cache_id`=20081 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_00_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_00_world.sql new file mode 100644 index 00000000000..3718ba29005 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_00_world.sql @@ -0,0 +1,2 @@ +-- +INSERT IGNORE INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) SELECT 1,1,`guid` FROM `gameobject` WHERE `spawntimesecs` < 0; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_01_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_01_world_335.sql new file mode 100644 index 00000000000..9602d21c286 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_01_world_335.sql @@ -0,0 +1,237 @@ +-- 289 La tripulación maldita +-- https://es.classic.wowhead.com/quest=289 +SET @ID := 289; +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 mis sueños a veces escucho los gemidos de mis hermanos! Por favor señor, libéralos de sus ataduras y termina con sus lamentos.', 0), +(@ID, 'esMX', '¡En mis sueños a veces escucho los gemidos de mis hermanos! Por favor señor, libéralos de sus ataduras y termina con sus lamentos.', 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', 'Muchas gracias, $n. Recibe también la gratitud de mis hermanos malditos.', 0), +(@ID, 'esMX', 'Muchas gracias, $n. Recibe también la gratitud de mis hermanos malditos.', 0); +-- 470 Abriéndose paso entre los mocos +-- https://es.classic.wowhead.com/quest=470 +SET @ID := 470; +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', '¿Encontraste mi bolsa?', 0), +(@ID, 'esMX', '¿Encontraste mi bolsa?', 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', '¡Oh, gracias, $n! ¡Creía que la había perdido para siempre!$B$BUmm... esto ya no me vale de mucho, pero lávalo y estoy segura de que te será muy útil.', 0), +(@ID, 'esMX', '¡Oh, gracias, $n! ¡Creía que la había perdido para siempre!$B$BUmm... esto ya no me vale de mucho, pero lávalo y estoy segura de que te será muy útil.', 0); +-- 278 Se aproxima una oscura amenaza +-- https://es.classic.wowhead.com/quest=278 +SET @ID := 278; +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', '¿Tienes lo que te pedí? ¡Es muy urgente!', 0), +(@ID, 'esMX', '¿Tienes lo que te pedí? ¡Es muy urgente!', 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', '¡Justo a tiempo, $n!', 0), +(@ID, 'esMX', '¡Justo a tiempo, $n!', 0); +-- 280 Se aproxima una oscura amenaza +-- https://es.classic.wowhead.com/quest=280 +SET @ID := 280; +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', 'La tapa del barril se desliza lentamente.', 0), +(@ID, 'esMX', 'La tapa del barril se desliza lentamente.', 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 barril crepita un poco al verter la mezcla neutralizadora.', 0), +(@ID, 'esMX', 'El barril crepita un poco al verter la mezcla neutralizadora.', 0); +-- 283 Se aproxima una oscura amenaza +-- https://es.classic.wowhead.com/quest=283 +SET @ID := 283; +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', '¡Gracias, $n! Sin tu ayuda, la presa habría saltado en pedazos. Gracias en nombre del Reino y de la Alianza, $c.$B$BEstamos a salvo... al menos de momento.', 0), +(@ID, 'esMX', '¡Gracias, $n! Sin tu ayuda, la presa habría saltado en pedazos. Gracias en nombre del Reino y de la Alianza, $c.$B$BEstamos a salvo... al menos de momento.', 0); +-- 465 La estrategia de Nek'rosh +-- https://es.classic.wowhead.com/quest=465 +SET @ID := 465; +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', 'La primera catapulta está ante ti. ¿Vas a prenderle fuego?', 0), +(@ID, 'esMX', 'La primera catapulta está ante ti. ¿Vas a prenderle fuego?', 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', 'Colocas algo de yesca en la catapulta y haces saltar una chispa.$B$B¡Aparece una llama que se extiende rápidamente!', 0), +(@ID, 'esMX', 'Colocas algo de yesca en la catapulta y haces saltar una chispa.$B$B¡Aparece una llama que se extiende rápidamente!', 0); +-- 305 La búsqueda del equipo de excavación +-- https://es.classic.wowhead.com/quest=305 +SET @ID := 305; +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', 'Oh, ¡loados sean los cielos! ¡Estás aquí!', 0), +(@ID, 'esMX', 'Oh, ¡loados sean los cielos! ¡Estás aquí!', 0); +-- 294 La venganza de Ormer +-- https://es.classic.wowhead.com/quest=294 +SET @ID := 294; +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', 'Mata a 10 estridadores jaspeados y 10 raptores jaspeados, $n. Mis compañeros de trabajo no se merecían el destino que les tocó. Es hora de igualar el marcador.', 0), +(@ID, 'esMX', 'Mata a 10 estridadores jaspeados y 10 raptores jaspeados, $n. Mis compañeros de trabajo no se merecían el destino que les tocó. Es hora de igualar el marcador.', 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', 'Matar es un negocio sucio, pero has hecho muy bien tu trabajo, $n. Si no tuviera que permanecer junto al prospector y a Merrin estaría a tu lado vertiendo sangre.', 0), +(@ID, 'esMX', 'Matar es un negocio sucio, pero has hecho muy bien tu trabajo, $n. Si no tuviera que permanecer junto al prospector y a Merrin estaría a tu lado vertiendo sangre.', 0); +-- 306 La búsqueda del equipo de excavación +-- https://es.classic.wowhead.com/quest=306 +SET @ID := 306; +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 podido encontrar a Merrin? ¿Ha enviado algún mensaje?', 0), +(@ID, 'esMX', '¿Has podido encontrar a Merrin? ¿Ha enviado algún mensaje?', 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', '¡Qué noticias tan horribles! Al menos tres sobrevivieron. ¿Cuándo terminarán las muertes? Anhelo el día en el que los súbditos del rey Magni puedan vivir libres de miedo.', 0), +(@ID, 'esMX', '¡Qué noticias tan horribles! Al menos tres sobrevivieron. ¿Cuándo terminarán las muertes? Anhelo el día en el que los súbditos del rey Magni puedan vivir libres de miedo.', 0); +-- 299 Desvelando el pasado +-- https://es.classic.wowhead.com/quest=299 +SET @ID := 299; +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 has descubierto los cuatro fragmentos, $n? Ados, Modr, Golm y Neru...', 0), +(@ID, 'esMX', '¿Ya has descubierto los cuatro fragmentos, $n? Ados, Modr, Golm y Neru...', 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', '¡Ah, la piedra Goaz está completa! Buen trabajo, $n. Buen trabajo, sin duda. Ahora puedo seguir con la trascripción de este escrito de los Titanes. ¡Ya puedo descifrar nuevas palabras! Umm... aquí dice, "Dioses antiguos... encadenados bajo la tierra." Esto debe ser el comienzo de algún relato épico.', 0), +(@ID, 'esMX', '¡Ah, la piedra Goaz está completa! Buen trabajo, $n. Buen trabajo, sin duda. Ahora puedo seguir con la trascripción de este escrito de los Titanes. ¡Ya puedo descifrar nuevas palabras! Umm... aquí dice, "Dioses antiguos... encadenados bajo la tierra." Esto debe ser el comienzo de algún relato épico.', 0); +-- 295 La venganza de Ormer +-- https://es.classic.wowhead.com/quest=295 +SET @ID := 295; +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', 'Quiero hacer que esos raptores segadores jaspeados y raptores tajobuches jaspeados paguen por lo que hicieron. ¿Has matado a 10 de cada uno?', 0), +(@ID, 'esMX', 'Quiero hacer que esos raptores segadores jaspeados y raptores tajobuches jaspeados paguen por lo que hicieron. ¿Has matado a 10 de cada uno?', 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', '¡Hiciste un trabajo fenomenal eliminando a esos raptores, $n!', 0), +(@ID, 'esMX', '¡Hiciste un trabajo fenomenal eliminando a esos raptores, $n!', 0); +-- 296 La venganza de Ormer +-- https://es.classic.wowhead.com/quest=296 +SET @ID := 296; +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', '¿Está muerto Sarldente? ¿Has redimido la memoria de los caídos?', 0), +(@ID, 'esMX', '¿Está muerto Sarldente? ¿Has redimido la memoria de los caídos?', 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', 'Gracias, $n. No olvidaremos tus esfuerzos. Muchos enanos inocentes murieron en este lugar mientras se limitaban a hacer su trabajo. Has hecho que la venganza caiga sobre esas malvadas criaturas. Se lo pensarán dos veces antes de volver a atacar a los súbditos del rey Magni.', 0), +(@ID, 'esMX', 'Gracias, $n. No olvidaremos tus esfuerzos. Muchos enanos inocentes murieron en este lugar mientras se limitaban a hacer su trabajo. Has hecho que la venganza caiga sobre esas malvadas criaturas. Se lo pensarán dos veces antes de volver a atacar a los súbditos del rey Magni.', 0); +-- 474 Derrota a Nek'rosh +-- https://es.classic.wowhead.com/quest=474 +SET @ID := 474; +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 matado a Nek\'rosh?', 0), +(@ID, 'esMX', '¿Has matado a Nek\'rosh?', 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 has hecho con gran resolución, $n. Has dado un golpe contundente al clan orco de los Faucedraco. Quizás nunca se recuperen. Y la destrucción de las catapultas han hecho de Puerto de Menethil un lugar mucho más seguro.$B$BTus méritos son innegables, y el reino de Forjaz sabe recompensar a quienes le sirven.', 0), +(@ID, 'esMX', 'Lo has hecho con gran resolución, $n. Has dado un golpe contundente al clan orco de los Faucedraco. Quizás nunca se recuperen. Y la destrucción de las catapultas han hecho de Puerto de Menethil un lugar mucho más seguro.$B$BTus méritos son innegables, y el reino de Forjaz sabe recompensar a quienes le sirven.', 0); +-- 276 Patas sucias +-- https://es.classic.wowhead.com/quest=276 +SET @ID := 276; +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', 'Aún tienes que completar tu misión, joven $c.', 0), +(@ID, 'esMX', 'Aún tienes que completar tu misión, joven $c.', 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', 'Al reducir el número de gnolls has cuidado de la salud de Los Humedales. Aunque mi fe en tu pueblo fue puesta a prueba en el pasado, $r, quizás ahora se recupere.', 0), +(@ID, 'esMX', 'Al reducir el número de gnolls has cuidado de la salud de Los Humedales. Aunque mi fe en tu pueblo fue puesta a prueba en el pasado, $r, quizás ahora se recupere.', 0); +-- 277 No al fuego +-- https://es.classic.wowhead.com/quest=277 +SET @ID := 277; +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', '¿Tienes las herramientas gnoll para hacer fuego?', 0), +(@ID, 'esMX', '¿Tienes las herramientas gnoll para hacer fuego?', 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', '... Gracias. Romperé estos pedernales y los lanzaré al mar para que nunca más puedan ser usados para prender fuego a madera viva.', 0), +(@ID, 'esMX', '... Gracias. Romperé estos pedernales y los lanzaré al mar para que nunca más puedan ser usados para prender fuego a madera viva.', 0); +-- 275 Ampollas en la tierra +-- https://es.classic.wowhead.com/quest=275 +SET @ID := 275; +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', 'Los humedales todavía lloran y los trepadores del pantano todavía se enfurecen. Regresa a mí cuando hayas terminado tu tarea.', 0), +(@ID, 'esMX', 'Los humedales todavía lloran y los trepadores del pantano todavía se enfurecen. Regresa a mí cuando hayas terminado tu tarea.', 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', 'Tus esfuerzos han aliviado a esta tierra, recibirás algo muy provechoso.', 0), +(@ID, 'esMX', 'Tus esfuerzos han aliviado a esta tierra, recibirás algo muy provechoso.', 0); +-- 281 Recuperación de bienes +-- https://es.classic.wowhead.com/quest=281 +SET @ID := 281; +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 cajón está cubierto de arañazos y está dañado por el agua. Cuando lo abres descubres paja empapada y podrida, como si hubiera habido algo de valor guardado en el cajón. Buscas por la paja...$B$B... y encuentras un puñado de botellas de color rojo.', 0), +(@ID, 'esMX', 'El cajón está cubierto de arañazos y está dañado por el agua. Cuando lo abres descubres paja empapada y podrida, como si hubiera habido algo de valor guardado en el cajón. Buscas por la paja...$B$B... y encuentras un puñado de botellas de color rojo.', 0); +-- 324 Los lingotes perdidos +-- https://es.classic.wowhead.com/quest=324 +SET @ID := 324; +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 el hierro Forjaluz que necesitas?', 0), +(@ID, 'esMX', '¿Has encontrado el hierro Forjaluz que necesitas?', 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', '¡Ah, los encontraste! ¡Vamos a fundir este hierro Forjaluz en algo útil!, ¿qué te parece?', 0), +(@ID, 'esMX', '¡Ah, los encontraste! ¡Vamos a fundir este hierro Forjaluz en algo útil!, ¿qué te parece?', 0); +-- 322 Brazo bendito +-- https://es.classic.wowhead.com/quest=322 +SET @ID := 322; +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 qué te podrían servir mis conocimientos, $c?', 0), +(@ID, 'esMX', '¿En qué te podrían servir mis conocimientos, $c?', 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', '¡Menuda historia la tuya! ¡Y tienes hierro Forjaluz! Hace años que no trabajo con ese metal. Será un honor trabajar con él otra vez. Vuelve a verme luego para contarme la historia de tu batalla contra el Necromántico.$B$BPero estamos yendo demasiado deprisa. Antes de nada, tu arma contra Morbent Vil...', 0), +(@ID, 'esMX', '¡Menuda historia la tuya! ¡Y tienes hierro Forjaluz! Hace años que no trabajo con ese metal. Será un honor trabajar con él otra vez. Vuelve a verme luego para contarme la historia de tu batalla contra el Necromántico.$B$BPero estamos yendo demasiado deprisa. Antes de nada, tu arma contra Morbent Vil...', 0); +-- 1448 En búsqueda del templo +-- https://es.classic.wowhead.com/quest=1448 +SET @ID := 1448; +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', 'He viajado por el mundo desde las selvas de Azeroth hasta los picos nevados de Khaz Modan.$B$BNunca antes había pedido ayuda en mis aventuras. Pero mis viejos huesos están cansados.$B$BNada me dejaría más satisfecho que saber que completé mi búsqueda final de la Liga de Expedicionarios.$B$BSi tuvieras la amabilidad de ayudarme a buscar el Templo de Atal\'Hakkar, $c, te lo agradecería mucho.$B$B¡Explora el Pantano de las Penas e informame de tus hallazgos!', 0), +(@ID, 'esMX', 'He viajado por el mundo desde las selvas de Azeroth hasta los picos nevados de Khaz Modan.$B$BNunca antes había pedido ayuda en mis aventuras. Pero mis viejos huesos están cansados.$B$BNada me dejaría más satisfecho que saber que completé mi búsqueda final de la Liga de Expedicionarios.$B$BSi tuvieras la amabilidad de ayudarme a buscar el Templo de Atal\'Hakkar, $c, te lo agradecería mucho.$B$B¡Explora el Pantano de las Penas e informame de tus hallazgos!', 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 Templo de Atal\'Hakkar está sumergido bajo la Charca de Lágrimas? ¿Y rodeado del Vuelo Verde?$B$BUn descubrimiento increíble, $c. Pero, obviamente, algo ha salido terriblemente mal.', 0), +(@ID, 'esMX', '¿El Templo de Atal\'Hakkar está sumergido bajo la Charca de Lágrimas? ¿Y rodeado del Vuelo Verde?$B$BUn descubrimiento increíble, $c. Pero, obviamente, algo ha salido terriblemente mal.', 0); +-- 325 Armado y listo +-- https://es.classic.wowhead.com/quest=325 +SET @ID := 325; +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', 'Hola, $n. No hace tanto que te fuiste y, sin embargo, veo un fuego en tus ojos que no había visto antes.', 0), +(@ID, 'esMX', 'Hola, $n. No hace tanto que te fuiste y, sin embargo, veo un fuego en tus ojos que no había visto antes.', 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', 'Ah, ¡esto será perfecto para el malvado Morbent Vil! ¡Bien hecho!$B$BYa estás preparado. Morbent Vil caerá.', 0), +(@ID, 'esMX', 'Ah, ¡esto será perfecto para el malvado Morbent Vil! ¡Bien hecho!$B$BYa estás preparado. Morbent Vil caerá.', 0); +-- 1363 La orden de Mazen +-- https://es.classic.wowhead.com/quest=1363 +SET @ID := 1363; +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', 'No fue culpa mía. En serio, no fue culpa mía.', 0), +(@ID, 'esMX', 'No fue culpa mía. En serio, no fue culpa mía.', 0); +-- 1364 La orden de Mazen +-- https://es.classic.wowhead.com/quest=1364 +SET @ID := 1364; +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é te trae por el Castillo de Nethergarde, $r?', 0), +(@ID, 'esMX', '¿Qué te trae por el Castillo de Nethergarde, $r?', 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', '¡Ah, estupendo!$B$BDurante un tiempo temí que el maestro Mazen de la Academia de Artes y Ciencias Arcanas hubiese olvidado mi pedido de los ensayos de Khadgar sobre convergencia dimensional.$B$BDebe de tener muchísimas peticiones teniendo en cuenta los extraños sucesos que están teniendo lugar.$B$BAhora, si me disculpas, tengo que comenzar con mi investigación. Llegar a comprender por fin a alguien tan grandioso como Khadgar me excita en gran medida.', 0), +(@ID, 'esMX', '¡Ah, estupendo!$B$BDurante un tiempo temí que el maestro Mazen de la Academia de Artes y Ciencias Arcanas hubiese olvidado mi pedido de los ensayos de Khadgar sobre convergencia dimensional.$B$BDebe de tener muchísimas peticiones teniendo en cuenta los extraños sucesos que están teniendo lugar.$B$BAhora, si me disculpas, tengo que comenzar con mi investigación. Llegar a comprender por fin a alguien tan grandioso como Khadgar me excita en gran medida.', 0); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_02_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_02_world.sql new file mode 100644 index 00000000000..f49bf28b1f7 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_02_world.sql @@ -0,0 +1,16 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` IN (56711,56713); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,56711,0,0,31,0,3,30413,132012,0,0,0,"","Group 0: Spell 'Image Channel' targets creature 'Channel Image Target'"), +(13,1,56713,0,0,31,0,3,30413,132013,0,0,0,"","Group 0: Spell 'Image Channel' targets creature 'Channel Image Target'"); + +DELETE FROM `smart_scripts` WHERE `entryorguid` = 30111 AND `source_type` = 0 AND `id` IN (4,5); +DELETE FROM `smart_scripts` WHERE `entryorguid` = 30179 AND `source_type` = 0 AND `id` IN (4,5); +DELETE FROM `smart_scripts` WHERE `entryorguid` = 30319 AND `source_type` = 0 AND `id` IN (5,6); +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 +(30111,0,4,0,1,0,100,1,1000,1000,0,0,0,11,56711,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Twilight Worshipper - Out of Combat - Cast 'Image Channel' (No Repeat)"), +(30111,0,5,0,1,0,100,1,1000,1000,0,0,0,11,56713,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Twilight Worshipper - Out of Combat - Cast 'Image Channel' (No Repeat)"), +(30179,0,4,0,1,0,100,1,1000,1000,0,0,0,11,56711,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Twilight Apostle - Out of Combat - Cast 'Image Channel' (No Repeat)"), +(30179,0,5,0,1,0,100,1,1000,1000,0,0,0,11,56713,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Twilight Apostle - Out of Combat - Cast 'Image Channel' (No Repeat)"), +(30319,0,5,0,1,0,100,1,1000,1000,0,0,0,11,56711,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Twilight Darkcaster - Out of Combat - Cast 'Image Channel' (No Repeat)"), +(30319,0,6,0,1,0,100,1,1000,1000,0,0,0,11,56713,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Twilight Darkcaster - Out of Combat - Cast 'Image Channel' (No Repeat)"); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_03_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_03_world.sql new file mode 100644 index 00000000000..d058a7b51f8 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_03_world.sql @@ -0,0 +1,2 @@ +-- Remove SMARTCAST_INTERRUPT_PREVIOUS from nearly all scripts +UPDATE `smart_scripts` SET `action_param2` = `action_param2` &~1 WHERE `event_type` IN (0,2,3,4,9,11,12,13,14,15,16,19,22,23,25,62,63,74) AND `event_flags` & 1 = 0 AND `action_type` = 11 AND `source_type` = 0 AND `action_param2` & 1; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_04_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_04_world_335.sql new file mode 100644 index 00000000000..cb8260b37ff --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_04_world_335.sql @@ -0,0 +1,151 @@ +-- +UPDATE `areatrigger_teleport` SET /*`name`='Gundrak - Entrance Target A (Mammoth)',*/`target_position_x`=1880.74, `target_position_y`=853.76, `target_position_z`=176.696, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=5205; -- WSL 3865 +UPDATE `areatrigger_teleport` SET /*`name`='Violet Hold - Entrance Target',*/`target_position_x`=1806.37, `target_position_y`=803.374, `target_position_z`=44.3647, `target_orientation`=0, `VerifiedBuild`=15882 WHERE `id`=5209; -- WSL 3867 +UPDATE `areatrigger_teleport` SET /*`name`='Violet Hold - Exit Target',*/`target_position_x`=5682.51, `target_position_y`=489.276, `target_position_z`=652.299, `target_orientation`=0.890118, `VerifiedBuild`=15882 WHERE `id`=5211; -- WSL 3868 +UPDATE `areatrigger_teleport` SET /*`name`='Lower City - Exit Target',*/`target_position_x`=3641.17, `target_position_y`=2031.15, `target_position_z`=2.59325, `target_orientation`=1.22173, `VerifiedBuild`=15882 WHERE `id`=5213; -- WSL 3869 +UPDATE `areatrigger_teleport` SET /*`name`='Gundrak - Exit Target A (Mammoth)',*/`target_position_x`=6717.32, `target_position_y`=-4645.55, `target_position_z`=450.017, `target_orientation`=0.785398, `VerifiedBuild`=15882 WHERE `id` IN (5231, 5276); -- WSL 3871, 3880 +UPDATE `areatrigger_teleport` SET /*`name`='Gundrak - Exit Target B (Snake)',*/`target_position_x`=6955.24, `target_position_y`=-4416.92, `target_position_z`=450.447, `target_orientation`=3.92699, `VerifiedBuild`=15882 WHERE `id` IN (5233, 5277); -- WSL 3872, 3881 +UPDATE `areatrigger_teleport` SET /*`name`='Wintergrasp Raid - Teleport Target',*/`target_position_x`=-507.946, `target_position_y`=-103.067, `target_position_z`=157, `target_orientation`=0, `VerifiedBuild`=15882 WHERE `id`=5258; -- WSL 3878 +UPDATE `areatrigger_teleport` SET /*`name`='Wintergrasp Raid - Teleport Target - Exit',*/`target_position_x`=5485.52, `target_position_y`=2840.14, `target_position_z`=420.037, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=5262; -- WSL 3879 +UPDATE `areatrigger_teleport` SET /*`name`='Eye of Eternity - Port In Loc',*/`target_position_x`=728.055, `target_position_y`=1329.03, `target_position_z`=275, `target_orientation`=5.51524, `VerifiedBuild`=15882 WHERE `id`=5290; -- WSL 3882 +UPDATE `areatrigger_teleport` SET `name`='Dire Maul - East Entrance Target 01', `target_position_x`=47.4501, `target_position_y`=-153.665, `target_position_z`=-2.71439, `target_orientation`=5.49779, `VerifiedBuild`=15882 WHERE `id`=3183; -- WSL 3682 +UPDATE `areatrigger_teleport` SET `name`='Dire Maul - East Entrance Target 02', `target_position_x`=-203.166, `target_position_y`=-322.997, `target_position_z`=-2.72467, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=3184; -- WSL 3683 +UPDATE `areatrigger_teleport` SET `name`='Dire Maul - East Entrance Target 03', `target_position_x`=10.5786, `target_position_y`=-836.991, `target_position_z`=-32.3988, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=3185; -- WSL 3684 +UPDATE `areatrigger_teleport` SET `name`='Dire Maul - West Entrance Target 01', `target_position_x`=-65.6559, `target_position_y`=159.561, `target_position_z`=-3.4647, `target_orientation`=2.35619, `VerifiedBuild`=15882 WHERE `id`=3186; -- WSL 3685 +UPDATE `areatrigger_teleport` SET `name`='Dire Maul - West Entrance Target 02', `target_position_x`=33.1083, `target_position_y`=158.977, `target_position_z`=-3.47126, `target_orientation`=0.785398, `VerifiedBuild`=15882 WHERE `id`=3187; -- WSL 3686 +UPDATE `areatrigger_teleport` SET `name`='Dire Maul - North Entrance Target 02', `target_position_x`=254.92, `target_position_y`=-19.463, `target_position_z`=-2.5596, `target_orientation`=5.49779, `VerifiedBuild`=15882 WHERE `id`=3189; -- WSL 3687 +UPDATE `areatrigger_teleport` SET `name`='Dire Maul - West Exit Target 01', `target_position_x`=-3812.76, `target_position_y`=1250.33, `target_position_z`=160.273, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=3190; -- WSL 3688 +UPDATE `areatrigger_teleport` SET `name`='Dire Maul - West Exit Target 02', `target_position_x`=-3766.57, `target_position_y`=1249.48, `target_position_z`=160.273, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=3191; -- WSL 3689 +UPDATE `areatrigger_teleport` SET `name`='Dire Maul - North Exit Target 02', `target_position_x`=-3520.07, `target_position_y`=1100.1, `target_position_z`=161.027, `target_orientation`=1.5708, `VerifiedBuild`=15882 WHERE `id`=3193; -- WSL 3690 +UPDATE `areatrigger_teleport` SET `name`='Dire Maul - East Exit Target 01', `target_position_x`=-3768.78, `target_position_y`=935.179, `target_position_z`=161.027, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=3194; -- WSL 3691 +UPDATE `areatrigger_teleport` SET `name`='Dire Maul - East Exit Target 02', `target_position_x`=-3980.81, `target_position_y`=801.198, `target_position_z`=161.012, `target_orientation`=1.5708, `VerifiedBuild`=15882 WHERE `id`=3195; -- WSL 3692 +UPDATE `areatrigger_teleport` SET `name`='Dire Maul - East Exit Target 03', `target_position_x`=-4031.25, `target_position_y`=129.345, `target_position_z`=26.4744, `target_orientation`=2.70526, `VerifiedBuild`=15882 WHERE `id`=3196; -- WSL 3693 +UPDATE `areatrigger_teleport` SET `name`='Dire Maul - East Exit Target 04', `target_position_x`=-3585.84, `target_position_y`=847.367, `target_position_z`=138.641, `target_orientation`=2.35619, `VerifiedBuild`=15882 WHERE `id`=3197; -- WSL 3694 +UPDATE `areatrigger_teleport` SET `name`='Maraudon - Purple Exit Target', `target_position_x`=-1183.87, `target_position_y`=2876.53, `target_position_z`=85.8458, `target_orientation`=1.65806, `VerifiedBuild`=15882 WHERE `id`=3126; -- WSL 3678 +UPDATE `areatrigger_teleport` SET `name`='Maraudon - Orange Exit Target', `target_position_x`=-1471.77, `target_position_y`=2616.09, `target_position_z`=76.301, `target_orientation`=6.10865, `VerifiedBuild`=15882 WHERE `id`=3131; -- WSL 3679 +UPDATE `areatrigger_teleport` SET `name`='Maraudon - Orange Entrance Target', `target_position_x`=1016.83, `target_position_y`=-458.52, `target_position_z`=-43.4737, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=3133; -- WSL 3680 +UPDATE `areatrigger_teleport` SET `name`='Maraudon - Purple Entrance Target', `target_position_x`=755.078, `target_position_y`=-617.696, `target_position_z`=-32.9222, `target_orientation`=1.5708, `VerifiedBuild`=15882 WHERE `id`=3134; -- WSL 3681 +UPDATE `areatrigger_teleport` SET /*`name`='Molten Core Entrance Target',*/`target_position_x`=1091.89, `target_position_y`=-466.985, `target_position_z`=-105.084, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id` IN (2886, 3528, 3529); -- WSL 3676, 3695, 3696 +UPDATE `areatrigger_teleport` SET /*`name`='Onyxia''s Lair Entrance Target',*/`target_position_x`=30.8916, `target_position_y`=-54.079, `target_position_z`=-5.02784, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=2848; -- WSL 3675 +UPDATE `areatrigger_teleport` SET /*`name`='Alterac Valley - Horde Exit Target',*/`target_position_x`=536.495, `target_position_y`=-1085.72, `target_position_z`=106.27, `target_orientation`=3.66519, `VerifiedBuild`=15882 WHERE `id`=2606; -- WSL 3673 +UPDATE `areatrigger_teleport` SET /*`name`='Alterac Valley - Alliance Exit Target',*/`target_position_x`=101.144, `target_position_y`=-184.934, `target_position_z`=127.344, `target_orientation`=4.88692, `VerifiedBuild`=15882 WHERE `id`=2608; -- WSL 3674 +UPDATE `areatrigger_teleport` SET /*`name`='Orgrimmar - Barracks Exit Target 001',*/`target_position_x`=1637.91, `target_position_y`=-4240.25, `target_position_z`=56.1744, `target_orientation`=3.92699, `VerifiedBuild`=15882 WHERE `id`=2530; -- WSL 3666 +UPDATE `areatrigger_teleport` SET /*`name`='Stormwind - Barracks Exit Target 001',*/`target_position_x`=-8762.82, `target_position_y`=402.434, `target_position_z`=103.901, `target_orientation`=5.49779, `VerifiedBuild`=15882 WHERE `id`=2534; -- WSL 3667 +UPDATE `areatrigger_teleport` SET /*`name`='OrgrimmarInstance Exit Target 001',*/`target_position_x`=1813.15, `target_position_y`=-4415.75, `target_position_z`=-18.2856, `target_orientation`=2.00713, `VerifiedBuild`=15882 WHERE `id`=2226; -- WSL 3656 +-- Looks incorrect +-- UPDATE `areatrigger_teleport` SET /*`name`='OrgrimmarInstance Entrance Target 001',*/`target_position_x`=0.797643, `target_position_y`=-8.23429, `target_position_z`=-15.5288, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=2230; -- WSL 3657 +UPDATE `areatrigger_teleport` SET /*`name`='Scarlet Monastery Entrance Target 01',*/`target_position_x`=1687.27, `target_position_y`=1050.09, `target_position_z`=18.6773, `target_orientation`=1.5708, `VerifiedBuild`=15882 WHERE `id`=45; -- WSL 3597 +-- UPDATE `areatrigger_teleport` SET /*`name`='Stormwind Jail Entrance Target',*/`target_position_x`=48.9849, `target_position_y`=0.483882, `target_position_z`=-16.3942, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=101; -- WSL 3599 +UPDATE `areatrigger_teleport` SET /*`name`='Stormwind High Prison Exit Target',*/`target_position_x`=-8661.57, `target_position_y`=616.574, `target_position_z`=86.1877, `target_orientation`=5.49779, `VerifiedBuild`=15882 WHERE `id`=109; -- WSL 3600 +UPDATE `areatrigger_teleport` SET /*`name`='Shadowfang Bridge Exit Target',*/`target_position_x`=-232.594, `target_position_y`=1567.67, `target_position_z`=76.8845, `target_orientation`=4.36332, `VerifiedBuild`=15882 WHERE `id`=194; -- WSL 3603 +UPDATE `areatrigger_teleport` SET /*`name`='Wailing Caverns Exit Target',*/`target_position_x`=-738.462, `target_position_y`=-2217.8, `target_position_z`=16.919, `target_orientation`=6.02139, `VerifiedBuild`=15882 WHERE `id`=226; -- WSL 3604 +UPDATE `areatrigger_teleport` SET /*`name`='Razorfen Exit Target',*/`target_position_x`=-4462, `target_position_y`=-1663.06, `target_position_z`=81.8912, `target_orientation`=3.92699, `VerifiedBuild`=15882 WHERE `id`=242; -- WSL 3606 +UPDATE `areatrigger_teleport` SET /*`name`='Razorfen Entrance Target',*/`target_position_x`=1942.27, `target_position_y`=1544.23, `target_position_z`=83.3055, `target_orientation`=1.309, `VerifiedBuild`=15882 WHERE `id`=244; -- WSL 3607 +UPDATE `areatrigger_teleport` SET /*`name`='Blackfathom Exit Target',*/`target_position_x`=4248.14, `target_position_y`=745.047, `target_position_z`=-24.4963, `target_orientation`=4.36332, `VerifiedBuild`=15882 WHERE `id`=259; -- WSL 3609 +UPDATE `areatrigger_teleport` SET /*`name`='Uldaman Entrance Target',*/`target_position_x`=-228.859, `target_position_y`=46.1018, `target_position_z`=-46.0186, `target_orientation`=1.5708, `VerifiedBuild`=15882 WHERE `id`=286; -- WSL 3610 +UPDATE `areatrigger_teleport` SET /*`name`='Uldaman Exit Target',*/`target_position_x`=-6066.36, `target_position_y`=-2954.85, `target_position_z`=209.772, `target_orientation`=3.1765, `VerifiedBuild`=15882 WHERE `id`=288; -- WSL 3611 +UPDATE `areatrigger_teleport` SET /*`name`='Razorfen Downs Exit Target',*/`target_position_x`=-4659.44, `target_position_y`=-2527.94, `target_position_z`=81.6564, `target_orientation`=1.0472, `VerifiedBuild`=15882 WHERE `id`=444; -- WSL 3615 +-- Changed in Cata +-- UPDATE `areatrigger_teleport` SET /*`name`='Sunken Temple Entrance Target',*/`target_position_x`=-328.474, `target_position_y`=95.3291, `target_position_z`=-91.0008, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=446; -- WSL 3616 +-- UPDATE `areatrigger_teleport` SET /*`name`='Sunken Temple Exit Target',*/`target_position_x`=-10291.1, `target_position_y`=-3984.65, `target_position_z`=-70.4401, `target_orientation`=1.29154, `VerifiedBuild`=15882 WHERE `id`=448; -- WSL 3617 +UPDATE `areatrigger_teleport` SET /*`name`='Stormwind Low Prison Exit Target',*/`target_position_x`=-8766.11, `target_position_y`=845.499, `target_position_z`=87.9952, `target_orientation`=3.83972, `VerifiedBuild`=15882 WHERE `id`=503; -- WSL 3618 +UPDATE `areatrigger_teleport` SET /*`name`='Gnomeregan Entrance 02 Target',*/`target_position_x`=-733.636, `target_position_y`=1.86838, `target_position_z`=-249.09, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=523; -- WSL 3619 +-- Changed in Cata +-- UPDATE `areatrigger_teleport` SET /*`name`='Gnomeregan Exit 02 Target',*/`target_position_x`=-4915.38, `target_position_y`=811.773, `target_position_z`=268.77, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=525; -- WSL 3620 +UPDATE `areatrigger_teleport` SET /*`name`='Darnassus Entrance Target',*/`target_position_x`=9946.25, `target_position_y`=2612.97, `target_position_z`=1316.49, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=542; -- WSL 3622 +UPDATE `areatrigger_teleport` SET /*`name`='Scarlet Monastery Exit Target 01',*/`target_position_x`=2915.34, `target_position_y`=-801.58, `target_position_z`=160.333, `target_orientation`=3.49066, `VerifiedBuild`=15882 WHERE `id`=602; -- WSL 3623 +UPDATE `areatrigger_teleport` SET /*`name`='Scarlet Monastery Exit Target 02',*/`target_position_x`=2915.13, `target_position_y`=-823.637, `target_position_z`=160.327, `target_orientation`=3.49066, `VerifiedBuild`=15882 WHERE `id`=604; -- WSL 3624 +UPDATE `areatrigger_teleport` SET /*`name`='Scarlet Monastery Exit Target 03',*/`target_position_x`=2885.96, `target_position_y`=-835.802, `target_position_z`=160.327, `target_orientation`=0.349066, `VerifiedBuild`=15882 WHERE `id`=606; -- WSL 3625 +UPDATE `areatrigger_teleport` SET /*`name`='Scarlet Monastery Exit Target 04',*/`target_position_x`=2869.32, `target_position_y`=-820.818, `target_position_z`=160.333, `target_orientation`=0.349066, `VerifiedBuild`=15882 WHERE `id`=608; -- WSL 3626 +UPDATE `areatrigger_teleport` SET /*`name`='Scarlet Monastery Entrance Target 02',*/`target_position_x`=853.179, `target_position_y`=1319.18, `target_position_z`=18.6714, `target_orientation`=1.5708, `VerifiedBuild`=15882 WHERE `id`=610; -- WSL 3627 +UPDATE `areatrigger_teleport` SET /*`name`='Scarlet Monastery Entrance Target 03',*/`target_position_x`=1608.1, `target_position_y`=-318.919, `target_position_z`=18.6714, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=612; -- WSL 3628 +UPDATE `areatrigger_teleport` SET /*`name`='Scarlet Monastery Entrance Target 04',*/`target_position_x`=253.672, `target_position_y`=-206.624, `target_position_z`=18.6773, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=614; -- WSL 3629 +UPDATE `areatrigger_teleport` SET /*`name`='Stormwind - Mage Exit Target',*/`target_position_x`=-9014.94, `target_position_y`=873.326, `target_position_z`=148.616, `target_orientation`=5.23599, `VerifiedBuild`=15882 WHERE `id`=702; -- WSL 3630 +UPDATE `areatrigger_teleport` SET /*`name`='Stormwind - Mage Entrance Target',*/`target_position_x`=-9016.97, `target_position_y`=885.436, `target_position_z`=29.6207, `target_orientation`=5.41052, `VerifiedBuild`=15882 WHERE `id`=704; -- WSL 3631 +UPDATE `areatrigger_teleport` SET /*`name`='Uldaman Exit Target Rear',*/`target_position_x`=-6619.97, `target_position_y`=-3765.74, `target_position_z`=266.309, `target_orientation`=3.40339, `VerifiedBuild`=15882 WHERE `id`=882; -- WSL 3632 +UPDATE `areatrigger_teleport` SET /*`name`='Uldaman Entrance Target Rear',*/`target_position_x`=-212.95, `target_position_y`=382.427, `target_position_z`=-38.7486, `target_orientation`=1.39626, `VerifiedBuild`=15882 WHERE `id`=902; -- WSL 3633 +UPDATE `areatrigger_teleport` SET /*`name`='Zul''Farrak Exit Target',*/`target_position_x`=-6795.56, `target_position_y`=-2890.72, `target_position_z`=8.88742, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=922; -- WSL 3634 +UPDATE `areatrigger_teleport` SET /*`name`='Zul''Farrak Entrance Target',*/`target_position_x`=1212.67, `target_position_y`=842.04, `target_position_z`=8.93346, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=924; -- WSL 3635 +UPDATE `areatrigger_teleport` SET /*`name`='Thousand Needles - Test of Faith (Target)',*/`target_position_x`=-5191.27, `target_position_y`=-2802.59, `target_position_z`=-7.21111, `target_orientation`=5.67232, `VerifiedBuild`=15882 WHERE `id`=943; -- WSL 3636, 3637, 3638 +UPDATE `areatrigger_teleport` SET /*`name`='Onyxia''s Lair Exit Target',*/`target_position_x`=-4750.38, `target_position_y`=-3754.44, `target_position_z`=49.0485, `target_orientation`=0.785398, `VerifiedBuild`=15882 WHERE `id`=1064; -- WSL 3639 +UPDATE `areatrigger_teleport` SET /*`name`='Blackwing Lair - Entrance Target',*/`target_position_x`=-7672.32, `target_position_y`=-1107.05, `target_position_z`=396.651, `target_orientation`=0.785398, `VerifiedBuild`=15882 WHERE `id`=3726; -- WSL 3700, 3702 +UPDATE `areatrigger_teleport` SET /*`name`='Arathi Highlands - Arathi Basin Exit Target - Alliance',*/`target_position_x`=-1215.59, `target_position_y`=-2531.75, `target_position_z`=21.6734, `target_orientation`=3.1765, `VerifiedBuild`=15882 WHERE `id`=3948; -- WSL 3703 +UPDATE `areatrigger_teleport` SET /*`name`='Arathi Highlands - Arathi Basin Exit Target - Horde',*/`target_position_x`=-831.881, `target_position_y`=-3518.52, `target_position_z`=72.4831, `target_orientation`=3.36849, `VerifiedBuild`=15882 WHERE `id`=3949; -- WSL 3704 +UPDATE `areatrigger_teleport` SET /*`name`='Ahn''Qiraj Ruins - Outbound Teleport Target',*/`target_position_x`=-8415.7, `target_position_y`=1502.44, `target_position_z`=30.6862, `target_orientation`=5.49779, `VerifiedBuild`=15882 WHERE `id`=4006; -- WSL 3707 +UPDATE `areatrigger_teleport` SET /*`name`='Ahn''Qiraj Ruins - Inbound Teleport Target',*/`target_position_x`=-8436.53, `target_position_y`=1519.17, `target_position_z`=31.907, `target_orientation`=2.61799, `VerifiedBuild`=15882 WHERE `id`=4008; -- WSL 3708 +UPDATE `areatrigger_teleport` SET /*`name`='Ahn''Qiraj Temple - Inbound Teleport Target',*/`target_position_x`=-8221.35, `target_position_y`=2014.34, `target_position_z`=129.071, `target_orientation`=0.872665, `VerifiedBuild`=15882 WHERE `id`=4010; -- WSL 3709 +UPDATE `areatrigger_teleport` SET /*`name`='Ahn''Qiraj Temple - Outbound Target',*/`target_position_x`=-8239.01, `target_position_y`=1993.25, `target_position_z`=129.071, `target_orientation`=4.01426, `VerifiedBuild`=15882 WHERE `id`=4012; -- WSL 3710 +UPDATE `areatrigger_teleport` SET /*`name`='Karazhan - Front Entrance Target',*/`target_position_x`=-11102, `target_position_y`=-1998.2, `target_position_z`=49.8921, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=4131; -- WSL 3712 +UPDATE `areatrigger_teleport` SET /*`name`='Karazhan - Upper Entrance Target',*/`target_position_x`=-11041.8, `target_position_y`=-1995.14, `target_position_z`=96.2004, `target_orientation`=2.18166, `VerifiedBuild`=15882 WHERE `id`=4135; -- WSL 3713 +UPDATE `areatrigger_teleport` SET /*`name`='Hellfire Military - Exit Target',*/`target_position_x`=-310.515, `target_position_y`=3084.06, `target_position_z`=-3.7682, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=4145; -- WSL 3714 +UPDATE `areatrigger_teleport` SET /*`name`='Hellfire Demon - Exit Target',*/`target_position_x`=-302.408, `target_position_y`=3162.92, `target_position_z`=31.7273, `target_orientation`=5.32325, `VerifiedBuild`=15882 WHERE `id`=4147; -- WSL 3715 +UPDATE `areatrigger_teleport` SET /*`name`='Hellfire Raid - Exit Target',*/`target_position_x`=-312.27, `target_position_y`=3086.53, `target_position_z`=-116.53, `target_orientation`=2.02458, `VerifiedBuild`=15882 WHERE `id`=4149; -- WSL 3716 +UPDATE `areatrigger_teleport` SET /*`name`='Hellfire Military - Entrance Target',*/`target_position_x`=-40.7388, `target_position_y`=-19.2881, `target_position_z`=-13.8417, `target_orientation`=1.13446, `VerifiedBuild`=15882 WHERE `id`=4151; -- WSL 3718 +UPDATE `areatrigger_teleport` SET /*`name`='Hellfire Raid - Entrance Target',*/`target_position_x`=188.452, `target_position_y`=36.776, `target_position_z`=67.931, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=4153; -- WSL 3720 +UPDATE `areatrigger_teleport` SET /*`name`='Hellfire Ramparts - Exit Target',*/`target_position_x`=-363.436, `target_position_y`=3078.43, `target_position_z`=-15.0013, `target_orientation`=4.88692, `VerifiedBuild`=15882 WHERE `id`=4297; -- WSL 3725 +UPDATE `areatrigger_teleport` SET /*`name`='CoT - Hyjal - Human Base - Teleport Target',*/`target_position_x`=5066.79, `target_position_y`=-1791.9, `target_position_z`=1321.65, `target_orientation`=2.35619, `VerifiedBuild`=15882 WHERE `id`=4311; -- WSL 3727 +UPDATE `areatrigger_teleport` SET /*`name`='CoT - Hyjal - Orc Base - Teleport Target',*/`target_position_x`=5499.96, `target_position_y`=-2756.8, `target_position_z`=1488.96, `target_orientation`=1.39626, `VerifiedBuild`=15882 WHERE `id`=4312; -- WSL 3728 +UPDATE `areatrigger_teleport` SET /*`name`='CoT - Hyjal - Night Elf Base - Teleport Target',*/`target_position_x`=5163.02, `target_position_y`=-3428.31, `target_position_z`=1627.61, `target_orientation`=0.785398, `VerifiedBuild`=15882 WHERE `id`=4313; -- WSL 3729 +UPDATE `areatrigger_teleport` SET /*`name`='CoT - Hyjal - Entrance - Teleport Target',*/`target_position_x`=4252.72, `target_position_y`=-4226.16, `target_position_z`=868.222, `target_orientation`=2.35619, `VerifiedBuild`=15882 WHERE `id`=4319; -- WSL 3730 +UPDATE `areatrigger_teleport` SET /*`name`='CoT - Black Morass - Entrance - Teleport Target',*/`target_position_x`=-1491.61, `target_position_y`=7056.51, `target_position_z`=32.1011, `target_orientation`=1.74533, `VerifiedBuild`=15882 WHERE `id`=4320; -- WSL 3731 +UPDATE `areatrigger_teleport` SET /*`name`='CoT - Hillsbrad - Entrance - Teleport Target',*/`target_position_x`=2741.68, `target_position_y`=1312.64, `target_position_z`=14.0413, `target_orientation`=2.79253, `VerifiedBuild`=15882 WHERE `id`=4321; -- WSL 3732 +UPDATE `areatrigger_teleport` SET /*`name`='CoT - Black Morass - Exit - Teleport Target',*/`target_position_x`=-8759.51, `target_position_y`=-4192.27, `target_position_z`=-209.501, `target_orientation`=5.49779, `VerifiedBuild`=15882 WHERE `id`=4322; -- WSL 3733 +UPDATE `areatrigger_teleport` SET /*`name`='CoT - Hyjal - Exit - Teleport Target',*/`target_position_x`=-8176.99, `target_position_y`=-4176.92, `target_position_z`=-166.463, `target_orientation`=3.92699, `VerifiedBuild`=15882 WHERE `id`=4323; -- WSL 3734 +UPDATE `areatrigger_teleport` SET /*`name`='CoT - Hillsbrad - Exit - Teleport Target',*/`target_position_x`=-8359.11, `target_position_y`=-4058.83, `target_position_z`=-208.186, `target_orientation`=3.49066, `VerifiedBuild`=15882 WHERE `id`=4324; -- WSL 3735 +UPDATE `areatrigger_teleport` SET /*`name`='Dark Portal - E. Kingdoms Target',*/`target_position_x`=-11896.8, `target_position_y`=-3206.77, `target_position_z`=-14.6724, `target_orientation`=0.174533, `VerifiedBuild`=15882 WHERE `id`=4352; -- WSL 3736 +UPDATE `areatrigger_teleport` SET /*`name`='Dark Portal - Outland Target',*/`target_position_x`=-248.113, `target_position_y`=922.9, `target_position_z`=84.3497, `target_orientation`=1.5708, `VerifiedBuild`=15882 WHERE `id`=4354; -- WSL 3737 +UPDATE `areatrigger_teleport` SET /*`name`='Coilfang Pumping - Entrance Target',*/`target_position_x`=-15.3686, `target_position_y`=5.78336, `target_position_z`=-4.32129, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=4364; -- WSL 3739 +UPDATE `areatrigger_teleport` SET /*`name`='Coilfang Draenei - Entrance Target',*/`target_position_x`=122.376, `target_position_y`=-123.644, `target_position_z`=-0.33828, `target_orientation`=1.5708, `VerifiedBuild`=15882 WHERE `id`=4365; -- WSL 3740 +UPDATE `areatrigger_teleport` SET /*`name`='Coilfang Pumping - Exit Target',*/`target_position_x`=817.924, `target_position_y`=6937.56, `target_position_z`=-80.6139, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=4366; -- WSL 3741 +UPDATE `areatrigger_teleport` SET /*`name`='Coilfang Marsh - Exit Target',*/`target_position_x`=781.377, `target_position_y`=6754.61, `target_position_z`=-72.5371, `target_orientation`=1.5708, `VerifiedBuild`=15882 WHERE `id`=4367; -- WSL 3742 +UPDATE `areatrigger_teleport` SET /*`name`='Coilfang Draenei - Exit Target',*/`target_position_x`=731.021, `target_position_y`=7013.75, `target_position_z`=-71.919, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=4379; -- WSL 3743 +UPDATE `areatrigger_teleport` SET /*`name`='Eastern Plaguelands - From Ghostlands Target',*/`target_position_x`=3468.42, `target_position_y`=-4479.6, `target_position_z`=137.329, `target_orientation`=2.18166, `VerifiedBuild`=15882 WHERE `id`=4386; -- WSL 3744 +UPDATE `areatrigger_teleport` SET /*`name`='Auchindoun Shadow - Exit Target',*/`target_position_x`=-3635.39, `target_position_y`=4942.94, `target_position_z`=-101.048, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=4397; -- WSL 3745 +UPDATE `areatrigger_teleport` SET /*`name`='Auchindoun Etherial - Exit Target',*/`target_position_x`=-3086.51, `target_position_y`=4942.43, `target_position_z`=-101.047, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=4401; -- WSL 3747 +UPDATE `areatrigger_teleport` SET /*`name`='Auchindoun Draenei - Exit Target',*/`target_position_x`=-3361.8, `target_position_y`=5209.2, `target_position_z`=-101.049, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=4403; -- WSL 3748 +UPDATE `areatrigger_teleport` SET /*`name`='Auchindoun Shadow - Entrance Target',*/`target_position_x`=-7.06027, `target_position_y`=-0.107037, `target_position_z`=-1.12795, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=4407; -- WSL 3752 +UPDATE `areatrigger_teleport` SET /*`name`='Ghostlands - EPL Return Target',*/`target_position_x`=6123.23, `target_position_y`=-7006.57, `target_position_z`=138.508, `target_orientation`=5.75959, `VerifiedBuild`=15882 WHERE `id`=4409; -- WSL 3753 +UPDATE `areatrigger_teleport` SET /*`name`='Coilfang Raid - Entrance Target',*/`target_position_x`=7.95838, `target_position_y`=0.067823, `target_position_z`=821.727, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=4416; -- WSL 3754 +UPDATE `areatrigger_teleport` SET /*`name`='Coilfang Raid - Exit Target',*/`target_position_x`=828.235, `target_position_y`=6865.8, `target_position_z`= -63.7858, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=4418; -- WSL 3755 +UPDATE `areatrigger_teleport` SET /*`name`='Karazhan - Front Exit Target',*/`target_position_x`=-11113.5, `target_position_y`=-2006.63, `target_position_z`=49.3307, `target_orientation`=3.75246, `VerifiedBuild`=15882 WHERE `id`=4436; -- WSL 3756 +UPDATE `areatrigger_teleport` SET /*`name`='Tempest Keep - Arcane Exit Target',*/`target_position_x`=3310.32, `target_position_y`=1336.59, `target_position_z`=505.56, `target_orientation`=1.95477, `VerifiedBuild`=15882 WHERE `id`=4455; -- WSL 3761 +UPDATE `areatrigger_teleport` SET /*`name`='Tempest Keep - Raid Exit Target',*/`target_position_x`=3088.15, `target_position_y`=1382.22, `target_position_z`=184.848, `target_orientation`=1.5708, `VerifiedBuild`=15882 WHERE `id`=4457; -- WSL 3762 +UPDATE `areatrigger_teleport` SET /*`name`='Tempest Keep - Atrium Exit Target',*/`target_position_x`=3409.85, `target_position_y`=1486.26, `target_position_z`=182.837, `target_orientation`=2.53073, `VerifiedBuild`=15882 WHERE `id` IN (4459, 4612); -- WSL 3763, 3781 +UPDATE `areatrigger_teleport` SET /*`name`='Tempest Keep - Factory Exit Target',*/`target_position_x`=2867.93, `target_position_y`=1550.95, `target_position_z`=252.159, `target_orientation`=0.785398, `VerifiedBuild`=15882 WHERE `id` IN (4461, 4614); -- WSL 3764, 3782 +UPDATE `areatrigger_teleport` SET /*`name`='Tempest Keep - Atrium Entrance Target',*/`target_position_x`=40.5531, `target_position_y`=-28.7947, `target_position_z`=-1.11728, `target_orientation`=2.35619, `VerifiedBuild`=15882 WHERE `id`=4467; -- WSL 3765 +UPDATE `areatrigger_teleport` SET /*`name`='Tempest Keep - Arcane Entrance Target',*/`target_position_x`=8.73761, `target_position_y`=0.008027, `target_position_z`=-0.205496, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=4468; -- WSL 3766 +UPDATE `areatrigger_teleport` SET /*`name`='Tempest Keep - Factory Entrance Target',*/`target_position_x`=-26.4934, `target_position_y`=0.315267, `target_position_z`=-1.8124, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=4469; -- WSL 3767 +UPDATE `areatrigger_teleport` SET /*`name`='Tempest Keep - Raid Entrance Target',*/`target_position_x`=-0.9436, `target_position_y`=-0.817774, `target_position_z`=-2.42833, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=4470; -- WSL 3768 +UPDATE `areatrigger_teleport` SET /*`name`='CoT - Hyjal - Exit - Teleport Target',*/`target_position_x`=-8176.99, `target_position_y`=-4176.92, `target_position_z`=-166.463, `target_orientation`=3.92699, `VerifiedBuild`=15882 WHERE `id`=4487; -- WSL 3770 +UPDATE `areatrigger_teleport` SET /*`name`='Karazhan - Upper Exit Target',*/`target_position_x`=-11036.7, `target_position_y`=-2001.6, `target_position_z`=92.971, `target_orientation`=5.41052, `VerifiedBuild`=15882 WHERE `id`=4520; -- WSL 3771 +UPDATE `areatrigger_teleport` SET /*`name`='Gruul''s Lair - Exit Target',*/`target_position_x`=3540.17, `target_position_y`=5092.14, `target_position_z`=3.73097, `target_orientation`=2.35619, `VerifiedBuild`=15882 WHERE `id`=4534; -- WSL 3774 +UPDATE `areatrigger_teleport` SET /*`name`='Gruul''s Lair - Entrance Target',*/`target_position_x`=64.063, `target_position_y`=45.1714, `target_position_z`=-4.86252, `target_orientation`=1.5708, `VerifiedBuild`=15882 WHERE `id`=4535; -- WSL 3775 +UPDATE `areatrigger_teleport` SET /*`name`='Black Temple - Entrance Target',*/`target_position_x`=97.7989, `target_position_y`=1001.99, `target_position_z`=-86.7756, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=4598; -- WSL 3780 +UPDATE `areatrigger_teleport` SET /*`name`='Black Temple - Exit Target',*/`target_position_x`=-3650.9, `target_position_y`=316.897, `target_position_z`=35.8528, `target_orientation`=6.28319, `VerifiedBuild`=15882 WHERE `id`=4619; -- WSL 3783 +UPDATE `areatrigger_teleport` SET /*`name`='Utgarde Keep - Exit Target',*/`target_position_x`=1221.63, `target_position_y`=-4864.75, `target_position_z`=41.2481, `target_orientation`=2.35619, `VerifiedBuild`=15882 WHERE `id`=4741; -- WSL 3788 +UPDATE `areatrigger_teleport` SET /*`name`='Utgarde Pinnacle - Exit Target',*/`target_position_x`=1242.55, `target_position_y`=-4857.47, `target_position_z`=217.783, `target_orientation`=0.314159, `VerifiedBuild`=15882 WHERE `id`=4743; -- WSL 3789 +UPDATE `areatrigger_teleport` SET /*`name`='Magisters'' Terrace - Exit Target',*/`target_position_x`=12885.3, `target_position_y`=-7336.42, `target_position_z`=65.4882, `target_orientation`=1.0472, `VerifiedBuild`=15882 WHERE `id`=4885; -- WSL 3793 +UPDATE `areatrigger_teleport` SET /*`name`='Magisters'' Terrace - Entrance Target',*/`target_position_x`=7.52409, `target_position_y`=0.545139, `target_position_z`=-2.79914, `target_orientation`=0, `VerifiedBuild`=15882 WHERE `id`=4887; -- WSL 3794 +UPDATE `areatrigger_teleport` SET /*`name`='Sunwell Raid - Entrance Target',*/`target_position_x`=1792.53, `target_position_y`=925.929, `target_position_z`=15.076, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=4889; -- WSL 3795 +UPDATE `areatrigger_teleport` SET /*`name`='Sunwell Raid - Exit Target',*/`target_position_x`=12556.5, `target_position_y`=-6774.95, `target_position_z`=15.0719, `target_orientation`=0, `VerifiedBuild`=15882 WHERE `id`=4891; -- WSL 3796 +UPDATE `areatrigger_teleport` SET /*`name`='The Nexus - Exit Target',*/`target_position_x`=3896.74, `target_position_y`=6985.4, `target_position_z`=69.4879, `target_orientation`=3.15905, `VerifiedBuild`=15882 WHERE `id`=4981; -- WSL 3819 +UPDATE `areatrigger_teleport` SET /*`name`='Drak''Tharon - Entrance Target',*/`target_position_x`=-517.15, `target_position_y`=-489.201, `target_position_z`=11.0179, `target_orientation`=4.7822, `VerifiedBuild`=15882 WHERE `id`=4998; -- WSL 3821 +UPDATE `areatrigger_teleport` SET /*`name`='Drak''Tharon - Exit Target',*/`target_position_x`=4774.44, `target_position_y`=-2030.03, `target_position_z`=229.38, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=5000; -- WSL 3822 +UPDATE `areatrigger_teleport` SET /*`name`='Halls of Stone - Entrance Target',*/`target_position_x`=1153.95, `target_position_y`=809.891, `target_position_z`=195.835, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=5010; -- WSL 3825 +UPDATE `areatrigger_teleport` SET /*`name`='Halls of Stone - Exit Target',*/`target_position_x`=8921.17, `target_position_y`=-979.096, `target_position_z`=1039.16, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=5012; -- WSL 3826 +UPDATE `areatrigger_teleport` SET /*`name`='Ulduar 80 - Exit Target',*/`target_position_x`=9175.68, `target_position_y`=-1378.8, `target_position_z`=1103.57, `target_orientation`=2.35619, `VerifiedBuild`=15882 WHERE `id`=5091; -- WSL 3835 +UPDATE `areatrigger_teleport` SET /*`name`='Azjol-Nerub Back Exit Target',*/`target_position_x`=3817.4, `target_position_y`=2032.82, `target_position_z`=11.0133, `target_orientation`=3.61283, `VerifiedBuild`=15882 WHERE `id`=5113; -- WSL 3837 +UPDATE `areatrigger_teleport` SET /*`name`='Azjol-Nerub Front Exit Target',*/`target_position_x`=3674.13, `target_position_y`=2168.61, `target_position_z`=35.8741, `target_orientation`=5.49779, `VerifiedBuild`=15882 WHERE `id`=5115; -- WSL 3838 +UPDATE `areatrigger_teleport` SET /*`name`='CoT Stratholme - Entrance Target',*/`target_position_x`=1431.47, `target_position_y`=555.038, `target_position_z`=36.2723, `target_orientation`=5.06145, `VerifiedBuild`=15882 WHERE `id`=5150; -- WSL 3853 +UPDATE `areatrigger_teleport` SET /*`name`='CoT Stratholme - Exit Target',*/`target_position_x`=-8756.6, `target_position_y`=-4457.02, `target_position_z`=-200.481, `target_orientation`=1.39626, `VerifiedBuild`=15882 WHERE `id`=5181; -- WSL 3854 +UPDATE `areatrigger_teleport` SET /*`name`='Ulduar Raid - Exit Target',*/`target_position_x`=9338.31, `target_position_y`=-1114.16, `target_position_z`=1245.15, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=5381; -- WSL 3904 +UPDATE `areatrigger_teleport` SET /*`name`='Argent Raid - Entrance Target',*/`target_position_x`=563.646, `target_position_y`=92.1233, `target_position_z`=395.208, `target_orientation`=1.5708, `VerifiedBuild`=15882 WHERE `id`=5503; -- WSL 3914 +UPDATE `areatrigger_teleport` SET /*`name`='Argent Raid - Exit Target',*/`target_position_x`=8515.35, `target_position_y`=730.17, `target_position_z`=558.594, `target_orientation`=4.71239, `VerifiedBuild`=15882 WHERE `id`=5508; -- WSL 3916 +UPDATE `areatrigger_teleport` SET /*`name`='Argent Dungeon - Exit Target',*/`target_position_x`=8577.85, `target_position_y`=792.042, `target_position_z`=558.581, `target_orientation`=0, `VerifiedBuild`=15882 WHERE `id`=5510; -- WSL 3917 +UPDATE `areatrigger_teleport` SET /*`name`='Icecrown Dungeon - Forge of Souls - Exit Target',*/`target_position_x`=5667.65, `target_position_y`=2007.45, `target_position_z`=798.041, `target_orientation`=2.35619, `VerifiedBuild`=15882 WHERE `id`=5642; -- WSL 3923 +UPDATE `areatrigger_teleport` SET /*`name`='Icecrown Dungeon - Pit of Saron - Exit Target',*/`target_position_x`=5595.78, `target_position_y`=2013.27, `target_position_z`=798.041, `target_orientation`=0.785398, `VerifiedBuild`=15882 WHERE `id`=5643; -- WSL 3924 +UPDATE `areatrigger_teleport` SET /*`name`='Icecrown Dungeon - Halls of Reflection - Exit Target',*/`target_position_x`=5629.14, `target_position_y`=1976.46, `target_position_z`=802.642, `target_orientation`=1.46608, `VerifiedBuild`=15882 WHERE `id`=5646; -- WSL 3925 +UPDATE `areatrigger_teleport` SET /*`name`='Icecrown Raid - Exit Target',*/`target_position_x`=5788.36, `target_position_y`=2070.69, `target_position_z`=636.064, `target_orientation`=0.383972, `VerifiedBuild`=15882 WHERE `id`=5668; -- WSL 3928 +UPDATE `areatrigger_teleport` SET /*`name`='Icecrown Raid - Entrance Target',*/`target_position_x`=73.0174, `target_position_y`=2211.49, `target_position_z`=30.1157, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=5670; -- WSL 3929 +UPDATE `areatrigger_teleport` SET /*`name`='Ruby Sanctum - Entrance Target',*/`target_position_x`=3273.88, `target_position_y`=533.497, `target_position_z`=87.6648, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `id`=5869; -- WSL 3940 +UPDATE `areatrigger_teleport` SET /*`name`='Ruby Sanctum - Exit Target',*/`target_position_x`=3603.89, `target_position_y`=192.448, `target_position_z`=-109.762, `target_orientation`=2.26893, `VerifiedBuild`=15882 WHERE `id`=5872; -- WSL 3941 diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_05_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_05_world.sql new file mode 100644 index 00000000000..91b5f5e6a30 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_05_world.sql @@ -0,0 +1,2 @@ +-- +DELETE FROM `spawn_group` WHERE `spawnType` = 1 AND `groupId` = 2 AND `spawnId` IN (SELECT `guid` FROM `gameobject` WHERE `spawntimesecs` < 0); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_06_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_06_world_335.sql new file mode 100644 index 00000000000..a381ec7702b --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_06_world_335.sql @@ -0,0 +1,13 @@ +-- +UPDATE `areatrigger_teleport` SET `VerifiedBuild` = 15882 WHERE `ID` IN (4917,4919,4921,4922,4923,4924,4925,4927,4928,4929,4930,4931,4932,4933,4934,4935,4936,4941,4944,5127,5128,5129,5130,5131,5132,5133,5134,5135,5136,5137,5138,5148,5326,5328,5329,5330,5331,5740,4304,4233,4267,2406,2407,2408,2409,2410,2411); + +UPDATE `areatrigger_teleport` SET /*Scholomance Instance*/ `target_position_x`=1273.91, `target_position_y`=-2553.09, `target_position_z`=91.8393, `target_orientation`=3.57792, `VerifiedBuild`=15882 WHERE `ID`=2568; -- WSL 4012 +UPDATE `areatrigger_teleport` SET /*Pit of Saron (Exit)*/ `target_position_x`=5595.78, `target_position_y`=2013.27, `target_position_z`=798.041, `target_orientation`=0.78539, `VerifiedBuild`=15882 WHERE `ID`=5683; -- WSL 3924 +UPDATE `areatrigger_teleport` SET /*Forge of Souls (Exit)*/ `target_position_x`=5667.65, `target_position_y`=2007.45, `target_position_z`=798.041, `target_orientation`=2.35619, `VerifiedBuild`=15882 WHERE `ID`=5688; -- WSL 3923 + +-- There's 3 areatriggers, not only one +UPDATE `areatrigger_teleport` SET `Name` = "Thousand Needles - Test of Faith (Target)" WHERE `ID` = 943; +DELETE FROM `areatrigger_teleport` WHERE `ID` IN (942,944); +INSERT INTO `areatrigger_teleport` (`ID`,`Name`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`,`VerifiedBuild`) VALUES +(942,"Thousand Needles - Test of Faith (Target)",1,-5191.27,-2802.59,-7.21111,5.67232,15882), +(944,"Thousand Needles - Test of Faith (Target)",1,-5191.27,-2802.59,-7.21111,5.67232,15882); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_07_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_07_world.sql new file mode 100644 index 00000000000..040f8963412 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_07_world.sql @@ -0,0 +1,2 @@ +-- Lady Sylvanas Windrunner +UPDATE `creature_text` SET `Text`= "Sighing, %s kneels down and picks up the amulet.", `BroadcastTextId`= 19244 WHERE `CreatureID`= 10181 AND `GroupID`= 0; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_00_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_00_world.sql new file mode 100644 index 00000000000..901c5742eac --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_00_world.sql @@ -0,0 +1,2 @@ +-- +DELETE FROM `command` WHERE `name`='debug asan outofbounds'; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_01_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_01_world.sql new file mode 100644 index 00000000000..27672b109f5 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_01_world.sql @@ -0,0 +1,3 @@ +UPDATE `command` SET `help`='Syntax: .debug transport [start/stop] + + Allows to stop the current transport at its nearest wait point and start movement of a stopped one. Not all transports can be started or stopped.' WHERE `name`='debug transport'; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_02_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_02_world.sql new file mode 100644 index 00000000000..b850fd391e2 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_02_world.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `command` WHERE `name`='debug asan outofbounds'; +INSERT INTO `command` (`name`,`permission`,`help`) VALUES +('debug asan outofbounds',874,'Syntax: .debug asan outofbounds +Triggers a stack out of bounds read. +Use only when testing dynamic analysis tools.'); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_00_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_00_world_335.sql new file mode 100644 index 00000000000..b8187b1706e --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_00_world_335.sql @@ -0,0 +1,204 @@ +-- 690 Una petición de Malin +-- https://es.classic.wowhead.com/quest=690 +SET @ID := 690; +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', '¿Así que t\'envía Malin? M\'importa un bledo que Muradin resucitara y te pusiera un dragón pa\' traerte aquí. ¡Estoy ocupao! Habla con Kryten pa\' lo que sea.', 0), +(@ID, 'esMX', '¿Así que t\'envía Malin? M\'importa un bledo que Muradin resucitara y te pusiera un dragón pa\' traerte aquí. ¡Estoy ocupao! Habla con Kryten pa\' lo que sea.', 0); +-- 1477 Suministros de vital importancia +-- https://es.classic.wowhead.com/quest=1477 +SET @ID := 1477; +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 envía Andromath? Muy bien. Tengo una importante tarea para ti...', 0), +(@ID, 'esMX', '¿Te envía Andromath? Muy bien. Tengo una importante tarea para ti...', 0); +-- 2861 La tarea de Tabetha +-- https://es.classic.wowhead.com/quest=2861 +SET @ID := 2861; +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 cierto. Tengo unas cuentas que arreglar con un trol. Algunas cuentas. ¡Todas!$B$B¿Quieres ayudarme?', 0), +(@ID, 'esMX', 'Es cierto. Tengo unas cuentas que arreglar con un trol. Algunas cuentas. ¡Todas!$B$B¿Quieres ayudarme?', 0); +-- 212 Un plato bien frío +-- https://es.classic.wowhead.com/quest=212 +SET @ID := 212; +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! ¿Has conseguido el anca ya? Debo cocinar pronto, ¡o el banquete será un desastre total!', 0), +(@ID, 'esMX', '¡$n! ¿Has conseguido el anca ya? Debo cocinar pronto, ¡o el banquete será un desastre total!', 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', 'Ah, ¡esto vendrá de perlas! ¡Muchas, pero que muchísimas gracias!$B$BAhora, si me disculpas, tengo que picar esta pierna, marinarla y preparar la guarnición para el banquete.', 0), +(@ID, 'esMX', 'Ah, ¡esto vendrá de perlas! ¡Muchas, pero que muchísimas gracias!$B$BAhora, si me disculpas, tengo que picar esta pierna, marinarla y preparar la guarnición para el banquete.', 0); +-- 1260 Morgan Stern +-- https://es.classic.wowhead.com/quest=1260 +SET @ID := 1260; +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', 'Ah, así que te envía mi tío, ¿eh?$B$BBueno, he estado investigando unas recetas, y tengo algunas pistas, pero necesito ayuda.$B$BAyuda de alguien a quien no le importe mojarse los pies.', 0), +(@ID, 'esMX', 'Ah, así que te envía mi tío, ¿eh?$B$BBueno, he estado investigando unas recetas, y tengo algunas pistas, pero necesito ayuda.$B$BAyuda de alguien a quien no le importe mojarse los pies.', 0); +-- 55 Morbent Vil +-- https://es.classic.wowhead.com/quest=55 +SET @ID := 55; +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 derrotado a Morbent Vil?!', 0), +(@ID, 'esMX', '¡¿Has derrotado a Morbent Vil?!', 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', 'Morbent Vil ha sido derrotado. Los jinetes oscuros aún andan por ahí, pero ya ha ocurrido una de las dos cosas que esperaba con desesperación.$B$BHas hecho lo imposible y tu hazaña perdurará en las leyendas del Bosque del Ocaso.$B$BVe, $n. Quizás un día, el destino vuelva a traerte a mí...', 0), +(@ID, 'esMX', 'Morbent Vil ha sido derrotado. Los jinetes oscuros aún andan por ahí, pero ya ha ocurrido una de las dos cosas que esperaba con desesperación.$B$BHas hecho lo imposible y tu hazaña perdurará en las leyendas del Bosque del Ocaso.$B$BVe, $n. Quizás un día, el destino vuelva a traerte a mí...', 0); +-- 284 La búsqueda continúa +-- https://es.classic.wowhead.com/quest=284 +SET @ID := 284; +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 barril no ha sido tocado en mucho tiempo. Lo abres...$B$B... y te abruma un fuerte olor a queso. Está un poco mojado, ¡pero aún está bueno!', 0), +(@ID, 'esMX', 'El barril no ha sido tocado en mucho tiempo. Lo abres...$B$B... y te abruma un fuerte olor a queso. Está un poco mojado, ¡pero aún está bueno!', 0); +-- 285 Inspecciona más casuchas +-- https://es.classic.wowhead.com/quest=285 +SET @ID := 285; +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 barril está casi enterrado entre el barro y la hierba...', 0), +(@ID, 'esMX', 'El barril está casi enterrado entre el barro y la hierba...', 0); +-- 286 Devuelve la Estatuilla +-- https://es.classic.wowhead.com/quest=286 +SET @ID := 286; +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', '¿Tienes la estatuilla?', 0), +(@ID, 'esMX', '¿Tienes la estatuilla?', 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 capitán de La princesa ciega se sentirá aliviado al saber que has recuperado su precioso cargamento. Te has ganado el pago por tus servicios.$B$BEs bueno encontrar a gente fiable como tú, especialmente en tiempos difíciles como estos.', 0), +(@ID, 'esMX', 'El capitán de La princesa ciega se sentirá aliviado al saber que has recuperado su precioso cargamento. Te has ganado el pago por tus servicios.$B$BEs bueno encontrar a gente fiable como tú, especialmente en tiempos difíciles como estos.', 0); +-- 290 Purga de la maldición +-- https://es.classic.wowhead.com/quest=290 +SET @ID := 290; +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', 'Este cofre está bien cerrado.', 0), +(@ID, 'esMX', 'Este cofre está bien cerrado.', 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', 'La llave está oxidada pero entra perfectamente en el candado.', 0), +(@ID, 'esMX', 'La llave está oxidada pero entra perfectamente en el candado.', 0); +-- 292 El ojo de Paleth +-- https://es.classic.wowhead.com/quest=292 +SET @ID := 292; +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', '¿Te envía el borracho de Fistimos? Puedes decirle que no tengo más cerveza. ¡Tendrá que ir mendigarle a otro!', 0), +(@ID, 'esMX', '¿Te envía el borracho de Fistimos? Puedes decirle que no tengo más cerveza. ¡Tendrá que ir mendigarle a otro!', 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', '¿Un ojo de Paleth? ¡Fascinante! Umm... algo va mal con este. ¿Lo encontraste en uno de los restos de naufragio? ¡Eso lo explica todo! Pero... no sabía que tuvieran un ojo así en la Tercera Flota...$B$BNo me extraña que Fistimos estuviera tan asustado. Encontrarse con un Ojo maldito de Paleth no es ninguna alegría.', 0), +(@ID, 'esMX', '¿Un ojo de Paleth? ¡Fascinante! Umm... algo va mal con este. ¿Lo encontraste en uno de los restos de naufragio? ¡Eso lo explica todo! Pero... no sabía que tuvieran un ojo así en la Tercera Flota...$B$BNo me extraña que Fistimos estuviera tan asustado. Encontrarse con un Ojo maldito de Paleth no es ninguna alegría.', 0); +-- 293 Limpieza del ojo +-- https://es.classic.wowhead.com/quest=293 +SET @ID := 293; +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é es ese orbe? Parece... dañado.', 0), +(@ID, 'esMX', '¿Qué es ese orbe? Parece... dañado.', 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', 'Un ojo de Paleth. Pero este ha visto demasiado dolor... debe haber sido testigo de una terrible, terrible tragedia.$B$BDéjame purificarlo, los ojos fueron creados para iluminar y sus poderes pueden ser muy peligrosos si están malditos como este.', 0), +(@ID, 'esMX', 'Un ojo de Paleth. Pero este ha visto demasiado dolor... debe haber sido testigo de una terrible, terrible tragedia.$B$BDéjame purificarlo, los ojos fueron creados para iluminar y sus poderes pueden ser muy peligrosos si están malditos como este.', 0); +-- 681 Mansión Redilnorte +-- https://es.classic.wowhead.com/quest=681 +SET @ID := 681; +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, con cada hora que pasa nuestro control sobre Stromgarde se vuelve más débil. Debes darte prisa o nuestra ciudad seguramente caerá.', 0), +(@ID, 'esMX', '$n, con cada hora que pasa nuestro control sobre Stromgarde se vuelve más débil. Debes darte prisa o nuestra ciudad seguramente caerá.', 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. Con la muerte de los miembros de la Hermandad debería ser más fácil recibir los suministros de Costasur.$B$BQuizás aún quede esperanza para nuestra causa.', 0), +(@ID, 'esMX', 'Muy bien, $n. Con la muerte de los miembros de la Hermandad debería ser más fácil recibir los suministros de Costasur.$B$BQuizás aún quede esperanza para nuestra causa.', 0); +-- 684 Se busca: Marez Cogulla +-- https://es.classic.wowhead.com/quest=684 +SET @ID := 684; +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', 'Saludos, $c. ¿Tienes un informe para mí?', 0), +(@ID, 'esMX', 'Saludos, $c. ¿Tienes un informe para mí?', 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', '¿Has despachado a Marez Cogulla? Muy bien, $n. ¡Pero que muy bien!$B$BMarez era una amenaza para nuestros defensores de Stromgarde y se rumoreaba que era una emisaria entre la Hermandad y algún poder más oscuro. Nos alegramos de que ya no ejerza sus poderes contra nosotros.', 0), +(@ID, 'esMX', '¿Has despachado a Marez Cogulla? Muy bien, $n. ¡Pero que muy bien!$B$BMarez era una amenaza para nuestros defensores de Stromgarde y se rumoreaba que era una emisaria entre la Hermandad y algún poder más oscuro. Nos alegramos de que ya no ejerza sus poderes contra nosotros.', 0); +-- 685 Se busca: Otto y Lord Falconcrest +-- https://es.classic.wowhead.com/quest=685 +SET @ID := 685; +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', 'Hola. ¿Vienes a presentar un informe?', 0), +(@ID, 'esMX', 'Hola. ¿Vienes a presentar un informe?', 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', '¿Falconcrest y Otto? ¡Estupendo!$B$BAquí tienes tu recompensa, $n. Te la pago con mucho gusto.', 0), +(@ID, 'esMX', '¿Falconcrest y Otto? ¡Estupendo!$B$BAquí tienes tu recompensa, $n. Te la pago con mucho gusto.', 0); +-- 691 Valer su peso en oro +-- https://es.classic.wowhead.com/quest=691 +SET @ID := 691; +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', '¿Ha habido suerte hasta ahora, $n?$B$B<Kryten toma algunas notas en su diario mientras lee>$B$BSi mi investigación es correcta, los colmillos deberían proceder de cualquier trol Secacorteza. Las bolsas de medicina proceden de los médicos brujos Secacorteza y el más fuerte de los cazadores oscuros Secacorteza debería llevar el cuchillo especial que se les entrega después de completar sus ritos de paso. No hay forma de saber qué cazador oscuro lleva el cuchillo hasta que te enfrentas a ellos.', 0), +(@ID, 'esMX', '¿Ha habido suerte hasta ahora, $n?$B$B<Kryten toma algunas notas en su diario mientras lee>$B$BSi mi investigación es correcta, los colmillos deberían proceder de cualquier trol Secacorteza. Las bolsas de medicina proceden de los médicos brujos Secacorteza y el más fuerte de los cazadores oscuros Secacorteza debería llevar el cuchillo especial que se les entrega después de completar sus ritos de paso. No hay forma de saber qué cazador oscuro lleva el cuchillo hasta que te enfrentas a ellos.', 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', '¡Increíble! Ahora entiendo por qué Malin te pidió que te unieras a nosotros, ¡gran idea, digo!$B$BA este paso, Skuerto y yo estaremos de vuelta en Ventormenta antes de que nos demos cuenta.$B$BCreo que mi compañero enano ha vuelto de su exploración de la Sala Puño de Roca; ve a hablar con él cuando estés $glisto:lista;.$B$BAl parecer, tuvo una escaramuza con los ogros. Aunque ni se lo menciones, es muy sensible ante las críticas a sus habilidades y a su trabajo como rastreador.', 0), +(@ID, 'esMX', '¡Increíble! Ahora entiendo por qué Malin te pidió que te unieras a nosotros, ¡gran idea, digo!$B$BA este paso, Skuerto y yo estaremos de vuelta en Ventormenta antes de que nos demos cuenta.$B$BCreo que mi compañero enano ha vuelto de su exploración de la Sala Puño de Roca; ve a hablar con él cuando estés $glisto:lista;.$B$BAl parecer, tuvo una escaramuza con los ogros. Aunque ni se lo menciones, es muy sensible ante las críticas a sus habilidades y a su trabajo como rastreador.', 0); +-- 3636 Trae la Luz +-- https://es.classic.wowhead.com/quest=3636 +SET @ID := 3636; +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', 'Amnennar debe ser erradicado. Vete rápido.', 0), +(@ID, 'esMX', 'Amnennar debe ser erradicado. Vete rápido.', 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', 'Gracias, $n. La Plaga ahora se lo pensará dos veces antes de intentar incrementar sus ejércitos.$B$BQue la Luz te bendiga.', 0), +(@ID, 'esMX', 'Gracias, $n. La Plaga ahora se lo pensará dos veces antes de intentar incrementar sus ejércitos.$B$BQue la Luz te bendiga.', 0); +-- 6141 Hermano Anton +-- https://es.classic.wowhead.com/quest=6141 +SET @ID := 6141; +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', 'Recibí noticias de una ayuda que llegaba del este. ¿Eres tú el objeto de tales rumores? ¿Has venido aquí a ayudar a la Hermandad Escarlata en su cruzada?$B$BSi es así, escucha con atención...', 0), +(@ID, 'esMX', 'Recibí noticias de una ayuda que llegaba del este. ¿Eres tú el objeto de tales rumores? ¿Has venido aquí a ayudar a la Hermandad Escarlata en su cruzada?$B$BSi es así, escucha con atención...', 0); +-- 682 Distintivos de Stromgarde +-- https://es.wowhead.com/quest=682 +-- https://wow-es.gamepedia.com/Misión:Distintivos de Stromgarde +SET @ID := 682; +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 recuperar alguna de las insignias de Stromgarde, $n? La Hermandad debe aprender que no se aprovecharán de nuestros muertos.', 0), +(@ID, 'esMX', '¿Has conseguido recuperar alguna de las insignias de Stromgarde, $n? La Hermandad debe aprender que no se aprovecharán de nuestros muertos.', 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', 'Gracias, $n. Informaremos a las familias sobre los soldados caídos en la batalla.$B$BSerán noticias crudas pero es mejor que la incertidumbre de alguien querido que ha desaparecido.', 0), +(@ID, 'esMX', 'Gracias, $n. Informaremos a las familias sobre los soldados caídos en la batalla.$B$BSerán noticias crudas pero es mejor que la incertidumbre de alguien querido que ha desaparecido.', 0); +-- 693 Empuñar la varita +-- https://es.classic.wowhead.com/quest=693 +SET @ID := 693; +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', 'Nuestro objetivo es la varita, $n. Por ahora céntrate en eso.', 0), +(@ID, 'esMX', 'Nuestro objetivo es la varita, $n. Por ahora céntrate en eso.', 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', '¡Genial, $n! 1 menos, solo faltan 3, según mi lista. Los otros 3 están en Stromgarde.$B$BDescansa un poco pa’ recuperar las fuerzas, que t’hará buena falta pa’ la siguiente fase de mi plan. Vuelve cuando hayas tomado algo caliente y hayas descansado.', 0), +(@ID, 'esMX', '¡Genial, $n! 1 menos, solo faltan 3, según mi lista. Los otros 3 están en Stromgarde.$B$BDescansa un poco pa’ recuperar las fuerzas, que t’hará buena falta pa’ la siguiente fase de mi plan. Vuelve cuando hayas tomado algo caliente y hayas descansado.', 0); +-- 694 Las defensas de Trelane +-- https://es.classic.wowhead.com/quest=694 +SET @ID := 694; +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', 'Hola otra vez, $n. ¿Has encontrado ya una ágata azur?', 0), +(@ID, 'esMX', 'Hola otra vez, $n. ¿Has encontrado ya una ágata azur?', 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', 'Impresionante, $n. Una vez más, enhorabuena.$B$BDame un momento para lanzar el hechizo apropiado para encantar la gema ¡y listo!', 0), +(@ID, 'esMX', 'Impresionante, $n. Una vez más, enhorabuena.$B$BDame un momento para lanzar el hechizo apropiado para encantar la gema ¡y listo!', 0); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_01_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_01_world_335.sql new file mode 100644 index 00000000000..99b353b3121 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_01_world_335.sql @@ -0,0 +1,184 @@ +-- 1343 Montaraz Pico Tormenta +SET @ID := 1343; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Bueno, si se trata de $gun:una; joven y errante $c, ¡sin duda, $gatraido:atraida; por lo que se dice de mis hazañas en los campos de batalla!$B$B¡No hay tiempo para historias ahora, porque hay grandes e importantes acciones que deben hacerse! Si estás buscando gloria, entonces la suerte te brilla hoy...', 0), +(@ID, 0, 'esMX', 'Bueno, si se trata de $gun:una; joven y errante $c, ¡sin duda, $gatraido:atraida; por lo que se dice de mis hazañas en los campos de batalla!$B$B¡No hay tiempo para historias ahora, porque hay grandes e importantes acciones que deben hacerse! Si estás buscando gloria, entonces la suerte te brilla hoy...', 0); +-- 392 Capitán Grisillo +SET @ID := 392; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'No se alarme, $r. Hace mucho tiempo que dejé este mundo, pero no pretendo dañar a los tuyos. He sido testigo de demasiada muerte en mi tiempo. Mi único deseo ahora es por la paz. Quizás puedas ayudar a mi causa.', 0), +(@ID, 0, 'esMX', 'No se alarme, $r. Hace mucho tiempo que dejé este mundo, pero no pretendo dañar a los tuyos. He sido testigo de demasiada muerte en mi tiempo. Mi único deseo ahora es por la paz. Quizás puedas ayudar a mi causa.', 0); +-- 344 Magistrado Solomon +SET @ID := 344; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', '¡Crestagrana está en caos por todas partes!', 0), +(@ID, 0, 'esMX', '¡Crestagrana está en caos por todas partes!', 0); +-- 342 Martie Jainrose +SET @ID := 342; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Saludos, $n. $gBienvenido:Bienvenida; a mi humilde jardín. El clima ha sido perfecto últimamente. Esperemos que se mantenga estable para una cosecha madura.', 0), +(@ID, 0, 'esMX', 'Saludos, $n. $gBienvenido:Bienvenida; a mi humilde jardín. El clima ha sido perfecto últimamente. Esperemos que se mantenga estable para una cosecha madura.', 0); +-- 381 Maestro de embarcadero Baren +SET @ID := 381; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Bien conocido, $c. Si estás aquí por negocios, consíguete una cerveza y tendremos una charla.', 0), +(@ID, 0, 'esMX', 'Bien conocido, $c. Si estás aquí por negocios, consíguete una cerveza y tendremos una charla.', 0); +-- 382 Alguacil Marris +SET @ID := 382; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'No tengo tiempo para charlar, ciudadano, pero si estás $gdispuesto:dispuesta; a echarnos una mano contra los orcos, entonces encontraré un uso para ti.', 0), +(@ID, 0, 'esMX', 'No tengo tiempo para charlar, ciudadano, pero si estás $gdispuesto:dispuesta; a echarnos una mano contra los orcos, entonces encontraré un uso para ti.', 0); +-- 415 Verner Osbien +SET @ID := 415; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Hola $gamigo:amiga;, ¿cree que podría echarme una mano con algo? Realmente estoy en una situación desesperada aquí...', 0), +(@ID, 0, 'esMX', 'Hola $gamigo:amiga;, ¿cree que podría echarme una mano con algo? Realmente estoy en una situación desesperada aquí...', 0); +-- 633 Elaine Carevin +SET @ID := 633; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Son tiempos oscuros, $c... Demasiado pronto lo perderemos todo... Cuando la Luz abandonará a todos menos a aquellos que realmente caminen bajo la Luz.', 0), +(@ID, 0, 'esMX', 'Son tiempos oscuros, $c... Demasiado pronto lo perderemos todo... Cuando la Luz abandonará a todos menos a aquellos que realmente caminen bajo la Luz.', 0); +-- 265 Lady Eva +SET @ID := 265; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'He presentido tu llegada desde hace bastante tiempo, $n. Está escrito en las estrellas.', 0), +(@ID, 0, 'esMX', 'He presentido tu llegada desde hace bastante tiempo, $n. Está escrito en las estrellas.', 0); +-- 1428 Rema Schneider +SET @ID := 1428; +DELETE FROM `quest_greeting` WHERE `ID` = @ID AND `Type` = 0; +INSERT INTO `quest_greeting` (`ID`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES (@ID, 0, 0, 0, 'Greetings, $n.', 0); +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Saludos, $n', 0), +(@ID, 0, 'esMX', 'Saludos, $n', 0); +-- 273 Tabernero Smitts +SET @ID := 273; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Deja la puerta cerrada, $c. Nunca se sabe cuándo volverán a pasar los Jinetes oscuros.', 0), +(@ID, 0, 'esMX', 'Deja la puerta cerrada, $c. Nunca se sabe cuándo volverán a pasar los Jinetes oscuros.', 0); +-- 267 Secretario Daltry +SET @ID := 267; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', '$gBienvenido:Bienvenida; al pueblo de Villa Oscura. Secretario Daltry a su servicio. ¿Puedo ser de alguna ayuda?', 0), +(@ID, 0, 'esMX', '$gBienvenido:Bienvenida; al pueblo de Villa Oscura. Secretario Daltry a su servicio. ¿Puedo ser de alguna ayuda?', 0); +-- 6579 Shoni la Shilenshiosha +SET @ID := 6579; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', '¡Por Gnomeregan!', 0), +(@ID, 0, 'esMX', '¡Por Gnomeregan!', 0); +-- 656 Wilder Cardortiga +SET @ID := 656; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', '¡Había ladrones por todas partes!$B$BFue horrible. La cueva cayó sobre nosotros. Creo que la compañía minera está muerta, incluido mi hermano, el Capataz.', 0), +(@ID, 0, 'esMX', '¡Había ladrones por todas partes!$B$BFue horrible. La cueva cayó sobre nosotros. Creo que la compañía minera está muerta, incluido mi hermano, el Capataz.', 0); +-- 6031 Tormus Forjahonda +SET @ID := 6031; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Algunos no pueden soportar el calor de la Gran Fragua, pero creo que el calor es perfecto. Y es el mejor lugar para hacer un trabajo de herrería serio.', 0), +(@ID, 0, 'esMX', 'Algunos no pueden soportar el calor de la Gran Fragua, pero creo que el calor es perfecto. Y es el mejor lugar para hacer un trabajo de herrería serio.', 0); +-- 6569 Gnoarn +SET @ID := 6569; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Donde vagan los troggs y los gnomos leprosos, en nuestro hogar: Gnomeregan.$B$BNuestras familias perdidas, nuestros hogares desplazados. Dispersado.$B$BOh, cuánto anhelo los días de la vida despreocupada de Gnomeregan, pero esos días ya no existen. ¡Debemos defendernos! ¡Debemos salvar a Gnomeregan!', 0), +(@ID, 0, 'esMX', 'Donde vagan los troggs y los gnomos leprosos, en nuestro hogar: Gnomeregan.$B$BNuestras familias perdidas, nuestros hogares desplazados. Dispersado.$B$BOh, cuánto anhelo los días de la vida despreocupada de Gnomeregan, pero esos días ya no existen. ¡Debemos defendernos! ¡Debemos salvar a Gnomeregan!', 0); +-- 1377 Piloto Roscapiedra +SET @ID := 1377; +DELETE FROM `quest_greeting` WHERE `ID` = @ID AND `Type` = 0; +INSERT INTO `quest_greeting` (`ID`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES (@ID, 0, 0, 0, 'Greetings, $n.', 0); +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Saludos, $n.', 0), +(@ID, 0, 'esMX', 'Saludos, $n.', 0); +-- 1344 Prospector Vetaferro +SET @ID := 1344; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Aunque estamos atravesando un período lento en estas ruinas, estoy seguro de que no durará mucho. Pero mientras tanto, me vendría bien alguien como tú. ¿Te gustaría ayudar a la Liga de Expedicionarios?', 0), +(@ID, 0, 'esMX', 'Aunque estamos atravesando un período lento en estas ruinas, estoy seguro de que no durará mucho. Pero mientras tanto, me vendría bien alguien como tú. ¿Te gustaría ayudar a la Liga de Expedicionarios?', 0); +-- 1139 Magistrado Narizroma +SET @ID := 1139; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Bueno, hola, ciudadano. El nombre es Narizroma, Magistrado Narizroma para ser precisos. Estoy encargado de supervisar el bienestar de Thelsamar, y créeme, ¡siempre podríamos usar otro par de brazos fuertes por aquí!', 0), +(@ID, 0, 'esMX', 'Bueno, hola, ciudadano. El nombre es Narizroma, Magistrado Narizroma para ser precisos. Estoy encargado de supervisar el bienestar de Thelsamar, y créeme, ¡siempre podríamos usar otro par de brazos fuertes por aquí!', 0); +-- 1356 Prospector Pico Tormenta +SET @ID := 1356; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Estoy en medio de una tarea muy importante. Negocios de prospector. A menos que tengas algo igualmente importante que decir, lo cual dudo, tendrás que disculparme.', 0), +(@ID, 0, 'esMX', 'Estoy en medio de una tarea muy importante. Negocios de prospector. A menos que tengas algo igualmente importante que decir, lo cual dudo, tendrás que disculparme.', 0); +-- 1092 Capitán Rugelfuss +SET @ID := 1092; +DELETE FROM `quest_greeting` WHERE `ID` = @ID AND `Type` = 0; +INSERT INTO `quest_greeting` (`ID`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES (@ID, 0, 0, 0, 'Greetings, $n.', 0); +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Saludos, $n.', 0), +(@ID, 0, 'esMX', 'Saludos, $n.', 0); +-- 714 Talin Ojo Ávido +SET @ID := 714; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', '¡Saludos, $c! Buen día para cazar, ¿no crees? Yo también he tenido más que un poco de suerte con los jabalíes. ¿Quizás te gustaría un trago?', 0), +(@ID, 0, 'esMX', '¡Saludos, $c! Buen día para cazar, ¿no crees? Yo también he tenido más que un poco de suerte con los jabalíes. ¿Quizás te gustaría un trago?', 0); +-- 786 Grelin Barbablanca +SET @ID := 786; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Saludos, $gmuchacho:muchacha;. Soy Grelin Whitebeard. Estoy aquí para examinar la amenaza que representa el creciente número de trolls en valle Crestanevada. ¿Qué he encontrado?... Es un poco preocupante...', 0), +(@ID, 0, 'esMX', 'Saludos, $gmuchacho:muchacha;. Soy Grelin Whitebeard. Estoy aquí para examinar la amenaza que representa el creciente número de trolls en valle Crestanevada. ¿Qué he encontrado?... Es un poco preocupante...', 0); +-- 2086 Valstag Quijahierro +SET @ID := 2086; +DELETE FROM `quest_greeting` WHERE `ID` = @ID AND `Type` = 0; +INSERT INTO `quest_greeting` (`ID`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES (@ID, 0, 0, 0, 'Greetings, $n.', 0); +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Saludos, $n.', 0), +(@ID, 0, 'esMX', 'Saludos, $n.', 0); +-- 2094 James Halloran +SET @ID := 2094; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Saludos, $c. Estoy en un pequeño aprieto en este momento, me estoy quedando sin pieles.', 0), +(@ID, 0, 'esMX', 'Saludos, $c. Estoy en un pequeño aprieto en este momento, me estoy quedando sin pieles.', 0); +-- 1239 Contramaestre Fistimos +SET @ID := 1239; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Si estás dispuesto a soportar cuentos que te hagan temblar las piernas y hagan que te empapes las botas, entonces tómate un trago y siéntate a descansar...', 0), +(@ID, 0, 'esMX', 'Si estás dispuesto a soportar cuentos que te hagan temblar las piernas y hagan que te empapes las botas, entonces tómate un trago y siéntate a descansar...', 0); +-- 1141 Angus Stern +SET @ID := 1141; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Si estás aquí por la comida, ¡$gbienvenido:bienvenida;! No encontrarás mejor restaurante en toda Ventormenta ... ¡o Azeroth!$B$BSi estás aquí por otros asuntos, se breve. Tengo una docena de platos en preparación y debo cuidar de cada uno.', 0), +(@ID, 0, 'esMX', 'Si estás aquí por la comida, ¡$gbienvenido:bienvenida;! No encontrarás mejor restaurante en toda Ventormenta ... ¡o Azeroth!$B$BSi estás aquí por otros asuntos, se breve. Tengo una docena de platos en preparación y debo cuidar de cada uno.', 0); +-- 2700 Capitana Nials +SET @ID := 2700; +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'En el Refugio de la Zaga tenemos uno de los pocos territorio de Stromgarde que quedan en las Tierras Altas de Arathi. Y estamos perdiendo terreno...$B$BSi tiene algo para mí, espero que sean buenas noticias.', 0), +(@ID, 0, 'esMX', 'En el Refugio de la Zaga tenemos uno de los pocos territorio de Stromgarde que quedan en las Tierras Altas de Arathi. Y estamos perdiendo terreno...$B$BSi tiene algo para mí, espero que sean buenas noticias.', 0); +-- 1284 Arzobispo Benedictus +SET @ID := 1284; +DELETE FROM `quest_greeting` WHERE `ID` = @ID AND `Type` = 0; +INSERT INTO `quest_greeting` (`ID`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES (@ID, 0, 0, 0, 'Greetings, $n.', 0); +DELETE FROM `quest_greeting_locale` WHERE `ID` = @ID AND `Type` = 0 AND `locale` IN ('esES', 'esMX'); +INSERT INTO `quest_greeting_locale` (`ID`, `Type`, `locale`, `Greeting`, `VerifiedBuild`) VALUES +(@ID, 0, 'esES', 'Saludos, $n.', 0), +(@ID, 0, 'esMX', 'Saludos, $n.', 0); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_02_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_02_world_335.sql new file mode 100644 index 00000000000..1734140c64c --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_02_world_335.sql @@ -0,0 +1,26 @@ +-- +UPDATE `areatrigger_teleport` SET `VerifiedBuild` = 15882 WHERE `ID` IN (2547,2548,2549); + +UPDATE `areatrigger_teleport` SET /*Zul'Gurub Exit*/ `target_position_x`=-11916.2, `target_position_y`=-1209.47, `target_position_z`=92.2873, `target_orientation`=1.57079, `VerifiedBuild`=15882 WHERE `ID`=3930; -- WSL 3995 +UPDATE `areatrigger_teleport` SET /*Deeprun Tram - Ironforge Instance (Inside)*/ `target_position_x`=-4839.51, `target_position_y`=-1317.74, `target_position_z`=501.868, `target_orientation`=1.48352, `VerifiedBuild`=15882 WHERE `ID`=2166; -- WSL 3648 +UPDATE `areatrigger_teleport` SET /*Deeprun Tram - Stormwind Instance*/ `target_position_x`=67.7607, `target_position_y`=2490.98, `target_position_z`=-4.29649, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `ID`=2173; -- WSL 3650 +UPDATE `areatrigger_teleport` SET /*Deeprun Tram - Stormwind Instance*/ `target_position_x`=69.2277, `target_position_y`=10.3932, `target_position_z`=-4.29665, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `ID`=2175; -- WSL 3651 +UPDATE `areatrigger_teleport` SET /*Stratholme - Eastern Plaguelands Instance*/ `target_position_x`=3590.87, `target_position_y`=-3643.22, `target_position_z`=138.491, `target_orientation`=5.49778, `VerifiedBuild`=15882 WHERE `ID`=2214; -- WSL 3652 +UPDATE `areatrigger_teleport` SET /*Stratholme - Eastern Plaguelands Instance*/ `target_position_x`=3233.06, `target_position_y`=-4048.3, `target_position_z`=108.442, `target_orientation`=2.00712, `VerifiedBuild`=15882 WHERE `ID`=2221; -- WSL 3655 +-- Sometimes Z position may look incorrect but it's correct https://youtu.be/2GxM9F192MA?t=18 +UPDATE `areatrigger_teleport` SET /*Blackrock Mountain - Searing Gorge Instance*/ `target_position_x`=456.929, `target_position_y`=34.0923, `target_position_z`=-68.0896, `target_orientation`=4.71238, `VerifiedBuild`=15882 WHERE `ID`=1466; -- WSL 3643 +UPDATE `areatrigger_teleport` SET /*Blackrock Spire - Searing Gorge Instance (Inside)*/ `target_position_x`=78.3534, `target_position_y`=-226.841, `target_position_z`=49.7662, `target_orientation`=4.71238, `VerifiedBuild`=15882 WHERE `ID`=1468; -- WSL 3644 +UPDATE `areatrigger_teleport` SET /*Blackrock Spire - Searing Gorge Instance*/ `target_position_x`=-7524.65, `target_position_y`=-1229.13, `target_position_z`=285.731, `target_orientation`=2.09439, `VerifiedBuild`=15882 WHERE `ID`=1470; -- WSL 3645 +UPDATE `areatrigger_teleport` SET /*Blackrock Dephts - Searing Gorge Instance*/ `target_position_x`=-7178.41, `target_position_y`=-922.152, `target_position_z`=166.092, `target_orientation`=2.00712, `VerifiedBuild`=15882 WHERE `ID`=1472; -- WSL 3646 +UPDATE `areatrigger_teleport` SET /*Razorfen Downs Entrance*/ `target_position_x`=2593.68, `target_position_y`=1111.23, `target_position_z`=50.9518, `target_orientation`=4.71238, `VerifiedBuild`=15882 WHERE `ID`=442; -- WSL 3614 +UPDATE `areatrigger_teleport` SET /*Gnomeregan Entrance*/ `target_position_x`=-329.484, `target_position_y`=-3.22991, `target_position_z`=-152.846, `target_orientation`=2.96705, `VerifiedBuild`=15882 WHERE `ID`=324; -- WSL 3613 +UPDATE `areatrigger_teleport` SET /*Blackphantom Deeps Entrance*/ `target_position_x`=-150.234, `target_position_y`=106.594, `target_position_z`=-39.779, `target_orientation`=4.45058, `VerifiedBuild`=15882 WHERE `ID`=257; -- WSL 3608 +UPDATE `areatrigger_teleport` SET /*Shadowfang Keep Entrance*/ `target_position_x`=-228.191, `target_position_y`=2111.41, `target_position_z`=76.8904, `target_orientation`=1.22173, `VerifiedBuild`=15882 WHERE `ID`=145; -- WSL 3602 +UPDATE `areatrigger_teleport` SET /*DeadMines Instance Start*/ `target_position_x`=-11208, `target_position_y`=1676.41, `target_position_z`=24.5716, `target_orientation`=4.71238, `VerifiedBuild`=15882 WHERE `ID`=119; -- WSL 3601 + +-- 6.28319 is value converted from 360 degree, actually 0 is used +UPDATE `areatrigger_teleport` SET `target_orientation` = 0 WHERE `ID` IN (924,2410,2411,2547,2548,2549,3133,3185,3190,4131,4364,4397,4416,4468,4469,4470,4598,4619); + +DELETE FROM `areatrigger_teleport` WHERE `ID` = 2068; +INSERT INTO `areatrigger_teleport` (`ID`,`Name`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`,`VerifiedBuild`) VALUES +(2068,"Blackrock Spire - Target - Shaft",0,-7558.39,-1309.43,248.454,1.57079,15882); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_03_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_03_world.sql new file mode 100644 index 00000000000..96a20f57938 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_03_world.sql @@ -0,0 +1,13 @@ +-- Instructor Razuvious Event +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2835700,2835701,-129391,12939100,-129390,12939000,28391) AND `action_type`=48; +-- Acherus Necromancer SAI +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=-129391 AND `id`=0 AND `link`=1 AND `source_type`=0; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=-129390 AND `id`=0 AND `link`=1 AND `source_type`=0; +-- Death Knight Initiate SAI +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=28391 AND `id`=1 AND `link`=6 AND `source_type`=0; + +-- Gothik the Harvester Event +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (28890,28906,28897) AND `action_type`=48; +-- Scourge Gryphon SAI +UPDATE `smart_scripts` SET `event_type`=38,`event_param1`=1,`event_param2`=1 WHERE `entryorguid`=28906 AND `id`=1 AND `event_type`=61 AND `source_type`=0; +UPDATE `smart_scripts` SET `event_type`=38,`event_param1`=2,`event_param2`=2 WHERE `entryorguid`=28906 AND `id`=4 AND `event_type`=61 AND `source_type`=0; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_04_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_04_world.sql new file mode 100644 index 00000000000..b64aa312288 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_04_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `smart_scripts` SET `action_type` = 15 WHERE `entryorguid` = 197802 AND `source_type` = 9 AND `id` = 1; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_05_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_05_world.sql new file mode 100644 index 00000000000..d4aeeb104df --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_05_world.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid` = 1947 AND `source_type` = 0 AND `id` IN (4,5); +DELETE FROM `smart_scripts` WHERE `entryorguid` = 194700 AND `source_type` = 9; +DELETE FROM `creature_text` WHERE `CreatureID` = 1947; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_06_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_06_world.sql new file mode 100644 index 00000000000..e1c80df1475 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_06_world.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `command` WHERE `name`='debug warden force'; +INSERT INTO `command` (`name`,`permission`,`help`) VALUES +('debug warden force', 300, 'Syntax: .debug warden force id1 [id2 [id3 [...]]] + +Queues the specified Warden checks for your client. They will be sent according to your Warden settings.'); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_20_00_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_20_00_world.sql new file mode 100644 index 00000000000..e599ed191d1 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_20_00_world.sql @@ -0,0 +1,16 @@ +-- +ALTER TABLE `warden_checks` + MODIFY COLUMN `str` VARCHAR(170) DEFAULT NULL, + MODIFY COLUMN `result` VARBINARY(24) DEFAULT NULL; + +-- shift all warden checks down by 1 so we no longer have a gap at id 0 +-- (left join is for reapply safety) +UPDATE `warden_checks` wc1 + LEFT JOIN `warden_checks` wc2 ON `wc2`.`id` = 0 + SET `wc1`.`id` = `wc1`.`id`-1 + WHERE `wc2`.`id` IS NULL; + +DELETE FROM `warden_checks` WHERE `id` IN (786,787); +INSERT INTO `warden_checks` (`id`,`type`,`str`,`address`,`length`,`result`, `comment`) VALUES +(786, 243, NULL, 0x819210, 16, UNHEX('558BEC518305A013D40001A19C13D400'), 'FrameScript::Execute'), +(787, 243, NULL, 0x84F860, 15, UNHEX('558BEC8B4D108B450C83EC0883F903'), 'FrameScript::lua_loadbuffer'); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_20_01_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_20_01_world.sql new file mode 100644 index 00000000000..e4d1a60b44f --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_20_01_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `warden_checks` SET `length`=NULL WHERE `type`=243; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_00_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_00_world.sql new file mode 100644 index 00000000000..fbe7598a97b --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_00_world.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `warden_checks` WHERE `id` IN (788,789,790); +INSERT INTO `warden_checks` (`id`,`type`,`str`,`address`,`length`,`result`, `comment`) VALUES +(788, 139, 'forceinsecure() return issecure()', NULL, NULL, NULL, 'Detects naive Lua unlockers'), +(789, 139, 'return not not PQR_IsMoving', NULL, NULL, NULL, 'Detects PQR'), +(790, 139, 'local f=DEFAULT_CHAT_FRAME for i=1,f:GetNumMessages() do if (f:GetMessageInfo(i)):find("|cffffd200PQR|r") then return true end end', NULL, NULL, NULL, 'Detects PQR'); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_01_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_01_world.sql new file mode 100644 index 00000000000..217e6b5ce46 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_01_world.sql @@ -0,0 +1,2 @@ +-- Remove SMARTCAST_INTERRUPT_PREVIOUS from more event types +UPDATE `smart_scripts` SET `action_param2` = `action_param2` &~1 WHERE `event_type` IN (6,8,38,40,60,75) AND `event_flags` & 1 = 0 AND `action_type` = 11 AND `source_type` = 0 AND `action_param2` & 1; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_02_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_02_world_335.sql new file mode 100644 index 00000000000..0950d59a4f5 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_02_world_335.sql @@ -0,0 +1,3 @@ +-- Adjust reputation amount given after killing members of Gelkis / Magram Clan Centaur +-- +20 and -100 instead of +100 and -500 +UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1` = 20, `RewOnKillRepValue2` = -100 WHERE `RewOnKillRepFaction1` IN (92,93); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_03_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_03_world_335.sql new file mode 100644 index 00000000000..3b68f6745fe --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_03_world_335.sql @@ -0,0 +1,493 @@ +-- NYI spells 19770 Apply Area Aura - Party: Dummy, 19768 +-- Despawn if player abbandoned quest is not implemented (works with all escorts?) https://www.wowhead.com/npc=12245/vendor-tron-1000#comments:id=632118 +-- They respawns in wrong place https://www.wowhead.com/npc=12245/vendor-tron-1000#comments:id=632118 +-- Path was probably sniffed but some points are incorrect +-- Despawn if player was killed or one of caravan's member was killed(requires research) is not implemented + +-- Cork Gizelton SAI +SET @ID := 11625; +UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = @ID; +DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID AND `source_type` = 0; +DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN @ID*100+0 AND @ID*100+12 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 +(@ID,0,0,1,11,0,100,0,0,0,0,0,0,53,1,11625,1,0,0,2,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Respawn - Start Waypoint"), +(@ID,0,1,2,61,0,100,0,0,0,0,0,0,83,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Link - Remove NPC Flags Gossip & Questgiver"), +(@ID,0,2,0,61,0,100,0,0,0,0,0,0,83,3,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Link - Remove NPC Flags Gossip & Questgiver (Rigger Gizelton)"), +-- Player accepted Rigger's quest +(@ID,0,3,4,38,0,100,0,0,1,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Data Set 0 1 - Resume Waypoint"), +(@ID,0,4,5,61,0,100,0,0,0,0,0,0,59,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Link - Set Run Off"), +(@ID,0,5,0,61,0,100,0,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Link - Set Event Phase 1"), + +(@ID,0,6,0,40,0,100,0,52,0,0,0,0,80,@ID*100+0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 52 Reached - Run Script"), +(@ID,0,7,0,40,0,100,0,76,0,0,0,0,80,@ID*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 76 Reached - Run Script"), +(@ID,0,8,0,40,1,100,0,84,0,0,0,0,80,@ID*100+2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 84 Reached - Run Script (Phase 1)"), +(@ID,0,9,0,40,1,100,0,92,0,0,0,0,80,@ID*100+3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 92 Reached - Run Script (Phase 1)"), +(@ID,0,10,0,40,1,100,0,100,0,0,0,0,80,@ID*100+4,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 100 Reached - Run Script (Phase 1)"), +(@ID,0,11,0,40,1,100,0,107,0,0,0,0,80,@ID*100+5,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 107 Reached - Run Script (Phase 1)"), +(@ID,0,12,0,40,0,100,0,193,0,0,0,0,80,@ID*100+6,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 193 Reached - Run Script"), +(@ID,0,13,0,40,0,100,0,209,0,0,0,0,80,@ID*100+7,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 209 Reached - Run Script"), +(@ID,0,14,0,40,1,100,0,215,0,0,0,0,80,@ID*100+8,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 215 Reached - Run Script (Phase 1)"), +(@ID,0,15,0,40,1,100,0,223,0,0,0,0,80,@ID*100+9,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 223 Reached - Run Script (Phase 1)"), +(@ID,0,16,0,40,1,100,0,233,0,0,0,0,80,@ID*100+10,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 233 Reached - Run Script (Phase 1)"), +(@ID,0,17,0,40,1,100,0,240,0,0,0,0,80,@ID*100+11,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 240 Reached - Run Script (Phase 1)"), + +(@ID,0,18,0,19,0,100,0,5821,0,0,0,0,80,@ID*100+12,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Quest 'Bodyguard for Hire' Taken - Run Script"), +(@ID,0,19,20,6,0,100,0,0,0,0,0,0,6,5821,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Cork Gizelton - On Death - Fail Quest 'Bodyguard for Hire'"), +(@ID,0,20,21,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Link - Despawn Instant (Rigger Gizelton)"), +(@ID,0,21,22,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,11,11564,100,0,0,0,0,0,0,"Cork Gizelton - On Link - Despawn Instant (Gizelton Caravan Kodo)"), +(@ID,0,22,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Link - Despawn Instant"), + +-- Vendor-Tron 1000 +(@ID*100+0,9,0,0,0,0,100,0,0,0,0,0,0,54,600000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"), +(@ID*100+0,9,1,0,0,0,100,0,0,0,0,0,0,107,6,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 6"), +(@ID*100+0,9,2,0,0,0,100,0,0,0,0,0,0,82,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Add NPC Flag Gossip"), +(@ID*100+0,9,3,0,0,0,100,0,600000,600000,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 0"), +(@ID*100+0,9,4,0,0,0,100,0,0,0,0,0,0,83,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove NPC Flag Gossip"), +-- Propose Bodyguard for Hire +(@ID*100+1,9,0,0,0,0,100,0,0,0,0,0,0,54,300000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"), +(@ID*100+1,9,1,0,0,0,100,0,0,0,0,0,0,82,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Add NPC Flag Questgiver"), +(@ID*100+1,9,2,0,0,0,100,0,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 1"), +(@ID*100+1,9,3,0,0,0,100,0,300000,300000,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove NPC Flag Questgiver"), +-- Kolkar ambush 1 https://youtu.be/9TLf3OF9gLM?t=69 +(@ID*100+2,9,0,0,0,0,100,0,0,0,0,0,0,54,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"), +(@ID*100+2,9,1,0,0,0,100,0,3000,3000,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 2"), +(@ID*100+2,9,2,0,0,0,100,0,2000,2000,0,0,0,107,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 0"), +-- Kolkar ambush 2 https://youtu.be/9TLf3OF9gLM?t=185 +(@ID*100+3,9,0,0,0,0,100,0,0,0,0,0,0,54,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"), +(@ID*100+3,9,1,0,0,0,100,0,3000,3000,0,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 3"), +(@ID*100+3,9,2,0,0,0,100,0,2000,2000,0,0,0,107,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 1"), +-- Kolkar ambush 3 https://youtu.be/9TLf3OF9gLM?t=327 +(@ID*100+4,9,0,0,0,0,100,0,0,0,0,0,0,54,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"), +(@ID*100+4,9,1,0,0,0,100,0,3000,3000,0,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 4"), +(@ID*100+4,9,2,0,0,0,100,0,2000,2000,0,0,0,107,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 2"), +-- Complete https://youtu.be/9TLf3OF9gLM?t=449 +(@ID*100+5,9,0,0,0,0,100,0,0,0,0,0,0,54,7000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"), +(@ID*100+5,9,1,0,0,0,100,0,0,0,0,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 5"), +(@ID*100+5,9,2,0,0,0,100,0,0,0,0,0,0,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 35"), +(@ID*100+5,9,3,0,0,0,100,0,0,0,0,0,0,2,35,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 35 (Rigger Gizelton)"), +(@ID*100+5,9,4,0,0,0,100,0,0,0,0,0,0,2,35,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 35 (Gizelton Caravan Kodo)"), +(@ID*100+5,9,5,0,0,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Flag Immune To NPC's"), +(@ID*100+5,9,6,0,0,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Flag Immune To NPC's (Rigger Gizelton)"), +(@ID*100+5,9,7,0,0,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Flag Immune To NPC's (Gizelton Caravan Kodo)"), +(@ID*100+5,9,8,0,0,0,100,0,0,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Run On"), +(@ID*100+5,9,9,0,0,0,100,0,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Event Phase 0"), +(@ID*100+5,9,10,0,0,0,100,0,7000,7000,0,0,0,15,5821,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Quest Credit 'Bodyguard for Hire'"), +-- Super-Seller 680 +(@ID*100+6,9,0,0,0,0,100,0,0,0,0,0,0,54,600000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"), +(@ID*100+6,9,1,0,0,0,100,0,0,0,0,0,0,107,7,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 7"), +(@ID*100+6,9,2,0,0,0,100,0,0,0,0,0,0,82,1,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Add NPC Flag Gossip (Rigger Gizelton)"), +(@ID*100+6,9,3,0,0,0,100,0,600000,600000,0,0,0,1,0,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 0 (Rigger Gizelton)"), +(@ID*100+6,9,4,0,0,0,100,0,0,0,0,0,0,83,1,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove NPC Flag Gossip (Rigger Gizelton)"), +-- Propose Gizelton Caravan +(@ID*100+7,9,0,0,0,0,100,0,0,0,0,0,0,54,300000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"), +(@ID*100+7,9,1,0,0,0,100,0,0,0,0,0,0,82,2,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Add NPC Flag Questgiver (Rigger Gizelton)"), +(@ID*100+7,9,2,0,0,0,100,0,0,0,0,0,0,1,1,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 1 (Rigger Gizelton)"), +(@ID*100+7,9,3,0,0,0,100,0,300000,300000,0,0,0,83,2,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove NPC Flag Questgiver (Rigger Gizelton)"), +-- Demon ambush 1 https://youtu.be/3-kKd4VNuU8?t=47 +(@ID*100+8,9,0,0,0,0,100,0,0,0,0,0,0,54,2000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"), +(@ID*100+8,9,1,0,0,0,100,0,2000,2000,0,0,0,1,2,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 2 (Rigger Gizelton)"), +(@ID*100+8,9,2,0,0,0,100,0,1000,1000,0,0,0,107,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 3"), +-- Demon ambush 2 https://youtu.be/3-kKd4VNuU8?t=106 +(@ID*100+9,9,0,0,0,0,100,0,0,0,0,0,0,54,2000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"), +(@ID*100+9,9,1,0,0,0,100,0,2000,2000,0,0,0,1,3,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 3 (Rigger Gizelton)"), +(@ID*100+9,9,2,0,0,0,100,0,1000,1000,0,0,0,107,4,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 4"), +-- Demon ambush 2 https://youtu.be/3-kKd4VNuU8?t=161 +(@ID*100+10,9,0,0,0,0,100,0,0,0,0,0,0,54,2000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"), +(@ID*100+10,9,1,0,0,0,100,0,2000,2000,0,0,0,1,4,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 4 (Rigger Gizelton)"), +(@ID*100+10,9,2,0,0,0,100,0,1000,1000,0,0,0,107,5,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 5"), +-- Complete https://youtu.be/3-kKd4VNuU8?t=226 +(@ID*100+11,9,0,0,0,0,100,0,0,0,0,0,0,54,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"), +(@ID*100+11,9,1,0,0,0,100,0,0,0,0,0,0,1,5,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 5 (Rigger Gizelton)"), +(@ID*100+11,9,2,0,0,0,100,0,0,0,0,0,0,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 35"), +(@ID*100+11,9,3,0,0,0,100,0,0,0,0,0,0,2,35,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 35 (Rigger Gizelton)"), +(@ID*100+11,9,4,0,0,0,100,0,0,0,0,0,0,2,35,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 35 (Gizelton Caravan Kodo)"), +(@ID*100+11,9,5,0,0,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Flag Immune To NPC's"), +(@ID*100+11,9,6,0,0,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Flag Immune To NPC's (Rigger Gizelton)"), +(@ID*100+11,9,7,0,0,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Flag Immune To NPC's (Gizelton Caravan Kodo)"), +(@ID*100+11,9,8,0,0,0,100,0,0,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Run On"), +(@ID*100+11,9,9,0,0,0,100,0,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Event Phase 0"), +(@ID*100+11,9,10,0,0,0,100,0,3000,3000,0,0,0,15,5943,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Quest Credit 'Gizelton Caravan'"), + +-- Not a group quest, do not store party's guids +-- https://www.wowhead.com/quest=5943/gizelton-caravan#comments:id=666145 +(@ID*100+12,9,0,0,0,0,100,0,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Store Targetlist"), +(@ID*100+12,9,1,0,0,0,100,0,0,0,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Resume Waypoint"), +(@ID*100+12,9,2,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,"Cork Gizelton - On Script - Set Event Phase 1"), +(@ID*100+12,9,3,0,0,0,100,0,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove NPC Flag Questgiver"), +(@ID*100+12,9,4,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 113"), +(@ID*100+12,9,5,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 113 (Rigger Gizelton)"), +(@ID*100+12,9,6,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 113 (Gizelton Caravan Kodo)"), +(@ID*100+12,9,7,0,0,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove Flag Immune To NPC's"), +(@ID*100+12,9,8,0,0,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove Flag Immune To NPC's (Rigger Gizelton)"), +(@ID*100+12,9,9,0,0,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove Flag Immune To NPC's (Gizelton Caravan Kodo)"), +(@ID*100+12,9,10,0,0,0,100,0,0,0,0,0,0,59,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Run Off"); + +DELETE FROM `creature_text` WHERE `CreatureID` = @ID; +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(@ID,0,0,"So sorry to leave a customer but we have places to go and people to swindle. We will be back sometime later today. Good-bye!",12,0,100,0,0,0,7505,0,"Cork Gizelton"), +-- Probably zonewide +(@ID,1,0,"I am looking for some bodyguards that would like to protect the Gizelton Caravan. We are stopped on the road east of Kormek's Hut, north of Kolkar Centaur Village.",14,0,100,0,0,0,7474,0,"Cork Gizelton"), +(@ID,2,0,"Hey, you call yourself a body guard? Get to work and protect us...",12,0,100,0,0,0,7310,0,"Cork Gizelton"), +(@ID,3,0,"Mister body guard, are you going to earn your money or what?",12,0,100,0,0,0,7311,0,"Cork Gizelton"), +(@ID,4,0,"You're fired! <Cough...Cork clears throat.> I mean, help!",12,0,100,0,0,0,7312,0,"Cork Gizelton"), +(@ID,5,0,"Blast those stupid centaurs! Sigh - well, it seems you kept your bargain. Up the road you shall find Smeed Scrabblescrew, he has your money.",12,0,100,0,0,0,7334,0,"Cork Gizelton"); + +DELETE FROM `creature_summon_groups` WHERE `summonerId` = @ID AND `summonerType` = 0; +INSERT INTO `creature_summon_groups` (`summonerId`,`summonerType`,`groupId`,`entry`,`position_x`,`position_y`,`position_z`,`orientation`,`summonType`,`summonTime`,`Comment`) VALUES +(@ID,0,0,12976,-786.496399,1186.830444,98.872955,4.338541,4,60000,"Cork Gizelton - Group 0 - Kolkar Waylayer"), +(@ID,0,0,12976,-810.522156,1168.825928,99.596046,1.259777,4,60000,"Cork Gizelton - Group 0 - Kolkar Waylayer"), +(@ID,0,0,12977,-804.962158,1184.335938,99.555801,4.977856,4,60000,"Cork Gizelton - Group 0 - Kolkar Ambusher"), +(@ID,0,0,12977,-789.564453,1167.567505,97.738983,2.225817,4,60000,"Cork Gizelton - Group 0 - Kolkar Ambusher"), +(@ID,0,1,12976,-941.752502,1171.344360,91.599319,1.051649,4,60000,"Cork Gizelton - Group 1 - Kolkar Waylayer"), +(@ID,0,1,12976,-915.573914,1171.861816,94.556068,0.702927,4,60000,"Cork Gizelton - Group 1 - Kolkar Waylayer"), +(@ID,0,1,12977,-931.896179,1188.513672,92.509621,4.437494,4,60000,"Cork Gizelton - Group 1 - Kolkar Ambusher"), +(@ID,0,1,12977,-907.493713,1190.668213,95.699776,4.036945,4,60000,"Cork Gizelton - Group 1 - Kolkar Ambusher"), +(@ID,0,2,12976,-1114.50512,1197.017822,89.739799,5.670575,4,60000,"Cork Gizelton - Group 2 - Kolkar Waylayer"), +(@ID,0,2,12976,-1086.44262,1176.773315,89.744904,2.301221,4,60000,"Cork Gizelton - Group 2 - Kolkar Waylayer"), +(@ID,0,2,12977,-1108.92358,1180.153076,89.740318,0.526221,4,60000,"Cork Gizelton - Group 2 - Kolkar Ambusher"), +(@ID,0,2,12977,-1094.88842,1196.839111,89.739746,4.555314,4,60000,"Cork Gizelton - Group 2 - Kolkar Ambusher"), +(@ID,0,3,4676,-1818.365112,2051.031738,61.448582,1.282561,4,60000,"Cork Gizelton - Group 3 - Lesser Infernal"), +(@ID,0,3,4677,-1819.779419,2082.620117,65.348495,5.704354,4,60000,"Cork Gizelton - Group 3 - Doomwarder"), +(@ID,0,3,4684,-1825.155640,2059.577393,61.964958,0.885935,4,60000,"Cork Gizelton - Group 3 - Nether Sorceress"), +(@ID,0,4,4676,-1787.307495,1923.290405,59.631226,2.902831,4,60000,"Cork Gizelton - Group 4 - Lesser Infernal"), +(@ID,0,4,4677,-1801.117310,1935.664307,60.699883,0.722568,4,60000,"Cork Gizelton - Group 4 - Doomwarder"), +(@ID,0,4,4684,-1783.754150,1942.123413,60.261951,2.759897,4,60000,"Cork Gizelton - Group 4 - Nether Sorceress"), +(@ID,0,5,4676,-1671.754150,1855.579102,59.029522,1.452987,4,60000,"Cork Gizelton - Group 5 - Lesser Infernal"), +(@ID,0,5,4677,-1692.874023,1858.821533,58.936962,4.662123,4,60000,"Cork Gizelton - Group 5 - Doomwarder"), +-- Both of them were sniffed in TBC +(@ID,0,6,12245,-692.743,1522.2,90.3611,0.558505,3,600000,"Cork Gizelton - Group 6 - Vendor-Tron 1000"), +(@ID,0,7,12246,-1926.6,2412.79,60.6956,0.174533,3,600000,"Cork Gizelton - Group 7 - Super-Seller 680"); + +-- Rigger Gizelton SAI +SET @ID := 11626; +UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = @ID; +DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID AND `source_type` = 0; +DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID*100+0 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 +(@ID,0,0,0,19,0,100,0,5943,0,0,0,0,80,@ID*100+0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Rigger Gizelton - On Quest 'Gizelton Caravan' Taken - Run Script"), +(@ID,0,1,2,6,0,100,0,0,0,0,0,0,6,5943,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Rigger Gizelton - On Death - Fail Quest 'Gizelton Caravan'"), +(@ID,0,2,3,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,19,11625,0,0,0,0,0,0,0,"Rigger Gizelton - On Link - Despawn Instant (Cork Gizelton)"), +(@ID,0,3,4,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,11,11564,100,0,0,0,0,0,0,"Rigger Gizelton - On Link - Despawn Instant (Gizelton Caravan Kodo)"), +(@ID,0,4,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Rigger Gizelton - On Link - Despawn Instant"), + +-- Not a group quest, do not store party's guids +-- https://www.wowhead.com/quest=5943/gizelton-caravan#comments:id=666145 +(@ID*100+0,9,0,0,0,0,100,0,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Store Targetlist"), +(@ID*100+0,9,1,0,0,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,19,11625,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Send Target 1 (Cork Gizelton)"), +(@ID*100+0,9,2,0,0,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,19,11625,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Set Data 0 1 (Cork Gizelton)"), +(@ID*100+0,9,3,0,0,0,100,0,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Remove NPC Flag Questgiver"), +(@ID*100+0,9,4,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Set Faction 113"), +(@ID*100+0,9,5,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,19,11625,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Set Faction 113 (Cork Gizelton)"), +(@ID*100+0,9,6,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Rigger Gizelton - On Script - Set Faction 113 (Gizelton Caravan Kodo)"), +(@ID*100+0,9,7,0,0,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Remove Flag Immune To NPC's"), +(@ID*100+0,9,8,0,0,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,19,11625,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Remove Flag Immune To NPC's (Cork Gizelton)"), +(@ID*100+0,9,9,0,0,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Rigger Gizelton - On Script - Remove Flag Immune To NPC's (Gizelton Caravan Kodo)"); + +DELETE FROM `creature_text` WHERE `CreatureID` = @ID; +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(@ID,0,0,"Time for the Gizleton Caravan to head on out! We'll be back soon but if you cannot wait, head north to Kormek's Hut. We open shop in about an hour.",12,0,100,0,0,0,7506,0,"Rigger Gizelton"), +(@ID,1,0,"This is Rigger Gizelton asking for assistance escorting my caravan past Mannoroc Coven. I'm on the road east of Shadowprey village.",14,0,100,0,0,0,7475,0,"Rigger Gizelton"), +(@ID,2,0,"Eeck! Demons appear hungry for the kodos!",12,0,100,0,0,0,7330,0,"Rigger Gizelton"), +(@ID,3,0,"What am I paying you for? The kodos are nearly dead!",12,0,100,0,0,0,7331,0,"Rigger Gizelton"), +(@ID,4,0,"Only if I were about five feet taller, then I would show these blasphemous demons a thing or two! Help!",12,0,100,0,0,0,7332,0,"Rigger Gizelton"), +(@ID,5,0,"Wow! We did it... not sure why we thought we needed the likes of you. Nevertheless, speak with Smeed Scrabblescrew; he will give you your earnings! +",12,0,100,0,0,0,7333,0,"Rigger Gizelton"); + +DELETE FROM `waypoint_data` WHERE `id` IN (272900,272890,287140,287280); +UPDATE `creature` SET `MovementType` = 0 WHERE `id` IN (11564,11625,11626); +UPDATE `creature_addon` SET `path_id` = 0 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (11564,11625,11626)); + +DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (12245,12246)); +DELETE FROM `creature` WHERE `id` IN (12245,12246); + +DELETE FROM `creature_formations` WHERE `leaderGUID` = 28714; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(28714,28714,0,0,515,0,0), +(28714,28728,8,360,515,0,0), +(28714,27290,18,360,515,0,0), +(28714,27289,28,360,515,0,0); + +DELETE FROM `waypoints` WHERE `entry` = 11625; +INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES +(11625,1,-1290.31,1231.38,109.237,"Cork Gizelton"), +(11625,2,-1277.59,1225.54,108.85,"Cork Gizelton"), +(11625,3,-1264.86,1219.71,108.452,"Cork Gizelton"), +(11625,4,-1230.04,1204.31,104.374,"Cork Gizelton"), +(11625,5,-1216.17,1206.24,101.889,"Cork Gizelton"), +(11625,6,-1202.32,1208.28,99.7026,"Cork Gizelton"), +(11625,7,-1188.03,1207.66,97.2208,"Cork Gizelton"), +(11625,8,-1170.99,1195.93,94.5615,"Cork Gizelton"), +(11625,9,-1155.46,1192.16,92.4374,"Cork Gizelton"), +(11625,10,-1127.52,1190.39,89.8358,"Cork Gizelton"), +(11625,11,-1113.58,1189.12,89.7403,"Cork Gizelton"), +(11625,12,-1070.8,1186.15,89.7403,"Cork Gizelton"), +(11625,13,-1037.27,1183.2,89.8006,"Cork Gizelton"), +(11625,14,-995.58,1177.92,89.7409,"Cork Gizelton"), +(11625,15,-981.817,1180.48,89.8152,"Cork Gizelton"), +(11625,16,-952.606,1181.99,89.7313,"Cork Gizelton"), +(11625,17,-935.445,1182.25,91.2113,"Cork Gizelton"), +(11625,18,-921.448,1182.53,93.1746,"Cork Gizelton"), +(11625,19,-879.467,1183.72,97.6043,"Cork Gizelton"), +(11625,20,-858.976,1184.22,99.0322,"Cork Gizelton"), +(11625,21,-828.316,1180.2,99.6657,"Cork Gizelton"), +(11625,22,-799.811,1176,99.3364,"Cork Gizelton"), +(11625,23,-757.106,1191.47,96.9164,"Cork Gizelton"), +(11625,24,-731.879,1208.14,92.6956,"Cork Gizelton"), +(11625,25,-719.12,1213.91,91.3297,"Cork Gizelton"), +(11625,26,-706.36,1219.67,90.2856,"Cork Gizelton"), +(11625,27,-689.935,1228.43,89.4426,"Cork Gizelton"), +(11625,28,-679.121,1237.31,89.17,"Cork Gizelton"), +(11625,29,-661.434,1247.28,89.17,"Cork Gizelton"), +(11625,30,-635.655,1258.2,89.2063,"Cork Gizelton"), +(11625,31,-614.489,1269.64,89.1686,"Cork Gizelton"), +(11625,32,-600.078,1274.85,89.1238,"Cork Gizelton"), +(11625,33,-586.268,1277.15,89.145,"Cork Gizelton"), +(11625,34,-546.297,1287.15,89.1597,"Cork Gizelton"), +(11625,35,-541.257,1300.21,89.1602,"Cork Gizelton"), +(11625,36,-536.026,1313.2,89.1314,"Cork Gizelton"), +(11625,37,-525.098,1338.97,89.1005,"Cork Gizelton"), +(11625,38,-518.852,1356.12,89.0827,"Cork Gizelton"), +(11625,39,-516.879,1395.56,89.0827,"Cork Gizelton"), +(11625,40,-518.905,1436.25,89.0696,"Cork Gizelton"), +(11625,41,-525.605,1446.54,88.4907,"Cork Gizelton"), +(11625,42,-543.459,1462.9,88.3752,"Cork Gizelton"), +(11625,43,-557.591,1471.17,88.9477,"Cork Gizelton"), +(11625,44,-584.698,1478.14,88.3754,"Cork Gizelton"), +(11625,45,-598.459,1480.72,88.3754,"Cork Gizelton"), +(11625,46,-632.084,1491.03,88.3754,"Cork Gizelton"), +(11625,47,-644.249,1497.95,88.3754,"Cork Gizelton"), +(11625,48,-660.456,1507.56,88.3874,"Cork Gizelton"), +(11625,49,-666.507,1504.7,89.0746,"Cork Gizelton"), +(11625,50,-673.795,1499.48,90.3922,"Cork Gizelton"), +(11625,51,-692.154,1480.43,90.5302,"Cork Gizelton"), +(11625,52,-710.764,1470.11,91.3034,"Cork Gizelton"), -- Vendor-Tron 1000 +(11625,53,-697.048,1484.75,91.0929,"Cork Gizelton"), +(11625,54,-676.552,1497.37,90.6505,"Cork Gizelton"), +(11625,55,-665.209,1505.76,88.8321,"Cork Gizelton"), +(11625,56,-657.898,1510.94,88.3752,"Cork Gizelton"), +(11625,57,-647.387,1501.69,88.3752,"Cork Gizelton"), +(11625,58,-630.597,1491.17,88.3752,"Cork Gizelton"), +(11625,59,-603.756,1483.26,88.3752,"Cork Gizelton"), +(11625,60,-576.573,1476.54,88.3752,"Cork Gizelton"), +(11625,61,-556.868,1470.92,88.8685,"Cork Gizelton"), +(11625,62,-547.471,1464.89,88.3747,"Cork Gizelton"), +(11625,63,-529.316,1449.97,88.402,"Cork Gizelton"), +(11625,64,-517.699,1433.75,89.0816,"Cork Gizelton"), +(11625,65,-518.09,1405.76,89.0816,"Cork Gizelton"), +(11625,66,-518.149,1377.76,89.0816,"Cork Gizelton"), +(11625,67,-521.289,1350.76,89.0816,"Cork Gizelton"), +(11625,68,-531.625,1324.74,89.1339,"Cork Gizelton"), +(11625,69,-537.391,1311.99,89.1594,"Cork Gizelton"), +(11625,70,-551.845,1284.12,89.1594,"Cork Gizelton"), +(11625,71,-578.054,1278.57,89.1685,"Cork Gizelton"), +(11625,72,-591.957,1276.92,89.1634,"Cork Gizelton"), +(11625,73,-611.806,1271.05,89.1694,"Cork Gizelton"), +(11625,74,-623.928,1264.06,89.1694,"Cork Gizelton"), +(11625,75,-653.384,1249.74,89.1694,"Cork Gizelton"), +(11625,76,-666.372,1244.51,89.1694,"Cork Gizelton"), -- Propose Bodyguard for Hire +(11625,77,-684.6,1232.06,89.2134,"Cork Gizelton"), +(11625,78,-694.027,1225.67,89.6627,"Cork Gizelton"), +(11625,79,-706.605,1219.58,90.2981,"Cork Gizelton"), +(11625,80,-732.184,1208.23,92.7376,"Cork Gizelton"), +(11625,81,-738.514,1204.75,93.8662,"Cork Gizelton"), +(11625,82,-754.159,1193.91,96.6195,"Cork Gizelton"), +(11625,83,-766.62,1187.59,97.8394,"Cork Gizelton"), +(11625,84,-792.515,1177.07,98.8327,"Cork Gizelton"), -- Kolkar ambush 1 https://youtu.be/9TLf3OF9gLM?t=69 +(11625,85,-802.533,1175.57,99.4435,"Cork Gizelton"), +(11625,86,-821.772,1178.84,99.6542,"Cork Gizelton"), +(11625,87,-835.435,1181.9,99.6662,"Cork Gizelton"), +(11625,88,-848.98,1184.67,99.5782,"Cork Gizelton"), +(11625,89,-861.251,1185.3,98.8033,"Cork Gizelton"), +(11625,90,-889.179,1183.34,96.6117,"Cork Gizelton"), +(11625,91,-903.158,1182.57,95.2033,"Cork Gizelton"), +(11625,92,-931.15,1182.17,91.8346,"Cork Gizelton"), -- Kolkar ambush 2 https://youtu.be/9TLf3OF9gLM?t=185 +(11625,93,-945.149,1182.01,89.8612,"Cork Gizelton"), +(11625,94,-959.149,1181.92,89.7397,"Cork Gizelton"), +(11625,95,-973.149,1181.97,89.7397,"Cork Gizelton"), +(11625,96,-1001.65,1178.06,89.7398,"Cork Gizelton"), +(11625,97,-1011.8,1177.4,89.7398,"Cork Gizelton"), +(11625,98,-1033.08,1182.29,89.7629,"Cork Gizelton"), +(11625,99,-1073.62,1186.33,89.7398,"Cork Gizelton"), +(11625,100,-1101.59,1187.56,89.7398,"Cork Gizelton"), -- Kolkar ambush 3 https://youtu.be/9TLf3OF9gLM?t=327 +(11625,101,-1129.48,1190.01,89.8855,"Cork Gizelton"), +(11625,102,-1143.44,1191.11,91.0344,"Cork Gizelton"), +(11625,103,-1166.85,1194.28,93.9649,"Cork Gizelton"), +(11625,104,-1184.71,1203.56,96.6406,"Cork Gizelton"), +(11625,105,-1201.45,1208.2,99.5698,"Cork Gizelton"), +(11625,106,-1225.42,1204.68,103.502,"Cork Gizelton"), +(11625,107,-1235.55,1206.75,105.129,"Cork Gizelton"), -- Complete +(11625,108,-1261.05,1218.25,108.207,"Cork Gizelton"), +(11625,109,-1286.64,1229.58,109.112,"Cork Gizelton"), +(11625,110,-1306.84,1233.21,109.771,"Cork Gizelton"), +(11625,111,-1331.25,1233.54,110.674,"Cork Gizelton"), +(11625,112,-1350.02,1227.22,111.201,"Cork Gizelton"), +(11625,113,-1389.37,1212.53,111.587,"Cork Gizelton"), +(11625,114,-1415.8,1202.23,111.948,"Cork Gizelton"), +(11625,115,-1424.26,1196.81,112.038,"Cork Gizelton"), +(11625,116,-1449.27,1188.13,111.53,"Cork Gizelton"), +(11625,117,-1474.53,1186.42,109.366,"Cork Gizelton"), +(11625,118,-1491.78,1189.4,106.114,"Cork Gizelton"), +(11625,119,-1502.95,1198.12,101.757,"Cork Gizelton"), +(11625,120,-1512.09,1209.44,96.2469,"Cork Gizelton"), +(11625,121,-1520.19,1226.67,89.7861,"Cork Gizelton"), +(11625,122,-1522.75,1243.63,83.3864,"Cork Gizelton"), +(11625,123,-1520.9,1257.51,77.7027,"Cork Gizelton"), +(11625,124,-1518.48,1273.17,71.8991,"Cork Gizelton"), +(11625,125,-1516.17,1290.94,66.8473,"Cork Gizelton"), +(11625,126,-1514.74,1306.19,63.4211,"Cork Gizelton"), +(11625,127,-1511.54,1328.73,60.2051,"Cork Gizelton"), +(11625,128,-1505.75,1341.47,59.2142,"Cork Gizelton"), +(11625,129,-1494.42,1367.08,58.9254,"Cork Gizelton"), +(11625,130,-1485.84,1393.02,58.9251,"Cork Gizelton"), +(11625,131,-1485.47,1407,58.9469,"Cork Gizelton"), +(11625,132,-1487.57,1434.84,58.9347,"Cork Gizelton"), +(11625,133,-1489.45,1448.71,58.9302,"Cork Gizelton"), +(11625,134,-1489.77,1469.49,58.9251,"Cork Gizelton"), +(11625,135,-1483.8,1482.15,58.9251,"Cork Gizelton"), +(11625,136,-1471.32,1507.22,58.9251,"Cork Gizelton"), +(11625,137,-1464.94,1519.68,58.9251,"Cork Gizelton"), +(11625,138,-1452.27,1544.64,58.9251,"Cork Gizelton"), +(11625,139,-1442.94,1584.75,58.9255,"Cork Gizelton"), +(11625,140,-1452.7,1610.98,58.9255,"Cork Gizelton"), +(11625,141,-1464.1,1641.7,58.9255,"Cork Gizelton"), +(11625,142,-1474.86,1647.49,58.9255,"Cork Gizelton"), +(11625,143,-1500.84,1657.91,58.9255,"Cork Gizelton"), +(11625,144,-1521.76,1671.96,58.9255,"Cork Gizelton"), +(11625,145,-1541.37,1691.94,58.9255,"Cork Gizelton"), +(11625,146,-1551.2,1701.92,58.9255,"Cork Gizelton"), +(11625,147,-1571.41,1721.29,58.9255,"Cork Gizelton"), +(11625,148,-1592.97,1739.14,58.9255,"Cork Gizelton"), +(11625,149,-1613.28,1758.07,58.9255,"Cork Gizelton"), +(11625,150,-1630.32,1780.27,58.9255,"Cork Gizelton"), +(11625,151,-1645.92,1803.52,58.9296,"Cork Gizelton"), +(11625,152,-1661.7,1826.65,58.9271,"Cork Gizelton"), +(11625,153,-1681.42,1858.29,58.9271,"Cork Gizelton"), +(11625,154,-1686.38,1877.21,59.2059,"Cork Gizelton"), +(11625,155,-1692.06,1899.02,60.7504,"Cork Gizelton"), +(11625,156,-1699.45,1908.31,61.1412,"Cork Gizelton"), +(11625,157,-1717,1915.93,60.0908,"Cork Gizelton"), +(11625,158,-1738.04,1917.48,59.0673,"Cork Gizelton"), +(11625,159,-1757.16,1918.92,58.9757,"Cork Gizelton"), +(11625,160,-1772.71,1926.58,59.1537,"Cork Gizelton"), +(11625,161,-1791.81,1939.62,60.7298,"Cork Gizelton"), +(11625,162,-1802.7,1951.89,60.7237,"Cork Gizelton"), +(11625,163,-1809.79,1963.96,59.7477,"Cork Gizelton"), +(11625,164,-1815.2,1976.74,59.0006,"Cork Gizelton"), +(11625,165,-1817.51,2008.7,59.5336,"Cork Gizelton"), +(11625,166,-1823,2032.7,60.6767,"Cork Gizelton"), +(11625,167,-1821.87,2042.21,60.944,"Cork Gizelton"), +(11625,168,-1813.14,2068.68,63.0096,"Cork Gizelton"), +(11625,169,-1810.52,2082.43,63.114,"Cork Gizelton"), +(11625,170,-1806.9,2095.9,63.1144,"Cork Gizelton"), +(11625,171,-1802.03,2111.56,63.6862,"Cork Gizelton"), +(11625,172,-1802.03,2111.56,63.6862,"Cork Gizelton"), +(11625,173,-1801.53,2141.07,63.006,"Cork Gizelton"), +(11625,174,-1801.53,2141.07,63.006,"Cork Gizelton"), +(11625,175,-1802.25,2155.05,61.5195,"Cork Gizelton"), +(11625,176,-1803.02,2183.03,59.8215,"Cork Gizelton"), +(11625,177,-1808.36,2207.2,59.8215,"Cork Gizelton"), +(11625,178,-1822.66,2219.86,59.8215,"Cork Gizelton"), +(11625,179,-1836.76,2232.87,59.8215,"Cork Gizelton"), +(11625,180,-1843.44,2245.11,59.8215,"Cork Gizelton"), +(11625,181,-1844.75,2266.9,59.8215,"Cork Gizelton"), +(11625,182,-1846.34,2280.81,59.8215,"Cork Gizelton"), +(11625,183,-1849.89,2294.13,59.8215,"Cork Gizelton"), +(11625,184,-1864.58,2316.31,59.8215,"Cork Gizelton"), +(11625,185,-1872.72,2327.7,59.8224,"Cork Gizelton"), +(11625,186,-1884.98,2346.82,59.8224,"Cork Gizelton"), +(11625,187,-1887.2,2354.3,59.8696,"Cork Gizelton"), +(11625,188,-1893.87,2379.11,59.9196,"Cork Gizelton"), +(11625,189,-1900.07,2391.67,59.8224,"Cork Gizelton"), +(11625,190,-1904,2405.04,59.8224,"Cork Gizelton"), +(11625,191,-1904,2405.04,59.8224,"Cork Gizelton"), +(11625,192,-1895.71,2431.78,59.8224,"Cork Gizelton"), +(11625,193,-1888.72,2458.89,59.8224,"Cork Gizelton"), -- Super-Seller 680 +(11625,194,-1895.4,2432.5,59.8224,"Cork Gizelton"), +(11625,195,-1899.03,2418.98,59.8224,"Cork Gizelton"), +(11625,196,-1899.68,2393.35,59.8224,"Cork Gizelton"), +(11625,197,-1892.03,2375.61,59.9178,"Cork Gizelton"), +(11625,198,-1885.29,2346.94,59.8216,"Cork Gizelton"), +(11625,199,-1881.12,2339.05,59.8216,"Cork Gizelton"), +(11625,200,-1864.4,2316.59,59.8226,"Cork Gizelton"), +(11625,201,-1852.79,2300.12,59.8226,"Cork Gizelton"), +(11625,202,-1847.08,2287.99,59.8226,"Cork Gizelton"), +(11625,203,-1844.34,2264.2,59.8226,"Cork Gizelton"), +(11625,204,-1842.38,2243.22,59.8226,"Cork Gizelton"), +(11625,205,-1840.11,2237.75,59.8226,"Cork Gizelton"), +(11625,206,-1830.64,2226.2,59.8226,"Cork Gizelton"), +(11625,207,-1810.22,2209.43,59.8226,"Cork Gizelton"), +(11625,208,-1802.8,2194.02,59.8226,"Cork Gizelton"), +(11625,209,-1800.41,2180.08,59.8226,"Cork Gizelton"), -- Propose Gizelton Caravan https://www.youtube.com/watch?v=3-kKd4VNuU8 +(11625,210,-1800.26,2166.08,60.1822,"Cork Gizelton"), +(11625,211,-1801.62,2148.85,62.344,"Cork Gizelton"), +(11625,212,-1801.15,2134.86,63.1766,"Cork Gizelton"), +(11625,213,-1802.26,2110.11,63.6737,"Cork Gizelton"), +(11625,214,-1805.87,2096.6,63.1784,"Cork Gizelton"), +(11625,215,-1809.25,2083.01,63.0772,"Cork Gizelton"), -- Demon ambush 1 https://youtu.be/3-kKd4VNuU8?t=47 +(11625,216,-1812.63,2069.43,63.043,"Cork Gizelton"), +(11625,217,-1816.72,2056.04,61.8496,"Cork Gizelton"), +(11625,218,-1822.89,2032.23,60.6524,"Cork Gizelton"), +(11625,219,-1822.76,2027.39,60.3783,"Cork Gizelton"), +(11625,220,-1815.56,2003.46,59.4022,"Cork Gizelton"), +(11625,221,-1814.41,1983.18,58.9549,"Cork Gizelton"), +(11625,222,-1811.8,1967.01,59.4735,"Cork Gizelton"), +(11625,223,-1803.12,1951.78,60.7154,"Cork Gizelton"), -- Demon ambush 2 https://youtu.be/3-kKd4VNuU8?t=106 +(11625,224,-1793.24,1941.87,60.8439,"Cork Gizelton"), +(11625,225,-1775.92,1926.82,59.3033,"Cork Gizelton"), +(11625,226,-1759.93,1918.92,58.9613,"Cork Gizelton"), +(11625,227,-1751.9,1917.2,59.0003,"Cork Gizelton"), +(11625,228,-1737.91,1917.04,59.0673,"Cork Gizelton"), +(11625,229,-1712.18,1914.85,60.4394,"Cork Gizelton"), +(11625,230,-1701.72,1911.02,61.0949,"Cork Gizelton"), +(11625,231,-1694.06,1904.03,61.03,"Cork Gizelton"), +(11625,232,-1687.1,1886.34,59.7501,"Cork Gizelton"), +(11625,233,-1684.12,1872.66,59.0354,"Cork Gizelton"), -- Demon ambush 3 https://youtu.be/3-kKd4VNuU8?t=161 +(11625,234,-1673.14,1845.28,58.9273,"Cork Gizelton"), +(11625,235,-1657.63,1821.97,58.9273,"Cork Gizelton"), +(11625,236,-1649.83,1810.34,58.9273,"Cork Gizelton"), +(11625,237,-1634.24,1787.08,58.9252,"Cork Gizelton"), +(11625,238,-1626.45,1775.45,58.9252,"Cork Gizelton"), +(11625,239,-1605.77,1750.66,58.9256,"Cork Gizelton"), +(11625,240,-1594.91,1741.83,58.9256,"Cork Gizelton"), -- Complete https://youtu.be/3-kKd4VNuU8?t=226 +(11625,241,-1573.31,1724.02,58.9256,"Cork Gizelton"), +(11625,242,-1553.4,1704.35,58.9256,"Cork Gizelton"), +(11625,243,-1543.67,1694.29,58.9256,"Cork Gizelton"), +(11625,244,-1523.39,1674.99,58.9256,"Cork Gizelton"), +(11625,245,-1505.1,1659.98,58.9256,"Cork Gizelton"), +(11625,246,-1489.89,1652.47,58.9256,"Cork Gizelton"), +(11625,247,-1460.15,1634.27,58.9256,"Cork Gizelton"), +(11625,248,-1453.16,1621.35,58.9256,"Cork Gizelton"), +(11625,249,-1446.87,1598.31,58.9256,"Cork Gizelton"), +(11625,250,-1440.81,1573.28,58.9256,"Cork Gizelton"), +(11625,251,-1445.9,1553.99,58.9256,"Cork Gizelton"), +(11625,252,-1451.91,1541.35,58.9256,"Cork Gizelton"), +(11625,253,-1458.46,1528.97,58.9256,"Cork Gizelton"), +(11625,254,-1471.62,1504.26,58.9256,"Cork Gizelton"), +(11625,255,-1478.08,1491.84,58.9256,"Cork Gizelton"), +(11625,256,-1490.08,1466.54,58.9256,"Cork Gizelton"), +(11625,257,-1491.71,1455.14,58.9291,"Cork Gizelton"), +(11625,258,-1488.22,1427.36,58.9348,"Cork Gizelton"), +(11625,259,-1486.41,1413.48,58.9418,"Cork Gizelton"), +(11625,260,-1487.62,1388.44,58.9251,"Cork Gizelton"), +(11625,261,-1491.84,1375.08,58.9301,"Cork Gizelton"), +(11625,262,-1502.72,1349.31,58.9416,"Cork Gizelton"), +(11625,263,-1508.49,1336.58,59.525,"Cork Gizelton"), +(11625,264,-1511.68,1327.41,60.3754,"Cork Gizelton"), +(11625,265,-1514.03,1314.22,62.0185,"Cork Gizelton"), +(11625,266,-1514.79,1300.27,64.5471,"Cork Gizelton"), +(11625,267,-1516.1,1286.34,68.0841,"Cork Gizelton"), +(11625,268,-1518.52,1272.55,72.0932,"Cork Gizelton"), +(11625,269,-1523.17,1245.16,82.7876,"Cork Gizelton"), +(11625,270,-1522.5,1234.75,87.008,"Cork Gizelton"), +(11625,271,-1517.95,1221.51,91.5343,"Cork Gizelton"), +(11625,272,-1511.76,1208.2,96.7403,"Cork Gizelton"), +(11625,273,-1501.33,1196.53,102.475,"Cork Gizelton"), +(11625,274,-1490.76,1188.95,106.376,"Cork Gizelton"), +(11625,275,-1475.92,1185.48,109.181,"Cork Gizelton"), +(11625,276,-1452.6,1187.95,111.422,"Cork Gizelton"), +(11625,277,-1433.28,1193.58,111.857,"Cork Gizelton"), +(11625,278,-1414.55,1203.63,111.886,"Cork Gizelton"), +(11625,279,-1388.31,1213.37,111.599,"Cork Gizelton"), +(11625,280,-1375.11,1218.03,111.465,"Cork Gizelton"), +(11625,281,-1348.49,1226.69,111.175,"Cork Gizelton"), +(11625,282,-1319.41,1232.27,110.201,"Cork Gizelton"); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_04_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_04_world.sql new file mode 100644 index 00000000000..029a6ac41c6 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_04_world.sql @@ -0,0 +1,3 @@ +-- Make Bonestripper Buzzard & Vulture move to invoker rather than random creature +UPDATE `smart_scripts` SET `target_type` = 7, `target_param1` = 0, `target_param2` = 0, `target_param3` = 0, `comment` = "Bonestripper Buzzard - On Data 1 1 Set - Move To Invoker" WHERE `entryorguid` = 16972 AND `source_type` = 0 AND `id` = 2; +UPDATE `smart_scripts` SET `target_type` = 7, `target_param1` = 0, `target_param2` = 0, `target_param3` = 0, `comment` = "Bonestripper Vulture - On Data 1 1 Set - Move To Invoker" WHERE `entryorguid` = 16973 AND `source_type` = 0 AND `id` = 2; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_05_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_05_world_335.sql new file mode 100644 index 00000000000..1a20316476b --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_05_world_335.sql @@ -0,0 +1,27 @@ +-- +UPDATE `creature_model_info` SET `DisplayID_Other_Gender` = 0 WHERE `DisplayID` = 2582; +UPDATE `creature_equip_template` SET `ItemID1` = 4560, `VerifiedBuild` = 0 WHERE `CreatureID` = 14221 AND `ID` = 1; +UPDATE `creature` SET `position_x` = 717.6572, `position_y` = -846.4034, `position_z` = 160.7536, `orientation` = 3.351032 WHERE `id` = 14221; +DELETE FROM `waypoint_data` WHERE `id` = 867560; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(867560,1,710.176,-847.23,158.978,0,0), +(867560,2,700.134,-853.063,158.516,0,0), +(867560,3,684.42,-847.68,158.498,0,0), +(867560,4,666.937,-858.739,158.498,0,0), +(867560,5,663.885,-866.644,158.499,0,0), +(867560,6,662.637,-879.389,158.291,0,0), +(867560,7,659.842,-884.845,158.617,0,0), +(867560,8,666.729,-899.79,164.624,0,0), +(867560,9,669.022,-904.201,164.414,0,0), +(867560,10,667.229,-921.961,164.414,0,0), +(867560,11,666.778,-939.546,164.85,0,0), +(867560,12,673.587,-950.274,164.35,0,0), +(867560,13,684.347,-959.261,164.35,0,0), +(867560,14,698.708,-966.321,164.653,0,0), +(867560,15,708.321,-976.576,165.562,0,30000), +(867560,16,700.121,-957.096,164.68,0,0), +(867560,17,715.224,-933.369,164.344,0,0), +(867560,18,716.543,-899.917,166.366,0,0), +(867560,19,715.204,-866.595,161.66,0,0), +(867560,20,717.657,-846.403,160.754,0,0), +(867560,21,717.657,-846.403,160.754,3.35103,30000); diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_22_00_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_22_00_world.sql new file mode 100644 index 00000000000..6b32776d0d7 --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_22_00_world.sql @@ -0,0 +1,2 @@ +-- Remove SMARTCAST_INTERRUPT_PREVIOUS from Invoker Cast, Cross Cast and Self Cast actions +UPDATE `smart_scripts` SET `action_param2` = `action_param2` &~1 WHERE `action_type` IN (85,86,134) AND `action_param2` & 1; diff --git a/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_22_01_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_22_01_world.sql new file mode 100644 index 00000000000..12e1482b84d --- /dev/null +++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_22_01_world.sql @@ -0,0 +1,40 @@ +-- Set Sheath Melee handled in core +DELETE FROM `smart_scripts` WHERE `entryorguid` = 15938 AND `source_type` = 0 AND `id` = 2; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 16378 AND `source_type` = 0 AND `id` IN (2,6); +UPDATE `smart_scripts` SET `link` = 0 WHERE `entryorguid` = 16378 AND `source_type` = 0 AND `id` IN (1,5); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (26414,27224,27225,27377,27564,27749) 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`,`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 +(26414,0,0,0,0,0,100,0,0,0,4000,6000,0,11,46982,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Runic Lightning Gunner - In Combat CMC - Cast 'Lightning Gun Shot'"), +(26414,0,1,2,8,0,100,1,48046,0,0,0,0,11,48047,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Runic Lightning Gunner - On Spellhit 'Use Camera' - Cast 'Iron Dwarf Snapshot Credit' (No Repeat)"), +(26414,0,2,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Runic Lightning Gunner - On Spellhit 'Use Camera' - Despawn Instant (No Repeat)"), + +(27224,0,0,0,0,0,100,0,0,0,2300,3900,0,11,38556,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Forgotten Knight - In Combat CMC - Cast 'Throw'"), +(27224,0,1,0,23,0,100,0,48143,0,2000,2000,0,11,48143,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Forgotten Knight - On Has Aura 'Forgotten Aura' - Cast 'Forgotten Aura'"), +(27224,0,2,3,8,0,100,0,48882,0,0,0,0,3,27465,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Forgotten Knight - On Spellhit 'Spirits Redeemed' - Update Template To 'Forgotten Soul'"), +(27224,0,3,0,61,0,100,0,0,0,0,0,0,51,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Forgotten Knight - On Link - Die"), +(27224,0,4,5,62,0,100,0,9544,0,0,0,0,85,48831,2,0,0,0,0,7,0,0,0,0,0,0,0,0,"Forgotten Knight - On Gossip Option 0 Selected - Invoker Cast 'Forgotten Knight Credit'"), +(27224,0,5,0,61,0,100,0,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Forgotten Knight - On Gossip Option 0 Selected - Close Gossip"), + +(27225,0,0,0,0,0,100,0,0,0,2300,3900,0,11,15547,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Forgotten Rifleman - In Combat CMC - Cast 'Shoot'"), +(27225,0,1,0,0,0,100,0,9000,12000,9000,14000,0,11,17174,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Forgotten Rifleman - In Combat - Cast 'Concussive Shot'"), +(27225,0,2,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,"Forgotten Rifleman - Between 0-15% Health - Flee For Assist (No Repeat)"), +(27225,0,3,0,23,0,100,0,48143,0,2000,2000,0,11,48143,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Forgotten Rifleman - On Has Aura 'Forgotten Aura' - Cast 'Forgotten Aura'"), +(27225,0,4,5,8,0,100,0,48882,0,0,0,0,3,27465,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Forgotten Rifleman - On Spellhit 'Spirits Redeemed' - Update Template To 'Forgotten Soul'"), +(27225,0,5,0,61,0,100,0,0,0,0,0,0,51,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Forgotten Rifleman - On Link - Die"), +(27225,0,6,7,62,0,100,0,9543,0,0,0,0,85,48830,2,0,0,0,0,7,0,0,0,0,0,0,0,0,"Forgotten Rifleman - On Gossip Option 0 Selected - Invoker Cast 'Forgotten Rifleman Credit'"), +(27225,0,7,0,61,0,100,0,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Forgotten Rifleman - On Gossip Option 0 Selected - Close Gossip"), + +(27377,0,0,0,0,0,100,0,0,0,2300,3900,0,11,50512,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Thane Torvald Eriksson - In Combat CMC - Cast 'Shoot'"), +(27377,0,1,0,0,0,100,0,9000,12000,12000,15000,0,11,52813,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Thane Torvald Eriksson - In Combat - Cast 'Multi-Shot'"), +(27377,0,2,0,0,0,100,0,8000,13000,9000,15000,0,11,34829,0,0,0,0,0,6,0,0,0,0,0,0,0,0,"Thane Torvald Eriksson - In Combat - Cast 'Arcane Shot'"), +(27377,0,3,0,9,0,100,0,10,70,15000,20000,0,11,56843,0,0,0,0,0,5,0,0,0,0,0,0,0,0,"Thane Torvald Eriksson - Within 10-70 Range - Cast 'Volley'"), +(27377,0,4,0,2,0,100,0,0,30,15000,19000,0,11,57057,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Thane Torvald Eriksson - Between 0-30% Health - Cast 'Torvald's Deterrence'"), + +(27564,0,0,0,1,0,100,0,0,5000,0,10000,0,11,49329,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Alliance Conscript - Out of Combat - Cast 'Summon Frigid Ghoul Attacker'"), +(27564,0,1,0,0,0,100,0,0,0,2300,3900,0,11,15620,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Alliance Conscript - In Combat CMC - Cast 'Shoot'"), +(27564,0,2,0,9,0,100,0,0,5,5000,9000,0,11,29426,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Alliance Conscript - Within 0-5 Range - Cast 'Heroic Strike'"), + +(27749,0,0,0,1,0,100,0,0,5000,0,10000,0,11,49329,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Horde Conscript - Out of Combat - Cast 'Summon Frigid Ghoul Attacker'"), +(27749,0,1,0,0,0,100,0,0,0,2300,3900,0,11,15620,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Horde Conscript - In Combat CMC - Cast 'Shoot'"), +(27749,0,2,0,9,0,100,0,0,5,7000,9000,0,11,29426,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Horde Conscript - Within 0-5 Range - Cast 'Heroic Strike'"); |