tt_news select configuration¶

What does it do?¶

• The extension tt_news select configuration enables you to add an andWhere clause to the SQL query of a tt_news. I.e. it is possible to display tt_news items in dependence on the fe_user ownership.
• The andWhere clause has the stdWrap property.
• It's possible to configure tt_news select configuration differently per each tt_news plugin.

What do you need?¶

The extension tt_news.

Extension Manager¶

• Open the extension manager, download the extension named tt_news select configuration (extkey: ttnews_selectconf) and install it.
• Extend the typoscript of your tt_news with the andWhere clause (see the property "extension" in the reference on page 8).

Display news of the current day only¶

The andWhere statement from below will display news only, if they are published today.

plugin.tt_news.extensions.ttnews_selectconf {

andWhere (

tt_news.datetime >= (UNIX_TIMESTAMP() - (UNIX_TIMESTAMP() % 86400) + 7200)

AND tt_news.datetime < (UNIX_TIMESTAMP() - (UNIX_TIMESTAMP() % 86400) - 86400 + 7200)

)

}

Be aware: if you are customising tt_news by TypoScript and nit by a plugin, you have to configure your tt_news within the page object like in the snippet below:

page.10.default.subparts.content.20.extensions.ttnews_selectconf {

...

}

Probably the 7.200 in the snippet above has to do with the properties of the current server. 7.200 seconds are two hours.

Thanks to

Michael Langmedia.design http://www.mediadesign-ffm.de

for the code snippet.

Display latest news only configured for selected plugins¶

The andWhere statement from below will display latest news only, published from today. The andWhere statement has an effect only for plugins with the uids 791 and 2558.

The andWhere statement is usefull especially for an event calendar.

plugin.tt_news {

extensions {

ttnews_selectconf {

csvPluginsOnly = 2558, 791

andWhere (

tt_news.datetime >= (UNIX_TIMESTAMP() - (UNIX_TIMESTAMP() % 86400) + 7200)

)

}

}

}

Be aware: if you are customising tt_news by TypoScript and nit by a plugin, you have to configure your tt_news within the page object like in the snippet below:

page.10.default.subparts.content.20.extensions.ttnews_selectconf {

...

}

Probably the 7.200 in the snippet above has to do with the properties of the current server. 7.200 seconds are two hours.

Thanks to

Michael Langmedia.design http://www.mediadesign-ffm.de

for the code snippet.

Debug Query¶

For developers only.

Should delivers the start time of today like 2015-08-30 00:00:00

SELECT FROM_UNIXTIME(UNIX_TIMESTAMP() - ((UNIX_TIMESTAMP() % 86400) + 7200))

Should delivers the start time of tomorrow like 2015-08-31 00:00:00

SELECT FROM_UNIXTIME(UNIX_TIMESTAMP() - ((UNIX_TIMESTAMP() % 86400) - 86400 + 7200))

Extensions.ttnews-selectConf¶

plugin.tt_news {
  extensions {
    ttnews_selectconf {
      andWhere = tt_news.crfeuser_id = 85
    }
  }
}

plugin.tt_news.extensions.ttnews_selectconf {
  andWhere {
    dataWrap        = tt_news < {field:field_date}
    if.isFalse.data =         field:field_specific
  }
  udInList.data = field:field_specific
}

select¶

These are the SQL-select statements which are available. It's important to notice though, that many of them will not be available in every display mode as they are overwritten internally in the tt_news code. Also you might get unexpected results in some situations if you mess too much with the current values. The andWhere statement doesn't seem to be used by tt_news (extensions extending tt_news might), so you can relative safely use this one without worrying if it will be overwritten.

New Features and Bug Reports¶

You are welcome to post any question, bug or code snippet on TYPO3 forge.Here you find feature announcements and bug reports.See

http://forge.typo3.org/projects/extension-ttnewsselectconf

Other extensions published by Die Netzmacher¶

• +AOE Linkhandler Configurator: Configure the AOE linkhandler supported by userinterfaces. Out-of-the-box templates for cal, org, tt_news and tt_products. Don't edit page TSconfig any longer. http://typo3.org/extensions/repository/view/linkhandlerconf/
• autositemap: A smart site-map optimised for the footer. It groups menus in columns. Great menus will get two columns. Configuration is based on TypoScript HMENU. http://typo3.org/extensions/repository/view/autositemap/
• Browser – TYPO3 without PHP. Develop your TYPO3 extension 8 times faster! You need one line TypoScript for a result list with a search form, a record browser and an index browser. Images are wrapped self-acting. SEO, Search Engine Optimization, is integrated. http://typo3.org/extensions/repository/view/browser/
• Caddy – the TYPO3 shopping cart. You can use it for your own needs. You need a database with products or any other items only. You can install Caddy out of the box with one mouse click – see Quick Shop below. http://typo3.org/extensions/repository/view/caddy/
• Deal! – TYPO3 Quick Shop interface for the marketplace ebay. Manage all items with TYPO3 and publish it on ebay. Amazon is under construction. http://typo3.org/extensions/repository/view/deal/
• Flip it! offers lovely and smooth page flip transitions. It enables you to run over pages in PDF documents like in a real magazine. It is based on flash. Flipt it! can convert PDF documents to swf files automatically. http://typo3.org/extensions/repository/view/flipit/
• Jobmarket is a catalogue with job offers. Views, the a-z-browser, the page-browser, the search, social bookmarks and a lot of other stuff can configured by the Browser plugin with the mouse. Job Market hasn't any PHP code, it should be easy to adapt it to your needs. http://typo3.org/extensions/repository/view/job_market/
• Majordomo: For subcribing to and unsubscribing from a majordomo mailing list. http://typo3.org/extensions/repository/view/majordomo/
• Organiser – TYPO3 for the lobby and the organisers. Handle news, events, staff, headquarters, locations, workshops and a calendar with one extension. Sell online tickets! Install the Organiser with one mouse click! http://typo3-organiser.de/
• Quick Shop – the fastest shop in the history of TYPO3. Install it with one mouse click! Quick Shop is based on the browser (see above) and powermail. http://typo3-quick-shop.de/
• PDF Controller: Easy to install. Add to your HTML page the PDF-controller-button. Link from the button to the controller. Adjust the controller by mouseclicks. The PDF Controller supports CSS 3. http://typo3-pdfcontroller.de/
• Radial Search (Umkreissuche) – Enable the browsing through your data by geo location. 'Your data must have a latitude and a longitude. Address data can geocoded automatically by the Browser - TYPO3 without PHP. http://typo3.org/extensions/repository/view/radialsearch/
• Route – Publish your routes with GoogleMaps or OpenStreetMap. Routes have points of interest (POI). You can categorise and filter both: routes and POI. Address data can geocoded automatically. http://typo3.org/extensions/repository/view/route/
• seo_dynamic_tag: Search Engine Optimization for the title tag, the canonical tag and the meta tags author, description and keywords. Configuration by a user interface. http://typo3.org/extensions/repository/view/seo_dynamic_tag/
• TSconfig Pages and Users by extManager (extkey: tsconf): Configure the the eight most commonly used TSconfig porperties with the mouse - like page tree uids, activated extended view, activated clipboard, ... http://typo3.org/extensions/repository/view/tsconf/