__( 'Show notifications and new private messages on sidebar', 'pm4wp' ) );
$control_options = array();
parent::WP_Widget( 'pm4wp-widget', __( 'Private Messages Widget', 'pm4wp' ), $widget_options, $control_options );
}
/**
* Display widget
*/
function widget( $args, $instance )
{
global $wpdb, $current_user;
if ( !is_user_logged_in() )
{
return;
}
extract( $args );
$title = apply_filters( 'widget_title', $instance['title'] );
echo $before_widget;
if ( $title )
{
echo $before_title . $title . $after_title;
}
// get number of PM
$num_pm = $wpdb->get_var( 'SELECT COUNT(*) FROM ' . $wpdb->prefix . 'pm WHERE `recipient` = "' . $current_user->user_login . '" AND `deleted` != "2"' );
$num_unread = $wpdb->get_var( 'SELECT COUNT(*) FROM ' . $wpdb->prefix . 'pm WHERE `recipient` = "' . $current_user->user_login . '" AND `read` = 0 AND `deleted` != "2"' );
if ( empty( $num_pm ) )
{
$num_pm = 0;
}
if ( empty( $num_unread ) )
{
$num_unread = 0;
}
echo '', sprintf( __ngettext( 'You have %d private message. %d unread.', 'You have %d private messages. %d unread.', $num_pm, 'pm4wp' ), $num_pm, $num_unread ), '
';
if ( $instance['num_pm'] )
{
$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 LIMIT ' . $instance['num_pm'] );
if ( count( $msgs ) )
{
echo '';
foreach ( $msgs as $msg )
{
$msg->sender = $wpdb->get_var( "SELECT display_name FROM $wpdb->users WHERE user_login = '$msg->sender'" );
echo '- ';
if ( !$msg->read )
{
echo '';
}
echo $msg->subject;
if ( !$msg->read )
{
echo '';
}
printf( __( '
by %s
at %s', 'pm4wp' ), $msg->sender, $msg->date );
echo ' ';
}
echo '
';
}
}
echo '', __( 'Click here to go to inbox', 'pm4wp' ), ' »
';
echo $after_widget;
}
/**
* Update widget
*/
function update( $new_instance, $old_instance )
{
$instance = $old_instance;
/* Strip tags (if needed) and update the widget settings. */
$instance['title'] = strip_tags( $new_instance['title'] );
$instance['num_pm'] = intval( $new_instance['num_pm'] );
return $instance;
}
function form( $instance )
{
/* Set up some default widget settings. */
$defaults = array( 'title' => __( 'Private Messages', 'pm4wp' ), 'num_pm' => 5 );
$instance = wp_parse_args( (array) $instance, $defaults );
?>