How do I export Skill/Spell changes?

[Kingly_Krab]

In your server folder, you should see a 'export_spells.pl' to export spells.
Open it and you will see something like the following:

my $db = "";
my $user = "";
my $pass = "";
my $host = "localhost";

Edit that to your database specifications and open up your command prompt, put in the following (assuming your directory is like mine).

cdC:\EQ\EQEmuServer

Then put this in once you're in whatever your server directory is.

perl export_spells.pl

If you have an already existing spell file, you may have to put "-o" at the end to make it overwrite the existing file.

[Lucia Moore]

I have something called "export_client_files.pdb", is that it?

Also, I cannot seem to modify spells. I used the Null editor, and exported a spells_us.txt file. The client now displays the correct numbers (I'm trying to convert all healing spells to HoT spells), but the spells in-game don't apply a buff...

[demonstar55]

If you're building from current upstream and build with client files on (default is on), it will create import_client_files and export_client_files. If you create an export folder running export_client_files will create spells_us.text, SkillCaps.text, and BaseData.text based on your database. I'm not sure if there is plans to expand this program to include the other stuff you mention, but this should work well for these files.

The import executable will import those same files in the import directory.

[demonstar55]

Pdb is not an executable, it has to do with VS debugging when programs crash etc.

[Lucia Moore]

Originally Posted by demonstar55

If you're building from current upstream and build with client files on (default is on), it will create import_client_files and export_client_files. If you create an export folder running export_client_files will create spells_us.text, SkillCaps.text, and BaseData.text based on your database. I'm not sure if there is plans to expand this program to include the other stuff you mention, but this should work well for these files.

The import executable will import those same files in the import directory.

How do I run it? Using "perl export_client_files.pdb" doesn't work, it gives me an error about an invalid character, so I assume that .pdb files aren't perl scripts...

I built with all of the defaults on, so I never disabled anything.

[chrsschb]

Just tried to do this myself and got this:



This is line 62:

my $dbh = DBI->connect($source, $user, $pass) || die "could not create db handle\n";