includes/admin/upgrades.php ➔ ppp_v22_postmeta_upgrade()

Complexity

Conditions	23
Paths	5384

Size

Total Lines

113

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function ppp_v22_postmeta_upgrade() {

	if( ! current_user_can( PostPromoterPro::get_manage_capability() ) ) {
		wp_die( __( 'You do not have permission to do upgrades', 'ppp-txt' ), __( 'Error', 'ppp-txt' ), array( 'response' => 403 ) );
	}

	ignore_user_abort( true );

	global $wpdb;


	$step   = isset( $_GET['step'] ) ? absint( $_GET['step'] ) : 1;
	$number = 25;
	$offset = $step == 1 ? 0 : ( $step - 1 ) * $number;

	if ( $step < 2 ) {
		// Check if we have any payments before moving on
		$sql = "SELECT post_id FROM $wpdb->postmeta WHERE meta_key = '_ppp_post_override_data' LIMIT 1";
		$has_overrides = $wpdb->get_col( $sql );

		if( empty( $has_overrides ) ) {
			// We had no payments, just complete
			update_option( 'ppp_version', preg_replace( '/[^0-9.].*/', '', PPP_VERSION ) );
			ppp_set_upgrade_complete( 'upgrade_post_meta' );
			delete_option( 'ppp_doing_upgrade' );
			wp_redirect( admin_url() ); exit;
		}
	}

	$total = isset( $_GET['total'] ) ? absint( $_GET['total'] ) : false;

	if ( empty( $total ) || $total <= 1 ) {
		$total_sql = "SELECT COUNT(post_id) as total FROM $wpdb->postmeta WHERE meta_key = '_ppp_post_override_data'";
		$results   = $wpdb->get_row( $total_sql, 0 );

		$total     = $results->total;
	}

	$results       = $wpdb->get_results( $wpdb->prepare( "SELECT post_id, meta_value FROM $wpdb->postmeta WHERE meta_key = '_ppp_post_override_data' ORDER BY meta_id DESC LIMIT %d,%d;", $offset, $number ) );
	$new_post_meta = array();

	if ( $results ) {
		foreach ( $results as $result ) {

			$share_key     = 1;

			$override_data = unserialize( $result->meta_value );

			foreach ( $override_data as $day => $values ) {

				if ( ! isset( $values['enabled'] ) ) {
					continue;
				}

				$text = ! empty( $values['text'] ) ? $values['text'] : '';
				$time = ! empty( $values['time'] ) ? $values['time'] : '8:00am';

				$post          = get_post( $result->post_id );
				$days_ahead    = substr( $day, -1 );
				$date          = date( 'm\/d\/Y', strtotime( $post->post_date . '+' . $days_ahead . ' days' ) );
				$image         = '';
				$attachment_id = '';

				if ( ! empty( $values['use_image'] ) ) {
					$thumb_id  = get_post_thumbnail_id( $result->post_id );
					$thumb_url = wp_get_attachment_image_src( $thumb_id, 'ppp-tw-share-image', true );

					if ( isset( $thumb_url[0] ) && ! empty( $thumb_url[0] ) && !strpos( $thumb_url[0], 'wp-includes/images/media/default.png' ) ) {
						$thumb_url = $thumb_url[0];
					}

					if ( ! empty( $thumb_id ) && ! empty( $thumb_url ) ) {
						$attachment_id = $thumb_id;
						$image         = $thumb_url;
					}
				}

				$new_post_meta[$share_key] = array (
					'date'          => $date,
					'time'          => $time,
					'text'          => $text,
					'image'         => ! empty( $image ) ? $image : '',
					'attachment_id' => ! empty( $attachment_id ) ? $attachment_id : ''
				);

				$share_key++;

			}

			update_post_meta( $result->post_id, '_ppp_tweets', $new_post_meta );
		}

		// Postmeta found so upgrade them
		$step++;
		$redirect = add_query_arg( array(
			'page'        => 'ppp-upgrades',
			'ppp-upgrade' => 'upgrade_post_meta',
			'step'        => $step,
			'number'      => $number,
			'total'       => $total
		), admin_url( 'index.php' ) );
		wp_redirect( $redirect ); exit;

	} else {

		// No more postmeta found, finish up
		update_option( 'ppp_version', preg_replace( '/[^0-9.].*/', '', PPP_VERSION ) );
		ppp_set_upgrade_complete( 'upgrade_post_meta' );
		delete_option( 'ppp_doing_upgrade' );
		wp_redirect( admin_url() ); exit;

	}
}
add_action( 'ppp_upgrade_post_meta', 'ppp_v22_postmeta_upgrade' );