Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 04-10-2013, 11:29 PM
JimB_1958
Sarnak
 
Join Date: Mar 2013
Location: Springfield MO
Posts: 66
Default War mobs

First post...

I been working on my server for a couple weeks, and finaly run into something I cant figure out on my own.

I want a warring NPC to spawn now and then and reek havok in a zone.

I have made them scowling and ready to attack every player type but for the life of me I cannot make the attack other NPCs. I want them to pretty much sweep the zone and kill everything in sight or be killed off in trying.

Thanks for any help.
__________________
"We are all on the same team, and I think not enough people realize this."
- Leetsauce
Reply With Quote
  #2  
Old 04-11-2013, 12:05 AM
ChaosSlayerZ's Avatar
ChaosSlayerZ
Demi-God
 
Join Date: Mar 2009
Location: Umm
Posts: 1,492
Default

you need to set agro flag for that specific npc to 1
i forgot what the field called, but its in npcs table in DB
Reply With Quote
  #3  
Old 04-11-2013, 12:44 AM
JimB_1958
Sarnak
 
Join Date: Mar 2013
Location: Springfield MO
Posts: 66
Default

Quote:
you need to set agro flag for that specific npc to 1
i forgot what the field called, but its in npcs table in DB
Well... I thought I did that. I set npc_aggro to 1 in npc_types but that didnt seem to work.

I also looked in rule values... there are some settigs for Agro, but not anything that stands out to be NPC to NPC agro.

Im befuddled for now.
__________________
"We are all on the same team, and I think not enough people realize this."
- Leetsauce
Reply With Quote
  #4  
Old 04-11-2013, 09:15 AM
ChaosSlayerZ's Avatar
ChaosSlayerZ
Demi-God
 
Join Date: Mar 2009
Location: Umm
Posts: 1,492
Default

ok, did you also set your specific NPC to be on opposite faction to other npcs?

see how say Qeynos Guards are set in default PEQ Db so they attack gnolls and snakes
Reply With Quote
  #5  
Old 04-11-2013, 02:52 PM
JimB_1958
Sarnak
 
Join Date: Mar 2013
Location: Springfield MO
Posts: 66
Default

Ok... Think I got this as clear as mud

From Faction_List I found that Qeynos Guard are faction ID 135

Running this query...

select * from npc_faction where id in
(select npc_faction_id from npc_faction_entries where faction_id =135
and value > 0)

gives me data like...

id,name,primaryfaction,ignore_primary_assist
4,Lord_Grimrot,21,0
18,Guard_Donlan,21,0
29,Chesgard,21,0
50,qey_gnolls,279,0
51,a_gnoll_commander,279,0

Where as if I change value to < 0 I get

id,name,primaryfaction,ignore_primary_assist
8,Sir_Morgan,167,0
12,Narra_Tanith,135,0
17,Chanda_Miller,167,0
26,Holly_Windstalker,265,0

which looks pretty much in line with KOS and non-kos mobs... However...
Nowhere can I find in the database where any of the Qeyons Guards like Guard Hezlan is tied to this faction ID 135
And the guards dont attack the gnolls. Flippy Darkpaw walks right into town without harrassment.

I even tried an experiment... I changed npc_faction_id to 135 in npc_type table for Guard Hezlan and he still does nothing

Im stumped.
__________________
"We are all on the same team, and I think not enough people realize this."
- Leetsauce
Reply With Quote
  #6  
Old 04-11-2013, 09:30 PM
Maceblade
Hill Giant
 
Join Date: Jun 2010
Posts: 231
Default

Derakor The Vindicator will ONLY attack Paladin npc type mobs in Qeynos but leave other guards alone, however the other guards will assist Paladin type guards on Vindi.

Experimented in Kael, Quarm won't fight anything in the zone but it will fight Yelinak. IDK why.

**Yes I said Kael, and Yes I spawned Yelinak inside Kael to see who he would fight. He fights with Vindi thats about it**
Reply With Quote
  #7  
Old 04-12-2013, 12:01 AM
ChaosSlayerZ's Avatar
ChaosSlayerZ
Demi-God
 
Join Date: Mar 2009
Location: Umm
Posts: 1,492
Default

ok i don't really have time to explain this in full right now, but there are 3 different tables tied to each other in DB that determine how faction interaction works.
Its rather complex, but there is an article in Wiki explaining that - which is where I originally learn how to do it. Look it up
Reply With Quote
  #8  
Old 04-12-2013, 05:53 PM
JimB_1958
Sarnak
 
Join Date: Mar 2013
Location: Springfield MO
Posts: 66
Default

Quote:
ok i don't really have time to explain this in full right now, but there are 3 different tables tied to each other in DB that determine how faction interaction works.
Its rather complex, but there is an article in Wiki explaining that - which is where I originally learn how to do it. Look it up
Yes... Did that before my first post. Double and triple-checked it. The values there are correct. Or at least seem to be correct. But, they just dont seem to work. I can summon any mob into the guards agro range and they stand there like they are on a smoke break.

So its not working with guards and such and not working with the mobs I created. They attack Players of all kinds just fine.. they and the guards will not attack another NPC.

Im going back to test with my non-DM test character to see if the guards will protect him if he pulls mobs to him. Maybe, if this works, I can figure out a way to make assist agro do the trick
__________________
"We are all on the same team, and I think not enough people realize this."
- Leetsauce
Reply With Quote
  #9  
Old 04-14-2013, 11:13 PM
JimB_1958
Sarnak
 
Join Date: Mar 2013
Location: Springfield MO
Posts: 66
Default

Im still struggling with this issue. If anyone can point me in the right direction or tell me it's impossible I would very much appreciate it.

The problem: NPCs do not attack other NPCs. Qeyos guards stand by and watch Flippy Darkpaw run into the city, the Dragoons in Overthere walk around and molest nothing... not even a cactus.

Did I miss a setting or something in the DB?
__________________
"We are all on the same team, and I think not enough people realize this."
- Leetsauce
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 02:05 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3