V10 Halloween + LETC events
Close

User Tag List

Page 1 of 2 12 LastLast
Results 1 to 10 of 19
  1. #1
    Titesusy's Avatar
    Join Date
    Jul 2016
    Location
    France
    Posts
    132
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    V10 Halloween + LETC events

    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 by Titesusy; 02-21-2019 at 03:58 PM.
    To check easily my lastest scripts , check them here :
    [Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ]

  2. #2
    Titesusy's Avatar
    Join Date
    Jul 2016
    Location
    France
    Posts
    132
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)
    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)

  3. #3
    ExO's Avatar
    Join Date
    Mar 2014
    Posts
    3,609
    Mentioned
    73 Post(s)
    Tagged
    12 Thread(s)
    Quote Originally Posted by Titesusy View Post
    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.
    Have a question? Look here! If it's not already there, feel free to ask!
    [Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ][Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ]

    Want to donate and get VIP Access?
    Click
    [Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ]!



  4. #4
    Titesusy's Avatar
    Join Date
    Jul 2016
    Location
    France
    Posts
    132
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)
    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)

  5. #5
    ExO's Avatar
    Join Date
    Mar 2014
    Posts
    3,609
    Mentioned
    73 Post(s)
    Tagged
    12 Thread(s)
    Great! Sounds good. Will run it whenever you say I should.
    Have a question? Look here! If it's not already there, feel free to ask!
    [Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ][Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ]

    Want to donate and get VIP Access?
    Click
    [Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ]!



  6. #6
    Titesusy's Avatar
    Join Date
    Jul 2016
    Location
    France
    Posts
    132
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)
    Alliance character successfully tested. It remains one horde character now (and the test will be completed ... in one hour )

  7. #7
    Titesusy's Avatar
    Join Date
    Jul 2016
    Location
    France
    Posts
    132
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)
    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) @[Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ]

    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 by Titesusy; 01-18-2019 at 11:41 PM.

  8. #8
    ravish123's Avatar
    Join Date
    Aug 2015
    Posts
    253
    Mentioned
    17 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Titesusy View Post
    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) @[Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ]

    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?

  9. #9
    Titesusy's Avatar
    Join Date
    Jul 2016
    Location
    France
    Posts
    132
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)
    @[Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ] for creature / gobject scripting, yes. For LETC, i used event horizon, yes.
    But i'm not too much experienced into it.

  10. #10
    ravish123's Avatar
    Join Date
    Aug 2015
    Posts
    253
    Mentioned
    17 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Titesusy View Post
    @[Only registered users can see this link. Therefor you need to register first, and hopefully we see you wanting to join our friendly community we are trying to build up. Enjoy! ] 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?

Visitors found this page by searching for:

Nobody landed on this page from a search engine, yet!
SEO Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •