Swish
Simple WoWHead Ripper
Enter Swish. Swish is a simple WoWHead list ripper, capable of ripping any item list you can assemble; From regular filtered lists to creature and item loots, this handy program can create formatted output for almost anything you can throw at it. Currently it only supports item lists. Support for spells and item sets will be added soon.
Instructions: Extract the RAR'd files, edit swish.conf and run swish.exe. It's that simple.
Here's an example; Say I wanted to add all keys to a certain vendor, entry 10000. Instead of going and adding everything by hand, I just assemble the following list:
Keys - Items - World of Warcraft
I edit my conf file like so:
Code:
# The URL of the list you wish to rip
TargetURL = "http://www.wowhead.com/?items=13"
# The path to the file you want Swish to generate
# Can be either relative or absolute
TargetPath = "keyvendor.sql"
# Format of the output
# '%(name)s' will be replaced by the item's name
# '%(entry)s' will be replaced by the item's entry
# '\n' marks a new-line
Format = "INSERT INTO vendors(entry, item, amount) VALUES(10000, %(entry)s, 1);[\n"
# Turn escaping on or off
# When Escaping is set to 'true', all quotes in the
# item's name will be escaped.
Escaping = True
Then I run swish.exe and voila! The file "keyvendor.sql" now has queries to add all keys to the vendor I made 
So what are you waiting for? Download Swish Now!