Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Bugs

Archive::Bugs Archive area for Bugs's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 08-22-2004, 10:28 AM
Cripp's Avatar
Cripp
Discordant
 
Join Date: Oct 2003
Location: The Shire
Posts: 474
Default #npcspawn add bug....

HI, i am getting this error in zone.exe when using #npcspawn add...
Code:
ReturnFalse: spawngroup query in NPCSpawnDB() (query: INSERT INTO spawngroup (name) values('pooop005515265'))
i spawned the first couple hundred NPCS in my zone and it all of the sudden started doing this...
any help would be GREATLY appreciated.
__________________
Nug Blazers - ServerOP / founder
^^comming... later!

www.nugblazers.com
Reply With Quote
  #2  
Old 08-22-2004, 12:25 PM
Cisyouc
Demi-God
 
Join Date: Jun 2004
Location: Heaven.
Posts: 1,260
Default Re: #npcspawn add bug....

Quote:
Originally Posted by Cripp
HI, i am getting this error in zone.exe when using #npcspawn add...
Code:
ReturnFalse: spawngroup query in NPCSpawnDB() (query: INSERT INTO spawngroup (name) values('pooop005515265'))
i spawned the first couple hundred NPCS in my zone and it all of the sudden started doing this...
any help would be GREATLY appreciated.
pooop005515265?
__________________
namespace retval { template <class T> class ReturnValueGen { private: T x; public: ReturnValueGen() { x = 0; }; T& Generator() { return x; }; }; } int main() { retval::ReturnValueGen<int> retvalue; return retvalue.Generator(); }
C++ is wonderful.
Reply With Quote
  #3  
Old 08-22-2004, 12:58 PM
Cripp's Avatar
Cripp
Discordant
 
Join Date: Oct 2003
Location: The Shire
Posts: 474
Default

lol replaced the real thing with that for my own reasons now.. anyone have any clue wtf this is all about?
__________________
Nug Blazers - ServerOP / founder
^^comming... later!

www.nugblazers.com
Reply With Quote
  #4  
Old 08-22-2004, 01:00 PM
mattmeck
Guest
 
Posts: n/a
Default

Quote:
ReturnFalse: spawngroup query in NPCSpawnDB() (query: INSERT INTO spawngroup (name) values('pooop005515265'))
Tried more fiber?
Reply With Quote
  #5  
Old 08-22-2004, 02:41 PM
killspree
Dragon
 
Join Date: Jun 2002
Posts: 776
Default

Try using create instead of add - it seems to work fine.
__________________
Xeldan
Lead Content Designer
Shards of Dalaya
Reply With Quote
  #6  
Old 08-22-2004, 03:01 PM
Cripp's Avatar
Cripp
Discordant
 
Join Date: Oct 2003
Location: The Shire
Posts: 474
Default

yea but, when i use create, SOMETIMES it adds the npcs to the spawn tables and sometimes it doesnt.. its wierd. in this case it didnt add to spawn tables, so i had to #npcspawn add the npcID so he was in spawn tables. (hope that made any sense lol)
__________________
Nug Blazers - ServerOP / founder
^^comming... later!

www.nugblazers.com
Reply With Quote
  #7  
Old 08-22-2004, 05:34 PM
sotonin
Demi-God
 
Join Date: May 2004
Posts: 1,177
Default

all create does is add a new NPC_TYPE record in the database. a copy of whatever you have targeted. doesnt add the spawn
Reply With Quote
  #8  
Old 08-22-2004, 05:44 PM
Cisyouc
Demi-God
 
Join Date: Jun 2004
Location: Heaven.
Posts: 1,260
Default

Quote:
Originally Posted by sotonin
all create does is add a new NPC_TYPE record in the database. a copy of whatever you have targeted. doesnt add the spawn
I beg to differ, it puts it in npc_types as well as putting it in spawns.
__________________
namespace retval { template <class T> class ReturnValueGen { private: T x; public: ReturnValueGen() { x = 0; }; T& Generator() { return x; }; }; } int main() { retval::ReturnValueGen<int> retvalue; return retvalue.Generator(); }
C++ is wonderful.
Reply With Quote
  #9  
Old 08-22-2004, 07:28 PM
killspree
Dragon
 
Join Date: Jun 2002
Posts: 776
Default

Yep, what Cisyouc said. It puts it in both - check the code. :P
__________________
Xeldan
Lead Content Designer
Shards of Dalaya
Reply With Quote
  #10  
