[Tilesathome] MySQL and iowait

[OJW]

On Saturday 19 May 2007 21:30, Frederik Ramm wrote:
> Anyway, OJW was critical about my change, (rightly) stating that it
> would enable people to "sneak in" spam images at above zoom level 12
> without being (easily) identifiable. He has asked for comments about
> this, without saying whether or not he's using my modified code.

Just to be clear: the "disable metadata for z>12" change hasn't been installed 
on the server.  

The tiles at home server allows lots of people we barely know to upload images, 
which we then display to the public.  That's fine if everyone uploads maps, 
but could get a bit dodgy if someone "experiments" with their privileges.  So 
I don't want to do any updates that allow anonymous uploads to the tiles at home 
server.

However...

Lots of people are talking about "batch uploads" now, where each upload 
contains all 1376 images in one tileset, and just one piece of meta-info is 
stored for the entire tileset.  This will require some extra code on both the 
server and the client, but will reduce the SQL load while maintaining 
traceability for images.  

I believe LA2 has started looking at the upload script?  If not, the change 
basically needs to be "look for a complete tileset, put that into a ZIP and 
upload it" (instead of just uploading any images it finds in the directory).

A "tileset" here is defined as "all images in one layer within a z-12 area". I 
think the total should be 1376 images, but that's just from memory.  When it 
goes live, the server will need to check each upload to ensure it contains 
exactly the right images, before accepting the upload.

I can probably do the server side of that, but if anyone wants to create a PHP 
function which looks in a directory full of "layer_z_x_y.png" images,  checks 
that it's one complete tileset (and nothing outside that tileset), then 
returns which tileset it is, that would be very helpful.