[TYPO3-english] CoolURI + Macina Banners

Guus Leeuw Jr guus.leeuw at itpassion.com
Thu Nov 4 07:14:12 CET 2010


OK. Now I've got the query correct, in that CoolURI generates the page title
from the macinabanner uid:
            <to>SELECT title FROM pages WHERE uid IN (SELECT url FROM
tx_macinabanners_banners WHERE uid = $1)</to>
However, that generates a link http://www.mydomain.com/24x7-monitoring/ and
seems to forget about the page path (which is

Any suggestions, anyone?


> -----Original Message-----
> From: typo3-english-bounces at lists.typo3.org [mailto:typo3-english-
> bounces at lists.typo3.org] On Behalf Of Guus Leeuw Jr
> Sent: 02 November 2010 06:47
> To: typo3-english at lists.typo3.org
> Subject: [TYPO3-english] CoolURI + Macina Banners
> Hello,
> I'm trying to integrate Macina Banners with CoolURI. Shouldn't be too
> difficult, as macinabanners works on the basis of a URL parameter called
> tx_macinabanners_pi1[banneruid].
> So I made an image banner with a link to page id 61 (/solutions/24x7-
> monitoring). This banner has uid=2.
> Converting that is easy:
> <part>
>  <parameter>tx_macinabanners_pi1[banneruid]</parameter>
>  <lookindb>
>   <to>SELECT title FROM pages where uid in (SELECT url FROM
> tx_macinabanners_banners WHERE uid=$1)</to>
>   <t3conv>1</t3conv>
>  </lookindb>
> </part>
> The problem with this is that the title is then taken as full CoolURI URI:
> http://www.mydomain.com/24x7-monitoring where as it should have been
> http://wwww.mydomain.com/solutions/24x7-monitoring.
> If I simply
> <part>
>  <parameter>tx_macinabanners_pi1[banneruid]</parameter>
>  <lookindb>
>   <to> SELECT url FROM tx_macinabanners_banners WHERE uid=$1</to>
>   <t3conv>1</t3conv>
>  </lookindb>
> </part>
> the generated URL looks like:
> http://www.mydomain.com/61/solutions/24x7-monitoring
> So, I'm kinda at a loss as to what to look up. The page id by itself
doesn't help,
> and I can't quite figure out how to query the link_cache table based on
> parameter. Maybe there is a way to call a function that will get me the
> page path within my domain, which then would be sensible enough for
> CoolURI to map back to a page.
> Hmm... An Idea: Apparently, if I look up the url in
> tx_macinabanners_banners, the generated URL becomes
> /61/solutions/24x7-monitoring. What if I just simply make the whole
> parameter disappear, much like cHash, would that help? Let's see... No,
> doesn't help either. The generated link is then /2/solutions/24x7-
> monitoring...
> Anybody any idea as to what I should be generating in CoolUriConf.xml so
> to make the correct path (/solutions/24x7-monitoring) appear?
> Regards,
> Guus
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

More information about the TYPO3-english mailing list