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; } } }