Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Tools

Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...)

Reply
 
Thread Tools Display Modes
  #1  
Old 06-04-2010, 04:54 AM
Null
Sarnak
 
Join Date: Mar 2010
Posts: 38
Default Null Spell Editor

Greetings,

I started building this just as a clone of the Ailia & Bleh Editor (the GUI layout is almost identical) with a few minor changes to fit my needs. It kept evolving over a few months of work off and on to the point that I didn't feel embarrassed at the thought of releasing it. So here it is!

Screenshots
File Loading
Spell Editing

Features:
  • Supports read/write directly from a Database or spells_us.txt (Titanium or SoF/SoD) and allows you to write back and forth between the two.
  • Write the entire contents of the spell data in your editor to the database or only the spells that you have changed.
  • Parses (Most) drop down values directly from spdat.h and skills.h which can be loaded directly from the SVN or locally. This means that you can select custom spell effects in your source directly in the editor or have them automatically updated as the project gets updated.
  • The search field updates the spell list in real-time with search filters. You can also select that it only displays changes that you have made since the last save.
  • Revert a single spell or the entire spell file back to the last save.
  • Copy and Delete spells. Copied spells are appended to the bottom of the spell list and marks it as a new spell.
  • Optional Spell Effect videos (thanks George!) that play in editor. Spell Effect videos that are added to the videos directory are automatically loaded in, so you can fill in missing videos yourself or replace existing ones.
  • Icon Preview for new_icon field.

Install Directions
  1. Download either NullSpellEdit.7z or NullSpellEdit_no_video.7z if you do not care about the videos.
  2. Extract its contents somewhere on your computer.
  3. If you want to access files remotely (like on the SVN) then run trustfall.bat which will add a security exception to your flash player for the directory that trustfall.bat is run from. This is entirely optional.
  4. Run NullSpellEditor.html and enjoy!

Known Issues
  • Spell Data loaded from the database will always write to a spells_us.txt as SoF format.
  • A full database write takes a very long time...go get a sandwich long for SoF based files.
  • Stock Everquest spell files that are loaded and then saved without any changes are slightly different then they started. This is because some values in the original files (mainly the SoF file) have blank entries. I replace these blanks with zeros if the value is a integer, but it shouldn't break your spell file.

Disclaimer
I have tested this pretty heavily but I do not guarantee that it wont hiccup or even explode. Please make backups before using this, and please post here if you have any problems.
Reply With Quote
  #2  
Old 06-04-2010, 05:33 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Wow, that looks pretty amazing! Nice work and thanks for sharing that

I have your first bug report though; I am unable to load the skills.h file by browsing locally. It just seems to ignore it, or maybe it is loading for the spdat.h file instead when I try to load skills.h. The spdat.h file seems to load fine though. Also, the spell file itself loads fine.

It's awesome you set it to be that flexible as well as for it to be able to automatically adapt for the future.

EDIT: Another bug seems to be that it will not connect to my database either. I created a new user to test it out, and verified I could connect with that new user via Navicat, but your tool just times out.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!

Last edited by trevius; 06-04-2010 at 07:54 AM..
Reply With Quote
  #3  
Old 06-04-2010, 10:36 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Just ran it briefly this morning, and it works very nicely.
You did a good job on incorporating the movies and editing in one package, and my hat is off to you - good job.

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #4  
Old 06-04-2010, 11:06 AM
Secrets's Avatar
Secrets
Demi-God
 
Join Date: May 2007
Location: b
Posts: 1,447
Default

I stickied the thread for the time being. Haven't checked it out but it sounds nice from what is described here.
Reply With Quote
  #5  
Old 06-04-2010, 12:56 PM
Null
Sarnak
 
Join Date: Mar 2010
Posts: 38
Default

Thanks for the comments and I hope you get some good use out of it.



Quote:
Originally Posted by trevius View Post
I have your first bug report though; I am unable to load the skills.h file by browsing locally. It just seems to ignore it, or maybe it is loading for the spdat.h file instead when I try to load skills.h. The spdat.h file seems to load fine though. Also, the spell file itself loads fine.
After you try to locally load all 3 files does the submit button still light up despite it saying that the skills.h file is needed? I might have just forgot to set the status for that file on a local load.

Quote:
EDIT: Another bug seems to be that it will not connect to my database either. I created a new user to test it out, and verified I could connect with that new user via Navicat, but your tool just times out.
Did you try running trustfall.bat? Is the database localhost or are you accessing it remotely? I am thinking it is either a flash sandbox issue (trustfall.bat will resolve this) or that my timeout is a little too militant for a remote database connect.
Reply With Quote
  #6  
