I made a tool to extract data from the wowhead web. It is used basically to vendors that have a lot of items but it works with all.
http://www.mediafire.com/?v98b6b50i86j59o
The limitations are:
- extendedcost is always 0
- incrtime is always 0 on infinite items, for restockable items it is an hour, 3600 secs
- It only fills vendor_data table
Recommend to use only with vendors that sells only items that can be bought with gold. Otherwise you must fill the extendedcost column manually.
Instructions:
Go wowhead, a vendor like this:
http://www.wowhead.com/npc=2483
Right click, view source code. File menu, save as "npc.htm"
Put the .exe on the same folder that "npc.htm" and open it. You should get a file called vendor.sql. From the npc shown I get this:
-- Jaquilina Dramet'
SET @ENTRY := 2483;
DELETE FROM `npc_vendor` WHERE `entry`=@ENTRY;
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(@ENTRY,0,12250,1,3600,0),
(@ENTRY,0,2523,0,0,0),
(@ENTRY,0,2522,0,0,0),
(@ENTRY,0,2530,0,0,0),
(@ENTRY,0,25876,0,0,0),
(@ENTRY,0,2531,0,0,0),
(@ENTRY,0,12164,1,3600,0);
And this is what you get in the console:
http://imageshack.us.../dibujohbm.png/
The source code: