View paypal_cert_test.php
<?php
/*
File prepared by Matt Weinberg, www.vectormediagroup.com and www.cartthrob.com
EXPLANATION:
On Jan 20, 2016 PayPal changed their Sandbox/Test SSL settings.
On June 17th, PayPal will be updating their Live/Production environment.
View query.sql
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)
View script.php
<?php
require 'vendor/autoload.php';
use Aws\S3\S3Client;
$client = S3Client::factory(array(
'key' => '',
'secret' => '',
));
View query.sql
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;
View gist:ea1c3e7c506fce61dd8f
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
View ExpressionEngine 2 Multi-Database Setup.php
<?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';
}