Submitting Quests, Items, Mobs in SQL format

[gatorman]

I am very interested in creating quests, items, mobs, etc for the database(peq) / emulator. I have created many already, however I used tools to create the items, mobs, tradeskills, and I'm not sure exactly how the syntax should look if I want to submit them.

If I create a new mob A_Kobold_Caster and stick him in Tox, give him a way point, loot... is there a way to export the commands neccesary to create this in sql? I've been using Georges EqEmu tools for many quests/mobs/items... but since I can't exactly show a direct sql statement, none of the work I've completed has a chance for the peq db releases.

I would like to make the project better,... is there any way to export what has been newly created into a text file? (for example, when I create a new npc type with loot tables etc and 'save' the information, can this also be written out to a text file?)

Thanks,
Blaz

[Angelox]

GeorgeS sql_browser, is still one of my main tools, when it comes to creating usable exports. I know there are massive programs out there , but his is simple, straightforward, quick and easy to understand. Also the PEQ Editor log makes inserts you can use.

[thepoetwarrior]

Here is how:

http://www.eqemulator.net/wiki/wikka...egoryCreateNPC

[Secrets]

Personally, I use Navicat (or the free alternative, HeidiSQL) for what you're trying to do. They have options to export and import (!!!) into different formats, whether it be exporting raw SQL or exporting data into an Excel Spreadsheet, and modifying it there.

Seriously, these tools help tremendously. If you're still learning, chances are you don't know how spawn2 spawnentries spawngroups and npc_types link in together, but you can see how they work together by reading the spawn tutorial posted in this thread.

Seeing a visual of a database and its columns helps a lot, that's why I advise using these programs to learn and when you're done learning, you can use them to make things tons quicker.

Best of luck on learning, if you need any assistance with learning the database, just shoot a PM. I'll be glad to help with any small questions.