How do I create a new spell?

[Dispair2]

Originally Posted by GeorgeS

With the number of fields (like items table), this is hard work to code. I spent several months writing eqitems item editor, and a spell editor is also no simple feat - hence the very very few out there.

I still abide what I said, and will eventually write the program, but we'll see how it goes. I should have time next week open for programing this

One thing I would prefer is to upload this as a table and not work from a flat text file (nightmare to parse). It will create the file when you're done so that the spells will work in game.

I really wish the spells were in a table...

GeorgeS

Yes, I think you are correct that this would be easier if it were in a table. If i was to write code for this is say vb.net i would have the program import the file to an SQL table seeing as we are all already using MySQL and then edit the DB to make changes then write a new .txt file for publication. as i am sure their are a ton of people already working on this i will most likely not hammer away at it however, i will play with it a little over the next week while i am off of work and see if i can't get a moderately functional design together for everyone to play with.

[Dispair2]

This is a bad Guide: Spells_us.txt

[AndMetal]

Originally Posted by Dispair2

This is a bad Guide: Spells_us.txt

Originally Posted by AndMetal

It is by no means complete (as in, missing descriptions about several of the fields), but of course others are welcome to contribute to it

Originally Posted by Dispair2

i will play with it a little over the next week while i am off of work and see if i can't get a moderately functional design together for everyone to play with.

Nuff said

[TheLieka]

That guide is actually pretty good. It identifies the values used by OpenSpell. It's a very handy reference when you're digging through the spell file with excel trying to adjust a batch of spells. In fact, I've got it saved as a favorite.

Dax

[Dispair2]

I looked back over the wiki about the spells file and i am not sure if i am just too simple to understand but it seams like allot of things are off on that file from my spells files that or their are allot of spells that have a 0 mana cost and so on. Also can anyone give me a broken down side by side list of what the fields are? I have been pulling it apart my self in word and just can not seam to decipher it.

[AndMetal]

Another useful resource for decoding the different fields is Lucy. On the download page, there are dumps of the Lucy spell database in CVS format (although you can't extract them on a Windows system because the files contain colons), which is parsed from the spells_us.txt file. By cross referencing known fields in Lucy & unknown fields based on current known information, I have already uncovered some additional information (like field 145, counting from 0, is the spell animation).

Something else to remember is that the most recent spells_us.txt file uses 215 unique fields, where as the Titanium client uses 203 unique fields. The most recent spells_us.txt file can be downloaded directly from the official patch server here (right-click & choose Save As, otherwise it will kill your browser) if you want to work against it.

[AndMetal]

I found myself with some free time yesterday & updated the Wiki. It should be a little more complete, and hopefully a little easier to read. A lot of the fields don't have a description, but they should be relatively self-explanatory. I also included a SQL file at the bottom to create a table with all of the columns.

On a side note, there's actually an even more recent version of the spells_us.txt file here (also through the official patcher) that has a few more fields, which look to still be unknown.