function AgentHasResults($uploadId = 0)
{
$dbManager = $GLOBALS['container']->get('db.manager');
$uploadtree_tablename = GetUploadtreeTableName($uploadId);
if (NULL == $uploadtree_tablename) {
strcpy($uploadtree_tablename, "uploadtree");
}
/* see if the latest nomos and bucket agents have scaned this upload for this bucketpool */
$uploadtreeRec = $dbManager->getSingleRow("SELECT * FROM {$uploadtree_tablename} WHERE upload_fk=\$1 and lft is not null", array($uploadId), __METHOD__ . '.lftNotSet');
if (empty($uploadtreeRec)) {
return 0;
}
$stmt = __METHOD__ . $uploadtree_tablename;
$sql = "SELECT parent,lft FROM {$uploadtree_tablename} WHERE upload_fk=\$1 ORDER BY parent, ufile_mode&(1<<29) DESC, ufile_name";
$dbManager->prepare($stmt, $sql);
$res = $dbManager->execute($stmt, array($uploadId));
$prevRow = array('parent' => 0, 'lft' => 0);
$wrongOrder = false;
while ($row = $dbManager->fetchArray($res)) {
$wrongOrder = $prevRow['parent'] == $row['parent'] && $prevRow['lft'] > $row['lft'];
if ($wrongOrder) {
break;
}
$prevRow = $row;
}
$dbManager->freeResult($res);
return $wrongOrder ? 2 : 1;
}
function set_suffix($filename, $suffix)
{
// always use set_suffix() and NEVER the code below
strcpy(get_suffix($filename), $suffix);
return $filename;
}
require __DIR__ . "/../includes/config.php";
// numerically indexed array of places
$places = [];
// searching database for places matching $_GET["geo"]
$keywords = preg_split("/[\\s,]+/", $_GET["geo"]);
$number = count($keywords);
$changed = false;
if ($number == 1 && is_numeric($keywords[0])) {
$places = query("SELECT * FROM places WHERE postal_code = ?", $keywords[0]);
} else {
for ($index = 0; $index < $number; $index++) {
if (strlen($keywords[$index]) <= 3) {
if (is_numeric($keywords[$index])) {
strcpy($keywords[$index], query("SELECT admin_name2 FROM \n places WHERE admin_code2 = ?", $keywords[$index]));
} else {
strcpy($keywords[$index], query("SELECT admin_name1 FROM \n places WHERE admin_code1 = ?", $keywords[$index]));
}
$changed = true;
}
}
if ($changed == true) {
$changedQuery = implode("+", $keywords);
$places = query("SELECT * FROM `places` WHERE MATCH (`postal_code`, \n `place_name`, `admin_name1`, `admin_name2`) AGAINST (?)", $changedQuery);
} else {
$places = query("SELECT * FROM `places` WHERE MATCH (`postal_code`, \n `place_name`, `admin_name1`, `admin_name2`) AGAINST (?)", $_GET["geo"]);
}
}
// output places as JSON (pretty-printed for debugging convenience)
header("Content-type: application/json");
print json_encode($places, JSON_PRETTY_PRINT);
