[Ready for Testing] DB-Code Refactoring & Moncole-Alternate support

[123FLO321]

Description

Moved all queries to a new class. This allows easy support for different Scanners and even DB types. Currently RocketMap [MySQL] and the Monocle-Alternate [MySQL and PgSQL] fork are implemented. The DB Type can be set via in config.php. ["rocketmap", "monocle-alt-mysql" or "monocle-alt-pgsql"].

Run CreateStatsRocketMap.sql or CreateStatsMonocle.sql for counts to work.

Requires PR 27 Moncole-Alternate Recommended Settings for Moncole-Alternate:

KEEP_GYM_HISTORY = True
CLEANUP_SIGHTINGS_OLDER_THAN_X_HR = 168.0 (or higher | min: 24.0)
CLEANUP_FORT_SIGHTINGS_OLDER_THAN_X_HR = -1.0 (or 168.0 or higher)
CLEANUP_GYM_DEFENDERS_OLDER_THAN_X_HR = -1.0 (or 168.0 or higher)
RAIDERS_PER_GYM = 0.1 (target update interval of ~60s)

ToDo

• [ ] Test RocketMap
• [ ] Test Moncole-Alternate MySQL
• [ ] Test Moncole-Alternate PgSQL
• [x] Implement the Trainer-Page for Moncole-Alternate once it stores levels in the dB
• [x] Implement Gymhistory for Moncole-Alternate

Types of changes

• [X] Bug fix (non-breaking change which fixes an issue)
• [x] New feature (non-breaking change which adds functionality)
• [x] Breaking change (fix or feature that would cause existing functionality to change)

[javisabalete]

Tested with RocketMap and works as expected.

Requested small changes

[123FLO321]

fixed @michikrug

[Obihoernchen]

Now in #371