betweenbrain

$db->loadAssocList('value', 'key');

betweenbrain

/**
 * Returns a random image from /image/homeslides/
 *
 * @return mixed
 */
function randomImage()
{
	// Use full system path for security
    $files = glob(JPATH_BASE . '/images/homeslides/*.jpg');
    // Get random image

betweenbrain

Backup MySQL to Amazon S3

This is a simple way to backup your MySQL tables to Amazon S3 for a nightly backup - this is all to be done on your server :-)

Sister Document - Restore MySQL from Amazon S3 - read that next

1 - Install s3cmd

this is for Centos 5.6, see http://s3tools.org/repositories for other systems like ubuntu etc

betweenbrain

$ sudo ./domain.sh add vagrant default

betweenbrain

SELECT
table1.id,
table1.firstName,
table1.lastName,
a.sales
FROM `table1`
LEFT JOIN
( SELECT
	firstName,
	sales,

betweenbrain

SELECT
table1.id,
table1.firstName,
table1.lastName,
table2.sales,
table2.date
FROM `table1`
LEFT JOIN `table2` ON table1.firstName = table2.firstName
WHERE MONTH(table2.date) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH);

betweenbrain

SELECT
table1.id,
table1.firstName,
table1.lastName,
table2.sales,
table2.date
FROM `table1`
LEFT JOIN `table2` ON table1.firstName = table2.firstName;

betweenbrain

<?php defined('_JEXEC') or die;

/**
 * File       recipients.php
 * Created    8/1/14 11:38 AM
 * Author     Matt Thomas | [email protected] | http://betweenbrain.com
 * Support    https://github.com/betweenbrain/
 * Copyright  Copyright (C) 2014 betweenbrain llc. All Rights Reserved.
 * License    GNU GPL v2 or later
 */

betweenbrain

<?php
$query
->select($this->db->quoteName(array(
	'title',
	'id',
	'parent_id')))
->select($this->db->quoteName('metadesc', 'description'))
->from($this->db->quoteName('#__categories'))
->order($this->db->quoteName('parent_id') . ' ASC')
->order($this->db->quoteName('ordering') . ' ASC');

betweenbrain

<?php
$db    = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName(array('id')))
	->from($db->quoteName('#__categories'))
	->where($db->quoteName('published') . ' = ' . $db->quote('1') .
		' AND ' . $db->quoteName('extension') . ' = ' . $db->quote('com_content'))
	->order('LFT ASC');
$db->setQuery($query);
$categories = $db->loadObjectList('id');