query("DELETE FROM $wpdb->email"); if($delete_logs) { $text = ''.__('All E-Mail Logs Have Been Deleted.', 'wp-email').''; } else { $text = ''.__('An Error Has Occured While Deleting All E-Mail Logs.', 'wp-email').''; } } } ### Get E-Mail Logs Data $total_email_success = $wpdb->get_var("SELECT COUNT(email_id) FROM $wpdb->email WHERE email_status = '".__('Success', 'wp-email')."'"); $total_email_failed = $wpdb->get_var("SELECT COUNT(email_id) FROM $wpdb->email WHERE email_status = '".__('Failed', 'wp-email')."'"); $total_email = $total_email_success+$total_email_failed; ### Checking $email_page and $offset if(empty($email_page) || $email_page == 0) { $email_page = 1; } if(empty($offset)) { $offset = 0; } if(empty($email_log_perpage) || $email_log_perpage == 0) { $email_log_perpage = 20; } ### Determin $offset $offset = ($email_page-1) * $email_log_perpage; ### Determine Max Number Of Polls To Display On Page if(($offset + $email_log_perpage) > $total_email) { $max_on_page = $total_email; } else { $max_on_page = ($offset + $email_log_perpage); } ### Determine Number Of Polls To Display On Page if (($offset + 1) > ($total_email)) { $display_on_page = $total_email; } else { $display_on_page = ($offset + 1); } ### Determing Total Amount Of Pages $total_pages = ceil($total_email / $email_log_perpage); ### Get The Logs $email_logs = $wpdb->get_results("SELECT * FROM $wpdb->email ORDER BY $email_sortby $email_sortorder LIMIT $offset, $email_log_perpage"); ?>
'.$text.'
%s To %s Of %s E-Mail Logs', 'wp-email'), $display_on_page, $max_on_page, $total_email); ?>
%s In %s Order', 'wp-email'), $email_sortby_text, $email_sortorder_text); ?>
| $email_id | \n"; echo "$email_yourname $email_youremail | \n";
echo "$email_friendname $email_friendemail | \n";
echo "$email_date $email_time | \n";
echo "$email_ip $email_host | \n";
echo "$email_posttitle | \n"; echo "$email_status | \n"; echo '
| '.__('No E-Mail Logs Found', 'wp-email').' | ||||||
| 1 && ((($email_page*$email_log_perpage)-($email_log_perpage-1)) <= $total_email)) { echo '« '.__('Previous Page', 'wp-email').''; } else { echo ' '; } ?> | = 1 && ((($email_page*$email_log_perpage)+1) <= $total_email)) { echo ''.__('Next Page', 'wp-email').' »'; } else { echo ' '; } ?> |
| (): = 4) { echo '« '.__('First', 'wp-email').' ... '; } if($email_page > 1) { echo ' « '; } for($i = $email_page - 2 ; $i <= $email_page +2; $i++) { if ($i >= 1 && $i <= $total_pages) { if($i == $email_page) { echo "[$i] "; } else { echo ''.$i.' '; } } } if($email_page < $total_pages) { echo ' » '; } if (($email_page+2) < $total_pages) { echo ' ... '.__('Last', 'wp-email').' »'; } ?> | |