I noticed the issue as i was getting dupes in psychostats so there's an issue there too i imagine. I hadnt noticed this before so i assumed it was only a problem since the 2nd most recent update, but the nature of the issue suggests its been happening longer than that.
Thanks for the Query Chris, ill post it up on the sourcemod forum for the plugin. Apologies to all affected by this bug On Thu, Feb 19, 2009 at 9:00 AM, Chris Oryschak <[email protected]> wrote: > Oh and i'm assuming if you are running connect announce you were > probably running HLStatsX: CE so you will need to cleanup your DB. > > You will want to find the last "wrong" record that was recorded in your > db and delete everything past that that has a uniqueID with a char count > of 16. Here is my sql query: > > DELETE FROM `hlstats_PlayerUniqueIds` > WHERE (char_length( uniqueId ) =16 AND `playerId` >=30653) > > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Chris Oryschak > Sent: Wednesday, February 18, 2009 3:59 PM > To: Half-Life dedicated Win32 server mailing list > Subject: Re: [hlds] Sliced Steam IDs after yesterdays update > > Connect Announce > http://forums.alliedmods.net/showthread.php?t=77306 > > > ________________________________ > > From: [email protected] on behalf of Cc2iscooL > Sent: Wed 2/18/2009 2:31 PM > To: Half-Life dedicated Win32 server mailing list > Subject: Re: [hlds] Sliced Steam IDs after yesterdays update > > > > What plugin was it, or was it a private plugin? > > On Wed, Feb 18, 2009 at 2:32 AM, Arg! <[email protected]> wrote: > > > Ah yes, i found the plugin that was causing this. > > > > On Wed, Feb 18, 2009 at 7:19 PM, Ronny Schedel <[email protected] > > >wrote: > > > > > > > > I can't confirm this. DODS and TF2 logs seems to be fine, no sliced > > > SteamIDs. Try without any plugins. > > > > > > > > > > All, > > > > > > > > After yesterdays update i noticed i had some people with duplicate > > > entires > > > > in psychostats, i had a look at the log files and found entries > > > > like > > > this: > > > > > > > > L 02/18/2009 - 11:42:21: "oritsuro<4><STEAM_0:1:21944><>" > > > > connected, address "xxx.xxx.xxx.xxx:xxxx" > > > > L 02/18/2009 - 11:42:22: "oritsuro<4><STEAM_0:1:21944994><>" STEAM > > USERID > > > > validated > > > > > > > > and > > > > > > > > L 02/18/2009 - 11:50:48: "TL. Scratchy<6><STEAM_0:1:16101><>" > > connected, > > > > address "yyy.yyy.yyy.yyy:yyyy" > > > > L 02/18/2009 - 11:50:48: "TL. Scratchy<6><STEAM_0:1:16101845><>" > > > > STEAM USERID validated > > > > > > > > Has anyone else noticed something like this where steam id's are > > > > being > > > cut > > > > off on the connect event but showed in full on the validated > event? > > > > _______________________________________________ > > > > To unsubscribe, edit your list preferences, or view the list > > > > archives, please visit: > > > > http://list.valvesoftware.com/mailman/listinfo/hlds > > > > > > > > > > > > > _______________________________________________ > > > To unsubscribe, edit your list preferences, or view the list > > > archives, please visit: > > > http://list.valvesoftware.com/mailman/listinfo/hlds > > > > > _______________________________________________ > > To unsubscribe, edit your list preferences, or view the list archives, > > > please visit: > > http://list.valvesoftware.com/mailman/listinfo/hlds > > > _______________________________________________ > To unsubscribe, edit your list preferences, or view the list archives, > please visit: > http://list.valvesoftware.com/mailman/listinfo/hlds > > > > _______________________________________________ > To unsubscribe, edit your list preferences, or view the list archives, > please visit: > http://list.valvesoftware.com/mailman/listinfo/hlds > _______________________________________________ To unsubscribe, edit your list preferences, or view the list archives, please visit: http://list.valvesoftware.com/mailman/listinfo/hlds
