Perl Import_Spells.pl

[ChaosSlayerZ]

is there a specific difference between T and Sof spell files, other than number of spells?

cuase all my custom spells are T based, you saying the program won't work for them?

[GeorgeS]

It's the number of fields and the field names in the spell table and if they line up or not is not tested. It's possible to add this in at some stage as a beta test

I would need a table struct/schema of your spell table with a few sample spells, then I can add this in.

Fear not, I just don't have non SOF spell tables, and providing me with them - I can add non SOF support.

*edit*
I looked at the Titanium spell file, and it looks like it lines up with SOF, but with 15 or so fewer fields, so I will code up Titanium next.


GeorgeS

[Yeormom]

I gave it a try but all it did was run at 100% thread processor usage for 2 hours before I killed the process tree. Never saw an interface of any type, if there is one.

[GeorgeS]

If it ran for that long, there should have been some progress indicated. On my laptop it loads 500 spells in 3 seconds. I cannot comment adversely otherwise without more details

Please backup your table first, before running this

Also, in addition, how do you all create the table? -- it should have 215 fields for SOF

GeorgeS

[Krugus]

the .sql for the spell table file is located in the eqemu/utils/sql/svn/ then look for the file 230_spells_table.sql that will be the sql needed to create the table for SoF.

Its listed in the change log as well as the directions on how to import spells via the perl script

[GeorgeS]

For those who use Ti, the program supports Ti spells.
Select the option for Ti when exporting, or if you select SOF when using a Ti spell set, it will export to SOF compatibility


GeorgeS


-- the above SQL is what I used. I hope everyone uses the same file

[trevius]

GeorgeS,

There isn't a need for Titanium exporting, only for Titanium importing. The spell files are backwards compatible, meaning that a Titanium client can use a SoF client spell file perfectly fine. The only problem is that it is not forward compatible, so an SoF client cannot use a Titanium client spell file. For any server wanting to share a customized spell file or a single spell file to use for both clients, they should only be sharing the SoF version, since it will work with both types. IMO, there isn't any need to export into Titanium format. The only possible use of it would be to slightly reduce the file size. The only other difference between the clients as far as the spell files go is that Titanium can only load spell IDs up to 9999, where SoF has a much higher limit (currently I am not aware of what the max is, but it should be at least 20K+).