class tx_adhocmessage_pi1 extends tslib_pibase {
	var $prefixId      = 'tx_adhocmessage_pi1';		// Same as class name
	var $scriptRelPath = 'pi1/class.tx_adhocmessage_pi1.php';	// Path to this script relative to the extension dir.
	var $extKey        = 'adhocmessage';	// The extension key.
	var $pi_checkCHash = true;
 
	/**
	 * Main method of your PlugIn
	 *
	 * @param	string		$content: The content of the PlugIn
	 * @param	array		$conf: The PlugIn Configuration
	 * @return	The content that should be displayed on the website
	 */
	function main($content, $conf)	{
		switch((string)$conf['CMD'])	{
			case 'singleView':
				list($t) = explode(':',$this->cObj->currentRecord);
				$this->internal['currentTable']=$t;
				$this->internal['currentRow']=$this->cObj->data;
				return $this->pi_wrapInBaseClass($this->singleView($content, $conf));
			break;
			default:
				if (strstr($this->cObj->currentRecord,'tt_content'))	{
					$conf['pidList'] = $this->cObj->data['pages'];
					$conf['recursive'] = $this->cObj->data['recursive'];
				}
				return $this->pi_wrapInBaseClass($this->listView($content, $conf));
			break;
		}
	}
 
	/**
	 * Shows a list of database entries
	 *
	 * @param	string		$content: content of the PlugIn
	 * @param	array		$conf: PlugIn Configuration
	 * @return	HTML list of table entries
	 */
	function listView($content, $conf) {
		$this->conf = $conf;		// Setting the TypoScript passed to this function in $this->conf
		$this->pi_setPiVarDefaults();
		$this->pi_loadLL();		// Loading the LOCAL_LANG values
 
		$lConf = $this->conf['listView.'];	// Local settings for the listView function
 
		if ($this->piVars['showUid'])	{	// If a single element should be displayed:
			$this->internal['currentTable'] = 'tx_adhocmessage_data';
			$this->internal['currentRow'] = $this->pi_getRecord('tx_adhocmessage_data',$this->piVars['showUid']);
 
			$content = $this->singleView($content, $conf);
			return $content;
		} else {
			$items=array(
				'1'=> $this->pi_getLL('list_mode_1','Mode 1'),
				'2'=> $this->pi_getLL('list_mode_2','Mode 2'),
				'3'=> $this->pi_getLL('list_mode_3','Mode 3'),
			);
			if (!isset($this->piVars['pointer']))	$this->piVars['pointer']=0;
			if (!isset($this->piVars['mode']))	$this->piVars['mode']=1;
 
			// 
			if (!isset($this->piVars['sort'])) {
  			$this->piVars['sort'] = 'crdate:0'; // 1== Descending, 0 == ascending
} 
			// Initializing the query parameters:
			list($this->internal['orderBy'],$this->internal['descFlag']) = explode(':',$this->piVars['sort']);
			$this->internal['results_at_a_time']=t3lib_div::intInRange($lConf['results_at_a_time'],0,1000,3);		// Number of results to show in a listing.
			$this->internal['maxPages']=t3lib_div::intInRange($lConf['maxPages'],0,1000,2);;		// The maximum number of "pages" in the browse-box: "Page 1", "Page 2", etc.
			$this->internal['searchFieldList']='date,message';
			$this->internal['orderByList']='uid,crdate,message';
 
				// Get number of records:
			$res = $this->pi_exec_query('tx_adhocmessage_data',1);
			list($this->internal['res_count']) = $GLOBALS['TYPO3_DB']->sql_fetch_row($res);
 
				// Make listing query, pass query to SQL database:
			$res = $this->pi_exec_query('tx_adhocmessage_data');
			$this->internal['currentTable'] = 'tx_adhocmessage_data';
 
				// Put the whole list together:
			$fullTable='';	// Clear var;
		#	$fullTable.=t3lib_div::view_array($this->piVars);	// DEBUG: Output the content of $this->piVars for debug purposes. REMEMBER to comment out the IP-lock in the debug() function in t3lib/config_default.php if nothing happens when you un-comment this line!
 
				// Adds the mode selector.
			$fullTable.=$this->pi_list_modeSelector($items);
 
				// Adds the whole list table
			$fullTable.=$this->makelist($res);
 
				// Adds the search box:
			$fullTable.=$this->pi_list_searchBox();
 
				// Adds the result browser:
			$fullTable.=$this->pi_list_browseresults();
 
				// Returns the content from the plugin.
			return $fullTable;
		}
	}
	/**
	 * Creates a list from a database query
	 *
	 * @param	ressource	$res: A database result ressource
	 * @return	A HTML list if result items
	 */
	function makelist($res)	{
		$items=array();
			// Make list table rows
		while($this->internal['currentRow'] = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res))	{
			$items[]=$this->makeListItem();
		}
 
