Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 07-29-2007, 02:02 PM
endra
Sarnak
 
Join Date: Jul 2007
Posts: 30
Default Spell editing and item editing

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.
Reply With Quote
  #2  
Old 08-28-2007, 11:27 AM
Criimson
Hill Giant
 
Join Date: Sep 2006
Posts: 172
Default

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
Reply With Quote
  #3  
Old 08-28-2007, 10:35 PM
sdabbs65
Dragon
 
Join Date: Dec 2003
Location: Earth
Posts: 818
Default Maybe this will help

This isn't updated and may be old now not sure....

__________________
hosting Eqemu/Runuo/wow Emulators.

www.cheaterz.info
Reply With Quote
  #4  
Old 11-01-2007, 03:02 AM
Diuretic
Sarnak
 
Join Date: Oct 2007
Posts: 30
Default ER Diagram Software

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?
Reply With Quote
  #5  
Old 11-01-2007, 08:52 AM
Diuretic
Sarnak
 
Join Date: Oct 2007
Posts: 30
Default

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
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 01:47 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3