TYPO3 Core

<?php

/***************************************************************

/**

* Class to setup values in localconf.php and verify the TYPO3 DB tables/fields

*

*

*

* 83: class t3lib_install

*

*

*

* TOTAL FUNCTIONS: 17

* (This index is automatically created/updated by the extension "extdeveval")

*/

/**

* Class to setup values in localconf.php and verify the TYPO3 DB tables/fields

*

// External, Static

// Internal, dynamic:

/**

*

* @return void

*/

}

}

/**************************************

*

* Writing to localconf.php

* @see writeToLocalconf_control()

*/

public function setValueInLocalconfFile(&$line_array, $variable, $value, $quoteValue = TRUE) {

// Initialize:

$found = 0;

$this->touchedLine = '';

$commentKey = '## ';

$stopAtToken = ($this->localconf_editPointToken && $inArray);

$replace = array('["', '"]');

$search = array('[\'', '\']');

$varDoubleQuotes = str_replace($search, $replace, $variable);

// Search for variable name:

$line_array = array_reverse($line_array);

$v2 = trim($v);

if ($quoteValue) {

$value = '\'' . $this->slashValueForSingleDashes($value) . '\'';

}

$line_array[$k] = $mainparts[0] . $variable . " = " . $value . "; " . ('//' . $comment . str_replace($comment, '', $subparts[1]));

$found = 1;

break;

}

$this->touchedLine = count($line_array) - $k - 1;

$found = 1;

break;

}

$line_array = array_reverse($line_array);

}

$line_array[] = '';

}

if ($quoteValue) {

public function setArrayValueInLocalconfFile(array &$lines, $variable, array $value) {

$commentKey = '## ';

$inArray = in_array($commentKey . $this->localconf_editPointToken, $lines);

$stopAtToken = $this->localconf_editPointToken && $inArray;

$comment = 'Modified or inserted by ' . $this->updateIdentity . '.';

$format = "%s = %s;\t// " . $comment;

* @return mixed If $inlines is not an array it will return an array with the lines from localconf.php. Otherwise it will return a status string, either "continue" (updated) or "nochange" (not updated)

* @see setValueInLocalconfFile()

*/

$tmpExt = '.TMP.php';

$writeToLocalconf_dat = array();

// Checking write state of localconf.php:

if (!$this->allowUpdateLocalConf) {

1270853915

);

}

throw new RuntimeException(

'TYPO3 Fatal Error: ' . $writeToLocalconf_dat['file'] . ' is not writable!',

1270853916

);

}

// Checking if "updated" line was set by this tool - if so remove old line.

$updatedLine = array_pop($lines);

}

// Setting configuration

$success = $this->writeToLocalconf($inlines, $absFullPath);

return 'continue';

} else {

return 'nochange';

} else {

return 'nochange';

}

return $lines;

}

}

);

}

if (!strstr('?' . '>', $writeToLocalconf_dat['endLine'])) {

$lines[] = $writeToLocalconf_dat['endLine'];

$writeToLocalconf_dat['endLine'] = '?' . '>';

}

// Checking if "updated" line was set by this tool - if so remove old line.

$updatedLine = array_pop($lines);

if (!strstr($updatedLine, $writeToLocalconf_dat['updatedText'])) {

$lines[] = $updatedLine;

* @return boolean Returns TRUE if string is OK

* @see setValueInLocalconfFile()

*/

}

/**

* @return string Output value

* @see setValueInLocalconfFile()

*/

$value = str_replace("'.LF.'", '###INSTALL_TOOL_LINEBREAK###', $value);

$value = str_replace('###INSTALL_TOOL_LINEBREAK###', "'.LF.'", $value);

return $value;

}

/*************************************

*

* SQL

* @param string Should be a string read from an SQL-file made with 'mysqldump [database_name] -d'

* @return array Array with information about table.

*/

$lines = t3lib_div::trimExplode(LF, $fileContent, 1);

$table = '';

$total = array();

foreach ($lines as $value) {

}

if (!strlen($table)) {

$parts = t3lib_div::trimExplode(' ', $value, TRUE);

if (strtoupper($parts[0]) === 'CREATE' && strtoupper($parts[1]) === 'TABLE') {

$table = strtolower($table);

}

}

} else {

$ttype = array();

$total[$table]['extra']['ENGINE'] = $ttype[2];

} // Otherwise, just do nothing: If table engine is not defined, just accept the system default.

$total[$table]['extra']['COLLATE'] = $tcollation[2];

} else {

// Otherwise, get the CHARACTER SET and try to find the default collation for it as returned by "SHOW CHARACTER SET" query (for details, see http://dev.mysql.com/doc/refman/5.1/en/charset-table.html)

$charset = $tcharset[2];

} else {

}

$total[$table]['extra']['COLLATE'] = $this->getCollationForCharset($charset);

}

} else {

$lineV = str_replace('`', '', $lineV);

$parts = explode(' ', $lineV, 2);

// Make sure there is no default value when auto_increment is set

}