Old 06-05-2010, 01:10 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Yeah, the DB is on another PC on my LAN. I was finally able to get it all working by using IE instead of Firefox. I may still need to mess around with the Firefox settings to get it working properly. Either way, the tool is pretty impressive
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #7  
Old 06-05-2010, 02:10 AM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Wow this is very impressive. Thank you so much for this!
Reply With Quote
  #8  
Old 06-05-2010, 02:25 AM
Null
Sarnak
 
Join Date: Mar 2010
Posts: 38
Default

I fixed the local skills.h load and put up a new version, enjoy!
Reply With Quote
  #9  
Old 06-05-2010, 03:19 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

The new version works great, thanks! I got skills.h to load locally just fine this time. You may want to specify on that screen that it wants zone/spdat.h and common/skills.h, because there is also a zone/skills.h file.

I can connect to my DB after running your .bat file, I just had to restart Firefox.

One minor detail is that the most recent upload seems to contain your assets and history folders outside of the NullSpellEdit folder as well as within it. Not a big deal, but thought it might be worth mentioning to reduce possible confusion.

Also, would it be possible to have a config file to save your file/DB loading settings so you don't have to set them each time you start up the editor? Another minor suggestion would be to set the default URLs for loading spdat.h and skills.h to use the trunk instead of the spells branch.

I haven't used the tool much yet, but so far I am impressed. I like how it automatically updates the icon and effect video as soon as you start altering either of those fields. Does the tool use the new icon types or are they an older version of icons? I don't know if spells might use a different gem icon and buff icon offhand, but if so, it might be nice to show both types.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!

Last edited by trevius; 06-05-2010 at 03:27 AM..
Reply With Quote
  #10  
Old 06-06-2010, 05:10 AM
Null
Sarnak
 
Join Date: Mar 2010
Posts: 38
Default

I put up a new version that will save your loading preferences. I also added a button to reset them and a check box for password inclusion. The default remote location for spdat and skills are now pointing at the trunk instead of the spellsbranch.

The additional icon previews will take a bit more time then I have at the moment, but its definitely something I can work in eventually.

Thanks for the requests Trevius!

edit:

I spoke too soon, small problem with the spdat and skills file preference saving, ill have a new version up soon.
Reply With Quote
  #11  
Old 06-06-2010, 06:28 AM
Null
Sarnak
 
Join Date: Mar 2010
Posts: 38
Default

So apparently the object I am using to bring up the file browser window doesn't expose the absolute path of the file that is selected...

This means that I cannot save off the path to use later. You can enter a local file path in the URL field then click 'Load URL' and it will load the file for you and save the path.

Ill look into it some more and if I think of a better option ill put it in later on.
Reply With Quote
  #12  
Old 06-06-2010, 08:09 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Thanks for the changes/fixes so far

It looks like the skills.h is still being a bit flakey, though. I am able to load from URL like you suggested by putting my local path in there for spdat.h, but it fails for skills.h:

F:\EQEmuServer\zone\spdat.h

F:\EQEmuServer\common\skills.h

Probably related to the problem with browsing for the local file that was happening before.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #13  
Old 06-06-2010, 04:17 PM
Null
Sarnak
 
Join Date: Mar 2010
Posts: 38
Default

Ok, I finally reproduced the error that you are getting. The only way I could get it to react the way that you are describing is to extract the zip to a new folder and not run trustfall.bat for that folder. The bug is that the status label is getting set to complete for spdat.h even though its getting a flash player error in the background preventing it from loading.

Try running trustfall.bat and see if that doesn't clear up the problem.
Reply With Quote
  #14  
Old 06-09-2010, 07:07 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Thanks. It looks like everything is working great now. All of the information is saving properly with 1 exception; The spell file location doesn't save. I think if you added a field for the location like the other files, it could be saved.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #15  
Old 07-09-2010, 01:25 AM
AudioGarden21
Sarnak
 
Join Date: Aug 2004
Posts: 80
Default Database Error

When I try to load the spell file from the database I get an error that says, "Database Error". I can load the spell file locally, and I can connect to the database, but if I click "From Database" it gives me the above error.

I also have an issue with writing changes or full write to database. The former does nothing and the latter just drops my entire spells_new table.

I'm not sure what the issue is. I've tried it out on two different PCs, neither worked right.

I'd very much like to get this working because for one, it's sexy, and for two, since I'm rather anal retentive about making sure every detail is complete, importing spell files after minor changes to one thing (which I do a lot, ugh) takes up quite a bit of time and having the option to apply the changes directly to the database would be much appreciated.

Thanks in advance.
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:22 AM.


 

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