View Single Post
Scuzzy
Senior Member
Join Date: Oct 2007
Old 01-19-2008 , 21:42   Re: Convert STEAMID to Steam Community ID
Reply With Quote #29

BTW, for anyone interested in doing this strictly in mySQL, like a trigger to calculate this field when you create a player record... I found some issues getting mySQL to actually ADD the numbers together. I finally came up with this:

Code:
 
cast(mid(steam_id,9,1)  as unsigned) + cast('76561197960265728' as unsigned) + cast(mid(steam_id, 11,10)*2 as unsigned)
That did it appropriately. (but make sure you're not getting a false steam id, like "STEAM_ID_LAN")

Cheers,
Scuzzy
Scuzzy is offline