[s2042] Fix duplicate entry issue added in [s2034]

Signed-off-by: Xfurry <xfurry@scriptdev2.com>

(based on commit [12530] - f9573a0)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
[s2043] 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

(based on commit [12531] - 3a57de2)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
[s2044] Cody Style Improvements

Also remove an unused variable (thanks to Den for this!)

(based on commit [12532] - b1f227c)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
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]

(based on commit 2f8e7b1)
Sync mangos.sql with other versions

[ci skip]
[s2045] 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.

(based on commit [12536] - 51c5713)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
[s2046] Immediately remove corpses when ForcedDespawn is used

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

(based on commit [12537] - 4c3ff5c)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
[s2047] Implement some custom use for Effect Activate Object spells

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

(based on commit [12538] - 91268f6)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
[s2048] 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

(based on commit [12539] - 1167ecf)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
[s2049] Add new parameter 'expansion' to command 'account create'

(based on commit [12540] - 6796ff3)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
[s2050] Add CMake source groups to target 'shared'

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

(based on commit [12541] - 82b02fc)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
[s2051] Add CMake source groups to target 'framework'

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

(based on commit [12542] - bd2eb31)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
[s2052] 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.

(based on commit [12543] - 0088ce3)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
[s2053] 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.

(based on commit [12544] - d14ec5b)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
[s2054] Fix backport mistake