Garaph Changes

2013-02-27 14:00:47

The same minor SQL fix as has been mentioned many times before, just applied to a little-used function I hadn't noticed was still broken: the ability to look at software groups as they were in a past week.

2012-12-16 13:54:19

I won't list all of the affected pages, but all of the ones dealing with Japanese hardware have had 3DSLL and Wii U added in both the dropdown boxes and lists of commonly-needed weeks.

2012-08-04 03:59:42

Companion to the group pages, the software group lines, still needed the fix. They got it.

2012-08-03 11:37:40

Group pages were broken in the same way as the other pages were needing a tiny fix, but since they tend to stay cached without change longer most of them continued showing up fine for quite a while. Fixed now.

Separately fixed, the automatic hardware data gatherers for both Famitsu and Media Create. Famitsu changed their format, requiring modifcations to the parser--and unfortunately they seem to have dropped the pie chart information on how total software sales were split. MC just needed to be told how to recognize numbers for the 3DS LL. Famitsu is just lumping 3DS and 3DSLL together as they did with DSi and DSiLL, so no worries there.

2012-06-26 20:09:22

Same thing as usual lately has now been fixed in the Weekly Overview.

2012-06-24 05:22:30

Same fix again, this time on Hardware Shipment Line Graph Generator.

2012-06-23 19:18:44

Game Search has been fixed; it was afflicted with the same trouble as most of the others from a few updates back.

2012-06-23 15:59:07

Another fix. The function that makes numbers presentable for tables is no longer willing to put up with the character the graphing software uses to represent blanks in the same way, so it's got to go through one more small step to make it show as 0 rather than yelling out a warning. At a glance it seems like this was only a problem for the Japanese Hardware Sales Line Graph Generator, since it tries to list every single week while other things list what data is actually present in the database.

2012-06-23 11:18:21

Same issue as last time has been fixed in more areas: Japanese Software Sales Line Graph Generator, Japanese Hardware Sales Pie Graph Generator, Japanese Hardware Sales Bar Graph Generator, Japanese Software Sales Group Bar Graph Generator, Game Database Direct SQL Access.

It was also pointed out that the companion page to the last one, Game Database Direct SQL Access: Table Descriptions, was extremely out of date, so it has been updated. Today appears to be exactly 4 years since it was created (and last touched)!

2012-06-20 14:38:02

My host just upgraded to newer versions of both PHP and MySQL. Unsurprisingly not all code written before works 100% the same way, so errors are popping up in various places. I've only scratched the surface so I'm not sure how widespread things are. In the next few days I'll try to get things patched up, though without going through everything with a fine-tooth comb or trying a thousand things on the site it's quite likely something will slip through the cracks. So if something is still wrong and I haven't updated the site in a few days, give me a heads up.

For now I've just made a fix to the Japanese Hardware Sales Line Graph Generator. For reference, it seems like it's no longer sufficient to say the code equivalent of "Give me column X of this search result" if only one result is expected; it's now necessary to specify "Give me column X from row 0 of this search result". I imagine there's a lot of that around the site.