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

• 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]
• Official Guild Creation R... by Sarthin [April 21, 2024, 03:37:37 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]
• T11 Feedback Thread by Pubis [April 03, 2024, 12:54:53 pm]
• T10 Sunderock quest track... by Marcone [March 12, 2024, 07:12:11 am]
• It makes me very happy to... by Sarthin [March 10, 2024, 08:18:12 am]
• Broken Stuff Repair Shop ... by gnonim [March 08, 2024, 10:39:39 am]
• World loot currently brok... by Sarthin [March 08, 2024, 12:36:31 am]
• Testing Help Needed - Tes... by Sarthin [February 28, 2024, 09:49:51 am]
• Tier 11 - Kael Drakkel by Sarthin [February 25, 2024, 09:11:15 am]
• Set filters macro by Marcone [February 23, 2024, 05:13:59 pm]
• TOFS and possible spell b... by AreFitz [February 20, 2024, 02:31:05 pm]
• At Long Last....Tier 11. by Draca [February 16, 2024, 09:30:46 pm]
• Kickoff to T11 by Draca [February 15, 2024, 08:45:03 pm]
• T11 NPC Testers by Serra Angel [February 05, 2024, 05:20:29 pm]
• RALLOS ZEK EVENT by gnonim [February 01, 2024, 09:13:31 am]
• EZ Update - T11, Recent C... by Draca [January 31, 2024, 05:25:11 pm]
• T5 Named kills by ZerarWarrior [January 24, 2024, 08:08:07 am]
• Possible bug by Raygan [January 17, 2024, 03:35:08 pm]
• Tier 11, Kael Drakkel Upd... by Draca [January 09, 2024, 12:42:02 pm]
• Multi-botting instances by Serra Angel [December 31, 2023, 02:19:16 am]
• New Characters crashing w... by ZerarWarrior [December 30, 2023, 01:16:50 pm]
• Christmas event by Dbeast [December 26, 2023, 05:08:45 pm]
• Christmas Events? by Sarthin [December 22, 2023, 10:11:20 am]
• EQ3 by orkiho [December 19, 2023, 06:02:00 pm]
• T10 Factions by Otto [December 16, 2023, 03:00:09 pm]
• eq emulator site by akpainter [December 12, 2023, 05:39:13 pm]
• T11 Status by Pubis [December 12, 2023, 05:00:10 pm]

Members

• Total Members: 6125
• Latest: farrvva

Stats

• Total Posts: 64988
• Total Topics: 5053
• Online Today: 189
• Online Ever: 8678
• (December 19, 2022, 02:32:09 pm)

Users Online

Users: 1
Guests: 159
Total: 160

skinnytick