Lunar Event
- Thread starter Titesusy
- Start date
here is the code 
Code:
-- Last Revision & Tests : 2019.03.03 by Titesusy
-- Tested with V10.1
-- Modifiable starting here
SET @my_guid = 23200; -- @my_guid => @my_guid+110 must be free
-- NON Modifiable starting here
SET @my_event_id = 7;
DELETE FROM game_event_creature_quest WHERE id IN
('30364', '15567', '15871', '30375', '30357', '30538', '15574', '15583', '15566', '15562', '30370', '15580', '30359', '15595', '15560', '15565',
'30373', '15597', '15549', '15559', '15588', '30536', '30531', '30534', '15598', '30368', '15600', '30367', '30358', '30374', '15607', '15568',
'30360', '30533', '15561', '15584', '15586', '30537', '30371', '15556', '15557', '15570', '15569', '15596', '30362', '15575', '30348', '15564',
'15563', '30369', '30363', '15581', '15592', '15558', '15603', '30365', '30372', '30535', '15585', '15606', '15605', '15593', '15577', '15602',
'15578', '15594', '15599', '15587', '15604', '15579', '15601', '15573', '15582', '15572',
'55217', '55216', '55210', '55211', '55218', '55219', '55227', '55224', '55228',
'15892', '15891', '15895', '15898', '15909', '15864');
DELETE FROM creature_questrelation WHERE id IN
('30364', '15567', '15871', '30375', '30357', '30538', '15574', '15583', '15566', '15562', '30370', '15580', '30359', '15595', '15560', '15565',
'30373', '15597', '15549', '15559', '15588', '30536', '30531', '30534', '15598', '30368', '15600', '30367', '30358', '30374', '15607', '15568',
'30360', '30533', '15561', '15584', '15586', '30537', '30371', '15556', '15557', '15570', '15569', '15596', '30362', '15575', '30348', '15564',
'15563', '30369', '30363', '15581', '15592', '15558', '15603', '30365', '30372', '30535', '15585', '15606', '15605', '15593', '15577', '15602',
'15578', '15594', '15599', '15587', '15604', '15579', '15601', '15573', '15582', '15572',
'55217', '55216', '55210', '55211', '55218', '55219', '55227', '55224', '55228',
'15892', '15891', '15895', '15898', '15909', '15864');
DELETE FROM creature_involvedrelation WHERE id IN
('30364', '15567', '15871', '30375', '30357', '30538', '15574', '15583', '15566', '15562', '30370', '15580', '30359', '15595', '15560', '15565',
'30373', '15597', '15549', '15559', '15588', '30536', '30531', '30534', '15598', '30368', '15600', '30367', '30358', '30374', '15607', '15568',
'30360', '30533', '15561', '15584', '15586', '30537', '30371', '15556', '15557', '15570', '15569', '15596', '30362', '15575', '30348', '15564',
'15563', '30369', '30363', '15581', '15592', '15558', '15603', '30365', '30372', '30535', '15585', '15606', '15605', '15593', '15577', '15602',
'15578', '15594', '15599', '15587', '15604', '15579', '15601', '15573', '15582', '15572',
'55217', '55216', '55210', '55211', '55218', '55219', '55227', '55224', '55228',
'15892', '15891', '15895', '15898', '15909', '15864');
INSERT INTO creature_questrelation (id, quest) VALUES
-- elders
('30364', '13033'), -- Borean Tundra
('15567', '8651'), -- Searing Gorge
('15871', '8866'), -- Ironforge
('30375', '13020'), -- Storm peaks
('30357', '13013'), -- Grizzly hills
('30538', '13067'), -- Dongeon : Utgarde pinnacle
('15574', '8672'), -- winterspring
('15583', '8681'), -- ungoro
('15566', '8650'), -- eastern plaguelands
('15562', '8646'), -- Stormwind
('30370', '13028'), -- Storm peaks (K3)
('15580', '8678'), -- Thunder Bluff
('30359', '13015'), -- frosthold
('15595', '8715'), -- teldrassil
('15560', '8644'), -- dungeon : blackrock spire
('15565', '8649'), -- goldshire
('30373', '13031'), -- agmar hammer
('15597', '8717'), -- Northen barrens
('15549', '8619'), -- Blackrock depths
('15559', '8643'), -- hinterlands
('15588', '8686'), -- South barrens
('30536', '13021'), -- dungeon : nexus
('30531', '13017'), -- dungeon : utgarde keep
('30534', '13023'), -- dungeon : Drak Tharon
('15598', '8718'), -- Darnassus
('30368', '13026'), -- wintergrasp
('15600', '8720'), -- Azshara
('30367', '13025'), -- grizzly hills (bis)
('30358', '13014'), -- star's rest (dragonblight)
('30374', '13032'), -- Tunka'lo
('15607', '8727'), -- dungeon : Stratholme
('15568', '8652'), -- Brill (Tirisfal)
('30360', '13016'), -- Borean Tundra (bis)
('30533', '13022'), -- dungeon : Azjol Nerub
('15561', '8645'), -- Silverpine
('15584', '8682'), -- Thousand needles
('15586', '8684'), -- gadgetzan
('30537', '13065'), -- dungeon : gundrak
('30371', '13029'), -- warsong hold
('15556', '8635'), -- dungeon : maraudon
('15557', '8636'), -- dreadmaul (burning steppes)
('15570', '8654'), -- crystal vale (silithus)
('15569', '8653'), -- Kharanos
('15596', '8716'), -- stranglethorn northen
('30362', '13018'), -- Sholazar
('15575', '8673'), -- mulgore
('30348', '13012'), -- vaillance keep (borean tundra)
('15564', '8648'), -- undercity
('15563', '8647'), -- blasted lands
('30369', '13027'), -- zuldrak
('30363', '13019'), -- moa'ki
('15581', '8679'), -- mojache (feralas)
('15592', '8688'), -- Eastern Plaguelands
('15558', '8642'), -- Loch Modan
('15603', '8723'), -- felwood
('30365', '13024'), -- sholazar
('30372', '13030'), -- grizzly hills
('30535', '13066'), -- dungeon : hall of stone
('15585', '8683'), -- burning steppes
('15606', '8726'), -- winterspring 60
('15605', '8725'), -- astranaar
('15593', '8713'), -- sunken temple
('15577', '8675'), -- Westfall
('15602', '8722'), -- Western plaguelands
('15578', '8676'), -- dungeon : Zul Farrak
('15594', '8714'), -- scholomance (western plaguelands)
('15599', '8719'), -- silithus (bis)
('15587', '8685'), -- feralas (bis)
('15604', '8724'), -- thousand needles (bis)
('15579', '8677'), -- orgrimmar
('15601', '8721'), -- darkshore
('15573', '8671'), -- tanaris
('15582', '8680'), -- cabestan
('15572', '8670'), -- durotar
('55217', '29735'), -- Deepholm 1
('55216', '29734'), -- Deepholm 2
('55210', '29741'), -- uldum 1
('55211', '29742'), -- uldum 2
('55218', '29736'), -- twilight highlands 1
('55219', '29737'), -- twilight highlands 2
('55227', '29740'), -- hyjal 1
('55224', '29739'), -- hyjal 2
('55228', '29738'), -- vashjir
-- emissaires debut only
('15892', '8870'), ('15892', '8871'), ('15892', '8872'),
-- herault debut only
('15891', '8873'), ('15891', '8874'), ('15891', '8875'),
-- messageres debut only
('15895', '8867'), ('15895', '8883'),
-- valadar chantétoile debut only
('15864', '8868');
INSERT INTO creature_involvedrelation (id, quest) VALUES
-- elders
('30364', '13033'), -- Borean Tundra
('15567', '8651'), -- Searing Gorge
('15871', '8866'), -- Ironforge
('30375', '13020'), -- Storm peaks
('30357', '13013'), -- Grizzly hills
('30538', '13067'), -- Dongeon : Utgarde pinnacle
('15574', '8672'), -- winterspring
('15583', '8681'), -- ungoro
('15566', '8650'), -- eastern plaguelands
('15562', '8646'), -- Stormwind
('30370', '13028'), -- Storm peaks (K3)
('15580', '8678'), -- Thunder Bluff
('30359', '13015'), -- frosthold
('15595', '8715'), -- teldrassil
('15560', '8644'), -- dungeon : blackrock spire
('15565', '8649'), -- goldshire
('30373', '13031'), -- agmar hammer
('15597', '8717'), -- Northen barrens
('15549', '8619'), -- Blackrock depths
('15559', '8643'), -- hinterlands
('15588', '8686'), -- South barrens
('30536', '13021'), -- dungeon : nexus
('30531', '13017'), -- dungeon : utgarde keep
('30534', '13023'), -- dungeon : Drak Tharon
('15598', '8718'), -- Darnassus
('30368', '13026'), -- wintergrasp
('15600', '8720'), -- Azshara
('30367', '13025'), -- grizzly hills (bis)
('30358', '13014'), -- star's rest (dragonblight)
('30374', '13032'), -- Tunka'lo
('15607', '8727'), -- dungeon : Stratholme
('15568', '8652'), -- Brill (Tirisfal)
('30360', '13016'), -- Borean Tundra (bis)
('30533', '13022'), -- dungeon : Azjol Nerub
('15561', '8645'), -- Silverpine
('15584', '8682'), -- Thousand needles
('15586', '8684'), -- gadgetzan
('30537', '13065'), -- dungeon : gundrak
('30371', '13029'), -- warsong hold
('15556', '8635'), -- dungeon : maraudon
('15557', '8636'), -- dreadmaul (burning steppes)
('15570', '8654'), -- crystal vale (silithus)
('15569', '8653'), -- Kharanos
('15596', '8716'), -- stranglethorn northen
('30362', '13018'), -- Sholazar
('15575', '8673'), -- mulgore
('30348', '13012'), -- vaillance keep (borean tundra)
('15564', '8648'), -- undercity
('15563', '8647'), -- blasted lands
('30369', '13027'), -- zuldrak
('30363', '13019'), -- moa'ki
('15581', '8679'), -- mojache (feralas)
('15592', '8688'), -- Eastern Plaguelands
('15558', '8642'), -- Loch Modan
('15603', '8723'), -- felwood
('30365', '13024'), -- sholazar
('30372', '13030'), -- grizzly hills
('30535', '13066'), -- dungeon : hall of stone
('15585', '8683'), -- burning steppes
('15606', '8726'), -- winterspring 60
('15605', '8725'), -- astranaar
('15593', '8713'), -- sunken temple
('15577', '8675'), -- Westfall
('15602', '8722'), -- Western plaguelands
('15578', '8676'), -- dungeon : Zul Farrak
('15594', '8714'), -- scholomance (western plaguelands)
('15599', '8719'), -- silithus (bis)
('15587', '8685'), -- feralas (bis)
('15604', '8724'), -- thousand needles (bis)
('15579', '8677'), -- orgrimmar
('15601', '8721'), -- darkshore
('15573', '8671'), -- tanaris
('15582', '8680'), -- cabestan
('15572', '8670'), -- durotar
('55217', '29735'), -- Deepholm 1
('55216', '29734'), -- Deepholm 2
('55210', '29741'), -- uldum 1
('55211', '29742'), -- uldum 2
('55218', '29736'), -- twilight highlands 1
('55219', '29737'), -- twilight highlands 2
('55227', '29740'), -- hyjal 1
('55224', '29739'), -- hyjal 2
('55228', '29738'), -- vashjir
-- messageres fin only
('15895', '8870'), ('15895', '8871'), ('15895', '8872'),
('15895', '8873'), ('15895', '8874'), ('15895', '8875'),
('15895', '8867'),
-- valadar chantétoile fin only
('15864', '8868'), ('15864', '8883');
DELETE FROM creature WHERE id IN
('30364', '15567', '15871', '30375', '30357', '30538', '15574', '15583', '15566', '15562', '30370', '15580', '30359', '15595', '15560', '15565',
'30373', '15597', '15549', '15559', '15588', '30536', '30531', '30534', '15598', '30368', '15600', '30367', '30358', '30374', '15607', '15568',
'30360', '30533', '15561', '15584', '15586', '30537', '30371', '15556', '15557', '15570', '15569', '15596', '30362', '15575', '30348', '15564',
'15563', '30369', '30363', '15581', '15592', '15558', '15603', '30365', '30372', '30535', '15585', '15606', '15605', '15593', '15577', '15602',
'15578', '15594', '15599', '15587', '15604', '15579', '15601', '15573', '15582', '15572',
'55217', '55216', '55210', '55211', '55218', '55219', '55227', '55224', '55228',
'15892', '15891', '15895', '15898', '15909', '15864');
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+0 ,'15549','230','0','0','1','1','0','0','592.67','-190.145','-54.0991','0.222688','25','0','0','2563','5751','0','0','0','0','0','0'),
(@my_guid+1 ,'15556','349','0','0','1','1','0','0','-7.67095','-246.622','-168.102','3.28483','25','0','0','2563','5751','0','0','0','0','0','0'),
(@my_guid+2 ,'15557','0','46','249','1','1','0','0','-7986.77','-2517.4','135.895','0.702454','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+3 ,'15558','0','38','144','1','1','0','0','-5371.5','-2910.58','340.201','1.68891','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+4 ,'15559','0','47','47','1','1','0','0','485.1','-3598.7','117.233','2.72234','300','0','0','7469','0','0','0','0','0','0','0'),
(@my_guid+5 ,'15560','229','0','0','1','1','0','0','31.5467','-401.319','48.6986','1.68414','25','0','0','2563','5751','0','0','0','0','0','0'),
(@my_guid+6 ,'15561','0','130','228','1','3','0','0','491.81','1524.71','130.901','1.31727','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+7 ,'15562','0','12','12','1','1','0','0','-9129.87','333.085','93.2741','1.50202','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+8 ,'15563','0','4','72','1','1','0','0','-11796.9','-3205.23','-29.0437','1.84447','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+9 ,'15564','0','1497','1497','1','65535','0','0','1585.67','250.872','-62.0803','2.22127','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+10 ,'15565','0','12','87','1','1','0','0','-9417.15','109.01','59.9278','4.03651','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+11 ,'15566','0','139','2268','1','1','0','0','2280.48','-5330.23','89.5843','1.91497','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+12 ,'15567','0','51','1957','1','1','0','0','-7239.17','-767.329','308.66','3.98699','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+13 ,'15568','0','85','159','1','1','0','0','2180.79','223.314','37.9151','1.66757','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+14 ,'15569','0','1','131','1','1','0','0','-5608.46','-508.595','401.852','0.345865','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+15 ,'15570','1','1377','3100','1','1','0','0','-6163.13','1776.59','28.7369','0.226889','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+16 ,'15572','1','14','362','1','1','0','0','319.39','-4709.33','13.6551','4.0368','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+17 ,'15573','1','440','992','1','1','0','0','-9465.32','-2979.14','11.0077','1.1074','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+18 ,'15573','1','0','0','1','1','0','0','-9560.5','-2700.24','12.281','0.920799','90','0','0','2563','5751','0','0','0','0','0','0'),
(@my_guid+19 ,'15574','1','618','2255','1','1','0','0','6672.79','-4638.01','721.593','1.57195','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+20 ,'15575','1','215','223','1','1','0','0','-2112.22','-412.853','-6.89172','4.02893','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+21 ,'15577','0','40','108','1','65535','0','0','-10499.3','1033.81','95.6127','4.99','25','0','0','2563','5751','0','0','0','0','0','0'),
(@my_guid+22 ,'15578','209','0','0','1','1','0','0','1689.15','1147.89','8.87702','2.41196','25','0','0','2563','5751','0','0','0','0','0','0'),
(@my_guid+23 ,'15579','1','1637','1637','1','65535','0','0','1769.24','-4329','101.366','4.7515','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+24 ,'15580','1','1638','1639','1','65535','0','0','-1025.42','-270.258','159.03','0.270022','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+25 ,'15581','1','357','357','1','1','0','0','-4261.93','160.017','57.408','6.16205','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+26 ,'15582','1','17','392','1','1','0','0','-954.043','-3706.45','6.16971','3.29572','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+27 ,'15583','1','490','540','1','1','0','0','-7924.79','-1237.84','-268.086','0.328295','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+28 ,'15584','1','400','484','1','1','0','0','-5444.9','-2432.31','89.5751','2.54688','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+29 ,'15585','0','46','251','1','1','0','0','-7506.36','-2192.86','165.114','1.46193','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+30 ,'15586','1','440','976','1','1','0','0','-7101.13','-3768.72','8.94287','2.51702','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+31 ,'15587','1','357','4992','1','1','0','0','-3989.52','1129.35','161.026','6.23745','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+32 ,'15588','1','4709','4986','1','1','0','0','-2150.16','-1749.11','91.5373','2.0954','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+33 ,'15592','0','139','2263','1','1','0','0','1849.12','-3682.94','157.37','5.7367','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+34 ,'15593','109','1477','1477','1','65535','0','0','-407.623','123.53','-91.0045','3.71499','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+35 ,'15594','0','28','2298','1','1','0','0','1139.45','-2578.32','62.0727','3.45904','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+36 ,'15595','1','141','186','1','1','0','0','9885.11','952.287','1310.1','3.08813','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+37 ,'15596','0','33','19','1','1','0','0','-11929.8','-1205.52','85.1127','1.60726','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+38 ,'15597','1','17','380','1','1','0','0','-483.933','-2641.43','96.9475','5.06656','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+39 ,'15598','1','1657','1658','1','1','0','0','10148.6','2562.82','1321.67','3.25699','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+40 ,'15599','1','1377','3425','1','1','0','0','-6840.63','822.321','49.9208','6.06083','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+41 ,'15600','1','16','5306','1','1','0','0','3685.65','-6335.02','4.46639','3.24175','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+42 ,'15601','1','148','4659','1','1','0','0','7374.87','-308.501','4.9932','0.557559','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+43 ,'15602','0','28','198','1','1','0','0','2259.88','-2399.85','59.8106','2.40662','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+44 ,'15603','1','361','361','1','1','0','0','5200.21','-542.08','331.604','5.55349','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+45 ,'15604','1','400','5041','1','1','0','0','-6038.34','-3839.42','4.52127','3.11079','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+46 ,'15605','1','331','415','1','1','0','0','2793.95','-352.59','107.121','1.83151','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+47 ,'15606','1','618','2252','1','1','0','0','6423.91','-4294.87','666.743','5.56573','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+48 ,'15607','329','0','0','1','1','0','0','3703.6','-3450.27','130.831','6.13656','600','0','0','2930','2434','0','0','0','0','0','0'),
(@my_guid+49 ,'15864','1','493','2361','1','1','0','15864','7945.71','-2632.58','492.434','2.51211','300','0','0','3921','0','0','0','0','0','0','0'),
(@my_guid+50 ,'15871','0','1537','5344','1','1','0','0','-4664.62','-957.323','500.378','0.660044','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+51 ,'15891','1','1637','5170','1','65535','0','0','1495.01','-4397.87','24.4211','4.95962','300','0','0','3921','0','0','0','0','0','0','0'),
(@my_guid+52 ,'15891','0','1497','1497','1','65535','0','0','1617.03','236.383','-62.0788','2.75535','300','0','0','3921','0','0','0','0','0','0','0'),
(@my_guid+53 ,'15891','1','1638','5345','1','65535','0','0','-1244.96','82.1546','128.998','2.39295','300','0','0','3921','0','0','0','0','0','0','0'),
(@my_guid+54 ,'15892','1','1657','1657','1','1','0','0','9960.88','2509.89','1318.41','5.93127','300','0','0','3921','0','0','0','0','0','0','0'),
(@my_guid+55 ,'15892','0','12','12','1','1','0','0','-9119.66','322.59','93.3204','4.49361','300','0','0','3921','0','0','0','0','0','0','0'),
(@my_guid+56 ,'15892','0','1537','5719','1','1','0','0','-4919.63','-980.715','501.459','1.73603','300','0','0','3921','0','0','0','0','0','0','0'),
(@my_guid+57 ,'15895','0','1537','5719','1','1','0','0','-4924.57','-982.706','501.461','0.754278','300','0','0','2745','5013','0','0','0','0','0','0'),
(@my_guid+58 ,'15895','1','1657','1657','1','1','0','0','9967.14','2518.19','1318.48','4.22695','300','0','0','2745','5013','0','0','0','0','0','0'),
(@my_guid+59 ,'15895','0','12','12','1','1','0','0','-9120.36','345.895','94.1137','2.41545','300','0','0','2745','5013','0','0','0','0','0','0'),
(@my_guid+60 ,'15895','1','1637','1637','1','65535','0','0','1775.97','-4333.65','101.563','3.93076','300','0','0','2745','5013','0','0','0','0','0','0'),
(@my_guid+61 ,'15895','0','1497','1497','1','65535','0','0','1574.76','241.262','-62.078','0.0496511','300','0','0','2745','5013','0','0','0','0','0','0'),
(@my_guid+62 ,'15895','1','1638','5345','1','65535','0','0','-1275.65','110.103','129.761','5.32012','300','0','0','2745','5013','0','0','0','0','0','0'),
(@my_guid+63 ,'15898','1','1638','1639','1','65535','0','0','-1004.71','-263.624','159.305','3.32759','300','0','0','2745','5013','0','0','0','0','0','0'),
(@my_guid+64 ,'15898','0','1497','1497','1','65535','0','0','1606.09','239.888','-62.0777','0.00252189','300','0','0','2745','5013','0','0','0','0','0','0'),
(@my_guid+65 ,'15898','1','1637','1637','1','65535','0','0','1757.16','-4337.11','101.577','0.243314','300','0','0','2745','5013','0','0','0','0','0','0'),
(@my_guid+66 ,'15898','0','12','12','1','1','0','0','-9101.14','330.722','94.0197','6.04005','300','0','0','2745','5013','0','0','0','0','0','0'),
(@my_guid+67 ,'15898','0','1537','5719','1','1','0','0','-4914.68','-976.054','501.455','3.14189','300','0','0','2745','5013','0','0','0','0','0','0'),
(@my_guid+68 ,'15898','1','1657','1658','1','1','0','0','10138.9','2576.99','1322.94','4.67464','300','0','0','2745','5013','0','0','0','0','0','0'),
(@my_guid+69 ,'15898','1','493','2361','1','1','0','0','7935.29','-2637.33','492.689','1.41256','300','0','0','2745','5013','0','0','0','0','0','0'),
(@my_guid+70 ,'15909','1','493','656','1','1','0','0','7928.73','-2636.46','492.638','1.24762','300','0','0','5226','5751','0','0','0','0','0','0'),
(@my_guid+71 ,'30348','571','0','0','1','1','0','0','2377.03','5164.3','4.35338','1.15621','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+72 ,'30357','571','0','0','1','1','0','0','4569.61','-4291.44','174.174','1.41542','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+73 ,'30357','571','394','4159','1','1','0','0','4418.26','-4169.35','171.715','0.0181863','300','0','0','15120','17628','0','0','0','0','0','0'),
(@my_guid+74 ,'30358','571','0','0','1','1','0','0','3484.58','1963.3','64.861','3.01972','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+75 ,'30359','571','0','0','1','1','0','0','6705.19','-214.593','976.073','3.85017','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+76 ,'30360','571','0','0','1','1','0','0','3577.08','6622.38','195.505','0.96167','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+77 ,'30362','571','0','0','1','1','0','0','5437.03','4760.17','-198.617','1.28406','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+78 ,'30363','571','0','0','1','1','0','0','2649.97','891.349','4.38401','0.0517055','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+79 ,'30364','571','0','0','1','1','0','0','3217.16','5260.9','47.9395','1.89942','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+80 ,'30365','571','0','0','1','1','0','0','5863.64','4150.25','-93.9985','4.86312','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+81 ,'30367','571','0','0','1','1','0','0','4217.56','-5340.09','11.5247','1.21671','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+82 ,'30368','571','4197','4575','1','65535','0','0','5372.61','2886.31','409.239','3.45401','300','0','0','15120','17628','0','0','0','0','0','0'),
(@my_guid+83 ,'30369','571','0','0','1','1','0','0','5805.2','-3542.67','391.641','3.79204','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+84 ,'30370','571','0','0','1','1','0','0','6179.8','-1087.18','415.553','2.79773','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+85 ,'30371','571','0','0','1','1','0','0','2990.3','6096.12','141.675','5.69133','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+86 ,'30372','571','0','0','1','1','0','0','3873.39','-4482.22','222.352','4.62769','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+87 ,'30373','571','0','0','1','1','0','0','3769.64','1659.56','118.819','5.40648','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+88 ,'30374','571','0','0','1','1','0','0','7763.1','-2753.64','1164.62','0.329227','90','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+89 ,'30375','571','67','4502','1','1','0','0','8356.28','-538.894','982.005','4.2428','300','0','0','15120','17628','0','0','0','0','0','0'),
(@my_guid+90 ,'30531','574','0','0','1','1','0','0','169.619','73.3813','74.0251','3.27909','600','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+91 ,'30533','601','0','0','1','1','0','0','499.667','564.403','289.749','5.77096','600','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+92 ,'30534','600','0','0','1','1','0','0','-502.929','-635.642','30.2465','4.69041','600','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+93 ,'30535','599','0','0','1','1','0','0','947.419','752.651','202.751','0.685903','600','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+94 ,'30536','576','0','0','1','1','0','0','355.083','-212.745','-14.4552','1.74791','500','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+95 ,'30537','604','4416','4416','1','65535','0','0','1662.25','760.03','142.786','4.93581','300','0','0','15120','17628','0','0','0','0','0','0'),
(@my_guid+96 ,'30538','575','0','0','1','1','0','0','474.041','-523.128','104.725','1.7075','600','0','0','48','120','0','0','0','0','0','0'),
(@my_guid+97 ,'55210','1','5034','5606','1','65535','0','0','-10719.2','333.383','27.2565','5.96067','300','0','0','42','0','0','0','0','0','0','0'),
(@my_guid+98 ,'55211','1','5034','5455','1','65535','0','0','-8941.76','-1570.66','94.4544','3.1411','300','0','0','42','0','0','0','0','0','0','0'),
(@my_guid+99 ,'55216','646','5042','5330','1','65535','0','0','352.974','1546.22','351.71','2.71897','300','0','0','42','0','0','0','0','0','0','0'),
(@my_guid+100 ,'55217','646','5042','5303','1','65535','0','0','986.107','512.579','-49.3348','0.547347','300','0','0','42','0','0','0','0','0','0','0'),
(@my_guid+101 ,'55218','0','4922','5138','1','65535','0','0','-3634.84','-5385.87','38.0644','4.80695','300','0','0','42','0','0','0','0','0','0','0'),
(@my_guid+102 ,'55219','0','4922','5486','1','65535','0','0','-4675.17','-5061.84','134.781','5.65518','300','0','0','42','0','0','0','0','0','0','0'),
(@my_guid+103 ,'55224','1','0','0','1','1','39082','0','4438.98','-2062.39','1207.41','5.46288','120','0','0','1','1','0','0','0','0','0','0'),
(@my_guid+104 ,'55227','1','616','5038','1','65535','0','0','5563.01','-3561.79','1570.29','5.34245','300','0','0','116235','0','0','0','0','0','0','0'),
(@my_guid+105 ,'55228','0','5144','4966','1','65535','0','0','-7630.38','3917.48','-210.892','5.74019','300','0','0','42','0','0','0','0','0','0','0');
DELETE FROM game_event_creature WHERE game_event_creature.guid IN (
SELECT creature.guid
FROM creature WHERE creature.id IN (
'30364', '15567', '15871', '30375', '30357', '30538', '15574', '15583', '15566', '15562', '30370', '15580', '30359', '15595', '15560', '15565',
'30373', '15597', '15549', '15559', '15588', '30536', '30531', '30534', '15598', '30368', '15600', '30367', '30358', '30374', '15607', '15568',
'30360', '30533', '15561', '15584', '15586', '30537', '30371', '15556', '15557', '15570', '15569', '15596', '30362', '15575', '30348', '15564',
'15563', '30369', '30363', '15581', '15592', '15558', '15603', '30365', '30372', '30535', '15585', '15606', '15605', '15593', '15577', '15602',
'15578', '15594', '15599', '15587', '15604', '15579', '15601', '15573', '15582', '15572',
'55217', '55216', '55210', '55211', '55218', '55219', '55227', '55224', '55228',
'15892', '15891', '15895', '15898', '15909', '15864'));
INSERT INTO `game_event_creature` (eventEntry, guid)
SELECT @my_event_id , creature.guid
FROM creature
WHERE creature.id IN
('30364', '15567', '15871', '30375', '30357', '30538', '15574', '15583', '15566', '15562', '30370', '15580', '30359', '15595', '15560', '15565',
'30373', '15597', '15549', '15559', '15588', '30536', '30531', '30534', '15598', '30368', '15600', '30367', '30358', '30374', '15607', '15568',
'30360', '30533', '15561', '15584', '15586', '30537', '30371', '15556', '15557', '15570', '15569', '15596', '30362', '15575', '30348', '15564',
'15563', '30369', '30363', '15581', '15592', '15558', '15603', '30365', '30372', '30535', '15585', '15606', '15605', '15593', '15577', '15602',
'15578', '15594', '15599', '15587', '15604', '15579', '15601', '15573', '15582', '15572',
'55217', '55216', '55210', '55211', '55218', '55219', '55227', '55224', '55228',
'15892', '15891', '15895', '15898', '15909', '15864');
Last edited:
core
Verified Member
- 23
- 2015
- 0
- Location
- United States
Ooo very useful and modifiable thanks to you. k:
k: