spawnfix

[Runeblade]

When i spawn an npc and type #spawnfix it says it can't determine which entry in the database this mob came from?

any clue lol?
thinking about trying to add npc from mysql or something out of game.

[fanman55]

#spawnfix is used to update the coordinates of an NPC that is currently in the database. By creating an NPC in the game using the #spawn command, you are not actually adding it to the database. I find that adding NPC's through MySQL is the best way to do it... But that's just me :P

[Jibbatwinkers]

I have the same issue, I'll use:

#spawn Testmob
#npcspawn create
#npcspawn add

I zone out and come back, and he is not there. When i search #findnpctype Testmob it will come up something like ID: 950001. #npcspawntype 950001 spawns him, and when i do #spawnfix I get the same error. This only happens on my older/custom database, when I load a fresh database the mob comes back and I can #spawnfix fine. I'm currently trying to lay down a fresh PEQ database, so I get luclin and all that good stuff, and then putting my custom things over-top. Getting these spawn commands to work properly is my primary concern and problem.

I heard there was some mysql code that might fix the #npcspawn create problem. Also to the maker of the thread, try to zone out and back in, see if the same thing happens to you.

[RangerDown]

Your #npcspawn commands currently just tell the system to "make an entry in the database that's like this mob." It doesn't do anything to the in-memory attributes of the mob that you just targetted and typed the command on. So, the #spawnfix command is correct in saying that it (still) doesn't know which entry the mob came from.

If you want to #spawnfix on a mob you just created with #npcspawn, you need to be working with a timed-spawned instance of that mob. Usually this means you'll need to shutdown/reload the zone you're working in so you can get the mob started spawning. Or, just make sure you're positioned correctly when you first type the #spawn command, so there is no need for #spawnfix.

[Jibbatwinkers]

I did a ton of work on my database. For me the table in my DB that was breaking it was 'spawngroup'. What I did was I replaced PEQ's 'spawngroup' table with mine, and it seemed to work fine. I did alot more work than that but i think that fixed the #npcspawn create problems I had. Hope that helps

[Runeblade]

Got it working, Guess i just had to wait for the code to settle in or something lol. Thanx for all the info