Please be careful eveyone when updating the scripts with the above changes.
the charset is changed from utf8 to utf8mb4, which is great, but if you database isn't adjusted then you'll end up with errors such as:
Code:
DBD::mysql::st execute failed: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' at .//HLstats.plib line 185.
Unable to execute query:
SELECT
playerId
FROM
hlstats_PlayerNames
WHERE
playerId = 1180307
AND name ='{} '
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
__________________