Raised This Month: $ Target: $400
 0% 

[Counter strike Source]Players duplicates again after update


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
stoneyschillhouse
Senior Member
Join Date: Nov 2012
Old 09-18-2015 , 15:15   Re: Players duplicates again after update
Reply With Quote #5

Quote:
Originally Posted by musosoft View Post
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(uniqueId11)+SUBSTR(uniqueId3)*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
__________________
SRY FOR MY BAD ENGLISH
I'm german
stoneyschillhouse is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 12:44.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode