Andrei Eftimie

All your web are belong to us!

0 Notes & Comments

Safely make a Typoscript query with CONTENT from a get/post parameter

Use this code when you need to make a query from Typoscript based on a parameter sent by GET or POST. They say if you pass it trough the markers method, it will be escaped and quotes to avoid SQL injection attacks.

temp.user = CONTENT
temp.user {
    table = fe_users
    select {
        #ID of the Userfolder
	pidInList = 11
	where = uid = ###myid###
	markers {
    	    myid.data = GP:myid
        }
    }
}

Original source here: http://wiki.typo3.org/index.php/TSref/select

Filed in typo3 ts typoscript tsref CONTENT select query

0 Notes & Comments

Elmshorn #t3dd10

We’ve finally arrived at our hotel  — Royal (anyone at the Royal lets get together for a beer or two) — in Elmshorn, Germany for the Typo3 Developer Conference 2010 ( #t3dd10 ).

Wizair flight from Cluj to Dortmund was good.
(This was actually my first flight, and I enjoyed it quite a bit).

We tried to rent a car from Dortmund’s airport. None of the 5 credit debit cards we had on us (with money on them) was good, as they only accept credit cards — the debit card is not supported — and none of them accepted cash.

We came by train: long, exhausting and for a big part we had no seats :(

*****

But we are here. In our hotel rooms. No free internet :( , only T-Mobile pay-wireless 8 € / hour or 29.5 € / 30 days. No, they don’t have any in-between plan. Just awesome.

The Weissbier was really good.

******

Plans:

  • meet some more typo3 folk
  • learn cool stuff about Typo3 that we may have missed
  • get some more insight as to where Typo3 is headed
  • try to use this as a marketing tool since we offer great Web Development skills (most of them focused on Front-End and Typo3) for good prices — good for nearshore outsourcing

Filed in elmshorn typo3 t3dd10