adrienne’s gists

adrienne / Useful SQL snippets

Last active August 30, 2023 22:17

Useful SQL snippets

	Various handy bits and bobs relating to SQL (and the mySQL RDBMS in particular).

	# Dump all databases from CLI:

	$ mysqldump -h [server] -u root --password=password --default-character-set=utf8 --set-charset --all-databases > all_dbs.sql

	# Restore all databases from CLI:

	$ mysql -u root --password=password --default-character-set=utf8 --set-charset < all_dbs.sql

adrienne / Preferences.sublime-settings

Created April 25, 2013 05:16

SublimeText Prefs Files

	{
	"": "",
	"auto_complete_commit_on_tab": true,
	"auto_indent": true,
	"bold_folder_labels": true,
	"color_scheme": "Packages/Color Scheme - Default/Solarized (Light).tmTheme",
	"ensure_newline_at_eof_on_save": true,
	"fade_fold_buttons": false,
	"font_face": "Consolas",
	"font_options":

adrienne / Custom Playa field in Safecracker

Created April 23, 2013 07:01

Useful EE snippets

	<select name="playa_field[selections][]">

	{exp:channel:entries dynamic="no" channel="my_channel"}

	<option name="{entry_id}">{title}</option>

	{/exp:channel:entries}

	</select>

adrienne / perftips.js

Last active December 15, 2015 23:39

some quick Javascript/jQuery performance tips

	// Some references here: http://bitly.com/bundles/adrienne/15


	// Using native getElementByID to create a jQuery collection is faster than jQuery's ID selector!
	// -------------------------------------------------------------------------------------------------------------
	// prefer:
	$(document.getElementById("testid"));
	// to:
	$("#testid");

adrienne / .htaccess

Created March 28, 2013 21:35 — forked from johndwells/.htaccess

	# ----------------------------------------------------------------------
	# 5G BLACKLIST/FIREWALL (2013)
	# @ http://perishablepress.com/5g-blacklist-2013/
	# ----------------------------------------------------------------------

	# ----------------------------------------------------------------------
	# 5G:[QUERY STRINGS]
	# ----------------------------------------------------------------------
	<IfModule mod_rewrite.c>
	RewriteEngine On

adrienne / EE RSS Feed (Dynamic)

Last active December 7, 2021 06:32

EE sample feed; multiple entries if no third segment, otherwise comments from single entry. REQUIRES STASH.

	<?xml version="1.0" encoding="{charset}"?>

	<rss version="2.0"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:admin="http://webns.net/mvcb/"
	xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:ee="http://ellislab.com/">

adrienne / gist:3977777

Created October 30, 2012 01:27

How to follow an organization on gitHub

	Paste this into the console in your browser:

	$.post("https://github.com/users/follow?target=organizationName");

adrienne / gist:3950202

Created October 25, 2012 03:02

Quick Stash thing

	{!-- putting the items in lists --}
	{exp:channel:entries channel="clinical_trials" orderby="ct_last_updated" sort="desc" status="not Closed"}
	{exp:stash:append_list name='ct_recruitment_list'}
	{stash:listitem}
	{ct_recruitment}
	{/stash:listitem}
	{/exp:stash:append_list}
	{exp:stash:append_list name='ct_agegroups_list'}
	{stash:listitem}
	{ct_age_groups:ct_age_group}

adrienne / string_manipulation_AND_json_output.sql

Created August 29, 2012 16:50

Things NOT to do with MySQL, generally speaking

	SELECT
	ia.descriptor_id, descriptor_name,
	MAX(pkg_override_id) AS pkg_id, MAX(version_type_id) AS version,
	CASE WHEN MAX(version_type_id) > 1 THEN 1 ELSE 0 END AS overridden,
	CONCAT('[',
	SUBSTRING_INDEX(
	GROUP_CONCAT(
	CASE
	WHEN cat_override_id IS NOT NULL AND cat_override_id > 0
	THEN CONCAT('{"',ia.item_id,'" : [ {"iname" : "',item_name,'"} , {"icat" : "',

adrienne / gist:3312817

Created August 10, 2012 09:17 — forked from ckimrie/gist:3312619

Example extension that allows you to modify the final ExpressionEngine CP output

	<?php

	/**
	* Modifying the final CP Output
	*
	* This extension demonstrates how you can access and modify the final ExpressionEngine
	* CP output. It is not a hack, but it is a new technique that to my knowledge has not
	* been used before in an EE addon.
	*
	* This has not been road tested and its side effects are unknown, so use this at your own risk.

Adrienne L. Travis adrienne