Give_DB_Logs::get_sql() - Code Metrics - WordImpress/Give - Measure and Improve Code Quality continuously with Scrutinizer

Give_DB_Logs::get_sql() F
last analyzed 2018-09-17 22:00 UTC

↳ Parent: Give_DB_Logs

Complexity

Conditions	17
Paths	3456

Size

Total Lines

101

Duplication

Lines	26
Ratio	25.74 %

Importance

Changes

Metric	Value
cc	17
nc	3456
nop	1
dl	26
loc	101
rs	0.8399
c	0
b	0
f	0

How to fix Long Method Complexity

<?php
/**
 * Donors DB
 *
 * @package     Give
 * @subpackage  Classes/Give_DB_Logs
 * @copyright   Copyright (c) 2016, WordImpress
 * @license     https://opensource.org/licenses/gpl-license GNU Public License
 * @since       2.0
 */

// Exit if accessed directly.
if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

/**
 * Give_DB_Logs Class
 *
 * This class is for interacting with the log database table.
 *
 * @since 2.0
 */
class Give_DB_Logs extends Give_DB {

	/**
	 * Give_DB_Logs constructor.
	 *
	 * Set up the Give DB Donor class.
	 *
	 * @since  2.0
	 * @access public
	 */
	public function __construct() {

		/* @var WPDB $wpdb */
		global $wpdb;

		$this->table_name  = $wpdb->prefix . 'give_logs';
		$this->primary_key = 'ID';
		$this->version     = '1.0';

		// Install table.
		$this->register_table();

		parent::__construct();
	}

	/**
	 * Get columns and formats
	 *
	 * @since  2.0
	 * @access public
	 *
	 * @return array  Columns and formats.
	 */
	public function get_columns() {
		return array(
			'ID'           => '%d',
			'log_title'    => '%s',
			'log_content'  => '%s',
			'log_parent'   => '%d',
			'log_type'     => '%s',
			'log_date'     => '%s',
			'log_date_gmt' => '%s',
		);
	}

	/**
	 * Get default column values
	 *
	 * @since  2.0
	 * @access public
	 *
	 * @return array  Default column values.
	 */
	public function get_column_defaults() {
		$log_create_date     = current_time( 'mysql', 0 );
		$log_create_date_gmt = get_gmt_from_date( $log_create_date );

		return array(
			'ID'           => 0,
			'log_title'    => '',
			'log_content'  => '',
			'log_parent'   => 0,
			'log_type'     => '',
			'log_date'     => $log_create_date,
			'log_date_gmt' => $log_create_date_gmt,
		);
	}

	/**
	 * Add a log
	 *
	 * @since  2.0
	 * @access public
	 *
	 * @param  array $data
	 *
	 * @return bool|int
	 */
	public function add( $data = array() ) {
		// Valid table columns.
		$table_columns = array_keys( $this->get_columns() );

		// Filter data.
		foreach ( $data as $table_column => $column_data ) {
			if ( ! in_array( $table_column, $table_columns ) ) {
				unset( $data[ $table_column ] );
			}
		}

		// Set default values.
		$current_log_data = wp_parse_args( $data, $this->get_column_defaults() );

		// Log parent should be an int.
		$current_log_data['log_parent'] = absint( $current_log_data['log_parent'] );

		// Get log.
		$existing_log = $this->get_log_by( $current_log_data['ID'] );

		// Update an existing log.
		if ( $existing_log ) {

			// Create new log data from existing and new log data.
			$current_log_data = array_merge( $current_log_data, $existing_log );

			// Update log data.
			$this->update( $current_log_data['ID'], $current_log_data );

			$log_id = $current_log_data['ID'];

		} else {
			$log_id = $this->insert( $current_log_data, 'log' );
		}

		return $log_id;
	}


