Database Contributing

Tazadar · **Posted:** Tue Jul 21, 2009 11:26 am

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

Secrets wrote:

Hello, EQClassic. I have some great news today for all of you who wish to contribute to the project: I am pleased to announce the independent, open source database project which may be used to drive the EQC server-side code.

The project is located at google code: http://code.google.com/p/eqclassicdb/

What does this mean for you? It means you finally have a way to contribute to the project! You, the community, will finally be able to help recreate the database within the game as it was during the SoV era. This includes merchants, NPCs, loot, spawns, and faction. I do not expect anyone to be creating additional spawns, but I do expect incorrect, post-classic era spawns to be purged from the database.

All it requires is that you have a PHP-based webserver (you can download one like WAMP for local use) and a MySQL database available. Every query and change you make to your local database will generate an SQL query through the tool. For this purpose, I suggest you do not use anything else with the tool unless it logs queries, or your submissions may be lost. In addition to this, you must give an explanation to as what changes you have made. All submissions will be reviewed by the database team (currently, that is me, Secrets). At this time, the submissions forum is unavailable, but it will be added soon.

The tool is very easy to set up: You must have a web server with PHP & MySQL enabled, and you MUST fill out config.php for local use, located in the phpeditor directory.

A sample of this tool is available here: http://totalanarchy.vpscustomer.com/phpeditor/

There will be NO support for the tool past being set up. Any bugs are to be reported in the database forum WHEN IT IS SET UP. If you have a question about the schema, well, that's what the questions forum is for.

A big thanks to Cavedude & Team of EQEMu's ProjectEQ.net for making the editor source code available for public use. Without him, I would not have made this editor.

Oh, and good luck, submitters. I look forward to seeing your SQL knowledge.

Thank you Secrets.

Secrets · **Posted:** Tue Jul 21, 2009 11:32 am

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!

Shawk · **Posted:** Thu Jul 23, 2009 2:44 pm

This is cool,

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

TZ Spawn · **Posted:** Thu Jul 23, 2009 6:15 pm

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.

tarzan · **Joined:** Fri May 29, 2009 6:14 pm **Posts:** 218

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.

kaboume · **Joined:** Fri Feb 08, 2008 8:57 am **Posts:** 102

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

Harakiri · **Posted:** Fri Jul 24, 2009 10:53 am

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

TZ Spawn · **Posted:** Fri Jul 24, 2009 1:08 pm

Quote:

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.

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).

Secrets · **Posted:** Fri Jul 24, 2009 2:41 pm

TZ Spawn wrote:

Quote:

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.

Romell · **Posted:** Sat Jul 25, 2009 3:00 am

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

nmts · **Joined:** Sun Jul 05, 2009 10:20 pm **Posts:** 2

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.

Romell · **Posted:** Wed Aug 05, 2009 5:28 pm

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

Warhorse8 · **Joined:** Thu Aug 06, 2009 11:20 pm **Posts:** 2

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.

Tiiden · **Posted:** Fri Aug 07, 2009 2:23 am

Warhorse8 wrote:

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...

Warhorse8 · **Joined:** Thu Aug 06, 2009 11:20 pm **Posts:** 2

yes I hadn't read above about hehe

Database Contributing

Who is online