more stuff broke

tenhou

Well, I fixed the aforementioned problems a while back. I did not repopulate the database with the missing information, and I think another similar outage happened again since, but there are only a few days of missing data. I think it is negligible for the most part.

Anyway, yesterday or so stuff broke again and my cron tasks ceased to work. rondb also broke for even more mysterious reasons and I can't figure out why (I haven't touched it in about a year). I fixed the ranking.pl frontend though. By request I need to add something that will allow you to search for games where somebody got +-0.

ranking.pl backend broken for now

tenhou

Tenhou recently changed their sc* format to have etcetc(+x.0), and so the storage backend to the game record database behind ranking.pl has ceased to add new entries. It is a fairly simple fix; change a few cron tasked scripts I suppose. I haven't fixed it yet because I am feeling really lazy.

day missing in ranking.pl mysql database

tenhou

Apparently 2009-08-17 was never loaded into the MySQL database behind ranking.pl. I blame the likely event of server downtime. I noticed because of an entry into calibrate.pl that resulted in a negative first-game index. Suffice to say, there were fewer games in the database than had been actually played, which was very alarming. It is fixed now, though. See: http://arcturus.su/tenhou/gamerecords/log.txt

There is another problem too, but it is very late so I will address it some other time.

interesting things and expansion of ranking.pl

tenhou

I am planning more things for ranking.pl. In the pipeline is a feature much like Xfire's, which will auto-generate little images that people can use on blags and SNS sites and stuff. I'm not sure entirely how feasible that is computationally, but I should be able to do it when I get unlazy. Monthly statistics on plots might also be added - effectively differentiating the little information that I can get from simple game records. Extrapolation of data seems to be a good way to expand. Also, should I get to the bottom of it, I might add player rank/pt statistics. I need to sort out some nitty-gritty date things first, though.

Should I add the rank/pt thing, there is a slight problem. Since it is impossible to figure out when an ID was registered, it is likewise impossible to get the right rank/pt unless it is calibrated. I will probably add a page where a player can paste their ID into a textbox and click a button - the script will log in, take note of the current pt/rank/rate and number of games played for both 3p and 4p games, and calibrate the database accordingly. Future queries will then show correct information. The biggest problem with this is quite simply people's reluctance to give some random (foreigner's) script their ID just so others can see correct information, but I suppose as time goes on it will become more trusted.

Another idea which I will probably implement this moment is a feature request form linked directly from the ranking.pl front page. I'm sure I will get a lot more suggestions than I have so far if it is possible without emailing.

game logs for analysis

tenhou

I have been collecting these for ages now but nobody really knows about them:
http://arcturus.su/tenhou/gamelogs/houou/

It's all the game logs of all the houou games ever played (including the very frist two, played by me, almost a month before houou was made public). You may also find some of the stuff up a directory useful:
http://arcturus.su/tenhou/gamelogs/

Enjoy.