View Single Post
  #5  
Old 04-27-2021, 12:04 PM
Drakiyth's Avatar
Drakiyth
Dragon
 
Join Date: Apr 2012
Posts: 549
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