private static function LoadLastNews($limit, $start)
{
if ($start > 0) {
self::$current_news_page = $start;
$offset = $start * $limit;
} else {
$offset = 0;
}
self::$last_news = DB::WoW()->select("SELECT `id`, `image`, `header_image`, `title_%s` AS `title`, `desc_%s` AS `desc`, `author`, `postdate` FROM `DBPREFIX_news` ORDER BY `postdate` DESC LIMIT %d, %d", WoW_Locale::GetLocale(), WoW_Locale::GetLocale(), $offset, $limit);
$count = count(self::$last_news);
for ($i = 0; $i < $count; $i++) {
self::$last_news[$i]['comments_count'] = DB::WoW()->selectCell("SELECT COUNT(*) FROM `DBPREFIX_blog_comments` WHERE `blog_id` = %d", self::$last_news[$i]['id']);
}
self::$total_news_count = DB::WoW()->selectCell("SELECT COUNT(*) FROM `DBPREFIX_news`");
if (self::$current_news_page > 0) {
self::$pager_data['prev'] = true;
if ($limit * ($start + 1) < self::$total_news_count) {
self::$pager_data['next'] = true;
}
} else {
self::$pager_data['prev'] = false;
if (self::$total_news_count > $limit) {
self::$pager_data['next'] = true;
}
}
}
