private static function LoadGuildFeed() { if (!self::IsCorrect()) { WoW_Log::WriteError('%s : guild was not found.', __METHOD__); return false; } self::$guild_feed = DB::Characters()->select("\n SELECT\n `character_feed_log`.`guid`,\n `character_feed_log`.`type`,\n `character_feed_log`.`data`, \n `character_feed_log`.`date`, \n `character_feed_log`.`item_guid`, \n `character_feed_log`.`item_quality`,\n `characters`.`name` AS `charName`,\n `characters`.`gender`\n FROM `character_feed_log`\n INNER JOIN `characters` ON `characters`.`guid` = `character_feed_log`.`guid`\n WHERE `character_feed_log`.`guid` IN (%s)\n AND\n (\n (\n `character_feed_log`.`type` = %d \n AND\n `character_feed_log`.`item_quality` >= 3\n )\n OR\n (\n `type` = %d\n )\n )\n ORDER BY `date` DESC\n LIMIT 50", self::GetGuildMembersGUIDs(), TYPE_ITEM_FEED, TYPE_ACHIEVEMENT_FEED); if (!self::$guild_feed) { WoW_Log::WriteLog('%s : no feed data found for guild members (GUILD: %s, GUILDID: %d)', __METHOD__, self::GetGuildName(), self::GetGuildID()); return false; } $feed_count = count(self::$guild_feed); for ($i = 0; $i < $feed_count; $i++) { if (self::$guild_feed[$i]['type'] == TYPE_ACHIEVEMENT_FEED) { self::$guild_feed[$i]['date'] = DB::Characters()->selectCell("SELECT `date` FROM `character_achievement` WHERE `guid` = %d AND `achievement` = %d LIMIT 1", self::$guild_feed[$i]['guid'], self::$guild_feed[$i]['data']); } } return true; }