Core/Spells: Fixed double heal reduction on Eart Shield (issue #4032).
[TW] Val'kyr Shadowguard

- Old hack for valkyr stun despawn
- Move Remove UNIT_FLAG_NOT_SELECTABLE to EVENT_MOVE_TO_DROP_POS  fix
teleport to edge (maybe)
- Get 2d distance and not 3d in EffectChargeDest
- Send target z posistion to GetFirstCollisionPosition and then
MovePositionToFirstCollision since they don't work in 3d space and
flying units just stay on the same z
Scripts/ScarletMonastery: rewritten InstanceScript and some bosses converted to BossAI and eventmap
Scripts/Ulduar: Spellscripts for Mimiron

Closes #12579

Signed-off-by: DDuarte <dnpd.dd@gmail.com>
Core/RBAC: Fix RBAC permissions

This commit adds three missing commands to the world.commands table. The RBAC.h file is updated to the correct IDs from the auth.rbac_permissions table and the world.commands table. The RBAC.h file also had to be reordered to keep it clean.

Closes #12854

Signed-off-by: DDuarte <dnpd.dd@gmail.com>
Rename 2014_08_14_02_world_command.sql to 2014_08_18_01_world_command.sql
Core/Creatures: Fixed an arithmetic error in respawn code

Creatures should now respawn correctly in their correct time.
Issue was caused by single-precision floating-point format losing precision on lower digits with high numbers, for reference http://docs.oracle.com/cd/E19957-01/806-3568/ncg_goldberg.html
Closes #12428
Core/Loot: Fixes lootable items being able to be moved in inventory, and
also loot generated that uses conditions from being saved to the DB.
Fixed tabs
Merge pull request #12875 from runningnak3d/master

Core/Loot: Fix lootable items so they can be moved in inventory, and also fix lootable items not saving items that fail conditions to the DB. Closes #10548
Core/SmartScripts: fix escort quest group-complete
Merge pull request #60 from ShinDarth/tw_fix_escort_quest_group_complete

Core/SmartScripts: fix escort quest group-complete
Merge pull request #43 from gecko32/Patch2

[TW] Val'kyr Shadowguard
[TW] Core/Spell: Rework SPELL_AURA_OBS_MOD_HEALTH

- Fixes spells where value = 1 eg.(Blood Craze, Glyph of Ghost Wolf)
when affected by auras with SPELL_AURA_MOD_HEALING_DONE_PERCENT
(Arena/Bg Dampening)
Merge pull request #61 from gecko32/patch7

[TW] Core/Spell: Rework SPELL_AURA_OBS_MOD_HEALTH
DB/Misc:Missing Emotes

Add missing emotes for Image of Loken and High Abbot Landgren for quest scripts,
Core/SmartScripts: fix escort quest group-complete
DB/Misc: Greetings texts for Dalaran Vendors

Only one not working is Tiffany Cartier even though sai is same as the rest and texts are added,

idk seems theres an invisible wall as unlike other vendors player cannot get behind counter where tiffany is either.
Improved 4faddb3ae49be8f5b2066ab99f55ffa4684b8e1c by adding check if player is not dead and check if player is near
DB/Gameevent: Brew of the Year

Adds vendors, events, sai for faction change, change of appearance depending on location (orgrimmar or iron forge), gossip and conditions

* To Do

* At start of each monthly event mail should be sent to players who are members with a sample of that months brew, this is not currently implemented.
* Possibly missing yells from vendors saying beer but cannot confirm this.