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