Hello everybody, Secrets has a great news for all of you who want to help us :



Thank you Secrets.

Thanks, Taz.

Until Yeahlight comes around and makes me a forum, please, DO NOT post any submissions, however, feel free to use (and abuse) the program. If you want to change the default user, "admin" w/ "password", you will need to use an SQL statement to do so. I highly reccomend grabbing Navicat or the free HeidiSQL for adding new users. I think I broke the admincp on the browser, however, I will fix it in a later revision.

Also, be sure to PM me bugs with it for the time being.

Thank you!

This is cool,

Unfortunately my brain can barely remember things from 3 years ago let alone 9..

Asking people to clean up and tweak a whole database based on nothing but their memories is foolish, especially when resources already exist to make the huge task much less painful.

Below are some links that should prove useful. I'm sure that other people will be able to contribute some more. I wish I could help the project but I sadly don't have the spare time.


N.B. Links using the Internet Archives (web.archive.org) need to be fully loaded if you intend to follow any link present on the displayed archived web page. Also, some pages, usually the less visited, will not be displayed fully or at all. If the link might contain valuable information, try using another archived mirror from an earlier or later date.

PS: Remember to remove the added space to the links below to avoid the censoring of web links (evar quest => remove the space before clicking the links).


Allakhazam:

Circa march 2001: http://web.archive.org/web/20010302000007/ever quest.allakhazam.com/

Circa may 2001: http://web.archive.org/web/20010517021106/ever quest.allakhazam.com/

Circa june 2001: http://web.archive.org/web/20010627185803/ever quest.allakhazam.com/

Circa 2000: http://web.archive.org/web/20000511085510/http://ever quest.allakhazam.com

Item list by zone: http://web.archive.org/web/200102021405 ... mzone.html

Item list by zone: http://web.archive.org/web/200103310303 ... mzone.html

Quest list (by item/zone/faction): http://web.archive.org/web/200106280149 ... ml?class=9

Quest list (by item/zone/faction): http://web.archive.org/web/200012160042 ... tml?zone=8


Comments: The first three links will show three rather functional mirrors of Allakhazam at the end of the "Classic" period. From these you can access many lists and interesting info, notably a full bestiary and quest list by zone, complete with loot table etc. The fourth link shows an old version of Allakhazam (circa 2000) where you can access equipment lists before they made it subscribers only. The fifth and sixth links both show only items by zones. The two final links will let you search for quests by item rewards, zones and faction (remember to scroll all the way down or you won't see the results).


EQ Atlas:

http://www.eqatlas.com

Comments: Still up and running after all these years, EQ Atlas features many relevant information, notably a list of monsters, notable NPCs and unique (rare) items all sorted by zones.


Everlore:

http://web.archive.org/web/200104042203 ... rlore.com/

http://web.archive.org/web/200105160300 ... rlore.com/

http://web.archive.org/web/200106111946 ... rlore.com/

http://web.archive.org/web/200106220029 ... rlore.com/


Comments: Everlore never had the most accurate information but it did feature a nice item list complete with stats and source.


Anezka's Faction Guide:

http://web.archive.org/web/200303252353 ... tions.html

http://web.archive.org/web/200304040816 ... tions.html

Comments: These two links show a faction guide for the major factions that you could raise as a KoS player. I assume most of the faction work could be done using only Allakhazam links but I'll post this guide anyway in case it's needed to explain some of the mechanisms behind factions.


Happy hunting.

I am not a programmer, nor am I an expert on the accuracy of resources at our disposal on the internet.

However, I would urgently recommend to all who are involved in the database contributions:

Don't take information from sites such as Allakhazam at face value. I have found Allakhazam to be less than reliable, and usually incomplete, especially regarding very old classic EQ. I am not saying that such sites are of no value, far from it; however, I strongly urge you to cross-reference, whenever and wherever possible, to have a better chance of getting things right.

I would suggest being especially careful regarding faction information, mob listings for different zones, and drop tables for mobs in various zones.

here is my contribution in term of sourcing :


Everlore bestiary i backuped in 1999
http://mikcro.kilu.de/6_BKP_Of_everlore ... /Index.htm
mob lvl / faction / some drop info

Excel item DB from 2000 i found on old HD :
http://mikcro.kilu.de/4_xls-txt_files/EQ_db_2000.xls

also find DB schema here :
http://eqemu.psend.com/schema.png


Have fun and see ya online

the bestiary is great, but dont you have an offline archive for the list?

The links I posted are archived mirrors from Classic era EQ. While the information posted on Allakhazam may not have been perfect, I bet it's much better than whatever we manage to remember as a collective. After all, the database from Allakhazam was mainly built from users' contributions.

Unfortunately I don't have an offline archive for the list though it should be possible to run a spider and siphon all the info from the archived mirrors to view it offline, although it might prove more tedious than simply using the online version.

However, I do have a ShowEQ database dump compiled from (then) live server data, complete with mob name, zone name, level, HP, race, class and coordinates. The dump was created on the 26th of August 2001, maybe it might be of some use for double checking stuff?

Download link (better results when opening with something else than notepad, e.g. wordpad).

Already have that, thanks though. I do believe the spawn DB we started with initially used that information.

It is indeed not foolish, and you have proved that yourself.

There is some real gold in here guys, Thank you very much!

Getting a blank light blue screen when I load the /phpeditor/index.php . I got the database all setup and changed the info in the config file.

I had the same problem. see this thread. http://eqclassic.org/forums/viewtopic.php?f=42&t=963

regarding accurate mob hps: there was once a program called showeq in the golden days of yore. it was a packet collector, that would give a player mob hps. Somewhere on the internet there was a website wher someone had posted almost all the mob hps with their lvls collected by showeq. This was before they encrypted it so u could see exact hps. ANyways, if anyone can recall the url of this site (it was a basic white background site with lists of zones) im sure it could assist in database accuracy.

If you'll read a few posts up, you'll see a link to it . I'm currently using it as the source for mob HPs when making changes. I might break down and try to get an account on EQ Mac so I can make a character and do parses. EQ Mac is going to be a gold mine for real info. Just a pain to use... damn macs...

yes I hadn't read above about hehe