zone.exe crashes when updating faction tables

[govtcheeze]

I am trying to redo the faction lists, but keep running into a zone.exe crash with the following message:

C:\EQEMU>zone . 192.168.0.103 7995 192.168.0.103
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.5-DR1
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading NPCTypes from database...
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
Error: Database::DBLoadNPCFactionLists: !EMuShareMemDLL.NPCFactionList.cbSetFact
ion
Error: EMuShareMem: DLLLoadNPCFactionLists: !cbDBLoadNPCFactionLists
[Error] Loading npcs faction lists FAILED!

C:\EQEMU>

I thought at first it was an error on my part, but here is the weird thing.

I removed all the data from the faction_list, npc_faction, and npc_faction_entries tables. I have not changed any of the table definitions.

I sourced in my own faction_list, no crash.

I sourced in my npc_faction, no crash.

I sourced in my npc_faction_entries, message above.

I removed the data from npc_faction, no crash.

I then began cutting down the size of my sources...when sourcing in the first 200 entries, it crashes. When sourcing in 180 entries, it doesnt crash. So I figured the error was in the next 20 entries...

I source in JUST THOSE 20 entries, and it doesnt crash...

I then thought it was a bad entry in npc_types, so I updated npc_faction_id to all be 1. Results did not change.

I also removed all single quotes from my faction_list, but results did not change.

I ask here for 2 reasons:

1) Is there a memory limit, or is there some hard-coded faction stuff?
2) Can anyone post the code that throws this error. It may help me find a work around, or figure out where my code is wrong.

THanks.

[govtcheeze]

DELETE FROM npc_faction;
DELETE FROM npc_faction_entries;

