Never mind! I have it working. It is an INNER JOIN query change in class-dlm-admin.php
In the “Export Logs” function lines 468 – 611 here are the modifications
$items = $wpdb->get_results(
$wpdb->prepare(
"SELECT p.ID, p.post_title, d.ID, d.download_id,d.type,d.version_id,d.user_id,d.user_ip,d.user_agent,d.download_date,d.download_status,d.download_status_message FROM $wpdb->download_log AS d
INNER JOIN $wpdb->posts AS p ON p.ID = d.download_id
WHERE d.type = 'download'
" . ( $filter_status ? "AND d.download_status = '%s'" : "%s" ) . "
" . ( $filter_month ? "AND d.download_date >= '%s'" : "%s" ) . "
" . ( $filter_month ? "AND d.download_date <= '%s'" : "%s" ) . "
ORDER BY d.download_date DESC",
( $filter_status ? $filter_status : "" ),
( $filter_month ? date( 'Y-m-01', strtotime( $filter_month ) ) : "" ),
( $filter_month ? date( 'Y-m-t', strtotime( $filter_month ) ) : "" )
)
);
$rows = array();
$row = array();
$row[] = __( 'Title', 'download-monitor' );
$row[] = __( 'Download ID', 'download-monitor' );
$row[] = __( 'Version ID', 'download-monitor' );
$row[] = __( 'Filename', 'download-monitor' );
$row[] = __( 'User ID', 'download-monitor' );
$row[] = __( 'User Login', 'download-monitor' );
$row[] = __( 'User Email', 'download-monitor' );
$row[] = __( 'User IP', 'download-monitor' );
$row[] = __( 'User Agent', 'download-monitor' );
$row[] = __( 'Date', 'download-monitor' );
$row[] = __( 'Status', 'download-monitor' );
$rows[] = '"' . implode( '","', $row ) . '"';
if ( ! empty( $items ) ) {
foreach ( $items as $item ) {
$row = array();
$row[] = $item->post_title;
$row[] = $item->download_id;
$row[] = $item->version_id;
$download = new DLM_Download( $item->download_id );
$download->set_version( $item->version_id );
if ( $download->exists() && $download->get_the_filename() )
$row[] = $download->get_the_filename();
else
$row[] = '-';
$row[] = $item->user_id;
if ( $item->d.user_id )
$user = get_user_by( 'id', $item->user_id );
if ( ! isset( $user ) || ! $user ) {
$row[] = '-';
$row[] = '-';
} else {
$row[] = $user->user_login;
$row[] = $user->user_email;
}
$row[] = $item->user_ip;
$row[] = $item->user_agent;
$row[] = $item->download_date;
$row[] = $item->download_status . ( $item->download_status_message ? ' - ' : '' ) . $item->download_status_message;
$rows[] = '"' . implode( '","', $row ) . '"';
}
}