Spells 110812

[Guest]

Welcome, Guest. Please login or register.
Did you miss your activation email?

1 Hour 1 Day 1 Week 1 Month Forever

Login with username, password and session length

Getting Started

Rules

Character Mover

Optimization Guide

EZ Wiki

EZ Guide

Magelo

Zone List

Spell Recipes

T10.5 Spell Recipes

Crafting Recipes

Donate

EZ Player Discord

[EZ Server Files]

EZ Server Files

EZ Client Downloads

Custom UF MiniMap

Custom UF Inventory

EQEmu Server Status

EQEmulator Home

Allakhazam Home

UFMissingFilesList

TwitchTV

[Hunter]

Spell file 110812 is now available.

This fixes Paladin Lay on Hands and Stonewall stacking issues for several classes.

Enjoy!

[Natedog]

Spell file 110812 is now available.

This fixes Paladin Lay on Hands and Stonewall stacking issues for several classes.

Enjoy!

Imported this spell file into my test server and everything was working great thank you!



Also noticed that Divine Intervention was never changed to a Divine Save 

Code:

UPDATE spells_new SET effectid1 = 232 WHERE  id = 1546;

[Hunter]

I don't know why it didn't work last time, so I updated the code again for Divine Intervention.

No new spell file yet though.

Hunter

[Natedog]

One last change needed... forgot about the warrior 1hders and discipline...  those stack with the cleric which is still a bit overpowered



Fixed will be!!
With Discipline
Disc 45%
SoA 8%
Pet 17%
Total 70%



With 1hder 3.5
1hder - 35%
SoA 8%
Pet 17%
Total 60%



With 1hder 4.0++
1hder 45%
SoA 8%
Pet 17%
Total 70%









OLD!


With Discipline
Disc 45%
Cleric 25%
SoA 8%
Pet 17%
Total 95% (( OP ))



With 1hder 3.5
1hder - 35%
Cleric - 25%
SoA 8%
Pet 17%
Total 85% (( still pretty high ))



With 1hder 4.0++
1hder 45%
Cleric 25%
SoA 8%
Pet 17%
Total 95% (( OP ))





==============================================================
==============================================================



SQL fixes for -- 1hders and Stonewall Disc!




Stonewall Disc --- (( also removes slow runspeed ))

Code:

REPLACE INTO `spells_new` VALUES (4688, 'Stonewall Discipline', 'PLAYER_1', '0', '0', '0', 'Your body becomes as hard as stone.', '\'s body becomes as hard as stone.', 'Your body returns to normal.', 15, 0, 0, 0, 0, 0, 0, 11, 30, 0, 0, 0, 45, 0, 0, -45, 0, -700, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2503, 2119, -1, -1, -1, -1, 1, 1, 1, 1, -1, -1, -1, -1, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 0, 1, 0, 0, 10, 114, 254, 10, 168, 10, 0, 10, 10, 169, 10, 10, 6, 0, 15, -1, 0, 0, 81, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 44, 13, 0, 51, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 1, 326, 1, 0, 0, 1, 0, 0, 0, 0, 0, 4688, 27, 117, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 11, 0, 0, -87, 136, -144, -99, 11, 30, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 0, 0, 1, 1);

Epic 3.5 -- 1hder

Code:

REPLACE INTO `spells_new` VALUES (9796, 'Warrior Epic Stonewall I', 'PLAYER_1', '0', '0', '0', 'Your body becomes as hard as stone.', '\'s body becomes as hard as stone.', 'Your body returns to normal.', 15, 0, 0, 0, 0, 0, 0, 11, 40, 0, 0, 0, 0, 0, 0, -35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2503, 2119, -1, -1, -1, -1, 1, 1, 1, 1, -1, -1, -1, -1, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 0, 1, 0, 0, 10, 10, 254, 10, 168, 10, 10, 10, 10, 169, 10, 10, 6, 0, 15, -1, 0, 0, 81, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 44, 13, 0, 51, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 1, 326, 1, 0, 0, 1, 0, 0, 0, 0, 0, 4688, 27, 117, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 11, 0, 0, -87, 136, -144, -99, 11, 30, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 0, 0, 1, 1);

Epic 4.0 - 6.0  --- 1hder

Code:

REPLACE INTO `spells_new` VALUES (9745, 'Warrior Epic Stonewall II', 'PLAYER_1', '0', '0', '0', 'Your body becomes as hard as stone.', '\'s body becomes as hard as stone.', 'Your body returns to normal.', 15, 0, 0, 0, 0, 0, 0, 11, 40, 0, 0, 0, 0, 0, 0, -45, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2503, 2119, -1, -1, -1, -1, 1, 1, 1, 1, -1, -1, -1, -1, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 0, 1, 0, 0, 10, 10, 254, 10, 168, 10, 10, 10, 10, 169, 10, 10, 6, 0, 15, -1, 0, 0, 81, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 44, 13, 0, 51, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 1, 326, 1, 0, 0, 1, 0, 0, 0, 0, 0, 4688, 27, 117, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 11, 0, 0, -87, 136, -144, -99, 11, 30, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 0, 0, 1, 1);

Thanks again hunter! -- Sorry I didn't think of these before.. but I had a nap and remembered them lol

[Hunter]

Code:

