Pilgrims Bounty (v10.1)

Titesusy

Veteran Member
134
2016
4
Location
France
Pilgrims Bounty​

This is mainly a patch to "complete" the actual version of the event in V10.1 EmuCoach version. I didn't tried the achievements requiering other players around, it may works, or not :)
But we can't reach this achievement: https://www.wowhead.com/achievement=3558
maybe a script in the skills is needed?! (only the first skill is working, for every sits , but we can't share the foods : the others skills : 2, 3 , 4 ...)
 

Titesusy

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

Code:
-- Last Revision & Tests : 2019.03.01 by Titesusy
-- Tested with V10.1
-- Modificable setup STARTING HERE

SET @my_guid = 802000; -- my_guid => my_guid+300 must to be free, or you'll have a dupplication of primary key


-- Non Modifiable starting HERE

SET @idTurkey = 32820;
SET @mySpawnTurkey = 100;
SET @rangeTurkey = 20;
SET @MvtTurkey = 1;

-- Achievement completed thanks to the script: (the horde side was already scripted)
-- https://www.wowhead.com/achievement=3556 -- (Alliance)
-- https://www.wowhead.com/achievement=3580 -- (Alliance)
-- https://www.wowhead.com/achievement=3596 -- (Alliance)
-- https://www.wowhead.com/achievement=3582 -- (Both)
-- https://www.wowhead.com/achievement=3578 -- (Both)
-- https://www.wowhead.com/achievement=3558 -- (Both)

DELETE FROM creature WHERE ( id IN 
( '34645', -- Ironforge
'34681', -- Darnassus
'34682', -- Stormwind
'34710',   -- Ellen Moore, Stormwind
'34744', -- Jasper Moore , Stormwind
@idTurkey )); -- Turkeys elwynn + tirisfal

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_guid, '34645','0','0','0','1','1','0','0','-5076.66','-808.073','495.833','2.01829','300','0','0','334680','0','0','0','0','0','0','0'),
(@my_guid+1, '34681','1','1657','1657','1','1','0','0','10002.7','2225.53','1330.05','2.96795','300','0','0','334680','0','0','0','0','0','0','0'),
(@my_guid+2, '34682','0','12','12','1','1','0','0','-9126.01','354.502','93.2509','2.13348','300','0','0','334680','0','0','0','0','0','0','0'),
(@my_guid+3, '34710','0','12','12','1','1','0','34710','-9110.88','371.063','94.06','2.8537','300','0','0','334680','0','0','0','0','0','0','0'),
(@my_guid+4, '34744','0','12','12','1','1','0','0','-9116.77','363.731','93.6499','2.83721','300','0','0','334680','0','0','0','0','0','0','0'),

