V10 Halloween + LETC events

Titesusy

Veteran Member
134
2016
4
Location
France
It seems we have some issues with the halloween event and etc. I rewrote the scripts, i post them here :

Code:
-- Last Revision 2019.01.19 by Titesusy
-- Modificable setup STARTING HERE

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

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

-- NO MODIFY STARTING HERE

-- ETC EVENT
-- To note: The ETC sql is mainly made by event horizon

UPDATE `game_event` SET `start_time`='2014-09-19 20:00:00', `end_time`='2030-01-01 23:00:0',`occurence`='1440',`length`='5' WHERE (`eventEntry`='32');
UPDATE `smart_scripts` SET `link`='0' WHERE (`entryorguid`='23623') AND (`source_type`='0') AND (`id`='1') AND (`link`='2');
UPDATE `smart_scripts` SET `link`='0' WHERE (`entryorguid`='23624') AND (`source_type`='0') AND (`id`='1') AND (`link`='2');
UPDATE `smart_scripts` SET `link`='0' WHERE (`entryorguid`='23626') AND (`source_type`='0') AND (`id`='1') AND (`link`='2');
UPDATE `smart_scripts` SET `link`='0' WHERE (`entryorguid`='23619') AND (`source_type`='0') AND (`id`='1') AND (`link`='2');
UPDATE `smart_scripts` SET `link`='0' WHERE (`entryorguid`='23830') AND (`source_type`='0') AND (`id`='1') AND (`link`='2');
UPDATE `smart_scripts` SET `link`='0' WHERE (`entryorguid`='23625') AND (`source_type`='0') AND (`id`='1') AND (`link`='2');
UPDATE `smart_scripts` SET `event_flags`='0' WHERE (`entryorguid`='23830') AND (`source_type`='0') AND (`id`='0') AND (`link`='0');


UPDATE `smart_scripts` SET `event_param1`='3000', `event_param2`='3000', `event_flags`='0' WHERE (`entryorguid`='23624') AND (`source_type`='0') AND (`id`='0') AND (`link`='0');
UPDATE `smart_scripts` SET `event_param1`='3000', `event_param2`='3000', `event_flags`='0' WHERE (`entryorguid`='23623') AND (`source_type`='0') AND (`id`='0') AND (`link`='0');
UPDATE `smart_scripts` SET `event_param1`='3000', `event_param2`='3000', `event_flags`='0' WHERE (`entryorguid`='23619') AND (`source_type`='0') AND (`id`='1') AND (`link`='0');
UPDATE `smart_scripts` SET `event_param1`='3000', `event_param2`='3000', `event_flags`='0' WHERE (`entryorguid`='23626') AND (`source_type`='0') AND (`id`='0') AND (`link`='0');
UPDATE `smart_scripts` SET `event_flags`='0', `event_param1`='3000', `event_param2`='3000' WHERE (`entryorguid`='23625') AND (`source_type`='0') AND (`id`='0') AND (`link`='0');
UPDATE `smart_scripts` SET `event_flags`='1' WHERE (`entryorguid`='23625') AND (`source_type`='0') AND (`id`='1') AND (`link`='0');

UPDATE `smart_scripts` SET `event_flags`='1' WHERE (`entryorguid`='23624') AND (`source_type`='0') AND (`id`='1') AND (`link`='0'); // Bug fix on 23624 with flames...

-- HALLOWEEN EVENT

DELETE FROM game_event_gameobject_quest
WHERE ( id = '208120' AND quest =  '28954');

INSERT INTO `game_event_gameobject_quest` (`eventEntry`, `id`, `quest`) VALUES ('12', '208120', '28954');

DELETE FROM item_loot_template
WHERE (entry = '37586' AND ( item = '49212' OR item = '49210' OR item = '49216' OR item = '49215' ));

INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`) VALUES 
('37586', '49212', '6'), ('37586', '49210', '6'), ('37586', '49216', '6'), ('37586', '49215', '6');


-- Deleting the existings candy bucket in game_event_gameobject table to prevent any duplications...

DELETE FROM game_event_gameobject
WHERE game_event_gameobject.guid IN 
(SELECT gameobject.guid
FROM
gameobject
WHERE gameobject.id IN
(189303, 190034, 190035, 190036, 190037, 190038, 190039, 190110, 190111, 190112, 190113, 190114, 190115, 190116, 191878,
190040, 190041, 190043, 190044, 190045, 190046, 190047, 190048, 190051, 190052, 190053, 190054, 190055, 190056, 190057,
190058, 190059, 190060, 190061, 190062, 190063, 190064, 190065, 190066, 190067, 190068, 190069, 190070, 190071, 190072,
190073, 190074, 190075, 190076, 190078, 190079, 190080, 190082, 190083, 190084, 190085, 190086, 190088, 190089, 190090,
190091, 190096, 190097, 190098, 190099, 190100, 190101, 190102, 190103, 190104, 190105, 190106, 190107, 190108, 190109,
191879, 191880, 191881, 191882, 191883, 192018, 194056, 194057, 194058, 194059, 194060, 194061, 194062, 194063, 194064,
194065, 194066, 194067, 194068, 194069, 194070, 194071, 194072, 194073, 194074, 194075, 194076, 194077, 194078, 194079,
194080, 194081, 194084, 194119, 208115, 208116, 208117, 208118, 208119, 208120, 208121, 208122, 208123, 208124, 208125,
208126, 208127, 208128, 208129, 208130, 208131, 208132, 208133, 208134, 208135, 208136, 208137, 208138, 208139, 208140,
208141, 208142, 208143, 208144, 208145, 208146, 208147, 208148, 208149, 208150, 208151, 208153, 208154, 208155, 208156,
208157, 208158, 208159, 208160, 208161, 208162, 208163, 208164, 208165, 208166, 208167, 208168,  208169, 208170, 208171,
208172, 208173, 208174, 208175, 208176, 208177, 208178, 208179, 208180, 208181, 208183));


-- Deleting the Candy Bucket already existing....
DELETE FROM gameobject
WHERE gameobject.id IN
(189303, 190034, 190035, 190036, 190037, 190038, 190039, 190110, 190111, 190112, 190113, 190114, 190115, 190116, 191878,
190040, 190041, 190043, 190044, 190045, 190046, 190047, 190048, 190051, 190052, 190053, 190054, 190055, 190056, 190057,
190058, 190059, 190060, 190061, 190062, 190063, 190064, 190065, 190066, 190067, 190068, 190069, 190070, 190071, 190072,
190073, 190074, 190075, 190076, 190078, 190079, 190080, 190082, 190083, 190084, 190085, 190086, 190088, 190089, 190090,
190091, 190096, 190097, 190098, 190099, 190100, 190101, 190102, 190103, 190104, 190105, 190106, 190107, 190108, 190109,
191879, 191880, 191881, 191882, 191883, 192018, 194056, 194057, 194058, 194059, 194060, 194061, 194062, 194063, 194064,
194065, 194066, 194067, 194068, 194069, 194070, 194071, 194072, 194073, 194074, 194075, 194076, 194077, 194078, 194079,
194080, 194081, 194084, 194119, 208115, 208116, 208117, 208118, 208119, 208120, 208121, 208122, 208123, 208124, 208125,
208126, 208127, 208128, 208129, 208130, 208131, 208132, 208133, 208134, 208135, 208136, 208137, 208138, 208139, 208140,
208141, 208142, 208143, 208144, 208145, 208146, 208147, 208148, 208149, 208150, 208151, 208153, 208154, 208155, 208156,
208157, 208158, 208159, 208160, 208161, 208162, 208163, 208164, 208165, 208166, 208167, 208168,  208169, 208170, 208171,
208172, 208173, 208174, 208175, 208176, 208177, 208178, 208179, 208180, 208181, 208183);


-- Insertion into GAMEOBJECT Table

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,'189303','0','12','5637','1','1','-9461.68','8.80097','56.9611','2.11384','0','0','0.870845','0.491558','300','0','1'), 
(@my_id+1,'190034','1','141','186','1','1','9800,1','978.942','1313.89','2.16588','0','0','0.883341','0.468731','300','0','1'), 
(@my_id+2,'190035','1','331','415','1','1','2776.89','-435.128','116.58','2.82031','0','0','0.987125','0.159949','300','0','1'), 
(@my_id+3,'190036','0','1','2102','1','1','-5602,13','-534.463','399.652','1.23702','0','0','0.579821','0.814744','300','0','1'), 
(@my_id+4,'190037','530','0','0','1','1','-4125.09','-12473.8','44.5691','-1.74533','0','0','0','1','120','255','1'), 
(@my_id+5,'190038','1','1657','1657','1','1','10141.1','2216.58','1329.98','3.41406','0','0','0.990735','-0.135811','300','0','1'), 
(@my_id+6,'190039','0','1537','5719','1','1','-4843.97','-857.06','501.914','3.42435','0','0','0.990022','-0.14091','300','0','1'), 
(@my_id+7,'190040','0','1519','5148','1','3969','-8865.38','671.861','97.9034','1.68581','0','0','0.746579','0.665296','300','0','1'), 
(@my_id+8,'190041','530','0','0','1','1','-3739.82','-11692.4','-105.786','-1.88495','0','0','0','1','120','255','1'), 
(@my_id+9,'190043','0','38','2101','1','1','-5394.05','-2956.98','322.058','0.109974','0','0','0.0549595','0.998489','300','0','1'), 
(@my_id+10,'190044','0','11','2104','1','1','-3830.39','-837.781','0.648706','1.28413','0','0','0.598852','0.80086','300','0','1'), 
(@my_id+11,'190045','530','0','0','1','1','-2062.63','-11892','46.1438','1.15192','0','0','0','1','120','255','1'), 
(@my_id+12,'190046','0','44','69','1','1','-9217.57','-2151.45','64.3542','1.94497','0','0','0.826288','0.563248','300','0','1'), 
(@my_id+13,'190047','0','40','108','1','1','-10655.4','1168.12','34.5006','4.04752','0','0','0.899154','-0.437632','300','0','1'), 
(@my_id+14,'190048','0','10','42','1','1','-10513.7','-1159.53','28.1006','2.31967','0','0','0.916737','0.399491','300','0','1'), 
(@my_id+15,'190051','1','405','608','1','1','250.002','1253.36','192.156','1.57927','0','0','0.710096','0.704104','300','0','1'), 
(@my_id+16,'190052','1','15','513','1','1','-3618.13','-4469.11','14.2448','0.675423','0','0','0.331329','0.943515','300','0','1'), 
(@my_id+17,'190053','1','357','5072','1','1','-4458.88','2224.63','27.6739','2.34895','0','0','0.922487','0.386027','300','0','1'), 
(@my_id+18,'190054','0','47','349','1','1','324.091','-2116.39','121.839','4.96369','0','0','0.612916','-0.790148','300','0','1'), 
(@my_id+19,'190055','530','0','0','1','1','-711.659','2737.82','95.8952','-0.104719','0','0','0','1','120','255','1'), 
(@my_id+20,'190056','530','0','0','1','1','228.606','4330.16','119.241','-1.51844','0','0','0.688354','-0.725374','120','100','1'), 
(@my_id+21,'190057','530','0','0','1','1','294.863','6098.85','132.057','0.733038','0','0','0','1','120','255','1'), 
(@my_id+22,'190058','530','0','0','1','1','1058.27','7368.56','39.5833','-0.558505','0','0','0.275637','-0.961262','120','100','1'), 
(@my_id+23,'190059','530','0','0','1','1','-2916.02','4027.2','0.407846','2,11185','0','0','0','1','120','255','1'), 
(@my_id+24,'190060','530','0','0','1','1','-2753.11','7301.62','43.4717','2.51327','0','0','0.951057','0.309017','120','100','1'), 
(@my_id+25,'190061','530','0','0','1','1','2103.43','6901.82','183.23','-1.81514','0','0','0','1','120','255','1'), 
(@my_id+26,'190062','530','0','0','1','1','1946.05','5533.66','266.482','-3.07177','0','0','0','1','120','255','1'), 
(@my_id+27,'190063','530','0','0','1','1','-4085.19','2189.32','107.502','0.994837','0','0','0','1','120','255','1'), 
(@my_id+28,'190064','1','14','362','1','65535','332.472','-4681.36','16.4894','1.69626','0','0','0.750045','0.661387','0','0','1'), 
(@my_id+29,'190065','1','215','222','1','1','-2372.41','-344.605','-8.95603','5.96101','0','0','0.160392','-0.987053','300','0','1'), 
(@my_id+30,'190066','0','85','159','1','1','2288.21','285.632','33.2433','6.19068','0','0','0.0462354','-0.998931','300','0','1'), 
(@my_id+31,'190067','530','0','0','1','1','9469.68','-6861.26','17.4359','2.67035','0','0','0.97237','0.233445','120','100','1'), 
(@my_id+32,'190068','530','0','0','1','1','8709.6','-6637.39','72.7446','4.13877','0','0','0.878258','-0.478188','120','0','1'), 
(@my_id+33,'190069','1','1637','5170','1','3969','1578.5','-4454.33','15.6547','2.20681','0','0','0.892747','0.450559','300','0','1'), 
(@my_id+34,'190070','1','1638','5345','1','1','-1307.18','34.0591','129.21','0.36898','0','0','0.183445','0.98303','300','0','1'), 
(@my_id+35,'190071','0','1497','1497','1','1','1642.24','219.521','-43.103','2.65717','0','0','0.970809','0.239852','300','0','1'), 
(@my_id+36,'190072','530','0','0','1','1','9688.54','-7362.99','11.9295','-0.349066','0','0','0.173648','-0.984808','120','100','1'), 
(@my_id+37,'190073','530','0','0','1','1','9565.64','-7219.54','16.2122','-1.18682','0','0','0.559193','-0.829037','120','100','1'), 
(@my_id+38,'190074','0','130','228','1','1','475.378','1497.37','135.522','2.47967','0','0','0.94573','0.324953','300','0','1'), 
(@my_id+39,'190075','530','0','0','1','1','7552.82','-6888.99','96.027','2.33628','0','0','0.920024','0.391863','120','0','1'), 
(@my_id+40,'190076','1','17','380','1','1','-404.09','-2652.74','96.2232','2.67411','0','0','0.972806','0.23162','300','0','1'), 
(@my_id+41,'190078','0','267','272','1','1','-47.4233','-970.667','53.452','1.56466','0','0','0.704935','0.709272','300','0','1'), 
(@my_id+42,'190079','1','331','431','1','1','2347.03','-2565.69','103.093','2.75664','0','0','0.981534','0.191289','300','0','1'), 
(@my_id+43,'190080','1','406','460','1','1','888.176','930.471','106.258','5.91783','0','0','0.181665','-0.983361','300','0','1'), 
(@my_id+44,'190082','0','45','321','1','1','-911.715','-3530.85','72.564','2.23236','0','0','0.898429','0.439118','300','0','1'), 
(@my_id+45,'190083','1','405','2408','1','1','-1588.18','3155.43','46.9582','4.00537','0','0','0.908177','-0.418586','300','0','1'), 
(@my_id+46,'190084','0','33','117','1','1','-12439.2','209.406','2.36542','0.932474','0','0','0.449528','0.893266','300','0','1'), 
(@my_id+47,'190085','1','15','496','1','1','-3189.45','-2925.4','33.3289','0.671355','0','0','0.329409','0.944187','300','0','1'), 
(@my_id+48,'190086','0','8','75','1','1','-10490.6','-3251.6','21.1411','4.88303','0','0','0.644277','-0.764792','300','0','1'), 
(@my_id+49,'190088','1','357','5726','1','1','-4467.4','239.468','39.1084','0.463243','0','0','0.229556','0.973296','300','0','1'), 
(@my_id+50,'190089','0','47','3317','1','1','-628.538','-4582.07','11.6874','5.15011','0','0','0.536715','-0.843763','300','0','1'), 
(@my_id+51,'190090','530','0','0','1','1','191.673','2605.61','87.2835','-2.28638','0','0','0.909961','-0.414693','120','100','1'), 
(@my_id+52,'190091','530','0','0','1','1','-566.872','4150.64','68.0928','-1.15192','0','0','0.544639','-0.838671','120','100','1'), 
(@my_id+53,'190096','530','0','0','1','1','230.295','7935.66','25.0778','0.680678','0','0','0.333807','0.942641','120','100','1'), 
(@my_id+54,'190097','530','0','0','1','1','-2626.18','4451.71','36.0935','0.314159','0','0','0.156434','0.987688','120','100','1'), 
(@my_id+55,'190098','530','0','0','1','1','-1228.37','7164.28','57.2651','-2.51327','0','0','0.951057','-0.309017','120','100','1'), 
(@my_id+56,'190099','530','0','0','1','1','2397.13','5944.2','152.071','1.06132','0','0','0.506103','0.862473','120','0','1'), 
(@my_id+57,'190100','530','0','0','1','1','2224.21','4710.98','161.946','-2.79252','0','0','0','1','120','255','1'), 
(@my_id+58,'190101','530','0','0','1','1','-2963.83','2559.04','78.1715','-1.69297','0','0','0.748956','-0.66262','120','100','1'), 
(@my_id+59,'190102','1','17','392','1','1','-1056.04','-3667.58','23.8813','0.561381','0','0','0.277019','0.960864','300','0','1'), 
(@my_id+60,'190103','0','5287','35','1','1','-14456.1','492.736','15.1257','3.324','0','0','0.995844','-0.0910794','300','0','1'), 
(@my_id+61,'190104','1','15','4010','1','1','-4629.22','-3169.27','41.2189','5.08924','0','0','0.562143','-0.82704','300','0','1'), 
(@my_id+62,'190105','1','440','976','1','1','-7069.97','-3852.15','9.9129','3.59305','0','0','0.974632','-0.223814','300','0','1'), 
(@my_id+63,'190106','1','618','2255','1','1','6690.62','-4675.78','721.714','5.76473','0','0','0.256334','-0.966588','300','0','1'), 
(@my_id+64,'190107','1','1377','3425','1','1','-6867.41','724.407','45.6626','1.81019','0','0','0.786483','0.617612','300','0','1'), 
(@my_id+65,'190108','0','139','2268','1','1','2299','-5343','90.7534','1.35666','0','0','0.627495','0.77862','300','0','1'), 
(@my_id+66,'190109','530','0','0','1','1','-169.249','5518.45','29.4082','2.93428','0','0','0.994632','0.103471','120','0','1'), 
(@my_id+67,'190110','530','0','0','1','1','-1901.48','5766.43','131.212','1.79769','0','0','0','1','120','255','1'), 
(@my_id+68,'190111','530','0','0','1','1','-2187.64','5399.79','51.8825','2.63545','0','0','0.968148','0.25038','120','100','1'), 
(@my_id+69,'190112','530','0','0','1','1','3022.12','5433.25','146.617','-2.72271','0','0','0','1','120','255','1'), 
(@my_id+70,'190113','530','0','0','1','1','3061.03','3698.17','142.33','-0.122173','0','0','0','1','120','255','1'), 
(@my_id+71,'190114','530','0','0','1','1','4114.65','3068.59','339.465','0.645772','0','0','0.317305','0.948324','120','100','1'), 
(@my_id+72,'190115','530','0','0','1','1','-2980.84','870.225','-7.47893','0.069813','0','0','0.034899','0.999391','120','100','1'), 
(@my_id+73,'190116','530','0','0','1','1','-4141.28','1124.8','44.5249','1.50098','0','0','0','1','120','255','1'), 
(@my_id+74,'191878','571','0','0','1','1','5764.23','-3562.13','387.181','0.429754','0','0','0.213227','0.977003','120','0','1'), 
(@my_id+75,'191879','571','0','0','1','1','5470.01','-2638.2','307.051','4.98113','0','0','0.606002','-0.795463','120','0','1'), 
(@my_id+76,'191880','571','0','0','1','1','3252','-2208.6','117.374','3.20612','0','0','0.99948','-0.0322598','120','0','1'), 
(@my_id+77,'191881','571','0','0','1','1','3871.49','-4542.2','209.266','1.94398','0','0','0.82601','0.563656','120','0','1'), 
(@my_id+78,'191882','571','0','0','1','1','3409.12','-2789.01','201.52','4.57114','0','0','0.755241','-0.655448','120','0','1'), 
(@my_id+79,'191883','571','0','0','1','1','4592.64','-4240.23','178.728','0.0527409','0','0','0.0263674','0.999652','120','0','1'), 
(@my_id+80,'192018','571','0','0','1','1','5568.46','5770.29','-75.2011','3.42663','0','0','0.989861','-0.142039','120','0','1'), 
(@my_id+81,'194056','571','0','0','1','1','585.526','-4923.32','18.6751','4.31614','0','0','0.832454','-0.554094','120','0','1'), 
(@my_id+82,'194057','571','0','0','1','1','1446.16','-3261.3','167.303','0.546185','0','0','0.269711','0.962941','120','0','1'), 
(@my_id+83,'194058','571','0','0','1','1','2475.8','-5054.51','284.391','3.84818','0','0','0.938238','-0.345992','120','0','1'), 
(@my_id+84,'194059','571','0','0','1','1','2289.64','5197.55','11.703','5.64376','0','0','0.314292','-0.949326','120','0','1'), 
(@my_id+85,'194060','571','0','0','1','1','4174.85','5278.33','26.6931','5.60564','0','0','0.332328','-0.943164','120','0','1'), 
(@my_id+86,'194061','571','0','0','1','1','3474.77','2002.38','64.8625','4.93995','0','0','0.622255','-0.782815','120','0','1'), 
(@my_id+87,'194062','571','0','0','1','1','3648.29','-720.879','215.033','5.78524','0','0','0.246407','-0.969166','120','0','1'), 
(@my_id+88,'194063','571','0','0','1','1','6674.62','-205.505','950.089','1.27084','0','0','0.593517','0.804821','120','0','1'), 
(@my_id+89,'194064','571','0','0','1','1','5717.42','700.954','645.751','-0.733038','0','0','0','1','120','255','1'), 
(@my_id+90,'194065','571','0','0','1','1','703.564','-2939.04','-3.06821','2.58839','0','0','0.961989','0.273087','120','0','1'), 
(@my_id+91,'194066','571','0','0','1','1','3573.57','254.726','47.288','0.748473','0','0','0.365562','0.930787','120','0','1'), 
(@my_id+92,'194067','571','0','0','1','1','2781.92','930.436','22.5388','2.82408','0','0','0.987425','0.158089','120','0','1'), 
(@my_id+93,'194068','571','0','0','1','1','3008.25','4048.31','26.6159','0.0222444','0','0','0.011122','0.999938','120','0','1'), 
(@my_id+94,'194069','571','0','0','1','1','6127.09','-1078.27','403.96','1.45541','0','0','0.665158','0.746703','120','0','1'), 
(@my_id+95,'194070','571','0','0','1','1','8435.04','-359.272','906.402','0.391197','0','0','0.194354','0.980932','120','0','1'), 
(@my_id+96,'194071','571','0','0','1','1','5838.1','652.884','647.512','1.25664','0','0','0','1','120','255','1'), 
(@my_id+97,'194072','571','0','0','1','1','5751.58','700.566','618.537','-2.35619','0','0','0','1','120','255','1'), 
(@my_id+98,'194073','571','0','0','1','1','2683.51','-4386.89','284.43','1.61764','0','0','0.723474','0.690351','120','0','1'), 
(@my_id+99,'194074','571','0','0','1','1','451.108','-4547.86','244.869','1.18394','0','0','0.557996','0.829844','120','0','1'), 
(@my_id+100,'194075','571','0','0','1','1','1877.37','-6221.42','13.0987','0.530647','0','0','0.262221','0.965008','120','0','1'), 
(@my_id+101,'194076','571','0','0','1','1','3471.5','4175.09','17.193','5.69911','0','0','0.287906','-0.957659','120','0','1'), 
(@my_id+102,'194077','571','0','0','1','1','2814.43','6156.97','85.3594','1.80361','0','0','0.784448','0.620194','120','0','1'), 
(@my_id+103,'194078','571','0','0','1','1','3837.51','1505.4','92.0613','6.19914','0','0','0.0420117','-0.999117','120','0','1'), 
(@my_id+104,'194079','571','0','0','1','1','3217.49','-680.655','167.536','1.82428','0','0','0.790815','0.612055','120','0','1'), 
(@my_id+105,'194080','571','0','0','1','1','7799.18','-2970.92','1259','0.118661','0','0','0.0592958','0.99824','120','0','1'), 
(@my_id+106,'194081','571','0','0','1','1','5902.78','497.684','641.57','-1.3439','0','0','0','1','120','255','1'), 
(@my_id+107,'194084','571','0','0','1','1','4506.17','5710.09','81.5123','4.77926','0','0','0.683074','-0.730349','120','0','1'), 
(@my_id+108,'194119','571','0','0','1','1','7849.99','-796.047','1184.33','5.04076','0','0','0.582022','-0.813173','120','0','1'), 
(@my_id+109,'208115','1','148','4659','1','1','7426.67','-277.372','7.6512','1.21963','0','0','0.572716','0.819754','300','0','1'), 
(@my_id+110,'208116','1','357','5024','1','1','-3190.95','1894.88','49.2062','4.23391','0','0','0.854527','-0.519407','300','0','1'), 
(@my_id+111,'208117','1','331','420','1','1','2092.65','-1216.74','101.793','1.71204','0','0','0.755241','0.655447','300','0','1'), 
(@my_id+112,'208118','1','331','4691','1','1','3049.11','-521.13','205.64','4.46487','0','0','0.788988','-0.614409','300','0','1'), 
(@my_id+113,'208119','1','331','2897','1','1','3356.83','950.38','7.40418','0.490758','0','0','0.242924','0.970045','300','0','1'), 
(@my_id+114,'208120','0','45','320','1','1','-1286.91','-2519.33','21.5821','0.569397','0','0','0.280868','0.959746','300','0','1'), 
(@my_id+115,'208121','0','3','5564','1','1','-7010.83','-2531.55','241.714','3.02055','0','0','0.998169','0.0604862','300','0','1'), 
(@my_id+116,'208122','0','4','1438','1','1','-10919.9','-3399.24','66.4989','1.06531','0','0','0.507821','0.861462','300','0','1'), 
(@my_id+117,'208123','0','4','5084','1','1','-12727.9','-2815.4','7.54315','6.09578','0','0','0.0935637','-0.995613','300','0','1'), 
(@my_id+118,'208124','0','38','147','1','1','-5673.73','-4258.01','407.016','3.0991','0','0','0.999774','0.021244','300','0','1'), 
(@my_id+119,'208125','0','33','5320','1','1','-12852.8','-434.131','12.9659','4.81166','0','0','0.671155','-0.741317','300','0','1'), 
(@my_id+120,'208126','0','8','657','1','1','-10072.8','-2805.44','24.0628','3.76709','0','0','0.951492','-0.307673','300','0','1'), 
(@my_id+121,'208127','0','47','5323','1','1','330.079','-4116.33','117.21','4.40604','0','0','0.806715','-0.59094','300','0','1'), 
(@my_id+122,'208128','0','4922','5141','1','1','-4203.4','-5621.16','23.4887','0.172221','0','0','0.0860041','0.996295','300','0','1'), 
(@my_id+123,'208129','0','4922','5140','1','1','-4888.25','-6599.87','10.8319','4.45268','0','0','0.792715','-0.609592','300','0','1'), 
(@my_id+124,'208130','0','4922','5142','1','1','-3159.02','-5067.76','109.918','3.13319','0','0','0.999991','0.00420219','300','0','1'), 
(@my_id+125,'208131','0','4922','5470','1','1','-4172.09','-4741.23','126.791','0.0229919','0','0','0.0114957','0.999934','300','0','1'), 
(@my_id+126,'208132','0','5145','4976','1','1','-6880.01','5973.78','-764.671','4.58784','0','0','0.749741','-0.661731','300','0','1'), 
(@my_id+127,'208133','0','5144','4969','1','1','-6604.07','4288.71','-563.008','1.40306','0','0','0.645387','0.763856','300','0','1'), 
(@my_id+128,'208134','0','28','3197','1','1','969.186','-1427.86','65.005','4.2097','0','0','0.860749','-0.509029','300','0','1'), 
(@my_id+129,'208135','0','11','5305','1','1','-3234.14','-2796.21','21.1282','4.89695','0','0','0.638937','-0.769259','300','0','1'), 
(@my_id+130,'208136','0','11','1024','1','1','-2856.57','-1449.81','8.60624','0.922837','0','0','0.445219','0.895422','300','0','1'), 
(@my_id+131,'208137','0','3','5496','1','1','-6585.51','-3928.06','379.79','1.99275','0','0','0.839507','0.543348','300','0','1'), 
(@my_id+132,'208138','0','51','5628','1','1','-7088.99','-1191.2','323.962','5.54672','0','0','0.359965','-0.932966','300','0','1'), 
(@my_id+133,'208139','0','8','5458','1','1','-9768.36','-3887.67','21.8826','1.54902','0','0','0.699366','0.714764','300','0','1'), 
(@my_id+134,'208140','1','16','4821','1','1','3534.11','-6523.63','43.4713','2.40323','0','0','0.932622','0.360854','300','0','1'), 
(@my_id+135,'208141','0','4815','5058','1','1','-5132.08','3276.45','-118.242','2.21303','0','0','0.894143','0.447781','300','0','1'), 
(@my_id+136,'208142','0','5144','4961','1','1','-6067.91','4305.83','-154.499','2.00883','0','0','0.843848','0.536582','300','0','1'), 
(@my_id+137,'208143','0','3','5565','1','1','-6734.28','-2465.13','274.577','0.834307','0','0','0.40516','0.914246','300','0','1'), 
(@my_id+138,'208144','0','4','1437','1','1','-10864.5','-2671.17','9.80814','5.74304','0','0','0.266799','-0.963752','300','0','1'), 
(@my_id+139,'208145','0','267','5603','1','1','-606.909','-1046.27','65.8228','3.57138','0','0','0.976999','-0.213244','300','0','1'), 
(@my_id+140,'208146','0','130','5386','1','1','1095.19','1587.97','28.5289','5.81368','0','0','0.2326','-0.972573','300','0','1'), 
(@my_id+141,'208147','0','5287','1739','1','1','-13233.9','726.382','3.35755','5.02832','0','0','0.58707','-0.809536','300','0','1'), 
(@my_id+142,'208148','0','47','1885','1','1','-17.1946','-2796.74','122.307','2.78994','0','0','0.984582','0.174923','300','0','1'), 
(@my_id+143,'208149','0','85','152','1','1','1665.64','-727.467','58.8145','1.00313','0','0','0.480798','0.876831','300','0','1'), 
(@my_id+144,'208150','0','4922','5138','1','1','-3662.26','-5255.57','42.1434','0.811833','0','0','0.394861','0.918741','300','0','1'), 
(@my_id+145,'208151','0','4922','5471','1','1','-4855.41','-4813','196.599','3.28588','0','0','0.997399','-0.0720822','300','0','1'), 
(@my_id+146,'208153','0','4922','5137','1','1','-2729.59','-6409.85','241.784','2.33943','0','0','0.920639','0.390415','300','0','1'), 
(@my_id+147,'208154','0','5144','4970','1','65535','-6779.89','4182.87','-480.013','2.05987','0','0','0.857267','0.514873','300','0','1'), 
(@my_id+148,'208155','0','5145','4975','1','1','-6542.16','6113.42','-670.804','0.575463','0','0','0.283778','0.95889','300','0','1'), 
(@my_id+149,'208156','0','28','193','1','1','1532.85','-1659.15','67.9158','5.97469','0','0','0.153637','-0.988127','300','0','1'), 
(@my_id+150,'208157','1','405','4805','1','1','-1049.17','1685.87','60.1387','5.29736','0','0','0.473195','-0.880958','300','0','1'), 
(@my_id+151,'208158','1','361','5645','1','1','6062.72','-929.556','414.772','3.25145','0','0','0.998492','-0.0549025','300','0','1'), 
(@my_id+152,'208159','1','361','1998','1','1','6154.85','-1958.71','568.057','1.79931','0','0','0.783113','0.62188','300','0','1'), 
(@my_id+153,'208160','1','357','5002','1','1','-3103.38','2559.41','50.1782','0.471099','0','0','0.233377','0.972386','300','0','1'), 
(@my_id+154,'208161','1','357','5003','1','1','-4545.84','1835.83','87.2097','3.26711','0','0','0.998031','-0.0627165','300','0','1'), 
(@my_id+155,'208162','1','616','5730','1','1','5511.49','-3602.78','1570.05','3.96105','0','0','0.917228','-0.398362','300','0','1'), 
(@my_id+156,'208163','1','616','4989','1','1','5147.1','-1726.12','1336.43','0.949056','0','0','0.456919','0.889509','300','0','1'), 
(@my_id+157,'208164','1','616','4990','1','1','4907.48','-2738.3','1437.61','2.69655','0','0','0.975345','0.220687','300','0','1'), 
(@my_id+158,'208165','1','17','1704','1','1','278.118','-3025.55','97.3072','4.65724','0','0','0.726332','-0.687344','300','0','1'), 
(@my_id+159,'208166','1','17','5117','1','1','1173.56','-3388.58','91.9077','5.18739','0','0','0.520892','-0.853622','300','0','1'), 
(@my_id+160,'208167','1','4709','4844','1','1','-785.757','-1546.16','140.392','4.48446','0','0','0.782932','-0.622107','300','0','1'), 
(@my_id+161,'208168','1','4709','4853','1','1','-3220.41','-1656.47','99.9099','4.78684','0','0','0.680302','-0.732932','300','0','1'), 
(@my_id+162,'208169','1','4709','4843','1','1','-347.61','-1541.89','87.2653','1.13769','0','0','0.538661','0.842523','300','0','1'), 
(@my_id+163,'208170','1','4709','4847','1','1','-2091.97','-3501.99','94.9959','4.47567','0','0','0.785657','-0.618662','300','0','1'), 
(@my_id+164,'208171','1','4709','4854','1','1','-3187.76','-2279.93','93.2809','0.132393','0','0','0.066148','0.99781','300','0','1'), 
(@my_id+165,'208172','1','406','4933','1','1','877.655','-24.4567','92.6759','1.37825','0','0','0.635862','0.771803','300','0','1'), 
(@my_id+166,'208173','1','406','5093','1','1','294.139','-284.014','92.0756','5.47087','0','0','0.395084','-0.918645','300','0','1'), 
(@my_id+167,'208174','1','406','5073','1','1','1181.66','424.222','80.5248','2.98904','0','0','0.997092','0.0762031','300','0','1'), 
(@my_id+168,'208175','1','406','4937','1','1','2110.63','1571.39','343.374','0.770291','0','0','0.375694','0.926744','300','0','1'), 
(@my_id+169,'208176','1','406','4939','1','1','1019.85','2045.45','129.985','4.62661','0','0','0.736773','-0.67614','300','0','1'), 
(@my_id+170,'208177','1','440','5062','1','1','-8700.46','-4070.79','40.4314','3.34172','0','0','0.994998','-0.0998986','300','0','1'), 
(@my_id+171,'208178','1','5034','5670','1','1','-8334.63','799.581','151.869','5.48474','0','0','0.3887','-0.921364','300','0','1'), 
(@my_id+172,'208179','1','5034','5466','1','1','-9415.63','-910.417','112.541','2.70443','0','0','0.976206','0.216846','300','0','1'), 
(@my_id+173,'208180','1','490','4882','1','1','-7500.02','-1509.7','-266.145','4.71223','0','0','0.707161','-0.707052','300','0','1'), 
(@my_id+174,'208181','646','5042','5395','1','1','1082.28','436.665','-45.3152','5.81853','0','0','0.230242','-0.973134','300','0','1'), 
(@my_id+175,'208183','646','5042','5303','1','1','999.11','517.296','-49.334','0.324651','0','0','0.161614','0.986854','300','0','1');


 



UPDATE `quest_template` SET `RequiredRaces`='0' WHERE 
(`Id`='12403') OR (`Id`='12406') OR (`Id`='12407') OR 
(`Id`='12408') OR (`Id`='12397') OR (`Id`='12400') OR
(`Id`='12401') OR (`Id`='12399') OR (`Id`='12398') OR (`Id`='12396');


-- Links between candy buckets and quests 
DELETE FROM gameobject_questrelation
WHERE id IN
(189303, 190034, 190035, 190036, 190037, 190038, 190039, 190110, 190111, 190112, 190113, 190114, 190115, 190116, 191878,
190040, 190041, 190043, 190044, 190045, 190046, 190047, 190048, 190051, 190052, 190053, 190054, 190055, 190056, 190057,
190058, 190059, 190060, 190061, 190062, 190063, 190064, 190065, 190066, 190067, 190068, 190069, 190070, 190071, 190072,
190073, 190074, 190075, 190076, 190078, 190079, 190080, 190082, 190083, 190084, 190085, 190086, 190088, 190089, 190090,
190091, 190096, 190097, 190098, 190099, 190100, 190101, 190102, 190103, 190104, 190105, 190106, 190107, 190108, 190109,
191879, 191880, 191881, 191882, 191883, 192018, 194056, 194057, 194058, 194059, 194060, 194061, 194062, 194063, 194064,
194065, 194066, 194067, 194068, 194069, 194070, 194071, 194072, 194073, 194074, 194075, 194076, 194077, 194078, 194079,
194080, 194081, 194084, 194119, 208115, 208116, 208117, 208118, 208119, 208120, 208121, 208122, 208123, 208124, 208125,
208126, 208127, 208128, 208129, 208130, 208131, 208132, 208133, 208134, 208135, 208136, 208137, 208138, 208139, 208140,
208141, 208142, 208143, 208144, 208145, 208146, 208147, 208148, 208149, 208150, 208151, 208153, 208154, 208155, 208156,
208157, 208158, 208159, 208160, 208161, 208162, 208163, 208164, 208165, 208166, 208167, 208168,  208169, 208170, 208171,
208172, 208173, 208174, 208175, 208176, 208177, 208178, 208179, 208180, 208181, 208183);

INSERT INTO `gameobject_questrelation` (`id`, `quest`) VALUES 
('189303','12286'), ('190034','12331'), ('190035','12345'), ('190036','12332'), ('190037','12333'), ('190038','12334'), ('190039','12335'), ('190040','12336'),
('190041','12337'), ('190043','12339'), ('190044','12343'), ('190045','12341'), ('190046','12342'), ('190047','12340'), ('190048','12344'),
('190051','12348'), ('190052','12349'), ('190053','12350'), ('190054','12351'), ('190055','12352'), ('190056','12353'), ('190057','12354'),
('190058','12355'), ('190059','12356'), ('190060','12357'), ('190061','12358'), ('190062','12359'), ('190063','12360'), ('190064','12361'),
('190065','12362'), ('190066','12363'), ('190067','12364'), ('190068','12365'), ('190069','12366'), ('190070','12367'), ('190071','12368'),
('190072','12369'), ('190073','12370'), ('190074','12371'), ('190075','12373'), ('190076','12374'), ('190078','12376'), ('190079','12377'),
('190080','12378'), ('190082','12380'), ('190083','12381'), ('190084','12382'), ('190085','12383'), ('190086','12384'), ('190088','12386'),
('190089','12387'), ('190090','12388'), ('190091','12389'), ('190096','12390'), ('190097','12391'), ('190098','12392'), ('190099','12393'),
('190100','12394'), ('190101','12395'), ('190102','12396'), ('190103','12397'), ('190104','12398'), ('190105','12399'), ('190106','12400'),
('190107','12401'), ('190108','12402'), ('190109','12403'), ('190110','12404'), ('190111','12404'), ('190112','12406'), ('190113','12407'),
('190114','12408'), ('190115','12409'), ('190116','12409'), ('191878','12940'), ('191879','12941'), ('191880','12946'), ('191881','12947'),
('191882','12944'), ('191883','12945'), ('192018','12950'), ('194056','13433'), ('194057','13434'), ('194058','13435'), ('194059','13436'),
('194060','13437'), ('194061','13438'), ('194062','13439'), ('194063','13448'), ('194064','13473'), ('194065','13452'), ('194066','13456'),
('194067','13459'), ('194068','13460'), ('194069','13461'), ('194070','13462'), ('194071','13463'), ('194072','13472'), ('194073','13464'),
('194074','13465'), ('194075','13466'), ('194076','13467'), ('194077','13468'), ('194078','13469'), ('194079','13470'), ('194080','13471'),
('194081','13474'), ('194084','13501'), ('194119','13548'), ('208115','28951'), ('208116','28952'), ('208117','28953'), ('208118','28958'),
('208119','28989'), ('208120','28954'), ('208121','28956'), ('208122','28960'), ('208123','28961'), ('208124','28963'), ('208125','28964'),
('208126','28968'), ('208127','28970'), ('208128','28977'), ('208129','28980'), ('208130','28978'), ('208131','28979'), ('208132','28985'),
('208133','28983'), ('208134','28988'), ('208135','28991'), ('208136','28990'), ('208137','28955'), ('208138','28965'), ('208139','28967'),
('208140','28992'), ('208141','28981'), ('208142','28982'), ('208143','28957'), ('208144','28959'), ('208145','28962'), ('208146','28966'),
('208147','28969'), ('208148','28971'), ('208149','28972'), ('208150','28973'), ('208151','28974'), ('208153','28976'), ('208154','28984'),
('208155','28986'), ('208156','28987'), ('208157','28993'), ('208158','28994'), ('208159','28995'), ('208160','28996'), ('208161','28998'),
('208162','28999'), ('208163','29000'), ('208164','29001'), ('208165','29002'), ('208166','29003'), ('208167','29004'), ('208168','29005'), 
('208169','29006'), ('208170','29007'), ('208171','29008'), ('208172','29009'), ('208173','29010'), ('208174','29011'), ('208175','29012'),
('208176','29013'), ('208177','29014'), ('208178','29016'), ('208179','29017'), ('208180','29018'), ('208181','29019'), ('208183','29020');


DELETE FROM gameobject_involvedrelation
WHERE gameobject_involvedrelation.id IN
(189303, 190034, 190035, 190036, 190037, 190038, 190039, 190110, 190111, 190112, 190113, 190114, 190115, 190116, 191878,
190040, 190041, 190043, 190044, 190045, 190046, 190047, 190048, 190051, 190052, 190053, 190054, 190055, 190056, 190057,
190058, 190059, 190060, 190061, 190062, 190063, 190064, 190065, 190066, 190067, 190068, 190069, 190070, 190071, 190072,
190073, 190074, 190075, 190076, 190078, 190079, 190080, 190082, 190083, 190084, 190085, 190086, 190088, 190089, 190090,
190091, 190096, 190097, 190098, 190099, 190100, 190101, 190102, 190103, 190104, 190105, 190106, 190107, 190108, 190109,
191879, 191880, 191881, 191882, 191883, 192018, 194056, 194057, 194058, 194059, 194060, 194061, 194062, 194063, 194064,
194065, 194066, 194067, 194068, 194069, 194070, 194071, 194072, 194073, 194074, 194075, 194076, 194077, 194078, 194079,
194080, 194081, 194084, 194119, 208115, 208116, 208117, 208118, 208119, 208120, 208121, 208122, 208123, 208124, 208125,
208126, 208127, 208128, 208129, 208130, 208131, 208132, 208133, 208134, 208135, 208136, 208137, 208138, 208139, 208140,
208141, 208142, 208143, 208144, 208145, 208146, 208147, 208148, 208149, 208150, 208151, 208153, 208154, 208155, 208156,
208157, 208158, 208159, 208160, 208161, 208162, 208163, 208164, 208165, 208166, 208167, 208168,  208169, 208170, 208171,
208172, 208173, 208174, 208175, 208176, 208177, 208178, 208179, 208180, 208181, 208183);

INSERT INTO `gameobject_involvedrelation` (`id`, `quest`) VALUES 
('189303','12286'), ('190034','12331'), ('190035','12345'), ('190036','12332'), ('190037','12333'), ('190038','12334'), ('190039','12335'), ('190040','12336'),
('190041','12337'), ('190043','12339'), ('190044','12343'), ('190045','12341'), ('190046','12342'), ('190047','12340'), ('190048','12344'),
('190051','12348'), ('190052','12349'), ('190053','12350'), ('190054','12351'), ('190055','12352'), ('190056','12353'), ('190057','12354'),
('190058','12355'), ('190059','12356'), ('190060','12357'), ('190061','12358'), ('190062','12359'), ('190063','12360'), ('190064','12361'),
('190065','12362'), ('190066','12363'), ('190067','12364'), ('190068','12365'), ('190069','12366'), ('190070','12367'), ('190071','12368'),
('190072','12369'), ('190073','12370'), ('190074','12371'), ('190075','12373'), ('190076','12374'), ('190078','12376'), ('190079','12377'),
('190080','12378'), ('190082','12380'), ('190083','12381'), ('190084','12382'), ('190085','12383'), ('190086','12384'), ('190088','12386'),
('190089','12387'), ('190090','12388'), ('190091','12389'), ('190096','12390'), ('190097','12391'), ('190098','12392'), ('190099','12393'),
('190100','12394'), ('190101','12395'), ('190102','12396'), ('190103','12397'), ('190104','12398'), ('190105','12399'), ('190106','12400'),
('190107','12401'), ('190108','12402'), ('190109','12403'), ('190110','12404'), ('190111','12404'), ('190112','12406'), ('190113','12407'),
('190114','12408'), ('190115','12409'), ('190116','12409'), ('191878','12940'), ('191879','12941'), ('191880','12946'), ('191881','12947'),
('191882','12944'), ('191883','12945'), ('192018','12950'), ('194056','13433'), ('194057','13434'), ('194058','13435'), ('194059','13436'),
('194060','13437'), ('194061','13438'), ('194062','13439'), ('194063','13448'), ('194064','13473'), ('194065','13452'), ('194066','13456'),
('194067','13459'), ('194068','13460'), ('194069','13461'), ('194070','13462'), ('194071','13463'), ('194072','13472'), ('194073','13464'),
('194074','13465'), ('194075','13466'), ('194076','13467'), ('194077','13468'), ('194078','13469'), ('194079','13470'), ('194080','13471'),
('194081','13474'), ('194084','13501'), ('194119','13548'), ('208115','28951'), ('208116','28952'), ('208117','28953'), ('208118','28958'),
('208119','28989'), ('208120','28954'), ('208121','28956'), ('208122','28960'), ('208123','28961'), ('208124','28963'), ('208125','28964'),
('208126','28968'), ('208127','28970'), ('208128','28977'), ('208129','28980'), ('208130','28978'), ('208131','28979'), ('208132','28985'),
('208133','28983'), ('208134','28988'), ('208135','28991'), ('208136','28990'), ('208137','28955'), ('208138','28965'), ('208139','28967'),
('208140','28992'), ('208141','28981'), ('208142','28982'), ('208143','28957'), ('208144','28959'), ('208145','28962'), ('208146','28966'),
('208147','28969'), ('208148','28971'), ('208149','28972'), ('208150','28973'), ('208151','28974'), ('208153','28976'), ('208154','28984'),
('208155','28986'), ('208156','28987'), ('208157','28993'), ('208158','28994'), ('208159','28995'), ('208160','28996'), ('208161','28998'),
('208162','28999'), ('208163','29000'), ('208164','29001'), ('208165','29002'), ('208166','29003'), ('208167','29004'), ('208168','29005'), 
('208169','29006'), ('208170','29007'), ('208171','29008'), ('208172','29009'), ('208173','29010'), ('208174','29011'), ('208175','29012'),
('208176','29013'), ('208177','29014'), ('208178','29016'), ('208179','29017'), ('208180','29018'), ('208181','29019'), ('208183','29020');


 


-- Insertion into the game_event_object table.
INSERT INTO `game_event_gameobject` (eventEntry, guid)
SELECT '12' , gameobject.guid
FROM gameobject
WHERE gameobject.guid IN (
@my_id, @my_id+1, @my_id+2, @my_id+3, @my_id+4, @my_id+5, @my_id+6, @my_id+7, @my_id+8, @my_id+9, @my_id+10, @my_id+11, @my_id+12, @my_id+13,
@my_id+14, @my_id+15, @my_id+16, @my_id+17, @my_id+18, @my_id+19, @my_id+20, @my_id+21, @my_id+22, @my_id+23, @my_id+24, @my_id+25, @my_id+26, 
@my_id+27, @my_id+28, @my_id+29, @my_id+30, @my_id+31, @my_id+32, @my_id+33, @my_id+34, @my_id+35, @my_id+36, @my_id+37, @my_id+38, @my_id+39, 
@my_id+40, @my_id+41, @my_id+42, @my_id+43, @my_id+44, @my_id+45, @my_id+46, @my_id+47, @my_id+48, @my_id+49, @my_id+50, @my_id+51, @my_id+52, 
@my_id+53, @my_id+54, @my_id+55, @my_id+56, @my_id+57, @my_id+58, @my_id+59, @my_id+60, @my_id+61, @my_id+62, @my_id+63, @my_id+64, @my_id+65, 
@my_id+66, @my_id+67, @my_id+68, @my_id+69, @my_id+70, @my_id+71, @my_id+72, @my_id+73, @my_id+74, @my_id+75, @my_id+76, @my_id+77, @my_id+78, 
@my_id+79, @my_id+80, @my_id+81, @my_id+82, @my_id+83, @my_id+84, @my_id+85, @my_id+86, @my_id+87, @my_id+88, @my_id+89, @my_id+90, @my_id+91, 
@my_id+92, @my_id+93, @my_id+94, @my_id+95, @my_id+96, @my_id+97, @my_id+98, @my_id+99, @my_id+100, @my_id+101, @my_id+102, @my_id+103, @my_id+104, 
@my_id+105, @my_id+106, @my_id+107, @my_id+108, @my_id+109, @my_id+110, @my_id+111, @my_id+112, @my_id+113, @my_id+114, @my_id+115, @my_id+116, 
@my_id+117, @my_id+118, @my_id+119, @my_id+120, @my_id+121, @my_id+122, @my_id+123, @my_id+124, @my_id+125, @my_id+126, @my_id+127, @my_id+128, 
@my_id+129, @my_id+130, @my_id+131, @my_id+132, @my_id+133, @my_id+134, @my_id+135, @my_id+136, @my_id+137, @my_id+138, @my_id+139, @my_id+140, 
@my_id+141, @my_id+142, @my_id+143, @my_id+144, @my_id+145, @my_id+146, @my_id+147, @my_id+148, @my_id+149, @my_id+150, @my_id+151, @my_id+152, 
@my_id+153, @my_id+154, @my_id+155, @my_id+156, @my_id+157, @my_id+158, @my_id+159, @my_id+160, @my_id+161, @my_id+162, @my_id+163, @my_id+164, 
@my_id+165, @my_id+166, @my_id+167, @my_id+168, @my_id+169, @my_id+170, @my_id+171, @my_id+172, @my_id+173, @my_id+174, @my_id+175);



-- Kraazar phasemask. It must be done at the end because of possible treatment (deletions, creations) in the gameobject table
UPDATE `gameobject` SET `phaseMask`='2' WHERE (id = '208153');
 
Last edited:

Titesusy

Veteran Member
134
2016
4
Location
France
I'll test the script before the end of this day. The execution is already done. I already tested the multiple running of these scripts. It's ok! (The previous version of halloween scripts couldn't because of absence of "delete from" commands.
The candy buckets have to be checked (i'll do it before midnight, do not worry)
 

ExO

Admin
5,084
2014
1,442
I'll test the script before the end of this day. The execution is already done. I already tested the multiple running of these scripts. It's ok! (The previous version of halloween scripts couldn't because of absence of "delete from" commands.
The candy buckets have to be checked (i'll do it before midnight, do not worry)

Awesome! Great job.

If you can test it within the next couple of hours, I can include it for release v.10 (2) because I am releasing that soon.
 

Titesusy

Veteran Member
134
2016
4
Location
France
i'm testing actually. Major bugs are fixed. I'm mainly testing now if every candybuckets are covered as well with one horde and one alliance character. Warning, the scripts code are updated (since your last answer)
 

Titesusy

Veteran Member
134
2016
4
Location
France
Alliance character successfully tested. It remains one horde character now (and the test will be completed ... in one hour :) )
 

Titesusy

Veteran Member
134
2016
4
Location
France
Tests are done with horde and alliance characters.
To note, these tests were made by "lambda" characters, that's means they didn't do others quests from the areas. Maybe some candybucket may disappear from a phasemask... Let me know it. Thanks by advance.
You can upload it into V10(2) [MENTION=1]ExO[/MENTION]

Update to fix the next issue.

Horde known issue (semi fixed because don't know how many phases had script):
object guid = 600146 or id = 208153
have to put it in phase 2. But I don't know how many phase had been scripted, so maybe to add some candybucket for each phase? I don't really know about it, i'm sorry.
 
Last edited:

ravish123

Gold Supporter
Senior User
279
2015
76
Tests are done with horde and alliance characters.
To note, these tests were made by "lambda" characters, that's means they didn't do others quests from the areas. Maybe some candybucket may disappear from a phasemask... Let me know it. Thanks by advance.
You can upload it into V10(2) [MENTION=1]ExO[/MENTION]

Update to fix the next issue.

Horde known issue (semi fixed because don't know how many phases had script):
object guid = 600146 or id = 208153
have to put it in phase 2. But I don't know how many phase had been scripted, so maybe to add some candybucket for each phase? I don't really know about it, i'm sorry.

Do you use event horzion SAI?
 

Titesusy

Veteran Member
134
2016
4
Location
France
[MENTION=7506]ravish123[/MENTION] for creature / gobject scripting, yes. For LETC, i used event horizon, yes.
But i'm not too much experienced into it.
 

ravish123

Gold Supporter
Senior User
279
2015
76
[MENTION=7506]ravish123[/MENTION] for creature / gobject scripting, yes. For LETC, i used event horizon, yes.
But i'm not too much experienced into it.

Can you send the link to the event horizon ur using or upload the file?
 

Titesusy

Veteran Member
134
2016
4
Location
France
Can you send the link to the event horizon ur using or upload the file?

I didn't really checked if it's the same version of event horizon, but looking at the last date of modification, it's matching between mine and the download link. so....
For tutorials about event horizon, i don't remember if there are some in our forums (Emucoach, maybe in tutorial). But else, there should be some youtube videos or on ac-web forums
http://www.ac-web.org/forums/showth...Horizon-A-SmartAI-Editor-(for-Skyfire-and-TC)
 

Titesusy

Veteran Member
134
2016
4
Location
France
First of all, thanks for the credits in changelog :) Thanks for the V10(1) too!

Great, will include it for the release coming monday.

hummm you forgot it i think :)
Because halloween isn't included (quests aren't available)
My test: (check the database about the questgivers : if they really give their quests. They can reward the quest (i made the same request to the gameobject_involvedrelation table, and it seems that table has the records. So they can reward but nobody can give the quests. (the script to use is here)

Code:
select *
FROM gameobject_questrelation
WHERE id IN
(189303, 190034, 190035, 190036, 190037, 190038, 190039, 190110, 190111, 190112, 190113, 190114, 190115, 190116, 191878,
190040, 190041, 190043, 190044, 190045, 190046, 190047, 190048, 190051, 190052, 190053, 190054, 190055, 190056, 190057,
190058, 190059, 190060, 190061, 190062, 190063, 190064, 190065, 190066, 190067, 190068, 190069, 190070, 190071, 190072,
190073, 190074, 190075, 190076, 190078, 190079, 190080, 190082, 190083, 190084, 190085, 190086, 190088, 190089, 190090,
190091, 190096, 190097, 190098, 190099, 190100, 190101, 190102, 190103, 190104, 190105, 190106, 190107, 190108, 190109,
191879, 191880, 191881, 191882, 191883, 192018, 194056, 194057, 194058, 194059, 194060, 194061, 194062, 194063, 194064,
194065, 194066, 194067, 194068, 194069, 194070, 194071, 194072, 194073, 194074, 194075, 194076, 194077, 194078, 194079,
194080, 194081, 194084, 194119, 208115, 208116, 208117, 208118, 208119, 208120, 208121, 208122, 208123, 208124, 208125,
208126, 208127, 208128, 208129, 208130, 208131, 208132, 208133, 208134, 208135, 208136, 208137, 208138, 208139, 208140,
208141, 208142, 208143, 208144, 208145, 208146, 208147, 208148, 208149, 208150, 208151, 208153, 208154, 208155, 208156,
208157, 208158, 208159, 208160, 208161, 208162, 208163, 208164, 208165, 208166, 208167, 208168,  208169, 208170, 208171,
208172, 208173, 208174, 208175, 208176, 208177, 208178, 208179, 208180, 208181, 208183);

the result was : no entry for this request. (So noboday can take the halloween candy quest :( )
 
Last edited:
Top