DB/Broken Isles: Start phases and some cosmetic for Legion tailoring quest chain

[aquadeus]

Description

^

SQL fix

SET @OGUID := xxxx;
SET @CGUID := xxxx;

-- Creature
DELETE FROM `creature` WHERE `guid` = @CGUID+0;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curHealthPct`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
(@CGUID+0, 93967, 1220, 7334, 7620, '0', 5049, 0, 0, 0, 274.848968505859375, 5872.89599609375, 15.98129177093505859, 3.646122217178344726, 120, 10, 0, 100, 0, NULL, NULL, NULL, NULL, 54604); -- Lyndras (Area: The Greenway - Difficulty: 0) CreateObject1

DELETE FROM `creature_queststarter` WHERE (`id`=93967 AND `quest` IN (38950,38949,38948,38947));
INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
(93967, 38950, 54604), -- The Wayward Tailor offered by Lyndras
(93967, 38949, 54604), -- So You Think You Can Sew offered by Lyndras
(93967, 38948, 54604), -- Hard Times offered by Lyndras
(93967, 38947, 54604); -- Runic Catgut offered by Lyndras

UPDATE `creature_template_difficulty` SET `ContentTuningID`=331, `StaticFlags1`=268435456, `VerifiedBuild`=54604 WHERE (`Entry`=93967 AND `DifficultyID`=0); -- Lyndras
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 93967;

DELETE FROM `creature_template_gossip` WHERE (`CreatureID`=93967 AND `MenuID`=18502);
INSERT INTO `creature_template_gossip` (`CreatureID`, `MenuID`, `VerifiedBuild`) VALUES
(93967, 18502, 54604); -- Lyndras

DELETE FROM `creature_text` WHERE `CreatureID`=93967;
INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(93967, 0, 0, 'This simply will not do. I MUST find better accommodations.', 12, 0, 50, 0, 0, 0, 98225, 0, 'Lyndras'),
(93967, 0, 1, 'Maybe if I explain that I was just borrowing it, they\'ll have me back. No, no, no! Tytallo would never go for that.', 12, 0, 50, 0, 0, 0, 98227, 0, 'Lyndras'),
(93967, 1, 0, 'Let\'s see, did I remember the spritethorn needles...?', 12, 0, 50, 0, 0, 0, 98219, 0, 'Lyndras'),
(93967, 1, 1, 'One... two... three, four... yes. They\'re all here.', 12, 0, 50, 0, 0, 0, 98221, 0, 'Lyndras');

-- Gameobject
UPDATE `gameobject_template` SET `ContentTuningId`=348, `VerifiedBuild`=54604 WHERE `entry`=242634; -- Tanithria's Thread
UPDATE `gameobject_template` SET `ContentTuningId`=348, `VerifiedBuild`=54604 WHERE `entry`=242633; -- Tanithria's Silkweave

DELETE FROM `gameobject_template_addon` WHERE `entry` IN (242633, 242634);
INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES
(242633, 0, 2113536, 0, 0), -- Tanithria's Silkweave
(242634, 0, 2113536, 0, 0); -- Tanithria's Thread

DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+1;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
(@OGUID+0, 242633, 1220, 7502, 8415, '0', 5081, 0, -768.82989501953125, 4582.134765625, 728.8717041015625, 4.839252471923828125, 0.360172748565673828, 0.46509552001953125, -0.51393032073974609, 0.624369561672210693, 120, 255, 1, 54604), -- Tanithria's Silkweave (Area: Talismanic Textiles - Difficulty: 0) CreateObject1
(@OGUID+1, 242634, 1220, 7502, 8415, '0', 5085, 0, -773.86981201171875, 4579.12939453125, 728.70819091796875, 4.022988319396972656, 0, 0, -0.90445423126220703, 0.426570683717727661, 120, 255, 1, 54604); -- Tanithria's Thread (Area: Talismanic Textiles - Difficulty: 0) CreateObject1

-- Phase
DELETE FROM `phase_name` WHERE `ID` IN (5081, 5085, 5049);
INSERT INTO `phase_name` (`ID`, `Name`) VALUES
(5081, 'Cosmetic - Legion Tailoring - Tanithria\'s Silkweave'),
(5085, 'Cosmetic - Legion Tailoring - Tanithria\'s Thread'),
(5049, 'Cosmetic - Legion Tailoring - Lyndras');

DELETE FROM `phase_area` WHERE `PhaseId` IN (5081, 5085, 5049);
INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES
(8415, 5081, 'Talismanic Textiles - Tanithria\'s Silkweave'),
(8415, 5085, 'Talismanic Textiles - Tanithria\'s Silkweave'),
(7620, 5049, 'The Greenway - Lyndras'),
(8418, 5049, 'Lyndras\' Exile - Lyndras');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=26 AND `SourceGroup` IN (5081, 5085);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES
(26, 5081, 0, 0, 0, 47, 0, 38945, 2 | 8, 0, 0, 'Apply Phase 5081 if Quest 38945 is in progress | completed'),
(26, 5085, 0, 0, 0, 47, 0, 38945, 2 | 8, 0, 0, 'Apply Phase 5085 if Quest 38945 is in progress | completed');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=26 AND `SourceGroup` = 5049;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES
(26, 5049, 0, 0, 0, 47, 0, 38946, 2 | 64, 0, 0, 'Apply Phase 5049 if Quest 38946 is completed | rewarded'),
(26, 5049, 0, 0, 1, 47, 0, 38950, 2 | 64, 1, 0, 'Apply Phase 5049 if Quest 37733 is not completed | rewarded');

-- Quest
DELETE FROM `quest_offer_reward_locale` WHERE (`locale`='esES' AND `ID` IN (38946, 38945,38944));
INSERT INTO `quest_offer_reward_locale` (`ID`, `locale`, `RewardText`, `VerifiedBuild`) VALUES
(38946, 'esES', '¡Vaya, vaya, mírate! $gUn:Una; joven $c tan $gatractivo:atractiva;, y $gtodo adornado:toda adornada; con sus armas y sus galas mágicas. ¿A qué debo el placer?$B$B¡Ajá! ¡Sastrería! Es tu día de suerte, esto...$B$BDisculpa, ¿cómo te llamabas? ¿$n?$B$B¡Es tu día de suerte, $n! Resulta que soy uno de los mejores sastres de Suramar...', 54604),
(38945, 'esES', 'Qué pena. Sin la posibilidad de coser, apenas podemos hacer nada con este tejido.$B$B<Tanithria hace un mohín.>$B$BAun así, EXISTEN patrones para los que sabemos que no hace falta coser. Las hombreras son fáciles, y los cinturones deberían de estar chupados.', 54604),
(38944, 'esES', 'Con esto... ¡Con esto sí que puedo trabajar!$B$BMe recuerda a una tela de un viejo festival de elfos de la noche.', 54604);

DELETE FROM `quest_request_items_locale` WHERE (`ID`=38944 AND `locale`='esES');
INSERT INTO `quest_request_items_locale` (`ID`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES
(38944, 'esES', 'No me importaría trabajar con un poco de cachemir...', 54604);

UPDATE `quest_template_locale` SET `LogTitle`='Esto no debería ser complicado... ¿no?', `LogDescription`='Fabrica una toga de filoseda hecha a mano en el banco de retoques de Tanithria. Puedes conseguir el patrón en tu lista de patrones de sastrería, y los materiales del patrón, en su tienda.', `QuestDescription`='Tengo muchos patrones de seda con los que podemos usar esta tela.$B$BAyúdame a preparar los materiales, $n. Le daremos un buen uso a esta tela y te haremos una toga nueva.', `VerifiedBuild`=54604 WHERE (`ID`=38945 AND `locale`='esES');
UPDATE `quest_template_locale` SET `LogTitle`='Consulta a los lugareños', `QuestDescription`='El que tejió esto NO PUEDE haberlo hecho solamente para cinturones y hombreras. Debe de haber una forma de coser este material.$B$BBaja a Azsuna y busca un sastre. Necesitamos coser si queremos hacer algo de sastrería en serio.', `VerifiedBuild`=54604 WHERE (`ID`=38946 AND `locale`='esES');

DELETE FROM `quest_details` WHERE `ID` IN (38945 /*This Should Be Simple... Right?*/, 38944 /*Sew It Begins*/);
INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES
(38945, 1, 0, 0, 0, 0, 0, 0, 0, 54604), -- This Should Be Simple... Right?
(38944, 1, 0, 0, 0, 0, 0, 0, 0, 54604); -- Sew It Begins

DELETE FROM `creature_queststarter` WHERE (`id`=93542 AND `quest` IN (38945,38944)) OR (`id`=114274 AND `quest`=44544);
INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
(93542, 38945, 54604), -- This Should Be Simple... Right? offered by Tanithria
(93542, 38944, 54604); -- Sew It Begins offered by Tanithria

-- Waypoints
SET @ENTRY := 93967;
SET @PATHOFFSET := 0;
SET @PATH := @ENTRY * 100 + @PATHOFFSET;
DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES
(@PATH, 0, 0, 'Lyndras - Cosmetic Waypoint');

DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
(@PATH, 0, 277.316, 5875.141, 15.98129, NULL, 0),
(@PATH, 1, 274.849, 5872.896, 15.98129, NULL, 121894),
(@PATH, 2, 287.7274, 5877.945, 15.98129, NULL, 0),
(@PATH, 3, 290.7188, 5877.89, 15.98129, NULL, 120626);

UPDATE `creature` SET `position_x`= 277.316, `position_y`= 5875.141, `position_z`= 15.98129, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+0;
DELETE FROM `creature_addon` WHERE `guid`= @CGUID+0;
INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
(@CGUID+0, @PATH, 1);

DELETE FROM `smart_scripts` WHERE `entryorguid`= -@CGUID+0 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (9396700, 9396701) AND `source_type`=9;
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(-@CGUID+0, 0, 0, 0, '', 40, 0, 100, 0, 1, @PATH, 0, 0, 0, '', 80, 9396700, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Lyndras - On waypoint reached - Action List'),
(-@CGUID+0, 0, 1, 0, '', 40, 0, 100, 0, 3, @PATH, 0, 0, 0, '', 80, 9396701, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Lyndras - On waypoint reached - Action List'),

(9396700, 9, 0, 1, '', 0, 0, 100, 0, 100, 100, 0, 0, 0, '', 90, 8, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Lyndras - On Script - Set Flag Standstate Kneel'),
(9396700, 9, 1, 2, '', 0, 0, 100, 0, 3000, 10000, 0, 0, 0, '', 1, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Lyndras - On Script - Talk'),
(9396700, 9, 2, 0, '', 0, 0, 100, 0, 115000, 115000, 0, 0, 0, '', 91, 8, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Lyndras - On Script - Remove Flag Standstate Kneel'),

(9396701, 9, 0, 1, '', 0, 0, 100, 0, 100, 100, 0, 0, 0, '', 17, 569, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Lyndras - On Script - Set Emotestate 569'),
(9396701, 9, 1, 2, '', 0, 0, 100, 0, 3000, 10000, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Lyndras - On Script - Talk'),
(9396701, 9, 2, 0, '', 0, 0, 100, 0, 113000, 113000, 0, 0, 0, '', 17, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Lyndras - On Script - Remove Emotestate');

Branch

master

TC rev. hash/commit

ad97b44