EQEmulator Forums - Zone and NPCS

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Zone and NPCS (https://www.eqemulator.org/forums/showthread.php?t=16990)

darkdonno

11-13-2004 12:46 PM

Zone and NPCS

Eqemu version: 0.6.0-DR2
Database: peq_kunark- RC1

From Zone.exe

Quote:

[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
Error in DBLoadNPCFactionLists query3 'SELECT npc_faction_id, faction_id, value,
npc_value FROM npc_faction_entries order by npc_faction_id' #1054: Unknown colu
mn 'npc_value' in 'field list'
Error: EMuShareMem: DLLLoadNPCFactionLists: !cbDBLoadNPCFactionLists
[Error] Loading npcs faction lists FAILED!

Sarepean

11-13-2004 01:16 PM

Try this:

Quote:

ALTER TABLE npc_faction_entries ADD npc_value TINYINT UNSIGNED DEFAULT '0' NOT NULL;

UPDATE npc_faction_entries SET npc_value=1 WHERE value<0;

-Sarepean

All times are GMT -4. The time now is 11:13 AM.