summaryrefslogtreecommitdiff
path: root/Postman/PostmanLogMeta.php
diff options
context:
space:
mode:
authorYehuda Hassine <yehuda@myinbox.in>2019-04-22 00:23:38 +0300
committerYehuda Hassine <yehuda@myinbox.in>2019-04-22 00:23:38 +0300
commit7781aa65cef32d8c8196979edb21ec4551e5b904 (patch)
tree2a7944400ede6a9a574a83ce89d010b26628fe02 /Postman/PostmanLogMeta.php
parentdad9828e8c866e50d6e44aebd103f1ab97409a5b (diff)
downloadPost-SMTP-7781aa65cef32d8c8196979edb21ec4551e5b904.zip
better meta query,bugs, optimization
Diffstat (limited to 'Postman/PostmanLogMeta.php')
-rw-r--r--Postman/PostmanLogMeta.php76
1 files changed, 0 insertions, 76 deletions
diff --git a/Postman/PostmanLogMeta.php b/Postman/PostmanLogMeta.php
deleted file mode 100644
index 8a05b3a..0000000
--- a/Postman/PostmanLogMeta.php
+++ /dev/null
@@ -1,76 +0,0 @@
-<?php
-
-class PostmanLogMeta {
-
- public $log_meta_type = 'post_smtp_logs';
-
- private $meta_fields = array(
- 'success',
- 'from_header',
- 'to_header',
- 'cc_header',
- 'bcc_header',
- 'reply_to_header',
- 'transport_uri',
- 'original_to',
- 'original_subject',
- 'original_message',
- 'original_headers',
- 'session_transcript'
- );
-
- function install_table() {
-
- global $wpdb;
-
- $sql = "CREATE TABLE `{$this->log_meta_type}_{$wpdb->prefix}_{$this->log_meta_type}` (

- `meta_id` bigint(20) NOT NULL AUTO_INCREMENT,

- `post_smtp_id` bigint(20) NOT NULL DEFAULT '0',

- `meta_key` varchar(255) DEFAULT NULL,
 `meta_value` longtext,

- PRIMARY KEY (`meta_id`),

- KEY `post_smtp_id` (`post_smtp_id`),

- KEY `meta_key` (`meta_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
";
-
- dbDelta( $sql );
- }
-
- function migrate_data() {
- $args = array(
- 'post_type' => 'postman_sent_mail',
- 'posts_per_page' => -1,
- );
-
- $logs = new WP_Query($args);
-
- $failed_records = 0;
- foreach ( $logs->posts as $log ) {
-
- foreach ( $this->meta_fields as $key ) {
- $value = $this->get_meta( $log->ID, $key, true );
-
- if ( $this->add_meta( $log->ID, $key, $value ) ) {
- delete_post_meta( $log->ID, $key );
- } else {
- $failed_records++;
- }
- }
- }
- }
-
- function add_meta( $post_id = 0, $meta_key = '', $meta_value = '' ) {
- return add_metadata( $this->log_meta_type, $post_id, $meta_key, $meta_value );
- }
-
- function update_meta( $post_id = 0, $meta_key = '', $meta_value = '' ) {
- return update_metadata( $this->log_meta_type, $post_id, $meta_key, $meta_value );
- }
-
- function get_meta( $post_id = 0, $meta_key = '', $single = false ) {
- return get_metadata( $this->log_meta_type, $post_id, $meta_key, $single );
- }
-
- function delete_meta( $post_id = 0, $meta_key = '' ) {
- return delete_metadata( $this->log_meta_type, $post_id, $meta_key );
- }
-
-} \ No newline at end of file