Skip to content
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';
}
Something went wrong with that request. Please try again.