NPC Faction - Stuck at amiable

[vrated]

I am trying to modify the faction of lava beetles in Soldungb to KOS. They are currently amiable.

Here is what I have done:

1. Create a new record in faction_list. Record has unique ID "366", and a unique name, "Animals". Base is set to "-1000" and all other mods to "0".

2. Looked for the npc_faction_id of Lava Beetles in the npc_types table. This number was "3268".

3. Create a new record under npc_faction. id = "3268". name = "lava beetle". Primaryfaction = "366".

4. Create a new record under npc_faction_entries. npc_faction_id = "3268". faction_id = "366". value="0".

I do not want the player to drop or raise faction thus value set to 0 in step 4, even though all the mod's in faction_list are set to 0.

Restart the server, log in, con Lava Beetle(s). All con amiable.

Running 5.7-DR4 (06/14/04). MySQL 4.0.18.
MW_057DR2_alpha_1 db, with the govtcheese faction updates.

Other mobs for example, in Soldungb such as kobolds which in the mysql db are set to kos through their faction, do con KOS. So its not a server wide problems. I just cannot change the con on Lava beetles. I also tried it on Sonic bats, and have the same problem.

I'm stumped as to why I cannot get the faction changed.

Any ideas or help would be greatly appreciated.

Thanks.

[Swampdog]

I had a similar problem but it resolved itself after I updated my npc_types table. Cant remember if it was adding the AC column or what. Go through the forums and make sure you have done all the table updates for npc_types.

[vrated]

The updates i have done to my npc_types table are:

SOURCE noc_types_update;
ALTER TABLE `npc_types` ADD `AC` smallint(5) not null default 0;
update npc_types set AC=(((level*level)/1.5)+15) where AC=0;

did i miss something?

any other ideas?

[sandy]

hi

1) lava beetles are not animals they are insects ^^

2) if you don't want faction hits, put no entries in npc_faction_entries

[vrated]

hi

1) lava beetles are not animals they are insects ^^

2) if you don't want faction hits, put no entries in npc_faction_entries

Sill not sure how this resolves my problem though. I took the entry out, and still they con amiable.

Animals is just a generic faction I created which will include bears, lions, insects, giants. Basically the faction towards these mobs cannot be changed, but begins at KoS.

I've set the "base" to "-1000", which should not be amiable, yet they show up amiable.

[govtcheeze]

3. Create a new record under npc_faction. id = "3268". name = "lava beetle". Primaryfaction = "366".

There should have already been an entry:

INSERT INTO npc_faction VALUES (3268, 'Lava_Beetle', 0); -- NO FACTION

Instead of ADDING a new one, you should edit this line in the DB to update the 0 to 366.

4. Create a new record under npc_faction_entries. npc_faction_id = "3268". faction_id = "366". value="0".

4 is not needed since faction will not be gained or lost.

Let me know if this works.

[RangerDown]

Govtcheeze was right, in that if there already was a record with id 3268 in the `npc_faction` table then nothing happened when you tried to add one. In fact the database should give an error if you try to add an entry into `npc_faction` with an `id` field that already exists.

Make sure the PrimaryFaction field is set to 366 for that record. You can make sure of this by executing the command:
UPDATE npc_faction SET Primaryfaction=366 WHERE id=3268
Then restart the server.

That should have the beetles conning at least threatening, if not scowling.

If you still don't get a correct faction after that, then do two things:

(1) Do an #npcstats on the beetle you're conning. From what I read, you found that the beetle's faction_id was 3268 from looking in the database -- but there might be more than one lava beetle in the npc_types table, and that particular lava beetle's faction_id might not be 3268. If it's not, get its Npc Type number and make the appropriate change in the npc_types table.

(2) If you still have problems, let me know. I will have you do a few SELECT's on some tables to make sure the values are what you and I think they are.

[vrated]

Thank you both for your help. I've got the beetles KOS! ;)

Now to convert all animals\insect\giants\undead and i'm all finished!

[sandy]

sorry what i said was not to resolve your pb of amiable

nm =)