Problem adding an NPC with faction

[Angelox]

I saw where the same thing happened to me when I used nine digit numbers in some of my tables, and somebody posted a reason for the somewhere in these forums - I can't find it though :( - will keep looking.
I think it might have been it was related to the number you used - did you try other higher numbers, like 60000?

[John Adams]

I ran into a "ceiling" too when trying to build custom items over id 100,000. Totally guessing here, but I think all this stuff is loaded into shared memory at bootup. Limiting the highest # may just be a way to cut down on memory consumption? I mean, if I have the original 50k items, and somehow manage to make 50k more, I imagine the memory usage for items variables would skyrocket.

May just be limitations intended to keep things running smooth. Best thing you can do is look at the existing faction ranges and pick a range not currently in use, that IS currently below 50,000 (or whatever).

This is one reason I am opposed to > 6 digit (non "standard") IDs - not sure what problems will rise with this down the road.

[zephyr325]

Thanks for the thoughts, all. It looks like both Cavedude and PEQ keep their id's for this table under 25,000, so I'm just:
- doing an (id +25000) to generate it, and
- if for some reason it goes over 50,000, just don't write that particular insert statement.

It looks like this is working. Soulshot and I are testing it on Darktides right now, but we ran the program against 4 zones and loaded them up, and it seems to be working. Basically, the program will read the "from" database record, checking the "to" database for the existance of that record, and generating the insert statment. Its currently creating the npc, spells, faction, spawn, loot and movement information insert statements. As long as things seem to be working over the next day or two, I'll post the program.