Code:
Mangos 9843 - 9891
Restore need seelction show at loot roll.

Also some clanups including merge 2 roll type enum.
Fix some whitespace errors.
Fix dispel damage for 30108 and ranks
Restore work of 44745 and rank/s
 Add dummy effect of spell 50546, 50547 and 50548
Add script effect of spell 47393, 47615 and 47638
Implement character database clean up.

This can be disabled by config option.

Flag for clean up can be set for example on client version change.
Fixed target selection for area spells casted from aura at enemy.

* Spell::GetCastingObject must be use for selection visual/point cast,
  not for friend/enemy checks. Add extanded GetAffectiveCasterObject
  for proper provide for referecned checks wild gameobject casted case.

* Also support chain damage spells casted by gameobjects.
Restore work of 1856 and ranks
Disable forced alteration of specialFlags in quest_template at startup.

This will allow quest 10162 to work properly with the expected data in 
quest_template (no specialFlags is needed), but will still give a startup error 
for spell 33824.
Add dummy effect of spell 61832
Fix negative amounts for spell base damage/healing and fix heal effects 
to correctly benefit from heal increasing/reducing auras
Fix some sqls from prev. commit
Add dummy effect of spell 51840
Fix double damage dealing of 63625 and ranks. Thanks to Revils
Restore work of 1064 and ranks, broken in [9854]
Add dummy effect of spell 51964
Add script effect of spell 54182
Backporting some code chnages from 400 branch.

(based on 400's commit 0f37423)
(based on 400's commit 636cfef)
(based on 400's commit 0bbe3a7)
(based on 400's commit ce86b56)
(based on 400's commit b74c6a8)
Defines for some spelentry arrays.

* Move and rename MAX_REAGENTS to DBC Strcuture.h.
  It used only afore access to SpellEntry field and so part of strcuture 
  definition.
* Add MAX_SPELL_TOTEMS and MAX_SPELL_TOTEM_CATEGORIES for same reasons, and use 
in code.
Implement SPELL_EFFECT_BREAK_PLAYER_TARGETING (93)
Use proper arg for player name send.
Add support split damage for spells 66765, 67333.
Also small cleanup in mangos_spell_check.sql
More weapon damage split spells.
Prevent another potion drink until combat end.
Impliment glyph 42905.
Extend SCRIPT_COMMAND_QUEST_EXPLORED to allow player<->player as 
source/target

Additional code cleanup and output script id in error messages.
Add script id to all remaining SCRIPT_COMMAND_* error message outputs.

Note that script id can be id from different DB tables. It will however make it 
easier to find the source of any error.
More code cleanup and style corrections.
Implement movement impairing effects for spell 58875.
Replaced hardcoded value with enum.
Added some comments.
Drop outdated code for 18788
Fix auras with custom periodic damage not entering spell/melee bonus 
damage done methods
Fix immunity ignoring for delayed spells
Fixed TARGET_ALL_FRIENDLY_UNITS_AROUND_CASTER work

TARGET_ALL_FRIENDLY_UNITS_AROUND_CASTER expected seelction friendly targets
for spell caster around spell caster (so ignore original caster faction).
This meaning that for begative spell also selected friendly targets for
spell caster object.
One more meteor-like spell.
Set for client battleground weekend event world state.
Update battleground weekend world state at start/stop event.
Prepare world state inint packet data in more clean way.

* Avoid use hardcoded field amount values
* Avoid use world state update packets just after world state init packet
* Attempt make code look less horrible in general.
Add additional fields to *_scripts tables for storage of more data.

Currently not in use by any SCRIPT_COMMAND_* but we have secret plans to be 
revealed in the future!
Add support for mounts dependent from riding skill and location
Change SCRIPT_COMMAND_TALK to support CHAT_TYPE_* using enum ChatType

Making data consistent with other, similar tables like EventAI's text tables.
This convert existing data and also adds support for all chat types.
Code style fixes thx to hunuza & Wowka321
Added VS2010 projects for maps extractor.

(based on commit 211997d)
Implement new commands for account search

* .lookup account email, .lookup account ip, .lookup account name
* For new commands and for .lookup player versions use first arg as part of 
email/ip/name search
* Use similar output format for player/account lists.
Fix special mounts using in Dalaran
Party restore IsKnowHowFlyIn and add area arg
Extend features available for SCRIPT_COMMAND_TALK

* Allow other than Creature to talk.
* Add "buddy-talk", using creature entry in datalong2 (the npc who will do the 
talk instead of the original source). Value in datalong3 is how far to look for 
the buddy.
* Add data_flags making it possible to have conversations between units, 
controlling who does the talking and to whom, including make player do the 
talking when player is not already the source.

Notes and details are added in the comments for SCRIPT_COMMAND_TALK
Add TYPEMASK_WORLDOBJECT to enum TypeMask

Check typemask and replace a few dynamic_cast with more simple casts.
Implement *_scripts for creature_movement

New field script_id in creature_movement can be filled for each waypoint point 
and run the corresponding script from creature_movement_scripts.
Script_id can be any value and several points/creatures can share the same 
script (with limits of course, such as script depending on location and other 
factors).

DB projects are advised to move current text, spells and emotes data in 
creature_movement fields as these fields are strictly no longer needed and may 
be fully removed in the future.

YTDB 322

+ All fixes from forum;
+ fix spawn;
+ quest scripts;
+ mob's gossip menues;
+ new templates from WDB
+ fix loot in Vault of Archavon (Full)
+ processed 187 caches (3.3.3a)