BuddyPress.org

Thanks Paul, I made it :), it’s something really rough, but if somebody needs it here it is:

<?php

// parametri del database
$db_host = "localhost";         //Your database host
$db_user = "database";          //Your database username
$db_password = "password";      //Your database password
$db_name = "database_01";       //Your database name

$db = mysql_connect($db_host, $db_user, $db_password);
set_time_limit(0);

if ($db == FALSE)
die ("Connection Error.");

mysql_select_db($db_name, $db)
or die ("Database Error.");

$n = 0;
$query = "SELECT * FROM <code>wp_posts</code> WHERE post_type = 'topic' OR post_type = 'reply' ORDER BY post_date ASC";

$result = mysql_query($query, $db);

while ($row = mysql_fetch_array($result))

	{
		unset($user_id);
		unset($reg);
		unset($guid);
		unset($id);
		unset($post_parent);
		unset($post_date);
		unset($nicename);
		unset($displayname);
		unset($title);
		unset($forum);
		unset($forumurl);
		unset($post_type);
		unset($forum_id);
		unset($acttype);
	
		$user_id = $row['post_author'];
		$guid = $row['guid'];
		$reg = $row['user_registered'];
		$id = $row['ID'];
		$post_parent = $row['post_parent'];
		$post_date = $row['post_date'];
		$title = $row['post_title'];
		$content = $row['post_content'];
		$post_type = $row['post_type'];
		$forum_id = $post_parent;
		
		$q1 = "SELECT * FROM <code>wp_users</code> WHERE ID = '$user_id'";
		$r1 = mysql_query($q1, $db);
		$e1 = mysql_fetch_array($r1);
		
		$nicename = $e1['user_nicename'];
		$displayname = $e1['display_name'];
		
		if ( $post_type == 'reply' ) {
			$q1 = "SELECT * FROM <code>wp_posts</code> WHERE ID = '$post_parent'";
			$r1 = mysql_query($q1, $db);
			$e1 = mysql_fetch_array($r1);
			
			$post_parent = $e1['post_parent'];
			$title = $e1['post_title'];
			$guid = $e1['guid'];
		}
		
		$q1 = "SELECT * FROM <code>wp_posts</code> WHERE ID = '$forum_id'";
		$r1 = mysql_query($q1, $db);
		$e1 = mysql_fetch_array($r1);
		
		$forum = $e1['post_title'];
		$forumurl = $e1['guid'];

		if ( $post_type == 'topic' ) {
			$action = mysql_real_escape_string('<a href="http://www.yoursite.com/users/' . $nicename . '/" rel="nofollow">' . $displayname . '</a> ha iniziato la discussione <a href="' . $guid . '">' . $title . '</a> nel forum <a href="' . $forumurl . '">' . $forum . '</a>');
			$acttype = 'bbp_topic_create';
		} else {
			$action = mysql_real_escape_string('<a href="http://www.yoursite.com/users/' . $nicename . '/" rel="nofollow">' . $displayname . '</a> ha risposto alla discussione <a href="' . $guid . '">' . $title . '</a> nel forum <a href="' . $forumurl . '">' . $forum . '</a>');
			$acttype = 'bbp_reply_create';
		}
		
		$content = mysql_real_escape_string( $content );

		if ( $user_id > 0 ) {
			$q1 = "SELECT COUNT(umeta_id) AS conto FROM <code>wp_usermeta</code> WHERE user_id = '$user_id' AND meta_key = 'last_activity'";
			$r1 = mysql_query($q1, $db);
			$e1 = mysql_fetch_array($r1);
			
			if ( $e1['conto'] > 0 ) {
				$q = "UPDATE wp_usermeta SET meta_value = '$post_date' WHERE user_id = '$user_id' AND meta_key = 'last_activity'";
				mysql_query($q, $db);
			} else {
				$q = "INSERT INTO <code>wp_usermeta</code> (<code>umeta_id</code>, <code>user_id</code>, <code>meta_key</code>, <code>meta_value</code> ) VALUES ( NULL, '$user_id', 'last_activity', '$post_date' );";
				mysql_query($q, $db);
			}
		}
		
		$q = "INSERT INTO <code>wp_bp_activity</code> (<code>id</code>, <code>user_id</code>, <code>component</code>, <code>type</code>, <code>action</code>, <code>content</code>, <code>primary_link</code>, <code>item_id</code>, <code>secondary_item_id</code>, <code>date_recorded</code>, <code>hide_sitewide</code>, <code>mptt_left</code>, <code>mptt_right</code>, <code>is_spam</code> ) VALUES ";
		$q .= "(NULL, '$user_id', 'bbpress', '$acttype', '$action', '$content', '$guid', '$id', '$post_parent', '$post_date', '0', '0', '0', '0')";
		mysql_query($q, $db);

                $n++;
	}

