BunnyWebhookUpgrade.php
4 months ago
OnboardingBackfillUpgrade.php
1 month ago
PerformanceUpgrade.php
1 year ago
TransientsUpgrade.php
3 weeks ago
Upgrades.php
1 month ago
VisitsUpgrade.php
1 year ago
VisitsUpgrade.php
63 lines
| 1 | <?php |
| 2 | |
| 3 | namespace PrestoPlayer\Database\Upgrades; |
| 4 | |
| 5 | use PrestoPlayer\Models\ReusableVideo; |
| 6 | |
| 7 | class VisitsUpgrade { |
| 8 | |
| 9 | protected $table; |
| 10 | protected $version = 2; |
| 11 | protected $name = 'presto_player_visits_upgrade_version'; |
| 12 | |
| 13 | public function run() { |
| 14 | $this->fixReusableVideoStats(); |
| 15 | } |
| 16 | |
| 17 | /** |
| 18 | * Fixes error where reusable video ids were stored instead of video id |
| 19 | * in visits table |
| 20 | * |
| 21 | * @return void |
| 22 | */ |
| 23 | public function fixReusableVideoStats() { |
| 24 | global $wpdb; |
| 25 | |
| 26 | $current_version = get_option( $this->name, 0 ); |
| 27 | |
| 28 | // we've already done this one |
| 29 | if ( $this->version <= $current_version ) { |
| 30 | return; |
| 31 | } |
| 32 | |
| 33 | // get all reusable video ids |
| 34 | $reusable_videos = get_posts( |
| 35 | array( |
| 36 | 'posts_per_page' => -1, |
| 37 | 'post_type' => 'pp_video_block', |
| 38 | ) |
| 39 | ); |
| 40 | |
| 41 | // bail if we have no reusable videos |
| 42 | if ( empty( $reusable_videos ) ) { |
| 43 | return; |
| 44 | } |
| 45 | |
| 46 | // get visits with this id and update to video |
| 47 | foreach ( $reusable_videos as $reusable_video ) { |
| 48 | $video_block = new ReusableVideo( $reusable_video ); |
| 49 | $block = $video_block->getBlock(); |
| 50 | |
| 51 | if ( ! empty( $block['attrs']['id'] ) ) { |
| 52 | $id = $block['attrs']['id']; |
| 53 | try { |
| 54 | $wpdb->update( $wpdb->prefix . 'presto_player_visits', array( 'video_id' => $id ), array( 'video_id' => (int) $reusable_video->ID ) ); |
| 55 | } catch ( \Exception $e ) { |
| 56 | } |
| 57 | } |
| 58 | } |
| 59 | |
| 60 | update_option( $this->name, $this->version ); |
| 61 | } |
| 62 | } |
| 63 |