Quote:
Originally Posted by Slimshaydy
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.