Edit File by line

[500] Fix | Delete

if ( in_array( $filters['request_type'], array( 'call', 'ajax', 'cron' ) ) ) {

[501] Fix | Delete

$criteria[] = array( 'col' => 'request_type', 'val' => $filters['request_type'] );

[502] Fix | Delete

}

[503] Fix | Delete

}

[504] Fix | Delete

[505] Fix | Delete

if ( ! empty( $filters['file'] ) ) {

[506] Fix | Delete

$criteria[] = array(

[507] Fix | Delete

'col' => 'file',

[508] Fix | Delete

'op' => 'LIKE',

[509] Fix | Delete

'val' => '%' . esc_sql( $filters['file'] ),

[510] Fix | Delete

);

[511] Fix | Delete

}

[512] Fix | Delete

[513] Fix | Delete

if ( ! empty( $filters['function'] ) ) {

[514] Fix | Delete

$criteria[] = array(

[515] Fix | Delete

'col' => 'function',

[516] Fix | Delete

'op' => 'LIKE',

[517] Fix | Delete

'val' => '%' . esc_sql( $filters['function'] ),

[518] Fix | Delete

);

[519] Fix | Delete

}

[520] Fix | Delete

[521] Fix | Delete

if ( ! empty( $filters['process_id'] ) && is_numeric( $filters['process_id'] ) ) {

[522] Fix | Delete

$criteria[] = array( 'col' => 'process_id', 'val' => $filters['process_id'] );

[523] Fix | Delete

}

[524] Fix | Delete

[525] Fix | Delete

if ( ! empty( $filters['logger'] ) ) {

[526] Fix | Delete

$criteria[] = array(

[527] Fix | Delete

'col' => 'logger',

[528] Fix | Delete

'op' => 'LIKE',

[529] Fix | Delete

'val' => '%' . esc_sql( $filters['logger'] ) . '%',

[530] Fix | Delete

);

[531] Fix | Delete

}

[532] Fix | Delete

[533] Fix | Delete

if ( ! empty( $filters['message'] ) ) {

[534] Fix | Delete

$criteria[] = array(

[535] Fix | Delete

'col' => 'message',

[536] Fix | Delete

'op' => 'LIKE',

[537] Fix | Delete

'val' => '%' . esc_sql( $filters['message'] ) . '%',

[538] Fix | Delete

);

[539] Fix | Delete

}

[540] Fix | Delete

[541] Fix | Delete

if ( 0 < count( $criteria ) ) {

[542] Fix | Delete

$query .= "\nWHERE\n";

[543] Fix | Delete

[544] Fix | Delete

$first = true;

[545] Fix | Delete

foreach ( $criteria as $c ) {

[546] Fix | Delete

if ( ! $first ) {

[547] Fix | Delete

$query .= "AND\n";

[548] Fix | Delete

}

[549] Fix | Delete

[550] Fix | Delete

if ( is_array( $c['val'] ) ) {

[551] Fix | Delete

$operator = 'IN';

[552] Fix | Delete

[553] Fix | Delete

for ( $i = 0, $len = count( $c['val'] ); $i < $len; $i ++ ) {

[554] Fix | Delete

$c['val'][ $i ] = "'" . esc_sql( $c['val'][ $i ] ) . "'";

[555] Fix | Delete

}

[556] Fix | Delete

[557] Fix | Delete

$val = '(' . implode( ',', $c['val'] ) . ')';

[558] Fix | Delete

} else {

[559] Fix | Delete

$operator = ! empty( $c['op'] ) ? $c['op'] : '=';

[560] Fix | Delete

$val = "'" . esc_sql( $c['val'] ) . "'";

[561] Fix | Delete

}

[562] Fix | Delete

[563] Fix | Delete

$query .= "`{$c['col']}` {$operator} {$val}\n";

[564] Fix | Delete

[565] Fix | Delete

$first = false;

[566] Fix | Delete

}

[567] Fix | Delete

}

[568] Fix | Delete

}

[569] Fix | Delete

[570] Fix | Delete

if ( ! is_array( $order ) ) {

[571] Fix | Delete

$order = array(

[572] Fix | Delete

'col' => 'id',

[573] Fix | Delete

'order' => 'desc'

[574] Fix | Delete

);

[575] Fix | Delete

}

[576] Fix | Delete

[577] Fix | Delete

$query .= " ORDER BY {$order['col']} {$order['order']} LIMIT {$offset},{$limit}";

[578] Fix | Delete

[579] Fix | Delete

return $query;

[580] Fix | Delete

}

[581] Fix | Delete

[582] Fix | Delete

