Quote:
Originally Posted by musosoft
Try
PHP Code:
CREATE TABLE hlstats_PlayerUniqueIds_copy LIKE hlstats_PlayerUniqueIds
INSERT hlstats_PlayerUniqueIds_copy SELECT * FROM hlstats_PlayerUniqueIds
DELETE FROM hlstats_PlayerUniqueIds WHERE game = 'css' AND INSTR(uniqueId, 'U') > 0
UPDATE hlstats_PlayerUniqueIds SET uniqueId=CONCAT('[U:1:', SUBSTR(uniqueId, 1, 1)+SUBSTR(uniqueId, 3)*2, ']') WHERE game = 'css'
|
Thanks
This code have a syntax error
if I take each line individually I always get at least one error message.
it shows effect, but only for players that are already deposited with the v3 ID in the database.
I hope there is
__________________