AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   HLstatsX:CE (https://forums.alliedmods.net/forumdisplay.php?f=156)
-   -   Fix SteamIDs for the new update (https://forums.alliedmods.net/showthread.php?t=246712)

Nikkii 08-21-2014 19:31

Fix SteamIDs for the new update
 
This will convert the new value to the old, allowing all of your current stats to be saved.

In scripts/HLstats_EventHandlers.plib, find
Code:

$owner =~ /.+?<STEAM_[0-9]+:([0-9]+:[0-9]+)>.*/;
Add this before it:
Code:

$owner =~ s!\[U:1:(\d+)\]!'STEAM_0:'.($1 % 2).':'.int($1 / 2)!eg;
In scripts/hlstats.pl, find
Code:

$uniqueid =~ s/^STEAM_[0-9]+?\://;
Add this before it:
Code:

$uniqueid =~ s!\[U:1:(\d+)\]!'STEAM_0:'.($1 % 2).':'.int($1 / 2)!eg;
In scripts/TRcon.pm, find
Code:

$uniqueid =~ s/^STEAM_[0-9]+?\://i;
Add this before or after it:
Code:

$uniqueid =~ s!\[U:1:(\d+)\]!($1 % 2).':'.int($1 / 2)!eg;

Jabra 08-21-2014 20:42

Re: Fix SteamIDs for the new update
 
Works like a charm. Thanks!

Horsedick 08-21-2014 22:30

Re: Fix SteamIDs for the new update
 
I'd try this but I'm sure they will release an update tomorrow or sometime this weekend.

Mavrick4283 08-22-2014 00:39

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by Horsedick (Post 2187492)
I'd try this but I'm sure they will release an update tomorrow or sometime this weekend.

No.... This is the new format....


We apologize for the lack of warning regarding the SteamID format change in today's update. It was our intent to give the community a heads-up before the change was released, but it was missed.

The change was made to update TF2 to use the current SteamID format, which most other games on Steam and Steam itself uses. You will find that you can now use SteamIDs rendered by these other locations in your interactions with the engine. The engine will still recognize the old format, though, so your current server ban lists should still be valid.

The conversion equation has already been posted by a community member, but here it is again:

Old: STEAM_0:A:B
New: [U:1:B*2+A]
Example: STEAM_0:1:1234 ---> [U:1:2469]

We're sorry for the problems this may cause while you update your scripts to use the new format. It was not our intent to disrupt your servers.

-Eric

ddhoward 08-22-2014 00:44

Re: Fix SteamIDs for the new update
 
The newest 1.6 SM snapshot has fixed this. Anyone who converted their admins' steam ids is out of luck. You should have waited for the SourceMod team to put out a fix.

KorDen 08-22-2014 05:13

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by ddhoward (Post 2187535)
The newest 1.6 SM snapshot has fixed this. Anyone who converted their admins' steam ids is out of luck. You should have waited for the SourceMod team to put out a fix.

SM fixes only internal SM functions, but not general logging and 'status' command


How about converting entire HLXCE databases to new format and use new IDs?

soja92 08-22-2014 06:55

Re: Fix SteamIDs for the new update
 
Thanks for this quick fix!

Now my TF2 servers have stats working again, and my other servers log properly too

Nikkii 08-22-2014 07:52

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by KorDen (Post 2187619)
SM fixes only internal SM functions, but not general logging and 'status' command


How about converting entire HLXCE databases to new format and use new IDs?

I was thinking about doing this, but the problem is players will lose their stats (unless you convert the ids over, could be 350,000+ rows) and there's a few parts that rely on STEAM_ in the php code.

This is more of a quick patch to just make it work.

Horsedick 08-22-2014 09:06

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by Mavrick4283 (Post 2187534)
No.... This is the new format....

I was talking about something from you guys - Hey any chance on helping me out with my other question I've been asking you about these last few weeks?

I know you are busy but I just need to figure out if this is doable in a easy manner or what needs to be done either way.

https://forums.alliedmods.net/showthread.php?t=244891

NeonHeights 08-22-2014 13:55

Re: Fix SteamIDs for the new update
 
This is awesome, thank you

Weasel 08-22-2014 21:09

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by Horsedick (Post 2187492)
I'd try this but I'm sure they will release an update tomorrow or sometime this weekend.

I am with you on that. I think I'll wait for few days to see if there is an update that includes some sort of fix before hacking-up existing code myself.

Phaiz 08-23-2014 09:09

Re: Fix SteamIDs for the new update
 
Is this supposed to change old steam IDs to the new ID?

C00ller 08-23-2014 10:31

Re: Fix SteamIDs for the new update
 
Another solution: update old SteamIDs to new format right in the database.

I wrote PHP-script to update old SteamIDs to new ones (in order to use that change $DB* vars accordingly) for TF2-related stats:

Code:

<?php

// RUN ONLY ONCE!!! Or restore from backup before any extra run!

$DBServ = "localhost";
$DBUser = "root";
$DBPass = "";
$DBName = "hlstats";
$DBTable = "hlstats_PlayerUniqueIds";

$db = mysql_connect($DBServ, $DBUser, $DBPass) or die("Can't connect to MySQL server");
mysql_select_db($DBName) or die("Can't select DB");

$now = time();

mysql_query("CREATE TABLE " . $DBTable . "_copy_" . $now . " LIKE $DBTable");
mysql_query("INSERT " . $DBTable . "_copy_" . $now . " SELECT * FROM $DBTable");

mysql_query("DELETE FROM $DBTable WHERE game = 'tf' AND INSTR(uniqueId, 'U') > 0");
mysql_query("UPDATE $DBTable SET uniqueId=CONCAT('[U:1:', SUBSTR(uniqueId, 1, 1)+SUBSTR(uniqueId, 3)*2, ']') WHERE game = 'tf'");

// Redundant code :)
/*
$players = mysql_query("SELECT * FROM $DBTable");
while($row = mysql_fetch_assoc($players))
{
    $id = $row["playerId"];
    $oldsteamid = $row["uniqueId"];

    $idparts = explode(':', $oldsteamid);
    $newsteamid = "[U:1:" . ($idparts[1] * 2 + $idparts[0]) . "]";
    mysql_query("UPDATE $DBTable SET game='$oldsteamid', uniqueId = '$newsteamid' WHERE playerId = $id");
}

mysql_free_result($players);
*/

mysql_close($db);

echo "Done";

Script does the backup copy of used table and deletes player records with new IDs (to prevent uniqueId duplicating after update).

Phaiz 08-23-2014 10:55

Re: Fix SteamIDs for the new update
 
I added the changes in the original post after I updated sourcemod. The hlstats daemon will not continue running now.

Code:

**:/**/scripts$ ./run_hlstats start

HLstatsX:CE daemon control
http://www.hlxce.com
---------------------------
Attempting to start HLstatsX:CE daemon on port 27500...
Daemon successfully started on port 27500
**:/**/scripts$ ./run_hlstats start

HLstatsX:CE daemon control
http://www.hlxce.com
---------------------------
Attempting to start HLstatsX:CE daemon on port 27500...
Daemon successfully started on port 27500

Those were back to back commands, it should have said it was already running on port 27500.

If I check the status,
Code:

**:/**/scripts$ ./run_hlstats status

HLstatsX:CE daemon control
http://www.hlxce.com
---------------------------
A stale process was found for daemon on port 27500.  It has been removed.


Weasel 08-23-2014 14:50

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by C00ller (Post 2188245)
Another solution: update old SteamIDs to new format right in the database.

I wrote PHP-script to update old SteamIDs to new ones (in order to use that change $DB* vars accordingly):

Spoiler

Script does the backup copy of used table and deletes player records with new IDs (to prevent uniqueId duplicating after update).

Eh... wait. We only want to update SteamID's in the hlstats_PlayerUniqueIds that are relevant to Team Fortress 2 - right? So, just those that match the value "tf" in the "game" field? - right? I have a bunch of other game-servers using the same HLStatsX:CE database - including both Source-engine games and mods as well as older GoldSrc-engine games and mods. I thought only TF2 was using the new Steam3 ID format so far?

C00ller 08-23-2014 15:37

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by Weasel (Post 2188386)
We only want to update SteamID's in the hlstats_PlayerUniqueIds that are relevant to Team Fortress 2 - right? So, just those that match the value "tf" in the "game" field? - right?


You're definitely right! I've made corrections to my original post, thanks for notice.


Quote:

Originally Posted by Weasel (Post 2188386)
I thought only TF2 was using the new Steam3 ID format so far?

I'm not sure. Thought the new format is Steam-related, not game.

bottiger 08-23-2014 16:56

Re: Fix SteamIDs for the new update
 
You can update hlstats to use the new format internally by running this SQL command

Code:

UPDATE hlstats_PlayerUniqueIds SET uniqueId=SUBSTR(uniqueId, 1, 1)+SUBSTR(uniqueId, 3)*2 WHERE uniqueId REGEXP('[01]:[0-9]+')
And replacing the $uniqueid in hlstats.pl sub getPlayerInfo with this.

Code:

                $uniqueid =~ /^\[U:1:(\d+)\]/;
                $uniqueid = $1;

There are few other cosmetic changes such as searching and player display which shouldn't be too difficult to figure out and I am sure the hlstats team will do.

Weasel 08-24-2014 23:36

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by C00ller (Post 2188403)
Regarding the script/query: You're definitely right! I've made corrections to my original post, thanks for notice.

Thanks! I ran that PHP script (with proper authentication parameters inserted in the required variables, etc.) and it updated all my TF2 users just fine - without interfering with players logged for other games in the same HLStats database. HLStats itself still has some cosmetic/display issues to deal with - hopefully to be fixed in a coming update, but otherwise seems to be running fine.

The cosmetic stuff is includes things such as the display of steam IDs incorrectly on-screen (with "Steam:0" prefixed - regardless of whether it is a Steam2 or Steam3 format ID in the database for that particular game), and linking to Steam profiles where the Steam ID in the database is updated to the Steam3 format.

Personally, I can live with the cosmetic stuff - until there is an "official" update to deal with that stuff - rather than hack it up myself.

Quote:

Originally Posted by C00ller (Post 2188403)
Regarding other games: I'm not sure. Thought the new format is Steam-related, not game.

I definitely do not see the Steam3 ID's showing-up in any other games that I happen to currently host (Fistful of Frags, CS:S, etc.). I seem to recall somebody saying there are some other games already using the new format prior to TF2? (maybe CS:GO? or DOTA?).

So, I would assume that eventually all Valve titles that are using some Source-engine variant will be converting to this new format, and eventually mods based on Source-engine will get forced over to it as well.

It wouldn't surprise me if Valve did the same thing for all Valve titles using the old GoldSrc-engine too - in which case AMX-Mod-X will likely need to be similarly patched to accommodate the change. At the moment, from what I see my GoldSrc-engine games (HL1, TFC, Counter-Strike, DMC, and some mods) are still using the old format.

Phaiz 08-25-2014 09:35

Re: Fix SteamIDs for the new update
 
I'm assuming that these "cosmetic" issues would include a players stats page not showing their avatar?

Weasel 08-25-2014 12:09

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by Phaiz (Post 2189233)
I'm assuming that these "cosmetic" issues would include a players stats page not showing their avatar?

Yes, it sure does.

kelvin31 08-27-2014 23:29

Re: Fix SteamIDs for the new update
 
can any body teach me....how to run that php script... I m not programmer.....thanks...

Sreaper 08-28-2014 00:08

Re: Fix SteamIDs for the new update
 
Just get Sourcemod snapshot 4558 and use the old steam ids.

C00ller 08-28-2014 02:56

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by Sreaper (Post 2190706)
Just get Sourcemod snapshot 4558 and use the old steam ids.

What about snapshop 4559, is it suitable?

Sreaper 08-28-2014 03:26

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by C00ller (Post 2190745)
What about snapshop 4559, is it suitable?

Probably, since others claim that it works for them.

Phaiz 08-28-2014 13:20

Re: Fix SteamIDs for the new update
 
I'm using 4559 and it works fine

bottiger 08-28-2014 18:50

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by Phaiz (Post 2189233)
I'm assuming that these "cosmetic" issues would include a players stats page not showing their avatar?

I didn't notice it was broken but to fix it just edit playerinfo_general.php and find the Player profile table and replace it with this.

PHP Code:

                                <tr class="data-table-head">
                                        <td style="vertical-align:top;">Player Profile<br /><br /></td>
                                        <td style="text-align:center; vertical-align:middle;" rowspan="7" id="player_avatar">
                                                <?php
                                                        $db
->query
                                                        
("
                                                                SELECT
                                                                        hlstats_PlayerUniqueIds.uniqueId,
                                                                        CONCAT('[U:1:',hlstats_PlayerUniqueIds.uniqueId,']') AS communityId
                                                                FROM
                                                                        hlstats_PlayerUniqueIds
                                                                WHERE
                                                                        hlstats_PlayerUniqueIds.playerId = '
$player'
                                                        "
);
                                                        list(
$uqid$coid) = $db->fetch_row();
                                                        
$pagedata file_get_contents("http://steamcommunity.com/profiles/$coid?xml=1");
                                                        
preg_match('/<onlineState>(.*?)<\/onlineState>/'$pagedata$results);
                                                        
preg_match('/<avatarFull><!\[CDATA\[(.*?)\]\]><\/avatarFull>/'$pagedata$results2);
                                                        
$status ucwords($results[1]);
                                                        
$avatar_full $results2[1];
                                                        
$avimg getImage("/avatars/$player");
                                                        if (
$avimg)
                                                        {
                                                                
$avatar_full $avimg['url'];
                                                        }
                                                        else if (
$avatar_full == '' || $playerdata['blockavatar'] == '1')
                                                        {
                                                                
$avatar_full IMAGE_PATH."/unknown.jpg";
                                                        }
                                                        if (
$status == '')
                                                                
$status '(Unknown)';
                                                        echo(
"<img src=\"$avatar_full\" style=\"height:158px;width:158px;\" alt=\"Steam Community Avatar\" />");
                                                
?>
                                        </td>
                                </tr>


Horsedick 08-30-2014 08:40

Re: Fix SteamIDs for the new update
 
I'm surprised the HLStats team hasn't released an update to this yet... I'm really not wanting to do patch work on something that is normally been supported well.

Mavrick4283 08-30-2014 16:34

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by Horsedick (Post 2191817)
I'm surprised the HLStats team hasn't released an update to this yet... I'm really not wanting to do patch work on something that is normally been supported well.

Let me be as blunt as I can, I work for a living......so I have not finished looking over these changes and what effected they will have IE does it cause older games like HL2MP to stop working ? or does it conflict with DOD?

Checking these things takes time, this has happened about a week ago...so I have not had a weekend yet to work on it.....

I did not plan for HLX to have any major changes to the current code so I don't know it very well (To be clear I know what it does as a whole but what parts do what function not so much); So if the changes in this thread conflict create bugs it will be even longer before you see a "release" fix...

Be happy that I am at least trying to keep this project alive, if you want to see it move faster // have more active support then the community is going to have to step up....This project does not pay the bills so my job comes first....

C00ller 08-31-2014 09:06

Re: Fix SteamIDs for the new update
 
About HLStatsX and SM snapshot (4559) with converting to the old IDs: is it enough to use snapshot for stats gets normal or the patch from the 1st post must be applied too?

I'm watching one server that use the SM from snapshot and stats is going crazy: every player has a clone, server list shows players twice, and some score goes to one player record (old ID), some to new one :) I wonder it's because of new IDs that left in the hlstats_PlayerUniqueIds table, or because of SM utilizing both ID formats...

Horsedick 08-31-2014 09:58

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by Mavrick4283 (Post 2191997)
Let me be as blunt as I can, I work for a living......so I have not finished looking over these changes and what effected they will have IE does it cause older games like HL2MP to stop working ? or does it conflict with DOD?

Checking these things takes time, this has happened about a week ago...so I have not had a weekend yet to work on it.....

I did not plan for HLX to have any major changes to the current code so I don't know it very well (To be clear I know what it does as a whole but what parts do what function not so much); So if the changes in this thread conflict create bugs it will be even longer before you see a "release" fix...

Be happy that I am at least trying to keep this project alive, if you want to see it move faster // have more active support then the community is going to have to step up....This project does not pay the bills so my job comes first....


Listen...I'll be blunt as well. I said TEAM - I'm unaware or was unaware it was only you working on it. You act as if I'm attacking you or the project and that is far from it. I understand all to well about a full time job coming first but don't sit here and react like this when this wasn't my intentions and I'm sure others didn't intend to come off that either. If you want help from the community then make a sticky post about it rather wait till someone inquires about a issue and you go off on them with whatever reasons you have.

I use this project and enjoy it...but speak up a little...if the support isn't there then that is fine but you gotta let people know so they can make decisions to do something else or wait.

Phaiz 09-01-2014 11:55

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by bottiger (Post 2191118)
I didn't notice it was broken but to fix it just edit playerinfo_general.php and find the Player profile table and replace it with this.

PHP Code:

                                <tr class="data-table-head">
                                        <td style="vertical-align:top;">Player Profile<br /><br /></td>
                                        <td style="text-align:center; vertical-align:middle;" rowspan="7" id="player_avatar">
                                                <?php
                                                        $db
->query
                                                        
("
                                                                SELECT
                                                                        hlstats_PlayerUniqueIds.uniqueId,
                                                                        CONCAT('[U:1:',hlstats_PlayerUniqueIds.uniqueId,']') AS communityId
                                                                FROM
                                                                        hlstats_PlayerUniqueIds
                                                                WHERE
                                                                        hlstats_PlayerUniqueIds.playerId = '
$player'
                                                        "
);
                                                        list(
$uqid$coid) = $db->fetch_row();
                                                        
$pagedata file_get_contents("http://steamcommunity.com/profiles/$coid?xml=1");
                                                        
preg_match('/<onlineState>(.*?)<\/onlineState>/'$pagedata$results);
                                                        
preg_match('/<avatarFull><!\[CDATA\[(.*?)\]\]><\/avatarFull>/'$pagedata$results2);
                                                        
$status ucwords($results[1]);
                                                        
$avatar_full $results2[1];
                                                        
$avimg getImage("/avatars/$player");
                                                        if (
$avimg)
                                                        {
                                                                
$avatar_full $avimg['url'];
                                                        }
                                                        else if (
$avatar_full == '' || $playerdata['blockavatar'] == '1')
                                                        {
                                                                
$avatar_full IMAGE_PATH."/unknown.jpg";
                                                        }
                                                        if (
$status == '')
                                                                
$status '(Unknown)';
                                                        echo(
"<img src=\"$avatar_full\" style=\"height:158px;width:158px;\" alt=\"Steam Community Avatar\" />");
                                                
?>
                                        </td>
                                </tr>


Thanks for that Bot, it fixed it!

Phaiz 09-01-2014 12:00

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by Horsedick (Post 2192228)
Listen...I'll be blunt as well. I said TEAM - I'm unaware or was unaware it was only you working on it. You act as if I'm attacking you or the project and that is far from it. I understand all to well about a full time job coming first but don't sit here and react like this when this wasn't my intentions and I'm sure others didn't intend to come off that either. If you want help from the community then make a sticky post about it rather wait till someone inquires about a issue and you go off on them with whatever reasons you have.

I use this project and enjoy it...but speak up a little...if the support isn't there then that is fine but you gotta let people know so they can make decisions to do something else or wait.

I have to fully agree with this. This is used on a LOT of communities which are mainly manned by someone like myself who has absolutely no idea how it works much less how to fix it. A lot of us are forced to either let it collect dust or trust that the code some stranger just posted won't break our whole server. In my opinion, the best route for hlstats is an official word on what is broken and/or how to fix x y or z. If it's needed I am sure there are those with enough experience who are able to lend a hand when they have the time.

bobdole 09-01-2014 13:52

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by Phaiz (Post 2192633)
I have to fully agree with this. This is used on a LOT of communities which are mainly manned by someone like myself who has absolutely no idea how it works much less how to fix it. A lot of us are forced to either let it collect dust or trust that the code some stranger just posted won't break our whole server. In my opinion, the best route for hlstats is an official word on what is broken and/or how to fix x y or z. If it's needed I am sure there are those with enough experience who are able to lend a hand when they have the time.

Strangely seeing as this project has its own subfourm its rather easy for users to post the problems they are having (o wait that already happening strange) rather than trying to get someone (who's already time and time again explained how busy he is) try to find each and every little thing that's wrong with a large project like this (which i'll make it easy for you the only main problems are anything related to steamIDs, which as i believe multiple quick patches have already been posted by helpfull people)

If its needed people will lend a hand? well first let me point out that Maverick only took over the project because the original team who worked on it moved on to other things and with life and HE didnt want it to die. As such i guess its something to point out (which should be obvious to anyone with knowledge enough to be able to help knows) the project is hosted on BitBucket meaning anyone who wants to help has complete ability to add to the project by cloning the project and making pull requests with their changes. Something that seeing as noone has done this, it seems that most people who is able to do something mealy doesn't care about this project.

bottiger 09-04-2014 01:32

Re: Fix SteamIDs for the new update
 
HLstats needs to be rewritten from the ground up. The code is not pretty or efficient, that's why no one is forking it.

I would rewrite it myself but I don't really have the time and I can't justify it given how poorly community servers are being treated by Valve now.

I've already provided the code you need to switch to the new SteamIDs though.

Weasel 09-05-2014 23:53

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by Phaiz (Post 2192631)
Thanks for that Bot, it fixed it!

Wait, will that make it assume all SteamID's for all game-servers logging to that instance of HLStatsX:CE are using the new Steam3 format? I have several different games (mixture of Source-based and GoldSrc-based at that) all using the same system.

Phaiz 09-08-2014 11:21

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by Weasel (Post 2194419)
Wait, will that make it assume all SteamID's for all game-servers logging to that instance of HLStatsX:CE are using the new Steam3 format? I have several different games (mixture of Source-based and GoldSrc-based at that) all using the same system.

The edit Bot posted was just to fix the missing avatars on profile pages, at least as far as I know.

I do think Bot is right though, some form of a rewrite would be beneficial. Currently, I'll try to explain this in the least confusing way possible, my hlstats is using the old steam ID format but it has given players a NEW steam ID with the old format but it somehow linked the old to the new. Sourcebans for example is still tracking their old steam IDs but the hlstats changes we made are making it work strangely BUT IT DOES WORK, even if it isn't pretty.

Horsedick 09-12-2014 09:32

Re: Fix SteamIDs for the new update
 
Ok I used the changes in the first post just because I figure what the hell.... now when I see notices of points in the game sometimes it shows the original stats numbers of the player on some kills and whatever and on others it appears as if it tried to restart them?

bottiger 09-14-2014 23:20

Re: Fix SteamIDs for the new update
 
The code in the first post converts steam3 to steam2.

My fixes assume steam3 everywhere.

If you want to convert steam2 to steam3 I think you can use something like this instead. I haven't tested this yet so it might have some syntax errors.

Code:

$uniqueid =~ s!STEAM_0:([01]):(\d+)!'[U:1:'.int($1)+int($2)*2.']'!eg;

sadam_unike 01-01-2015 19:10

Re: Fix SteamIDs for the new update
 
Hello!

Please help me I did everything Nikkii sent but did not work the players continue to appear two times in the Hlstasx page.

Best Regards

C00ller 01-02-2015 02:59

Re: Fix SteamIDs for the new update
 
Quote:

Originally Posted by sadam_unike (Post 2243366)
Hello!

the players continue to appear two times in the Hlstasx page.

Best Regards


Assuming you prefer old SteamIDs, you should get rid of player records stored with new SteamIDs meanwhile, by query like this:

Code:

DELETE FROM hlstats_PlayerUniqueIds WHERE INSTR(uniqueId, 'U') > 0
And, of course, use Sourcemod snapshot 4558 or newer (to utilize old SteamIDs)


All times are GMT -4. The time now is 11:05.

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