- <dt><label for="msn">{L_UCP_MSNM}{L_COLON}</label></dt>

- <dd><input type="text" id="msn" name="msn" value="{MSN}" /></dd>

- </dl>

- <dl>

- $msn = 0;

- $sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmilies, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey)

- VALUES ($new_user_id, '$username', " . time() . ", '$password', '$email', '$icq', '$website', '$occupation', '$location', '$interests', '$signature', '$signature_bbcode_uid', '$avatar_filename', $viewemail, '$aim', '$yim', '$msn', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $user_timezone, '$user_dateformat', '$user_lang', $user_style, 0, 1, ";

- 'user_msnm' => array('VCHAR_UNI', ''),

- 'user_msnm' => array('VCHAR_UNI', ''),

- 'msn' => request_var('msn', $user_row['user_msnm']),

- 'msn' => array('string', true, 5, 255),

- 'user_msnm' => $data['msn'],

- 'MSN' => $data['msn'],

- 'U_MSN' => ($user_info['user_msnm'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&amp;action=msnm&amp;u=' . $author_id) : '',

- 'msn' => request_var('msn', $user->data['user_msnm']),

- 'msn' => array('string', true, 5, 255),

- 'user_msnm' => $data['msn'],

- 'MSN' => $data['msn'],

- array('user_msnm', 'users.user_msnm', array('function1' => 'phpbb_set_encoding')),

- user_msnm VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

- [user_msnm] [varchar] (255) DEFAULT ('') NOT NULL ,

- user_msnm blob NOT NULL,

- user_msnm varchar(255) DEFAULT '' NOT NULL,

- user_msnm varchar2(765) DEFAULT '' ,

- user_msnm varchar(255) DEFAULT '' NOT NULL,

-INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd, user_allow_massemail) VALUES (2, 1, 'Anonymous', 'anonymous', 0, '', '', 'en', 1, 0, '', 0, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0);

-INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin', 'admin', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

- user_msnm varchar(255) NOT NULL DEFAULT '',

- 'IMG_ICON_CONTACT_MSNM' => 'WLM',

- 'MSNM' => 'WLM',

- 'TOO_LONG_MSN' => 'The WLM name you entered is too long.',

- 'TOO_SHORT_MSN' => 'The WLM name you entered is too short.',

- 'IM_MSNM' => 'Please note that you need Windows Live Messenger installed to use this.',

- 'IM_MSNM_BROWSER' => 'Your browser does not support this.',

- 'IM_MSNM_CONNECT' => 'WLM is not connected.\nYou have to connect to WLM to continue.',

- 'SEND_MSNM_MESSAGE' => 'Send WLM message',

- 'UCP_MSNM' => 'Windows Live Messenger',

- case 'msnm':

- $lang = 'MSNM';

- $sql_field = 'user_msnm';

- $s_select = 'S_SEND_MSNM';

- $s_action = '';

- break;

-

- 'MSN_IMG' => $user->img('icon_contact_msnm', $user->lang['MSNM']),

- $sort_key_text = array('a' => $user->lang['SORT_USERNAME'], 'b' => $user->lang['SORT_LOCATION'], 'c' => $user->lang['SORT_JOINED'], 'd' => $user->lang['SORT_POST_COUNT'], 'f' => $user->lang['WEBSITE'], 'g' => $user->lang['ICQ'], 'h' => $user->lang['AIM'], 'i' => $user->lang['MSNM'], 'j' => $user->lang['YIM'], 'k' => $user->lang['JABBER']);

- $sort_key_sql = array('a' => 'u.username_clean', 'b' => 'u.user_from', 'c' => 'u.user_regdate', 'd' => 'u.user_posts', 'f' => 'u.user_website', 'g' => 'u.user_icq', 'h' => 'u.user_aim', 'i' => 'u.user_msnm', 'j' => 'u.user_yim', 'k' => 'u.user_jabber');

- $search_params = array('username', 'email', 'icq', 'aim', 'yahoo', 'msn', 'jabber', 'search_group_id', 'joined_select', 'active_select', 'count_select', 'joined', 'active', 'count', 'ip');

- $msn = request_var('msn', '');

- $sql_where .= ($msn) ? ' AND u.user_msnm ' . $db->sql_like_expression(str_replace('*', $db->any_char, $msn)) . ' ' : '';

- 'msn' => array('msn', ''),

- 'MSNM' => $msn,

- 'MSN_IMG' => $user->img('icon_contact_msnm', $user->lang['MSNM']),

- 'U_SORT_MSN' => $sort_url . '&amp;sk=i&amp;sd=' . (($sort_key == 'i' && $sort_dir == 'a') ? 'd' : 'a'),

- 'U_MSN' => ($data['user_msnm'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&amp;action=msnm&amp;u=' . $user_id) : '',

- 'USER_MSN' => $data['user_msnm'],

-<!-- MSNM info from http://www.cdolive.net/ - doesn't seem to work with MSN Messenger -->

- <dd><strong>{USERNAME}</strong><!-- IF S_SEND_ICQ or S_SEND_AIM or S_SEND_MSNM or S_NO_SEND_JABBER --> [ {IM_CONTACT} ]<!-- ENDIF --><!-- IF PRESENCE_IMG --> {PRESENCE_IMG}<!-- ENDIF --></dd>

- <!-- IF S_SEND_MSNM -->

- <dl class="fields2">

- <dt>&nbsp;</dt>

- <dd><object classid="clsid:B69003B3-C55E-4B48-836C-BC5946FC3B28" codetype="application/x-oleobject" id="objMessengerApp" width="0" height="0"></object></dd>

- <dd><a href="#" onclick="add_contact('{A_IM_CONTACT}'); return false;">{L_IM_ADD_CONTACT}</a></dd>

- <dd><a href="#" onclick="im_contact('{A_IM_CONTACT}'); return false;">{L_IM_SEND_MESSAGE}</a></dd>

- </dl>

- <!-- ENDIF -->

-

-<script type="text/javascript">

-// <![CDATA[

-

- /** The following will not work with Windows Vista **/

-

- var app = document.getElementById('objMessengerApp');

-

- /**

- * Check whether the browser supports this and whether MSNM is connected

- */

- function msn_supported()

- {

- // Does the browser support the MSNM object?

- if (app.MyStatus)

- {

- // Is MSNM connected?

- if (app.MyStatus == 1)

- {

- alert('{LA_IM_MSNM_CONNECT}');

- return false;

- }

- }

- else

- {

- alert('{LA_IM_MSNM_BROWSER}');

- return false;

- }

- return true;

- }

-

- /**

- * Add to your contact list

- */

- function add_contact(address)

- {

- if (msn_supported())

- {

- // Could return an error while MSNM is connecting, don't want that

- try

- {

- app.AddContact(0, address);

- }

- catch (e)

- {

- return;

- }

- }

-}

-

-/**

-* Write IM to contact

-*/

-function im_contact(address)

-{

- if (msn_supported())

- {

- // Could return an error while MSNM is connecting, don't want that

- try

- {

- app.InstantMessage(address);

- }

- catch (e)

- {

- return;

- }

- }

-}

-// ]]>

-</script>

-

- <dl>

- <dt><label for="msn">{L_MSNM}{L_COLON}</label></dt>

- <dd><input type="text" name="msn" id="msn" value="{MSNM}" class="inputbox" /></dd>

- </dl>

- <!-- IF U_MSN or USER_MSN --><dt>{L_MSNM}{L_COLON}</dt> <dd><!-- IF U_MSN --><a href="{U_MSN}" onclick="popup(this.href, 550, 320); return false;">{L_SEND_MSNM_MESSAGE}</a><!-- ELSE -->{USER_MSN}<!-- ENDIF --></dd><!-- ENDIF -->

- <!-- IF U_PM or U_EMAIL or U_WWW or U_MSN or U_ICQ or U_YIM or U_AIM or U_JABBER -->

- <!-- IF U_MSN --><li class="msnm-icon"><a href="{U_MSN}" onclick="popup(this.href, 550, 320); return false;" title="{L_MSNM}"><span>{L_MSNM}</span></a></li><!-- ENDIF -->

- <dt><label for="msn">{L_UCP_MSNM}{L_COLON}</label></dt>

- <dd><input type="text" name="msn" id="msn" maxlength="255" value="{MSN}" class="inputbox" /></dd>

- </dl>

- <dl>

- <!-- IF postrow.U_PM or postrow.U_EMAIL or postrow.U_WWW or postrow.U_MSN or postrow.U_ICQ or postrow.U_YIM or postrow.U_AIM or postrow.U_JABBER -->

- <!-- IF postrow.U_MSN --><li class="msnm-icon"><a href="{postrow.U_MSN}" onclick="popup(this.href, 550, 320); return false;" title="{L_MSNM}"><span>{L_MSNM}</span></a></li><!-- ENDIF -->

-.rtl .imageset.icon_contact_aim, .rtl .imageset.icon_contact_email, .rtl .imageset.icon_contact_icq, .rtl .imageset.icon_contact_jabber, .rtl .imageset.icon_contact_msnm, .rtl .imageset.icon_contact_www, .rtl .imageset.icon_contact_yahoo, .rtl .imageset.icon_post_delete, .rtl .imageset.icon_post_info, .rtl .imageset.icon_post_report, .rtl .imageset.icon_user_warn {

-.msnm-icon, .msnm-icon a { background: none top left no-repeat; }

-ul.profile-icons li.msnm-icon { width: 20px; height: 20px; }

-.msnm-icon, .msnm-icon a { background-image: url("./images/icon_contact_msnm.gif"); }

-.imageset.icon_contact_msnm {

- background-image: url("./images/icon_contact_msnm.gif");

- padding-left: 20px;

- padding-top: 20px;

-}

-<!-- MSNM info from http://www.cdolive.net/ - doesn't seem to work with MSN Messenger -->

-

- <td class="row2"><span class="gen"><b>{USERNAME}</b><!-- IF S_SEND_ICQ or S_SEND_AIM or S_SEND_MSNM or S_NO_SEND_JABBER --> [ {IM_CONTACT} ]<!-- ENDIF --></span> <!-- IF PRESENCE_IMG -->{PRESENCE_IMG}<!-- ENDIF --></td>

- <!-- IF S_SEND_MSNM -->

- <tr>

- <td class="row1" colspan="2" align="center">

- <object classid="clsid:B69003B3-C55E-4B48-836C-BC5946FC3B28" codetype="application/x-oleobject" id="objMessengerApp" width="0" height="0"></object>

- <script type="text/javascript">

- // <![CDATA[

- var app = document.getElementById('objMessengerApp');

-

- /**

- * Check whether the browser supports this and whether MSNM is connected

- */

- function msn_supported()

- {

- // Does the browser support the MSNM object?

- if (app.MyStatus)

- {

- // Is MSNM connected?

- if (app.MyStatus == 1)

- {

- alert('{LA_IM_MSNM_CONNECT}');

- return false;

- }

- }

- else

- {

- alert('{LA_IM_MSNM_BROWSER}');

- return false;

- }

- return true;

- }

-

- /**

- * Add to your contact list

- */

- function add_contact(address)

- {

- if (msn_supported())

- {

- // Could return an error while MSNM is connecting, don't want that

- try

- {

- app.AddContact(0, address);

- }

- catch (e)

- {

- return;

- }

- }

- }

-

- /**

- * Write IM to contact

- */

- function im_contact(address)

- {

- if (msn_supported())

- {

- // Could return an error while MSNM is connecting, don't want that

- try

- {

- app.InstantMessage(address);

- }

- catch (e)

- {

- return;

- }

- }

- }

- // ]]>

- </script>

-

- <a class="gen" href="#" onclick="add_contact('{A_IM_CONTACT}'); return false;">{L_IM_ADD_CONTACT}</a><br /><a class="gen" href="#" onclick="im_contact('{A_IM_CONTACT}'); return false;">{L_IM_SEND_MESSAGE}</a>

- </td>

- </tr>

- <tr>

- <td class="cat" colspan="2" align="center">&nbsp;</td>

- </tr>

- <!-- ENDIF -->

-

- <td class="row1"><b class="genmed">{L_MSNM}{L_COLON}</b></td>

- <td class="row2"><input class="post" type="text" name="msn" value="{MSNM}" /></td>

- <td class="row1"><b class="genmed">{L_JABBER}{L_COLON}</b></td>

- <td class="row2"><input class="post" type="text" name="jabber" value="{JABBER}" /></td>

- <td class="gen" nowrap="nowrap" align="{S_CONTENT_FLOW_END}">{L_MSNM}{L_COLON} </td>

- <td><!-- IF U_MSN --><a href="{U_MSN}" onclick="popup(this.href, 550, 320); return false" class="imageset">{MSN_IMG}</a><!-- ELSEIF USER_MSN -->{USER_MSN}<!-- ENDIF --></td>

- </tr>

- <tr>

- <td class="row1" width="35%"><b class="genmed">{L_UCP_MSNM}{L_COLON} </b></td>

- <td class="row2"><input class="post" type="text" name="msn" size="30" maxlength="255" value="{MSN}" /></td>

-</tr>

-<tr>

-.imageset.icon_contact_msnm {

- background-image: url("./icon_contact_msnm.gif");

- padding-left: 72px;

- padding-top: 20px;

-}

-.imageset.icon_contact_msnm {

- background-image: url("./en/icon_contact_msnm.gif");

- padding-left: 72px;

- padding-top: 20px;

-}

- 'MSN_IMG' => $user->img('icon_contact_msnm', 'MSNM'),

- 'msn' => '',

- 'msn' => ($row['user_msnm'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=contact&amp;action=msnm&amp;u=$poster_id") : '',

- 'U_MSN' => $user_cache[$poster_id]['msn'],