[TYPO3-english] CoolURI + Macina Banners

[Guus Leeuw Jr]

Hello,

OK. Now I've got the query correct, in that CoolURI generates the page title
from the macinabanner uid:
    <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>
However, that generates a link http://www.mydomain.com/24x7-monitoring/ and
seems to forget about the page path (which is
/solutions/24x7-monitoring/)...

Any suggestions, anyone?

Regards,
Guus

> -----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
the
> parameter. Maybe there is a way to call a function that will get me the
full
> 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
as
> 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