Bug #18640 ยป 8158.diff

Administrator Admin, 2008-04-19 15:39

View differences:

/home/klee/eclipse/typo3_4.2/typo3/mod/tools/em/class.em_xmlhandler.php (working copy)
98 98
				$forder = 'category';
99 99
			break;
100 100
		}
101
		$order = $forder.', title';
101
		$order = $forder.', title, '
102
			// gets the x from a version number x.y.z as a number
103
			.'CAST(SUBSTRING_INDEX(version, \'.\', 1) AS UNSIGNED), '
104
			// gets the y from a version number x.y.z as a number
105
			.'CAST(SUBSTRING_INDEX('
106
				// gets the x.y from a version number x.y.z
107
				.'SUBSTRING_INDEX(version, \'.\', 2)'
108
			.', \'.\', -1) AS UNSIGNED), '
109
			// gets the z from a version number x.y.z as a number
110
			.'CAST(SUBSTRING_INDEX(version, \'.\', -1) AS UNSIGNED)';
111

  
102 112
		if (!$allVer)	{
103 113
			if ($this->useUnchecked)	{
104 114
				$where .= ' AND lastversion>0';
    (1-1/1)