Log in

View Full Version : Spell editing and item editing


endra
07-29-2007, 02:02 PM
Sorry if this was posted elsewhere but I googled and found nothing at peq or here, i think. Is there any guides or anything that explains some of the fields that navicat displays for items? like what Id numbers to use for "clicktype" to distinguish between disposable clickable in inventory clickable when worn etc. and also an explanation on adding procs and focus effects. There are several fields I don't understand. I guess im not worried about the aug fields because last I read the emu doesn't support it. Also does openspell work with the latest version of the emu? if not is there a guide to editing the spells? And I assume you cant add new items because I tried and it threw an error saying something like Error curitemid > maxitem id and the world server wont boot. So I've edited what I can. Making an item with good stats, but I used a common item so everything drops it now so if I can get a host or somehow figure out how to host online through a nat on my dsl i wouldnt want my uber gm equips dropping off of low level decaying skeletons in nektulos all the time. I also need the id numbers for class race and diety that equal all. I think the one for class is 65535 but I'm not sure. Any help would be appreciated.

Criimson
08-28-2007, 11:27 AM
Sorry that I don't have an answer for you or at least in the fashion you are looking for. But here is what I would do.

Create several items; naming them by what you check.

Make each one with a different field checked or changed. Then you can make notes on what field did what to the items. This is what I do when I want to figure something out and it works well. I'm still lost on all of the faction columns that are related to class/diety....so many of them =)

Criimson

sdabbs65
08-28-2007, 10:35 PM
This isn't updated and may be old now not sure....

http://eqemu.psend.com/schema.png

Diuretic
11-01-2007, 03:02 AM
I'd like to draft an updated ER diagram, but the software I have is inordinately "busy" with the annotations. Anyone know what software was used to create that old ER diagram for the database?

Diuretic
11-01-2007, 08:52 AM
MySQL workbench, I'm pretty sure. Working on it now.

Thanks, D. for the assist in getting the answer. ;)

http://dev.mysql.com/downloads/gui-tools/5.0.html