About: Quentin Algood

The incompatibility is with Ajax Event Calendar. When Ajax Event Calendar is disabled, the EOT column displays properly.

The plugin functionality that may cause this issue is:

Track the number of events created by each user in the Users menu

A quick fix is to disable the functionality by editing ajax-event-calendar.php like so:

// wordpress overrides
//add_filter('manage_users_columns', array($this, 'add_events_column'));
//add_filter('manage_users_custom_column', array($this, 'add_events_column_data'), 10, 3);

Of course, the edit doesn’t fix the cause of incompatibility. If anyone sees the reason for incompatibility in the Ajax Event Calendar plugin code, please chime in:

// CUSTOMIZE WORDPRESS
// adds column field label to WordPress users page
function add_events_column($columns) {
	$columns['calendar_events'] = __('Events', AEC_NAME);
	return $columns;
}

// adds column field value to WordPress users page
function add_events_column_data($empty='', $column_name, $user_id) {
	if ($column_name == 'calendar_events') {
		return $this->db_query_events_by_user($user_id);
	}
}

function db_query_events_by_user($user_id) {
	global $wpdb;
	$result = $wpdb->get_var($wpdb->prepare('SELECT count(id)
		 FROM ' . $wpdb->prefix . AEC_EVENT_TABLE . '
		 WHERE user_id = %d;', $user_id));
	return $this->return_result($result);
}

function return_result($result) {
	if ($result === false) {
		global $wpdb;
		$this->log($wpdb->print_error());
		return false;
	}
	return $result;
}

function log($message) {
	if (is_array($message) || is_object($message)) {
		error_log(print_r($message, true));
	} else {
		error_log($message);
	}
	return;
}

• This reply was modified 4 years, 1 month ago by  Quentin Algood.
• This reply was modified 4 years, 1 month ago by  Quentin Algood. Reason: code
• This reply was modified 4 years, 1 month ago by  Quentin Algood. Reason: more code
• This reply was modified 4 years, 1 month ago by  Quentin Algood.

Yes. This is /wp-content/mu-plugins/s2-hacks.php

<?php

/*
* Code to order columns adopted from http://wordpress.org/support/topic/make-extra-columns-in-userphp-sortable#post-2810255
*
* Hack tested s2Member v120703; WordPress version 3.4.2; PHP v5.4 on September 25, 2012
*/

add_filter('manage_users_columns', 's2hack_eot_column_add');
function s2hack_eot_column_add($col)
	{
		$col['s2member_auto_eot_time'] = 'EOT'; # Set title for column
		return $col;
	}

add_filter('manage_users_custom_column', 's2hack_eot_column_edit_val', 10, 3);
function s2hack_eot_column_edit_val($val, $col_name, $id)
	{
		$user = get_userdata($id); # Get the user's info
		
		if($col_name === 's2member_auto_eot_time' && ($eot = get_user_field('s2member_auto_eot_time', $user->ID))) # If column is for EOT, and user's EOT date is not empty
			return date("D M dS, Y".'<\b\r /><\s\m\a\l\l>'."@\p\\r\\e\c\i\s\\e\l\y g:i a".'</\s\m\a\l\l>', $eot); # return the date user's membership expires (using same standards as s2Member registration date layout)
		
		elseif($col_name === 's2member_auto_eot_time') # Otherwise, if the user does not have an EOT date
			return '--'; # Just return -- as s2Member does normally
		
		else return $val; # Otherwise, we don't need to edit this
	}

add_action('pre_user_query', 's2hack_eot_column_query'); # This could also be changed from pre_user_query to query, but easier to work with an object (pre_user_query) than a string(query)
function s2hack_eot_column_query($query)
	{
		global $wpdb; # Get WordPress database class / for prefix
		$vars = $query->query_vars; # Query variables reassigned for easier access
		
		if($vars['orderby'] === 's2member_auto_eot_time') # If querying the s2Member Automatic EOT times
			{
				// Could var_dump($query) here if need to know the values within the $query Object
				$query->query_from .= " LEFT JOIN ".$wpdb->prefix."usermeta m ON (".$wpdb->prefix."users.ID = m.user_id  AND m.meta_key = '".$wpdb->prefix."$vars[orderby]')"; # Append meta values for s2Member EOT times...
				$query->query_orderby = "ORDER BY m.meta_value ".$vars['order']; # ...and order by these times by EOT in ASC or DESC order, depending on the query
			}
	}

add_filter('manage_users_sortable_columns', 's2hack_eot_column_add_sort');
function s2hack_eot_column_add_sort($columns)
	{
		$columns['s2member_auto_eot_time'] = 's2member_auto_eot_time'; # Add eot column to sortable columns
		return $columns; # Then return all sortable columns
	}

// hack to deliver paypal button with date based expiration
// no longer used now that club expires all memberships on 7/1
add_action("ws_plugin__s2member_before_sc_paypal_button", "s2_hacks_eot_by_date");
function s2_hacks_eot_by_date($vars = array())
{
	if ($vars["attr"]["expire"] && $vars["attr"]["cutoff"])	
	{
		$expire = strtotime($vars["attr"]["expire"] . "+1 day"); // Include all of the last day
		$cutoff = strtotime($vars["attr"]["cutoff"] . "+1 day"); // Include all of the last day
		$now = time();
		if($now > $cutoff) {
			$expire = strtotime(date("Y-m-d", $expire) . "+1 year"); // Add one year if after cutoff
		}
		$timeleft = $expire-$now;
		$daysleft = round((($timeleft/24)/60)/60) + 1; // Add one day to include the last day
		$vars["attr"]["rp"] = $daysleft; // Set the number of days
		$vars["attr"]["rt"] = "D"; // Set the rate term to days
		$vars["attr"]["custom"] .= "|" . date("Y-m-d", $expire); // Append computed EOT to the custom field
		unset($vars["attr"]["expire"]);
		unset($vars["attr"]["cutoff"]);
	}
	return;
}




?>