[EXECUTED] v7 (maybe older?) cataclysm server - Midsummer event

Titesusy

Veteran Member
134
2016
4
Location
France
Midsummer scripts for Emucoach server V10. It works too in V7.
The updates since the previous edition (2018 November):
- The working tests (Ally + Horde) for the V10 Emucoach
- Correction of format of some numbers in the code appeared by the "quote" balise. Now the "code" balise is used.
- Added the flame keeper 25884 in the event to prevent him to appear when the event is off. I suspect some other flame keepers, but i'll try to chase them for adding them into the correct table. (in a next update)




Code:
-- Last Revision & Tests : 2019.02.24 by Titesusy
-- Tested with V10.1
-- Modificable setup STARTING HERE

-- https://www.wowhead.com/achievement=1034
-- https://www.wowhead.com/achievement=1036
-- https://www.wowhead.com/achievement=1037
-- https://www.wowhead.com/achievement=1035

-- GUID = 'my_id+0' To GUID = 'my_id+100' must be FREE, 
-- or you will have errors from duplication primary keys tentatives

SET @my_id=601000; -- You can modify this variable.
  

-- NO MODIFY STARTING HERE

UPDATE `game_event` SET `end_time`='2031-02-01 23:00:00' WHERE (`eventEntry`='1'); -- Timeline event
UPDATE `quest_template` SET `RequiredRaces`='2098253' WHERE (`Id`='11821'); -- Nagrand Alliance quest 
UPDATE `quest_template` SET `RequiredRaces`='946' WHERE (`Id`='11732' OR `Id`='11755' ); -- alliance's Arathi higlands/Hinterlands desacralise this fire

-- Quest relations
UPDATE `gameobject_template` SET `ScriptName`='', `data0`='0', `data1`='0', `data3`='0', `faction`='0'  
WHERE (gameobject_template.name =  'Alliance Bonfire' OR gameobject_template.name =  'Horde Bonfire' OR
 gameobject_template.entry = '208188');


-- Deletion of some potential quests in the game_event_gameobject_quest table
DELETE FROM
game_event_gameobject_quest
WHERE
game_event_gameobject_quest.id IN ( SELECT gameobject_template.entry
FROM gameobject_template
WHERE gameobject_template.name =  'Alliance Bonfire' OR gameobject_template.name =  'Horde Bonfire' OR
 gameobject_template.entry = '208188');


-- Preparing the installation in the bonfire's GObjects
DELETE FROM `gameobject_involvedrelation`
WHERE `gameobject_involvedrelation`.id IN ( SELECT gameobject_template.entry
FROM gameobject_template
WHERE gameobject_template.name =  'Alliance Bonfire' OR gameobject_template.name =  'Horde Bonfire' OR
 gameobject_template.entry = '208188');

DELETE FROM `gameobject_questrelation`
WHERE `gameobject_questrelation`.id IN ( SELECT gameobject_template.entry
FROM gameobject_template
WHERE gameobject_template.name =  'Alliance Bonfire' OR gameobject_template.name =  'Horde Bonfire' OR
 gameobject_template.entry = '208188');

-- Installation of the quests in the bonfire's GObjects
INSERT INTO `gameobject_involvedrelation` (`id`, `quest`) VALUES
 ('187971', '11580'), ('187971', '11584'), -- Silverpine
