1: <?php
2: 3: 4:
5: if (!defined('XOOPS_ROOT_PATH')) exit();
6: function smarty_function_message_userlist($params, &$smarty)
7: {
8: $name = isset($params['name']) ? trim($params['name']) : 'uname';
9: $username = isset($params['uname']) ? trim($params['uname']) : '';
10: $buid = isset($params['uid']) ? true : false;
11:
12: $root = XCube_Root::getSingleton();
13: $db = $root->mController->getDB();
14:
15: $option = '<option value=""></option>';
16:
17: $sql = "SELECT `uname`, `uid` FROM `".$db->prefix('users')."` ";
18: $sql.= "WHERE `uid` <> ".$root->mContext->mXoopsUser->get('uid'). " ";
19: $sql.= "ORDER BY `uname`";
20: $result = $db->query($sql);
21: while (list($uname, $uid) = $db->fetchRow($result)) {
22: $uname = htmlspecialchars($uname, ENT_QUOTES);
23: $option.= '<option value="';
24: $option.= $buid ? $uid : $uname;
25: if ( ($buid == false && $uname == $username) || ($buid && $uid == $username ) ) {
26: $option.= '" selected="selected';
27: }
28: $option.= '">'.$uname.'</option>'.chr(10);
29: }
30: echo '<select name="'.$name.'">';
31: echo $option;
32: echo '</select>';
33: }
34: ?>
35: