PHP consolidateArrayValuesByKey函数代码示例

 public function getData()
 {
     if (Gdn::session()->isValid()) {
         $BookmarkIDs = Gdn::sql()->select('DiscussionID')->from('UserDiscussion')->where('UserID', Gdn::session()->UserID)->where('Bookmarked', 1)->get()->resultArray();
         $BookmarkIDs = consolidateArrayValuesByKey($BookmarkIDs, 'DiscussionID');
         if (count($BookmarkIDs)) {
             $DiscussionModel = new DiscussionModel();
             DiscussionModel::CategoryPermissions();
             $DiscussionModel->SQL->whereIn('d.DiscussionID', $BookmarkIDs);
             $Bookmarks = $DiscussionModel->get(0, $this->Limit, array('w.Bookmarked' => '1'));
             $this->setData('Bookmarks', $Bookmarks);
         } else {
             $this->setData('Bookmarks', new Gdn_DataSet());
         }
     }
 }

/**
 * Get all tutorials, or a specific one.
 */
function getTutorials($TutorialCode = '')
{
    // Define all Tutorials
    $Tutorials = array(array('Code' => 'introduction', 'Name' => 'Introduction to Vanilla', 'Description' => 'This video gives you a brief overview of the Vanilla administrative dashboard and the forum itself.', 'VideoID' => '31043422'), array('Code' => 'using-the-forum', 'Name' => 'Using the Forum', 'Description' => 'Learn how to start, announce, close, edit and delete discussions and comments.', 'VideoID' => '31502992'), array('Code' => 'private-conversations', 'Name' => 'Private Conversations', 'Description' => 'Learn how to start new private conversations and add people to them.', 'VideoID' => '31498383'), array('Code' => 'user-profiles', 'Name' => 'User Profiles', 'Description' => 'Learn how to use and manage your user profile. ', 'VideoID' => '31499266'), array('Code' => 'appearance', 'Name' => 'Changing the appearance of your forum', 'Description' => 'This tutorial takes you through the "Appearance" section of the Vanilla Forums administrative dashboard.', 'VideoID' => '31089641'), array('Code' => 'roles-and-permissions', 'Name' => 'Managing Roles and Permissions in Vanilla', 'Description' => 'This tutorial walks you through how to create new roles and how to use permissions.', 'VideoID' => '31091056'), array('Code' => 'users', 'Name' => 'Finding & Managing Users', 'Description' => 'This tutorial shows you how to search for and manage users.', 'VideoID' => '31094514'), array('Code' => 'category-management-and-advanced-settings', 'Name' => 'Category Management & Advanced Settings', 'Description' => 'Learn how to add, edit, and manage categories. Also learn about advanced forum settings.', 'VideoID' => '31492046'), array('Code' => 'user-registration', 'Name' => 'User Registration', 'Description' => 'Learn to control how new users get into your community.', 'VideoID' => '31493119'));
    // Default Thumbnails
    $Thumbnail = Asset('applications/dashboard/design/images/help-tn-200.jpg');
    $LargeThumbnail = Asset('applications/dashboard/design/images/help-tn-640.jpg');
    for ($i = 0; $i < count($Tutorials); $i++) {
        $Tutorials[$i]['Thumbnail'] = $Thumbnail;
        $Tutorials[$i]['LargeThumbnail'] = $LargeThumbnail;
    }
    if ($TutorialCode != '') {
        $Keys = consolidateArrayValuesByKey($Tutorials, 'Code');
        $Index = array_search($TutorialCode, $Keys);
        if ($Index === FALSE) {
            return FALSE;
        }
        // Not found!
        // Found it, so define it's thumbnail location
        $Tutorial = val($Index, $Tutorials);
        $VideoID = val('VideoID', $Tutorial);
        try {
            $videoInfo = json_decode(file_get_contents("http://vimeo.com/api/v2/video/{$Tutorial['VideoID']}.json"));
            if ($videoInfo && ($vimeo = array_shift($videoInfo))) {
                $Tutorial['Thumbnail'] = str_replace('http://', '//', val('thumbnail_medium', $vimeo));
                $Tutorial['LargeThumbnail'] = str_replace('http://', '//', val('thumbnail_large', $vimeo));
            }
        } catch (Exception $Ex) {
            // Do nothing
        }
        return $Tutorial;
    } else {
        // Loop through each tutorial populating the thumbnail image location
        try {
            foreach ($Tutorials as $Key => &$Tutorial) {
                $videoInfo = json_decode(file_get_contents("http://vimeo.com/api/v2/video/{$Tutorial['VideoID']}.json"));
                if ($videoInfo && ($vimeo = array_shift($videoInfo))) {
                    $Tutorial['Thumbnail'] = str_replace('http://', '//', val('thumbnail_medium', $vimeo));
                    $Tutorial['LargeThumbnail'] = str_replace('http://', '//', val('thumbnail_large', $vimeo));
                }
            }
        } catch (Exception $Ex) {
            // Do nothing
        }
        return $Tutorials;
    }
}

 /**
  * Delete all of the Vanilla related information for a specific user.
  *
  * @since 2.1
  *
  * @param int $UserID The ID of the user to delete.
  * @param array $Options An array of options:
  *  - DeleteMethod: One of delete, wipe, or NULL
  */
 public function deleteUserData($UserID, $Options = array(), &$Data = null)
 {
     $SQL = Gdn::sql();
     // Remove discussion watch records and drafts.
     $SQL->delete('UserDiscussion', array('UserID' => $UserID));
     Gdn::userModel()->GetDelete('Draft', array('InsertUserID' => $UserID), $Data);
     // Comment deletion depends on method selected
     $DeleteMethod = val('DeleteMethod', $Options, 'delete');
     if ($DeleteMethod == 'delete') {
         // Clear out the last posts to the categories.
         $SQL->update('Category c')->join('Discussion d', 'd.DiscussionID = c.LastDiscussionID')->where('d.InsertUserID', $UserID)->set('c.LastDiscussionID', null)->set('c.LastCommentID', null)->put();
         $SQL->update('Category c')->join('Comment d', 'd.CommentID = c.LastCommentID')->where('d.InsertUserID', $UserID)->set('c.LastDiscussionID', null)->set('c.LastCommentID', null)->put();
         // Grab all of the discussions that the user has engaged in.
         $DiscussionIDs = $SQL->select('DiscussionID')->from('Comment')->where('InsertUserID', $UserID)->groupBy('DiscussionID')->get()->resultArray();
         $DiscussionIDs = consolidateArrayValuesByKey($DiscussionIDs, 'DiscussionID');
         Gdn::userModel()->GetDelete('Comment', array('InsertUserID' => $UserID), $Data);
         // Update the comment counts.
         $CommentCounts = $SQL->select('DiscussionID')->select('CommentID', 'count', 'CountComments')->select('CommentID', 'max', 'LastCommentID')->whereIn('DiscussionID', $DiscussionIDs)->groupBy('DiscussionID')->get('Comment')->resultArray();
         foreach ($CommentCounts as $Row) {
             $SQL->put('Discussion', array('CountComments' => $Row['CountComments'] + 1, 'LastCommentID' => $Row['LastCommentID']), array('DiscussionID' => $Row['DiscussionID']));
         }
         // Update the last user IDs.
         $SQL->update('Discussion d')->join('Comment c', 'd.LastCommentID = c.CommentID', 'left')->set('d.LastCommentUserID', 'c.InsertUserID', false, false)->set('d.DateLastComment', 'c.DateInserted', false, false)->whereIn('d.DiscussionID', $DiscussionIDs)->put();
         // Update the last posts.
         $Discussions = $SQL->whereIn('DiscussionID', $DiscussionIDs)->where('LastCommentUserID', $UserID)->get('Discussion');
         // Delete the user's dicussions
         Gdn::userModel()->GetDelete('Discussion', array('InsertUserID' => $UserID), $Data);
         // Update the appropriat recent posts in the categories.
         $CategoryModel = new CategoryModel();
         $Categories = $CategoryModel->getWhere(array('LastDiscussionID' => null))->resultArray();
         foreach ($Categories as $Category) {
             $CategoryModel->SetRecentPost($Category['CategoryID']);
         }
     } elseif ($DeleteMethod == 'wipe') {
         // Erase the user's dicussions
         $SQL->update('Discussion')->set('Body', t('The user and all related content has been deleted.'))->set('Format', 'Deleted')->where('InsertUserID', $UserID)->put();
         $SQL->update('Comment')->set('Body', t('The user and all related content has been deleted.'))->set('Format', 'Deleted')->where('InsertUserID', $UserID)->put();
     } else {
         // Leave comments
     }
     // Remove the user's profile information related to this application
     $SQL->update('User')->set(array('CountDiscussions' => 0, 'CountUnreadDiscussions' => 0, 'CountComments' => 0, 'CountDrafts' => 0, 'CountBookmarks' => 0))->where('UserID', $UserID)->put();
 }

 /**
  *
  *
  * @param null $AddonCode
  * @param bool $Explicit
  * @param bool $Drop
  * @throws Exception
  */
 public function runStructure($AddonCode = null, $Explicit = false, $Drop = false)
 {
     // Get the structure files for all of the enabled applications.
     $ApplicationManager = new Gdn_ApplicationManager();
     $Apps = $ApplicationManager->EnabledApplications();
     $AppNames = consolidateArrayValuesByKey($Apps, 'Folder');
     $Paths = array();
     foreach ($Apps as $Key => $AppInfo) {
         $Path = PATH_APPLICATIONS . "/{$AppInfo['Folder']}/settings/structure.php";
         if (file_exists($Path)) {
             $Paths[] = $Path;
         }
         Gdn::ApplicationManager()->RegisterPermissions($Key, $this->Validation);
     }
     // Execute the structures.
     $Database = Gdn::database();
     $SQL = Gdn::sql();
     $Structure = Gdn::structure();
     foreach ($Paths as $Path) {
         include $Path;
     }
     // Execute the structures for all of the plugins.
     $PluginManager = Gdn::pluginManager();
     $Registered = $PluginManager->RegisteredPlugins();
     foreach ($Registered as $ClassName => $Enabled) {
         if (!$Enabled) {
             continue;
         }
         try {
             $Plugin = $PluginManager->GetPluginInstance($ClassName, Gdn_PluginManager::ACCESS_CLASSNAME);
             if (method_exists($Plugin, 'Structure')) {
                 trace("{$ClassName}->Structure()");
                 $Plugin->Structure();
             }
         } catch (Exception $Ex) {
             // Do nothing, plugin wouldn't load/structure.
             if (Debug()) {
                 throw $Ex;
             }
         }
     }
     $this->fireEvent('AfterStructure');
 }

 /**
  * Gets announced discussions.
  *
  * @since 2.0.0
  * @access public
  *
  * @param array $Wheres SQL conditions.
  * @return object SQL result.
  */
 public function getAnnouncements($Wheres = '')
 {
     $Session = Gdn::session();
     $Limit = Gdn::config('Vanilla.Discussions.PerPage', 50);
     $Offset = 0;
     $UserID = $Session->UserID > 0 ? $Session->UserID : 0;
     $CategoryID = val('d.CategoryID', $Wheres, 0);
     $GroupID = val('d.GroupID', $Wheres, 0);
     // Get the discussion IDs of the announcements.
     $CacheKey = $this->GetAnnouncementCacheKey($CategoryID);
     if ($GroupID == 0) {
         $this->SQL->Cache($CacheKey);
     }
     $this->SQL->select('d.DiscussionID')->from('Discussion d');
     if (!is_array($CategoryID) && ($CategoryID > 0 || $GroupID > 0)) {
         $this->SQL->where('d.Announce >', '0');
     } else {
         $this->SQL->where('d.Announce', 1);
     }
     if ($GroupID > 0) {
         $this->SQL->where('d.GroupID', $GroupID);
     } elseif (is_array($CategoryID) || $CategoryID > 0) {
         $this->SQL->where('d.CategoryID', $CategoryID);
     }
     $AnnouncementIDs = $this->SQL->get()->resultArray();
     $AnnouncementIDs = consolidateArrayValuesByKey($AnnouncementIDs, 'DiscussionID');
     // Short circuit querying when there are no announcements.
     if (count($AnnouncementIDs) == 0) {
         return new Gdn_DataSet();
     }
     $this->DiscussionSummaryQuery(array(), false);
     if (!empty($Wheres)) {
         $this->SQL->where($Wheres);
     }
     if ($UserID) {
         $this->SQL->select('w.UserID', '', 'WatchUserID')->select('w.DateLastViewed, w.Dismissed, w.Bookmarked')->select('w.CountComments', '', 'CountCommentWatch')->select('w.Participated')->join('UserDiscussion w', 'd.DiscussionID = w.DiscussionID and w.UserID = ' . $UserID, 'left');
     } else {
         // Don't join in the user table when we are a guest.
         $this->SQL->select('null as WatchUserID, null as DateLastViewed, null as Dismissed, null as Bookmarked, null as CountCommentWatch');
     }
     // Add conditions passed.
     //      if (is_array($Wheres))
     //         $this->SQL->where($Wheres);
     //
     //      $this->SQL
     //         ->where('d.Announce', '1');
     $this->SQL->whereIn('d.DiscussionID', $AnnouncementIDs);
     // If we aren't viewing announcements in a category then only show global announcements.
     if (!$Wheres || is_array($CategoryID)) {
         $this->SQL->where('d.Announce', 1);
     } else {
         $this->SQL->where('d.Announce >', 0);
     }
     // If we allow users to dismiss discussions, skip ones this user dismissed
     if (c('Vanilla.Discussions.Dismiss', 1) && $UserID) {
         $this->SQL->where('coalesce(w.Dismissed, \'0\')', '0', false);
     }
     $this->SQL->orderBy(self::GetSortField(), 'desc')->limit($Limit, $Offset);
     $Data = $this->SQL->get();
     // Save the announcements that were fetched for later removal.
     $AnnouncementIDs = array();
     foreach ($Data as $Row) {
         $AnnouncementIDs[] = val('DiscussionID', $Row);
     }
     $this->_AnnouncementIDs = $AnnouncementIDs;
     $this->AddDiscussionColumns($Data);
     if (c('Vanilla.Views.Denormalize', false)) {
         $this->AddDenormalizedViews($Data);
     }
     Gdn::userModel()->joinUsers($Data, array('FirstUserID', 'LastUserID'));
     CategoryModel::JoinCategories($Data);
     // Prep and fire event
     $this->EventArguments['Data'] = $Data;
     $this->fireEvent('AfterAddColumns');
     return $Data;
 }

