OK fixed the following things today:
respawn and variance fixed
factions fixed - just need some more testing. database-wise it looks good now
issues from emails - all dealt with. Will reward you with stuff later once i put in item couriers
check skill limits - fixed was only 15 entries in class_skill now has all entries.
fix zone points - fixed
analyze other potential static tables - lots of static data was simply lacking. that is now resolved.
regarding factions
Code:
SELECT
nt.id, nt.name, nt.class
FROM
npc_types as nt
WHERE
nt.npc_faction_id = 0 AND
nt.class < 17 AND
nt.id NOT IN
(
SELECT np.npcID
FROM
pets as np
) AND
nt.race <> 127 AND
nt.size > 0 AND
nt.level > 1 AND
nt.bodytype <> 66
ORDER BY
nt.name,nt.class,nt.id;
still gives me 702 matches but i think those don't matter as they look like quest-ish npcs. I will investigate some more. the original missing faction assignment list was ~5000 npcs
next up is fixing the npc_types table with min max damage attack counts etc