search

Looking4Group / L4G_Core

Looking4Group Core
http://looking4group.eu
GNU General Public License v2.0
37 stars 69 forks source link

Gas clouds - (Arcane Vortex/Felmist/Swamp Gas/Windy Cloud) #2116

Open Xadras opened 8 years ago

Xadras commented 8 years ago

http://wowwiki.wikia.com/wiki/Gas_cloud , http://wowwiki.wikia.com/wiki/Zapthrottle_Mote_Extractor

http://wowwiki.wikia.com/wiki/Patch_2.3.0

Patch 2.3.0 (13-Nov-2007): Windy Clouds in Nagrand now produce [Motes of Air].

Patch 2.3.0 (13-Nov-2007): Gas clouds in Zangarmarsh now produce [Motes of Water] instead of [Motes of Life].

Xadras commented 8 years ago

Done

Windy Cloud:

https://db.rising-gods.de/?maps=3518:4404606207616907006905705203005003805204913314313194662815804267844615904802504304713518036545042706115604503582876547375508016826255422336585632163303432672504233015902996214856675767722472952245123632487054316253925714776414625192173843104182402753612993303563922996523718074706995866297005125994274882835112524152994705594262675375084467536466136616645168155867306027846047103226294903063122604703763353964265285506446697726176446435826725826876567186647186915792602397612504305807806207602203404906603005903402703006205634366595555422252504305807806207602203404906603005903402703006205634366595555422255807514327722846132554384932996935656637496047824725595604716506095408003016113702795312425907125518003126094203106805616595703006293312815415007004404417594312715315106606604302835208113602405494604707202504305807806207602203404906603005903402703006205634366595555422252502813843084182405182175412426253945714716414627044336836252846115807806207602203404906603005903402703006205634366595555422252502813843084092445182175412426253945714716414627044336866525122994535963618115937147025223383945198296727706456696765906515902873663106674285263226295516446106467250430580780620760220340490660300590340270300620563436659555542225693667680563693462621605356299319326250430580780620760220340490660300590340270300620563436659555542225693667680563693462621605356299319326250430580780620760220340490660300590340270300620563436659555542225250281384308418240518217541242625394571471641462704433683625512299453596361811601710702522250430580780620760220340490660300590340270300620563436659555542225250281384308418240518217541242625394571471641462704433683625512299453596

http://de.tinypic.com/view.php?pic=7yhet8z&s=1#.V9a2y62hSUk

Felmist

http://www.wow-strategy.com/insane-gold-farming/

Felmist complete: http://www.wowhead.com/npc=17407/felmist#comments : https://db.rising-gods.de/?maps=3520:614587614592487207568464466470573743522210525222384419389420642466650361518208467521581455495330420426469537214327533341349344622631649612466378430490560540300450620374542506450380350450280360431729570190328378342412512524446627607477566376363370363491621213651304614587614592487207568464466470573743522210525222384419389420642466650361518208467521581455495330420426469537214327533341349344622631649612466378430490560540300450620374542506450380350450280360431729570190328378342412512524446627607477566376363370363491621213651304614587614592613583568460466470570461522210525222384419389420642466634466646471640474642470638474518208467521471535581455495330420426469537214327533341349344622631649612466378430490560540300450620374542506450380350450280360431729570190328378342412614587566363509520568460466470485207522210620211384419363370642466651304363491573743651363607479467521471535581455495330420426214327533341349344622631649612466378430490560540300450620374542506450380350450280360431729570190328378342412391277593675463586591368441621

#!sql

