mrw

name: Deploy to Vapor

on:
  push:
    branches: 
      - staging

jobs:
  vapor-deploy:

mrw

<?php

	/*
		File prepared by Matt Weinberg, www.vectormediagroup.com

		EXPLANATION:

		In 2018, Stripe will be updating their Live/Production environment TLS settings.

		Many servers, especially older ones, will not be able to connect to Stripe after the settings are changed. 

mrw

<?php

	/*
		File prepared by Matt Weinberg, www.vectormediagroup.com and www.cartthrob.com

		EXPLANATION:

		In 2018, PayPal will be updating their Live/Production environment.

		Many servers, especially older ones, will not be able to connect to PayPal after the settings are changed. 

mrw

SELECT
	products.entry_id,
	products.title,
	order_items.price,
	SUM(order_items.quantity) AS total_sold,
	SUM(order_items.quantity) * order_items.price AS total_price
FROM
	exp_cartthrob_order_items AS order_items
		INNER JOIN exp_channel_titles AS products
			USING(entry_id)

mrw

<?php
	
	require 'vendor/autoload.php';
	
	use Aws\S3\S3Client;
	use Aws\S3\Exception\S3Exception;

	$s3 = new S3Client([
		'region'  => 'us-east-1',
		'version' => 'latest',

mrw

SELECT JA.ID, author, JA.created, summary, pname, CONCAT(P.pkey, "-", JI.issuenum), JA.actionbody
FROM jiraaction JA
JOIN jiraissue JI ON JA.issueid = JI.id
JOIN project P ON JI.project = P.id
JOIN app_user U ON U.user_key = JA.author
WHERE JA.actiontype = 'comment'
AND U.lower_user_name = 'xxx'
ORDER BY created DESC;

mrw

SELECT
	user_id,
	user_name,
	email_address,
	from_unixtime(attribute_value / 1000) AS last_login_time
FROM
	cwd_user_attributes
		INNER JOIN cwd_user
			ON cwd_user_attributes.user_id = cwd_user.ID
WHERE

mrw

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

// Multiple if statements, or a switch statement,
// can handle as many environments as you need
if ($_SERVER['HTTP_HOST'] == "local-site.dev") {
    $active_group = 'expressionengine';
} else {
    $active_group = 'enginehosting';
}