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

Archive::Database/World Building Archive area for General Discussion's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-01-2002, 11:57 AM
quester
Hill Giant
 
Join Date: Oct 2002
Posts: 108
Default Seiitng NPC spells/procs/attacks

Can someone clue me in on how you would set NPCs to cast certian spells, and to have special attacks (such as kick, bash, etc) and procs (Like GhoulRoot)?

Let me clarify... Yes I know edit the database. Not a problem. But i'm not sure the format of the data that I need to use.

For example, lets say I was making a Froglock Warrior. He should bash, and kick, and should have a GhoulRoot proc. How would I enter that data into the DB? I found fields for "usedspells" and "npcspecialattacks", but i'm just not clear on how to enter the data in there. I'm pretty sure I do'nt enter "this dued procs ghoulroot!" lol. I'm guessing its the ID values of the Effects as given in spells_en? Would it be a standard text field with CSV, os space seperated values? Some form of bit flag?

Any help please. I'm goign through the code and beefing up the pet support in the emu, and in order to do that I need to be able to give pets thier proper special attacks, spells, procs, etc.
Reply With Quote
  #2  
Old 11-01-2002, 02:02 PM
Xarslik
Hill Giant
 
Join Date: Oct 2002
Location: System.Web
Posts: 107
Default

NPC Special Attacks involves flags A-N, which specify whether or not they flurry, rampage, summon, and enrage. Some of them will crash the emu atm so be careful using them.

"Procs" havn't really been implemented yet, however you can make them cast spells by placing spell IDs separated by spaces in the usedspells column.
__________________
~ Xarslik
[ Xarslik's Arena Challenge Server ]
Reply With Quote
  #3  
Old 11-01-2002, 02:12 PM
quester
Hill Giant
 
Join Date: Oct 2002
Posts: 108
Default

Thanks for the info. Does the spell casting check for valid class?

Maybe i'll start this out by adding in NPC procs first. Thats really something that should be there.
Reply With Quote
  #4  
Old 11-02-2002, 04:32 AM
Lurker_005
Demi-God
 
Join Date: Jan 2002
Location: Tourist town USA
Posts: 1,671
Default

quester,
if you provide a list of race,class,level, spell list
and race,class,level,special attack
for named mobs just lest the name,spelllist,special attack
I'll add it to the DB Addon for the whole DB

There is no class or even level check on the spells, limit it to 8 spells per npc. The emu can handle more, but requires a change somewhere. Not sure but the order of the spells might matter, I can't remember.

Drawde's DB has spells and special attack in it if you want a referance.
__________________
Please read the forum rules and look at reacent messages before posting.
Reply With Quote
  #5  
Old 11-02-2002, 04:35 AM
quester
Hill Giant
 
Join Date: Oct 2002
Posts: 108
Default

What i'm working on right now is the code for NPC Procs.. Pretty much finished it last night, but got a few things to iron out today.

It requires a new field in the DB though. I posted the propsed DB change in the dev forum, havent' seen a response yet.
Reply With Quote
  #6  
Old 11-02-2002, 04:47 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

I dont think that'd be a problem.. changing the table would be easy, even for an existing database. Just make the code robust enough to recognize a null value field so all npc's dont need to be assigned a zero if they dont have a proc attatched.

Optionally, you could modify spells used field, and identify the proc differently, with a <spellid>.<procnumber> id, that way it wouldnt require a database change, but the code where spells are read in would need to be modified minorly to ignore the procs.
Since usedspells is a varchar(70), you shouldnt have anyproblems. Still just be easier though to create the new column though.
Reply With Quote
  #7  
Old 11-02-2002, 04:55 AM
quester
Hill Giant
 
Join Date: Oct 2002
Posts: 108
Default

I've already written the code to work off the new caolumn, so I dont think I would go back and use the spells one now. It is a pretty simple change though, just:

ALTER TABLE npc_types ADD npcproc int(7);

The code simply ignores the proc if it is null, 0, or 65535
Reply With Quote
  #8  
Old 11-02-2002, 06:40 AM
quester
Hill Giant
 
Join Date: Oct 2002
Posts: 108
Default

See the dev forum if you are interested.. I've posted the changes required to add mob melee procs into the emulator:
http://forums.eqemu.net/showthread.p...;threadid=3982

Now that that is finished, tonight I will start on beefing up the ole pet support.
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 12:32 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3