projects / Packages / TYPO3.CMS.git / commitdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | patch | inline | side by side (parent: 52c714d)
[BUGFIX] impexp: Wrong FAL references after import 67/55367/2
authorChristian Kuhn <lolli@schwarzbu.ch>
Mon, 15 Jan 2018 14:54:57 +0000 (15:54 +0100)
committerChristian Kuhn <lolli@schwarzbu.ch>
Mon, 15 Jan 2018 19:51:02 +0000 (20:51 +0100)
Fix a case during ext:impexp FAL uid mapping where
sys_file_reference end up pointing to wrong sys_file
records in case new sys_file uids also already exist
in import file, due to multiple mappings.
Power the patch with a functional test - it fails
without the change in Import.php and is ok with the
change.
See the test method comments for more details
on what exactly is checked here.

Change-Id: I472cad2652e8d6f5d30e4ebc68ff1ae93de71ea1
Resolves: #67188
Releases: master, 8.7, 7.6
Reviewed-on: https://review.typo3.org/55367
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Christian Kuhn <lolli@schwarzbu.ch>
Tested-by: Christian Kuhn <lolli@schwarzbu.ch>
typo3/sysext/impexp/Classes/Import.php patch | blob | history
typo3/sysext/impexp/Tests/Functional/Fixtures/DatabaseAssertions/importPagesAndTtContentWithRemappingNewSysFileEntries.csv [new file with mode: 0644] patch | blob
typo3/sysext/impexp/Tests/Functional/Fixtures/DatabaseImports/sys_file_single_image.xml [new file with mode: 0644] patch | blob
typo3/sysext/impexp/Tests/Functional/Fixtures/XmlImports/pages-and-ttcontent-with-two-images.xml [new file with mode: 0644] patch | blob
typo3/sysext/impexp/Tests/Functional/Import/PagesAndTtContentWithImagesInFilledDatabaseTest.php patch | blob | history

diff --git a/typo3/sysext/impexp/Classes/Import.php b/typo3/sysext/impexp/Classes/Import.php
index 19fe74d..59002d5 100644 (file)
--- a/typo3/sysext/impexp/Classes/Import.php
+++ b/typo3/sysext/impexp/Classes/Import.php
@@ -511,10 +511,11 @@ class Import extends ImportExport
         }
 
         foreach ($this->dat['header']['records']['sys_file_reference'] as $sysFileReferenceUid => $_) {
-            $fileReferenceRecord = $this->dat['records']['sys_file_reference:' . $sysFileReferenceUid]['data'];
-            if ($fileReferenceRecord['uid_local'] == $oldFileUid) {
-                $fileReferenceRecord['uid_local'] = $newFileUid;
-                $this->dat['records']['sys_file_reference:' . $sysFileReferenceUid]['data'] = $fileReferenceRecord;
+            if (!isset($this->dat['records']['sys_file_reference:' . $sysFileReferenceUid]['hasBeenMapped'])
+                && $this->dat['records']['sys_file_reference:' . $sysFileReferenceUid]['data']['uid_local'] == $oldFileUid
+            ) {
+                $this->dat['records']['sys_file_reference:' . $sysFileReferenceUid]['hasBeenMapped'] = true;
+                $this->dat['records']['sys_file_reference:' . $sysFileReferenceUid]['data']['uid_local'] = $newFileUid;
             }
         }
     }
