'; $echo_str .= wfu_generate_dashboard_menu_title("\n\t"); if ( $message != '' ) { $echo_str .= "\n\t".'
'; $echo_str .= "\n\t\t".'

'.wfu_sanitize_simple_html($message).'

'; $echo_str .= "\n\t".'
'; } $echo_str .= "\n\t".'
'; $echo_str .= wfu_generate_dashboard_menu("\n\t\t", "Maintenance Actions"); //maintenance actions $echo_str .= "\n\t\t".'

'.esc_html__('Database Actions', 'wp-file-upload').'

'; $echo_str .= "\n\t\t".''; $echo_str .= "\n\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t".''; $echo_str .= "\n\t\t".'
'; $wfu_maintenance_nonce = wp_create_nonce("wfu_maintenance_actions"); $wfu_downloadfile_nonce = wp_create_nonce('wfu_download_file_invoker'); $echo_str .= "\n\t\t\t\t\t\t".''.esc_html__('Sync Database', 'wp-file-upload').''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t".''.esc_html__('Clean Log', 'wp-file-upload').''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t\t\t".''.esc_html__('Close', 'wp-file-upload').''; $echo_str .= "\n\t\t\t\t\t\t\t\t".''.esc_html__('Proceed', 'wp-file-upload').''; $echo_str .= "\n\t\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t".''.esc_html__('Purge All Data', 'wp-file-upload').''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".'
'; $echo_str .= "\n\t".'
'; //export actions $echo_str .= "\n\t".'
'; $echo_str .= "\n\t\t".'

'.esc_html__('Export Actions', 'wp-file-upload').'

'; $echo_str .= "\n\t\t".''; $echo_str .= "\n\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t".''; $echo_str .= "\n\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t".''.esc_html__('Export Uploaded File Data', 'wp-file-upload').''; $echo_str .= "\n\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".'
'; //debugging actions $debug_logging = ( isset($maintenance_options["debug_logging"]) ? $maintenance_options["debug_logging"] === true : false ); $echo_str .= "\n\t".'
'; $echo_str .= "\n\t\t".'

'.esc_html__('Debugging', 'wp-file-upload').'

