I had to translate events in a multilingual site (French + UK)
As JEM does not comply with the Joomla multilingual language feature, I had to duplicate French categories + events and translate them in English. So for each event I have 2 items (1 Fr and 1 UK)
It worked fine… until I saw the global calendar:
where of course all the events are shown. So all twice: 1 French, 1 UK
It's just normal but unwanted... I'd like to show a French calendar or a UK calendar.
As far as I know, there’s no parameter to set for this menu item type to filter categories/events to be shown
(I know the Calendar Legend at the bottom of the page, were you can filter categories. But I'd like categories to be already filtered at page loading...)
What do you suggest to me?
Override this file /components/com_jem/views/calendar/tmpl/default.php
check the user language choosen by user and filter categories ids that should be displayed?
Hum... it seems to work...
if I set 2 global "master" categories: French and English,
and give to each event one of these master categories + it's own sub category,
then I get all the French or English category events are listed in the calendar and with the subcategory color !...
I'll try to deploy it tomorrow and report here.
It works but I have more than 100 events to edit:
I have to add to each one it’s « mother » category (French or English) depending of it’s actual category.
I’d prefer do a PHP / myySQL script to automate that, no ?
I should have to create a php/SQL request that would parse the table `jem_cats_event_relations` from the id ‘7000` (before, they are passed events), copy the `catid` and just depending of the French/UK belonging ids, add a new line for this `itemid` with the French or UK catid
Could I do that directly with phpMyAdmin or should I create a php file with the whole script (if… then…)?
And if you could guide me a little bit, I would be grateful.