[Tilesathome] Link to recent uploaded tiles pr user broken

[Rob Reid]

spaetz wrote the following on 03/12/2007 05:39:
> On Sun, Dec 02, 2007 at 05:08:22PM +0100, J.D. Schmidt wrote:
>   
>> http://tah.openstreetmap.org/Credits/ByUser/ is broken. No display of 
>> tiles, when inputting a user ID.
>>
>> Page used with user ID at every user from normal credits page.
>>     
> Somebody had disabled it (not me). It absolutely killed performance as the sorting by date was done in a filesort.
> I reenabled the site, but disabled the sorting by date. This means it will just display whatever mysql returns. It seems to be the most recents ones, but that is just a mysql coincidence.
>   
Could we add an additional 'where' clause to select only those tiles 
returned is the last 24hrs(or have the hours as parameter), remove the 
limit clause and then sort the result in php?

I'm happy to code something like this but I'm new to svn so what's the 
best way of being able to test my changes on the server before comitting 
them?
 
Cheers

rcr