EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Spells (https://www.eqemulator.org/forums/showthread.php?t=36320)

Disorder

01-23-2013 08:02 AM

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!

Drajor

01-23-2013 10:14 AM

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

Disorder

01-23-2013 03:15 PM

I was afraid I missed something in search. I think I just did not know what to search for. Thank you.

Disorder

01-23-2013 03:18 PM

Oh for the love of pete. Getting missing perl514.dll again.

Disorder

01-23-2013 04:22 PM

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.

Drajor

01-23-2013 04:30 PM

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.

Disorder

01-23-2013 04:34 PM

Thanks for the help, Drajor.

I just did this, as you recommended. I get the same message in the command prompt.

Derision

01-23-2013 04:38 PM

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>

Drajor

01-23-2013 04:44 PM

Of course! I forgot the dependency >< Thanks Derision!

Disorder

01-23-2013 05:02 PM

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.

Derision

01-23-2013 05:11 PM

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.

Disorder

01-23-2013 05:20 PM

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?

azog	10-05-2013 05:49 PM

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/

All times are GMT -4. The time now is 08:20 AM.