vamp-website: forum/Sources/PersonalMessage.php annotate

annotate forum/Sources/PersonalMessage.php @ 76:e3e11437ecea website

Add forum code

author	Chris Cannam
date	Sun, 07 Jul 2013 11:25:48 +0200
parents
children

rev	line source
Chris@76	1 <?php
Chris@76	2
Chris@76	3 /**
Chris@76	4 * Simple Machines Forum (SMF)
Chris@76	5 *
Chris@76	6 * @package SMF
Chris@76	7 * @author Simple Machines http://www.simplemachines.org
Chris@76	8 * @copyright 2011 Simple Machines
Chris@76	9 * @license http://www.simplemachines.org/about/smf/license.php BSD
Chris@76	10 *
Chris@76	11 * @version 2.0
Chris@76	12 */
Chris@76	13
Chris@76	14 if (!defined('SMF'))
Chris@76	15 die('Hacking attempt...');
Chris@76	16
Chris@76	17 /* This file is mainly meant for viewing personal messages. It also sends,
Chris@76	18 deletes, and marks personal messages. For compatibility reasons, they are
Chris@76	19 often called "instant messages". The following functions are used:
Chris@76	20
Chris@76	21 void MessageMain()
Chris@76	22 // !!! ?action=pm
Chris@76	23
Chris@76	24 void messageIndexBar(string area)
Chris@76	25 // !!!
Chris@76	26
Chris@76	27 void MessageFolder()
Chris@76	28 // !!! ?action=pm;sa=folder
Chris@76	29
Chris@76	30 void prepareMessageContext(type reset = 'subject', bool reset = false)
Chris@76	31 // !!!
Chris@76	32
Chris@76	33 void MessageSearch()
Chris@76	34 // !!!
Chris@76	35
Chris@76	36 void MessageSearch2()
Chris@76	37 // !!!
Chris@76	38
Chris@76	39 void MessagePost()
Chris@76	40 // !!! ?action=pm;sa=post
Chris@76	41
Chris@76	42 void messagePostError(array error_types, array named_recipients, array recipient_ids)
Chris@76	43 // !!!
Chris@76	44
Chris@76	45 void MessagePost2()
Chris@76	46 // !!! ?action=pm;sa=post2
Chris@76	47
Chris@76	48 void WirelessAddBuddy()
Chris@76	49 // !!!
Chris@76	50
Chris@76	51 void MessageActionsApply()
Chris@76	52 // !!! ?action=pm;sa=pmactions
Chris@76	53
Chris@76	54 void MessageKillAllQuery()
Chris@76	55 // !!! ?action=pm;sa=killall
Chris@76	56
Chris@76	57 void MessageKillAll()
Chris@76	58 // !!! ?action=pm;sa=killall2
Chris@76	59
Chris@76	60 void MessagePrune()
Chris@76	61 // !!! ?action=pm;sa=prune
Chris@76	62
Chris@76	63 void deleteMessages(array personal_messages, string folder,
Chris@76	64 int owner = user)
Chris@76	65 // !!!
Chris@76	66
Chris@76	67 void markMessages(array personal_messages = all, int label = all,
Chris@76	68 int owner = user)
Chris@76	69 - marks the specified personal_messages read.
Chris@76	70 - if label is set, only marks messages with that label.
Chris@76	71 - if owner is set, marks messages owned by that member id.
Chris@76	72
Chris@76	73 void ManageLabels()
Chris@76	74 // !!!
Chris@76	75
Chris@76	76 void MessageSettings()
Chris@76	77 // !!!
Chris@76	78
Chris@76	79 void ReportMessage()
Chris@76	80 - allows the user to report a personal message to an administrator.
Chris@76	81 - in the first instance requires that the ID of the message to report
Chris@76	82 is passed through $_GET.
Chris@76	83 - allows the user to report to either a particular administrator - or
Chris@76	84 the whole admin team.
Chris@76	85 - will forward on a copy of the original message without allowing the
Chris@76	86 reporter to make changes.
Chris@76	87 - uses the report_message sub-template.
Chris@76	88
Chris@76	89 void ManageRules()
Chris@76	90 // !!!
Chris@76	91
Chris@76	92 void LoadRules()
Chris@76	93 // !!!
Chris@76	94
Chris@76	95 void ApplyRules()
Chris@76	96 // !!!
Chris@76	97 */
Chris@76	98
Chris@76	99 // This helps organize things...
Chris@76	100 function MessageMain()
Chris@76	101 {
Chris@76	102 global $txt, $scripturl, $sourcedir, $context, $user_info, $user_settings, $smcFunc, $modSettings;
Chris@76	103
Chris@76	104 // No guests!
Chris@76	105 is_not_guest();
Chris@76	106
Chris@76	107 // You're not supposed to be here at all, if you can't even read PMs.
Chris@76	108 isAllowedTo('pm_read');
Chris@76	109
Chris@76	110 // This file contains the basic functions for sending a PM.
Chris@76	111 require_once($sourcedir . '/Subs-Post.php');
Chris@76	112
Chris@76	113 loadLanguage('PersonalMessage');
Chris@76	114
Chris@76	115 if (WIRELESS && WIRELESS_PROTOCOL == 'wap')
Chris@76	116 fatal_lang_error('wireless_error_notyet', false);
Chris@76	117 elseif (WIRELESS)
Chris@76	118 $context['sub_template'] = WIRELESS_PROTOCOL . '_pm';
Chris@76	119 else
Chris@76	120 loadTemplate('PersonalMessage');
Chris@76	121
Chris@76	122 // Load up the members maximum message capacity.
Chris@76	123 if ($user_info['is_admin'])
Chris@76	124 $context['message_limit'] = 0;
Chris@76	125 elseif (($context['message_limit'] = cache_get_data('msgLimit:' . $user_info['id'], 360)) === null)
Chris@76	126 {
Chris@76	127 // !!! Why do we do this? It seems like if they have any limit we should use it.
Chris@76	128 $request = $smcFunc['db_query']('', '
Chris@76	129 SELECT MAX(max_messages) AS top_limit, MIN(max_messages) AS bottom_limit
Chris@76	130 FROM {db_prefix}membergroups
Chris@76	131 WHERE id_group IN ({array_int:users_groups})',
Chris@76	132 array(
Chris@76	133 'users_groups' => $user_info['groups'],
Chris@76	134 )
Chris@76	135 );
Chris@76	136 list ($maxMessage, $minMessage) = $smcFunc['db_fetch_row']($request);
Chris@76	137 $smcFunc['db_free_result']($request);
Chris@76	138
Chris@76	139 $context['message_limit'] = $minMessage == 0 ? 0 : $maxMessage;
Chris@76	140
Chris@76	141 // Save us doing it again!
Chris@76	142 cache_put_data('msgLimit:' . $user_info['id'], $context['message_limit'], 360);
Chris@76	143 }
Chris@76	144
Chris@76	145 // Prepare the context for the capacity bar.
Chris@76	146 if (!empty($context['message_limit']))
Chris@76	147 {
Chris@76	148 $bar = ($user_info['messages'] * 100) / $context['message_limit'];
Chris@76	149
Chris@76	150 $context['limit_bar'] = array(
Chris@76	151 'messages' => $user_info['messages'],
Chris@76	152 'allowed' => $context['message_limit'],
Chris@76	153 'percent' => $bar,
Chris@76	154 'bar' => min(100, (int) $bar),
Chris@76	155 'text' => sprintf($txt['pm_currently_using'], $user_info['messages'], round($bar, 1)),
Chris@76	156 );
Chris@76	157 }
Chris@76	158
Chris@76	159 // a previous message was sent successfully? show a small indication.
Chris@76	160 if (isset($_GET['done']) && ($_GET['done'] == 'sent'))
Chris@76	161 $context['pm_sent'] = true;
Chris@76	162
Chris@76	163 // Now we have the labels, and assuming we have unsorted mail, apply our rules!
Chris@76	164 if ($user_settings['new_pm'])
Chris@76	165 {
Chris@76	166 $context['labels'] = $user_settings['message_labels'] == '' ? array() : explode(',', $user_settings['message_labels']);
Chris@76	167 foreach ($context['labels'] as $id_label => $label_name)
Chris@76	168 $context['labels'][(int) $id_label] = array(
Chris@76	169 'id' => $id_label,
Chris@76	170 'name' => trim($label_name),
Chris@76	171 'messages' => 0,
Chris@76	172 'unread_messages' => 0,
Chris@76	173 );
Chris@76	174 $context['labels'][-1] = array(
Chris@76	175 'id' => -1,
Chris@76	176 'name' => $txt['pm_msg_label_inbox'],
Chris@76	177 'messages' => 0,
Chris@76	178 'unread_messages' => 0,
Chris@76	179 );
Chris@76	180
Chris@76	181 ApplyRules();
Chris@76	182 updateMemberData($user_info['id'], array('new_pm' => 0));
Chris@76	183 $smcFunc['db_query']('', '
Chris@76	184 UPDATE {db_prefix}pm_recipients
Chris@76	185 SET is_new = {int:not_new}
Chris@76	186 WHERE id_member = {int:current_member}',
Chris@76	187 array(
Chris@76	188 'current_member' => $user_info['id'],
Chris@76	189 'not_new' => 0,
Chris@76	190 )
Chris@76	191 );
Chris@76	192 }
Chris@76	193
Chris@76	194 // Load the label data.
Chris@76	195 if ($user_settings['new_pm'] \|\| ($context['labels'] = cache_get_data('labelCounts:' . $user_info['id'], 720)) === null)
Chris@76	196 {
Chris@76	197 $context['labels'] = $user_settings['message_labels'] == '' ? array() : explode(',', $user_settings['message_labels']);
Chris@76	198 foreach ($context['labels'] as $id_label => $label_name)
Chris@76	199 $context['labels'][(int) $id_label] = array(
Chris@76	200 'id' => $id_label,
Chris@76	201 'name' => trim($label_name),
Chris@76	202 'messages' => 0,
Chris@76	203 'unread_messages' => 0,
Chris@76	204 );
Chris@76	205 $context['labels'][-1] = array(
Chris@76	206 'id' => -1,
Chris@76	207 'name' => $txt['pm_msg_label_inbox'],
Chris@76	208 'messages' => 0,
Chris@76	209 'unread_messages' => 0,
Chris@76	210 );
Chris@76	211
Chris@76	212 // Looks like we need to reseek!
Chris@76	213 $result = $smcFunc['db_query']('', '
Chris@76	214 SELECT labels, is_read, COUNT(*) AS num
Chris@76	215 FROM {db_prefix}pm_recipients
Chris@76	216 WHERE id_member = {int:current_member}
Chris@76	217 AND deleted = {int:not_deleted}
Chris@76	218 GROUP BY labels, is_read',
Chris@76	219 array(
Chris@76	220 'current_member' => $user_info['id'],
Chris@76	221 'not_deleted' => 0,
Chris@76	222 )
Chris@76	223 );
Chris@76	224 while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76	225 {
Chris@76	226 $this_labels = explode(',', $row['labels']);
Chris@76	227 foreach ($this_labels as $this_label)
Chris@76	228 {
Chris@76	229 $context['labels'][(int) $this_label]['messages'] += $row['num'];
Chris@76	230 if (!($row['is_read'] & 1))
Chris@76	231 $context['labels'][(int) $this_label]['unread_messages'] += $row['num'];
Chris@76	232 }
Chris@76	233 }
Chris@76	234 $smcFunc['db_free_result']($result);
Chris@76	235
Chris@76	236 // Store it please!
Chris@76	237 cache_put_data('labelCounts:' . $user_info['id'], $context['labels'], 720);
Chris@76	238 }
Chris@76	239
Chris@76	240 // This determines if we have more labels than just the standard inbox.
Chris@76	241 $context['currently_using_labels'] = count($context['labels']) > 1 ? 1 : 0;
Chris@76	242
Chris@76	243 // Some stuff for the labels...
Chris@76	244 $context['current_label_id'] = isset($_REQUEST['l']) && isset($context['labels'][(int) $_REQUEST['l']]) ? (int) $_REQUEST['l'] : -1;
Chris@76	245 $context['current_label'] = &$context['labels'][(int) $context['current_label_id']]['name'];
Chris@76	246 $context['folder'] = !isset($_REQUEST['f']) \|\| $_REQUEST['f'] != 'sent' ? 'inbox' : 'sent';
Chris@76	247
Chris@76	248 // This is convenient. Do you know how annoying it is to do this every time?!
Chris@76	249 $context['current_label_redirect'] = 'action=pm;f=' . $context['folder'] . (isset($_GET['start']) ? ';start=' . $_GET['start'] : '') . (isset($_REQUEST['l']) ? ';l=' . $_REQUEST['l'] : '');
Chris@76	250 $context['can_issue_warning'] = in_array('w', $context['admin_features']) && allowedTo('issue_warning') && $modSettings['warning_settings'][0] == 1;
Chris@76	251
Chris@76	252 // Build the linktree for all the actions...
Chris@76	253 $context['linktree'][] = array(
Chris@76	254 'url' => $scripturl . '?action=pm',
Chris@76	255 'name' => $txt['personal_messages']
Chris@76	256 );
Chris@76	257
Chris@76	258 // Preferences...
Chris@76	259 $context['display_mode'] = WIRELESS ? 0 : $user_settings['pm_prefs'] & 3;
Chris@76	260
Chris@76	261 $subActions = array(
Chris@76	262 'addbuddy' => 'WirelessAddBuddy',
Chris@76	263 'manlabels' => 'ManageLabels',
Chris@76	264 'manrules' => 'ManageRules',
Chris@76	265 'pmactions' => 'MessageActionsApply',
Chris@76	266 'prune' => 'MessagePrune',
Chris@76	267 'removeall' => 'MessageKillAllQuery',
Chris@76	268 'removeall2' => 'MessageKillAll',
Chris@76	269 'report' => 'ReportMessage',
Chris@76	270 'search' => 'MessageSearch',
Chris@76	271 'search2' => 'MessageSearch2',
Chris@76	272 'send' => 'MessagePost',
Chris@76	273 'send2' => 'MessagePost2',
Chris@76	274 'settings' => 'MessageSettings',
Chris@76	275 );
Chris@76	276
Chris@76	277 if (!isset($_REQUEST['sa']) \|\| !isset($subActions[$_REQUEST['sa']]))
Chris@76	278 MessageFolder();
Chris@76	279 else
Chris@76	280 {
Chris@76	281 messageIndexBar($_REQUEST['sa']);
Chris@76	282 $subActions[$_REQUEST['sa']]();
Chris@76	283 }
Chris@76	284 }
Chris@76	285
Chris@76	286 // A sidebar to easily access different areas of the section
Chris@76	287 function messageIndexBar($area)
Chris@76	288 {
Chris@76	289 global $txt, $context, $scripturl, $sourcedir, $sc, $modSettings, $settings, $user_info, $options;
Chris@76	290
Chris@76	291 $pm_areas = array(
Chris@76	292 'folders' => array(
Chris@76	293 'title' => $txt['pm_messages'],
Chris@76	294 'areas' => array(
Chris@76	295 'send' => array(
Chris@76	296 'label' => $txt['new_message'],
Chris@76	297 'custom_url' => $scripturl . '?action=pm;sa=send',
Chris@76	298 'permission' => allowedTo('pm_send'),
Chris@76	299 ),
Chris@76	300 'inbox' => array(
Chris@76	301 'label' => $txt['inbox'],
Chris@76	302 'custom_url' => $scripturl . '?action=pm',
Chris@76	303 ),
Chris@76	304 'sent' => array(
Chris@76	305 'label' => $txt['sent_items'],
Chris@76	306 'custom_url' => $scripturl . '?action=pm;f=sent',
Chris@76	307 ),
Chris@76	308 ),
Chris@76	309 ),
Chris@76	310 'labels' => array(
Chris@76	311 'title' => $txt['pm_labels'],
Chris@76	312 'areas' => array(),
Chris@76	313 ),
Chris@76	314 'actions' => array(
Chris@76	315 'title' => $txt['pm_actions'],
Chris@76	316 'areas' => array(
Chris@76	317 'search' => array(
Chris@76	318 'label' => $txt['pm_search_bar_title'],
Chris@76	319 'custom_url' => $scripturl . '?action=pm;sa=search',
Chris@76	320 ),
Chris@76	321 'prune' => array(
Chris@76	322 'label' => $txt['pm_prune'],
Chris@76	323 'custom_url' => $scripturl . '?action=pm;sa=prune'
Chris@76	324 ),
Chris@76	325 ),
Chris@76	326 ),
Chris@76	327 'pref' => array(
Chris@76	328 'title' => $txt['pm_preferences'],
Chris@76	329 'areas' => array(
Chris@76	330 'manlabels' => array(
Chris@76	331 'label' => $txt['pm_manage_labels'],
Chris@76	332 'custom_url' => $scripturl . '?action=pm;sa=manlabels',
Chris@76	333 ),
Chris@76	334 'manrules' => array(
Chris@76	335 'label' => $txt['pm_manage_rules'],
Chris@76	336 'custom_url' => $scripturl . '?action=pm;sa=manrules',
Chris@76	337 ),
Chris@76	338 'settings' => array(
Chris@76	339 'label' => $txt['pm_settings'],
Chris@76	340 'custom_url' => $scripturl . '?action=pm;sa=settings',
Chris@76	341 ),
Chris@76	342 ),
Chris@76	343 ),
Chris@76	344 );
Chris@76	345
Chris@76	346 // Handle labels.
Chris@76	347 if (empty($context['currently_using_labels']))
Chris@76	348 unset($pm_areas['labels']);
Chris@76	349 else
Chris@76	350 {
Chris@76	351 // Note we send labels by id as it will have less problems in the querystring.
Chris@76	352 $unread_in_labels = 0;
Chris@76	353 foreach ($context['labels'] as $label)
Chris@76	354 {
Chris@76	355 if ($label['id'] == -1)
Chris@76	356 continue;
Chris@76	357
Chris@76	358 // Count the amount of unread items in labels.
Chris@76	359 $unread_in_labels += $label['unread_messages'];
Chris@76	360
Chris@76	361 // Add the label to the menu.
Chris@76	362 $pm_areas['labels']['areas']['label' . $label['id']] = array(
Chris@76	363 'label' => $label['name'] . (!empty($label['unread_messages']) ? ' (<strong>' . $label['unread_messages'] . '</strong>)' : ''),
Chris@76	364 'custom_url' => $scripturl . '?action=pm;l=' . $label['id'],
Chris@76	365 'unread_messages' => $label['unread_messages'],
Chris@76	366 'messages' => $label['messages'],
Chris@76	367 );
Chris@76	368 }
Chris@76	369
Chris@76	370 if (!empty($unread_in_labels))
Chris@76	371 $pm_areas['labels']['title'] .= ' (' . $unread_in_labels . ')';
Chris@76	372 }
Chris@76	373
Chris@76	374 $pm_areas['folders']['areas']['inbox']['unread_messages'] = &$context['labels'][-1]['unread_messages'];
Chris@76	375 $pm_areas['folders']['areas']['inbox']['messages'] = &$context['labels'][-1]['messages'];
Chris@76	376 if (!empty($context['labels'][-1]['unread_messages']))
Chris@76	377 {
Chris@76	378 $pm_areas['folders']['areas']['inbox']['label'] .= ' (<strong>' . $context['labels'][-1]['unread_messages'] . '</strong>)';
Chris@76	379 $pm_areas['folders']['title'] .= ' (' . $context['labels'][-1]['unread_messages'] . ')';
Chris@76	380 }
Chris@76	381
Chris@76	382 // Do we have a limit on the amount of messages we can keep?
Chris@76	383 if (!empty($context['message_limit']))
Chris@76	384 {
Chris@76	385 $bar = round(($user_info['messages'] * 100) / $context['message_limit'], 1);
Chris@76	386
Chris@76	387 $context['limit_bar'] = array(
Chris@76	388 'messages' => $user_info['messages'],
Chris@76	389 'allowed' => $context['message_limit'],
Chris@76	390 'percent' => $bar,
Chris@76	391 'bar' => $bar > 100 ? 100 : (int) $bar,
Chris@76	392 'text' => sprintf($txt['pm_currently_using'], $user_info['messages'], $bar)
Chris@76	393 );
Chris@76	394 }
Chris@76	395
Chris@76	396 require_once($sourcedir . '/Subs-Menu.php');
Chris@76	397
Chris@76	398 // What page is this, again?
Chris@76	399 $current_page = $scripturl . '?action=pm' . (!empty($_REQUEST['sa']) ? ';sa=' . $_REQUEST['sa'] : '') . (!empty($context['folder']) ? ';f=' . $context['folder'] : '') . (!empty($context['current_label_id']) ? ';l=' . $context['current_label_id'] : '');
Chris@76	400
Chris@76	401 // Set a few options for the menu.
Chris@76	402 $menuOptions = array(
Chris@76	403 'current_area' => $area,
Chris@76	404 'disable_url_session_check' => true,
Chris@76	405 'toggle_url' => $current_page . ';togglebar',
Chris@76	406 'toggle_redirect_url' => $current_page,
Chris@76	407 );
Chris@76	408
Chris@76	409 // Actually create the menu!
Chris@76	410 $pm_include_data = createMenu($pm_areas, $menuOptions);
Chris@76	411 unset($pm_areas);
Chris@76	412
Chris@76	413 // Make a note of the Unique ID for this menu.
Chris@76	414 $context['pm_menu_id'] = $context['max_menu_id'];
Chris@76	415 $context['pm_menu_name'] = 'menu_data_' . $context['pm_menu_id'];
Chris@76	416
Chris@76	417 // Set the selected item.
Chris@76	418 $context['menu_item_selected'] = $pm_include_data['current_area'];
Chris@76	419
Chris@76	420 // obExit will know what to do!
Chris@76	421 if (!WIRELESS)
Chris@76	422 $context['template_layers'][] = 'pm';
Chris@76	423 }
Chris@76	424
Chris@76	425 // A folder, ie. inbox/sent etc.
Chris@76	426 function MessageFolder()
Chris@76	427 {
Chris@76	428 global $txt, $scripturl, $modSettings, $context, $subjects_request;
Chris@76	429 global $messages_request, $user_info, $recipients, $options, $smcFunc, $memberContext, $user_settings;
Chris@76	430
Chris@76	431 // Changing view?
Chris@76	432 if (isset($_GET['view']))
Chris@76	433 {
Chris@76	434 $context['display_mode'] = $context['display_mode'] > 1 ? 0 : $context['display_mode'] + 1;
Chris@76	435 updateMemberData($user_info['id'], array('pm_prefs' => ($user_settings['pm_prefs'] & 252) \| $context['display_mode']));
Chris@76	436 }
Chris@76	437
Chris@76	438 // Make sure the starting location is valid.
Chris@76	439 if (isset($_GET['start']) && $_GET['start'] != 'new')
Chris@76	440 $_GET['start'] = (int) $_GET['start'];
Chris@76	441 elseif (!isset($_GET['start']) && !empty($options['view_newest_pm_first']))
Chris@76	442 $_GET['start'] = 0;
Chris@76	443 else
Chris@76	444 $_GET['start'] = 'new';
Chris@76	445
Chris@76	446 // Set up some basic theme stuff.
Chris@76	447 $context['from_or_to'] = $context['folder'] != 'sent' ? 'from' : 'to';
Chris@76	448 $context['get_pmessage'] = 'prepareMessageContext';
Chris@76	449 $context['signature_enabled'] = substr($modSettings['signature_settings'], 0, 1) == 1;
Chris@76	450
Chris@76	451 $labelQuery = $context['folder'] != 'sent' ? '
Chris@76	452 AND FIND_IN_SET(' . $context['current_label_id'] . ', pmr.labels) != 0' : '';
Chris@76	453
Chris@76	454 // Set the index bar correct!
Chris@76	455 messageIndexBar($context['current_label_id'] == -1 ? $context['folder'] : 'label' . $context['current_label_id']);
Chris@76	456
Chris@76	457 // Sorting the folder.
Chris@76	458 $sort_methods = array(
Chris@76	459 'date' => 'pm.id_pm',
Chris@76	460 'name' => 'IFNULL(mem.real_name, \'\')',
Chris@76	461 'subject' => 'pm.subject',
Chris@76	462 );
Chris@76	463
Chris@76	464 // They didn't pick one, use the forum default.
Chris@76	465 if (!isset($_GET['sort']) \|\| !isset($sort_methods[$_GET['sort']]))
Chris@76	466 {
Chris@76	467 $context['sort_by'] = 'date';
Chris@76	468 $_GET['sort'] = 'pm.id_pm';
Chris@76	469 // An overriding setting?
Chris@76	470 $descending = !empty($options['view_newest_pm_first']);
Chris@76	471 }
Chris@76	472 // Otherwise use the defaults: ascending, by date.
Chris@76	473 else
Chris@76	474 {
Chris@76	475 $context['sort_by'] = $_GET['sort'];
Chris@76	476 $_GET['sort'] = $sort_methods[$_GET['sort']];
Chris@76	477 $descending = isset($_GET['desc']);
Chris@76	478 }
Chris@76	479
Chris@76	480 $context['sort_direction'] = $descending ? 'down' : 'up';
Chris@76	481
Chris@76	482 // Why would you want access to your sent items if you're not allowed to send anything?
Chris@76	483 if ($context['folder'] == 'sent')
Chris@76	484 isAllowedTo('pm_send');
Chris@76	485
Chris@76	486 // Set the text to resemble the current folder.
Chris@76	487 $pmbox = $context['folder'] != 'sent' ? $txt['inbox'] : $txt['sent_items'];
Chris@76	488 $txt['delete_all'] = str_replace('PMBOX', $pmbox, $txt['delete_all']);
Chris@76	489
Chris@76	490 // Now, build the link tree!
Chris@76	491 if ($context['current_label_id'] == -1)
Chris@76	492 $context['linktree'][] = array(
Chris@76	493 'url' => $scripturl . '?action=pm;f=' . $context['folder'],
Chris@76	494 'name' => $pmbox
Chris@76	495 );
Chris@76	496
Chris@76	497 // Build it further for a label.
Chris@76	498 if ($context['current_label_id'] != -1)
Chris@76	499 $context['linktree'][] = array(
Chris@76	500 'url' => $scripturl . '?action=pm;f=' . $context['folder'] . ';l=' . $context['current_label_id'],
Chris@76	501 'name' => $txt['pm_current_label'] . ': ' . $context['current_label']
Chris@76	502 );
Chris@76	503
Chris@76	504 // Figure out how many messages there are.
Chris@76	505 if ($context['folder'] == 'sent')
Chris@76	506 $request = $smcFunc['db_query']('', '
Chris@76	507 SELECT COUNT(' . ($context['display_mode'] == 2 ? 'DISTINCT pm.id_pm_head' : '*') . ')
Chris@76	508 FROM {db_prefix}personal_messages AS pm
Chris@76	509 WHERE pm.id_member_from = {int:current_member}
Chris@76	510 AND pm.deleted_by_sender = {int:not_deleted}',
Chris@76	511 array(
Chris@76	512 'current_member' => $user_info['id'],
Chris@76	513 'not_deleted' => 0,
Chris@76	514 )
Chris@76	515 );
Chris@76	516 else
Chris@76	517 $request = $smcFunc['db_query']('', '
Chris@76	518 SELECT COUNT(' . ($context['display_mode'] == 2 ? 'DISTINCT pm.id_pm_head' : '*') . ')
Chris@76	519 FROM {db_prefix}pm_recipients AS pmr' . ($context['display_mode'] == 2 ? '
Chris@76	520 INNER JOIN {db_prefix}personal_messages AS pm ON (pm.id_pm = pmr.id_pm)' : '') . '
Chris@76	521 WHERE pmr.id_member = {int:current_member}
Chris@76	522 AND pmr.deleted = {int:not_deleted}' . $labelQuery,
Chris@76	523 array(
Chris@76	524 'current_member' => $user_info['id'],
Chris@76	525 'not_deleted' => 0,
Chris@76	526 )
Chris@76	527 );
Chris@76	528 list ($max_messages) = $smcFunc['db_fetch_row']($request);
Chris@76	529 $smcFunc['db_free_result']($request);
Chris@76	530
Chris@76	531 // Only show the button if there are messages to delete.
Chris@76	532 $context['show_delete'] = $max_messages > 0;
Chris@76	533
Chris@76	534 // Start on the last page.
Chris@76	535 if (!is_numeric($_GET['start']) \|\| $_GET['start'] >= $max_messages)
Chris@76	536 $_GET['start'] = ($max_messages - 1) - (($max_messages - 1) % $modSettings['defaultMaxMessages']);
Chris@76	537 elseif ($_GET['start'] < 0)
Chris@76	538 $_GET['start'] = 0;
Chris@76	539
Chris@76	540 // ... but wait - what if we want to start from a specific message?
Chris@76	541 if (isset($_GET['pmid']))
Chris@76	542 {
Chris@76	543 $pmID = (int) $_GET['pmid'];
Chris@76	544
Chris@76	545 // Make sure you have access to this PM.
Chris@76	546 if (!isAccessiblePM($pmID, $context['folder'] == 'sent' ? 'outbox' : 'inbox'))
Chris@76	547 fatal_lang_error('no_access', false);
Chris@76	548
Chris@76	549 $context['current_pm'] = $pmID;
Chris@76	550
Chris@76	551 // With only one page of PM's we're gonna want page 1.
Chris@76	552 if ($max_messages <= $modSettings['defaultMaxMessages'])
Chris@76	553 $_GET['start'] = 0;
Chris@76	554 // If we pass kstart we assume we're in the right place.
Chris@76	555 elseif (!isset($_GET['kstart']))
Chris@76	556 {
Chris@76	557 if ($context['folder'] == 'sent')
Chris@76	558 $request = $smcFunc['db_query']('', '
Chris@76	559 SELECT COUNT(' . ($context['display_mode'] == 2 ? 'DISTINCT pm.id_pm_head' : '*') . ')
Chris@76	560 FROM {db_prefix}personal_messages
Chris@76	561 WHERE id_member_from = {int:current_member}
Chris@76	562 AND deleted_by_sender = {int:not_deleted}
Chris@76	563 AND id_pm ' . ($descending ? '>' : '<') . ' {int:id_pm}',
Chris@76	564 array(
Chris@76	565 'current_member' => $user_info['id'],
Chris@76	566 'not_deleted' => 0,
Chris@76	567 'id_pm' => $pmID,
Chris@76	568 )
Chris@76	569 );
Chris@76	570 else
Chris@76	571 $request = $smcFunc['db_query']('', '
Chris@76	572 SELECT COUNT(' . ($context['display_mode'] == 2 ? 'DISTINCT pm.id_pm_head' : '*') . ')
Chris@76	573 FROM {db_prefix}pm_recipients AS pmr' . ($context['display_mode'] == 2 ? '
Chris@76	574 INNER JOIN {db_prefix}personal_messages AS pm ON (pm.id_pm = pmr.id_pm)' : '') . '
Chris@76	575 WHERE pmr.id_member = {int:current_member}
Chris@76	576 AND pmr.deleted = {int:not_deleted}' . $labelQuery . '
Chris@76	577 AND pmr.id_pm ' . ($descending ? '>' : '<') . ' {int:id_pm}',
Chris@76	578 array(
Chris@76	579 'current_member' => $user_info['id'],
Chris@76	580 'not_deleted' => 0,
Chris@76	581 'id_pm' => $pmID,
Chris@76	582 )
Chris@76	583 );
Chris@76	584
Chris@76	585 list ($_GET['start']) = $smcFunc['db_fetch_row']($request);
Chris@76	586 $smcFunc['db_free_result']($request);
Chris@76	587
Chris@76	588 // To stop the page index's being abnormal, start the page on the page the message would normally be located on...
Chris@76	589 $_GET['start'] = $modSettings['defaultMaxMessages'] * (int) ($_GET['start'] / $modSettings['defaultMaxMessages']);
Chris@76	590 }
Chris@76	591 }
Chris@76	592
Chris@76	593 // Sanitize and validate pmsg variable if set.
Chris@76	594 if (isset($_GET['pmsg']))
Chris@76	595 {
Chris@76	596 $pmsg = (int) $_GET['pmsg'];
Chris@76	597
Chris@76	598 if (!isAccessiblePM($pmsg, $context['folder'] == 'sent' ? 'outbox' : 'inbox'))
Chris@76	599 fatal_lang_error('no_access', false);
Chris@76	600 }
Chris@76	601
Chris@76	602 // Set up the page index.
Chris@76	603 $context['page_index'] = constructPageIndex($scripturl . '?action=pm;f=' . $context['folder'] . (isset($_REQUEST['l']) ? ';l=' . (int) $_REQUEST['l'] : '') . ';sort=' . $context['sort_by'] . ($descending ? ';desc' : ''), $_GET['start'], $max_messages, $modSettings['defaultMaxMessages']);
Chris@76	604 $context['start'] = $_GET['start'];
Chris@76	605
Chris@76	606 // Determine the navigation context (especially useful for the wireless template).
Chris@76	607 $context['links'] = array(
Chris@76	608 'first' => $_GET['start'] >= $modSettings['defaultMaxMessages'] ? $scripturl . '?action=pm;start=0' : '',
Chris@76	609 'prev' => $_GET['start'] >= $modSettings['defaultMaxMessages'] ? $scripturl . '?action=pm;start=' . ($_GET['start'] - $modSettings['defaultMaxMessages']) : '',
Chris@76	610 'next' => $_GET['start'] + $modSettings['defaultMaxMessages'] < $max_messages ? $scripturl . '?action=pm;start=' . ($_GET['start'] + $modSettings['defaultMaxMessages']) : '',
Chris@76	611 'last' => $_GET['start'] + $modSettings['defaultMaxMessages'] < $max_messages ? $scripturl . '?action=pm;start=' . (floor(($max_messages - 1) / $modSettings['defaultMaxMessages']) * $modSettings['defaultMaxMessages']) : '',
Chris@76	612 'up' => $scripturl,
Chris@76	613 );
Chris@76	614 $context['page_info'] = array(
Chris@76	615 'current_page' => $_GET['start'] / $modSettings['defaultMaxMessages'] + 1,
Chris@76	616 'num_pages' => floor(($max_messages - 1) / $modSettings['defaultMaxMessages']) + 1
Chris@76	617 );
Chris@76	618
Chris@76	619 // First work out what messages we need to see - if grouped is a little trickier...
Chris@76	620 if ($context['display_mode'] == 2)
Chris@76	621 {
Chris@76	622 // On a non-default sort due to PostgreSQL we have to do a harder sort.
Chris@76	623 if ($smcFunc['db_title'] == 'PostgreSQL' && $_GET['sort'] != 'pm.id_pm')
Chris@76	624 {
Chris@76	625 $sub_request = $smcFunc['db_query']('', '
Chris@76	626 SELECT MAX({raw:sort}) AS sort_param, pm.id_pm_head
Chris@76	627 FROM {db_prefix}personal_messages AS pm' . ($context['folder'] == 'sent' ? ($context['sort_by'] == 'name' ? '
Chris@76	628 LEFT JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm)' : '') : '
Chris@76	629 INNER JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm
Chris@76	630 AND pmr.id_member = {int:current_member}
Chris@76	631 AND pmr.deleted = {int:not_deleted}
Chris@76	632 ' . $labelQuery . ')') . ($context['sort_by'] == 'name' ? ( '
Chris@76	633 LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = {raw:id_member})') : '') . '
Chris@76	634 WHERE ' . ($context['folder'] == 'sent' ? 'pm.id_member_from = {int:current_member}
Chris@76	635 AND pm.deleted_by_sender = {int:not_deleted}' : '1=1') . (empty($pmsg) ? '' : '
Chris@76	636 AND pm.id_pm = {int:id_pm}') . '
Chris@76	637 GROUP BY pm.id_pm_head
Chris@76	638 ORDER BY sort_param' . ($descending ? ' DESC' : ' ASC') . (empty($pmsg) ? '
Chris@76	639 LIMIT ' . $_GET['start'] . ', ' . $modSettings['defaultMaxMessages'] : ''),
Chris@76	640 array(
Chris@76	641 'current_member' => $user_info['id'],
Chris@76	642 'not_deleted' => 0,
Chris@76	643 'id_member' => $context['folder'] == 'sent' ? 'pmr.id_member' : 'pm.id_member_from',
Chris@76	644 'id_pm' => isset($pmsg) ? $pmsg : '0',
Chris@76	645 'sort' => $_GET['sort'],
Chris@76	646 )
Chris@76	647 );
Chris@76	648 $sub_pms = array();
Chris@76	649 while ($row = $smcFunc['db_fetch_assoc']($sub_request))
Chris@76	650 $sub_pms[$row['id_pm_head']] = $row['sort_param'];
Chris@76	651
Chris@76	652 $smcFunc['db_free_result']($sub_request);
Chris@76	653
Chris@76	654 $request = $smcFunc['db_query']('', '
Chris@76	655 SELECT pm.id_pm AS id_pm, pm.id_pm_head
Chris@76	656 FROM {db_prefix}personal_messages AS pm' . ($context['folder'] == 'sent' ? ($context['sort_by'] == 'name' ? '
Chris@76	657 LEFT JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm)' : '') : '
Chris@76	658 INNER JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm
Chris@76	659 AND pmr.id_member = {int:current_member}
Chris@76	660 AND pmr.deleted = {int:not_deleted}
Chris@76	661 ' . $labelQuery . ')') . ($context['sort_by'] == 'name' ? ( '
Chris@76	662 LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = {raw:id_member})') : '') . '
Chris@76	663 WHERE ' . (empty($sub_pms) ? '0=1' : 'pm.id_pm IN ({array_int:pm_list})') . '
Chris@76	664 ORDER BY ' . ($_GET['sort'] == 'pm.id_pm' && $context['folder'] != 'sent' ? 'id_pm' : '{raw:sort}') . ($descending ? ' DESC' : ' ASC') . (empty($pmsg) ? '
Chris@76	665 LIMIT ' . $_GET['start'] . ', ' . $modSettings['defaultMaxMessages'] : ''),
Chris@76	666 array(
Chris@76	667 'current_member' => $user_info['id'],
Chris@76	668 'pm_list' => array_keys($sub_pms),
Chris@76	669 'not_deleted' => 0,
Chris@76	670 'sort' => $_GET['sort'],
Chris@76	671 'id_member' => $context['folder'] == 'sent' ? 'pmr.id_member' : 'pm.id_member_from',
Chris@76	672 )
Chris@76	673 );
Chris@76	674 }
Chris@76	675 else
Chris@76	676 {
Chris@76	677 $request = $smcFunc['db_query']('pm_conversation_list', '
Chris@76	678 SELECT MAX(pm.id_pm) AS id_pm, pm.id_pm_head
Chris@76	679 FROM {db_prefix}personal_messages AS pm' . ($context['folder'] == 'sent' ? ($context['sort_by'] == 'name' ? '
Chris@76	680 LEFT JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm)' : '') : '
Chris@76	681 INNER JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm
Chris@76	682 AND pmr.id_member = {int:current_member}
Chris@76	683 AND pmr.deleted = {int:deleted_by}
Chris@76	684 ' . $labelQuery . ')') . ($context['sort_by'] == 'name' ? ( '
Chris@76	685 LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = {raw:pm_member})') : '') . '
Chris@76	686 WHERE ' . ($context['folder'] == 'sent' ? 'pm.id_member_from = {int:current_member}
Chris@76	687 AND pm.deleted_by_sender = {int:deleted_by}' : '1=1') . (empty($pmsg) ? '' : '
Chris@76	688 AND pm.id_pm = {int:pmsg}') . '
Chris@76	689 GROUP BY pm.id_pm_head
Chris@76	690 ORDER BY ' . ($_GET['sort'] == 'pm.id_pm' && $context['folder'] != 'sent' ? 'id_pm' : '{raw:sort}') . ($descending ? ' DESC' : ' ASC') . (empty($_GET['pmsg']) ? '
Chris@76	691 LIMIT ' . $_GET['start'] . ', ' . $modSettings['defaultMaxMessages'] : ''),
Chris@76	692 array(
Chris@76	693 'current_member' => $user_info['id'],
Chris@76	694 'deleted_by' => 0,
Chris@76	695 'sort' => $_GET['sort'],
Chris@76	696 'pm_member' => $context['folder'] == 'sent' ? 'pmr.id_member' : 'pm.id_member_from',
Chris@76	697 'pmsg' => isset($pmsg) ? (int) $pmsg : 0,
Chris@76	698 )
Chris@76	699 );
Chris@76	700 }
Chris@76	701 }
Chris@76	702 // This is kinda simple!
Chris@76	703 else
Chris@76	704 {
Chris@76	705 // !!!SLOW This query uses a filesort. (inbox only.)
Chris@76	706 $request = $smcFunc['db_query']('', '
Chris@76	707 SELECT pm.id_pm, pm.id_pm_head, pm.id_member_from
Chris@76	708 FROM {db_prefix}personal_messages AS pm' . ($context['folder'] == 'sent' ? '' . ($context['sort_by'] == 'name' ? '
Chris@76	709 LEFT JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm)' : '') : '
Chris@76	710 INNER JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm
Chris@76	711 AND pmr.id_member = {int:current_member}
Chris@76	712 AND pmr.deleted = {int:is_deleted}
Chris@76	713 ' . $labelQuery . ')') . ($context['sort_by'] == 'name' ? ( '
Chris@76	714 LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = {raw:pm_member})') : '') . '
Chris@76	715 WHERE ' . ($context['folder'] == 'sent' ? 'pm.id_member_from = {raw:current_member}
Chris@76	716 AND pm.deleted_by_sender = {int:is_deleted}' : '1=1') . (empty($pmsg) ? '' : '
Chris@76	717 AND pm.id_pm = {int:pmsg}') . '
Chris@76	718 ORDER BY ' . ($_GET['sort'] == 'pm.id_pm' && $context['folder'] != 'sent' ? 'pmr.id_pm' : '{raw:sort}') . ($descending ? ' DESC' : ' ASC') . (empty($pmsg) ? '
Chris@76	719 LIMIT ' . $_GET['start'] . ', ' . $modSettings['defaultMaxMessages'] : ''),
Chris@76	720 array(
Chris@76	721 'current_member' => $user_info['id'],
Chris@76	722 'is_deleted' => 0,
Chris@76	723 'sort' => $_GET['sort'],
Chris@76	724 'pm_member' => $context['folder'] == 'sent' ? 'pmr.id_member' : 'pm.id_member_from',
Chris@76	725 'pmsg' => isset($pmsg) ? (int) $pmsg : 0,
Chris@76	726 )
Chris@76	727 );
Chris@76	728 }
Chris@76	729 // Load the id_pms and initialize recipients.
Chris@76	730 $pms = array();
Chris@76	731 $lastData = array();
Chris@76	732 $posters = $context['folder'] == 'sent' ? array($user_info['id']) : array();
Chris@76	733 $recipients = array();
Chris@76	734
Chris@76	735 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	736 {
Chris@76	737 if (!isset($recipients[$row['id_pm']]))
Chris@76	738 {
Chris@76	739 if (isset($row['id_member_from']))
Chris@76	740 $posters[$row['id_pm']] = $row['id_member_from'];
Chris@76	741 $pms[$row['id_pm']] = $row['id_pm'];
Chris@76	742 $recipients[$row['id_pm']] = array(
Chris@76	743 'to' => array(),
Chris@76	744 'bcc' => array()
Chris@76	745 );
Chris@76	746 }
Chris@76	747
Chris@76	748 // Keep track of the last message so we know what the head is without another query!
Chris@76	749 if ((empty($pmID) && (empty($options['view_newest_pm_first']) \|\| !isset($lastData))) \|\| empty($lastData) \|\| (!empty($pmID) && $pmID == $row['id_pm']))
Chris@76	750 $lastData = array(
Chris@76	751 'id' => $row['id_pm'],
Chris@76	752 'head' => $row['id_pm_head'],
Chris@76	753 );
Chris@76	754 }
Chris@76	755 $smcFunc['db_free_result']($request);
Chris@76	756
Chris@76	757 // Make sure that we have been given a correct head pm id!
Chris@76	758 if ($context['display_mode'] == 2 && !empty($pmID) && $pmID != $lastData['id'])
Chris@76	759 fatal_lang_error('no_access', false);
Chris@76	760
Chris@76	761 if (!empty($pms))
Chris@76	762 {
Chris@76	763 // Select the correct current message.
Chris@76	764 if (empty($pmID))
Chris@76	765 $context['current_pm'] = $lastData['id'];
Chris@76	766
Chris@76	767 // This is a list of the pm's that are used for "full" display.
Chris@76	768 if ($context['display_mode'] == 0)
Chris@76	769 $display_pms = $pms;
Chris@76	770 else
Chris@76	771 $display_pms = array($context['current_pm']);
Chris@76	772
Chris@76	773 // At this point we know the main id_pm's. But - if we are looking at conversations we need the others!
Chris@76	774 if ($context['display_mode'] == 2)
Chris@76	775 {
Chris@76	776 $request = $smcFunc['db_query']('', '
Chris@76	777 SELECT pm.id_pm, pm.id_member_from, pm.deleted_by_sender, pmr.id_member, pmr.deleted
Chris@76	778 FROM {db_prefix}personal_messages AS pm
Chris@76	779 INNER JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm)
Chris@76	780 WHERE pm.id_pm_head = {int:id_pm_head}
Chris@76	781 AND ((pm.id_member_from = {int:current_member} AND pm.deleted_by_sender = {int:not_deleted})
Chris@76	782 OR (pmr.id_member = {int:current_member} AND pmr.deleted = {int:not_deleted}))
Chris@76	783 ORDER BY pm.id_pm',
Chris@76	784 array(
Chris@76	785 'current_member' => $user_info['id'],
Chris@76	786 'id_pm_head' => $lastData['head'],
Chris@76	787 'not_deleted' => 0,
Chris@76	788 )
Chris@76	789 );
Chris@76	790 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	791 {
Chris@76	792 // This is, frankly, a joke. We will put in a workaround for people sending to themselves - yawn!
Chris@76	793 if ($context['folder'] == 'sent' && $row['id_member_from'] == $user_info['id'] && $row['deleted_by_sender'] == 1)
Chris@76	794 continue;
Chris@76	795 elseif ($row['id_member'] == $user_info['id'] & $row['deleted'] == 1)
Chris@76	796 continue;
Chris@76	797
Chris@76	798 if (!isset($recipients[$row['id_pm']]))
Chris@76	799 $recipients[$row['id_pm']] = array(
Chris@76	800 'to' => array(),
Chris@76	801 'bcc' => array()
Chris@76	802 );
Chris@76	803 $display_pms[] = $row['id_pm'];
Chris@76	804 $posters[$row['id_pm']] = $row['id_member_from'];
Chris@76	805 }
Chris@76	806 $smcFunc['db_free_result']($request);
Chris@76	807 }
Chris@76	808
Chris@76	809 // This is pretty much EVERY pm!
Chris@76	810 $all_pms = array_merge($pms, $display_pms);
Chris@76	811 $all_pms = array_unique($all_pms);
Chris@76	812
Chris@76	813 // Get recipients (don't include bcc-recipients for your inbox, you're not supposed to know :P).
Chris@76	814 $request = $smcFunc['db_query']('', '
Chris@76	815 SELECT pmr.id_pm, mem_to.id_member AS id_member_to, mem_to.real_name AS to_name, pmr.bcc, pmr.labels, pmr.is_read
Chris@76	816 FROM {db_prefix}pm_recipients AS pmr
Chris@76	817 LEFT JOIN {db_prefix}members AS mem_to ON (mem_to.id_member = pmr.id_member)
Chris@76	818 WHERE pmr.id_pm IN ({array_int:pm_list})',
Chris@76	819 array(
Chris@76	820 'pm_list' => $all_pms,
Chris@76	821 )
Chris@76	822 );
Chris@76	823 $context['message_labels'] = array();
Chris@76	824 $context['message_replied'] = array();
Chris@76	825 $context['message_unread'] = array();
Chris@76	826 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	827 {
Chris@76	828 if ($context['folder'] == 'sent' \|\| empty($row['bcc']))
Chris@76	829 $recipients[$row['id_pm']][empty($row['bcc']) ? 'to' : 'bcc'][] = empty($row['id_member_to']) ? $txt['guest_title'] : '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member_to'] . '">' . $row['to_name'] . '</a>';
Chris@76	830
Chris@76	831 if ($row['id_member_to'] == $user_info['id'] && $context['folder'] != 'sent')
Chris@76	832 {
Chris@76	833 $context['message_replied'][$row['id_pm']] = $row['is_read'] & 2;
Chris@76	834 $context['message_unread'][$row['id_pm']] = $row['is_read'] == 0;
Chris@76	835
Chris@76	836 $row['labels'] = $row['labels'] == '' ? array() : explode(',', $row['labels']);
Chris@76	837 foreach ($row['labels'] as $v)
Chris@76	838 {
Chris@76	839 if (isset($context['labels'][(int) $v]))
Chris@76	840 $context['message_labels'][$row['id_pm']][(int) $v] = array('id' => $v, 'name' => $context['labels'][(int) $v]['name']);
Chris@76	841 }
Chris@76	842 }
Chris@76	843 }
Chris@76	844 $smcFunc['db_free_result']($request);
Chris@76	845
Chris@76	846 // Make sure we don't load unnecessary data.
Chris@76	847 if ($context['display_mode'] == 1)
Chris@76	848 {
Chris@76	849 foreach ($posters as $k => $v)
Chris@76	850 if (!in_array($k, $display_pms))
Chris@76	851 unset($posters[$k]);
Chris@76	852 }
Chris@76	853
Chris@76	854 // Load any users....
Chris@76	855 $posters = array_unique($posters);
Chris@76	856 if (!empty($posters))
Chris@76	857 loadMemberData($posters);
Chris@76	858
Chris@76	859 // If we're on grouped/restricted view get a restricted list of messages.
Chris@76	860 if ($context['display_mode'] != 0)
Chris@76	861 {
Chris@76	862 // Get the order right.
Chris@76	863 $orderBy = array();
Chris@76	864 foreach (array_reverse($pms) as $pm)
Chris@76	865 $orderBy[] = 'pm.id_pm = ' . $pm;
Chris@76	866
Chris@76	867 // Seperate query for these bits!
Chris@76	868 $subjects_request = $smcFunc['db_query']('', '
Chris@76	869 SELECT pm.id_pm, pm.subject, pm.id_member_from, pm.msgtime, IFNULL(mem.real_name, pm.from_name) AS from_name,
Chris@76	870 IFNULL(mem.id_member, 0) AS not_guest
Chris@76	871 FROM {db_prefix}personal_messages AS pm
Chris@76	872 LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = pm.id_member_from)
Chris@76	873 WHERE pm.id_pm IN ({array_int:pm_list})
Chris@76	874 ORDER BY ' . implode(', ', $orderBy) . '
Chris@76	875 LIMIT ' . count($pms),
Chris@76	876 array(
Chris@76	877 'pm_list' => $pms,
Chris@76	878 )
Chris@76	879 );
Chris@76	880 }
Chris@76	881
Chris@76	882 // Execute the query!
Chris@76	883 $messages_request = $smcFunc['db_query']('', '
Chris@76	884 SELECT pm.id_pm, pm.subject, pm.id_member_from, pm.body, pm.msgtime, pm.from_name
Chris@76	885 FROM {db_prefix}personal_messages AS pm' . ($context['folder'] == 'sent' ? '
Chris@76	886 LEFT JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm)' : '') . ($context['sort_by'] == 'name' ? '
Chris@76	887 LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = {raw:id_member})' : '') . '
Chris@76	888 WHERE pm.id_pm IN ({array_int:display_pms})' . ($context['folder'] == 'sent' ? '
Chris@76	889 GROUP BY pm.id_pm, pm.subject, pm.id_member_from, pm.body, pm.msgtime, pm.from_name' : '') . '
Chris@76	890 ORDER BY ' . ($context['display_mode'] == 2 ? 'pm.id_pm' : $_GET['sort']) . ($descending ? ' DESC' : ' ASC') . '
Chris@76	891 LIMIT ' . count($display_pms),
Chris@76	892 array(
Chris@76	893 'display_pms' => $display_pms,
Chris@76	894 'id_member' => $context['folder'] == 'sent' ? 'pmr.id_member' : 'pm.id_member_from',
Chris@76	895 )
Chris@76	896 );
Chris@76	897 }
Chris@76	898 else
Chris@76	899 $messages_request = false;
Chris@76	900
Chris@76	901 $context['can_send_pm'] = allowedTo('pm_send');
Chris@76	902 if (!WIRELESS)
Chris@76	903 $context['sub_template'] = 'folder';
Chris@76	904 $context['page_title'] = $txt['pm_inbox'];
Chris@76	905
Chris@76	906 // Finally mark the relevant messages as read.
Chris@76	907 if ($context['folder'] != 'sent' && !empty($context['labels'][(int) $context['current_label_id']]['unread_messages']))
Chris@76	908 {
Chris@76	909 // If the display mode is "old sk00l" do them all...
Chris@76	910 if ($context['display_mode'] == 0)
Chris@76	911 markMessages(null, $context['current_label_id']);
Chris@76	912 // Otherwise do just the current one!
Chris@76	913 elseif (!empty($context['current_pm']))
Chris@76	914 markMessages($display_pms, $context['current_label_id']);
Chris@76	915 }
Chris@76	916 }
Chris@76	917
Chris@76	918 // Get a personal message for the theme. (used to save memory.)
Chris@76	919 function prepareMessageContext($type = 'subject', $reset = false)
Chris@76	920 {
Chris@76	921 global $txt, $scripturl, $modSettings, $context, $messages_request, $memberContext, $recipients, $smcFunc;
Chris@76	922 global $user_info, $subjects_request;
Chris@76	923
Chris@76	924 // Count the current message number....
Chris@76	925 static $counter = null;
Chris@76	926 if ($counter === null \|\| $reset)
Chris@76	927 $counter = $context['start'];
Chris@76	928
Chris@76	929 static $temp_pm_selected = null;
Chris@76	930 if ($temp_pm_selected === null)
Chris@76	931 {
Chris@76	932 $temp_pm_selected = isset($_SESSION['pm_selected']) ? $_SESSION['pm_selected'] : array();
Chris@76	933 $_SESSION['pm_selected'] = array();
Chris@76	934 }
Chris@76	935
Chris@76	936 // If we're in non-boring view do something exciting!
Chris@76	937 if ($context['display_mode'] != 0 && $subjects_request && $type == 'subject')
Chris@76	938 {
Chris@76	939 $subject = $smcFunc['db_fetch_assoc']($subjects_request);
Chris@76	940 if (!$subject)
Chris@76	941 {
Chris@76	942 $smcFunc['db_free_result']($subjects_request);
Chris@76	943 return false;
Chris@76	944 }
Chris@76	945
Chris@76	946 $subject['subject'] = $subject['subject'] == '' ? $txt['no_subject'] : $subject['subject'];
Chris@76	947 censorText($subject['subject']);
Chris@76	948
Chris@76	949 $output = array(
Chris@76	950 'id' => $subject['id_pm'],
Chris@76	951 'member' => array(
Chris@76	952 'id' => $subject['id_member_from'],
Chris@76	953 'name' => $subject['from_name'],
Chris@76	954 'link' => $subject['not_guest'] ? '<a href="' . $scripturl . '?action=profile;u=' . $subject['id_member_from'] . '">' . $subject['from_name'] . '</a>' : $subject['from_name'],
Chris@76	955 ),
Chris@76	956 'recipients' => &$recipients[$subject['id_pm']],
Chris@76	957 'subject' => $subject['subject'],
Chris@76	958 'time' => timeformat($subject['msgtime']),
Chris@76	959 'timestamp' => forum_time(true, $subject['msgtime']),
Chris@76	960 'number_recipients' => count($recipients[$subject['id_pm']]['to']),
Chris@76	961 'labels' => &$context['message_labels'][$subject['id_pm']],
Chris@76	962 'fully_labeled' => count($context['message_labels'][$subject['id_pm']]) == count($context['labels']),
Chris@76	963 'is_replied_to' => &$context['message_replied'][$subject['id_pm']],
Chris@76	964 'is_unread' => &$context['message_unread'][$subject['id_pm']],
Chris@76	965 'is_selected' => !empty($temp_pm_selected) && in_array($subject['id_pm'], $temp_pm_selected),
Chris@76	966 );
Chris@76	967
Chris@76	968 return $output;
Chris@76	969 }
Chris@76	970
Chris@76	971 // Bail if it's false, ie. no messages.
Chris@76	972 if ($messages_request == false)
Chris@76	973 return false;
Chris@76	974
Chris@76	975 // Reset the data?
Chris@76	976 if ($reset == true)
Chris@76	977 return @$smcFunc['db_data_seek']($messages_request, 0);
Chris@76	978
Chris@76	979 // Get the next one... bail if anything goes wrong.
Chris@76	980 $message = $smcFunc['db_fetch_assoc']($messages_request);
Chris@76	981 if (!$message)
Chris@76	982 {
Chris@76	983 if ($type != 'subject')
Chris@76	984 $smcFunc['db_free_result']($messages_request);
Chris@76	985
Chris@76	986 return false;
Chris@76	987 }
Chris@76	988
Chris@76	989 // Use '(no subject)' if none was specified.
Chris@76	990 $message['subject'] = $message['subject'] == '' ? $txt['no_subject'] : $message['subject'];
Chris@76	991
Chris@76	992 // Load the message's information - if it's not there, load the guest information.
Chris@76	993 if (!loadMemberContext($message['id_member_from'], true))
Chris@76	994 {
Chris@76	995 $memberContext[$message['id_member_from']]['name'] = $message['from_name'];
Chris@76	996 $memberContext[$message['id_member_from']]['id'] = 0;
Chris@76	997 // Sometimes the forum sends messages itself (Warnings are an example) - in this case don't label it from a guest.
Chris@76	998 $memberContext[$message['id_member_from']]['group'] = $message['from_name'] == $context['forum_name'] ? '' : $txt['guest_title'];
Chris@76	999 $memberContext[$message['id_member_from']]['link'] = $message['from_name'];
Chris@76	1000 $memberContext[$message['id_member_from']]['email'] = '';
Chris@76	1001 $memberContext[$message['id_member_from']]['show_email'] = showEmailAddress(true, 0);
Chris@76	1002 $memberContext[$message['id_member_from']]['is_guest'] = true;
Chris@76	1003 }
Chris@76	1004 else
Chris@76	1005 {
Chris@76	1006 $memberContext[$message['id_member_from']]['can_view_profile'] = allowedTo('profile_view_any') \|\| ($message['id_member_from'] == $user_info['id'] && allowedTo('profile_view_own'));
Chris@76	1007 $memberContext[$message['id_member_from']]['can_see_warning'] = !isset($context['disabled_fields']['warning_status']) && $memberContext[$message['id_member_from']]['warning_status'] && ($context['user']['can_mod'] \|\| (!empty($modSettings['warning_show']) && ($modSettings['warning_show'] > 1 \|\| $message['id_member_from'] == $user_info['id'])));
Chris@76	1008 }
Chris@76	1009
Chris@76	1010 // Censor all the important text...
Chris@76	1011 censorText($message['body']);
Chris@76	1012 censorText($message['subject']);
Chris@76	1013
Chris@76	1014 // Run UBBC interpreter on the message.
Chris@76	1015 $message['body'] = parse_bbc($message['body'], true, 'pm' . $message['id_pm']);
Chris@76	1016
Chris@76	1017 // Send the array.
Chris@76	1018 $output = array(
Chris@76	1019 'alternate' => $counter % 2,
Chris@76	1020 'id' => $message['id_pm'],
Chris@76	1021 'member' => &$memberContext[$message['id_member_from']],
Chris@76	1022 'subject' => $message['subject'],
Chris@76	1023 'time' => timeformat($message['msgtime']),
Chris@76	1024 'timestamp' => forum_time(true, $message['msgtime']),
Chris@76	1025 'counter' => $counter,
Chris@76	1026 'body' => $message['body'],
Chris@76	1027 'recipients' => &$recipients[$message['id_pm']],
Chris@76	1028 'number_recipients' => count($recipients[$message['id_pm']]['to']),
Chris@76	1029 'labels' => &$context['message_labels'][$message['id_pm']],
Chris@76	1030 'fully_labeled' => count($context['message_labels'][$message['id_pm']]) == count($context['labels']),
Chris@76	1031 'is_replied_to' => &$context['message_replied'][$message['id_pm']],
Chris@76	1032 'is_unread' => &$context['message_unread'][$message['id_pm']],
Chris@76	1033 'is_selected' => !empty($temp_pm_selected) && in_array($message['id_pm'], $temp_pm_selected),
Chris@76	1034 );
Chris@76	1035
Chris@76	1036 $counter++;
Chris@76	1037
Chris@76	1038 return $output;
Chris@76	1039 }
Chris@76	1040
Chris@76	1041 function MessageSearch()
Chris@76	1042 {
Chris@76	1043 global $context, $txt, $scripturl, $modSettings, $smcFunc;
Chris@76	1044
Chris@76	1045 if (isset($_REQUEST['params']))
Chris@76	1046 {
Chris@76	1047 $temp_params = explode('\|"\|', base64_decode(strtr($_REQUEST['params'], array(' ' => '+'))));
Chris@76	1048 $context['search_params'] = array();
Chris@76	1049 foreach ($temp_params as $i => $data)
Chris@76	1050 {
Chris@76	1051 @list ($k, $v) = explode('\|\'\|', $data);
Chris@76	1052 $context['search_params'][$k] = $v;
Chris@76	1053 }
Chris@76	1054 }
Chris@76	1055 if (isset($_REQUEST['search']))
Chris@76	1056 $context['search_params']['search'] = un_htmlspecialchars($_REQUEST['search']);
Chris@76	1057
Chris@76	1058 if (isset($context['search_params']['search']))
Chris@76	1059 $context['search_params']['search'] = htmlspecialchars($context['search_params']['search']);
Chris@76	1060 if (isset($context['search_params']['userspec']))
Chris@76	1061 $context['search_params']['userspec'] = htmlspecialchars($context['search_params']['userspec']);
Chris@76	1062
Chris@76	1063 if (!empty($context['search_params']['searchtype']))
Chris@76	1064 $context['search_params']['searchtype'] = 2;
Chris@76	1065
Chris@76	1066 if (!empty($context['search_params']['minage']))
Chris@76	1067 $context['search_params']['minage'] = (int) $context['search_params']['minage'];
Chris@76	1068
Chris@76	1069 if (!empty($context['search_params']['maxage']))
Chris@76	1070 $context['search_params']['maxage'] = (int) $context['search_params']['maxage'];
Chris@76	1071
Chris@76	1072 $context['search_params']['subject_only'] = !empty($context['search_params']['subject_only']);
Chris@76	1073 $context['search_params']['show_complete'] = !empty($context['search_params']['show_complete']);
Chris@76	1074
Chris@76	1075 // Create the array of labels to be searched.
Chris@76	1076 $context['search_labels'] = array();
Chris@76	1077 $searchedLabels = isset($context['search_params']['labels']) && $context['search_params']['labels'] != '' ? explode(',', $context['search_params']['labels']) : array();
Chris@76	1078 foreach ($context['labels'] as $label)
Chris@76	1079 {
Chris@76	1080 $context['search_labels'][] = array(
Chris@76	1081 'id' => $label['id'],
Chris@76	1082 'name' => $label['name'],
Chris@76	1083 'checked' => !empty($searchedLabels) ? in_array($label['id'], $searchedLabels) : true,
Chris@76	1084 );
Chris@76	1085 }
Chris@76	1086
Chris@76	1087 // Are all the labels checked?
Chris@76	1088 $context['check_all'] = empty($searchedLabels) \|\| count($context['search_labels']) == count($searchedLabels);
Chris@76	1089
Chris@76	1090 // Load the error text strings if there were errors in the search.
Chris@76	1091 if (!empty($context['search_errors']))
Chris@76	1092 {
Chris@76	1093 loadLanguage('Errors');
Chris@76	1094 $context['search_errors']['messages'] = array();
Chris@76	1095 foreach ($context['search_errors'] as $search_error => $dummy)
Chris@76	1096 {
Chris@76	1097 if ($search_error == 'messages')
Chris@76	1098 continue;
Chris@76	1099
Chris@76	1100 $context['search_errors']['messages'][] = $txt['error_' . $search_error];
Chris@76	1101 }
Chris@76	1102 }
Chris@76	1103
Chris@76	1104 $context['simple_search'] = isset($context['search_params']['advanced']) ? empty($context['search_params']['advanced']) : !empty($modSettings['simpleSearch']) && !isset($_REQUEST['advanced']);
Chris@76	1105 $context['page_title'] = $txt['pm_search_title'];
Chris@76	1106 $context['sub_template'] = 'search';
Chris@76	1107 $context['linktree'][] = array(
Chris@76	1108 'url' => $scripturl . '?action=pm;sa=search',
Chris@76	1109 'name' => $txt['pm_search_bar_title'],
Chris@76	1110 );
Chris@76	1111 }
Chris@76	1112
Chris@76	1113 function MessageSearch2()
Chris@76	1114 {
Chris@76	1115 global $scripturl, $modSettings, $user_info, $context, $txt;
Chris@76	1116 global $memberContext, $smcFunc;
Chris@76	1117
Chris@76	1118 if (!empty($context['load_average']) && !empty($modSettings['loadavg_search']) && $context['load_average'] >= $modSettings['loadavg_search'])
Chris@76	1119 fatal_lang_error('loadavg_search_disabled', false);
Chris@76	1120
Chris@76	1121 // !!! For the moment force the folder to the inbox.
Chris@76	1122 $context['folder'] = 'inbox';
Chris@76	1123
Chris@76	1124 // Some useful general permissions.
Chris@76	1125 $context['can_send_pm'] = allowedTo('pm_send');
Chris@76	1126
Chris@76	1127 // Some hardcoded veriables that can be tweaked if required.
Chris@76	1128 $maxMembersToSearch = 500;
Chris@76	1129
Chris@76	1130 // Extract all the search parameters.
Chris@76	1131 $search_params = array();
Chris@76	1132 if (isset($_REQUEST['params']))
Chris@76	1133 {
Chris@76	1134 $temp_params = explode('\|"\|', base64_decode(strtr($_REQUEST['params'], array(' ' => '+'))));
Chris@76	1135 foreach ($temp_params as $i => $data)
Chris@76	1136 {
Chris@76	1137 @list ($k, $v) = explode('\|\'\|', $data);
Chris@76	1138 $search_params[$k] = $v;
Chris@76	1139 }
Chris@76	1140 }
Chris@76	1141
Chris@76	1142 $context['start'] = isset($_GET['start']) ? (int) $_GET['start'] : 0;
Chris@76	1143
Chris@76	1144 // Store whether simple search was used (needed if the user wants to do another query).
Chris@76	1145 if (!isset($search_params['advanced']))
Chris@76	1146 $search_params['advanced'] = empty($_REQUEST['advanced']) ? 0 : 1;
Chris@76	1147
Chris@76	1148 // 1 => 'allwords' (default, don't set as param) / 2 => 'anywords'.
Chris@76	1149 if (!empty($search_params['searchtype']) \|\| (!empty($_REQUEST['searchtype']) && $_REQUEST['searchtype'] == 2))
Chris@76	1150 $search_params['searchtype'] = 2;
Chris@76	1151
Chris@76	1152 // Minimum age of messages. Default to zero (don't set param in that case).
Chris@76	1153 if (!empty($search_params['minage']) \|\| (!empty($_REQUEST['minage']) && $_REQUEST['minage'] > 0))
Chris@76	1154 $search_params['minage'] = !empty($search_params['minage']) ? (int) $search_params['minage'] : (int) $_REQUEST['minage'];
Chris@76	1155
Chris@76	1156 // Maximum age of messages. Default to infinite (9999 days: param not set).
Chris@76	1157 if (!empty($search_params['maxage']) \|\| (!empty($_REQUEST['maxage']) && $_REQUEST['maxage'] != 9999))
Chris@76	1158 $search_params['maxage'] = !empty($search_params['maxage']) ? (int) $search_params['maxage'] : (int) $_REQUEST['maxage'];
Chris@76	1159
Chris@76	1160 $search_params['subject_only'] = !empty($search_params['subject_only']) \|\| !empty($_REQUEST['subject_only']);
Chris@76	1161 $search_params['show_complete'] = !empty($search_params['show_complete']) \|\| !empty($_REQUEST['show_complete']);
Chris@76	1162
Chris@76	1163 // Default the user name to a wildcard matching every user (*).
Chris@76	1164 if (!empty($search_params['user_spec']) \|\| (!empty($_REQUEST['userspec']) && $_REQUEST['userspec'] != '*'))
Chris@76	1165 $search_params['userspec'] = isset($search_params['userspec']) ? $search_params['userspec'] : $_REQUEST['userspec'];
Chris@76	1166
Chris@76	1167 // This will be full of all kinds of parameters!
Chris@76	1168 $searchq_parameters = array();
Chris@76	1169
Chris@76	1170 // If there's no specific user, then don't mention it in the main query.
Chris@76	1171 if (empty($search_params['userspec']))
Chris@76	1172 $userQuery = '';
Chris@76	1173 else
Chris@76	1174 {
Chris@76	1175 $userString = strtr($smcFunc['htmlspecialchars']($search_params['userspec'], ENT_QUOTES), array('"' => '"'));
Chris@76	1176 $userString = strtr($userString, array('%' => '\%', '_' => '\_', '*' => '%', '?' => '_'));
Chris@76	1177
Chris@76	1178 preg_match_all('~"([^"]+)"~', $userString, $matches);
Chris@76	1179 $possible_users = array_merge($matches[1], explode(',', preg_replace('~"[^"]+"~', '', $userString)));
Chris@76	1180
Chris@76	1181 for ($k = 0, $n = count($possible_users); $k < $n; $k++)
Chris@76	1182 {
Chris@76	1183 $possible_users[$k] = trim($possible_users[$k]);
Chris@76	1184
Chris@76	1185 if (strlen($possible_users[$k]) == 0)
Chris@76	1186 unset($possible_users[$k]);
Chris@76	1187 }
Chris@76	1188
Chris@76	1189 // Who matches those criteria?
Chris@76	1190 // !!! This doesn't support sent item searching.
Chris@76	1191 $request = $smcFunc['db_query']('', '
Chris@76	1192 SELECT id_member
Chris@76	1193 FROM {db_prefix}members
Chris@76	1194 WHERE real_name LIKE {raw:real_name_implode}',
Chris@76	1195 array(
Chris@76	1196 'real_name_implode' => '\'' . implode('\' OR real_name LIKE \'', $possible_users) . '\'',
Chris@76	1197 )
Chris@76	1198 );
Chris@76	1199 // Simply do nothing if there're too many members matching the criteria.
Chris@76	1200 if ($smcFunc['db_num_rows']($request) > $maxMembersToSearch)
Chris@76	1201 $userQuery = '';
Chris@76	1202 elseif ($smcFunc['db_num_rows']($request) == 0)
Chris@76	1203 {
Chris@76	1204 $userQuery = 'AND pm.id_member_from = 0 AND (pm.from_name LIKE {raw:guest_user_name_implode})';
Chris@76	1205 $searchq_parameters['guest_user_name_implode'] = '\'' . implode('\' OR pm.from_name LIKE \'', $possible_users) . '\'';
Chris@76	1206 }
Chris@76	1207 else
Chris@76	1208 {
Chris@76	1209 $memberlist = array();
Chris@76	1210 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	1211 $memberlist[] = $row['id_member'];
Chris@76	1212 $userQuery = 'AND (pm.id_member_from IN ({array_int:member_list}) OR (pm.id_member_from = 0 AND (pm.from_name LIKE {raw:guest_user_name_implode})))';
Chris@76	1213 $searchq_parameters['guest_user_name_implode'] = '\'' . implode('\' OR pm.from_name LIKE \'', $possible_users) . '\'';
Chris@76	1214 $searchq_parameters['member_list'] = $memberlist;
Chris@76	1215 }
Chris@76	1216 $smcFunc['db_free_result']($request);
Chris@76	1217 }
Chris@76	1218
Chris@76	1219 // Setup the sorting variables...
Chris@76	1220 // !!! Add more in here!
Chris@76	1221 $sort_columns = array(
Chris@76	1222 'pm.id_pm',
Chris@76	1223 );
Chris@76	1224 if (empty($search_params['sort']) && !empty($_REQUEST['sort']))
Chris@76	1225 list ($search_params['sort'], $search_params['sort_dir']) = array_pad(explode('\|', $_REQUEST['sort']), 2, '');
Chris@76	1226 $search_params['sort'] = !empty($search_params['sort']) && in_array($search_params['sort'], $sort_columns) ? $search_params['sort'] : 'pm.id_pm';
Chris@76	1227 $search_params['sort_dir'] = !empty($search_params['sort_dir']) && $search_params['sort_dir'] == 'asc' ? 'asc' : 'desc';
Chris@76	1228
Chris@76	1229 // Sort out any labels we may be searching by.
Chris@76	1230 $labelQuery = '';
Chris@76	1231 if ($context['folder'] == 'inbox' && !empty($search_params['advanced']) && $context['currently_using_labels'])
Chris@76	1232 {
Chris@76	1233 // Came here from pagination? Put them back into $_REQUEST for sanitization.
Chris@76	1234 if (isset($search_params['labels']))
Chris@76	1235 $_REQUEST['searchlabel'] = explode(',', $search_params['labels']);
Chris@76	1236
Chris@76	1237 // Assuming we have some labels - make them all integers.
Chris@76	1238 if (!empty($_REQUEST['searchlabel']) && is_array($_REQUEST['searchlabel']))
Chris@76	1239 {
Chris@76	1240 foreach ($_REQUEST['searchlabel'] as $key => $id)
Chris@76	1241 $_REQUEST['searchlabel'][$key] = (int) $id;
Chris@76	1242 }
Chris@76	1243 else
Chris@76	1244 $_REQUEST['searchlabel'] = array();
Chris@76	1245
Chris@76	1246 // Now that everything is cleaned up a bit, make the labels a param.
Chris@76	1247 $search_params['labels'] = implode(',', $_REQUEST['searchlabel']);
Chris@76	1248
Chris@76	1249 // No labels selected? That must be an error!
Chris@76	1250 if (empty($_REQUEST['searchlabel']))
Chris@76	1251 $context['search_errors']['no_labels_selected'] = true;
Chris@76	1252 // Otherwise prepare the query!
Chris@76	1253 elseif (count($_REQUEST['searchlabel']) != count($context['labels']))
Chris@76	1254 {
Chris@76	1255 $labelQuery = '
Chris@76	1256 AND {raw:label_implode}';
Chris@76	1257
Chris@76	1258 $labelStatements = array();
Chris@76	1259 foreach ($_REQUEST['searchlabel'] as $label)
Chris@76	1260 $labelStatements[] = $smcFunc['db_quote']('FIND_IN_SET({string:label}, pmr.labels) != 0', array(
Chris@76	1261 'label' => $label,
Chris@76	1262 ));
Chris@76	1263
Chris@76	1264 $searchq_parameters['label_implode'] = '(' . implode(' OR ', $labelStatements) . ')';
Chris@76	1265 }
Chris@76	1266 }
Chris@76	1267
Chris@76	1268 // What are we actually searching for?
Chris@76	1269 $search_params['search'] = !empty($search_params['search']) ? $search_params['search'] : (isset($_REQUEST['search']) ? $_REQUEST['search'] : '');
Chris@76	1270 // If we ain't got nothing - we should error!
Chris@76	1271 if (!isset($search_params['search']) \|\| $search_params['search'] == '')
Chris@76	1272 $context['search_errors']['invalid_search_string'] = true;
Chris@76	1273
Chris@76	1274 // Extract phrase parts first (e.g. some words "this is a phrase" some more words.)
Chris@76	1275 preg_match_all('~(?:^\|\s)([-]?)"([^"]+)"(?:$\|\s)~' . ($context['utf8'] ? 'u' : ''), $search_params['search'], $matches, PREG_PATTERN_ORDER);
Chris@76	1276 $searchArray = $matches[2];
Chris@76	1277
Chris@76	1278 // Remove the phrase parts and extract the words.
Chris@76	1279 $tempSearch = explode(' ', preg_replace('~(?:^\|\s)(?:[-]?)"(?:[^"]+)"(?:$\|\s)~' . ($context['utf8'] ? 'u' : ''), ' ', $search_params['search']));
Chris@76	1280
Chris@76	1281 // A minus sign in front of a word excludes the word.... so...
Chris@76	1282 $excludedWords = array();
Chris@76	1283
Chris@76	1284 // .. first, we check for things like -"some words", but not "-some words".
Chris@76	1285 foreach ($matches[1] as $index => $word)
Chris@76	1286 if ($word == '-')
Chris@76	1287 {
Chris@76	1288 $word = $smcFunc['strtolower'](trim($searchArray[$index]));
Chris@76	1289 if (strlen($word) > 0)
Chris@76	1290 $excludedWords[] = $word;
Chris@76	1291 unset($searchArray[$index]);
Chris@76	1292 }
Chris@76	1293
Chris@76	1294 // Now we look for -test, etc.... normaller.
Chris@76	1295 foreach ($tempSearch as $index => $word)
Chris@76	1296 if (strpos(trim($word), '-') === 0)
Chris@76	1297 {
Chris@76	1298 $word = substr($smcFunc['strtolower'](trim($word)), 1);
Chris@76	1299 if (strlen($word) > 0)
Chris@76	1300 $excludedWords[] = $word;
Chris@76	1301 unset($tempSearch[$index]);
Chris@76	1302 }
Chris@76	1303
Chris@76	1304 $searchArray = array_merge($searchArray, $tempSearch);
Chris@76	1305
Chris@76	1306 // Trim everything and make sure there are no words that are the same.
Chris@76	1307 foreach ($searchArray as $index => $value)
Chris@76	1308 {
Chris@76	1309 $searchArray[$index] = $smcFunc['strtolower'](trim($value));
Chris@76	1310 if ($searchArray[$index] == '')
Chris@76	1311 unset($searchArray[$index]);
Chris@76	1312 else
Chris@76	1313 {
Chris@76	1314 // Sort out entities first.
Chris@76	1315 $searchArray[$index] = $smcFunc['htmlspecialchars']($searchArray[$index]);
Chris@76	1316 }
Chris@76	1317 }
Chris@76	1318 $searchArray = array_unique($searchArray);
Chris@76	1319
Chris@76	1320 // Create an array of replacements for highlighting.
Chris@76	1321 $context['mark'] = array();
Chris@76	1322 foreach ($searchArray as $word)
Chris@76	1323 $context['mark'][$word] = '<strong class="highlight">' . $word . '</strong>';
Chris@76	1324
Chris@76	1325 // This contains everything
Chris@76	1326 $searchWords = array_merge($searchArray, $excludedWords);
Chris@76	1327
Chris@76	1328 // Make sure at least one word is being searched for.
Chris@76	1329 if (empty($searchArray))
Chris@76	1330 $context['search_errors']['invalid_search_string'] = true;
Chris@76	1331
Chris@76	1332 // Sort out the search query so the user can edit it - if they want.
Chris@76	1333 $context['search_params'] = $search_params;
Chris@76	1334 if (isset($context['search_params']['search']))
Chris@76	1335 $context['search_params']['search'] = htmlspecialchars($context['search_params']['search']);
Chris@76	1336 if (isset($context['search_params']['userspec']))
Chris@76	1337 $context['search_params']['userspec'] = htmlspecialchars($context['search_params']['userspec']);
Chris@76	1338
Chris@76	1339 // Now we have all the parameters, combine them together for pagination and the like...
Chris@76	1340 $context['params'] = array();
Chris@76	1341 foreach ($search_params as $k => $v)
Chris@76	1342 $context['params'][] = $k . '\|\'\|' . $v;
Chris@76	1343 $context['params'] = base64_encode(implode('\|"\|', $context['params']));
Chris@76	1344
Chris@76	1345 // Compile the subject query part.
Chris@76	1346 $andQueryParts = array();
Chris@76	1347
Chris@76	1348 foreach ($searchWords as $index => $word)
Chris@76	1349 {
Chris@76	1350 if ($word == '')
Chris@76	1351 continue;
Chris@76	1352
Chris@76	1353 if ($search_params['subject_only'])
Chris@76	1354 $andQueryParts[] = 'pm.subject' . (in_array($word, $excludedWords) ? ' NOT' : '') . ' LIKE {string:search_' . $index . '}';
Chris@76	1355 else
Chris@76	1356 $andQueryParts[] = '(pm.subject' . (in_array($word, $excludedWords) ? ' NOT' : '') . ' LIKE {string:search_' . $index . '} ' . (in_array($word, $excludedWords) ? 'AND pm.body NOT' : 'OR pm.body') . ' LIKE {string:search_' . $index . '})';
Chris@76	1357 $searchq_parameters['search_' . $index] = '%' . strtr($word, array('_' => '\\_', '%' => '\\%')) . '%';
Chris@76	1358 }
Chris@76	1359
Chris@76	1360 $searchQuery = ' 1=1';
Chris@76	1361 if (!empty($andQueryParts))
Chris@76	1362 $searchQuery = implode(!empty($search_params['searchtype']) && $search_params['searchtype'] == 2 ? ' OR ' : ' AND ', $andQueryParts);
Chris@76	1363
Chris@76	1364 // Age limits?
Chris@76	1365 $timeQuery = '';
Chris@76	1366 if (!empty($search_params['minage']))
Chris@76	1367 $timeQuery .= ' AND pm.msgtime < ' . (time() - $search_params['minage'] * 86400);
Chris@76	1368 if (!empty($search_params['maxage']))
Chris@76	1369 $timeQuery .= ' AND pm.msgtime > ' . (time() - $search_params['maxage'] * 86400);
Chris@76	1370
Chris@76	1371 // If we have errors - return back to the first screen...
Chris@76	1372 if (!empty($context['search_errors']))
Chris@76	1373 {
Chris@76	1374 $_REQUEST['params'] = $context['params'];
Chris@76	1375 return MessageSearch();
Chris@76	1376 }
Chris@76	1377
Chris@76	1378 // Get the amount of results.
Chris@76	1379 $request = $smcFunc['db_query']('', '
Chris@76	1380 SELECT COUNT(*)
Chris@76	1381 FROM {db_prefix}pm_recipients AS pmr
Chris@76	1382 INNER JOIN {db_prefix}personal_messages AS pm ON (pm.id_pm = pmr.id_pm)
Chris@76	1383 WHERE ' . ($context['folder'] == 'inbox' ? '
Chris@76	1384 pmr.id_member = {int:current_member}
Chris@76	1385 AND pmr.deleted = {int:not_deleted}' : '
Chris@76	1386 pm.id_member_from = {int:current_member}
Chris@76	1387 AND pm.deleted_by_sender = {int:not_deleted}') . '
Chris@76	1388 ' . $userQuery . $labelQuery . $timeQuery . '
Chris@76	1389 AND (' . $searchQuery . ')',
Chris@76	1390 array_merge($searchq_parameters, array(
Chris@76	1391 'current_member' => $user_info['id'],
Chris@76	1392 'not_deleted' => 0,
Chris@76	1393 ))
Chris@76	1394 );
Chris@76	1395 list ($numResults) = $smcFunc['db_fetch_row']($request);
Chris@76	1396 $smcFunc['db_free_result']($request);
Chris@76	1397
Chris@76	1398 // Get all the matching messages... using standard search only (No caching and the like!)
Chris@76	1399 // !!! This doesn't support sent item searching yet.
Chris@76	1400 $request = $smcFunc['db_query']('', '
Chris@76	1401 SELECT pm.id_pm, pm.id_pm_head, pm.id_member_from
Chris@76	1402 FROM {db_prefix}pm_recipients AS pmr
Chris@76	1403 INNER JOIN {db_prefix}personal_messages AS pm ON (pm.id_pm = pmr.id_pm)
Chris@76	1404 WHERE ' . ($context['folder'] == 'inbox' ? '
Chris@76	1405 pmr.id_member = {int:current_member}
Chris@76	1406 AND pmr.deleted = {int:not_deleted}' : '
Chris@76	1407 pm.id_member_from = {int:current_member}
Chris@76	1408 AND pm.deleted_by_sender = {int:not_deleted}') . '
Chris@76	1409 ' . $userQuery . $labelQuery . $timeQuery . '
Chris@76	1410 AND (' . $searchQuery . ')
Chris@76	1411 ORDER BY ' . $search_params['sort'] . ' ' . $search_params['sort_dir'] . '
Chris@76	1412 LIMIT ' . $context['start'] . ', ' . $modSettings['search_results_per_page'],
Chris@76	1413 array_merge($searchq_parameters, array(
Chris@76	1414 'current_member' => $user_info['id'],
Chris@76	1415 'not_deleted' => 0,
Chris@76	1416 ))
Chris@76	1417 );
Chris@76	1418 $foundMessages = array();
Chris@76	1419 $posters = array();
Chris@76	1420 $head_pms = array();
Chris@76	1421 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	1422 {
Chris@76	1423 $foundMessages[] = $row['id_pm'];
Chris@76	1424 $posters[] = $row['id_member_from'];
Chris@76	1425 $head_pms[$row['id_pm']] = $row['id_pm_head'];
Chris@76	1426 }
Chris@76	1427 $smcFunc['db_free_result']($request);
Chris@76	1428
Chris@76	1429 // Find the real head pms!
Chris@76	1430 if ($context['display_mode'] == 2 && !empty($head_pms))
Chris@76	1431 {
Chris@76	1432 $request = $smcFunc['db_query']('', '
Chris@76	1433 SELECT MAX(pm.id_pm) AS id_pm, pm.id_pm_head
Chris@76	1434 FROM {db_prefix}personal_messages AS pm
Chris@76	1435 INNER JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm)
Chris@76	1436 WHERE pm.id_pm_head IN ({array_int:head_pms})
Chris@76	1437 AND pmr.id_member = {int:current_member}
Chris@76	1438 AND pmr.deleted = {int:not_deleted}
Chris@76	1439 GROUP BY pm.id_pm_head
Chris@76	1440 LIMIT {int:limit}',
Chris@76	1441 array(
Chris@76	1442 'head_pms' => array_unique($head_pms),
Chris@76	1443 'current_member' => $user_info['id'],
Chris@76	1444 'not_deleted' => 0,
Chris@76	1445 'limit' => count($head_pms),
Chris@76	1446 )
Chris@76	1447 );
Chris@76	1448 $real_pm_ids = array();
Chris@76	1449 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	1450 $real_pm_ids[$row['id_pm_head']] = $row['id_pm'];
Chris@76	1451 $smcFunc['db_free_result']($request);
Chris@76	1452 }
Chris@76	1453
Chris@76	1454 // Load the users...
Chris@76	1455 $posters = array_unique($posters);
Chris@76	1456 if (!empty($posters))
Chris@76	1457 loadMemberData($posters);
Chris@76	1458
Chris@76	1459 // Sort out the page index.
Chris@76	1460 $context['page_index'] = constructPageIndex($scripturl . '?action=pm;sa=search2;params=' . $context['params'], $_GET['start'], $numResults, $modSettings['search_results_per_page'], false);
Chris@76	1461
Chris@76	1462 $context['message_labels'] = array();
Chris@76	1463 $context['message_replied'] = array();
Chris@76	1464 $context['personal_messages'] = array();
Chris@76	1465
Chris@76	1466 if (!empty($foundMessages))
Chris@76	1467 {
Chris@76	1468 // Now get recipients (but don't include bcc-recipients for your inbox, you're not supposed to know :P!)
Chris@76	1469 $request = $smcFunc['db_query']('', '
Chris@76	1470 SELECT
Chris@76	1471 pmr.id_pm, mem_to.id_member AS id_member_to, mem_to.real_name AS to_name,
Chris@76	1472 pmr.bcc, pmr.labels, pmr.is_read
Chris@76	1473 FROM {db_prefix}pm_recipients AS pmr
Chris@76	1474 LEFT JOIN {db_prefix}members AS mem_to ON (mem_to.id_member = pmr.id_member)
Chris@76	1475 WHERE pmr.id_pm IN ({array_int:message_list})',
Chris@76	1476 array(
Chris@76	1477 'message_list' => $foundMessages,
Chris@76	1478 )
Chris@76	1479 );
Chris@76	1480 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	1481 {
Chris@76	1482 if ($context['folder'] == 'sent' \|\| empty($row['bcc']))
Chris@76	1483 $recipients[$row['id_pm']][empty($row['bcc']) ? 'to' : 'bcc'][] = empty($row['id_member_to']) ? $txt['guest_title'] : '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member_to'] . '">' . $row['to_name'] . '</a>';
Chris@76	1484
Chris@76	1485 if ($row['id_member_to'] == $user_info['id'] && $context['folder'] != 'sent')
Chris@76	1486 {
Chris@76	1487 $context['message_replied'][$row['id_pm']] = $row['is_read'] & 2;
Chris@76	1488
Chris@76	1489 $row['labels'] = $row['labels'] == '' ? array() : explode(',', $row['labels']);
Chris@76	1490 // This is a special need for linking to messages.
Chris@76	1491 foreach ($row['labels'] as $v)
Chris@76	1492 {
Chris@76	1493 if (isset($context['labels'][(int) $v]))
Chris@76	1494 $context['message_labels'][$row['id_pm']][(int) $v] = array('id' => $v, 'name' => $context['labels'][(int) $v]['name']);
Chris@76	1495
Chris@76	1496 // Here we find the first label on a message - for linking to posts in results
Chris@76	1497 if (!isset($context['first_label'][$row['id_pm']]) && !in_array('-1', $row['labels']))
Chris@76	1498 $context['first_label'][$row['id_pm']] = (int) $v;
Chris@76	1499 }
Chris@76	1500 }
Chris@76	1501 }
Chris@76	1502
Chris@76	1503 // Prepare the query for the callback!
Chris@76	1504 $request = $smcFunc['db_query']('', '
Chris@76	1505 SELECT pm.id_pm, pm.subject, pm.id_member_from, pm.body, pm.msgtime, pm.from_name
Chris@76	1506 FROM {db_prefix}personal_messages AS pm
Chris@76	1507 WHERE pm.id_pm IN ({array_int:message_list})
Chris@76	1508 ORDER BY ' . $search_params['sort'] . ' ' . $search_params['sort_dir'] . '
Chris@76	1509 LIMIT ' . count($foundMessages),
Chris@76	1510 array(
Chris@76	1511 'message_list' => $foundMessages,
Chris@76	1512 )
Chris@76	1513 );
Chris@76	1514 $counter = 0;
Chris@76	1515 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	1516 {
Chris@76	1517 // If there's no message subject, use the default.
Chris@76	1518 $row['subject'] = $row['subject'] == '' ? $txt['no_subject'] : $row['subject'];
Chris@76	1519
Chris@76	1520 // Load this posters context info, if it ain't there then fill in the essentials...
Chris@76	1521 if (!loadMemberContext($row['id_member_from'], true))
Chris@76	1522 {
Chris@76	1523 $memberContext[$row['id_member_from']]['name'] = $row['from_name'];
Chris@76	1524 $memberContext[$row['id_member_from']]['id'] = 0;
Chris@76	1525 $memberContext[$row['id_member_from']]['group'] = $txt['guest_title'];
Chris@76	1526 $memberContext[$row['id_member_from']]['link'] = $row['from_name'];
Chris@76	1527 $memberContext[$row['id_member_from']]['email'] = '';
Chris@76	1528 $memberContext[$row['id_member_from']]['show_email'] = showEmailAddress(true, 0);
Chris@76	1529 $memberContext[$row['id_member_from']]['is_guest'] = true;
Chris@76	1530 }
Chris@76	1531
Chris@76	1532 // Censor anything we don't want to see...
Chris@76	1533 censorText($row['body']);
Chris@76	1534 censorText($row['subject']);
Chris@76	1535
Chris@76	1536 // Parse out any BBC...
Chris@76	1537 $row['body'] = parse_bbc($row['body'], true, 'pm' . $row['id_pm']);
Chris@76	1538
Chris@76	1539 $href = $scripturl . '?action=pm;f=' . $context['folder'] . (isset($context['first_label'][$row['id_pm']]) ? ';l=' . $context['first_label'][$row['id_pm']] : '') . ';pmid=' . ($context['display_mode'] == 2 && isset($real_pm_ids[$head_pms[$row['id_pm']]]) ? $real_pm_ids[$head_pms[$row['id_pm']]] : $row['id_pm']) . '#msg' . $row['id_pm'];
Chris@76	1540 $context['personal_messages'][] = array(
Chris@76	1541 'id' => $row['id_pm'],
Chris@76	1542 'member' => &$memberContext[$row['id_member_from']],
Chris@76	1543 'subject' => $row['subject'],
Chris@76	1544 'body' => $row['body'],
Chris@76	1545 'time' => timeformat($row['msgtime']),
Chris@76	1546 'recipients' => &$recipients[$row['id_pm']],
Chris@76	1547 'labels' => &$context['message_labels'][$row['id_pm']],
Chris@76	1548 'fully_labeled' => count($context['message_labels'][$row['id_pm']]) == count($context['labels']),
Chris@76	1549 'is_replied_to' => &$context['message_replied'][$row['id_pm']],
Chris@76	1550 'href' => $href,
Chris@76	1551 'link' => '<a href="' . $href . '">' . $row['subject'] . '</a>',
Chris@76	1552 'counter' => ++$counter,
Chris@76	1553 );
Chris@76	1554 }
Chris@76	1555 $smcFunc['db_free_result']($request);
Chris@76	1556 }
Chris@76	1557
Chris@76	1558 // Finish off the context.
Chris@76	1559 $context['page_title'] = $txt['pm_search_title'];
Chris@76	1560 $context['sub_template'] = 'search_results';
Chris@76	1561 $context['menu_data_' . $context['pm_menu_id']]['current_area'] = 'search';
Chris@76	1562 $context['linktree'][] = array(
Chris@76	1563 'url' => $scripturl . '?action=pm;sa=search',
Chris@76	1564 'name' => $txt['pm_search_bar_title'],
Chris@76	1565 );
Chris@76	1566 }
Chris@76	1567
Chris@76	1568 // Send a new message?
Chris@76	1569 function MessagePost()
Chris@76	1570 {
Chris@76	1571 global $txt, $sourcedir, $scripturl, $modSettings;
Chris@76	1572 global $context, $options, $smcFunc, $language, $user_info;
Chris@76	1573
Chris@76	1574 isAllowedTo('pm_send');
Chris@76	1575
Chris@76	1576 loadLanguage('PersonalMessage');
Chris@76	1577 // Just in case it was loaded from somewhere else.
Chris@76	1578 if (!WIRELESS)
Chris@76	1579 {
Chris@76	1580 loadTemplate('PersonalMessage');
Chris@76	1581 $context['sub_template'] = 'send';
Chris@76	1582 }
Chris@76	1583
Chris@76	1584 // Extract out the spam settings - cause it's neat.
Chris@76	1585 list ($modSettings['max_pm_recipients'], $modSettings['pm_posts_verification'], $modSettings['pm_posts_per_hour']) = explode(',', $modSettings['pm_spam_settings']);
Chris@76	1586
Chris@76	1587 // Set the title...
Chris@76	1588 $context['page_title'] = $txt['send_message'];
Chris@76	1589
Chris@76	1590 $context['reply'] = isset($_REQUEST['pmsg']) \|\| isset($_REQUEST['quote']);
Chris@76	1591
Chris@76	1592 // Check whether we've gone over the limit of messages we can send per hour.
Chris@76	1593 if (!empty($modSettings['pm_posts_per_hour']) && !allowedTo(array('admin_forum', 'moderate_forum', 'send_mail')) && $user_info['mod_cache']['bq'] == '0=1' && $user_info['mod_cache']['gq'] == '0=1')
Chris@76	1594 {
Chris@76	1595 // How many messages have they sent this last hour?
Chris@76	1596 $request = $smcFunc['db_query']('', '
Chris@76	1597 SELECT COUNT(pr.id_pm) AS post_count
Chris@76	1598 FROM {db_prefix}personal_messages AS pm
Chris@76	1599 INNER JOIN {db_prefix}pm_recipients AS pr ON (pr.id_pm = pm.id_pm)
Chris@76	1600 WHERE pm.id_member_from = {int:current_member}
Chris@76	1601 AND pm.msgtime > {int:msgtime}',
Chris@76	1602 array(
Chris@76	1603 'current_member' => $user_info['id'],
Chris@76	1604 'msgtime' => time() - 3600,
Chris@76	1605 )
Chris@76	1606 );
Chris@76	1607 list ($postCount) = $smcFunc['db_fetch_row']($request);
Chris@76	1608 $smcFunc['db_free_result']($request);
Chris@76	1609
Chris@76	1610 if (!empty($postCount) && $postCount >= $modSettings['pm_posts_per_hour'])
Chris@76	1611 fatal_lang_error('pm_too_many_per_hour', true, array($modSettings['pm_posts_per_hour']));
Chris@76	1612 }
Chris@76	1613
Chris@76	1614 // Quoting/Replying to a message?
Chris@76	1615 if (!empty($_REQUEST['pmsg']))
Chris@76	1616 {
Chris@76	1617 $pmsg = (int) $_REQUEST['pmsg'];
Chris@76	1618
Chris@76	1619 // Make sure this is yours.
Chris@76	1620 if (!isAccessiblePM($pmsg))
Chris@76	1621 fatal_lang_error('no_access', false);
Chris@76	1622
Chris@76	1623 // Work out whether this is one you've received?
Chris@76	1624 $request = $smcFunc['db_query']('', '
Chris@76	1625 SELECT
Chris@76	1626 id_pm
Chris@76	1627 FROM {db_prefix}pm_recipients
Chris@76	1628 WHERE id_pm = {int:id_pm}
Chris@76	1629 AND id_member = {int:current_member}
Chris@76	1630 LIMIT 1',
Chris@76	1631 array(
Chris@76	1632 'current_member' => $user_info['id'],
Chris@76	1633 'id_pm' => $pmsg,
Chris@76	1634 )
Chris@76	1635 );
Chris@76	1636 $isReceived = $smcFunc['db_num_rows']($request) != 0;
Chris@76	1637 $smcFunc['db_free_result']($request);
Chris@76	1638
Chris@76	1639 // Get the quoted message (and make sure you're allowed to see this quote!).
Chris@76	1640 $request = $smcFunc['db_query']('', '
Chris@76	1641 SELECT
Chris@76	1642 pm.id_pm, CASE WHEN pm.id_pm_head = {int:id_pm_head_empty} THEN pm.id_pm ELSE pm.id_pm_head END AS pm_head,
Chris@76	1643 pm.body, pm.subject, pm.msgtime, mem.member_name, IFNULL(mem.id_member, 0) AS id_member,
Chris@76	1644 IFNULL(mem.real_name, pm.from_name) AS real_name
Chris@76	1645 FROM {db_prefix}personal_messages AS pm' . (!$isReceived ? '' : '
Chris@76	1646 INNER JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = {int:id_pm})') . '
Chris@76	1647 LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = pm.id_member_from)
Chris@76	1648 WHERE pm.id_pm = {int:id_pm}' . (!$isReceived ? '
Chris@76	1649 AND pm.id_member_from = {int:current_member}' : '
Chris@76	1650 AND pmr.id_member = {int:current_member}') . '
Chris@76	1651 LIMIT 1',
Chris@76	1652 array(
Chris@76	1653 'current_member' => $user_info['id'],
Chris@76	1654 'id_pm_head_empty' => 0,
Chris@76	1655 'id_pm' => $pmsg,
Chris@76	1656 )
Chris@76	1657 );
Chris@76	1658 if ($smcFunc['db_num_rows']($request) == 0)
Chris@76	1659 fatal_lang_error('pm_not_yours', false);
Chris@76	1660 $row_quoted = $smcFunc['db_fetch_assoc']($request);
Chris@76	1661 $smcFunc['db_free_result']($request);
Chris@76	1662
Chris@76	1663 // Censor the message.
Chris@76	1664 censorText($row_quoted['subject']);
Chris@76	1665 censorText($row_quoted['body']);
Chris@76	1666
Chris@76	1667 // Add 'Re: ' to it....
Chris@76	1668 if (!isset($context['response_prefix']) && !($context['response_prefix'] = cache_get_data('response_prefix')))
Chris@76	1669 {
Chris@76	1670 if ($language === $user_info['language'])
Chris@76	1671 $context['response_prefix'] = $txt['response_prefix'];
Chris@76	1672 else
Chris@76	1673 {
Chris@76	1674 loadLanguage('index', $language, false);
Chris@76	1675 $context['response_prefix'] = $txt['response_prefix'];
Chris@76	1676 loadLanguage('index');
Chris@76	1677 }
Chris@76	1678 cache_put_data('response_prefix', $context['response_prefix'], 600);
Chris@76	1679 }
Chris@76	1680 $form_subject = $row_quoted['subject'];
Chris@76	1681 if ($context['reply'] && trim($context['response_prefix']) != '' && $smcFunc['strpos']($form_subject, trim($context['response_prefix'])) !== 0)
Chris@76	1682 $form_subject = $context['response_prefix'] . $form_subject;
Chris@76	1683
Chris@76	1684 if (isset($_REQUEST['quote']))
Chris@76	1685 {
Chris@76	1686 // Remove any nested quotes and <br />...
Chris@76	1687 $form_message = preg_replace('~<br ?/?' . '>~i', "\n", $row_quoted['body']);
Chris@76	1688 if (!empty($modSettings['removeNestedQuotes']))
Chris@76	1689 $form_message = preg_replace(array('~\n?\[quote.*?\].+?\[/quote\]\n?~is', '~^\n~', '~\[/quote\]~'), '', $form_message);
Chris@76	1690 if (empty($row_quoted['id_member']))
Chris@76	1691 $form_message = '[quote author="' . $row_quoted['real_name'] . '"]' . "\n" . $form_message . "\n" . '[/quote]';
Chris@76	1692 else
Chris@76	1693 $form_message = '[quote author=' . $row_quoted['real_name'] . ' link=action=profile;u=' . $row_quoted['id_member'] . ' date=' . $row_quoted['msgtime'] . ']' . "\n" . $form_message . "\n" . '[/quote]';
Chris@76	1694 }
Chris@76	1695 else
Chris@76	1696 $form_message = '';
Chris@76	1697
Chris@76	1698 // Do the BBC thang on the message.
Chris@76	1699 $row_quoted['body'] = parse_bbc($row_quoted['body'], true, 'pm' . $row_quoted['id_pm']);
Chris@76	1700
Chris@76	1701 // Set up the quoted message array.
Chris@76	1702 $context['quoted_message'] = array(
Chris@76	1703 'id' => $row_quoted['id_pm'],
Chris@76	1704 'pm_head' => $row_quoted['pm_head'],
Chris@76	1705 'member' => array(
Chris@76	1706 'name' => $row_quoted['real_name'],
Chris@76	1707 'username' => $row_quoted['member_name'],
Chris@76	1708 'id' => $row_quoted['id_member'],
Chris@76	1709 'href' => !empty($row_quoted['id_member']) ? $scripturl . '?action=profile;u=' . $row_quoted['id_member'] : '',
Chris@76	1710 'link' => !empty($row_quoted['id_member']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row_quoted['id_member'] . '">' . $row_quoted['real_name'] . '</a>' : $row_quoted['real_name'],
Chris@76	1711 ),
Chris@76	1712 'subject' => $row_quoted['subject'],
Chris@76	1713 'time' => timeformat($row_quoted['msgtime']),
Chris@76	1714 'timestamp' => forum_time(true, $row_quoted['msgtime']),
Chris@76	1715 'body' => $row_quoted['body']
Chris@76	1716 );
Chris@76	1717 }
Chris@76	1718 else
Chris@76	1719 {
Chris@76	1720 $context['quoted_message'] = false;
Chris@76	1721 $form_subject = '';
Chris@76	1722 $form_message = '';
Chris@76	1723 }
Chris@76	1724
Chris@76	1725 $context['recipients'] = array(
Chris@76	1726 'to' => array(),
Chris@76	1727 'bcc' => array(),
Chris@76	1728 );
Chris@76	1729
Chris@76	1730 // Sending by ID? Replying to all? Fetch the real_name(s).
Chris@76	1731 if (isset($_REQUEST['u']))
Chris@76	1732 {
Chris@76	1733 // If the user is replying to all, get all the other members this was sent to..
Chris@76	1734 if ($_REQUEST['u'] == 'all' && isset($row_quoted))
Chris@76	1735 {
Chris@76	1736 // Firstly, to reply to all we clearly already have $row_quoted - so have the original member from.
Chris@76	1737 if ($row_quoted['id_member'] != $user_info['id'])
Chris@76	1738 $context['recipients']['to'][] = array(
Chris@76	1739 'id' => $row_quoted['id_member'],
Chris@76	1740 'name' => htmlspecialchars($row_quoted['real_name']),
Chris@76	1741 );
Chris@76	1742
Chris@76	1743 // Now to get the others.
Chris@76	1744 $request = $smcFunc['db_query']('', '
Chris@76	1745 SELECT mem.id_member, mem.real_name
Chris@76	1746 FROM {db_prefix}pm_recipients AS pmr
Chris@76	1747 INNER JOIN {db_prefix}members AS mem ON (mem.id_member = pmr.id_member)
Chris@76	1748 WHERE pmr.id_pm = {int:id_pm}
Chris@76	1749 AND pmr.id_member != {int:current_member}
Chris@76	1750 AND pmr.bcc = {int:not_bcc}',
Chris@76	1751 array(
Chris@76	1752 'current_member' => $user_info['id'],
Chris@76	1753 'id_pm' => $pmsg,
Chris@76	1754 'not_bcc' => 0,
Chris@76	1755 )
Chris@76	1756 );
Chris@76	1757 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	1758 $context['recipients']['to'][] = array(
Chris@76	1759 'id' => $row['id_member'],
Chris@76	1760 'name' => $row['real_name'],
Chris@76	1761 );
Chris@76	1762 $smcFunc['db_free_result']($request);
Chris@76	1763 }
Chris@76	1764 else
Chris@76	1765 {
Chris@76	1766 $_REQUEST['u'] = explode(',', $_REQUEST['u']);
Chris@76	1767 foreach ($_REQUEST['u'] as $key => $uID)
Chris@76	1768 $_REQUEST['u'][$key] = (int) $uID;
Chris@76	1769
Chris@76	1770 $_REQUEST['u'] = array_unique($_REQUEST['u']);
Chris@76	1771
Chris@76	1772 $request = $smcFunc['db_query']('', '
Chris@76	1773 SELECT id_member, real_name
Chris@76	1774 FROM {db_prefix}members
Chris@76	1775 WHERE id_member IN ({array_int:member_list})
Chris@76	1776 LIMIT ' . count($_REQUEST['u']),
Chris@76	1777 array(
Chris@76	1778 'member_list' => $_REQUEST['u'],
Chris@76	1779 )
Chris@76	1780 );
Chris@76	1781 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	1782 $context['recipients']['to'][] = array(
Chris@76	1783 'id' => $row['id_member'],
Chris@76	1784 'name' => $row['real_name'],
Chris@76	1785 );
Chris@76	1786 $smcFunc['db_free_result']($request);
Chris@76	1787 }
Chris@76	1788
Chris@76	1789 // Get a literal name list in case the user has JavaScript disabled.
Chris@76	1790 $names = array();
Chris@76	1791 foreach ($context['recipients']['to'] as $to)
Chris@76	1792 $names[] = $to['name'];
Chris@76	1793 $context['to_value'] = empty($names) ? '' : '"' . implode('", "', $names) . '"';
Chris@76	1794 }
Chris@76	1795 else
Chris@76	1796 $context['to_value'] = '';
Chris@76	1797
Chris@76	1798 // Set the defaults...
Chris@76	1799 $context['subject'] = $form_subject != '' ? $form_subject : $txt['no_subject'];
Chris@76	1800 $context['message'] = str_replace(array('"', '<', '>', ' '), array('"', '<', '>', ' '), $form_message);
Chris@76	1801 $context['post_error'] = array();
Chris@76	1802 $context['copy_to_outbox'] = !empty($options['copy_to_outbox']);
Chris@76	1803
Chris@76	1804 // And build the link tree.
Chris@76	1805 $context['linktree'][] = array(
Chris@76	1806 'url' => $scripturl . '?action=pm;sa=send',
Chris@76	1807 'name' => $txt['new_message']
Chris@76	1808 );
Chris@76	1809
Chris@76	1810 $modSettings['disable_wysiwyg'] = !empty($modSettings['disable_wysiwyg']) \|\| empty($modSettings['enableBBC']);
Chris@76	1811
Chris@76	1812 // Needed for the WYSIWYG editor.
Chris@76	1813 require_once($sourcedir . '/Subs-Editor.php');
Chris@76	1814
Chris@76	1815 // Now create the editor.
Chris@76	1816 $editorOptions = array(
Chris@76	1817 'id' => 'message',
Chris@76	1818 'value' => $context['message'],
Chris@76	1819 'height' => '175px',
Chris@76	1820 'width' => '100%',
Chris@76	1821 'labels' => array(
Chris@76	1822 'post_button' => $txt['send_message'],
Chris@76	1823 ),
Chris@76	1824 );
Chris@76	1825 create_control_richedit($editorOptions);
Chris@76	1826
Chris@76	1827 // Store the ID for old compatibility.
Chris@76	1828 $context['post_box_name'] = $editorOptions['id'];
Chris@76	1829
Chris@76	1830 $context['bcc_value'] = '';
Chris@76	1831
Chris@76	1832 $context['require_verification'] = !$user_info['is_admin'] && !empty($modSettings['pm_posts_verification']) && $user_info['posts'] < $modSettings['pm_posts_verification'];
Chris@76	1833 if ($context['require_verification'])
Chris@76	1834 {
Chris@76	1835 $verificationOptions = array(
Chris@76	1836 'id' => 'pm',
Chris@76	1837 );
Chris@76	1838 $context['require_verification'] = create_control_verification($verificationOptions);
Chris@76	1839 $context['visual_verification_id'] = $verificationOptions['id'];
Chris@76	1840 }
Chris@76	1841
Chris@76	1842 // Register this form and get a sequence number in $context.
Chris@76	1843 checkSubmitOnce('register');
Chris@76	1844 }
Chris@76	1845
Chris@76	1846 // An error in the message...
Chris@76	1847 function messagePostError($error_types, $named_recipients, $recipient_ids = array())
Chris@76	1848 {
Chris@76	1849 global $txt, $context, $scripturl, $modSettings;
Chris@76	1850 global $smcFunc, $user_info, $sourcedir;
Chris@76	1851
Chris@76	1852 $context['menu_data_' . $context['pm_menu_id']]['current_area'] = 'send';
Chris@76	1853
Chris@76	1854 if (!WIRELESS)
Chris@76	1855 $context['sub_template'] = 'send';
Chris@76	1856
Chris@76	1857 $context['page_title'] = $txt['send_message'];
Chris@76	1858
Chris@76	1859 // Got some known members?
Chris@76	1860 $context['recipients'] = array(
Chris@76	1861 'to' => array(),
Chris@76	1862 'bcc' => array(),
Chris@76	1863 );
Chris@76	1864 if (!empty($recipient_ids['to']) \|\| !empty($recipient_ids['bcc']))
Chris@76	1865 {
Chris@76	1866 $allRecipients = array_merge($recipient_ids['to'], $recipient_ids['bcc']);
Chris@76	1867
Chris@76	1868 $request = $smcFunc['db_query']('', '
Chris@76	1869 SELECT id_member, real_name
Chris@76	1870 FROM {db_prefix}members
Chris@76	1871 WHERE id_member IN ({array_int:member_list})',
Chris@76	1872 array(
Chris@76	1873 'member_list' => $allRecipients,
Chris@76	1874 )
Chris@76	1875 );
Chris@76	1876 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	1877 {
Chris@76	1878 $recipientType = in_array($row['id_member'], $recipient_ids['bcc']) ? 'bcc' : 'to';
Chris@76	1879 $context['recipients'][$recipientType][] = array(
Chris@76	1880 'id' => $row['id_member'],
Chris@76	1881 'name' => $row['real_name'],
Chris@76	1882 );
Chris@76	1883 }
Chris@76	1884 $smcFunc['db_free_result']($request);
Chris@76	1885 }
Chris@76	1886
Chris@76	1887 // Set everything up like before....
Chris@76	1888 $context['subject'] = isset($_REQUEST['subject']) ? $smcFunc['htmlspecialchars']($_REQUEST['subject']) : '';
Chris@76	1889 $context['message'] = isset($_REQUEST['message']) ? str_replace(array(' '), array('  '), $smcFunc['htmlspecialchars']($_REQUEST['message'])) : '';
Chris@76	1890 $context['copy_to_outbox'] = !empty($_REQUEST['outbox']);
Chris@76	1891 $context['reply'] = !empty($_REQUEST['replied_to']);
Chris@76	1892
Chris@76	1893 if ($context['reply'])
Chris@76	1894 {
Chris@76	1895 $_REQUEST['replied_to'] = (int) $_REQUEST['replied_to'];
Chris@76	1896
Chris@76	1897 $request = $smcFunc['db_query']('', '
Chris@76	1898 SELECT
Chris@76	1899 pm.id_pm, CASE WHEN pm.id_pm_head = {int:no_id_pm_head} THEN pm.id_pm ELSE pm.id_pm_head END AS pm_head,
Chris@76	1900 pm.body, pm.subject, pm.msgtime, mem.member_name, IFNULL(mem.id_member, 0) AS id_member,
Chris@76	1901 IFNULL(mem.real_name, pm.from_name) AS real_name
Chris@76	1902 FROM {db_prefix}personal_messages AS pm' . ($context['folder'] == 'sent' ? '' : '
Chris@76	1903 INNER JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = {int:replied_to})') . '
Chris@76	1904 LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = pm.id_member_from)
Chris@76	1905 WHERE pm.id_pm = {int:replied_to}' . ($context['folder'] == 'sent' ? '
Chris@76	1906 AND pm.id_member_from = {int:current_member}' : '
Chris@76	1907 AND pmr.id_member = {int:current_member}') . '
Chris@76	1908 LIMIT 1',
Chris@76	1909 array(
Chris@76	1910 'current_member' => $user_info['id'],
Chris@76	1911 'no_id_pm_head' => 0,
Chris@76	1912 'replied_to' => $_REQUEST['replied_to'],
Chris@76	1913 )
Chris@76	1914 );
Chris@76	1915 if ($smcFunc['db_num_rows']($request) == 0)
Chris@76	1916 fatal_lang_error('pm_not_yours', false);
Chris@76	1917 $row_quoted = $smcFunc['db_fetch_assoc']($request);
Chris@76	1918 $smcFunc['db_free_result']($request);
Chris@76	1919
Chris@76	1920 censorText($row_quoted['subject']);
Chris@76	1921 censorText($row_quoted['body']);
Chris@76	1922
Chris@76	1923 $context['quoted_message'] = array(
Chris@76	1924 'id' => $row_quoted['id_pm'],
Chris@76	1925 'pm_head' => $row_quoted['pm_head'],
Chris@76	1926 'member' => array(
Chris@76	1927 'name' => $row_quoted['real_name'],
Chris@76	1928 'username' => $row_quoted['member_name'],
Chris@76	1929 'id' => $row_quoted['id_member'],
Chris@76	1930 'href' => !empty($row_quoted['id_member']) ? $scripturl . '?action=profile;u=' . $row_quoted['id_member'] : '',
Chris@76	1931 'link' => !empty($row_quoted['id_member']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row_quoted['id_member'] . '">' . $row_quoted['real_name'] . '</a>' : $row_quoted['real_name'],
Chris@76	1932 ),
Chris@76	1933 'subject' => $row_quoted['subject'],
Chris@76	1934 'time' => timeformat($row_quoted['msgtime']),
Chris@76	1935 'timestamp' => forum_time(true, $row_quoted['msgtime']),
Chris@76	1936 'body' => parse_bbc($row_quoted['body'], true, 'pm' . $row_quoted['id_pm']),
Chris@76	1937 );
Chris@76	1938 }
Chris@76	1939
Chris@76	1940 // Build the link tree....
Chris@76	1941 $context['linktree'][] = array(
Chris@76	1942 'url' => $scripturl . '?action=pm;sa=send',
Chris@76	1943 'name' => $txt['new_message']
Chris@76	1944 );
Chris@76	1945
Chris@76	1946 // Set each of the errors for the template.
Chris@76	1947 loadLanguage('Errors');
Chris@76	1948 $context['post_error'] = array(
Chris@76	1949 'messages' => array(),
Chris@76	1950 );
Chris@76	1951 foreach ($error_types as $error_type)
Chris@76	1952 {
Chris@76	1953 $context['post_error'][$error_type] = true;
Chris@76	1954 if (isset($txt['error_' . $error_type]))
Chris@76	1955 {
Chris@76	1956 if ($error_type == 'long_message')
Chris@76	1957 $txt['error_' . $error_type] = sprintf($txt['error_' . $error_type], $modSettings['max_messageLength']);
Chris@76	1958 $context['post_error']['messages'][] = $txt['error_' . $error_type];
Chris@76	1959 }
Chris@76	1960 }
Chris@76	1961
Chris@76	1962 // We need to load the editor once more.
Chris@76	1963 require_once($sourcedir . '/Subs-Editor.php');
Chris@76	1964
Chris@76	1965 // Create it...
Chris@76	1966 $editorOptions = array(
Chris@76	1967 'id' => 'message',
Chris@76	1968 'value' => $context['message'],
Chris@76	1969 'width' => '90%',
Chris@76	1970 'labels' => array(
Chris@76	1971 'post_button' => $txt['send_message'],
Chris@76	1972 ),
Chris@76	1973 );
Chris@76	1974 create_control_richedit($editorOptions);
Chris@76	1975
Chris@76	1976 // ... and store the ID again...
Chris@76	1977 $context['post_box_name'] = $editorOptions['id'];
Chris@76	1978
Chris@76	1979 // Check whether we need to show the code again.
Chris@76	1980 $context['require_verification'] = !$user_info['is_admin'] && !empty($modSettings['pm_posts_verification']) && $user_info['posts'] < $modSettings['pm_posts_verification'];
Chris@76	1981 if ($context['require_verification'])
Chris@76	1982 {
Chris@76	1983 require_once($sourcedir . '/Subs-Editor.php');
Chris@76	1984 $verificationOptions = array(
Chris@76	1985 'id' => 'pm',
Chris@76	1986 );
Chris@76	1987 $context['require_verification'] = create_control_verification($verificationOptions);
Chris@76	1988 $context['visual_verification_id'] = $verificationOptions['id'];
Chris@76	1989 }
Chris@76	1990
Chris@76	1991 $context['to_value'] = empty($named_recipients['to']) ? '' : '"' . implode('", "', $named_recipients['to']) . '"';
Chris@76	1992 $context['bcc_value'] = empty($named_recipients['bcc']) ? '' : '"' . implode('", "', $named_recipients['bcc']) . '"';
Chris@76	1993
Chris@76	1994 // No check for the previous submission is needed.
Chris@76	1995 checkSubmitOnce('free');
Chris@76	1996
Chris@76	1997 // Acquire a new form sequence number.
Chris@76	1998 checkSubmitOnce('register');
Chris@76	1999 }
Chris@76	2000
Chris@76	2001 // Send it!
Chris@76	2002 function MessagePost2()
Chris@76	2003 {
Chris@76	2004 global $txt, $context, $sourcedir;
Chris@76	2005 global $user_info, $modSettings, $scripturl, $smcFunc;
Chris@76	2006
Chris@76	2007 isAllowedTo('pm_send');
Chris@76	2008 require_once($sourcedir . '/Subs-Auth.php');
Chris@76	2009
Chris@76	2010 loadLanguage('PersonalMessage', '', false);
Chris@76	2011
Chris@76	2012 // Extract out the spam settings - it saves database space!
Chris@76	2013 list ($modSettings['max_pm_recipients'], $modSettings['pm_posts_verification'], $modSettings['pm_posts_per_hour']) = explode(',', $modSettings['pm_spam_settings']);
Chris@76	2014
Chris@76	2015 // Check whether we've gone over the limit of messages we can send per hour - fatal error if fails!
Chris@76	2016 if (!empty($modSettings['pm_posts_per_hour']) && !allowedTo(array('admin_forum', 'moderate_forum', 'send_mail')) && $user_info['mod_cache']['bq'] == '0=1' && $user_info['mod_cache']['gq'] == '0=1')
Chris@76	2017 {
Chris@76	2018 // How many have they sent this last hour?
Chris@76	2019 $request = $smcFunc['db_query']('', '
Chris@76	2020 SELECT COUNT(pr.id_pm) AS post_count
Chris@76	2021 FROM {db_prefix}personal_messages AS pm
Chris@76	2022 INNER JOIN {db_prefix}pm_recipients AS pr ON (pr.id_pm = pm.id_pm)
Chris@76	2023 WHERE pm.id_member_from = {int:current_member}
Chris@76	2024 AND pm.msgtime > {int:msgtime}',
Chris@76	2025 array(
Chris@76	2026 'current_member' => $user_info['id'],
Chris@76	2027 'msgtime' => time() - 3600,
Chris@76	2028 )
Chris@76	2029 );
Chris@76	2030 list ($postCount) = $smcFunc['db_fetch_row']($request);
Chris@76	2031 $smcFunc['db_free_result']($request);
Chris@76	2032
Chris@76	2033 if (!empty($postCount) && $postCount >= $modSettings['pm_posts_per_hour'])
Chris@76	2034 fatal_lang_error('pm_too_many_per_hour', true, array($modSettings['pm_posts_per_hour']));
Chris@76	2035 }
Chris@76	2036
Chris@76	2037 // If we came from WYSIWYG then turn it back into BBC regardless.
Chris@76	2038 if (!empty($_POST['message_mode']) && isset($_POST['message']))
Chris@76	2039 {
Chris@76	2040 require_once($sourcedir . '/Subs-Editor.php');
Chris@76	2041 $_POST['message'] = html_to_bbc($_POST['message']);
Chris@76	2042
Chris@76	2043 // We need to unhtml it now as it gets done shortly.
Chris@76	2044 $_POST['message'] = un_htmlspecialchars($_POST['message']);
Chris@76	2045
Chris@76	2046 // We need this in case of errors etc.
Chris@76	2047 $_REQUEST['message'] = $_POST['message'];
Chris@76	2048 }
Chris@76	2049
Chris@76	2050 // Initialize the errors we're about to make.
Chris@76	2051 $post_errors = array();
Chris@76	2052
Chris@76	2053 // If your session timed out, show an error, but do allow to re-submit.
Chris@76	2054 if (checkSession('post', '', false) != '')
Chris@76	2055 $post_errors[] = 'session_timeout';
Chris@76	2056
Chris@76	2057 $_REQUEST['subject'] = isset($_REQUEST['subject']) ? trim($_REQUEST['subject']) : '';
Chris@76	2058 $_REQUEST['to'] = empty($_POST['to']) ? (empty($_GET['to']) ? '' : $_GET['to']) : $_POST['to'];
Chris@76	2059 $_REQUEST['bcc'] = empty($_POST['bcc']) ? (empty($_GET['bcc']) ? '' : $_GET['bcc']) : $_POST['bcc'];
Chris@76	2060
Chris@76	2061 // Route the input from the 'u' parameter to the 'to'-list.
Chris@76	2062 if (!empty($_POST['u']))
Chris@76	2063 $_POST['recipient_to'] = explode(',', $_POST['u']);
Chris@76	2064
Chris@76	2065 // Construct the list of recipients.
Chris@76	2066 $recipientList = array();
Chris@76	2067 $namedRecipientList = array();
Chris@76	2068 $namesNotFound = array();
Chris@76	2069 foreach (array('to', 'bcc') as $recipientType)
Chris@76	2070 {
Chris@76	2071 // First, let's see if there's user ID's given.
Chris@76	2072 $recipientList[$recipientType] = array();
Chris@76	2073 if (!empty($_POST['recipient_' . $recipientType]) && is_array($_POST['recipient_' . $recipientType]))
Chris@76	2074 {
Chris@76	2075 foreach ($_POST['recipient_' . $recipientType] as $recipient)
Chris@76	2076 $recipientList[$recipientType][] = (int) $recipient;
Chris@76	2077 }
Chris@76	2078
Chris@76	2079 // Are there also literal names set?
Chris@76	2080 if (!empty($_REQUEST[$recipientType]))
Chris@76	2081 {
Chris@76	2082 // We're going to take out the "s anyway ;).
Chris@76	2083 $recipientString = strtr($_REQUEST[$recipientType], array('\\"' => '"'));
Chris@76	2084
Chris@76	2085 preg_match_all('~"([^"]+)"~', $recipientString, $matches);
Chris@76	2086 $namedRecipientList[$recipientType] = array_unique(array_merge($matches[1], explode(',', preg_replace('~"[^"]+"~', '', $recipientString))));
Chris@76	2087
Chris@76	2088 foreach ($namedRecipientList[$recipientType] as $index => $recipient)
Chris@76	2089 {
Chris@76	2090 if (strlen(trim($recipient)) > 0)
Chris@76	2091 $namedRecipientList[$recipientType][$index] = $smcFunc['htmlspecialchars']($smcFunc['strtolower'](trim($recipient)));
Chris@76	2092 else
Chris@76	2093 unset($namedRecipientList[$recipientType][$index]);
Chris@76	2094 }
Chris@76	2095
Chris@76	2096 if (!empty($namedRecipientList[$recipientType]))
Chris@76	2097 {
Chris@76	2098 $foundMembers = findMembers($namedRecipientList[$recipientType]);
Chris@76	2099
Chris@76	2100 // Assume all are not found, until proven otherwise.
Chris@76	2101 $namesNotFound[$recipientType] = $namedRecipientList[$recipientType];
Chris@76	2102
Chris@76	2103 foreach ($foundMembers as $member)
Chris@76	2104 {
Chris@76	2105 $testNames = array(
Chris@76	2106 $smcFunc['strtolower']($member['username']),
Chris@76	2107 $smcFunc['strtolower']($member['name']),
Chris@76	2108 $smcFunc['strtolower']($member['email']),
Chris@76	2109 );
Chris@76	2110
Chris@76	2111 if (count(array_intersect($testNames, $namedRecipientList[$recipientType])) !== 0)
Chris@76	2112 {
Chris@76	2113 $recipientList[$recipientType][] = $member['id'];
Chris@76	2114
Chris@76	2115 // Get rid of this username, since we found it.
Chris@76	2116 $namesNotFound[$recipientType] = array_diff($namesNotFound[$recipientType], $testNames);
Chris@76	2117 }
Chris@76	2118 }
Chris@76	2119 }
Chris@76	2120 }
Chris@76	2121
Chris@76	2122 // Selected a recipient to be deleted? Remove them now.
Chris@76	2123 if (!empty($_POST['delete_recipient']))
Chris@76	2124 $recipientList[$recipientType] = array_diff($recipientList[$recipientType], array((int) $_POST['delete_recipient']));
Chris@76	2125
Chris@76	2126 // Make sure we don't include the same name twice
Chris@76	2127 $recipientList[$recipientType] = array_unique($recipientList[$recipientType]);
Chris@76	2128 }
Chris@76	2129
Chris@76	2130 // Are we changing the recipients some how?
Chris@76	2131 $is_recipient_change = !empty($_POST['delete_recipient']) \|\| !empty($_POST['to_submit']) \|\| !empty($_POST['bcc_submit']);
Chris@76	2132
Chris@76	2133 // Check if there's at least one recipient.
Chris@76	2134 if (empty($recipientList['to']) && empty($recipientList['bcc']))
Chris@76	2135 $post_errors[] = 'no_to';
Chris@76	2136
Chris@76	2137 // Make sure that we remove the members who did get it from the screen.
Chris@76	2138 if (!$is_recipient_change)
Chris@76	2139 {
Chris@76	2140 foreach ($recipientList as $recipientType => $dummy)
Chris@76	2141 {
Chris@76	2142 if (!empty($namesNotFound[$recipientType]))
Chris@76	2143 {
Chris@76	2144 $post_errors[] = 'bad_' . $recipientType;
Chris@76	2145
Chris@76	2146 // Since we already have a post error, remove the previous one.
Chris@76	2147 $post_errors = array_diff($post_errors, array('no_to'));
Chris@76	2148
Chris@76	2149 foreach ($namesNotFound[$recipientType] as $name)
Chris@76	2150 $context['send_log']['failed'][] = sprintf($txt['pm_error_user_not_found'], $name);
Chris@76	2151 }
Chris@76	2152 }
Chris@76	2153 }
Chris@76	2154
Chris@76	2155 // Did they make any mistakes?
Chris@76	2156 if ($_REQUEST['subject'] == '')
Chris@76	2157 $post_errors[] = 'no_subject';
Chris@76	2158 if (!isset($_REQUEST['message']) \|\| $_REQUEST['message'] == '')
Chris@76	2159 $post_errors[] = 'no_message';
Chris@76	2160 elseif (!empty($modSettings['max_messageLength']) && $smcFunc['strlen']($_REQUEST['message']) > $modSettings['max_messageLength'])
Chris@76	2161 $post_errors[] = 'long_message';
Chris@76	2162 else
Chris@76	2163 {
Chris@76	2164 // Preparse the message.
Chris@76	2165 $message = $_REQUEST['message'];
Chris@76	2166 preparsecode($message);
Chris@76	2167
Chris@76	2168 // Make sure there's still some content left without the tags.
Chris@76	2169 if ($smcFunc['htmltrim'](strip_tags(parse_bbc($smcFunc['htmlspecialchars']($message, ENT_QUOTES), false), '<img>')) === '' && (!allowedTo('admin_forum') \|\| strpos($message, '[html]') === false))
Chris@76	2170 $post_errors[] = 'no_message';
Chris@76	2171 }
Chris@76	2172
Chris@76	2173 // Wrong verification code?
Chris@76	2174 if (!$user_info['is_admin'] && !empty($modSettings['pm_posts_verification']) && $user_info['posts'] < $modSettings['pm_posts_verification'])
Chris@76	2175 {
Chris@76	2176 require_once($sourcedir . '/Subs-Editor.php');
Chris@76	2177 $verificationOptions = array(
Chris@76	2178 'id' => 'pm',
Chris@76	2179 );
Chris@76	2180 $context['require_verification'] = create_control_verification($verificationOptions, true);
Chris@76	2181
Chris@76	2182 if (is_array($context['require_verification']))
Chris@76	2183 {
Chris@76	2184 $post_errors = array_merge($post_errors, $context['require_verification']);
Chris@76	2185 }
Chris@76	2186 }
Chris@76	2187
Chris@76	2188 // If they did, give a chance to make ammends.
Chris@76	2189 if (!empty($post_errors) && !$is_recipient_change && !isset($_REQUEST['preview']))
Chris@76	2190 return messagePostError($post_errors, $namedRecipientList, $recipientList);
Chris@76	2191
Chris@76	2192 // Want to take a second glance before you send?
Chris@76	2193 if (isset($_REQUEST['preview']))
Chris@76	2194 {
Chris@76	2195 // Set everything up to be displayed.
Chris@76	2196 $context['preview_subject'] = $smcFunc['htmlspecialchars']($_REQUEST['subject']);
Chris@76	2197 $context['preview_message'] = $smcFunc['htmlspecialchars']($_REQUEST['message'], ENT_QUOTES);
Chris@76	2198 preparsecode($context['preview_message'], true);
Chris@76	2199
Chris@76	2200 // Parse out the BBC if it is enabled.
Chris@76	2201 $context['preview_message'] = parse_bbc($context['preview_message']);
Chris@76	2202
Chris@76	2203 // Censor, as always.
Chris@76	2204 censorText($context['preview_subject']);
Chris@76	2205 censorText($context['preview_message']);
Chris@76	2206
Chris@76	2207 // Set a descriptive title.
Chris@76	2208 $context['page_title'] = $txt['preview'] . ' - ' . $context['preview_subject'];
Chris@76	2209
Chris@76	2210 // Pretend they messed up but don't ignore if they really did :P.
Chris@76	2211 return messagePostError($post_errors, $namedRecipientList, $recipientList);
Chris@76	2212 }
Chris@76	2213
Chris@76	2214 // Adding a recipient cause javascript ain't working?
Chris@76	2215 elseif ($is_recipient_change)
Chris@76	2216 {
Chris@76	2217 // Maybe we couldn't find one?
Chris@76	2218 foreach ($namesNotFound as $recipientType => $names)
Chris@76	2219 {
Chris@76	2220 $post_errors[] = 'bad_' . $recipientType;
Chris@76	2221 foreach ($names as $name)
Chris@76	2222 $context['send_log']['failed'][] = sprintf($txt['pm_error_user_not_found'], $name);
Chris@76	2223 }
Chris@76	2224
Chris@76	2225 return messagePostError(array(), $namedRecipientList, $recipientList);
Chris@76	2226 }
Chris@76	2227
Chris@76	2228 // Before we send the PM, let's make sure we don't have an abuse of numbers.
Chris@76	2229 elseif (!empty($modSettings['max_pm_recipients']) && count($recipientList['to']) + count($recipientList['bcc']) > $modSettings['max_pm_recipients'] && !allowedTo(array('moderate_forum', 'send_mail', 'admin_forum')))
Chris@76	2230 {
Chris@76	2231 $context['send_log'] = array(
Chris@76	2232 'sent' => array(),
Chris@76	2233 'failed' => array(sprintf($txt['pm_too_many_recipients'], $modSettings['max_pm_recipients'])),
Chris@76	2234 );
Chris@76	2235 return messagePostError($post_errors, $namedRecipientList, $recipientList);
Chris@76	2236 }
Chris@76	2237
Chris@76	2238 // Protect from message spamming.
Chris@76	2239 spamProtection('pm');
Chris@76	2240
Chris@76	2241 // Prevent double submission of this form.
Chris@76	2242 checkSubmitOnce('check');
Chris@76	2243
Chris@76	2244 // Do the actual sending of the PM.
Chris@76	2245 if (!empty($recipientList['to']) \|\| !empty($recipientList['bcc']))
Chris@76	2246 $context['send_log'] = sendpm($recipientList, $_REQUEST['subject'], $_REQUEST['message'], !empty($_REQUEST['outbox']), null, !empty($_REQUEST['pm_head']) ? (int) $_REQUEST['pm_head'] : 0);
Chris@76	2247 else
Chris@76	2248 $context['send_log'] = array(
Chris@76	2249 'sent' => array(),
Chris@76	2250 'failed' => array()
Chris@76	2251 );
Chris@76	2252
Chris@76	2253 // Mark the message as "replied to".
Chris@76	2254 if (!empty($context['send_log']['sent']) && !empty($_REQUEST['replied_to']) && isset($_REQUEST['f']) && $_REQUEST['f'] == 'inbox')
Chris@76	2255 {
Chris@76	2256 $smcFunc['db_query']('', '
Chris@76	2257 UPDATE {db_prefix}pm_recipients
Chris@76	2258 SET is_read = is_read \| 2
Chris@76	2259 WHERE id_pm = {int:replied_to}
Chris@76	2260 AND id_member = {int:current_member}',
Chris@76	2261 array(
Chris@76	2262 'current_member' => $user_info['id'],
Chris@76	2263 'replied_to' => (int) $_REQUEST['replied_to'],
Chris@76	2264 )
Chris@76	2265 );
Chris@76	2266 }
Chris@76	2267
Chris@76	2268 // If one or more of the recipient were invalid, go back to the post screen with the failed usernames.
Chris@76	2269 if (!empty($context['send_log']['failed']))
Chris@76	2270 return messagePostError($post_errors, $namesNotFound, array(
Chris@76	2271 'to' => array_intersect($recipientList['to'], $context['send_log']['failed']),
Chris@76	2272 'bcc' => array_intersect($recipientList['bcc'], $context['send_log']['failed'])
Chris@76	2273 ));
Chris@76	2274
Chris@76	2275 // Message sent successfully?
Chris@76	2276 if (!empty($context['send_log']) && empty($context['send_log']['failed']))
Chris@76	2277 $context['current_label_redirect'] = $context['current_label_redirect'] . ';done=sent';
Chris@76	2278
Chris@76	2279 // Go back to the where they sent from, if possible...
Chris@76	2280 redirectexit($context['current_label_redirect']);
Chris@76	2281 }
Chris@76	2282
Chris@76	2283 // This function lists all buddies for wireless protocols.
Chris@76	2284 function WirelessAddBuddy()
Chris@76	2285 {
Chris@76	2286 global $scripturl, $txt, $user_info, $context, $smcFunc;
Chris@76	2287
Chris@76	2288 isAllowedTo('pm_send');
Chris@76	2289 $context['page_title'] = $txt['wireless_pm_add_buddy'];
Chris@76	2290
Chris@76	2291 $current_buddies = empty($_REQUEST['u']) ? array() : explode(',', $_REQUEST['u']);
Chris@76	2292 foreach ($current_buddies as $key => $buddy)
Chris@76	2293 $current_buddies[$key] = (int) $buddy;
Chris@76	2294
Chris@76	2295 $base_url = $scripturl . '?action=pm;sa=send;u=' . (empty($current_buddies) ? '' : implode(',', $current_buddies) . ',');
Chris@76	2296 $context['pm_href'] = $scripturl . '?action=pm;sa=send' . (empty($current_buddies) ? '' : ';u=' . implode(',', $current_buddies));
Chris@76	2297
Chris@76	2298 $context['buddies'] = array();
Chris@76	2299 if (!empty($user_info['buddies']))
Chris@76	2300 {
Chris@76	2301 $request = $smcFunc['db_query']('', '
Chris@76	2302 SELECT id_member, real_name
Chris@76	2303 FROM {db_prefix}members
Chris@76	2304 WHERE id_member IN ({array_int:buddy_list})
Chris@76	2305 ORDER BY real_name
Chris@76	2306 LIMIT ' . count($user_info['buddies']),
Chris@76	2307 array(
Chris@76	2308 'buddy_list' => $user_info['buddies'],
Chris@76	2309 )
Chris@76	2310 );
Chris@76	2311 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	2312 $context['buddies'][] = array(
Chris@76	2313 'id' => $row['id_member'],
Chris@76	2314 'name' => $row['real_name'],
Chris@76	2315 'selected' => in_array($row['id_member'], $current_buddies),
Chris@76	2316 'add_href' => $base_url . $row['id_member'],
Chris@76	2317 );
Chris@76	2318 $smcFunc['db_free_result']($request);
Chris@76	2319 }
Chris@76	2320 }
Chris@76	2321
Chris@76	2322 // This function performs all additional stuff...
Chris@76	2323 function MessageActionsApply()
Chris@76	2324 {
Chris@76	2325 global $txt, $context, $user_info, $options, $smcFunc;
Chris@76	2326
Chris@76	2327 checkSession('request');
Chris@76	2328
Chris@76	2329 if (isset($_REQUEST['del_selected']))
Chris@76	2330 $_REQUEST['pm_action'] = 'delete';
Chris@76	2331
Chris@76	2332 if (isset($_REQUEST['pm_action']) && $_REQUEST['pm_action'] != '' && !empty($_REQUEST['pms']) && is_array($_REQUEST['pms']))
Chris@76	2333 {
Chris@76	2334 foreach ($_REQUEST['pms'] as $pm)
Chris@76	2335 $_REQUEST['pm_actions'][(int) $pm] = $_REQUEST['pm_action'];
Chris@76	2336 }
Chris@76	2337
Chris@76	2338 if (empty($_REQUEST['pm_actions']))
Chris@76	2339 redirectexit($context['current_label_redirect']);
Chris@76	2340
Chris@76	2341 // If we are in conversation, we may need to apply this to every message in the conversation.
Chris@76	2342 if ($context['display_mode'] == 2 && isset($_REQUEST['conversation']))
Chris@76	2343 {
Chris@76	2344 $id_pms = array();
Chris@76	2345 foreach ($_REQUEST['pm_actions'] as $pm => $dummy)
Chris@76	2346 $id_pms[] = (int) $pm;
Chris@76	2347
Chris@76	2348 $request = $smcFunc['db_query']('', '
Chris@76	2349 SELECT id_pm_head, id_pm
Chris@76	2350 FROM {db_prefix}personal_messages
Chris@76	2351 WHERE id_pm IN ({array_int:id_pms})',
Chris@76	2352 array(
Chris@76	2353 'id_pms' => $id_pms,
Chris@76	2354 )
Chris@76	2355 );
Chris@76	2356 $pm_heads = array();
Chris@76	2357 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	2358 $pm_heads[$row['id_pm_head']] = $row['id_pm'];
Chris@76	2359 $smcFunc['db_free_result']($request);
Chris@76	2360
Chris@76	2361 $request = $smcFunc['db_query']('', '
Chris@76	2362 SELECT id_pm, id_pm_head
Chris@76	2363 FROM {db_prefix}personal_messages
Chris@76	2364 WHERE id_pm_head IN ({array_int:pm_heads})',
Chris@76	2365 array(
Chris@76	2366 'pm_heads' => array_keys($pm_heads),
Chris@76	2367 )
Chris@76	2368 );
Chris@76	2369 // Copy the action from the single to PM to the others.
Chris@76	2370 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	2371 {
Chris@76	2372 if (isset($pm_heads[$row['id_pm_head']]) && isset($_REQUEST['pm_actions'][$pm_heads[$row['id_pm_head']]]))
Chris@76	2373 $_REQUEST['pm_actions'][$row['id_pm']] = $_REQUEST['pm_actions'][$pm_heads[$row['id_pm_head']]];
Chris@76	2374 }
Chris@76	2375 $smcFunc['db_free_result']($request);
Chris@76	2376 }
Chris@76	2377
Chris@76	2378 $to_delete = array();
Chris@76	2379 $to_label = array();
Chris@76	2380 $label_type = array();
Chris@76	2381 foreach ($_REQUEST['pm_actions'] as $pm => $action)
Chris@76	2382 {
Chris@76	2383 if ($action === 'delete')
Chris@76	2384 $to_delete[] = (int) $pm;
Chris@76	2385 else
Chris@76	2386 {
Chris@76	2387 if (substr($action, 0, 4) == 'add_')
Chris@76	2388 {
Chris@76	2389 $type = 'add';
Chris@76	2390 $action = substr($action, 4);
Chris@76	2391 }
Chris@76	2392 elseif (substr($action, 0, 4) == 'rem_')
Chris@76	2393 {
Chris@76	2394 $type = 'rem';
Chris@76	2395 $action = substr($action, 4);
Chris@76	2396 }
Chris@76	2397 else
Chris@76	2398 $type = 'unk';
Chris@76	2399
Chris@76	2400 if ($action == '-1' \|\| $action == '0' \|\| (int) $action > 0)
Chris@76	2401 {
Chris@76	2402 $to_label[(int) $pm] = (int) $action;
Chris@76	2403 $label_type[(int) $pm] = $type;
Chris@76	2404 }
Chris@76	2405 }
Chris@76	2406 }
Chris@76	2407
Chris@76	2408 // Deleting, it looks like?
Chris@76	2409 if (!empty($to_delete))
Chris@76	2410 deleteMessages($to_delete, $context['display_mode'] == 2 ? null : $context['folder']);
Chris@76	2411
Chris@76	2412 // Are we labeling anything?
Chris@76	2413 if (!empty($to_label) && $context['folder'] == 'inbox')
Chris@76	2414 {
Chris@76	2415 $updateErrors = 0;
Chris@76	2416
Chris@76	2417 // Get information about each message...
Chris@76	2418 $request = $smcFunc['db_query']('', '
Chris@76	2419 SELECT id_pm, labels
Chris@76	2420 FROM {db_prefix}pm_recipients
Chris@76	2421 WHERE id_member = {int:current_member}
Chris@76	2422 AND id_pm IN ({array_int:to_label})
Chris@76	2423 LIMIT ' . count($to_label),
Chris@76	2424 array(
Chris@76	2425 'current_member' => $user_info['id'],
Chris@76	2426 'to_label' => array_keys($to_label),
Chris@76	2427 )
Chris@76	2428 );
Chris@76	2429 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	2430 {
Chris@76	2431 $labels = $row['labels'] == '' ? array('-1') : explode(',', trim($row['labels']));
Chris@76	2432
Chris@76	2433 // Already exists? Then... unset it!
Chris@76	2434 $ID_LABEL = array_search($to_label[$row['id_pm']], $labels);
Chris@76	2435 if ($ID_LABEL !== false && $label_type[$row['id_pm']] !== 'add')
Chris@76	2436 unset($labels[$ID_LABEL]);
Chris@76	2437 elseif ($label_type[$row['id_pm']] !== 'rem')
Chris@76	2438 $labels[] = $to_label[$row['id_pm']];
Chris@76	2439
Chris@76	2440 if (!empty($options['pm_remove_inbox_label']) && $to_label[$row['id_pm']] != '-1' && ($key = array_search('-1', $labels)) !== false)
Chris@76	2441 unset($labels[$key]);
Chris@76	2442
Chris@76	2443 $set = implode(',', array_unique($labels));
Chris@76	2444 if ($set == '')
Chris@76	2445 $set = '-1';
Chris@76	2446
Chris@76	2447 // Check that this string isn't going to be too large for the database.
Chris@76	2448 if ($set > 60)
Chris@76	2449 $updateErrors++;
Chris@76	2450 else
Chris@76	2451 {
Chris@76	2452 $smcFunc['db_query']('', '
Chris@76	2453 UPDATE {db_prefix}pm_recipients
Chris@76	2454 SET labels = {string:labels}
Chris@76	2455 WHERE id_pm = {int:id_pm}
Chris@76	2456 AND id_member = {int:current_member}',
Chris@76	2457 array(
Chris@76	2458 'current_member' => $user_info['id'],
Chris@76	2459 'id_pm' => $row['id_pm'],
Chris@76	2460 'labels' => $set,
Chris@76	2461 )
Chris@76	2462 );
Chris@76	2463 }
Chris@76	2464 }
Chris@76	2465 $smcFunc['db_free_result']($request);
Chris@76	2466
Chris@76	2467 // Any errors?
Chris@76	2468 // !!! Separate the sprintf?
Chris@76	2469 if (!empty($updateErrors))
Chris@76	2470 fatal_lang_error('labels_too_many', true, array($updateErrors));
Chris@76	2471 }
Chris@76	2472
Chris@76	2473 // Back to the folder.
Chris@76	2474 $_SESSION['pm_selected'] = array_keys($to_label);
Chris@76	2475 redirectexit($context['current_label_redirect'] . (count($to_label) == 1 ? '#msg' . $_SESSION['pm_selected'][0] : ''), count($to_label) == 1 && $context['browser']['is_ie']);
Chris@76	2476 }
Chris@76	2477
Chris@76	2478 // Are you sure you want to PERMANENTLY (mostly) delete ALL your messages?
Chris@76	2479 function MessageKillAllQuery()
Chris@76	2480 {
Chris@76	2481 global $txt, $context;
Chris@76	2482
Chris@76	2483 // Only have to set up the template....
Chris@76	2484 $context['sub_template'] = 'ask_delete';
Chris@76	2485 $context['page_title'] = $txt['delete_all'];
Chris@76	2486 $context['delete_all'] = $_REQUEST['f'] == 'all';
Chris@76	2487
Chris@76	2488 // And set the folder name...
Chris@76	2489 $txt['delete_all'] = str_replace('PMBOX', $context['folder'] != 'sent' ? $txt['inbox'] : $txt['sent_items'], $txt['delete_all']);
Chris@76	2490 }
Chris@76	2491
Chris@76	2492 // Delete ALL the messages!
Chris@76	2493 function MessageKillAll()
Chris@76	2494 {
Chris@76	2495 global $context;
Chris@76	2496
Chris@76	2497 checkSession('get');
Chris@76	2498
Chris@76	2499 // If all then delete all messages the user has.
Chris@76	2500 if ($_REQUEST['f'] == 'all')
Chris@76	2501 deleteMessages(null, null);
Chris@76	2502 // Otherwise just the selected folder.
Chris@76	2503 else
Chris@76	2504 deleteMessages(null, $_REQUEST['f'] != 'sent' ? 'inbox' : 'sent');
Chris@76	2505
Chris@76	2506 // Done... all gone.
Chris@76	2507 redirectexit($context['current_label_redirect']);
Chris@76	2508 }
Chris@76	2509
Chris@76	2510 // This function allows the user to delete all messages older than so many days.
Chris@76	2511 function MessagePrune()
Chris@76	2512 {
Chris@76	2513 global $txt, $context, $user_info, $scripturl, $smcFunc;
Chris@76	2514
Chris@76	2515 // Actually delete the messages.
Chris@76	2516 if (isset($_REQUEST['age']))
Chris@76	2517 {
Chris@76	2518 checkSession();
Chris@76	2519
Chris@76	2520 // Calculate the time to delete before.
Chris@76	2521 $deleteTime = max(0, time() - (86400 * (int) $_REQUEST['age']));
Chris@76	2522
Chris@76	2523 // Array to store the IDs in.
Chris@76	2524 $toDelete = array();
Chris@76	2525
Chris@76	2526 // Select all the messages they have sent older than $deleteTime.
Chris@76	2527 $request = $smcFunc['db_query']('', '
Chris@76	2528 SELECT id_pm
Chris@76	2529 FROM {db_prefix}personal_messages
Chris@76	2530 WHERE deleted_by_sender = {int:not_deleted}
Chris@76	2531 AND id_member_from = {int:current_member}
Chris@76	2532 AND msgtime < {int:msgtime}',
Chris@76	2533 array(
Chris@76	2534 'current_member' => $user_info['id'],
Chris@76	2535 'not_deleted' => 0,
Chris@76	2536 'msgtime' => $deleteTime,
Chris@76	2537 )
Chris@76	2538 );
Chris@76	2539 while ($row = $smcFunc['db_fetch_row']($request))
Chris@76	2540 $toDelete[] = $row[0];
Chris@76	2541 $smcFunc['db_free_result']($request);
Chris@76	2542
Chris@76	2543 // Select all messages in their inbox older than $deleteTime.
Chris@76	2544 $request = $smcFunc['db_query']('', '
Chris@76	2545 SELECT pmr.id_pm
Chris@76	2546 FROM {db_prefix}pm_recipients AS pmr
Chris@76	2547 INNER JOIN {db_prefix}personal_messages AS pm ON (pm.id_pm = pmr.id_pm)
Chris@76	2548 WHERE pmr.deleted = {int:not_deleted}
Chris@76	2549 AND pmr.id_member = {int:current_member}
Chris@76	2550 AND pm.msgtime < {int:msgtime}',
Chris@76	2551 array(
Chris@76	2552 'current_member' => $user_info['id'],
Chris@76	2553 'not_deleted' => 0,
Chris@76	2554 'msgtime' => $deleteTime,
Chris@76	2555 )
Chris@76	2556 );
Chris@76	2557 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	2558 $toDelete[] = $row['id_pm'];
Chris@76	2559 $smcFunc['db_free_result']($request);
Chris@76	2560
Chris@76	2561 // Delete the actual messages.
Chris@76	2562 deleteMessages($toDelete);
Chris@76	2563
Chris@76	2564 // Go back to their inbox.
Chris@76	2565 redirectexit($context['current_label_redirect']);
Chris@76	2566 }
Chris@76	2567
Chris@76	2568 // Build the link tree elements.
Chris@76	2569 $context['linktree'][] = array(
Chris@76	2570 'url' => $scripturl . '?action=pm;sa=prune',
Chris@76	2571 'name' => $txt['pm_prune']
Chris@76	2572 );
Chris@76	2573
Chris@76	2574 $context['sub_template'] = 'prune';
Chris@76	2575 $context['page_title'] = $txt['pm_prune'];
Chris@76	2576 }
Chris@76	2577
Chris@76	2578 // Delete the specified personal messages.
Chris@76	2579 function deleteMessages($personal_messages, $folder = null, $owner = null)
Chris@76	2580 {
Chris@76	2581 global $user_info, $smcFunc;
Chris@76	2582
Chris@76	2583 if ($owner === null)
Chris@76	2584 $owner = array($user_info['id']);
Chris@76	2585 elseif (empty($owner))
Chris@76	2586 return;
Chris@76	2587 elseif (!is_array($owner))
Chris@76	2588 $owner = array($owner);
Chris@76	2589
Chris@76	2590 if ($personal_messages !== null)
Chris@76	2591 {
Chris@76	2592 if (empty($personal_messages) \|\| !is_array($personal_messages))
Chris@76	2593 return;
Chris@76	2594
Chris@76	2595 foreach ($personal_messages as $index => $delete_id)
Chris@76	2596 $personal_messages[$index] = (int) $delete_id;
Chris@76	2597
Chris@76	2598 $where = '
Chris@76	2599 AND id_pm IN ({array_int:pm_list})';
Chris@76	2600 }
Chris@76	2601 else
Chris@76	2602 $where = '';
Chris@76	2603
Chris@76	2604 if ($folder == 'sent' \|\| $folder === null)
Chris@76	2605 {
Chris@76	2606 $smcFunc['db_query']('', '
Chris@76	2607 UPDATE {db_prefix}personal_messages
Chris@76	2608 SET deleted_by_sender = {int:is_deleted}
Chris@76	2609 WHERE id_member_from IN ({array_int:member_list})
Chris@76	2610 AND deleted_by_sender = {int:not_deleted}' . $where,
Chris@76	2611 array(
Chris@76	2612 'member_list' => $owner,
Chris@76	2613 'is_deleted' => 1,
Chris@76	2614 'not_deleted' => 0,
Chris@76	2615 'pm_list' => $personal_messages !== null ? array_unique($personal_messages) : array(),
Chris@76	2616 )
Chris@76	2617 );
Chris@76	2618 }
Chris@76	2619 if ($folder != 'sent' \|\| $folder === null)
Chris@76	2620 {
Chris@76	2621 // Calculate the number of messages each member's gonna lose...
Chris@76	2622 $request = $smcFunc['db_query']('', '
Chris@76	2623 SELECT id_member, COUNT(*) AS num_deleted_messages, CASE WHEN is_read & 1 >= 1 THEN 1 ELSE 0 END AS is_read
Chris@76	2624 FROM {db_prefix}pm_recipients
Chris@76	2625 WHERE id_member IN ({array_int:member_list})
Chris@76	2626 AND deleted = {int:not_deleted}' . $where . '
Chris@76	2627 GROUP BY id_member, is_read',
Chris@76	2628 array(
Chris@76	2629 'member_list' => $owner,
Chris@76	2630 'not_deleted' => 0,
Chris@76	2631 'pm_list' => $personal_messages !== null ? array_unique($personal_messages) : array(),
Chris@76	2632 )
Chris@76	2633 );
Chris@76	2634 // ...And update the statistics accordingly - now including unread messages!.
Chris@76	2635 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	2636 {
Chris@76	2637 if ($row['is_read'])
Chris@76	2638 updateMemberData($row['id_member'], array('instant_messages' => $where == '' ? 0 : 'instant_messages - ' . $row['num_deleted_messages']));
Chris@76	2639 else
Chris@76	2640 updateMemberData($row['id_member'], array('instant_messages' => $where == '' ? 0 : 'instant_messages - ' . $row['num_deleted_messages'], 'unread_messages' => $where == '' ? 0 : 'unread_messages - ' . $row['num_deleted_messages']));
Chris@76	2641
Chris@76	2642 // If this is the current member we need to make their message count correct.
Chris@76	2643 if ($user_info['id'] == $row['id_member'])
Chris@76	2644 {
Chris@76	2645 $user_info['messages'] -= $row['num_deleted_messages'];
Chris@76	2646 if (!($row['is_read']))
Chris@76	2647 $user_info['unread_messages'] -= $row['num_deleted_messages'];
Chris@76	2648 }
Chris@76	2649 }
Chris@76	2650 $smcFunc['db_free_result']($request);
Chris@76	2651
Chris@76	2652 // Do the actual deletion.
Chris@76	2653 $smcFunc['db_query']('', '
Chris@76	2654 UPDATE {db_prefix}pm_recipients
Chris@76	2655 SET deleted = {int:is_deleted}
Chris@76	2656 WHERE id_member IN ({array_int:member_list})
Chris@76	2657 AND deleted = {int:not_deleted}' . $where,
Chris@76	2658 array(
Chris@76	2659 'member_list' => $owner,
Chris@76	2660 'is_deleted' => 1,
Chris@76	2661 'not_deleted' => 0,
Chris@76	2662 'pm_list' => $personal_messages !== null ? array_unique($personal_messages) : array(),
Chris@76	2663 )
Chris@76	2664 );
Chris@76	2665 }
Chris@76	2666
Chris@76	2667 // If sender and recipients all have deleted their message, it can be removed.
Chris@76	2668 $request = $smcFunc['db_query']('', '
Chris@76	2669 SELECT pm.id_pm AS sender, pmr.id_pm
Chris@76	2670 FROM {db_prefix}personal_messages AS pm
Chris@76	2671 LEFT JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm AND pmr.deleted = {int:not_deleted})
Chris@76	2672 WHERE pm.deleted_by_sender = {int:is_deleted}
Chris@76	2673 ' . str_replace('id_pm', 'pm.id_pm', $where) . '
Chris@76	2674 GROUP BY sender, pmr.id_pm
Chris@76	2675 HAVING pmr.id_pm IS null',
Chris@76	2676 array(
Chris@76	2677 'not_deleted' => 0,
Chris@76	2678 'is_deleted' => 1,
Chris@76	2679 'pm_list' => $personal_messages !== null ? array_unique($personal_messages) : array(),
Chris@76	2680 )
Chris@76	2681 );
Chris@76	2682 $remove_pms = array();
Chris@76	2683 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	2684 $remove_pms[] = $row['sender'];
Chris@76	2685 $smcFunc['db_free_result']($request);
Chris@76	2686
Chris@76	2687 if (!empty($remove_pms))
Chris@76	2688 {
Chris@76	2689 $smcFunc['db_query']('', '
Chris@76	2690 DELETE FROM {db_prefix}personal_messages
Chris@76	2691 WHERE id_pm IN ({array_int:pm_list})',
Chris@76	2692 array(
Chris@76	2693 'pm_list' => $remove_pms,
Chris@76	2694 )
Chris@76	2695 );
Chris@76	2696
Chris@76	2697 $smcFunc['db_query']('', '
Chris@76	2698 DELETE FROM {db_prefix}pm_recipients
Chris@76	2699 WHERE id_pm IN ({array_int:pm_list})',
Chris@76	2700 array(
Chris@76	2701 'pm_list' => $remove_pms,
Chris@76	2702 )
Chris@76	2703 );
Chris@76	2704 }
Chris@76	2705
Chris@76	2706 // Any cached numbers may be wrong now.
Chris@76	2707 cache_put_data('labelCounts:' . $user_info['id'], null, 720);
Chris@76	2708 }
Chris@76	2709
Chris@76	2710 // Mark personal messages read.
Chris@76	2711 function markMessages($personal_messages = null, $label = null, $owner = null)
Chris@76	2712 {
Chris@76	2713 global $user_info, $context, $smcFunc;
Chris@76	2714
Chris@76	2715 if ($owner === null)
Chris@76	2716 $owner = $user_info['id'];
Chris@76	2717
Chris@76	2718 $smcFunc['db_query']('', '
Chris@76	2719 UPDATE {db_prefix}pm_recipients
Chris@76	2720 SET is_read = is_read \| 1
Chris@76	2721 WHERE id_member = {int:id_member}
Chris@76	2722 AND NOT (is_read & 1 >= 1)' . ($label === null ? '' : '
Chris@76	2723 AND FIND_IN_SET({string:label}, labels) != 0') . ($personal_messages !== null ? '
Chris@76	2724 AND id_pm IN ({array_int:personal_messages})' : ''),
Chris@76	2725 array(
Chris@76	2726 'personal_messages' => $personal_messages,
Chris@76	2727 'id_member' => $owner,
Chris@76	2728 'label' => $label,
Chris@76	2729 )
Chris@76	2730 );
Chris@76	2731
Chris@76	2732 // If something wasn't marked as read, get the number of unread messages remaining.
Chris@76	2733 if ($smcFunc['db_affected_rows']() > 0)
Chris@76	2734 {
Chris@76	2735 if ($owner == $user_info['id'])
Chris@76	2736 {
Chris@76	2737 foreach ($context['labels'] as $label)
Chris@76	2738 $context['labels'][(int) $label['id']]['unread_messages'] = 0;
Chris@76	2739 }
Chris@76	2740
Chris@76	2741 $result = $smcFunc['db_query']('', '
Chris@76	2742 SELECT labels, COUNT(*) AS num
Chris@76	2743 FROM {db_prefix}pm_recipients
Chris@76	2744 WHERE id_member = {int:id_member}
Chris@76	2745 AND NOT (is_read & 1 >= 1)
Chris@76	2746 AND deleted = {int:is_not_deleted}
Chris@76	2747 GROUP BY labels',
Chris@76	2748 array(
Chris@76	2749 'id_member' => $owner,
Chris@76	2750 'is_not_deleted' => 0,
Chris@76	2751 )
Chris@76	2752 );
Chris@76	2753 $total_unread = 0;
Chris@76	2754 while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76	2755 {
Chris@76	2756 $total_unread += $row['num'];
Chris@76	2757
Chris@76	2758 if ($owner != $user_info['id'])
Chris@76	2759 continue;
Chris@76	2760
Chris@76	2761 $this_labels = explode(',', $row['labels']);
Chris@76	2762 foreach ($this_labels as $this_label)
Chris@76	2763 $context['labels'][(int) $this_label]['unread_messages'] += $row['num'];
Chris@76	2764 }
Chris@76	2765 $smcFunc['db_free_result']($result);
Chris@76	2766
Chris@76	2767 // Need to store all this.
Chris@76	2768 cache_put_data('labelCounts:' . $owner, $context['labels'], 720);
Chris@76	2769 updateMemberData($owner, array('unread_messages' => $total_unread));
Chris@76	2770
Chris@76	2771 // If it was for the current member, reflect this in the $user_info array too.
Chris@76	2772 if ($owner == $user_info['id'])
Chris@76	2773 $user_info['unread_messages'] = $total_unread;
Chris@76	2774 }
Chris@76	2775 }
Chris@76	2776
Chris@76	2777 // This function handles adding, deleting and editing labels on messages.
Chris@76	2778 function ManageLabels()
Chris@76	2779 {
Chris@76	2780 global $txt, $context, $user_info, $scripturl, $smcFunc;
Chris@76	2781
Chris@76	2782 // Build the link tree elements...
Chris@76	2783 $context['linktree'][] = array(
Chris@76	2784 'url' => $scripturl . '?action=pm;sa=manlabels',
Chris@76	2785 'name' => $txt['pm_manage_labels']
Chris@76	2786 );
Chris@76	2787
Chris@76	2788 $context['page_title'] = $txt['pm_manage_labels'];
Chris@76	2789 $context['sub_template'] = 'labels';
Chris@76	2790
Chris@76	2791 $the_labels = array();
Chris@76	2792 // Add all existing labels to the array to save, slashing them as necessary...
Chris@76	2793 foreach ($context['labels'] as $label)
Chris@76	2794 {
Chris@76	2795 if ($label['id'] != -1)
Chris@76	2796 $the_labels[$label['id']] = $label['name'];
Chris@76	2797 }
Chris@76	2798
Chris@76	2799 if (isset($_POST[$context['session_var']]))
Chris@76	2800 {
Chris@76	2801 checkSession('post');
Chris@76	2802
Chris@76	2803 // This will be for updating messages.
Chris@76	2804 $message_changes = array();
Chris@76	2805 $new_labels = array();
Chris@76	2806 $rule_changes = array();
Chris@76	2807
Chris@76	2808 // Will most likely need this.
Chris@76	2809 LoadRules();
Chris@76	2810
Chris@76	2811 // Adding a new label?
Chris@76	2812 if (isset($_POST['add']))
Chris@76	2813 {
Chris@76	2814 $_POST['label'] = strtr($smcFunc['htmlspecialchars'](trim($_POST['label'])), array(',' => ','));
Chris@76	2815
Chris@76	2816 if ($smcFunc['strlen']($_POST['label']) > 30)
Chris@76	2817 $_POST['label'] = $smcFunc['substr']($_POST['label'], 0, 30);
Chris@76	2818 if ($_POST['label'] != '')
Chris@76	2819 $the_labels[] = $_POST['label'];
Chris@76	2820 }
Chris@76	2821 // Deleting an existing label?
Chris@76	2822 elseif (isset($_POST['delete'], $_POST['delete_label']))
Chris@76	2823 {
Chris@76	2824 $i = 0;
Chris@76	2825 foreach ($the_labels as $id => $name)
Chris@76	2826 {
Chris@76	2827 if (isset($_POST['delete_label'][$id]))
Chris@76	2828 {
Chris@76	2829 unset($the_labels[$id]);
Chris@76	2830 $message_changes[$id] = true;
Chris@76	2831 }
Chris@76	2832 else
Chris@76	2833 $new_labels[$id] = $i++;
Chris@76	2834 }
Chris@76	2835 }
Chris@76	2836 // The hardest one to deal with... changes.
Chris@76	2837 elseif (isset($_POST['save']) && !empty($_POST['label_name']))
Chris@76	2838 {
Chris@76	2839 $i = 0;
Chris@76	2840 foreach ($the_labels as $id => $name)
Chris@76	2841 {
Chris@76	2842 if ($id == -1)
Chris@76	2843 continue;
Chris@76	2844 elseif (isset($_POST['label_name'][$id]))
Chris@76	2845 {
Chris@76	2846 $_POST['label_name'][$id] = trim(strtr($smcFunc['htmlspecialchars']($_POST['label_name'][$id]), array(',' => ',')));
Chris@76	2847
Chris@76	2848 if ($smcFunc['strlen']($_POST['label_name'][$id]) > 30)
Chris@76	2849 $_POST['label_name'][$id] = $smcFunc['substr']($_POST['label_name'][$id], 0, 30);
Chris@76	2850 if ($_POST['label_name'][$id] != '')
Chris@76	2851 {
Chris@76	2852 $the_labels[(int) $id] = $_POST['label_name'][$id];
Chris@76	2853 $new_labels[$id] = $i++;
Chris@76	2854 }
Chris@76	2855 else
Chris@76	2856 {
Chris@76	2857 unset($the_labels[(int) $id]);
Chris@76	2858 $message_changes[(int) $id] = true;
Chris@76	2859 }
Chris@76	2860 }
Chris@76	2861 else
Chris@76	2862 $new_labels[$id] = $i++;
Chris@76	2863 }
Chris@76	2864 }
Chris@76	2865
Chris@76	2866 // Save the label status.
Chris@76	2867 updateMemberData($user_info['id'], array('message_labels' => implode(',', $the_labels)));
Chris@76	2868
Chris@76	2869 // Update all the messages currently with any label changes in them!
Chris@76	2870 if (!empty($message_changes))
Chris@76	2871 {
Chris@76	2872 $searchArray = array_keys($message_changes);
Chris@76	2873
Chris@76	2874 if (!empty($new_labels))
Chris@76	2875 {
Chris@76	2876 for ($i = max($searchArray) + 1, $n = max(array_keys($new_labels)); $i <= $n; $i++)
Chris@76	2877 $searchArray[] = $i;
Chris@76	2878 }
Chris@76	2879
Chris@76	2880 // Now find the messages to change.
Chris@76	2881 $request = $smcFunc['db_query']('', '
Chris@76	2882 SELECT id_pm, labels
Chris@76	2883 FROM {db_prefix}pm_recipients
Chris@76	2884 WHERE FIND_IN_SET({raw:find_label_implode}, labels) != 0
Chris@76	2885 AND id_member = {int:current_member}',
Chris@76	2886 array(
Chris@76	2887 'current_member' => $user_info['id'],
Chris@76	2888 'find_label_implode' => '\'' . implode('\', labels) != 0 OR FIND_IN_SET(\'', $searchArray) . '\'',
Chris@76	2889 )
Chris@76	2890 );
Chris@76	2891 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	2892 {
Chris@76	2893 // Do the long task of updating them...
Chris@76	2894 $toChange = explode(',', $row['labels']);
Chris@76	2895
Chris@76	2896 foreach ($toChange as $key => $value)
Chris@76	2897 if (in_array($value, $searchArray))
Chris@76	2898 {
Chris@76	2899 if (isset($new_labels[$value]))
Chris@76	2900 $toChange[$key] = $new_labels[$value];
Chris@76	2901 else
Chris@76	2902 unset($toChange[$key]);
Chris@76	2903 }
Chris@76	2904
Chris@76	2905 if (empty($toChange))
Chris@76	2906 $toChange[] = '-1';
Chris@76	2907
Chris@76	2908 // Update the message.
Chris@76	2909 $smcFunc['db_query']('', '
Chris@76	2910 UPDATE {db_prefix}pm_recipients
Chris@76	2911 SET labels = {string:new_labels}
Chris@76	2912 WHERE id_pm = {int:id_pm}
Chris@76	2913 AND id_member = {int:current_member}',
Chris@76	2914 array(
Chris@76	2915 'current_member' => $user_info['id'],
Chris@76	2916 'id_pm' => $row['id_pm'],
Chris@76	2917 'new_labels' => implode(',', array_unique($toChange)),
Chris@76	2918 )
Chris@76	2919 );
Chris@76	2920 }
Chris@76	2921 $smcFunc['db_free_result']($request);
Chris@76	2922
Chris@76	2923 // Now do the same the rules - check through each rule.
Chris@76	2924 foreach ($context['rules'] as $k => $rule)
Chris@76	2925 {
Chris@76	2926 // Each action...
Chris@76	2927 foreach ($rule['actions'] as $k2 => $action)
Chris@76	2928 {
Chris@76	2929 if ($action['t'] != 'lab' \|\| !in_array($action['v'], $searchArray))
Chris@76	2930 continue;
Chris@76	2931
Chris@76	2932 $rule_changes[] = $rule['id'];
Chris@76	2933 // If we're here we have a label which is either changed or gone...
Chris@76	2934 if (isset($new_labels[$action['v']]))
Chris@76	2935 $context['rules'][$k]['actions'][$k2]['v'] = $new_labels[$action['v']];
Chris@76	2936 else
Chris@76	2937 unset($context['rules'][$k]['actions'][$k2]);
Chris@76	2938 }
Chris@76	2939 }
Chris@76	2940 }
Chris@76	2941
Chris@76	2942 // If we have rules to change do so now.
Chris@76	2943 if (!empty($rule_changes))
Chris@76	2944 {
Chris@76	2945 $rule_changes = array_unique($rule_changes);
Chris@76	2946 // Update/delete as appropriate.
Chris@76	2947 foreach ($rule_changes as $k => $id)
Chris@76	2948 if (!empty($context['rules'][$id]['actions']))
Chris@76	2949 {
Chris@76	2950 $smcFunc['db_query']('', '
Chris@76	2951 UPDATE {db_prefix}pm_rules
Chris@76	2952 SET actions = {string:actions}
Chris@76	2953 WHERE id_rule = {int:id_rule}
Chris@76	2954 AND id_member = {int:current_member}',
Chris@76	2955 array(
Chris@76	2956 'current_member' => $user_info['id'],
Chris@76	2957 'id_rule' => $id,
Chris@76	2958 'actions' => serialize($context['rules'][$id]['actions']),
Chris@76	2959 )
Chris@76	2960 );
Chris@76	2961 unset($rule_changes[$k]);
Chris@76	2962 }
Chris@76	2963
Chris@76	2964 // Anything left here means it's lost all actions...
Chris@76	2965 if (!empty($rule_changes))
Chris@76	2966 $smcFunc['db_query']('', '
Chris@76	2967 DELETE FROM {db_prefix}pm_rules
Chris@76	2968 WHERE id_rule IN ({array_int:rule_list})
Chris@76	2969 AND id_member = {int:current_member}',
Chris@76	2970 array(
Chris@76	2971 'current_member' => $user_info['id'],
Chris@76	2972 'rule_list' => $rule_changes,
Chris@76	2973 )
Chris@76	2974 );
Chris@76	2975 }
Chris@76	2976
Chris@76	2977 // Make sure we're not caching this!
Chris@76	2978 cache_put_data('labelCounts:' . $user_info['id'], null, 720);
Chris@76	2979
Chris@76	2980 // To make the changes appear right away, redirect.
Chris@76	2981 redirectexit('action=pm;sa=manlabels');
Chris@76	2982 }
Chris@76	2983 }
Chris@76	2984
Chris@76	2985 // Edit Personal Message Settings
Chris@76	2986 function MessageSettings()
Chris@76	2987 {
Chris@76	2988 global $txt, $user_settings, $user_info, $context, $sourcedir, $smcFunc;
Chris@76	2989 global $scripturl, $profile_vars, $cur_profile, $user_profile;
Chris@76	2990
Chris@76	2991 // Need this for the display.
Chris@76	2992 require_once($sourcedir . '/Profile.php');
Chris@76	2993 require_once($sourcedir . '/Profile-Modify.php');
Chris@76	2994
Chris@76	2995 // We want them to submit back to here.
Chris@76	2996 $context['profile_custom_submit_url'] = $scripturl . '?action=pm;sa=settings;save';
Chris@76	2997
Chris@76	2998 loadMemberData($user_info['id'], false, 'profile');
Chris@76	2999 $cur_profile = $user_profile[$user_info['id']];
Chris@76	3000
Chris@76	3001 loadLanguage('Profile');
Chris@76	3002 loadTemplate('Profile');
Chris@76	3003
Chris@76	3004 $context['page_title'] = $txt['pm_settings'];
Chris@76	3005 $context['user']['is_owner'] = true;
Chris@76	3006 $context['id_member'] = $user_info['id'];
Chris@76	3007 $context['require_password'] = false;
Chris@76	3008 $context['menu_item_selected'] = 'settings';
Chris@76	3009 $context['submit_button_text'] = $txt['pm_settings'];
Chris@76	3010 $context['profile_header_text'] = $txt['personal_messages'];
Chris@76	3011
Chris@76	3012 // Add our position to the linktree.
Chris@76	3013 $context['linktree'][] = array(
Chris@76	3014 'url' => $scripturl . '?action=pm;sa=settings',
Chris@76	3015 'name' => $txt['pm_settings']
Chris@76	3016 );
Chris@76	3017
Chris@76	3018 // Are they saving?
Chris@76	3019 if (isset($_REQUEST['save']))
Chris@76	3020 {
Chris@76	3021 checkSession('post');
Chris@76	3022
Chris@76	3023 // Mimic what profile would do.
Chris@76	3024 $_POST = htmltrim__recursive($_POST);
Chris@76	3025 $_POST = htmlspecialchars__recursive($_POST);
Chris@76	3026
Chris@76	3027 // Save the fields.
Chris@76	3028 saveProfileFields();
Chris@76	3029
Chris@76	3030 if (!empty($profile_vars))
Chris@76	3031 updateMemberData($user_info['id'], $profile_vars);
Chris@76	3032 }
Chris@76	3033
Chris@76	3034 // Load up the fields.
Chris@76	3035 pmprefs($user_info['id']);
Chris@76	3036 }
Chris@76	3037
Chris@76	3038 // Allows a user to report a personal message they receive to the administrator.
Chris@76	3039 function ReportMessage()
Chris@76	3040 {
Chris@76	3041 global $txt, $context, $scripturl, $sourcedir;
Chris@76	3042 global $user_info, $language, $modSettings, $smcFunc;
Chris@76	3043
Chris@76	3044 // Check that this feature is even enabled!
Chris@76	3045 if (empty($modSettings['enableReportPM']) \|\| empty($_REQUEST['pmsg']))
Chris@76	3046 fatal_lang_error('no_access', false);
Chris@76	3047
Chris@76	3048 $pmsg = (int) $_REQUEST['pmsg'];
Chris@76	3049
Chris@76	3050 if (!isAccessiblePM($pmsg, 'inbox'))
Chris@76	3051 fatal_lang_error('no_access', false);
Chris@76	3052
Chris@76	3053 $context['pm_id'] = $pmsg;
Chris@76	3054 $context['page_title'] = $txt['pm_report_title'];
Chris@76	3055
Chris@76	3056 // If we're here, just send the user to the template, with a few useful context bits.
Chris@76	3057 if (!isset($_POST['report']))
Chris@76	3058 {
Chris@76	3059 $context['sub_template'] = 'report_message';
Chris@76	3060
Chris@76	3061 // !!! I don't like being able to pick who to send it to. Favoritism, etc. sucks.
Chris@76	3062 // Now, get all the administrators.
Chris@76	3063 $request = $smcFunc['db_query']('', '
Chris@76	3064 SELECT id_member, real_name
Chris@76	3065 FROM {db_prefix}members
Chris@76	3066 WHERE id_group = {int:admin_group} OR FIND_IN_SET({int:admin_group}, additional_groups) != 0
Chris@76	3067 ORDER BY real_name',
Chris@76	3068 array(
Chris@76	3069 'admin_group' => 1,
Chris@76	3070 )
Chris@76	3071 );
Chris@76	3072 $context['admins'] = array();
Chris@76	3073 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	3074 $context['admins'][$row['id_member']] = $row['real_name'];
Chris@76	3075 $smcFunc['db_free_result']($request);
Chris@76	3076
Chris@76	3077 // How many admins in total?
Chris@76	3078 $context['admin_count'] = count($context['admins']);
Chris@76	3079 }
Chris@76	3080 // Otherwise, let's get down to the sending stuff.
Chris@76	3081 else
Chris@76	3082 {
Chris@76	3083 // Check the session before proceeding any further!
Chris@76	3084 checkSession('post');
Chris@76	3085
Chris@76	3086 // First, pull out the message contents, and verify it actually went to them!
Chris@76	3087 $request = $smcFunc['db_query']('', '
Chris@76	3088 SELECT pm.subject, pm.body, pm.msgtime, pm.id_member_from, IFNULL(m.real_name, pm.from_name) AS sender_name
Chris@76	3089 FROM {db_prefix}personal_messages AS pm
Chris@76	3090 INNER JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm)
Chris@76	3091 LEFT JOIN {db_prefix}members AS m ON (m.id_member = pm.id_member_from)
Chris@76	3092 WHERE pm.id_pm = {int:id_pm}
Chris@76	3093 AND pmr.id_member = {int:current_member}
Chris@76	3094 AND pmr.deleted = {int:not_deleted}
Chris@76	3095 LIMIT 1',
Chris@76	3096 array(
Chris@76	3097 'current_member' => $user_info['id'],
Chris@76	3098 'id_pm' => $context['pm_id'],
Chris@76	3099 'not_deleted' => 0,
Chris@76	3100 )
Chris@76	3101 );
Chris@76	3102 // Can only be a hacker here!
Chris@76	3103 if ($smcFunc['db_num_rows']($request) == 0)
Chris@76	3104 fatal_lang_error('no_access', false);
Chris@76	3105 list ($subject, $body, $time, $memberFromID, $memberFromName) = $smcFunc['db_fetch_row']($request);
Chris@76	3106 $smcFunc['db_free_result']($request);
Chris@76	3107
Chris@76	3108 // Remove the line breaks...
Chris@76	3109 $body = preg_replace('~<br ?/?' . '>~i', "\n", $body);
Chris@76	3110
Chris@76	3111 // Get any other recipients of the email.
Chris@76	3112 $request = $smcFunc['db_query']('', '
Chris@76	3113 SELECT mem_to.id_member AS id_member_to, mem_to.real_name AS to_name, pmr.bcc
Chris@76	3114 FROM {db_prefix}pm_recipients AS pmr
Chris@76	3115 LEFT JOIN {db_prefix}members AS mem_to ON (mem_to.id_member = pmr.id_member)
Chris@76	3116 WHERE pmr.id_pm = {int:id_pm}
Chris@76	3117 AND pmr.id_member != {int:current_member}',
Chris@76	3118 array(
Chris@76	3119 'current_member' => $user_info['id'],
Chris@76	3120 'id_pm' => $context['pm_id'],
Chris@76	3121 )
Chris@76	3122 );
Chris@76	3123 $recipients = array();
Chris@76	3124 $hidden_recipients = 0;
Chris@76	3125 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	3126 {
Chris@76	3127 // If it's hidden still don't reveal their names - privacy after all ;)
Chris@76	3128 if ($row['bcc'])
Chris@76	3129 $hidden_recipients++;
Chris@76	3130 else
Chris@76	3131 $recipients[] = '[url=' . $scripturl . '?action=profile;u=' . $row['id_member_to'] . ']' . $row['to_name'] . '[/url]';
Chris@76	3132 }
Chris@76	3133 $smcFunc['db_free_result']($request);
Chris@76	3134
Chris@76	3135 if ($hidden_recipients)
Chris@76	3136 $recipients[] = sprintf($txt['pm_report_pm_hidden'], $hidden_recipients);
Chris@76	3137
Chris@76	3138 // Now let's get out and loop through the admins.
Chris@76	3139 $request = $smcFunc['db_query']('', '
Chris@76	3140 SELECT id_member, real_name, lngfile
Chris@76	3141 FROM {db_prefix}members
Chris@76	3142 WHERE (id_group = {int:admin_id} OR FIND_IN_SET({int:admin_id}, additional_groups) != 0)
Chris@76	3143 ' . (empty($_POST['ID_ADMIN']) ? '' : 'AND id_member = {int:specific_admin}') . '
Chris@76	3144 ORDER BY lngfile',
Chris@76	3145 array(
Chris@76	3146 'admin_id' => 1,
Chris@76	3147 'specific_admin' => isset($_POST['ID_ADMIN']) ? (int) $_POST['ID_ADMIN'] : 0,
Chris@76	3148 )
Chris@76	3149 );
Chris@76	3150
Chris@76	3151 // Maybe we shouldn't advertise this?
Chris@76	3152 if ($smcFunc['db_num_rows']($request) == 0)
Chris@76	3153 fatal_lang_error('no_access', false);
Chris@76	3154
Chris@76	3155 $memberFromName = un_htmlspecialchars($memberFromName);
Chris@76	3156
Chris@76	3157 // Prepare the message storage array.
Chris@76	3158 $messagesToSend = array();
Chris@76	3159 // Loop through each admin, and add them to the right language pile...
Chris@76	3160 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	3161 {
Chris@76	3162 // Need to send in the correct language!
Chris@76	3163 $cur_language = empty($row['lngfile']) \|\| empty($modSettings['userLanguage']) ? $language : $row['lngfile'];
Chris@76	3164
Chris@76	3165 if (!isset($messagesToSend[$cur_language]))
Chris@76	3166 {
Chris@76	3167 loadLanguage('PersonalMessage', $cur_language, false);
Chris@76	3168
Chris@76	3169 // Make the body.
Chris@76	3170 $report_body = str_replace(array('{REPORTER}', '{SENDER}'), array(un_htmlspecialchars($user_info['name']), $memberFromName), $txt['pm_report_pm_user_sent']);
Chris@76	3171 $report_body .= "\n" . '[b]' . $_POST['reason'] . '[/b]' . "\n\n";
Chris@76	3172 if (!empty($recipients))
Chris@76	3173 $report_body .= $txt['pm_report_pm_other_recipients'] . ' ' . implode(', ', $recipients) . "\n\n";
Chris@76	3174 $report_body .= $txt['pm_report_pm_unedited_below'] . "\n" . '[quote author=' . (empty($memberFromID) ? '"' . $memberFromName . '"' : $memberFromName . ' link=action=profile;u=' . $memberFromID . ' date=' . $time) . ']' . "\n" . un_htmlspecialchars($body) . '[/quote]';
Chris@76	3175
Chris@76	3176 // Plonk it in the array ;)
Chris@76	3177 $messagesToSend[$cur_language] = array(
Chris@76	3178 'subject' => ($smcFunc['strpos']($subject, $txt['pm_report_pm_subject']) === false ? $txt['pm_report_pm_subject'] : '') . un_htmlspecialchars($subject),
Chris@76	3179 'body' => $report_body,
Chris@76	3180 'recipients' => array(
Chris@76	3181 'to' => array(),
Chris@76	3182 'bcc' => array()
Chris@76	3183 ),
Chris@76	3184 );
Chris@76	3185 }
Chris@76	3186
Chris@76	3187 // Add them to the list.
Chris@76	3188 $messagesToSend[$cur_language]['recipients']['to'][$row['id_member']] = $row['id_member'];
Chris@76	3189 }
Chris@76	3190 $smcFunc['db_free_result']($request);
Chris@76	3191
Chris@76	3192 // Send a different email for each language.
Chris@76	3193 foreach ($messagesToSend as $lang => $message)
Chris@76	3194 sendpm($message['recipients'], $message['subject'], $message['body']);
Chris@76	3195
Chris@76	3196 // Give the user their own language back!
Chris@76	3197 if (!empty($modSettings['userLanguage']))
Chris@76	3198 loadLanguage('PersonalMessage', '', false);
Chris@76	3199
Chris@76	3200 // Leave them with a template.
Chris@76	3201 $context['sub_template'] = 'report_message_complete';
Chris@76	3202 }
Chris@76	3203 }
Chris@76	3204
Chris@76	3205 // List all rules, and allow adding/entering etc....
Chris@76	3206 function ManageRules()
Chris@76	3207 {
Chris@76	3208 global $txt, $context, $user_info, $scripturl, $smcFunc;
Chris@76	3209
Chris@76	3210 // The link tree - gotta have this :o
Chris@76	3211 $context['linktree'][] = array(
Chris@76	3212 'url' => $scripturl . '?action=pm;sa=manrules',
Chris@76	3213 'name' => $txt['pm_manage_rules']
Chris@76	3214 );
Chris@76	3215
Chris@76	3216 $context['page_title'] = $txt['pm_manage_rules'];
Chris@76	3217 $context['sub_template'] = 'rules';
Chris@76	3218
Chris@76	3219 // Load them... load them!!
Chris@76	3220 LoadRules();
Chris@76	3221
Chris@76	3222 // Likely to need all the groups!
Chris@76	3223 $request = $smcFunc['db_query']('', '
Chris@76	3224 SELECT mg.id_group, mg.group_name, IFNULL(gm.id_member, 0) AS can_moderate, mg.hidden
Chris@76	3225 FROM {db_prefix}membergroups AS mg
Chris@76	3226 LEFT JOIN {db_prefix}group_moderators AS gm ON (gm.id_group = mg.id_group AND gm.id_member = {int:current_member})
Chris@76	3227 WHERE mg.min_posts = {int:min_posts}
Chris@76	3228 AND mg.id_group != {int:moderator_group}
Chris@76	3229 AND mg.hidden = {int:not_hidden}
Chris@76	3230 ORDER BY mg.group_name',
Chris@76	3231 array(
Chris@76	3232 'current_member' => $user_info['id'],
Chris@76	3233 'min_posts' => -1,
Chris@76	3234 'moderator_group' => 3,
Chris@76	3235 'not_hidden' => 0,
Chris@76	3236 )
Chris@76	3237 );
Chris@76	3238 $context['groups'] = array();
Chris@76	3239 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	3240 {
Chris@76	3241 // Hide hidden groups!
Chris@76	3242 if ($row['hidden'] && !$row['can_moderate'] && !allowedTo('manage_membergroups'))
Chris@76	3243 continue;
Chris@76	3244
Chris@76	3245 $context['groups'][$row['id_group']] = $row['group_name'];
Chris@76	3246 }
Chris@76	3247 $smcFunc['db_free_result']($request);
Chris@76	3248
Chris@76	3249 // Applying all rules?
Chris@76	3250 if (isset($_GET['apply']))
Chris@76	3251 {
Chris@76	3252 checkSession('get');
Chris@76	3253
Chris@76	3254 ApplyRules(true);
Chris@76	3255 redirectexit('action=pm;sa=manrules');
Chris@76	3256 }
Chris@76	3257 // Editing a specific one?
Chris@76	3258 if (isset($_GET['add']))
Chris@76	3259 {
Chris@76	3260 $context['rid'] = isset($_GET['rid']) && isset($context['rules'][$_GET['rid']])? (int) $_GET['rid'] : 0;
Chris@76	3261 $context['sub_template'] = 'add_rule';
Chris@76	3262
Chris@76	3263 // Current rule information...
Chris@76	3264 if ($context['rid'])
Chris@76	3265 {
Chris@76	3266 $context['rule'] = $context['rules'][$context['rid']];
Chris@76	3267 $members = array();
Chris@76	3268 // Need to get member names!
Chris@76	3269 foreach ($context['rule']['criteria'] as $k => $criteria)
Chris@76	3270 if ($criteria['t'] == 'mid' && !empty($criteria['v']))
Chris@76	3271 $members[(int) $criteria['v']] = $k;
Chris@76	3272
Chris@76	3273 if (!empty($members))
Chris@76	3274 {
Chris@76	3275 $request = $smcFunc['db_query']('', '
Chris@76	3276 SELECT id_member, member_name
Chris@76	3277 FROM {db_prefix}members
Chris@76	3278 WHERE id_member IN ({array_int:member_list})',
Chris@76	3279 array(
Chris@76	3280 'member_list' => array_keys($members),
Chris@76	3281 )
Chris@76	3282 );
Chris@76	3283 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	3284 $context['rule']['criteria'][$members[$row['id_member']]]['v'] = $row['member_name'];
Chris@76	3285 $smcFunc['db_free_result']($request);
Chris@76	3286 }
Chris@76	3287 }
Chris@76	3288 else
Chris@76	3289 $context['rule'] = array(
Chris@76	3290 'id' => '',
Chris@76	3291 'name' => '',
Chris@76	3292 'criteria' => array(),
Chris@76	3293 'actions' => array(),
Chris@76	3294 'logic' => 'and',
Chris@76	3295 );
Chris@76	3296 }
Chris@76	3297 // Saving?
Chris@76	3298 elseif (isset($_GET['save']))
Chris@76	3299 {
Chris@76	3300 checkSession('post');
Chris@76	3301 $context['rid'] = isset($_GET['rid']) && isset($context['rules'][$_GET['rid']])? (int) $_GET['rid'] : 0;
Chris@76	3302
Chris@76	3303 // Name is easy!
Chris@76	3304 $ruleName = $smcFunc['htmlspecialchars'](trim($_POST['rule_name']));
Chris@76	3305 if (empty($ruleName))
Chris@76	3306 fatal_lang_error('pm_rule_no_name', false);
Chris@76	3307
Chris@76	3308 // Sanity check...
Chris@76	3309 if (empty($_POST['ruletype']) \|\| empty($_POST['acttype']))
Chris@76	3310 fatal_lang_error('pm_rule_no_criteria', false);
Chris@76	3311
Chris@76	3312 // Let's do the criteria first - it's also hardest!
Chris@76	3313 $criteria = array();
Chris@76	3314 foreach ($_POST['ruletype'] as $ind => $type)
Chris@76	3315 {
Chris@76	3316 // Check everything is here...
Chris@76	3317 if ($type == 'gid' && (!isset($_POST['ruledefgroup'][$ind]) \|\| !isset($context['groups'][$_POST['ruledefgroup'][$ind]])))
Chris@76	3318 continue;
Chris@76	3319 elseif ($type != 'bud' && !isset($_POST['ruledef'][$ind]))
Chris@76	3320 continue;
Chris@76	3321
Chris@76	3322 // Members need to be found.
Chris@76	3323 if ($type == 'mid')
Chris@76	3324 {
Chris@76	3325 $name = trim($_POST['ruledef'][$ind]);
Chris@76	3326 $request = $smcFunc['db_query']('', '
Chris@76	3327 SELECT id_member
Chris@76	3328 FROM {db_prefix}members
Chris@76	3329 WHERE real_name = {string:member_name}
Chris@76	3330 OR member_name = {string:member_name}',
Chris@76	3331 array(
Chris@76	3332 'member_name' => $name,
Chris@76	3333 )
Chris@76	3334 );
Chris@76	3335 if ($smcFunc['db_num_rows']($request) == 0)
Chris@76	3336 continue;
Chris@76	3337 list ($memID) = $smcFunc['db_fetch_row']($request);
Chris@76	3338 $smcFunc['db_free_result']($request);
Chris@76	3339
Chris@76	3340 $criteria[] = array('t' => 'mid', 'v' => $memID);
Chris@76	3341 }
Chris@76	3342 elseif ($type == 'bud')
Chris@76	3343 $criteria[] = array('t' => 'bud', 'v' => 1);
Chris@76	3344 elseif ($type == 'gid')
Chris@76	3345 $criteria[] = array('t' => 'gid', 'v' => (int) $_POST['ruledefgroup'][$ind]);
Chris@76	3346 elseif (in_array($type, array('sub', 'msg')) && trim($_POST['ruledef'][$ind]) != '')
Chris@76	3347 $criteria[] = array('t' => $type, 'v' => $smcFunc['htmlspecialchars'](trim($_POST['ruledef'][$ind])));
Chris@76	3348 }
Chris@76	3349
Chris@76	3350 // Also do the actions!
Chris@76	3351 $actions = array();
Chris@76	3352 $doDelete = 0;
Chris@76	3353 $isOr = $_POST['rule_logic'] == 'or' ? 1 : 0;
Chris@76	3354 foreach ($_POST['acttype'] as $ind => $type)
Chris@76	3355 {
Chris@76	3356 // Picking a valid label?
Chris@76	3357 if ($type == 'lab' && (!isset($_POST['labdef'][$ind]) \|\| !isset($context['labels'][$_POST['labdef'][$ind] - 1])))
Chris@76	3358 continue;
Chris@76	3359
Chris@76	3360 // Record what we're doing.
Chris@76	3361 if ($type == 'del')
Chris@76	3362 $doDelete = 1;
Chris@76	3363 elseif ($type == 'lab')
Chris@76	3364 $actions[] = array('t' => 'lab', 'v' => (int) $_POST['labdef'][$ind] - 1);
Chris@76	3365 }
Chris@76	3366
Chris@76	3367 if (empty($criteria) \|\| (empty($actions) && !$doDelete))
Chris@76	3368 fatal_lang_error('pm_rule_no_criteria', false);
Chris@76	3369
Chris@76	3370 // What are we storing?
Chris@76	3371 $criteria = serialize($criteria);
Chris@76	3372 $actions = serialize($actions);
Chris@76	3373
Chris@76	3374 // Create the rule?
Chris@76	3375 if (empty($context['rid']))
Chris@76	3376 $smcFunc['db_insert']('',
Chris@76	3377 '{db_prefix}pm_rules',
Chris@76	3378 array(
Chris@76	3379 'id_member' => 'int', 'rule_name' => 'string', 'criteria' => 'string', 'actions' => 'string',
Chris@76	3380 'delete_pm' => 'int', 'is_or' => 'int',
Chris@76	3381 ),
Chris@76	3382 array(
Chris@76	3383 $user_info['id'], $ruleName, $criteria, $actions, $doDelete, $isOr,
Chris@76	3384 ),
Chris@76	3385 array('id_rule')
Chris@76	3386 );
Chris@76	3387 else
Chris@76	3388 $smcFunc['db_query']('', '
Chris@76	3389 UPDATE {db_prefix}pm_rules
Chris@76	3390 SET rule_name = {string:rule_name}, criteria = {string:criteria}, actions = {string:actions},
Chris@76	3391 delete_pm = {int:delete_pm}, is_or = {int:is_or}
Chris@76	3392 WHERE id_rule = {int:id_rule}
Chris@76	3393 AND id_member = {int:current_member}',
Chris@76	3394 array(
Chris@76	3395 'current_member' => $user_info['id'],
Chris@76	3396 'delete_pm' => $doDelete,
Chris@76	3397 'is_or' => $isOr,
Chris@76	3398 'id_rule' => $context['rid'],
Chris@76	3399 'rule_name' => $ruleName,
Chris@76	3400 'criteria' => $criteria,
Chris@76	3401 'actions' => $actions,
Chris@76	3402 )
Chris@76	3403 );
Chris@76	3404
Chris@76	3405 redirectexit('action=pm;sa=manrules');
Chris@76	3406 }
Chris@76	3407 // Deleting?
Chris@76	3408 elseif (isset($_POST['delselected']) && !empty($_POST['delrule']))
Chris@76	3409 {
Chris@76	3410 checkSession('post');
Chris@76	3411 $toDelete = array();
Chris@76	3412 foreach ($_POST['delrule'] as $k => $v)
Chris@76	3413 $toDelete[] = (int) $k;
Chris@76	3414
Chris@76	3415 if (!empty($toDelete))
Chris@76	3416 $smcFunc['db_query']('', '
Chris@76	3417 DELETE FROM {db_prefix}pm_rules
Chris@76	3418 WHERE id_rule IN ({array_int:delete_list})
Chris@76	3419 AND id_member = {int:current_member}',
Chris@76	3420 array(
Chris@76	3421 'current_member' => $user_info['id'],
Chris@76	3422 'delete_list' => $toDelete,
Chris@76	3423 )
Chris@76	3424 );
Chris@76	3425
Chris@76	3426 redirectexit('action=pm;sa=manrules');
Chris@76	3427 }
Chris@76	3428 }
Chris@76	3429
Chris@76	3430 // This will apply rules to all unread messages. If all_messages is set will, clearly, do it to all!
Chris@76	3431 function ApplyRules($all_messages = false)
Chris@76	3432 {
Chris@76	3433 global $user_info, $smcFunc, $context, $options;
Chris@76	3434
Chris@76	3435 // Want this - duh!
Chris@76	3436 loadRules();
Chris@76	3437
Chris@76	3438 // No rules?
Chris@76	3439 if (empty($context['rules']))
Chris@76	3440 return;
Chris@76	3441
Chris@76	3442 // Just unread ones?
Chris@76	3443 $ruleQuery = $all_messages ? '' : ' AND pmr.is_new = 1';
Chris@76	3444
Chris@76	3445 //!!! Apply all should have timeout protection!
Chris@76	3446 // Get all the messages that match this.
Chris@76	3447 $request = $smcFunc['db_query']('', '
Chris@76	3448 SELECT
Chris@76	3449 pmr.id_pm, pm.id_member_from, pm.subject, pm.body, mem.id_group, pmr.labels
Chris@76	3450 FROM {db_prefix}pm_recipients AS pmr
Chris@76	3451 INNER JOIN {db_prefix}personal_messages AS pm ON (pm.id_pm = pmr.id_pm)
Chris@76	3452 LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = pm.id_member_from)
Chris@76	3453 WHERE pmr.id_member = {int:current_member}
Chris@76	3454 AND pmr.deleted = {int:not_deleted}
Chris@76	3455 ' . $ruleQuery,
Chris@76	3456 array(
Chris@76	3457 'current_member' => $user_info['id'],
Chris@76	3458 'not_deleted' => 0,
Chris@76	3459 )
Chris@76	3460 );
Chris@76	3461 $actions = array();
Chris@76	3462 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	3463 {
Chris@76	3464 foreach ($context['rules'] as $rule)
Chris@76	3465 {
Chris@76	3466 $match = false;
Chris@76	3467 // Loop through all the criteria hoping to make a match.
Chris@76	3468 foreach ($rule['criteria'] as $criterium)
Chris@76	3469 {
Chris@76	3470 if (($criterium['t'] == 'mid' && $criterium['v'] == $row['id_member_from']) \|\| ($criterium['t'] == 'gid' && $criterium['v'] == $row['id_group']) \|\| ($criterium['t'] == 'sub' && strpos($row['subject'], $criterium['v']) !== false) \|\| ($criterium['t'] == 'msg' && strpos($row['body'], $criterium['v']) !== false))
Chris@76	3471 $match = true;
Chris@76	3472 // If we're adding and one criteria don't match then we stop!
Chris@76	3473 elseif ($rule['logic'] == 'and')
Chris@76	3474 {
Chris@76	3475 $match = false;
Chris@76	3476 break;
Chris@76	3477 }
Chris@76	3478 }
Chris@76	3479
Chris@76	3480 // If we have a match the rule must be true - act!
Chris@76	3481 if ($match)
Chris@76	3482 {
Chris@76	3483 if ($rule['delete'])
Chris@76	3484 $actions['deletes'][] = $row['id_pm'];
Chris@76	3485 else
Chris@76	3486 {
Chris@76	3487 foreach ($rule['actions'] as $ruleAction)
Chris@76	3488 {
Chris@76	3489 if ($ruleAction['t'] == 'lab')
Chris@76	3490 {
Chris@76	3491 // Get a basic pot started!
Chris@76	3492 if (!isset($actions['labels'][$row['id_pm']]))
Chris@76	3493 $actions['labels'][$row['id_pm']] = empty($row['labels']) ? array() : explode(',', $row['labels']);
Chris@76	3494 $actions['labels'][$row['id_pm']][] = $ruleAction['v'];
Chris@76	3495 }
Chris@76	3496 }
Chris@76	3497 }
Chris@76	3498 }
Chris@76	3499 }
Chris@76	3500 }
Chris@76	3501 $smcFunc['db_free_result']($request);
Chris@76	3502
Chris@76	3503 // Deletes are easy!
Chris@76	3504 if (!empty($actions['deletes']))
Chris@76	3505 deleteMessages($actions['deletes']);
Chris@76	3506
Chris@76	3507 // Relabel?
Chris@76	3508 if (!empty($actions['labels']))
Chris@76	3509 {
Chris@76	3510 foreach ($actions['labels'] as $pm => $labels)
Chris@76	3511 {
Chris@76	3512 // Quickly check each label is valid!
Chris@76	3513 $realLabels = array();
Chris@76	3514 foreach ($context['labels'] as $label)
Chris@76	3515 if (in_array($label['id'], $labels) && ($label['id'] != -1 \|\| empty($options['pm_remove_inbox_label'])))
Chris@76	3516 $realLabels[] = $label['id'];
Chris@76	3517
Chris@76	3518 $smcFunc['db_query']('', '
Chris@76	3519 UPDATE {db_prefix}pm_recipients
Chris@76	3520 SET labels = {string:new_labels}
Chris@76	3521 WHERE id_pm = {int:id_pm}
Chris@76	3522 AND id_member = {int:current_member}',
Chris@76	3523 array(
Chris@76	3524 'current_member' => $user_info['id'],
Chris@76	3525 'id_pm' => $pm,
Chris@76	3526 'new_labels' => empty($realLabels) ? '' : implode(',', $realLabels),
Chris@76	3527 )
Chris@76	3528 );
Chris@76	3529 }
Chris@76	3530 }
Chris@76	3531 }
Chris@76	3532
Chris@76	3533 // Load up all the rules for the current user.
Chris@76	3534 function LoadRules($reload = false)
Chris@76	3535 {
Chris@76	3536 global $user_info, $context, $smcFunc;
Chris@76	3537
Chris@76	3538 if (isset($context['rules']) && !$reload)
Chris@76	3539 return;
Chris@76	3540
Chris@76	3541 $request = $smcFunc['db_query']('', '
Chris@76	3542 SELECT
Chris@76	3543 id_rule, rule_name, criteria, actions, delete_pm, is_or
Chris@76	3544 FROM {db_prefix}pm_rules
Chris@76	3545 WHERE id_member = {int:current_member}',
Chris@76	3546 array(
Chris@76	3547 'current_member' => $user_info['id'],
Chris@76	3548 )
Chris@76	3549 );
Chris@76	3550 $context['rules'] = array();
Chris@76	3551 // Simply fill in the data!
Chris@76	3552 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76	3553 {
Chris@76	3554 $context['rules'][$row['id_rule']] = array(
Chris@76	3555 'id' => $row['id_rule'],
Chris@76	3556 'name' => $row['rule_name'],
Chris@76	3557 'criteria' => unserialize($row['criteria']),
Chris@76	3558 'actions' => unserialize($row['actions']),
Chris@76	3559 'delete' => $row['delete_pm'],
Chris@76	3560 'logic' => $row['is_or'] ? 'or' : 'and',
Chris@76	3561 );
Chris@76	3562
Chris@76	3563 if ($row['delete_pm'])
Chris@76	3564 $context['rules'][$row['id_rule']]['actions'][] = array('t' => 'del', 'v' => 1);
Chris@76	3565 }
Chris@76	3566 $smcFunc['db_free_result']($request);
Chris@76	3567 }
Chris@76	3568
Chris@76	3569 // Check if the PM is available to the current user.
Chris@76	3570 function isAccessiblePM($pmID, $validFor = 'in_or_outbox')
Chris@76	3571 {
Chris@76	3572 global $user_info, $smcFunc;
Chris@76	3573
Chris@76	3574 $request = $smcFunc['db_query']('', '
Chris@76	3575 SELECT
Chris@76	3576 pm.id_member_from = {int:id_current_member} AND pm.deleted_by_sender = {int:not_deleted} AS valid_for_outbox,
Chris@76	3577 pmr.id_pm IS NOT NULL AS valid_for_inbox
Chris@76	3578 FROM {db_prefix}personal_messages AS pm
Chris@76	3579 LEFT JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm AND pmr.id_member = {int:id_current_member} AND pmr.deleted = {int:not_deleted})
Chris@76	3580 WHERE pm.id_pm = {int:id_pm}
Chris@76	3581 AND ((pm.id_member_from = {int:id_current_member} AND pm.deleted_by_sender = {int:not_deleted}) OR pmr.id_pm IS NOT NULL)',
Chris@76	3582 array(
Chris@76	3583 'id_pm' => $pmID,
Chris@76	3584 'id_current_member' => $user_info['id'],
Chris@76	3585 'not_deleted' => 0,
Chris@76	3586 )
Chris@76	3587 );
Chris@76	3588
Chris@76	3589 if ($smcFunc['db_num_rows']($request) === 0)
Chris@76	3590 {
Chris@76	3591 $smcFunc['db_free_result']($request);
Chris@76	3592 return false;
Chris@76	3593 }
Chris@76	3594
Chris@76	3595 $validationResult = $smcFunc['db_fetch_assoc']($request);
Chris@76	3596 $smcFunc['db_free_result']($request);
Chris@76	3597
Chris@76	3598 switch ($validFor)
Chris@76	3599 {
Chris@76	3600 case 'inbox':
Chris@76	3601 return !empty($validationResult['valid_for_inbox']);
Chris@76	3602 break;
Chris@76	3603
Chris@76	3604 case 'outbox':
Chris@76	3605 return !empty($validationResult['valid_for_outbox']);
Chris@76	3606 break;
Chris@76	3607
Chris@76	3608 case 'in_or_outbox':
Chris@76	3609 return !empty($validationResult['valid_for_inbox']) \|\| !empty($validationResult['valid_for_outbox']);
Chris@76	3610 break;
Chris@76	3611
Chris@76	3612 default:
Chris@76	3613 trigger_error('Undefined validation type given', E_USER_ERROR);
Chris@76	3614 break;
Chris@76	3615 }
Chris@76	3616 }
Chris@76	3617
Chris@76	3618 ?>

Mercurial > hg > vamp-website

annotate forum/Sources/PersonalMessage.php @ 76:e3e11437ecea website