Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 12-07-2013, 08:39 PM
Lucia Moore
Sarnak
 
Join Date: Sep 2013
Posts: 32
Default How do I export Skill/Spell changes?

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.
Reply With Quote
  #2  
Old 12-07-2013, 09:01 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

In your server folder, you should see a 'export_spells.pl' to export spells.
Open it and you will see something like the following:
Code:
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).
Code:
cdC:\EQ\EQEmuServer
Then put this in once you're in whatever your server directory is.
Code:
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.
Reply With Quote
  #3  
Old 12-07-2013, 09:26 PM
Lucia Moore
Sarnak
 
Join Date: Sep 2013
Posts: 32
Default

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...
Reply With Quote
  #4  
Old 12-07-2013, 09:28 PM
demonstar55
Demi-God
 
Join Date: Apr 2008
Location: MA
Posts: 1,165
Default

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.
Reply With Quote
  #5  
Old 12-07-2013, 09:29 PM
demonstar55
Demi-God
 
Join Date: Apr 2008
Location: MA
Posts: 1,165
Default

Pdb is not an executable, it has to do with VS debugging when programs crash etc.
Reply With Quote
  #6  
Old 12-07-2013, 09:33 PM
Lucia Moore
Sarnak
 
Join Date: Sep 2013
Posts: 32
Default

Quote:
Originally Posted by demonstar55 View Post
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.
Reply With Quote
  #7  
Old 12-07-2013, 09:50 PM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 905
Default

Just tried to do this myself and got this:



This is line 62:

Code:
my $dbh = DBI->connect($source, $user, $pass) || die "could not create db handle\n";
__________________
Clumsy's World: Resurgence
Clumsy's World [2006-2012]
Reply With Quote
  #8  
Old 12-07-2013, 09:53 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

You may not have DBI. :|
Reply With Quote
  #9  
Old 12-07-2013, 10:14 PM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 905
Default

Quote:
Originally Posted by Kingly_Krab View Post
You may not have DBI. :|
Just reinstalled DBI, ran the script again, same error.


I tried to manually install the DBD

Code:
ppm install DBD-mysql
and get this error:

Code:
Downloading DBD-mysql-4.022...redirect
Downloading DBD-mysql-4.022...failed 401 Authorization Required
ppm install failed: 401 Authorization Required
__________________
Clumsy's World: Resurgence
Clumsy's World [2006-2012]
Reply With Quote
  #10  
Old 12-07-2013, 10:42 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

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.
Reply With Quote
  #11  
Old 12-07-2013, 10:44 PM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 905
Default

Quote:
Originally Posted by Kingly_Krab View Post
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.
__________________
Clumsy's World: Resurgence
Clumsy's World [2006-2012]
Reply With Quote
  #12  
Old 12-07-2013, 10:56 PM
Tabasco's Avatar
Tabasco
Discordant
 
Join Date: Sep 2009
Posts: 270
Default

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.
__________________
http://dungeoncrawl.us.to
Reply With Quote
  #13  
Old 12-07-2013, 11:02 PM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 905
Default

Quote:
Originally Posted by Tabasco View Post
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...
__________________
Clumsy's World: Resurgence
Clumsy's World [2006-2012]
Reply With Quote
  #14  
Old 12-07-2013, 11:30 PM
rencro
Hill Giant
 
Join Date: Sep 2008
Location: So. California
Posts: 219
Default

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...
Reply With Quote
  #15  
Old 12-07-2013, 11:43 PM
KLS
Administrator
 
Join Date: Sep 2006
Posts: 1,348
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 06:53 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3