Build crop finder
Status
World:
9c/15c in map:
Rows in table:
Last updated:
The croppers table stores only wref,x,y,fieldtype,best_oasis_bonus.
Ownership and occupied status are pulled live from vdata/users by the finder.
Actions
Building streams progress below. You can leave this page; the process stops when the request ends.
dblink, "SELECT COUNT(*) AS c FROM `$WDATA` WHERE `fieldtype` IN (1,6)"));
$target = (int)($cnt['c'] ?? 0);
logLine("Detected $target croppers.");
$offset = 0; $total = 0;
while (true) {
$sql = "SELECT id AS wref, x, y, fieldtype
FROM `$WDATA`
WHERE `fieldtype` IN (1,6)
LIMIT $offset, $batch";
$res = mysqli_query($database->dblink, $sql);
if (!$res) { logLine('Query failed: '.mysqli_error($database->dblink)); break; }
$rows = [];
while ($r = mysqli_fetch_assoc($res)) { $rows[] = $r; }
if (!$rows) break;
$values = [];
foreach ($rows as $r) {
$x = (int)$r['x']; $y = (int)$r['y'];
$bonus = (int)$database->getBestOasisCropBonus($x, $y);
if (!in_array($bonus, [0,25,50,75,100,125,150], true)) {
$bonus = max(0, min(150, $bonus));
}
$values[] = sprintf("(%d,%d,%d,%d,%d)",
(int)$r['wref'], $x, $y, (int)$r['fieldtype'], $bonus);
}
if ($values) {
$sql = "REPLACE INTO `$CROP_TABLE`
(`wref`,`x`,`y`,`fieldtype`,`best_oasis_bonus`)
VALUES ".implode(',', $values);
if (!mysqli_query($database->dblink, $sql)) {
logLine('Upsert failed: '.mysqli_error($database->dblink));
break;
}
}
$countThis = count($rows);
$total += $countThis;
$offset += $batch;
logLine("Processed $total / $target");
}
@mysqli_query($database->dblink, "ANALYZE TABLE `$CROP_TABLE`");
logLine("Analyze complete.");
logLine("Done.");
endStreaming();
// Refresh stats after build
$stats = getCounts($database->dblink, $WDATA, $CROP_TABLE);
}
?>
