Chandan Web Blog.

Entries for the ‘typoscript’ Category

Running a SQL Query using TypoScript

Well, after using this feature for quite long time, I though I should post this info:Consider the following Query: SELECT DISTINCT FROM_UNIXTIME(`datetime`, ‘%Y’) AS `year` FROM tt_news where pid=113 order by datetime limit 1 My main goal was to get the latest year from the tt_news records, that is then going to be pushed to [...]

Conditional menu based on menu page-id

Following code gives a nice way to have a custom content element as sub-menu item for each main menu item lib.customMenu = HMENU lib.customMenu { 1 = TMENU 1 { wrap = | NO.allWrap = | NO.stdWrap.htmlSpecialChars = 1 NO.after.cObject = COA NO.after.cObject { 20 = CASE 20 { key.field = uid default = RECORDS [...]

Display Image when both path and file name are in two fields

The following code gives an overview of how to display an IMAGe when 2 fields are involved. That is one contains the image path “fileadmin/templates/imgs/” and the other field has the image name “mylogo.png” 10 = IMAGE10 { file.import { cObject = COA cObject { 10 = TEXT 10.data = field:image_path 20 = TEXT 20.data [...]

Displaying page title : Various methods

Getting page title for a specific page (using uid) METHOD 1: temp.pTitle = HMENU temp.pTitle { special = list special.value = {$my_page_uid} 1 = TMENU 1 { NO { doNotLinkIt = 1 } } } METHOD 2: (The localization may not work fine in the below method) lib.pagetitle = RECORDS lib.pagetitle { source.data = page:uid [...]

How to find and change TYPO3 settings.

This is a small reference to give an idea on how to find a TYPO3 setting that can be changed, and how to change it. Easy: go to BE Click the Configuration module in left menu bar Now use the drop down at the top, and select TYPO3_CONF_VARS. Search for what you need Click on [...]

Subscribe to this page grab our RSS feed
search_left
Theme & Wordpress Integration - by Chandan