public function ToString($Results) { $UserIDs = array(); foreach ($Results as $Row) { $UserIDs[] = $Row->{SS_ATTR_USERID}; ///IMPORTANT, this is lowercase since grab results directly from sphinx } // print_r($Return); die; $Sql = clone Gdn::Sql(); $Users = $Sql->Select('Photo, UserID, Name')->From('User')->WhereIn('UserID', $UserIDs)->Get()->ResultObject(); ob_start(); ?> <div id="People" class="Box People"> <h4 class="Header"><?php echo T('People'); ?> </h4> <ul class="PanelInfo PanelDiscussions"> <?php foreach ($Users as $Row) { ?> <li class="Item"> <?php $User = UserBuilder($Row); ?> <?php echo UserPhoto($User); echo UserAnchor($User); ?> </li> <?php } ?> </ul> </div> <?php $String = ob_get_contents(); @ob_end_clean(); return $String; }
/** * * @param Gdn_SQLDriver $Sql */ protected 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'; } $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); }
public function get_user_token_for_user_id($user_id) { // Read the user_id for this login_token $result = Gdn::Sql()->Select('user_token')->From('oasl_user')->Where('user_id', intval($user_id))->Get()->Result(DATASET_TYPE_ARRAY); foreach ($result as $row) { $user_token = GetValue('user_token', $row); if ($user_token !== FALSE) { return $user_token; } } // Not found return FALSE; }