private static function LoadBlizzPosts($last, $page = 0) { self::$total_blizz_posts = DB::WoW()->selectCell("SELECT COUNT(`post_id`) FROM `DBPREFIX_forum_posts` WHERE `blizzpost` = 1"); self::$loaded_blizz_posts = DB::WoW()->select("\n SELECT DISTINCT\n `a`.`post_id`,\n `a`.`thread_id`,\n `a`.`cat_id`,\n `a`.`bn_id`,\n `a`.`character_guid`,\n `a`.`message`,\n `a`.`post_date`,\n DATE_FORMAT(`a`.`post_date`, '%%d/%%c/%%Y') AS `formated_date`,\n `b`.`title` AS `threadTitle`,\n `c`.`title_%s` AS `categoryTitle`,\n `d`.`name` AS `author`,\n DATEDIFF(NOW(), `a`.`post_date`) AS `post_days`,\n HOUR(SUBTIME(NOW(), DATE_FORMAT(`a`.`post_date`, '%%H:%%i:%%s'))) AS `post_hours`,\n MINUTE(SUBTIME(NOW(), DATE_FORMAT(`a`.`post_date`, '%%H:%%i:%%s'))) AS `post_minutes`,\n (SELECT COUNT(*)+1 FROM `DBPREFIX_forum_posts` WHERE `post_id` < `a`.`post_id` AND`thread_id` = `a`.`thread_id` ORDER BY `a`.`post_date` ASC ) AS `ROW`\n FROM `DBPREFIX_forum_posts` AS `a`\n LEFT JOIN `DBPREFIX_forum_threads` AS `b` ON `b`.`thread_id` = `a`.`thread_id`\n LEFT JOIN `DBPREFIX_forum_category` AS `c` ON `c`.`cat_id` = `a`.`cat_id`\n LEFT JOIN `DBPREFIX_user_characters` AS `d` ON `d`.`bn_id` = `a`.`bn_id` AND `d`.`guid` = `a`.`character_guid`\n WHERE `a`.`blizzpost` = 1\n ORDER BY `a`.`post_date` DESC\n LIMIT %s%s", WoW_Locale::GetLocale(), $page > 0 ? ($page - 1) * 15 . ', ' : null, $last ? '14' : '15'); if (self::$blizz_tracker_active) { self::$blizz_tracker = self::$loaded_blizz_posts; } self::HandleBlizzPosts(); }