-- Windy Cloud
-- https://bitbucket.org/looking4group_b2tbc/looking4group/issues/2403/npc-missing-vendor-item-drop-item-trainer Spawns
--
-- Windy Cloud
UPDATE `creature_template` SET `unit_flags`=`unit_flags`|'256'|'512'|'32768'|'33554432',`MovementType`='1' WHERE `entry` = 24222; -- 32768
INSERT IGNORE INTO `creature_template_addon` VALUES
(24222,0,0,16777472,0,4097,0,0,'');
--
UPDATE `creature` SET `spawntimesecs`='900' WHERE `id` = 24222; -- 3600
DELETE FROM `creature` WHERE `guid` BETWEEN 140601 AND 140622;
-- 32 Windy Cloud Spawns
SET @GUID := 140601;
INSERT INTO `creature` VALUES (@GUID := @GUID + 0, 24222, 530, 1, 0, 0, -1533.7329, 6369.8935, 77.6436, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -1880.1965, 6415.6181, 51.1248, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -1666.3409, 6767.5034, -7.6006, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -1412.7789, 6872.9023, 22.0742, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -558.2117, 8848.8232, 307.7323, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -1037.4024, 8959.2158, 98.4896, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -1541.7697, 9476.0996, 477.0890, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -1863.4951, 9053.9423, 72.3042, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -2755.5195, 8960.7558, 14.9967, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -1274.0355, 9965.7451, 276.0653, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -1909.5537, 7905.9433, 61.3013, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -2367.1943, 7202.4086, 43.9668, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -1661.2734, 8545.5673, -14.7632, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -2070.9245, 6541.8271, 20.3846, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -2803.8540, 6583.5644, 35.5174, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -2522.1479, 6416.3344, 203.8655, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -1931.3232, 8855.9765, 31.6673, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -1928.3510, 9085.7080, 291.5415, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -1000.0269, 8885.9755, 309.1237, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -1355.4300, 6243.0019, 264.3694, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -2821.8842, 8212.4746, 202.8714, 1.337, 3600, 40, 0, 1, 0, 0, 1);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24222, 530, 1, 0, 0, -2499.7490, 8631.8759, 193.3694, 1.337, 3600, 40, 0, 1, 0, 0, 1);

DELETE FROM `pool_creature` WHERE `pool_entry` = 30043;
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES
(7202, 30043, 0, 'Windy Cloud - Nagrand'),
(9740, 30043, 0, 'Windy Cloud - Nagrand'),
(9741, 30043, 0, 'Windy Cloud - Nagrand'),
(13050, 30043, 0, 'Windy Cloud - Nagrand'),
(14241, 30043, 0, 'Windy Cloud - Nagrand'),
(14324, 30043, 0, 'Windy Cloud - Nagrand'),
(14325, 30043, 0, 'Windy Cloud - Nagrand'),
(14326, 30043, 0, 'Windy Cloud - Nagrand'),
(14327, 30043, 0, 'Windy Cloud - Nagrand'),
(14328, 30043, 0, 'Windy Cloud - Nagrand'),
(14329, 30043, 0, 'Windy Cloud - Nagrand'),
(14330, 30043, 0, 'Windy Cloud - Nagrand'),
(14331, 30043, 0, 'Windy Cloud - Nagrand'),
(14332, 30043, 0, 'Windy Cloud - Nagrand'),
(14730, 30043, 0, 'Windy Cloud - Nagrand'),
(14731, 30043, 0, 'Windy Cloud - Nagrand'),
(52399, 30043, 0, 'Windy Cloud - Nagrand'),
(52400, 30043, 0, 'Windy Cloud - Nagrand'),
(52401, 30043, 0, 'Windy Cloud - Nagrand'),
(52402, 30043, 0, 'Windy Cloud - Nagrand'),
(52403, 30043, 0, 'Windy Cloud - Nagrand'),
(52404, 30043, 0, 'Windy Cloud - Nagrand'),
(99969, 30043, 0, 'Windy Cloud - Nagrand'),
(99970, 30043, 0, 'Windy Cloud - Nagrand'),
-- (99971, 30043, 0, 'Windy Cloud - Nagrand'),
(43598, 30043, 0, 'Windy Cloud - Nagrand'),
(99972, 30043, 0, 'Windy Cloud - Nagrand'),
(99973, 30043, 0, 'Windy Cloud - Nagrand'),
(99974, 30043, 0, 'Windy Cloud - Nagrand'),
(140601, 30043, 0, 'Windy Cloud - Nagrand'),
(140602, 30043, 0, 'Windy Cloud - Nagrand'),
(140603, 30043, 0, 'Windy Cloud - Nagrand'),
(140604, 30043, 0, 'Windy Cloud - Nagrand'),
(140605, 30043, 0, 'Windy Cloud - Nagrand'),
(140606, 30043, 0, 'Windy Cloud - Nagrand'),
(140607, 30043, 0, 'Windy Cloud - Nagrand'),
(140608, 30043, 0, 'Windy Cloud - Nagrand'),
(140609, 30043, 0, 'Windy Cloud - Nagrand'),
(140610, 30043, 0, 'Windy Cloud - Nagrand'),
(140611, 30043, 0, 'Windy Cloud - Nagrand'),
(140612, 30043, 0, 'Windy Cloud - Nagrand'),
(140613, 30043, 0, 'Windy Cloud - Nagrand'),
(140614, 30043, 0, 'Windy Cloud - Nagrand'),
(140615, 30043, 0, 'Windy Cloud - Nagrand'),
(140616, 30043, 0, 'Windy Cloud - Nagrand'),
(140617, 30043, 0, 'Windy Cloud - Nagrand'),
(140618, 30043, 0, 'Windy Cloud - Nagrand'),
(140619, 30043, 0, 'Windy Cloud - Nagrand'),
(140620, 30043, 0, 'Windy Cloud - Nagrand'),
(140621, 30043, 0, 'Windy Cloud - Nagrand'),
(140622, 30043, 0, 'Windy Cloud - Nagrand');

