Typoscript to get database values in Breadcrumb

lib.breadcrumb = COA
lib.breadcrumb.wrap = <ul class=”breadcrumb hidden-xs”>|</ul>
lib.breadcrumb {
10 = HMENU
10 {
special = rootline
special.range = 0|-1
1 = TMENU
1 {
no.allwrap = <li>|</li>
no.stdwrap.htmlspecialchars = 1
cur = 1
cur {
allwrap = <li>|</li>
donotlinkit = 1
stdwrap {
data = page:subtitle // page:nav_title // tsfe:page|title
htmlspecialchars = 1
}
}
}
wrap >
}
20 = CONTENT
20 {
table = country
select {
pidInList = 605
where = uid= ###whatever### AND NOT deleted AND NOT hidden
markers {
whatever.data = GP:tx_country|country
}
}
renderObj = COA_INT
renderObj {
10 = TEXT
10.field = name
10.stdWrap.typolink.parameter = 610
10.stdWrap.typolink.additionalParams = &tx_country[country]={GP:tx_country|country}
10.stdWrap.typolink.additionalParams.insertData = 1
10.wrap = <li>|</li>
}
}
30 = CONTENT
30 {
table = city
select {
pidInList = 606
where = uid= ###whatever### AND NOT deleted AND NOT hidden
markers {
whatever.data = GP:tx_country|city
}
}
renderObj = COA_INT
renderObj {
10 = TEXT
10.field = name
10.wrap = <li>|</li>
}
}
}

That’s it

Output will be like this

Section Index menu to link perticular content in other page

Here is the typoscript

tt_content.menu.20.3 >
tt_content.menu.20 {
3 < styles.content.get
3.wrap = <div class=”csc-menu csc-menu-3″>|</div>
3.select.andWhere = sectionIndex!=0
3.select.pidInList.override.field = pages
3.renderObj = CASE
3.renderObj {
key.field = header_layout
default = COA
default {
stdWrap.fieldRequired = header
stdWrap.fieldRequired = header_link
10 = TEXT
10.field = header
10.trim = 1
10.htmlSpecialChars = 1
10.dataWrap = <p class=”csc-section-1″>|</p>
#10.typolink.parameter.field = pid
#  Where header_link is a link field in content element (542#210) where 542 is page ID and # # 201 is content id to link
10.typolink.parameter.field = header_link

}
1 < .default
2 < .default
2.10.dataWrap = <p class=”csc-section-2″>|</p>
3 < .default
3.10.dataWrap = <p class=”csc-section-3″>|</p>
4 < .default
4.10.dataWrap = <p class=”csc-section-4″>|</p>
5 < .default
5.10.dataWrap = <p class=”csc-section-5″>|</p>
}
}

Typoscript to show filesize in FAL

Here is the code to show file size in terms of kilobytes,Megabytes and Gigabytes

lib.image = FILES
lib.image {
references {
table = tt_content
fieldName = media
}
renderObj = COA
renderObj {
10 = TEXT
10.data = file:current:size
10.bytes.labels = Bytes | KB | MB | GB
10.dataWrap = <a target=”_blank” href=”{file:current:publicUrl}” >{file:current:title},&nbsp; |</a>
}
}

TYPO3 adding section frames.

Below is the way how we can add the section frames by preserving the content element ID. This way works on TYPO3 6.x.

1. In TS template

### FRAMES ###
tt_content.stdWrap.innerWrap.cObject {
100 < tt_content.stdWrap.innerWrap.cObject.default
100.20.10.value = boxclass
}

2. In page TS Config

TCEFORM.tt_content.section_frame {
addItems.100 = My custom box
}