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? |
Quote:
Here's the table: Code:
mysql> show columns in spells_new; |
And here's the error reported by the editor:
Code:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range, aoerange, pushback, pushup, cast_time, recovery_time, recast_time, buffdu' at line 1 edit: also, not exactly sure what you mean by blind inserts, but if I use Code:
mysql> insert into blind values (1,'test','test',1); Code:
mysql> show columns in blind; Code:
mysql> select * from blind; |
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
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! |
|
Quote:
|
Quote:
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. |
All times are GMT -4. The time now is 09:55 AM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.