CREATE TABLE IF NOT EXISTS hlstats_PlayerUniqueIds_copy LIKE hlstats_PlayerUniqueIds;INSERT hlstats_PlayerUniqueIds_copy SELECT * FROM hlstats_PlayerUniqueIds WHERE NOT EXISTS (SELECT * FROM hlstats_PlayerUniqueIds_copy);DELETE FROM hlstats_PlayerUniqueIds WHERE (game = 'css' OR 'dods' OR 'hl2mp') AND INSTR(uniqueId, 'U') > 0;UPDATE IGNORE hlstats_PlayerUniqueIds SET uniqueId=CONCAT('[U:1:', SUBSTR(uniqueId, 1, 1)+SUBSTR(uniqueId, 3)*2, ']') WHERE (game = 'css' OR 'dods' OR 'hl2mp');
$uniqueid =~ /^\[U:1:(\d+)\]/;$uniqueid = $1;