Navicat Quickstart!

[MMOtoaster]

Hello :wave:
Decided to make a quick-start guide for all of you Navicat users!

Okay, first off you would probably need to know where to change things on your server, this is mainly done in the World database.
Here is how it looks:

These are called tables, where you can make alot of custom stuff like items, quests and even create your own npc's/vendors .
I will show you some of the tables.

This is the "Items" table where you can change or create items, but its pretty hard the first time, so here is a tool to make it easier for you to create custom items:
http://www.mmowned.com/forums/progra...t=item+creator
All credits for the DBeditor goes to latruwski!
Alot of things can be done with the DBeditor, such as NPC's, Quests, and even the weather can be changed!

Some things you need to know if you are hosting your own server:

A public server needs to have several backups, on ALL tables.
You import SQL files by right-clicking on your Database and "Execute batch file". Most of the files you import should be stored in the World Database.
If you get any errors while importing, talk to the one that made the SQL file and make sure you are running on the same version as its made for!

In my opinion Navicat is easier to use for beginners than SQLyog. A great guide for setting up your server is Bloodkip's 2.4.3 ArcEmu guide:
http://www.mmowned.com/forums/emulat...-included.html
Happy DBediting! :wave: