get_var("SELECT MAX(act_date) FROM ".$wpdb->prefix."activity"))); $users = $wpdb->get_results("SELECT ID, display_name, user_nicename FROM $wpdb->users"); $wp_url = get_bloginfo('wpurl'); foreach ($users as $user) { $users_nicename[$user->ID]=$user->user_nicename; $users_display[$user->ID]=$user->display_name; } $sql="SELECT * FROM ".$wpdb->prefix."activity ORDER BY id DESC"; if ( $items = $wpdb->get_results($sql)){ $cache = ''; $cache .= ''; $cache .= ''; $cache .= ''.attribute_escape(strip_tags(html_entity_decode(sprintf(__('%s activity RSS Feed', 'wp-activity'), get_bloginfo('name'))))).''; $cache .= ''.$wp_url.''; //$cache .= ' $cache .= ''; $cache .= ''.$date.''; $cache .= ''.get_bloginfo('language').''; foreach ( (array) $items as $item ){ $flag= false; $item_date = date('r', strtotime($item->act_date)); $user_nicename = $users_nicename[$item->user_id]; switch ($item->act_type){ case 'CONNECT': $flag = ($act_feed_connect) ? true : false ; $item_title = __('New visit', 'wp-activity'); $item_desc = ''.$users_display[$item->user_id].' '.__('has logged.', 'wp-activity'); break; case 'COMMENT_ADD': $flag = ($act_feed_comments) ? true : false ; $item_title = __('New comment', 'wp-activity'); $item_comment=get_comment($item->act_params); $item_post=get_post($item_comment->comment_post_ID); $item_desc = ''.$item_comment->comment_author.' '.__('commented', 'wp-activity').' '.$item_post->post_title.''; break; case 'POST_ADD': $flag = ($act_feed_posts) ? true : false ; $item_title = __('New post', 'wp-activity'); $item_post=get_post($item->act_params); $item_desc = ''.$users_display[$item_post->post_author].' '.__('published', 'wp-activity').' '.$item_post->post_title.''; break; case 'POST_EDIT': $flag = ($act_feed_posts) ? true : false ; $item_title = __('Post edited', 'wp-activity'); $item_post=get_post($item->act_params); $item_desc = ''.$users_display[$item_post->post_author].' '.__('edited', 'wp-activity').' '.$item_post->post_title.''; break; case 'PROFILE_EDIT': $flag = ($act_feed_profiles) ? true : false ; $item_title = __('Profile edited', 'wp-activity'); $item_desc = ''.$users_display[$item->user_id].' '.__('has updated his profile.', 'wp-activity'); break; case 'LINK_ADD': $flag = ($act_feed_links) ? true : false ; $item_title = __('New link', 'wp-activity'); $link = get_bookmark($item->act_params); if ($link->link_visible == 'Y'){ $item_desc = ''.$users_display[$item->user_id].' '.__('has added a link to', 'wp-activity').' '.$link->link_name.'.'; } break; } if ($flag){ $cache .=''; $cache .=''.$item_title.''; $cache .=''.$item_date.''; $cache .=''.attribute_escape(strip_tags(html_entity_decode($item_desc))).'

]]>'; $cache .=''.get_avatar($item->user_id,40).'

'.attribute_escape(strip_tags(html_entity_decode($item_desc))).'

]]>'; $cache .=''.$users_display[$item->user_id].''; $cache .=''.$wp_url.''; $cache .=''; } } $cache .=''; $cache .=''; } wp_cache_set( 'act_feed', $cache, '3600' ); return $cache; }else{ return $act_feed; } } if ($options['act_feed_display']) { echo act_feed(); }else{ echo "Error. Activity feed not allowed !"; } ?>