diff --git a/typo3/sysext/impexp/Tests/Functional/Fixtures/DatabaseAssertions/importPagesAndTtContentWithRemappingNewSysFileEntries.csv b/typo3/sysext/impexp/Tests/Functional/Fixtures/DatabaseAssertions/importPagesAndTtContentWithRemappingNewSysFileEntries.csv
new file mode 100644 (file)
index 0000000..ce8d3fc
--- /dev/null
+++ b/typo3/sysext/impexp/Tests/Functional/Fixtures/DatabaseAssertions/importPagesAndTtContentWithRemappingNewSysFileEntries.csv
@@ -0,0 +1,21 @@
+"pages"
+,"uid","pid","sorting","deleted","title"
+,1,0,256,0,"Root"
+"tt_content"
+,"uid","pid","sorting","deleted","header","image"
+,1,1,256,0,"CE 3 second image",1
+,2,1,128,0,"CE 2 second image",1
+,3,1,64,0,"CE 1 first image",1
+"sys_file_storage"
+,"uid","pid","name","driver"
+,1,0,"fileadmin/ (auto-created)","Local"
+"sys_file"
+,"uid","pid","storage","type","identifier","identifier_hash","folder_hash","extension","mime_type","name","sha1","size"
+,1,0,1,2,"/user_upload/typo3_image2.jpg","f90bb9a35622f35b5279195e324eddbaec8164b2","19669f1e02c2f16705ec7587044c66443be70725","jpg","image/jpeg","typo3_image2.jpg","da9acdf1e105784a57bbffec9520969578287797","7958"
+,2,0,1,2,"/user_upload/used-1.jpg","a0d28ab6398a25c7a0c24f6ace6a3b43d773115e","19669f1e02c2f16705ec7587044c66443be70725","jpg","image/jpeg","used-1.jpg","da9acdf1e105784a57bbffec9520969578287797","7958"
+,3,0,1,2,"/user_upload/used-2.jpg","5fd92415f6154c29349bbfb214b9e2d9dbb3d89a","19669f1e02c2f16705ec7587044c66443be70725","jpg","image/jpeg","used-2.jpg","c3511df85d21bc578faf71c6a19eeb3ff44af370","7425"
+"sys_file_reference"
+,"uid","pid","uid_local","uid_foreign","tablenames","fieldname","table_local","title","description","alternative","link"
+,1,1,3,1,"tt_content","image","sys_file",\NULL,\NULL,\NULL,""
+,2,1,3,2,"tt_content","image","sys_file",\NULL,\NULL,\NULL,""
+,3,1,2,3,"tt_content","image","sys_file",\NULL,\NULL,\NULL,""
diff --git a/typo3/sysext/impexp/Tests/Functional/Fixtures/DatabaseImports/sys_file_single_image.xml b/typo3/sysext/impexp/Tests/Functional/Fixtures/DatabaseImports/sys_file_single_image.xml
new file mode 100644 (file)
index 0000000..fa76c6b
--- /dev/null
+++ b/typo3/sysext/impexp/Tests/Functional/Fixtures/DatabaseImports/sys_file_single_image.xml
@@ -0,0 +1,19 @@
+<?xml version="1.0" encoding="utf-8"?>
+<dataset>
+       <sys_file>
+               <uid>1</uid>
+               <pid>0</pid>
+               <storage>1</storage>
+               <type>2</type>
+               <identifier>/user_upload/typo3_image2.jpg</identifier>
+               <identifier_hash>f90bb9a35622f35b5279195e324eddbaec8164b2</identifier_hash>
+               <folder_hash>19669f1e02c2f16705ec7587044c66443be70725</folder_hash>
+               <extension>jpg</extension>
+               <mime_type>image/jpeg</mime_type>
+               <name>typo3_image2.jpg</name>
+               <sha1>da9acdf1e105784a57bbffec9520969578287797</sha1>
+               <size>7958</size>
+               <creation_date>1389878273</creation_date>
+               <modification_date>1389878273</modification_date>
+       </sys_file>
+</dataset>
\ No newline at end of file
diff --git a/typo3/sysext/impexp/Tests/Functional/Fixtures/XmlImports/pages-and-ttcontent-with-two-images.xml b/typo3/sysext/impexp/Tests/Functional/Fixtures/XmlImports/pages-and-ttcontent-with-two-images.xml
new file mode 100644 (file)
index 0000000..0b5e175
--- /dev/null
+++ b/typo3/sysext/impexp/Tests/Functional/Fixtures/XmlImports/pages-and-ttcontent-with-two-images.xml
@@ -0,0 +1,741 @@
+<?xml version="1.0" encoding="utf-8" standalone="yes" ?>
+<T3RecordDocument>
+       <header type="array">
+               <extensionDependencies type="array"></extensionDependencies>
+               <records type="array">
+                       <table index="pages" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>0</pid>
+                                       <title>Root</title>
+                                       <size>138</size>
+                                       <relations index="rels" type="array"></relations>
+                                       <softrefs type="array"></softrefs>
+                               </rec>
+                       </table>
+                       <table index="tt_content" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>CE 1 first image</title>
+                                       <size>196</size>
+                                       <relations index="rels" type="array">
+                                               <element index="sys_file_reference:1" type="array">
+                                                       <id>1</id>
+                                                       <table>sys_file_reference</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array"></softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>CE 2 second image</title>
+                                       <size>196</size>
+                                       <relations index="rels" type="array">
+                                               <element index="sys_file_reference:2" type="array">
+                                                       <id>2</id>
+                                                       <table>sys_file_reference</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array"></softrefs>
+                               </rec>
+                               <rec index="3" type="array">
+                                       <uid>3</uid>
+                                       <pid>1</pid>
+                                       <title>CE 3 second image</title>
+                                       <size>196</size>
+                                       <relations index="rels" type="array">
+                                               <element index="sys_file_reference:3" type="array">
+                                                       <id>3</id>
+                                                       <table>sys_file_reference</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array"></softrefs>
+                               </rec>
+                       </table>
+                       <table index="sys_file_reference" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>used-1.jpg</title>
+                                       <size>277</size>
+                                       <relations index="rels" type="array">
+                                               <element index="sys_file:1" type="array">
+                                                       <id>1</id>
+                                                       <table>sys_file</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array"></softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>used-2.jpg</title>
+                                       <size>277</size>
+                                       <relations index="rels" type="array">
+                                               <element index="sys_file:2" type="array">
+                                                       <id>2</id>
+                                                       <table>sys_file</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array"></softrefs>
+                               </rec>
+                               <rec index="3" type="array">
+                                       <uid>3</uid>
+                                       <pid>1</pid>
+                                       <title>used-2.jpg</title>
+                                       <size>277</size>
+                                       <relations index="rels" type="array">
+                                               <element index="sys_file:2" type="array">
+                                                       <id>2</id>
+                                                       <table>sys_file</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array"></softrefs>
+                               </rec>
+                       </table>
+                       <table index="sys_file" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>0</pid>
+                                       <title>used-1.jpg</title>
+                                       <size>502</size>
+                                       <relationLevel>1</relationLevel>
+                                       <relations index="rels" type="array">
+                                               <element index="sys_file_storage:1" type="array">
+                                                       <id>1</id>
+                                                       <table>sys_file_storage</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array"></softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>0</pid>
+                                       <title>used-2.jpg</title>
+                                       <size>502</size>
+                                       <relationLevel>1</relationLevel>
+                                       <relations index="rels" type="array">
+                                               <element index="sys_file_storage:1" type="array">
+                                                       <id>1</id>
+                                                       <table>sys_file_storage</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array"></softrefs>
+                               </rec>
+                       </table>
+                       <table index="sys_file_storage" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>0</pid>
+                                       <title>fileadmin/ (auto-created)</title>
+                                       <size>722</size>
+                                       <relationLevel>2</relationLevel>
+                                       <relations index="rels" type="array"></relations>
+                                       <softrefs type="array"></softrefs>
+                               </rec>
+                       </table>
+               </records>
+               <pid_lookup type="array">
+                       <page_contents index="0" type="array">
+                               <table index="sys_file" type="array">
+                                       <item index="1">1</item>
+                                       <item index="2">1</item>
+                               </table>
+                               <table index="sys_file_storage" type="array">
+                                       <item index="1">1</item>
+                               </table>
+                               <table index="tt_content" type="array">
+                                       <item index="1">1</item>
+                                       <item index="2">1</item>
+                                       <item index="3">1</item>
+                               </table>
+                               <table index="sys_file_reference" type="array">
+                                       <item index="1">1</item>
+                                       <item index="2">1</item>
+                                       <item index="3">1</item>
+                               </table>
+                       </page_contents>
+               </pid_lookup>
+               <pagetree type="array">
+                       <node index="0" type="array">
+                               <uid>0</uid>
+                               <node index="subrow" type="array">
+                                       <node index="1" type="array">
+                                               <uid>1</uid>
+                                       </node>
+                               </node>
+                       </node>
+               </pagetree>
+               <files_fal type="array">
+                       <file index="4a705ca3ef43b53dc00de861ba2c86af" type="array">
+                               <filesize>7958</filesize>
+                               <filename>used-1.jpg</filename>
+                               <filemtime>1389878273</filemtime>
+                       </file>
+                       <file index="23116a2a95820388bb7eede903382d4c" type="array">
+                               <filesize>7425</filesize>
+                               <filename>used-2.jpg</filename>
+                               <filemtime>1393432183</filemtime>
+                       </file>
+               </files_fal>
+       </header>
+       <records type="array">
+               <tablerow index="pages:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">0</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="perms_everybody" type="integer">15</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="title">Root</field>
+                               <field index="doktype" type="integer">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array"></related>
+               </tablerow>
+               <tablerow index="tt_content:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="t3ver_oid" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="CType">textpic</field>
+                               <field index="header">CE 1 first image</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="sorting" type="integer">10</field>
+                               <field index="image" type="integer">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="image" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>sys_file_reference</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tt_content:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="t3ver_oid" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="CType">textpic</field>
+                               <field index="header">CE 2 second image</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="sorting" type="integer">20</field>
+                               <field index="image" type="integer">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="image" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>sys_file_reference</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tt_content:3" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid" type="integer">3</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="t3ver_oid" type="integer">0</field>
+                               <field index="hidden" type="integer">0</field>
+                               <field index="CType">textpic</field>
+                               <field index="header">CE 3 second image</field>
+                               <field index="deleted" type="integer">0</field>
+                               <field index="sorting" type="integer">30</field>
+                               <field index="image" type="integer">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="image" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>3</id>
+                                                       <table>sys_file_reference</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="sys_file_reference:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="uid_local" type="integer">1</field>
+                               <field index="uid_foreign" type="integer">1</field>
+                               <field index="tablenames">tt_content</field>
+                               <field index="fieldname">image</field>
+                               <field index="sorting_foreign" type="integer">0</field>
+                               <field index="table_local">sys_file</field>
+                               <field index="title" type="NULL"></field>
+                               <field index="description" type="NULL"></field>
+                               <field index="alternative" type="NULL"></field>
+                               <field index="link"></field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="uid_local" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>sys_file</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="sys_file_reference:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="uid_local" type="integer">2</field>
+                               <field index="uid_foreign" type="integer">2</field>
+                               <field index="tablenames">tt_content</field>
+                               <field index="fieldname">image</field>
+                               <field index="sorting_foreign" type="integer">0</field>
+                               <field index="table_local">sys_file</field>
+                               <field index="title" type="NULL"></field>
+                               <field index="description" type="NULL"></field>
+                               <field index="alternative" type="NULL"></field>
+                               <field index="link"></field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="uid_local" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>sys_file</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="sys_file_reference:3" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid" type="integer">3</field>
+                               <field index="pid" type="integer">1</field>
+                               <field index="uid_local" type="integer">2</field>
+                               <field index="uid_foreign" type="integer">3</field>
+                               <field index="tablenames">tt_content</field>
+                               <field index="fieldname">image</field>
+                               <field index="sorting_foreign" type="integer">0</field>
+                               <field index="table_local">sys_file</field>
+                               <field index="title" type="NULL"></field>
+                               <field index="description" type="NULL"></field>
+                               <field index="alternative" type="NULL"></field>
+                               <field index="link"></field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="uid_local" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>sys_file</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="sys_file:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">0</field>
+                               <field index="storage" type="integer">1</field>
+                               <field index="type">2</field>
+                               <field index="metadata" type="integer">0</field>
+                               <field index="identifier">/user_upload/used-1.jpg</field>
+                               <field index="identifier_hash">f90bb9a35622f35b5279195e324eddbaec8164b2</field>
+                               <field index="folder_hash">19669f1e02c2f16705ec7587044c66443be70725</field>
+                               <field index="mime_type">image/jpeg</field>
+                               <field index="name">used-1.jpg</field>
+                               <field index="sha1">da9acdf1e105784a57bbffec9520969578287797</field>
+                               <field index="size" type="integer">7958</field>
+                               <field index="creation_date" type="integer">1389878273</field>
+                               <field index="modification_date" type="integer">1389878273</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="storage" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>sys_file_storage</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="sys_file:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid" type="integer">2</field>
+                               <field index="pid" type="integer">0</field>
+                               <field index="storage" type="integer">1</field>
+                               <field index="type">2</field>
+                               <field index="metadata" type="integer">0</field>
+                               <field index="identifier">/user_upload/used-2.jpg</field>
+                               <field index="identifier_hash">8180e85d25c96697ec9d2004683216831b91ffc1</field>
+                               <field index="folder_hash">19669f1e02c2f16705ec7587044c66443be70725</field>
+                               <field index="extension">jpg</field>
+                               <field index="mime_type">image/jpeg</field>
+                               <field index="name">used-2.jpg</field>
+                               <field index="sha1">c3511df85d21bc578faf71c6a19eeb3ff44af370</field>
+                               <field index="size" type="integer">7425</field>
+                               <field index="creation_date" type="integer">1393432184</field>
+                               <field index="modification_date" type="integer">1393432183</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="storage" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>sys_file_storage</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="sys_file_storage:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid" type="integer">1</field>
+                               <field index="pid" type="integer">0</field>
+                               <field index="name">fileadmin/ (auto-created)</field>
+                               <field index="description" type="NULL"></field>
+                               <field index="driver">Local</field>
+                               <field index="configuration">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot; standalone=&quot;yes&quot; ?&gt;
+&lt;T3FlexForms&gt;
+       &lt;data&gt;
+               &lt;sheet index=&quot;sDEF&quot;&gt;
+                       &lt;language index=&quot;lDEF&quot;&gt;
+                               &lt;field index=&quot;basePath&quot;&gt;
+                                       &lt;value index=&quot;vDEF&quot;&gt;fileadmin/&lt;/value&gt;
+                               &lt;/field&gt;
+                               &lt;field index=&quot;pathType&quot;&gt;
+                                       &lt;value index=&quot;vDEF&quot;&gt;relative&lt;/value&gt;
+                               &lt;/field&gt;
+                               &lt;field index=&quot;caseSensitive&quot;&gt;
+                                       &lt;value index=&quot;vDEF&quot;&gt;1&lt;/value&gt;
+                               &lt;/field&gt;
+                       &lt;/language&gt;
+               &lt;/sheet&gt;
+       &lt;/data&gt;
+&lt;/T3FlexForms&gt;</field>
+                               <field index="is_default" type="integer">0</field>
+                               <field index="is_browsable" type="integer">1</field>
+                               <field index="is_public" type="integer">1</field>
+                               <field index="is_writable" type="integer">1</field>
+                               <field index="is_online" type="integer">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="configuration" type="array">
+                                       <type>flex</type>
+                                       <flexform index="flexFormRels" type="array">
+                                               <db_relations index="db" type="array"></db_relations>
+                                               <file_relations index="file" type="array"></file_relations>
+                                               <softref_relations index="softrefs" type="array"></softref_relations>
+                                       </flexform>
+                               </field>
+                       </related>
+               </tablerow>
+       </records>
+       <files_fal type="array">
+               <file index="4a705ca3ef43b53dc00de861ba2c86af" type="array">
+                       <filesize>7958</filesize>
+                       <filename>used-1.jpg</filename>
+                       <filemtime>1389878273</filemtime>
+                       <content base64="1">
+/9j/4AAQSkZJRgABAQEASABIAAD/2wBDAA0JCgsKCA0LCgsODg0PEyAVExISEyccHhcgLikxMC4p
+LSwzOko+MzZGNywtQFdBRkxOUlNSMj5aYVpQYEpRUk//2wBDAQ4ODhMREyYVFSZPNS01T09PT09P
+T09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0//wAARCAEsAZADASIA
+AhEBAxEB/8QAGgAAAgMBAQAAAAAAAAAAAAAAAAECBAUDBv/EADsQAAICAgEDAwIEAwYFBAMAAAAB
+AgMEERIFITETQVEiYRQycaGBkcEVI0JSYrEkM0PR8FNyguGSovH/xAAYAQEBAQEBAAAAAAAAAAAA
+AAAAAQIDBP/EACARAQEBAAIDAAMBAQAAAAAAAAABEQIhEjFBAxNRYXH/2gAMAwEAAhEDEQA/APKJ
+bJJGY/xVEVOUuUfgv490boKSIrsNIEMAR0we2bNfMSBPE7Z6+8WBpoYIYQIAGAe4B7DAQD/gACGG
+gKo9gAAgEMAoEMAEMAAQuK3vXckATFaOFVB2SrTg7Fp6ZVlg2xk7J3c1GuUV27vfyaehNJpp+GXR
+k4SyLrMac6+FdUOz3+btohCzjhZlMW1ZGUnr318mvXXGuEYQWoxWkJ1QbbcE21pvXsDWP6cK7HHE
+lqSpVj0/LTLE8m25XSpjCdcIxbjL37bZ2WJi4W71FxSTT9+zOfTcfjgWai16rk0n8ewHazNqoqql
+ZtKxdtI6xuqlGElNamtx7+SpXXZJYauqadbcX7/4fJnzjUo2u7tKFb9Pfs+T8AxvkeSaTTTT8dwW
+3UnHW3Htsyo32V4dcrKmvSs7NPfLu0RGqBXjmUuMHOXCU20oy87+DrfZ6VUrOMpKPdpeQJsQJpxT
+XhoZAAAAADDQUgZIAqLQmiWhaAi0cbqK7lqyKf8A5/8ARY0RaA8zbk1zxuz7/BDpln1Sj7PuTlRi
+8XNNHPp0N3ylHwiz2taqGIkAx0PWfX900L+Iodsylr50BsDEMiIXWwpg5zekVquoVTvnX2Sj35b7
+E8+KljSThzXwjyvo2xvaUZxXnXvoRcezTTSae0NFfB08SvjJyWvLLBWRsZi5uRK3Ldau9OutbbRL
+DzHXeqpXetXN6Un5TMzk6frua2AEu4GmDAAAAAPYAAAAAAAAQwLqEAAAAAAJpPs1tfALstIYBCKH
+Ucay7tXXXJNa+rtxfyXwAjCPGuMfhJFGWNfHlCLjKr1FOPyvq3/3L4A1i5VHG6UrXOuDlNckt+dM
+1Z6lQ15Ti/8AY6Nb8i120DWdblXV00+kotKrnLl8didObGMb/WjOPCb8rfZvtr+YXdNjOpV12zhp
+NfPZ+37Cvx7nC2EYqUZNT7PT2tdv2Iqysmlx2ppvjzS33aOsJKcIyj4a2jJjVCNtcI1zj6kXFqa7
+rz3TLvT1rCglY5tLvt719gLSGZtOfaowV1acmubcXrUfk7wzYTsrSTipycfq7b18EFv3AUZRktxa
+f6DAAAApCZITA8y+npvXJ8fjZapohUtQR00MqgkL3H7DAEW9XVP/AFon7nO164P4ki4jaXgZFPsS
+JiGcZYtUrvVcfr1o6jWwFGEYLUVpfBIQwPNZsOPUp80+HLb/AEIyspdlqqTjvXD9TYz8Wdk421RU
+pR7OL9zlRCu3Ih/wjjx8trwzM4vROcwdKvsUrKL2+ce65fBKrPm5ZFktOqvxo59XrsrlHJo3y8S1
+8DpxZf2RKOvrmuQys9Wb/To6pOUoO6njXN6Uy1dn00WuFjafHkn8mVRj0XYyUspwa8xl7MtX0Qn1
+HFjNqUeHn50IXjx1foy6b63ZXP6Y+d9tE4XV2fknGX6Mp2dP1Rkxrkl6r2l8FTp6ooyIwurdV67J
+77SL2z48bLY1G7vxS1r0ePf52djN9GWN1KnjbOULeW4t9vBPOyL45FVGNrnPvthLx29L4GbHPtro
+v9aC9WnW0vdM6Y3UVfeq51ShzW4N+5dTwq8AGJVkZVvV9x1xTceO/ZMrLbAzcnKzKMyNUa4TjZ+X
+5L1k/TplZLf0x20gjoIjVNWVxsj4ktoU7oVzhCUtOfZIgmAAUGgAAhAxiATWhaGIBAMQAKEIw3xi
+lye3peWMZFZ8eny9DSscbHtNvv8AT40DxrYSc51qcY2c1GP3TTff9UzQGUVMBcFdWoNKM+zcdb/8
++S2AEUAAAGhNDADzFnUIxm4xi5a8tHfHyoZC7dn8FHBUYVTtl3/gVqreOXzj2TYzvGvjf33GRj3i
+n8kgHo53/wDLb34aOhC/vVL9CjYr7wT+xJHPHe6IP5ijqRAA215ZkZnV1W3GvSkpaaa9iWmNdAVs
+XNqynJVy24+S0VC9wSS8CssjXBzm0kl3ZVq6pjWTUFJpt6W0S2RqS31FtpNd1sel49jjbl0VTUbL
+Ixb7rZ2hOM4qUWmn4aLqZfatZ0/FsnylUtvyT/C186pradS1H9Ds5R3rfdjC+Vc7oOyqUIy4trs/
+gzZ9OyrLK/VujOMHveu5rAMOPKz0o9Qquc6LaIc5Vyb1s5ZSujLHzFU+UNqcP1NMBizmwrFLJll3
+quUY+nr6kWbklfgTS1vt+xp6Wta7fApVwk1yinx7rt4GF5mYvUYrDzq8ujW5bU1v7G2Z2X0qrIvV
+vOS+rclvsysajmSUsjAtj4lL3+6IZzyL8qzHps9OEK+T7b5b9jtl9PnfOuVV7rVeuMdbSaIZGHlO
+aspsjzlXwsb/AN0MNPHsvjgYjogpp6U/sin1Cnl1ip3OShPSjJPWmXq4ZOL0+quEFOyLSa37HDrU
+264VyonKLafKPs/gDUS0kvsM5YnNYtSt/PxW/wBTsEINDEEITRIGBFi0SEBEBgAgAZAAMAoAYAIB
+gFLQEhAeGrnOa9FeGzvlVqp1xUdP3Ot2JOu31aV2FXjXXXqdvZIN60af+VH9DoKK0kvgY1DI2Ldc
+l9iQS1xYGhhPeJX/AO0sFXpr3hV/bt+5aCA851jEvnZK2VcYxXuvc9IKUVJakk19wayOiUTx5uMq
+/K3zRsiSSWktaGW3WWZ1uzjTCD8Sl3M+VlltUV6MY1SfGL13NLrNLtxlJeIPbM9YuZZRD02nXDvH
+TOfevR+Ozx7WJQhf0ybtjytqXHk/1LvSZb6fX9tnGvGnV0671fzzTbJ9ElvB1vxJlntnld40TliX
+58GrmrYduPyX5NJbb7GV1SuFeXj2Rgk3Lu9eTr1mc44aUXpSkk9Deks3MX42Vzeozi/0ZLa35KON
+0/Hp4XVp8kt+fPYyZ3TsuunOyxWReoKPgW2E4TlenpNgYVmRlXWYyrscJWx0+53ryMiiOVTObsnW
+txloeRfx3GsBmdOuyruM53Vzr13S8oh/alnrSlwh6EZcW99y+SeF3GsRU483BSXJLbQ01KKa8MzM
+rJjidTc5RlJzqSSiu77lYaYGbkdQrdWPZCxw5TW0+3b3O2XmQjjxspth3nFefK33CYuCaT8pMg76
+oxTlZHT8PY421zr9SM4uHyn2AmAnJRg5N9kt7K9WS5YX4mxJLTlr7BFkGQpm7KoTceLkt6+CZQhD
+AIRFkgZFRESEAAAAMAGFIYDAQDAKAAYGGh+wt6W2xRnGXhphtIAAIfuDAZRa6U/+F18SZdKHSn/d
+WL4my+vIQwACIYAgKFKKnFxktp+xSfTVF8a7ZxrfmOy+BFls9ISrTqde+2tFLG6bLGtUoZEuPlx9
+jQAdE5WKnUMSWXGChNRlB72L8JO3CdGTPnLfaSXguhodHlcxmUVdRrlGDnCVce38CMqMvGvsnjQj
+Oub3p+zNUCZF86yp05NuRi3TqUXB/Uo+yJzhZX1C65VOUXX/ADfwaQFw86wq4zefVKnHnTt6mn40
+RdVFFt1eTRZLcnKMo+6N/wBxaXwTGv2IUtOmHFNR4rSZUuin1amUlv8Au5a/mXtaONtMpzU42uDS
+12imac9ZVkI/gLpSgn6WQ349tnfNrxbem2OpQagt/T7Fn8LZxlFXLUvKcF3I14VlUJQhKpRl5XDz
++4FTKx8V1Y8KnFVu1OWn8onjU0zhm0b1Rz/l27kMjptiqUK41OLmm0tosRxLIY0seNdXpy3vUn/2
+CJZr4YMKKnt2arj/AOfoLNSVFOJHt6klH/4ryJY98XR/dRapX0rn/wDROUb5ZMLpUPcItJKa9wK+
+U7/XunXc4Rx4JqC8S/U515WVzd7s3T6vHhryn9zrl49t9jmq7a+UeM1Fxe1/M410zllT5QtVMLOS
+rUV518gKrqWQ6rJ7jN8VKKS1rvrX7naWblVwUJQr9X1OLbeo+Noiq7Y1yp+v0tfSvTe132PJbkre
+MFJWNNxnXL418Adp504X8ZU/RHUZz34k0KfUYQrU5Ql3hGel38vRU4TSjW7E4T4OxtPaa/8A4QrU
+/USslVxhGMY/Wu+pJgX458JutKuzlP2Ufy99dzrj5VeQ5qtt8Xp7WitbdCrKVlPCyM48JKMkmu+9
+/uzjiNYytahOU4Q1vltS7+wMaEsmmNrqlYlNR5NfCHHIpkotWw1J6XfyzOyYylbOKrk3Y+akl4XB
+poWRXXjzqaremo8e35XyTf6dgdL34qX4lV8Nwc+HLfvx34LEJOSbcdabRQ2oY9F1n07u5t/G9/8A
+dEH6UZ+lObhVC98vq1ra2ge2oMxIzu579d/TKUnFS2+z8P7djpG7K5Qrrscprlybaab7a/h3C41t
+pPW+79h77marrJQjKM92RiouUl4cp68fbTDGvsyLKZ3KG1LcWl7NSX9CDSDffRU9RSsdkIy1LhtS
+3HxJpsUuocJJSpluTajprv30v6gefzrb5P06k9P4I9MclbKMmaDUXHkl5Rn4j1myXcT21Wmh/wAQ
+/iNFUDEMI79L7Tuj/qTNEzOmvWTcvlJml/IiJFDqWbLES1BuL8tF7ZT6jjW5NahVNRT8gZmB1d/T
+VLlOUpefsehXfuebwel3QtcoNxnCXba7NG9faqMeVk34Rb1E91TvyLLOpV0UTail9ekaZl9Hqcoz
+yrPz2P8AY0yFPsAAEAxAA/cBAAwEMADsIAGIAAA0AAAaAAgAAABaWxiKDQaAAF2E0n8DEwIOuD8x
+j/Ii6KX5qg//AIo6CIOX4XH/APRh/wDijjb0+i6UG1KKi96i9J/qWh+wVyWLTrWppfab/wC4PEqk
+mm59/P1s7IZRX/BV7bUppvy+z3+xH+z6ta5PW9/lj5/kWwAo2YDjjTrpmvqXiUez9/Yjj9OlTXr1
+Y73F74v28e5oDGqq241tjbdkd8XHsmv6nN4VvLaktcm9cu3nevHz3Lw0QeYnkRx4RU9717GfVkRh
+lOzUtM15Vwl+aKYelV/6a/kSe2kMe+N6bSaOyFGMY/lSX6EkUAxMa+NATwXrOkvmBqoycXtnw+8W
+avsEpjEMIZl9Vc77qsSO9Sacn8I0xcY8uWu4w0qa1VVGEfEVpHQQwgAA2AAGwAAAAgAAAAAAoAAC
+AA2GwAAAAAAAAAAAQOSW+67efsJTi5OKabXlANkSQgIsRCnIpv5elZGXHs9M6BSA4X5dVFSsm24y
+ek4rfc7xlySa91sYGiRzqtjbWpR3p7Xf9TogAZCyyNdcpvxFN9glZCP5pxXbfd+wMSGV3lVK5wlZ
+BJJPfL3fsRyL7acmrtWqGm5ye9rQXFpLuNFa7IeqJVThxnZxba8rTfb+RXv6lHjuiyPZRl3Xlbaa
+/mkgKfsBWvyONPOtb2VZX53DlwSj+gbagFTCyfxEHyX1LyWkAx+5ysthX+aWhV5Fdn5ZL9AjtU9Z
+1L7d9r9jYMaL1lUP/Vo2UKgQNpLbekRnbXDtOUV+rOVqpy65VKxPfniyaOynCTSUk38bJmDiVLG6
+z6cW2u+tm948iXYvPj4+gMpWdUxK5uMrO67dkdLM2mvFWQ39D8fLHlE8eX8WQXhFHH6nVfbGuEJp
+v3aFldTjRf6MK5WT17DTw5bmL6DwjhiZDyK3KVcq2vZljRWb17Zd3WsaqbjKM/pevBZws2GYpOEJ
+RUf8yKnXaYRwlNQSasi32LN7tqwFZixjySTa15RehcAysbqM83Mrhj9oRjuza8fY1iWYjLzOpW0Z
+U6aqOfCPJvfsO/qF0sCOVi1xlHTcuXsVc+2eP1luup2Ssq1pHTCUZdAtint8Zcl8MvxpqUTdlELH
+rcop9jommZVts49AhKt6bjFb+DhZCXS8mv07JSjbB7Unvul5GI2nOG+Kkt/GzN6ZZmZOrrbo+mpN
+OOipTRXX+ByXJu62zcm352d+lU3+pY1kJVQtknXrz3LmDT/EU8VL1I6b4p79/g5252NTb6dlsYz+
+DJ1VR1309v0FLaXtGbRzyJ0/gbXNJ3yyH+q7kkXGtHqmHKajG5Nt6XZijm4ubJ40LJblHe12/kzH
+ophGlWRjqXGD/wD37lrp7qlZh1ULc63N2dvHsXEXsO2OP06UrJNqpyTbe29NnbEyo5UJNQlCUXpx
+ktNFCa9bHzcKCl6inKS7dn32SwrsXGrna4X18tJuxeX9iYF1Buq3JhvtfWmv13r+p3ot45WRGdKh
+KEE+W98kcsuC6gse3HTfp2rlvt29zvbj2vqDnGMXTZXwm9915AovrU1W5OuG9bWnvs09fx2jRw8h
+5VHqaWm2lopLpt06VRZGiMISjqUV3lp+/wDA7VUZWHUqcaFc48nJyk9eWXoZ9M5waePHhJf3MpuP
+bbl+/Y7rKyPXpjbbwipOEmobUpJ67/BeWGniOiUmm5OSa/wvezn/AGbDhCMrrWovk+/5nvfcnQr1
+q6PT7vWnBqM3rita1Lucr7boX2v1p8ZzdaS8RXZ7/dl+zp+PY7OfNqx7kuT0TWHjqHDgnH7v7a/2
+GjIq5O3gr3GmEZLbnptbl3Xy/H8i/iSss6TN7l6zjLlvzy7llY+KuK9KvUfHbwdVKuPjS350hVY9
+dUZ+nCDdkHCUW47STe+P9UdI0xsthJV28HGKUXH4fdNv9DV9SK9mL1V7ImN+dZSxr4p8aJKcNOMu
+3d+3n29jSyap2KDhFNrltPw9xa/30T9V/AvUl9hiW6qRoyFTTjqqDVDTU5P6Za7Lt53oF0+70XV6
+sNS87jv33/u5fsWucvkOUvllZYOLDVEVJJkc26NVLT8vwjhh5DWPJze+Pg40xeZe7LH2XjZL3W/U
+d+l1yjGU2tci9ZJQg5P2QoOC1GLRHJW6JfoNRUx8OzqEpS9RLT8M7X9JeLS7XetrxpFPAy3i5PLb
+4vyWusZ6v411S3H3GiWNc7VVKXdxmj0TeoN/CPK4T/un9mj1S7w/VCoxsah9SybbMiT4xekkaeLg
+04snKpS2+3dmXFZHTsmbjW7IS76RexMzIvtSnjuENeWZ4uvPbOr0qXfR12D+Wi71a2VWFJw7OXbf
+wVeoYuTPOjdjw5cdFl0X5WHKvKSU/bRO8xLZ1VaGPRX0j1JRjycd8mu+wqx5ZfSKowaUova2Rh0v
+LsrjTdcvRj4SLcOn2QwlRG5xalvki9reU/vbhTlXY10KcmqOnLSml5JZeFP8Q8jHuUJtd0/cnX0t
++rCd18p8HtJnW/ptN9rtlKabXhMZWby4y7EOl5lmQ7K7UucH5Xg0Svi4lWLFqpd35bfksFnTnzst
+2M/rcd9Ms17af7knkKnpSta2+HZfcuTjGcXGSTT9mHGOktLS9tFZ1gYNOR0+yvIlHlC/86S7xNOf
+VcWDac3te2i6c/RpT3wjv50XdNZWQ778ynNwquaUWvq7FnAxboYd8b0lZc22l7bReTil20kDnH5G
+9YazsfByHhzxcqcHDilHj7BX0+1TjZmXK2NUWopL9zQ9SP3E7V8Darz9ddbyMdUXTtkrFqL/AOnE
+1Y9KqjkO5WW7c+elLts7xVcJucK4qT8vRP1X9haa5/gMf05QcW1KXNtvvsb6fiuyVkqYuUvLfuS9
+ST9xc5fLG0Tjj0xWo1wS8eCGHjrHq4tR5cm9pfL2G38iJtFjlFe6IuUH50ziAHb1ILwJ2r4OQAT9
+V/BF2y+xETAbsl8kXOT92AALb+WAAFA0AIoYxDSb8IAAmq5P2JKl+7A5oZ1VS92ySrivYaPLQxOO
+M61rb8s4x6ZJf9Vr9DS+A8EaU6cFVT5epJstzjyi4/I/YfsBQXTU3tyJrp1fu22XQXsVFZ0Qpplw
+RvVPdUX8oyLluqf6F2i9/hINJb4/0IYujWvCM2jqMbK4uc4qT8otRtcltSWvsExYHtFbk/lhthFn
+kt+ULnFe5XGB2dkfkPVXsjiCA6u77Cdr9kcwAn6khc5fJECofJ/LFsAAAAAAAAKAAYCGAAAAAAAB
+p/AABJQk/Zj9KX2A5gdvR+WNVRXkCuLX2bLXCPwg0BWUJPwmSVTOwBXNVL3ZNVx+7JDASjFeESAA
+AYAADBDCvO8k1tNNHCzNork4ufcp9PnPnKty2l2LKxKItysSbfyTFdKMuq56g/5lj+BjcVHqOqda
+37GwvACdkI+WiLyKl5mjIypTV8lt+S7/AGZJ9PV+5c/OgLH4iqyMoxa3os0Rsswa1Cah203rZh4P
+a/TN7pzf4RL4bGJWHKiLpsaluUH9TNjo0nLAht7abKFVSstzaXLW3vuPpWVkRiqK6uUFLTkIVvDE
+t6GgyYAAAADCF7jAAD2AAAAACgAfGT8IarkBEDoqvlklWgOI9HdQivYetEHBQk/YkqpM7ABz9H5Y
+1VEmMKioRXsPQwAWg0MQADQAAtC0SYgI6DQwCjQ9CGAD0AFAPQAAaGkAIDw/TrIws4TTUn8l7Ixp
+Xf42l8GfW3dnKcI9ky3bmTrscVW9L3M+2/SnOmzCsU97T7bNeqTnWpa1tGdKN2bbHceMEadcVCCj
+8F+J9Z1tcI50ZXdob2zWl1jChXwjuSS1pI4W0QtjqaKq6bFS/N2IiNChfmStri41+xqdN/5El8TZ
+yrqhVHjBaRPClwhe2u0Zt9ijNtpU+oZafnW13LfQH/w84/EivPFtzMq+yqcq+y7NabNHpeK8XGUZ
+rU2+/cSFXUMFF/ckq5fBGSAmqnruyfpLfdgcRo7cI/BJKK9ga4cX7Iarl8aO4BHJVP3ZJVL5JgBF
+QivYaS+Bh4KAAAIAAAAYAFAAAAAwCgAABAMAEAxAAhiYUmA2IAGCABjACgABsAABgearprrWoxS0
+TlGMlpxQx9tGWiUVFaSAG0vL8j7exQDF7jSAZ06bCLtvX+pM5o69N7ZV6+yYRdhj1wnKaX1S8s6K
+MV7EtBomoAGBECABgIEMAABvwL3KgAA9wABhooTABhCAYaAAAAoAYAIYAAhgAUhgACAYyqiAw0QR
+aESFoAAYAMAGUIYAFAw0MDxUeoWxtUbocUzRjNOO/byY+XdHIyYqC7J+S3l3ejjKEX9TWjO9NfcU
+8vJlPKSjJ8YvRs1PdUX8ow7KVVTCUmuUu5q4uRXOEYKSctF+JVsfuIYB8HTAes+xfMP6nP2J4j11
+KP8Aqg/9yalayBCQyIAAAgGHuABsAABiAEAbBB7AVDDYgQQwEMoAAAoAAABiGAbAAAA2ABQMQAAx
+AFP2EAAIAAAGIYDGIApgIYAMQwPEZuJXXXzj2ZCnEnlVJynpLwdI4t2RJO6TUV7GjXWq4KMV4GNf
+8ZWXg+lWpKTky90+mEKIzUdSa7stOMZLuk19xpJL4EQ0MAQDQUduoVP5TX7ARX05mO/9WgjZGR2o
+pt+EZt/XMWpuMFOyS/yoymNQCpgZ1ebXygtNeUWy4hhoQyAGICgYB8AiBiGIqAABAMBAUMAAAGIA
+GAhlAAARQAAUMBAAwAAAQwCkIYEANCACQCGUAABFAxDA84SRWnl0wenNb+Dor4yqcoNPSEbx2AyZ
+Z99k3GqKR2xI5MrVK1vivYSJWghoF4ABohN6spl8TR0Xg5ZHatP4af7hG1OPOuUd9mtGdfVjdNwJ
+tQi209N+W2ace6Rk9SpsyeoY8JRboT3Iz/iK3TqMrGwHdTDcpvai/g6/2xkY71mY8o6em0at11eL
+Q5z7RivYyYUX9XtjbkR9PHj+WP8Am7mvdGphZcMuvnWpa+6LBGquFVahXFRivZEyIPcA9hgINDAI
+QD+RDAtdhh7gEAAGygHoQwoAAAAACgDQwANAAAAAPYCANjAQaGAUtCJCAASBDCgBgAgGBAAAAeLn
+g0V0tyffXlnPpybhNd2h34+Tcnyfb4I4Nk67vQklpkjdQpulRdPjW5NsuY/UVKfCyPFlpKuCfZIz
+cnhbmQjSttPu0WfwbCe1tDIwTjFL4JIiGc8lf3MzoRuTdMl9mBr1PlVB/KRSy8G3JyoT9aUa4/4U
+yzhvliVP/SjuifWUZVQnWoTjyivZk4xUUlFaS+AGEAAAAAAAxDABAP5EVAAAgAAAoBgAAAAAAAAM
+AAoAGIgBiGAhgAUAAAIBgFLQwAAGAAAAAAIAIPHT6hXx+hbZzxKLJ3+tYuO+6LFWNUnvguxZS7D0
+2pWYM7LOTsff2+Czi4sKO6W5P3Z3Q/8AKND+40u4ew17/YAXgckuLQf0GwmLnTHywavstfuW0Uuk
+98TXxJl74ImEA/dgvACAYAwa9gH7/wAQQTB8CGACAloRTCAYIJhAP3AGAAGAgGBTCGCALg0A2AMA
+AgKDQDAgQD9xAwAMAYQDF7gwAMBphAP3ALhAMTIEAAB//9k=
+</content>
+                       <content_sha1>da9acdf1e105784a57bbffec9520969578287797</content_sha1>
+               </file>
+               <file index="23116a2a95820388bb7eede903382d4c" type="array">
+                       <filesize>7425</filesize>
+                       <filename>used-2.jpg</filename>
+                       <filemtime>1393432183</filemtime>
+                       <content base64="1">
+/9j/4AAQSkZJRgABAQEAZABkAAD/2wBDABALDA4MChAODQ4SERATGCgaGBYWGDEjJR0oOjM9PDkz
+ODdASFxOQERXRTc4UG1RV19iZ2hnPk1xeXBkeFxlZ2P/2wBDARESEhgVGC8aGi9jQjhCY2NjY2Nj
+Y2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2P/wAARCADIASwDASIA
+AhEBAxEB/8QAGgAAAgMBAQAAAAAAAAAAAAAAAAIDBAUBBv/EADcQAAEEAQIEBAQEBgMAAwAAAAEA
+AgMRBBIhBTFBURMiYXEUMoGRBlKhsSNCwdHh8BUz8UNigv/EABoBAQEBAQEBAQAAAAAAAAAAAAAB
+AgMEBQb/xAAnEQACAgMAAgAGAgMAAAAAAAAAAQIRAxIhBDEFEyJBUWEysSPB8P/aAAwDAQACEQMR
+AD8Ax6XaTUuUvceA5SKTUikBykUmpCAWkUmpFIBaRSakUgFpFJqRSoFpFJqRSA5SKXaRSAWl2l2k
+UgOUil2kUgOUil2l2kAtIpNS5SA5S5SakUgFpFJqRSAWl2l2kUhBaRSakUgFpFJqRSAWkUmpFIBa
+XKT0uUgO0ik1IpQHKRS7S7SAWkUmpFIBaRSakUgOUik1IpCi0ik1IpCC0ik1IpALSKTUikKLSiyZ
+48aLXJ9B3KnpVsvCblNNk6gPIOgKkrrhY1fTuNkxZMYcxwvq29wpqWNFjTYkmsGnj02V8Zzi3UWt
+o+64LOvUj3PwMjVxLVJuI4hi4fDkxzu8R5NsG1dlVOWRtoBvsVqcOzsYYBZK1w8M0RQOoqSzJ+iP
+w8mL+aM/HkMsQc4U7kVJSpS8ZByZGmDyh1NLaG3r6qeLMhkaCTovuukcsfuzi/GyO3FWiakUutLX
+i2ODh6G12l1s87TXGLSKTUilSC0ik1IpALSKTEAc0UsqSbpM04tdaFpFJqRS0ZEpFJqRSAWkUmpF
+IDtIpNSKUBykUmpFIBaRSakUhRaRSal2kAtIpNSKQC0ik1IpALSKTUikAtIpNSKQC0ik1IpAI9jZ
+G09oIVOfCO5iFt7Xur9LtLnPHGfs9GDycmH+L5+DMZG1w2O+3NROx5vMWyUTQu62+is5H8PKIOwd
+uEjztsV8+ScXR+qh8vyMSkZwxy11Or6FTx4r/D8Q34ZBp3OiuPPmFj7LYxm6caMVzbde66Yobtnz
+fJyrx0mlfTzjTPBJcbj7jqvQwF74GOkFOI3TiCIO1CNoPsuTyujLGsjMkj/lbdL1Qjp1s+TlyRyJ
+RghqRSr4ea3Kc9mnS9m5F3atUuqaatHmaadMWkUnpGlUg8mayJgjhx9TyADI800E/usvHyjCXMyX
+AizpcAbdv27KfPeY4W+GQJSaZapwY72QePN8+1CuQ5r58/8AHJpM+phiskE3E0Y3CVgcGubfRwoh
+NSpNeXtEjTTuYKuxuEkbXjrz916MGbfj9nn8rxvlfUvTCkUmpFL0HjEpFJ6XKQh2l2k1IpQotIpN
+SKQC0ik9IpALSKTUikAtIpNSKQC0ik1IpALSKT0ikAlIpNS7SASkUnpFIBKRSekUgKfEWascOrdp
+59lTiHl829dVpZm2HKaum2vPDN0Nc17KP7rx54/VaPufDvIhDHUmTTuFuNgLchcJIY3t5OaCvJPy
+JHdaHYL0fBXGThjLFFpI991rAqZ5vOyxy019i5So8Tgme+OWInygggGldllbEK5u7dlUfK95J1kE
+ciOiubKktV7N+F8OyZKyS4v7KPDYvh84SOGu7GgHmOpCvcT4g3EcfBDXg8i6xd79t0zI3HwnxFjX
+VUhJILiORu1n52C7w3ymXU1gJ0n/AH0WFNpWjnkwvZqS6i3HlnJx2vcQ0kcm8rXGZDmjZ5Hpap4B
+Bg0tOwpdOGzI1j4nwSOV8nLg23L2fajpDx4tQT56NPADeJZXhSHzNFxkfmG/7WnyIZYdUUrwyuZr
+osjGxOIcPyGTxBsgBBtrlq8TzBxLYY5jEAD3lzqcL6DupPHseCOdRdpUvwZ8rWY0pbCXFrhZHOlP
+w6W53xm/MNW/dVpIcaMeM06mtAo3zPspuF1k5PisGlkXMHqSFrBeyoz5TXymmadIpPSKX0j4glIp
+NSKQHaRSekUoBKXaTUikAtIpNS7SASkUnpFIBKXaTUikKLSKTUu0hBKRSekUhRKRSekUgEpFJ6RS
+ASkUnpFICN8YexzHcnAg/VeRzYnRyEOFFpLSvZUvOccZWZJ6gH9FyyrlnbC+0Z+OwBhcdyr+DxAw
+YMkcZAlEhc297BpQsjA4dC+jbnPBP2/yq0cXiTgAHS024+i49R6OP2az8p04BY0uJGonspizQw6n
+MBJqtQv7Ky7Ggw+HzOaS/U35gOfb6KjC5nhgirK4zhr7PveJ5Dzt0+L/ALgSOAbRfpPQ0qmRJKQ4
+CQujft6KTIcNR7BWDEx3BWPLgCXucP2/opFWY8qSclH8lWFzY2itr2IXHylhIewtIVj8Ox+JPkSv
+FhgAaCLon/xWOPQRx4wyNJ1XoNetldPlOtjxLzkpaIyo+IzRA+C9w9On2VZ+TKXlxcdTjuOhHZAH
+kukuOzxcqNlHdwCqVHlyTcnZdlxHYZDpAHDXtR2pbHCDrgkcI9LS/Y99lHlDxZAygQdqK1WsaxoY
+wU1ooALriXbPPmfKEpFJ6RS9B5RKRSekUgO0ik9IpZstCUik9IpLFCUu0npFJYoSkUnpFJYoSl2k
+9IpLFCUik9IpLFCUik9IpLFCUilJpRSlloSkUnpGlLFCUjSn0opLFEdLF/EMbAYX15iCD7D/ANW9
+pWZx+LVgB9WWO59gf9CzPqN4+SK/ARHkcNfBKxrhHJyPrv8A3V2bBjOl0MLBWxAAbY91j/h2bw+I
+OhJ8sreXqN/2tem0qKnGmalcZcKWZC53DHxAAuDRy9CFgRSujIje0Ft/UL1jgPDcXHajfsvNZL4m
+vI8O3VzXDP7R9b4bekpXVP8AsGRxSuLqLgD9FL4Bfw6Z7aEbZg0CutKWeFmDYB/hkamEb2D/AJtS
+tLRwEQtIdJPOC1vuK/ouKTTo92aeOWOEn9x+Bw+Hw4OIp0ji4/t/RLx9hPDxQsCQE/YrUjiEUTI2
+/KxoaPoo82MPwp2uBI8M7D2Xur6aPzV/XZ4sHyEHmkx8gwZLJeek3S7Ma3pRUDuuB6T0uPUmbDZ5
+mwR91sELyPDckslY1xJ0uDmr2RbuuuP0cMq6R0ik+lFLpZxoTSik9IpLFHaRpU3hP0h2h1Hka5od
+DI1upzCB3WNjerIdKNKkpGlWyUR6V3SnpGlSxQmlGlSaUaUsUR6V3SpNKNKWKI9KNKk0o0pYoj0o
+0qTSu6UstEelGlSaUaUsUR6UaVLpRpSxRFpRpUulc0pYoj0qDOxzk4UsLfmcNvdXAwk0ASfRBY5p
+pwIPYhSypV08Vj48uHxmBsjac2QDuCvY6d1mythm4lBGyHTMyUve7rQ7++y1qWYs3PtEL2amObV2
+KpeYy4QWRyN+Zx0lpK9W7ytc7sLWHiYXiytlmBETdwPzH+y5ZmlTPo+C6xTt/j/Y3EeGkyWx1QRM
+a2if2/T7qjwyKJnFXy5DmRsbuxgJIB6LdnIGJKDZc7kDzPVZT8fVZaAT1pco5OtmJpyiot+jba+N
+/wAsjCavYp9K80+N0VhriAeYBQ3ImicPDLgL6Fd1lPK8H7JvxBw5kWF4kEcbWh1kcj9F5qJr3vEb
+GlznHYAWSvV/iTAjLopmzESvjGqM3/fYLGHDs3h8kOS1rfM2279Clp+ipNLog4fLiyj4gBr6sNsW
+Pde0AsA+i8e0B2YDLrbGCLFb0vURcSwpBTZw2tqeKW4ujnNWWKRSZrmPPkcHbXsbTaVuznRHSKT6
+UaUslE3EMrXpZJOG07YCj9yFYxJmTx6nDSxo325lUxiGNnxGWC0ONUP8Jw4tYAYXNL/k1db5mvb9
+1x5R6C89mC6B0zqDGbktO/tssxp8QFwjextkDUFcayeHHAx2EukNNGwvuVE98oJxy0h4vVpNn13R
+OiONkVIpDp44pGxuiLnHYU7r/jZTRNx5HhgyGX6mlrYzqRUil18mOwuuQkA00AWXK9gY0ORGHu3v
+fnVDomw1KNIpbL+HwuLL1Bo6NHNT4+OMVrnuIA6Nb2/qVNi6GC2J7tmscfYKdvDspw/6iPcgLXlz
+omtOhzXkdAf0VFvFrZK4gANdpu6rZNmNEQ/8XlfkaP8A9BK7h2S3/wCO/YhSM4qxzHTOnfGCSGMI
+vboVE/iUkjbGRp9m/wBd1NmXVEPhSb3FIK5207JaV6B2TnNBje9rGkNLmuIP0/uVazJYGAMbG2V+
+rSRzIH72rsTQx6QGk8gtYYDHR65WeED2NkbrNiwzxDNmEEskeNG7SHXYcfT9U2GhHICxtgsebotD
+vNft1TRQyzAaIn2eQIpW2/hoNfrbluB6eT9991sYmN8PFoLy83dkAfspsXVEGDhMxmB7mkSHnuvP
+8TyZhxV7vD1RuOkA78uq9PmRMlhLJGl0fUAE39liZ2McfNDgGCN4HMEV0H9vqoUrSsh1ufEwl1bc
+r+6hjk1F2ptBu1g3urDh4MlvdsORPXsqWRlQ4jS6V4NWQ0dV5XmyLh6lhxvo8s0ZcYNTmvdGXAgc
+hytVJZZhNGCGiJo87xu53Pp9k2BDJLI7OnBBkFRtIqm9/rsppi0Ciuyba+o58XI+jJyM6ZkkznQl
+7QfIbouHt0T8PkPEYnuYGsc00WvNH3CmlANjZUHRB7iG0KFlNYjaRZnwc0An4cvrs4FUHR5EWRGc
+jHkbGXAeYVforuNjTTytiwy8Sn8rivT4X4Rb5ZOJZk2S8bhmrytP15qxSatEk2uMzsTh7M3MMuRG
+6djWlo3oOPf/AH0WhN+G48loAyWiFjgWtDdwO13y3V/JbJDIzH4exgABLxVnp/v0TMblRQkvxzfU
+Mo3/AGVM2ZeRwHFZjkP0+O4nwnaqC8fxJpx5H48jiS0kcgaIXuMpz4IWSvx/DGqqPRYPFOGxcQc6
+eMaZTu8d/VVcHs84yZscZ0Pde3Mcvqpo+J5TTQnf05u/upH8L0agH0TXNtKB3DJnNNC+uxU2RrVm
+hFxbPaAXR+ID10WPuFKOPurzQNvr5qWVCM7DY58etrB8zTyI9ldbnwStD5YGPeRuXc1dn9jOi/B7
+2IPeQNtI9VFxKR5aY4mF+lpJocz0Uc+eGSGKANcQac67DVFLkyudoY7U5xAB6BDIjMqcStc6GRoa
+PKC4AX3O6ePKjMbg8tDi0lxHK7/8XJoNbac4bG7P83oqTh/G1fOW9DzB9f0VBbkZj5Ebg52kPoag
+Nz6KU8NxBA6OIkyu+aR3Mf0CqwAxgBzdZBs9gp5ScbCc98lOkIGkdzz/AEUBXPD8fWGMm102wDtf
++FowyuhgawvjbZB8m+yx2NErw0fzm3776R0TS5YbLJI1wGolra6BUGxHnRSSuY9xBHInYnf/AH7K
+1K9s8Ok3oI7815Rkz3uFWCSLJ6dAFpScSLWiCJuqQ9b5b8ylCzQ+FgOzWBoqqGyifgYor+E0dqUu
+E9szQ5tm27kn1KaQFjwGhzy4/ZQpXHCsR7tT4ySf/sQrTMHGY3ywsob1VqRrfunBIQHWxMYCQ1re
+5ApMyFsbi5rQCeZAUb8pmO3XK4Nb3KjHGMVwJGogdQ27QFp3naWGiDsQkhhbjxhkTAxo5ABV8bIi
+fLq+IYS/5Wh23/qnzMs4rWEMD9Roi6QEwe4dEjpWtfZJ2HLoo8XPgzA4RkhzfmaRuE0rGWSaNowd
+OZG1hcdVDs0qhxLJjyGNaxri9pB3FbFU8mQgubE47c+tqF0pBD5JSNqcKAB91nYtE/zM0y+U+qpZ
+OPw/HZ8TJjxmVp8u3M+yuY2Xw3QXTOAvlYJsfqouJxYs8HjQtqF2wDRRLr5AKOXOFUe9M34zKyo3
+vjjaGixqJ6rAmzcxkzmSONjpppepiiEcTWA6KHys5ffqpRUr78NkhI5+HZKzGafEblFx6zzMMJyG
+B2p7i787iA36BX8fhbWTwaXmTxxu2iKK9HPwTHOKZHnwnOb5i0VVqKCTHwpNe87wLaQ2tK1JtP8A
+RmKTX7NbhfCsfAt0bf4jgA5y0VU4dmjNjc5rC3SaPa1cXRdXDDEYwMBoCybKZJI8NNWgyNawuc4A
+DmShDO/EJH/HFpqydl5Z0x2qxW3NafGcz4mW4/M1vIHksqTGfI8eMTG270N2tYc1H2dIwbOyFkzb
+Ip/L0Krux231BVsYjG07zkEna+iinMEb2xl72tI21b0f6opxkHCUTPeJGAF2pzSau6C7qjbs6Bv1
+arTJsdpMUg1VZBa6r/RIH49DTNQ7OoEfojjFhbGwxgaxzS2tQ3U0AcHl/wDOBQ7JXkHpskjk8N99
+Fs5nX4r5JS50jgQ35t+f35KrjRuExGqi3zOeOq0J5tURDLFjsq7YwcYxMBL3vBJ9B0SwaGMBpfte
++59VK5jXsaXC9Jse6giDoIQHdTqK6+e4yG3fooUhMUbxIyg13LUBuqzeHRRFgMhe55IApMWDVqNk
+l1fRaOLEyN4eTyFbm67q3RCvlcG04rZMf/tbvp/MSfVZb4ZIZyz/ALZHG3ad7/uvSy68hzGNoRDd
+xs37BPiRGBg8R2pyJiitwvBy4YGGZzGEm3NDd66C/RaHww16i412G33KbxVwyHuoUG4sTZhLb9Q6
+F5r7ck5ZGX69ILu9f73Kj1WmsAEkqghzBA+EiYN0DvsvPBrIpLheCy7bW1rYyM6EuLWG3cr7b0sE
+zNnlcCDY6nfTy/x90RGSvia4GxYJ+yYyzFjGPkc9rOWo2m3aQHbJZYyNO+xPNUhw6g9kkWprgfmv
+lsrTsuQQu8VziBvYNFV21TmuB36joe6WGKd02rIki8JvyBp3ce59lympbcOsHHXpHPBI83DlPaT0
+e0Gv0VJ0WfDIHSOZPGNiAAD7rYe+FjbMjQ0GrJTY8MmWNWOzWz83Jv3U/QXOma4UGUBXIrmPM6TI
+bjPd5ILc0dbI/wAn7LePBpJWEzPaCejRyUOF+HBHmDJkyBIBzZoq+fM36rmscrZ1+ZGkLi4D80Ei
+QNaDRPULYw8CPDhaxm9CrPM+6eLHZjl3gt06uYHJR5fxnhjwQ0uvffousIKKOU5ubMbjM0wyHxh4
+8L052s1rS4tZGHOd2G5K3Y+DPyJTLlPLQXEmNvP7rSixIMdhbDG1g6qSx7MqmolPgkeTHC85FtaT
+5IyNx3P1VrPzmYcBeRbjs1vcqc00KnxHF+Kh8rQZG/KT0W6ajSMWnK2YU2dku1SOlNncAbAKZr58
+kFmouaDyVeWJ0EzGZDSCXAUf5lt4+M6FvLmbtc4W/Z0nS9GFkYz9LmaC01sQOSjlklghJy4z4IBI
+f1HovTANBWVx+Jr2Bzh5ACCb6dkyJVYxt3RmnJh0N3aSBzdsFTzPCycWQ2x7mDYNdzUNgYUbSCSG
+AVXJY8PDH5mcXPZpiabOra1I46dmnPhLMHsALrAA29QlY3xgX6Hv3qwLUudGzGmDebSL37pYtm+Q
+uYCbpriP2W/RLs9ht2KPorww2nm5cmx44IXyuJIY0uI9ls4FJMATyBPstHHjxpImSx05rhYKn0tH
+ytCFoyxHM/8AkcfcKRuLKebaU+bxCLBa0yk+bkGjdGNxKDJjdIyQhreZcK+iAidA2MEvkAoWduS5
+qxWML3ZALWi9lSzcxofI1socHm5HgWAByA/3uqQlb4YELgwbl1jd3rfsgNSHjjDI5jMeTw2gUarc
+8hSsRcSM+trGASNbq06rv027Lz0cw+FLWxgkEnxCdz0UeHnPxpYwGghjy4uvc3zC0lZLNYfiItoP
+xxd7+borcXGopXhpjczV8p7+iwM6PTkOlbTopDqaf6LsDDlTY2Ow6gXEHoR1KtIls3JuKZDJjG2J
+ra38xux6KnJxGV7i1x8R2rSBqoJc92mEBzT48Z0/XuooXM8cuIAcDTgP6KULOySNpxFtdp5nvex/
+VdhEcPC3Pid53ci4buN/0Vadskrzd2dgOo2Co8QcY5WsaSWNbQs8lG6KlZp488kup8z2Oj5bmla1
+E4skkb7bpJb7rEwWfEP8SS/BafNX8x7L0MEBz4ZWQMIjrSSdhv0C5ylfEdIxrrPNjjk5cA3QSOtK
+zwzI4jxPNbDAGubfndo2YO5W7i/hLDipz2tJ6gjV+/8AZbOBgwYMJjhaACbJAAv7Kqw3GuGLLwqS
+STwnBjyfqt/DhGPixQt5RtDeal2HIJWkh1dFpKjFknMKO6KZxoe6j0XNfpZCpCRtjmuudQ2RYuuq
+jmIogHc7ICVRveGEA9U7D5Qh7Q4boCLT4rCHHmpQ0AJB5V3WEB18TH1raHUbFhceQAuh9jdcJCAp
+ui1SEi/vskkiDmlsjQ4HYg7hXtQVSZ48ago0WyjNwuCbetBqhp2H2VGbgUg3hlafRwpbYHdOFKLZ
+4ninBsqSEsljIAN6huq+PwaYxDS17x3C985ocqxAaSKVZDuTlQ4zQZHAWaCoScRjczUQQ14AAdW4
+PZQY/wAKwGaaVuVM7fS07N+5WPxTiBnyWeHAYjBVbivp9lUrIzZx+M42FLJjuiIia/SwxiwO/wDo
+TT8Zky5vBwC1o/Oas+1rzUDJZAWta53Vxr+q6CXO1RO+R36reqM7MvzMklm15Uz6JI1OHKr2/wDE
+TZIeI2ta4Rs2ZY29T6la3DGw5mC0ZPmMTvMLoE9P3UWRw2GSdwx2CgbeS6hXYfQrBoqxvxJIpGAl
+r3NBJI2Fc1Tka4M7NI5pp4mMkLQQ5nUtGx9ApPEYZDraGNsAtQER1jEDtNMAI1fmKqAGyNttloZc
+kZJ0jYgBrQfRV9LXkB76e53mIHILcWZkuDQQTTVoFtG5+nNNjyfC5DZ2gnT681q48BZM3S0tjB0t
+H5u5/RV87HBL3QgAs5tP8ze6bW+k1osTTiWBhp3ivkDWeX1sm+o3WbN5Mp2sFnWx07KXFkcZ4g06
+S3Zp7+nvsAmzHOGU0HS55q2joe2yi4zXsfRKWUd6GlQR8GyOIZJcI6iAoOf0Ht1W7wrhj2OM2QAN
+W7WDpt1C0RJBjytx2kB7wSGjnS5Vbs3dGbFwCCHGbFE9w0/zH9dlp42OzHgEbdmtU3siyRQWlFLq
+DbY/Slwt5UV0B3UoAtUycAKYgDdK5vmabKatigAEEJCadzFlMHV0VfKazyyc3MN1aAkew6/EYdwO
+XdZ/EZJy+Nsbae8Vp+qvjUd28j07IfD4oYQ4tc03YQC45eyMCU24dVZBsKs8OA1OokBdjLGx0zau
+iAnc3UFXlgkc3yP0HvVrnxDr51XRdL3OINkDsgOgGgmcKbacEEJi0FtICmZC7kl0g7nmne3Q6q+q
+V1Vz3QoosCuaYLgvVR5JwEA4aNJKpNAeCT3Kvx0diqboi17gdtzSgMMYmGGaN36qIDbIvodlJFjY
+UTw0s3I28TzfohCECXImgDjj48crHUHNDgxxPe1G+HFmLT8K8F+x0DkfWihCAgl4TDrcyKR7dQ5G
+6CP+JndHpjyHD0e86f0QhARDg+QSA5/LbUHWB9DX7p5OFT00RtaKrUS8gH6BCEBIOEzGNwf4DD+Y
+aif1KhGPMxxija1zm8yQ+j7jkhChSaDhma55tkILt7cbr6Ut6DAx4YmtLQ9wG5chCoIJuGYszgAz
+wzzthpNicLGPlsm8bU1o+XT9kIUoWWuJZcuPj6oInyyOOljWi6Pc+iXhuE6FviznXkv3e4716D0Q
+hUhoDshzfJTTXqhCoOM1DmbKcIQgOXdgikOcRy5IQgEL6Gyq5zJZ4gIQNQPetkIQE8RIYRWwHNSx
+bMCEIAkYHsNKs9prb6oQgFDCOlqURkDr9UIQAHFhIdsutn2FirQhCiyvbJGa5qs0n3QhANqTB1IQ
+oDglIOy49+o2eaEKg//Z
+                       </content>
+                       <content_sha1>c3511df85d21bc578faf71c6a19eeb3ff44af370</content_sha1>
+               </file>
+       </files_fal>
+</T3RecordDocument>
diff --git a/typo3/sysext/impexp/Tests/Functional/Import/PagesAndTtContentWithImagesInFilledDatabaseTest.php b/typo3/sysext/impexp/Tests/Functional/Import/PagesAndTtContentWithImagesInFilledDatabaseTest.php
index 64552d0..75d8fcc 100644 (file)
--- a/typo3/sysext/impexp/Tests/Functional/Import/PagesAndTtContentWithImagesInFilledDatabaseTest.php
+++ b/typo3/sysext/impexp/Tests/Functional/Import/PagesAndTtContentWithImagesInFilledDatabaseTest.php
@@ -96,4 +96,54 @@ class PagesAndTtContentWithImagesInFilledDatabaseTest extends AbstractImportExpo
 
         $this->assertFileEquals(__DIR__ . '/../Fixtures/Folders/fileadmin/user_upload/typo3_image2.jpg', PATH_site . 'fileadmin/user_upload/typo3_image2.jpg');
     }
+
+    /**
+     * This test checks multiple remapping does not occur - issue #67188
+     * Scenario:
+     * - Have a local sys_file:1 entry to some image
+     * - Have an import file with 3 tt_content, first element pointing to sys_file:1
+     *   image "used-1.jpg" (different from locally existing one), and the other two pointing to
+     *   sys_file:2 "used-2.jpg" (also not existing locally)
+     * Upon import, the following is expected:
+     * - sys_file:1 from import file becomes sys_file:2 locally
+     * - sys_file:2 from import file becomes sys_file:3 locally
+     * - content element:1 should reference sys_file:2
+     * - content element:2 & 3 should reference sys_file:3
+     * The issue from #67188 is that tt_content:1 was first mapped to sys_file:2
+     * and when tt_content:2 and tt_content:3 were processed, tt_content:1 image
+     * reference was mapped a second time to the not correct relation sys_file:3,
+     * ending up in mixed sys_file_reference entries.
+     * This test verifies first content element still points to the image used-1.jpg
+     * while the other two point to point to image used-2.jpg
+     * Note the internal handler mixes up insert orders resulting in former tt_content:1
+     * ending up as tt_content:3 and 2/3 ending up as 2/1 uid-wise ... making this issue
+     * even harder to grasp.
+     *
+     * @test
+     */
+    public function importPagesAndTtContentWithRemappingNewSysFileEntries()
+    {
+        $subject = GeneralUtility::makeInstance(Import::class);
+        $subject->init();
+
+        // Have a single sys_file entry with uid 1
+        $this->importDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_single_image.xml');
+        $this->importDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_storage.xml');
+
+        // Import file with sys_file:1 and sys_file:2, where sys_file:1 has one connected
+        // content element, and sys_file:2 has two connected content elements.
+        $subject->loadFile(
+            __DIR__ . '/../Fixtures/XmlImports/pages-and-ttcontent-with-two-images.xml',
+            1
+        );
+        $subject->importData(0);
+
+        $this->testFilesToDelete[] = PATH_site . 'fileadmin/user_upload/typo3_image2.jpg';
+        $this->testFilesToDelete[] = PATH_site . 'fileadmin/user_upload/used-1.jpg';
+        $this->testFilesToDelete[] = PATH_site . 'fileadmin/user_upload/used-2.jpg';
+
+        // Expect mapping is updated: one content element should still reference new sys_file:2,
+        // two others should reference new sys_file:3
+        $this->assertCSVDataSet('EXT:impexp/Tests/Functional/Fixtures/DatabaseAssertions/importPagesAndTtContentWithRemappingNewSysFileEntries.csv');
+    }
 }
TYPO3 CMS Core Development