public function get($refresh = false)
{
$sql = "select * from site";
if ($refresh) {
$cache = new Cache();
$cache->delete($sql);
}
$db = new DB();
$rows = $db->query($sql, true, NN_CACHE_EXPIRY_MEDIUM);
if ($rows === false) {
return false;
}
return $this->rows2Object($rows);
}
/**
* Query the indexer directly. Returns an array of the results, unless
* there was an error in which case ``false`` is returned. However, if
* Sphinx returns an "invalid query" error (1064), then an empty result
* array is returned. Note that an empty "result array" is not the same as
* an empty array and will instead look like::
*
* array({"_totalrows": 0})
*
* If ``$lookupQuery`` is an empty string, then the results returned will
* be the data from the index--this is not guaranteed to be the most recent
* data that is in the MySQL database. If you absolutely need the most
* recent data from MySQL, then ``$lookupQuery`` should be a valid SQL
* query that has contains "releases.id IN (%s)".
*
* @param string $sphinxQuery The raw SphinxQL query.
* @param string $lookupQuery The SQL to use to lookup the results.
* @param bool/int $useCache The ttl to store the item in the cache.
* @return array|false
*/
public function searchDirect($sphinxQuery, $lookupQuery = "", $useCache = false)
{
$cache = new Cache();
if ($useCache !== false && $cache->enabled && $cache->exists($sphinxQuery)) {
$ret = $cache->fetch($sphinxQuery);
if ($ret !== false) {
return $ret;
}
}
// Connect to Sphinx
$hostport = explode(":", $this->pdo->getSetting('sphinxserverhost'));
$sdb = mysqli_connect($hostport[0], "root", "", "", $hostport[1]);
if (!$sdb) {
// Couldn't connect to Sphinx.
return false;
}
// Get the results from Sphinx.
$lev = error_reporting();
error_reporting(0);
$result = mysqli_query($sdb, $sphinxQuery);
error_reporting($lev);
$error = mysqli_error($sdb);
// A 1064 error means that the query is invalid, so we don't care
// about that.
if ($error && mysqli_errno($sdb) != 1064) {
// All other errors we will considered a failure.
return false;
}
// Get the query metadata.
$meta = [];
$mresult = mysqli_query($sdb, "SHOW META");
if (!$mresult) {
return false;
}
while ($row = mysqli_fetch_row($mresult)) {
$meta[$row[0]] = $row[1];
}
$results = [];
if ($result) {
while ($row = mysqli_fetch_assoc($result)) {
if ($lookupQuery) {
// Save the IDs for a batch lookup.
$results[] = $row["id"];
} else {
$results[] = $row;
}
}
}
if ($lookupQuery && count($results) > 0) {
$ndb = new newznab\db\Settings();
$sql = sprintf($lookupQuery, implode(",", $results));
$result = $ndb->queryDirect($sql);
if ($result) {
$results = [];
while ($row = $ndb->getAssocArray($result)) {
$results[] = $row;
}
}
}
$count = 0;
if (count($results) > 0 && array_key_exists("total", $meta)) {
$count = (int) $meta["total_found"];
$results[0]["_totalrows"] = $count > MAX_MATCHES ? MAX_MATCHES : $count;
}
if ($useCache !== false && $cache->enabled) {
$cache->store($sphinxQuery, $results, $useCache);
}
return $results;
}
public function storeCache($key, $data)
{
$cache = new Cache();
$ret = $cache->set($key, $data, 900);
if ($ret !== false) {
return $ret;
}
return false;
}
