We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
I have a big problem - Newsfeed Trends Twitter style | Forum
Akash
Feb 17 '15
now the @ autocomplete plug in is only displaying the user name data
i just change the following code
$limitStr = $limit === null ? '' : 'LIMIT 0, ' . intval($limit); if ($questionName == 'realname') { $questionDataTable = BOL_QuestionDataDao::getInstance()->getTableName(); $queryParts = BOL_UserDao::getInstance()->getUserQueryFilter("qd", "userId", array( "method" => "AUTOCOMPLETE_BOL_AjaxService::findUsers" )); $query = 'SELECT DISTINCT qd.userId FROM ' . $questionDataTable . ' qd '.$queryParts['join'].' WHERE '.$queryParts['where'].' AND questionName=:name AND textValue LIKE :kw ORDER BY `textValue` '. $limitStr; return OW::getDbo()->queryForColumnList($query, array( 'kw' => $kw . '%', 'name' => $questionName )); } else if ($questionName == 'username') {
to:
$limitStr = $limit === null ? '' : 'LIMIT 0, ' . intval($limit); if ($questionName == 'realname') { $query = "SELECT DISTINCT id FROM ".OW_DB_PREFIX."base_user WHERE username like :kw ". $limitStr; return OW::getDbo()->queryForColumnList($query, array( 'kw' => $kw . '%' )); } else if ($questionName == 'username') {
and I also changed the following line
from:
displayName' => empty($avatarData[$opponentId]['title']) ? $userNameByUserIdList[$opponentId] : $avatarData[$opponentId]['title'],
to:
displayName' => empty($avatarData[$opponentId]['user']) ? $userNameByUserIdList[$opponentId] : $avatarData[$opponentId]['user'],
You do not have permission to reply this topic
