function pmpros_check_for_new_content()
{
global $wpdb;
//get all members
$users = $wpdb->get_results("\r\n SELECT *\r\n FROM {$wpdb->pmpro_memberships_users}\r\n WHERE status = 'active'\r\n\t");
//get all series
$series = $wpdb->get_results("\r\n SELECT *\r\n FROM {$wpdb->posts}\r\n WHERE post_type = 'pmpro_series'\r\n ");
//store emails to send
$emails = array();
//search through series looking for emails to send
foreach ($series as $s) {
$series = new PMProSeries($s->ID);
$series_posts = $series->getPosts();
if (empty($series_posts)) {
continue;
}
foreach ($series_posts as $series_post) {
foreach ($users as $user) {
$notified = get_user_meta($user->user_id, 'pmpros_notified', true);
if (empty($notified)) {
$notified = array();
}
if (pmpros_hasAccess($user->user_id, $series_post->id) && !in_array($series_post->id, $notified)) {
//add email to array to send
if (empty($emails[$user->user_id])) {
$emails[$user->user_id] = array();
}
$emails[$user->user_id][] = $series_post->id;
//$series->sendEmail($series_post->id, $user->user_id);
}
}
}
}
//send emails
foreach ($emails as $user_id => $posts) {
//send email
$series->sendEmail($posts, $user_id);
//remember that we emailed about these posts
$notified = get_user_meta($user_id, "pmpros_notified", true);
if (!is_array($notified)) {
$notified = array();
}
$notified = array_unique(array_merge($posts, $notified));
update_user_meta($user_id, "pmpros_notified", $notified);
}
}
static function seriesMetaBox()
{
global $post;
$series = new PMProSeries($post->ID);
?>
<div id="pmpros_series_posts">
<?php
$series->getPostListForMetaBox();
?>
</div>
<?php
}
function pmpros_member_links_bottom()
{
global $wpdb, $current_user;
//get all series
$all_series = $wpdb->get_results("\n SELECT *\n FROM {$wpdb->posts}\n WHERE post_type = 'pmpro_series'\n ");
if (empty($all_series)) {
return;
}
foreach ($all_series as $s) {
$series = new PMProSeries($s->ID);
$series_posts = $series->getPosts();
if (!empty($series_posts)) {
foreach ($series_posts as $series_post) {
if (pmpros_hasAccess($current_user->user_id, $series_post->id)) {
?>
<li><a href="<?php
echo get_permalink($series_post->id);
?>
" title="<?php
echo get_the_title($series_post->id);
?>
"><?php
echo get_the_title($series_post->id);
?>
</a></li>
<?php
}
}
}
}
}
