Typo3

I was trying to find out how to show an image with f:image with an absolute path and I was sure, google would be able to tell me a solution within 5 minutes. Turns out: I was wrong. It seems […]

I created an extbase extension to display a list of articles on a certain page (pageUid = 24). Before realurl, the url looked like this: http://www.domain.com/artikelsammlung/haushalt.html?tx_somethingarticles_categorydetail[articleCategory]=101&tx_somethingarticles_categorydetail[action]=showByArticleCategory&tx_somethingarticles_categorydetail[controller]=Article What I wanted to achieve: http://www.domain.com/artikelsammlung/haushalt/ARTIKELNAME.html My realurl_conf.php looks like this: ‘fixedPostVars’ => array( […]

It seems that this doesn’t work if pid = 0. So always set another pid.

I needed a query that returns 5 random items. My solution: //fetch 5 IDs from the mm table $idArr = $GLOBALS[‘TYPO3_DB’]->exec_SELECTgetRows( ‘uid_local’, ‘tx_something_user_userarticles_article_mm’,”, ”, ‘RAND()’, ‘5’ ); $ids = array(); //save the IDs to $ids foreach($idArr as $k => $v){ […]

If I want to look at the generated query, I have to do this: $queryParser = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance(‘TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Storage\\Typo3DbQueryParser’); \TYPO3\CMS\Extbase\Utility\DebuggerUtility::var_dump($queryParser->parseQuery($query)); That doesn’t show the query itself, but at least all parts and the information in tables, fields and where are quite helpful. […]

Today I spent hours trying to figure out why a relation wasn’t working. I have a table comments and a table fe_users, and a user can post a comment, therefore user:comment => 1:n. I had everything configured appropriately, yet $user->getComments() […]

The extension rlmp_language_detection is supposed to automatically detect the browser language and display the right language page. This is supposed to be as easy as installing the extension but, of course, with Typo3 it is never that easy. To make […]