Code Duplication    Length = 97-97 lines in 2 locations

includes/class-give-db-comments-meta.php 1 location

@@ 24-120 (lines=97) @@
21
 *
22
 * @since 2.3.0
23
 */
24
class Give_DB_Comment_Meta extends Give_DB_Meta {
25
	/**
26
	 * Meta supports.
27
	 *
28
	 * @since  2.3.0
29
	 * @access protected
30
	 * @var array
31
	 */
32
	protected $supports = array();
33
34
	/**
35
	 * Meta type
36
	 *
37
	 * @since  2.3.0
38
	 * @access protected
39
	 * @var bool
40
	 */
41
	protected $meta_type = 'comment';
42
43
	/**
44
	 * Give_DB_Comment_Meta constructor.
45
	 *
46
	 * @access  public
47
	 * @since   2.3.0
48
	 */
49
	public function __construct() {
50
		/* @var WPDB $wpdb */
51
		global $wpdb;
52
53
		$wpdb->commentmeta     = $this->table_name = $wpdb->prefix . 'give_commentmeta';
54
		$this->primary_key = 'meta_id';
55
		$this->version     = '1.0';
56
57
		$this->register_table();
58
59
		parent::__construct();
60
	}
61
62
	/**
63
	 * Get table columns and data types.
64
	 *
65
	 * @access  public
66
	 * @since   2.3.0
67
	 *
68
	 * @return  array  Columns and formats.
69
	 */
70
	public function get_columns() {
71
		return array(
72
			'meta_id'    => '%d',
73
			'comment_id'     => '%d',
74
			'meta_key'   => '%s',
75
			'meta_value' => '%s',
76
		);
77
	}
78
79
	/**
80
	 * Delete all comment meta
81
	 *
82
	 * @since  2.3.0
83
	 * @access public
84
	 *
85
	 * @param int $comment_id
86
	 *
87
	 * @return bool
88
	 */
89
	public function delete_row( $comment_id = 0 ) {
90
		/* @var WPDB $wpdb */
91
		global $wpdb;
92
93
		// Row ID must be positive integer
94
		$comment_id = absint( $comment_id );
95
96
		if ( empty( $comment_id ) ) {
97
			return false;
98
		}
99
100
		if ( false === $wpdb->query( $wpdb->prepare( "DELETE FROM $this->table_name WHERE comment_id = %d", $comment_id ) ) ) {
101
			return false;
102
		}
103
104
		return true;
105
	}
106
107
	/**
108
	 * Check if current id is valid
109
	 *
110
	 * @since  2.3.0
111
	 * @access protected
112
	 *
113
	 * @param $ID
114
	 *
115
	 * @return bool
116
	 */
117
	protected function is_valid_post_type( $ID ) {
118
		return $ID && true;
119
	}
120
}
121

includes/class-give-db-logs-meta.php 1 location

@@ 24-120 (lines=97) @@
21
 *
22
 * @since 2.0
23
 */
24
class Give_DB_Log_Meta extends Give_DB_Meta {
25
	/**
26
	 * Meta supports.
27
	 *
28
	 * @since  2.0
29
	 * @access protected
30
	 * @var array
31
	 */
32
	protected $supports = array();
33
34
	/**
35
	 * Meta type
36
	 *
37
	 * @since  2.0
38
	 * @access protected
39
	 * @var bool
40
	 */
41
	protected $meta_type = 'log';
42
43
	/**
44
	 * Give_DB_Log_Meta constructor.
45
	 *
46
	 * @access  public
47
	 * @since   2.0
48
	 */
49
	public function __construct() {
50
		/* @var WPDB $wpdb */
51
		global $wpdb;
52
53
		$wpdb->logmeta     = $this->table_name = $wpdb->prefix . 'give_logmeta';
54
		$this->primary_key = 'meta_id';
55
		$this->version     = '1.0';
56
57
		$this->register_table();
58
59
		parent::__construct();
60
	}
61
62
	/**
63
	 * Get table columns and data types.
64
	 *
65
	 * @access  public
66
	 * @since   2.0
67
	 *
68
	 * @return  array  Columns and formats.
69
	 */
70
	public function get_columns() {
71
		return array(
72
			'meta_id'    => '%d',
73
			'log_id'     => '%d',
74
			'meta_key'   => '%s',
75
			'meta_value' => '%s',
76
		);
77
	}
78
79
	/**
80
	 * Delete all log meta
81
	 *
82
	 * @since  2.0
83
	 * @access public
84
	 *
85
	 * @param int $log_id
86
	 *
87
	 * @return bool
88
	 */
89
	public function delete_row( $log_id = 0 ) {
90
		/* @var WPDB $wpdb */
91
		global $wpdb;
92
93
		// Row ID must be positive integer
94
		$log_id = absint( $log_id );
95
96
		if ( empty( $log_id ) ) {
97
			return false;
98
		}
99
100
		if ( false === $wpdb->query( $wpdb->prepare( "DELETE FROM $this->table_name WHERE log_id = %d", $log_id ) ) ) {
101
			return false;
102
		}
103
104
		return true;
105
	}
106
107
	/**
108
	 * Check if current id is valid
109
	 *
110
	 * @since  2.0
111
	 * @access protected
112
	 *
113
	 * @param $ID
114
	 *
115
	 * @return bool
116
	 */
117
	protected function is_valid_post_type( $ID ) {
118
		return $ID && true;
119
	}
120
}
121