search

Looking4Group / L4G_Core

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

npc missing vendor item / drop item / trainer spell / quest #2497

Open Xadras opened 8 years ago

Xadras commented 8 years ago

ToDo:

-- Junkbox (pickpocketed) -- Battered Junkbox 16882 -- Requires Lockpicking (1) -- Worn Junkbox 16883 -- Requires Lockpicking (70) -- Sturdy Junkbox 16884 -- Requires Lockpicking (175) -- Heavy Junkbox 16885 -- Requires Lockpicking (250) -- Strong Junkbox 29569 -- Requires Lockpicking (300)

-- Lockbox (dropped) -- Ornate Bronze Lockbox 4632 -- Requires Lockpicking (1) -- Heavy Bronze Lockbox 4633 -- Requires Lockpicking (25) -- Iron Lockbox 4634 -- Requires Lockpicking (70) -- Strong Iron Lockbox 4636 -- Requires Lockpicking (125) -- Steel Lockbox 4637 -- Requires Lockpicking (175) -- Reinforced Steel Lockbox 4638 -- Requires Lockpicking (225) -- Mithril Lockbox 5758 -- Requires Lockpicking (225) -- Thorium Lockbox 5759 -- Requires Lockpicking (225) -- Eternium Lockbox 5760 -- Requires Lockpicking (225)

Xadras commented 8 years ago

Placeholder

Xadras commented 8 years ago

Placeholder

Xadras commented 8 years ago

Herb Vendor Research:


-- 
765
785
3358
8845
8846
13463
13464
-- 13465? darkmoon vendor?
13467
13468
22785
22786
22787
22789
22790
22791
22792
22793
22794

-- recheck for more vendors done list
-- https://web.archive.org/web/20111011144503/http://www.wowhead.com:80/item=785/mageroyal#sold-by
-- https://web.archive.org/web/20171225111614/http://www.wowhead.com:80/item=765/silverleaf#sold-by

-- https://web.archive.org/web/20150622100415/http://www.wowhead.com/npc=844/antonio-perelli#sells
INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `condition_id`, `comments`) VALUES
(844, 785, 2, 7200, 0, 0, 'Mageroyal'),
(844, 3357, 1, 86400, 0, 0, 'Liferoot'),
(844, 3356, 1, 7200, 0, 0, 'Kingsblood'),
(844, 3355, 1, 7200, 0, 0, 'Wild Steelbloom'),
(844, 2453, 2, 7200, 0, 0, 'Bruiseweed'),
(844, 2449, 3, 7200, 0, 0, 'Earthroot'),

-- https://web.archive.org/web/20110625055112/http://www.wowhead.com:80/npc=1302#sells
(1302, 785, 1, 9000, 0, 0, 'Mageroyal'),
(1302, 2449, 3, 9000, 0, 0, 'Earthroot'),
(1302, 2453, 2, 9000, 0, 0, 'Bruiseweed'),
(1302, 3355, 1, 9000, 0, 0, 'Wild Steelbloom'),
(1302, 3356, 1, 9000, 0, 0, 'Kingsblood'),
(1302, 3357, 1, 9000, 0, 0, 'Liferoot'),

-- https://web.archive.org/web/20110630232905/http://www.wowhead.com:80/npc=1313
(1313, 765, 3, 7200, 0, 0, 'Silverleaf'),
(1313, 785, 2, 7200, 0, 0, 'Mageroyal'),
(1313, 2447, 2, 7200, 0, 0, 'Peacebloom'),
(1313, 2449, 3, 7200, 0, 0, 'Earthroot'),
(1313, 2453, 2, 7200, 0, 0, 'Bruiseweed'),
(1313, 3355, 1, 7200, 0, 0, 'Wild Steelbloom'),
(1313, 3356, 1, 7200, 0, 0, 'Kingsblood'),
(1313, 3357, 1, 7200, 0, 0, 'Liferoot'),

-- https://web.archive.org/web/20120509085015/http://www.wowhead.com:80/npc=3490/hulamahi
(3490, 765, 2, 7200, 0, 0, 'Silverleaf'),
(3490, 785, 2, 7200, 0, 0, 'Mageroyal'),
(3490, 2447, 3, 7200, 0, 0, 'Peacebloom'),
(3490, 2449, 3, 7200, 0, 0, 'Earthroot'),
(3490, 2453, 2, 7200, 0, 0, 'Bruiseweed'),

-- https://web.archive.org/web/20120428123137/http://www.wowhead.com:80/npc=3548/selina-weston
(3548, 765, 2, 7200, 0, 0, 'Silverleaf'),
(3548, 785, 1, 7200, 0, 0, 'Mageroyal'),
(3548, 2447, 3, 7200, 0, 0, 'Peacebloom'),
(3548, 2449, 3, 7200, 0, 0, 'Earthroot'),
(3548, 2453, 2, 7200, 0, 0, 'Bruiseweed'),

-- https://web.archive.org/web/20120330142047/http://www.wowhead.com:80/npc=4083/jeeda
(4083, 785, 2, 9000, 0, 0, 'Mageroyal'),
(4083, 2449, 3, 7200, 0, 0, 'Earthroot'),
(4083, 2453, 2, 7200, 0, 0, 'Bruiseweed'),
(4083, 3355, 1, 14400, 0, 0, 'Wild Steelbloom'),
(4083, 3356, 1, 7200, 0, 0, 'Kingsblood'),
(4083, 3357, 1, 7200, 0, 0, 'Liferoot'),

