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 10-30-2004, 03:35 AM
Sarepean
Discordant
 
Join Date: Sep 2004
Posts: 253
Default Question to the PEQ Team: about Kunark and Classic

Hey! I've been using your 058 Classic Database for a while and I must confess, you guys are doing a great job. =)

Okay, so here's the thing. When your database comes out, everything I source in is basically fixed to everything else (example: the loot_drop table has numbers that correspond with the npc_type table and if I had added an npc_type, that would throw it off), right?
That in mind, I'm curious when about do you think the Kunark release will be coming out? You see, I've got some item and npc creations and I'm wanting to delay making or adding anymore until after Kunark comes out since I'm going to have to use my backup database and readd everything.

Also--- I notice that there are no locked doors (or at least any I can find) in the classic database? Is this the database or is it the EQEmu coding or...? Either way, I'm just curious. =)

-Sarepean
Reply With Quote
  #2  
Old 10-30-2004, 04:01 AM
RangerDown
Demi-God
 
Join Date: Mar 2004
Posts: 1,066
Default

The npc_type ID's are numbered according to zone ID number. For example, npc ID's 1000-1999 are for the South Qeynos zone, 2000-2999 for the North Qeynos zone, and so on. To avoid conflicts, pick an NPC id number whose hundreds value is at 900 or above (ie, a custom NPC in North Qeynos, pick a number that's at least 2900 but less than 3000).

As for loottables and lootdrops, I don't think there's any rhyme or reason to the ID's picked there. Most likely the next available ID number used when our information source scripts another loot drop in.

The locked doors are probably our doing, and eventually we'll have to get to that. The doors table has a field that is set to 0 if the door doesn't lock, and the item ID of a needed key if it is locked. That probably won't be a high priority though, so you might want to update the doors on your own if you have the info.
__________________
<idleRPG> Rogean ate a plate of discounted, day-old sushi. This terrible calamity has slowed them 0 days, 15:13:51 from level 48.
Reply With Quote
  #3  
Old 10-30-2004, 04:25 AM
govtcheeze
Hill Giant
 
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default

Regarding the loot, kunark has a whole new table system. This will overwrite the classic loottables, so all info will be lost. If you are planning on adding loot, your best bet is to wait. I would HIGHLY recommend using the php editor Sotonin made to do any updates to the DB.

I think kunark is coming soon, I believe we are waiting on some code fixes and then need to confirm our faction is correct before releasing the DB.

Stay tuned
__________________
GovtCheeze, Welfare Warrior
"Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you ARE the sucker." -- Mike McDermott, Rounders

Developer of the original (circa 2004):
Loots v2.0, bitch!
Faction v1.0, bitch!
Magelo-like clone v0.3, bitch!
Zone geometry and spawn/path viewer, bitch!
Reply With Quote
Reply


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:11 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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3