PICTURE Tutorial: Extract a list of all NPCS/ITEMS with ID and Display ID!

[selulancie]

So, this will be my first tutorial here. I will do it as easy as I possibly can, so people won't spam me how ;D

- I used Navicat 8 for this, so if you got an earlier version, it should be something like i will do here in this tutorial..

Here we go!
1. Open Navicat, it should look like this.

2. Right click on "creature_names" for example. Then press "Export Wizard".

3. This window will appear. I chosed HTML because, I think it looks good

4. Make sure creature_names is checked, and then press the "..." button.

5. Save the file to a name that you choose. Mine's called "BIG ITEM LIST".

6. Check the fields you wish to see in your list. I took these 3, as you can see.
Press "Next >" to continue after you've choosed.

Press Next again.

Press start. And there you have your own list directly from Navicat database. All items/NPCS and DisplayID's your server have!



Now you're done!

[EmiloZ]

Great guide.

[selulancie]

Thanks alot, I will post more tutorials in the future, but I need alot of training yet.. Still a noob in the private server world ;D