[KingPovilas]

Hi , after css update players started to duplicate again,can anyone provide some info how to fix it?

Thanks

[micazoid]

Can confirm this. Player one has STEAM_0:0:28257275 and duplicate player has STEAM_0:[U:1:56514550]

[musosoft]

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(uniqueId, 1, 1)+SUBSTR(uniqueId, 3)*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

[KingPovilas]

Ill try this tomorrow,but maybe someone has actual info,if our steam id in counter strike source gonna stay as they are now,starting with U or they will be swapped back as it was before?

[stoneyschillhouse]

Originally Posted by musosoft Try PHP Code: CREATE TABLE hlstats_PlayerUniqueIds_copy LIKE hlstats_PlayerUniqueIds INSERT hlstats_PlayerUniqueIds_copy SELECT * FROM hlstats_PlayerUniqueIds DELETE FROM hlstats_PlayerUniqueIds WHERE game = 'css' AND INSTR(uniqueId, 'U') > 0 UPDATE hlstats_PlayerUniqueIds SET uniqueId=CONCAT('[U:1:', SUBSTR(uniqueId, 1, 1)+SUBSTR(uniqueId, 3)*2, ']') WHERE game = 'css'

Thanks
This code have a syntax error

if I take each line individually I always get at least one error message.

it shows effect, but only for players that are already deposited with the v3 ID in the database.

I hope there is

[musosoft]

edited post above thank you! kindly share errors if any

[micazoid]

Will your solution make use of old data or is every player considered as new player musoft?

Another Question:

WHERE game = 'css';

will this just be good for css game? I have dods? Do I have to change that?

Got an error here:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT hlstats_PlayerUniqueIds_copy SELECT * FROM hlstats_PlayerUniqueIds
DELET' at line 2

[musosoft]

This solution will convert old SteamID32 to new Steam3ID,

there might be some problems with superlogs which will still log old SteamID32 format, I recommend to disable this plugin until it's updated to Steam3ID

I updated statement to track dods and hl2mp also

Regarding that error... Start from third line, as it seems that you have already backup (_copy) created...

[Fragenstein]

Originally Posted by musosoft This solution will convert old SteamID32 to new Steam3ID, there might be some problems with superlogs which will still log old SteamID32 format, I recommend to disable this plugin until it's updated to Steam3ID I updated statement to track dods and hl2mp also Regarding that error... Start from third line, as it seems that you have already backup (_copy) created...

superlogs hasn't been updated since 2010, so I don't think that's going to happen. I'm having the same issue:

L 09/20/2015 - 19:21:22: "Coffee’ "Can Do"<99><STEAM_0:1:7818xxx><CT>" triggered "headshot"
L 09/20/2015 - 19:21:22: "Coffee’ "Can Do"<99><[U:1:15636xxx]><CT>" killed "Bob<158><BOT><TERRORIST>" with "glock" (headshot)

[Kahl_Drogo]

Hi All,

I think I solved and fixed problem with duplicate (STEAM3)

In superlogs-tf2.sp and loghelper.inc

I replaced all GetClientAuthString to new function GetClientAuthId(client, AuthId_Steam3, player_authid, sizeof(player_authid))

Let me know if also work for you