Announcement

Collapse
No announcement yet.

Your very own research web page!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Your very own research web page!

    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
    Code:
    /outputfile inventory c:\thischaracter.txt
    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:
    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!
    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
    Attached Files
    Last edited by Xorillian L`Amante; 08-21-2004, 12:43 PM. Reason: As you can see in the componentlookup screenshot, some spells show twice. You may need to delete the extra one from the database on some spells. In this case, deleting recipe number 69 will fix that

  • #2
    Wow! My Xorillian is so sweet. He's basically done everything my spreadsheet can do, but with much higher readability and no need for Excel. Plus, the components page is very nice, pulls up the spells so that it's much easier to read (whereas on the spreadsheet, you could miss a spell or two in the list).

    Anyhow, hope you try it out and have fun!
    RNG isn't prejudice. It hates all of us equally~

    Comment


    • #3
      updated...

      Found the recipes were jumbled due to a bad execl sort...will post once it is fixed
      Last edited by wundrfulthing; 03-03-2005, 04:27 PM.

      Comment


      • #4
        small fix

        see the above post
        Last edited by wundrfulthing; 03-03-2005, 04:26 PM.

        Comment


        • #5
          Updated....

          Changes I have made:

          -Replaced Hybrid, Cleric and Shaman class entries with generic class Priest
          -Added fields for components 5 and 6 fields
          -Updated Recipes to match current EQTraders.com lists
          -Minor edit to instructions

          Trivials are not included


          Kizar
          Emarr
          Attached Files

          Comment


          • #6
            OMFG! - I got it to work =)

            I got it to work with no experience what so ever with PhP or SQL databases.

            If you're having problems getting this set up, the readme.txt is all you need to read, just read it carefully =p
            Arboreal d'Rivervale

            Comment


            • #7
              I hosted this script on my site, hope it helps! It should have installed ok, but I don't have enough research mats on me to tell if it pulls data into a sheet right but pm me if i need to fix anything.

              Research Script

              *edit: updated URL*
              Last edited by scottd34; 02-12-2006, 10:35 AM.

              Comment


              • #8
                First off, I love this script, and thank you scottd34 for hosting it, it saved me the time of setting it up on my site. I have run into a couple of errors:

                Call of Bones: Says Parasitism instead of Motion
                Malignant Dead: Says Enlightenment instead of Collection (Beza)
                Word of Souls: Says Radience instead of Projection
                Bond of Death: Says Projection instead of Odus
                Shadow Vortex: Says Odus instead of Dissolution
                * Renew Bones: Says Recluse instead of Purification
                Nullify Magic: Says Eventide instead of Dissolution

                I have been lazy and not looked into the files to see where the mistakes occur, but with exception of Renew Bones, I had the appropriate words on my person, so they could simply be an issue with how it displays in the end html file.

                Comment


                • #9
                  having Problems

                  I'm having problems getting this to work... Got the Server/PHP/MySQL up and running (and talking to each other), but gettting a problem after I send the file.

                  --------------------------

                  File 1: player.txt Upload Successful!
                  Query Failure: Unknown column 'recipes.RLucyID' in 'on clause'

                  -----------------------------

                  The text file looks good, I can open it in excel nicely. Any ideas?

                  Comment


                  • #10
                    I will take a look at the errors you pointed out and see about correcting them in the database.. it could just be the database getting out of date.

                    I have some time this week to look into it.

                    I will add some contact info to my site so any omittions can be emailed to me. I would like to keep this as up to date as possible.

                    Comment


                    • #11
                      Xor, what a powerful tool you have given us! Scott, thanks for hosting this. I know you are not updating. However, it would be useful to have the component have the character/file that it is located on.

                      Comment


                      • #12
                        I'm afraid I'm getting the same error as reported above - I'm using a Ubuntu 6.06 server with "Server version: 5.0.22-Debian_0ubuntu6.06.2-log". Any MySQL experts out there that can help out?

                        If not, I may have to rewrite the functionality in Perl...
                        Gaell Stormracer, Storm Warden of Tunare, United Kingdoms, Antonius Bayle

                        Comment


                        • #13
                          No luck for me running it on a XAMMP sever.

                          http://www.apachefriends.org/en/index.html
                          Kekenewah Silverfire: 82 High Elf Wizard: Drinal Server salvage 3
                          300 Jeweler (plus 15%) & JM3, 300 Smith w/ SM3 (plus 15%), 248 brewer (plus 5%), 300 tailor (plus 15% & TM3), 200 baker, 217 Pottery (plus 5%), 200 Fisherman, 300 spell research w/ AT3 (plus 15%)
                          Kekema: 81 gnome magician 250 fletcher (plus 5%), 215 tinkerer (plus 5%)
                          Kekero: 65 dwarf rogue 300 make poison (plus 12%)
                          Keketrol: 74 troll shaman 300 alchemist w/ AM3 (plus 15%) salvage 3
                          Kekecha: 75 Erudite enchanter 122 smith (plus 5%)
                          Kekenebog: 59 Ogre warrior 203 blacksmith (plus 5%)
                          Kekera: 62 halfling ranger: 189 blacksmith (plus 5%)
                          Keneken: 75 dark elf necro: 112 tailor (plus 5%)
                          Keke 70 High Elf wizard on Mayong 300 plus 12% research with AT3

                          Comment


                          • #14
                            If you can't get this to work, you might want to give my program a try (see link down in my signature). It makes similar tables listing all the spells you can make from various items in your inventory, and also makes tables listing which researchable spells your various characters or guildmates need and how to make them. Plus a whole bunch of other stuff.
                            -- Mewkus: 2100 dings on the server formerly known as Solusek Ro
                            try: Inventory/Flags/Spells tracker program - (sample output)

                            Comment

                            Working...
                            X