Email Users Custom Lists

A recent question on the WordPress Support forum got me thinking on how to solve this user’s question.  The obvious answer was to use the Custom Meta filter capability which has been part of Email Users for quite a while.

The one limitation of Custom Meta filters was the limitation in how WordPress support SQL wildcards in the LIKE and NOT LIKE constructs.  WordPress would add unwanted escape characters preventing the wildcard from matching rendering LIKE and NOT LIKE largely useless.  I had submitted a WordPress patch 4+ years ago when I ran into this issue and expected it to be fixed in WordPress 3.6.  It was never incorporated, I am not sure why, there isn’t much of an explanation in the ticket.

When I started looking back into this today I found that WordPress had added support for regular expressions (REGEXP, NOT REGEXP) to user meta queries.  This is good news as it is actually a better, and easier to use, solution than using the SQL LIKE construct.

I have updated Email Users to reflect this recommended usage, all of the examples have switched from LIKE to REGEXP and I’ve added a couple more.  I’ve also updated the example plugin I use to test these custom meta queries.  I prefer to put these type of things in a small plugin instead of the theme’s functions.php file because risk of losing them with a theme update or change is much lower.

Email Users Custom List (164 downloads)

 

Example:  Select Users with Last Name beginning with M:

add_action( 'mailusers_user_custom_meta_filter', 'last_names_starting_with_m', 5 );

function last_names_starting_with_m()
{
 mailusers_register_user_custom_meta_filter('Last Name: M', 'last_name', '^M', 'REGEXP');
}

Example:  Select Users with Last Names beginning with S-Z:

</pre>
add_action( 'mailusers_user_custom_meta_filter', 'last_names_starting_with_s_through_z', 5 );

function last_names_starting_with_s_through_z()
{
mailusers_register_user_custom_meta_filter('Last Name: S-Z', 'last_name', '^[S-Z]', 'REGEXP');
}
<pre>

Google Forms v0.90 RC1 available

I have addressed what I hope is the last of the security concerns with Google Forms and resubmitted to WordPress.org for approval.  In the meantime, should anyone want early access to the next update, which includes some additional debug features as well as addressing the security concerns, you can download it here.

You can also find the current development version on GitHub.

Google Forms Beta (371 downloads)

EDIT:  Due to forgetting to update the stable version tag, the version is now v0.91.

Email Users v4.8.5-beta-4 available

This afternoon I posted beta-4 of Email Users v4.8.5.  This build adds some additional debug information to help chase down slow database queries.  When in debug mode, Email Users will now report information about the query like this:

<!-- email-users.php::1391 -->
<!-- email-users.php::1410 Query #1 Memory Usage: 15.75M -->
<!-- email-users.php::1415 Query #1 Execution: 0.30101704597473s / 301.01704597473ms -->
<!-- email-users.php::1410 Query #2 Memory Usage: 20M -->
<!-- email-users.php::1415 Query #2 Execution: 0.29001688957214s / 290.01688957214ms -->
<!-- email-users.php::1410 Query #3 Memory Usage: 24.5M -->
<!-- email-users.php::1415 Query #3 Execution: 0.201012134552s / 201.012134552ms -->
<!-- 1282 -->
<!-- email-users.php::1448 -->
Email Users Beta (178 downloads)

Email Users v4.8.5-beta-3

This morning I uploaded another beta (beta-3) build of Email Users v4.8.5.  This build addresses an issue with the mailusers_update_custom_meta_filters action not being applied to User Email (it was only applied to Group and Notificationemail).  This problem was reported in the WordPress Support Forum about a month ago.

Email Users Beta (178 downloads)

Email User v4.8.5-beta-2

This evening I uploaded another beta (beta-2) build of Email Users v4.8.5.  This build addresses an issue with the user’s email preferences not being respected when using a custom meta filter.  This problem was reported in the WordPress Support Forum a few weeks back.

Email Users Beta (178 downloads)

Email Users 4.8.5-beta-1 Available

I’ve posted Email Users v4.8.5-beta-1 for testing purposes.  This is a minor update which restores functionality which was removed in 4.7.1.  See this recent thread and this old 4.7.1 thread on the WordPress Support Forum for more details on the change in 4.7.1.

The change in 4.8.5 introduces a new option (Send User Exclude Role) on the Settings page which is enabled by default to retain the current functionality.  When turned off, the user’s current role is also included in the list of roles presented as potential recipients.

Please provide any feedback ASAP as my window to fix this over the holiday break at work is small.

Email Users Beta (178 downloads)

 

WordPress Google Forms V0.88-beta-2 Available

For the past week I have been working with WordPress.org to get my Google Forms plugin relisted.  They recommended a different approach to addressing the security concern than I had implemented.

It took a little longer than I expected to get their recommendation working but I have implemented the fixes recommended by the WordPress Security Team and am in the process of getting the plugin listed again.

I would like to enlist some additional testing besides my small suite of test cases with the updated code.

Google Forms Beta (371 downloads)

WordPress Google Forms v0.88-beta-1 available

Last week I was notified my Google Forms plugin had a potential security flaw and would be de-listed from the plugin repository until addressed.  I have implemented the fixes recommended by the WordPress Security Team and am in the process of getting the plugin listed again.

I would like to enlist some additional testing besides my small suite of test cases with the updated code.

Google Forms Beta (371 downloads)

Let me know ASAP if you encountered any issues with this beta release of the plugin.

Google Moves Downgrade Option – Again

Google has made another change to the new version of Google Forms and moved the option to downgrade a form to the older version.  There is no longer a Running Man icon to click on to get the downgrade option.  Instead, look for the large question mark in the lower right hand corner .

2016-11-11_8-44-09

  1. Click on the Question Mark icon
  2. Click on the “Back to old Form” menu

This is the third time access to the downgrade option has moved.  It is probably just a matter of time before Google eliminates this completely.  If/when that happens it may no longer be possible to use Google Forms with WordPress.