NomisCZ / hlstatsx-community-edition

HLstatsX Community Edition - PHP 7 and GeoIP2 supported
GNU General Public License v2.0
83 stars 50 forks source link

WIP: Rewrite HeatMaps #36

Closed NomisCZ closed 1 year ago

NomisCZ commented 5 years ago

Issue #30

siosios commented 4 years ago

the attached text file works but had to make modifications like removing ${DB_PREFIX} from some of the sql code, and removing LIMIT ' . KILL_LIMIT . ' from before the union. along with a couple other changes. all the other heat map files are identical to what are in the diffs above.

2020-03-15 17:09:17 IGNORE: Game: css, Map: cs_assault, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: cs_classified, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: cs_compound, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: cs_havana, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: cs_italy, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: cs_italy_reloaded_final, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: cs_meatlight, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: cs_militia, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: cs_occupation, Kills: 0, (to few kills) 2020-03-15 17:09:17 CACHE: Found cached file (cs_office_1584291373.png), we will use timestamp 1584291373 instead 2020-03-15 17:09:17 IGNORE: Game: css, Map: cs_office, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: cs_office07, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: de_alberta, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: de_alivemetal, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: de_asia, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: de_aztec, Kills: 0, (to few kills) 2020-03-15 17:09:17 IGNORE: Game: css, Map: de_boston, Kills: 0, (to few kills)

these errors were showing up with out creating a heatmap before the changes along with some others.

PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /var/www/html/hlstats/heatmap.class.php on line 721 2020-03-15 17:08:25 IGNORE: Game: css, Map: fy_twotowers2009, Kills: , (to few kills) PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /var/www/html/hlstats/heatmap.class.php on line 721 2020-03-15 17:08:25 IGNORE: Game: css, Map: fy_twotowers32, Kills: , (to few kills) 2020-03-15 17:08:25 CREATE: Heatmap creation done.

heatmap.class.txt