get_row('SELECT * FROM ' . $wpdb->prefix . 'pm WHERE `id` = "' . $id . '" LIMIT 1'); $msg->recipient = $wpdb->get_var("SELECT display_name FROM $wpdb->users WHERE user_login = '$msg->recipient'"); ?>

Recipient: %s
Date: %s', 'pm4wp'), $msg->recipient, $msg->date); ?>		 Subject: %s

%s

', 'pm4wp'), stripcslashes($msg->subject), nl2br(stripcslashes($msg->content))); ?>		 id", 'rwpm-delete_outbox_msg_' . $msg->id); ?>">
get_var('SELECT `deleted` FROM ' . $wpdb->prefix . 'pm WHERE `id` = "' . $msg_id . '" LIMIT 1'); // create corresponding query for deleting message if ($recipient_deleted == 2) { $query = 'DELETE from ' . $wpdb->prefix . 'pm WHERE `id` = "' . $msg_id . '"'; } else { $query = 'UPDATE ' . $wpdb->prefix . 'pm SET `deleted` = "1" WHERE `id` = "' . $msg_id . '"'; } if (!$wpdb->query($query)) { $error = true; } } if ($error) { $status = __('Error. Please try again.', 'pm4wp'); } else { $status = _n('Message deleted.', 'Messages deleted.', count($id), 'pm4wp'); } } // show all messages $msgs = $wpdb->get_results('SELECT `id`, `recipient`, `subject`, `date` FROM ' . $wpdb->prefix . 'pm WHERE `sender` = "' . $current_user->user_login . '" AND `deleted` != 1 ORDER BY `date` DESC'); ?>

', $status, '

'; } if (empty($msgs)) { echo '

', __('You have no items in outbox.', 'pm4wp'), '

'; } else { $n = count($msgs); echo '

', sprintf(_n('You wrote %d private message.', 'You wrote %d private messages.', $n, 'pm4wp'), $n), '

'; ?>
recipient = $wpdb->get_var("SELECT display_name FROM $wpdb->users WHERE user_login = '$msg->recipient'"); ?>
recipient; ?> id", 'rwpm-view_outbox_msg_' . $msg->id), '">', stripcslashes($msg->subject), ''; ?>
id", 'rwpm-view_outbox_msg_' . $msg->id); ?>"> | id", 'rwpm-delete_outbox_msg_' . $msg->id); ?>">
date; ?>