Raised This Month: $ Target: $400
 0% 

[Counter strike Source]Players duplicates again after update


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
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
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 12:45.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode