Geforce File Manager

NAME	SIZE	ACTIONS
📄 BunnyWebhookUpgrade.php	2,694 B	[ EDIT ] \| [ DEL ]
📄 PerformanceUpgrade.php	590 B	[ EDIT ] \| [ DEL ]
📄 TransientsUpgrade.php	1,599 B	[ EDIT ] \| [ DEL ]
📄 Upgrades.php	274 B	[ EDIT ] \| [ DEL ]
📄 VisitsUpgrade.php	1,393 B	[ EDIT ] \| [ DEL ]

[ CLOSE ]

EDIT: VisitsUpgrade.php

<?php

namespace PrestoPlayer\Database\Upgrades;

use PrestoPlayer\Models\ReusableVideo;

class VisitsUpgrade {

protected $table;
	protected $version = 2;
	protected $name    = 'presto_player_visits_upgrade_version';

public function run() {
		$this->fixReusableVideoStats();
	}

/**
	 * Fixes error where reusable video ids were stored instead of video id
	 * in visits table
	 *
	 * @return void
	 */
	public function fixReusableVideoStats() {
		global $wpdb;

$current_version = get_option( $this->name, 0 );

// we've already done this one
		if ( $this->version <= $current_version ) {
			return;
		}

// get all reusable video ids
		$reusable_videos = get_posts(
			array(
				'posts_per_page' => -1,
				'post_type'      => 'pp_video_block',
			)
		);

// bail if we have no reusable videos
		if ( empty( $reusable_videos ) ) {
			return;
		}

// get visits with this id and update to video
		foreach ( $reusable_videos as $reusable_video ) {
			$video_block = new ReusableVideo( $reusable_video );
			$block       = $video_block->getBlock();

if ( ! empty( $block['attrs']['id'] ) ) {
				$id = $block['attrs']['id'];
				try {
					$wpdb->update( $wpdb->prefix . 'presto_player_visits', array( 'video_id' => $id ), array( 'video_id' => (int) $reusable_video->ID ) );
				} catch ( \Exception $e ) {
				}
			}
		}

update_option( $this->name, $this->version );
	}
}