[SQL] REPLACE INTO `spells_new` VALUES (4688, 'Stonewall Discipline', 'PLAYER_1', '0', '0', '0', 'Your body becomes as hard as stone.', '\'s body becomes as hard as stone.', 'Your body returns to normal.', 15, 0, 0, 0, 0, 0, 0, 11, 30, 0, 0, 0, 45, 0, 0, -45, 0, -700, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2503, 2119, -1, -1, -1, -1, 1, 1, 1, 1, -1, -1, -1, -1, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 0, 1, 0, 0, 10, 114, 254, 10, 168, 10, 0, 10, 10, 169, 10, 10, 6, 0, 15, -1, 0, 0, 81, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 44, 13, 0, 51, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 1, 326, 1, 0, 0, 1, 0, 0, 0, 0, 0, 4688, 27, 117, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 11, 0, 0, -87, 136, -144, -99, 11, 30, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 0, 0, 1, 1);
Affected rows: 2
Time: 0.071ms

[SQL] 
REPLACE INTO `spells_new` VALUES (9796, 'Warrior Epic Stonewall I', 'PLAYER_1', '0', '0', '0', 'Your body becomes as hard as stone.', '\'s body becomes as hard as stone.', 'Your body returns to normal.', 15, 0, 0, 0, 0, 0, 0, 11, 40, 0, 0, 0, 0, 0, 0, -35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2503, 2119, -1, -1, -1, -1, 1, 1, 1, 1, -1, -1, -1, -1, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 0, 1, 0, 0, 10, 10, 254, 10, 168, 10, 10, 10, 10, 169, 10, 10, 6, 0, 15, -1, 0, 0, 81, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 44, 13, 0, 51, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 1, 326, 1, 0, 0, 1, 0, 0, 0, 0, 0, 4688, 27, 117, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 11, 0, 0, -87, 136, -144, -99, 11, 30, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 0, 0, 1, 1);
Affected rows: 2
Time: 0.002ms

[SQL] 
REPLACE INTO `spells_new` VALUES (9745, 'Warrior Epic Stonewall II', 'PLAYER_1', '0', '0', '0', 'Your body becomes as hard as stone.', '\'s body becomes as hard as stone.', 'Your body returns to normal.', 15, 0, 0, 0, 0, 0, 0, 11, 40, 0, 0, 0, 0, 0, 0, -45, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2503, 2119, -1, -1, -1, -1, 1, 1, 1, 1, -1, -1, -1, -1, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 0, 1, 0, 0, 10, 10, 254, 10, 168, 10, 10, 10, 10, 169, 10, 10, 6, 0, 15, -1, 0, 0, 81, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 44, 13, 0, 51, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 1, 326, 1, 0, 0, 1, 0, 0, 0, 0, 0, 4688, 27, 117, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 11, 0, 0, -87, 136, -144, -99, 11, 30, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 0, 0, 1, 1);
Affected rows: 2
Time: 0.005ms

Thanks for the catch. It'll be in for the reboot.

Will post new spell file again soon.

Advanced search

• Unable to log in by Chieftan [November 23, 2024, 07:04:51 am]
• Everquest Tweaks and Sett... by Pubis [November 18, 2024, 11:18:15 am]
• Broken Stuff Repair Shop ... by Draca [November 12, 2024, 08:47:03 am]
• Update to Halls of Honor by Sarthin [November 10, 2024, 04:57:40 pm]
• Halloween 2024 by clbreastmilk [November 04, 2024, 07:55:17 am]
• Some T12 Questions by Miriya [October 28, 2024, 01:38:59 pm]
• HW 2024 by Raygan [October 21, 2024, 08:03:01 am]
• Ninja Looting by zefirus [October 20, 2024, 04:55:10 pm]
• Official Guild Creation R... by Tylperion [September 15, 2024, 11:54:54 am]
• T11 Feedback Thread by Sarthin [August 28, 2024, 12:45:01 pm]
• What's next for the rest ... by Mixlor [August 27, 2024, 02:01:07 pm]
• Hard Mode NPC by Mixlor [August 06, 2024, 09:37:00 am]
• Looking for some advice (... by Draca [July 31, 2024, 10:55:17 am]
• 4th of July Event by orkiho [July 12, 2024, 07:35:22 pm]
• New Server update causing... by Mixlor [June 02, 2024, 01:01:54 am]
• Memorial Day Event by wachna [May 30, 2024, 01:52:28 pm]
• EZServer Rules by Sarthin [May 30, 2024, 01:10:12 pm]
• Fear Itself, testing week... by torotornot [May 24, 2024, 09:29:42 am]
• Fear Itself, the new Even... by kendiian [April 26, 2024, 11:48:38 pm]
• Recent & Upcoming Changes by Dokplayer2 [April 23, 2024, 10:48:30 pm]
• Issue with my epic by fangzy [April 22, 2024, 07:32:32 pm]
• Few Changes - T11, VP, Gu... by clbreastmilk [April 10, 2024, 11:32:33 am]
• Combine HoH tokens macro.... by Dbeast [April 04, 2024, 05:10:46 pm]
• Warlock self buffs by Fecs [April 04, 2024, 03:56:08 pm]

Members

• Total Members: 6156
• Latest: Rin1

Stats

• Total Posts: 65127
• Total Topics: 5066
• Online Today: 407
• Online Ever: 8678
• (December 19, 2022, 02:32:09 pm)

Users Online

Users: 1
Guests: 373
Total: 374