View query.sql
1 2 3 4 5 6 7 8
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
1 2 3 4 5 6 7 8 9 10
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 gist:36d0922c6e3cd35f92a4
1 2 3 4 5 6 7 8 9 10
<?php
header('Content-type: text/plain; charset=utf-8');
require 'vendor/autoload.php';
use Aws\S3\S3Client;
$client = S3Client::factory(array(
'key' => 'xxx',
'secret' => 'xxx',
View ExpressionEngine 2 Multi-Database Setup.php
1 2 3 4 5 6 7 8 9
<?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';
}
Something went wrong with that request. Please try again.