View Single Post
musosoft
Senior Member
Join Date: Dec 2008
Location: Thailand
Old 09-18-2015 , 11:41   Re: Players duplicates again after update
Reply With Quote #3

Try this:

1. SQL query

PHP Code:
CREATE TABLE IF NOT EXISTS hlstats_PlayerUniqueIds_copy LIKE hlstats_PlayerUniqueIds;
INSERT hlstats_PlayerUniqueIds_copy SELECT FROM hlstats_PlayerUniqueIds WHERE NOT EXISTS (SELECT FROM hlstats_PlayerUniqueIds_copy);
DELETE FROM hlstats_PlayerUniqueIds WHERE (game 'css' OR 'dods' OR 'hl2mp') AND INSTR(uniqueId'U') > 0;
UPDATE IGNORE hlstats_PlayerUniqueIds SET uniqueId=CONCAT('[U:1:'SUBSTR(uniqueId11)+SUBSTR(uniqueId3)*2']'WHERE (game 'css' OR 'dods' OR 'hl2mp'); 


2. hlstats.pl edit

Under getPlayerInfo replace lines containing $uniqueid with:

PHP Code:
$uniqueid =~ /^\[U:1:(\d+)\]/;
$uniqueid = $1
^^ borrowed from https://forums.alliedmods.net/showth...32#post2188432


Reported not working, hope someone can post proper solution. Currently only way I know is reinstalling HlstatsX
__________________
Making FiveM servers nowadays. Can help with CS:GO, CS:S, and other Source server stuff too, just PM me. Thanks

Last edited by musosoft; 09-19-2015 at 16:54.
musosoft is offline