Posted by Pha.Sapr01354 from on 2006-12-22 17:07:32 Reply
it looks kinda vague ... you haven't splited into the 9 ranks and the sorting is made by the registration date i think? also the challenges completed has to apear as well
Posted by Pha.Sphinx6553 from on 2006-12-22 17:56:06 Reply
Updated with flags and number of challengese solved...I haven't got the sorting to work. The ORDER BY solved_date doesn't seem to produce the right results...
9 +votes | 1 −votes
Huuuuuuu
Re^3: New hof/ranking
Posted by Pha.Sapr01354 from on 2006-12-22 18:54:00 Reply
Posted by Pha.Sphinx6553 from on 2006-12-24 11:09:12 Reply
The server is using an older version of MySQL (4.0++). I was trying with MIN(some_date) or MAX(some_date) which worked on my local comp because I'm using version 5++ but not on the server. Will find another way to get it right...
8 +votes | 1 −votes
Huuuuuuu
Re^5: New hof/ranking
Posted by Viz.yai2k3404 from on 2006-12-24 12:03:13 Reply
Looks to me like you're using the wrong info for the solve date -- more specifically, it's one challenge off. I solved #29 on Dec 07, not #30.