		$out = '<div'.$this->pi_classParam('listrow').'>
			'.implode(chr(10),$items).'
			</div>';
		return $out;
	}
 
	/**
	 * Implodes a single row from a database to a single line
	 *
	 * @return	Imploded column values
	 */
	function makeListItem()	{
		$out='
				<p'.$this->pi_classParam('listrowField-date').'>'.$this->getFieldContent('date').'</p>
				<p'.$this->pi_classParam('listrowField-message').'>'.$this->getFieldContent('message').'</p>
				<p'.$this->pi_classParam('listrowField-download').'>'.$this->getFieldContent('download').'</p>
				<p'.$this->pi_classParam('listrowField-file-header-name').'>'.$this->getFieldContent('file_header_name').'</p>
			';
		return $out;
	}
	/**
	 * Display a single item from the database
	 *
	 * @param	string		$content: The PlugIn content
	 * @param	array		$conf: The PlugIn configuration
	 * @return	HTML of a single database entry
	 */
	function singleView($content, $conf) {
		$this->conf = $conf;
		$this->pi_setPiVarDefaults();
		$this->pi_loadLL();
 
 
			// This sets the title of the page for use in indexed search results:
		if ($this->internal['currentRow']['title'])	$GLOBALS['TSFE']->indexedDocTitle=$this->internal['currentRow']['title'];
 
		$content='<div'.$this->pi_classParam('singleView').'>
			<h2>Record "'.$this->internal['currentRow']['uid'].'" from table "'.$this->internal['currentTable'].'":</h2>
				<p'.$this->pi_classParam("singleViewField-date&quot<img src="typo3conf/ext/mm_forum//res/smilies/icon_wink.gif" alt="icon_wink.gif" />.'><strong>'.$this->getFieldHeader('date').':</strong> '.$this->getFieldContent('date').'</p>
				<p'.$this->pi_classParam("singleViewField-message&quot<img src="typo3conf/ext/mm_forum//res/smilies/icon_wink.gif" alt="icon_wink.gif" />.'><strong>'.$this->getFieldHeader('message').':</strong> '.$this->getFieldContent('message').'</p>
				<p'.$this->pi_classParam("singleViewField-download&quot<img src="typo3conf/ext/mm_forum//res/smilies/icon_wink.gif" alt="icon_wink.gif" />.'><strong>'.$this->getFieldHeader('download').':</strong> '.$this->getFieldContent('download').'</p>
				<p'.$this->pi_classParam("singleViewField-file-header-name&quot<img src="typo3conf/ext/mm_forum//res/smilies/icon_wink.gif" alt="icon_wink.gif" />.'><strong>'.$this->getFieldHeader('file_header_name').':</strong> '.$this->getFieldContent('file_header_name').'</p>
		<p>'.$this->pi_list_linkSingle($this->pi_getLL('back','Back'),0).'</p></div>'.
		$this->pi_getEditPanel();
 
		return $content;
	}
	/**
	 * Returns the content of a given field
	 *
	 * @param	string		$fN: name of table field
	 * @return	Value of the field
	 */
	function getFieldContent($fN)	{
		switch($fN) {
			case 'uid':
				return $this->pi_list_linkSingle($this->internal['currentRow'][$fN],$this->internal['currentRow']['uid'],1);	// The "1" means that the display of single items is CACHED! Set to zero to disable caching.
			break;
 
			default:
				return $this->internal['currentRow'][$fN];
			break;
		}
	}
	/**
	 * Returns the label for a fieldname from local language array
	 *
	 * @param	[type]		$fN: ...
	 * @return	[type]		...
	 */
	function getFieldHeader($fN)	{
		switch($fN) {
 
			default:
				return $this->pi_getLL('listFieldHeader_'.$fN,'['.$fN.']');
			break;
		}
	}
 
	/**
	 * Returns a sorting link for a column header
	 *
	 * @param	string		$fN: Fieldname
	 * @return	The fieldlabel wrapped in link that contains sorting vars
	 */
	function getFieldHeader_sortLink($fN)	{
		return $this->pi_linkTP_keepPIvars($this->getFieldHeader($fN),array('sort'=>$fN.':'.($this->internal['descFlag']?0:1)));
	}
}
 
 
 
if (defined('TYPO3_MODE') && $TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/adhocmessage/pi1/class.tx_adhocmessage_pi1.php'])	{
	include_once($TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/adhocmessage/pi1/class.tx_adhocmessage_pi1.php']);
}
 
?>

$queryParts['SELECT'] = '
        a.*,
        b.cat';        
$queryParts['FROM'] = '
	tx_anweisungen_basis a,
	tx_anweisungen_category b'; 
 
$queryParts['WHERE'] = sprintf('
        a.category=b.uid ', 
        str_replace('tx_anweisungen_basis', 'a', $this->cObj->enableFields('tx_anweisungen_basis'))
	);
 
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
        $queryParts['SELECT'],
        $queryParts['FROM'],
       	$queryParts['WHERE']
	);