<?php

if (!defined('APPLICATION')) {
    exit;
}
require_once $this->fetchViewLocation('helper_functions');
$Tutorials = GetTutorials();
// Figure out the current video
$CurrentTutorialCode = $this->data('CurrentTutorial');
$Keys = consolidateArrayValuesByKey($Tutorials, 'Code');
$Index = array_search($CurrentTutorialCode, $Keys);
if (!$Index) {
    $Index = 0;
}
$CurrentTutorial = val($Index, $Tutorials);
$CurrentTutorialCode = val('Code', $CurrentTutorial, '');
?>
<style type="text/css">
    div.Tutorials {
        padding: 20px;
    }

    .Video {
        margin-right: 20px;
        float: left;
    }

    .VideoInfo {
        min-height: 420px;
    }

 /**
  * Show all categories and few discussions from each.
  *
  * @param string $Category The url code of the parent category.
  * @since 2.0.0
  * @access public
  */
 public function discussions($Category = '')
 {
     // Setup head
     $this->addJsFile('discussions.js');
     $this->Menu->highlightRoute('/discussions');
     if (!$this->title()) {
         $Title = c('Garden.HomepageTitle');
         if ($Title) {
             $this->title($Title, '');
         } else {
             $this->title(t('All Categories'));
         }
     }
     if (!$Category) {
         $this->Description(c('Garden.Description', null));
     }
     Gdn_Theme::section('CategoryDiscussionList');
     // Set the category follow toggle before we load category data so that it affects the category query appropriately.
     $CategoryFollowToggleModule = new CategoryFollowToggleModule($this);
     $CategoryFollowToggleModule->SetToggle();
     $this->CategoryModel->Watching = !Gdn::session()->GetPreference('ShowAllCategories');
     if ($Category) {
         $Subtree = CategoryModel::GetSubtree($Category, false);
         $CategoryIDs = consolidateArrayValuesByKey($Subtree, 'CategoryID');
         $Categories = $this->CategoryModel->GetFull($CategoryIDs)->resultArray();
     } else {
         $Categories = $this->CategoryModel->GetFull()->resultArray();
     }
     $this->setData('Categories', $Categories);
     // Get category data and discussions
     $this->DiscussionsPerCategory = c('Vanilla.Discussions.PerCategory', 5);
     $DiscussionModel = new DiscussionModel();
     $this->CategoryDiscussionData = array();
     foreach ($this->CategoryData->result() as $Category) {
         if ($Category->CategoryID > 0) {
             $this->CategoryDiscussionData[$Category->CategoryID] = $DiscussionModel->get(0, $this->DiscussionsPerCategory, array('d.CategoryID' => $Category->CategoryID, 'Announce' => 'all'));
         }
     }
     // Add modules
     $this->addModule('NewDiscussionModule');
     $this->addModule('DiscussionFilterModule');
     $this->addModule('CategoriesModule');
     $this->addModule('BookmarkedModule');
     $this->addModule($CategoryFollowToggleModule);
     // Set view and render
     $this->View = 'discussions';
     $this->canonicalUrl(url('/categories', true));
     $Path = $this->fetchViewLocation('helper_functions', 'discussions', false, false);
     if ($Path) {
         include_once $Path;
     }
     // For GetOptions function
     $Path2 = $this->fetchViewLocation('helper_functions', 'categories', false, false);
     if ($Path2) {
         include_once $Path2;
     }
     $this->render();
 }

 public function counts($Column)
 {
     $Result = array('Complete' => true);
     switch ($Column) {
         case 'CountDiscussions':
             $this->Database->query(DBAModel::GetCountSQL('count', 'Category', 'Discussion'));
             break;
         case 'CountComments':
             $this->Database->query(DBAModel::GetCountSQL('sum', 'Category', 'Discussion', $Column, 'CountComments'));
             break;
         case 'LastDiscussionID':
             $this->Database->query(DBAModel::GetCountSQL('max', 'Category', 'Discussion'));
             break;
         case 'LastCommentID':
             $Data = $this->SQL->select('d.CategoryID')->select('c.CommentID', 'max', 'LastCommentID')->select('d.DiscussionID', 'max', 'LastDiscussionID')->select('c.DateInserted', 'max', 'DateLastComment')->select('d.DateInserted', 'max', 'DateLastDiscussion')->from('Comment c')->join('Discussion d', 'd.DiscussionID = c.DiscussionID')->groupBy('d.CategoryID')->get()->resultArray();
             // Now we have to grab the discussions associated with these comments.
             $CommentIDs = consolidateArrayValuesByKey($Data, 'LastCommentID');
             // Grab the discussions for the comments.
             $this->SQL->select('c.CommentID, c.DiscussionID')->from('Comment c')->whereIn('c.CommentID', $CommentIDs);
             $Discussions = $this->SQL->get()->resultArray();
             $Discussions = Gdn_DataSet::Index($Discussions, array('CommentID'));
             foreach ($Data as $Row) {
                 $CategoryID = (int) $Row['CategoryID'];
                 $Category = CategoryModel::categories($CategoryID);
                 $CommentID = $Row['LastCommentID'];
                 $DiscussionID = valr("{$CommentID}.DiscussionID", $Discussions, null);
                 $DateLastComment = Gdn_Format::toTimestamp($Row['DateLastComment']);
                 $DateLastDiscussion = Gdn_Format::toTimestamp($Row['DateLastDiscussion']);
                 $Set = array('LastCommentID' => $CommentID);
                 if ($DiscussionID) {
                     $LastDiscussionID = val('LastDiscussionID', $Category);
                     if ($DateLastComment >= $DateLastDiscussion) {
                         // The most recent discussion is from this comment.
                         $Set['LastDiscussionID'] = $DiscussionID;
                     } else {
                         // The most recent discussion has no comments.
                         $Set['LastCommentID'] = null;
                     }
                 } else {
                     // Something went wrong.
                     $Set['LastCommentID'] = null;
                     $Set['LastDiscussionID'] = null;
                 }
                 $this->setField($CategoryID, $Set);
             }
             break;
         case 'LastDateInserted':
             $Categories = $this->SQL->select('ca.CategoryID')->select('d.DateInserted', '', 'DateLastDiscussion')->select('c.DateInserted', '', 'DateLastComment')->from('Category ca')->join('Discussion d', 'd.DiscussionID = ca.LastDiscussionID')->join('Comment c', 'c.CommentID = ca.LastCommentID')->get()->resultArray();
             foreach ($Categories as $Category) {
                 $DateLastDiscussion = val('DateLastDiscussion', $Category);
                 $DateLastComment = val('DateLastComment', $Category);
                 $MaxDate = $DateLastComment;
                 if (is_null($DateLastComment) || $DateLastDiscussion > $MaxDate) {
                     $MaxDate = $DateLastDiscussion;
                 }
                 if (is_null($MaxDate)) {
                     continue;
                 }
                 $CategoryID = (int) $Category['CategoryID'];
                 $this->setField($CategoryID, 'LastDateInserted', $MaxDate);
             }
             break;
     }
     self::ClearCache();
     return $Result;
 }

 /**
  *
  *
  * @param $UserID
  * @param $RoleIDs
  * @param $RecordEvent
  */
 public function saveRoles($UserID, $RoleIDs, $RecordEvent)
 {
     if (is_string($RoleIDs) && !is_numeric($RoleIDs)) {
         // The $RoleIDs are a comma delimited list of role names.
         $RoleNames = array_map('trim', explode(',', $RoleIDs));
         $RoleIDs = $this->SQL->select('r.RoleID')->from('Role r')->whereIn('r.Name', $RoleNames)->get()->resultArray();
         $RoleIDs = consolidateArrayValuesByKey($RoleIDs, 'RoleID');
     }
     if (!is_array($RoleIDs)) {
         $RoleIDs = array($RoleIDs);
     }
     // Get the current roles.
     $OldRoleIDs = array();
     $OldRoleData = $this->SQL->select('ur.RoleID, r.Name')->from('Role r')->join('UserRole ur', 'r.RoleID = ur.RoleID')->where('ur.UserID', $UserID)->get()->resultArray();
     if ($OldRoleData !== false) {
         $OldRoleIDs = consolidateArrayValuesByKey($OldRoleData, 'RoleID');
     }
     // 1a) Figure out which roles to delete.
     $DeleteRoleIDs = array_diff($OldRoleIDs, $RoleIDs);
     // 1b) Remove old role associations for this user.
     if (count($DeleteRoleIDs) > 0) {
         $this->SQL->whereIn('RoleID', $DeleteRoleIDs)->delete('UserRole', array('UserID' => $UserID));
     }
     // 2a) Figure out which roles to insert.
     $InsertRoleIDs = array_diff($RoleIDs, $OldRoleIDs);
     // 2b) Insert the new role associations for this user.
     foreach ($InsertRoleIDs as $InsertRoleID) {
         if (is_numeric($InsertRoleID)) {
             $this->SQL->insert('UserRole', array('UserID' => $UserID, 'RoleID' => $InsertRoleID));
         }
     }
     $this->clearCache($UserID, array('roles', 'permissions'));
     if ($RecordEvent && (count($DeleteRoleIDs) > 0 || count($InsertRoleIDs) > 0)) {
         $User = $this->getID($UserID);
         $Session = Gdn::session();
         $OldRoles = false;
         if ($OldRoleData !== false) {
             $OldRoles = consolidateArrayValuesByKey($OldRoleData, 'Name');
         }
         $NewRoles = false;
         $NewRoleData = $this->SQL->select('r.RoleID, r.Name')->from('Role r')->join('UserRole ur', 'r.RoleID = ur.RoleID')->where('ur.UserID', $UserID)->get()->resultArray();
         if ($NewRoleData !== false) {
             $NewRoles = consolidateArrayValuesByKey($NewRoleData, 'Name');
         }
         $RemovedRoles = array_diff($OldRoles, $NewRoles);
         $NewRoles = array_diff($NewRoles, $OldRoles);
         foreach ($RemovedRoles as $RoleName) {
             Logger::event('role_remove', Logger::INFO, "{username} removed {toUsername} from the {role} role.", array('toUsername' => $User->Name, 'role' => $RoleName));
         }
         foreach ($NewRoles as $RoleName) {
             Logger::event('role_add', Logger::INFO, "{username} added {toUsername} to the {role} role.", array('toUsername' => $User->Name, 'role' => $RoleName));
         }
         $RemovedCount = count($RemovedRoles);
         $NewCount = count($NewRoles);
         $Story = '';
         if ($RemovedCount > 0 && $NewCount > 0) {
             $Story = sprintf(t('%1$s was removed from the %2$s %3$s and added to the %4$s %5$s.'), $User->Name, implode(', ', $RemovedRoles), plural($RemovedCount, 'role', 'roles'), implode(', ', $NewRoles), plural($NewCount, 'role', 'roles'));
         } elseif ($RemovedCount > 0) {
             $Story = sprintf(t('%1$s was removed from the %2$s %3$s.'), $User->Name, implode(', ', $RemovedRoles), plural($RemovedCount, 'role', 'roles'));
         } elseif ($NewCount > 0) {
             $Story = sprintf(t('%1$s was added to the %2$s %3$s.'), $User->Name, implode(', ', $NewRoles), plural($NewCount, 'role', 'roles'));
         }
     }
 }

 /**
  *
  *
  * @param $Users
  * @param string $UserIDColumn
  * @param string $RolesColumn
  */
 public static function setUserRoles(&$Users, $UserIDColumn = 'UserID', $RolesColumn = 'Roles')
 {
     $UserIDs = array_unique(ConsolidateArrayValuesByKey($Users, $UserIDColumn));
     // Try and get all of the mappings from the cache.
     $Keys = array();
     foreach ($UserIDs as $UserID) {
         $Keys[$UserID] = formatString(UserModel::USERROLES_KEY, array('UserID' => $UserID));
     }
     $UserRoles = Gdn::cache()->get($Keys);
     if (!is_array($UserRoles)) {
         $UserRoles = array();
     }
     // Grab all of the data that doesn't exist from the DB.
     $MissingIDs = array();
     foreach ($Keys as $UserID => $Key) {
         if (!array_key_exists($Key, $UserRoles)) {
             $MissingIDs[$UserID] = $Key;
         }
     }
     if (count($MissingIDs) > 0) {
         $DbUserRoles = Gdn::sql()->select('ur.*')->from('UserRole ur')->whereIn('ur.UserID', array_keys($MissingIDs))->get()->resultArray();
         $DbUserRoles = Gdn_DataSet::Index($DbUserRoles, 'UserID', array('Unique' => false));
         // Store the user role mappings.
         foreach ($DbUserRoles as $UserID => $Rows) {
             $RoleIDs = consolidateArrayValuesByKey($Rows, 'RoleID');
             $Key = $Keys[$UserID];
             Gdn::cache()->store($Key, $RoleIDs);
             $UserRoles[$Key] = $RoleIDs;
         }
     }
     $AllRoles = self::roles();
     // roles indexed by role id.
     // Skip personal info roles
     if (!checkPermission('Garden.PersonalInfo.View')) {
         $AllRoles = array_filter($AllRoles, 'self::FilterPersonalInfo');
     }
     // Join the users.
     foreach ($Users as &$User) {
         $UserID = val($UserIDColumn, $User);
         $Key = $Keys[$UserID];
         $RoleIDs = val($Key, $UserRoles, array());
         $Roles = array();
         foreach ($RoleIDs as $RoleID) {
             if (!array_key_exists($RoleID, $AllRoles)) {
                 continue;
             }
             $Roles[$RoleID] = $AllRoles[$RoleID]['Name'];
         }
         setValue($RolesColumn, $User, $Roles);
     }
 }

 /**
  * Retrieves UserMeta information for a UserID / Key pair.
  *
  * This method takes a $UserID or array of $UserIDs, and a $Key. It converts the
  * $Key to fully qualified format and then queries for the associated value(s). $Key
  * can contain SQL wildcards, in which case multiple results can be returned.
  *
  * If $UserID is an array, the return value will be a multi dimensional array with the first
  * axis containing UserIDs and the second containing fully qualified UserMetaKeys, associated with
  * their values.
  *
  * If $UserID is a scalar, the return value will be a single dimensional array of $UserMetaKey => $Value
  * pairs.
  *
  * @param $UserID integer UserID or array of UserIDs
  * @param $Key string relative user meta key
  * @param $Default optional default return value if key is not found
  * @return array results or $Default
  */
 public function getUserMeta($UserID, $Key = null, $Default = null)
 {
     if (Gdn::cache()->activeEnabled()) {
         if (is_array($UserID)) {
             $Result = array();
             foreach ($UserID as $ID) {
                 $Meta = $this->GetUserMeta($ID, $Key, $Default);
                 $Result[$ID] = $Meta;
             }
             return $Result;
         }
         // Try and grab the user meta from the cache.
         $CacheKey = 'UserMeta_' . $UserID;
         $UserMeta = Gdn::cache()->get($CacheKey);
         if ($UserMeta === Gdn_Cache::CACHEOP_FAILURE) {
             $UserMeta = $this->getWhere(array('UserID' => $UserID), 'Name')->resultArray();
             $UserMeta = consolidateArrayValuesByKey($UserMeta, 'Name', 'Value');
             Gdn::cache()->store($CacheKey, $UserMeta);
         }
         if ($Key === null) {
             return $UserMeta;
         }
         if (strpos($Key, '%') === false) {
             $Result = val($Key, $UserMeta, $Default);
             return array($Key => $Result);
         }
         $Regex = '`' . str_replace('%', '.*', preg_quote($Key)) . '`i';
         $Result = array();
         foreach ($UserMeta as $Name => $Value) {
             if (preg_match($Regex, $Name)) {
                 $Result[$Name] = $Value;
             }
         }
         return $Result;
     }
     $Sql = clone Gdn::sql();
     $Sql->reset();
     $UserMetaQuery = $Sql->select('*')->from('UserMeta u');
     if (is_array($UserID)) {
         $UserMetaQuery->whereIn('u.UserID', $UserID);
     } else {
         $UserMetaQuery->where('u.UserID', $UserID);
     }
     if (stristr($Key, '%')) {
         $UserMetaQuery->where('u.Name like', $Key);
     } else {
         $UserMetaQuery->where('u.Name', $Key);
     }
     $UserMetaData = $UserMetaQuery->get();
     $UserMeta = array();
     if ($UserMetaData->numRows()) {
         if (is_array($UserID)) {
             while ($MetaRow = $UserMetaData->NextRow()) {
                 $UserMeta[$MetaRow->UserID][$MetaRow->Name] = $MetaRow->Value;
             }
         } else {
             while ($MetaRow = $UserMetaData->NextRow()) {
                 $UserMeta[$MetaRow->Name] = $MetaRow->Value;
             }
         }
     } else {
         self::$MemoryCache[$Key] = $Default;
         $UserMeta[$Key] = $Default;
     }
     unset($UserMetaData);
     return $UserMeta;
 }

 /**
  * Select content based on author RankID.
  *
  * @param array|int $Parameters
  * @return array|false
  */
 protected function selectByRank($Parameters)
 {
     // Must have Ranks enabled.
     if (!class_exists('RankModel')) {
         return false;
     }
     if (!is_array($Parameters)) {
         $RankID = $Parameters;
     } else {
         $RankID = val('RankID', $Parameters, null);
     }
     // Check for Rank passed by name.
     if (!is_numeric($RankID)) {
         $RankModel = new RankModel();
         $Rank = $RankModel->getWhere(array('Name' => $RankID))->firstRow();
         $RankID = val('RankID', $Rank);
     }
     // Disallow blank or multiple ranks.
     if (!$RankID || is_array($RankID)) {
         return false;
     }
     // Check cache
     $SelectorRankCacheKey = "modules.promotedcontent.rank.{$RankID}";
     $Content = Gdn::cache()->get($SelectorRankCacheKey);
     if ($Content == Gdn_Cache::CACHEOP_FAILURE) {
         // Get everyone with this Role
         $UserIDs = Gdn::sql()->select('u.UserID')->from('User u')->where('u.RankID', $RankID)->groupBy('UserID')->get()->result(DATASET_TYPE_ARRAY);
         $UserIDs = consolidateArrayValuesByKey($UserIDs, 'UserID');
         // Get matching Discussions
         $Discussions = array();
         if ($this->ShowDiscussions()) {
             $Discussions = Gdn::sql()->select('d.*')->from('Discussion d')->whereIn('d.InsertUserID', $UserIDs)->orderBy('DateInserted', 'DESC')->limit($this->Limit)->get()->result(DATASET_TYPE_ARRAY);
         }
         // Get matching Comments
         $Comments = array();
         if ($this->ShowComments()) {
             $Comments = Gdn::sql()->select('c.*')->from('Comment c')->whereIn('InsertUserID', $UserIDs)->orderBy('DateInserted', 'DESC')->limit($this->Limit)->get()->result(DATASET_TYPE_ARRAY);
             $this->JoinCategory($Comments);
         }
         // Interleave
         $Content = $this->Union('DateInserted', array('Discussion' => $Discussions, 'Comment' => $Comments));
         $this->processContent($Content);
         // Add result to cache
         Gdn::cache()->store($SelectorRankCacheKey, $Content, array(Gdn_Cache::FEATURE_EXPIRY => $this->Expiry));
     }
     $this->Security($Content);
     $this->Condense($Content, $this->Limit);
     return $Content;
 }

 /**
  *
  *
  * @param Gdn_SQLDriver $Sql
  */
 public function setTagSql($Sql, $Tag, &$Limit, &$Offset = 0, $Op = 'or')
 {
     $SortField = 'd.DateLastComment';
     $SortDirection = 'desc';
     $TagSql = clone Gdn::sql();
     if ($DateFrom = Gdn::request()->get('DateFrom')) {
         // Find the discussion ID of the first discussion created on or after the date from.
         $DiscussionIDFrom = $TagSql->getWhere('Discussion', array('DateInserted >= ' => $DateFrom), 'DiscussionID', 'asc', 1)->value('DiscussionID');
         $SortField = 'd.DiscussionID';
     }
     if (!is_array($Tag)) {
         $Tags = array_map('trim', explode(',', $Tag));
     }
     $TagIDs = $TagSql->select('TagID')->from('Tag')->whereIn('Name', $Tags)->get()->resultArray();
     $TagIDs = consolidateArrayValuesByKey($TagIDs, 'TagID');
     if ($Op == 'and' && count($Tags) > 1) {
         $DiscussionIDs = $TagSql->select('DiscussionID')->select('TagID', 'count', 'CountTags')->from('TagDiscussion')->whereIn('TagID', $TagIDs)->groupBy('DiscussionID')->having('CountTags >=', count($Tags))->limit($Limit, $Offset)->orderBy('DiscussionID', 'desc')->get()->resultArray();
         $Limit = '';
         $Offset = 0;
         $DiscussionIDs = consolidateArrayValuesByKey($DiscussionIDs, 'DiscussionID');
         $Sql->whereIn('d.DiscussionID', $DiscussionIDs);
         $SortField = 'd.DiscussionID';
     } else {
         $Sql->join('TagDiscussion td', 'd.DiscussionID = td.DiscussionID')->limit($Limit, $Offset)->whereIn('td.TagID', $TagIDs);
         if ($Op == 'and') {
             $SortField = 'd.DiscussionID';
         }
     }
     // Set up the sort field and direction.
     saveToConfig(array('Vanilla.Discussions.SortField' => $SortField, 'Vanilla.Discussions.SortDirection' => $SortDirection), '', false);
 }

