Dumping certian items

[dragonowner]

Is there a way to dump certain items from the item table where the level value is 80 and then change that into a vendor template? Just trying to find easier ways to do things

[stoneharry]

SELECT `entry` FROM `items` WHERE `itemlevel` = '80';

or:

SELECT `entry` FROM `items` WHERE `itemlevel` > '80';

or:

SELECT * FROM `items` WHERE `itemlevel` = '80';

And so on... Just experiment with what it is exactly you want to select, then you can dump the data returned into a SQL format or whatever, and copy + paste those numbers into your vendor.

[dragonowner]

Thank you a lot . Now I have to just figure out a way to execute the items into the database without writing them all :s

Edit: New problem: SELECT `entry` FROM `items` WHERE `itemlevel` = '80' ORDER BY `entry`
INTO OUTFILE 'M:/Users/Kyle/Desktop/itemtest.txt';

It prints on one line without breaks, how would i make it do a line break after each item id?

[stoneharry]

No idea, sorry. :/ I don't know how you would do that via a query. I just do it via the GUI given in SQLyog which has an option whether to export them as separate rows.

[dragonowner]

No idea, sorry. :/ I don't know how you would do that via a query. I just do it via the GUI given in SQLyog which has an option whether to export them as separate rows.

/Facepalm Well I have to learn about SQL

Edit: Dumping it into a sql file automatically does it