[11950] Implement spell 27819, thanks to stfx for research

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11951] Unify loot related code and fix engrish.

Also readd the m_groupLootId check in case the StopGroupLoot will be called from other places

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11952] Add support to send the anim for SMSG_TAMEOBJECT_CUSTOM_ANIM

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11953] Add missing nightelf player-create spell 21009 for druid and DK

Thanks to crackm for providing data

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11954] Do not calculate targets for different effects with same targeting multiple times

Some effects or target-combinations might need exception from the generic rule that calculated targets from one effect are used by other effects with same targets.
This will fix bugs that different random targets for different effects are selected, even when they should be the same.

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11955] Remove .hover command

You can use .cast 11010 and .unaura 11010 instead

Thanks to stfx for improving patch and porting it for us :)

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11956] Implement spells 28374, 54426 and 71123 (Decimate)

Thanks to piroy1337 for version of ICC Decimate,
thanks to ZuSe for bumping the issue of missing implementation

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11957] Aura 10848 should not cause UNIT_AURAFLAG_ALIVE_INVISIBLE

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11958] Add support for no-fly-zone text message

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11959] Implement spell effect 131 - SPELL_EFFECT_PLAY_SOUND

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11960] Implement custom overwrite for range of some spell effects

Original idea and improved design for this by PSZ, who also implemented spells 66881 (with diffmodes)
Original patch for spells 28241, 54363 by Azerus
Also fix spell 24811

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11961] Fix logic bug in 11954. Should fix most spells of issue #44
[11962] Add support for Creature List of Entry in Range grid searcher

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11963] Add additional check for game_events, invalid occurence

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11964] Implement new conditions system

Tree-like design idea by Faramir118, thanks for that!

* Add `conditions` table to store conditions.
* REPLACE current handling of conditions for the *_loot_template tables
  Convert the old conditions in *_loot_template to the new system by SQL-Queries
* ADD support for new conditions to gossip_menu and gossip_menu_option.
  If for these tables no condition_id (new system) is provided, the old conditions will still be used
* Add a small helper python script to contrib/convertConditions, see README there for details
* Add new command to reload the `conditions` table (.reload conditions)
* Add two Meta-Condition types CONDITION_AND (-1) and CONDITION_OR (-2) which are used as:
  value1 (as condition_entry) AND / OR value2 (as condition_entry)

  With these meta-conditions it is possible to create tree like and very complicated combined conditions (like HasAura && (HasItem || HasQuest))

NOTE about conversion:
For easier convertion all the old table data is still preserved, but will be removed eventually (within a circle of the moon approximately)
The python script will not create an optimal initial fill of the `conditions` table. You might want to tweak it manually or suggest some optimized algorithm :)

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
[11965] Tweak comment about default config values
[11966] Replace an ASSERT to prevent unnecessairy crashes

GetAngle can be called for self from very many places, not only DB-errors, hence adding the assert is too strong in the moment

Signed-off-by: Schmoozerd <schmoozerd@scriptdev2.com>
Merge branch 'master' of git://github.com/mangos/mangos