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.

Reply
 
Thread Tools Display Modes
  #1  
Old 07-14-2006, 05:59 AM
SCROFT
Fire Beetle
 
Join Date: Jul 2006
Posts: 13
Default

Little confused...

Are you saying this file is set to add POK to PEQ... with data from Cavemans DB?

Are you trying to merge the 2 DB's to get the best of both worlds?

I hope so as I think this would be very good for the Community. Also if this is your intentions... I would be willing to help. I know I am new to all of this, but I do know PHP and MySql... so if you you give me a basic run down on how to merge the info zone by zone(I figure it is a matter of comparing the DB's and making changes, but need to know all of the tables affected)... I would be very willing to help.

Last edited by SCROFT; 07-14-2006 at 02:04 PM..
Reply With Quote
  #2  
Old 07-14-2006, 06:54 AM
Thristam
Hill Giant
 
Join Date: Jun 2006
Posts: 117
Default

Yes. This is the POK Zone, complete with all objects, merchants, npcs, etc. In a standalone SQL format. All you have to do is source the file into your PEQ db and you will have POK.

I plan on going zone by zone and Converting/adding them as a standalone SQL file so people who would like to have just one zone of a certian type are able to. OR if you wanna have an event, and then afterwards be able to add everything in, you would be able to do just this zone.

This is used in my world, so i know it works, however i may have missed somthing. If i did, gimme a holler.

Scroft, i would love some help, tho this might end up being a one man thing (due to the way im converting them.) contact me in game on Azodia. or in IRC, maybe we can work out a system where we can make it more efficent.
Reply With Quote
  #3  
Old 07-14-2006, 07:10 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

You can also dump spawns, and grids;
spawn2, spawnentry, spawngroup, grid, grid_entries. This is how I started with my LoY Zones.
If you do, could you PM me these separatly? I already sourced what you had posted.
Reply With Quote
  #4  
Old 07-14-2006, 07:53 AM
tallerin
Hill Giant
 
Join Date: Mar 2005
Posts: 165
Default

that would be very helpful for all the zones that people pull from Cavedudes Db to merge with peq put them all together on one dl sight.

I have already merge cavedudes DB to Peq (which was tedious to do all at once would have been easier the way Angelox told me to do it hehe). And now i am going zone by zone adding missing spawns and fixng spawns that are untargetable adding loot tables and faction.
Reply With Quote
  #5  
Old 07-14-2006, 08:10 AM
SCROFT
Fire Beetle
 
Join Date: Jul 2006
Posts: 13
Default

Sounds like tallerin is ahead of both of us... any way we can coordinate and or work together? This way were not all doing the same thing.
Reply With Quote
  #6  
Old 07-15-2006, 10:09 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by SCROFT
Sounds like tallerin is ahead of both of us... any way we can coordinate and or work together? This way were not all doing the same thing.
My website belongs to me and is always on - if anyone is interested, we can arrange something for posting sql work, I'm a terrible web artist, If anyone can do better, I'll let them do the posting too.
Reply With Quote
  #7  
Old 07-15-2006, 12:03 PM
Thristam
Hill Giant
 
Join Date: Jun 2006
Posts: 117
Default

Same, i have my own website but im not a web designer by a long shot. I would be happy to post my work elsewhere. I can make a basic page with links to all the stuff.

You can usually find me on irc or in game.
Reply With Quote
  #8  
Old 07-15-2006, 10:06 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by tallerin
that would be very helpful for all the zones that people pull from Cavedudes Db to merge with peq put them all together on one dl sight.

I have already merge cavedudes DB to Peq (which was tedious to do all at once would have been easier the way Angelox told me to do it hehe). And now i am going zone by zone adding missing spawns and fixng spawns that are untargetable adding loot tables and faction.
I didn't realize this tell later also, I have a pile of work already done, that I need to fix - at least we are getting somewhere, by sharing our stuff now - I'm trying to make my zones more "complete" before I post them, But I get stuck a lot on things I don't know how to do, and, am learning.
Reply With Quote
  #9  
Old 07-14-2006, 08:27 AM
Thristam
Hill Giant
 
Join Date: Jun 2006
Posts: 117
Default

in the version you DL'd

npc_types
Spawn2
Spawngroup
Merchantlist
doors

Added:

SpawnEntries
grid
gridentries

SQL pack is updated with the missing data, and i created a FIX for the stuff that anyone DL' d prior to this fix here

Thanks for the heads up man, i forgot to add one of my notepads together...hehe
Reply With Quote
  #10  
Old 07-14-2006, 11:07 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by Thristam
in the version you DL'd

npc_types
Spawn2
Spawngroup
Merchantlist
doors

Added:

SpawnEntries
grid
gridentries

SQL pack is updated with the missing data, and i created a FIX for the stuff that anyone DL' d prior to this fix here

Thanks for the heads up man, i forgot to add one of my notepads together...hehe

All working now, thanks - I never really looked at how much was done by Cavedude in PoK. I noticed the portal to Gulf of Gunthark is not there, but this is probably because it was a recent addition. also, how would i go about getting the return-books to work?
Reply With Quote
Reply

Thread Tools
Display Modes

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 04:23 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