	/**
	 * Retrieves a single log from the database
	 *
	 * @since  2.0
	 * @access public
	 *
	 * @param int    $log_id
	 * @param string $by
	 *
	 * @return bool|null|array
	 */
	public function get_log_by( $log_id = 0, $by = 'id' ) {
		/* @var WPDB $wpdb */
		global $wpdb;
		$log = null;

		// Make sure $log_id is int.
		$log_id = absint( $log_id );

		// Bailout.
		if ( empty( $log_id ) ) {
			return null;
		}

		switch ( $by ) {
			case 'id':
				$log = $wpdb->get_row(

					$wpdb->prepare(
						"SELECT * FROM $this->table_name WHERE ID = %s LIMIT 1",
						$log_id
					),
					ARRAY_A
				);
				break;

			default:
				$log = apply_filters( "give_get_log_by_{$by}", $log, $log_id );
		}

		return $log;
	}

	/**
	 * Retrieve logs from the database.
	 *
	 * @since  2.0
	 * @access public
	 *
	 * @param  array $args
	 *
	 * @return mixed
	 */
	public function get_logs( $args = array() ) {
		global $wpdb;
		$sql_query = $this->get_sql( $args );

		// Get log.
		if ( ! ( $logs = Give_Cache::get( 'give_logs', true, $sql_query ) ) ) {
			$logs = $wpdb->get_results( $sql_query );

			Give_Cache::set( 'give_logs', $logs, 3600, true, $sql_query );
		}

		return $logs;
	}


	/**
	 * Count the total number of logs in the database
	 *
	 * @since  2.0
	 * @access public
	 *
	 * @param  array $args
	 *
	 * @return int
	 */
	public function count( $args = array() ) {
		/* @var WPDB $wpdb */
		global $wpdb;
		$args['number'] = - 1;
		$args['fields'] = 'ID';
		$args['count']  = true;

		$sql_query = $this->get_sql( $args );

		if ( ! ( $count = Give_Cache::get( 'give_logs_count', true, $sql_query ) ) ) {
			$count = $wpdb->get_var( $sql_query );

			Give_Cache::set( 'give_logs_count', $count, 3600, true, $args );
		}

		return absint( $count );
	}

	/**
	 * Create the table
	 *
	 * @since  2.0
	 * @access public
	 *
	 * @return void
	 */
	public function create_table() {

		global $wpdb;
		$charset_collate = $wpdb->get_charset_collate();

		$sql = "CREATE TABLE {$this->table_name} (
        ID bigint(20) NOT NULL AUTO_INCREMENT,
        log_title longtext NOT NULL,
        log_content longtext NOT NULL,
      	log_parent bigint(20) NOT NULL,
        log_type mediumtext NOT NULL,
        log_date datetime NOT NULL,
        log_date_gmt datetime NOT NULL,
        PRIMARY KEY  (ID)
        ) {$charset_collate};";

		require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
		dbDelta( $sql );

