[c2049] 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>
Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2050] 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>
Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.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]
[c2051] 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>
Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2052] 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>
Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.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>
Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2054] 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>
Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2055] Add new parameter 'expansion' to command 'account create'

(based on commit [12540] - 6796ff3)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2056] 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>
Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2057] 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>
Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2058] 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>
Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2059] 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>
Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2060] Fix backport mistake

Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2061] Fix crash due to bad compiler

Close cmangos/issues#259

Signed-off-by: Xfurry <xfurry@scriptdev2.com>
Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2062] EventAI - Add more developing error output

Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2063] FindOpenSSL.cmake already ships with CMake

No reason for us to ship it too. Also, we had an outdated version which
had not been used anyway, because we set the include path in such a way,
that the CMake delivered version is always found first.

Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2064] FindGit.cmake already ships with CMake

No reason for us to ship it too. Also, we had an outdated version which
had not been used anyway, because we set the include path in such a way,
that the CMake delivered version is always found first.

Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2065] EventAI - Ingame output of script state

With this the command .npc aiinfo will give more output about the current state.
Remark that this output is only given if the LogFilter for EventAIDev mode is disabled

Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>
[c2066] Get rid of bounding radius in GetNearPoint[2D] and ObjectPosSelector

This changes how ObjectPosSelector is used.
It changes the way how the functions Object::GetNearPoint and Object::GetNearPoint2d behave.

So you need to check all places where these functions are used if they are still used correctly.

Especially check your scripts!

Signed-off-by: Daniel S. Reichenbach <daniel@kogitoapp.com>