update( $wpdb->prefix . 'pm', array( 'read' => 1 ), array( 'id' => $id ) );
// select message information
$msg = $wpdb->get_row( 'SELECT * FROM ' . $wpdb->prefix . 'pm WHERE `id` = "' . $id . '" LIMIT 1' );
$msg->sender = $wpdb->get_var( "SELECT display_name FROM $wpdb->users WHERE user_login = '$msg->sender'" );
?>
query( 'UPDATE ' . $wpdb->prefix . 'pm SET `read` = "1" WHERE `id` IN (' . $id . ')' ) )
{
$status = _n( 'Message marked as read.', 'Messages marked as read', $n, 'pm4wp' );
}
else
{
$status = __( 'Error. Please try again.', 'pm4wp' );
}
}
// if delete message
if ( isset( $_GET['action'] ) && 'delete' == $_GET['action'] && !empty( $_GET['id'] ) )
{
$id = $_GET['id'];
if ( !is_array( $id ) )
{
check_admin_referer( "rwpm-delete_inbox_msg_$id" );
$id = array( $id );
}
else
{
check_admin_referer( "rwpm-bulk-action_inbox" );
}
$error = false;
foreach ( $id as $msg_id )
{
// check if the sender has deleted this message
$sender_deleted = $wpdb->get_var( 'SELECT `deleted` FROM ' . $wpdb->prefix . 'pm WHERE `id` = "' . $msg_id . '" LIMIT 1' );
// create corresponding query for deleting message
if ( $sender_deleted == 1 )
{
$query = 'DELETE from ' . $wpdb->prefix . 'pm WHERE `id` = "' . $msg_id . '"';
}
else
{
$query = 'UPDATE ' . $wpdb->prefix . 'pm SET `deleted` = "2" 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 which have not been deleted by this user (deleted status != 2)
$msgs = $wpdb->get_results( 'SELECT `id`, `sender`, `subject`, `read`, `date` FROM ' . $wpdb->prefix . 'pm WHERE `recipient` = "' . $current_user->user_login . '" AND `deleted` != "2" ORDER BY `date` DESC' );
?>
';
}
if ( empty( $msgs ) )
{
echo '', __( 'You have no items in inbox.', 'pm4wp' ), '
';
}
else
{
$n = count( $msgs );
$num_unread = 0;
foreach ( $msgs as $msg )
{
if ( !( $msg->read ) )
{
$num_unread++;
}
}
echo '', sprintf( _n( 'You have %d private message (%d unread).', 'You have %d private messages (%d unread).', $n, 'pm4wp' ), $n, $num_unread ), '
';
?>