Mangos 10611 - 10636
Code:
Made some values const
Revert "[10611] Made some values const"

Reason: It makes no sense to make a local variable const.

This reverts commit 49e3184d69056738701bc15d9b7f982bf11d7bbc.
A bit of cleanup in ByteBuffer::hexlike
Replace ACE_ASSERT with MANGOS_ASSERT
Add script effect of spell 66741
Simplified trade distance checks, GROUP_UPDATE_FLAG_POSITION flag handling moved out of Map

note: need avoid Map::PlayerRelocation calls now and use Player::SetPosition instead
Fixed array access in SCRIPT_COMMAND_TALK loading check.
Properly update objects usable state at GM-mode on/off.
Clarify premade groups mode config option.

Also prevent mark group as premade with 0 time wait.
It's any way useless becase at next tick group moved to normal team mode.
Fixed MSG_MOVE_HEARTBEAT structure.

Thx Wojta for pointing.
Add new field RequiredClasses for quest_template

* SkillOrClass is converted to RequiredSkill (and then field can contain skill id only)
* Field ZoneOrSort has no longer a function in quest requirement, and RequiredClasses must be used instead where class limits are expected.

To restrict a quest to one class or more, use bitmask of class in RequiredClasses. RequiredSkill works like before.
Set respawn delay for BG creatures before set dead state.

This prevent save to DB wrong respawn time and unexpected in wrong event state spawn BG creatures.
Make .respawn work correctly with BG event spawns
Fix quests w/QuestFlags QUEST_FLAGS_AUTO_REWARDED
Implement SPELL_EFFECT_CLEAR_QUEST (139)
Fix bad bandate check.
Fix logic in FillRaidOrPartyManaPriorityTargets and FillRaidOrPartyHealthPriorityTargets
Use ObjectGuid for player's selection and unit's target
SQL update for prev. commit
Drop function GuidHigh2TypeId

Added ObjectGuid version Aura::GetCasterGuid()

But for prevent big problen with backporting AuraHolder
to mangos-0.12 in most cases still used old uint64 version
Aura::GetCasterGUID.

Recommended use new version where possible in clean way
as done for some cases in commit already.
Convert Set(Get)ChannelObjectGuid to ObjectGuid way.

Also fix typo in debug output for prev. commit.
Small code style cleanup in quest related functions
Small comment style fix in mangosd.conf
Correct behavior for completion of quest objectives.

Rename related function to SendQuestCompleteEvent for clarification of when it's expected to be used.
Include non-percent mana cost in EffectDestroyAllTotems mana return.

Also small speedup for no-return spells.
Convert many opcode handlers to ObjectGuid use.

Also re-enabled anticheating check for bank window open
base at .bank command access rights.
Ignore another map target for text emote.
Implement server side check combo points req. for spell cast.

Thanks to nos4r2zod for problem research.
YTDB 347
Code:
+ all fixes from forum
+ fix spawn
+ quest scripts
+ mob's gossip menus
+ new templates from WDB
+ update table "*_template" by WDB
+ data from sniffs (templates, spawn)
+ processed 220 caches (3.3.5a)