Go Back   EQEmulator Home > EQEmulator Forums > Support > Spell Support

Spell Support Broken Spells? Want them Fixed? Request it here.

Reply
 
Thread Tools Display Modes
  #1  
Old 03-01-2021, 02:38 PM
Slimshaydy
Fire Beetle
 
Join Date: Oct 2014
Posts: 6
Default Am I missing a step?

Im editing some 71+ Spells to be used on my MAX Level 70 server and Im getting this.

Vinelash Cascade 73 ranger spell, scribable #scribespells 70, but still shows up on spell gem as level 73.. Heres what im doing.

1. Edited spell to be Ranger/Dru usable at 70 in EoC
2. Generated Spells text
3. Placed new file in my EQ directory
4. Copied the new file into imports
5. Imported file to db
6. Start server

Am i missing something on why these levels are off? TIA <3
Reply With Quote
  #2  
Old 03-01-2021, 05:27 PM
Slimshaydy
Fire Beetle
 
Join Date: Oct 2014
Posts: 6
Default

Could anyone please point me in the right direction ive been trying to figure this out all day smh
Reply With Quote
  #3  
Old 04-26-2021, 07:00 AM
Nerdgasm
Discordant
 
Join Date: Apr 2013
Posts: 419
Default

Quote:
Originally Posted by Slimshaydy View Post
Could anyone please point me in the right direction ive been trying to figure this out all day smh
Still need help with this?
__________________
I am the All Mighty Mittens!
Reply With Quote
  #4  
Old 04-26-2021, 09:05 AM
Drakiyth's Avatar
Drakiyth
Dragon
 
Join Date: Apr 2012
Posts: 545
Default

Quote:
Originally Posted by Slimshaydy View Post
Im editing some 71+ Spells to be used on my MAX Level 70 server and Im getting this.

Vinelash Cascade 73 ranger spell, scribable #scribespells 70, but still shows up on spell gem as level 73.. Heres what im doing.

1. Edited spell to be Ranger/Dru usable at 70 in EoC
2. Generated Spells text
3. Placed new file in my EQ directory
4. Copied the new file into imports
5. Imported file to db
6. Start server

Am i missing something on why these levels are off? TIA <3



What you're trying to do is very easy. I'll help you:

1) Open your Heidi/Navicat and go to your table spells_new you will see classes tabs. Each one of these is numbered 1-16 which represents the classes in the game.
2) Classes4 = Ranger
3) Classes6 = Druid
4) Change anything that is over level 70 and below level 255 with the classes with the following 2 SQL queries:
UPDATE spells_new SET classes4 = 70 WHERE classes4 > 70 and < 255;
UPDATE spells_new SET classes6 = 70 WHERE classes6 > 70 and < 255;

5) Once that is done you need to get your spells_us.txt created. You can do this multiple ways.
6) Add the file to your main EQ directory and replace the old one.


You're done. There is nothing else you need to do. All you're doing is lowering the levels which is handled by the database and the spells_us.txt client file. I hope this helps you.
Reply With Quote
  #5  
Old 04-27-2021, 12:04 PM
Drakiyth's Avatar
Drakiyth
Dragon
 
Join Date: Apr 2012
Posts: 545
Default

You can't edit your posts on this forum after a certain time so I'll have to double post.

I noticed I missed a small detail at the end of the SQL lines above. I just ran these on a test database and they will work for sure with what you're trying to do. Change the 255 down to whatever level you want to stop at for your 70 cap on these classes. So like < 81 if you want level 71 to 80 spells at level 70.

If you're using EOC 2.0 just get the spells_us.txt file on there with the peq editor under: spells -> generate spells_us.txt -> right click and save the file after it loads into your main EQ game directory and replace it. You'll be set.

UPDATE spells_new SET classes4 = 70 WHERE classes4 > 70 AND classes4 < 255;
UPDATE spells_new SET classes6 = 70 WHERE classes6 > 70 AND classes6 < 255;


My apologies if you already knew most of this. I find it better to be detailed in explanations even if it might be obvious, because you never know if you miss something. Like I did above, lol.
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 11:29 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