-- Last Revision & Tests : 2019.02.19 by Titesusy
-- Tested with V10.1
-- Modificable setup STARTING HERE
SET [MENTION=9511]core[/MENTION]nDirebrew_guid = 800000;
SET @my_guid = 800001; -- take range : @my_guid => @my_guid+50 free
-- https://fr.wowhead.com/brewfest#npcs
-- Non Modifiable starting HERE
-- Achievement completed thanks to the script:
-- https://www.wowhead.com/achievement=295
-- https://www.wowhead.com/achievement=303
-- https://www.wowhead.com/achievement=1183
-- https://www.wowhead.com/achievement=1185
-- https://www.wowhead.com/achievement=1184 (Alliance)
-- https://www.wowhead.com/achievement=1203 (Horde)
UPDATE `creature_template` SET `gossip_menu_id`='9548' WHERE (`entry`='27489');
UPDATE `game_event` SET `length`='23040' WHERE (`eventEntry`='24'); -- because : 1440 * 16 days = 23040
-- https://www.wowhead.com/npc=23872
DELETE FROM creature WHERE ( id = '23872');
INSERT INTO creature
(guid, id, map, zone, area, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags, walkmode, saiscriptflag) VALUES
[MENTION=9511]core[/MENTION]nDirebrew_guid, '23872','230','1584','1584','1','65535','0','23872','908.149','-141.133','-49.7554','3.49329','300','0','0','334680','0','0','0','0','0','0','0');
-- Insertion the npc to the event displaying
DELETE FROM game_event_creature WHERE game_event_creature.guid IN (
SELECT creature.guid
FROM creature WHERE (creature.id = '23872'));
INSERT INTO game_event_creature (eventEntry, guid) VALUES ('24', [MENTION=9511]core[/MENTION]nDirebrew_guid);
-- Modification to the loot of Coren Direbrew according to the official loottemplate. (because actually, some of loot item are set to 0%)
UPDATE creature_loot_template SET ChanceOrQuestChance = '10' WHERE (entry = '23872' AND ( item = '38280' OR item = '38281' ));
UPDATE creature_loot_template SET ChanceOrQuestChance = '1.7' WHERE (entry = '23872' AND
( item = '71333' OR item = '71334' OR item = '71335' OR item = '71336' OR item = '71337' OR item = '71338' ));
-- Others NPC
DELETE FROM creature WHERE (creature.id = '24545' OR
creature.id = '23482' OR
creature.id = '23511' OR
creature.id = '23521' OR
creature.id = '23481' OR
creature.id = '23522' OR
creature.id = '23604' OR
creature.id = '23605' OR
creature.id = '23603' OR
creature.id = '23627' OR
creature.id = '24108' OR
creature.id = '24498' OR
creature.id = '27489' OR
creature.id = '27820' OR
creature.id = '27478' OR
creature.id = '24710' OR
creature.id = '24711' OR
creature.id = '27215' OR
creature.id = '27216' OR
creature.id = '23533' OR
creature.id = '24501');
INSERT INTO creature
(guid, id, map, zone, area, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags, walkmode, saiscriptflag) VALUES
(@my_guid, '24545','530','3703','3703','1','1','0','0','-1932.92','5563.26','-12.4273','5.04695','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+1, '23482','530','0','0','1','1','22395','0','-4016.6','-11833','0.106771','4.04165','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+2, '23482','1','1657','1657','1','1','22395','0','9960.97','2219.7','1330.06','3.10464','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+3, '23482','0','1','809','1','1','0','0','-5186.32','-739.474','447.46','0.722853','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+4, '23482','0','12','12','1','1','22395','0','-9111.04','424.103','93.9629','5.08738','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+5, '23511','0','12','12','1','1','0','0','-9113.72','422.042','93.9989','5.67172','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+6, '23511','1','1657','1657','1','1','0','0','9960.9','2225.98','1331.06','3.5095','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+7, '23511','530','3557','3557','1','1','0','0','-4021.84','-11831.5','0.0847563','4.67367','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+8, '23511','0','1','809','1','1','0','0','-5189.68','-735.596','447.442','5.71441','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+9, '23511','530','3703','3703','1','1','0','0','-1937.09','5561.84','-12.4277','5.29839','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+10, '23511','0','85','85','1','65535','0','0','1583,95','65.2726','62.5366','1.54159','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+11, '23511','1','14','4982','1','65535','0','0','1368,98','-4337.78','28.6175','3.53021','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+12, '23511','1','1638','5345','1','65535','0','0','-1288.8','200.952','58.8931','1.48188','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+13, '23511','530','3430','3430','1','65535','0','0','9323.05','-7223.7','14.6605','2.81695','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+14, '23481','0','1','809','1','1','0','23481','-5178.54','-743.653','448.032','1.62372','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+15, '23521','0','1','809','1','1','0','0','-5182.27','-742.259','447.672','1.74466','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+16, '23522','0','1','809','1','1','0','23522','-5192.6','-732.855','446.676','5.72349','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+17, '23533','0','85','85','1','1','22493','0','1579.92','62.9768','62.5366','2.29624','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+18, '23533','530','3430','3430','1','1','22493','0','9325.55','-7218.43','14.7599','3.29918','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+19, '23533','1','1638','5345','1','1','22493','0','-1284.98','199.516','58.8919','1.23024','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+20, '23533','1','14','4982','1','1','0','0','1365.21','-4327.52','28.6159','4.25495','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+21, '23603','1','14','4982','1','65535','0','23603','1370.7','-4340.96','28.6168','3.35752','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+22, '23604','1','14','4982','1','65535','0','0','1371.2','-4344.09','28.6163','3.10138','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+23, '23605','1','14','4982','1','65535','0','23605','1369.29','-4334.08','28.6175','3.39669','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+24, '24501','0','85','85','1','1','0','0','1587.72','61.8507','62.5366','1.13431','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+25, '24501','530','3430','3430','1','1','22491','0','9321.72','-7227.96','14.6559','2.61076','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+26, '24501','1','1638','5345','1','1','22491','0','-1293.7','201.48','58.9076','1.22699','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+27, '24501','1','14','4982','1','1','22491','0','1367.15','-4330.09','28.6159','4.33647','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+28, '27478','0','0','0','1','1','0','0','-4849.41','-862.255','501.997','4.85202','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+29, '27820','0','0','0','1','1','24990','0','-4845.72','-861.515','501.997','4.15388','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+30, '27820','1','1637','5170','1','3969','0','27806','1608.31','-4398.42','16.6863','3.97837','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+31, '24710','0','1','809','1','65535','0','0','-5183.48','-746.918','448.051','0.0827579','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+32, '24711','1','14','14','1','1','0','0','1342.81','-4274.47','32.1923','2.74046','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+33, '27215','0','1','809','1','65535','0','27215','-5170.42','-728.774','449.695','3.77963','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+34, '27216','1','14','1296','1','65535','0','0','1289.99','-4246.04','26.3431','2.2932','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+35, '23627','0','1','809','1','65535','0','0','-5166.43','-729.64','450.843','3.8354','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+36, '24108','1','14','1296','1','65535','0','0','1289.76','-4214.04','26.4035','4.24256','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+37, '24108','0','1','1','1','65535','0','0','-5194.5','-622.544','397.327','0.543785','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+38, '24498','1','14','14','1','1','0','0','1344.24','-4269.71','33.0074','2.83279','300','0','0','3323','0','0','0','0','0','0','0'),
(@my_guid+39, '27489','1','1637','5170','1','65535','0','0','1612.46','-4401.76','15.5301','3.81295','300','0','0','3323','0','0','0','0','0','0','0');
-- modification of faction of a vendor, originally 774
UPDATE creature_template SET faction_H='474', faction_A ='474', AIName='' WHERE (entry ='27820');
-- Items added in vendor
DELETE FROM npc_vendor WHERE (entry = '27820');
INSERT INTO npc_vendor (entry, slot, item, maxcount, incrtime, ExtendedCost, type) VALUES
('27820','0','37909','0','0','0','1'),
('27820','1','37494','0','0','0','1'),
('27820','2','37495','0','0','0','1'),
('27820','3','37496','0','0','0','1'),
('27820','4','37497','0','0','0','1'),
('27820','5','37498','0','0','0','1'),
('27820','6','37499','0','0','0','1'),
('27820','7','37492','0','0','0','1'),
('27820','8','37901','0','0','0','1'),
('27820','9','37489','0','0','0','1'),
('27820','10','37903','0','0','0','1'),
('27820','11','37900','0','0','0','1'),
('27820','12','37898','0','0','0','1');
-- brewfest prize token
UPDATE `quest_template` SET PrevQuestId = '0', `RewardItemId1`='37829', `RewardItemCount1`='40' WHERE (id = '12491' OR id ='12492');
UPDATE `quest_template` SET `RewardItemId1`='37829', `RewardItemCount1`='10' WHERE (`Id`='12191' OR `Id`='12022');
UPDATE `quest_template` SET `RewardItemId1`='37829', `RewardItemCount1`='15' WHERE (`Id`='11293' OR `Id`='11407');
-- Some Quests updates
DELETE FROM creature_questrelation WHERE (quest = '12191' OR quest = '12022' OR quest = '11293' OR quest = '11407');
DELETE FROM creature_involvedrelation WHERE (quest = '12191' OR quest = '12022' OR quest = '11293' OR quest = '11407');
INSERT INTO creature_questrelation (id, quest) VALUES
('27216','12191'), -- buvez-éliminez Alliance
('27215','12022'), -- buvez-éliminez Horde
('23627','11293'), -- des-aboyeurs-pour-les-brasselorge Alliance
('24498','11407'); -- des-aboyeurs-pour-la-distillerie-drohn Horde
INSERT INTO creature_involvedrelation (id, quest) VALUES
('27216','12191'), -- buvez-éliminez Alliance
('27215','12022'), -- buvez-éliminez Horde
('23627','11293'), -- des-aboyeurs-pour-les-brasselorge Alliance
('24498','11407'); -- des-aboyeurs-pour-la-distillerie-drohn Horde
-- Insertion the npc to the event displaying (the @my_guid# )
DELETE FROM game_event_creature WHERE game_event_creature.guid IN (
SELECT creature.guid
FROM creature WHERE (creature.id = '24545' OR
creature.id = '23482' OR
creature.id = '23511' OR
creature.id = '23521' OR
creature.id = '23481' OR
creature.id = '23522' OR
creature.id = '23604' OR
creature.id = '23605' OR
creature.id = '23603' OR
creature.id = '23627' OR
creature.id = '24108' OR
creature.id = '24498' OR
creature.id = '27489' OR
creature.id = '27820' OR
creature.id = '27478' OR
creature.id = '24710' OR
creature.id = '24711' OR
creature.id = '27215' OR
creature.id = '27216' OR
creature.id = '23533' OR
creature.id = '24501'));
INSERT INTO `game_event_creature` (eventEntry, guid)
SELECT '24' , creature.guid
FROM creature WHERE (creature.id = '24545' OR
creature.id = '23482' OR
creature.id = '23511' OR
creature.id = '23521' OR
creature.id = '23481' OR
creature.id = '23522' OR
creature.id = '23604' OR
creature.id = '23605' OR
creature.id = '23603' OR
creature.id = '23627' OR
creature.id = '24108' OR
creature.id = '24498' OR
creature.id = '27489' OR
creature.id = '27820' OR
creature.id = '27478' OR
creature.id = '24710' OR
creature.id = '24711' OR
creature.id = '27215' OR
creature.id = '27216' OR
creature.id = '23533' OR
creature.id = '24501');