Hello i wanna clean my db.

[Poppe178]

Hello i downloaded i vendor pack. Then it didnt work and i dont want it. i dont know how to remove all files of the vendors. And then i finded an awesome vendor pack with 150 vendors and half of them is the same ids as old repack so i cant install it :S. please help me what how shall remove all of this.

 
80001
80002
80003
80004
80005
80006
80007
80008
80009
80010
80011
80012
80013
80014
80015
80016
80017
80018
80019
80020
80021
80022
80023
80024
80025
80026
80027
80028
80029
80030
80031
80034
80035
30036

EDIT THIS IS THE PACK I WANNA INSTALL :http://www.************/forums/showthread.php?t=88580

Still that id prob:s after run

delete from `vendors` where entry between 80005 and 80036;

EDIT: Works now it were wrong in the vendor pack with 2 vendors with the same id (80073)

[Jadd]

Type /camp

trollface.jpg

[Ground Zero]

Type /camp

trollface.jpg

Was that really needed?

On Topic:
You could run the following as a query

delete from `table_name` where entry between xxxxx and xxxxx;

In your case it would be:

delete from `vendors` where entry between 80005 and 80036;

[Poppe178]

Thanx Ground Zero shall i run that as a SQL file?

[lol97899]

DELETE from Table WHERE id ='ID'
Edit too late :P

[Innit]

Ctrl+A and then delete.

[Poppe178]

Okay i did it as a sql file but it still says thoose ids is already in Yes i pressed F9 to save

[lol97899]

have you cleared all the three tables ?

[Poppe178]

No i only cleared vendor Whats the name of the 2 other tables

[lol97899]

Creature_names and creature_proto

[Poppe178]

After i did that it worked until it said 80073 :S