Old 08-22-2004, 07:44 PM
Cisyouc
Demi-God
 
Join Date: Jun 2004
Location: Heaven.
Posts: 1,260
Default

I don't usually use the #spawn commands, but I assume how its supposed to work is you login,

Code:
#spawn A_Mob 6 70 ...
/targ A_Mob00
#npcspawn Create

(Restart Zone)

/targ A_Mob00
#npcstats
Name: A_Mob00
NPCID: 000001
...
...

#dbspawn 000001
#dbspawn 000001
#dbspawn 000001

/targ A_Mob01
#npcspawn add

/targ A_Mob02
#npcspawn add

/targ A_Mob03
#npcspawn add
Yes, no?
__________________
namespace retval { template <class T> class ReturnValueGen { private: T x; public: ReturnValueGen() { x = 0; }; T& Generator() { return x; }; }; } int main() { retval::ReturnValueGen<int> retvalue; return retvalue.Generator(); }
C++ is wonderful.
Reply With Quote
  #11  
Old 08-22-2004, 08:04 PM
Rogean's Avatar
Rogean
Administrator
 
Join Date: Jul 2003
Location: Massachusetts
Posts: 708
Default

NPCSpawn Create does both adding it into the npc_type table AND spawn tables. The professional way of spawning a zone would be to first #spawn a mob, then npcspawn create him.. get his npcid (Restart the zone if you have to) and then dbspawn that mob where you want it again and then npcspawn add.

The problem you are having is most likely due to the name field in the spawngroup table not having the proper length. Try increasing the varchar length (You can do this using a tool like mysqlcc).
__________________
EQEmulator Developer / Administrator
Reply With Quote
  #12  
Old 08-23-2004, 01:04 AM
sotonin
Demi-God
 
Join Date: May 2004
Posts: 1,177
Default

ah ok. clears some things up.

all i know was it always created a new entry for the mob, so when people always say, use npcspawn create i laugh and just know their npc_types table is 40 million records long )
Reply With Quote
  #13  
Old 08-23-2004, 04:34 AM
jimbox114
Hill Giant
 
Join Date: Jun 2004
Posts: 231
Default

I have had some trouble with certain zones not working right with the npcspawn add. For instance in POI I spawned A_Giant_Clockwork, did the npcspawn create, rebooted zone and then dbspawned/npcspawn add about 20 of them. Went back in later and only 4 of them showed up. So I thought maybe I screwed up so I did the dbspawn/npcspawn add again in the same spots. Once again when I restart the zone they are not there. So I open up eqadmin and look in the npc_spawns section and see they are not there. Plane of Innovation and Plane of Growth are the only two zones I had this problem. The odd thing is I had created 2 other types of spawns in poi and I had no trouble populating the zone with dbspawn/npcspawn add using them.
Reply With Quote
  #14  
Old 08-23-2004, 06:33 AM
Cripp's Avatar
Cripp
Discordant
 
Join Date: Oct 2003
Location: The Shire
Posts: 474
Default

found the problem... you cant use ' in the npc names.
my npc name was Lady_Poop's_Guard and it wouldnt add. changed to Lady_Poops_Guard and it added fine. after i found this out i noticed that all the other npcs that had the same error did have ' in there name.i did raise the var size on name in spawngroup too, but i think the main problem was the '. you can still use ' in the name, as long as you put it in there after you add it to spawn tables
__________________
Nug Blazers - ServerOP / founder
^^comming... later!

www.nugblazers.com
Reply With Quote
  #15  
Old 08-23-2004, 08:47 AM
Cisyouc
Demi-God
 
Join Date: Jun 2004
Location: Heaven.
Posts: 1,260
Default

Quote:
Originally Posted by Cripp
found the problem... you cant use ' in the npc names.
my npc name was Lady_Poop's_Guard and it wouldnt add. changed to Lady_Poops_Guard and it added fine. after i found this out i noticed that all the other npcs that had the same error did have ' in there name.i did raise the var size on name in spawngroup too, but i think the main problem was the '. you can still use ' in the name, as long as you put it in there after you add it to spawn tables
Hmm... ` usually works for me. (Not ', ` (next to the 1 on your keyboard))
__________________
namespace retval { template <class T> class ReturnValueGen { private: T x; public: ReturnValueGen() { x = 0; }; T& Generator() { return x; }; }; } int main() { retval::ReturnValueGen<int> retvalue; return retvalue.Generator(); }
C++ is wonderful.
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 03: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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3