V10 Halloween + LETC events

TokeurZ

Verified Member
17
2019
0
Location
France
For the first time in my entire life.. I see a post about script event, i will check this ! Thanks alot for this !
 

joca

Verified Member
28
2020
2
Location
brasil
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');


 


- Inserção na tabela game_event_object.
INSERT INTO `game_event_gameobject` (eventEntry, guid)
SELECIONE '12', gameobject.guid
FROM gameobject
ONDE 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);



- máscara de fase Kraazar. Deve ser feito no final devido ao possível tratamento (exclusões, criações) na tabela de objetos do jogo
ATUALIZAR `gameobject` SET` phaseMask` = '2' ONDE (id = '208153'); [/CÓDIGO]
[/QUOTE]
Obrigado, pelo seu tempo
 
Top