-- And the turkeys... (always in insert request)
(@my_guid +5 , @idTurkey ,'0','85','162','1','65535','0','0','2335.61','21.3819','23.3226','0.114088', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +6 , @idTurkey ,'0','85','85','1','65535','0','0','2262.95','48.1523','31.2914','4.12354', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +7 , @idTurkey ,'0','85','85','1','65535','0','0','2268.89','74.5562','38.3554','4.90816', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +8 , @idTurkey ,'0','85','85','1','65535','0','0','2294.16','110.395','39.4345','5.3896', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +9 , @idTurkey ,'0','85','85','1','65535','0','0','2282.11','143.502','39.1041','4.21622', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +10 , @idTurkey ,'0','85','159','1','65535','0','0','2271.64','178.337','42.3769','5.94331', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +11 , @idTurkey ,'0','85','159','1','65535','0','0','2234.04','181.709','42.7906','0.336351', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +12 , @idTurkey ,'0','85','85','1','65535','0','0','2192.53','152.883','53.604','0.680356', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +13 , @idTurkey ,'0','85','85','1','65535','0','0','2166.96','125.018','48.9782','0.586108', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +14 , @idTurkey ,'0','85','85','1','65535','0','0','2141.4','102.11','36.0801','1.29061', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +15 , @idTurkey ,'0','85','85','1','65535','0','0','2118.29','68.7745','36.4908','6.16715', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +16 , @idTurkey ,'0','85','85','1','65535','0','0','2078.22','80.1017','39.579','5.62993', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +17 , @idTurkey ,'0','85','85','1','65535','0','0','2040.83','138.14','34.6096','2.19931', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +18 , @idTurkey ,'0','85','85','1','65535','0','0','2085.5','107.777','35.2418','4.85946', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +19 , @idTurkey ,'0','85','85','1','65535','0','0','2104.43','140.625','36.596','3.64366', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +20 , @idTurkey ,'0','85','85','1','65535','0','0','2145.97','160.532','38.44','4.056', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +21 , @idTurkey ,'0','85','85','1','65535','0','0','2166.83','197.479','42.6595','5.69748', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +22 , @idTurkey ,'0','85','85','1','65535','0','0','2130.95','278.553','55.8087','3.53449', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +23 , @idTurkey ,'0','85','85','1','65535','0','0','2142.06','302.526','48.678','2.41844', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +24 , @idTurkey ,'0','85','159','1','65535','0','0','2170.72','288.34','41.9191','1.20029', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +25 , @idTurkey ,'0','85','85','1','65535','0','0','2161.38','250.036','42.818','0.377975', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +26 , @idTurkey ,'0','85','85','1','65535','0','0','2121.56','232.01','59.997','0.691349', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +27 , @idTurkey ,'0','85','85','1','65535','0','0','2084.77','221.578','52.284','5.82', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +28 , @idTurkey ,'0','85','85','1','65535','0','0','2039.67','235.925','43.9809','5.43123', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +29 , @idTurkey ,'0','85','85','1','65535','0','0','2015.05','253.274','47.1957','5.39117', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +30 , @idTurkey ,'0','85','153','1','65535','0','0','1996.05','266.225','43.2699','5.8734', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +31 , @idTurkey ,'0','85','85','1','65535','0','0','1922.94','488.442','40.6697','0.863348', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +32 , @idTurkey ,'0','85','153','1','65535','0','0','1888.71','495.13','37.5303','5.84591', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +33 , @idTurkey ,'0','85','85','1','65535','0','0','1854.72','571.896','40.9166','5.44458', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +34 , @idTurkey ,'0','85','85','1','65535','0','0','1840.06','608.352','46.5205','0.898689', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +35 , @idTurkey ,'0','85','85','1','65535','0','0','1806.71','585.865','44.9331','2.21816', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +36 , @idTurkey ,'0','85','85','1','65535','0','0','1826.47','553.08','35.474','0.844496', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +37 , @idTurkey ,'0','85','85','1','65535','0','0','1797.26','540.043','35.6303','5.98493', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +38 , @idTurkey ,'0','85','85','1','65535','0','0','1765.87','554.216','37.5508','5.78701', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +39 , @idTurkey ,'0','85','85','1','65535','0','0','1729.32','550.806','34.2319','1.78226', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +40 , @idTurkey ,'0','85','85','1','65535','0','0','2290.89','15.7968','24.024','5.77995', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +41 , @idTurkey ,'0','85','153','1','65535','0','0','1707.1','503.813','38.1476','0.182405', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +42 , @idTurkey ,'0','85','153','1','65535','0','0','1633.14','509.104','41.6697','5.49248', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +43 , @idTurkey ,'0','85','153','1','65535','0','0','1672.03','496.351','36.2205','6.1098', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +44 , @idTurkey ,'0','85','153','1','65535','0','0','1595.33','528.187','40.6875','0.341841', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +45 , @idTurkey ,'0','85','153','1','65535','0','0','1563.7','511.834','44.4487','4.81076', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +46 , @idTurkey ,'0','85','85','1','65535','0','0','1554.1','538.791','43.259','5.40216', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +47 , @idTurkey ,'0','85','85','1','65535','0','0','1592.52','556.825','39.1189','2.71296', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +48 , @idTurkey ,'0','85','85','1','65535','0','0','1644.54','538.755','34.3085','3.01534', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +49 , @idTurkey ,'0','85','153','1','65535','0','0','1693.03','532.6','34.2378','3.01534', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +50 , @idTurkey ,'0','85','153','1','65535','0','0','1733.26','522.317','35.6973','3.03183', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +51 , @idTurkey ,'0','85','153','1','65535','0','0','1772.58','511.547','33.9771','2.93758', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +52 , @idTurkey ,'0','85','153','1','65535','0','0','1811.11','502.933','34.2762','3.0389', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +53 , @idTurkey ,'0','85','153','1','65535','0','0','1859.98','498.663','35.5094','2.10506', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +54 , @idTurkey ,'0','85','153','1','65535','0','0','1882.46','469.047','35.1217','2.08856', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +55 , @idTurkey ,'0','85','153','1','65535','0','0','1881.42','437.306','34.9215','2.35639', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +56 , @idTurkey ,'0','85','153','1','65535','0','0','1902.85','414.959','34.907','1.69194', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +57 , @idTurkey ,'0','85','153','1','65535','0','0','1898.88','378.75','34.6936','2.91873', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +58 , @idTurkey ,'0','85','153','1','65535','0','0','1924.05','355.739','34.9539','0.944239', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +59 , @idTurkey ,'0','85','153','1','65535','0','0','1934.69','304.812','38.6362','4.97412', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +60 , @idTurkey ,'0','85','153','1','65535','0','0','1906.67','324.136','39.6519','1.22855', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +61 , @idTurkey ,'0','85','153','1','65535','0','0','1889.61','287.118','52.2065','1.12959', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +62 , @idTurkey ,'0','85','153','1','65535','0','0','1876.69','259.697','60.2571','2.25978', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +63 , @idTurkey ,'0','85','153','1','65535','0','0','1905.94','253.35','54.9555','3.0067', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +64 , @idTurkey ,'0','85','153','1','65535','0','0','1938.51','248.244','45.5181','4.27826', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +65 , @idTurkey ,'0','85','153','1','65535','0','0','1951.06','276.134','39.2137','2.13333', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +66 , @idTurkey ,'0','85','153','1','65535','0','0','1967.22','248.909','38.4886','4.33088', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +67 , @idTurkey ,'0','85','85','1','65535','0','0','1997.32','67.7955','36.5528','1.16651', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +68 , @idTurkey ,'0','85','85','1','65535','0','0','1979.28','34.06','28.6875','2.22365', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +69 , @idTurkey ,'0','85','85','1','65535','0','0','2037.02','-270.485','37.7165','4.33794', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +70 , @idTurkey ,'0','85','85','1','65535','0','0','2041.59','-233.433','37.6435','4.40392', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +71 , @idTurkey ,'0','85','85','1','65535','0','0','2057.15','-202.398','37.783','4.20835', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +72 , @idTurkey ,'0','85','85','1','65535','0','0','2073.57','-169.372','40.5196','5.00632', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +73 , @idTurkey ,'0','85','85','1','65535','0','0','2089.96','-121.536','39.7223','4.89558', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +74 , @idTurkey ,'0','85','85','1','65535','0','0','2055.01','-46.386','37.4727','0.743176', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +75 , @idTurkey ,'0','85','85','1','65535','0','0','2034.04','-77.8688','34.0294','1.44297', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +76 , @idTurkey ,'0','85','85','1','65535','0','0','2024.69','-106.925','34.5447','0.80915', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +77 , @idTurkey ,'0','85','85','1','65535','0','0','2011.87','-152.976','33.6215','1.05184', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +78 , @idTurkey ,'0','85','85','1','65535','0','0','1990.7','-196.596','35.7436','1.08247', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +79 , @idTurkey ,'0','85','85','1','65535','0','0','1975.68','-232.698','33.4601','1.27332', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +80 , @idTurkey ,'0','85','85','1','65535','0','0','1957.46','-271.719','36.9994','0.827999', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +81 , @idTurkey ,'0','85','165','1','65535','0','0','1930.42','-303.683','35.3715','0.533475', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +82 , @idTurkey ,'0','85','85','1','65535','0','0','1899.91','-303.55','36.1403','2.88967', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +83 , @idTurkey ,'0','85','85','1','65535','0','0','1934.21','-259.275','35.2081','3.74968', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +84 , @idTurkey ,'0','85','85','1','65535','0','0','1956.61','-207.317','34.5548','4.19264', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +85 , @idTurkey ,'0','85','85','1','65535','0','0','1976.17','-166.305','32.4496','4.31988', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +86 , @idTurkey ,'0','85','85','1','65535','0','0','1993.94','-122.001','33.2357','4.21149', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +87 , @idTurkey ,'0','85','85','1','65535','0','0','2007.87','-82.4855','33.5444','4.25391', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +88 , @idTurkey ,'0','85','85','1','65535','0','0','2022.65','-41.4562','33.994','4.21856', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +89 , @idTurkey ,'0','85','85','1','65535','0','0','2037.03','-2.34279','38.5236','5.10999', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +90 , @idTurkey ,'0','85','85','1','65535','0','0','2073.08','51.4019','34.6731','1.79482', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +91 , @idTurkey ,'0','85','85','1','65535','0','0','2075.26','-14.4843','41.2711','1.17514', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +92 , @idTurkey ,'0','85','85','1','65535','0','0','2069.72','-54.1689','39.7443','1.33615', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +93 , @idTurkey ,'0','85','85','1','65535','0','0','2052.51','-110.821','34.4734','1.27018', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +94 , @idTurkey ,'0','85','85','1','65535','0','0','2038.66','-155.501','36.9008','1.27018', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +95 , @idTurkey ,'0','85','85','1','65535','0','0','2016.02','-208.292','36.1458','1.17593', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +96 , @idTurkey ,'0','85','85','1','65535','0','0','1993.8','-247.04','34.0493','1.13823', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +97 , @idTurkey ,'0','85','85','1','65535','0','0','1982.33','-281.548','36.1294','1.11938', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +98 , @idTurkey ,'0','85','165','1','65535','0','0','1970.89','-315.055','36.9112','1.02513', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +99 , @idTurkey ,'0','85','165','1','65535','0','0','1925.09','-384.021','35.218','5.01731', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +100 , @idTurkey ,'0','85','165','1','65535','0','0','1937.77','-342.754','36.014','0.504413', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +101 , @idTurkey ,'0','85','85','1','65535','0','0','1895.07','-332.792','39.9986','0.113285', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +102 , @idTurkey ,'0','85','85','1','65535','0','0','1858.36','-336.032','34.5575','1.12566', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +103 , @idTurkey ,'0','85','165','1','65535','0','0','1856.61','-376.857','37.8061','3.76382', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +104 , @idTurkey ,'0','85','165','1','65535','0','0','1894.44','-398.748','34.5454','1.172', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +105 , @idTurkey ,'0','85','165','1','65535','0','0','1880.27','-448.849','39.4705','0.760452', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +106 , @idTurkey ,'0','85','85','1','65535','0','0','1846.21','-479.546','36.7686','0.92303', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +107 , @idTurkey ,'0','85','85','1','65535','0','0','1819.78','-507.257','36.3881','0.689766', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +108 , @idTurkey ,'0','85','85','1','65535','0','0','1787.64','-527.819','41.1447','0.180828', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +109 , @idTurkey ,'0','85','85','1','65535','0','0','1760.32','-543.897','40.0913','2.04851', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +110 , @idTurkey ,'0','85','85','1','65535','0','0','1773.11','-573.982','40.003','1.77754', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +111 , @idTurkey ,'0','85','85','1','65535','0','0','1774.79','-601.486','40.2324','0.89397', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +112 , @idTurkey ,'0','85','85','1','65535','0','0','1737.16','-623.943','44.7494','5.12334', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +113 , @idTurkey ,'0','85','85','1','65535','0','0','1723.33','-586.673','40.3669','4.48245', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +114 , @idTurkey ,'0','85','85','1','65535','0','0','1740','-551.264','38.9162','4.21149', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +115 , @idTurkey ,'0','85','85','1','65535','0','0','1757.88','-518.542','41.1651','4.09133', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +116 , @idTurkey ,'0','85','85','1','65535','0','0','1779.08','-478.24','37.5256','4.31516', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +117 , @idTurkey ,'0','85','85','1','65535','0','0','1798.34','-442.121','33.8351','1.02827', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +118 , @idTurkey ,'0','85','85','1','65535','0','0','1820.75','-478.487','37.5125','4.26804', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +119 , @idTurkey ,'0','85','165','1','65535','0','0','1841.03','-443.939','33.0143','4.42119', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +120 , @idTurkey ,'0','85','165','1','65535','0','0','1837.18','-408.086','33.1718','0.196536', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +121 , @idTurkey ,'0','85','85','1','65535','0','0','1782.08','-413.678','33.3702','1.09739', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +122 , @idTurkey ,'0','85','85','1','65535','0','0','1766.23','-442.801','33.2661','1.09739', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +123 , @idTurkey ,'0','85','85','1','65535','0','0','1750.22','-470.19','36.8193','2.2637', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +124 , @idTurkey ,'0','85','85','1','65535','0','0','1743.42','-502.182','41.833','0.809932', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +125 , @idTurkey ,'0','85','85','1','65535','0','0','1715.3','-529.876','38.6086','1.01021', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +126 , @idTurkey ,'0','85','85','1','65535','0','0','1705.19','-573.749','43.8664','1.57334', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +127 , @idTurkey ,'0','85','85','1','65535','0','0','1706.9','-608.226','44.9006','1.68172', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +128 , @idTurkey ,'0','85','85','1','65535','0','0','1858.18','-154.65','39.3584','2.09796', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +129 , @idTurkey ,'0','85','85','1','65535','0','0','1883.2','-140.096','36.0855','4.56018', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +130 , @idTurkey ,'0','85','85','1','65535','0','0','1885.65','-102.552','34.1313','4.8712', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +131 , @idTurkey ,'0','85','85','1','65535','0','0','1879.31','-59.627','37.1735','5.10211', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +132 , @idTurkey ,'0','85','85','1','65535','0','0','1930.63','-25.7485','13.3092','0.559373', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +133 , @idTurkey ,'0','85','85','1','65535','0','0','1918.15','-76.4625','30.9887','1.41703', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +134 , @idTurkey ,'0','85','85','1','65535','0','0','1912.15','-115.191','36.0618','1.41703', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +135 , @idTurkey ,'0','85','85','1','65535','0','0','1906.27','-153.121','36.0033','1.41703', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +136 , @idTurkey ,'0','85','85','1','65535','0','0','1896.4','-191.745','35.8056','1.03532', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +137 , @idTurkey ,'0','85','85','1','65535','0','0','1878.12','-231.287','36.6351','1.60552', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +138 , @idTurkey ,'0','85','85','1','65535','0','0','1823','-283.957','42.432','2.64146', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +139 , @idTurkey ,'0','85','85','1','65535','0','0','1845.02','-311.014','33.2034','3.99078', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +140 , @idTurkey ,'0','85','85','1','65535','0','0','1887.94','-259.372','33.1146','4.04026', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +141 , @idTurkey ,'0','85','85','1','65535','0','0','1909.53','-232.263','34.4738','4.13922', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +142 , @idTurkey ,'0','85','85','1','65535','0','0','1928.51','-201.916','34.3584','4.19812', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +143 , @idTurkey ,'0','85','85','1','65535','0','0','1945.05','-171.052','34.0411','4.29944', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +144 , @idTurkey ,'0','85','85','1','65535','0','0','1959.46','-139.268','35.2003','4.36777', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +145 , @idTurkey ,'0','85','85','1','65535','0','0','1972.18','-103.824','35.5329','4.36777', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +146 , @idTurkey ,'0','85','85','1','65535','0','0','1986.74','-62.2658','33.3688','4.70471', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +147 , @idTurkey ,'0','85','85','1','65535','0','0','1996.87','-25.0244','37.8411','4.51385', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +148 , @idTurkey ,'0','85','4919','1','65535','0','0','2014.27','14.7092','33.9261','4.07796', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +149 , @idTurkey ,'0','85','4919','1','65535','0','0','2054.02','32.2547','38.2487','3.60201', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +150 , @idTurkey ,'0','85','4919','1','65535','0','0','2055.19','64.3285','37.4329','5.2537', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +151 , @idTurkey ,'0','85','4919','1','65535','0','0','2045.63','91.3872','34.221','6.02889', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +152 , @idTurkey ,'0','85','4919','1','65535','0','0','2011.53','109.045','34.5482','5.97941', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +153 , @idTurkey ,'0','85','85','1','65535','0','0','1982.48','122.424','21.76','5.75321', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +154 , @idTurkey ,'0','85','85','1','65535','0','0','1943.83','136.276','12.3252','6.109', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +155 , @idTurkey ,'0','85','153','1','65535','0','0','1887.52','102.54','37.878','1.15942', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +156 , @idTurkey ,'0','85','153','1','65535','0','0','1876.03','36.0187','45.4333','1.31728', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +157 , @idTurkey ,'0','85','85','1','65535','0','0','1839.44','-39.6985','38.4847','2.30924', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +158 , @idTurkey ,'0','85','85','1','65535','0','0','1858.08','-118.484','44.3294','0.947362', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +159 , @idTurkey ,'0','85','85','1','65535','0','0','1835.91','-160.05','43.2125','1.65186', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +160 , @idTurkey ,'0','85','85','1','65535','0','0','1743.82','-298.021','42.1627','1.40996', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +161 , @idTurkey ,'0','85','85','1','65535','0','0','1791.9','-283.609','41.5118','0.0410129', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +162 , @idTurkey ,'0','85','85','1','65535','0','0','1864.83','-192.513','45.4658','1.66129', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +163 , @idTurkey ,'0','85','85','1','65535','0','0','1857.17','-261.638','38.7545','1.24738', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +164 , @idTurkey ,'0','85','85','1','65535','0','0','1688.28','-369.21','42.7397','0.290769', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +165 , @idTurkey ,'0','85','85','1','65535','0','0','1653.32','-389.306','44.9979','1.21911', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +166 , @idTurkey ,'0','85','85','1','65535','0','0','1645.58','-425.63','44.9979','2.9949', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +167 , @idTurkey ,'0','85','85','1','65535','0','0','1675.26','-451.07','44.9625','0.912019', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +168 , @idTurkey ,'0','85','85','1','65535','0','0','1641.85','-477.098','45.9011','4.01905', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +169 , @idTurkey ,'0','85','85','1','65535','0','0','1617.86','-467.634','48.2755','4.67722', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +170 , @idTurkey ,'0','85','85','1','65535','0','0','1609.8','-417.095','48.6432','5.06128', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +171 , @idTurkey ,'0','85','85','1','65535','0','0','1612.33','-374.022','46.6586','4.24368', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +172 , @idTurkey ,'0','85','85','1','65535','0','0','1633.46','-348.931','46.407','4.24132', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +173 , @idTurkey ,'0','85','85','1','65535','0','0','1662.48','-332.974','45.9391','2.57313', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +174 , @idTurkey ,'0','85','85','1','65535','0','0','1696.64','-339.399','40.4394','2.79226', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +175 , @idTurkey ,'0','85','85','1','65535','0','0','1716.4','-369.889','37.8128','3.36717', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +176 , @idTurkey ,'0','85','85','1','65535','0','0','1757.7','-359.033','34.7039','2.66267', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +177 , @idTurkey ,'0','85','85','1','65535','0','0','1806.71','-391.245','33.2627','3.90046', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +178 , @idTurkey ,'0','85','85','1','65535','0','0','1830.57','-361.886','34.7112','4.79346', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +179 , @idTurkey ,'0','85','85','1','65535','0','0','1811','-344.122','34.1211','0.958357', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +180 , @idTurkey ,'0','85','85','1','65535','0','0','1795.3','-362.033','34.0539','0.680326', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +181 , @idTurkey ,'0','85','85','1','65535','0','0','1763.13','-391.702','34.0296','0.885315', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +182 , @idTurkey ,'0','85','85','1','65535','0','0','1734.92','-430.132','33.2233','0.998412', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +183 , @idTurkey ,'0','85','85','1','65535','0','0','1700.4','-469.518','39.2581','0.503611', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +184 , @idTurkey ,'0','85','85','1','65535','0','0','1686.93','-508.473','39.9261','1.30001', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +185 , @idTurkey ,'0','85','85','1','65535','0','0','1671.05','-587.036','43.2806','4.7911', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +186 , @idTurkey ,'0','85','85','1','65535','0','0','1670','-549.253','44.8349','4.61439', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +187 , @idTurkey ,'0','85','85','1','65535','0','0','1656.82','-515.397','44.9922','5.71237', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +188 , @idTurkey ,'0','85','85','1','65535','0','0','1620.81','-505.475','49.7771','1.58511', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +189 , @idTurkey ,'0','85','85','1','65535','0','0','1632.24','-541.631','46.2781','1.92675', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +190 , @idTurkey ,'0','85','85','1','65535','0','0','1632.51','-576.339','45.4082','1.5639', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +191 , @idTurkey ,'0','85','85','1','65535','0','0','1651.73','-611.036','47.5642','2.10111', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +192 , @idTurkey ,'0','85','85','1','65535','0','0','1675.6','-632.094','44.8113','2.62183', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +193 , @idTurkey ,'0','12','12','1','65535','0','0','-9569.67','-479.88','61.5857','1.27348', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +194 , @idTurkey ,'0','12','12','1','65535','0','0','-9584.72','-529.43','59.0524','1.68581', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +195 , @idTurkey ,'0','12','91','1','65535','0','0','-9596.68','-577.523','55.7309','1.74865', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +196 , @idTurkey ,'0','12','91','1','65535','0','0','-9588.47','-622.723','56.9417','1.80991', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +197 , @idTurkey ,'0','12','91','1','65535','0','0','-9578.56','-668.737','59.7523','0.146433', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +198 , @idTurkey ,'0','12','91','1','65535','0','0','-9620.68','-703.575','47.1694','1.10069', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +199 , @idTurkey ,'0','12','91','1','65535','0','0','-9628.31','-768.389','45.0534','2.47828', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +200 , @idTurkey ,'0','12','91','1','65535','0','0','-9582.97','-802.222','41.5324','1.29311', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +201 , @idTurkey ,'0','12','12','1','65535','0','0','-9574.42','-847.286','46.0351','2.12485', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +202 , @idTurkey ,'0','12','12','1','65535','0','0','-9544.64','-928.927','45.3257','1.62769', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +203 , @idTurkey ,'0','12','12','1','65535','0','0','-9542.98','-971.104','49.904','1.31903', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +204 , @idTurkey ,'0','12','12','1','65535','0','0','-9559.62','-1005.85','49.0707','0.418966', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +205 , @idTurkey ,'0','12','12','1','65535','0','0','-9596.65','-1027.22','46.6047','6.10603', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +206 , @idTurkey ,'0','12','12','1','65535','0','0','-9658.01','-1011.59','41.5913','6.02592', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +207 , @idTurkey ,'0','12','12','1','65535','0','0','-9703.56','-1002.24','42.5138','5.54762', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +208 , @idTurkey ,'0','12','62','1','65535','0','0','-9829.36','-954.307','37.9846','6.05655', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +209 , @idTurkey ,'0','12','62','1','65535','0','0','-9899.09','-917.819','29.399','0.953823', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +210 , @idTurkey ,'0','12','62','1','65535','0','0','-9916.38','-975.062','22.8836','1.40386', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +211 , @idTurkey ,'0','12','62','1','65535','0','0','-9925.66','-1031.62','22.454','3.97996', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +212 , @idTurkey ,'0','12','62','1','65535','0','0','-9889.98','-1003.21','29.8486','3.62653', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +213 , @idTurkey ,'0','12','62','1','65535','0','0','-9850.63','-992.865','36.7834','3.3862', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +214 , @idTurkey ,'0','12','62','1','65535','0','0','-9813.31','-987.054','40.1299','3.24719', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +215 , @idTurkey ,'0','12','62','1','65535','0','0','-9782.84','-978.295','40.6841','3.34615', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +216 , @idTurkey ,'0','12','62','1','65535','0','0','-9733.4','-978.767','41.1977','3.22598', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +217 , @idTurkey ,'0','12','62','1','65535','0','0','-9683.43','-975.386','43.9943','3.30609', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +218 , @idTurkey ,'0','12','62','1','65535','0','0','-9638.02','-959.752','48.6373','4.26506', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +219 , @idTurkey ,'0','12','12','1','65535','0','0','-9614.27','-915.977','48.7083','5.1612', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +220 , @idTurkey ,'0','12','12','1','65535','0','0','-9622.17','-865.68','48.5106','5.57825', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +221 , @idTurkey ,'0','12','12','1','65535','0','0','-9647.79','-833.072','46.8923','4.76065', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +222 , @idTurkey ,'0','12','62','1','65535','0','0','-9680.06','-784.992','46.947','6.07069', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +223 , @idTurkey ,'0','12','62','1','65535','0','0','-9731.81','-787.187','41.4764','6.16259', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +224 , @idTurkey ,'0','12','62','1','65535','0','0','-9793.42','-815.557','41.4734','5.87277', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +225 , @idTurkey ,'0','12','62','1','65535','0','0','-9851.99','-779.398','34.6051','4.5266', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +226 , @idTurkey ,'0','12','62','1','65535','0','0','-9837.3','-733.439','32.6382','3.66188', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +227 , @idTurkey ,'0','12','62','1','65535','0','0','-9804.17','-720.186','35.5712','3.11524', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +228 , @idTurkey ,'0','12','62','1','65535','0','0','-9757.42','-717.744','39.8564','3.24954', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +229 , @idTurkey ,'0','12','12','1','65535','0','0','-9683.07','-712.068','48.5947','5.11879', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +230 , @idTurkey ,'0','12','12','1','65535','0','0','-9691.13','-668.43','47.5317','4.57215', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +231 , @idTurkey ,'0','12','12','1','65535','0','0','-9660.56','-624.239','54.561','3.90535', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +232 , @idTurkey ,'0','12','12','1','65535','0','0','-9654','-562.797','54.1919','5.23424', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +233 , @idTurkey ,'0','12','12','1','65535','0','0','-9697.52','-549.456','47.902','0.656944', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +234 , @idTurkey ,'0','12','12','1','65535','0','0','-9746.11','-575.087','41.0892','0.0726079', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +235 , @idTurkey ,'0','12','12','1','65535','0','0','-9779.42','-589.967','36.0536','6.23327', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +236 , @idTurkey ,'0','12','12','1','65535','0','0','-9813.03','-573.726','28.9589','4.26114', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +237 , @idTurkey ,'0','12','12','1','65535','0','0','-9812.82','-531.164','28.5943','5.01041', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +238 , @idTurkey ,'0','12','12','1','65535','0','0','-9842.24','-483.607','31.7227','5.50521', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +239 , @idTurkey ,'0','12','12','1','65535','0','0','-9882.24','-467.571','25.88','5.49107', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +240 , @idTurkey ,'0','12','12','1','65535','0','0','-9920.58','-415.717','25.0209','4.82662', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +241 , @idTurkey ,'0','12','12','1','65535','0','0','-9888.79','-406.271','33.7452','2.74846', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +242 , @idTurkey ,'0','12','12','1','65535','0','0','-9851.66','-418.393','34.2924','4.75279', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +243 , @idTurkey ,'0','12','12','1','65535','0','0','-9854.48','-388.653','34.6581','4.83055', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +244 , @idTurkey ,'0','12','12','1','65535','0','0','-9858.95','-345.851','36.8778','4.7151', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +245 , @idTurkey ,'0','12','12','1','65535','0','0','-9835.1','-276.102','38.6885','2.33769', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +246 , @idTurkey ,'0','12','12','1','65535','0','0','-9147.89','415.67','93.6798','1.93478', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +247 , @idTurkey ,'0','12','12','1','65535','0','0','-9164.04','437.071','93.6997','2.21046', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +248 , @idTurkey ,'0','12','12','1','65535','0','0','-9178.05','410.197','88.7159','4.46455', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +249 , @idTurkey ,'0','12','12','1','65535','0','0','-9188.67','372.463','74.8083','4.24071', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +250 , @idTurkey ,'0','12','12','1','65535','0','0','-9218.02','351.82','73.5478','3.0956', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +251 , @idTurkey ,'0','12','12','1','65535','0','0','-9226.68','321.313','73.7688','4.05693', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +252 , @idTurkey ,'0','12','12','1','65535','0','0','-9204.89','290.993','75.5284','4.95464', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +253 , @idTurkey ,'0','12','12','1','65535','0','0','-9247.61','271.289','71.2982','3.537', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +254 , @idTurkey ,'0','12','12','1','65535','0','0','-9274.29','236.065','68.22','4.95307', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +255 , @idTurkey ,'0','12','12','1','65535','0','0','-9253.95','205.605','69.2176','5.07088', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +256 , @idTurkey ,'0','12','12','1','65535','0','0','-9309.77','204.789','66.4957','3.04377', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +257 , @idTurkey ,'0','12','12','1','65535','0','0','-9327.38','245.326','66.5914','1.95049', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +258 , @idTurkey ,'0','12','12','1','65535','0','0','-9335.26','290.272','68.3023','1.24128', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +259 , @idTurkey ,'0','12','12','1','65535','0','0','-9370.75','326.318','61.5118','2.3212', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +260 , @idTurkey ,'0','12','92','1','65535','0','0','-9405.47','363.291','50.0797','2.63222', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +261 , @idTurkey ,'0','12','12','1','65535','0','0','-9430.78','329.629','55.3293','4.7363', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +262 , @idTurkey ,'0','12','12','1','65535','0','0','-9430.23','291.147','59.4123','4.67975', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +263 , @idTurkey ,'0','12','12','1','65535','0','0','-9442.95','251.61','60.2234','4.20616', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +264 , @idTurkey ,'0','12','87','1','65535','0','0','-9458.57','191.217','57.9102','3.8056', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +265 , @idTurkey ,'0','12','12','1','65535','0','0','-9514.44','171.667','57.7636','4.04122', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +266 , @idTurkey ,'0','12','12','1','65535','0','0','-9534.65','135.949','59.0188','3.87393', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +267 , @idTurkey ,'0','12','87','1','65535','0','0','-9559.12','88.8698','58.8816','4.81641', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +268 , @idTurkey ,'0','12','87','1','65535','0','0','-9561.34','46.7429','59.3169','4.71038', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +269 , @idTurkey ,'0','12','12','1','65535','0','0','-9585.95','19.4274','60.3182','4.07892', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +270 , @idTurkey ,'0','12','12','1','65535','0','0','-9572.94','-16.5111','63.0551','4.58315', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +271 , @idTurkey ,'0','12','12','1','65535','0','0','-9596.43','-61.1551','60.3601','4.12133', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +272 , @idTurkey ,'0','12','12','1','65535','0','0','-9612.13','-108.54','59.6092','4.38523', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +273 , @idTurkey ,'0','12','12','1','65535','0','0','-9620.7','-149.514','58.2841','4.19202', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +274 , @idTurkey ,'0','12','12','1','65535','0','0','-9640.97','-196.464','54.3354','4.53838', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +275 , @idTurkey ,'0','12','12','1','65535','0','0','-9669.29','-246.294','61.3451','3.91163', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +276 , @idTurkey ,'0','12','12','1','65535','0','0','-9697.69','-283.988','58.7762','4.11427', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +277 , @idTurkey ,'0','12','12','1','65535','0','0','-9735.88','-303.265','49.7923','3.47574', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +278 , @idTurkey ,'0','12','12','1','65535','0','0','-9855.23','-302.144','37.2969','4.50304', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_guid +279 , @idTurkey ,'0','12','12','1','65535','0','0','-9791.75','-301.168','46.2977','3.08225', @mySpawnTurkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0');


-- insertion the npcs into the events database (delete + insertion)
DELETE FROM game_event_creature WHERE game_event_creature.guid IN (
SELECT creature.guid
FROM creature WHERE ( creature.id IN
( '34645', -- Ironforge
'34681', -- Darnassus
'34682', -- Stormwind
'34710',   -- Ellen Moore, Stormwind
'34744', -- Jasper Moore , Stormwind
@idTurkey ))); -- Turkeys elwynn + tirisfal

INSERT INTO `game_event_creature` (eventEntry, guid)
SELECT '26' , creature.guid
FROM creature WHERE ( creature.id IN
( '34645', -- Ironforge
'34681', -- Darnassus
'34682', -- Stormwind
'34710',   -- Ellen Moore, Stormwind
'34744', -- Jasper Moore , Stormwind
@idTurkey )); -- Turkeys elwynn + tirisfal
 
Last edited:

Titesusy

Veteran Member
134
2016
4
Location
France
updates :
- version 2019.02.23: Alliance's NPCS added + Delete of previous Turkeys and put them in Elwynn Forest + Tirisfal like in official : https://www.wowhead.com/npc=32820
But those turkeys couldn't (for me) possible to add all of them manually, so there are actually 250 of 800. But the turkey slayer achievement is reachable, so it's satisfying (for me)

- version 2019.03.01: Updated code errors caused by typo mistakes. (changed name of [MENTION=16530]Spawn[/MENTION]Turkey to @mySpawnTurkey, and fixed some error with numbers in database (previously, there wasn't quotes, but now it's ok)
 
Last edited:

ExO

Admin
5,084
2014
1,442
[MENTION=13745]Titesusy[/MENTION]

Can you check the SQL? Seems like there are errors

-- Turkeys elwynn + tirisfal


(@my_guid+10, @idTurkey,0,12,12,1,65535,0,0,-9640.97,-196.464,54.3354,4.53838 [MENTION=16530]Spawn[/MENTION]Turkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','/* large SQL query (41.5 KiB), snipped at 2,000 characters */
/* SQL Error (1064): 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 [MENTION=16530]Spawn[/MENTION]Turkey, @rangeTurkey,'0','2','0',@MvtTurkey,'0','0','0','0','0'),
(@my_gu' at line 12 */

Can you fix them, then I will re-execute the SQL :)
 

Titesusy

Veteran Member
134
2016
4
Location
France
yes, it will be fixed in few minutes :) there was a typo mistake between my sql program (navicat) and the code in the forum.
 
Top