Spell bugs

[Dello0000]

(Server 1.6 + Client 10714L)
I'm going to hazard a guess and say all pet buffs are server crashers.
Here is a list of spells that are bugged. Ill update as i go.

All Combat Arts and non spells were / still are able to be "cast" while moving.

Partial or No Stat change is due to the non implementation of Mitigation and Avoidance stats i think.

[CRASHERS]
Necro - *Howl of the Damned* crashes server. [Class required = 0 (needs to be 30)]
Necro - *Grisly Protection* crashes server. [Class required = 0 (needs to be 30)]
Necro - *Bloody Ritual* crashes server. [Found LUA Spell Script: 'Spells/Mage/Summoner/Necromancer/BloodyRitual.Lua' *When cast* - Player: (name) earned 2331 experience.]

Conjuror - *Defensive Haven* crashes server. [Class required = 0 (needs to be 29)]
Conjuror - *Antagonize* crashes server. [Class required = 0 (needs to be 29)]

Coercer - charmed monster dies. crashes server. [Error running Spells/Mage/Enchanter/Coercer/Charm.lua:24: attempt to compare number with nil]

Swashbuckler *Double-Cross* crashes server. [Class_req = 0 (needs to be 33)]

Warden *Armor of Seasons* crashes server. [class required = 0] [class required = 1074791424] [(needs to be 16)]

Mystic *Haze* Crashes server. [Class_req = 0 (needs to be 19)]

[BUGGED]
----------
Wizard *firestorm* doesn't have any visuals.
Wizard *Incinerate* doesn't have any visuals.
Wizard *Ice Spears* doesn't have any visuals.
Wizard *Immolation* doesn't have any visuals.
Wizard *Glacial Wind* doesn't have any visuals.
Wizard *Solar Flare IV* doesn't have any visuals.
Wizard *Storm of Lightning* doesn't have any visuals.
Wizards *Fortify Element* doesn't give stats.
----------
Warlock *Cataclysm* Crashes server. (no error)
----------
Illusionist *Entrance II* (lv12) doesn't have an *Entrance*(Lv1) before it.
Illusionist *Chromatic Storm* Crashes server. (no error)
Illusionist *Personae Reflection* (Lv2) missing.
----------
Coercer *Mesmerize II* (lv12) doesn't have *Mesmerize* (lv2) before it.
Coercer *Hemorrhage* (I, II, III, IV) Crashes server. (no error)
Coercer *Charm* no crash!! [Class_req = 0(needs to be 27)]
----------
Swashbuckler *Bladeweaver* No stat change.
Swashbuckler *Fancy Footwork* Partial stat change.
----------
Brigand *Rob* Does no damage. [Class_req = 0 (needs to be 34)]
Brigand *Blackguard* Partial stat change.
----------
Troubador *Graceful Avoidance* No stat change.
Troubador *Selo's Accelerando* No stat change.
Troubador *Daelis' Dance of Blades* Needs changed to *Daeli's Dance of Blades*
Troubador *Disheartening Descant* Crashes server. (no error)
----------
Beastlord No extra skills apart from evade.
----------
Dirge *Lanet's Excruciating Scream* Does no damage.
Dirge *Tarven's Crippling Crescendo* Crashes server. (no error)
----------
Ranger *Rear Shot* Wont trigger when flanking or behind.
Ranger *Snipe* Crashes server. (no error)
Ranger *Natural Selection* Does no damage / no targets in range.
----------
Assassin *Cunning Defense* Partial stat change.
Assassin *Torture* Crashes server. (no error)
----------
Guardian *Battle Cry* No stat change.
Guardian *Assault* Does no damage.
----------
Berserker wont "learn" any new ability's other than heroic op.
----------
Monk *Crouching Tiger* Partial stat change.
Monk *Mend* Heals 6-8. Needs to be Heals 6-8%.
----------
Bruiser *Bodyguard* Partial stat change.
Bruiser *Bob and Weave* Partial stat change.
Bruiser *Brutality* Partial stat change.
----------
Shadowknight *Lucan's Pact* Partial stat change.
Shadowknight *Unholy Strength* Partial stat change.
Shadowknight *Blasphemy* Crashes server. (no error)
----------
Paladin *Knight's Stance* Partial stat change.
----------
Templar *Holy Armor* No stat change.
Templar *Aegolism* Partial stat change.
----------
Inquisitor Starts with no skills. [Combat][Spellcasting][Avoidance]
Inquisitor *Sacred Armor* Partial stat change.
Inquisitor *Forced Obedience* Crashes server. (no error)
----------
Warden *Favor of the Wild* Partial stat change.
Warden *Warden of the Forest* Partial stat change.
Warden *Thorncoat* Damages player in turn triggering another thorncoat attack in turn triggering....you guessed it.
Warden "Armor of Seasons II" not in DB.
----------
Channeler Unable to log into world. Kicks back to char select or freezes game. (no error)
----------
Fury *Master of the Hunt* No stat change.
Fury *Death Swarm* Crashes server. (no error)
Fury *Peerless Predator* No visual change. [Lion]
----------
Mystic *Runic Armor* Partial stat change.
Mystic *Ursine Avatar* No visual change. [Bear]
Mystic *Velium Winds* Does no damage.
Mystic Ward's don't work.
----------
Defiler *Harbinger* Partial stat change.
Defiler Ward's don't work.
Defiler Cant re-equip starting speer.
----------

