Alo EasyMail Newsletter:

Add new subscribers

?> "; foreach($array_num as $n) { $selected_test = ($id_test == $test->ID ? ' selected="selected" ': ''); echo ""; } echo ""; ?> prefix}easymail_subscribers"; if( !empty( $s ) ) { $search = '%' . trim( $s ) . '%'; $where_search = " WHERE email LIKE '$search' OR name LIKE '$search' "; $query .= $where_search; } // order if( $_GET['sortby'] == 'email' ) { $query .= ' ORDER BY email '; } elseif( $_GET['sortby'] == 'join_date' ) { $query .= ' ORDER BY join_date '; } elseif( $_GET['sortby'] == 'active' ) { $query .= ' ORDER BY active '; } $query .= ( $_GET['order'] == 'ASC' ) ? 'ASC' : 'DESC'; $query .= " LIMIT $offset, $items_per_page "; // The QUERY on subscribers $all_subscribers = $wpdb->get_results($query); if (count($all_subscribers)) { $class = 'alternate'; $row_count = 0; foreach($all_subscribers as $subscriber) { $row_count++; $class = ('alternate' == $class) ? '' : 'alternate'; print "\n"; ?>

#		".__("E-mail", "alo-easymail").""; ?>			".__("Join date", "alo-easymail").""; ?>	".__("Activated", "alo-easymail")."" .ALO_em_help_tooltip(__("For registered users the dafault state is activated. For public subscribers the default state is deactivated: it will be activated by clicking on the activation link in the e-mail.", "alo-easymail")); ?>
	email, 30) ; ?>	email; ?>	name; ?>	email) ) { $user_info = get_userdata( email_exists($subscriber->email) ); echo "ID}' title='".__("View user profile", "alo-easymail")."'>{$user_info->user_login}"; } ?>	join_date))." h.".date("H:i", strtotime($subscriber->join_date)) ?>	ID. "&act=".(($subscriber->active == 1)? "0":"1")."&sortby=".$_GET['sortby']. "&order=".$_GET['order']. "' title='".__("Modify activation state", "alo-easymail")."' "; echo " onclick=\"return confirm('". __("Do you really want to modify the activation state?", "alo-easymail") ."');\">"; echo "active == 1)? "yes.png":"no.png") ."' />"; ?>	ID. "&sortby=".$_GET['sortby']."&order=".$_GET['order']. "' title='".__("Delete subscriber", "alo-easymail")."' "; echo " onclick=\"return confirm('".__("Do you really want to DELETE this subscriber?", "alo-easymail")."');\">"; echo ""; ?>
.

get_var("SELECT COUNT(*) FROM {$wpdb->prefix}easymail_subscribers" . (!empty( $s )?$where_search : "")); $total_pages = ceil($total_items / $items_per_page); $arr_params = array ('paged' => '%#%', 'subscriber_id' => '' /* unset to avoid updated msg in next page */ ); $page_links = paginate_links( array( 'base' => add_query_arg( $arr_params/*'paged', '%#%' */), 'format' => '', 'total' => $total_pages, 'show_all' => true, 'current' => $page )); /* $page_links = paginate_links( array( 'base' => $link_base ."&num=".$items_per_page. (($_GET['s'])? "&s=".$s : "") , 'format' => '&paged=%#%', 'total' => $total_pages, 'show_all' => true, 'current' => $page ));*/ if ( $page_links ) echo "

$page_links

"; ?>

Add new subscribers ?> ".$query.""; //print "
Totali = ".$total_items."
"; //print_r($_GET) // end DEBUG -------------------------------------- ?>