Null Spell Editor

[GaG]

still does not work for me on newest db Rev it just wipes the table and stops

[trevius]

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]

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!

[Null]

Originally Posted by AudioGarden21

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?

Originally Posted by AudioGarden21

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.

[Null]

Originally Posted by GaG

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?

[GaG]

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`

[Null]

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

Here is a link to the Firefox/Opera/Chrome debug player

[GaG]

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?

[Null]

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,5 000,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,25 12,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);

[GaG]

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]

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!

[Bellos]

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]

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

GeorgeS