search

Looking4Group / L4G_Core

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

Vendor Item Restocktime #3770

Open NoMoreGoodNames opened 7 years ago

NoMoreGoodNames commented 7 years ago

Hello,

there seems to be Issue with enchanting recipe formula runed arcanite rod. According to wowhead , respawn timer should only be like 15 minutes , but it appears to be much longer here.

According to wowhead for the npc that sells http://www.wowhead.com/npc=12022/lorelae-wintersong#comments

According to other project, same issue and was fixed here https://github.com/FeenixServerProject/Archangel_2.4.3_Bugtracker/issues/1638

AnonXS commented 7 years ago 
    Formula: Runed Arcanite Rod (16243)
    Recipe: Sneaking Potion (22901)
    Recipe: Transmute Primal Might (23574)
    Recipe: Major Dreamless Sleep Potion (22911)
    Plans: Adamantite Maul (23590)
    Plans: Adamantite Cleaver (23591)
    Plans: Adamantite Dagger (23592)
    Plans: Adamantite Rapier (23593)
    Plans: Moonsteel Broadsword (12163)
    Plans: Massive Iron Axe (12164)
    Formula: Runed Arcanite Rod (16243)
    Formula: Superior Mana Oil (22562)
    Formula: Superior Wizard Oil (22563)
    Formula: Enchant Shield - Major Stamina (28282)
    Formula: Large Prismatic Shard (22565)
    Formula: Runed Adamantite Rod (25848)
    Formula: Runed Eternium Rod (25849)
    Schematic: Fel Iron Toolbox (23816)
    Schematic: Adamantite Scope (23807)
    Schematic: Adamantite Shell Machine (23815)
    Schematic: White Smoke Flare (23811)
    Schematic: Adamantite Rifle (23799)
    Pattern: Heavy Knothide Leather (25720)
    Pattern: Imbued Netherweave Robe (21900)
    Pattern: Imbued Netherweave Tunic (21901)
    Pattern: Imbued Netherweave Boots (21899)
    Pattern: Imbued Netherweave Pants (21898)
    Pattern: Bolt of Soulcloth (21894)
    Schematic: Fused Wiring (32381)
    Plans: Adamantite Rod (25846)
    Plans: Eternium Rod (25847)

-- UPDATE `npc_vendor` SET `incrtime` = XXX WHERE `item` IN (12164); -- 3600

UPDATE `npc_vendor` SET `incrtime` = 3600 WHERE `item` IN (12163,16243,22901,22911); -- 7200
UPDATE `npc_vendor` SET `incrtime` = 3600 WHERE `item` = 23574; -- 9000
UPDATE `npc_vendor` SET `incrtime` = 3600 WHERE `item` IN (22563,21900,21901,25849,28282); -- 10800
UPDATE `npc_vendor` SET `incrtime` = 3600 WHERE `item` IN (25720,25848); -- 21600
UPDATE `npc_vendor` SET `incrtime` = 3600 WHERE `item` IN (22562,22565,21894,23799,23811,23815,23816,23590,23591,23592,23593,21898,21899,23807,25846,25847); -- 43200