New Spell Editor

[BrainiacVince]

I know which one you're talking about, and I liked it too. The odd thing, every bit of it was in English, except the Windows error messages it popped up. I found it comical to see the German equivalent of "Memory Segment Fault at address 0x320808234". Good times, good times. Honestly, mine probably won't be much different visually from either of the existing ones (heck, they aren't that much different from each other), just more complete in functionality.

[ChaosSlayer]

Oh, that would be very nice to have =)
yes they are simular with OpenSpell, but OpenSpell is kind of all piled togther, while the "german" one is nicely broken into sub section, with icons preview and all.
If it wasn't for ocasinal corrupted save bug, and unability to properly change/save spell animation and descriotion- it would be all one would need.

But I am looking forward to your new spell editor =)

[BrainiacVince]

Week 1, Update 1:
My class is every Monday so I will be posting updates either Monday evening or Tuesday sometime.

I am going back to my original plan of using Java to implement this. The AJAX idea is for a separate project the professor had in mind.
This week, I'm going to be working on the GUI layout, which is due next week. This is your last chance to suggest major GUI features that you'd like. Some changes can be made later, but I don't want to have to reinvent this project every other week.

[TheLieka]

I don't know how easy or hard this would be for you, but it would be nice to be able to query and update spells in batch.

For instance, if we notice that fear is landing way too easily, we could update the Resist Level (if you could update it with a calculation rather than a value replacement - for instance +10, rather than setting them all to the same value - that would absolutely rock too) on all spells that contain effectid 34 (or maybe hard code the effect name for each value.

The main thing that most of these spell editors lack is the ability to query the spells and update in batch.

Also, ensure that it's possible to edit the spell effect fields, that's something that OpenSpell doesn't allow you to do very easily, so I find myself using excel for this (which is quite messy).

Also, if it helps, I have broken my spell file into an excel spreadsheet and labeled the columns by how the source reads them. I'll post a link to it if it'll help you (or anyone else).

Dax

[TheLieka]

link below:
http://www.pwnedemu.com/downloads/Do.../spells_us.zip

Dax

[BrainiacVince]

This "batch" concept is incredibly easy. In fact, you could have already done it, to be honest. Instead of adding the data to a spreadsheet, you can add it to a new table in a database. You can create a new table in the existing database you use for your server, or start a new database with a table just for the spells. Since you already have the column headings, export the data to a .csv file, then import it into a table. (In OpenOffice, choose Save As, not export. Csv is one of the options in the drop down menu.) You should be able to use existing headings (the first row) as your field names for the database when you import the data from csv.

This allows you to execute SQL against it, which will give you batch capability. The only difference between doing it straight in a database editor vs a spell editor is that the spell editor will be able to have some nice drop-down boxes (like you suggested) with labels instead of numbers. Actually, I intend to use both in the GUI, so people can easily associate "Beneficial" with, say, a 2 in that field. I know that with Java, the JDBC (the Java DB driver) allows direct execution of SQL against a database, so it will be virtually no work at all to allow for that. The work will come from creating the drop down boxes in the GUI that associate Beneficial with 2, for example.

Your giant table, as well as some info that AndMetal posted a link to on the wiki, will greatly reduce that work, and I thank both of you again for that.

[Dispair2]

I was also planning on working on a little project like this that would use vb.net to connect to a db and decode the .txt file to the db then you can easily update them then simply dump them back to a .txt file however you like when you are done. However i am not able to decipher the .txt formats at this point so any help you can give on this aspect (such as what the heck the field actually mean and how the values are determined) would be great.