/**
* Executes log rotation periodically.
* @since 1.4
*/
static function LogRotationSchedule()
{
global $wpml_settings, $wpdb;
$tableName = WPML_Plugin::getTablename('mails');
if ($wpml_settings['log-rotation-limit-amout'] == '1') {
$keep = $wpml_settings['log-rotation-limit-amout-keep'];
if ($keep > 0) {
$wpdb->query("DELETE p\n\t\t\t\t\t\tFROM\n\t\t\t\t\t\t{$tableName} AS p\n\t\t\t\t\t\tJOIN\n\t\t\t\t\t\t( SELECT mail_id\n\t\t\t\t\t\tFROM {$tableName}\n\t\t\t\t\t\tORDER BY mail_id DESC\n\t\t\t\t\t\tLIMIT 1 OFFSET {$keep}\n\t\t\t\t) AS lim\n\t\t\t\t\t\tON p.mail_id <= lim.mail_id;");
}
}
if ($wpml_settings['log-rotation-delete-time'] == '1') {
$days = $wpml_settings['log-rotation-delete-time-days'];
if ($days > 0) {
$wpdb->query("DELETE FROM {$tableName} WHERE DATEDIFF(now(), timestamp) >= {$days}");
}
}
}
/**
* Processes bulk actions.
* @since 1.0
*/
function process_bulk_action()
{
global $wpdb;
if (false === $this->current_action()) {
return;
}
if (check_admin_referer(Email_Logging_ListTable::NONCE_LIST_TABLE, Email_Logging_ListTable::NONCE_LIST_TABLE . '_nonce')) {
$name = $this->_args['singular'];
$tableName = WPML_Plugin::getTablename('mails');
//Detect when a bulk action is being triggered...
if ('delete' == $this->current_action()) {
foreach ($_REQUEST[$name] as $item_id) {
$wpdb->query($wpdb->prepare("DELETE FROM `{$tableName}` WHERE `mail_id` = %d", esc_sql($item_id)), ARRAY_A);
}
}
}
}
public function log_email($mailOriginal)
{
// make copy to avoid any changes on the original mail
$mail = $mailOriginal;
global $wpdb;
$fields = $this->extractFields($mail);
$tableName = WPML_Plugin::getTablename('mails');
$wpdb->insert($tableName, $fields);
return $mailOriginal;
}
function process_bulk_action()
{
global $wpdb;
$name = $this->_args['singular'];
$tableName = WPML_Plugin::getTablename('mails');
//Detect when a bulk action is being triggered...
if ('delete' == $this->current_action()) {
foreach ($_REQUEST[$name] as $item_id) {
$wpdb->query($wpdb->prepare("DELETE FROM `{$tableName}` WHERE `mail_id` = %d", $item_id));
}
}
}