		update_option( $this->table_name . '_db_version', $this->version, false );
	}


	/**
	 * Get sql query from quaried array.
	 *
	 * @since  2.0
	 * @access public
	 *
	 * @param array $args
	 *
	 * @return string
	 */
	public function get_sql( $args = array() ) {
		/* @var WPDB $wpdb */
		global $wpdb;

		$defaults = array(
			'number'  => 20,
			'offset'  => 0,
			'paged'   => 0,
			'orderby' => 'date',
			'order'   => 'DESC',
			'fields'  => 'all',
			'count'   => false,
		);

		$args = wp_parse_args( $args, $defaults );

		// validate params.
		$this->validate_params( $args );

		if ( $args['number'] < 1 ) {
			$args['number'] = 99999999999;
		}

		// Where clause for primary table.
		$where = '';

		// Get sql query for meta.
		if ( ! empty( $args['meta_query'] ) ) {
			$meta_query_object = new WP_Meta_Query( $args['meta_query'] );
			$meta_query        = $meta_query_object->get_sql( 'log', $this->table_name, 'id' );
			$where             = implode( '', $meta_query );
		}

		$where .= ' WHERE 1=1 ';

		// Set offset.
		if ( empty( $args['offset'] ) && ( 0 < $args['paged'] ) ) {
			$args['offset'] = $args['number'] * ( $args['paged'] - 1 );
		}

		// Set fields.
		$fields = "{$this->table_name}.*";
		if ( is_string( $args['fields'] ) && ( 'all' !== $args['fields'] ) ) {
			$fields = "{$this->table_name}.{$args['fields']}";
		}

		// Set count.
		if ( $args['count'] ) {
			$fields = "COUNT({$fields})";
		}

		// Specific logs.
		if ( ! empty( $args['ID'] ) ) {


			if ( ! is_array( $args['ID'] ) ) {
				$args['ID'] = explode( ',', $args['ID'] );
			}
			$log_ids = implode( ',', array_map( 'intval', $args['ID'] ) );

			$where .= " AND {$this->table_name}.ID IN( {$log_ids} ) ";
		}

		// Logs created for a specific date or in a date range
		if ( ! empty( $args['date_query'] ) ) {
			$date_query_object = new WP_Date_Query( $args['date_query'], "{$this->table_name}.log_date" );
			$where             .= $date_query_object->get_sql();
		}

		// Logs create for specific parent.
		if ( ! empty( $args['log_parent'] ) ) {

			if ( ! is_array( $args['log_parent'] ) ) {
				$args['log_parent'] = explode( ',', $args['log_parent'] );
			}
			$parent_ids = implode( ',', array_map( 'intval', $args['log_parent'] ) );

			$where .= " AND {$this->table_name}.log_parent IN( {$parent_ids} ) ";
		}

		// Logs create for specific type.
		// is_array check is for backward compatibility.
		if ( ! empty( $args['log_type'] ) && ! is_array( $args['log_type'] ) ) {

			if ( ! is_array( $args['log_type'] ) ) {
				$args['log_type'] = explode( ',', $args['log_type'] );
			}

			$log_types = implode( '\',\'', array_map( 'trim', $args['log_type'] ) );

			$where .= " AND {$this->table_name}.log_type IN( '{$log_types}' ) ";
		}

		$args['orderby'] = ! array_key_exists( $args['orderby'], $this->get_columns() ) ? 'log_date' : $args['orderby'];

		$args['orderby'] = esc_sql( $args['orderby'] );
		$args['order']   = esc_sql( $args['order'] );

		return $wpdb->prepare(
			"SELECT {$fields} FROM {$this->table_name} {$where} ORDER BY {$this->table_name}.{$args['orderby']} {$args['order']} LIMIT %d,%d;",
			absint( $args['offset'] ),
			absint( $args['number'] )
		);
	}


	/**
	 * Validate query params.
	 *
	 * @since  2.0
	 * @access private
	 *
	 * @param $args
	 *
	 * @return mixed
	 */
	private function validate_params( &$args ) {
		// fields params
		$args['fields'] = 'ids' === $args['fields'] ?
			'ID' :
			$args['fields'];
		$args['fields'] = array_key_exists( $args['fields'], $this->get_columns() ) ?
			$args['fields'] :
			'all';
	}
}