('187973', '11764'), ('187973', '11840'), ('194032', '11804'), ('194032', '11732'), -- Arathi Highlands
('187963', '11765'), ('187963', '11841'), ('187920', '11805'), ('187920', '11734'), -- Ashenvale
('207992', '11766'), ('207992', '11842'), ('187938', '28925'), ('187938', '28912'), -- Badlands
('187950', '11767'), ('187950', '11843'), ('187929', '11807'), ('187929', '11736'), -- Blade's Edge Mountains
('187961', '11768'), ('187961', '11844'), ('187924', '11810'), ('187924', '11739'), -- Burning Steppes
('207991', '11769'), ('207991', '11845'), ('187922', '11812'), ('187922', '11741'), -- Desolace
('187957', '11770'), ('187957', '11846'), -- Durotar
('187968', '11771'), ('187968', '11847'), ('187939', '11815'), ('187939', '11744'), -- Dustwallow
('187948', '11772'), ('187948', '11848'), -- Eversong woods
('187953', '11773'), ('187953', '11849'), ('187928', '11817'), ('187928', '11746'), -- Feralas
('187970', '11774'), ('187970', '11850'), -- Ghostlands
('187966', '11775'), ('187966', '11851'), ('187937', '11818'), ('187937', '11747'), -- Hellfire Peninsula
('187975', '11776'), ('187975', '11853'), -- Hillsbrad Foothills
('187969', '11777'), ('187969', '11852'), -- Mulgore
('187951', '11778'), ('187951', '11750'), ('187951', '11854'), ('187951', '11821'), -- Nagrand
('187956', '11779'), ('187956', '11855'), ('187931', '11823'), ('187931', '11752'), -- Shadowmoon Valley
('187954', '11780'), ('187954', '11856'), ('187932', '28928'), ('187932', '28915'), -- Stonetalon Mountains
('187947', '11781'), ('187947', '11857'), ('187947', '28929'), ('187947', '28916'), -- Swamp of Sorrows
('187972', '11782'), ('187972', '11858'), ('187925', '11825'), ('187925', '11754'), -- Terokkar
('187964', '11783'), ('187964', '11859'), -- Barrens
('187952', '11784'), ('187952', '11860'), ('187927', '11826'), ('187927', '11755'), -- Hinterlands
('187959', '11786'), ('187959', '11862'), -- Tirisfal
('187965', '11787'), ('187965', '11863'), ('187941', '11829'), ('187941', '11758'), -- Zangarmarsh
('194043', '11799'), ('194043', '11835'), ('194043', '11830'), ('194043', '11759'), -- Netherstorm
('194037', '11800'), ('194037', '11836'), ('194037', '11831'), ('194037', '11760'), -- Silithus
('194046', '11801'), ('194046', '11837'), ('194046', '11832'), ('194046', '11761'), -- Cap of Stranglethorn
('194042', '11802'), ('194042', '11838'), ('194042', '11833'), ('194042', '11762'), -- Tanaris
('187958', '11803'), ('187958', '11839'), ('187958', '11834'), ('187958', '11763'), -- Winterspring
('194034', '13441'), ('194034', '13493'), ('187943', '13485'), ('187943', '13440'), -- Borean Tundra
('194033', '13450'), ('194033', '13494'), ('194033', '13486'), ('194033', '13442'), -- Sholazar Basin
('187967', '13451'), ('187967', '13495'), ('187917', '13487'), ('187917', '13443'), -- Dragonblight
('187949', '13453'), ('187949', '13496'), ('187934', '13488'), ('187934', '13444'), -- Howling Fjord
('187962', '13454'), ('187962', '13497'), ('187936', '13489'), ('187936', '13445'), -- Grizzly Hills
('187955', '13455'), ('187955', '13498'), ('187955', '13490'), ('187955', '13446'), -- Storm Peaks
('187960', '13457'), ('187960', '13499'), ('194036', '13491'), ('194036', '13447'), -- Crystalsong Forest
('187974', '13458'), ('187974', '13500'), ('187974', '13492'), ('187974', '13449'), -- Zuldrak
('194039', '28911'), ('194039', '28924'), ('187916', '28922'), ('187916', '28910'), -- Northern Stranglethorn
('194048', '28914'), ('194048', '28927'), ('187942', '28926'), ('187942', '28913'), -- Southern Barrens
('208090', '28917'), ('208090', '28930'), ('187914', '11808'), ('187914', '11737'), -- Blasted Land
('208094', '28918'), ('208094', '28931'), ('187940', '11827'), ('187940', '11756'), -- Western Plaguelands
('187919', '11811'), ('187919', '11740'), -- Darkshore
('187944', '11806'), ('187944', '11735'), -- Azuremyst
('187923', '11809'), ('187923', '11738'), -- Bloodmyst isle
('187926', '11828'), ('187926', '11757'), -- Wetlands
('187930', '11824'), ('187930', '11753'), -- Teldrassil
('187933', '11822'), ('187933', '11751'), -- Redridge Mountains
('187935', '11814'), ('187935', '11743'), -- Duskwood
('187945', '11813'), ('187945', '11742'), -- Dun Morogh
('194035', '11820'), ('194035', '11749'), -- Loch Modan
('187946', '11816'), ('187946', '11745'), -- Elwynn Forest
('207986', '28919'), ('207986', '28923'), -- Azshara
('207989', '28920'), ('207989', '28933'), ('207989', '28932'), ('207989', '28921'),-- Ungoro
('187564', '11583'), ('187564', '11581'), -- Westfall
('207983', '28944'), ('207983', '28946'), ('187921', '28945'), ('187921', '28943'), -- Twilight Highlands
('207990', '28948'), ('207990', '28949'), ('207990', '28950'), ('207990', '28947'), -- Uldum
('208188','29036'), -- Deepholm
('194045','29031'), -- Vashjir
('194038','29030'); -- Hyjal


