« Future post searching for WordPress
Using multiple categories in EventCalendar3 for WordPress (update 1) »

Using multiple categories in EventCalendar3 for WordPress

Published by sosuke June 11th, 2006 in WordPress, PHP, Portfolio

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;

PLAIN TEXT
PHP:
  1. // Which posts are we interested in?
  2. if($ec3->show_only_events)
  3. {
  4. // Category ID number for event posts.
  5. $where_post = "category_id IN ('$ec3->event_category','14')";
  6. }

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!

PLAIN TEXT
PHP:
  1. $calendar_entries = $wpdb->get_results(
  2. "SELECT DISTINCT
  3. post_title,
  4. post_date,
  5. DAYOFMONTH(post_date) AS day,
  6. MONTH(post_date) AS month,
  7. YEAR(post_date) AS year,
  8. (category_id IN ('$ec3->event_category','14')) AS is_event
  9. FROM $tableposts,$tablepost2cat
  10. WHERE post_date>= '$begin_date'
  11. AND post_date < '$end_date'
  12. AND post_status = 'publish'
  13. AND id = post_id
  14. AND $where_post
  15. ORDER BY post_date ASC"
  16. );

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;

PLAIN TEXT
PHP:
  1. $ec3->is_listing =
  2. (preg_match("/\bcategory_id\s*=\s*'?($ec3->event_category|3|4|14|8|9)'?\b/",$where) ||
  3. 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

No Responses to “Using multiple categories in EventCalendar3 for WordPress”  

Feed for this Entry Trackback Address
  1. No Comments

Leave a Reply


Search