|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Archive::Bugs Archive area for Bugs's posts that were moved here after an inactivity period of 90 days. |
08-22-2004, 10:28 AM
|
|
Discordant
|
|
Join Date: Oct 2003
Location: The Shire
Posts: 474
|
|
#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
|
08-22-2004, 12:25 PM
|
Demi-God
|
|
Join Date: Jun 2004
Location: Heaven.
Posts: 1,260
|
|
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.
|
08-22-2004, 12:58 PM
|
|
Discordant
|
|
Join Date: Oct 2003
Location: The Shire
Posts: 474
|
|
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
|
08-22-2004, 01:00 PM
|
|
Quote:
ReturnFalse: spawngroup query in NPCSpawnDB() (query: INSERT INTO spawngroup (name) values('pooop005515265'))
|
Tried more fiber?
|
08-22-2004, 02:41 PM
|
Dragon
|
|
Join Date: Jun 2002
Posts: 776
|
|
Try using create instead of add - it seems to work fine.
|
08-22-2004, 03:01 PM
|
|
Discordant
|
|
Join Date: Oct 2003
Location: The Shire
Posts: 474
|
|
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
|
08-22-2004, 05:34 PM
|
Demi-God
|
|
Join Date: May 2004
Posts: 1,177
|
|
all create does is add a new NPC_TYPE record in the database. a copy of whatever you have targeted. doesnt add the spawn
|
08-22-2004, 05:44 PM
|
Demi-God
|
|
Join Date: Jun 2004
Location: Heaven.
Posts: 1,260
|
|
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.
|
08-22-2004, 07:28 PM
|
Dragon
|
|
Join Date: Jun 2002
Posts: 776
|
|
Yep, what Cisyouc said. It puts it in both - check the code. :P
|
08-22-2004, 07:44 PM
|
Demi-God
|
|
Join Date: Jun 2004
Location: Heaven.
Posts: 1,260
|
|
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.
|
08-22-2004, 08:04 PM
|
|
Administrator
|
|
Join Date: Jul 2003
Location: Massachusetts
Posts: 708
|
|
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
|
08-23-2004, 01:04 AM
|
Demi-God
|
|
Join Date: May 2004
Posts: 1,177
|
|
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 )
|
08-23-2004, 04:34 AM
|
Hill Giant
|
|
Join Date: Jun 2004
Posts: 231
|
|
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.
|
08-23-2004, 06:33 AM
|
|
Discordant
|
|
Join Date: Oct 2003
Location: The Shire
Posts: 474
|
|
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
|
08-23-2004, 08:47 AM
|
Demi-God
|
|
Join Date: Jun 2004
Location: Heaven.
Posts: 1,260
|
|
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.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 03:23 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|