// "default" is always lower-case

$parts[1] = str_ireplace(' DEFAULT ', ' default ', $parts[1]);

}

$key = $parts[0];

$total[$table]['fields'][$key] = $parts[1];

$search = array('/UNIQUE (INDEX|KEY)/', '/FULLTEXT (INDEX|KEY)/', '/INDEX/');

$replace = array('UNIQUE', 'FULLTEXT', 'KEY');

$lineV = preg_replace($search, $replace, $lineV);

$parts[1] = preg_replace('/^(KEY|INDEX) /', '', $parts[1]);

}

$total[$table]['keys'][$key] = $lineV;

// This is a protection against doing something stupid: Only allow clearing of cache_* and index_* tables.

// Suggest to truncate (clear) this table

$total[$table]['extra']['CLEAR'] = 1;

}

* @access private

* @see getFieldDefinitions_fileContent()

*/

// Init SQL parser:

$sqlParser = t3lib_div::makeInstance('t3lib_sqlparser');

if (is_array($cfg['fields'])) {

$orig_fType = $fType;

$fInfo = $sqlParser->parseFieldDef($fType);

case 'char':

case 'varchar':

$fInfo['value'] = $newSize;

} else {

$fInfo = array(

$match = array();

preg_match('/^([^(]*)\(([^)]+)\)(.*)/', $kType, $match);

$keys = array();

}

$keys[] = $kfN;

}

}

}

}

* @param string Character set

* @return string Corresponding default collation

*/

// Load character sets, if not cached already

if (!count($this->character_sets)) {

$this->character_sets = $GLOBALS['TYPO3_DB']->admin_get_charsets();

} else {

}

}

*

* @return array Array with information about table.

*/

$total = array();

$tempKeys = array();

$tempKeysPrefix = array();

$keyName = $keyRow['Key_name'];

$colName = $keyRow['Column_name'];

if ($keyRow['Sub_part']) {

}

$tempKeys[$tableName][$keyName][$keyRow['Seq_in_index']] = $colName;

$prefix = 'PRIMARY KEY';

} else {

$prefix = 'FULLTEXT';

} elseif ($keyRow['Non_unique']) {

$prefix = 'KEY';

} else {

$prefix = 'UNIQUE';

}

}

$tempKeysPrefix[$tableName][$keyName] = $prefix;

}

'Collation' => 'COLLATE',

);

if (isset($tableStatus[$mysqlKey])) {

$total[$tableName]['extra'][$internalKey] = $tableStatus[$mysqlKey];

}

foreach ($tempKeys as $table => $keyInf) {

foreach ($keyInf as $kName => $index) {

ksort($index);

}

}

}

* @param boolean If set, this function ignores NOT NULL statements of the SQL file field definition when comparing current field definition from database with field definition from SQL file. This way, NOT NULL statements will be executed when the field is initially created, but the SQL parser will never complain about missing NOT NULL statements afterwards.

* @return array Returns an array with 1) all elements from $FDsrc that is not in $FDcomp (in key 'extra') and 2) all elements from $FDsrc that is different from the ones in $FDcomp

*/

$extraArr = array();

$diffArr = array();

foreach ($FDsrc as $table => $info) {

if (!strlen($onlyTableList) || t3lib_div::inList($onlyTableList, $table)) {

if (!isset($FDcomp[$table])) {

} else {

foreach ($keyTypes as $theKey) {

if (is_array($info[$theKey])) {

foreach ($info[$theKey] as $fieldN => $fieldC) {

}

if (!isset($FDcomp[$table][$theKey][$fieldN])) {

* @param string List of fields in diff array to take notice of.

* @return array Array of SQL statements (organized in keys depending on type)

*/

$statements = array();

$deletedPrefixKey = $this->deletedPrefixKey;

$remove = 0;

$remove = 1;

$keyList = 'extra';

}

foreach ($keyList as $theKey) {

if (is_array($diffArr[$theKey])) {

foreach ($diffArr[$theKey] as $table => $info) {

if (is_array($info['fields'])) {

foreach ($info['fields'] as $fN => $fV) {

if ($info['whole_table']) {

} else {

// Special case to work around MySQL problems when adding auto_increment fields:

if (stristr($fV, 'auto_increment')) {

$info['extra']['CLEAR'] = 2;

}

}

if ($remove) {

$statements['change'][md5($statement)] = $statement;

} else {

$statements['drop'][md5($statement)] = $statement;

}

} else {

$statements['add'][md5($statement)] = $statement;

}

$statements['change'][md5($statement)] = $statement;

$statements['change_currentValue'][md5($statement)] = $diffArr['diff_currentValues'][$table]['fields'][$fN];

}

if ($info['whole_table']) {

$whole_table[] = $fV;

} else {

if ($remove) {

$statements['drop'][md5($statement)] = $statement;

} else {

$statements['add'][md5($statement)] = $statement;

}

$statements['change'][md5($statement)] = $statement;

$statements['change'][md5($statement)] = $statement;

}

}

if (is_array($info['extra'])) {

$extras = array();

$extras_currentValue = array();

foreach ($info['extra'] as $fN => $fV) {

// Only consider statements which are missing in the database but don't remove existing properties

if (!$remove) {

// Truncate table must happen later, not now

// Valid values for CLEAR: 1=only clear if keys are missing, 2=clear anyway (force)

}

continue;

} else {

}

}

}

}

if ($clear_table) {

$statements['clear_table'][md5($statement)] = $statement;

}

if (count($extras)) {

$statements['change'][md5($statement)] = $statement;

}

}

if ($info['whole_table']) {

if ($remove) {

$statements['change_table'][md5($statement)] = $statement;

} else {

$statements['drop_table'][md5($statement)] = $statement;

}

// count:

$count = $GLOBALS['TYPO3_DB']->exec_SELECTcountRows('*', $table);

} else {

if ($info['extra']) {

}

}

}

$statements['create_table'][md5($statement)] = $statement;

}

}

* @param array MySQL result row

* @return string Field definition

*/

$field = array($row['Type']);

$field[] = 'NOT NULL';

}

