#npcspawn add bug....
 

HI, i am getting this error in zone.exe when using #npcspawn add...
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.

Re: #npcspawn add bug....
 

pooop005515265?

lol replaced the real thing with that for my own reasons :D now.. anyone have any clue wtf this is all about?

Tried more fiber?

Try using create instead of add - it seems to work fine.

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)

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.

Yep, what Cisyouc said. It puts it in both - check the code. :P

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

Yes, no?

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).

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 )

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.

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 :D

Hmm... ` usually works for me. (Not ', ` (next to the 1 on your keyboard))