?HAMA

Edit File Size: 2.67 KB

/proc/self/root/home/nshryvcy/radiantskinclinics.org/wp-content/plugins/wpforms-lite/src/Migrations/Upgrade175.php

Text Base64

<?php

namespace WPForms\Migrations;

use WPForms\Tasks\Meta;
use WPForms\Tasks\Tasks;

/**
 * Class v1.7.5 upgrade.
 *
 * @since 1.7.5
 *
 * @noinspection PhpUnused
 */
class Upgrade175 extends UpgradeBase {

/**
	 * Delete all task meta of not active tasks.
	 *
	 * @since 1.7.5
	 *
	 * @noinspection ElvisOperatorCanBeUsedInspection
	 *
	 * @return bool|null Upgrade result:
	 *                   true  - the upgrade completed successfully,
	 *                   false - in the case of failure,
	 *                   null  - upgrade started but not yet finished (background task).
	 */
	public function run() {

global $wpdb;

if ( ! $this->as_tables_exist() ) {
			return true;
		}

$group = Tasks::GROUP;
		$sql   = "SELECT DISTINCT a.args FROM {$wpdb->prefix}actionscheduler_actions a
					JOIN {$wpdb->prefix}actionscheduler_groups g ON g.group_id = a.group_id
					WHERE g.slug = '$group' AND a.status IN ( 'pending', 'in-progress' )";

// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared
		$results = $wpdb->get_results( $sql, 'ARRAY_A' );
		// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared

$results  = $results ? $results : [];
		$meta_ids = [];

foreach ( $results as $result ) {
			$args = isset( $result['args'] ) ? json_decode( $result['args'], true ) : null;

if ( $args && ! empty( $args['tasks_meta_id'] ) ) {
				$meta_ids[] = $args['tasks_meta_id'];
			}
		}

$table_name = Meta::get_table_name();
		$not_in     = $meta_ids ? wpforms_wpdb_prepare_in( $meta_ids ) : '0';

// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.NoCaching
		$wpdb->query( "DELETE FROM $table_name WHERE id NOT IN ( $not_in )" );

// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.NoCaching

return true;
	}

/**
	 * Check whether AS tables exist.
	 *
	 * @since 1.7.6
	 *
	 * @return bool
	 */
	private function as_tables_exist() {

global $wpdb;

$required_tables = [
			$wpdb->prefix . 'actionscheduler_actions',
			$wpdb->prefix . 'actionscheduler_groups',
		];

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
		$tables    = $wpdb->get_col( "SHOW TABLES LIKE '{$wpdb->prefix}actionscheduler%'" );
		$intersect = array_values( array_intersect( $tables, $required_tables ) );

sort( $intersect );
		sort( $required_tables );

return $intersect === $required_tables;
	}
}

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Name	Size	Perms	Modified	Actions
Tasks DIR	-	drwxr-xr-x	2026-06-04 03:43:03	Edit Download recursive recursive
Base.php	12.04 KB	lrw-r--r--	2026-03-19 16:20:18	Edit Download recursive recursive
Migrations.php	992 B	lrw-r--r--	2025-12-11 20:10:08	Edit Download recursive recursive
Upgrade1_9_1.php	1.37 KB	lrw-r--r--	2024-09-26 15:36:36	Edit Download recursive recursive
Upgrade1_9_2.php	911 B	lrw-r--r--	2024-11-07 17:15:50	Edit Download recursive recursive
Upgrade1_9_7.php	333 B	lrw-r--r--	2025-08-11 13:38:06	Edit Download recursive recursive
Upgrade1_9_8_6.php	2.74 KB	lrw-r--r--	2025-12-11 20:10:08	Edit Download recursive recursive
Upgrade159.php	707 B	lrw-r--r--	2024-09-26 15:36:36	Edit Download recursive recursive
Upgrade168.php	1.24 KB	lrw-r--r--	2024-09-26 15:36:36	Edit Download recursive recursive
Upgrade175.php	2.67 KB	lrw-r--r--	2024-09-26 15:36:36	Edit Download recursive recursive
Upgrade177.php	1.21 KB	lrw-r--r--	2022-09-29 15:18:52	Edit Download recursive recursive
Upgrade182.php	3.10 KB	lrw-r--r--	2025-12-11 20:10:08	Edit Download recursive recursive
Upgrade183.php	769 B	lrw-r--r--	2023-08-10 15:19:36	Edit Download recursive recursive
Upgrade184.php	909 B	lrw-r--r--	2023-09-28 15:44:58	Edit Download recursive recursive
Upgrade186.php	395 B	lrw-r--r--	2024-01-16 17:57:58	Edit Download recursive recursive
Upgrade187.php	1.35 KB	lrw-r--r--	2024-09-26 15:36:36	Edit Download recursive recursive
Upgrade1672.php	863 B	lrw-r--r--	2022-06-30 15:09:42	Edit Download recursive recursive
Upgrade1751.php	562 B	lrw-r--r--	2022-08-18 14:59:52	Edit Download recursive recursive
UpgradeBase.php	3.43 KB	lrw-r--r--	2025-04-24 14:53:30	Edit Download recursive recursive

Directory Contents