Using multiple categories in EventCalendar3 for WordPress

By | June 11, 2006

So I read at a few points that EventCalendar 3.1 was on its way, but I decided to start mangling some code to get multiple event categories to work!

Open eventcalendar3.php near line 525;

// Which posts are we interested in?
if($ec3->show_only_events)
{
// Category ID number for event posts.
$where_post = "category_id IN ('$ec3->event_category','14')";
}

I changed $where_post to add another category, this category will show up in the calendar now!

Also update line 540 to incorperate the same code so the date will be colored!

$calendar_entries = $wpdb->get_results(
"SELECT DISTINCT
post_title,
post_date,
DAYOFMONTH(post_date) AS day,
MONTH(post_date) AS month,
YEAR(post_date) AS year,
(category_id IN ('$ec3->event_category','14')) AS is_event
FROM $tableposts,$tablepost2cat
WHERE post_date >= '$begin_date'
AND post_date <  '$end_date'
AND post_status = 'publish'
AND id = post_id
AND $where_post
ORDER BY post_date ASC"
);

Each of my Event categories I want to add will be entirely seperate categories, no sub-categories, I did this so I could exclude some categories from showing up where I did not want them.

To add each category to show up like the events open eventcalendar3.php again near line 1032;

$ec3->is_listing =
(preg_match("/\bcategory_id\s*=\s*'?($ec3->event_category|3|4|14|8|9)'?\b/",$where) ||
preg_match("/\bcategory_nicename\s*=\s*'$event_cat_nicename'/",$where));

I changed preg_match("/\bcategory_id\s*=\s*'?$ec3->event_category'?\b/",$where) || to add the extra categories.

Each category I want to show up in the calendar view I make sure that they are part of the Event category as well as their own.

You can see this in effect at www.austinpublic.com

2 thoughts on “Using multiple categories in EventCalendar3 for WordPress

  1. Jeff

    I seem to have completely different code in my version of EC3. Different variable names and different lines. I can’t quite make the translation.

  2. Barrett Sonntag Post author

    Jeff, it has been 3 years since I messed with EC3, it is likely that the code base has changed completely. I wish you luck.

Leave a Reply

Your email address will not be published.

Comment moderation is enabled. Your comment may take some time to appear.

This site uses Akismet to reduce spam. Learn how your comment data is processed.