12/04/17 20:48:09.50
高学歴揃いの雑スレ民ならこれくらい12秒で読んでレス返すくらい余裕だよね
2011-11-01~10 day downtime on ranking.pl service over, planned patches tenhou | 20:23
The perl executable path changed its location on my server about two weeks ago, so for about 10 days there was limited service for ranking.pl. It's fixed now and the missed days have been entered into the database.
As a result of this I've made a few changes that make it easier to patch any potential gaps or errors in the database.
Since it's really big, it can be the case that entries get entered multiple times - checking for duplicate entries is not possible since games are not necessarily unique.
I'm in the process of fixing some gaps or double entries that have plagued the database for quite a while.
Also, the 60 millionth game was recently played. There's a record I guess.
I have the intention (but not necessarily the will) to add support for jansou-mode gametype entry into the database. When I get around to it, I will add all games up to that point, meaning the database will be complete.
I harvest the data but I haven't automated its entry into the database yet. I think some database modifications are necessary, which might take a million years.
In related news MySQL is a pile of shit, but a necessary evil.