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