[EDIT] all server crashing spells and arts should be disabled now. If anyone finds more deactivate them or write there name here
End of Line.

[Jabantiz]

Thanks for testing the spells we have, will look into the issues you reported. The Class required = 0 might just be some debug info I left in when adding some features so probably means nothing.

Coercer *Mesmerize II* (lv12) doesn't have *Mesmerize* (lv2) before it.

Sadly this matches live. For some reason several low level utility spells are no longer given to the player upon leveling on live (can still get books for them though), not even data for the apprentice level, so we don't have them either. You should notice the same issue with taunt spells for fighters.

As for berserkers, they have no spells done, that was an over sight on my part as I thought we had finished them all.

As for the rest I will look into them when I get the time, again thanks for testing these and keep the bug reports coming.

[Dello0000]

Thanks for testing the spells we have, will look into the issues you reported.

I'm going through all the classes getting dem nice buffs lol, thought seeing as i would be largely soloing/duo'ing the game i/we would be underpowered, so adding buffs from all the classes would even that out. use the group ones in dungeons and raid buffs in raid zones. So this list is just a by-product of that. lucky you! haha

Coercer *Mesmerize II* (lv12) doesn't have *Mesmerize* (lv2) before it.

Sadly this matches live. For some reason several low level utility spells are no longer given to the player upon leveling on live (can still get books for them though), not even data for the apprentice level, so we don't have them either. You should notice the same issue with taunt spells for fighters.

Oh, Id hate to be an illusionist now lol, no "pet" until level 10! Ahh well i was sourcing some of the odd ones like 2's before 1's from all the old EQ2 sites, wonder why they took them out

As for berserkers, they have no spells done, that was an over sight on my part as I thought we had finished them all.

I was going to go a zerker aswell! or should i say i will be going a zerker with about 100 extra spells (Once the emu is maybe into beta) but atm I'm just going to test whats there with any old crap haha. naked level 1000 monk with a 10,000 dmg sucker punch :p

As for the rest I will look into them when I get the time, again thanks for testing these and keep the bug reports coming.

I'd say it was fun testing all 26 classes, but i would be lieing hahaha. Still, if i can help in any way then its a plus. (ill do the priest classes tomorrow.)

[Dello0000]

First off ill say I'm shite at coding and wouldn't even know where to start, but i was looking through the DB and seen the "cast_while_moving" parameter and wondered if you would like someone to change the combat ability's that can be cast while moving to reflect live?

