[TF2] Database Maintenance
 

Hello!

I would like to trace kills in MvM. As suggested in a previous thread I've enabled the tracking of BOTS (IgnoreBots = 0), so now I can correctly track the kills. Now I would like to make a daily maintenance to drop all statistics made by BOTS. Is this possible? What I would like to obtain is:

• track kills on MvM that counts when I kill a Bot too (this is already ok)
• don't see BOTs stats and RANKING
• don't see BOTs gaining AWARDS

If it's possible with daily SQL maintenances, no problem, I can set-up them (at my own risk) without problems.

I'm having last version of HLSTATSX on a Linux box.

Thank's,

simon

Re: [TF2] Database Maintenance
 

If i remember correct you can login to the admin, then go to the bots stats page and edit player to hide it.

Tho i can not remember if this works for bots or just normal players.

Re: [TF2] Database Maintenance
 

Uhm, I cannot find the "Bots Stats Page". Do you mean I need to search every BOT by name?
On "Edit Player or Clan" I must search for a name. Then there is a field called "Hide Ranking", that supports 3 values: NO, YES, BANNED, INACTIVE. Should I need to set it every BOT manually to YES?

Simon

Re: [TF2] Database Maintenance
 

I've solved mysqlf :)
I've seen that setting the HIDE RANKING to YES does the job. Now the ranking and awards are only held by real players and kills are tracked on bots as well. I've updated all bots via SQL query:

"UPDATE hlstats_Players SET hideranking = 1 WHERE hideranking = 0 AND playerId IN (SELECT playerId FROM hlstats_PlayerUniqueIds WHERE uniqueId LIKE 'BOT:%')"

This works well, but I've only ONE server on this installation also I've not filtered by server or gametype. Should this query use someone, to do at own risk ;)

Bye,

Simon