/** * ------------------------------------------------------------------------------------------- * Добавление истории дата * @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; }