<?php
// Initialize variables.
$db = JFactory::getDbo();
$subQuery = $db->getQuery(true);
$query = $db->getQuery(true);
// Create the base subQuery select statement.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
/** | |
* File index.php | |
* Created 7/16/14 1:34 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 | |
*/ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
### Keybase proof | |
I hereby claim: | |
* I am betweenbrain on github. | |
* I am betweenbrain (https://keybase.io/betweenbrain) on keybase. | |
* I have a public key whose fingerprint is 54B6 C5FB C8B0 AB9A 1822 143F 8E98 4A78 99B5 F294 | |
To claim this, I am signing this object: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$con = mysql_connect('localhost', 'dbUser', 'dbPassword'); | |
$key = '1234567890123456'; | |
$table = "CREATE TABLE people ( | |
id INT NOT NULL AUTO_INCREMENT, | |
full_name VARCHAR(255), | |
ssn VARCHAR(255), | |
PRIMARY KEY (id) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// SQL | |
SELECT | |
`users`.`id`, | |
`users`.`name`, | |
(SELECT | |
GROUP_CONCAT(`k2`.`title`) | |
FROM | |
`jos_k2_items` AS `k2` | |
WHERE | |
`k2`.`created_by` = `users`.`id` |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$sql = "SELECT id, name FROM `users`"; | |
try | |
{ | |
$query = $pdo->prepare($sql); | |
$query->execute(); | |
} |
|-CSS
|-SCSS
Arguments: --no-cache --update $FileName$:$FileParentDir$/css/$FileNameWithoutExtension$.css
Working directory: $FileDir$
Output paths to refresh: $FileParentDir$/css/$FileNameWithoutExtension$.css
NOTE: add --style compressed
to Arguments for minified output
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
config.vm.provider :virtualbox do |vb| | |
vb.customize ["modifyvm", :id, "--hwvirtex", "off"] | |
end |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
update `jos_modules` set `params` = replace(`params`, 'getTemplate=Elsewhere articles','getTemplate=Elsewhere Articles') WHERE `module` = 'mod_k2_content'; | |
update `jos_k2_items` set `fulltext` = replace(`fulltext`,'")','”)'); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
JTable::getInstance - /libraries/joomla/table/table.php | |
JTableContent - /libraries/legacy/table/content.php |