Re: MediaWiki edits -> BP activity streams
The last line of Boone’s script is the insert statement. You have collabbo_figures.wp_bp_activity as the database table. Have you tried to strip out that first part and just use wp_bp_activity ?
‘if ($seconds_between > 86400) {
mysql_select_db($wpmudp, $link) or die(mysql_error());
mysql_query( “INSERT INTO `wp_bp_activity` (`user_id`,`component`, `type`, `action`, `content`, `primary_link`, `item_id`, `secondary_item_id`, `date_recorded`, `hide_sitewide`, `mptt_left`, `mptt_right`) VALUES ( ‘$user_id’, ‘blogs’, ‘new_blog_post’, ‘$contentdesc’, ‘$WikiEdit $pagedesc’, ‘$articleURL’, ‘1’, ”, FROM_UNIXTIME($time1), ‘0’, ‘0’, ‘0’ )”) or die(mysql_error()); // insert into bp activity stream
}’