Archaic Binary

How to add more than one category?

Well, at the moment I don't believe it is possible. There would need to be some changes to the module and possibly the component. I will take a look at the module, and see if this is the cause. I'll post here when I take a look.

I remember it was fairly easy... I just changed some "select x from jos_content where category=$category" to "saelect x from jos_content where category = any ( $category)" or where category in ($category). Then just need to write categories separated by commas in the config page. When I'm home I'll try to find the exact spot.

If you can paste the code here would be very grateful.

Ok, I think it was this. Not sure, though, so backup before you try...

* Showing the contents of more than 1 category when you click on a date:

modules/com_calendar/class_com_ab_calendar.php, function getContent() ... around line 106

$sql .= $this->showall || !strlen($this->sectionid) || !strlen($this->categoryid) ? '' : " and sectionid='$this->sectionid' and catid='$this->categoryid' ";

becomes

$sql .= $this->showall || !strlen($this->sectionid) || !strlen($this->categoryid) ? '' : " and sectionid='$this->sectionid' and catid IN ($this->categoryid)";

* Making a link on a calendar's day if it contains any content from one of several categories:

same folder, class_my_calendar.php, function getDateLink, around line 482:

$sql .= $this->general[4] == 1 || !strlen($this->general[0]) || !strlen($this->general[2]) ? '' : " and sectionid='$this->sectionid' and catid='$this->categoryid' ";

becomes

$sql .= $this->general[4] == 1 || !strlen($this->general[0]) || !strlen($this->general[2]) ? '' : " and sectionid='$this->sectionid' and catid IN ($this->categoryid) ";

For these changes to work, categoryid is supposed to look like 22, 43 ... or '22', '43'. In my case I could do that in the config panel, but don't remember if after Sven's changes this was still possible. Worst case, you can assign the value in the code.

Thanks disablez! There you go, happy to see others helping out too