if ($res = $app->db->query($sql)) {
// Get the number of hit results
$res2 = $app->db->query($sql2);
$totalItemsCount = count($res2->fetchAll());
//$res2->numRows();
//echo $totalItemsCount;
// Archive By Date
if (preg_match('/^[0-9]{4}-[0-9]{2}-[0-9]{2}/', $date)) {
$contents = $app->getArchives($res);
$pager = $app->getPager($totalItemsCount, $pageNumberToShow, $date, $expand);
$result = '';
} else {
$contents = $app->getArchives($res);
$pager = $app->getPager($totalItemsCount, $pageNumberToShow, $date, $expand);
$result = new Loggix_View($pathToIndex . '/theme/' . $resultViewFile);
$item = $app->setSearchItems($res, $totalItemsCount, $previousItemNumber, $date);
$result->assign('item', $item);
$result->assign('lang', $lang);
$result = $result->render();
}
// Contents, Pager, and Results
$item['contents'] = $contents;
$item['pager'] = $pager;
$item['result'] = $result;
$item['title'] = !empty($_GET['c']) ? $app->setTitle(array($item['keyword'], $lang['archive'])) : $app->setTitle($lang['archive']);
}
// (2) Index View (Show Recent Entries)
} else {
$sql = 'SELECT ' . '* ' . 'FROM ' . TRACKBACK_TABLE . ' ' . 'GROUP BY ' . 'blog_id ' . 'ORDER BY ' . 'date DESC ' . 'LIMIT ' . $config['page_max'];
$countTotalItemsSql = 'SELECT ' . 'COUNT(id) ' . 'FROM ' . TRACKBACK_TABLE . ' ' . 'GROUP BY ' . 'blog_id';
// $totalItemsCount = $app->getTotalItemsCount($countTotalItemsSql);