INSERT INTO npc_faction VALUES (4, 'Obsolete_Model', 80); --  Defective Clockwork
INSERT INTO npc_faction_entries VALUES (4, 80, -3); --  Defective Clockwork
INSERT INTO npc_faction VALUES (6, 'Clockwork_Scrubber', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (6, 91, -6); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (6, 115, -6); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (6, 176, -6); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (6, 71, 2); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (6, 209, 2); --  Meldrath
INSERT INTO npc_faction VALUES (7, 'Clockwork_XXIA', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (7, 91, -6); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (7, 115, -6); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (7, 176, -6); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (7, 71, 2); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (7, 209, 2); --  Meldrath
INSERT INTO npc_faction VALUES (9, 'Clockwork_XXIIIA', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (9, 91, -9); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (9, 115, -9); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (9, 176, -9); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (9, 71, 3); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (9, 209, 3); --  Meldrath
INSERT INTO npc_faction VALUES (13, 'Clockwork_Cleaner', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (13, 91, -0); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (13, 115, -0); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (13, 176, -0); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (13, 71, 0); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (13, 209, 0); --  Meldrath
INSERT INTO npc_faction VALUES (14, 'Clockwork_Sweeper', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (14, 91, -0); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (14, 115, -0); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (14, 176, -0); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (14, 71, 0); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (14, 209, 0); --  Meldrath
INSERT INTO npc_faction VALUES (15, 'Clockwork_XIXA', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (15, 91, -15); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (15, 115, -15); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (15, 176, -15); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (15, 71, 5); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (15, 209, 5); --  Meldrath
INSERT INTO npc_faction VALUES (16, 'Clockwork_XVA', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (16, 91, -15); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (16, 115, -15); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (16, 176, -15); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (16, 71, 5); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (16, 209, 5); --  Meldrath
INSERT INTO npc_faction VALUES (17, 'Clockwork_XVIIA', 176); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (17, 176, -12); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (17, 115, -12); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (17, 91, -12); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (17, 209, 4); --  Meldrath
INSERT INTO npc_faction_entries VALUES (17, 71, 4); --  Dark Reflection
INSERT INTO npc_faction VALUES (18, 'Clockwork_XXA', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (18, 91, -12); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (18, 115, -12); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (18, 176, -12); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (18, 71, 4); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (18, 209, 4); --  Meldrath
INSERT INTO npc_faction VALUES (19, 'Drekon_Vebnebber', 120); --  Goblins of Fire Peak
INSERT INTO npc_faction_entries VALUES (19, 120, -12); --  Goblins of Fire Peak
INSERT INTO npc_faction VALUES (20, 'Clockwork_XXVA', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (20, 91, -12); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (20, 115, -12); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (20, 176, -12); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (20, 71, 4); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (20, 209, 4); --  Meldrath
INSERT INTO npc_faction VALUES (21, 'A_Mechanic', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (21, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (21, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (21, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (21, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (21, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (22, 'Lyra_Lyrestringer', 192); --  League of Antonican Bards
INSERT INTO npc_faction_entries VALUES (22, 192, -15); --  League of Antonican Bards
INSERT INTO npc_faction_entries VALUES (22, 184, -15); --  Knights of Truth
INSERT INTO npc_faction_entries VALUES (22, 135, -15); --  Guards of Qeynos
INSERT INTO npc_faction_entries VALUES (22, 273, 5); --  Ring of Scale
INSERT INTO npc_faction_entries VALUES (22, 207, 5); --  Mayong Mistmoore
INSERT INTO npc_faction VALUES (23, 'Sanfyrd_Featherhead', 210); --  Merchants of Ak'Anon
INSERT INTO npc_faction_entries VALUES (23, 210, -15); --  Merchants of Ak'Anon
INSERT INTO npc_faction_entries VALUES (23, 176, -15); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (23, 115, -15); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (23, 91, -15); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (23, 71, 5); --  Dark Reflection
INSERT INTO npc_faction VALUES (25, 'Clockwork_XE', 176); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (25, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (25, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (25, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (25, 209, 7); --  Meldrath
INSERT INTO npc_faction_entries VALUES (25, 71, 7); --  Dark Reflection
INSERT INTO npc_faction VALUES (26, 'Clockwork_XIIB', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (26, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (26, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (26, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (26, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (26, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (27, 'Clockwork_XIIIB', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (27, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (27, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (27, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (27, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (27, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (28, 'Clockwork_XIVE', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (28, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (28, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (28, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (28, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (28, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (29, 'Clockwork_XVE', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (29, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (29, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (29, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (29, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (29, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (30, 'Clockwork_XVIE', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (30, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (30, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (30, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (30, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (30, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (31, 'Clockwork_XXIIB', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (31, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (31, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (31, 120, -18); --  Goblins of Fire Peak
INSERT INTO npc_faction_entries VALUES (31, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (31, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (31, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (32, 'Clockwork_XXIXB', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (32, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (32, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (32, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (32, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (32, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (33, 'Clockwork_XXVIIB', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (33, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (33, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (33, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (33, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (33, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (36, 'Clockwork_IIIZ', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (36, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (36, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (36, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (36, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (36, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (37, 'Clockwork_IVB', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (37, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (37, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (37, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (37, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (37, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (38, 'Clockwork_IZ', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (38, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (38, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (38, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (38, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (38, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (39, 'Clockwork_XIB', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (39, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (39, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (39, 209, -18); --  Meldrath
INSERT INTO npc_faction_entries VALUES (39, 71, 6); --  Dark Reflection
INSERT INTO npc_faction VALUES (40, 'Clockwork_XIIE', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (40, 91, -0); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (40, 115, -0); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (40, 176, -0); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (40, 71, 0); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (40, 209, 0); --  Meldrath
INSERT INTO npc_faction VALUES (41, 'Clockwork_XVIB', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (41, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (41, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (41, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (41, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (41, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (42, 'Clockwork_XVIIB', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (42, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (42, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (42, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (42, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (42, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (43, 'Clockwork_XVIIIB', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (43, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (43, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (43, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (43, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (43, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (44, 'Clockwork_XVIIIE', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (44, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (44, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (44, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (44, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (44, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (45, 'Clockwork_XXB', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (45, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (45, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (45, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (45, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (45, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (46, 'Clockwork_XXVIIIB', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (46, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (46, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (46, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (46, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (46, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (49, 'A_Clockwork_Merchant', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (49, 76, -24); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (49, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (49, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (49, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (50, 'Clockwork_IIZ', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (50, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (50, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (50, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (50, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (50, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (51, 'Clockwork_XIE', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (51, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (51, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (51, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (51, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (51, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (52, 'Clockwork_XXE', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (52, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (52, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (52, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (52, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (52, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (55, 'Clockwork_XXIB', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (55, 91, -18); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (55, 115, -18); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (55, 176, -18); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (55, 71, 6); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (55, 209, 6); --  Meldrath
INSERT INTO npc_faction VALUES (57, 'Clockwork_XXVD', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (57, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (57, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (57, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (57, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (57, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (58, 'Clockwork_XXXD', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (58, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (58, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (58, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (58, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (58, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (59, 'Clockwork_XXID', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (59, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (59, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (59, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (59, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (59, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (60, 'Clockwork_XVD', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (60, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (60, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (60, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (60, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (60, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (61, 'Clockwork_XXD', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (61, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (61, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (61, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (61, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (61, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (62, 'Clockwork_XXIVD', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (62, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (62, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (62, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (62, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (62, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (67, 'Clockwork_XVID', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (67, 91, -21); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (67, 115, -21); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (67, 176, -21); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (67, 71, 7); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (67, 209, 7); --  Meldrath
INSERT INTO npc_faction VALUES (68, 'Clockwork_XVIIC', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (68, 91, -24); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (68, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (68, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (68, 71, 8); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (68, 209, 8); --  Meldrath
INSERT INTO npc_faction VALUES (69, 'Clockwork_XXVIC', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (69, 91, -27); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (69, 115, -27); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (69, 176, -27); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (69, 71, 9); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (69, 209, 9); --  Meldrath
INSERT INTO npc_faction VALUES (71, 'Clockwork_XXVIIC', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (71, 91, -24); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (71, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (71, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (71, 71, 8); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (71, 209, 8); --  Meldrath
INSERT INTO npc_faction VALUES (72, 'A_Clockwork_Alchemist', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (72, 76, -24); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (72, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (72, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (72, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (73, 'A_Clockwork_Armorer', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (73, 76, -24); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (73, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (73, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (73, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (74, 'A_Clockwork_Banker', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (74, 76, -24); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (74, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (74, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (74, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (75, 'A_Clockwork_Barkeep', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (75, 76, -24); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (75, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (75, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (75, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (76, 'A_Clockwork_Bowyer', 210); --  Merchants of Ak'Anon
INSERT INTO npc_faction_entries VALUES (76, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction_entries VALUES (76, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (76, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (76, 76, -24); --  Deep Muses
INSERT INTO npc_faction VALUES (77, 'A_Clockwork_Cobbler', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (77, 76, -24); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (77, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (77, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (77, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (78, 'A_Clockwork_Grocer', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (78, 76, -24); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (78, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (78, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (78, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (79, 'A_Clockwork_Jeweler', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (79, 76, -24); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (79, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (79, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (79, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (83, 'A_Clockwork_Tailor', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (83, 76, -24); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (83, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (83, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (83, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (84, 'A_Clockwork_Tanner', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (84, 76, -24); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (84, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (84, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (84, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (85, 'A_Clockwork_Torturer', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (85, 76, -24); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (85, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (85, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (85, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (86, 'A_Clockwork_Weaponsmith', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (86, 76, -24); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (86, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (86, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (86, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (87, 'Clockwork_Merchant', 210); --  Merchants of Ak'Anon
INSERT INTO npc_faction_entries VALUES (87, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (88, 'Kimble_Nogflop', 210); --  Merchants of Ak'Anon
INSERT INTO npc_faction_entries VALUES (88, 210, -24); --  Merchants of Ak'Anon
INSERT INTO npc_faction_entries VALUES (88, 176, -24); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (88, 115, -24); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (88, 71, 8); --  Dark Reflection
INSERT INTO npc_faction VALUES (90, 'Clockwork_XIIC', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (90, 91, -27); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (90, 115, -27); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (90, 176, -27); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (90, 71, 9); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (90, 209, 9); --  Meldrath
INSERT INTO npc_faction VALUES (91, 'Dewis_Caneal', 71); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (91, 71, -39); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (91, 76, 13); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (91, 91, 13); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (91, 115, 13); --  Gem Choppers
INSERT INTO npc_faction VALUES (93, 'Digetha_Chogaller', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (93, 76, -39); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (93, 115, -39); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (93, 176, -39); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (93, 210, -39); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (94, 'Lobal_Postugger', 210); --  Merchants of Ak'Anon
INSERT INTO npc_faction_entries VALUES (94, 210, -39); --  Merchants of Ak'Anon
INSERT INTO npc_faction_entries VALUES (94, 176, -39); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (94, 115, -39); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (94, 76, -39); --  Deep Muses
INSERT INTO npc_faction VALUES (95, 'Nonnie_Texaker', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (95, 91, -39); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (95, 115, -39); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (95, 176, -39); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (95, 210, -39); --  Merchants of Ak'Anon
INSERT INTO npc_faction_entries VALUES (95, 71, 13); --  Dark Reflection
INSERT INTO npc_faction VALUES (96, 'Tergon_Brenclog', 91); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (96, 91, -39); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (96, 115, -39); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (96, 176, -39); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (96, 71, 13); --  Dark Reflection
INSERT INTO npc_faction VALUES (100, 'Baxok_Curhunter', 210); --  Merchants of Ak'Anon
INSERT INTO npc_faction_entries VALUES (100, 210, -39); --  Merchants of Ak'Anon
INSERT INTO npc_faction_entries VALUES (100, 176, -39); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (100, 115, -39); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (100, 71, 13); --  Dark Reflection
INSERT INTO npc_faction VALUES (101, 'Eonis_Mournunder', 71); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (101, 71, -39); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (101, 91, 13); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (101, 76, 13); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (101, 115, 13); --  Gem Choppers
INSERT INTO npc_faction VALUES (102, 'Evah_Xokez', 71); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (102, 71, -39); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (102, 91, 13); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (102, 76, 13); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (102, 115, 13); --  Gem Choppers
INSERT INTO npc_faction VALUES (104, 'Juline_Urncaller', 176); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (104, 176, -39); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (104, 115, -39); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (104, 91, -39); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (104, 322, 13); --  The Dead
INSERT INTO npc_faction_entries VALUES (104, 71, 13); --  Dark Reflection
INSERT INTO npc_faction VALUES (105, 'Kaxon_Frennor', 71); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (105, 71, -39); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (105, 91, 13); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (105, 76, 13); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (105, 115, 13); --  Gem Choppers
INSERT INTO npc_faction VALUES (107, 'Naygog_Mitope', 71); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (107, 71, -39); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (107, 115, 13); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (107, 91, 13); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (107, 76, 13); --  Deep Muses
INSERT INTO npc_faction VALUES (108, 'Rilgor_Plegnog', 71); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (108, 71, -39); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (108, 115, 13); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (108, 91, 13); --  Eldritch Collective
INSERT INTO npc_faction VALUES (109, 'Tobon_Starpyre', 176); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (109, 176, -39); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (109, 115, -39); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (109, 91, -39); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (109, 210, -39); --  Merchants of Ak'Anon
INSERT INTO npc_faction_entries VALUES (109, 322, 13); --  The Dead
INSERT INTO npc_faction_entries VALUES (109, 71, 13); --  Dark Reflection
INSERT INTO npc_faction VALUES (110, 'Vaenor_Husga', 71); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (110, 71, -39); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (110, 91, 13); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (110, 76, 13); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (110, 115, 13); --  Gem Choppers
INSERT INTO npc_faction VALUES (111, 'Velena_Corgtec', 71); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (111, 71, -39); --  Dark Reflection
INSERT INTO npc_faction_entries VALUES (111, 91, 13); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (111, 115, 13); --  Gem Choppers
INSERT INTO npc_faction VALUES (112, 'Welno_Tanboots', 76); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (112, 76, -0); --  Deep Muses
INSERT INTO npc_faction_entries VALUES (112, 115, -0); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (112, 210, -0); --  Merchants of Ak'Anon
INSERT INTO npc_faction VALUES (113, 'Wuggan_Azusphere', 176); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (113, 176, -39); --  King Ak'Anon
INSERT INTO npc_faction_entries VALUES (113, 115, -39); --  Gem Choppers
INSERT INTO npc_faction_entries VALUES (113, 91, -39); --  Eldritch Collective
INSERT INTO npc_faction_entries VALUES (113, 322, 13); --  The Dead
INSERT INTO npc_faction_entries VALUES (113, 71, 13); --  Dark Reflection
INSERT INTO npc_faction VALUES (122, 'A_Putrid_Skeleton', 21); --  Bloodsabers
INSERT INTO npc_faction_entries VALUES (122, 21, -6); --  Bloodsabers
INSERT INTO npc_faction_entries VALUES (122, 53, -6); --  Corrupt Qeynos Guards
INSERT INTO npc_faction_entries VALUES (122, 235, -6); --  Opal Dark Briar
INSERT INTO npc_faction_entries VALUES (122, 135, 2); --  Guards of Qeynos
INSERT INTO npc_faction_entries VALUES (122, 257, 2); --  Priests of Life
INSERT INTO npc_faction VALUES (140, 'A_Ghoul', 117); --  Ghouls of Neriak
INSERT INTO npc_faction_entries VALUES (140, 117, -12); --  Ghouls of Neriak
INSERT INTO npc_faction VALUES (149, 'A_Muddite_Minor', 41); --  Clan Runnyeye
INSERT INTO npc_faction_entries VALUES (149, 41, -9); --  Clan Runnyeye
INSERT INTO npc_faction_entries VALUES (149, 313, -9); --  Stone Hive Bixies
INSERT INTO npc_faction_entries VALUES (149, 133, 3); --  Guardians of the Vale
INSERT INTO npc_faction_entries VALUES (149, 218, 3); --  Merchants of Rivervale
INSERT INTO npc_faction VALUES (150, 'A_Gorge_Minotaur', 180); --  King Xorbb
INSERT INTO npc_faction_entries VALUES (150, 180, -12); --  King Xorbb
INSERT INTO npc_faction_entries VALUES (150, 249, 4); --  Pickclaw Goblins
INSERT INTO npc_faction_entries VALUES (150, 41, 4); --  Clan Runnyeye
INSERT INTO npc_faction VALUES (151, 'A_Muddite_Elder', 180); --  King Xorbb
INSERT INTO npc_faction_entries VALUES (151, 180, -12); --  King Xorbb
INSERT INTO npc_faction_entries VALUES (151, 249, 4); --  Pickclaw Goblins
INSERT INTO npc_faction_entries VALUES (151, 41, 4); --  Clan Runnyeye
INSERT INTO npc_faction VALUES (155, 'An_Evil_Eye', 41); --  Clan Runnyeye
INSERT INTO npc_faction_entries VALUES (155, 41, -12); --  Clan Runnyeye
INSERT INTO npc_faction_entries VALUES (155, 316, 4); --  Storm Reapers
INSERT INTO npc_faction_entries VALUES (155, 314, 4); --  Storm Guard
INSERT INTO npc_faction_entries VALUES (155, 133, 4); --  Guardians of the Vale
INSERT INTO npc_faction VALUES (156, 'A_Chasm_Minotaur', 180); --  King Xorbb
INSERT INTO npc_faction_entries VALUES (156, 180, -12); --  King Xorbb
INSERT INTO npc_faction_entries VALUES (156, 249, 4); --  Pickclaw Goblins
INSERT INTO npc_faction_entries VALUES (156, 41, 4); --  Clan Runnyeye
INSERT INTO npc_faction VALUES (158, 'A_Gnoll_Pup', 279); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (158, 279, -3); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (158, 300, 1); --  Silent Fist Clan
INSERT INTO npc_faction_entries VALUES (158, 217, 1); --  Merchants of Qeynos
INSERT INTO npc_faction_entries VALUES (158, 159, 1); --  Jaggedpine Treefolk
INSERT INTO npc_faction_entries VALUES (158, 135, 1); --  Guards of Qeynos
INSERT INTO npc_faction VALUES (159, 'A_Scrawny_Gnoll', 279); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (159, 279, -3); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (159, 300, 1); --  Silent Fist Clan
INSERT INTO npc_faction_entries VALUES (159, 217, 1); --  Merchants of Qeynos
INSERT INTO npc_faction_entries VALUES (159, 159, 1); --  Jaggedpine Treefolk
INSERT INTO npc_faction_entries VALUES (159, 135, 1); --  Guards of Qeynos
INSERT INTO npc_faction VALUES (160, 'A_Razorgill', 279); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (160, 279, -6); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (160, 135, 2); --  Guards of Qeynos
INSERT INTO npc_faction_entries VALUES (160, 159, 2); --  Jaggedpine Treefolk
INSERT INTO npc_faction_entries VALUES (160, 217, 2); --  Merchants of Qeynos
INSERT INTO npc_faction_entries VALUES (160, 300, 2); --  Silent Fist Clan
INSERT INTO npc_faction VALUES (161, 'A_Gnoll', 279); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (161, 279, -6); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (161, 135, 2); --  Guards of Qeynos
INSERT INTO npc_faction_entries VALUES (161, 159, 2); --  Jaggedpine Treefolk
INSERT INTO npc_faction_entries VALUES (161, 217, 2); --  Merchants of Qeynos
INSERT INTO npc_faction_entries VALUES (161, 300, 2); --  Silent Fist Clan
INSERT INTO npc_faction VALUES (162, 'A_Patrolling_Gnoll', 279); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (162, 279, -6); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (162, 300, 2); --  Silent Fist Clan
INSERT INTO npc_faction_entries VALUES (162, 217, 2); --  Merchants of Qeynos
INSERT INTO npc_faction_entries VALUES (162, 159, 2); --  Jaggedpine Treefolk
INSERT INTO npc_faction_entries VALUES (162, 135, 2); --  Guards of Qeynos
INSERT INTO npc_faction VALUES (163, 'A_Burly_Gnoll', 279); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (163, 279, -6); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (163, 135, 2); --  Guards of Qeynos
INSERT INTO npc_faction_entries VALUES (163, 159, 2); --  Jaggedpine Treefolk
INSERT INTO npc_faction_entries VALUES (163, 217, 2); --  Merchants of Qeynos
INSERT INTO npc_faction_entries VALUES (163, 300, 2); --  Silent Fist Clan
INSERT INTO npc_faction VALUES (165, 'A_Gnoll_Guardsman', 279); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (165, 279, -6); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (165, 300, 2); --  Silent Fist Clan
INSERT INTO npc_faction_entries VALUES (165, 217, 2); --  Merchants of Qeynos
INSERT INTO npc_faction_entries VALUES (165, 159, 2); --  Jaggedpine Treefolk
INSERT INTO npc_faction_entries VALUES (165, 135, 2); --  Guards of Qeynos
INSERT INTO npc_faction VALUES (166, 'A_Gnoll_Shaman', 279); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (166, 279, -6); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (166, 217, 2); --  Merchants of Qeynos
INSERT INTO npc_faction_entries VALUES (166, 159, 2); --  Jaggedpine Treefolk
INSERT INTO npc_faction_entries VALUES (166, 135, 2); --  Guards of Qeynos
INSERT INTO npc_faction_entries VALUES (166, 300, 2); --  Silent Fist Clan
INSERT INTO npc_faction VALUES (167, 'An_Elite_Gnoll_Guard', 279); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (167, 279, -9); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (167, 135, 3); --  Guards of Qeynos
INSERT INTO npc_faction_entries VALUES (167, 159, 3); --  Jaggedpine Treefolk
INSERT INTO npc_faction_entries VALUES (167, 217, 3); --  Merchants of Qeynos
INSERT INTO npc_faction_entries VALUES (167, 300, 3); --  Silent Fist Clan
INSERT INTO npc_faction VALUES (168, 'A_Gnoll_Commander', 309); --  Splitpaw Clan
INSERT INTO npc_faction_entries VALUES (168, 309, -9); --  Splitpaw Clan
INSERT INTO npc_faction_entries VALUES (168, 279, -9); --  Sabertooths of Blackburrow
INSERT INTO npc_faction_entries VALUES (168, 167, 3); --  Karana Residents
INSERT INTO npc_faction_entries VALUES (168, 135, 3); --  Guards of Qeynos
INSERT INTO npc_faction VALUES (171, 'A_Goblin_Whelp', 249); --  Pickclaw Goblins
INSERT INTO npc_faction_entries VALUES (171, 249, -3); --  Pickclaw Goblins
INSERT INTO npc_faction_entries VALUES (171, 133, 1); --  Guardians of the Vale
INSERT INTO npc_faction_entries VALUES (171, 180, 1); --  King Xorbb
INSERT INTO npc_faction_entries VALUES (178, 187, 1); --  Krag

--INSERT INTO npc_faction VALUES (181, 'A_Goblin', 41); --  Clan Runnyeye
--INSERT INTO npc_faction_entries VALUES (181, 41, -6); --  Clan Runnyeye
--INSERT INTO npc_faction_entries VALUES (181, 316, 2); --  Storm Reapers
--INSERT INTO npc_faction_entries VALUES (181, 314, 2); --  Storm Guard
--INSERT INTO npc_faction_entries VALUES (181, 180, 2); --  King Xorbb
--INSERT INTO npc_faction_entries VALUES (181, 133, 2); --  Guardians of the Vale

Sourcing in this file will allow it to work. If I source in one more npc_faction_entries (commented out at the bottom), it crashes. However I can source in another npc_faction and it still works.

Ideas?

[RangerDown]

The code that loads the faction list is under common/database.cpp

I get the same error when I load in npc_faction_id 181, and don't get the error when I leave it out.

[govtcheeze]

It also happens if I empty the npc_faction and npc_faction_entries tables, and source JUST these 2 sections at the same time. But it works if I source ONLY one section or the other:

INSERT INTO npc_faction VALUES (171, 'A_Goblin_Whelp', 249); -- faction is Pickclaw Goblins
INSERT INTO npc_faction_entries VALUES (171, 249, -3); -- faction is Pickclaw Goblins
INSERT INTO npc_faction_entries VALUES (171, 133, 1); -- faction is Guardians of the Vale
INSERT INTO npc_faction_entries VALUES (171, 180, 1); -- faction is King Xorbb
INSERT INTO npc_faction_entries VALUES (178, 187, 1); -- faction is Krag

INSERT INTO npc_faction VALUES (204, 'Guard_Kyte', 220); -- faction is Miners Guild 628
INSERT INTO npc_faction_entries VALUES (204, 220, -15); -- faction is Miners Guild 628
INSERT INTO npc_faction_entries VALUES (204, 77, -15); -- faction is DeepPockets
INSERT INTO npc_faction_entries VALUES (204, 33, 5); -- faction is Circle of Unseen Hands
INSERT INTO npc_faction_entries VALUES (204, 29, 5); -- faction is Butcherblock Bandits
INSERT INTO npc_faction_entries VALUES (204, 90, 5); -- faction is Ebon Mask

[RangerDown]

From playing around with the database a little it looks like the crashes only happen if there is an orphan record in npc_faction_entries -- that is, a record in npc_faction_entries has an npc_faction_id that doesn't match any id in npc_faction.

In the source sample you submitted, you made that typo where one of the records was supposed to be faction id 171 but you have it as 178. The zone server would crash on me too, and then I updated that one record to be faction id 171 like it was supposed to and no more crashes.

[govtcheeze]

RangerDown,

Thanks for the help. Turns out that mobs that didn't belong to a faction but had opposing factions were not handled correctly in my script, and what you said above is exactly what happened.

GC