Raised This Month: $ Target: $400
 0% 

Fix SteamIDs for the new update


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
bottiger
AlliedModders Donor
Join Date: Dec 2010
Old 08-23-2014 , 16:56   Re: Fix SteamIDs for the new update
Reply With Quote #1

You can update hlstats to use the new format internally by running this SQL command

Code:
UPDATE hlstats_PlayerUniqueIds SET uniqueId=SUBSTR(uniqueId, 1, 1)+SUBSTR(uniqueId, 3)*2 WHERE uniqueId REGEXP('[01]:[0-9]+')
And replacing the $uniqueid in hlstats.pl sub getPlayerInfo with this.

Code:
                $uniqueid =~ /^\[U:1:(\d+)\]/;
                $uniqueid = $1;
There are few other cosmetic changes such as searching and player display which shouldn't be too difficult to figure out and I am sure the hlstats team will do.
__________________

Last edited by bottiger; 08-23-2014 at 16:58.
bottiger is offline
Sarabveer
Veteran Member
Join Date: Feb 2014
Old 01-17-2015 , 14:27   Re: Fix SteamIDs for the new update
Reply With Quote #2

Quote:
Originally Posted by bottiger View Post
I never used that random Steam3 fix provided by that other person which is probably why you have 2 entries per player as it allows your hlstats to receive both Steam2 and Steam3 ids. My fix only allows you to receive Steam3 and requires you to convert everything to Steam3 in the database which prevents all possible problems that you see now.

We also don't use the hlstats sourcemod plugin which is probably sending Steam2. You probably need to edit the plugin to correct this. Please don't ask me for help with this though because we are never going to use it.

Also I was about to answer you on IRC but you left.
I'm talking about this one.
Quote:
Originally Posted by bottiger View Post
You can update hlstats to use the new format internally by running this SQL command

Code:
UPDATE hlstats_PlayerUniqueIds SET uniqueId=SUBSTR(uniqueId, 1, 1)+SUBSTR(uniqueId, 3)*2 WHERE uniqueId REGEXP('[01]:[0-9]+')
And replacing the $uniqueid in hlstats.pl sub getPlayerInfo with this.

Code:
                $uniqueid =~ /^\[U:1:(\d+)\]/;
                $uniqueid = $1;
There are few other cosmetic changes such as searching and player display which shouldn't be too difficult to figure out and I am sure the hlstats team will do.
EDIT: After re-install, and removing the superlogs plugin. It's fixed!
__________________

Last edited by Sarabveer; 01-17-2015 at 15:05.
Sarabveer is offline
Horsedick
AlliedModders Donor
Join Date: Sep 2011
Old 02-24-2015 , 19:18   Re: Fix SteamIDs for the new update
Reply With Quote #3

Quote:
Originally Posted by Sarabveer View Post
I'm talking about this one.


EDIT: After re-install, and removing the superlogs plugin. It's fixed!

I do believe I have this same issue cept removing superlogs isn't something I can do mostly since I need superlogs to be present for HLSW to log properly so at this point I'm damned if I do and damned if I don't. Know of a fix that doesn't include removing superlogs to prevent the doubled up users in the DB?
Horsedick is offline
Sarabveer
Veteran Member
Join Date: Feb 2014
Old 02-25-2015 , 07:10   Re: Fix SteamIDs for the new update
Reply With Quote #4

Quote:
Originally Posted by Horsedick View Post
I do believe I have this same issue cept removing superlogs isn't something I can do mostly since I need superlogs to be present for HLSW to log properly so at this point I'm damned if I do and damned if I don't. Know of a fix that doesn't include removing superlogs to prevent the doubled up users in the DB?
Then modify superlogs to use Steam3
__________________
Sarabveer is offline
Horsedick
AlliedModders Donor
Join Date: Sep 2011
Old 02-25-2015 , 20:29   Re: Fix SteamIDs for the new update
Reply With Quote #5

Quote:
Originally Posted by Sarabveer View Post
Then modify superlogs to use Steam3
I have no idea where to start with that.. I did post about it giving out errors in its thread but I don't believe anyone has seen it yet.
Horsedick is offline
Reply



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:44.


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