[REQ] SQL File for quests

[Bloodshed2007]

hi

does anyone know how to make a SQL query so that it puts items into a vendor if they are a specific type of item like quest item..

it would take a long time to get every item that is a quest item and put it into the vendor db..

cheers

-bloodshed-

[MentaL]

[waymirec]

Well you can pull the list of quest items by doing

SELECT * FROM items WHERE `bonding` > 2

So then I guess you could do something like

INSERT INTO vendors (entry,item,amount,max_amount) SELECT <vendor id>,entry,#,# FROM `items` WHERE `bonding` > 2

Changing <vendor id> to the id of the vendor you want them dumped into, as well as putting in an amt and max_amount values in place of the hashes.

[marcelo_20xx]

Also if you are interested I had stripped all the ID of quest Items for a mod in which every mob had a 100% chance of dropping the item you could use the id to insert into the vendor if you like...Ill post the link later though I am at work right now.

[Bloodshed2007]

ok thanks for the help :)