The file needs to be imported into the database first, then the editor will see the spells. I sent a pm regarding this.

GeorgeS

The problem with that insert query is 'range' is a reserved word in mysql 5.something (is for me using 5.1.41 anyway). If you quote your column names with ` , you can specify the column name.

It's failing for me, not sure if it's due to that reason though. I tell it to do a full write to the database and it pauses for 10 seconds or so then appears to finish, but the table just gets truncated. No error messages.

I don't remember what version of MySQL I am using at home, but so far it has not had an issue with the range field.

Typically it breaks when a field in the database gets renamed, I keep meaning to fix it so people don't need to wait for me to get around to fixing it every time this happens but I'm slammed at the moment time wise. If I could get blind inserts working this wouldn't be a problem, but I cant seem to get them to play nice.

I thought I added error checking for that insert (what version are you using?) but I might have missed one.

Either way, can you give me a dump of your database fields so I can check them against what I am targeting in code?

I'm using 1.3, and it does have the error checking for that query, at least it tells you there's an error and doesn't just break.

Here's the table:

And here's the error reported by the editor:
When I put backticks (`) around 'range' from the query you posted earlier in this thread, it works.

edit: also, not exactly sure what you mean by blind inserts, but if I use
with table
It works fine.

There's probably a better way to auto insert the index, though.

any word on this error? Im trying 1.3 and I get that range error msg before i can even get in and edit something. I get the msg on starting screen when i hit use spellfile from database. Also get the error if i load from local spell file and then try to write full to database.

Been sort of swamped/moving/generally doing other shit. I'll try to patch it up in the near future, along with the ability to edit the db strings file.

Thanks for being patient.

can't seem to get it to connect to my database :( not sure why, I enter in all the information correctly

v1.8
 

Changes

• Fixed some MySQL query issues, let me know if anyone has any other issues with them.
• Added a gem icon viewer to go along side the buff icon viewer.
• Added the ability to edit the dbstr_us.txt. The caveat is that the file must be saved separately from the spells.
• Added a Resistance Simulator which allows you to edit spell resist formulas on the fly, view graphs of your formulas, setup resist modifiers for spell types and classes, and then test those resistances against two mock characters. This is entirely hooked into the spell editor so any changes that you make to the spells in the editor are automatically reflected in the simulator.

Remember to run trustfall.bat before using the editor...

Enjoy!

Null Spell Editor v1.8
Null Spell Editor v1.8 (No Video)

Hey Null.. Not sure if I'm missing something here, but with the latest version, I cannot click on "mana" box to edit value at all. In the old version, it works fine. (old version obviously refers to latest release prior to 1.8)


Also, have a question regarding old version. I cannot change the "skill" of any spells.. I can do everything else just fine, but the drop down list for skill type is blank other then the pre-chosen skill. What I have been doing is just copy/editing spells, then going into navicat to change the skill used. There something I messed up on when loading config up?

edit: Playing with it a little differently (keyboard only), I realized I can just tab over just fine. Playing with it further, I found I cannot click on any of the boxes to on the left side below Name and above the duration drop box. (new icon, particle effect, skill drop box, mana, casting time, spell group). Not really a big deal, but I'm sure this isn't as intended?

Thx for 1.8 release tho, I can now choose skills and whatnot, so you can disregard the "question". Great job!

Fixed!

1.8.1
1.8.1 (no video)

Null, you are the man!

Hey null, question about editing the strings.

How does it work, you just type in the ID you want the string to have then the description and hit save string file or?

I tried this but when i check that spell again the description for the string ID i entered comes up blank

You can change the number if you want or you can just edit that string value for its default id. The deal is that you have to save the string file separately from the spell file (File-> Save String File) and anyone playing on your server will need to save that file into their Everquest directory.

when you say you can change the number if you want.

It defaults to 0 correct? cause mine do, unless thats because the spells are already made. Anyway i tried setting the number to 35000, typed the description, saved the string file and the spell file and reloaded both and the field was blank and if I erased 35000 and typed it in again it was still blank.

Just wanna make sure im not doing something wrong

Also, should it take 60 seconds to save the string file?


Ok i just did the same thing and confirmed it does not save to the string file in 1.81 atleast for me. If its just me thats fine I can deal with that ill just edit the string file normally since i know how now.