Merge pull request #120 from dsavineau/master

Fix missing comma introduced in commit 12522
[12530] Fix duplicate entry issue added in [12522]

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
[12531] Implement the spells used in the Chess Event encounter

Combat spell entries: 37775, 37824, 39338, 39342, 39341, 39344, 45260
Melee spells: 37142, 37143, 37147, 37149, 37150, 37220, 37227, 37228, 37337, 37339, 37345, 37348
Chess movement spells: 30012, 32312, 37388, 30284, 37144, 37146, 37148, 37151, 37152, 37153
Aura stacking exception: 32261 and 39400
[12532] Cody Style Improvements

Also remove an unused variable (thanks to Den for this!)
[12533] Fix load bar step for alendarMgr::LoadCalendarsFromDB

Signed-off-by: Schmoozerd <schmoozerd@cmangos.net>
[12534] Add missing spell 61437 to playercreate spells for bloodelves

Thanks to NeatElves for porting from TC and pointing to this

Signed-off-by: Schmoozerd <schmoozerd@cmangos.net>
[12535] Loot-System: Fix reference loading check

This fixes a false error output for loot references that are only used with spell loot.

Thanks to X-Savior for properly reporting both error messages and use case
[12536] Fix use of config values related to quest-status and level

This fixes use of negative value in config values Quests.LowLevelHideDiff and Quests.HighLevelHideDiff

Also add some documentation around the related code

Thanks to Neotmiren for pointing and to cala for testing.

Close cmangos/issues#223
[12537] Immediately remove corpses when ForcedDespawn is used

Thanks to Neotmiren for pointing, special thanks to cala for testing!

Close cmangos/issues#222
[12538] Implement some custom use for Effect Activate Object spells

This will fix the summoning events for the Wind Stones, Ice Stones, Skettis bosses and quest 11865

Close scriptdev2/scriptdev2#50
[12539] Update some Sunwell Plateau spells

Limit targets and allow positive effect for spell 46650
Implement effect for spells 46289 and 46637
Remove effect for spell 44845 - will be handled in script library
[12540] Add new parameter 'expansion' to command 'account create'

This fixes cmangos/issues#201
[12541] Add CMake source groups to target 'shared'

This is the exact same grouping as it is currently in the VC 2012 files.

This is part of cmangos/issues#67
[12542] Add CMake source groups to target 'framework'

This is the exact same grouping as it is currently in the VC 2012 files.

This is part of cmangos/issues#67
[12543] Add CMake source groups to target 'game'

This is the exact same grouping as it is currently in the VC 2012 files.
These groupings will have to be refactored at some point as they are not
very logical.

This is part of cmangos/issues#67
[12544] CMake: generic way to build a script library

Added new parameter INCLUDE_BINDINGS_DIR which can be set to the name of a
folder inside src/bindings/.

Includes the script library in src/bindings/ with the defined name.
The name must correspond to the name of the folder and the folder must contain
a valid CMakeLists.txt

Note: if you currently use a script library, you will probably get a merge
problem on src/bindings/CMakeLists.txt as you will have modified this file
manually. Please use the new version of this file and rerun CMake once with the
parameter -DINCLUDE_BINDINGS_DIR=ScriptDev2 (if you are not using SD2 but
another script library, replace ScriptDev2 with the name of the folder in
src/bindings/).

If you do not use a script library you should not have any merge problems
and you don't need to do anything.
Redump sql databases to unify formatting

The main reason for this was because classic has updated the sql formatting and manually syncing would be a pain so redumping from master->tbc->classic->cata is easier.

Only the formatting was changed. The values were not changed at all.

mysqldump was used however manual modifications had to be done.

Dump the database:
C:/mysql/bin/mysqldump.exe mangos > sql/mangos.sql

Split insert values into multiple rows:
Replace "),(" with "),\n("
Replace "VALUES (" with "VALUES\n("

Remove the character sets by replacing them with an empty string


Custom formatting of mangos.sql:
Move db_version to the very top
Create all dbscripts_on_* tables based on dbscripts_on_creature_movement
Preserve our custom insert formatting of spell_affect (tbc/classic), spell_bonus_data, spell_chain, spell_elixir, spell_proc_event, spell_proc_item_enchant, spell_template, spell_threat
Remove autoincrement values from insert values of pet_name_generation and remove AUTO_INCREMENT=261 value from its table structure

Custom formatting of characters.sql:
Move character_db_version to the very top

Custom formatting of realmd.sql:
Move realmd_db_version to the very top

[ci skip]
Sync mangos.sql with other versions

[ci skip]
[12545] Implement spells 61187 and 61190
[12546] Implement some spells for Ignis the Furnace Master

Spell entries: 62717, 62381, 62488, 62707, 64475 and 64503