INSERT INTO `gameobject_questrelation` (`id`, `quest`) VALUES
 ('187971', '11580'), ('187971', '11584'), -- Silverpine
('187973', '11764'), ('187973', '11840'), ('194032', '11804'), ('194032', '11732'), -- Arathi Highlands
('187963', '11765'), ('187963', '11841'), ('187920', '11805'), ('187920', '11734'), -- Ashenvale
('207992', '11766'), ('207992', '11842'), ('187938', '28925'), ('187938', '28912'), -- Badlands
('187950', '11767'), ('187950', '11843'), ('187929', '11807'), ('187929', '11736'), -- Blade's Edge Mountains
('187961', '11768'), ('187961', '11844'), ('187924', '11810'), ('187924', '11739'), -- Burning Steppes
('207991', '11769'), ('207991', '11845'), ('187922', '11812'), ('187922', '11741'), -- Desolace
('187957', '11770'), ('187957', '11846'), -- Durotar
('187968', '11771'), ('187968', '11847'), ('187939', '11815'), ('187939', '11744'), -- Dustwallow
('187948', '11772'), ('187948', '11848'), -- Eversong woods
('187953', '11773'), ('187953', '11849'), ('187928', '11817'), ('187928', '11746'), -- Feralas
('187970', '11774'), ('187970', '11850'), -- Ghostlands
('187966', '11775'), ('187966', '11851'), ('187937', '11818'), ('187937', '11747'), -- Hellfire Peninsula
('187975', '11776'), ('187975', '11853'), -- Hillsbrad Foothills
('187969', '11777'), ('187969', '11852'), -- Mulgore
('187951', '11778'), ('187951', '11750'), ('187951', '11854'), ('187951', '11821'), -- Nagrand
('187956', '11779'), ('187956', '11855'), ('187931', '11823'), ('187931', '11752'), -- Shadowmoon Valley
('187954', '11780'), ('187954', '11856'), ('187932', '28928'), ('187932', '28915'), -- Stonetalon Mountains
('187947', '11781'), ('187947', '11857'), ('187947', '28929'), ('187947', '28916'), -- Swamp of Sorrows
('187972', '11782'), ('187972', '11858'), ('187925', '11825'), ('187925', '11754'), -- Terokkar
('187964', '11783'), ('187964', '11859'), -- Barrens
('187952', '11784'), ('187952', '11860'), ('187927', '11826'), ('187927', '11755'), -- Hinterlands
('187959', '11786'), ('187959', '11862'), -- Tirisfal
('187965', '11787'), ('187965', '11863'), ('187941', '11829'), ('187941', '11758'), -- Zangarmarsh
('194043', '11799'), ('194043', '11835'), ('194043', '11830'), ('194043', '11759'), -- Netherstorm
('194037', '11800'), ('194037', '11836'), ('194037', '11831'), ('194037', '11760'), -- Silithus
('194046', '11801'), ('194046', '11837'), ('194046', '11832'), ('194046', '11761'), -- Cap of Stranglethorn
('194042', '11802'), ('194042', '11838'), ('194042', '11833'), ('194042', '11762'), -- Tanaris
('187958', '11803'), ('187958', '11839'), ('187958', '11834'), ('187958', '11763'), -- Winterspring
('194034', '13441'), ('194034', '13493'), ('187943', '13485'), ('187943', '13440'), -- Borean Tundra
('194033', '13450'), ('194033', '13494'), ('194033', '13486'), ('194033', '13442'), -- Sholazar Basin
('187967', '13451'), ('187967', '13495'), ('187917', '13487'), ('187917', '13443'), -- Dragonblight
('187949', '13453'), ('187949', '13496'), ('187934', '13488'), ('187934', '13444'), -- Howling Fjord
('187962', '13454'), ('187962', '13497'), ('187936', '13489'), ('187936', '13445'), -- Grizzly Hills
('187955', '13455'), ('187955', '13498'), ('187955', '13490'), ('187955', '13446'), -- Storm Peaks
('187960', '13457'), ('187960', '13499'), ('194036', '13491'), ('194036', '13447'), -- Crystalsong Forest
('187974', '13458'), ('187974', '13500'), ('187974', '13492'), ('187974', '13449'), -- Zuldrak
('194039', '28911'), ('194039', '28924'), ('187916', '28922'), ('187916', '28910'), -- Northern Stranglethorn
('194048', '28914'), ('194048', '28927'), ('187942', '28926'), ('187942', '28913'), -- Southern Barrens
('208090', '28917'), ('208090', '28930'), ('187914', '11808'), ('187914', '11737'), -- Blasted Land
('208094', '28918'), ('208094', '28931'), ('187940', '11827'), ('187940', '11756'), -- Western Plaguelands
('187919', '11811'), ('187919', '11740'), -- Darkshore
('187944', '11806'), ('187944', '11735'), -- Azuremyst
('187923', '11809'), ('187923', '11738'), -- Bloodmyst isle
('187926', '11828'), ('187926', '11757'), -- Wetlands
('187930', '11824'), ('187930', '11753'), -- Teldrassil
('187933', '11822'), ('187933', '11751'), -- Redridge Mountains
('187935', '11814'), ('187935', '11743'), -- Duskwood
('187945', '11813'), ('187945', '11742'), -- Dun Morogh
('194035', '11820'), ('194035', '11749'), -- Loch Modan
('187946', '11816'), ('187946', '11745'), -- Elwynn Forest
('207986', '28919'), ('207986', '28923'), -- Azshara
('207989', '28920'), ('207989', '28933'), ('207989', '28932'), ('207989', '28921'),-- Ungoro
('187564', '11583'), ('187564', '11581'), -- Westfall
('207983', '28944'), ('207983', '28946'), ('187921', '28945'), ('187921', '28943'), -- Twilight Highlands
('207990', '28948'), ('207990', '28949'), ('207990', '28950'), ('207990', '28947'), -- Uldum
('208188','29036'), -- Deepholm
('194045','29031'), -- Vashjir
('194038','29030'); -- Hyjal

