- Модуль: forum
- Путь к файлу: ~/bitrix/modules/forum/classes/general/user.php
- Класс: CAllForumUser
- Вызов: CAllForumUser::SearchUser
static function SearchUser($template)
{
global $DB;
$template = $DB->ForSql(str_replace("*", "%", $template));
$strSql =
"SELECT U.ID, U.NAME, U.LAST_NAME, U.LOGIN, F.SHOW_NAME ".
"FROM b_forum_user F LEFT JOIN b_user U ON(F.USER_ID = U.ID)".
"WHERE ((F.SHOW_NAME='Y')AND(U.NAME LIKE '".$template."' OR U.LAST_NAME LIKE '".$template."')) OR(( U.LOGIN LIKE '".$template."')AND(F.SHOW_NAME='N'))";
$dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
return $dbRes;
}