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 12-07-2008, 04:24 PM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 904
Default Spell Lists

I'm currently running into an issue where a good number of my spell lists are empty. I have tried manually adding spells to the lists but they just don't work correctly.

More specifically, none of the pet's spell lists are populated. I tried doing the Air Pet and all he did was Proc Invis and didn't cast Stun even though I put the proc spell under Spell list 14 and the invis spell under spell list 13.

Please help!
Reply With Quote
  #2  
Old 12-07-2008, 04:29 PM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

The spell files for both the client and server must match. Have they been updated in both places?
Reply With Quote
  #3  
Old 12-07-2008, 05:35 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

He's talking about NPC spell lists, not the spell file :P

Have you tried using GeorgeS' NPC Loot Editor to change the spell lists? It works pretty well and is straight forward. You will need to at least restart your zone for spell list changes to take effect.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #4  
Old 12-07-2008, 06:01 PM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 904
Default

Quote:
Originally Posted by trevius View Post
He's talking about NPC spell lists, not the spell file :P

Have you tried using GeorgeS' NPC Loot Editor to change the spell lists? It works pretty well and is straight forward. You will need to at least restart your zone for spell list changes to take effect.
I have been and I zone to test changes.

I add the spells to the lists but they don't work correctly.

For instance, I added Air Elemental Strike to spell list 14 and Air Elemental Invisibility to spell list 13. When my air elementals attack they randomly proc Invis (not strike) and never cast invis.
Reply With Quote
  #5  
Old 12-07-2008, 06:50 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Did you set the level range to be within the range that you want the NPCs to be casting them? I'm not sure why they are set to proc invis, that should be set as a buff. If you want them to cast a spell on a player, then you would need to make sure you set it as the right type.

http://www.eqemulator.net/wiki/wikka...cspellsentries

If you want them to proc a spell when hitting (vs casting a spell), you need to set the spell ID as the proc. Also, you can check for parent lists that might use different lists of spells. You can have up to 1 parent list per spell list.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #6  
Old 12-07-2008, 09:29 PM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 904
Default

Is there a way for someone to export the lists to me and then me import them? I don't know why so many of mine are empty.

The last server I played on had full lists and it was a much older database.
Reply With Quote
  #7  
Old 12-08-2008, 01:40 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Just download the PEQ DB and install it into another database name in your mysql server. Then, you can easily use Navicat to copy the table and paste it into your own database. I highlight the table I want to copy and then press CTRL+C and then go to the database I want to paste it into and delete the table I am replacing, and then press CTRL+V. Of course, it is best to backup your entire database before doing risky changes like this.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #8  
Old 12-08-2008, 12:10 PM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 904
Default

I installed a new database (1129 Rev 233) with the newest CVS Quests and DB files and when I opened it up with the GeorgeS Spell List Editor the spell lists there are also empty.

Am I doing something wrong?
Reply With Quote
  #9  
Old 12-09-2008, 12:35 AM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 904
Default

Got the earth pet to work finally, but not any other pet.
Reply With Quote
  #10  
Old 12-10-2008, 06:58 PM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 904
Default

Finally made some progress.

Air pet casts invis finally. Problem is he just chain casts it non-stop. On top of that while he's chain casting invis he's randomly stunning himself (with the air elemental strike spell).

No idea how he's proc'ing off of a cast, but he is.
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 01:25 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