[EXECUTED] Brewfest Event

Titesusy

Veteran Member
134
2016
4
Location
France
Brewfest​

The below script reseolves some achievements of the seasonal event. But some quests aren't scripted ( 12191, 12022, 11293, 11407 ) These are the main quests which allow to succeed many more achievements. By the way, here it's the actual script. It's tested already and functionnal for Alliance and Horde. (except the quests listed previously)


Update 2019.02.19:
- Fixes about Alliance's quest (12491) gift by the item looted by Coren Direbrew.


the known bugs :
- Some NPC (mainly vendors) doesn't react as well but it resolves itself when the server is completely restarted (mysql too).
 
Last edited:

Titesusy

Veteran Member
134
2016
4
Location
France
Here is the code of brewfest :)

Code:
-- 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');
 
Last edited:

Titesusy

Veteran Member
134
2016
4
Location
France
errors? which one please ? is it about [MENTION=9511]core[/MENTION]nDirebrew_guid ? or something else ?
 
Last edited:
Top