Re: [GENERAL] Week numbers and calculating weekly statistics/diagrams

2010-02-16 Thread Thom Brown
On 16 February 2010 12:14, Alexander Farber wrote: > Hello, > > I have multiplayer card game in Flash/Perl/C and would > like to add weekly tournaments/player ratings to it. > > This means I have to add a table which holds: > player id, weekly score (which I update after each round) > and the week

Re: [GENERAL] Week numbers and calculating weekly statistics/diagrams

2010-02-16 Thread Greg Smith
Alexander Farber wrote: Does anybody has an advice how to save the week number? If I save it as a timestamp then calculating realtime statistics (on a player profile click) will probably be CPU-intensive, because I have to calculate the week numbers each time. If I save it as string "2010/52" t

Re: [GENERAL] Week numbers and calculating weekly statistics/diagrams

2010-02-16 Thread Martijn van Oosterhout
On Tue, Feb 16, 2010 at 01:14:26PM +0100, Alexander Farber wrote: > Does anybody has an advice how to save the week number? > > If I save it as a timestamp then calculating realtime statistics > (on a player profile click) will probably be CPU-intensive, > because I have to calculate the week numb

[GENERAL] Week numbers and calculating weekly statistics/diagrams

2010-02-16 Thread Alexander Farber
Hello, I have multiplayer card game in Flash/Perl/C and would like to add weekly tournaments/player ratings to it. This means I have to add a table which holds: player id, weekly score (which I update after each round) and the week number. Does anybody has an advice how to save the week number?