New spell editor

[jsr]

Anyone willing to help test a new spell editor for me? I'd like to iron out any bugs before I put it up for general use.

It's written in vb and is similar to Secrets/Ailia/Bleh except it edits the database directly (and creates files on request). Send me a PM :)

[jsr]

*Updated*
This is a Beta version with limited testing, please use accordingly (i.e. make frequent and seperate backups of your database)

Pre-requisites
.Net framework v4.0: http://www.microsoft.com/en-au/download/details.aspx?id=17851

Mysql connector for vb.net: http://dev.mysql.com/downloads/connector/net/

General Info
This tool edits the spells_new table in the database, and can output spell files in SOF/SOD format. It should support Titanium files, but I'm unfamiliar with the client and no Titanium testing has been done.

The tool can be downloaded here: Jsre Spell Editor v.0.1.1.4 (http://users.tpg.com.au/reynoldj/spell-editor/jsre-spell-editor-v0.1.1.4.zip)

Some Screenshots
http://users.tpg.com.au/reynoldj/spell-editor/configsmall.jpg (http://users.tpg.com.au/reynoldj/spell-editor/config.jpg)

http://users.tpg.com.au/reynoldj/spell-editor/editor1small.jpg (http://users.tpg.com.au/reynoldj/spell-editor/editor1.jpg)

http://users.tpg.com.au/reynoldj/spell-editor/editor3small.jpg (http://users.tpg.com.au/reynoldj/spell-editor/editor3.jpg)

http://users.tpg.com.au/reynoldj/spell-editor/editor4small.jpg (http://users.tpg.com.au/reynoldj/spell-editor/editor4.jpg)

Please report any feedback either here or by PM.



Lastly.. I can't seem to edit posts after a certain period, can this be changed so that I can update this thread as required?

Thanks,
Jsr

[Chrono]

Very surprised no one has commented on this tool yet.

I had a little trouble installing at first as it specifically needs a version of the MySQL Connector which was out of date at the time I downloaded, so had to do 5 minutes googling to get the right version.

Other than that, it's very quick and responsive. However I was going to add a Defensive Proc for a new spell, which is #323. The spell effects seem to cap at 254, so it doesn't show :(

List of all spell effects can be found here (dated Sept 2010, so not sure if theres many other spell effect list, but it's a good start.): http://code.google.com/p/peqphpeditor/source/browse/trunk/lib/spellenums.php @ Line 510

Once these get added in I will be able to use it more and give more feedback!

Nice tool though!

Thanks.

[jsr]

My intention is to source spell effects etc from the server files, so you'd just need to copy certain files into the tool's directory. Need some time to get around to it though. They're pretty limited at the moment :)

[AudioGarden21]

Well, I tried to get this tool working to test it out, but it's asking me for version 6.6.4 which I've been unable to acquire. It seems MySQL removed it from their archives, sadly, and I can't find a download for it anywhere else.

Gonna have to toss this one in the trash mate. Sorry.

[jsre]

I'll recompile with the latest connector over the weekend, and in a couple of weeks I'll add functionality to read the source for spell effects.

Given I can't maintain this thread I'm not planning to actively maintain the tool. It is intended for hobby users that don't know have the skills or time to write their own, and aren't able to setup the web based tools.. It doesn't look like there are many people in that category :)

[AudioGarden21]

Understood. In all honesty, as long as it works I reckon that's well enough on its own. It doesn't have to be too fancy. We're only changing entries here and there in the grand scheme of things.

Thanks for the heads up though. It looks promising in the screenshots. =)

[orionsun]

I'm not planning to actively maintain the tool.

Its pretty funny how many closed source tools there are for an open source project. Put it on google code, let people work on it and it grow into something you didnt expect, or you can let it die like Nulls/Secrets/Alliah/etc.

[jsre]

Good idea.. I'll add it to the rainy day do list

[jsr]

I've uploaded a version which uses the Mysql connector 6.6.5 (current).

Jsre spell editor v0.1.1.5 (http://users.tpg.com.au/reynoldj/spell-editor/jsre-spell-editor-v0.1.1.5.zip)

Still a BETA tool with limited testing, so please ensure you are backing up your spells_new table before using, and PM me with bugs or feedback.

[jsr]

FYI - **Please ensure you Backup spells_new table as well as your spell file.**

Reported issues being fixed;
- Blank spell file is written upon error
- Issues creating a new spell file (and some sloppy error handling)
- Use of spell ID's 0 or 1 causes issues

Reported issues I haven't worked out;
- Database error when writing spell file (some users)
- Potential File format issue with some operating systems(?)

Requested features that may be implemented at some point;
- Revert option (per spell and separately all spells)
- Updated spell effect Id's
- Ability to switch editor tabs while browsing spells
- List of NPC's "with this spell"


Again, MODs - it would be handy if I could edit my own posts in this thread :)
(if this can be changed)

[jsr]

Note: I no longer have access to the hosting where these files are located and so cannot update. Happy to provide files via email or alternate hosting, just drop me a PM.

[Garudan]

when i adjust spellDB with your editor and export it via Heidisql into spells_us.txt (your file export is not working for me) everything works absolutly perfect, i just loose every spell >65.....any idea what this might cause?

[jsr]

when you say 'loose every spell > 65', do you mean they're not in the file? If so what's the last spell ID in the file?

[Astal]

hey are you gonna make a way to load from the spells_us file to the database like null had?

My database is blank but I have my correct spell file, i just dont know how to load em in to the database

or load from the spell file in to the editor

[NatedogEZ]

Inside the GITHUB there is a file called import_spells.pl

Located in... utils / scripts / import_spells.pl


Uses DBI perl to import a spell file fairly easy to use

[jsr]

It's on my list, but fairly low priority as I don't need the functionality and there are alternatives. I'm happy to include if someone wants to write a text import function in vb.net. I'd need it to return an array(row, column) or dataset.

Note that the existing editor is out of date, has a couple of serious bugs, and I don't have anywhere to host new files at present. So if you need a copy PM me with an email address that will take exe files (gmail won't).

[Uleat]

I'm pretty sure there is no free way of getting DBI now through ppm.

(Please don't post links...)