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 10-06-2008, 01:26 PM
Irreverent
The Solo Server
 
Join Date: May 2007
Posts: 416
Default Quick Way to Make a Zone KoS?

Some zones, like PoAir & PoWater are not aggro due to not being fully implemented.

However, in the process I'd rather make them aggressive than sitting there ready to share a peace pipe.

I originally grabbed from the spawn tables all npcs that spawned from npc lists, then turned their faction to 360?(or whateer KoS was) but that didn't make them aggro? Haven't really spent much time on this, hoping there was a quick way before I had to figure it out.
__________________
OP of Irreverent Server (The Solo Server)
Our Forums
Reply With Quote
  #2  
Old 10-06-2008, 02:10 PM
paaco
Discordant
 
Join Date: Jan 2005
Posts: 320
Default

Grab George's loot editor tool. Figure out what faction ID you want to give every mob in the zone. Change the first mob in the lists faction ID to the new ID. Go to the top to Field Utilities -->Propagate/Copy Fields. It will ask if you are sure you want to do this, say yes. It changes every NPC in the zone to the new faction ID.
Reply With Quote
  #3  
Old 10-06-2008, 05:55 PM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Here's a quick way (for PEQ database);
KOS no assist
Code:
UPDATE npc_types SET npc_faction_id=19471 WHERE (ID>=215000 AND ID<=215999);
or KOS with assist;
Code:
UPDATE npc_types SET npc_faction_id=19472 WHERE (ID>=215000 AND ID<=215999);
This will set KOS to every NPC in Plane of Air.
Here's how I did that;

the faction IDs are both KOS factions, one the mobs will assist on a long pull the other no. Since 215 is the zone number for PoAir , 215000-215999 are reserved for PoAir NPCs only. Look up the zone numbers for the other zones you want to set, and use the above as a template (replace the '215').

This is the quickest way, but it has draw backs- there are in invisible NPCs in PoAir that do not require KOS. Also , there could be other NPCs that may need to be indiff.
I look for bodytype or race AFTER I run the above querys;

Code:
UPDATE npc_types SET npc_faction_id=0 WHERE (ID>=215000 AND ID<=215999) AND race=127;
127 is invisible NPCs in the zone, not intended to be beating on you out of nowhere

Lets say you had merchants in the zone, so merchant class id number is 41;
Code:
UPDATE npc_types SET npc_faction_id=0 WHERE (ID>=215000 AND ID<=215999) AND class=41;
Eventually, after you've run these querys (make sure you restart the server for changes to take effect), You will have to go into the zone and make sure you didn't leave any stray unwanted KOS-converted mobs.

With this same example, you can quickly set up regular factions to whole zones. after you've made one for one NPC, you get the number and apply it with the querys above.

Last edited by Angelox; 10-07-2008 at 03:25 AM..
Reply With Quote
  #4  
Old 10-06-2008, 09:55 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

Actually, the

KOS no assist=19471 and KOS with assist=19472 is something I will add to the tool. I did not know of both, just one of them.

Thanks for the info AX!

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #5  
Old 10-06-2008, 10:09 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Don't feel bad, 19472 I only added recently (past few months)
Reply With Quote
  #6  
Old 10-08-2008, 01:26 PM
Irreverent
The Solo Server
 
Join Date: May 2007
Posts: 416
Default

Awesome, thanks a lot. You've all helped again so much. Just trying hard to get some broadbrush polishes done so I can get back into more precision database building.
__________________
OP of Irreverent Server (The Solo Server)
Our Forums
Reply With Quote
  #7  
Old 10-08-2008, 02:55 PM
Congdar
Developer
 
Join Date: Jul 2007
Location: my own little world
Posts: 751
Default

hopefully the quest npc's and the keymaster don't get set to kos... others?
Reply With Quote
  #8  
Old 10-08-2008, 04:52 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Imatrigger hits you for 10,000 points of damage!

Loading please wait...


Yeah, I've been there.
Reply With Quote
  #9  
Old 10-11-2008, 04:28 PM
Irreverent
The Solo Server
 
Join Date: May 2007
Posts: 416
Default

Only question is I don't see those factions in the faction_list table?

Or is it a hardcoded value? Didn't see it in the most PEQ either
__________________
OP of Irreverent Server (The Solo Server)
Our Forums
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 09: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