Extension:BuddyPressActivity

$content = preg_replace('|(edited the wiki page.+?</a>)(.+?ago)|', '$1<span class="time-since">$2</span>', $content);

require_once("$IP/extensions/buddypress-activity/buddypress-activity.php");

 <?php
/*
 * buddypress-activity -- In environments where MediaWiki user authentication has been merged with WPMu/BuddyPress signin, this extension adds wiki edits to the BuddyPress activity feeds.
 *
 *  This program is free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 2 of the License, or
 *  (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program; if not, write to the Free Software
 *  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 *
 * @author Boone Gorges <boonebgorges@gmail.com>
 * @addtogroup Extensions
 */
 
 
if( !defined( 'MEDIAWIKI' ) ) {
	echo( "This file is an extension to the MediaWiki software and cannot be used standalone.\n" );
	die( 1 );
}
 
 
 
 
 
$wgHooks['ArticleSaveComplete'][] = 'writeToBPActivity';
 
function writeToBPActivity($article, &$user, $text, $summary) {
 
 
$wpmudp = 'yourwpmudatabasename'; // Replace this with the name of your WPMu database
 
$docRoot = 'http://' . $_SERVER['HTTP_HOST'];
 
 
$time1 = time();
$time2 = time();
 
 
$page = $article->getTitle();
$rawtitle = $page->getPrefixedText();
$articleURL  = $page->getFullUrl();
 
 
 
$titleUS = str_replace(" ", "_", $rawtitle);
$titleUS = str_replace("&", "%26", $titleUS); 
 
$articleURL = $docRoot . '/wiki/index.php/' . $titleUS;
 
$userNameMW = strtolower($user->mName); // This block uses the MW login name to find the correct BP user ID for the DB entry
mysql_select_db($wpmudp) or die(mysql_error());
$result = mysql_query( "SELECT * FROM `wp_users` WHERE `user_nicename`='$userNameMW' LIMIT 0, 1" );
$resultarray = mysql_fetch_array($result);
$user_id = $resultarray['ID'];
 
$profileURL = $docRoot . '/members/' . $userNameMW;
 
mysql_select_db($wpmudp) or die(mysql_error()); // Gets the user's full name from the BP fields
$bpquery = mysql_query( "SELECT * FROM `wp_bp_xprofile_data` WHERE `user_id`='$user_id' AND `field_id`='1' LIMIT 0, 1" );
$bpresultarray = mysql_fetch_array($bpquery);
$bpname = $bpresultarray['value'];
 
$contentdesc = '<a href="' . $profileURL . '">' . $bpname . '</a> edited the wiki page <a href="' . $articleURL . '">' . $rawtitle . '</a>';
 
mysql_select_db($wpmudp) or die(mysql_error()); // checks to see if the same page has been edited by the same person in the last 24 hrs
$checkrecent = mysql_query( "SELECT * FROM `wp_bp_activity_sitewide` WHERE `content`='$contentdesc' ORDER BY `id` DESC LIMIT 0, 1" );
$checkRecentArray = mysql_fetch_array($checkrecent);
$checkRecentDate = $checkRecentArray['date_recorded'];
$checkRecentDateUNIX = strtotime($checkRecentDate);
$seconds_between = $time1 - $checkRecentDateUNIX;
 
if ($seconds_between > 86400) {
	mysql_select_db($wpmudp) or die(mysql_error());
	mysql_query( "INSERT INTO `wp_bp_activity_sitewide` (`user_id`,`content`, `date_cached`, `date_recorded`, `component_name`, `component_action`, `primary_link`, `secondary_item_id`) VALUES ( '$user_id', '$contentdesc', FROM_UNIXTIME('$time1'), FROM_UNIXTIME('$time2'), 'blogs', 'new_blog_post', '$articleURL', '0' )") or die(mysql_error()); // insert into sitewide feed
	mysql_query( "INSERT INTO `wp_bp_activity_user_activity` (`item_id`, `secondary_item_id`, `user_id`, `component_name`, `component_action`, `date_recorded`, `is_private`, `no_sitewide_cache`) VALUES ( '46', '0', '$user_id', 'blogs', 'new_blog_post', FROM_UNIXTIME('$time1'), '0', '0' )") or die(mysql_error()); // insert into user_activity
	mysql_query( "INSERT INTO `wp_bp_activity_user_activity_cached` (`user_id`,`content`, `date_cached`, `date_recorded`, `component_name`, `component_action`, `primary_link`, `secondary_item_id`, `is_private`) VALUES ( '$user_id', '$contentdesc', FROM_UNIXTIME('$time1'), FROM_UNIXTIME('$time2'), 'blogs', 'new_blog_post', '$articleURL', '0', '0' )") or die(mysql_error()); // insert into user activity cache	
}	
 
 
return true;
}
 
$wgExtensionCredits['other'][] = array(
        'path' => __FILE__,
	'name' => 'BuddyPressActivity',
	'version' => 0.1,
	'author' => 'Boone Gorges',
	'url' => 'http://www.mediawiki.org/wiki/Extension:BuddyPressActivity',
	'description' => 'Adds MW page edits to BuddyPress activity streams.',
	'descriptionmsg' => 'foobar-desc',
);