Its a tedious job but iv got some time on my hands and would love to lend a hand.

[John Adams]

I have no problem adding you to our DB Editor app so you can make changes to spells as you encounter them. It requires no coding experience, just simple data entry. Simple, but tedious as you say. We do not accept SQL query updates, due to the nature of our database, auto-patching and SVN submissions... but all work done through the DB Editor is acceptable.

Let me know if this works for you.

[Dello0000]

We do not accept SQL query updates

To be honest i haven't used navicat in a very long time and don't know much about query's. That being said if i can see the db and edit it then that's fine by me.

Let me know if this works for you.

I haven't played EQ2 in years so I'm not sure exactly how much has changed, but i can always research spells and arts from the wiki if need be. It does seem like youz have the base info and code down for spells and arts but some need tweaked, which id be happy to do in order to save you lot some time.

So yeah, that's fine by me just pm me any info ill need to know and ill get started asap.

[Jabantiz]

[CRASHERS]
Necro - *Howl of the Damned* crashes server. [Class required = 0 (needs to be 30)]
Necro - *Grisly Protection* crashes server. [Class required = 0 (needs to be 30)]
Necro - *Bloody Ritual* crashes server. [Found LUA Spell Script: 'Spells/Mage/Summoner/Necromancer/BloodyRitual.Lua' *When cast* - Player: (name) earned 2331 experience.]

Conjuror - *Defensive Haven* crashes server. [Class required = 0 (needs to be 29)]
Conjuror - *Antagonize* crashes server. [Class required = 0 (needs to be 29)]

Coercer - charmed monster dies. crashes server. [Error running Spells/Mage/Enchanter/Coercer/Charm.lua:24: attempt to compare number with nil]

Swashbuckler *Double-Cross* crashes server. [Class_req = 0 (needs to be 33)]

Warden *Armor of Seasons* crashes server. [class required = 0] [class required = 1074791424] [(needs to be 16)]

Mystic *Haze* Crashes server. [Class_req = 0 (needs to be 19)]

All the ones I striked out had a skill buff, which should now all be fixed with the fix I did for skill buff on an entity without that skill.

Armor of Seasons does not crash on my local server, and haven't checked the other ones yet.

Also got rid of the class required = blah stuff.

[Dello0000]

[CRASHERS]
Necro - *Howl of the Damned* crashes server. [Class required = 0 (needs to be 30)]
Necro - *Grisly Protection* crashes server. [Class required = 0 (needs to be 30)]
Necro - *Bloody Ritual* crashes server. [Found LUA Spell Script: 'Spells/Mage/Summoner/Necromancer/BloodyRitual.Lua' *When cast* - Player: (name) earned 2331 experience.]

Conjuror - *Defensive Haven* crashes server. [Class required = 0 (needs to be 29)]
Conjuror - *Antagonize* crashes server. [Class required = 0 (needs to be 29)]

Coercer - charmed monster dies. crashes server. [Error running Spells/Mage/Enchanter/Coercer/Charm.lua:24: attempt to compare number with nil]

Swashbuckler *Double-Cross* crashes server. [Class_req = 0 (needs to be 33)]

Warden *Armor of Seasons* crashes server. [class required = 0] [class required = 1074791424] [(needs to be 16)]

Mystic *Haze* Crashes server. [Class_req = 0 (needs to be 19)]

All the ones I striked out had a skill buff, which should now all be fixed with the fix I did for skill buff on an entity without that skill.

Armor of Seasons does not crash on my local server, and haven't checked the other ones yet.

Also got rid of the class required = blah stuff.

Nice one! I haven't made a start on any priest, mage or scout classes yet tho, i did go and disable the skills that were problematic tho.
The Guardian skills are about finished tho. Needs Daze, Stun, Knock back, mitigation and some casting skills implemented before the rest can be added.
Of course there's the crazy buffs that are just way to complex for me to even attempt to script with my limited knowledge so those will need your experts touch.