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 11-10-2004, 07:56 PM
WildcardX
Developer
 
Join Date: Apr 2003
Posts: 589
Default Spells List?

I see in my database the tables for npc_spells and npc_spells_entries. from looking thru the DB i would guess the spells are in the later of the 2 tables, but everything is by ID number so I am not sure which spell is actually what ID. Anyone have a spell list or is there a description in the DB that matches to a ID I can look at?
Reply With Quote
  #2  
Old 11-11-2004, 01:59 AM
1010101
Sarnak
 
Join Date: Mar 2002
Posts: 63
Default

http://www.gameroom.com/1010101/EQLi...Oct25_2004.txt
__________________
- 1010101
Reply With Quote
  #3  
Old 11-11-2004, 02:02 AM
cloud2276
Fire Beetle
 
Join Date: May 2004
Posts: 19
Default

Download this
http://www.eqcaster.com/downloads/EqCaster.zip
Unzip it somewhere, and run the program.
open up your spells.en.txt in your everquest folder, If you want to find the translocate spells for the port gnomes click on miscellaneous and sort the descritptions by clicking on the bar that says descriptions. This will sort these to make it easier to find stuff. If you want the spell ID, scroll the window all the way to the right, and the last field is the spell ID number. Example to get from oasis to OOT with the port gnome, you would cast spell Portal to Ocean (spell ID 2279)

Hope this helps
Reply With Quote
  #4  
Old 11-11-2004, 05:03 AM
WildcardX
Developer
 
Join Date: Apr 2003
Posts: 589
Default

You guys rock! Thanks for the info. Gonna try it out now.
Reply With Quote
  #5  
Old 11-11-2004, 08:54 AM
WildcardX
Developer
 
Join Date: Apr 2003
Posts: 589
Default

Another question... I found that spellid 2285, gnome TL to OT drops the player off at the wrong LOC, but the LOC in the spells_en.txt is the correct LOC, where is the game getting the other incorrect loc from and how can I change it to the correct LOC?
Reply With Quote
  #6  
Old 11-11-2004, 12:15 PM
animepimp
Dragon
 
Join Date: Jan 2004
Posts: 860
Default

Its probably switching the x and y, making them backwards because the client uses them and shows them as y x z while the server shows them as x y z, so jsut reverse them in the spells.txt files the server uses.
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 06:09 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