-- 4 extra spawns

-- Felmist
--
UPDATE `creature` SET `spawntimesecs`='900' WHERE `id` = 17407; -- 3600 
DELETE FROM `pool_creature` WHERE `pool_entry` = 30046;
INSERT INTO `pool_creature` VALUES 
(26582,30046,0,'Felmist - Shadowmoonvalley'),
(29060,30046,0,'Felmist - Shadowmoonvalley'),
(29061,30046,0,'Felmist - Shadowmoonvalley'),
(29099,30046,0,'Felmist - Shadowmoonvalley'),
(29395,30046,0,'Felmist - Shadowmoonvalley'),
(31825,30046,0,'Felmist - Shadowmoonvalley'),
(32374,30046,0,'Felmist - Shadowmoonvalley'),
(32375,30046,0,'Felmist - Shadowmoonvalley'),
(32376,30046,0,'Felmist - Shadowmoonvalley'),
(32377,30046,0,'Felmist - Shadowmoonvalley'),
(32583,30046,0,'Felmist - Shadowmoonvalley'),
(32584,30046,0,'Felmist - Shadowmoonvalley'),
(32585,30046,0,'Felmist - Shadowmoonvalley'),
(32594,30046,0,'Felmist - Shadowmoonvalley'),
(35870,30046,0,'Felmist - Shadowmoonvalley'),
(35871,30046,0,'Felmist - Shadowmoonvalley'),
(40531,30046,0,'Felmist - Shadowmoonvalley'),
(40532,30046,0,'Felmist - Shadowmoonvalley'),
(40552,30046,0,'Felmist - Shadowmoonvalley'),
(40558,30046,0,'Felmist - Shadowmoonvalley'),
(41637,30046,0,'Felmist - Shadowmoonvalley'),
(42968,30046,0,'Felmist - Shadowmoonvalley'),
(47088,30046,0,'Felmist - Shadowmoonvalley'),
(86826,30046,0,'Felmist - Shadowmoonvalley'),
(86827,30046,0,'Felmist - Shadowmoonvalley'),
(86828,30046,0,'Felmist - Shadowmoonvalley'),
(86829,30046,0,'Felmist - Shadowmoonvalley'),
(86830,30046,0,'Felmist - Shadowmoonvalley'),
(86833,30046,0,'Felmist - Shadowmoonvalley'),
(140647,30046,0,'Felmist - Shadowmoonvalley'),
(140648,30046,0,'Felmist - Shadowmoonvalley'),
(140649,30046,0,'Felmist - Shadowmoonvalley'),
(140650,30046,0,'Felmist - Shadowmoonvalley'),
(140651,30046,0,'Felmist - Shadowmoonvalley'),
(140768,30046,0,'Felmist - Shadowmoonvalley'),
(140772,30046,0,'Felmist - Shadowmoonvalley'),
(140794,30046,0,'Felmist - Shadowmoonvalley'),
(140795,30046,0,'Felmist - Shadowmoonvalley'),
(140796,30046,0,'Felmist - Shadowmoonvalley'),
(140797,30046,0,'Felmist - Shadowmoonvalley'),
(140800,30046,0,'Felmist - Shadowmoonvalley'),
(140801,30046,0,'Felmist - Shadowmoonvalley'),
(140802,30046,0,'Felmist - Shadowmoonvalley'),
(140803,30046,0,'Felmist - Shadowmoonvalley'),
(140804,30046,0,'Felmist - Shadowmoonvalley'),
(140805,30046,0,'Felmist - Shadowmoonvalley');
Xadras commented 8 years ago

