iggi
03-25-2011, 08:45 PM
I have the latest server with the latest DB and latest SQL updates.
I first cleared the entire "freporte" zone by dropping all entries in the spawn2 table with freporte as their zone. I then created two factions, assigned them to two mobs, but both con indifferent and give no faction hits when killed.
Here is the entries in faction_list:
| id | name | base | (mod rows)|
| 4000 | Justicars_of_Rodcet_Nife | -750 | 0 |
| 4001 | The_Unholy_Bertox_Guard | 250 | 0 |
Entries in npc_faction:
+------+--------------------------+----------------+-----------------------+
| id | name | primaryfaction | ignore_primary_assist |
+------+--------------------------+----------------+-----------------------+
| 5000 | The_Unholy_Bertox_Guard | 4001 | 0 |
| 5001 | Justicars_of_Rodcet_Nife | 4000 | 0 |
+------+--------------------------+----------------+-----------------------+
Entries in npc_faction_entries:
+----------------+------------+-------+-----------+
| npc_faction_id | faction_id | value | npc_value |
+----------------+------------+-------+-----------+
| 5000 | 4000 | 100 | -1 |
| 5000 | 4001 | -1000 | 1 |
| 5001 | 4000 | -10 | 1 |
| 5001 | 4001 | 10 | -1 |
+----------------+------------+-------+-----------+
4 rows in set (0.00 sec)
Section from npc_type (the faction numbers are wrong probably because I was changing numbers):
| id | name | lastname | level | race | class | bodytype | hp | gender | texture | helmtexture | size | hp_regen_rate | mana_regen_rate | loottable_id | merchant_id | npc_spells_id | npc_faction_id |
--
| 999147 | good | NULL | 1 | 1 | 1 | NULL | 1000 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 |
--
| 999148 | bad | NULL | 1 | 1 | 1 | NULL | 1000 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5001 |
--
| 999151 | good | NULL | 1 | 1 | 1 | NULL | 10000 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 |
Any ideas?
I first cleared the entire "freporte" zone by dropping all entries in the spawn2 table with freporte as their zone. I then created two factions, assigned them to two mobs, but both con indifferent and give no faction hits when killed.
Here is the entries in faction_list:
| id | name | base | (mod rows)|
| 4000 | Justicars_of_Rodcet_Nife | -750 | 0 |
| 4001 | The_Unholy_Bertox_Guard | 250 | 0 |
Entries in npc_faction:
+------+--------------------------+----------------+-----------------------+
| id | name | primaryfaction | ignore_primary_assist |
+------+--------------------------+----------------+-----------------------+
| 5000 | The_Unholy_Bertox_Guard | 4001 | 0 |
| 5001 | Justicars_of_Rodcet_Nife | 4000 | 0 |
+------+--------------------------+----------------+-----------------------+
Entries in npc_faction_entries:
+----------------+------------+-------+-----------+
| npc_faction_id | faction_id | value | npc_value |
+----------------+------------+-------+-----------+
| 5000 | 4000 | 100 | -1 |
| 5000 | 4001 | -1000 | 1 |
| 5001 | 4000 | -10 | 1 |
| 5001 | 4001 | 10 | -1 |
+----------------+------------+-------+-----------+
4 rows in set (0.00 sec)
Section from npc_type (the faction numbers are wrong probably because I was changing numbers):
| id | name | lastname | level | race | class | bodytype | hp | gender | texture | helmtexture | size | hp_regen_rate | mana_regen_rate | loottable_id | merchant_id | npc_spells_id | npc_faction_id |
--
| 999147 | good | NULL | 1 | 1 | 1 | NULL | 1000 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 |
--
| 999148 | bad | NULL | 1 | 1 | 1 | NULL | 1000 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5001 |
--
| 999151 | good | NULL | 1 | 1 | 1 | NULL | 10000 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 |
Any ideas?