PageRenderTime 58ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 1ms

/typo3conf/ext/realurl/modfunc1/class.tx_realurl_modfunc1.php

https://github.com/moodley/fdummy
PHP | 1975 lines | 1219 code | 297 blank | 459 comment | 143 complexity | 0b6ff1c7d9e527f9ccc06304220385cc MD5 | raw file

Large files files are truncated, but you can click here to view the full file

    

  1. <?php

    2. 

  2. /***************************************************************

    3. 

  3. *  Copyright notice

    4. 

  4. *

    5. 

  5. *  (c) 2004-2005 Kasper Skaarhoj (kasperYYYY@typo3.com)

    6. 

  6. *  (c) 2005-2010 Dmitry Dulepov (dmitry@typo3.org)

    7. 

  7. *  All rights reserved

    8. 

  8. *

    9. 

  9. *  This script is part of the TYPO3 project. The TYPO3 project is

    10. 

  10. *  free software; you can redistribute it and/or modify

    11. 

  11. *  it under the terms of the GNU General Public License as published by

    12. 

  12. *  the Free Software Foundation; either version 2 of the License, or

    13. 

  13. *  (at your option) any later version.

    14. 

  14. *

    15. 

  15. *  The GNU General Public License can be found at

    16. 

  16. *  http://www.gnu.org/copyleft/gpl.html.

    17. 

  17. *

    18. 

  18. *  This script is distributed in the hope that it will be useful,

    19. 

  19. *  but WITHOUT ANY WARRANTY; without even the implied warranty of

    20. 

  20. *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

    21. 

  21. *  GNU General Public License for more details.

    22. 

  22. *

    23. 

  23. *  This copyright notice MUST APPEAR in all copies of the script!

    24. 

  24. ***************************************************************/

    25. 

  25. /**

    26. 

  26.  * Speaking Url management extension

    27. 

  27.  *

    28. 

  28.  * $Id: class.tx_realurl_modfunc1.php 63822 2012-06-25 09:29:36Z dmitry $

    29. 

  29.  *

    30. 

  30.  * @author	Kasper Skaarhoj <kasperYYYY@typo3.com>

    31. 

  31.  */

    32. 

  32. /**

    33. 

  33.  * [CLASS/FUNCTION INDEX of SCRIPT]

    34. 

  34.  *

    35. 

  35.  *

    36. 

  36.  *

    37. 

  37.  *   78: class tx_realurl_modfunc1 extends t3lib_extobjbase

    38. 

  38.  *   89:     function modMenu()

    39. 

  39.  *  113:     function main()

    40. 

  40.  *

    41. 

  41.  *              SECTION: Path Cache rendering:

    42. 

  42.  *  215:     function renderModule($tree)

    43. 

  43.  *  435:     function getPathCache($pageId)

    44. 

  44.  *  471:     function linkSelf($addParams)

    45. 

  45.  *  480:     function renderSearchForm()

    46. 

  46.  *  524:     function deletePathCacheEntry($cache_id)

    47. 

  47.  *  535:     function editPathCacheEntry($cache_id,$value)

    48. 

  48.  *  547:     function edit_save()

    49. 

  49.  *  562:     function saveCancelButtons($extra='')

    50. 

  50.  *

    51. 

  51.  *              SECTION: Decode view

    52. 

  52.  *  593:     function decodeView($tree)

    53. 

  53.  *

    54. 

  54.  *              SECTION: Encode view

    55. 

  55.  *  698:     function encodeView($tree)

    56. 

  56.  *

    57. 

  57.  *              SECTION: Unique Alias

    58. 

  58.  *  806:     function uniqueAlias()

    59. 

  59.  *  939:     function editUniqAliasEntry($cache_id,$value)

    60. 

  60.  *  951:     function edit_save_uniqAlias()

    61. 

  61.  *

    62. 

  62.  * TOTAL FUNCTIONS: 15

    63. 

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

    64. 

  64.  *

    65. 

  65.  */

    66. 

  66. 

    67. 

  67. require_once(PATH_t3lib.'class.t3lib_pagetree.php');

    68. 

  68. require_once(PATH_t3lib.'class.t3lib_extobjbase.php');

    69. 

  69. 

    70. 

  70. $GLOBALS['LANG']->includeLLfile('EXT:realurl/modfunc1/locallang.xml');

    71. 

  71. require_once(t3lib_extMgm::extPath('realurl', 'modfunc1/class.tx_realurl_pagebrowser.php'));

    72. 

  72. 

    73. 

  73. /**

    74. 

  74.  * Speaking Url management extension

    75. 

  75.  *

    76. 

  76.  * @author	Kasper Skaarhoj <kasperYYYY@typo3.com>

    77. 

  77.  * @package TYPO3

    78. 

  78.  * @subpackage tx_realurl

    79. 

  79.  */

    80. 

  80. class tx_realurl_modfunc1 extends t3lib_extobjbase {

    81. 

  81. 

    82. 

  82. 

    83. 

  83. 		// Internal, dynamic:

    84. 

  84. 	var $searchResultCounter = 0;

    85. 

  85. 

    86. 

  86. 	/**

    87. 

  87. 	 * Returns the menu array

    88. 

  88. 	 *

    89. 

  89. 	 * @return	array

    90. 

  90. 	 */

    91. 

  91. 	function modMenu()	{

    92. 

  92. 		return array (

    93. 

  93. 			'depth' => array(

    94. 

  94. 				0 => $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.depth_0'),

    95. 

  95. 				1 => $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.depth_1'),

    96. 

  96. 				2 => $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.depth_2'),

    97. 

  97. 				3 => $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.depth_3'),

    98. 

  98. 				99 => $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.depth_infi'),

    99. 

  99. 			),

    100. 

  100. 			'type' => array(

    101. 

  101. 				'pathcache' => 'ID-to-path mapping',

    102. 

  102. 				'decode' => 'Decode cache',

    103. 

  103. 				'encode' => 'Encode cache',

    104. 

  104. 				'uniqalias' => 'Unique Aliases',

    105. 

  105. 				'redirects' => 'Redirects',

    106. 

  106. 				'config' => 'Configuration',

    107. 

  107. 				'log' => 'Error Log'

    108. 

  108. 			)

    109. 

  109. 		);

    110. 

  110. 	}

    111. 

  111. 

    112. 

  112. 	/**

    113. 

  113. 	 * MAIN function for cache information

    114. 

  114. 	 *

    115. 

  115. 	 * @return	string		Output HTML for the module.

    116. 

  116. 	 */

    117. 

  117. 	function main() {

    118. 

  118. 		if ($this->pObj->id) {

    119. 

  119. 			$result = $this->createModuleContentForPage();

    120. 

  120. 		}

    121. 

  121. 		else {

    122. 

  122. 			$result = '<p>' . $GLOBALS['LANG']->getLL('no_page_id') . '</p>';

    123. 

  123. 		}

    124. 

  124. 

    125. 

  125. 		return $result;

    126. 

  126. 	}

    127. 

  127. 	/**

    128. 

  128. 	 * Enter description here ...

    129. 

  129. 	 */

    130. 

  130. 	protected function createModuleContentForPage() {

    131. 

  131. 		$this->addModuleStyles();

    132. 

  132. 

    133. 

  133. 		$result = $this->getFunctionMenu() . ' ';

    134. 

  134. 

    135. 

  135. 		switch ($this->pObj->MOD_SETTINGS['type']) {

    136. 

  136. 			case 'pathcache':

    137. 

  137. 				$this->edit_save();

    138. 

  138. 				$result .= $this->getDepthSelector();

    139. 

  139. 				$moduleContent = $this->renderModule($this->initializeTree());

    140. 

  140. 				$result .= $this->renderSearchForm();

    141. 

  141. 				$result .= $moduleContent;

    142. 

  142. 				break;

    143. 

  143. 			case 'encode':

    144. 

  144. 				$result .= $this->getDepthSelector();

    145. 

  145. 				$result .= $this->encodeView($this->initializeTree());

    146. 

  146. 				break;

    147. 

  147. 			case 'decode':

    148. 

  148. 				$result .= $this->getDepthSelector();

    149. 

  149. 				$result .= $this->decodeView($this->initializeTree());

    150. 

  150. 				break;

    151. 

  151. 			case 'uniqalias':

    152. 

  152. 				$this->edit_save_uniqAlias();

    153. 

  153. 				$result .= $this->uniqueAlias();

    154. 

  154. 				break;

    155. 

  155. 			case 'config':

    156. 

  156. 				$result .= $this->getDepthSelector();

    157. 

  157. 				$result .= $this->configView();

    158. 

  158. 				break;

    159. 

  159. 			case 'redirects':

    160. 

  160. 				$result .= $this->redirectView();

    161. 

  161. 				break;

    162. 

  162. 			case 'log':

    163. 

  163. 				$result .= $this->logView();

    164. 

  164. 				break;

    165. 

  165. 		}

    166. 

  166. 		return $result;

    167. 

  167. 	}

    168. 

  168. 

    169. 

  169. 	/**

    170. 

  170. 	 * Obtains function selection menu.

    171. 

  171. 	 *

    172. 

  172. 	 * @return string

    173. 

  173. 	 */

    174. 

  174. 	protected function getFunctionMenu() {

    175. 

  175. 		return $GLOBALS['LANG']->getLL('function') . ' ' .

    176. 

  176. 			t3lib_BEfunc::getFuncMenu($this->pObj->id, 'SET[type]',

    177. 

  177. 				$this->pObj->MOD_SETTINGS['type'], $this->pObj->MOD_MENU['type'],

    178. 

  178. 				'index.php');

    179. 

  179. 	}

    180. 

  180. 

    181. 

  181. 	/**

    182. 

  182. 	 * Adds module-specific styles to the output.

    183. 

  183. 	 *

    184. 

  184. 	 * @return void

    185. 

  185. 	 */

    186. 

  186. 	protected function addModuleStyles() {

    187. 

  187. 		$this->pObj->doc->inDocStyles .= '

    188. 

  188. 			TABLE.c-list TR TD { white-space: nowrap; vertical-align: top; }

    189. 

  189. 			TABLE#tx-realurl-pathcacheTable TD { vertical-align: top; }

    190. 

  190. 			FIELDSET { border: none; padding: 16px 0; }

    191. 

  191. 			FIELDSET DIV { clear: left; border-collapse: collapse; margin-bottom: 5px; }

    192. 

  192. 			FIELDSET DIV LABEL { display: block; float: left; width: 100px; }

    193. 

  193. 		' . tx_realurl_pagebrowser::getInlineStyles();

    194. 

  194. 	}

    195. 

  195. 

    196. 

  196. 

    197. 

  197. 	/**

    198. 

  198. 	 * Creates depth selector HTML for the page tree.

    199. 

  199. 	 *

    200. 

  200. 	 * @return string

    201. 

  201. 	 */

    202. 

  202. 	protected function getDepthSelector() {

    203. 

  203. 		return $GLOBALS['LANG']->getLL('depth') .

    204. 

  204. 			t3lib_BEfunc::getFuncMenu($this->pObj->id,'SET[depth]',$this->pObj->MOD_SETTINGS['depth'],$this->pObj->MOD_MENU['depth'],'index.php');

    205. 

  205. 	}

    206. 

  206. 

    207. 

  207. 	/**

    208. 

  208. 	 * Initializes the page tree.

    209. 

  209. 	 *

    210. 

  210. 	 * @return t3lib_pageTree

    211. 

  211. 	 */

    212. 

  212. 	protected function initializeTree() {

    213. 

  213. 		$tree = t3lib_div::makeInstance('t3lib_pageTree');

    214. 

  214. 		/** @var t3lib_pageTree $tree */

    215. 

  215. 		$tree->addField('nav_title', true);

    216. 

  216. 		$tree->addField('alias', true);

    217. 

  217. 		$tree->addField('tx_realurl_pathsegment', true);

    218. 

  218. 		$tree->init('AND '.$GLOBALS['BE_USER']->getPagePermsClause(1));

    219. 

  219. 

    220. 

  220. 		$treeStartingPoint = intval($this->pObj->id);

    221. 

  221. 		$treeStartingRecord = t3lib_BEfunc::getRecord('pages', $treeStartingPoint);

    222. 

  222. 		t3lib_BEfunc::workspaceOL('pages',$treeStartingRecord);

    223. 

  223. 

    224. 

  224. 			// Creating top icon; the current page

    225. 

  225. 		$tree->tree[] = array(

    226. 

  226. 			'row' => $treeStartingRecord,

    227. 

  227. 			'HTML' => t3lib_iconWorks::getIconImage('pages', $treeStartingRecord, $GLOBALS['BACK_PATH'], 'align="top"')

    228. 

  228. 		);

    229. 

  229. 

    230. 

  230. 			// Create the tree from starting point:

    231. 

  231. 		if ($this->pObj->MOD_SETTINGS['depth'] > 0) {

    232. 

  232. 			$tree->getTree($treeStartingPoint, $this->pObj->MOD_SETTINGS['depth'], '');

    233. 

  233. 		}

    234. 

  234. 		return $tree;

    235. 

  235. 	}

    236. 

  236. 

    237. 

  237. 

    238. 

  238. 

    239. 

  239. 

    240. 

  240. 

    241. 

  241. 

    242. 

  242. 

    243. 

  243. 

    244. 

  244. 

    245. 

  245. 

    246. 

  246. 

    247. 

  247. 

    248. 

  248. 

    249. 

  249. 	/****************************

    250. 

  250. 	 *

    251. 

  251. 	 * Path Cache rendering:

    252. 

  252. 	 *

    253. 

  253. 	 ****************************/

    254. 

  254. 

    255. 

  255. 	/**

    256. 

  256. 	 * Rendering the information

    257. 

  257. 	 *

    258. 

  258. 	 * @param	array		The Page tree data

    259. 

  259. 	 * @return	string		HTML for the information table.

    260. 

  260. 	 */

    261. 

  261. 	function renderModule(t3lib_pageTree $tree)	{

    262. 

  262. 

    263. 

  263. 			// Initialize:

    264. 

  264. 		$searchPath = trim(t3lib_div::_GP('pathPrefixSearch'));

    265. 

  265. 		$cmd = t3lib_div::_GET('cmd');

    266. 

  266. 		$entry = t3lib_div::_GET('entry');

    267. 

  267. 		$searchForm_replace = t3lib_div::_POST('_replace');

    268. 

  268. 		$searchForm_delete = t3lib_div::_POST('_delete');

    269. 

  269. 

    270. 

  270. 		$trackSameUrl = array();

    271. 

  271. 		$this->searchResultCounter = 0;

    272. 

  272. 

    273. 

  273. 			// Traverse tree:

    274. 

  274. 		$output = '';

    275. 

  275. 		$cc=0;

    276. 

  276. 		foreach($tree->tree as $row)	{

    277. 

  277. 

    278. 

  278. 				// Get all pagepath entries for page:

    279. 

  279. 			$pathCacheInfo = $this->getPathCache($row['row']['uid']);

    280. 

  280. 

    281. 

  281. 				// Row title:

    282. 

  282. 			$rowTitle = $row['HTML'].t3lib_BEfunc::getRecordTitle('pages',$row['row'],TRUE);

    283. 

  283. 			$cellAttrib = ($row['row']['_CSSCLASS'] ? ' class="'.$row['row']['_CSSCLASS'].'"' : '');

    284. 

  284. 

    285. 

  285. 				// Add at least one empty element:

    286. 

  286. 			if (!count($pathCacheInfo))	{

    287. 

  287. 

    288. 

  288. 						// Add title:

    289. 

  289. 					$tCells = array();

    290. 

  290. 					$tCells[]='<td nowrap="nowrap"'.$cellAttrib.'>'.$rowTitle.'</td>';

    291. 

  291. 

    292. 

  292. 						// Empty row:

    293. 

  293. 					$tCells[]='<td colspan="10" align="center">&nbsp;</td>';

    294. 

  294. 

    295. 

  295. 						// Compile Row:

    296. 

  296. 					$output.= '

    297. 

  297. 						<tr class="bgColor'.($cc%2 ? '-20':'-10').'">

    298. 

  298. 							'.implode('

    299. 

  299. 							',$tCells).'

    300. 

  300. 						</tr>';

    301. 

  301. 					$cc++;

    302. 

  302. 			} else {

    303. 

  303. 				foreach($pathCacheInfo as $c => $inf)	{

    304. 

  304. 

    305. 

  305. 						// Init:

    306. 

  306. 					$deletedEntry = FALSE;

    307. 

  307. 					$hash = $inf['pagepath'].'|'.$inf['rootpage_id'].'|'.$inf['language_id'];	// MP is not a part of this because the path itself should be different simply because the MP makes a different path! (see tx_realurl_advanced::pagePathtoID())

    308. 

  308. 

    309. 

  309. 						// Add icon/title and ID:

    310. 

  310. 					$tCells = array();

    311. 

  311. 					if (!$c)	{

    312. 

  312. 						$tCells[]='<td nowrap="nowrap" rowspan="'.count($pathCacheInfo).'"'.$cellAttrib.'>'.$rowTitle.'</td>';

    313. 

  313. 						$tCells[]='<td rowspan="'.count($pathCacheInfo).'">'.$inf['page_id'].'</td>';

    314. 

  314. 					}

    315. 

  315. 

    316. 

  316. 						// Add values from alternative field used to generate URL:

    317. 

  317. 					$baseRow = $row['row'];	// page row as base.

    318. 

  318. 					$onClick = t3lib_BEfunc::editOnClick('&edit[pages]['.$row['row']['uid'].']=edit&columnsOnly=title,nav_title,alias,tx_realurl_pathsegment',$this->pObj->doc->backPath);

    319. 

  319. 					$editIcon = '<a href="#" onclick="'.htmlspecialchars($onClick).'">'.

    320. 

  320. 								'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/edit2.gif','width="11" height="12"').' title="" alt="" />'.

    321. 

  321. 								'</a>';

    322. 

  322. 					$onClick = t3lib_BEfunc::viewOnClick($row['row']['uid'],$this->pObj->doc->backPath,'','','','');

    323. 

  323. 					$editIcon.= '<a href="#" onclick="'.htmlspecialchars($onClick).'">'.

    324. 

  324. 								'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/zoom.gif','width="12" height="12"').' title="" alt="" />'.

    325. 

  325. 								'</a>';

    326. 

  326. 

    327. 

  327. 					if ($inf['language_id']>0)	{	// For alternative languages, show another list of fields, form page overlay record:

    328. 

  328. 						$editIcon = '';

    329. 

  329. 						list($olRec) = t3lib_BEfunc::getRecordsByField('pages_language_overlay','pid',$row['row']['uid'],' AND sys_language_uid='.intval($inf['language_id']));

    330. 

  330. 						if (is_array($olRec))	{

    331. 

  331. 							$baseRow = array_merge($baseRow,$olRec);

    332. 

  332. 							$onClick = t3lib_BEfunc::editOnClick('&edit[pages_language_overlay]['.$olRec['uid'].']=edit&columnsOnly=title,nav_title',$this->pObj->doc->backPath);

    333. 

  333. 							$editIcon = '<a href="#" onclick="'.htmlspecialchars($onClick).'">'.

    334. 

  334. 										'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/edit2.gif','width="11" height="12"').' title="" alt="" />'.

    335. 

  335. 										'</a>';

    336. 

  336. 							$onClick = t3lib_BEfunc::viewOnClick($row['row']['uid'],$this->pObj->doc->backPath,'','','','&L='.$olRec['sys_language_uid']);

    337. 

  337. 							$editIcon.= '<a href="#" onclick="'.htmlspecialchars($onClick).'">'.

    338. 

  338. 										'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/zoom.gif','width="12" height="12"').' title="" alt="" />'.

    339. 

  339. 										'</a>';

    340. 

  340. 						} else {

    341. 

  341. 							$baseRow = array();

    342. 

  342. 						}

    343. 

  343. 					}

    344. 

  344. 					$tCells[]='<td>'.$editIcon.'</td>';

    345. 

  345. 

    346. 

  346. 						// 	Sources for segment:

    347. 

  347. 					$sources = count($baseRow) ? implode(' | ',array($baseRow['tx_realurl_pathsegment'], $baseRow['alias'], $baseRow['nav_title'], $baseRow['title'])) : '';

    348. 

  348. 					$tCells[]='<td nowrap="nowrap">'.htmlspecialchars($sources).'</td>';

    349. 

  349. 

    350. 

  350. 						// Show page path:

    351. 

  351. 					if (strcmp($searchPath,'') && t3lib_div::isFirstPartOfStr($inf['pagepath'],$searchPath) && !$inf['expire'])	{

    352. 

  352. 

    353. 

  353. 							// Delete entry:

    354. 

  354. 						if ($searchForm_delete)	{

    355. 

  355. 							$this->deletePathCacheEntry($inf['cache_id']);

    356. 

  356. 							$deletedEntry = TRUE;

    357. 

  357. 							$pagePath = '[DELETED]';

    358. 

  358. 						} elseif ($searchForm_replace) {

    359. 

  359. 							$replacePart = trim(t3lib_div::_POST('pathPrefixReplace'));

    360. 

  360. 							$this->editPathCacheEntry($inf['cache_id'],

    361. 

  361. 								$replacePart.substr($inf['pagepath'],strlen($searchPath)));

    362. 

  362. 

    363. 

  363. 							$pagePath =

    364. 

  364. 									'<span class="typo3-red">'.

    365. 

  365. 									htmlspecialchars($replacePart).

    366. 

  366. 									'</span>'.

    367. 

  367. 									htmlspecialchars(substr($inf['pagepath'],strlen($searchPath)));

    368. 

  368. 						} else {

    369. 

  369. 							$pagePath =

    370. 

  370. 									'<span class="typo3-red">'.

    371. 

  371. 									htmlspecialchars(substr($inf['pagepath'],0,strlen($searchPath))).

    372. 

  372. 									'</span>'.

    373. 

  373. 									htmlspecialchars(substr($inf['pagepath'],strlen($searchPath)));

    374. 

  374. 							$this->searchResultCounter++;

    375. 

  375. 						}

    376. 

  376. 					} else {

    377. 

  377. 							// Delete entries:

    378. 

  378. 						if ($cmd==='edit' && (!strcmp($entry,$inf['cache_id']) || !strcmp($entry,'ALL')))	{

    379. 

  379. 							$pagePath = '<input type="text" name="edit['.$inf['cache_id'].']" value="'.htmlspecialchars($inf['pagepath']).'" size="40" />';

    380. 

  380. 							if ($cmd==='edit' && $entry!='ALL')	{

    381. 

  381. 								$pagePath.= $this->saveCancelButtons();

    382. 

  382. 							}

    383. 

  383. 

    384. 

  384. 						} else {

    385. 

  385. 							$pagePath = htmlspecialchars($inf['pagepath']);

    386. 

  386. 						}

    387. 

  387. 					}

    388. 

  388. 

    389. 

  389. 					$tCells[]='<td'.($inf['expire'] ? ' style="font-style: italic; color:#999999;"' : '').'>'.$pagePath.'</td>';

    390. 

  390. 

    391. 

  391. 					if ($deletedEntry)	{

    392. 

  392. 						$tCells[]='<td>&nbsp;</td>';

    393. 

  393. 					} else {

    394. 

  394. 						$tCells[]='<td>'.

    395. 

  395. 								'<a href="'.$this->linkSelf('&cmd=delete&entry='.$inf['cache_id']).'">'.

    396. 

  396. 								'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="Delete" alt="" />'.

    397. 

  397. 								'</a>'.

    398. 

  398. 								'<a href="'.$this->linkSelf('&cmd=edit&entry='.$inf['cache_id']).'">'.

    399. 

  399. 								'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/edit2.gif','width="11" height="12"').' title="Edit" alt="" />'.

    400. 

  400. 								'</a>'.

    401. 

  401. 								'<a href="'.$this->linkSelf('&pathPrefixSearch='.rawurlencode($inf['pagepath'])).'">'.

    402. 

  402. 								'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/napshot.gif','width="12" height="12"').' title="Use for search" alt="" />'.

    403. 

  403. 								'</a>'.

    404. 

  404. 								'<a href="'.$this->linkSelf('&cmd=copy&entry='.$inf['cache_id']).'">'.

    405. 

  405. 								'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/clip_copy.gif','width="12" height="12"').' title="Copy entry" alt="" />'.

    406. 

  406. 								'</a>'.

    407. 

  407. 								'</td>';

    408. 

  408. 					}

    409. 

  409. 					$tCells[]='<td'.($inf['expire'] && $inf['expire']<time() ? ' style="color: red;"':'').'>'.

    410. 

  410. 								($inf['expire'] ? htmlspecialchars(t3lib_BEfunc::dateTimeAge($inf['expire'],-1)) : '').

    411. 

  411. 								($inf['expire'] ?

    412. 

  412. 									'<a href="'.$this->linkSelf('&cmd=raiseExpire&entry='.$inf['cache_id']).'">'.

    413. 

  413. 									'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/up.gif','width="14" height="14"').' title="Set expire time to 30 days" alt="" />'.

    414. 

  414. 									'</a>' : '').

    415. 

  415. 								'</td>';

    416. 

  416. 

    417. 

  417. 						// Set error msg:

    418. 

  418. 					$error = '';

    419. 

  419. 					if (!strcmp($inf['pagepath'],''))	{

    420. 

  420. 						if ($row['row']['uid']!=$this->pObj->id)	{	// Show error of "Empty" only for levels under the root. Yes, we cannot know that the pObj->id is the true root of the site, but at least any SUB page should probably have a path string!

    421. 

  421. 							$error = $this->pObj->doc->icons(2).'Empty';

    422. 

  422. 						}

    423. 

  423. 					} elseif (isset($trackSameUrl[$hash]))	{

    424. 

  424. 						$error = $this->pObj->doc->icons(2).'Already used on page ID '.$trackSameUrl[$hash];

    425. 

  425. 					} else {

    426. 

  426. 						$error = '&nbsp;';

    427. 

  427. 					}

    428. 

  428. 					$tCells[]='<td>'.$error.'</td>';

    429. 

  429. 

    430. 

  430. 					$tCells[]='<td>'.htmlspecialchars($inf['language_id']).'</td>';

    431. 

  431. 					$tCells[]='<td>'.htmlspecialchars($inf['mpvar']).'</td>';

    432. 

  432. 					$tCells[]='<td>'.htmlspecialchars($inf['rootpage_id']).'</td>';

    433. 

  433. 

    434. 

  434. 

    435. 

  435. 					#$tCells[]='<td nowrap="nowrap">'.htmlspecialchars(t3lib_BEfunc::datetime($inf['expire'])).' / '.htmlspecialchars(t3lib_BEfunc::calcAge($inf['expire']-time())).'</td>';

    436. 

  436. 

    437. 

  437. 					$trackSameUrl[$hash] = $inf['page_id'];

    438. 

  438. 

    439. 

  439. 						// Compile Row:

    440. 

  440. 					$rowClass = 'bgColor'.($cc%2 ? '-20':'-10');

    441. 

  441. 					$output.= '

    442. 

  442. 						<tr class="'.$rowClass.'">

    443. 

  443. 							'.implode('

    444. 

  444. 							',$tCells).'

    445. 

  445. 						</tr>';

    446. 

  446. 					$cc++;

    447. 

  447. 				}

    448. 

  448. 			}

    449. 

  449. 		}

    450. 

  450. 

    451. 

  451. 			// Create header:

    452. 

  452. 		$tCells = array();

    453. 

  453. 		$tCells[]='<td>Title:</td>';

    454. 

  454. 		$tCells[]='<td>ID:</td>';

    455. 

  455. 		$tCells[]='<td>&nbsp;</td>';

    456. 

  456. 		$tCells[]='<td>PathSegment | Alias | NavTitle | Title:</td>';

    457. 

  457. 		$tCells[]='<td>Pagepath:</td>';

    458. 

  458. 		$tCells[]='<td>'.

    459. 

  459. 					'<a href="'.$this->linkSelf('&cmd=delete&entry=ALL').'" onclick="return confirm(\'Are you sure you want to flush all cached page paths?\');">'.

    460. 

  460. 					'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' alt="" />'.

    461. 

  461. 					'</a>'.

    462. 

  462. 					'<a href="'.$this->linkSelf('&cmd=edit&entry=ALL').'">'.

    463. 

  463. 					'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/edit2.gif','width="11" height="12"').' title="" alt="" />'.

    464. 

  464. 					'</a>'.

    465. 

  465. 					'</td>';

    466. 

  466. 		$tCells[]='<td>Expires:'.

    467. 

  467. 						'<a href="'.$this->linkSelf('&cmd=flushExpired').'">'.

    468. 

  468. 						'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="Flush all expired" alt="" />'.

    469. 

  469. 						'</a>'.

    470. 

  470. 					'</td>';

    471. 

  471. 		$tCells[]='<td>Errors:</td>';

    472. 

  472. 		$tCells[]='<td>Lang:</td>';

    473. 

  473. 		$tCells[]='<td>&MP:</td>';

    474. 

  474. 		$tCells[]='<td>RootPage ID:</td>';

    475. 

  475. 		#$tCells[]='<td>Expire:</td>';

    476. 

  476. 		$output = '

    477. 

  477. 			<tr class="bgColor5 tableheader">

    478. 

  478. 				'.implode('

    479. 

  479. 				',$tCells).'

    480. 

  480. 			</tr>'.$output;

    481. 

  481. 

    482. 

  482. 			// Compile final table and return:

    483. 

  483. 		$output = '

    484. 

  484. 		<table border="0" cellspacing="1" cellpadding="0" id="tx-realurl-pathcacheTable" class="lrPadding c-list">'.$output.'

    485. 

  485. 		</table>';

    486. 

  486. 

    487. 

  487. 		if ($cmd==='edit' && $entry=='ALL')	{

    488. 

  488. 			$output.= $this->saveCancelButtons();

    489. 

  489. 		}

    490. 

  490. 

    491. 

  491. 		return $output;

    492. 

  492. 	}

    493. 

  493. 

    494. 

  494. 	/**

    495. 

  495. 	 * Fetch path caching information for page.

    496. 

  496. 	 *

    497. 

  497. 	 * @param	integer		Page ID

    498. 

  498. 	 * @return	array		Path Cache records

    499. 

  499. 	 */

    500. 

  500. 	function getPathCache($pageId)	{

    501. 

  501. 

    502. 

  502. 		$showLanguage = t3lib_div::_GP('showLanguage');

    503. 

  503. 		$cmd = t3lib_div::_GET('cmd');

    504. 

  504. 		$entry = t3lib_div::_GET('entry');

    505. 

  505. 

    506. 

  506. 		$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(

    507. 

  507. 					'*',

    508. 

  508. 					'tx_realurl_pathcache',

    509. 

  509. 					'page_id='.intval($pageId).

    510. 

  510. 						((string)$showLanguage!=='' ? ' AND language_id='.intval($showLanguage) : ''),

    511. 

  511. 					'',

    512. 

  512. 					'language_id,expire'

    513. 

  513. 				);

    514. 

  514. 

    515. 

  515. 			// Traverse result:

    516. 

  516. 		$output = array();

    517. 

  517. 		while (false != ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res))) {

    518. 

  518. 

    519. 

  519. 				// Delete entries:

    520. 

  520. 			if ($cmd==='delete' && (!strcmp($entry,$row['cache_id']) || !strcmp($entry,'ALL')))	{

    521. 

  521. 				$this->deletePathCacheEntry($row['cache_id']);

    522. 

  522. 				// Raise expire times:

    523. 

  523. 			} elseif ($cmd==='raiseExpire' && !strcmp($entry,$row['cache_id'])) {

    524. 

  524. 				$this->raiseExpirePathCacheEntry($row);

    525. 

  525. 				$output[] = $row;

    526. 

  526. 			} elseif ($cmd==='flushExpired' && $row['expire'] && $row['expire']<time()) {

    527. 

  527. 				$this->deletePathCacheEntry($row['cache_id']);

    528. 

  528. 			} elseif ($cmd==='copy' && (!strcmp($entry,$row['cache_id'])))	{

    529. 

  529. 				$output[] = $this->copyPathCacheEntry($row);

    530. 

  530. 				$output[] = $row;

    531. 

  531. 			} else {	// ... or add:

    532. 

  532. 				$output[] = $row;

    533. 

  533. 			}

    534. 

  534. 		}

    535. 

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

    536. 

  536. 

    537. 

  537. 		return $output;

    538. 

  538. 	}

    539. 

  539. 

    540. 

  540. 	/**

    541. 

  541. 	 * Links to the module script and sets necessary parameters (only for pathcache display)

    542. 

  542. 	 *

    543. 

  543. 	 * @param	string		Additional GET vars

    544. 

  544. 	 * @return	string		script + query

    545. 

  545. 	 */

    546. 

  546. 	function linkSelf($addParams)	{

    547. 

  547. 		return htmlspecialchars('index.php?id='.$this->pObj->id.'&showLanguage='.rawurlencode(t3lib_div::_GP('showLanguage')).$addParams);

    548. 

  548. 	}

    549. 

  549. 

    550. 

  550. 	/**

    551. 

  551. 	 * Create search form

    552. 

  552. 	 *

    553. 

  553. 	 * @return	string		HTML

    554. 

  554. 	 */

    555. 

  555. 	function renderSearchForm()	{

    556. 

  556. 

    557. 

  557. 		$output = '<fieldset>';

    558. 

  558. 		$output .= $this->getLanguageSelector();

    559. 

  559. 		$output .= '<div>' . $this->getSearchField() . '</div>';

    560. 

  560. 		$output .= $this->getReplaceAndDeleteFields();

    561. 

  561. 

    562. 

  562. 		$output.= '<input type="hidden" name="id" value="' . $this->pObj->id . '" />';

    563. 

  563. 		$output.= '</fieldset>';

    564. 

  564. 

    565. 

  565. 		return $output;

    566. 

  566. 	}

    567. 

  567. 

    568. 

  568. 	/**

    569. 

  569. 	 * Obtains fields for replace/delete.

    570. 

  570. 	 *

    571. 

  571. 	 * @return string

    572. 

  572. 	 */

    573. 

  573. 	private function getReplaceAndDeleteFields() {

    574. 

  574. 		$output = '';

    575. 

  575. 

    576. 

  576. 		if ($this->searchResultCounter && !t3lib_div::_POST('_replace') && !t3lib_div::_POST('_delete'))	{

    577. 

  577. 			$output .= '<div><label for="pathPrefixReplace">Replace with:</label> <input type="text" name="pathPrefixReplace" value="'.htmlspecialchars(t3lib_div::_GP('pathPrefixSearch')).'" />';

    578. 

  578. 			$output .= '<input type="submit" name="_replace" value="Replace" /> or <input type="submit" name="_delete" value="Delete" /></div>';

    579. 

  579. 			$output .= '<div><b>'.sprintf('Found: %d result(s).',$this->searchResultCounter).'</b></div>';

    580. 

  580. 		}

    581. 

  581. 		return $output;

    582. 

  582. 	}

    583. 

  583. 

    584. 

  584. 	/**

    585. 

  585. 	 * Enter description here ...

    586. 

  586. 	 * @param output

    587. 

  587. 	 */

    588. 

  588. 	protected function getSearchField() {

    589. 

  589. 		$output = '<label for="pathPrefixSearch">' . $GLOBALS['LANG']->getLL('search_path', true) .

    590. 

  590. 			'</label> <input type="text" name="pathPrefixSearch" id="pathPrefixSearch" value="' .

    591. 

  591. 				htmlspecialchars(t3lib_div::_GP('pathPrefixSearch')).'" />' .

    592. 

  592. 			'<input type="submit" name="_" value="' .

    593. 

  593. 				$GLOBALS['LANG']->getLL('look_up', true) . '" />';

    594. 

  594. 

    595. 

  595. 		return $output;

    596. 

  596. 	}

    597. 

  597. 

    598. 

  598. 

    599. 

  599. 	/**

    600. 

  600. 	 * Generates language selector.

    601. 

  601. 	 *

    602. 

  602. 	 * @return string

    603. 

  603. 	 */

    604. 

  604. 	protected function getLanguageSelector() {

    605. 

  605. 		$languages = $this->getSystemLanguages();

    606. 

  606. 

    607. 

  607. 		$options = array();

    608. 

  608. 		$showLanguage = t3lib_div::_GP('showLanguage');

    609. 

  609. 		foreach ($languages as $language) {

    610. 

  610. 			$selected = $showLanguage === $language['uid'] ? ' selected="selected"' : '';

    611. 

  611. 			$options[] = '<option value="' . $language['uid'] . '"' . $selected . '>' .

    612. 

  612. 				htmlspecialchars($language['title']) . '</option>';

    613. 

  613. 		}

    614. 

  614. 

    615. 

  615. 		return '<div><label for="showLanguage">' . $GLOBALS['LANG']->getLL('language', true) .

    616. 

  616. 			'</label> <select name="showLanguage">' . implode('', $options).'</select></div>';

    617. 

  617. 	}

    618. 

  618. 

    619. 

  619. 	/**

    620. 

  620. 	 * Obtains system languages.

    621. 

  621. 	 *

    622. 

  622. 	 * @return array

    623. 

  623. 	 */

    624. 

  624. 	protected function getSystemLanguages() {

    625. 

  625. 		$languages = (array)t3lib_BEfunc::getRecordsByField('sys_language','pid',0,'','','title');

    626. 

  626. 

    627. 

  627. 		$defaultLanguageLabel = $this->getDefaultLanguageName();

    628. 

  628. 

    629. 

  629. 		array_unshift($languages, array('uid' => 0, 'title' => $defaultLanguageLabel));

    630. 

  630. 		array_unshift($languages, array('uid' => '', 'title' => $GLOBALS['LANG']->getLL('all_languages')));

    631. 

  631. 

    632. 

  632. 		return $languages;

    633. 

  633. 	}

    634. 

  634. 

    635. 

  635. 	/**

    636. 

  636. 	 * Obtains the name of the default language.

    637. 

  637. 	 *

    638. 

  638. 	 * @return string

    639. 

  639. 	 */

    640. 

  640. 	protected function getDefaultLanguageName() {

    641. 

  641. 		$tsConfig = t3lib_BEfunc::getPagesTSconfig($this->pObj->id);

    642. 

  642. 		if (isset($tsConfig['mod.']['SHARED.']['defaultLanguageLabel'])) {

    643. 

  643. 			$label = $tsConfig['mod.']['SHARED.']['defaultLanguageLabel'];

    644. 

  644. 		}

    645. 

  645. 		else {

    646. 

  646. 			$label = $GLOBALS['LANG']->getLL('default_language');

    647. 

  647. 		}

    648. 

  648. 		return $label;

    649. 

  649. 	}

    650. 

  650. 

    651. 

  651. 	/**

    652. 

  652. 	 * Deletes an entry in pathcache table

    653. 

  653. 	 *

    654. 

  654. 	 * @param	integer		Path Cache id (cache_id)

    655. 

  655. 	 * @return	void

    656. 

  656. 	 */

    657. 

  657. 	function deletePathCacheEntry($cache_id)	{

    658. 

  658. 		$GLOBALS['TYPO3_DB']->exec_DELETEquery('tx_realurl_pathcache','cache_id='.intval($cache_id));

    659. 

  659. 	}

    660. 

  660. 

    661. 

  661. 	/**

    662. 

  662. 	 * Deletes an entry in pathcache table

    663. 

  663. 	 *

    664. 

  664. 	 * @param	integer		Path Cache id (cache_id)

    665. 

  665. 	 * @return	void

    666. 

  666. 	 */

    667. 

  667. 	function raiseExpirePathCacheEntry(&$row)	{

    668. 

  668. 		$row['expire'] = time()+30*24*3600;

    669. 

  669. 		$GLOBALS['TYPO3_DB']->exec_UPDATEquery('tx_realurl_pathcache','expire>0 AND cache_id='.intval($row['cache_id']),array('expire' => $row['expire']));

    670. 

  670. 	}

    671. 

  671. 

    672. 

  672. 	/**

    673. 

  673. 	 * Copies an entry in pathcache table

    674. 

  674. 	 *

    675. 

  675. 	 * @param	array		Record to copy, passed by reference, will be updated.

    676. 

  676. 	 * @return	array		New record.

    677. 

  677. 	 */

    678. 

  678. 	function copyPathCacheEntry(&$oEntry)	{

    679. 

  679. 

    680. 

  680. 			// Select old record:

    681. 

  681. 		$cEntry = $oEntry;

    682. 

  682. 		unset($cEntry['cache_id']);

    683. 

  683. 		$GLOBALS['TYPO3_DB']->exec_INSERTquery('tx_realurl_pathcache',$cEntry);

    684. 

  684. 		$cEntry['cache_id'] = $GLOBALS['TYPO3_DB']->sql_insert_id();

    685. 

  685. 

    686. 

  686. 			// Update the old record with expire time:

    687. 

  687. 		if (!$oEntry['expire'])	{

    688. 

  688. 			$oEntry['expire'] = time()+30*24*3600;

    689. 

  689. 			$field_values = array(

    690. 

  690. 				'expire' => $oEntry['expire'],

    691. 

  691. 			);

    692. 

  692. 			$GLOBALS['TYPO3_DB']->exec_UPDATEquery('tx_realurl_pathcache','cache_id='.intval($oEntry['cache_id']), $field_values);

    693. 

  693. 		}

    694. 

  694. 

    695. 

  695. 		return $cEntry;

    696. 

  696. 	}

    697. 

  697. 

    698. 

  698. 	/**

    699. 

  699. 	 * Changes the "pagepath" value of an entry in the pathcache table

    700. 

  700. 	 *

    701. 

  701. 	 * @param	integer		Path Cache id (cache_id)

    702. 

  702. 	 * @param	string		New value for the pagepath

    703. 

  703. 	 * @return	void

    704. 

  704. 	 */

    705. 

  705. 	function editPathCacheEntry($cache_id,$value)	{

    706. 

  706. 		$field_values = array(

    707. 

  707. 			'pagepath' => $value

    708. 

  708. 		);

    709. 

  709. 		$GLOBALS['TYPO3_DB']->exec_UPDATEquery('tx_realurl_pathcache','cache_id='.intval($cache_id), $field_values);

    710. 

  710. 

    711. 

  711. 			// Look up the page id so we can clear the encodeCache entries:

    712. 

  712. 		list($page_id_rec) = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows('page_id', 'tx_realurl_pathcache','cache_id='.intval($cache_id));

    713. 

  713. 		$this->clearDEncodeCache('page_'.$page_id_rec['page_id']); // Encode cache

    714. 

  714. 		$this->clearDEncodeCache('page_'.$page_id_rec['page_id'],TRUE);	// Decode cache

    715. 

  715. 	}

    716. 

  716. 

    717. 

  717. 	/**

    718. 

  718. 	 * Will look for submitted pagepath cache entries to save

    719. 

  719. 	 *

    720. 

  720. 	 * @return	void

    721. 

  721. 	 */

    722. 

  722. 	function edit_save()	{

    723. 

  723. 		if (t3lib_div::_POST('_edit_save'))	{

    724. 

  724. 			$editArray = t3lib_div::_POST('edit');

    725. 

  725. 			foreach($editArray as $cache_id => $value)	{

    726. 

  726. 				$this->editPathCacheEntry($cache_id,trim($value));

    727. 

  727. 			}

    728. 

  728. 		}

    729. 

  729. 	}

    730. 

  730. 

    731. 

  731. 	/**

    732. 

  732. 	 * Save / Cancel buttons

    733. 

  733. 	 *

    734. 

  734. 	 * @param	string		Extra code.

    735. 

  735. 	 * @return	string		Form elements

    736. 

  736. 	 */

    737. 

  737. 	function saveCancelButtons($extra='')	{

    738. 

  738. 		$output = '<input type="submit" name="_edit_save" value="Save" /> ';

    739. 

  739. 		$output .= '<input type="submit" name="_edit_cancel" value="Cancel" />';

    740. 

  740. 		$output .= $extra;

    741. 

  741. 

    742. 

  742. 		return $output;

    743. 

  743. 	}

    744. 

  744. 

    745. 

  745. 

    746. 

  746. 

    747. 

  747. 

    748. 

  748. 

    749. 

  749. 

    750. 

  750. 

    751. 

  751. 

    752. 

  752. 

    753. 

  753. 

    754. 

  754. 

    755. 

  755. 	/**************************

    756. 

  756. 	 *

    757. 

  757. 	 * Decode view

    758. 

  758. 	 *

    759. 

  759. 	 **************************/

    760. 

  760. 

    761. 

  761. 

    762. 

  762. 	/**

    763. 

  763. 	 * Rendering the decode-cache content

    764. 

  764. 	 *

    765. 

  765. 	 * @param	array		The Page tree data

    766. 

  766. 	 * @return	string		HTML for the information table.

    767. 

  767. 	 */

    768. 

  768. 	function decodeView(t3lib_pageTree $tree)	{

    769. 

  769. 

    770. 

  770. 			// Delete entries:

    771. 

  771. 		$cmd = t3lib_div::_GP('cmd');

    772. 

  772. 		$subcmd = '';

    773. 

  773. 		if ($cmd === 'deleteDC')	{

    774. 

  774. 			$subcmd = t3lib_div::_GP('entry');

    775. 

  775. 			$this->clearDEncodeCache($subcmd,TRUE);

    776. 

  776. 		}

    777. 

  777. 

    778. 

  778. 			// Traverse tree:

    779. 

  779. 		$output = '';

    780. 

  780. 		$cc=0;

    781. 

  781. 		$countDisplayed = 0;

    782. 

  782. 		foreach($tree->tree as $row)	{

    783. 

  783. 

    784. 

  784. 				// Select rows:

    785. 

  785. 			$displayRows = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows('*','tx_realurl_urldecodecache','page_id='.intval($row['row']['uid']),'','spurl');

    786. 

  786. 

    787. 

  787. 				// Row title:

    788. 

  788. 			$rowTitle = $row['HTML'].t3lib_BEfunc::getRecordTitle('pages',$row['row'],TRUE);

    789. 

  789. 

    790. 

  790. 				// Add at least one empty element:

    791. 

  791. 			if (!count($displayRows) || $subcmd==='displayed')	{

    792. 

  792. 

    793. 

  793. 					// Add title:

    794. 

  794. 				$tCells = array();

    795. 

  795. 				$tCells[]='<td nowrap="nowrap">'.$rowTitle.'</td>';

    796. 

  796. 

    797. 

  797. 					// Empty row:

    798. 

  798. 				$tCells[]='<td colspan="6" align="center">&nbsp;</td>';

    799. 

  799. 

    800. 

  800. 					// Compile Row:

    801. 

  801. 				$output.= '

    802. 

  802. 					<tr class="bgColor'.($cc%2 ? '-20':'-10').'">

    803. 

  803. 						'.implode('

    804. 

  804. 						',$tCells).'

    805. 

  805. 					</tr>';

    806. 

  806. 				$cc++;

    807. 

  807. 

    808. 

  808. 				if ($subcmd==='displayed') {

    809. 

  809. 					foreach($displayRows as $c => $inf)	{

    810. 

  810. 						$this->clearDEncodeCache('urlhash_'.$inf['url_hash'],TRUE);

    811. 

  811. 					}

    812. 

  812. 				}

    813. 

  813. 			} else {

    814. 

  814. 				foreach($displayRows as $c => $inf)	{

    815. 

  815. 

    816. 

  816. 						// Add icon/title and ID:

    817. 

  817. 					$tCells = array();

    818. 

  818. 					if (!$c)	{

    819. 

  819. 						$tCells[]='<td nowrap="nowrap" rowspan="'.count($displayRows).'">'.$rowTitle.'</td>';

    820. 

  820. 						$tCells[]='<td nowrap="nowrap" rowspan="'.count($displayRows).'">'.$row['row']['uid'].'</td>';

    821. 

  821. 						$tCells[]='<td rowspan="'.count($displayRows).'">'.

    822. 

  822. 							'<a href="'.$this->linkSelf('&cmd=deleteDC&entry=page_'.intval($row['row']['uid'])).'">'.

    823. 

  823. 							'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="Delete entries for page" alt="" />'.

    824. 

  824. 							'</a>'.

    825. 

  825. 						'</td>';

    826. 

  826. 					}

    827. 

  827. 

    828. 

  828. 						// Path:

    829. 

  829. 					$tCells[]='<td>'.htmlspecialchars($inf['spurl']).'</td>';

    830. 

  830. 

    831. 

  831. 						// Get vars:

    832. 

  832. 					$queryValues = unserialize($inf['content']);

    833. 

  833. 					$queryParams = '?id='.$queryValues['id'].

    834. 

  834. 									(is_array($queryValues['GET_VARS']) ? t3lib_div::implodeArrayForUrl('',$queryValues['GET_VARS']) : '');

    835. 

  835. 					$tCells[]='<td>'.htmlspecialchars($queryParams).'</td>';

    836. 

  836. 

    837. 

  837. 						// Delete:

    838. 

  838. 					$tCells[]='<td>'.

    839. 

  839. 							'<a href="'.$this->linkSelf('&cmd=deleteDC&entry=urlhash_'.intval($inf['url_hash'])).'">'.

    840. 

  840. 							'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="Delete entry" alt="" />'.

    841. 

  841. 							'</a>'.

    842. 

  842. 						'</td>';

    843. 

  843. 

    844. 

  844. 						// Timestamp:

    845. 

  845. 					$tCells[]='<td>'.htmlspecialchars(t3lib_BEfunc::datetime($inf['tstamp'])).' / '.htmlspecialchars(t3lib_BEfunc::calcAge(time()-$inf['tstamp'])).'</td>';

    846. 

  846. 

    847. 

  847. 						// Compile Row:

    848. 

  848. 					$output.= '

    849. 

  849. 						<tr class="bgColor'.($cc%2 ? '-20':'-10').'">

    850. 

  850. 							'.implode('

    851. 

  851. 							',$tCells).'

    852. 

  852. 						</tr>';

    853. 

  853. 					$cc++;

    854. 

  854. 					$countDisplayed++;

    855. 

  855. 				}

    856. 

  856. 			}

    857. 

  857. 		}

    858. 

  858. 

    859. 

  859. 		list($count_allInTable) = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows('count(*) AS count','tx_realurl_urldecodecache','');

    860. 

  860. 

    861. 

  861. 			// Create header:

    862. 

  862. 		$tCells = array();

    863. 

  863. 		$tCells[]='<td>Title:</td>';

    864. 

  864. 		$tCells[]='<td>ID:</td>';

    865. 

  865. 		$tCells[]='<td>&nbsp;</td>';

    866. 

  866. 		$tCells[]='<td>Path:</td>';

    867. 

  867. 		$tCells[]='<td>GET variables:</td>';

    868. 

  868. 		$tCells[]='<td>&nbsp;</td>';

    869. 

  869. 		$tCells[]='<td>Timestamp:</td>';

    870. 

  870. 

    871. 

  871. 		$output = '

    872. 

  872. 			<tr class="bgColor5 tableheader">

    873. 

  873. 				'.implode('

    874. 

  874. 				',$tCells).'

    875. 

  875. 			</tr>'.$output;

    876. 

  876. 

    877. 

  877. 			// Compile final table and return:

    878. 

  878. 		$output = '<br/><br/>

    879. 

  879. 		Displayed entries: <b>'.$countDisplayed.'</b> '.

    880. 

  880. 			'<a href="'.$this->linkSelf('&cmd=deleteDC&entry=displayed').'">'.

    881. 

  881. 			'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="Delete displayed entries" alt="" />'.

    882. 

  882. 			'</a>'.

    883. 

  883. 		'<br/>

    884. 

  884. 		Total entries in decode cache: <b>'.$count_allInTable['count'].'</b> '.

    885. 

  885. 			'<a href="'.$this->linkSelf('&cmd=deleteDC&entry=all').'">'.

    886. 

  886. 			'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="Delete WHOLE decode cache!" alt="" />'.

    887. 

  887. 			'</a>'.

    888. 

  888. 		'<br/>

    889. 

  889. 		<table border="0" cellspacing="1" cellpadding="0" id="tx-realurl-pathcacheTable" class="lrPadding c-list">'.$output.'

    890. 

  890. 		</table>';

    891. 

  891. 

    892. 

  892. 		return $output;

    893. 

  893. 	}

    894. 

  894. 

    895. 

  895. 

    896. 

  896. 

    897. 

  897. 

    898. 

  898. 

    899. 

  899. 

    900. 

  900. 

    901. 

  901. 

    902. 

  902. 

    903. 

  903. 

    904. 

  904. 

    905. 

  905. 	/**************************

    906. 

  906. 	 *

    907. 

  907. 	 * Encode view

    908. 

  908. 	 *

    909. 

  909. 	 **************************/

    910. 

  910. 

    911. 

  911. 

    912. 

  912. 	/**

    913. 

  913. 	 * Rendering the encode-cache content

    914. 

  914. 	 *

    915. 

  915. 	 * @param	array		The Page tree data

    916. 

  916. 	 * @return	string		HTML for the information table.

    917. 

  917. 	 */

    918. 

  918. 	function encodeView(t3lib_pageTree $tree)	{

    919. 

  919. 

    920. 

  920. 			// Delete entries:

    921. 

  921. 		$cmd = t3lib_div::_GP('cmd');

    922. 

  922. 		$subcmd = '';

    923. 

  923. 		if ($cmd === 'deleteEC')	{

    924. 

  924. 			$subcmd = t3lib_div::_GP('entry');

    925. 

  925. 			$this->clearDEncodeCache($subcmd);

    926. 

  926. 		}

    927. 

  927. 

    928. 

  928. 			// Traverse tree:

    929. 

  929. 		$cc = 0;

    930. 

  930. 		$countDisplayed = 0;

    931. 

  931. 		$output = '';

    932. 

  932. 		$duplicates = array();

    933. 

  933. 

    934. 

  934. 		foreach($tree->tree as $row)	{

    935. 

  935. 

    936. 

  936. 				// Select rows:

    937. 

  937. 			$displayRows = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows('*','tx_realurl_urlencodecache','page_id='.intval($row['row']['uid']),'','content');

    938. 

  938. 

    939. 

  939. 				// Row title:

    940. 

  940. 			$rowTitle = $row['HTML'].t3lib_BEfunc::getRecordTitle('pages',$row['row'],TRUE);

    941. 

  941. 

    942. 

  942. 				// Add at least one empty element:

    943. 

  943. 			if (!count($displayRows) || $subcmd==='displayed')	{

    944. 

  944. 

    945. 

  945. 					// Add title:

    946. 

  946. 				$tCells = array();

    947. 

  947. 				$tCells[]='<td nowrap="nowrap">'.$rowTitle.'</td>';

    948. 

  948. 				$tCells[]='<td nowrap="nowrap">&nbsp;</td>';

    949. 

  949. 

    950. 

  950. 					// Empty row:

    951. 

  951. 				$tCells[]='<td colspan="7" align="center">&nbsp;</td>';

    952. 

  952. 

    953. 

  953. 					// Compile Row:

    954. 

  954. 				$output.= '

    955. 

  955. 					<tr class="bgColor'.($cc%2 ? '-20':'-10').'">

    956. 

  956. 						'.implode('

    957. 

  957. 						',$tCells).'

    958. 

  958. 					</tr>';

    959. 

  959. 				$cc++;

    960. 

  960. 

    961. 

  961. 				if ($subcmd==='displayed') {

    962. 

  962. 					foreach($displayRows as $c => $inf)	{

    963. 

  963. 						$this->clearDEncodeCache('urlhash_'.$inf['url_hash']);

    964. 

  964. 					}

    965. 

  965. 				}

    966. 

  966. 			} else {

    967. 

  967. 				foreach($displayRows as $c => $inf)	{

    968. 

  968. 						// Add icon/title and ID:

    969. 

  969. 					$tCells = array();

    970. 

  970. 					if (!$c)	{

    971. 

  971. 						$tCells[]='<td nowrap="nowrap" rowspan="'.count($displayRows).'">'.$rowTitle.'</td>';

    972. 

  972. 						$tCells[]='<td nowrap="nowrap" rowspan="'.count($displayRows).'">'.$row['row']['uid'].'</td>';

    973. 

  973. 						$tCells[]='<td rowspan="'.count($displayRows).'">'.

    974. 

  974. 							'<a href="'.$this->linkSelf('&cmd=deleteEC&entry=page_'.intval($row['row']['uid'])).'">'.

    975. 

  975. 							'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="Delete entries for page" alt="" />'.

    976. 

  976. 							'</a>'.

    977. 

  977. 						'</td>';

    978. 

  978. 					}

    979. 

  979. 

    980. 

  980. 						// Get vars:

    981. 

  981. 					$tCells[]='<td>'.htmlspecialchars(t3lib_div::fixed_lgd_cs($inf['origparams'], 100)).'</td>';

    982. 

  982. 

    983. 

  983. 						// Internal Extras:

    984. 

  984. 					$tCells[]='<td>'.($inf['internalExtras'] ? t3lib_div::arrayToLogString(unserialize($inf['internalExtras'])) : '&nbsp;').'</td>';

    985. 

  985. 

    986. 

  986. 						// Path:

    987. 

  987. 					$tCells[]='<td>'.htmlspecialchars(t3lib_div::fixed_lgd_cs($inf['content'],100)).'</td>';

    988. 

  988. 

    989. 

  989. 						// Delete:

    990. 

  990. 					$tCells[]='<td>'.

    991. 

  991. 							'<a href="'.$this->linkSelf('&cmd=deleteEC&entry=urlhash_'.intval($inf['url_hash'])).'">'.

    992. 

  992. 							'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="Delete entry" alt="" />'.

    993. 

  993. 							'</a>'.

    994. 

  994. 						'</td>';

    995. 

  995. 

    996. 

  996. 						// Error:

    997. 

  997. 					$eMsg = ($duplicates[$inf['content']] && $duplicates[$inf['content']] !== $row['row']['uid'] ? $this->pObj->doc->icons(2).'Already used on page ID '.$duplicates[$inf['content']].'<br/>' : '');

    998. 

  998. 					if (count($GLOBALS['TYPO3_DB']->exec_SELECTgetRows('url_hash','tx_realurl_redirects','url_hash='.intval(t3lib_div::md5int($inf['content'])))))	{

    999. 

  999. 						$eMsg.= $this->pObj->doc->icons(3).'Also a redirect!';

    1000. 

  1000. 					}

    1001. 

  1001. 					$tCells[]='<td>'.$eMsg.'</td>';

    1002. 

  1002. 

    1003. 

  1003. 						// Timestamp:

    1004. 

  1004. 					$tCells[]='<td>'.htmlspecialchars(t3lib_BEfunc::datetime($inf['tstamp'])).' / '.htmlspecialchars(t3lib_BEfunc::calcAge(time()-$inf['tstamp'])).'</td>';

    1005. 

  1005. 

    1006. 

  1006. 						// Compile Row:

    1007. 

  1007. 					$output.= '

    1008. 

  1008. 						<tr class="bgColor'.($cc%2 ? '-20':'-10').'">

    1009. 

  1009. 							'.implode('

    1010. 

  1010. 							',$tCells).'

    1011. 

  1011. 						</tr>';

    1012. 

  1012. 					$cc++;

    1013. 

  1013. 

    1014. 

  1014. 					$countDisplayed++;

    1015. 

  1015. 

    1016. 

  1016. 					if (!isset($duplicates[$inf['content']]))	{

    1017. 

  1017. 						$duplicates[$inf['content']] = $row['row']['uid'];

    1018. 

  1018. 					}

    1019. 

  1019. 				}

    1020. 

  1020. 			}

    1021. 

  1021. 		}

    1022. 

  1022. 

    1023. 

  1023. 		list($count_allInTable) = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows('count(*) AS count','tx_realurl_urlencodecache','');

    1024. 

  1024. 

    1025. 

  1025. 			// Create header:

    1026. 

  1026. 		$tCells = array();

    1027. 

  1027. 		$tCells[]='<td>Title:</td>';

    1028. 

  1028. 		$tCells[]='<td>ID:</td>';

    1029. 

  1029. 		$tCells[]='<td>&nbsp;</td>';

    1030. 

  1030. 		$tCells[]='<td>Host | GET variables:</td>';

    1031. 

  1031. 		$tCells[]='<td>Internal Extras:</td>';

    1032. 

  1032. 		$tCells[]='<td>Path:</td>';

    1033. 

  1033. 		$tCells[]='<td>&nbsp;</td>';

    1034. 

  1034. 		$tCells[]='<td>Errors:</td>';

    1035. 

  1035. 		$tCells[]='<td>Timestamp:</td>';

    1036. 

  1036. 

    1037. 

  1037. 		$output = '

    1038. 

  1038. 			<tr class="bgColor5 tableheader">

    1039. 

  1039. 				'.implode('

    1040. 

  1040. 				',$tCells).'

    1041. 

  1041. 			</tr>'.$output;

    1042. 

  1042. 

    1043. 

  1043. 			// Compile final table and return:

    1044. 

  1044. 		$output = '

    1045. 

  1045. 

    1046. 

  1046. 		<br/>

    1047. 

  1047. 		<br/>

    1048. 

  1048. 		Displayed entries: <b>'.$countDisplayed.'</b> '.

    1049. 

  1049. 			'<a href="'.$this->linkSelf('&cmd=deleteEC&entry=displayed').'">'.

    1050. 

  1050. 			'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="Delete displayed entries" alt="" />'.

    1051. 

  1051. 			'</a>'.

    1052. 

  1052. 		'<br/>

    1053. 

  1053. 		Total entries in encode cache: <b>'.$count_allInTable['count'].'</b> '.

    1054. 

  1054. 			'<a href="'.$this->linkSelf('&cmd=deleteEC&entry=all').'">'.

    1055. 

  1055. 			'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="Delete WHOLE encode cache!" alt="" />'.

    1056. 

  1056. 			'</a>'.

    1057. 

  1057. 		'<br/>

    1058. 

  1058. 		<table border="0" cellspacing="1" cellpadding="0" id="tx-realurl-pathcacheTable" class="lrPadding c-list">'.$output.'

    1059. 

  1059. 		</table>';

    1060. 

  1060. 

    1061. 

  1061. 		return $output;

    1062. 

  1062. 	}

    1063. 

  1063. 

    1064. 

  1064. 	/**

    1065. 

  1065. 	 *

    1066. 

  1066. 	 */

    1067. 

  1067. 	function clearDEncodeCache($cmd, $decodeCache=FALSE)	{

    1068. 

  1068. 

    1069. 

  1069. 		$table = $decodeCache ? 'tx_realurl_urldecodecache' : 'tx_realurl_urlencodecache';

    1070. 

  1070. 

    1071. 

  1071. 		list($keyword,$id) = explode('_', $cmd);

    1072. 

  1072. 

    1073. 

  1073. 		switch((string)$keyword)	{

    1074. 

  1074. 			case 'all':

    1075. 

  1075. 				$GLOBALS['TYPO3_DB']->exec_DELETEquery($table, '');

    1076. 

  1076. 			break;

    1077. 

  1077. 			case 'page':

    1078. 

  1078. 				$GLOBALS['TYPO3_DB']->exec_DELETEquery($table, 'page_id='.intval($id));

    1079. 

  1079. 			break;

    1080. 

  1080. 			case 'urlhash':

    1081. 

  1081. 				$GLOBALS['TYPO3_DB']->exec_DELETEquery($table, 'url_hash='.intval($id));

    1082. 

  1082. 			break;

    1083. 

  1083. 			default:

    1084. 

  1084. 			break;

    1085. 

  1085. 		}

    1086. 

  1086. 	}

    1087. 

  1087. 

    1088. 

  1088. 

    1089. 

  1089. 

    1090. 

  1090. 

    1091. 

  1091. 

    1092. 

  1092. 

    1093. 

  1093. 

    1094. 

  1094. 

    1095. 

  1095. 

    1096. 

  1096. 	/*****************************

    1097. 

  1097. 	 *

    1098. 

  1098. 	 * Unique Alias

    1099. 

  1099. 	 *

    1100. 

  1100. 	 *****************************/

    1101. 

  1101. 

    1102. 

  1102. 	/**

    1103. 

  1103. 	 * Shows the mapping between aliases and unique IDs of arbitrary tables

    1104. 

  1104. 	 *

    1105. 

  1105. 	 * @return	string		HTML

    1106. 

  1106. 	 */

    1107. 

  1107. 	function uniqueAlias()	{

    1108. 

  1108. 

    1109. 

  1109. 		$tableName = t3lib_div::_GP('table');

    1110. 

  1110. 		$cmd = t3lib_div::_GET('cmd');

    1111. 

  1111. 		$entry = t3lib_div::_GET('entry');

    1112. 

  1112. 		$search = t3lib_div::_POST('search');

    1113. 

  1113. 

    1114. 

  1114. 			// Select rows:

    1115. 

  1115. 		$overviewRows = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows('tablename,count(*) as number_of_rows','tx_realurl_uniqalias','','tablename','','','tablename');

    1116. 

  1116. 

    1117. 

  1117. 		if ($tableName && isset($overviewRows[$tableName]))	{	// Show listing of single table:

    1118. 

  1118. 

    1119. 

  1119. 				// Some Commands:

    1120. 

  1120. 			if ($cmd==='delete')	{

    1121. 

  1121. 				if ($entry==='ALL')	{

    1122. 

  1122. 					$GLOBALS['TYPO3_DB']->exec_DELETEquery('tx_realurl_uniqalias','tablename='.$GLOBALS['TYPO3_DB']->fullQuoteStr($tableName,'tx_realurl_uniqalias'));

    1123. 

  1123. 				} else {

    1124. 

  1124. 					$GLOBALS['TYPO3_DB']->exec_DELETEquery('tx_realurl_uniqalias','tablename='.$GLOBALS['TYPO3_DB']->fullQuoteStr($tableName,'tx_realurl_uniqalias').' AND uid='.intval($entry));

    1125. 

  1125. 				}

    1126. 

  1126. 			}

    1127. 

  1127. 			if ($cmd==='flushExpired')	{

    1128. 

  1128. 				$GLOBALS['TYPO3_DB']->exec_DELETEquery('tx_realurl_uniqalias','tablename='.$GLOBALS['TYPO3_DB']->fullQuoteStr($tableName,'tx_realurl_uniqalias').' AND expire>0 AND expire<'.intval(time()));

    1129. 

  1129. 			}

    1130. 

  1130. 

    1131. 

  1131. 				// Select rows:

    1132. 

  1132. 			$tableContent = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows(

    1133. 

  1133. 				'*',

    1134. 

  1134. 				'tx_realurl_uniqalias',

    1135. 

  1135. 				'tablename='.$GLOBALS['TYPO3_DB']->fullQuoteStr($tableName,'tx_realurl_uniqalias').

    1136. 

  1136. 					($search ? ' AND (value_id='.$GLOBALS['TYPO3_DB']->fullQuoteStr($search,$tableName).' OR value_alias LIKE \'%'.$GLOBALS['TYPO3_DB']->quoteStr($search,$tableName).'%\')':''),

    1137. 

  1137. 				'',

    1138. 

  1138. 				'value_id, lang, expire'

    1139. 

  1139. 			);

    1140. 

  1140. 

    1141. 

  1141. 			$cc = 0; $field_id = $field_alias = $output = '';

    1142. 

  1142. 			$duplicates = array();

    1143. 

  1143. 			foreach($tableContent as $aliasRecord)	{

    1144. 

  1144. 					// Add data:

    1145. 

  1145. 				$tCells = array();

    1146. 

  1146. 				$tCells[]='<td>'.htmlspecialchars($aliasRecord['value_id']).'</td>';

    1147. 

  1147. 

    1148. 

  1148. 				if ((string)$cmd==='edit' && ($entry==='ALL' || !strcmp($entry,$aliasRecord['uid'])))	{

    1149. 

  1149. 					$tCells[]='<td>'.

    1150. 

  1150. 								'<input type="text" name="edit['.$aliasRecord['uid'].']" value="'.htmlspecialchars($aliasRecord['value_alias']).'" />'.

    1151. 

  1151. 								($entry!=='ALL' ? $this->saveCancelButtons('') : '').

    1152. 

  1152. 								'</td>';

    1153. 

  1153. 				} else {

    1154. 

  1154. 					$tCells[]='<td'.($aliasRecord['expire'] ? ' style="font-style: italic; color:#999999;"' : '').'>'.htmlspecialchars($aliasRecord['value_alias']).'</td>';

    1155. 

  1155. 				}

    1156. 

  1156. 

    1157. 

  1157. 				$tCells[]='<td>'.htmlspecialchars($aliasRecord['lang']).'</td>';

    1158. 

  1158. 				$tCells[]='<td'.($aliasRecord['expire'] && $aliasRecord['expire']<time() ? ' style="color: red;"':'').'>'.htmlspecialchars(t3lib_BEfunc::dateTimeAge($aliasRecord['expire'])).'</td>';

    1159. 

  1159. 

    1160. 

  1160. 				$tCells[]='<td>'.

    1161. 

  1161. 								// Edit link:

    1162. 

  1162. 							'<a href="'.$this->linkSelf('&table='.rawurlencode($tableName).'&cmd=edit&entry='.$aliasRecord['uid']).'">'.

    1163. 

  1163. 							'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/edit2.gif','width="11" height="12"').' title="" alt="" />'.

    1164. 

  1164. 							'</a>'.

    1165. 

  1165. 								// Delete link:

    1166. 

  1166. 							'<a href="'.$this->linkSelf('&table='.rawurlencode($tableName).'&cmd=delete&entry='.$aliasRecord['uid']).'">'.

    1167. 

  1167. 							'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="" alt="" />'.

    1168. 

  1168. 							'</a>'.

    1169. 

  1169. 							'</td>';

    1170. 

  1170. 

    1171. 

  1171. 

    1172. 

  1172. 

    1173. 

  1173. 				$tCells[]='<td>'.

    1174. 

  1174. 						(isset($duplicates[$aliasRecord['value_alias']]) ? $this->pObj->doc->icons(2).'Already used by ID '.$duplicates[$aliasRecord['value_alias']] :'&nbsp;').

    1175. 

  1175. 						'</td>';

    1176. 

  1176. 

    1177. 

  1177. 				$field_id = $aliasRecord['field_id'];

    1178. 

  1178. 				$field_alias = $aliasRecord['field_alias'];

    1179. 

  1179. 

    1180. 

  1180. 					// Compile Row:

    1181. 

  1181. 				$output .= '

    1182. 

  1182. 					<tr class="bgColor'.($cc%2 ? '-20':'-10').'">

    1183. 

  1183. 						'.implode('

    1184. 

  1184. 						',$tCells).'

    1185. 

  1185. 					</tr>';

    1186. 

  1186. 				$cc++;

    1187. 

  1187. 

    1188. 

  1188. 				$duplicates[$aliasRecord['value_alias']] = $aliasRecord['value_id'];

    1189. 

  1189. 			}

    1190. 

  1190. 

    1191. 

  1191. 				// Create header:

    1192. 

  1192. 			$tCells = array();

    1193. 

  1193. 			$tCells[]='<td>ID (Field: '.$field_id.')</td>';

    1194. 

  1194. 			$tCells[]='<td>Alias (Field: '.$field_alias.'):</td>';

    1195. 

  1195. 			$tCells[]='<td>Lang:</td>';

    1196. 

  1196. 			$tCells[]='<td>Expire:'.

    1197. 

  1197. 						(!$search ? '<a href="'.$this->linkSelf('&table='.rawurlencode($tableName).'&cmd=flushExpired').'">'.

    1198. 

  1198. 						'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="Flush expired" alt="" />'.

    1199. 

  1199. 						'</a>' : '').

    1200. 

  1200. 						'</td>';

    1201. 

  1201. 			$tCells[]='<td>'.

    1202. 

  1202. 						(!$search ? '<a href="'.$this->linkSelf('&table='.rawurlencode($tableName).'&cmd=edit&entry=ALL').'">'.

    1203. 

  1203. 						'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/edit2.gif','width="11" height="12"').' title="Edit all" alt="" />'.

    1204. 

  1204. 						'</a>'.

    1205. 

  1205. 						'<a href="'.$this->linkSelf('&table='.rawurlencode($tableName).'&cmd=delete&entry=ALL').'" onclick="return confirm(\'Delete all?\');">'.

    1206. 

  1206. 						'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="Delete all" alt="" />'.

    1207. 

  1207. 						'</a>' : '').

    1208. 

  1208. 						'</td>';

    1209. 

  1209. 			$tCells[]='<td>Error:</td>';

    1210. 

  1210. 

    1211. 

  1211. 			$output = '

    1212. 

  1212. 				<tr class="bgColor5 tableheader">

    1213. 

  1213. 					'.implode('

    1214. 

  1214. 					',$tCells).'

    1215. 

  1215. 				</tr>'.$output;

    1216. 

  1216. 					// Compile final table and return:

    1217. 

  1217. 			$output = '

    1218. 

  1218. 

    1219. 

  1219. 			<br/>

    1220. 

  1220. 			Table: <b>'.htmlspecialchars($tableName).'</b><br/>

    1221. 

  1221. 			Aliases: <b>'.htmlspecialchars(count($tableContent)).'</b><br/>

    1222. 

  1222. 			Search: <input type="text" name="search" value="'.htmlspecialchars($search).'" /><input type="submit" name="_" value="Search" />

    1223. 

  1223. 			<input type="hidden" name="table" value="'.htmlspecialchars($tableName).'" />

    1224. 

  1224. 			<input type="hidden" name="id" value="'.htmlspecialchars($this->pObj->id).'" />

    1225. 

  1225. 			<br/><br/>

    1226. 

  1226. 			<table border="0" cellspacing="1" cellpadding="0" id="tx-realurl-pathcacheTable" class="lrPadding c-list">'.$output.'

    1227. 

  1227. 			</table>';

    1228. 

  1228. 

    1229. 

  1229. 			if ($entry==='ALL')	{

    1230. 

  1230. 				$output.= $this->saveCancelButtons('<input type="hidden" name="table" value="'.htmlspecialchars($tableName).'" /><input type="hidden" name="id" value="'.htmlspecialchars($this->pObj->id).'" />');

    1231. 

  1231. 			}

    1232. 

  1232. 		} else {	// Create overview:

    1233. 

  1233. 			$cc=0;

    1234. 

  1234. 			$output='';

    1235. 

  1235. 			if (count($overviewRows))	{

    1236. 

  1236. 				foreach($overviewRows as $aliasRecord)	{

    1237. 

  1237. 

    1238. 

  1238. 						// Add data:

    1239. 

  1239. 					$tCells = array();

    1240. 

  1240. 					$tCells[]='<td><a href="'.$this->linkSelf('&table='.rawurlencode($aliasRecord['tablename'])).'">'.$aliasRecord['tablename'].'</a></td>';

    1241. 

  1241. 					$tCells[]='<td>'.$aliasRecord['number_of_rows'].'</td>';

    1242. 

  1242. 

    1243. 

  1243. 						// Compile Row:

    1244. 

  1244. 					$output.= '

    1245. 

  1245. 						<tr class="bgColor'.($cc%2 ? '-20':'-10').'">

    1246. 

  1246. 							'.implode('

    1247. 

  1247. 							',$tCells).'

    1248. 

  1248. 						</tr>';

    1249. 

  1249. 					$cc++;

    1250. 

  1250. 				}

    1251. 

  1251. 

    1252. 

  1252. 					// Create header:

    1253. 

  1253. 				$tCells = array();

    1254. 

  1254. 				$tCells[]='<td>Table:</td>';

    1255. 

  1255. 				$tCells[]='<td>Aliases:</td>';

    1256. 

  1256. 

    1257. 

  1257. 				$output = '

    1258. 

  1258. 					<tr class="bgColor5 tableheader">

    1259. 

  1259. 						'.implode('

    1260. 

  1260. 						',$tCells).'

    1261. 

  1261. 					</tr>'.$output;

    1262. 

  1262. 

    1263. 

  1263. 					// Compile final table and return:

    1264. 

  1264. 				$output = '

    1265. 

  1265. 				<table border="0" cellspacing="1" cellpadding="0" id="tx-realurl-pathcacheTable" class="lrPadding c-list">'.$output.'

    1266. 

  1266. 				</table>';

    1267. 

  1267. 			}

    1268. 

  1268. 		}

    1269. 

  1269. 

    1270. 

  1270. 		return $output;

    1271. 

  1271. 	}

    1272. 

  1272. 

    1273. 

  1273. 

    1274. 

  1274. 	/**

    1275. 

  1275. 	 * Changes the "alias" value of an entry in the unique alias table

    1276. 

  1276. 	 *

    1277. 

  1277. 	 * @param	integer		UID of unique alias

    1278. 

  1278. 	 * @param	string		New value for the alias

    1279. 

  1279. 	 * @return	void

    1280. 

  1280. 	 */

    1281. 

  1281. 	function editUniqAliasEntry($cache_id,$value)	{

    1282. 

  1282. 		$field_values = array(

    1283. 

  1283. 			'value_alias' => $value

    1284. 

  1284. 		);

    1285. 

  1285. 		$GLOBALS['TYPO3_DB']->exec_UPDATEquery('tx_realurl_uniqalias','uid='.intval($cache_id), $field_values);

    1286. 

  1286. 	}

    1287. 

  1287. 

    1288. 

  1288. 	/**

    1289. 

  1289. 	 * Will look for submitted unique alias entries to save

    1290. 

  1290. 	 *

    1291. 

  1291. 	 * @return	void

    1292. 

  1292. 	 */

    1293. 

  1293. 	function edit_save_uniqAlias()	{

    1294. 

  1294. 		if (t3lib_div::_POST('_edit_save'))	{

    1295. 

  1295. 			$editArray = t3lib_div::_POST('edit');

    1296. 

  1296. 			foreach($editArray as $cache_id => $value)	{

    1297. 

  1297. 				$this->editUniqAliasEntry($cache_id,trim($value));

    1298. 

  1298. 			}

    1299. 

  1299. 		}

    1300. 

  1300. 	}

    1301. 

  1301. 

    1302. 

  1302. 

    1303. 

  1303. 

    1304. 

  1304. 

    1305. 

  1305. 

    1306. 

  1306. 

    1307. 

  1307. 

    1308. 

  1308. 

    1309. 

  1309. 

    1310. 

  1310. 

    1311. 

  1311. 

    1312. 

  1312. 	/*****************************

    1313. 

  1313. 	 *

    1314. 

  1314. 	 * Configuration view:

    1315. 

  1315. 	 *

    1316. 

  1316. 	 *****************************/

    1317. 

  1317. 

    1318. 

  1318. 	/**

    1319. 

  1319. 	 * Shows configuration of the extension.

    1320. 

  1320. 	 *

    1321. 

  1321. 	 * @return	string		HTML

    1322. 

  1322. 	 */

    1323. 

  1323. 	function configView()	{

    1324. 

  1324. 		global $TYPO3_CONF_VARS;

    1325. 

  1325. 

    1326. 

  1326. 			// Include array browser:

    1327. 

  1327. 		require_once(PATH_t3lib . 'class.t3lib_arraybrowser.php');

    1328. 

  1328. 

    1329. 

  1329. 			// Initialize array browser:

    1330. 

  1330. 		$arrayBrowser = t3lib_div::makeInstance('t3lib_arrayBrowser');

    1331. 

  1331. 		/** @var t3lib_arrayBrowser $arrayBrowser */

    1332. 

  1332. 		$arrayBrowser->expAll = TRUE;

    1333. 

  1333. 		$arrayBrowser->fixedLgd = FALSE;

    1334. 

  1334. 		$arrayBrowser->dontLinkVar = TRUE;

    1335. 

  1335. 

    1336. 

  1336. 			// Create the display code:

    1337. 

  1337. 		$theVar = $TYPO3_CONF_VARS['EXTCONF']['realurl'];

    1338. 

  1338. 		$tree = $arrayBrowser->tree($theVar, '', '');

    1339. 

  1339. 

    1340. 

  1340. 		$tree = '<hr/>

    1341. 

  1341. 		<b>$TYPO3_CONF_VARS[\'EXTCONF\'][\'realurl\']</b>

    1342. 

  1342. 		<br/>

    1343. 

  1343. 		<span class="nobr">'.$tree.'</span>';

    1344. 

  1344. 

    1345. 

  1345. 		return $tree;

    1346. 

  1346. 	}

    1347. 

  1347. 

    1348. 

  1348. 

    1349. 

  1349. 

    1350. 

  1350. 

    1351. 

  1351. 

    1352. 

  1352. 

    1353. 

  1353. 

    1354. 

  1354. 

    1355. 

  1355. 

    1356. 

  1356. 

    1357. 

  1357. 

    1358. 

  1358. 	/*****************************

    1359. 

  1359. 	 *

    1360. 

  1360. 	 * Log view:

    1361. 

  1361. 	 *

    1362. 

  1362. 	 *****************************/

    1363. 

  1363. 

    1364. 

  1364. 	/**

    1365. 

  1365. 	 * View error log

    1366. 

  1366. 	 *

    1367. 

  1367. 	 * @return	string		HTML

    1368. 

  1368. 	 */

    1369. 

  1369. 	function logView()	{

    1370. 

  1370. 

    1371. 

  1371. 		$cmd = t3lib_div::_GP('cmd');

    1372. 

  1372. 		if ($cmd==='deleteAll')	{

    1373. 

  1373. 			$GLOBALS['TYPO3_DB']->exec_DELETEquery(

    1374. 

  1374. 				'tx_realurl_errorlog',

    1375. 

  1375. 				''

    1376. 

  1376. 			);

    1377. 

  1377. 		}

    1378. 

  1378. 

    1379. 

  1379. 		$list = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows(

    1380. 

  1380. 			'*',

    1381. 

  1381. 			'tx_realurl_errorlog',

    1382. 

  1382. 			'',

    1383. 

  1383. 			'',

    1384. 

  1384. 			'counter DESC, tstamp DESC',

    1385. 

  1385. 			100

    1386. 

  1386. 		);

    1387. 

  1387. 

    1388. 

  1388. 		if (is_array($list))	{

    1389. 

  1389. 			$output=''; $cc = 0;

    1390. 

  1390. 

    1391. 

  1391. 			foreach($list as $rec)	{

    1392. 

  1392. 				$host = '';

    1393. 

  1393. 				if ($rec['rootpage_id'] != 0) {

    1394. 

  1394. 					if (isset($hostCacheName[$rec['rootpage_id']])) {

    1395. 

  1395. 						$host = $hostCacheName[$rec['rootpage_id']];

    1396. 

  1396. 					}

    1397. 

  1397. 					else {

    1398. 

  1398. 						$hostCacheName[$rec['rootpage_id']] = $host = $this->getHostName($rec['rootpage_id']);

    1399. 

  1399. 					}

    1400. 

  1400. 				}

    1401. 

  1401. 

    1402. 

  1402. 					// Add data:

    1403. 

  1403. 				$tCells = array();

    1404. 

  1404. 				$tCells[]='<td>'.$rec['counter'].'</td>';

    1405. 

  1405. 				$tCells[]='<td>'.t3lib_BEfunc::dateTimeAge($rec['tstamp']).'</td>';

    1406. 

  1406. 				$tCells[]='<td><a href="'.htmlspecialchars($host.'/'.$rec['url']).'" target="_blank">'.($host ? $host . '/' : '') . htmlspecialchars($rec['url']).'</a>'.

    1407. 

  1407. 							' <a href="'.$this->linkSelf('&cmd=new&data[0][source]='.rawurlencode($rec['url']).'&SET[type]=redirects').'">'.

    1408. 

  1408. 							'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/napshot.gif','width="12" height="12"').' title="Set as redirect" alt="" />'.

    1409. 

  1409. 							'</a>'.

    1410. 

  1410. 							'</td>';

    1411. 

  1411. 				$tCells[]='<td>'.htmlspecialchars($rec['error']).'</td>';

    1412. 

  1412. 				$tCells[]='<td>'.

    1413. 

  1413. 								($rec['last_referer'] ? '<a href="'.htmlspecialchars($rec['last_referer']).'" target="_blank">'.htmlspecialchars($rec['last_referer']).'</a>' : '&nbsp;').

    1414. 

  1414. 								'</td>';

    1415. 

  1415. 				$tCells[]='<td>'.t3lib_BEfunc::datetime($rec['cr_date']).'</td>';

    1416. 

  1416. 

    1417. 

  1417. 					// Compile Row:

    1418. 

  1418. 				$output.= '

    1419. 

  1419. 					<tr class="bgColor'.($cc%2 ? '-20':'-10').'">

    1420. 

  1420. 						'.implode('

    1421. 

  1421. 						',$tCells).'

    1422. 

  1422. 					</tr>';

    1423. 

  1423. 				$cc++;

    1424. 

  1424. 			}

    1425. 

  1425. 				// Create header:

    1426. 

  1426. 			$tCells = array();

    1427. 

  1427. 			$tCells[]='<td>Counter:</td>';

    1428. 

  1428. 			$tCells[]='<td>Last time:</td>';

    1429. 

  1429. 			$tCells[]='<td>URL:</td>';

    1430. 

  1430. 			$tCells[]='<td>Error:</td>';

    1431. 

  1431. 			$tCells[]='<td>Last Referer:</td>';

    1432. 

  1432. 			$tCells[]='<td>First time:</td>';

    1433. 

  1433. 

    1434. 

  1434. 			$output = '

    1435. 

  1435. 				<tr class="bgColor5 tableheader">

    1436. 

  1436. 					'.implode('

    1437. 

  1437. 					',$tCells).'

    1438. 

  1438. 				</tr>'.$output;

    1439. 

  1439. 

    1440. 

  1440. 				// Compile final table and return:

    1441. 

  1441. 			$output = '

    1442. 

  1442. 			<br/>

    1443. 

  1443. 				<a href="'.$this->linkSelf('&cmd=deleteAll').'">'.

    1444. 

  1444. 				'<img'.t3lib_iconWorks::skinImg($this->pObj->doc->backPath,'gfx/garbage.gif','width="11" height="12"').' title="Delete All" alt="" />'.

    1445. 

  1445. 				' Flush log</a>

    1446. 

  1446. 				<br/>

    1447. 

  1447. 			<table border="0" cellspacing="1" cellpadding="0" id="tx-realurl-pathcacheTable" class="lrPadding c-list">'.$output.'

    1448. 

  1448. 			</table>';

    1449. 

  1449. 

    1450. 

  1450. 			return $output;

    1451. 

  1451. 		}

    1452. 

  1452. 	}

    1453. 

  1453. 

    1454. 

  1454. 	function getHostName($rootpage_id) {

    1455. 

  1455. 		foreach ($GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['realurl'] as $host => $config) {

    1456. 

  1456. 			if ($host != '_DEFAULT') {

    1457. 

  1457. 				$hostName = $host;

    1458. 

  1458. 				while ($config !== false && !is_array($config)) {

    1459. 

  1459. 					$host = $config;

    1460. 

  1460. 					$config = (isset($GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['realurl'][$host]) ? $GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['realurl'][$host] : false);

    1461. 

  1461. 				}

    1462. 

  1462. 				if (is_array($config) && isset($config['pagePath']) && isset($config['pagePath']['rootpage_id']) && $config['pagePath']['rootpage_id'] == $rootpage_id) {

    1463. 

  1463. 					return 'http://' . $hostName;

    1464. 

  1464. 				}

    1465. 

  1465. 			}

    1466. 

  1466. 		}

    1467. 

  1467. 		return '';

    1468. 

  1468. 	}

    1469. 

  1469. 

    1470. 

  1470. 

    1471. 

  1471. 	/*****************************

    1472. 

  1472. 	 *

    1473. 

  1473. 	 * Redirect view:

    1474. 

  1474. 	 *

    1475. 

  1475. 	 *****************************/

    1476. 

  1476. 

    1477. 

  1477. 	/**

    1478. 

  1478. 	 * Redirect view

    1479. 

  1479. 	 *

    1480. 

  1480. 	 * @return	string		HTML

    1481. 

  1481. 	 */

    1482. 

  1482. 	function redirectView()	{

    1483. 

  1483. 

    1484. 

  1484. 		$output = $this->pObj->doc->spacer(12);

    1485. 

  1485. 		$output .= $this->processRedirectActions();

    1486. 

  1486. 

    1487. 

  1487. 		list($sortingParameter, $sortingDirection) = $this->getRedirectViewSortingParameters();

    1488. 

  1488. 

    1489. 

  1489. 		$output .= $this->getRedirectsSearch();

    1490. 

  1490. 		$output .= $this->getRedirectViewHeader($sortingDirection);

    1491. 

  1491. 		$output .= $this->getRedirectsTableContent($sortingParameter, $sortingDirection);

    1492. 

  1492. 

    1493. 

  1493. 		return $output;

    1494. 

  1494. 	}

    1495. 

  1495. 

    1496. 

  1496. 	protected function getRedirectsSearch() {

    1497. 

  1497. 		$result = $this->getSearchField();

    1498. 

  1498. 		if (t3lib_div::_GP('pathPrefixSearch')) {

    1499. 

  1499. 			$result .= ' <input type="reset" name="_" value="' .

    1500. 

  1500. 				$GLOBALS['LANG']->getLL('show_all', true) . '" ' .

    1501. 

  1501. 				'onclick="document.getElementById(\'pathPrefixSearch\').value=\'\';document.forms[0].submit()" ' .

    1502. 

  1502. 				'/>';

    1503. 

  1503. 		}

    1504. 

  1504. 		$result .= '<input type="hidden" name="id" value="' . $this->pObj->id . '" />';

    1505. 

  1505. 

    1506. 

  1506. 		return $result;

    1507. 

  1507. 	}

    1508. 

  1508. 

    1509. 

  1509. 	/**

    1510. 

  1510. 	 * Creates a list of redirect entries.

    1511. 

  1511. 	 *

    1512. 

  1512. 	 * @param string $sortingParameter

    1513. 

  1513. 	 * @param string $sortingDirection

    1514. 

  1514. 	 * @return string

    1515. 

  1515. 	 */

    1516. 

  1516. 	protected function getRedirectsTableContent($sortingParameter, $sortingDirection) {

    1517. 

  1517. 		$itemCounter = 0;

    1518. 

  1518. 

    1519. 

  1519. 		$page = max(1, intval(t3lib_div:…
    1520.

Large files files are truncated, but you can click here to view the full file