-- http://db.hellfire-tbc.com/?npc=4878 -- https://web.archive.org/web/20171121081053/http://www.wowhead.com:80/npc=4878/deprecated-for-4-x-montarr
(4878, 785, 1, 7200, 0, 0, 'Mageroyal'),
-- (4878, 2449, 2, 9000, 0, 0, 'Earthroot'), verfiy
-- (4878, 2453, 1, 9000, 0, 0, 'Bruiseweed'),
-- (4878, 3355, 1, 14400, 0, 0, 'Wild Steelbloom'),
(4878, 3356, 1, 7200, 0, 0, 'Kingsblood'),
(4878, 3357, 1, 7200, 0, 0, 'Liferoot'),

-- https://web.archive.org/web/20120901141224/http://www.wowhead.com:80/npc=8305/kixxle
(8305, 3357, 1, 9000, 0, 0, 'Liferoot'),
(8305, 3356, 1, 14400, 0, 0, 'Kingsblood'),
(8305, 3355, 1, 14400, 0, 0, 'Wild Steelbloom'),
(8305, 2453, 2, 7200, 0, 0, 'Bruiseweed'),
(8305, 2449, 3, 7200, 0, 0, 'Earthroot'),
(8305, 785, 2, 7200, 0, 0, 'Mageroyal'),

-- https://web.archive.org/web/20111113165639/http://www.wowhead.com:80/npc=14846/lhara - wrath!

-- https://web.archive.org/web/20110826043402/http://www.wowhead.com:80/npc=16015/viel
(16015, 8846, 5, 7200, 0, 0, 'Gromsblood'),

-- https://web.archive.org/web/20111208032317/http://www.wowhead.com:80/npc=16224/rathis-tomber
(16224, 765, 3, 43200, 0, 0, 'Silverleaf'),
(16224, 785, 3, 43200, 0, 0, 'Mageroyal'),
(16224, 2447, 3, 43200, 0, 0, 'Peacebloom'),
(16224, 2449, 3, 43200, 0, 0, 'Earthroot'),
(16224, 2453, 3, 43200, 0, 0, 'Bruiseweed'),

-- https://web.archive.org/web/20111013071845/http://www.wowhead.com:80/npc=16641/melaris
(16641, 765, 3, 43200, 0, 0, 'Silverleaf'),
(16641, 785, 2, 7200, 0, 0, 'Mageroyal'),
(16641, 2447, 3, 9000, 0, 0, 'Peacebloom'),
(16641, 2449, 4, 7200, 0, 0, 'Earthroot'),
(16641, 2453, 2, 7200, 0, 0, 'Bruiseweed'),
(16641, 3355, 1, 7200, 0, 0, 'Wild Steelbloom'),
(16641, 3356, 1, 7200, 0, 0, 'Kingsblood'),
(16641, 3357, 1, 43200, 0, 0, 'Liferoot'),

-- https://web.archive.org/web/20130419003224/http://www.wowhead.com:80/npc=16705/altaa
(16705, 765, 3, 7200, 0, 0, 'Silverleaf'),
(16705, 785, 2, 7200, 0, 0, 'Mageroyal'),
(16705, 2447, 2, 7200, 0, 0, 'Peacebloom'),
(16705, 2449, 1, 7200, 0, 0, 'Earthroot'),
(16705, 2453, 2, 7200, 0, 0, 'Bruiseweed'),
(16705, 3355, 1, 7200, 0, 0, 'Wild Steelbloom'),
(16705, 3356, 1, 7200, 0, 0, 'Kingsblood'),
(16705, 3357, 1, 7200, 0, 0, 'Liferoot'),

-- https://web.archive.org/web/20120809045615/http://www.wowhead.com:80/npc=20989/dealer-sadaqat
(20989, 22793, 1, 43200, 0, 0, 'Mana Thistle'),
(20989, 22786, 3, 43200, 0, 0, 'Dreaming Glory'),
(20989, 22785, 3, 43200, 0, 0, 'Felweed'),
(20989, 13467, 3, 43200, 0, 0, 'Icecap'),
(20989, 22791, 3, 43200, 0, 0, 'Netherbloom'),

-- https://web.archive.org/web/20120308152027/http://www.wowhead.com:80/npc=24975/marnah
-- complete
(24975, 13467, 3, 9000, 0, 0, 'Icecap'),
(24975, 22785, 3, 9000, 0, 0, 'Felweed'),
(24975, 22786, 3, 9000, 0, 0, 'Dreaming Glory'),
(24975, 22791, 3, 9000, 0, 0, 'Netherbloom'),
(24975, 22793, 1, 9000, 0, 0, 'Mana Thistle');

-- items
-- https://web.archive.org/web/20100813073430/http://www.wowhead.com/item=22829#sold-by

-- healmanapot in 184716
-- https://www.wowhead.com/object=184716/coilskar-chest#comments:id=311537
-- https://web.archive.org/web/20160319165901/http://www.wowhead.com:80/object=184716#contains:mode=noteworthy

-- select entry from creature_template where vendortemplateid = 129;
INSERT INTO `npc_vendor_template` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `condition_id`, `comments`) VALUES (129, 785, 2, 7200, 0, 0, 'Mageroyal'),
INSERT INTO `npc_vendor_template` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `condition_id`, `comments`) VALUES (129, 2447, 2, 7200, 0, 0, 'Peacebloom'),
INSERT INTO `npc_vendor_template` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `condition_id`, `comments`) VALUES (129, 2449, 3, 7200, 0, 0, 'Earthroot'),
INSERT INTO `npc_vendor_template` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `condition_id`, `comments`) VALUES (129, 2453, 2, 7200, 0, 0, 'Bruiseweed'),
INSERT INTO `npc_vendor_template` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `condition_id`, `comments`) VALUES (129, 3355, 1, 7200, 0, 0, 'Wild Steelbloom'),
INSERT INTO `npc_vendor_template` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `condition_id`, `comments`) VALUES (129, 3356, 1, 7200, 0, 0, 'Kingsblood'),