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

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

01-23-2013, 10:14 AM
|
 |
Developer
|
|
Join Date: Nov 2012
Location: Halas
Posts: 355
|
|
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?
|

01-23-2013, 03:15 PM
|
Hill Giant
|
|
Join Date: Apr 2010
Location: USA
Posts: 133
|
|
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
|
Hill Giant
|
|
Join Date: Apr 2010
Location: USA
Posts: 133
|
|
Oh for the love of pete. Getting missing perl514.dll again.
__________________
Disorder
|

01-23-2013, 04:22 PM
|
Hill Giant
|
|
Join Date: Apr 2010
Location: USA
Posts: 133
|
|
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
|

01-23-2013, 04:30 PM
|
 |
Developer
|
|
Join Date: Nov 2012
Location: Halas
Posts: 355
|
|
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?
|

01-23-2013, 04:34 PM
|
Hill Giant
|
|
Join Date: Apr 2010
Location: USA
Posts: 133
|
|
Thanks for the help, Drajor.
I just did this, as you recommended. I get the same message in the command prompt.
__________________
Disorder
|

01-23-2013, 04:38 PM
|
Developer
|
|
Join Date: Feb 2004
Location: UK
Posts: 1,540
|
|
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>
|

01-23-2013, 04:44 PM
|
 |
Developer
|
|
Join Date: Nov 2012
Location: Halas
Posts: 355
|
|
Of course! I forgot the dependency >< Thanks Derision!
__________________
Drajor regards you indifferently -- what would you like your tombstone to say?
|

01-23-2013, 05:02 PM
|
Hill Giant
|
|
Join Date: Apr 2010
Location: USA
Posts: 133
|
|
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
|

01-23-2013, 05:11 PM
|
Developer
|
|
Join Date: Feb 2004
Location: UK
Posts: 1,540
|
|
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.
|

01-23-2013, 05:20 PM
|
Hill Giant
|
|
Join Date: Apr 2010
Location: USA
Posts: 133
|
|
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
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 02:10 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |