2 /***************************************************************
5 * (c) 1999-2010 Sebastian Kurfürst <sebastian@garbage-group.de>
8 * This script is part of the TYPO3 project. The TYPO3 project is
9 * free software; you can redistribute it and/or modify
10 * it under the terms of the GNU General Public License as published by
11 * the Free Software Foundation; either version 2 of the License, or
12 * (at your option) any later version.
14 * The GNU General Public License can be found at
15 * http://www.gnu.org/copyleft/gpl.html.
16 * A copy is found in the textfile GPL.txt and important notices to the license
17 * from the author is found in LICENSE.txt distributed with these scripts.
20 * This script is distributed in the hope that it will be useful,
21 * but WITHOUT ANY WARRANTY; without even the implied warranty of
22 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
23 * GNU General Public License for more details.
25 * This copyright notice MUST APPEAR in all copies of the script!
26 ***************************************************************/
29 * Contains the update class for not in menu pages. Used by the update wizard in the install tool.
31 * @author Sebastian Kurfürst <sebastian@garbage-group.de>
32 * @author Steffen Kamper <info@sk-typo3.de>
35 class tx_coreupdates_notinmenu
{
36 var $versionNumber; // version number coming from t3lib_div::int_from_ver()
44 var $userInput; // user input
48 * Checks if an update is needed
50 * @param string &$description: The description for the update
51 * @return boolean whether an update is needed (true) or not (false)
53 public function checkForUpdate(&$description) {
55 $description = 'Removes the deprecated pages doktype "Not in menu". It sets the successing flag "Not in menu" for the corresponding pages instead.';
57 if ($this->versionNumber
>= 4002000) {
58 $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('uid', 'pages', 'doktype=5', '', '', '1');
59 if($GLOBALS['TYPO3_DB']->sql_num_rows($res)) {
62 $GLOBALS['TYPO3_DB']->sql_free_result($res);
69 * Performs the database update. Changes the doktype from 5 ("not in menu") to 1 (standard) and sets the "nav_hide" flag to 1
71 * @param array &$dbQueries: queries done in this update
72 * @param mixed &$customMessages: custom messages
73 * @return boolean whether it worked (true) or not (false)
75 public function performUpdate(&$dbQueries, &$customMessages) {
77 if($this->versionNumber
>= 4002000) {
83 $res = $GLOBALS['TYPO3_DB']->exec_UPDATEquery('pages', 'doktype=5', $updateArray);
84 $dbQueries[] = str_replace(chr(10), ' ', $GLOBALS['TYPO3_DB']->debug_lastBuiltQuery
);
86 if ($GLOBALS['TYPO3_DB']->sql_error()) {
87 $customMessages = 'SQL-ERROR: ' . htmlspecialchars($GLOBALS['TYPO3_DB']->sql_error());