CUNY Academic Commons

<?php

global $wpdb, $bp;

$gms = $wpdb->get_results( "SELECT * FROM {$bp->groups->table_name_members} WHERE is_banned = 0 AND is_confirmed = 1" );

$cols = [

	0 => 'user_id',

	1 => 'user_email',

	2 => 'group_name',

	3 => 'group_id',

];

$data_rows = array_map(

	function( $gm ) {

		$user  = get_userdata( $gm->user_id );

		$group = groups_get_group( $gm->group_id );

		return [

			0 => $user->ID,

			1 => $user->user_email,

			2 => $group->name,

			3 => $group->id

		];

	},

	$gms

);

$csv_path = ABSPATH . '/al-cop-group-members-' . date( 'Y-m-d' ) . '.csv';

$fh = fopen( $csv_path, 'w+' );

fprintf( $fh, chr(0xEF) . chr(0xBB) . chr(0xBF) );

fputcsv( $fh, $cols );

foreach ( $data_rows as $data_row ) {

	fputcsv( $fh, $data_row );

}

fclose( $fh );

die();