while (!$recordSet->EOF) {
$tiles += $mosaic->expirePosition($recordSet->fields['x'], $recordSet->fields['y'], 0, true);
print "tiles = {$tiles}<br/>";
flush();
$count++;
$recordSet->MoveNext();
}
$recordSet->Close();
print "<h2>All Done</h2>";
print "Squares done = {$count}<br/>";
print "Tiles deleted = {$tiles}";
flush();
exit;
} elseif (isset($_GET['gridref'])) {
$square = new GridSquare();
$ok = $square->validGridRef($_GET['gridref']);
if ($ok) {
$gridref = $_GET['gridref'];
$smarty->assign_by_ref('gridref', $gridref);
$smarty->assign('showinfo', 1);
//can we find a square?
$sq = $db->GetRow("select * from gridsquare where grid_reference='{$gridref}'");
if (count($sq)) {
$smarty->assign('percent_land', $sq['percent_land']);
}
//update?
if (isset($_GET['save'])) {
$percent = intval($_GET['percent_land']);
if (count($sq)) {
//update existing square
$db->Execute("update gridsquare set percent_land='{$percent}' where gridsquare_id='{$sq['gridsquare_id']}'");
$data['location'] = '';
if (!empty($_GET['label'])) {
$data['description'] = "labeled [" . strip_tags($_GET['label']) . "]";
$db = NewADOConnection($GLOBALS['DSN']);
$where = "label = " . $db->Quote($_GET['label']);
} else {
$data['description'] = "in a cluster";
$where = 1;
}
$data['searchq'] = "inner join gridimage_group using (gridimage_id) where {$where} group by gridimage_id";
$data['distance'] = 1;
$nearstring = 'in';
if (!empty($data['gridref'])) {
require_once 'geograph/gridsquare.class.php';
$square = new GridSquare();
if ($square->validGridRef(preg_replace('/[^\\w]/', '', $data['gridref']))) {
$grid_ok = $square->setByFullGridRef($data['gridref'], false, true);
if ($grid_ok || $square->x && $square->y) {
$data['description'] .= ", {$nearstring} grid reference " . $square->grid_reference;
$data['x'] = $square->x;
$data['y'] = $square->y;
}
}
unset($data['gridref']);
}
if (empty($data['displayclass'])) {
$data['displayclass'] = 'cluster2';
}
$data['breakby'] = 'label+';
switch ($data['orderby']) {
case 'label':
