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 01-23-2013, 08:02 AM
Disorder
Hill Giant
 
Join Date: Apr 2010
Location: USA
Posts: 133
Default Spells

Greetings once again, mates.

I'm curious as to the spell files. How to I ensure my spell file on client side matches what I have on server side? I am using stock spell file from UF, but my client still can't see spell descriptions on some spells. It would be good to know regardless, in case I were to change any spells.

My apologies if I posted this in the wrong section.

Thanks!
__________________
Disorder
Reply With Quote
  #2  
Old 01-23-2013, 10:14 AM
Drajor's Avatar
Drajor
Developer
 
Join Date: Nov 2012
Location: Halas
Posts: 355
Default

Heya Disorder. The answer to this can be found fairly easily via the search- Regardless you can do this by using the tool 'export_spells.pl'. This is a perl program which connects to your database and produces a spell file by reading the spells_new table.

If you are using the source from SVN, export_spells.pl is located in the utils/scripts directory.

Or, to browse directly http://code.google.com/p/projecteqem...port_spells.pl
__________________
Drajor regards you indifferently -- what would you like your tombstone to say?
Reply With Quote
  #3  
Old 01-23-2013, 03:15 PM
Disorder
Hill Giant
 
Join Date: Apr 2010
Location: USA
Posts: 133
Default

I was afraid I missed something in search. I think I just did not know what to search for. Thank you.
__________________
Disorder
Reply With Quote
  #4  
Old 01-23-2013, 03:18 PM
Disorder
Hill Giant
 
Join Date: Apr 2010
Location: USA
Posts: 133
Default

Oh for the love of pete. Getting missing perl514.dll again.
__________________
Disorder
Reply With Quote
  #5  
Old 01-23-2013, 04:22 PM
Disorder
Hill Giant
 
Join Date: Apr 2010
Location: USA
Posts: 133
Default

Ok, got that error taken care of.

I've been reading over forums again but I don't see this. How do you actually run the perl script? I tried putting it in my server directory and running it, but it does not work correctly.

Quote:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\eqemu>perl export_spells.pl
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains:
C:/Perl/site/lib C:/Perl/lib .) at (eval 5) line 3, <F> line 59.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Pg, Proxy, SQL
ite, Sponge.
at export_spells.pl line 62

C:\eqemu>
That is what I see when I run it from the server folder in command prompt. Any suggestions?

Thank you.
__________________
Disorder
Reply With Quote
  #6  
Old 01-23-2013, 04:30 PM
Drajor's Avatar
Drajor
Developer
 
Join Date: Nov 2012
Location: Halas
Posts: 355
Default

Open a command prompt, navigate to the directory where the script is located and type "perl export_spells.pl -o". The -o tells the script to override spells_us.txt if there is already one in the same directory.
__________________
Drajor regards you indifferently -- what would you like your tombstone to say?
Reply With Quote
  #7  
Old 01-23-2013, 04:34 PM
Disorder
Hill Giant
 
Join Date: Apr 2010
Location: USA
Posts: 133
Default

Thanks for the help, Drajor.

I just did this, as you recommended. I get the same message in the command prompt.
__________________
Disorder
Reply With Quote
  #8  
Old 01-23-2013, 04:38 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

From a command prompt, try typing:
Code:
ppm install DBI
ppm install DBD-mysql
The output should look something like this, depending whether you already have DBI installed or not.
Code:
D:\projecteqemu\EQEmuServer\utils\scripts>ppm install DBI
No missing packages to install

D:\projecteqemu\EQEmuServer\utils\scripts>ppm install DBD-mysql
Downloading DBD-mysql-4.020...done
Unpacking DBD-mysql-4.020...done
Generating HTML for DBD-mysql-4.020...done
Updating files in site area...done
  12 files installed

D:\eqemusvn\projecteqemu\EQEmuServer\utils\scripts>
Reply With Quote
  #9  
Old 01-23-2013, 04:44 PM
Drajor's Avatar
Drajor
Developer
 
Join Date: Nov 2012
Location: Halas
Posts: 355
Default

Of course! I forgot the dependency >< Thanks Derision!
__________________
Drajor regards you indifferently -- what would you like your tombstone to say?
Reply With Quote
  #10  
Old 01-23-2013, 05:02 PM
Disorder
Hill Giant
 
Join Date: Apr 2010
Location: USA
Posts: 133
Default

Thanks, giving this a try. If its not too much trouble, can you explain what I just did? Any monkey can push buttons, I'm trying to grasp how everything fits together.

BTW, I was able to export the spells. Thank you.
__________________
Disorder
Reply With Quote
  #11  
Old 01-23-2013, 05:11 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

People write 'packages' that extend/enhance the functionality of Perl. DBD-mysql is one such package to make it easier to access MySQL databases from Perl.

ppm (Perl Package Manager) is a utility to find and install such packages. Those commands I gave just located and installed (from a repository on the Internet) the latest version of the packages called DBI and DBD-mysql which the export_spells.pl script needs to function.
Reply With Quote
  #12  
Old 01-23-2013, 05:20 PM
Disorder
Hill Giant
 
Join Date: Apr 2010
Location: USA
Posts: 133
Default

Derision, Thank you for that explanation.


I take it to get spell descriptions to show up when a player inspects them is a completely different thing all together?
__________________
Disorder
Reply With Quote
  #13  
Old 10-05-2013, 05:49 PM
azog
Sarnak
 
Join Date: Sep 2011
Posts: 51
Default

I can't find the DBD-mysql can anyone point me to the correct mirror because cpan is to old for 5.12.3 win 32bit. I would like to mess around with the scripts in the utils folder.
ty

this one ppm install http://trouchelle.com/ppm12/DBD-mysql.ppd gave me a 404 error.
further investigation I found that all the DBD-mysql are failed.
http://trouchelle.com/perl/ppmrepview.pl?l=D&v=12

are there others that could have it?

added all these;
ppm rep add Bribes http://www.bribes.org/perl/ppm
ppm rep add UWinnipeg http://theoryx5.uwinnipeg.ca/ppms
ppm rep add Trouchelle http://trouchelle.com/ppm/

Last edited by azog; 10-05-2013 at 05:55 PM.. Reason: Found it
Reply With Quote
Reply


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 02:10 PM.


 

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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3