I've been working on this for a little while now and it's finally to the point where when I start making the other changes to it, probably no one will want to use it ;-) So, since this is a workable version, I thought I'd go ahead and post it for anyone to use. Basic usage is just to log into everquest, type
And then submit it to this page. I don't have the bandwith required to host it for massive amounts of people, or I'd show you an example. ;-) It then parses that character file (and as many others as you select), sorts the spells you can make by class, and outputs a table showing the spells you can make, class, level, components to make that spell, and how many of those components you have. Clicking on a spell links you to the Lucy database. Clicking on a component tells you how many of that component you have and what other spells it is used in.
I know there's already a web page for parsing a magelo file, but I'd already started on this and since I don't use magelo any more, I like using EverQuest's file and not having to run any extra programs.
This is a php script (basically a web site directory) that requires PHP and MySQL. The only web server that I use is apache, so that may be required too, but I don't think so.
It's just something that I put together for Xorithra. I'll probably not be keeping it up to date on here (as it takes me months to get around to doing things), but anyone who wants to change it is free to, the only thing I ask is a little bit of credit in the code (Don't have to put my name on your page of course, just somewhere obscure in the code ;-) ).
From the readme file:
Attached are some screen shots and the zip file that has all the files you will need. Hopefully someone will find some use for this ;-)
--Xorillian L`Amante
Code:
/outputfile inventory c:\thischaracter.txt
I know there's already a web page for parsing a magelo file, but I'd already started on this and since I don't use magelo any more, I like using EverQuest's file and not having to run any extra programs.
This is a php script (basically a web site directory) that requires PHP and MySQL. The only web server that I use is apache, so that may be required too, but I don't think so.
It's just something that I put together for Xorithra. I'll probably not be keeping it up to date on here (as it takes me months to get around to doing things), but anyone who wants to change it is free to, the only thing I ask is a little bit of credit in the code (Don't have to put my name on your page of course, just somewhere obscure in the code ;-) ).
From the readme file:
Code:
PHP EverQuest Spell Research Helper By: Xorillian L`Amante for Xorithra L`Amante Very minimal instructions Requirements: Apache Webserver running PHP MySQL A little knowledge of each. Installation: 1.) Unzip the files to a directory on your web server 2.) Make sure that the group your webserver runs under has permission to access all files, in Linux this is done with chmod or chown. 3.) To recreate the database tables, use the provided eqresearch.sql as follows: mysql -p < eqresearch.sql 4.) Create a MySQL user who ONLY has access to your eqresearch database. 5.) Edit the index.php file and set the options that you would like to have. Options that must be set are: $originalsite -- The site that you will be running this from as in 'http://my.site.com/index.php' $host -- Location of your database server, if running from the same place as your webserver you can leave this as localhost. $database -- Unless you modify the eqresearch.sql file, this will be eqresearch. It is the database to use $user -- The user you created in step 4. $pass -- The password for the user from step 4. 6.) Feel free to change any of the other options, there is an explanation of what each does beside them. 7.) Load the page and see if it works~ You can change the database to change any of the graphics that you want, the format is just 'graphic.gif' As you can see from the other entries in the database. Included are a few graphics, but by far they're not the right ones for most of the components. I just grabbed some and threw them in. Also included are two css styles that you can modify however you would like. One is green and one is blue and both are sort of ugly~ But as I said, feel free to modify them. You don't need the following files once setup is complete: Readme.txt (this file), eqresearch.sql Good luck!
--Xorillian L`Amante
Comment