File manager

ÿØÿà JFIF ÿÛ „ ( %!1!%*+...983,7(-.- File manager

File manager - Edit - /home/trueinxa/truelove4seniors.org/wp-content/plugins/give/src/Subscriptions/Migrations/AddCampaignId.php

Back
<?php namespace Give\Subscriptions\Migrations; use Give\Framework\Database\DB; use Give\Framework\Database\Exceptions\DatabaseQueryException; use Give\Framework\Migrations\Contracts\Migration; use Give\Framework\Migrations\Contracts\ReversibleMigration; use Give\Framework\Migrations\Exceptions\DatabaseMigrationException; /** * @since 4.11.0 / class AddCampaignId extends Migration implements ReversibleMigration { /* * @inheritDoc / public static function id(): string { return 'add_campaign_id_to_subscriptions'; } /* * @inheritDoc / public static function title(): string { return 'Add campaign id to subscriptions'; } /* * @inheritdoc / public static function timestamp(): string { return strtotime('2025-10-16 00:00:00'); } /* * @inheritDoc * * @throws DatabaseMigrationException / public function run() { try { $query = <<<SQL UPDATE %s AS subscriptions JOIN %s campaignForms ON subscriptions.product_id = campaignForms.form_id SET subscriptions.campaign_id = campaignForms.campaign_id SQL; DB::query(sprintf( $query, DB::prefix('give_subscriptions'), DB::prefix('give_campaign_forms') )); } catch (DatabaseQueryException $exception) { throw new DatabaseMigrationException("An error occurred while adding campaign ID to the give_subscriptions table", 0, $exception); } } /* * @inheritDoc */ public function reverse(): void { DB::table('give_subscriptions')->update(['campaign_id' => null]); } }