/** * sortUsersByContentInfo * * Sorts $userIdList by $sort * * @param ZEND SQL search query returning array of user id:s * @param string $sort * @return $resultList * @author Jari Korpela */ public function sortUsersByContentInfo($search, $sort, $list, $limit) { $content = new Default_Model_ContentHasUser(); $select = $content->select()->from('cnt_has_usr', array('id_usr'))->where('id_usr IN (?)', $search)->order(array($sort, 'id_usr'))->group('id_usr'); if ($limit) { $select->limit($limit, 0); } //print_r($select->assemble());echo "\n"; $result = $this->simplifyArray($content->_db->fetchAll($select), 'id_usr'); if ($list) { $result = $this->addMissingIdsToResult($result, $this->simplifyArray($content->_db->fetchAll($search), 'id_usr'), $list); } return $result; }