1		<?php
2		/**
3		* Donors DB
4		*
5		* @package Give
6		* @subpackage Classes/Give_DB_Logs
7		* @copyright Copyright (c) 2016, WordImpress
8		* @license https://opensource.org/licenses/gpl-license GNU Public License
9		* @since 2.0
10		*/
11
12		// Exit if accessed directly.
13		if ( ! defined( 'ABSPATH' ) ) {
14		exit;
15		}
16
17		/**
18		* Give_DB_Logs Class
19		*
20		* This class is for interacting with the log database table.
21		*
22		* @since 2.0
23		*/
24		class Give_DB_Logs extends Give_DB {
25
26		/**
27		* Give_DB_Logs constructor.
28		*
29		* Set up the Give DB Donor class.
30		*
31		* @since 2.0
32		* @access public
33		*/
34	View Code Duplication	public function __construct() {
		0 ignored issues – show Duplication introduced 2018-02-17 00:46 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
35		/* @var WPDB $wpdb */
36		global $wpdb;
37
38		$this->table_name = $wpdb->prefix . 'give_logs';
39		$this->primary_key = 'ID';
40		$this->version = '1.0';
41
42		// Install table.
43		$this->register_table();
44
45		parent::__construct();
46		}
47
48		/**
49		* Get columns and formats
50		*
51		* @since 2.0
52		* @access public
53		*
54		* @return array Columns and formats.
55		*/
56		public function get_columns() {
57		return array(
58		'ID' => '%d',
59		'log_title' => '%s',
60		'log_content' => '%s',
61		'log_parent' => '%d',
62		'log_type' => '%s',
63		'log_date' => '%s',
64		'log_date_gmt' => '%s',
65		);
66		}
67
68		/**
69		* Get default column values
70		*
71		* @since 2.0
72		* @access public
73		*
74		* @return array Default column values.
75		*/
76		public function get_column_defaults() {
77		$log_create_date = current_time( 'mysql', 0 );
78		$log_create_date_gmt = get_gmt_from_date( $log_create_date );
79
80		return array(
81		'ID' => 0,
82		'log_title' => '',
83		'log_content' => '',
84		'log_parent' => 0,
85		'log_type' => '',
86		'log_date' => $log_create_date,
87		'log_date_gmt' => $log_create_date_gmt,
88		);
89		}
90
91		/**
92		* Add a log
93		*
94		* @since 2.0
95		* @access public
96		*
97		* @param array $data
98		*
99		* @return bool\|int
100		*/
101		public function add( $data = array() ) {
102		// Valid table columns.
103		$table_columns = array_keys( $this->get_columns() );
104
105		// Filter data.
106		foreach ( $data as $table_column => $column_data ) {
107		if ( ! in_array( $table_column, $table_columns ) ) {
108		unset( $data[ $table_column ] );
109		}
110		}
111
112		// Set default values.
113		$current_log_data = wp_parse_args( $data, $this->get_column_defaults() );
114
115		// Log parent should be an int.
116		$current_log_data['log_parent'] = absint( $current_log_data['log_parent'] );
117
118		// Get log.
119		$existing_log = $this->get_log_by( $current_log_data['ID'] );
120
121		// Update an existing log.
122		if ( $existing_log ) {
123
124		// Create new log data from existing and new log data.
125		$current_log_data = array_merge( $current_log_data, $existing_log );
126
127		// Update log data.
128		$this->update( $current_log_data['ID'], $current_log_data );
129
130		$log_id = $current_log_data['ID'];
131
132		} else {
133		$log_id = $this->insert( $current_log_data, 'log' );
134		}
135
136		return $log_id;
137		}
138
139
140		/**
141		* Retrieves a single log from the database
142		*
143		* @since 2.0
144		* @access public
145		*
146		* @param int $log_id
147		* @param string $by
148		*
149		* @return bool\|null\|array
150		*/
151		public function get_log_by( $log_id = 0, $by = 'id' ) {
152		/* @var WPDB $wpdb */
153		global $wpdb;
154		$log = null;
155
156		// Make sure $log_id is int.
157		$log_id = absint( $log_id );
158
159		// Bailout.
160		if ( empty( $log_id ) ) {
161		return null;
162		}
163
164		switch ( $by ) {
165		case 'id':
166		$log = $wpdb->get_row(
		0 ignored issues – show introduced 2018-01-17 19:08 UTC by Report Bug Copy Issue Report Usage of a direct database call is discouraged. Loading history... introduced 2018-01-17 19:08 UTC by Report Bug Copy Issue Report Usage of a direct database call without caching is prohibited. Use wp_cache_get / wp_cache_set. Loading history...
167		$wpdb->prepare(
168		"SELECT * FROM $this->table_name WHERE ID = %s LIMIT 1",
169		$log_id
170		),
171		ARRAY_A
172		);
173		break;
174
175		default:
176		$log = apply_filters( "give_get_log_by_{$by}", $log, $log_id );
177		}
178
179		return $log;
180		}
181
182		/**
183		* Retrieve logs from the database.
184		*
185		* @since 2.0
186		* @access public
187		*
188		* @param array $args
189		*
190		* @return mixed
191		*/
192		public function get_logs( $args = array() ) {
193		global $wpdb;
194		$sql_query = $this->get_sql( $args );
195
196		// Get log.
197		if ( ! ( $logs = Give_Cache::get( 'give_logs', true, $sql_query ) ) ) {
198		$logs = $wpdb->get_results( $sql_query );
		0 ignored issues – show introduced 2018-01-17 19:08 UTC by Report Bug Copy Issue Report Usage of a direct database call is discouraged. Loading history... introduced 2018-01-17 19:08 UTC by Report Bug Copy Issue Report Usage of a direct database call without caching is prohibited. Use wp_cache_get / wp_cache_set. Loading history...
199		Give_Cache::set( 'give_logs', $logs, 3600, true, $sql_query );
200		}
201
202		return $logs;
203		}
204
205
206		/**
207		* Count the total number of logs in the database
208		*
209		* @since 2.0
210		* @access public
211		*
212		* @param array $args
213		*
214		* @return int
215		*/
216		public function count( $args = array() ) {
217		/* @var WPDB $wpdb */
218		global $wpdb;
219		$args['number'] = - 1;
220		$args['fields'] = 'ID';
221		$args['count'] = true;
222
223		$sql_query = $this->get_sql( $args );
224
225		if ( ! ( $count = Give_Cache::get( 'give_logs_count', true, $sql_query ) ) ) {
226		$count = $wpdb->get_var( $sql_query );
		0 ignored issues – show introduced 2018-01-17 19:08 UTC by Report Bug Copy Issue Report Usage of a direct database call is discouraged. Loading history... introduced 2018-01-17 19:08 UTC by Report Bug Copy Issue Report Usage of a direct database call without caching is prohibited. Use wp_cache_get / wp_cache_set. Loading history...
227		Give_Cache::set( 'give_logs_count', $count, 3600, true, $args );
228		}
229
230		return absint( $count );
231		}
232
233		/**
234		* Create the table
235		*
236		* @since 2.0
237		* @access public
238		*
239		* @return void
240		*/
241	View Code Duplication	public function create_table() {
		0 ignored issues – show Duplication introduced 2018-07-24 22:16 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
242		global $wpdb;
243		$charset_collate = $wpdb->get_charset_collate();
244
245		$sql = "CREATE TABLE {$this->table_name} (
246		ID bigint(20) NOT NULL AUTO_INCREMENT,
247		log_title longtext NOT NULL,
248		log_content longtext NOT NULL,
249		log_parent bigint(20) NOT NULL,
250		log_type mediumtext NOT NULL,
251		log_date datetime NOT NULL,
252		log_date_gmt datetime NOT NULL,
253		PRIMARY KEY (ID)
254		) {$charset_collate};";
255
256		require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
257		dbDelta( $sql );
258
259		update_option( $this->table_name . '_db_version', $this->version, false );
260		}
261
262
263		/**
264		* Get sql query from quaried array.
265		*
266		* @since 2.0
267		* @access public
268		*
269		* @param array $args
270		*
271		* @return string
272		*/
273		public function get_sql( $args = array() ) {
274		/* @var WPDB $wpdb */
275		global $wpdb;
276
277		$defaults = array(
278		'number' => 20,
279		'offset' => 0,
280		'paged' => 0,
281		'orderby' => 'date',
282		'order' => 'DESC',
283		'fields' => 'all',
284		'count' => false,
285		);
286
287		$args = wp_parse_args( $args, $defaults );
288
289		// validate params.
290		$this->validate_params( $args );
291
292		if ( $args['number'] < 1 ) {
293		$args['number'] = 99999999999;
294		}
295
296		// Where clause for primary table.
297		$where = '';
298
299		// Get sql query for meta.
300		if ( ! empty( $args['meta_query'] ) ) {
301		$meta_query_object = new WP_Meta_Query( $args['meta_query'] );
302		$meta_query = $meta_query_object->get_sql( 'log', $this->table_name, 'id' );
303		$where = implode( '', $meta_query );
304		}
305
306		$where .= ' WHERE 1=1 ';
307
308		// Set offset.
309		if ( empty( $args['offset'] ) && ( 0 < $args['paged'] ) ) {
310		$args['offset'] = $args['number'] * ( $args['paged'] - 1 );
311		}
312
313		// Set fields.
314		$fields = "{$this->table_name}.*";
315		if ( is_string( $args['fields'] ) && ( 'all' !== $args['fields'] ) ) {
316		$fields = "{$this->table_name}.{$args['fields']}";
317		}
318
319		// Set count.
320		if ( $args['count'] ) {
321		$fields = "COUNT({$fields})";
322		}
323
324		// Specific logs.
325	View Code Duplication	if ( ! empty( $args['ID'] ) ) {
		0 ignored issues – show Duplication introduced 2017-08-01 08:32 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
326
327		if ( ! is_array( $args['ID'] ) ) {
328		$args['ID'] = explode( ',', $args['ID'] );
329		}
330		$log_ids = implode( ',', array_map( 'intval', $args['ID'] ) );
331
332		$where .= " AND {$this->table_name}.ID IN( {$log_ids} ) ";
333		}
334
335		// Logs created for a specific date or in a date range
336		if ( ! empty( $args['date_query'] ) ) {
337		$date_query_object = new WP_Date_Query( $args['date_query'], "{$this->table_name}.log_date" );
338		$where .= $date_query_object->get_sql();
339		}
340
341		// Logs create for specific parent.
342	View Code Duplication	if ( ! empty( $args['log_parent'] ) ) {
		0 ignored issues – show Duplication introduced 2018-01-17 19:08 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
343		if ( ! is_array( $args['log_parent'] ) ) {
344		$args['log_parent'] = explode( ',', $args['log_parent'] );
345		}
346		$parent_ids = implode( ',', array_map( 'intval', $args['log_parent'] ) );
347
348		$where .= " AND {$this->table_name}.log_parent IN( {$parent_ids} ) ";
349		}
350
351		// Logs create for specific type.
352		// is_array check is for backward compatibility.
353	View Code Duplication	if ( ! empty( $args['log_type'] ) && ! is_array( $args['log_type'] ) ) {
		0 ignored issues – show Duplication introduced 2018-01-17 19:08 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
354		if ( ! is_array( $args['log_type'] ) ) {
355		$args['log_type'] = explode( ',', $args['log_type'] );
356		}
357
358		$log_types = implode( '\',\'', array_map( 'trim', $args['log_type'] ) );
359
360		$where .= " AND {$this->table_name}.log_type IN( '{$log_types}' ) ";
361		}
362
363		$args['orderby'] = ! array_key_exists( $args['orderby'], $this->get_columns() ) ? 'log_date' : $args['orderby'];
364
365		$args['orderby'] = esc_sql( $args['orderby'] );
366		$args['order'] = esc_sql( $args['order'] );
367
368		return $wpdb->prepare(
369		"SELECT {$fields} FROM {$this->table_name} {$where} ORDER BY {$this->table_name}.{$args['orderby']} {$args['order']} LIMIT %d,%d;",
370		absint( $args['offset'] ),
371		absint( $args['number'] )
372		);
373		}
374
375
376		/**
377		* Validate query params.
378		*
379		* @since 2.0
380		* @access private
381		*
382		* @param $args
383		*
384		* @return mixed
385		*/
386		private function validate_params( &$args ) {
387		// fields params
388		$args['fields'] = 'ids' === $args['fields'] ?
389		'ID' :
390		$args['fields'];
391		$args['fields'] = array_key_exists( $args['fields'], $this->get_columns() ) ?
392		$args['fields'] :
393		'all';
394		}
395		}
396

WordImpress / Give

Give_DB_Logs::get_sql() F last analyzed 2018-09-17 22:00 UTC

Complexity

Size

Duplication

Importance

How to fix Long Method Complexity

Long Method

Duplication Side-by-Side

Filter issues like

Give_DB_Logs::get_sql() F
last analyzed 2018-09-17 22:00 UTC