Automator_DB_Handler_Triggers::get_meta( $meta_key,  $trigger_id,  $trigger_log_id, int|null $user_id = null )

Contents

Parameters Parameters

$meta_key

(Required)

$trigger_id

(Required)

$trigger_log_id

(Required)

$user_id

(Optional)

Default value: null

Top ↑

Return Return

(mixed|string)

Source Source

File: src/core/lib/utilities/db/class-automator-db-handler-triggers.php 

	public function get_meta( string $meta_key, int $trigger_id, int $trigger_log_id, int $user_id = null ) {
		if ( empty( $meta_key ) || empty( $trigger_id ) || empty( $trigger_log_id ) ) {
			return '';
		}

		global $wpdb;
		$tbl        = Automator()->db->tables->trigger_meta;
		$meta_value = $wpdb->get_var(
			$wpdb->prepare(
			//phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
				"SELECT meta_value FROM {$wpdb->prefix}$tbl
						WHERE 1=1
						AND user_id = %d
						AND meta_key = %s
						AND automator_trigger_id = %d
						AND automator_trigger_log_id = %d
						LIMIT 0,1",
				$user_id,
				$meta_key,
				$trigger_id,
				$trigger_log_id
			)
		);

		if ( ! empty( $meta_value ) ) {
			return maybe_unserialize( $meta_value );
		}

		return '';
	}

Expand full source code Collapse full source code View on Github

Top ↑