-- Maping of all bonfires
DELETE FROM gameobject
WHERE gameobject.id IN (SELECT gameobject_template.entry
FROM gameobject_template
WHERE gameobject_template.name =  'Alliance Bonfire' OR gameobject_template.name =  'Horde Bonfire' OR
 gameobject_template.entry = '208188');

INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(@my_id,'187975','0','267','272','1','1','-14.5513','-760.967','62.2875','0.930043','0','0','0.448442','0.893812','300','0','1'),
(@my_id+1,'187966','530','3483','3536','1','1','41.6889','2604.69','70.9675','2.6861','0','0','0.974178','0.225782','300','0','1'),
(@my_id+2,'187970','530','3433','3509','1','1','7671.3','-6833.76','79.1579','0.385328','0','0','0.191474','0.981498','300','0','1'),
(@my_id+3,'187953','1','357','1099','1','1','-4496.48','298.521','42.3945','0.482056','0','0','0.238701','0.971093','300','0','1'),
(@my_id+4,'187948','530','3430','3430','1','1','9377.51','-6791.11','15.0577','5.13859','0','0','0.541566','-0.840658','300','0','1'),
(@my_id+5,'187968','1','15','15','1','1','-3169.72','-3023.66','36.064','5.79657','0','0','0.240913','-0.970547','300','0','1'),
(@my_id+6,'187957','1','14','14','1','1','208.103','-4756.79','11.739','5.75601','0','0','0.260547','-0.965461','300','0','1'),
(@my_id+7,'207991','1','405','598','1','1','-1838.49','3017.22','10.3742','4.93622','0','0','0.623712','-0.781654','300','0','1'),
(@my_id+8,'187961','0','46','251','1','1','-7583.92','-2164.66','152.275','5.8955','0','0','0.19263','-0.981271','300','0','1'),
(@my_id+9,'187929','530','3522','3771','1','1','2023.05','6579.69','134.282','2.88024','0','0','0.991474','0.130307','300','0','1'),
(@my_id+10,'208188','646','0','0','1','1','1047.22','532.122','-49.3348','0.575958','0','0','0.284015','0.95882','300','255','1'),
(@my_id+11,'187914','0','4','5076','1','1','-10949.2','-3220.53','41.3481','3.79465','0','0','0.947161','-0.320757','300','0','1'),
(@my_id+12,'207986','1','16','4821','1','1','3535.38','-6676.35','96.3585','5.28849','0','0','0.477096','-0.878851','300','0','1'),
(@my_id+13,'187919','1','148','4659','1','1','7339.08','-170.023','11.0774','5.08696','0','0','0.563082','-0.826401','300','0','1'),
(@my_id+14,'194037','1','1377','1377','1','1','-6984.1','942.901','12.1445','2.55716','0','0','0.957608','0.288074','300','0','1'),
(@my_id+15,'187971','0','130','228','1','1','574.712','1385.03','91.6991','6.02417','0','0','0.129148','-0.991625','300','0','1'),
(@my_id+16,'187973','0','45','321','1','1','-1104.63','-3544.55','50.0248','4.98206','0','0','0.605633','-0.795744','300','0','1'),
(@my_id+17,'187952','0','47','3317','1','1','-492.324','-4529.4','12.2065','2.99409','0','0','0.997282','0.0736843','300','0','1'),
(@my_id+18,'187964','1','17','17','1','1','-358.091','-2459.48','92.4936','4.85452','0','0','0.655113','-0.755531','300','0','1'),
(@my_id+19,'207989','1','490','4882','1','1','-7536.53','-1550.13','-270.094','0.376212','0','0','0.186999','0.98236','300','0','1'),
(@my_id+20,'187564','0','40','20','1','1','-10919.1','1431.83','43.1888','4.62792','0','0','0.73633','-0.676622','300','0','1'),
(@my_id+21,'187958','1','618','2255','1','1','6703.27','-4596.33','721.85','3.15457','0','0','0.999979','-0.00648761','300','0','1'),
(@my_id+22,'187969','1','215','215','1','1','-2477.75','-511.14','-9.42404','1.0295','0','0','0.492316','0.870417','300','0','1'),
(@my_id+23,'187951','530','3518','3518','1','1','-1202.83','7478.1','22.3077','2.77247','0','0','0.983017','0.183517','300','0','1'),
(@my_id+24,'187956','530','3520','3744','1','1','-3169.19','2569.87','62.6315','0.735071','0','0','0.359316','0.933216','300','0','1'),
(@my_id+25,'187954','1','406','1076','1','1','939.753','757.688','108.513','4.35265','0','0','0.822201','-0.569197','300','0','1'),
(@my_id+26,'187947','0','8','8','1','1','-9894.73','-3884.87','21.2915','2.87807','0','0','0.991332','0.131378','300','0','1'),
(@my_id+27,'187972','530','3519','3519','1','1','-2554.88','4270.06','21.023','0.628258','0','0','0.308988','0.951066','300','0','1'),
(@my_id+28,'187959','0','85','85','1','1','2158.22','222.592','42.1399','1.93461','0','0','0.82336','0.56752','300','0','1'),
(@my_id+29,'187965','530','3521','3521','1','1','220.101','7684.02','23.2568','2.59185','0','0','0.96246','0.271424','300','0','1'),
(@my_id+30,'194043','530','3523','3523','1','1','3012.46','3552.77','144.332','1.05206','0','0','0.502102','0.864808','300','0','1'),
(@my_id+31,'194046','0','5287','43','1','1','-14345.7','124.739','2.27994','1.83344','0','0','0.793609','0.608428','300','0','1'),
(@my_id+32,'194042','1','440','976','1','1','-7080.24','-3671.51','12.4892','4.9645','0','0','0.612597','-0.790395','300','0','1'),
(@my_id+33,'194034','571','3537','4122','1','1','4446.14','5651.6','61.9464','2.70701','0','0','0.976485','0.215586','300','0','1'),
(@my_id+34,'194033','571','3711','4290','1','1','5429.31','4742.1','-196.068','4.73041','0','0','0.700708','-0.713448','300','0','1'),
(@my_id+35,'187967','571','65','65','1','1','3722.72','1522.99','93.2221','5.22192','0','0','0.50608','-0.862486','300','0','1'),
(@my_id+36,'187949','571','495','495','1','1','2574.64','-4325.2','277.327','0.813354','0','0','0.39556','0.91844','300','0','1'),
(@my_id+37,'187962','571','394','394','1','1','3374.48','-2137.62','124.892','3.4056','0','0','0.9913','-0.131622','300','0','1'),
(@my_id+38,'187955','571','67','4419','1','1','6159.79','-1021.45','408.22','4.30719','0','0','0.834925','-0.550363','300','0','1'),
(@my_id+39,'187960','571','2817','4557','1','1','5532.43','-847.613','162.289','0.813739','0','0','0.395736','0.918364','300','0','1'),
(@my_id+40,'187974','571','66','4275','1','1','5465.56','-2680.72','303.954','0.432091','0','0','0.214369','0.976753','300','0','1'),
(@my_id+41,'194039','0','33','117','1','1','-12382.9','77.0239','3.36778','0.636552','0','0','0.31293','0.949776','300','0','1'),
(@my_id+42,'194048','1','4709','4709','1','1','-3007.94','-1999.37','93.9157','0.933787','0','0','0.450114','0.892971','300','0','1'),
(@my_id+43,'208090','0','4','1437','1','1','-11024.9','-2859.56','9.4167','1.19731','0','0','0.563533','0.826094','300','0','1'),
(@my_id+44,'208094','0','28','813','1','1','1732.79','-847.165','60.8114','1.52621','0','0','0.691168','0.722694','300','0','1'),
(@my_id+45,'207983','0','4922','4922','1','1','-3743.37','-5193.48','39.9502','5.44637','0','0','0.406305','-0.913738','300','0','1'),
(@my_id+46,'207990','1','5034','5466','1','1','-9562.53','-920.24','100.27','1.31788','0','0','0.61228','0.790641','300','0','1'),
(@my_id+47,'207992','0','3','1878','1','1','-6723.6','-2644.71','241.667','0.234359','0','0','0.116912','0.993142','300','0','1'),
(@my_id+48,'187936','571','394','394','1','1','3342.89','-2965.15','190.922','1.82069','0','0','0.789714','0.613475','300','0','1'),
(@my_id+49,'187916','0','5339','33','1','1','-12785.2','-451.11','15.3523','2.76885','0','0','0.982683','0.185296','300','0','1'),
(@my_id+50,'187917','571','65','4177','1','1','3767.03','-996.752','124.901','1.28234','0','0','0.598133','0.801397','300','0','1'),
(@my_id+51,'187920','1','331','2358','1','1','2959.21','-3230.44','164.944','2.10245','0','0','0.868031','0.496509','300','0','1'),
(@my_id+52,'187921','0','4922','5142','1','1','-3195.35','-5013.37','121.514','0.178692','0','0','0.089227','0.996011','300','0','1'),
(@my_id+53,'187922','1','405','608','1','1','-49.3093','1169.07','91.3554','0.655005','0','0','0.321679','0.946849','300','0','1'),
(@my_id+54,'187923','530','3525','3525','1','1','-2155.81','-11868.3','36.4004','0.605551','0','0','0.298171','0.954513','300','0','1'),
(@my_id+55,'187924','0','46','5677','1','1','-8298.09','-2754.36','175.982','2.28111','0','0','0.908864','0.417092','300','0','1'),
(@my_id+56,'187925','530','3519','3519','1','1','-2967.88','4125.31','7.06353','1.85111','0','0','0.798955','0.601391','300','0','1'),
(@my_id+57,'187926','0','11','11','1','1','-3477.94','-910.883','10.4615','4.40876','0','0','0.80591','-0.592038','300','0','1'),
(@my_id+58,'187927','0','47','348','1','1','200.002','-2081.63','116.818','1.68404','0','0','0.745989','0.665959','300','0','1'),
(@my_id+59,'187928','1','357','5072','1','1','-4227.9','2228.66','10.5052','3.47362','0','0','0.986251','-0.165254','300','0','1'),
(@my_id+60,'194045','0','5144','5005','1','1','-6114.18','4290.3','-348.941','2.6127','0','0','0.965238','0.261374','300','0','1'),
(@my_id+61,'187930','1','141','141','1','1','9868.26','842.995','1307.98','5.22358','0','0','0.505361','-0.862908','300','0','1'),
(@my_id+62,'187931','530','3520','3745','1','1','-3865.59','2124.53','95.0656','2.63025','0','0','0.967494','0.252896','300','0','1'),
(@my_id+63,'187932','1','406','464','1','1','1410.23','999.276','151.36','3.06066','0','0','0.999181','0.0404564','300','0','1'),
(@my_id+64,'187933','0','44','44','1','1','-9441.65','-2135.48','67.058','4.56507','0','0','0.757227','-0.653152','300','0','1'),
(@my_id+65,'187934','571','495','495','1','1','2336.89','-4905.06','250.256','2.75722','0','0','0.981589','0.191003','300','0','1'),
(@my_id+66,'187935','0','10','42','1','1','-10458.5','-1185.51','26.7824','5.13766','0','0','0.541955','-0.840408','300','0','1'),
(@my_id+67,'187937','530','3483','3483','1','1','-626.613','2502.31','67.7245','0.737529','0','0','0.360463','0.932773','300','0','1'),
(@my_id+68,'187938','0','3','5564','1','1','-7007.27','-2494.55','241.667','5.12425','0','0','0.547577','-0.836756','300','0','1'),
(@my_id+69,'187939','1','15','15','1','1','-3549.02','-4281.23','7.11044','2.33139','0','0','0.919062','0.394113','300','0','1'),
(@my_id+70,'187940','0','28','28','1','1','1029.54','-1439.29','63.1364','3.2588','0','0','0.998283','-0.0585693','300','0','1'),
(@my_id+71,'187941','530','3521','3521','1','1','174.406','6054.13','21.8511','0.997531','0','0','0.478342','0.878174','300','0','1'),
(@my_id+72,'187942','1','4709','4709','1','1','-3023.82','-2137.53','106.161','4.25782','0','0','0.848255','-0.529589','300','0','1'),
(@my_id+73,'187943','571','3537','4108','1','1','4139.65','5395.79','27.0848','4.95796','0','0','0.615179','-0.788388','300','0','1'),
(@my_id+74,'187944','530','3524','3524','1','1','-4210.17','-12296.5','1.58731','3.60656','0','0','0.973097','-0.230394','300','0','1'),
(@my_id+75,'187945','0','1','189','1','1','-5451.34','-671.924','393.762','3.67047','0','0','0.965239','-0.261368','300','0','1'),
(@my_id+76,'187946','0','12','87','1','1','-9502.27','11.649','56.8187','5.73609','0','0','0.270147','-0.962819','300','0','1'),
(@my_id+77,'194032','0','45','320','1','1','-1202.42','-2644.73','47.252','4.25008','0','0','0.8503','-0.526299','300','0','1'),
(@my_id+78,'194035','0','38','38','1','1','-5284.12','-2865.52','337.39','1.00483','0','0','0.481543','0.876423','300','0','1'),
(@my_id+79,'194036','571','2817','4557','1','1','5160.18','-727.045','168.351','3.29716','0','0','0.996976','-0.0777055','300','0','1'),
(@my_id+80,'187950','530','3522','3768','1','1','2273.09','6135.38','136.726','5.69037','0','0','0.292084','-0.956393','300','0','1'),
(@my_id+81,'194038','1','616','5038','1','1','5592.74','-3588.75','1571.62','0.223424','0','0','0.11148','0.993767','300','0','1'),
(@my_id+82,'187963','1','331','420','1','1','2147.5','-1235.57','96.3553','1.19533','0','0','0.562714','0.826652','300','0','1');




