Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #15  
Old 01-09-2007, 05:31 PM
mwmdragon's Avatar
mwmdragon
Discordant
 
Join Date: Apr 2003
Location: Winnipeg, Manitoba Canada
Posts: 270
Question My Database Ideas

Ok, here goes.

Angelox, Cavedude, PEQ = Choice... but

I think we should conglomerate the 3 databases. And this is how I suggest it gets done (Read the word "Suggest" a few times to make sure you saw it there :P


1. Start with a blank Database (All the base tables ect)

2. Start with one Table and use a nice viewer like MySQL Front to compare the info... copy or export the info needed from each database and compile it into a sql file. Continue this until you have gone threw every table. It may take a long time but if you get different person to do a different table then it will go faster.

3. After this is done source all the .sql files you have into the clean database.

4. Now setup a forum that has a public area and a private area. Public so everyone can submit fixes. Private so you can copy and paste fix code from the poublic area as needed.

The Forums must be set up with an area for every table in the database so that posts go into the forum according to the table the public person is offering the code to edit.

5. Make one date per month..say the 15th. That a new verion of the database is released that way the people doing the editing have 30 days to add or change whatever they want from the forums or privately inbetween the releases. After a edit is made from the public forums message you just delete that message that way the forums stay clean.

6. Make it known to people joining the forums that this isn't a place of discussion but a place of submission for work doen on the Master Database.



I REALLY wish I had time to do Database work again :( Starting my own company has really killed my fun time, but filled my pockets with more than lint.

I know Angelox and cavedude are really the only major player in the database are right now (cavedude now holds PEQ or so i believe) so I guess it is really an idea for them to mull over.

If you need a fast host for files and forums let me know I've got a pro server up and running that I have complete controll over >
__________________
Thanks
MWMDRAGON

NeverQuest
http://neverquest.gotdns.com
Emucade
http://dragonsden.emuunlim.com
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 07:14 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