TYPO3: Move content elements into fluid content containers

raw

1-create-container.sql

1
2
3
4
5
6
7
8
INSERT INTO tt_content (pid, tstamp, crdate, cruser_id, CType, header, tx_fed_fcefile)
 SELECT
  uid, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 1,
  "fluidcontent_content", "Content elements", "Vnd.Foo:Container.html"
 FROM pages
 WHERE title = "Referenzen" LIMIT 1
 
 
raw

2-move-elements-into-container.sql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
UPDATE tt_content AS t1, tt_content AS t2, pages
 SET
  t1.colPos = 18181,
  t1.tx_flux_column = "content",
  t1.tx_flux_parent = t2.uid
 WHERE
  t2.pid = pages.uid
  AND t1.colPos = 0
  AND t1.tx_fed_fcefile != "Vnd.Foo:Container.html"
  AND t1.pid = pages.uid
  AND t2.pid = pages.uid
  AND pages.title = "Referenzen"
  AND t2.tx_fed_fcefile = "Vnd.Foo:Container.html"
 
Christian Weiske Christian Weiske
owner

History