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 11-01-2006, 12:37 PM
Rhodan
Hill Giant
 
Join Date: Oct 2006
Posts: 179
Default spawn2 spawngroup

In the peq database there are many spawn2 entries with the same spawngroupid. I noticed this because I would use $gassign and then look at a mob and the gassign appeared not to work. When I then looked in the spawn2 table, I saw that the gassign worked, just not on the mob I had targetted - it went to another mob with the same spawngroupid in spawn2 instead.

I thought the spawn2 table would have spawngroupid as a unique entry - the place where multiple mobs would be assigned would be the spawnentry table. The spawn2 row acting as the "spawn point" and choosing one of the multiple mobs listed in spawnentry. So each spawn2 row would spawn only one mob at a time.

Am I correct and the peq method is wrong or do I have to go back and examine the table relationships again?
Reply With Quote
  #2  
Old 11-01-2006, 02:34 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

The same spawngroupid is normal in spawn2 and this means just that a spawngroup under which many or one npc is linked to. All npc's under this spawn group get spawned by a chance factor.

Actually have a look at my spawn editor and you'll understand this better.

I would not edit these by hand as the table inter-relationships can be hard to deal with.

You can spawn within the game manually, and use my tool to tweak things

GeorgeS

__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #3  
Old 11-02-2006, 07:03 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

Use #dbspawn [npc_id] to spawn a single NPC. Spawning by spawngroupid should work as George described - and we like it like that.
Reply With Quote
  #4  
Old 11-02-2006, 10:59 AM
Rhodan
Hill Giant
 
Join Date: Oct 2006
Posts: 179
Default

Quote:
Originally Posted by GeorgeS
The same spawngroupid is normal in spawn2 and this means just that a spawngroup under which many or one npc is linked to. All npc's under this spawn group get spawned by a chance factor.

Actually have a look at my spawn editor and you'll understand this better.

I would not edit these by hand as the table inter-relationships can be hard to deal with.

You can spawn within the game manually, and use my tool to tweak things

GeorgeS
Actually, I edited a ton of spawns by hand, including finding and deleting orphaned grid_entries.

I got your spawn editor up and running - its GREAT! Far more convenient than manual editing.
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 08:49 PM.


 

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