mysql_close($db);

echo "Done! inserted $n activity entries";
?>

The action is in italian, you can modify as you want

Oh Your Right so sorry. Here is my link: http://tvbari.org So Sorry about that and Thank you for helping. Very Very Much!

I have it in the root. No Multisite. BP1.8.1 WP3.7 and the below:

URL: http://tvbari.heavenboundministry.com
WordPress Version: 3.7.1
Theme: BuddyPress Default v1.8.1
Multisite Enabled: False
PHP version: 5.3.27
MySQL version: 5.5.33
Current User Role: administrator
Active Plugins:
Akismet 2.5.9
by Automattic (url)
All in one Favicon 4.3
by Arne Franken (url)
Ban User By IP 1.06
by Danilo Andreini (url)
BAW Login/Logout menu 1.3.2
by Juliobox (url)
BAW Post Views Count 2.19.11
by Juliobox (url)
bbPress - Private Replies 1.0.9
by Pippin Williamson and Remi Corson (url)
bbPress - Report Content 1.0.1
by Josh Eaton (url)
bbpress Simple View Counts 0.1
by jezza101 (url)
bbPress 2.4.1
by The bbPress Community (url)
Better WP Security 3.5.6
by Bit51 (url)
Block Bad Queries (BBQ) 20130707
by Jeff Starr (url)
BNS Support 1.6
by Edward Caissie (url)
BuddyPress Group TinyChat Pro 1.2.1
by Van dat (url)
BP My Home 2.0
by imath (url)
(BuddyDev)BP Poke 1.0.1
by Anu Sharma (url)
BP | You Are Blocked! 1.0Beta5
by Gabriel S Merovingi (url)
Buddydrive 1.1.1
by imath (url)
BuddyPress Docs 1.5.3
by Boone B Gorges (url)
BuddyPress Extended Friendship Request 1.0.2
by Brajesh Singh
BuddyPress Groups Extras Pro - Search 1.2
by slaFFik (url)
BuddyPress Groups Extras 3.6.5
by slaFFik (url)
rtMedia for WordPress, BuddyPress and bbPress 3.2.6
by rtCamp (url)
BuddyPress MyMood 1.7
by Ayush (url)
BuddyPress 1.8.1
by The BuddyPress Community (url)
CalculatorPro Calculators 1.1.4
by jgadbois (url)
Confirm User Registration 2.1.1
by Ralf Hortt (url)
Events Manager 5.5.2
by Marcus Sykes (url)
EWWW Image Optimizer 1.7.1
by Shane Bishop (url)
Jetpack by WordPress.com 2.5
by Automattic (url)
Kitchenbug 0.6.0
by Liquee Technologies Ltd. (url)
Moods Addon for Ultimate TinyMCE 1.2
by Josh Lobe (url)
Quick Flag 2.11
by Marko Martinović (url)
Social Articles 1.4
by Broobe (url)
Stop Spammer Registrations Plugin 4.3
by Keith P. Graham (url)
TDLC Birthdays 0.4
by Tom Granger (url)
Ultimate TinyMCE PRO 9.1
by Josh Lobe & Marventus (url)
Visitor Maps and Who's Online 1.5.8.1
by Mike Challis (url)
WangGuard 1.5.10
by WangGuard (url)
WP Super Cache 1.4
by Donncha O Caoimh (url)
Yet Another Related Posts Plugin 4.0.8