// Add a default value if the field is not auto-incremented (these fields never have a default definition)

}

}

if ($row['Extra']) {

$field[] = $row['Extra'];

}

}

/**

* @param string Regex to filter SQL lines to include

* @return array Array of SQL statements

*/

$sqlcodeArr = explode(LF, $sqlcode);

// Based on the assumption that the sql-dump has

$is_set = 0;

// auto_increment fields cannot have a default value!

$lineContent = preg_replace('/ default \'0\'/i', '', $lineContent);

}

$is_set = 1;

}

if (isset($statementArray[$statementArrayPointer])) {

unset($statementArray[$statementArrayPointer]);

}

}

$statementArrayPointer++;

} elseif ($is_set) {

}

}

* @param boolean If set, will count number of INSERT INTO statements following that table definition

* @return array Array with table definitions in index 0 and count in index 1

*/

$crTables = array();

$insertCount = array();

foreach ($statements as $line => $lineContent) {

$reg = array();

$table = trim($reg[1]);

// table names are always lowercase on Windows!

if (TYPO3_OS == 'WIN') {

$table = strtolower($table);

}

$sqlLines = explode(LF, $lineContent);

$sqlLines[$k] = preg_replace('/ default \'0\'/i', '', $v);

}

}

$lineContent = implode(LF, $sqlLines);

$crTables[$table] = $lineContent;

}

$nTable = trim($reg[1]);

$insertCount[$nTable]++;

}

}

}

/**

* @param string Table name

* @return array Array of INSERT INTO statements where table match $table

*/

$reg = array();

$nTable = trim($reg[1]);

$outStatements[] = $lineContent;

}

}

* @param array Array with keys that must match keys in $arr. Only where a key in this array is set and true will the query be executed (meant to be passed from a form checkbox)

* @return mixed Array with error message from database if any occured. Otherwise true if everything was executed successfully.

*/

$result = array();

$res = $GLOBALS['TYPO3_DB']->admin_query($string);

$result[$key] = $GLOBALS['TYPO3_DB']->sql_error();

} elseif (is_resource($res)) {

$GLOBALS['TYPO3_DB']->sql_free_result($res);

}

}

}

return $result;

} else {

}

}

* @return array List of tables.

* @see t3lib_db::admin_get_tables()

*/

$whichTables = $GLOBALS['TYPO3_DB']->admin_get_tables(TYPO3_db);

$value = $key;

}

return $whichTables;

* @param boolean If set, will show the prefix "Current value" if $currentValue is given.

* @return string HTML table with checkboxes for update. Must be wrapped in a form.

*/

$out = array();

$tableId = uniqid('table');

if (count($arr) > 1) {

$out[] = '

<td nowrap="nowrap"><label for="' . $tableId . '-checkbox" style="cursor:pointer"><strong>select/deselect all</strong></label></td>

</tr>';

}

$ico = '';

$warnings = array();

$warnings['clear_table_info'] = 'Clearing the table is sometimes neccessary when adding new keys. In case of cache_* tables this should not hurt at all. However, use it with care.';

}

}

<tr>

</tr>';

<tr>

<td valign="top"></td>

</tr>';

}

}

$out[] = '

<tr>

<td valign="top"></td>

</tr>';

}

$content = '

<!-- Update database fields / tables -->

<table border="0" cellpadding="2" cellspacing="2" id="' . $tableId . '" class="update-db-fields">' . implode('', $out) . '

</table>';

}

* @return array Array with information about table.

* @deprecated since TYPO3 4.2, this function will be removed in TYPO3 4.6, use ->getFieldDefinitions_fileContent() instead!

*/

t3lib_div::logDeprecatedFunction();

return $this->getFieldDefinitions_fileContent($fileContent);

}

}

include_once($TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['t3lib/class.t3lib_install.php']);

}