Looking for help on some commands

[shamanistik]

Hi guys,

I would like to edit some zones, found a zone editor, got studio max for ages, but seems files from EQ work on it.

So here is the commands in SQL i'd like to know, searched the wiki, found some pieces, but not enough to make it work.

Need to do 'use <database name>' I think

Then what commands I need to type to :

- Change the x,y,z when you zone in from a zone (might be able to zone from different zones tho.. )

- change a zone in the DB (replace)

- Add a zone to the DB (with the files needed to be running)
(well, how to add a file in the database, in the right directory)

- is it possible to add forges, brewing machine, etc.. ? if so, how did you do?

For a zone to be working, need a file objet.s3d I think ? I am at work and can't access my EQ directory, the _chr files can be done with a text file so np