$user_rules = $db->sql_fetchrowset($result);

$db->sql_freeresult($result);

{

$sql = 'SELECT zebra_id, friend, foe

FROM ' . ZEBRA_TABLE . "

$db->sql_freeresult($result);

// Retrieve user memberships

{

$sql = 'SELECT *

FROM ' . USER_GROUP_TABLE . '

// only gone through if new messages arrive.

// Delete messages

{

delete_pm($user_id, $delete_ids, PRIVMSGS_NO_BOX);

}

// Set messages to Unread

{

$sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . '

SET pm_unread = 0

}

// mark messages as important

{

$sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . '

SET pm_marked = 1 - pm_marked

// Move into folder

$folder = array();

{

// Determine Full Folder Action - we need the move to folder id later eventually

$full_folder_action = ($user->data['user_full_folder'] == FULL_FOLDER_NONE) ? ($config['full_folder_action'] - (FULL_FOLDER_NONE*(-1))) : $user->data['user_full_folder'];

// Check Message Limit - we calculate with the complete array, most of the time it is one message

// But we are making sure that the other way around works too (more messages in queue than allowed to be stored)

{

$full_folder_action = ($user->data['user_full_folder'] == FULL_FOLDER_NONE) ? ($config['full_folder_action'] - (FULL_FOLDER_NONE*(-1))) : $user->data['user_full_folder'];

// If destination folder itself is full...

{

$full_folder_action = $config['full_folder_action'] - (FULL_FOLDER_NONE*(-1));

}

WHERE user_id = $user_id

AND folder_id = $dest_folder

ORDER BY msg_id ASC";

$delete_ids = array();

while ($row = $db->sql_fetchrow($result))

}

$db->sql_freeresult($result);

delete_pm($user_id, $delete_ids, $dest_folder);

}

}

}

}

{

// Move from OUTBOX to SENTBOX

// We are not checking any full folder status here... SENTBOX is a special treatment (old messages get deleted)

$move_msg_ids = array($move_msg_ids);

}

!in_array($cur_folder_id, array(PRIVMSGS_NO_BOX, PRIVMSGS_OUTBOX)) && $cur_folder_id != $dest_folder)

{

// We have to check the destination folder ;)

trigger_error('NOT_AUTHORISED');

}

{

$message = sprintf($user->lang['NOT_ENOUGH_SPACE_FOLDER'], $row['folder_name']) . '<br /><br />';

$message .= sprintf($user->lang['CLICK_RETURN_FOLDER'], '<a href="' . append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;folder=' . $row['folder_id']) . '">', '</a>', $row['folder_name']);

$num_messages = (int) $db->sql_fetchfield('num_messages');

$db->sql_freeresult($result);

{

$message = sprintf($user->lang['NOT_ENOUGH_SPACE_FOLDER'], $user->lang['PM_INBOX']) . '<br /><br />';

$message .= sprintf($user->lang['CLICK_RETURN_FOLDER'], '<a href="' . append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;folder=inbox') . '">', '</a>', $user->lang['PM_INBOX']);

$msg_ids = $request->variable('marked_msg_id', array(0));

$cur_folder_id = $request->variable('cur_folder_id', PRIVMSGS_NO_BOX);

{

return false;

}

{

delete_pm($user_id, $msg_ids, $cur_folder_id);

$redirect = append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;folder=' . $cur_folder_id);

meta_refresh(3, $redirect);

$msg_ids = array($msg_ids);

}

{

return false;

}

$db->sql_freeresult($result);

unset($msg_ids);

{

return false;

}

$delete_ids = array_keys($delete_rows);

{

// Check if there are any attachments we need to remove

/** @var \phpbb\attachment\manager $attachment_manager */

$num_pms = (int) $row['num_undelivered_privmsgs'];

$undelivered_user[$num_pms][] = (int) $row['user_id'];

{

// If there are too many users affected the query might get

// too long, so we update the value for the first bunch here.

$_types = array('u', 'g');

foreach ($_types as $type)

{

{

foreach (${$type} as $id)

{

}

$address = array();

{

$sql = 'SELECT user_id, username, user_colour

FROM ' . USERS_TABLE . '

$db->sql_freeresult($result);

}

{

if ($plaintext)

{

}

}

{

$template->assign_var('S_' . strtoupper($check_type) . '_RECIPIENT', true);

$_types = array('u', 'g');

foreach ($_types as $ug_type)

{

{

foreach ($data_ary['address_list'][$ug_type] as $id => $field)

{

}

}

{

// We need to check the PM status of group members (do they want to receive PM's?)

// Only check if not a moderator or admin, since they are allowed to override this user setting

$db->sql_freeresult($result);

}

{

trigger_error('NO_RECIPIENT');

}

break;

}

{

if ($mode == 'post' || $mode == 'reply' || $mode == 'quote' || $mode == 'quotepost' || $mode == 'forward')

{

$orphan_rows[(int) $attach_row['attach_id']] = array();

}

{

$sql = 'SELECT attach_id, filesize, physical_filename

FROM ' . ATTACHMENTS_TABLE . '

while ($row = $db->sql_fetchrow($result));

$db->sql_freeresult($result);

{

return false;

}

// Re-order rowset to be able to get the next/prev message rows...

$rowset = array_values($rowset);

{

$row = &$rowset[$i];

$id = (int) $row['msg_id'];

foreach ($_types as $ug_type)

{

{

foreach ($address[$message_id][$ug_type] as $ug_id => $in_to)

{