Arcane Vortex:

https://db.rising-gods.de/?maps=3523:406629432759532609538875643580705440519598332656206625425683515186716435403326525683515186716435403326524921515186716435403326524921525883396103325535568330401619430751518600531871643580699440332652492184248411231768384766408687332601272588301382457252588339610374724394411524422568514532553582616582633601654594617633568330401619430751518600531871643580699440332652492184238425231768384766408687332601272588301382457252588339610374724394411524422568514532562570616582633601654594617633580803536266397316646363458180410254720351663514511557341545309434405166630485608345579460306407660304297530568330401619430751518600531871643580699440332652200660250419490182332601273586301380457252231768384765408687724396610372591341410524420566516532553582617633617582654594633601459178395318537267646365581803405166410256607345659306721353579458630485664516511559306407309434296532340543281792319722568330401619430751518600531871643580699440332652200660250419490182332601273586301380457252231768384765408687724396610372591341410524420566516532553582617633617582654594633601459178395318537267646365581803405166410256607345659306721353579458630485664516511559306407309434296532340543281792319722568330401619430751518600531871643580699440332652492184238425231768384766408687332601272588301382457252588339610374724394411524422568514532562570616582633601654594617633580803536266397316646363458180410254720351663514511557341545309434405166630485608345579460306407660304297530194654

#!sql

-- Arcane Vortex
--

SET @POOL := POOLENTRY;
DELETE FROM `pool_creature` WHERE `pool_entry` = XXX; -- Arcane Vortex Pool
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES
(GUID, @POOL, 0, 'Arcane Vortex - Netherstorm'),

Swamp Gas:

This is where all left out potential Swamp Gas Spawns should be: https://db.rising-gods.de/?maps=3521:280240380600450560630660712442720341712679829730251279769881586349844312331619160242269359272433282479867456603464673658808790435533388522414584401623383631199316787464696580761398629405481312398363373359354390360460266386264308544553531666803821590350440560280240381589450560630660160240330621826726844312713347269359270433590350440560280240381589450560630660160240330621826726844312590350437533280240381589450560630660160240330621826726844312713347269359270433415584808792402623382631603462281481673658866458388520323312160190130433119458086508120601165596182683256547300506317378339417459584581510603532607559650726751834839489306318299215

http://www.kujaswowgoldguide.com/2011/07/exploring-zangarmarsh-1650g-in-30.html

#!sql

-- Corona Left Free 140000-150000
DELETE FROM `creature` WHERE `guid` BETWEEN 140296 AND 140417;

SELECT * FROM `creature` WHERE `id` = 17378;

-- Swamp Gas
--
UPDATE `creature` SET `spawntimesecs`='900' WHERE `id` = 17378; -- 3600 
SET @GUID := 140591; -- 140601
DELETE FROM `creature` WHERE `guid` BETWEEN @GUID AND @GUID + 9;
INSERT INTO `creature` VALUES (@GUID := @GUID + 0, 17378, 530, 1, 0, 0, -97.2742, 8879.4179, 18.0272, 0, 3600, 0, 0, 6900, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 17378, 530, 1, 0, 0, -162.5833, 8832.7041, 18.1157, 0, 3600, 0, 0, 6900, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 17378, 530, 1, 0, 0, -63.4768, 8676.1152, 17.9017, 0, 3600, 0, 0, 6900, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 17378, 530, 1, 0, 0, -362.6227, 8542.6884, 17.3747, 0, 3600, 0, 0, 6900, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 17378, 530, 1, 0, 0, 384.9076, 8878.4960, 21.9058, 0, 3600, 0, 0, 6900, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 17378, 530, 1, 0, 0, 472.5953, 8805.1416, 20.9977, 0, 3600, 0, 0, 6900, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 17378, 530, 1, 0, 0, XXX, YYY, ZZZ, 0, 3600, 0, 0, 6900, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 17378, 530, 1, 0, 0, XXX, YYY, ZZZ, 0, 3600, 0, 0, 6900, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 17378, 530, 1, 0, 0, XXX, YYY, ZZZ, 0, 3600, 0, 0, 6900, 0, 0, 0);

SET @POOL := POOLENTRY;
DELETE FROM `pool_creature` WHERE `pool_entry` = XXX; -- Swamp Gas Pool
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES
(GUID, @POOL, 0, 'Swamp Gas - Zangarmarsh'),