'; $echo_str .= "\n\t\t".''; $echo_str .= "\n\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $debuglog_exists = file_exists(wfu_debug_log_filepath()); $debuglog_size = ( $debuglog_exists ? filesize(wfu_debug_log_filepath()) : 0 ); $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t".''; $echo_str .= "\n\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t".''.( $debug_logging ? esc_html__('Deactivate Debug Logging', 'wp-file-upload'): esc_html__('Activate Debug Logging', 'wp-file-upload') ).''; $echo_str .= "\n\t\t\t\t\t".''; if ( $debug_logging ) $echo_str .= "\n\t\t\t\t\t\t".''; else $echo_str .= "\n\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t".''.esc_html__('Download Debug Log Data', 'wp-file-upload').''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".'
'; $echo_str .= "\n\t\t\t\t\t\t".''.esc_html__('Reset Debug Log Data', 'wp-file-upload').''; $echo_str .= "\n\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t\t".''; $echo_str .= "\n\t\t\t\t\t".'
'; $echo_str .= "\n\t".'
'; $handler = 'function() { wfu_cleanlog_initialize_elements(); }'; $echo_str .= "\n\t".''; $echo_str .= "\n".'
'; return $echo_str; } /** * Check and Execute Database Synchronization. * * This function performs security checks whether database synchronization can * be executed and then executes this operation. * * @since 4.6.0 * * @param string $nonce A string that verifies that the request came from * Maintenance Actions page. * * @return int The number of records affected by synchronization. */ function wfu_sync_database_controller($nonce) { if ( !current_user_can( 'manage_options' ) ) return -1; $nonce = sanitize_text_field( wp_unslash ( $nonce ) ); if ( !wp_verify_nonce($nonce, 'wfu_maintenance_actions') ) return -1; return wfu_sync_database(); } /** * Prepare Data for Log Cleaning. * * This function prepares data for executing log cleaning operation. * * @since 4.6.0 * * @param string $data An encoded string containing information about what * records to clean. * * @return array An array containing log cleaning data. */ function wfu_clean_log_parse_data($data) { $ret = array( "result" => true ); $data_array = explode(":", $data); if ( count($data_array) == 0 ) $ret["result"] = false; elseif ( $data_array[0] == "00" || $data_array[0] == "01" ) { $ret["code"] = "0"; $ret["include_files"] = ( substr($data_array[0], 1, 1) == "1" ); if ( count($data_array) != 2 || strlen($data_array[1]) != 8 ) $ret["result"] = false; else { $ret["dateold"] = strtotime(substr($data_array[1], 0, 4)."-".substr($data_array[1], 4, 2)."-".substr($data_array[1], 6, 2)." 00:00"); if ( $ret["dateold"] > time() ) $ret["result"] = false; } } elseif ( $data_array[0] == "10" || $data_array[0] == "11" ) { $ret["code"] = "1"; $ret["include_files"] = ( substr($data_array[0], 1, 1) == "1" ); if ( count($data_array) != 3 ) $ret["result"] = false; else { $ret["periodold"] = (int)$data_array[1]; if ( $ret["periodold"] <= 0 ) $ret["result"] = false; elseif ( $data_array[2] == 'd' ) $ret["periodtype"] = 'days'; elseif ( $data_array[2] == 'm' ) $ret["periodtype"] = 'months'; elseif ( $data_array[2] == 'y' ) $ret["periodtype"] = 'years'; else $ret["result"] = false; } } elseif ( $data_array[0] == "20" || $data_array[0] == "21" ) { $ret["code"] = "2"; $ret["include_files"] = ( substr($data_array[0], 1, 1) == "1" ); if ( count($data_array) != 3 || strlen($data_array[1]) != 8 || strlen($data_array[2]) != 8 ) $ret["result"] = false; $ret["datefrom"] = strtotime(substr($data_array[1], 0, 4)."-".substr($data_array[1], 4, 2)."-".substr($data_array[1], 6, 2)." 00:00"); if ( $ret["datefrom"] > time() ) $ret["result"] = false; else { $ret["dateto"] = strtotime(substr($data_array[2], 0, 4)."-".substr($data_array[2], 4, 2)."-".substr($data_array[2], 6, 2)." 00:00"); if ( $ret["dateto"] > $ret["datefrom"] ) $ret["result"] = false; } } elseif ( $data_array[0] == "30" || $data_array[0] == "31" ) { $ret["code"] = "3"; $ret["include_files"] = ( substr($data_array[0], 1, 1) == "1" ); if ( count($data_array) != 1 ) $ret["result"] = false; } else $ret["result"] = false; return $ret; } /** * Prepare Query for Log Cleaning. * * This function prepares the SQL WHERE clause of the query for log cleaning. * * @since 4.9.1 * * @param array $data An array containing log cleaning data. * * @return string An SQL WHERE clause that defines which database records will * be affected by log cleaning operation. */ function wfu_clean_log_where_query($data) { $query = ""; if ( $data["code"] == "0" ) $query = " WHERE date_from < '".date('Y-m-d H:i:s', $data["dateold"])."'"; elseif ( $data["code"] == "1" ) { $date = strtotime(date('Y-m-d', strtotime('-'.$data["periodold"].' '.$data["periodtype"]))." 00:00"); $query = " WHERE date_from < '".date('Y-m-d H:i:s', $date)."'"; } elseif ( $data["code"] == "2" ) $query = " WHERE date_from < '".date('Y-m-d H:i:s', $data["datefrom"] + 86400)."' AND date_from >= '".date('Y-m-d H:i:s', $data["dateto"])."'"; return $query; } /** * Confirm Log Cleaning Operation. * * This function shows a page to confirm log cleaning operation. * * @since 3.3.1 * * @param string $nonce A string that verifies that the request came from * Maintenance Actions page. * @param string $data_enc An encoded string containing information about what * records to clean. * * @return string The HTML code of the confirmation page. */ function wfu_clean_log_prompt($nonce, $data_enc) { global $wpdb; $table_name1 = $wpdb->prefix . "wfu_log"; $siteurl = site_url(); $nonce = sanitize_text_field( wp_unslash ( $nonce ) ); if ( !current_user_can( 'manage_options' ) || !wp_verify_nonce($nonce, 'wfu_maintenance_actions') ) return wfu_maintenance_actions(); //parse data $admin_nonce = wp_create_nonce('wfu_admin_nonce'); $data = wfu_clean_log_parse_data(sanitize_text_field($data_enc)); if ( $data["result"] == false ) return wfu_maintenance_actions(); $echo_str = "\n".'
'; $echo_str .= "\n\t".'
'; $echo_str .= "\n\t\t".''.esc_html__('Go back', 'wp-file-upload').''; $echo_str .= "\n\t".'
'; $echo_str .= "\n\t".'

