How to easily fill your vendors

**Sorayazlawl** · 07-12-2008

This is an easy way to fill a vendor with a specific item that is between specific item levels (not required levels, but that's an easy fix if that's what you're after.)

Keep in mind what I do here is pretty damn ghetto, but it works well for me!

What you will need:
HeidiSQL
Navicat
Notepad++

#1 Search up an item of the type you want and find it's subclass in navicat, try filtering the subclass to make sure everything shown is of your weapon type.
#2 Query in navicat:
[code[SELECT entry FROM items WHERE itemlevel < 'x' AND itemlevel > y' AND subclass = 'z'; [/code]
x = maxitemlevel, y = minitemlevel, z = subclass you just found.
#3 Select all and copy/paste into Notepad++
#4 Select all and go to TextFX => Tools => insert line numbers
#5 Copy a space and press conrol + h
#6 Paste space in find what, and put a " ," with no quotes in replace with
#7 Select all and go back to TextFX/Tools/ and remove line numbers
#8 Remove comma before entry
#9 Press the record button up there, and make a period, go down a line, and press stop.
#10 Then Press the fast forward button and have it go till the end
#11 Replace comma with "x," Where x is the number of the vendor its going in
#12 Replace period with ",1,0,0" with no quotes
#13 Add this line to the top of your document, if your DB has a diff format, just export a CSV data document from HeidiSQL and steal it's top line:

Code:

entry,item,amount,max_amount,inctime

#13 Save as a .csv file
#14 Go into vendors on HeidiSql and import it in as csv data
#15 Search up the vendor ID and make sure it has items

If you're like me and went from sunwell items down to 60 items, you'll be getting some gay 60 blues and stuff. How do you remove that? Keep going!

#1 Run this query in navicat:

Code:

SELECT entry FROM items WHERE itemlevel < 'x' AND itemlevel > 'y' AND quality < 'z';

x = the maximum level of gear you want, y = the minimum level of gear you want, z = the minimum quality. Putting 4 here will get rid of everything that is not epic or legendary.
#2 Select all and copy/paste into Notepad++
#3 Select all and go to TextFX => Tools => insert line numbers
#4 Copy a space and press conrol + h
#5 Paste space in find what, and put a " ," with no quotes in replace with
#6 Select all and go back to TextFX/Tools/ and remove line numbers
#7 Remove comma before entry
#8 Press the record button up there, and make a period, go down a line, and press stop.
#9 Then Press the fast forward button and have it go till the end
#10 Replace comma with

Code:

 DELETE FROM vendors WHERE item = '

#11 Replace Period with

Code:

 ' AND ENTRY = 'x';

Replace X with the Entry ID of the vendor it's being purged from.
#12 Copy all of this into a New Query on navicat, and run it. Keep in mind it may say 0 rows affected when it really did alot.
#13 Check your vendor DB for a random blue that was in your vendor to see if it still is.

Keep in mind this list of "DELETE FROM"'s can be used on any item, as you did not define a subclass, so you can keep it for other items too.

This was fully written by me and I searched but did not find any, so I hope it's not a repost.