How do I export Skill/Spell changes?

[Lucia Moore]

Is there an easy way to do it? Like, a command that creates new .txt files that I can give to my players?

I've seen the RaceData.txt and spells_us.txt files, and I've seen Null's spell editor, which I intend to play around with later, but what about races and skills?

Any help, as always, would be very much appreciated. I am quite happy with how patient and informative this community has been so far.

[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";

[Kingly_Krab]

You may not have DBI. :|

[chrsschb]

Originally Posted by Kingly_Krab

You may not have DBI. :|

Just reinstalled DBI, ran the script again, same error.


I tried to manually install the DBD

ppm install DBD-mysql

and get this error:

Downloading DBD-mysql-4.022...redirect
Downloading DBD-mysql-4.022...failed 401 Authorization Required
ppm install failed: 401 Authorization Required

[Kingly_Krab]

I don't believe you can acquire DBI for free anymore, some of the other members on the forum have had the same issue, they have often times had to go look for it on their own and manually install it.

[chrsschb]

Originally Posted by Kingly_Krab

I don't believe you can acquire DBI for free anymore, some of the other members on the forum have had the same issue, they have often times had to go look for it on their own and manually install it.

DBI is installed, DBI is not the problem, DBD-mysql is. According to their FAQ I need to either have a business edition license or version 5.16 of perl. I've tried searching for other ways to get it with no luck.

[Tabasco]

http://www.wampserver.com/en/
http://code.google.com/p/peqphpeditor/source/checkout

There's a spell export under the Spells tab.

An alternative might be to use an SQL tool to export the table to CSV and modify the perl script to parse the dump rather than connect to the database.
I could put something together tomorrow if needed.

[chrsschb]

Originally Posted by Tabasco

http://www.wampserver.com/en/
http://code.google.com/p/peqphpeditor/source/checkout

There's a spell export under the Spells tab.

An alternative might be to use an SQL tool to export the table to CSV and modify the perl script to parse the dump rather than connect to the database.
I could put something together tomorrow if needed.

If you say so...

[rencro]

You may be able to get DBD-mysql from a third party source via PPM

You could try:

ppm gui

Edit--->Preferences-->Repositories

and a repository that may still have this package available. Try from the "suggested" list....

Also, Secrets mentioned he got perl 5.18 to work on x64 systems, though I never checked myself, but I certainly believe him...

[KLS]

If you're using current upstream source (which it sounds like you are).

1) Put export_client_files.exe into your server directory. eg: C:/eqemu/export_client_files.exe
2) Create a directory "export" in your server directory. eg: C:/eqemu/export
3) Run export_client_files.exe.
4) All the files that export_client_files.exe works with will now be in the directory created.

Currently we export: spells, skills and base data. We don't yet work with race but if someone works it out I'm not against more of the files being officially exportable.