Quote:
I'll probably just make a Perl script to do both (since not everyone has PHP installed on their server systems), although I'm already to the point where I have about 80% of the base Titanium spell file in a .sql file that can be easily sourced (80% being the table structure, 20% importing it from the spells file). |
Quote:
|
Quote:
Code:
Usage: import_spells.pl [-c path] [-s path] [-t table] [-d] I feel there are probably some opportunities to clean up the script a little (I've never worked with DBI before), so if anyone has any recommendations, let me know (or if you have SVN access, feel free to change it). |
Just finished up the export script:
Code:
Usage: import_spells.pl [-c path] [-t table] [-i column] [-s path] [-o] |
Can you give an example of using the script? Also, how do you disable using this so it continues to use the normal spells file? From reading the changelog, it sounds like it is supposed to use this table by default. I am guessing that means it will ignore the spells file unless you disable this feature? Or, will it use the spells file if it can't find the table?
BTW, your code box in your export script post says "import", not "export" for usage. So, to import spells into the database, I would do this?: Code:
/utils/import_spells.pl -c /home/eqemu/server/eqemu_config.xml -s /home/eqemu/server/spells_us.txt -t spells_new -d Code:
/utils/export_spells.pl -c /home/eqemu/server/eqemu_config.xml -t spells_new -s /home/eqemu/server/spells_us.txt Code:
eqemu@muse:~/source/EQEmuServer2/utils$ ls |
should be able to just
Code:
sh export_spells.pl |
This is what I get from sh:
Code:
eqemu@muse:~/source/EQEmuServer2/utils$ sh export_spells.pl -h Code:
//#define NEW_LoadSPDat |
Quote:
Edit: Looked at your error and it seems to be picking up the ^M from the DOS file type. You can edit those out or you can run dos2unix to remove them. |
It's a perl script, not a shell script so use:
Code:
perl export_spells.pl Not sure if anybody would use it, but here is the sql dump of the spells file: http://projecteq.net/cavedude/spells_new.zip Source utils/230_spells_table.sql first for the schema, as that is just data. It'll appear as a system table in PEQ CVS. |
Just for the future: I'd rather you turn large (potentially game breaking) features off by default at least at first when they coexist with previous implementations.
|
It doesn't look like it can be disabled. :( Without the table, zones crash as soon as a spell is cast, with a blank table, the zones won't boot at all.
|
Been trying the export script for 2 hours now with no luck :-x
Code:
perl export_spells.pl |
Quote:
|
Is it possible to retract an SVN submission? Would be pretty awesome to just be able to remove it and not have to either manually remove everything added in it, or commit an older version to revert it.
I was hoping to get the new food stats fix in that I got done last night, but couldn't because of the problems with this. |
Sheesh, I go away for 17 hours and everyone freaks out...
Anyways, to address the questions: Quote:
Quote:
Code:
perl import_spells.pl -h Quote:
Quote:
Code:
eqemu@amsk-server:~/svn/EQEmuServer/utils$ perl import_spells.pl -c ~/server/eqemu_config.xml -s ~/server/spells_us.txt -d Quote:
Code:
//#define NEW_LoadSPDat Code:
//#define NEW_LoadSPDat Quote:
Quote:
Quote:
Code:
use DBI; I guess the question now is anyone actually having problems after getting the spells into the database? Because other than that, I'm not sure what all the ruckus is about... I know it compiles, I know it runs, I know it works, and made sure to test it thoroughly before I got to this point. I even just checked my launcher status page & haven't had any zone crashes since my server was booted up at 6:28am today. |
All times are GMT -4. The time now is 04:45 PM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.