[GrO]

BTW switch hint info works fine for me, maybe because I recompiled this plugin with the latest SM version (1.3.8).

EDIT:
I've removed attachment, cause I forgot I've translated the message to polish ;]. Anyway, You can always compile it, by Yourself and if You still don't know how: #425.

[FunKillerClan]

Hi tHx 4 the Info, can u please recompiled this in german too. I unfortunately do not get to the because that spcomp.exe does not open.

I would really appreciate, sorry my english ist bad google helps me

[GrO]

Originally Posted by FunKillerClan Hi tHx 4 the Info, can u please recompiled this in german too. I unfortunately do not get to the because that spcomp.exe does not open. I would really appreciate, sorry my english ist bad google helps me

Don't open spcomp.exe file. Just drop teambalance.sp on it.

[Mister_Magotchi]

I have made a tweak to this plugin, based on version 2.2.4 by GrO.

This version makes use of (and requires) the HLstatsX:CE SQL API for Sourcemod.

In the original plugin, as each player connects, their kills, deaths, KDR (for some reason), and timestamp from their previous session are grabbed from the database. When the player disconnects, that same data (updated based on the current session) is written back to the database.

Looking at sm_tbstats, other admins and I noticed some inconsistencies in the data. Some players had accurate stats (several thousand kills for a few), but some players, including one that had played every day for the last week (and had over 1000 kills for the week) had only about 60 kills in sm_tbstats.

Rather than spend lots of time troubleshooting the reason behind this issue, I decided to change the plugin to use HLstatsX:CE data instead.

In this version, when a player connects to the server (or when the map changes), their kills and deaths are loaded via the HLstatsX:CE SQL API. If either their stats can't be loaded or have not been loaded (like if the the plugin is reloaded while a game is running), the balancer will just calculate based on their current session kills and deaths that it normally collects. [Edit: This can be fixed using the API, but I was apparently just lazy, and who cares.] Additionally, the plugin still continues to augment the initial kill/death data with data it collects from the current session, although it of course reloads all that data on map change, which is no problem, since HLstatsX:CE was keeping track of the same data anyway.

This plugin is read-only with respect to HLstatsX:CE data.

I haven't tested it extensively, but so far it isn't throwing any errors in my logs, the proper data is showing up in sm_tbstats (the plugin's internal stats it's using for the session), and people are getting balanced around. Time will tell whether it actually does a great job of balancing.

For those unsure how to get the HLX:CE API working after installing it, you have to add an "hlxce" entry to addons/sourcemod/configs/databases.cfg with the information for your HLstatsX:CE MySQL database. I've also attached a compiled version of HLX:CE API 0.4 alpha (the latest as of now) for those who aren't sure how to compile with includes.

Short version:
CS:S Team Balance with HLstatsX:CE API support:

[Mister_Magotchi]

I've had multiple server regulars and admins tell me that they think it's doing a better job of balancing now, and I think so as well from my observations.

[Ares Veteran]

Nice to see that someone is still working on this. Thank You!

I will try your version.

[BartholomewPSkibbenheims]

Originally Posted by Mister_Magotchi I have made a tweak to this plugin, based on version 2.2.4 by GrO. This version makes use of (and requires) the HLstatsX:CE SQL API for Sourcemod. In the original plugin, as each player connects, their kills, deaths, KDR (for some reason), and timestamp from their previous session are grabbed from the database. When the player disconnects, that same data (updated based on the current session) is written back to the database. Looking at sm_tbstats, other admins and I noticed some inconsistencies in the data. Some players had accurate stats (several thousand kills for a few), but some players, including one that had played every day for the last week (and had over 1000 kills for the week) had only about 60 kills in sm_tbstats. Rather than spend lots of time troubleshooting the reason behind this issue, I decided to change the plugin to use HLstatsX:CE data instead. In this version, when a player connects to the server (or when the map changes), their kills and deaths are loaded via the HLstatsX:CE SQL API. If either their stats can't be loaded or have not been loaded (like if the the plugin is reloaded while a game is running), the balancer will just calculate based on their current session kills and deaths that it normally collects. [Edit: This can be fixed using the API, but I was apparently just lazy, and who cares.] Additionally, the plugin still continues to augment the initial kill/death data with data it collects from the current session, although it of course reloads all that data on map change, which is no problem, since HLstatsX:CE was keeping track of the same data anyway. This plugin is read-only with respect to HLstatsX:CE data. I haven't tested it extensively, but so far it isn't throwing any errors in my logs, the proper data is showing up in sm_tbstats (the plugin's internal stats it's using for the session), and people are getting balanced around. Time will tell whether it actually does a great job of balancing. For those unsure how to get the HLX:CE API working after installing it, you have to add an "hlxce" entry to addons/sourcemod/configs/databases.cfg with the information for your HLstatsX:CE MySQL database. I've also attached a compiled version of HLX:CE API 0.4 alpha (the latest as of now) for those who aren't sure how to compile with includes. Short version: CS:S Team Balance with HLstatsX:CE API support:

How hard would it be to make this work with gameme, which is much like HLStats:CE? Gameme does have a built in balancer ... I used to run it and literally watch it over and over literally pick the worst people to move when trying to balance teams.

[Mister_Magotchi]

It would probably be easy, but I don't plan on doing it, because I don't have GameME to test it. They have an API, and the gScramble plugin uses it if someone wants to see how it works. The API is part of the include that comes with the GameME SourceMod plugin. The function is called QueryGameMEStats.

[nightrider]

Fantastic update Mister Magotchi.

[Mister_Magotchi]

Thanks, man. I just make tweaks like this periodically on my own servers and am glad to spread the wealth.