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); $email_yourname = stripslashes($email_log->email_yourname); $email_youremail = stripslashes($email_log->email_youremail); $email_friendname = stripslashes($email_log->email_friendname); $email_friendemail = stripslashes($email_log->email_friendemail); $email_postid = intval($email_log->email_postid); $email_posttitle = htmlspecialchars(stripslashes($email_log->email_posttitle)); $email_date = gmdate(get_option('date_format'), $email_log->email_timestamp); $email_time = gmdate(get_option('time_format'), $email_log->email_timestamp); $email_ip = $email_log->email_ip; $email_host = $email_log->email_host; $email_status = stripslashes($email_log->email_status); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ''; $i++; } } else { echo ''; } ?>
$email_id$email_yourname
$email_youremail
$email_friendname
$email_friendemail
$email_date
$email_time
$email_ip
$email_host
$email_posttitle$email_status
'.__('No E-Mail Logs Found', 'wp-email').'
1) { ?>
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').' »'; } ?>

           



 Yes