index.php

Typo3, 开源里边最强大的

<?php
/***************************************************************
*  Copyright notice
*
*  (c) 2004, 2005 Kasper Skaarhoj ([e-mail])
*  (c) 2004, 2005 Karsten Dambekalns ([e-mail])
*  All rights reserved
*
*  This script is part of the TYPO3 project. The TYPO3 project is
*  free software; you can redistribute it and/or modify
*  it under the terms of the GNU General Public License as published by
*  the Free Software Foundation; either version 2 of the License, or
*  (at your option) any later version.
*
*  The GNU General Public License can be found at
*  http://www.gnu.org/copyleft/gpl.html.
*
*  This script is distributed in the hope that it will be useful,
*  but WITHOUT ANY WARRANTY; without even the implied warranty of
*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
*  GNU General Public License for more details.
*
*  This copyright notice MUST APPEAR in all copies of the script!
***************************************************************/
/**
 * Module 'DBAL Debug' for the 'dbal' extension.
 *
 * @author	Kasper Skaarhoj <[e-mail]>
 * @author	Karsten Dambekalns <[e-mail]>
 */

unset($MCONF);
require ('conf.php');
require ($BACK_PATH.'init.php');
require ($BACK_PATH.'template.php');
$LANG->includeLLFile('EXT:dbal/mod1/locallang.xml');
require_once (PATH_t3lib.'class.t3lib_scbase.php');
$BE_USER->modAccess($MCONF,1);


/**
 * Script class; Backend module for DBAL extension
 *
 * @author	Kasper Skaarhoj <[e-mail]>
 * @author	Karsten Dambekalns <[e-mail]>
 * @package TYPO3
 * @subpackage dbal
 */
class tx_dbal_module1 extends t3lib_SCbase {

	/**
	 * Adds items to the ->MOD_MENU array. Used for the function menu selector.
	 *
	 * @return	void
	 */
	function menuConfig()	{
		$this->MOD_MENU = Array (
			'function' => Array (
				0 => $GLOBALS['LANG']->getLL('Debug_log'),
				'info' => $GLOBALS['LANG']->getLL('Cached_info'),
				'sqlcheck' => $GLOBALS['LANG']->getLL('SQL_check'),
			)
		);
		parent::menuConfig();
	}

