13if (!defined(
'XOOPS_ROOT_PATH')) {
16function smarty_function_message_userlist($params, &$smarty)
18 $name = isset($params[
'name']) ? trim($params[
'name']) :
'uname';
19 $username = isset($params[
'uname']) ? trim($params[
'uname']) :
'';
20 $buid = isset($params[
'uid']) ? true :
false;
21 $id = isset($params[
'id']) ? trim($params[
'id']) :
'user-select';
22 $placeholder = isset($params[
'placeholder']) ? trim($params[
'placeholder']) :
'Select a user';
24 $root = XCube_Root::getSingleton();
25 $db = $root->mController->getDB();
29 $sql =
'SELECT `uname`, `uid` FROM `' . $db->prefix(
'users') .
'` ';
30 $sql.=
'WHERE `uid` <> ' . $root->mContext->mXoopsUser->get(
'uid') .
' ';
31 $sql.=
'ORDER BY `uname`';
32 $result = $db->query($sql);
33 while ([$uname, $uid] = $db->fetchRow($result)) {
36 'uname' => htmlspecialchars($uname, ENT_QUOTES)
41 $html =
'<select name="'.$name.
'" id="'.$id.
'" class="user-select">';
42 $html .=
'<option value="">'.$placeholder.
'</option>';
44 foreach ($users as $user) {
45 $value = $buid ? $user[
'uid'] : $user[
'uname'];
46 $selected = ((
false == $buid && $user[
'uname'] == $username) ||
47 ($buid && $user[
'uid'] == $username)) ?
' selected="selected"' :
'';
48 $html .=
'<option value="'.$value.
'"'.$selected.
'>'.$user[
'uname'].
'</option>';
58 border: 1px solid #212121;
60 box-sizing: border-box;