EQEmulator Forums - ADVANCED HOWTO:: Increase # of loadable items, factions

In order to use this tutorial, you must understand how to compile code. This tutorial is not necessary to use servers or to host a server. If compiling code is a foreign concept to you, it will not be possible to follow the instructions within.

Please refer to those tutorials :
How to install Eqemu under Linux : http://www.eqemulator.net/forums/viewtopic.php?t=18975
How to compile with free trial of VS.NET (windows) : http://www.eqemulator.net/forums/viewtopic.php?t=14719
How to host on a windows server : http://www.eqemulator.net/forums/viewtopic.php?t=17531

At server boot time, if you get some errors saying that you have too many factions, items, or npctypes in your database, you ll have to modify your source code then recompile it. Tutorials forum contain topics on how to compile eqemu. The guide you used, whatever it is describes how to connect to mysql, and how to run a query. Please refer to them before trying to follow that guide.

Please remember to always backup the files you modify, that's the best and easiest way to make a step back when everything starts to be broken.

The value you need to change before recompiling is a number set as a constant in the .h files (c++ include files). You will find that value by running a short mysql query into your database. Below are the files that can be modified and the queries to be ran for each modification. You can edit the .h files with any text editor, as long as it saves the file in ascii mode (don't use MS Word!). Notepad under Windows, or vi under Linux are perfect. If you have Visual Studio, it ll be even easier due to syntax highlightning.

Too many npctypes, edit
EMUShareMem/NPCTypes.h :
and change the value of
#define MMF_MAX_NPCTYPE_ID 400000
to find the number of npc_types in your database, run the following query :
select MAX(id) FROM npc_types;

Too many items, edit
common/Items.h
and change the value of
#define MMF_EQMAX_ITEMS 85000
to find the number of items in your database, run the following query :
select max(id) from items;

To many factions, edit
EMUShareMem/NPCFactionList.h
and change the value of
#define MMF_MAX_NPCFactionList_ID 50000
to find the number of factions in your database, run the following query :
select max(id) from npc_faction;

Another file contains constants that you could have to or modify : zone/features.h. Most of them are commented enough to be explicit. Be carefull tho, changing some constants could create unwanted effects, or even some bugs.

Don't change the values of (unless you really know what you're doing) :
#define MAX_GROUP_MEMBERS 6
#define TRAP_NPC_TYPE 1586