/**

[583] Fix | Delete

* Load logs from DB.

[584] Fix | Delete

[585] Fix | Delete

* @author Vova Feldman (@svovaf)

[586] Fix | Delete

* @since 1.2.1.6

[587] Fix | Delete

[588] Fix | Delete

* @param bool $filters

[589] Fix | Delete

* @param int $limit

[590] Fix | Delete

* @param int $offset

[591] Fix | Delete

* @param bool $order

[592] Fix | Delete

[593] Fix | Delete

* @return object[]|null

[594] Fix | Delete

[595] Fix | Delete

public static function load_db_logs(

[596] Fix | Delete

$filters = false,

[597] Fix | Delete

$limit = 200,

[598] Fix | Delete

$offset = 0,

[599] Fix | Delete

$order = false

[600] Fix | Delete

) {

[601] Fix | Delete

global $wpdb;

[602] Fix | Delete

[603] Fix | Delete

$query = self::build_db_logs_query(

[604] Fix | Delete

$filters,

[605] Fix | Delete

$limit,

[606] Fix | Delete

$offset,

[607] Fix | Delete

$order

[608] Fix | Delete

);

[609] Fix | Delete

[610] Fix | Delete

return $wpdb->get_results( $query );

[611] Fix | Delete

}

[612] Fix | Delete

[613] Fix | Delete

/**

[614] Fix | Delete

* Load logs from DB.

[615] Fix | Delete

[616] Fix | Delete

* @author Vova Feldman (@svovaf)

[617] Fix | Delete

* @since 1.2.1.6

[618] Fix | Delete

[619] Fix | Delete

* @param bool $filters

[620] Fix | Delete

* @param string $filename

[621] Fix | Delete

* @param int $limit

[622] Fix | Delete

* @param int $offset

[623] Fix | Delete

* @param bool $order

[624] Fix | Delete

[625] Fix | Delete

* @return false|string File download URL or false on failure.

[626] Fix | Delete

[627] Fix | Delete

public static function download_db_logs(

[628] Fix | Delete

$filters = false,

[629] Fix | Delete

$filename = '',

[630] Fix | Delete

$limit = 10000,

[631] Fix | Delete

$offset = 0,

[632] Fix | Delete

$order = false

[633] Fix | Delete

) {

[634] Fix | Delete

global $wpdb;

[635] Fix | Delete

[636] Fix | Delete

$query = self::build_db_logs_query(

[637] Fix | Delete

$filters,

[638] Fix | Delete

$limit,

[639] Fix | Delete

$offset,

[640] Fix | Delete

$order,

[641] Fix | Delete

true

[642] Fix | Delete

);

[643] Fix | Delete

[644] Fix | Delete

$upload_dir = wp_upload_dir();

[645] Fix | Delete

if ( empty( $filename ) ) {

[646] Fix | Delete

$filename = 'fs-logs-' . date( 'Y-m-d_H-i-s', WP_FS__SCRIPT_START_TIME ) . '.csv';

[647] Fix | Delete

}

[648] Fix | Delete

$filepath = rtrim( $upload_dir['path'], '/' ) . "/{$filename}";

[649] Fix | Delete

[650] Fix | Delete

$query .= " INTO OUTFILE '{$filepath}' FIELDS TERMINATED BY '\t' ESCAPED BY '\\\\' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\\n'";

[651] Fix | Delete

[652] Fix | Delete

$columns = '';

[653] Fix | Delete

for ( $i = 0, $len = count( self::$_log_columns ); $i < $len; $i ++ ) {

[654] Fix | Delete

if ( $i > 0 ) {

[655] Fix | Delete

$columns .= ', ';

[656] Fix | Delete

}

[657] Fix | Delete

[658] Fix | Delete

$columns .= "'" . self::$_log_columns[ $i ] . "'";

[659] Fix | Delete

}

[660] Fix | Delete

[661] Fix | Delete

$query = "SELECT {$columns} UNION ALL " . $query;

[662] Fix | Delete

[663] Fix | Delete

$result = $wpdb->query( $query );

[664] Fix | Delete

[665] Fix | Delete

if ( false === $result ) {

[666] Fix | Delete

return false;

[667] Fix | Delete

}

[668] Fix | Delete

[669] Fix | Delete

return rtrim( $upload_dir['url'], '/' ) . '/' . $filename;

[670] Fix | Delete

}

[671] Fix | Delete

[672] Fix | Delete

/**

[673] Fix | Delete

* @author Vova Feldman (@svovaf)

[674] Fix | Delete

* @since 1.2.1.6

[675] Fix | Delete

[676] Fix | Delete

* @param string $filename

[677] Fix | Delete

[678] Fix | Delete

* @return string

[679] Fix | Delete

[680] Fix | Delete

public static function get_logs_download_url( $filename = '' ) {

[681] Fix | Delete

$upload_dir = wp_upload_dir();

[682] Fix | Delete

if ( empty( $filename ) ) {

[683] Fix | Delete

$filename = 'fs-logs-' . date( 'Y-m-d_H-i-s', WP_FS__SCRIPT_START_TIME ) . '.csv';

[684] Fix | Delete

}

[685] Fix | Delete

[686] Fix | Delete

return rtrim( $upload_dir['url'], '/' ) . $filename;

[687] Fix | Delete

}

[688] Fix | Delete

[689] Fix | Delete

#endregion

[690] Fix | Delete

}

[691] Fix | Delete

[692] Fix | Delete