-- Last Revision & Tests : 2019.03.01 by Titesusy
-- Tested with V10.1
-- Modifiable starting here
SET @my_go_guid = 605000; -- my_go_guid => my_go_guid+200 free
SET @my_npc_guid = 700000; -- my_npc_guid => my_npc_guid+20 free
SET @my_SpawnEgg = 1800 ; -- 1800 = 30min
-- Non modifiable starting here
SET @id_Eggs = 113768;
SET @event_id = 9;
-- insertion into the tables the loot of the eggs.
DELETE FROM gameobject_loot_template WHERE ( entry = @id_Eggs );
INSERT INTO gameobject_loot_template (entry, item, ChanceOrQuestChance, lootmode, groupid, mincountOrRef, maxcount) VALUES
(@id_Eggs,'45072','100','1','0','1','1');
UPDATE item_loot_template SET maxcount = '6' WHERE (entry = '45072' AND item = '44791'); -- Noblegarden Chocolate (it's 6 max in the ofiicial, instead of 1 actually)
UPDATE item_loot_template SET maxcount = '2' WHERE (entry = '45072' AND item = '44806'); -- Brightly Colored Shell Fragment (it's 2 max in the ofiicial, instead of 1 actually)
-- french fix
UPDATE locales_creature SET name_loc2 = 'Vendeur du Jardin des nobles' WHERE ( entry = '32836' );
UPDATE locales_creature SET name_loc2 = 'Collecteur du printemps' WHERE ( entry = '32799' );
UPDATE locales_creature SET name_loc2 = 'Récolteur du printemps' WHERE ( entry = '32798' );
UPDATE locales_creature SET name_loc2 = 'Marchand du Jardin des nobles' WHERE ( entry = '32837' );
-- insertion into creature tables
DELETE FROM creature WHERE ( id IN (
'32836', -- Vendeur du Jardin des nobles (alliance)
'32799', -- Collecteur du printemps (alliance)
'32798', -- Récolteur du printemps (horde)
'32837')); -- Marchand du Jardin des nobles (horde)
INSERT INTO creature
(guid, id, map, zone, area, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags, walkmode, saiscriptflag) VALUES
(@my_npc_guid,'32798','530','3430','3665','1','65535','0','0','9496.47','-6840.33','16.494','0.829088','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+1,'32798','0','85','159','1','65535','0','0','2268.58','289.072','33.6906','3.47791','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+2,'32798','1','215','222','1','65535','0','0','-2335.25','-353.905','-8.78457','4.42163','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+3,'32798','1','14','362','1','65535','0','0','323.987','-4702.93','15.996','5.21488','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+4,'32799','530','3524','3576','1','1','0','0','-4155.54','-12485.9','44.7692','4.09744','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+5,'32799','0','12','87','1','1','0','0','-9452.48','48.0161','57.0914','2.23636','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+6,'32799','0','1','131','1','1','0','0','-5606.82','-507.522','401.518','0.715774','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+7,'32799','1','141','186','1','1','0','0','9838.85','962.549','1308.34','0.555242','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+8,'32836','530','3524','3576','1','1','0','32836','-4150.47','-12492.1','44.6442','3.58929','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+9,'32836','0','12','87','1','1','0','32836','-9462.88','50.8959','56.5371','1.13366','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+10,'32836','0','1','131','1','1','0','32836','-5597.71','-507.146','401.15','2.5968','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+11,'32836','1','141','186','1','1','0','32836','9837.45','969.44','1308.19','5.38937','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+12,'32837','530','3430','3665','1','65535','0','32837','9489.87','-6833.56','16.494','0.485869','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+13,'32837','0','85','159','1','65535','0','32837','2264.59','283.234','33.6906','1.76967','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+14,'32837','1','215','222','1','65535','0','32837','-2343.22','-365.448','-8.36635','0.204827','300','0','0','42','0','0','0','0','0','0','0'),
(@my_npc_guid+15,'32837','1','14','362','1','65535','0','32837','333.036','-4709.74','15.0985','2.51625','300','0','0','42','0','0','0','0','0','0','0');
-- insertion into the tables the eggs that we have to loot
DELETE FROM gameobject WHERE ( id = @id_Eggs ); -- brightly-colored-egg
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_go_guid,@id_Eggs,'1','215','223','1','65535','-2129.31','-424.352','-6.6296','1.05149','0','0','0.501856','0.864951',@my_SpawnEgg,'0','1'),
(@my_go_guid+1,@id_Eggs,'1','215','223','1','65535','-2171.87','-477.968','-8.91058','0.806441','0','0','0.392383','0.919802',@my_SpawnEgg,'0','1'),
(@my_go_guid+2,@id_Eggs,'1','215','223','1','65535','-2211.33','-512.298','-9.36233','0.601452','0','0','0.296214','0.955122',@my_SpawnEgg,'0','1'),
(@my_go_guid+3,@id_Eggs,'1','215','215','1','65535','-2264.02','-549.675','-7.96182','0.67685','0','0','0.332002','0.943279',@my_SpawnEgg,'0','1'),
(@my_go_guid+4,@id_Eggs,'1','215','215','1','65535','-2310.82','-581.246','-8.8101','0.559041','0','0','0.275895','0.961188',@my_SpawnEgg,'0','1'),
(@my_go_guid+5,@id_Eggs,'1','215','223','1','65535','-2144.28','-351.822','-5.59096','2.17932','0','0','0.886469','0.462788',@my_SpawnEgg,'0','1'),
(@my_go_guid+6,@id_Eggs,'1','215','223','1','65535','-2203.68','-288.096','-10.6198','2.64349','0','0','0.969147','0.246485',@my_SpawnEgg,'0','1'),
(@my_go_guid+7,@id_Eggs,'1','215','223','1','65535','-2263.82','-224.852','-10.2535','2.52332','0','0','0.952597','0.304235',@my_SpawnEgg,'0','1'),
(@my_go_guid+8,@id_Eggs,'1','215','223','1','65535','-2318.6','-222.516','-9.98074','3.41161','0','0','0.9909','-0.134598',@my_SpawnEgg,'0','1'),
(@my_go_guid+9,@id_Eggs,'1','215','222','1','65535','-2315.56','-264.951','-8.90661','5.47328','0','0','0.393975','-0.919121',@my_SpawnEgg,'0','1'),
(@my_go_guid+10,@id_Eggs,'1','215','222','1','65535','-2346.09','-318.599','-9.0132','2.44557','0','0','0.940053','0.34103',@my_SpawnEgg,'0','1'),
(@my_go_guid+11,@id_Eggs,'1','215','222','1','65535','-2393.96','-343.22','-9.38058','4.65332','0','0','0.727678','-0.685919',@my_SpawnEgg,'0','1'),
(@my_go_guid+12,@id_Eggs,'1','215','222','1','65535','-2420.99','-391.972','-2.1472','5.61544','0','0','0.327705','-0.94478',@my_SpawnEgg,'0','1'),
(@my_go_guid+13,@id_Eggs,'1','215','222','1','65535','-2377.6','-411.05','-4.45057','0.174984','0','0','0.0873806','0.996175',@my_SpawnEgg,'0','1'),
(@my_go_guid+14,@id_Eggs,'1','215','222','1','65535','-2334.37','-449.538','-6.54438','1.52037','0','0','0.689057','0.724708',@my_SpawnEgg,'0','1'),
(@my_go_guid+15,@id_Eggs,'1','215','222','1','65535','-2306.72','-473.488','-7.36734','0.610097','0','0','0.300339','0.953832',@my_SpawnEgg,'0','1'),
(@my_go_guid+16,@id_Eggs,'1','215','223','1','65535','-2197.31','-479.444','-9.27251','5.07351','0','0','0.568627','-0.822596',@my_SpawnEgg,'0','1'),
(@my_go_guid+17,@id_Eggs,'1','215','222','1','65535','-2182.47','-420.184','-4.48176','1.32638','0','0','0.615634','0.788032',@my_SpawnEgg,'0','1'),
(@my_go_guid+18,@id_Eggs,'1','215','222','1','65535','-2145.36','-397.615','-2.64568','1.13631','0','0','0.538079','0.842894',@my_SpawnEgg,'0','1'),
(@my_go_guid+19,@id_Eggs,'1','215','222','1','65535','-2216.99','-367.743','-8.323','4.77664','0','0','0.684031','-0.729453',@my_SpawnEgg,'0','1'),
(@my_go_guid+20,@id_Eggs,'1','215','222','1','65535','-2295.23','-421.906','-7.66282','2.77465','0','0','0.983217','0.182441',@my_SpawnEgg,'0','1'),
(@my_go_guid+21,@id_Eggs,'1','215','222','1','65535','-2326.28','-391.288','-7.97645','2.68355','0','0','0.973889','0.227025',@my_SpawnEgg,'0','1'),
(@my_go_guid+22,@id_Eggs,'1','215','222','1','65535','-2357.08','-366.395','-8.52815','0.975307','0','0','0.468554','0.883435',@my_SpawnEgg,'0','1'),
(@my_go_guid+23,@id_Eggs,'1','215','222','1','65535','-2283.59','-507.668','-9.42172','0.526077','0','0','0.260016','0.965604',@my_SpawnEgg,'0','1'),
(@my_go_guid+24,@id_Eggs,'1','215','222','1','65535','-2188.01','-410.176','-4.45688','5.44973','0','0','0.404772','-0.914418',@my_SpawnEgg,'0','1'),
(@my_go_guid+25,@id_Eggs,'1','215','222','1','65535','-2238.74','-401.872','-9.42387','2.59873','0','0','0.963388','0.268111',@my_SpawnEgg,'0','1'),
(@my_go_guid+26,@id_Eggs,'1','215','222','1','65535','-2255.61','-333.789','-9.42471','1.73793','0','0','0.763662','0.645616',@my_SpawnEgg,'0','1'),
(@my_go_guid+27,@id_Eggs,'1','215','222','1','65535','-2327.11','-425.482','-7.2293','4.35017','0','0','0.822906','-0.568177',@my_SpawnEgg,'0','1'),
(@my_go_guid+28,@id_Eggs,'530','3524','3576','1','65535','-4229.96','-12468','46.1631','5.96746','0','0','0.157208','-0.987565',@my_SpawnEgg,'0','1'),
(@my_go_guid+29,@id_Eggs,'530','3524','3576','1','65535','-4207.22','-12438.5','45.552','5.80017','0','0','0.239168','-0.970978',@my_SpawnEgg,'0','1'),
(@my_go_guid+30,@id_Eggs,'530','3524','3576','1','65535','-4155.21','-12425.2','41.6128','4.6904','0','0','0.714838','-0.69929',@my_SpawnEgg,'0','1'),
(@my_go_guid+31,@id_Eggs,'530','3524','3576','1','65535','-4125.19','-12457.2','45.1984','4.54353','0','0','0.764218','-0.644958',@my_SpawnEgg,'0','1'),
(@my_go_guid+32,@id_Eggs,'530','3524','3576','1','65535','-4144.73','-12538.4','45.5057','3.15887','0','0','0.999963','-0.00863987',@my_SpawnEgg,'0','1'),
(@my_go_guid+33,@id_Eggs,'530','3524','3576','1','65535','-4170.05','-12543.6','45.1558','1.88024','0','0','0.80763','0.589689',@my_SpawnEgg,'0','1'),
(@my_go_guid+34,@id_Eggs,'530','3524','3576','1','65535','-4236.34','-12538.9','46.4093','0.602401','0','0','0.296667','0.954981',@my_SpawnEgg,'0','1'),
(@my_go_guid+35,@id_Eggs,'530','3524','3576','1','65535','-4247.37','-12522.7','47.1886','5.89991','0','0','0.190466','-0.981694',@my_SpawnEgg,'0','1'),
(@my_go_guid+36,@id_Eggs,'530','3524','3576','1','65535','-4180.31','-12496.3','44.3652','4.992','0','0','0.601672','-0.798743',@my_SpawnEgg,'0','1'),
(@my_go_guid+37,@id_Eggs,'530','3524','3576','1','65535','-4132.38','-12488.6','43.9197','1.83706','0','0','0.79471','0.60699',@my_SpawnEgg,'0','1'),
(@my_go_guid+38,@id_Eggs,'530','3524','3576','1','65535','-4144.66','-12533.3','45.0842','5.59282','0','0','0.338367','-0.941014',@my_SpawnEgg,'0','1'),
(@my_go_guid+39,@id_Eggs,'530','3524','3576','1','65535','-4163.59','-12539.9','45.0195','4.55688','0','0','0.759896','-0.650045',@my_SpawnEgg,'0','1'),
(@my_go_guid+40,@id_Eggs,'530','3524','3576','1','65535','-4211.67','-12532','45.8415','3.97883','0','0','0.913652','-0.406497',@my_SpawnEgg,'0','1'),
(@my_go_guid+41,@id_Eggs,'530','3524','3576','1','65535','-4227.47','-12527','45.2597','6.16301','0','0','0.060051','-0.998195',@my_SpawnEgg,'0','1'),
(@my_go_guid+42,@id_Eggs,'530','3524','3576','1','65535','-4220.01','-12482.9','45.0134','2.20932','0','0','0.893311','0.449439',@my_SpawnEgg,'0','1'),
(@my_go_guid+43,@id_Eggs,'530','3524','3576','1','65535','-4203.51','-12454.8','45.5697','1.39329','0','0','0.641648','0.767',@my_SpawnEgg,'0','1'),
(@my_go_guid+44,@id_Eggs,'530','3524','3576','1','65535','-4140.5','-12493.9','44.2462','1.1451','0','0','0.541779','0.840521',@my_SpawnEgg,'0','1'),
(@my_go_guid+45,@id_Eggs,'530','3524','3576','1','65535','-4223.87','-12561.8','41.8341','2.14806','0','0','0.879128','0.476586',@my_SpawnEgg,'0','1'),
(@my_go_guid+46,@id_Eggs,'0','12','87','1','65535','-9426.77','56.8721','56.9315','5.97101','0','0','0.155456','-0.987843',@my_SpawnEgg,'0','1'),
(@my_go_guid+47,@id_Eggs,'0','12','87','1','65535','-9437.21','116.292','57.5062','3.53549','0','0','0.980668','-0.195678',@my_SpawnEgg,'0','1'),
(@my_go_guid+48,@id_Eggs,'0','12','87','1','65535','-9459.7','105.946','57.4716','5.05759','0','0','0.575158','-0.818043',@my_SpawnEgg,'0','1'),
(@my_go_guid+49,@id_Eggs,'0','12','87','1','65535','-9466','98.3465','58.3439','3.52685','0','0','0.981504','-0.19144',@my_SpawnEgg,'0','1'),
(@my_go_guid+50,@id_Eggs,'0','12','87','1','65535','-9473.08','79.0949','57.6316','4.01851','0','0','0.905407','-0.424544',@my_SpawnEgg,'0','1'),
(@my_go_guid+51,@id_Eggs,'0','12','87','1','65535','-9469.1','100.123','58.0037','5.6702','0','0','0.301716','-0.953398',@my_SpawnEgg,'0','1'),
(@my_go_guid+52,@id_Eggs,'0','12','87','1','65535','-9499.43','84.6211','57.5034','5.84456','0','0','0.217559','-0.976047',@my_SpawnEgg,'0','1'),
(@my_go_guid+53,@id_Eggs,'0','12','87','1','65535','-9484.45','47.1966','57.018','4.93507','0','0','0.624162','-0.781295',@my_SpawnEgg,'0','1'),
(@my_go_guid+54,@id_Eggs,'0','12','87','1','65535','-9481.37','32.29','57.3332','2.80507','0','0','0.985877','0.167469',@my_SpawnEgg,'0','1'),
(@my_go_guid+55,@id_Eggs,'0','12','87','1','65535','-9483.81','13.3021','56.7701','0.18027','0','0','0.0900131','0.995941',@my_SpawnEgg,'0','1'),
(@my_go_guid+56,@id_Eggs,'0','12','87','1','65535','-9472.69','9.01483','56.4875','6.03934','0','0','0.121621','-0.992577',@my_SpawnEgg,'0','1'),
(@my_go_guid+57,@id_Eggs,'0','12','87','1','65535','-9452.71','18.3744','56.5308','2.34326','0','0','0.921385','0.388651',@my_SpawnEgg,'0','1'),
(@my_go_guid+58,@id_Eggs,'0','12','5637','1','65535','-9458.24','9.21242','56.963','0.636589','0','0','0.312947','0.949771',@my_SpawnEgg,'0','1'),
(@my_go_guid+59,@id_Eggs,'0','12','5637','1','65535','-9474.32','3.17681','49.7952','4.85339','0','0','0.655539','-0.755161',@my_SpawnEgg,'0','1'),
(@my_go_guid+60,@id_Eggs,'1','14','362','1','65535','379.997','-4705.33','15.7616','4.03915','0','0','0.900978','-0.433864',@my_SpawnEgg,'0','1'),
(@my_go_guid+61,@id_Eggs,'1','14','362','1','65535','354.085','-4658.67','16.2061','3.39276','0','0','0.992124','-0.125256',@my_SpawnEgg,'0','1'),
(@my_go_guid+62,@id_Eggs,'1','14','362','1','65535','286.875','-4632.18','20.3353','5.01383','0','0','0.592919','-0.805262',@my_SpawnEgg,'0','1'),
(@my_go_guid+63,@id_Eggs,'1','14','362','1','65535','256.411','-4709','15.3054','6.24847','0','0','0.0173554','-0.999849',@my_SpawnEgg,'0','1'),
(@my_go_guid+64,@id_Eggs,'1','14','362','1','65535','281.515','-4776.45','11.3062','2.26729','0','0','0.905961','0.423361',@my_SpawnEgg,'0','1'),
(@my_go_guid+65,@id_Eggs,'1','14','362','1','65535','284.049','-4814.9','10.263','0.23311','0','0','0.116291','0.993215',@my_SpawnEgg,'0','1'),
(@my_go_guid+66,@id_Eggs,'1','14','362','1','65535','329.015','-4863.27','10.5579','6.26261','0','0','0.0102865','-0.999947',@my_SpawnEgg,'0','1'),
(@my_go_guid+67,@id_Eggs,'1','14','362','1','65535','359.885','-4836.23','11.2603','3.97475','0','0','0.914479','-0.404633',@my_SpawnEgg,'0','1'),
(@my_go_guid+68,@id_Eggs,'1','14','362','1','65535','330.094','-4796.77','10.2157','3.83495','0','0','0.940507','-0.339774',@my_SpawnEgg,'0','1'),
(@my_go_guid+69,@id_Eggs,'1','14','362','1','65535','369.31','-4768.35','12.4685','3.50979','0','0','0.983101','-0.183062',@my_SpawnEgg,'0','1'),
(@my_go_guid+70,@id_Eggs,'1','141','186','1','65535','9893.21','966.44','1310.14','2.13779','0','0','0.87667','0.481092',@my_SpawnEgg,'0','1'),
(@my_go_guid+71,@id_Eggs,'1','141','186','1','65535','9893.43','988.957','1327.58','0.226924','0','0','0.113219','0.99357',@my_SpawnEgg,'0','1'),
(@my_go_guid+72,@id_Eggs,'1','141','186','1','65535','9897.76','974.872','1354.95','1.86843','0','0','0.804132','0.59445',@my_SpawnEgg,'0','1'),
(@my_go_guid+73,@id_Eggs,'1','141','186','1','65535','9896.97','1010.77','1316.82','6.15278','0','0','0.0651579','-0.997875',@my_SpawnEgg,'0','1'),
(@my_go_guid+74,@id_Eggs,'1','141','186','1','65535','9907.58','966.469','1314.54','2.65775','0','0','0.97088','0.239567',@my_SpawnEgg,'0','1'),
(@my_go_guid+75,@id_Eggs,'1','141','141','1','65535','9932.01','899.529','1318.02','1.04298','0','0','0.498171','0.867079',@my_SpawnEgg,'0','1'),
(@my_go_guid+76,@id_Eggs,'1','141','141','1','65535','9968.31','948.699','1330.68','2.48575','0','0','0.946714','0.322074',@my_SpawnEgg,'0','1'),
(@my_go_guid+77,@id_Eggs,'1','141','141','1','65535','9853.12','884.599','1310.68','5.22365','0','0','0.505334','-0.862924',@my_SpawnEgg,'0','1'),
(@my_go_guid+78,@id_Eggs,'1','141','186','1','65535','9779.45','869.85','1297.45','1.82601','0','0','0.791345','0.611369',@my_SpawnEgg,'0','1'),
(@my_go_guid+79,@id_Eggs,'1','141','186','1','65535','9764.15','874.324','1297.42','1.1168','0','0','0.529829','0.848104',@my_SpawnEgg,'0','1'),
(@my_go_guid+80,@id_Eggs,'1','141','186','1','65535','9700.97','891.327','1298.15','3.67013','0','0','0.965284','-0.261203',@my_SpawnEgg,'0','1'),
(@my_go_guid+81,@id_Eggs,'1','141','259','1','65535','9660.33','919.775','1279.29','2.07577','0','0','0.861332','0.508043',@my_SpawnEgg,'0','1'),
(@my_go_guid+82,@id_Eggs,'0','85','159','1','65535','2232.47','295.231','33.5749','3.85884','0','0','0.93638','-0.350988',@my_SpawnEgg,'0','1'),
(@my_go_guid+83,@id_Eggs,'0','85','159','1','65535','2196.21','282.283','40.3585','3.71354','0','0','0.959387','-0.282093',@my_SpawnEgg,'0','1'),
(@my_go_guid+84,@id_Eggs,'0','85','159','1','65535','2205.42','227.671','33.9233','5.15082','0','0','0.536413','-0.843955',@my_SpawnEgg,'0','1'),
(@my_go_guid+85,@id_Eggs,'0','85','159','1','65535','2286.08','204.019','33.7249','2.28726','0','0','0.910144','0.414293',@my_SpawnEgg,'0','1'),
(@my_go_guid+86,@id_Eggs,'0','85','159','1','65535','2304.28','204.174','34.6673','4.79111','0','0','0.678734','-0.734384',@my_SpawnEgg,'0','1'),
(@my_go_guid+87,@id_Eggs,'0','85','159','1','65535','2299.7','255.42','33.5807','1.89613','0','0','0.812288','0.583256',@my_SpawnEgg,'0','1'),
(@my_go_guid+88,@id_Eggs,'0','85','159','1','65535','2339.04','268.94','34.5943','4.73927','0','0','0.697539','-0.716547',@my_SpawnEgg,'0','1'),
(@my_go_guid+89,@id_Eggs,'0','85','159','1','65535','2310.61','285.348','34.5746','4.07404','0','0','0.893273','-0.449515',@my_SpawnEgg,'0','1'),
(@my_go_guid+90,@id_Eggs,'0','85','159','1','65535','2345.17','325.788','36.3631','5.51211','0','0','0.376058','-0.926596',@my_SpawnEgg,'0','1'),
(@my_go_guid+91,@id_Eggs,'0','85','159','1','65535','2335.47','367.759','33.9296','1.4249','0','0','0.65369','0.756762',@my_SpawnEgg,'0','1'),
(@my_go_guid+92,@id_Eggs,'0','85','159','1','65535','2405.82','407.734','35.6125','4.77463','0','0','0.684761','-0.728768',@my_SpawnEgg,'0','1'),
(@my_go_guid+93,@id_Eggs,'0','85','159','1','65535','2398.7','457.939','35.818','2.0548','0','0','0.855958','0.517045',@my_SpawnEgg,'0','1'),
(@my_go_guid+94,@id_Eggs,'0','85','159','1','65535','2428.29','428.558','35.6508','3.40569','0','0','0.991294','-0.131667',@my_SpawnEgg,'0','1'),
(@my_go_guid+95,@id_Eggs,'0','85','159','1','65535','2424.16','381.355','33.9719','5.40768','0','0','0.423904','-0.905707',@my_SpawnEgg,'0','1'),
(@my_go_guid+96,@id_Eggs,'0','1519','5148','1','3969','-8816.52','551.143','95.7464','1.19651','0','0','0.5632','0.826321',@my_SpawnEgg,'0','1'),
(@my_go_guid+97,@id_Eggs,'0','1519','5148','1','3969','-8786.69','606.632','97.6999','1.78555','0','0','0.778816','0.627253',@my_SpawnEgg,'0','1'),
(@my_go_guid+98,@id_Eggs,'0','1519','5148','1','3969','-8753.94','567.2','97.5133','0.917692','0','0','0.442914','0.896564',@my_SpawnEgg,'0','1'),
(@my_go_guid+99,@id_Eggs,'0','1519','5148','1','3969','-8852.82','614.507','93.616','2.20575','0','0','0.892507','0.451034',@my_SpawnEgg,'0','1'),
(@my_go_guid+100,@id_Eggs,'0','1519','5148','1','3969','-8820.7','674.912','98.2961','5.26173','0','0','0.488811','-0.872389',@my_SpawnEgg,'0','1'),
(@my_go_guid+101,@id_Eggs,'0','1519','5148','1','3969','-8798.04','676.805','101.714','5.56332','0','0','0.352209','-0.935921',@my_SpawnEgg,'0','1'),
(@my_go_guid+102,@id_Eggs,'0','1519','5148','1','3969','-8774.42','653.12','104.033','2.93066','0','0','0.994444','0.105269',@my_SpawnEgg,'0','1'),
(@my_go_guid+103,@id_Eggs,'0','1519','5148','1','3969','-8860.39','708.964','97.8055','4.89729','0','0','0.638809','-0.769365',@my_SpawnEgg,'0','1'),
(@my_go_guid+104,@id_Eggs,'0','1519','5154','1','3969','-9025.61','901.534','106.232','1.07161','0','0','0.510534','0.859857',@my_SpawnEgg,'0','1'),
(@my_go_guid+105,@id_Eggs,'0','1519','5154','1','3969','-9020.58','951.221','116.662','3.04139','0','0','0.998745','0.0500799',@my_SpawnEgg,'0','1'),
(@my_go_guid+106,@id_Eggs,'0','1519','1519','1','3969','-8896.94','970.336','120.999','5.16747','0','0','0.529371','-0.848391',@my_SpawnEgg,'0','1'),
(@my_go_guid+107,@id_Eggs,'0','1519','5148','1','3969','-8938.9','526.316','96.6755','1.69206','0','0','0.748654','0.662961',@my_SpawnEgg,'0','1'),
(@my_go_guid+108,@id_Eggs,'0','1519','5150','1','3969','-8359.91','630.297','95.2223','2.29682','0','0','0.912112','0.40994',@my_SpawnEgg,'0','1'),
(@my_go_guid+109,@id_Eggs,'0','1','2102','1','65535','-5611.78','-523.006','403.274','6.19943','0','0','0.0418642','-0.999123',@my_SpawnEgg,'0','1'),
(@my_go_guid+110,@id_Eggs,'0','1','131','1','1','-5564.79','-426.739','397.326','6.26776','0','0','0.00771244','-0.99997',@my_SpawnEgg,'0','1'),
(@my_go_guid+111,@id_Eggs,'0','1','131','1','1','-5572.77','-545.576','415.254','1.97163','0','0','0.833722','0.552185',@my_SpawnEgg,'0','1'),
(@my_go_guid+112,@id_Eggs,'0','1','131','1','1','-5583.33','-424.983','424.015','4.73859','0','0','0.697781','-0.716311',@my_SpawnEgg,'0','1'),
(@my_go_guid+113,@id_Eggs,'0','1','131','1','1','-5639.01','-462.693','397.054','4.18489','0','0','0.866999','-0.498309',@my_SpawnEgg,'0','1'),
(@my_go_guid+114,@id_Eggs,'0','1','131','1','1','-5645.44','-506.914','396.864','1.23336','0','0','0.578331','0.815802',@my_SpawnEgg,'0','1'),
(@my_go_guid+115,@id_Eggs,'0','1','131','1','1','-5631.12','-498.752','396.945','3.93513','0','0','0.922314','-0.38644',@my_SpawnEgg,'0','1'),
(@my_go_guid+116,@id_Eggs,'0','1','131','1','1','-5639.31','-531.551','405.207','1.77293','0','0','0.774842','0.632155',@my_SpawnEgg,'0','1'),
(@my_go_guid+117,@id_Eggs,'0','1','131','1','1','-5649.1','-504.692','396.804','4.70639','0','0','0.709224','-0.704983',@my_SpawnEgg,'0','1'),
(@my_go_guid+118,@id_Eggs,'0','1','2102','1','1','-5583.98','-508.261','404.374','2.41852','0','0','0.935355','0.353712',@my_SpawnEgg,'0','1'),
(@my_go_guid+119,@id_Eggs,'0','1','2102','1','1','-5587.55','-543.394','403.542','0.420469','0','0','0.208689','0.977982',@my_SpawnEgg,'0','1'),
(@my_go_guid+120,@id_Eggs,'0','1','2102','1','1','-5606.79','-548.412','393.655','3.87386','0','0','0.933718','-0.358009',@my_SpawnEgg,'0','1'),
(@my_go_guid+121,@id_Eggs,'0','1','2102','1','1','-5628.02','-535.139','389.376','1.32839','0','0','0.616424','0.787414',@my_SpawnEgg,'0','1'),
(@my_go_guid+122,@id_Eggs,'530','3430','3531','1','65535','9488.46','-6688.79','15.8262','2.33707','0','0','0.920177','0.391501',@my_SpawnEgg,'0','1'),
(@my_go_guid+123,@id_Eggs,'530','3430','3665','1','65535','9474.84','-6803.21','16.5059','6.12111','0','0','0.0809466','-0.996718',@my_SpawnEgg,'0','1'),
(@my_go_guid+124,@id_Eggs,'530','3430','3665','1','65535','9514.99','-6857.8','16.6043','4.91239','0','0','0.632982','-0.774166',@my_SpawnEgg,'0','1'),
(@my_go_guid+125,@id_Eggs,'530','3430','3665','1','65535','9554.63','-6833.24','16.4991','2.90413','0','0','0.992959','0.118455',@my_SpawnEgg,'0','1'),
(@my_go_guid+126,@id_Eggs,'530','3430','3665','1','65535','9528.35','-6804','16.4927','5.65774','0','0','0.307652','-0.951499',@my_SpawnEgg,'0','1'),
(@my_go_guid+127,@id_Eggs,'530','3430','3665','1','65535','9533.77','-6880.18','18.7516','5.40876','0','0','0.423415','-0.905936',@my_SpawnEgg,'0','1'),
(@my_go_guid+128,@id_Eggs,'530','3430','3665','1','65535','9536.09','-6871.4','26.1489','5.18728','0','0','0.520941','-0.853592',@my_SpawnEgg,'0','1'),
(@my_go_guid+129,@id_Eggs,'530','3430','5728','1','65535','9466.82','-6842.04','28.3785','1.45428','0','0','0.664734','0.74708',@my_SpawnEgg,'0','1'),
(@my_go_guid+130,@id_Eggs,'530','3430','5728','1','65535','9480.13','-6883.15','28.3385','2.78081','0','0','0.983774','0.179413',@my_SpawnEgg,'0','1'),
(@my_go_guid+131,@id_Eggs,'530','3430','5728','1','65535','9502.73','-6901.51','28.8471','5.35928','0','0','0.445699','-0.895183',@my_SpawnEgg,'0','1'),
(@my_go_guid+132,@id_Eggs,'530','3487','3487','1','65535','10022.1','-7014.97','43.267','2.69676','0','0','0.975367','0.220586',@my_SpawnEgg,'0','1'),
(@my_go_guid+133,@id_Eggs,'530','3487','3487','1','65535','10008','-7023.06','50.1388','4.05236','0','0','0.898091','-0.439809',@my_SpawnEgg,'0','1'),
(@my_go_guid+134,@id_Eggs,'530','3487','3487','1','65535','9997.81','-7042.76','45.362','5.73783','0','0','0.269313','-0.963053',@my_SpawnEgg,'0','1'),
(@my_go_guid+135,@id_Eggs,'530','3487','3487','1','65535','10013.8','-7099.15','47.7055','1.18487','0','0','0.558382','0.829584',@my_SpawnEgg,'0','1'),
(@my_go_guid+136,@id_Eggs,'530','3487','3487','1','65535','9997.38','-7123.57','47.7052','4.72859','0','0','0.701356','-0.712811',@my_SpawnEgg,'0','1'),
(@my_go_guid+137,@id_Eggs,'530','3487','3487','1','65535','9962.61','-7127.71','47.7136','1.65847','0','0','0.737414','0.675441',@my_SpawnEgg,'0','1'),
(@my_go_guid+138,@id_Eggs,'530','3487','3487','1','65535','9924.32','-7095.6','47.7434','0.249452','0','0','0.124403','0.992232',@my_SpawnEgg,'0','1'),
(@my_go_guid+139,@id_Eggs,'1','490','543','1','65535','-7448.42','-705.503','-267.577','1.06736','0','0','0.508704','0.860942',@my_SpawnEgg,'0','1'),
(@my_go_guid+140,@id_Eggs,'1','490','543','1','65535','-7360.93','-592.241','-272.001','0.973109','0','0','0.467583','0.883949',@my_SpawnEgg,'0','1'),
(@my_go_guid+141,@id_Eggs,'1','490','543','1','65535','-7156.34','-655.99','-258.869','0.600027','0','0','0.295533','0.955333',@my_SpawnEgg,'0','1'),
(@my_go_guid+142,@id_Eggs,'1','490','543','1','65535','-7138.75','-815.981','-271.109','3.93639','0','0','0.92207','-0.387023',@my_SpawnEgg,'0','1');
-- insertion the quests into the npc as givers and rewarders ( quetes 13484 et 13483 : début roturiers .... )
DELETE FROM creature_involvedrelation WHERE id IN ('32836', '32799', '32798', '32837');
DELETE FROM creature_questrelation WHERE id IN ('32836', '32799', '32798', '32837');
INSERT INTO creature_involvedrelation (id, quest) VALUES
('32836', '13502'),
('32837', '13503'),
('32798', '13479'),
('32798', '13483'), -- Commoners (patch required)
('32799', '13480'),
('32799','13484'); -- Commoners (patch required)
INSERT INTO creature_questrelation (id, quest) VALUES
('32836', '13502'),
('32799', '13480'),
('32798', '13479'),
('32837', '13503');
-- insertion the gameobjects and npc into the events tables
DELETE FROM game_event_gameobject WHERE ( game_event_gameobject.guid IN (
SELECT gameobject.guid
FROM gameobject WHERE ( gameobject.id = @id_Eggs )));
INSERT INTO game_event_gameobject (eventEntry, guid)
SELECT '9' , gameobject.guid
FROM gameobject WHERE ( gameobject.id = @id_Eggs );
DELETE FROM game_event_creature WHERE game_event_creature.guid IN (
SELECT creature.guid
FROM creature WHERE ( creature.id IN
( '32836', -- Vendeur du Jardin des nobles (alliance)
'32799', -- Collecteur du printemps (alliance)
'32798', -- Récolteur du printemps (horde)
'32837'))); -- Marchand du Jardin des nobles (horde)
INSERT INTO `game_event_creature` (eventEntry, guid)
SELECT @event_id , creature.guid
FROM creature WHERE ( creature.id IN (
'32836', -- Vendeur du Jardin des nobles (alliance)
'32799', -- Collecteur du printemps (alliance)
'32798', -- Récolteur du printemps (horde)
'32837')); -- Marchand du Jardin des nobles (horde)