/**
* Returns true if this storage mechanism is ready to be used. false otherwise.
*/
public function isAvailable()
{
$qry = 'SHOW TABLES LIKE "config_alt"';
$result = $this->db->query($qry);
if (I2CE::pearError($result, "Cannot access database")) {
return false;
}
if ($result->numRows() == 0) {
I2CE::raiseError("No config_alt");
return false;
}
if (count($this->db_statements) != 5) {
I2CE::raiseError("No prep stmts:" . count($this->db_statements));
return false;
}
return true;
}
/**
* Return list of articles
*
* @param integer $start
* @param integer $max
* @param string $order_field
* @param string $order_dir
* @param string $filter
*/
private function dataArticles($start = 0, $max = 10, $order_field = "date", $order_dir = "desc", $filter = '')
{
$order_by = " ORDER BY";
if ($filter != '') {
$filter = ' WHERE ' . $filter;
}
switch ($order_field) {
case 'id':
$order_by = $order_by . " Article_ID";
break;
case 'url':
$order_by = $order_by . " Article_URL_Name";
break;
case 'date':
default:
$order_by = $order_by . " Article_Date";
break;
}
switch ($order_dir) {
case 'asc':
$order_by = $order_by . " ASC";
break;
case 'desc':
default:
$order_by = $order_by . " DESC";
break;
}
if ($max != 0) {
$limit = "LIMIT {$start}, {$max}";
} else {
$limit = "";
}
$querySearch = "SELECT `article_id` FROM articles {$filter} {$order_by} {$limit}";
$querySearchResults = $this->_db->query($querySearch);
$data = $querySearchResults->fetchAll(MDB2_FETCHMODE_ASSOC);
$querySearchResults->free();
return $data;
}
public function query($sql)
{
$startTime = microtime(true);
$ret = parent::query($sql);
$costTime = sprintf('%01.4f', microtime(true) - $startTime);
if ($costTime > 1) {
$this->_log("SLOW QUERY:\t{$sql}");
}
return $ret;
}
/**
* Return array of list of images ids
*
* @param integer $start
* @param integer $max
* @param array $filters
* @param string $order
* @param boolean $all
*
* @return array
*/
private function qImageId($start, $max, $filters, $order, $all = false)
{
$data = array();
$where = $this->filterSQL($filters);
if ($all) {
$querySearch = "SELECT im.`Image_ID` FROM `photo_images` im " . $where . " ORDER BY im.`Image_ID` {$order}";
} else {
$querySearch = "SELECT im.`Image_ID` FROM `photo_images` im " . $where . " ORDER BY im.`Image_ID` {$order} LIMIT {$start}, {$max}";
}
$querySearchResults = $this->_db->query($querySearch);
$data = $querySearchResults->fetchAll();
$querySearchResults->free();
return $data;
}
