Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Tools

Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...)

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 12-23-2007, 06:42 PM
AndMetal
Developer
 
Join Date: Mar 2007
Location: Ohio
Posts: 648
Default

Sorry I didn't reply back sooner (haven't been on the forums as much recently).

The main reason I haven't put together a readme file yet is because this is still in the alpha stages. Once I complete some of the functionality and streamline some of the files into others, I'll be able to focus on a more user-friendly approach. In the meantime, you can just post here if you have any questions or concerns.

The idea behind the spell folder was for a few things (eventually): importing the spells_us.txt file into the database, viewing spells, editing spells in the database, and exporting a new spells_us.txt file from the database (for easy distribution to others via a web page). Thus far, only the first has been semi-implemented.

The spells folder, right now, contains scripts to import the spells_us.txt file into a new table, which currently is spells_new. "spells" is used by other utilities, which don't use the same schema.

The insert_columns.php file was meant to be run after creating the table spells_new (which is currently done manually via command line or a GUI front-end, but could be incorporated into the script relatively easy), to create a base schema. Eventually, it will contain an array of all the column names instead of just creating field{$y}, which I'm still working on.

The add_spells.php file was meant to be run next, which actually imports the text file into the database. Luckily, there isn't anything really special about this, except it uses a ton of memory (more than 128MB, but less than 256MB). If your PHP server is set to run in safe mode, it might not complete correctly because of the ini_set() functions at the top.

In reference to "../includes/db_login.inc", that was an old file that I used to use if a file needed to access the database. Because everything needs access to the database plus several constants (race info, class info, etc), I incorporated it into the the constants.php file (1 less line per script). Just before I started sharing the files, I removed the file for good, but apparently forgot to change some of the references. I'll make sure I update it for future releases (thank you for catching that, by the way )
__________________
GM-Impossible of 'A work in progress'
A non-legit PEQ DB server
How to create your own non-legit server

My Contributions to the Wiki
Reply With Quote
 


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