-- Insertion of the GObjects in the correct event
DELETE FROM `game_event_gameobject` WHERE `eventEntry`=1; -- A clear of BD about creatures to prevents any duplications of primary keys

INSERT INTO `game_event_gameobject` (eventEntry, guid)
SELECT  '1' , go.guid
FROM gameobject AS go
WHERE go.id IN ( SELECT gameobject_template.entry
FROM gameobject_template
WHERE gameobject_template.name =  'Alliance Bonfire' OR gameobject_template.name =  'Horde Bonfire');

INSERT INTO `game_event_gameobject` (eventEntry, guid)
SELECT '1' , gameobject.guid
FROM gameobject
WHERE gameobject.id IN (
 '188021', -- Camp Pavillon
'181302', -- Camp Crate
'188020', -- Camp Banner
'208188', -- Earthen Ring Bonfire - Deepholm Bonfire
'181358', -- Hanging, Square, Large - MFF
'181393', -- Hanging, Tall/thin, Medium - MFF
'181389', -- Hanging, Tall/thin, Large - MFF
'181401', -- Hanging, Streamer x3 - MFF
'181392', -- Hanging, Streamer - MFF
'181390', -- Hanging,Square, Medium - MFF
'181374', -- Midsummer Music Doodad
'181376', -- Midsummer Bonfire Campfire Damage Trap
'181355', -- Midsummer Brazier
'181605'); -- Ribbon Pole


-- NPC management
DELETE FROM `game_event_creature` WHERE `eventEntry`=1; -- A clear of BD about creatures to prevents any duplications of primary keys


INSERT INTO `game_event_creature` (eventEntry, guid)
SELECT '1' , creature.guid
FROM creature
WHERE creature.id IN (
'25994', -- Avaleur de flamme
'25962', -- Mangeur de feu
'25975', -- Maitre Mangeur de feu
'16817', -- Maitre des traditions de la fete
'16781', -- Noceur du solstice d'ete
'16818', -- Conteur de la fete
'26520', -- Bruletin de la fete
'26221', -- Ancien du cercle terrestre
'26123', -- Fournisseuse du solstice
'26124',-- Marchande du solstice
'25934', -- Hellfire Peninsula Flame Keeper
'25936', -- Garde-flamme de la foret de Terokkar
'25947', -- Garde-flamme du marécage de Zangar
'25883', -- Garde-flamme d'Orneval
'25884', -- Garde-flamme d'Orneval
'25890', -- Gardienne des flammes des Terres foudroyées
'25900', -- hellfire peninsula flame warden
'25937'); -- Nagrand Flame Keeper
 
Last edited:

Titesusy

Veteran Member
134
2016
4
Location
France
Sorry if sometimes the comments are in French, it's because it's translated in French for me :) But there are only comments, so ... :)

And sorry for the title, but it would be "V7 (MAYBE NEWER?) CATACLYSM SERVER - MIDSUMMER EVENT" (to replace the "older" by "newer") ... we don't mind about it :)
 
Last edited:

ExO

Admin
5,084
2014
1,442
Thanks for the contribution! Sending you the updated revision so you can see the newest fixes the start of next week :)
 

Titesusy

Veteran Member
134
2016
4
Location
France
ok thanks you :)

This script will be revised maybe later, adding some decorations around the bonfires (on many places, there is only a bonfire to accomplish the quests, in the barrens for example)
 

ExO

Admin
5,084
2014
1,442
Has the new release been delayed, Exo ?

It's best to send you the new version at the same time as V.10 releases.

V.10 will release around 20 december, so I will send it to you there :)

(It's the best way to prevent you from reporting bugs that are already fixed)
 

Titesusy

Veteran Member
134
2016
4
Location
France
updated 2019.02.24
- minor fix about "Hanging, Tall/thin, Large - MFF" (item_id = '181389' ) was showed up even when the event was off
 
Top