Noblegarden v10.1 Emucoach

Titesusy

Veteran Member
134
2016
4
Location
France
Noblegarden



A global comment about "@SpawnEgg". In the script, it's set to 30 minutes. If the time is too short, the egg will respawn more faster, so there is no more game :/ To the opposite, if the egg has a large spawn time, one "farmer" can take all of them, preventing the respawn to "other players". So i think a respawn with 30 minutes/ 1 hour is nice.

Successfully tested achievements (horde and alliance sides):
https://www.wowhead.com/achievement=2676
https://www.wowhead.com/achievement=2417
https://www.wowhead.com/achievement=2418
https://www.wowhead.com/achievement=248
https://www.wowhead.com/achievement=2422
https://www.wowhead.com/achievement=2436
https://www.wowhead.com/achievement=2420 (Horde)
https://www.wowhead.com/achievement=2421 (Alliance)



Impossible for me to test the achievements (because i can't log multiple account)
https://www.wowhead.com/achievement=2419 (Alliance)
https://www.wowhead.com/achievement=2497 (Horde)
https://www.wowhead.com/achievement=2576

Tested but not reached achievements (buggued?) :
https://www.wowhead.com/achievement=2416



Changelogs :
- update 2019.03.01 : Changed name of one variable causing maybe some interferrence, and fixed one tippo error into the maping part of the code.
 
Last edited:

Titesusy

Veteran Member
134
2016
4
Location
France
Here the code :)

Code:
-- 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)
 
Last edited:

ExO

Admin
5,084
2014
1,442
you're welcome ! But be sure you had checked the others events too. (Some events or patchs have been made these last days)

Will do!

Tried to execute this but SQL errors, will you fix them? :)


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','0','1'),
(@my_go_guid+1,@id_Eggs,'1','215','223','1','65535','-2171.87','-47' at line 3 */

Eg seems like there are issues with eg: [MENTION=16530]Spawn[/MENTION]Egg',
 

Titesusy

Veteran Member
134
2016
4
Location
France
arf, maybe about the name ? because the forum link with the name "spawn" ? i will try it with a different variable name


EDIT : by the way, the script is just updated.
 
Last edited:

glorin

Trial Member
9
2021
1
Noblegarden



A global comment about "@SpawnEgg". In the script, it's set to 30 minutes. If the time is too short, the egg will respawn more faster, so there is no more game :/ To the opposite, if the egg has a large spawn time, one "farmer" can take all of them, preventing the respawn to "other players". So i think a respawn with 30 minutes/ 1 hour is nice.

Successfully tested achievements (horde and alliance sides):
https://www.wowhead.com/achievement=2676
https://www.wowhead.com/achievement=2417
https://www.wowhead.com/achievement=2418
https://www.wowhead.com/achievement=248
https://www.wowhead.com/achievement=2422
https://www.wowhead.com/achievement=2436
https://www.wowhead.com/achievement=2420 (Horde)
https://www.wowhead.com/achievement=2421 (Alliance)



Impossible for me to test the achievements (because i can't log multiple account)
https://www.wowhead.com/achievement=2419 (Alliance)
https://www.wowhead.com/achievement=2497 (Horde)
https://www.wowhead.com/achievement=2576

Tested but not reached achievements (buggued?) :
https://www.wowhead.com/achievement=2416



Changelogs :
- update 2019.03.01 : Changed name of one variable causing maybe some interferrence, and fixed one tippo error into the maping part of the code.
nice
 
Top