BuddyPress.org

define('DB_SERVER', DB_HOST );
define('DB_PORT', '3306' );
define('DB_USERNAME', DB_USER );
define('TABLE_PREFIX', 'wp_' );
define('DB_USERTABLE', 'users' );
define('DB_USERTABLE_NAME', 'display_name' );
define('DB_USERTABLE_USERID', 'ID' );
define('DB_USERTABLE_LASTACTIVITY'…[Read more]

EXECUTE MYSQLALTER TABLE wp_users ADD COLUMN 'lastactivity' INT default 0

` $sql = (“(select DISTINCT “.TABLE_PREFIX.DB_USERTABLE.”.”.DB_USERTABLE_USERID.” userid, “.TABLE_PREFIX.DB_USERTABLE.”.”.DB_USERTABLE_NAME.” username, “.TABLE_PREFIX.DB_USERTABLE.”.”.DB_USERTABLE_LASTACTIVITY.” lastactivity, CONCAT(“.TABLE_PREFIX.DB_USERTABLE.”.”.DB_USERTABLE_USERID.”,’|’,”.TABLE_PREFIX.DB_USERTABLE.”.user_email) avatar,…[Read more]

function follow_deleted( $user_id ) {
global $wpdb, $bp;

$wpdb->query( $wpdb->prepare( “DELETE FROM {$bp->follow->table_name} WHERE leader_id = %d”, user_id ) );
$wpdb->query( $wpdb->prepare( “DELETE FROM {$bp->follow->table_name} WHERE follower_id = %d”, user_id ) );

}

add_action( ‘wpmu_delete_user’, ‘follow_deleted’ );
add_action(…[Read more]

function follow_deleted( $user_id ) {
global $wpdb, $bp;

$wpdb->query( $wpdb->prepare( “DELETE FROM {$bp->follow->table_name} WHERE leader_id = %d”, user_id ) );
$wpdb->query( $wpdb->prepare( “DELETE FROM {$bp->follow->table_name} WHERE follower_id = %d”, user_id ) );

}

add_action( ‘wpmu_delete_user’, ‘follow_deleted’ );
add_action(…[Read more]