[EventCalendar] EC3 tripples upcoming events on trilingual blog (one per language)

[Ralf Strandell]

Yes, indeed. There is that sql query :(

Gengo faq tells: "A meta content-language tag [is added] to the head of
single language pages. link rel tags for all of the translations of a post.
a href-lang tags for all links that will go to a language page."

So I just need to modify that sql query (or pass its results through some
additional filtering) to display the heads of those posts only, than have
the link rel tags match with the_language_code ...

I am no sql master, so I do not know what to add where to compare those link
rel tags.
Any ideas? Examples? Documentation? Anything?

2007/10/2, Dr. Peter Troxler <peter.troxler at gmx.net>:
>
> I had a look into the gengo multilingual plugin this morning.  If you
> create a second post which is a translation then you actually create a 2nd
> post for the same day(s) as the first one
> in your .fi example
>
> http://www.homoglobiini.fi/category/event-calendar/en/ lists the english
> events (so does http://www.homoglobiini.fi/?cat=7&language=en)
> http://www.homoglobiini.fi/category/tapahtumakalenteri/fi/ lists the
> finnish events (do does http://www.homoglobiini.fi/?cat=7&language=fi)
> http://www.homoglobiini.fi/category/handelsekalender/sv/ lists the swedish
> events (so does http://www.homoglobiini.fi/?cat=7&language=sv)
>
> also trying the ?m=20071026&cat=7&language=e<http://domain.com?m=20071026&cat=7&language=en>n
> (or fi or sv) shows the event in that respective language only
>
> so it looks like you have solved the problem,  except for the upcoming
> events widget
>
> this widget uses the ec3_get_events function which contains a direct
> database query.  this query gets all posts that are related to the schedule
> entries, i.e. if you duplicated a post as described above, it will
> retrieve 2 posts.  you would most probably need to alter that function to
> make it work nicely with  (as far as I can see from looking at the code).
> this is, I'd assume, not such an easy fix.
>
> On 2-okt-2007, at 20:38, anonymous forever wrote:
>
> I have an example. Go to the homoglobiini.fi domain and look at the
> two-column sidebar to the right. The upcoming events widget "Tulossa" lists
> the same event three times on 26th october and also on 2nd november.
>
>
> On 10/2/07, Ralf Strandell <ralf.strandell at gmail.com> wrote:
> >
> > WordPress 2.2.3 (i.e. NOT 2.3)
> > ec3 version 3.1.1_RC1
> >
> > 2007/10/2, Dr. Peter Troxler < peter.troxler at gmx.net>:
> > >
> > > Ralf, if you give us a bit more information we might be able to help
> > > -- wp version
> > > -- ec3 version
> > > -- link to your site
> > >
> > > / pt
> > > On 2-okt-2007, at 6:53, Ralf Strandell wrote:
> > >
> > > Hi
> > >
> > > I am using this splendid EventCalendar3 plugin together with Gengo
> > > multilingual plugin.
> > >
> > >
> > > The EC3 sidebar calendar correctly takes me either to:
> > >
> > > - domain.com?m=20071026&cat=7&language=en
> > >  or
> > > - domain.com?m=20071026&cat=7&language=fi
> > > ...
> > >
> > > depending on the language I have chosen to view my site in.
> > >
> > >
> > > The upcoming events widget however, lists all the event posts. It does
> > > not take into consideration the_language or the_language_code or anything.
> > > So... Each of my events produces three rows of upcoming events. One in
> > > finnish. One in swedish. One in english. What a nuisance!
> > >
> > > Could someone please instruct me, as to how to correct this problem. I
> > > guess that I just need to modify some little function to filter by language,
> > > but I am no PHP wizard yet.
> > >
> > > Thanks
> > >
> > > _______________________________________________
> > > Blog: http://wpcal.firetree.net /
> > > EventCalendar at firetree.net mailing list
> > > Unsubscribe: http://penguin.firetree.net/eventcalendar
> > >
> > >
> > >
> > > _______________________________________________
> > > Blog: http://wpcal.firetree.net/
> > > EventCalendar at firetree.net mailing list
> > > Unsubscribe: http://penguin.firetree.net/eventcalendar
> > >
> > >
> >
> > _______________________________________________
> > Blog: http://wpcal.firetree.net/
> > EventCalendar at firetree.net mailing list
> > Unsubscribe: http://penguin.firetree.net/eventcalendar
> >
> >
> _______________________________________________
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar
>
>
>
> _______________________________________________
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20071003/42b2218c/attachment.htm