'.esc_html__('Clean Database Log', 'wp-file-upload').'

'; $echo_str .= "\n\t".'
'; $nonce = wp_nonce_field('wfu_clean_log', '_wpnonce', false, false); $nonce_ref = wp_referer_field(false); $echo_str .= "\n\t\t".$nonce; $echo_str .= "\n\t\t".$nonce_ref; $echo_str .= "\n\t\t".''; $echo_str .= "\n\t\t".''; $echo_str .= "\n\t\t".''; if ( $data["include_files"] ) { if ( $data["code"] == "0" ) $echo_str .= "\n\t\t".'
'; elseif ( $data["code"] == "1" ) $echo_str .= "\n\t\t".'
'; elseif ( $data["code"] == "2" ) $echo_str .= "\n\t\t".'
'; else $echo_str .= "\n\t\t".'
'; $affected_recs = $wpdb->get_results("SELECT * FROM $table_name1".wfu_clean_log_where_query($data)); $affected_files = wfu_get_valid_affected_files($affected_recs); $echo_str .= "\n\t\t".'
'; $echo_str .= "\n\t\t\t".'
'; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t".'
'; $echo_str .= "\n\t\t\t".'
'; $echo_str .= "\n\t\t\t\t".''; $echo_str .= "\n\t\t\t".'
'; $echo_str .= "\n\t\t".'
'; $echo_str .= "\n\t\t".'

'; $echo_str .= "\n\t\t".''; } else { if ( $data["code"] == "0" ) $echo_str .= "\n\t\t".'
'; elseif ( $data["code"] == "1" ) $echo_str .= "\n\t\t".'
'; elseif ( $data["code"] == "2" ) $echo_str .= "\n\t\t".'
'; else $echo_str .= "\n\t\t".'
'; } $echo_str .= "\n\t\t".'

'; $echo_str .= "\n\t\t\t".''; $echo_str .= "\n\t\t\t".''; $echo_str .= "\n\t\t".'

