Factions not working 5.5dr-1
 

Hi

I've just tested the latest version of EQemu from CVS and can't seem to get any mobs to affect the faction_values table. There doesn't seem to be any faction hits and most mobs appear to be indifferent at least.

I created two new factions, good/evil and set the npc_factions to them. I've also set all npcs to be good/evil based on their race.

I can see a range of indifferent to amiable. The faction hits don't work from npc_faction_values and no message in game either with a GM and non-GM.

Any suggestions anyone?

Many thanks

InKy

After lots of checking and help from Rogean it looks as if EQEmu isn't checking the faction id when spawning mobs. If you do a #viewnpctype <id> it lists it as factionid = 0. Even though there is an entry in npc_faction_id in npc_types.

I'm wondering if the column has changed? Agro works perfectly if I #ai factionid <id>.

Thanks in advance

InKy

In database.cpp I see the following:

/* if (RunQuery(query, MakeAnyLenString(&query, "SELECT faction_id, value, primary_faction FROM npc_faction WHERE npc_id = %i", tmpNPCType.npc_id), errbuf, &result2)) {
safe_delete_array(query);
int i = 0;
while((row2 = mysql_fetch_row(result2))) {
if (atoi(row2[2]) && i != 0) {
tmpNPCType.factionid[i] = tmpNPCType.factionid[0];
tmpNPCType.factionvalue[i] = tmpNPCType.factionvalue[0];
tmpNPCType.factionid[0] = atoi(row2[0]);
tmpNPCType.factionvalue[0] = atoi(row2[1]);
}
else {
tmpNPCType.factionid[i] = atoi(row2[0]);
tmpNPCType.factionvalue[i] = atoi(row2[1]);
}
i++;
if (i >= MAX_NPC_FACTIONS) {
cerr << "Error in DBLoadNPCTypes: More than MAX_NPC_FACTIONS factions returned, npcid=" << tmpNPCType.npc_id << endl;
break;
}
}
mysql_free_result(result2);
}*/


Since this is all commented out it explains my faction problems. However, since I wasn't aware of any change to the npc_types table I was never aware.

How can I correct my npc_type table to allow factions to function?

Many thanks

I went into the source and looked too , it seems that everywhere it refers to faction it is commented out , is there a reason for this???
Makes for some really boring game play when the npcs just stand there like idiots.

It seems that when the new qglobals field was added it was, for some reason, tied to faction.
To get faction working again , make sure you have the qglobals field in the npc_types table.

sql statement in Shawn319's post following this one :)

ALTER TABLE `npc_types` ADD `qglobal` INT(2) UNSIGNED DEFAULT "0" NOT NULL;

Great, thanks that's resolved the problem.

So where do we put this line?
enter it directly into the mysql prompt command line?

Im just new to mysql, thanks info :)

Yes.