Ok after reading up on everything, I'm trying to import SoF spells_us.txt file Deleted the Spells_New table. Sourced in the 230_spells_table.sql then ran perl import_spells.pl and I get a grand total of 28 spells in the db and a ton of errors in the cmd screen like the following:
Quote:
Error loading "Corruption DoT Bonus 5" (15925)
DBD::mysql::db do failed: Incorrect integer value: '' for column 'aoerange' at r
ow 1 at import_spells.pl line 115, <SPELLS> line 14797.
Error loading "Corruption DoT Bonus 7" (15926)
DBD::mysql::db do failed: Incorrect integer value: '' for column 'aoerange' at r
ow 1 at import_spells.pl line 115, <SPELLS> line 14798.
Error loading "Corruption DoT Bonus 9" (15927)
DBD::mysql::db do failed: Incorrect integer value: '' for column 'aoerange' at r
ow 1 at import_spells.pl line 115, <SPELLS> line 14799.
Error loading "Place Banner" (1592
Spells Loaded: 28 of 14799
Highest ID: 15928
|
Using SoF client
spells_us.txt from the SoF Client
sourced in the 230_spells_table.sql
copy the import_spells.pl from a fresh download of the Trunk
perl import_spells.pl and get the above errors (more than it listed of course)
Import_spells working for SoF spells_us.txt ? or am I missing something that if it was a snake it would have bit me twice?
I even sourced in a fresh DB and copied the Structure only from it to my DB and still get the same errors as I did when I sourced in the 230_spells_table.sql.