Raised This Month: $32 Target: $400
 8% 

[TF2] Database Maintenance


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
xefil
Junior Member
Join Date: Dec 2012
Old 12-19-2012 , 09:24   [TF2] Database Maintenance
Reply With Quote #1

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
xefil is offline
Mavrick4283
Veteran Member
Join Date: Apr 2010
Location: 127.0.0.1@root
Old 12-19-2012 , 11:22   Re: [TF2] Database Maintenance
Reply With Quote #2

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.
__________________
Mavrick4283 is offline
xefil
Junior Member
Join Date: Dec 2012
Old 12-19-2012 , 14:31   Re: [TF2] Database Maintenance
Reply With Quote #3

Quote:
Originally Posted by Mavrick4283 View Post
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.
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
xefil is offline
xefil
Junior Member
Join Date: Dec 2012
Old 12-20-2012 , 05:37   Re: [TF2] Database Maintenance
Reply With Quote #4

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
xefil is offline
Reply


Thread Tools
Display Modes

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 14:42.


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