<?php

if (!defined('APPLICATION')) {
    exit;
}
?>
    <h1><?php 
echo $this->data('Title');
?>
</h1>
<?php 
echo $this->Form->open();
echo $this->Form->errors();
$Discussions = $this->data('Discussions');
if (count($Discussions) < 2) {
    echo wrap(t('You have to select at least 2 discussions to merge.'), 'p');
} else {
    echo wrap(t('Choose the main discussion into which all comments will be merged:'), 'p');
    $DefaultDiscussionID = $Discussions[0]['DiscussionID'];
    $RadioData = consolidateArrayValuesByKey($Discussions, 'DiscussionID', 'Name');
    array_map('htmlspecialchars', $RadioData);
    echo '<ul><li>';
    echo $this->Form->RadioList('MergeDiscussionID', $RadioData, array('ValueField' => 'DiscussionID', 'TextField' => 'Name', 'Default' => $DefaultDiscussionID));
    echo '</li></ul>';
    echo '<div class="P">' . $this->Form->checkBox('RedirectLink', 'Leave a redirect links from the old discussions.') . '</div>';
    echo '<div class="Buttons">' . $this->Form->button('Merge') . '</div>';
}
echo $this->Form->close();

            <dd class="LastActive"><?php 
    echo Gdn_Format::date($this->User->DateLastActive, 'html');
    ?>
</dd>
            <dt class="Roles"><?php 
    echo t('Roles');
    ?>
</dt>
            <dd class="Roles"><?php 
    if (Gdn::session()->checkPermission('Garden.Moderation.Manage')) {
        echo UserVerified($this->User) . ', ';
    }
    if (empty($this->Roles)) {
        echo t('No Roles');
    } else {
        echo htmlspecialchars(implode(', ', consolidateArrayValuesByKey($this->Roles, 'Name')));
    }
    ?>
</dd>
            <?php 
    if ($Points = valr('User.Points', $this, 0)) {
        // Only show positive point totals
        ?>
                <dt class="Points"><?php 
        echo t('Points');
        ?>
</dt>
                <dd class="Points"><?php 
        echo number_format($Points);
        ?>
</dd>