EZ Server

General Category => Updates => Topic started by: Hunter on November 08, 2012, 10:52:25 am


Title: Spells 110812
Post by: Hunter on November 08, 2012, 10:52:25 am
Spell file 110812 is now available.

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

Enjoy!

Title: Re: Spells 110812
Post by: Natedog on November 08, 2012, 12:23:25 pm
Quote from: Hunter on November 08, 2012, 10:52:25 am
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  :P :P



Code:
UPDATE spells_new SET effectid1 = 232 WHERE  id = 1546;

Title: Re: Spells 110812
Post by: Hunter on November 08, 2012, 04:44:14 pm
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

Title: Re: Spells 110812
Post by: Natedog on November 08, 2012, 06:16:15 pm
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



Title: Re: Spells 110812
Post by: Hunter on November 09, 2012, 12:28:26 am
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.


Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC