[anticheats]

Rytis, just help me find a way to make daemon log the stats into two databases and I'll reveal the logic to you later

[Rytis]

You could start two daemons and add one server to them two^^
Do you want to gain performance? Like a failback server?

[Mavrick4283]

Originally Posted by anticheats Rytis, just help me find a way to make daemon log the stats into two databases and I'll reveal the logic to you later

How about you say why you are trying to do something that has no reasoning behind it.

It will not help preformance
It will not help backup
It will not work as a fall over

so...why.....

If you want back up // warm back up or even performance then set up MySQL in a cluster... The way the daemon is written at this time you will not be able to write to 2 DB's you could copy and paste some code to getto rig it but there is no logic behind doing that there for not even worth the time to find the files to edit.

[anticheats]

Well, what I had in mind was to make every daemon log into a 'master' database along with the 'default' database configured in hlstats.conf so that 'global rankings' can be determined from the master database and sever-specific rankings from the default. Is that a very bad idea?

[Rytis]

No, it's not, but it's kinde useless (for me atleast)

As I said: You could start two daemons and add the logaddress_add command twice.

[anticheats]

It might be useful to me because I plan of offering the stats to other gaming communities as well. I guess the global rankings (determined from the master database) for all the participating servers will be interesting.

Rytis, I don't think starting two daemons is a good idea because that will not only drain the resources of both the web sever and game server but also delay the response time.

[Mavrick4283]

Originally Posted by anticheats Well, what I had in mind was to make every daemon log into a 'master' database along with the 'default' database configured in hlstats.conf so that 'global rankings' can be determined from the master database and sever-specific rankings from the default. Is that a very bad idea?

Yes, if you do it that way then each server decides how many points each action is worth so for example if server 1 killing some one is worth 2 points but server 3 killing some one is worth 10 points then players from server 3 will be higher ranked.

+ it is a waste of resources for the daemon to dup the data like that, MySQL has backup tools for running "warm" and "hot" backups just use those as they will work on the DBA level and have less over head.

[anticheats]

Yea you're right, servers could manipulate with their skill points and therefore it's a bad idea.

One last question, I've noticed that the file 'HLstats_EventHandlers.plib' includes the connect announce thing like 'player has connected from United States'. What do I put there (or any other file) to include cities as well. E.g, 'player has connected from San Francisco, United States'?

[abr]

In table geoLiteCity_Location there is field 'city', so may be you can try to use
$msg = sprintf("Player %s has connected from %s (%s)", $player->{name},$player->{country},$player->{city});
instead of
$msg = sprintf("Player %s has connected from %s", $player->{name},$player->{country});
and in other if..elsif branches