webzunft

# Basic queries to analyse canceled subscriptions using EDD Recurring Payments pre EDD 3.0
# Use EXPLAIN if you have large stores since the "notes" column is not indexed and queries can take some time
# Some of these reports might be worth storing as Views and look at the graphs PHPMyAdmin can also create from them

# List subscription cancelation with creation and cancelation date, as well as the user who canceled
# good as a basis for further queries

SELECT ID,
  created,
  REGEXP_SUBSTR( REGEXP_SUBSTR( notes, '.* Status changed from active to cancelled .*' ), '^[a-z]+ [0-9]+, [0-9]+' ) AS 'date',

webzunft

if ( is_wp_error( $response ) ) {
			$body = wp_remote_retrieve_body( $response );
			if ( $body ) {
				return $body;
			} else {
				$curl = curl_version();

				return __( 'License couldn’t be activated. Please try again later.', 'advanced-ads' ) . " (cURL {$curl['version']})";
			}
		}

webzunft

<?php
/**
 * Shortcodes that help with displaying pricing information
 */

/**
 * Show the original price of a given download and price ID
 *
 * @param array $atts shortcode attributes.
 * @param array $content shortcode attributes.

webzunft

<?php
/**
 * Add more columns to the order table
 *
 * - Products
 * - Country
 */
/**
 * Add table columns
 *

webzunft

<?php
/**
 * Plugin Name: ISC Options Printer
 * Plugin URI: https://yourwebsite.com/
 * Description: A helper plugin to print the Image Source Control plugin options in raw, serialized format at the top of the ISC plugin options page.
 * Version: 1.0
 * Author: Your Name
 * Author URI: https://yourwebsite.com/
 * License: GPL2
 */

webzunft

/**
 * Tracking order items and orders for Easy Digital Downloads as Ecommerce data in a self-hosted Matomo (the WordPress plugin)
 * the code is fired on the purchase confirmation page that appears right after the purchase.
 * Based on https://matomo.org/faq/reports/advanced-manually-tracking-ecommerce-actions-in-matomo/
 */
add_action('edd_order_receipt_after_table', function( $order, $edd_receipt_args ) {
	if ( empty( $edd_receipt_args['payment_id'] ) ) {
		return;
	}
	// Only accept complete or pending orders. Pending orders can be caused by a delay with PayPal, so we are accepting them here