I hate to break the bad news but spammers already know about it. The problem is no one here seems to care.

Others have also reported this:

http://wordpress.stackexchange.com/questions/113255/spammers-are-bypassing-buddypress-registration-form

https://buddypress.org/support/topic/critical-exploit-backdoor-spam-registrations-via-bbpress/

Hi @bphelp

Its looks like its the following plugin;

At the moment I want to moderate membership signup which the plugin provides to cut down on spam members. Would I be best speaking to the plugins forum?

@hnla; thanks.

@sooskriszta; i have checked all the spam folder of the emails used, no such mail as the activation email.

Thanks all
_ Samuel

Spam did not solve my problem, no.

Thanks! There it is 🙂

So there appears to be an issue with my user receiving emails from the site. I triple checked my profile email address with no luck. No messages to my spam folder or anything. Any idea’s what might cause all notifications for my admin user to be disabled?

No they don’t have to create 2 accounts. What I want is for the god awful registration page to go away and get bacl my normal wordpress login and registration page back. I have social sign ins and want to be able to use those and also a captcha for spam.

@mercime

Just out of interest, if I use the capabilities page to mark a user as a spammer, what does that actually do? Delete the user from the site? Banish them into a black hole? etc

Here is more information about our installation.

8. Do you have any plugins other than BuddyPress installed and activated? If so, which ones?

All In One SEO Pack
Version 2.0.3.1 | By Michael Torbert

Antispam Bee
Version 2.5.9 | By Sergej Müller

AntiVirus
Version 1.3.4 | By Sergej Müller

bbPress
Version 2.4 | By The bbPress Community

Better WordPress Minify
Version 1.2.2 | By Khang Minh

Broken Link Checker
Version 1.8.3 | By Janis Elsts

BuddyPress
Version 1.8.1 | By The BuddyPress Community

Contact Form 7
Version 3.5.2 | By Takayuki Miyoshi

Duplicate Post
Version 2.4.1 | By Enrico Battocchi

Google Analyticator
Version 6.4.5 | By Video User Manuals Pty Ltd

NGFB Open Graph+ Pro
Version 6.8 | By Jean-Sebastien Morisset

Revolution Slider
Version 3.0.7 | By ThemePunch

Social Login for wordpress
Version 4.8 | By LoginRadius Team

TinyMCE Advanced
Version 3.5.8 | By Andrew Ozz

W3 Total Cache
Version 0.9.3 | By Frederick Townes

Widget Importer & Exporter
Version 1.0 | By Steven Gliebe

WordPress Social Share Buttons
Version 1.1.3 | By Lee Chestnutt

WP-Memory-Usage
Version 1.2.1 | By Alex Rabe

WP Sliding Login | Register Panel
Version 2.3 | By Kyle Powning @ The Factory

WP Smush.it
Version 1.6.5.3 | By WPMU DEV

9. Are you using the standard BuddyPress themes or customized themes?

I’m using another theme callet BulletPress from HB-Themes

10. Have you modified the core files in any way?

I haven’t modified any BP related files, but I do use a child theme with a custom functions.php

11. Do you have any custom functions in bp-custom.php?

No

12. If running bbPress, which version? Or did your BuddyPress install come with a copy of bbPress built-in?

Our theme came with bbPress, see above for version.

14. Which company provides your hosting?

PlanetHoster

I know that I can use “Site/Super Admin” however the group created right after clicking on “create group and continue” it’s a BIG MISTAKE.

It’s necessary to solve it.

Thanks
Simone