prefix . 'pm (
`id` bigint(20) NOT NULL auto_increment,
`subject` text NOT NULL,
`content` text NOT NULL,
`sender` varchar(60) NOT NULL,
`recipient` varchar(60) NOT NULL,
`date` datetime NOT NULL,
`read` tinyint(1) NOT NULL,
`deleted` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) COLLATE utf8_general_ci;';
// Note: deleted = 1 if message is deleted by sender, = 2 if it is deleted by recipient
$wpdb->query( $query );
// Default numbers of PM for each group
$default_option = array(
'administrator' => 0,
'editor' => 50,
'author' => 20,
'contributor' => 10,
'subscriber' => 5,
'type' => 'dropdown', // How to choose recipient: dropdown list or autocomplete based on user input
'email_enable' => 1,
'email_name' => '%BLOG_NAME%',
'email_address' => '%BLOG_ADDRESS%',
'email_subject' => __( 'New PM at %BLOG_NAME%', 'pm4wp' ),
'email_body' => __( "You have new private message from %SENDER% at %BLOG_NAME%.\n\nClick here to go to your inbox.\n\nThis email is sent automatically. Please don't reply.", 'pm4wp' )
);
add_option( 'rwpm_option', $default_option, '', 'no' );
}
/**
* Show notification of new PM
*/
function rwpm_notify()
{
global $wpdb, $current_user;
// get number of unread messages
$num_unread = (int) $wpdb->get_var( 'SELECT COUNT(*) FROM ' . $wpdb->prefix . 'pm WHERE `recipient` = "' . $current_user->user_login . '" AND `read` = 0 AND `deleted` != "2"' );
if ( !$num_unread )
return;
printf(
'',
sprintf( _n( 'You have %d new message!', 'You have %d new messages!', $num_unread, 'pm4wp' ), $num_unread ),
admin_url( 'admin.php?page=rwpm_inbox' ),
__( 'Click here to go to inbox', 'pm4wp' )
);
}
/**
* Show number of unread messages in admin bar
*/
function rwpm_adminbar()
{
global $wp_admin_bar;
global $wpdb, $current_user;
// get number of unread messages
$num_unread = (int) $wpdb->get_var( 'SELECT COUNT(*) FROM ' . $wpdb->prefix . 'pm WHERE `recipient` = "' . $current_user->user_login . '" AND `read` = 0 AND `deleted` != "2"' );
if ( $num_unread && is_admin_bar_showing() )
{
$wp_admin_bar->add_menu( array(
'id' => 'rwpm',
'title' => sprintf( _n( 'You have %d new message!', 'You have %d new messages!', $num_unread, 'pm4wp' ), $num_unread ),
'href' => admin_url( 'admin.php?page=rwpm_inbox' ),
'meta' => array( 'class' => "rwpm_newmessages" ),
) );
}
}
/**
* Ajax callback function to get list of users
*/
function rwpm_get_users()
{
$keyword = trim( strip_tags( $_POST['term'] ) );
$values = array();
$args = array( 'search' => '*' . $keyword . '*',
'fields' => 'all_with_meta' );
$results_search_users = get_users( $args );
$results_search_users = apply_filters( 'rwpm_recipients', $results_search_users );
if ( !empty( $results_search_users ) )
{
foreach ( $results_search_users as $result )
{
$values[] = $result->display_name;
}
}
die( json_encode( $values ) );
}