Thread: Convert STEAMID to Steam Community ID
View Single Post
devicenull
Veteran Member
Join Date: Mar 2004
Location: CT
Old 02-25-2009 , 16:57   Re: Convert STEAMID to Steam Community ID
Reply With Quote #140
Quote:
Originally Posted by Gizmo View Post
Add this in the amxbans query and make a link of the steamid with the comid, i hope you know what i mean, im not to good in explaning, player_id is the field in amxbans for the steamid but i guess you already knew that

Code:
SELECT somefield, cast(mid(player_id,9,1)  as unsigned) + cast('76561197960265728' as unsigned) + cast(mid(player_id, 11,10)*2 as unsigned) AS comid, somefield FROM sometable
Why would yo do that when I just gave you a nice stored procedure to do it
__________________
Various bits of semi-useful code in a bunch of languages: http://code.devicenull.org/
devicenull is offline