	/**
	 * Main function of the module. Write the content to $this->content
	 *
	 * @return	void
	 */
	function main()	{
		global $BACK_PATH,$BE_USER;

			// Clean up settings:
		$this->MOD_SETTINGS = t3lib_BEfunc::getModuleData($this->MOD_MENU, t3lib_div::_GP('SET'), $this->MCONF['name']);

			// Draw the header.
		$this->doc = t3lib_div::makeInstance('noDoc');
		$this->doc->backPath = $BACK_PATH;
		$this->doc->form='<form action="" method="post">';
		$this->doc->docType = 'xhtml_trans';

			// JavaScript
		$this->doc->JScode = $this->doc->wrapScriptTags('
				script_ended = 0;
				function jumpToUrl(URL)	{	//
					window.location.href = URL;
				}
			');

			// DBAL page title:
		$this->content.=$this->doc->startPage($GLOBALS['LANG']->getLL('title'));
		$this->content.=$this->doc->header($GLOBALS['LANG']->getLL('title'));
		$this->content.=$this->doc->spacer(5);
		$this->content.=$this->doc->section('',$this->doc->funcMenu('',t3lib_BEfunc::getFuncMenu(0,'SET[function]',$this->MOD_SETTINGS['function'],$this->MOD_MENU['function'])));

			// Debug log:
		switch($this->MOD_SETTINGS['function']) {
			case 'info':
				$this->content .= $this->doc->section($GLOBALS['LANG']->getLL('Cached_info'), $this->printCachedInfo());
				break;
			case 'sqlcheck':
				$this->content .= $this->doc->section($GLOBALS['LANG']->getLL('SQL_check'), $this->printSqlCheck());
				break;
			case 0:
				$this->content.= $this->doc->section($GLOBALS['LANG']->getLL('Debug_log'), $this->printLogMgm());
				break;
		}

			// ShortCut
		if ($BE_USER->mayMakeShortcut())	{
			$this->content.=$this->doc->spacer(20).$this->doc->section('',$this->doc->makeShortcutIcon('id',implode(',',array_keys($this->MOD_MENU)),$this->MCONF['name']));
		}

		$this->content.=$this->doc->spacer(10);
	}

	/**
	 * Prints out the module HTML
	 *
	 * @return	string HTML output
	 */
	function printContent()	{
		global $SOBE;

		$this->content.=$this->doc->middle();
		$this->content.=$this->doc->endPage();
		echo $this->content;
	}

	/**
	 * Displays a form to check DBAL SQL methods and parse raw SQL.
	 *
	 * @return string HTML output
	 */
	function printSqlCheck()	{
		$input = t3lib_div::_GP('tx_dbal');

		$out = '
			<form name="sql_check" action="index.php" method="post" enctype="'.$GLOBALS['TYPO3_CONF_VARS']['SYS']['form_enctype'].'">
			<script type="text/javascript">
/*<![CDATA[*/
function updateQryForm(s) {
	document.getElementById(\'tx-dbal-result\').style.display = \'none\';
	switch(s) {
	case \'SELECT\':
		document.getElementById(\'tx-dbal-qryupdate\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryfields\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qryinsertvalues\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryupdatevalues\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryfrom\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qryinto\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qrywhere\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qrygroup\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qryorder\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qrylimit\').style.display = \'table-row\';
	break;
	case \'INSERT\':
		document.getElementById(\'tx-dbal-qryupdate\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryfields\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryinsertvalues\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qryupdatevalues\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryfrom\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryinto\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qrywhere\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qrygroup\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qryorder\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qrylimit\').style.display = \'table-row\';
	break;
	case \'UPDATE\':
		document.getElementById(\'tx-dbal-qryupdate\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qryfields\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryinsertvalues\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryupdatevalues\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qryfrom\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryinto\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryupdate\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qrywhere\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qrygroup\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryorder\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qrylimit\').style.display = \'none\';
	break;
	case \'DELETE\':
		document.getElementById(\'tx-dbal-qryupdate\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryfields\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryinsertvalues\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryupdatevalues\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryfrom\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qryinto\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qrywhere\').style.display = \'table-row\';
		document.getElementById(\'tx-dbal-qrygroup\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qryorder\').style.display = \'none\';
		document.getElementById(\'tx-dbal-qrylimit\').style.display = \'none\';
	break;
	}
}
/*]]>*/
				</script>
	    <table>
	    <tr class="tableheader bgColor5"><th colspan="2">Easy SQL check</th></tr>
	    <tr><td colspan="2">
	    <select name="tx_dbal[QUERY]"size="1" onchange="updateQryForm(this.options[this.selectedIndex].value)">
	     <option value="SELECT" '.($input['QUERY']=='SELECT'? 'selected="selected"' : '').'>SELECT</option>
	     <option value="INSERT" '.($input['QUERY']=='INSERT'? 'selected="selected"' : '').'>INSERT</option>
	     <option value="UPDATE" '.($input['QUERY']=='UPDATE'? 'selected="selected"' : '').'>UPDATE</option>
	     <option value="DELETE" '.($input['QUERY']=='DELETE' ? 'selected="selected"' : '').'>DELETE</option>
	    </select>
	    </td></tr>
 	    <tr id="tx-dbal-qryupdate" style="display:none;"><td></td><td><input name="tx_dbal[UPDATE]" value="'.$input['UPDATE'].'" type="text" size="30" maxsize="100" /></td></tr>
	    <tr id="tx-dbal-qryfields"><td></td><td><input name="tx_dbal[FIELDS]" value="'.$input['FIELDS'].'" type="text" size="30" maxsize="100" /></td></tr>
	    <tr id="tx-dbal-qryinsertvalues" style="display:none;"><td></td><td><textarea name="tx_dbal[INSERTVALUES]" cols="30" rows="4">'.$input['INSERTVALUES'].'</textarea></td></tr>
	    <tr id="tx-dbal-qryupdatevalues" style="display:none;"><th>SET</th><td><textarea name="tx_dbal[UPDATEVALUES]" cols="30" rows="4">'.$input['UPDATEVALUES'].'</textarea></td></tr>
 	    <tr id="tx-dbal-qryfrom"><th>FROM</th><td><input name="tx_dbal[FROM]" value="'.$input['FROM'].'" type="text" size="30" maxsize="100" /></td></tr>
 	    <tr id="tx-dbal-qryinto" style="display:none;"><th>INTO</th><td><input name="tx_dbal[INTO]" value="'.$input['INTO'].'" type="text" size="30" maxsize="100" /></td></tr>
	    <tr id="tx-dbal-qrywhere"><th>WHERE</th><td><input name="tx_dbal[WHERE]" value="'.$input['WHERE'].'" type="text" size="30" maxsize="100" /></td></tr>
	    <tr id="tx-dbal-qrygroup"><th>GROUP BY</th><td><input name="tx_dbal[GROUP]" value="'.$input['GROUP'].'" type="text" size="30" maxsize="100" /></td></tr>
	    <tr id="tx-dbal-qryorder"><th>ORDER BY</th><td><input name="tx_dbal[ORDER]" value="'.$input['ORDER'].'" type="text" size="30" maxsize="100" /></td></tr>
	    <tr id="tx-dbal-qrylimit"><th>LIMIT</th><td><input name="tx_dbal[LIMIT]" value="'.$input['LIMIT'].'" type="text" size="30" maxsize="100" /></td></tr>
			<tr><td></td><td style="text-align:right;"><input type="submit" value="CHECK" /></td></tr>
			<script type="text/javascript">
/*<![CDATA[*/
updateQryForm(\''.$input['QUERY'].'\');
/*]]>*/
				</script>
			';

		$out .= '<tr id="tx-dbal-result" class="bgColor4"><th>Result:</th><td>';
		switch($input['QUERY']) {
			case 'SELECT':
				$qry = $GLOBALS['TYPO3_DB']->SELECTquery($input['FIELDS'],$input['FROM'],$input['WHERE'],$input['GROUP'],$input['ORDER'],$input['LIMIT']);
				break;
			case 'INSERT':
				$qry = $GLOBALS['TYPO3_DB']->INSERTquery($input['INTO'],$this->createFieldsValuesArray($input['INSERTVALUES']));
				break;
			case 'UPDATE':
				$qry = $GLOBALS['TYPO3_DB']->UPDATEquery($input['UPDATE'],$input['WHERE'],$this->createFieldsValuesArray($input['UPDATEVALUES']));
				break;
			case 'DELETE':
				$qry = $GLOBALS['TYPO3_DB']->DELETEquery($input['FROM'],$input['WHERE']);
				break;
		}
		$out .= '<pre>'.htmlspecialchars($qry).'</pre></td></tr>';

		$out .= '
			<tr class="tableheader bgColor5"><th colspan="2">RAW SQL check</th></tr>
			<tr><td colspan="2" style="text-align:right;"><textarea name="tx_dbal[RAWSQL]" cols="60" rows="5">'.$input['RAWSQL'].'</textarea><br /><input type="submit" value="CHECK" /></td></tr>';
		if(!empty($input['RAWSQL'])) {
			$out .= '<tr class="bgColor4">';
			$parseResult = $GLOBALS['TYPO3_DB']->SQLparser->parseSQL($input['RAWSQL']);
			if (is_array($parseResult))	{
				$newQuery = $GLOBALS['TYPO3_DB']->SQLparser->compileSQL($parseResult);
				$testResult = $GLOBALS['TYPO3_DB']->SQLparser->debug_parseSQLpartCompare($input['RAWSQL'], $newQuery);
				if (!is_array($testResult))	{
					$out .= '<td colspan="2">'.$newQuery;
				} else {
					$out .= '<td colspan="2">'.htmlspecialchars($testResult[0]).'</td></tr>
					<tr><th>Error:</th><td style="border:2px solid #f00;">Input query did not match the parsed and recompiled query exactly (not observing whitespace):<br />'.htmlspecialchars($testResult[1]);
				}
			} else {
				$out .= '<th>Result:</th><td style="border:2px solid #f00;">'.$parseResult;
			}
			$out .='</td></tr>';
		}

		$out .='</table></form>';
		return $out;
	}

	/**
	 * Parses a very simple text format into an array.
	 *
	 * Each line is seen as a key/value pair that is exploded at =. This is used
	 * in the simple SQL check to input values for INSERT and UPDATE statements.
	 *
	 * @param string $in String to parse into key/value array.
	 * @return array Array created from the input string.
	 */
	function createFieldsValuesArray($in) {
		$ret = array();
		$in = explode(chr(10),$in);
		foreach ($in as $v) {
			$fv = explode('=',$v);
			$ret[$fv[0]] = $fv[1];
		}

		return $ret;
	}