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);