All pastes #398009 Raw Edit

Miscellany

public php v1 · immutable
·published 2007-03-16 21:47 UTC
rendered paste body
/** * "Direct Slug" support */if ( request_url(0) && !module_exists(request_url(0)) ){	$slug = request_url(0, '');	$sql = array(		0 => 'SELECT true AS is_user, false AS is_story, false AS is_content FROM ' . USERS_TABLE . ' WHERE user_slug = \'' . $db->escape($slug) . '\'',		1 => 'SELECT false AS is_user, true AS is_story, false AS is_content FROM ' . STORIES_TABLE . ' WHERE story_slug = \'' . $db->escape($slug) . '\'',		2 => 'SELECT false AS is_user, false AS is_story, true AS is_content FROM ' . CONTENT_TABLE . ' WHERE content_slug = \'' . $db->escape($slug) . '\'',	);	$sql = implode(' UNION ', $sql);	$db->query($sql);		if ( $row = $db->fetchrow() )	{		switch ( true )		{			case ($row->is_user):				$crumbs->push('user');				break;			case ($row->is_story):				$crumbs->push('story');				break;			case ($row->is_content):				$crumbs->push('content');				break;		}	}		$db->freeresult();}