'; $echo_str .= "\n\t".'
'; $echo_str .= "\n".'
'; return $echo_str; } /** * Execute Log Cleaning. * * This function cleans the database log based on criteria selected by the * admin. * * @since 3.3.1 * * @redeclarable * * @return array An array containing the number of records and files affected by * cleaning operation. */ function wfu_clean_log() { $a = func_get_args(); $a = WFU_FUNCTION_HOOK(__FUNCTION__, $a, $out); if (isset($out['vars'])) foreach($out['vars'] as $p => $v) $$p = $v; switch($a) { case 'R': return $out['output']; break; case 'D': die($out['output']); } global $wpdb; if ( !current_user_can( 'manage_options' ) ) return array( "recs_count" => -1, "files_count" => -1 ); if ( !check_admin_referer('wfu_clean_log') ) return array( "recs_count" => -1, "files_count" => -1 ); $recs_count = 0; $files_count = 0; if ( isset($_POST['data']) && isset($_POST['submit']) && $_POST['submit'] == "Yes" ) { $data = wfu_clean_log_parse_data(sanitize_text_field($_POST['data'])); if ( $data["result"] ) { $table_name1 = $wpdb->prefix . "wfu_log"; $table_name2 = $wpdb->prefix . "wfu_userdata"; //$table_name3 = $wpdb->prefix . "wfu_dbxqueue"; $affected_files = array(); if ( $data["include_files"] ) { $affected_recs = $wpdb->get_results("SELECT * FROM $table_name1".wfu_clean_log_where_query($data)); $affected_files = wfu_get_valid_affected_files($affected_recs); } $query1 = "DELETE FROM $table_name1"; $query2 = "DELETE FROM $table_name2"; //$query3 = "DELETE FROM $table_name3"; if ( $data["code"] == "0" ) { $query1 .= " WHERE date_from < '".date('Y-m-d H:i:s', $data["dateold"])."'"; $query2 .= " WHERE date_from < '".date('Y-m-d H:i:s', $data["dateold"])."'"; } elseif ( $data["code"] == "1" ) { $date = strtotime(date('Y-m-d', strtotime('-'.$data["periodold"].' '.$data["periodtype"]))." 00:00"); $query1 .= " WHERE date_from < '".date('Y-m-d H:i:s', $date)."'"; $query2 .= " WHERE date_from < '".date('Y-m-d H:i:s', $date)."'"; } elseif ( $data["code"] == "2" ) { $query1 .= " WHERE date_from < '".date('Y-m-d H:i:s', $data["datefrom"] + 86400)."' AND date_from >= '".date('Y-m-d H:i:s', $data["dateto"])."'"; $query2 .= " WHERE date_from < '".date('Y-m-d H:i:s', $data["datefrom"] + 86400)."' AND date_from >= '".date('Y-m-d H:i:s', $data["dateto"])."'"; } $recs_count = $wpdb->query($query1); $recs_count += $wpdb->query($query2); //$recs_count += $wpdb->query($query3); //delete affected files foreach( $affected_files as $file ) { wfu_unlink($file, "wfu_clean_log"); if ( !wfu_file_exists($file, "wfu_clean_log") ) $files_count ++; } } } return array( "recs_count" => $recs_count, "files_count" => $files_count ); } /** * Confirm Purge of Data Operation. * * This function shows a page to confirm purge of data operation. Purge * operation deletes all plugin data from the website. * * @since 4.9.1 * * @param string $nonce A string that verifies that the request came from * Maintenance Actions page. * * @return string The HTML code of the confirmation page. */ function wfu_purge_data_prompt($nonce) { $siteurl = site_url(); $nonce = sanitize_text_field( wp_unslash ( $nonce ) ); if ( !current_user_can( 'manage_options' ) || !wp_verify_nonce($nonce, 'wfu_maintenance_actions') ) return wfu_maintenance_actions(); $admin_nonce = wp_create_nonce('wfu_admin_nonce'); $echo_str = "\n".'
'; $echo_str .= "\n\t".'
'; $echo_str .= "\n\t\t".''.esc_html__('Go back', 'wp-file-upload').''; $echo_str .= "\n\t".'
'; $echo_str .= "\n\t".'

'.esc_html__('Purge All Data', 'wp-file-upload').'

'; $echo_str .= "\n\t".'
'; $nonce = wp_nonce_field('wfu_purge_data', '_wpnonce', false, false); $nonce_ref = wp_referer_field(false); $echo_str .= "\n\t\t".$nonce; $echo_str .= "\n\t\t".$nonce_ref; $echo_str .= "\n\t\t".''; $echo_str .= "\n\t\t".''; $echo_str .= "\n\t\t".'
'; $echo_str .= "\n\t\t".'

'; $echo_str .= "\n\t\t".'

'; $echo_str .= "\n\t\t\t".''; $echo_str .= "\n\t\t\t".''; $echo_str .= "\n\t\t".'

'; $echo_str .= "\n\t".'
'; $echo_str .= "\n".'
'; return $echo_str; } /** * Purge Plugin Data. * * This function deletes all plugin data from the website. It drops the tables * of the plugin from the database, it deletes all plugin options and all plugin * data stored in session and removes all notifications from comments db. * * @since 4.9.1 * * @redeclarable * * @return bool Always true. */ function wfu_purge_data() { $a = func_get_args(); $a = WFU_FUNCTION_HOOK(__FUNCTION__, $a, $out); if (isset($out['vars'])) foreach($out['vars'] as $p => $v) $$p = $v; switch($a) { case 'R': return $out['output']; break; case 'D': die($out['output']); } global $wpdb; if ( !current_user_can( 'manage_options' ) ) return; if ( !check_admin_referer('wfu_purge_data') ) return; if ( isset($_POST['submit']) && $_POST['submit'] == "Yes" ) { $all_options = array_keys(wp_load_alloptions()); $all_session = ( isset($_SESSION) ? array_keys($_SESSION) : array() ); $wfu_options = wfu_get_all_plugin_options(); //first delete relevant db options foreach ( $all_options as $opt1 ) foreach ( $wfu_options as $opt2 ) if ( $opt2[2] && $opt2[1] == "db" ) { if (( substr($opt2[0], 0, 1) != "*" && substr($opt2[0], -1) != "*" && $opt1 == $opt2[0] ) || ( substr($opt2[0], 0, 1) != "*" && substr($opt2[0], -1) == "*" && substr($opt1, 0, strlen($opt2[0])) == substr($opt2[0], 0, -1) ) || ( substr($opt2[0], 0, 1) == "*" && substr($opt2[0], -1) != "*" && substr($opt1, -strlen($opt2[0])) == substr($opt2[0], 1) ) || ( substr($opt2[0], 0, 1) == "*" && substr($opt2[0], -1) == "*" && strpos($opt1, substr($opt2[0], 1, -1)) !== false )) delete_option($opt1); } //then delete relevant session data foreach ( $all_session as $opt1 ) foreach ( $wfu_options as $opt2 ) if ( $opt2[2] && $opt2[1] == "session" ) { if (( substr($opt2[0], 0, 1) != "*" && substr($opt2[0], -1) != "*" && $opt1 == $opt2[0] ) || ( substr($opt2[0], 0, 1) != "*" && substr($opt2[0], -1) == "*" && substr($opt1, 0, strlen($opt2[0])) == substr($opt2[0], 0, -1) ) || ( substr($opt2[0], 0, 1) == "*" && substr($opt2[0], -1) != "*" && substr($opt1, -strlen($opt2[0])) == substr($opt2[0], 1) ) || ( substr($opt2[0], 0, 1) == "*" && substr($opt2[0], -1) == "*" && strpos($opt1, substr($opt2[0], 1, -1)) !== false )) unset($_SESSION[$opt1]); } //then delete relevant tables $wpdb->query( "DROP TABLE IF EXISTS ".$wpdb->prefix."wfu_log" ); $wpdb->query( "DROP TABLE IF EXISTS ".$wpdb->prefix."wfu_userdata" ); $wpdb->query( "DROP TABLE IF EXISTS ".$wpdb->prefix."wfu_dbxqueue" ); //then delete all notifications $wpdb->query( "DELETE FROM ".$wpdb->prefix."commentmeta WHERE comment_id IN (SELECT comment_ID FROM ".$wpdb->prefix."comments WHERE comment_type = 'wfunotification')" ); $wpdb->query( "DELETE FROM ".$wpdb->prefix."comments WHERE comment_type = 'wfunotification'" ); //then deactivate the plugin deactivate_plugins( plugin_basename( WPFILEUPLOAD_PLUGINFILE ) ); } else return; return true; } /** * Update File Transfers. * * This function causes the file transfers manager to re-check the pending file * tranfers immediately. * * @since 4.6.0 * * @redeclarable * * @param bool $clearfiles Optional. If it is true then all pending file * transfers will be cleared. */ function wfu_process_all_transfers($clearfiles = false) { $a = func_get_args(); $a = WFU_FUNCTION_HOOK(__FUNCTION__, $a, $out); if (isset($out['vars'])) foreach($out['vars'] as $p => $v) $$p = $v; switch($a) { case 'R': return $out['output']; break; case 'D': die($out['output']); } global $wpdb; if ( $clearfiles ) { $table_name1 = $wpdb->prefix . "wfu_log"; $table_name3 = $wpdb->prefix . "wfu_dbxqueue"; $wpdb->query('DELETE FROM '.$table_name3); } wfu_schedule_transfermanager(true); } /** * Check and Execute Reset of File Transfers. * * This function performs security checks whether reset of file transfers can be * executed and then executes this operation. * * @since 4.6.0 * * @param string $nonce A string that verifies that the request came from * Maintenance Actions page. * * @return bool Always true. */ function wfu_reset_all_transfers_controller($nonce) { if ( !current_user_can( 'manage_options' ) ) return false; $nonce = sanitize_text_field( wp_unslash ( $nonce ) ); if ( !wp_verify_nonce($nonce, 'wfu_maintenance_actions') ) return false; wfu_process_all_transfers(); return true; } /** * Check and Execute Clear of File Transfers. * * This function performs security checks whether clear of file transfers can be * executed and then executes this operation. * * @since 4.6.0 * * @param string $nonce A string that verifies that the request came from * Maintenance Actions page. * * @return bool Always true. */ function wfu_clear_all_transfers_controller($nonce) { if ( !current_user_can( 'manage_options' ) ) return false; $nonce = sanitize_text_field( wp_unslash ( $nonce ) ); if ( !wp_verify_nonce($nonce, 'wfu_maintenance_actions') ) return false; wfu_process_all_transfers(true); return true; } /** * Toggle Debug Logging. * * This function activates or deactivate debug logging. * * @since 4.24.2 * * @param bool $status The new status of debug logging, true or false. * @param string $nonce A string that verifies that the request came from * Maintenance Actions page. */ function wfu_toggle_debug_logging($status, $nonce) { if ( !current_user_can( 'manage_options' ) ) return false; $nonce = sanitize_text_field( wp_unslash ( $nonce ) ); if ( !wp_verify_nonce($nonce, 'wfu_maintenance_actions') ) return false; $maintenance_options = get_option( "wfu_maintenance_options", array() ); if ( $status === true ) $maintenance_options["debug_logging"] = true; elseif ( $status === false ) $maintenance_options["debug_logging"] = false; else return; wfu_update_option( "wfu_maintenance_options", $maintenance_options ); } /** * Reset Debug Log Data. * * This function clears the contents of debug log file, if it exists. * * @since 4.24.2 * * @param string $nonce A string that verifies that the request came from * Maintenance Actions page. */ function wfu_reset_debuglog_data($nonce) { if ( !current_user_can( 'manage_options' ) ) return false; $nonce = sanitize_text_field( wp_unslash ( $nonce ) ); if ( !wp_verify_nonce($nonce, 'wfu_maintenance_actions') ) return false; $logfile = wfu_debug_log_filepath(); if ( !file_exists($logfile) ) return; file_put_contents($logfile, ""); } /** * Remove Waste Items From Options. * * This function retrieves any waste options and removes them. Waste options are * plugin options stored in Wordpress options table that are no longer used. * * @since 4.24.14 * * @redeclarable */ function wfu_remove_waste_items_from_options() { $a = func_get_args(); $a = WFU_FUNCTION_HOOK(__FUNCTION__, $a, $out); if (isset($out['vars'])) foreach($out['vars'] as $p => $v) $$p = $v; switch($a) { case 'R': return $out['output']; break; case 'D': die($out['output']); } $waste = wfu_update_waste_options(); $affected = wfu_process_waste($waste); $message = ( $affected <= 0 ? __('No items affected', 'wp-file-upload') : sprintf(_n('%s item affected', '%s items affected', $affected, 'wp-file-upload'), $affected) ); wfu_add_admin_notification(__('Completed cleaning database periodic action.', 'wp-file-upload').' '.$message, 'info', 'db_cleaning', __('Plugin maintenance.', 'wp-file-upload'), null, true); } /** * Update Waste Options. * * This function returns any waste options that need to be processed and it also * collects any new waste options that need to be processed in the future. * * Waste options are not processed immediately but after an amount of time. This * happens in order to ensure that they are no longer used. Such a case is * "wfu_queue_*" options. We do not know which of them are still used by running * upload scripts. For this reason, we collect and store a current list of them. * After a certain period of time, when we are certain that they are no longer * used (e.g. after 4 days, when session has surely expired), we retrieve the * list and we remove them. * * @since 4.24.14 * * @redeclarable * * @global object $wpdb The database object. * * @return array An array of waste items that need to be processed. */ function wfu_update_waste_options() { $a = func_get_args(); $a = WFU_FUNCTION_HOOK(__FUNCTION__, $a, $out); if (isset($out['vars'])) foreach($out['vars'] as $p => $v) $$p = $v; switch($a) { case 'R': return $out['output']; break; case 'D': die($out['output']); } global $wpdb; $table_name1 = $wpdb->prefix . "options"; $ret = array(); $maintenance_options = get_option( "wfu_maintenance_options", array() ); $waste_options = wfu_arr_get_array_item($maintenance_options, "waste_options"); $now = time(); $changed = false; // process wfu_queue items $wfu_queue_waste = wfu_arr_get_array_item($waste_options, "wfu_queue"); // get $process_time to check if there are any waste items that are ready // to be processed provided that process time has passed $process_time = ( isset($wfu_queue_waste["process_time"]) ? intval($wfu_queue_waste["process_time"]) : 0 ); if ( $process_time > 0 && $now >= $process_time ) { $items = ( isset($wfu_queue_waste["items"]) ? trim($wfu_queue_waste["items"]) : "" ); // if there are waste items then add then to the return list and clear // $waste_options if ( !empty($items) ) { $ret["wfu_queue"] = $items; } $waste_options["wfu_queue"] = array( "process_time" => 0, "items" => "" ); $changed = true; } // get again any waste items from the database provided that any previous // waste has been processed if ( $process_time <= 0 || $now >= $process_time ) { $limit = intval(WFU_VAR("WFU_WASTE_BATCHSIZE")); $limit = ( $limit == 0 ? 500 : $limit ); $items = $wpdb->get_var( $wpdb->prepare( "SELECT GROUP_CONCAT(option_id ORDER BY option_id SEPARATOR ',') FROM $table_name1 WHERE option_name LIKE 'wfu_queue_%' LIMIT %d", $limit ) ); if ( $items !== null && !empty($items) ) { $process_after = intval(WFU_VAR("WFU_UPLOADWASTE_PROCESSAFTER")); $process_after = ( $process_after == 0 ? 4 : $process_after ) * 86400; $waste_options["wfu_queue"] = array( "process_time" => $now + $process_after, "items" => $items ); $changed = true; } } // update wfu_maintenance_options if changes have been done if ( $changed ) { $maintenance_options["waste_options"] = $waste_options; wfu_update_option( "wfu_maintenance_options", $maintenance_options ); } return $ret; } /** * Process Waste Items. * * This function removes a list of waste items from the database. * * @since 4.24.14 * * @redeclarable * * @global object $wpdb The database object. * * @param array $waste The waste items. * @return integer The number of items removed from the database. */ function wfu_process_waste($waste) { $a = func_get_args(); $a = WFU_FUNCTION_HOOK(__FUNCTION__, $a, $out); if (isset($out['vars'])) foreach($out['vars'] as $p => $v) $$p = $v; switch($a) { case 'R': return $out['output']; break; case 'D': die($out['output']); } global $wpdb; $table_name1 = $wpdb->prefix . "options"; if ( !is_array($waste) || count($waste) == 0 ) return 0; $affected = 0; foreach ( $waste as $items ) { // we perform a validation of $items because we are using it directly // inside the query without $wpdb->prepare() if ( preg_match( "/[^[0-9,]/", $items ) === 0 ) { $affected += $wpdb->query("DELETE FROM $table_name1 WHERE option_id IN ($items)"); } } return $affected; }