#npcspawn add error.. nasty

[gernblan]

Figured out the problem... the field simply ran out of characters... long mobname + spawngroup number and it ran out. Increasing the size of the field (to, in my case, varchar(50)) gave it room and it was able to update.

[gernblan]

And here is the difference between #npcspawn add and create:

create - literally creates a NEW mob in the database. New NPCID. New spawngroup. Use SPARINGLY because you'll have tons of mobs to edit.

add - only creates a new spawnpoint for that mob in the same spawngroup of the mob you're spawning. The mob must already exist in the DB and have a spawngroup ID (meaning, usually a mob you dbspawned from somewhere else).

So, create will create a completely new mob (NPCID, spawngroupID, first spawnpoint) and add will create an addition spawnpoint for a mob, with the same NPCID of what you copied along with it's spawngroup, merely adding a new spawnpoint for it.

add creates mobs with the same NPCID, same spawngroup, different spawn points... so if you edit the texture, hp, other stats... of any one of them, you edit them all (very nice when you're merely making clones).

create creates a brand new, standalone mob in all respects.

[Sakrateri]

Well that explains it then, all of the mobs I spawn I create myself. I am not wanting to fill my zones with all the same mobs, Thanks for the info