View Full Version : 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 (http://dl.dropbox.com/u/7751891/spell_ss_01.jpg)
Spell Editing (http://dl.dropbox.com/u/7751891/spell_ss_02.jpg)
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
Download either NullSpellEdit.7z (http://dl.dropbox.com/u/7751891/NullSpellEdit.7z) or NullSpellEdit_no_video.7z (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video.7z) if you do not care about the videos.
Extract its contents somewhere on your computer.
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.
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.
trevius
06-04-2010, 05:33 AM
Wow, that looks pretty amazing! Nice work and thanks for sharing that :D
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.
GeorgeS
06-04-2010, 10:36 AM
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
Secrets
06-04-2010, 11:06 AM
I stickied the thread for the time being. Haven't checked it out but it sounds nice from what is described here.
Thanks for the comments and I hope you get some good use out of it.
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.
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.
trevius
06-05-2010, 01:10 AM
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 :)
Akkadius
06-05-2010, 02:10 AM
Wow this is very impressive. Thank you so much for this!
I fixed the local skills.h load and put up a new version, enjoy!
trevius
06-05-2010, 03:19 AM
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.
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.
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.
trevius
06-06-2010, 08:09 AM
Thanks for the changes/fixes so far :D
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.
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.
trevius
06-09-2010, 07:07 AM
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.
AudioGarden21
07-09-2010, 01:25 AM
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.
nilbog
07-09-2010, 02:17 AM
Hey, nice job on the editor! Looking good.
I'm not sure if you are taking feature requests yet, but you mentioned your editor reads the new_icon field. I was interested in quality checking some of my spell gems.. and your editor looks perfect to see the stats and the graphics simultaneously. However, I use a different lineup of gem placement and pictures (http://i29.tinypic.com/ab6udx.jpg). Is there some way to replace what is loaded for the pictures?
Once again, nice job! This is the most attractive spell editor I've seen yet. Had no issues running it across a LAN.
I have not been able to add in the new_icon preview yet, but when I do ill make sure to have it loaded from an external file (and ill move the other icons over also) so you can swap them out with whatever you want so long as it keeps the same dimensions as the original.
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.
The only other time I have seen something like this happen was when one of the database fields got a name change. What SVN Build are you using?
If it is the above problem, I just need to update the SQL queries and it should be good to go, but I am unsure of the best approach to keep things like this from breaking in the future.
maybe expose the expected field list so it doesn't take a recompile to fix?
AudioGarden21
07-09-2010, 06:37 PM
I'm using the latest SVN 1549.
I'm not sure if it makes a difference but I had to drop the items table because it was faulty with the server code and imported the items table from one of GeorgeS' compiled server/databse zips on his page.
Without doing so would cause an error when starting the server, but it works perfectly with GeorgeS' items table.
EDIT
When I look at the database in Heidi there's a table called "db_version" that says 1535 however.
Caryatis
07-09-2010, 07:46 PM
You are most likely missing this SQL Update (http://code.google.com/p/projecteqemu/source/browse/trunk/EQEmuServer/utils/sql/svn/1542_items_table_cleanup.sql) which affected the items table in rev1542
AudioGarden21
07-09-2010, 09:19 PM
I don't suppose you mean source the update, because I've tried that every which way I can and it spams nothing but errors saying either duplicate column or can't drop a column.
How would I apply the update?
AudioGarden21
07-11-2010, 10:34 AM
Hmm, so I updated to the latest revision 1589 and it still gives me the database error.
Can you send me a list of column names in your spells_new table?
AudioGarden21
07-14-2010, 01:47 AM
Certainly Null. And thanks for helping.
Going from left to right I have:
id
name
player_1
teleport_zone
you_cast
other_casts
cast_on_you
cast_on_other
spell_fades
range
aoerange
pushback
pushup
cast_time
recovery_time
recast_time
buffdurationformula
buffduration
AEDuration
mana
effect_base_value1
effect_base_value2
effect_base_value3
effect_base_value4
effect_base_value5
effect_base_value6
effect_base_value7
effect_base_value8
effect_base_value9
effect_base_value10
effect_base_value11
effect_base_value12
effect_limit_value1
effect_limit_value2
effect_limit_value3
effect_limit_value4
effect_limit_value5
effect_limit_value6
effect_limit_value7
effect_limit_value8
effect_limit_value9
effect_limit_value10
effect_limit_value11
effect_limit_value12
max1
max2
max3
max4
max5
max6
max7
max8
max9
max10
max11
max12
icon
memicon
components1
components2
components3
components4
component_counts1
component_counts2
component_counts3
component_counts4
NoexpendReagent1
NoexpendReagent2
NoexpendReagent3
NoexpendReagent4
formula1
formula2
formula3
formula4
formula5
formula6
formula7
formula8
formula9
formula10
formula11
formula12
LightType
goodEffect
Activated
resisttype
effectid1
effectid2
effectid3
effectid4
effectid5
effectid6
effectid7
effectid8
effectid9
effectid10
effectid11
effectid12
targettype
basediff
skill
zonetype
EnvironmentType
TimeOfDay
classes1
classes2
classes3
classes4
classes5
classes6
classes7
classes8
classes9
classes10
classes11
classes12
classes13
classes14
classes15
classes16
CastingAnim
TargetAnim
TravelType
SpellAffectIndex
field124
field125
deities1
deities2
deities3
deities4
deities5
deities6
deities7
deities8
deities9
deities10
deities11
deities12
deities13
deities14
deities15
deities16
field142
field143
new_icon
spellanim
uninterruptable
ResistDiff
dot_stacking_exempt
deleteable <--- noticed the typo on the database, should be deletable)
RecourseLink
field151
field152
field153
short_buff_box
descnum
typedescnum
effectdescnum
field158
field159
field160
field161
bonushate
field163
field164
field165
EndurCost
EndurTimerIndex
field168
field169
field170
field171
field172
HateAdded
EndurUpkeep
field175
numhits
pvpresistbase
pvpresistcalc
pvpresistcap
spell_category
field181
field182
field183
field184
can_mgb
nodispell
npc_category
npc_usefulness
field189
field190
field191
field192
nimbuseffect
field194
field195
field196
field197
field198
field199
field200
field201
field202
field203
field204
field205
field206
spellgroup
field208
field209
field210
field211
allowrest
field213
field214
That should do it. I hope it helps rectify the problem. And I hope I didn't make too many grammatical errors. =P
Let me know if you need anything else from me.
Cheers!
I think I see the problem, ill put up a new build after work tonight.
Here is a new version that has updated table queries. I might make these queries pulled from a file in the future so I can avoid having to put up a new build every time a field name gets changed.
I am leaving up the previous version also (link is on the first post) for people who don't need/want to update their db version for whatever reason.
Null Spell Editor v1.1.9 (http://dl.dropbox.com/u/7751891/NullSpellEdit_1.1.9.7z)
Null Spell Editor v1.1.9 (no videos) (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.1.9.7z)
Enjoy!
still does not work for me on newest db Rev it just wipes the table and stops
trevius
07-15-2010, 08:51 AM
Thanks for the update, Null! I will give it a shot this weekend :)
I am sure it was due to my change to identify the nimbus effect field out of the list of unknowns. I wish we knew more fields, but those higher ones are hard to figure out.
AudioGarden21
07-15-2010, 10:55 AM
Thanks Null! It that fixed that issue!
However... (always that however in lurking somewhere, isn't there? =/ )
After testing the update a bit on two different PCs, I've discovered a few things I thought I should bring to your attention.
1. Creating a new spell via "copy" command and writing changes to the database works with both Firefox and IE on both PCs. But if you alter a spell, for instance just the name of the new spell AFTER you write the new spell to the database it will not change anything. This applies to all spells currently in the database already.
It appears that anything that already exists in the database is not being overridden when writing changes to the database. I think of all functions available with your editor, that one would be essential as it saves a lot of time having to export to Spell IO to make changes to any spells that already exist.
I'm not sure if this is an actual function of this feature, to re-write changes over existing spell entries, or not. But logic tells me that's the way you designed it to function. It just isn't, unfortunately.
2. This one is quite minor because there's an easy work around, but the bottom of the login portion (the reset and submit buttons specifically) of the editor is cut off on my 19 inch CRT monitor running 10x7 resolution. Changing my resolution to 16x12 certainly fixes that issue, but of course text is so small you practically have to face-plant the monitor to read entries in the database.
I don't have a problem on my laptop because it naturally runs a higher resolution than my desktop does, and that's the PC I use for my server. Like I said a minor issue.
Might I suggest a fix to widen the login screen horizontally, so it doesn't extend so much vertically? I think that would certainly fix any and all issues regarding different user resolution settings, and we all know that everyone has their preferences that vary as much as the people themselves.
Thanks again Null, you're the man!
Thanks Null! It that fixed that issue!
However... (always that however in lurking somewhere, isn't there? =/ )
After testing the update a bit on two different PCs, I've discovered a few things I thought I should bring to your attention.
1. Creating a new spell via "copy" command and writing changes to the database works with both Firefox and IE on both PCs. But if you alter a spell, for instance just the name of the new spell AFTER you write the new spell to the database it will not change anything. This applies to all spells currently in the database already.
It appears that anything that already exists in the database is not being overridden when writing changes to the database. I think of all functions available with your editor, that one would be essential as it saves a lot of time having to export to Spell IO to make changes to any spells that already exist.
I'm not sure if this is an actual function of this feature, to re-write changes over existing spell entries, or not. But logic tells me that's the way you designed it to function. It just isn't, unfortunately.
If I am understanding the issue correctly, you are importing from a spells_us.txt then writing your changes to the database and it is only updating the ones you have changed. Write Changes will write only the spells that have been altered since the last import/save/write. Full Write will write everything to the database no matter if it has been changed or not. I did it this way for performance reasons since doing a full write to the database can take a very long time.
So if you want to get the spells in your spells_us.txt into your database, you will need to import from file, then full write to the database. Then any other time you want to load your spells, you can do so directly from the database and just save off a spells_us.txt when you need to make a version for your players.
If this isn't the problem that you are having, can you give me step by step instructions of what you are doing so I can reproduce it?
2. This one is quite minor because there's an easy work around, but the bottom of the login portion (the reset and submit buttons specifically) of the editor is cut off on my 19 inch CRT monitor running 10x7 resolution. Changing my resolution to 16x12 certainly fixes that issue, but of course text is so small you practically have to face-plant the monitor to read entries in the database.
I don't have a problem on my laptop because it naturally runs a higher resolution than my desktop does, and that's the PC I use for my server. Like I said a minor issue.
Might I suggest a fix to widen the login screen horizontally, so it doesn't extend so much vertically? I think that would certainly fix any and all issues regarding different user resolution settings, and we all know that everyone has their preferences that vary as much as the people themselves.
I thought it would scale but I just tested it and yea, it really doesnt like that low of a resolution. I'll try and get it a bit more friendly with lower resolutions in the future.
still does not work for me on newest db Rev it just wipes the table and stops
When you get to the login screen, does the version in the uper right hand corner of the login window say 'v1.1.9'?
Can you double check that the fields in your database are the same as the fields listed by AudioGarden21?
If they are, can you check that the user that are you using to log into mysql has proper permissions to insert/update?
The version is v1.19, and im using Root to login the spell fields Look the same but i might of missed one so exported them from my db and Pasted em here,
btw thanks for the Super fast responce and all your hard word on this Fine Tool
`id`
`name`
`player_1`
`teleport_zone`
`you_cast`
`other_casts`
`cast_on_you`
`cast_on_other`
`spell_fades`
`range`
`aoerange`
`pushback`
`pushup`
`cast_time`
`recovery_time`
`recast_time`
`buffdurationformula`
`buffduration`
`AEDuration`
`mana`
`effect_base_value1`
`effect_base_value2`
`effect_base_value3`
`effect_base_value4`
`effect_base_value5`
`effect_base_value6`
`effect_base_value7`
`effect_base_value8`
`effect_base_value9`
`effect_base_value10`
`effect_base_value11`
`effect_base_value12`
`effect_limit_value1`
`effect_limit_value2`
`effect_limit_value3`
`effect_limit_value4`
`effect_limit_value5`
`effect_limit_value6`
`effect_limit_value7`
`effect_limit_value8`
`effect_limit_value9`
`effect_limit_value10`
`effect_limit_value11`
`effect_limit_value12`
`max1`
`max2`
`max3`
`max4`
`max5`
`max6`
`max7`
`max8`
`max9`
`max10`
`max11`
`max12`
`icon`
`memicon`
`components1`
`components2`
`components3`
`components4`
`component_counts1`
`component_counts2`
`component_counts3`
`component_counts4`
`NoexpendReagent1`
`NoexpendReagent2`
`NoexpendReagent3`
`NoexpendReagent4`
`formula1`
`formula2`
`formula3`
`formula4`
`formula5`
`formula6`
`formula7`
`formula8`
`formula9`
`formula10`
`formula11`
`formula12`
`LightType`
`goodEffect`
`Activated`
`resisttype`
`effectid1`
`effectid2`
`effectid3`
`effectid4`
`effectid5`
`effectid6`
`effectid7`
`effectid8`
`effectid9`
`effectid10`
`effectid11`
`effectid12`
`targettype`
`basediff`
`skill`
`zonetype`
`EnvironmentType`
`TimeOfDay`
`classes1`
`classes2`
`classes3`
`classes4`
`classes5`
`classes6`
`classes7`
`classes8`
`classes9`
`classes10`
`classes11`
`classes12`
`classes13`
`classes14`
`classes15`
`classes16`
`CastingAnim`
`TargetAnim`
`TravelType`
`SpellAffectIndex`
`field124`
`field125`
`deities1`
`deities2`
`deities3`
`deities4`
`deities5`
`deities6`
`deities7`
`deities8`
`deities9`
`deities10`
`deities11`
`deities12`
`deities13`
`deities14`
`deities15`
`deities16`
`field142`
`field143`
`new_icon`
`spellanim`
`uninterruptable`
`ResistDiff`
`dot_stacking_exempt`
`deleteable`
`RecourseLink`
`field151`
`field152`
`field153`
`short_buff_box`
`descnum`
`typedescnum`
`effectdescnum`
`field158`
`field159`
`field160`
`field161`
`bonushate`
`field163`
`field164`
`field165`
`EndurCost`
`EndurTimerIndex`
`field168`
`field169`
`field170`
`field171`
`field172`
`HateAdded`
`EndurUpkeep`
`field175` ,
`numhits`
`pvpresistbase`
`pvpresistcalc`
`pvpresistcap`
`spell_category`
`field181`
`field182`
`field183`
`field184`
`can_mgb`
`nodispell`
`npc_category`
`npc_usefulness`
`field189`
`field190`
`field191`
`field192`
`nimbuseffect`
`field194`
`field195`
`field196`
`field197`
`field198`
`field199`
`field200`
`field201`
`field202`
`field203`
`field204`
`field205`
`field206`
`spellgroup`
`field208`
`field209`
`field210`
`field211`
`allowrest`
`field213`
`field214`
Yea, they are identical...
When you login, are the drop down menus for all the pages populated? If they are not then it might be tripping up on the file parsing for the *.h files.
Are you using the most recent version of Flash?
The only other thing I can think of is that Flash is throwing an error silently... If you download and install the debug version of flash player then you will get error popups when flash has a problem. The only issue with the debug version is that -many- websites, even well known ones have all sorts of runtime errors that you will have to click past/ignore.
Here is a link to the IE debug player (http://download.macromedia.com/pub/flashplayer/updaters/10/flashplayer_10_ax_debug.exe)
Here is a link to the Firefox/Opera/Chrome debug player (http://download.macromedia.com/pub/flashplayer/updaters/10/flashplayer_10_ax_debug.exe)
Yep all the menu items are there and no errors from the Flash debug version, could it have something to do with the fact im running Mysql 5.1x instead of 5.0x?
I'm using 5.1 at home so probably not.
Can you try manually running these queries against your spells_new and let me know what happens?
TRUNCATE TABLE spells_new;
INSERT INTO spells_new(id, name, player_1, teleport_zone, you_cast, other_casts, cast_on_you, cast_on_other, spell_fades, range, aoerange, pushback, pushup, cast_time, recovery_time, recast_time, buffdurationformula, buffduration, AEDuration, mana, effect_base_value1, effect_base_value2, effect_base_value3, effect_base_value4, effect_base_value5, effect_base_value6, effect_base_value7, effect_base_value8, effect_base_value9, effect_base_value10, effect_base_value11, effect_base_value12, effect_limit_value1, effect_limit_value2, effect_limit_value3, effect_limit_value4, effect_limit_value5, effect_limit_value6, effect_limit_value7, effect_limit_value8, effect_limit_value9, effect_limit_value10, effect_limit_value11, effect_limit_value12, max1, max2, max3, max4, max5, max6, max7, max8, max9, max10, max11, max12, icon, memicon, components1, components2, components3, components4, component_counts1, component_counts2, component_counts3, component_counts4, NoexpendReagent1, NoexpendReagent2, NoexpendReagent3, NoexpendReagent4, formula1, formula2, formula3, formula4, formula5, formula6, formula7, formula8, formula9, formula10, formula11, formula12, LightType, goodEffect, Activated, resisttype, effectid1, effectid2, effectid3, effectid4, effectid5, effectid6, effectid7, effectid8, effectid9, effectid10, effectid11, effectid12, targettype, basediff, skill, zonetype, EnvironmentType, TimeOfDay, classes1, classes2, classes3, classes4, classes5, classes6, classes7, classes8, classes9, classes10, classes11, classes12, classes13, classes14, classes15, classes16, CastingAnim, TargetAnim, TravelType, SpellAffectIndex, field124, field125, deities1, deities2, deities3, deities4, deities5, deities6, deities7, deities8, deities9, deities10, deities11, deities12, deities13, deities14, deities15, deities16, field142, field143, new_icon, spellanim, uninterruptable, ResistDiff, dot_stacking_exempt, deleteable, RecourseLink, field151, field152, field153, short_buff_box, descnum, typedescnum, effectdescnum, field158, field159, field160, field161, bonushate, field163, field164, field165, EndurCost, EndurTimerIndex, field168, field169, field170, field171, field172, HateAdded, EndurUpkeep, field175, numhits, pvpresistbase, pvpresistcalc, pvpresistcap, spell_category, field181, field182, field183, field184, can_mgb, nodispell, npc_category, npc_usefulness, field189, field190, field191, field192, nimbuseffect, field194, field195, field196, field197, field198, field199, field200, field201) VALUES(3,"Summon Corpse","PLAYER_1","","","","","","",10000,0,0,0,5000,2250,12000,0,0,0,700,70,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,2512,2106,17355,-1,-1,-1,1,1,1,1,-1,-1,-1,-1,100,100,100,100,100,100,100,100,100,100,100,100, 0,1,0,0,91,254,254,254,254,254,254,254,254,254,254 ,254,5,20,14,-1,0,0,255,255,255,255,51,255,255,255,255,255,255,2 55,255,255,255,255,43,0,0,4,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,100,0,109,83,0,0,0,0,0,0,0,0,0,3,125 ,64,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,101,49 ,52,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0);
SQL Error (1064): You have an error in your SQL syntax: Check the Manual Thate corresponds to your Mysql server version for the right syntax to use near 'range, aoerange, puchback, pushup, cast_time, recovery_time. recast_time. buffdu' at line 1
AudioGarden21
07-16-2010, 07:56 AM
I know exactly what he's talking about Null. I had this issue before your update as well.
Forgive me if I hadn't explained the issue as clearly as I thought.
So allow me to reiterate what's happening for me.
Step 1.
Log into the database, Load URLS and spell file from database works great now.
Step 2.
Copy any spell in the list, then click "Write Changes to Database". Check HeidiSQL and the new spell is visible, there is a copy of a custom spell of mine called "Recall". Database shows "Copy of Recall".
Step 3.
Change the name of the copy of the custom spell to "Copy of Recall Test", then click "Write Changes to Database". Check HeidiSQL and the file name is exactly the same as it was before, "Copy of Recall". No change took place.
The only function that works for me and "Write Changes to Database" is the "Copy" function. The Delete function doesn't work, nor does altering any data on a spell, including something simple like the name.
GaG's issue stems from the same issue as "Write Changes to Database". Neither functions are doing what they're supposed to do, which is alter the database.
As for "Full Write to Database" it will clear the database (it did this to me before I even posted on this thread), but it won't write anything.
Writing changes to database, full write, and delete do not write anything unfortunately. The only thing that actually writes any change to the database is the "Copy" function. You can copy something, alter it, then write that change to the database, but after you write that change you can no longer write further changes to that same spell you just copied. Basically a one-shot deal.
This applies also to spells that are in the spells_new file already.
It appears that the ability to write completely new rows is functioning only with the "Copy" function (as seen in the case when copying a spell and writing a whole new row) but you cannot update a spell after it has been inserted and saved into a row on the database.
I hope I've made it a little more clear this time around.
You've been a great help with this tool and your support for it. I'm behind it all the way and I hope that we here in this thread can make it the highlight of spell editing tools. Love ya George but you have enough tools that we all love, so you can share some of the lime-light. =p
You've done a great job Null, keep it up!
I am pretty sure I fixed the problem. Apparently I rolled my face across the keyboard when I was updating my queries and caused a whole mess of issues. I added an error message so next time this happens it will be more apparent.
Null Spell Editor v1.1.10 (http://dl.dropbox.com/u/7751891/NullSpellEdit_1.1.10.7z)
Null Spell Editor v1.1.10 (No Videos) (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.1.10.7z)
Let me know if you have any other issues.
AudioGarden21
07-17-2010, 01:05 AM
I am pretty sure I fixed the problem. Apparently I rolled my face across the keyboard when I was updating my queries and caused a whole mess of issues. I added an error message so next time this happens it will be more apparent.
Null Spell Editor v1.1.10 (http://dl.dropbox.com/u/7751891/NullSpellEdit_1.1.10.7z)
Null Spell Editor v1.1.10 (No Videos) (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.1.10.7z)
Let me know if you have any other issues.
LMAO! Well, I'm restarting my laptop (which runs my server) currently but I will be sure to check it and get back to you as soon as it's done.
EDIT
Congratulations on a job well done Null. You are the frickin' man. Now all you have left is that minor issue we discussed earlier (I don't really care one way or another as long as the function of the program is operable) and you can call this a finished product ready for shipping.
I'm quite excited to have this fix to writing changes to the database because it saves me soooo much time testing spells. Before this fix I had to make the adjustments to the spell I was working on, export it, then use the GeorgeS' Spell IO program, which would take about 1 minute or 2 to finalize. Considering I only want to make a few minor adjustments to a single spell at a time, you can see how that adds up...
With this new version I can bypass all of that completely by just writing the changes and ignoring spells that are already there.
Thank you so much Null. You're a life saver. I've actually put off spell adjustments until this was fixed because I simply dreaded all the time involved in doing so.
Way to go Null, way to go. You're my new hero.
P.S. - Null for President! *throws ticker tape*
EDIT 2
I just tested the "Delete" function and it's still on the fritz. Not that I care because deleting a spell manually isn't a big deal. As long as write changes works, I'm a happy camper. I just thought you'd like to know though.
I also tested "Full Write to Database" and that is functioning beautifully too. It does the full write AND removes spells that were deleted using the "Delete" function which fails to do it's job.
So everything is in pristine order other than the login screen layout and delete function, so once you've addressed those issues you're golden hoss.
P.S. - Your "Full Write to Database" function is probably 100 times faster than Spell IO. It literally takes about 3 seconds. A superior spell editor to anything else I've used.
I have a fixes for delete and the positioning issue you were having, but I want to test it in the morning when I am a bit more sober.
Changes
Redid Delete Functionality so that it will only mark a spell for deletion, but will not actually preform the delete until a write is preformed. (it actually works now too) Improved the Searching functionality so it will take into account the search string, search filter and changed check box at the same time. Previously it would best case only take into account two of them. Changed the Copy Incrementation so that if it finds a roman numeral or numeric value in the spell name, it will increment that value (III changes to IV or 3 changes to 4) Added Undelete Spell and Undelete All to the menu drop downs.
I also moved the initialization panel so that it would be fully viewable at lower resolutions.
Null Spell Editor v1.2 (http://dl.dropbox.com/u/7751891/NullSpellEdit_1.2.7z)
Null Spell Editor v1.2 (No Video) (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.2.7z)
Enjoy!
AudioGarden21
07-18-2010, 03:26 AM
I think you're done Null. Stick a fork in it.
Way to go man. I'm sure the community will be thankful for your hard work and diligence on this project. I know I am.
Have a good one Null.
Cheers!
Akkadius
07-24-2010, 01:45 PM
Very very great editor once again. I do have one request though. An option to select a spell a reassign it to an id that is free of the lowest number (for the sake of Titanium clients). For example I weeded out spells that don't need to be used by us, but to be able to auto snap a new spell to a ID that is the lowest in the free range without conflicting and playing a guessing game would be awesome. Thanks tons Null!
I have a new version up. If you pull your spdat.h from google code then you will need to use this version to get your pull downs populated correctly.
Changes
Updated the parsing for spdat.h on the latest enum formatting for google code. This change should work with the old way of formatting, so dont worry about your custom/outdated local files throwing up. Added 'Set to Lowest ID' to the Spells menu. This will move a spell file to the lowest possible unused ID. It works with revert so that if you accidentally press it or otherwise decide the old id was better, you can send it back. Thanks Akkadius for this idea. Did some minor text changes so that fields were a little more descriptive.
Download Links
Null Spell Editor v1.3 (http://dl.dropbox.com/u/7751891/NullSpellEdit_1.3.7z)
Null Spell Editor v1.3 (No Videos) (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.3.7z)
Enjoy the new build, and let me know if you have any issues or requests!
Bellos
07-27-2010, 08:41 PM
Hey i can connect and everything but it seems like the changes are being saved to my spell file. I mean it looks like it in the editor, but when i try to add a spell to an item like a clicky. It doesnt show up in my spell list.
Im using georges item editor. Also im on titanium.
GeorgeS
07-27-2010, 09:41 PM
The file needs to be imported into the database first, then the editor will see the spells. I sent a pm regarding this.
GeorgeS
pfyon
09-18-2010, 02:44 PM
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?
pfyon
09-21-2010, 05:33 PM
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:
mysql> show columns in spells_new;
+----------------------+--------------+------+-----+------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+------------+-------+
| id | int(11) | NO | PRI | 0 | |
| name | varchar(64) | YES | | NULL | |
| player_1 | varchar(64) | YES | | BLUE_TRAIL | |
| teleport_zone | varchar(64) | YES | | NULL | |
| you_cast | varchar(120) | YES | | NULL | |
| other_casts | varchar(120) | YES | | NULL | |
| cast_on_you | varchar(120) | YES | | NULL | |
| cast_on_other | varchar(120) | YES | | NULL | |
| spell_fades | varchar(120) | YES | | NULL | |
| range | int(11) | NO | | 100 | |
| aoerange | int(11) | NO | | 0 | |
| pushback | int(11) | NO | | 0 | |
| pushup | int(11) | NO | | 0 | |
| cast_time | int(11) | NO | | 0 | |
| recovery_time | int(11) | NO | | 0 | |
| recast_time | int(11) | NO | | 0 | |
| buffdurationformula | int(11) | NO | | 7 | |
| buffduration | int(11) | NO | | 65 | |
| AEDuration | int(11) | NO | | 0 | |
| mana | int(11) | NO | | 0 | |
| effect_base_value1 | int(11) | NO | | 100 | |
| effect_base_value2 | int(11) | NO | | 0 | |
| effect_base_value3 | int(11) | NO | | 0 | |
| effect_base_value4 | int(11) | NO | | 0 | |
| effect_base_value5 | int(11) | NO | | 0 | |
| effect_base_value6 | int(11) | NO | | 0 | |
| effect_base_value7 | int(11) | NO | | 0 | |
| effect_base_value8 | int(11) | NO | | 0 | |
| effect_base_value9 | int(11) | NO | | 0 | |
| effect_base_value10 | int(11) | NO | | 0 | |
| effect_base_value11 | int(11) | NO | | 0 | |
| effect_base_value12 | int(11) | NO | | 0 | |
| effect_limit_value1 | int(11) | NO | | 0 | |
| effect_limit_value2 | int(11) | NO | | 0 | |
| effect_limit_value3 | int(11) | NO | | 0 | |
| effect_limit_value4 | int(11) | NO | | 0 | |
| effect_limit_value5 | int(11) | NO | | 0 | |
| effect_limit_value6 | int(11) | NO | | 0 | |
| effect_limit_value7 | int(11) | NO | | 0 | |
| effect_limit_value8 | int(11) | NO | | 0 | |
| effect_limit_value9 | int(11) | NO | | 0 | |
| effect_limit_value10 | int(11) | NO | | 0 | |
| effect_limit_value11 | int(11) | NO | | 0 | |
| effect_limit_value12 | int(11) | NO | | 0 | |
| max1 | int(11) | NO | | 0 | |
| max2 | int(11) | NO | | 0 | |
| max3 | int(11) | NO | | 0 | |
| max4 | int(11) | NO | | 0 | |
| max5 | int(11) | NO | | 0 | |
| max6 | int(11) | NO | | 0 | |
| max7 | int(11) | NO | | 0 | |
| max8 | int(11) | NO | | 0 | |
| max9 | int(11) | NO | | 0 | |
| max10 | int(11) | NO | | 0 | |
| max11 | int(11) | NO | | 0 | |
| max12 | int(11) | NO | | 0 | |
| icon | int(11) | NO | | 0 | |
| memicon | int(11) | NO | | 0 | |
| components1 | int(11) | NO | | -1 | |
| components2 | int(11) | NO | | -1 | |
| components3 | int(11) | NO | | -1 | |
| components4 | int(11) | NO | | -1 | |
| component_counts1 | int(11) | NO | | 1 | |
| component_counts2 | int(11) | NO | | 1 | |
| component_counts3 | int(11) | NO | | 1 | |
| component_counts4 | int(11) | NO | | 1 | |
| NoexpendReagent1 | int(11) | NO | | -1 | |
| NoexpendReagent2 | int(11) | NO | | -1 | |
| NoexpendReagent3 | int(11) | NO | | -1 | |
| NoexpendReagent4 | int(11) | NO | | -1 | |
| formula1 | int(11) | NO | | 100 | |
| formula2 | int(11) | NO | | 100 | |
| formula3 | int(11) | NO | | 100 | |
| formula4 | int(11) | NO | | 100 | |
| formula5 | int(11) | NO | | 100 | |
| formula6 | int(11) | NO | | 100 | |
| formula7 | int(11) | NO | | 100 | |
| formula8 | int(11) | NO | | 100 | |
| formula9 | int(11) | NO | | 100 | |
| formula10 | int(11) | NO | | 100 | |
| formula11 | int(11) | NO | | 100 | |
| formula12 | int(11) | NO | | 100 | |
| LightType | int(11) | NO | | 0 | |
| goodEffect | int(11) | NO | | 0 | |
| Activated | int(11) | NO | | 0 | |
| resisttype | int(11) | NO | | 0 | |
| effectid1 | int(11) | NO | | 254 | |
| effectid2 | int(11) | NO | | 254 | |
| effectid3 | int(11) | NO | | 254 | |
| effectid4 | int(11) | NO | | 254 | |
| effectid5 | int(11) | NO | | 254 | |
| effectid6 | int(11) | NO | | 254 | |
| effectid7 | int(11) | NO | | 254 | |
| effectid8 | int(11) | NO | | 254 | |
| effectid9 | int(11) | NO | | 254 | |
| effectid10 | int(11) | NO | | 254 | |
| effectid11 | int(11) | NO | | 254 | |
| effectid12 | int(11) | NO | | 254 | |
| targettype | int(11) | NO | | 2 | |
| basediff | int(11) | NO | | 0 | |
| skill | int(11) | NO | | 98 | |
| zonetype | int(11) | NO | | -1 | |
| EnvironmentType | int(11) | NO | | 0 | |
| TimeOfDay | int(11) | NO | | 0 | |
| classes1 | int(11) | NO | | 255 | |
| classes2 | int(11) | NO | | 255 | |
| classes3 | int(11) | NO | | 255 | |
| classes4 | int(11) | NO | | 255 | |
| classes5 | int(11) | NO | | 255 | |
| classes6 | int(11) | NO | | 255 | |
| classes7 | int(11) | NO | | 255 | |
| classes8 | int(11) | NO | | 255 | |
| classes9 | int(11) | NO | | 255 | |
| classes10 | int(11) | NO | | 255 | |
| classes11 | int(11) | NO | | 255 | |
| classes12 | int(11) | NO | | 255 | |
| classes13 | int(11) | NO | | 255 | |
| classes14 | int(11) | NO | | 255 | |
| classes15 | int(11) | NO | | 255 | |
| classes16 | int(11) | NO | | 255 | |
| CastingAnim | int(11) | NO | | 44 | |
| TargetAnim | int(11) | NO | | 13 | |
| TravelType | int(11) | NO | | 0 | |
| SpellAffectIndex | int(11) | NO | | -1 | |
| field124 | int(11) | NO | | 0 | |
| field125 | int(11) | NO | | 0 | |
| deities1 | int(11) | NO | | 0 | |
| deities2 | int(11) | NO | | 0 | |
| deities3 | int(11) | NO | | 0 | |
| deities4 | int(11) | NO | | 0 | |
| deities5 | int(11) | NO | | 0 | |
| deities6 | int(11) | NO | | 0 | |
| deities7 | int(11) | NO | | 0 | |
| deities8 | int(11) | NO | | 0 | |
| deities9 | int(11) | NO | | 0 | |
| deities10 | int(11) | NO | | 0 | |
| deities11 | int(11) | NO | | 0 | |
| deities12 | int(12) | NO | | 0 | |
| deities13 | int(11) | NO | | 0 | |
| deities14 | int(11) | NO | | 0 | |
| deities15 | int(11) | NO | | 0 | |
| deities16 | int(11) | NO | | 0 | |
| field142 | int(11) | NO | | 100 | |
| field143 | int(11) | NO | | 0 | |
| new_icon | int(11) | NO | | 161 | |
| spellanim | int(11) | NO | | 0 | |
| uninterruptable | int(11) | NO | | 0 | |
| ResistDiff | int(11) | NO | | -150 | |
| dot_stacking_exempt | int(11) | NO | | 0 | |
| deleteable | int(11) | NO | | 0 | |
| RecourseLink | int(11) | NO | | 0 | |
| field151 | int(11) | NO | | 0 | |
| field152 | int(11) | NO | | 0 | |
| field153 | int(11) | NO | | 0 | |
| short_buff_box | int(11) | NO | | -1 | |
| descnum | int(11) | NO | | 0 | |
| typedescnum | int(11) | YES | | NULL | |
| effectdescnum | int(11) | YES | | NULL | |
| field158 | int(11) | YES | | NULL | |
| field159 | int(11) | NO | | 0 | |
| field160 | int(11) | NO | | 0 | |
| field161 | int(11) | NO | | 0 | |
| bonushate | int(11) | NO | | 0 | |
| field163 | int(11) | NO | | 100 | |
| field164 | int(11) | NO | | -150 | |
| field165 | int(11) | NO | | 0 | |
| EndurCost | int(11) | NO | | 0 | |
| EndurTimerIndex | int(11) | NO | | 0 | |
| field168 | int(11) | NO | | 0 | |
| field169 | int(11) | NO | | 0 | |
| field170 | int(11) | NO | | 0 | |
| field171 | int(11) | NO | | 0 | |
| field172 | int(11) | NO | | 0 | |
| HateAdded | int(11) | NO | | 0 | |
| EndurUpkeep | int(11) | NO | | 0 | |
| field175 | int(11) | YES | | NULL | |
| numhits | int(11) | NO | | 0 | |
| pvpresistbase | int(11) | NO | | -150 | |
| pvpresistcalc | int(11) | NO | | 100 | |
| pvpresistcap | int(11) | NO | | -150 | |
| spell_category | int(11) | NO | | -99 | |
| field181 | int(11) | NO | | 7 | |
| field182 | int(11) | NO | | 65 | |
| field183 | int(11) | NO | | 0 | |
| field184 | int(11) | NO | | 0 | |
| can_mgb | int(11) | NO | | 0 | |
| nodispell | int(11) | NO | | -1 | |
| npc_category | int(11) | NO | | 0 | |
| npc_usefulness | int(11) | NO | | 0 | |
| field189 | int(11) | NO | | 0 | |
| field190 | int(11) | NO | | 0 | |
| field191 | int(11) | NO | | 0 | |
| field192 | int(11) | NO | | 0 | |
| nimbuseffect | int(11) | YES | | 0 | |
| field194 | int(11) | NO | | 0 | |
| field195 | int(11) | NO | | 0 | |
| field196 | int(11) | NO | | 0 | |
| field197 | int(11) | NO | | 0 | |
| field198 | int(11) | NO | | 0 | |
| field199 | int(11) | NO | | 1 | |
| field200 | int(11) | NO | | 0 | |
| field201 | int(11) | NO | | 0 | |
| field202 | int(11) | NO | | 0 | |
| field203 | int(11) | YES | | 0 | |
| field204 | int(11) | YES | | 0 | |
| field205 | int(11) | YES | | 0 | |
| field206 | int(11) | YES | | -1 | |
| spellgroup | int(11) | YES | | 0 | |
| field208 | int(11) | YES | | 0 | |
| field209 | int(11) | YES | | 0 | |
| field210 | int(11) | YES | | 1 | |
| field211 | int(11) | YES | | 0 | |
| allowrest | int(11) | YES | | 0 | |
| field213 | int(11) | YES | | 1 | |
| field214 | int(11) | YES | | 1 | |
+----------------------+--------------+------+-----+------------+-------+
215 rows in set (0.02 sec)
pfyon
09-21-2010, 05:35 PM
And here's the error reported by the editor:
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
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
mysql> insert into blind values (1,'test','test',1);
Query OK, 1 row affected (0.24 sec)
with table
mysql> show columns in blind;
+-------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| col1 | varchar(45) | NO | | NULL | |
| col2 | varchar(45) | NO | | NULL | |
| col3 | int(10) unsigned | NO | | NULL | |
+-------+------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
It works fine.
mysql> select * from blind;
+----+------+------+------+
| id | col1 | col2 | col3 |
+----+------+------+------+
| 1 | test | test | 1 |
+----+------+------+------+
1 row in set (0.00 sec)
There's probably a better way to auto insert the index, though.
Funkey Monkey
10-07-2010, 07:29 PM
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.
Templus
11-08-2010, 10:24 AM
can't seem to get it to connect to my database :( not sure why, I enter in all the information correctly
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 (http://dl.dropbox.com/u/7751891/NullSpellEdit_1.8.rar)
Null Spell Editor v1.8 (No Video) (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.8.rar)
deaddraqear
04-19-2011, 01:57 PM
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 (http://dl.dropbox.com/u/7751891/NullSpellEdit_1.8.1.rar)
1.8.1 (no video) (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.8.1.rar)
Akkadius
04-26-2011, 08:19 PM
Fixed!
1.8.1 (http://dl.dropbox.com/u/7751891/NullSpellEdit_1.8.1.rar)
1.8.1 (no video) (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.8.1.rar)
Null, you are the man!
Astal
05-03-2011, 08:51 PM
Fixed!
1.8.1 (http://dl.dropbox.com/u/7751891/NullSpellEdit_1.8.1.rar)
1.8.1 (no video) (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.8.1.rar)
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.
Astal
05-04-2011, 06:53 PM
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.
I went back and tried what you did, setting the ID to 3500 and it exploded...silently. I fixed the bug and here is the build:
1.8.2 (http://dl.dropbox.com/u/7751891/NullSpellEdit_1.8.2.rar)
1.8.2 (no video) (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.8.2.rar)
Let me know if it gives you anymore troubles.
Astal
05-05-2011, 04:16 PM
I went back and tried what you did, setting the ID to 3500 and it exploded...silently. I fixed the bug and here is the build:
1.8.2 (http://dl.dropbox.com/u/7751891/NullSpellEdit_1.8.2.rar)
1.8.2 (no video) (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.8.2.rar)
Let me know if it gives you anymore troubles.
will do thanks man
Astal
05-19-2011, 11:59 PM
nevermind, sigh
krujo81
08-21-2011, 01:19 AM
Hay i was wondering if you keep up with this anymore?. i been waiting on a vearsion that lets me edit spell id and target type.
the current target type box is empty. and as for the edit spell id's i was wondering if it was posabile to notice holes in the spellfile id's like for example 2345 2346-2350 and you could select any of the open ID's to put in your spell before just adding to the next highest ID
I believe I fixed the target type drop down issue, the formatting changed in one of the header files so I had to update it.
The editor should have a 'Set to Lowest ID' menu option under spells, let me know if that does what you want.
Here is the new build:
Null Spell Editor v1.8.3 (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.8.3.rar)
lerxst2112
09-08-2011, 08:29 PM
Thanks Null! The target type is working fine for me now. :)
krujo81
09-08-2011, 11:34 PM
Hay null thanks for the update the only thing about the find next id's i was talking about is for some reason i was told Not to use spell id 0-3? cant remember how many but i know 0-2 for sure wasn't to be used. so i was hopeing it could scan the file and find all id's then give you refrence slots like it would see the 0-3 and 400-800 and 700-1000 and then lets say you edit the ID to 701 and the next scan would show 700 702-1000
1.8.3 with videos as requested:
http://dl.dropbox.com/u/7751891/NullSpellEdit_1.8.3.rar
AudioGarden21
01-17-2012, 02:57 AM
Hey Null! Been a while man. I want to thank you again for all the work you've done on this editor.
I just recently came across an issue with assigning requirements to spells. For some reason the diety/dieties I select won't stick. I'm trying to create a diety restricted spell for the purpose of making custom spells for each class/diety mix. After I assign the diety, if I select the spell on the left side of the menu again, it shows a check mark for a diety other than the one I'm trying to assign.
Here's an example:
I select Yaulp, a level 1 Cleric spell, and assign it to Innoruuk. If I reselect the spell on the left side box again, it shows Quellious as checked instead of Inny. If I try to uncheck Quellious, then reselect the spell again on the left side, it still shows as checked. In order to clear that check mark from Quellious, I have to check Innoruuk, uncheck it, then reselect the spell to clear Quellious.
All I know is, that feature is functioning completely out of whack and I'm not sure why. Some help would be appreciated.
QUICK RUN DOWN
Check Innoruuk
Select spell
Quellious checked instead of Innoruuk
Select spell
Check Innoruuk
Uncheck Innoruuk
Select spell
Quellious deselected
The rest seem to be pretty much the same in that they don't select/deselect as they should.
EDIT
Here's a quick edit to give a run down of what check selects what diety:
Bertoxxulos - works fine, selects and deselects no problem
Cazic Thule - selects Brell Serilis, check/uncheck Cazic Thule to deselect Brell Serilis
Bristlebane - selects Cazic Thule, check/uncheck Bristlebane to deselect Cazic Thule
Karana - selects Erollisi Marr, check/uncheck Karana to deselect Erollisi Marr
Prexus - selects Bristlebane, check/uncheck Prexus to deselect Bristlebane
Rallos Zek - selects Innoruuk, check/uncheck Rallos Zek to deselect Bristlebane
Solusek Ro - selects Karana, check/uncheck Solusek Ro to deselect Karana
Tunare - works fine, selects and deselects no problem
Brell Serilis - selects Mithaniel Marr, check/uncheck Brell Serilis to deselect Mithaniel Marr
Erollisi Marr - selects Prexus, check/uncheck Erollisi Marr to deselect Prexus
Innoruuk - selects Quellious, check/uncheck Quellious to deselect Quellious
Mithaniel Marr - selects Rallos Zek, check/uncheck Mithaniel Marr to deselect Rallos Zek
Quellious - selects Rodcet Nife, check/uncheck Quellious to deselect Rodcet Nife
Rodcet Nife - selects Solusek Ro, check/uncheck Rodcet Nife to deselect Solusek Ro
The Tribunal - works fine, selects and deselects no problem
Clearly there's an issue with the linkage of the selection boxes and the proper diety.
Here's an easier to read summary:
Broken
Cazic Thule > Brell Serilis
Bristlebane > Cazic Thule
Karana > Erollisi Marr
Prexus > Bristlebane
Rallos Zek > Innoruuk
Solusek Ro > Karana
Brell Serilis > Mithaniel Marr
Erollisi Marr > Prexus
Innoruuk > Quellious
Mithaniel Marr > Rallos Zek
Quellious > Rodcet Nife
Rodcet Nife > Solusek Ro
Working
Bertoxxulos
Tunare
The Tribunal
EDIT 2
Well, it seems through my testing you can cast a spell regardless of your class diety and whether or not you set it for a specific diety (just tested with a Gnome Cleric following Brell Serillis using a spell restricted to Innoruuk in the spell file), so I guess it's irrelevant in the end. The only way to limit a specific spell is on the scroll itself, from what I've seen, but it would still be nice to get that fixed if there is any reason for it existing outside of my tests.
AudioGarden21
01-17-2012, 08:01 AM
It has come to my attention that some spells have what could be considered charges. Take for example the spell Burning Aura (http://everquest.allakhazam.com/db/spell.html?spell=8038). It has a maximum of 240 charges before it dissipates. Field175 I believe refers to the type of spell being used, and only spells that have the numhits field populated have anything in field175. Burning Aura has a value of 1 in Field175, for example.
I looked and the values range between 1-9 (minus 4) and I've cross checked each of them with several spells in each value, but I couldn't link them to anything specific on the spell data from Allakhazam.
I thought it was liked to Category on Allakhazam, but I came across several anomalies that didn't seem to welcome that theory, however.
Caryatis
01-17-2012, 08:24 PM
It is a category, its called "numhits_type" on what.the.fizzle(alla is pretty useless for anything higher end... spell parser-wise)
This is from an old server of mine when I combed through w.t.f and organized them as best I could:
NUMHIT_AEMAX = 0, // max target in cone/beam/unknown(32) spells
NUMHIT_INCOMINGMELEE = 1, // melee hits landing on you
NUMHIT_OFFENSIVEMELEE = 2, // outgoing melee attacks
NUMHIT_INCOMINGDETRISPELL = 3, // incoming detrimental spells
NUMHIT_OFFENSIVECAST = 4, // spells/procs
NUMHIT_OFFENSIVEMELEE2 = 5, // All melee skills
NUMHIT_INCOMINGMELEE2 = 6, // same
NUMHIT_CASTSPELL = 7, // any cast spell matching focus
NUMHIT_ANYDAMAGE = 8, // spell or melee dmg
NUMHIT_INCOMINGDETRISPELL2 = 9, // guessed
NUMHIT_SPELLPROC = 10, // buff procs etc
NUMHIT_SPELLPROC2 = 11 // same
The current numhits code is pretty sloppy(mostly my bad) but it gets the job done. I do have a diff of all the categories incorporated unfortunately its mixed with 15k other lines and it was mainly cosmetic. For example, Skin of the Reptile is numhits_type 10 which means its numhits only last for XX buff procs but the code currently checks for buffs like this on every melee swing so the field is not needed in that instance.
Its not ideal however as we have bits all over and to add support for other types means spreading even more around.
AudioGarden21
01-17-2012, 09:10 PM
It is a category, its called "numhits_type" on what.the.fizzle(alla is pretty useless for anything higher end... spell parser-wise)
This is from an old server of mine when I combed through w.t.f and organized them as best I could:
NUMHIT_AEMAX = 0, // max target in cone/beam/unknown(32) spells
NUMHIT_INCOMINGMELEE = 1, // melee hits landing on you
NUMHIT_OFFENSIVEMELEE = 2, // outgoing melee attacks
NUMHIT_INCOMINGDETRISPELL = 3, // incoming detrimental spells
NUMHIT_OFFENSIVECAST = 4, // spells/procs
NUMHIT_OFFENSIVEMELEE2 = 5, // All melee skills
NUMHIT_INCOMINGMELEE2 = 6, // same
NUMHIT_CASTSPELL = 7, // any cast spell matching focus
NUMHIT_ANYDAMAGE = 8, // spell or melee dmg
NUMHIT_INCOMINGDETRISPELL2 = 9, // guessed
NUMHIT_SPELLPROC = 10, // buff procs etc
NUMHIT_SPELLPROC2 = 11 // same
The current numhits code is pretty sloppy(mostly my bad) but it gets the job done. I do have a diff of all the categories incorporated unfortunately its mixed with 15k other lines and it was mainly cosmetic. For example, Skin of the Reptile is numhits_type 10 which means its numhits only last for XX buff procs but the code currently checks for buffs like this on every melee swing so the field is not needed in that instance.
Its not ideal however as we have bits all over and to add support for other types means spreading even more around.
Thanks for the clarification of the values, Caryatis, much appreciated.
I did notice that the numhits factor had no bearing on when or whether the spell would actually dissipate once those charges were met, so I knew there was some limiting factor in the code for the usefulness of numhits. You also mentioned that Skin of the Reptile uses type 10. When I was cross referencing the values for an explanation of their purpose, I saw that Reptile's value was set to 1 in my database. Do you think that the type value might play a factor in why most of my reverse procs don't function like I remember them functioning?
EDIT
I just tested Skin of the Reptile, setting numhits to 3 and numhits_type to 10, to see if it would dissipate after three procs but it doesn't seem to make any difference as it lasted the entire duration and proc'd 5 times. One thing of note though, it seems that average procs per minute limit the amount of procs that defensive procs are capable of putting out, which is contrary to what I remember happening. I'm pretty sure they're supposed to be independent of APM. I'm guessing there's no code implemented to take advantage of the numhits_type values in the spell file.
Caryatis
01-17-2012, 10:14 PM
I never said all types were working and the code I posted is from my server source, not the general source so the setting of that field is irrelevant.
Since I no longer commit, you might want to just do it yourself. Look at how it works for regular dmg shields and then add that in execweaponproc(which will work for any hit limited proc buff if you do it right).
chrsschb
02-28-2012, 03:13 AM
Having an issue with bard aoe songs trying to affect NPCs.
They hit players fine using the AEBard target type, but are also trying to hit npcs, returning a crap load of these errors:
Your spell did not take hold.
Over and over and over and over and over...
Any idea how to prevent this? Maybe a LimitTarget effect, but what value? Is there a different target type I can use? I've tried AECaster, AEClientv1, AEClientv2, etc.
Completely lost here.
sorvani
02-28-2012, 10:07 PM
you are completely lost but that's ok. i just tested a fix for it.
chrsschb
02-28-2012, 10:43 PM
you are completely lost but that's ok. i just tested a fix for it.
Let me know what it is, thanks.
sorvani
02-28-2012, 11:05 PM
just committed the change, get rev2105
chrsschb
02-29-2012, 12:09 AM
Guessing it's a source edit and not a SQL update since I can't grab it from the updates folder.
chrsschb
03-08-2012, 03:25 PM
I don't know what it is, maybe I'm just retarded but every spell I edit using this editor, doing things as simple as just modifying minimum values on a proc, completely breaks them.
For example, Shroud of Death. Normally this spell gives the Shadowknight a lifetap weapon proc for 50 damage/heal.
I modified this to be Level + Min, with min being 50. So it should be healing for 110 now at 60. No, instead it says it heals the NPC for 107.
screenshot showing the parts I edited, I changed minimum from -45 to 50, and maximum from 50 to 0:
http://downloads.overthetophosting.com/images/spelleditor.png
in-game results:
http://downloads.overthetophosting.com/images/wtf.png
ARGHHHH
sorvani
03-08-2012, 06:15 PM
It's a lifetap hence the negative number to damage the NPC and not heal it.
chrsschb
03-08-2012, 07:58 PM
It's a lifetap hence the negative number to damage the NPC and not heal it.
Doh, totally brain farted that one. So, how does that work with level + min if the number is supposed to be negative? I notice the maxes are all positive numbers.
Hateborne
04-02-2012, 07:40 PM
Does anyone have a link to the editor with videos? If no link, does anyone have the actual file? I can give a link to safely (and quickly) upload it.
Thank You!
-Hate
lerxst2112
04-02-2012, 09:37 PM
There is a link to the editor with the videos in this thread, you just need to read back a page or so:
http://www.eqemulator.org/forums/showpost.php?p=204254&postcount=68
Hateborne
04-05-2012, 11:09 AM
I read through, and missed it. I am rather embarassed at doing so.
Thank you again lerxst2112.
-Hate
AudioGarden21
04-30-2012, 06:37 PM
A simple Max Hits box (for numhits field from spell data) in the Effects tab would be very, very helpful Null. We would all appreciate it very much if you're still around.
Thanks.
A simple Max Hits box (for numhits field from spell data) in the Effects tab would be very, very helpful Null. We would all appreciate it very much if you're still around.
Thanks.
Here. (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.9.7z)
I placed it in the main tab to the right of spell name.
Enjoy!
AudioGarden21
05-03-2012, 10:48 AM
You are simply the best Null. <3
EDIT
When attempting to connect to database I get an error "Unknown column 'field193' in 'field list'.
I had a look at the database and field 193 seems to refer to nimbuseffect, as that's the only thing between field192 and field194.
lerxst2112
05-03-2012, 03:15 PM
What version of the editor are you using? field193 changed to nimbuseffect way back at rev 1548. Make sure you downloaded a recent version, and not the one from the initial post here.
You are simply the best Null. <3
EDIT
When attempting to connect to database I get an error "Unknown column 'field193' in 'field list'.
I had a look at the database and field 193 seems to refer to nimbuseffect, as that's the only thing between field192 and field194.
Ooops, had a flag set that targets an older version of the source, should be fixed now.
Here. (http://dl.dropbox.com/u/7751891/NullSpellEdit_no_video_1.9.1.7z)
AudioGarden21
05-06-2012, 08:33 AM
Like'a'bawce... =D
Hateborne
06-06-2012, 06:13 PM
Sorry to bother everyone, but getting "Error #2032" at the bottom. Started ~3 days ago and have not been able to use since. I've tried re-extracting both versions (vids/no-vids) and running the trustfall.bat files....nothing.
I couldn't find anything on forums about this. Is there some super obvious solution that I am overlooking?
-Hate
Drakiyth
06-08-2012, 04:46 PM
How in the world do you get these two things to work as a buff?
8.0 is the mod I want to give the bard for a limited time and 51 is All Bard Instrument mods. All the tests I've tried haven't shown any improvements when I check out my test bard in #mystats.
Also question: Is there any place/guide that has the right way to make these spell effects work? Where to put numbers etc?
http://i269.photobucket.com/albums/jj60/drakiyth/BardMods.png
Checked the spell_effects.cpp and it says it's handled elsewhere. ???
Nothing on either of these in spells.cpp either.
Drakiyth
06-09-2012, 01:35 PM
Anybody know how to get bard instruments going through here? I've tried.
AddIntrumentMod - 12, 41, 49, 54, 70 on min and special. - NOTHING
AllInstrumentMod - 12, 41, 49, 54, 70 on min and special. - NOTHING
Is this just broken? I notice on live they use the spell effects for their instrument mods. I need it for the Mystical Artist's 1.0 weapon buff.
Caryatis
06-09-2012, 02:36 PM
I suppose you never checked the spdat.h file(you know where all this is defined):
#define SE_AddInstrumentMod 260 // *not implemented
and from bonuses.cpp:
case SE_AllInstrumentMod:
{
if(effect_value > newbon->singingMod)
newbon->singingMod = effect_value;
if(effect_value > newbon->brassMod)
newbon->brassMod = effect_value;
if(effect_value > newbon->percussionMod)
newbon->percussionMod = effect_value;
if(effect_value > newbon->windMod)
newbon->windMod = effect_value;
if(effect_value > newbon->stringedMod)
newbon->stringedMod = effect_value;
break;
}
ie you don't need to use any other field but the effect_base_valueXX.
You say live uses spell effects to boost spells, yet you dont try to copy any live spells?
For example, if you had checked out Amplification (http://lucy.allakhazam.com/spellraw.html?id=2603&source=Live) you would have noticed it uses an entirely seperate spell effect(118 ) to boost the singing skill.
Last but not least, your testing method is quite lazy. All you did was open mystats and then get disappointed. Lets look at the mystats code since that takes like 5 seconds:
std::string bard_info = "";
if(GetClass() == BARD) {
bard_info = indP + "Singing: " + itoa(GetSingMod()) + "<br>" +
indP + "Brass: " + itoa(GetBrassMod()) + "<br>" +
indP + "String: " + itoa(GetStringMod()) + "<br>" +
indP + "Percussion: " + itoa(GetPercMod()) + "<br>" +
indP + "Wind: " + itoa(GetWindMod()) + "<br>";
}
The important bits are GetXXXMod, lets go deeper:
inline virtual sint16 GetStringMod() const { return itembonuses.stringedMod; }
So to recap, you create a spellbonus to songs, you then check that with a function that only returns the itembonuses and thus you assume the effects are broken and post twice about it.
Searching... not just for the forums!
Luccian
06-09-2012, 03:29 PM
Sorry to bother everyone, but getting "Error #2032" at the bottom. Started ~3 days ago and have not been able to use since. I've tried re-extracting both versions (vids/no-vids) and running the trustfall.bat files....nothing.
I couldn't find anything on forums about this. Is there some super obvious solution that I am overlooking?
-Hate
Been getting the same error. Glad it's not just me.
Drakiyth
06-09-2012, 04:13 PM
Hey Caryatis,
Thanks for your help, even though you were a total douche about it.
Amplification is considered "SINGING SKILL" which is not what I asked for - There are currently no ADDINSTRUMENTMOD OR ALLINSTRUMENTMOD effects in the spell data base. But I'll try it with just the base value without the special and see if it works. Did I piss in your cheerios or something, or do you have a vendetta against me because you're acting like a real tool towards me. If you have something to say, I'm all for talking to you one on one.
Optimus
06-09-2012, 05:39 PM
Booo.... I liked the first response better. He deserved it.
Drakiyth
06-09-2012, 05:45 PM
Gotta try and stay a bit professional and not lose my head over trolls. Honestly though, if anybody did talk to me like that in person I would break their jaw. He acted like a total asshole, no doubt about that. That didn't work, AllInstrumentMod does not work at all and if it does please tell me what I'm doing wrong and prove me wrong. I would love to be proven wrong on this issue.
Caryatis
06-09-2012, 07:37 PM
Honestly though, if anybody did talk to me like that in person I would break their jaw.
I love when people say this, I know in your head you think this sounds good but I wish you could see how others view you after saying that. Ill take a guess though...
Number of jaws you have broken in your life: 0
Number of assholes you have met in real life: Not 0
That didn't work, AllInstrumentMod does not work at all
Prove it. What did you do besides typing #mystats?
Drakiyth
06-09-2012, 07:49 PM
I've tested it with several songs and nothing has changed. With #mystats 0 all the way across the board on instrument mods. When equipping an item with instrument mods it's fine. It's the buff/spell effect that just won't work for shit for some reason.
-----------------------------------------------------------------------------------------------
AllInstrumentMod min / 80 / 0 / 0 / <-- that order. nothing happens.
AllInstrumentMod min / 8 / 0 / 0 / <-- that order. nothing happens.
AllInstrumentMod min+levelx 20 for shits /1 /80 / 0/0 nothing.
AllInstrumentMod min / 0 / 0 / 8 / <-- that order. nothing happens.
AllInstrumentMod min / 0 / 0 / 80 / <-- that order. nothing happens.
Caryatis
06-09-2012, 09:08 PM
Still not enough info. Good luck.
Sorry to bother everyone, but getting "Error #2032" at the bottom. Started ~3 days ago and have not been able to use since. I've tried re-extracting both versions (vids/no-vids) and running the trustfall.bat files....nothing.
I couldn't find anything on forums about this. Is there some super obvious solution that I am overlooking?
-Hate
Can you give me a screenshot?
Luccian
06-09-2012, 10:13 PM
http://i53.photobucket.com/albums/g64/slade127/Capture.png
wolfwalkereci
06-10-2012, 03:23 PM
Caryatis might come across like an ass but he provides good info if you take the time to look for it.
I remember when he gave out all the source to one of his previous servers.
Shame I lost it because it had some fun stuff in it.
Sinclipse
06-13-2012, 02:56 AM
It doesn't seem to want to connect to my DB with my Vista 32... Connects fine with my windows 7 though... Any possible reason?
Hateborne
06-14-2012, 11:55 AM
Can you give me a screenshot?
http://i185.photobucket.com/albums/x206/Bobtheamerican/EZ%20Server/error.png
Disregard the user id. Generic Win7 vbox :-P
-Hate
Sinclipse
06-18-2012, 05:14 PM
Error connecting to the DB on a Vista 32 bit. Tried the bat file, failed too. Any idea?
Disregard the user id. Generic Win7 vbox :-P
-Hate
Same error here on IE, Safari, and Firefox, possibly related to a flash update. I haven't used the editor for a few months so can't be sure on the cause.
Burningsoul
07-05-2012, 04:31 PM
Bumping, as I also have the same problem. W7 64 blah blah specs, just like JSR I also haven't used in a few months so flash update seems to be the issue.
Hateborne
07-24-2012, 10:31 PM
Ok, I am able to get the NO_VIDEO one to work now. I had to destroy the file created through the Trustfall.bat (which pointed to the editor with video) and re-run it to point to the NO_VIDEO one.
-Hate
BlackSunGM
10-16-2012, 02:51 PM
I tried to download this editor today and the link doesnt work. Does anyone have a copy i could snag? Thanks
Burningsoul
10-16-2012, 05:48 PM
I have a copy, when I get off work tonight I'll upload it if no one has beaten me to the punch.
GeorgeS
10-16-2012, 08:02 PM
I am upoading a copy now. Should be live in 10 min -- off the tool website
GeorgeS
Burningsoul
10-16-2012, 08:10 PM
Thanks a ton again GeorgeS, was about to upload it. If things fall through, I'll have an upload link ready.
GeorgeS
10-16-2012, 09:56 PM
No problem, you're welcome to upload a copy anyway. The rar is over 100MB!
GeorgeS
emuzual
10-18-2012, 04:55 PM
Thanks alots Georges
and in Bonus ggoggle nolonger say that the site might be infected
:D
BlackSunGM
10-19-2012, 08:11 PM
Havent been able to get this to write changes to my database. Found a newer version but I am having the above errors now the error #2032. How do other server admins edit spells? Is it by hand?
Can't find a way around this issue, including hate's suggestion. Anyone had any luck?
Disorder
01-25-2013, 01:42 AM
Greetings,
I'm unable to get the null editor to connect to my database.
http://i.imgur.com/AaJgdAO.png
I get a DB time out error.
I ran the trustfall file prior to opening the flash program. Also, my browser was closed when I ran it, etc. yadda yadda. :) Am I just entering the information incorrectly?
Thanks in advance!
Disorder
01-30-2013, 02:00 AM
I just realized that this doesn't seem to be maintained anymore. I can load spells using internet explorer instead of chrome, however it appears to be unable to read all the spell data or write to my DB. It was able to change my spells_us.text file.
Moving house at the moment, but in about 2 weeks I'll have an alternative editor ready for use.
*EDIT*
Highly unpolished version can be obtained here: http://users.tpg.com.au/reynoldj/spell%20editor/jsre+spell+editor+v0.1.zip
Basic edit/create/delete functionality is there. Please take precautions like backing up your spells_new table, as I haven't had time to do any real testing. It is a vb2010 express build and is installed by running setup.exe. I'll have limited internet over the next week or so but will get PM's.
wolfwalkereci
01-30-2013, 06:41 PM
Works fine using Firefox
For some reason I can't edit my last post, but the link is broken. Working link: http://users.tpg.com.au/Reynoldj/spell-editor/jsre-spelleditor-v0.1.zip
Bodmingaol
07-02-2013, 12:36 AM
Hello,
I downloaded and tried out the editor from GeorgeS site, and am rather impressed by it. There was one issue that I ran across. When I tried to get spels_us.txt from the database, there was a crash and this was the message:
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
The mysql server that I am running is 5.1.68-community. The spells_new table is fresh from rev 2506 with no changes or edits.
If this is an error on my end, please let me know.
btw. When I tried to make a full write to the database, it dropped the table then crashed giving me the same error message.
Bodmin
kaos00723
07-02-2013, 10:41 AM
This program is ancient and I doubt it has the correct db structure anymore which is why you are getting those crashes.
wolfwalkereci
07-02-2013, 11:28 AM
I still use this every day and it works fine for me. If you keep having issues and no one else responds here send me a PM.
Bodmingaol
07-02-2013, 05:53 PM
I can use it to look stuff up. It reads either spells_us.txt (I am guessing) ok, but if I want to add or modify any part of the database, it will either just crash or drop the table and crash. The errors are consistent, so I will pm you wolfwakereci, and see what can be done.
If there is a better spellfile/spells_new app I'm game. I just need a good tool.
Thanks,
Bodmin
Expletus
08-01-2013, 11:34 PM
Was there any headway in the error you were getting Bodmingaol?
Shin Noir
08-02-2014, 02:41 AM
Every URL Link I see on this topic seems to 404.
Maybe unsticky/update where you can download it?
Tyen05
08-02-2014, 06:32 AM
a new version is droppin real soon
wolfwalkereci
08-02-2014, 07:53 AM
Thats good to know. Messaged OP awhile back about it but he said he didnt have his original source and I never got around to cloning it. Sure there are a bunch of other tools out there that can handle spells but this one is my favorite, hands down.
vBulletin® v3.8.11, Copyright ©2000-2024, vBulletin Solutions Inc.