/**
* -------------------------------------------------------------------------------------------
* Добавление истории дата
* @return
* -------------------------------------------------------------------------------------------
*/
public static function add($sitemap_id, $szName)
{
$sitemap_id = intval($sitemap_id);
$szName = \Faid\DB::escape($szName);
//
$sql = 'SELECT * FROM `%s` WHERE id="%d"';
$sql = sprintf($sql, SITEMAP_TABLE, $sitemap_id);
$aFound = DB::Get($sql);
if (empty($aFound)) {
throw new SitemapException('Page with id="' . htmlspecialchars($sitemap_id) . '" not found');
}
//
$sql = 'INSERT INTO `%s` SET `date`=NOW(),`name`="%s",`url`="%s",`page_id`="%d"';
$sql = sprintf($sql, SITEMAP_HISTORY_TABLE, \Faid\DB::escape($szName), \Faid\DB::escape($aFound['full_url']), $sitemap_id);
//
DB::post($sql);
}
/**
* -------------------------------------------------------------------------------------------
* Метод осуществляет поиск по карте сайте
* @param string $szKeyword строка поисковая ключа
* @return array
* -------------------------------------------------------------------------------------------
*/
public static function selectPaged($nParent, $nStart, $nLimit)
{
$nParent = intval($nParent);
$nStart = intval($nStart);
$nLimit = intval($nLimit);
//
$sql = 'SELECT SQL_CALC_FOUND_ROWS * FROM `%s` WHERE `parent`="%d" ORDER by `order` LIMIT %d,%d';
$sql = sprintf($sql, SITEMAP_TABLE, $nParent, $nStart, $nLimit);
$aResult = DB::query($sql);
$sql = 'SELECT FOUND_ROWS() as `totalcount`';
$aFound = DB::Get($sql);
self::$nItemCount = ceil($aFound['totalcount'] / $nLimit);
return $aResult;
}
