New Format Steam ID's

[Turiontje]

First of all, I've managed to completely setup a srcds server and it's working though I have this strange issue where all of my clients including myself get this new format with Steam ID's though I haven't seen this anywhere before.

I'm changing from providers to get a home hosted server up and running only I'm not sure if I missed a config file or forgot to set something up.

My test list to compare:
If I open up my console and type the command "status" I can see all the connected clients their steamid's. The format as described in the valve developer documentation (see: https://developer.valvesoftware.com/wiki/SteamID)
Result row from the status command telling my SteamID
# 90 "Turion" STEAM_0:0:37469898 00:49 45 0 active

So I go up to my newly installed server do the same thing and type status I will get the following:
# 17 "Turion" [U:1:74939796] 00:24 37 0 active

Which is completely different. I've been messing around and google the web around for hours what this could be. I even tried going to some other servers. Some showing the old steam ID format and others showing the newest one which confused me.

My question therefore is. What could be causing this problem and could it be solved?

(I'm also not sure if I should be posting it here or make a post on the steam forums or even make a steam support ticket)

Some information for comparing purposes perhaps

BASIC INFO
Server OS: Windows 7-64bit
Processor: Virtualized CPU 3-core (Host = AMD Phenom II X4 2.9Ghz)
Ram: 6GB Ram
Game(s): Team Fortress 2
Start Up Command: -console -game tf +map dm_duel_mgc +maxplayers 19 +sv_pure 1 -port 27015 -tickrate 100 +exec duel_server_init.cfg -replay
Admin Mods: Sourcemod, Metamod (Though without these mods the problem still exists)

INSTALLING INFO
Using SteamCMD
Using an automated script to update frequently, though it generates this script both for installing and executing:
"login anonymous
force_install_dir C:\Data\GameManager\games\tf2_dm_duel_mgc\
app_update 232250 validate
quit"


NETWORK AND BANDWIDTH INFO

Bandwidth: 500/500MBit connection (Reaching 400/300 regularly)
Router: 1 Switch -> FritzBox modem
Local IP of Server: 192.168.178.10
External IP: 80.100.140.205
Port Forwarding Screen Shot:
27000-27050 UDP And TCP
Typical Home Network: Server -> Switch -> Modem -> Internet (Everything till the modem is Gigabit Ethernet wired and the hardware supports it)

[LetsFrag]

This has been coming for a long time, this has been reported for TF2 servers, this is going to stay and if you are trying to use sourcemod with the server right now, well it won't work because now it needs a update.

Here is the forumula to the new id:

Code:

OLD: STEAM_0:X:Y
NEW: [U:1:Z]

Where Z is do the following:
Y(2)+X

Note: You still have a steam id as well.

[Turiontje]

(08-25-2014, 01:18 AM)LetsFrag Wrote:  This has been coming for a long time, this has been reported for TF2 servers, this is going to stay and if you are trying to use sourcemod with the server right now, well it won't work because now it needs a update.

Here is the forumula to the new id:

Code:

OLD: STEAM_0:X:Y
NEW: [U:1:Z]

Where Z is do the following:
Y(2)+X

Note: You still have a steam id as well.

Yeah, but I couldn't find any related topic to this cause nor any commands. Even google didn't come up with hits with the new steam id format. Or how to deal with them in anyway. Of course running a server configuration with MySQL database as storage broke a couple of features on the server

Because it might be a permanent change I've made a solution for me to fix all database issues.

Made a test query to run on a database to check if the new stuff is valid (Used this on a 6000 rows ranking table)

Code:

SELECT SteamID, IF(LEFT(STEAMID,9) = "STEAM_0:0",CONCAT('[U:1:',REPLACE(STEAMID,'STEAM_0:0:','')*2,']'),CONCAT('[U:1:',REPLACE(STEAMID,'STEAM_0:1:','')*2+1,']')  ) as newSteamId
FROM player
WHERE steamid LIKE "STEAM_%";

Of course that's just a test query to see if the results are correct

Code:

UPDATE Player
Set SteamID = IF(LEFT(STEAMID,9) = "STEAM_0:0",CONCAT('[U:1:',REPLACE(STEAMID,'STEAM_0:0:','')*2,']'),CONCAT('[U:1:',REPLACE(STEAMID,'STEAM_0:1:','')*2+1,']')  )
WHERE steamid LIKE "STEAM_%";

Changed the query so I could apply it on sourcemod stuff too etc.

It's a messy query but it really works as quick fix.

Thanks for pointing it out as well