| @@ 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 | ||
| @@ 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 | ||