Michael C. Harris michaeltwofish

michaeltwofish / out

Created June 4, 2010 04:42

	tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN
	tcp 0 0 127.0.0.1:5433 0.0.0.0:* LISTEN
	tcp6 0 0 ::1:5432 :::* LISTEN
	tcp6 0 0 ::1:5433 :::* LISTEN
	tcp6 0 0 ::1:37957 ::1:5432 CLOSE_WAIT
	tcp6 1 0 ::1:55184 ::1:5432 CLOSE_WAIT
	unix 2 [ ACC ] STREAM LISTENING 1132560 /var/run/postgresql/.s.PGSQL.5433
	unix 2 [ ACC ] STREAM LISTENING 1146714 /var/run/postgresql/.s.PGSQL.5432
	unix 3 [ ] STREAM CONNECTED 1146473 /var/run/postgresql/.s.PGSQL.5433
	unix 3 [ ] STREAM CONNECTED 539543

michaeltwofish / out

Created June 4, 2010 04:39

	Version Cluster Port Status Owner Data directory Log file
	8.4 main 5433 online postgres /var/lib/postgresql/8.4/main /var/log/postgresql/postgresql-8.4-main.log

michaeltwofish / gist:424937

Created June 4, 2010 04:13

	postgres=# \l
	List of databases
	Name \| Owner \| Encoding \| Collation \| Ctype \| Access privileges
	-----------+----------+-----------+-----------+-------+-----------------------
	habari \| habari \| SQL_ASCII \| C \| C \| =Tc/habari
	: habari=CTc/habari
	postgres \| postgres \| SQL_ASCII \| C \| C \|
	template0 \| postgres \| SQL_ASCII \| C \| C \| =c/postgres
	: postgres=CTc/postgres
	template1 \| postgres \| SQL_ASCII \| C \| C \| =c/postgres

michaeltwofish / imprint.plugin.php

Created May 26, 2010 01:32

	$years = DB::get_column(
	"SELECT habari__postinfo.value, count(habari__posts.id) FROM habari__posts
	INNER JOIN habari__posttype ON habari__posts.content_type = habari__posttype.id AND habari__posttype.name = ?
	INNER JOIN habari__postinfo ON habari__posts.id = habari__postinfo.`post_id` AND `habari__postinfo`.name = ?
	INNER JOIN habari__poststatus ON habari__posts.status = habari__poststatus.id AND habari__poststatus.name = ?
	GROUP BY habari__postinfo.value
	ORDER BY habari__postinfo.value DESC",
	array('imprint', 'year', 'published')
	);

michaeltwofish / imprint.plugin.php

Created May 20, 2010 01:31

	public function get_years_array()
	{
	$years = DB::get_column(
	"SELECT DISTINCT habari__postinfo.value from habari__posts
	INNER join habari__posttype on habari__posts.content_type = habari__posttype.id and habari__posttype.name = ?
	left join habari__postinfo on habari__posts.id = habari__postinfo.`post_id` and `habari__postinfo`.name = ?
	ORDER BY habari__postinfo.value DESC",
	array('imprint', 'year')
	);

michaeltwofish / theme.php

Created April 19, 2010 05:58

	public function action_admin_header($theme)
	{
	if ( $theme->page == 'themes' ) {
	$js = <<<JS
	$(document).ready(function() {
	$('#twitter input:checkbox').bind('change', function() {
	var disable_twitter_username = $('#twitter input:checked').length == 0;
	$('#twitter_username input').attr('disabled', disable_twitter_username);
	});

michaeltwofish / out

Created April 19, 2010 04:41

michaeltwofish / form_mailer.plugin.php

Created April 18, 2010 03:17

	<?php

	/**
	* A generic form mailer, designed to be built upon by other plugins and themes
	*/
	class FormMailer extends Plugin
	{
	const X_MAILER = 'Habari Form Mailer';

	public function __get($name) {