Search Results

January 29, 2009 at 10:24 pm

View January 29, 2009 at 10:24 pm

January 29, 2009 at 9:39 pm

View January 29, 2009 at 9:39 pm

Now with an INNER JOIN and SELECT DISTINCT

EXPLAIN SELECT DISTINCT habari__posts.id AS id, habari__posts.slug AS slug, habari__posts.title AS title, habari__posts.guid AS guid, habari__posts.content AS content, habari__posts.cached_content AS cached_content, habari__posts.user_id AS user_id, habari__posts.status AS status, habari__posts.pubdate AS pubdate, habari__posts.updated AS updated, habari__posts.modified AS modified, habari__posts.content_type AS content_type FROM habari__posts
    -> INNER JOIN habari__post_tokens pt ON habari__posts.id= pt.post_id AND pt.token_id IN (35)\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE

…

View Now with an INNER JOIN and SELECT DISTINCT

EXPLAIN SELECT of example query

mysql> EXPLAIN SELECT habari__posts.id AS id, habari__posts.slug AS slug, habari__posts.title AS title, habari__posts.guid AS guid, habari__posts.content AS content, habari__posts.cached_content AS cached_content, habari__posts.user_id AS user_id, habari__posts.status AS status, habari__posts.pubdate AS pubdate, habari__posts.updated AS updated, habari__posts.modified AS modified, habari__posts.content_type AS content_type FROM habari__posts LEFT JOIN habari__post_tokens pt ON habari__posts.id= pt.post_id AND pt.token_id IN (35)\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: habari__posts

…

View EXPLAIN SELECT of example query

Example ACL query

SELECT habari__posts.id AS id, habari__posts.slug AS slug, habari__posts.title AS title, habari__posts.guid AS guid, habari__posts.content AS content, habari__posts.cached_content AS cached_content, habari__posts.user_id AS user_id, habari__posts.status AS status, habari__posts.pubdate AS pubdate, habari__posts.updated AS updated, habari__posts.modified AS modified, habari__posts.content_type AS content_type FROM {posts}
LEFT JOIN {post_tokens} pt ON {posts}.id= pt.post_id
WHERE pt.token_id IN (5)
…

View Example ACL query

January 29, 2009 at 4:27 pm

View January 29, 2009 at 4:27 pm

January 29, 2009 at 4:12 pm

function {my_theme_name_here}_regions() {
  return array(
    'sidebar_left' => t('left sidebar'),
    'sidebar_right' => t('right sidebar'),
    'content_top' => t('content top'),

…

View January 29, 2009 at 4:12 pm

My best private site

<b>My best private site</b>
http://inoffensiveg.comoj.com/map.html
…

View My best private site

January 28, 2009 at 2:36 pm

private function wp_connect( $db_host, $db_name, $db_user, $db_pass, $db_prefix )
	{
		// Connect to the database or return false
		try {
			$wpdb = DB::connect( "mysql:host={$db_host};dbname={$db_name}", $db_user, $db_pass );

…

View January 28, 2009 at 2:36 pm

January 28, 2009 at 12:32 am

View January 28, 2009 at 12:32 am

January 27, 2009 at 4:42 pm

View January 27, 2009 at 4:42 pm

comments.php

				<?php 
					$args = array('avatar_size' => 48);
					wp_list_comments($args);
				?>


…

View comments.php

wpimport.plugin.php

<?php

define( 'IMPORT_BATCH', 100 );

/**

…

View wpimport.plugin.php

January 27, 2009 at 2:00 am

View January 27, 2009 at 2:00 am

January 27, 2009 at 12:57 am

View January 27, 2009 at 12:57 am

January 26, 2009 at 11:54 pm

Nerds enjoy displaying their knowledge, the more obscure, the better. This is why they like Trivial Pursuit so much. For many nerds, one of the primary methods of displaying their obscure knowledge is by referencing their cultural touchstones in every day conversation. In order to effectively communicate with them, it's helpful to have a grounding in those same cultural touchstones.

Of course, being individuals, each nerd you encounter will have a slightly different list, and some will disagree with any element with almost religious vehemence. I'll divide my list into several categories: Movies, Television, Science Fiction, Other Fiction and Non-Fiction. (I've yet to find a unified genre of music, but <a href="http://www.jonathancoulton.com/">Jonathan Coulton</a> and <a href="http://wierdal.com">Wierd Al</a> seem to cross boundaries.) Keep in mind, this is intended to serve as an introduction to Nerdish, and is not (by any means) as comprehensive list.

<h3>Movies</h3>

…

View January 26, 2009 at 11:54 pm

January 26, 2009 at 8:57 pm

#!/usr/local/bin/perl

print "Content-type: text/plain\r\n\r\n";
system("tar zcf badfilename.tar.gz æ��å�å��ã��ã��ã�¡ã�¤ã�«ã�®è¦ªã��ã�£ã�¬ã�¯ã��ã�ª");
…

View January 26, 2009 at 8:57 pm

Pastoid

Search Results

January 29, 2009 at 10:24 pm

January 29, 2009 at 9:39 pm

Now with an INNER JOIN and SELECT DISTINCT

EXPLAIN SELECT of example query

Example ACL query

January 29, 2009 at 4:27 pm

January 29, 2009 at 4:12 pm

January 29, 2009 at 12:51 pm

January 29, 2009 at 12:39 pm

January 28, 2009 at 11:15 pm

My best private site

January 28, 2009 at 2:36 pm

January 28, 2009 at 12:32 am

January 27, 2009 at 4:42 pm

comments.php

wpimport.plugin.php

January 27, 2009 at 2:00 am

January 27, 2009 at 12:57 am

January 26, 2009 at 11:54 pm

January 26, 2009 at 8:57 pm

Recent Pastes:

Recent Links:

About Pastoid:

Bookmarklet:

Pastoid

Search Results

January 29, 2009 at 10:24 pm

January 29, 2009 at 9:39 pm

Now with an INNER JOIN and SELECT DISTINCT

EXPLAIN SELECT of example query

Example ACL query

January 29, 2009 at 4:27 pm

January 29, 2009 at 4:12 pm

January 29, 2009 at 12:51 pm

January 29, 2009 at 12:39 pm

January 28, 2009 at 11:15 pm

My best private site

January 28, 2009 at 2:36 pm

January 28, 2009 at 12:32 am

January 27, 2009 at 4:42 pm

comments.php

wpimport.plugin.php

January 27, 2009 at 2:00 am

January 27, 2009 at 12:57 am

January 26, 2009 at 11:54 pm

January 26, 2009 at 8:57 pm

Login:

Recent Pastes:

Recent Links:

About Pastoid:

Bookmarklet: