*/
function ec3_util_calendar_days($begin_month_id,$end_month_id)
{
$begin_date=substr($begin_month_id,4) . '_1';
$end_date =substr($end_month_id,4) . '_1';
global $ec3, $tablepost2cat, $tableposts, $wpdb;
// Which posts are we interested in?
if($ec3->show_only_events)
{
// Category ID number for event posts.
$where_post = "category_id = $ec3->event_category";
}
else
{
$now = gmdate('Y-m-d H:i:59');
$where_post = "(post_date_gmt<='$now' OR category_id=$ec3->event_category)";
}
$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 = $ec3->event_category) 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"
);
$calendar_days = array(); // result
if($calendar_entries)
{
$time_format=get_settings('time_format');
foreach($calendar_entries as $ent)
{
$date=new ec3_Date($ent->year,$ent->month,$ent->day);
$day_id=$date->day_id();
if(empty($calendar_days[$day_id]))
$calendar_days[$day_id] = new ec3_Day();
$calendar_days[$day_id]->add_post(
"$ent->post_title",
mysql2date($time_format,$ent->post_date),
$ent->is_event
);
}
}
return $calendar_days;
}
/** Echos one event calendar month table. */
function ec3_get_calendar_month($date,$calendar_days,$thead)
{
global $ec3;
//
// Table start.
$title=
sprintf(__('View posts for %1$s %2$s'),$date->month_name(),$date->year_num);
echo "";
}
/** Template function. Call this from your template to insert the
* Event Calendar. */
function ec3_get_calendar()
{
// Can't cope with more than one calendar on the same page. Everything has
// a unique ID, so it can't be duplicated.
// Simple fix for problem: Just ignore all calls after the first.
$ec3->call_count++;
if($ec3->call_count>1)
{
echo "\n";
return;
}
echo "\n";
$this_month = new ec3_Date();
global $ec3;
// Display navigation panel.
if(!$ec3->nav_below)
ec3_get_calendar_nav($this_month,$ec3->num_months);
// Get entries
$end_month=$this_month->plus_months($ec3->num_months);
$calendar_days =
ec3_util_calendar_days(
$this_month->month_id(),
$end_month->month_id()
);
// Display months.
$thead=ec3_util_thead();
for($i=0; $i<$ec3->num_months; $i++)
{
ec3_get_calendar_month($this_month,$calendar_days,$thead);
$this_month=$this_month->next_month();
}
// Display navigation panel.
if($ec3->nav_below)
ec3_get_calendar_nav(new ec3_Date(),$ec3->num_months);
echo "
\n";
if(!$ec3->disable_popups)
echo "\t\n";
}
/** Substitutes placeholders like '%key%' in $format with 'value' from $data
* array. */
function ec3_format_str($format,$data)
{
foreach($data as $k=>$v)
$format=str_replace("%$k%",$v,$format);
return $format;
}
/** Template function. Call this from your template to insert a list of
* forthcoming events. Available template variables are:
* - template_day: %DATE% %SINCE% (only with Time Since plugin)
* - template_event: %DATE% %TIME% %LINK% %TITLE% %AUTHOR%
*/
function ec3_get_events(
$limit,
$template_event='%TITLE% (%TIME%)',
$template_day='%DATE%:',
$date_format='j F')
{
global $ec3,$wpdb,$tableposts,$tablepost2cat,$tableusers;
if(!$date_format)
$date_format=get_settings('date_format');
// Start at midnight to show all of today's events
$now = gmdate('Y-m-d 00:00:00');
$calendar_entries = $wpdb->get_results(
"SELECT
p.id AS id,
post_title,
post_date,
u.user_nickname AS author
FROM $tableposts p, $tablepost2cat p2c, $tableusers u
WHERE post_status = 'publish'
AND post_date_gmt > '$now'
AND p.id = post_id
AND p.post_author = u.id
AND category_id = $ec3->event_category
ORDER BY post_date
LIMIT $limit"
);
echo "";
echo "\n";
if(count($calendar_entries))
{
$time_format=get_settings('time_format');
$current_date=false;
$data=array();
$time_now=time()+(60*60*get_settings("gmt_offset"));
foreach($calendar_entries as $entry)
{
// To use %SINCE%, you need Dunstan's 'Time Since' plugin.
if(function_exists('time_since'))
$data['SINCE']=time_since($time_now,abs(strtotime($entry->post_date)));
$data['DATE']=mysql2date($date_format,$entry->post_date);
if((!$current_date || $current_date!=$data['DATE']) && $template_day)
{
if($current_date)
echo "
\n";
echo ""
. ec3_format_str($template_day,$data)."\n\n";
$current_date=$data['DATE'];
}
$data['TIME'] =mysql2date($time_format,$entry->post_date);
$data['TITLE'] =$entry->post_title;
$data['LINK'] =get_permalink($entry->id);
$data['AUTHOR']=$entry->author;
echo " - ".ec3_format_str($template_event,$data)."
\n";
}
if($template_day)
echo "
\n";
}
else
{
echo "".__('No events.','ec3')."\n";
}
echo "\n";
}
/** DO NOT USE. This function is for backwards compatibility. */
function ec2_get_calendar()
{
ec3_get_calendar();
}
/** DO NOT USE. This function is for backwards compatibility. */
function ec2_get_events($limit, $date_format)
{
ec3_get_events(
$limit,
'%TITLE% (%TIME%)',
'%DATE%:',
$date_format
);
}
function ec3_action_admin_menu()
{
if(function_exists('add_options_page'))
{
add_options_page(
'Event Calendar Options',
'EventCalendar',
6,
basename(__FILE__),
'ec3_options_subpanel'
);
}
}
function ec3_options_subpanel()
{
global $ec3;
if(isset($_POST['info_update']))
{
echo '';
if(isset($_POST['ec3_event_category']))
$ec3->set_event_category( intval($_POST['ec3_event_category']) );
if(isset($_POST['ec3_num_months']))
$ec3->set_num_months( intval($_POST['ec3_num_months']) );
if(isset($_POST['ec3_show_only_events']))
$ec3->set_show_only_events( intval($_POST['ec3_show_only_events']) );
if(isset($_POST['ec3_day_length']))
$ec3->set_day_length( intval($_POST['ec3_day_length']) );
if(isset($_POST['ec3_hide_logo']))
$ec3->set_hide_logo( intval($_POST['ec3_hide_logo']) );
if(isset($_POST['ec3_advanced']))
$ec3->set_advanced( intval($_POST['ec3_advanced']) );
if(isset($_POST['ec3_nav_below']))
$ec3->set_nav_below( intval($_POST['ec3_nav_below']) );
if(isset($_POST['ec3_disable_popups']))
$ec3->set_disable_popups( intval($_POST['ec3_disable_popups']) );
_e('Options set.','ec3');
echo '
EXAMPLE SIDEBAR CODE:
<li>
<?php ec3_get_calendar(); ?>
</li>
<li><?php _e('Events'); ?>
<?php ec3_get_events(5); ?>
</li>
event_category);
$event_cat_nicename = $event_cat_record->category_nicename;
$ec3->is_listing =
(preg_match("/\bcategory_id\s*=\s*$ec3->event_category\b/",$where) ||
preg_match("/\bcategory_nicename\s*=\s*'$event_cat_nicename'/",$where));
if($ec3->is_listing && $ec3->advanced && !$wp_query->is_date)
{
// reverse date restriction for event category listing
$now = gmdate('Y-m-d 00:00:00');
$result=preg_replace(
"/\bAND\s+post_date_gmt\s*<=\s*'([-0-9]+) [:0-9]+'/",
"AND post_date_gmt > '\$1 00:00:00'",$where
);
}
elseif($wp_query->is_date || $wp_query->is_single ||
$ec3->is_listing || $ec3->advanced)
{
// (This should be a sub-select, but older versions of MySQL can't cope.)
$post_list=$wpdb->get_results(
"SELECT DISTINCT(post_id) FROM $tablepost2cat " .
"WHERE category_id=$ec3->event_category" );
if(count($post_list))
{
$post_list_str='-1'; // start with a dummy value
foreach($post_list as $p)
$post_list_str.=",$p->post_id";
if($wp_query->is_date || $wp_query->is_single || $ec3->is_listing)
// remove date restriction for events
$result=preg_replace(
"/AND +(post_date_gmt *<= *'[-: 0-9]+') +/",
'AND ($1 OR id IN ('.$post_list_str.') ) ',$where
);
else // ($ec3->advanced)
// remove events from blog.
$result=preg_replace(
"/AND +(post_date_gmt *<= *'[-: 0-9]+') +/",
'AND ($1 AND id NOT IN ('.$post_list_str.') ) ',$where
);
} // end if(count($post_list))
}
return $result;
}
/** Change the order of event listings (only advanced mode). */
function ec3_filter_posts_orderby($orderby)
{
global $ec3;
if($ec3->is_listing)
$orderby=preg_replace("/\bDESC\b/",'',$orderby);
return $orderby;
}
/** If the parameter ec3_xml is set, then brutally hijack the page and replace
* it with XML calendar data. This is used by XmlHttpRequests from the
* active calendar JavaScript. */
function ec3_filter_query_vars_xml($wpvarstoreset)
{
if(isset($_GET['ec3_xml']))
{
$components=explode('_',$_GET['ec3_xml']);
if(count($components)==2)
{
$date=new ec3_Date($components[0],$components[1]);
$end=$date->next_month();
$calendar_days=ec3_util_calendar_days($date->month_id(),$end->month_id());
@header('Content-type: text/xml');
echo '';
echo "\n";
foreach($calendar_days as $day_id=>$day)
{
if('today'==$day_id)
$dc=explode('_', gmdate(':_Y_m_d') );
else
$dc=explode('_',$day_id);
if(count($dc)==4)
{
$date->day_num=$dc[3];
$titles=$day->get_titles();
echo "\n";
}
}
echo "\n";
exit(0);
}
}
// else...
return $wpvarstoreset;
}
/** If the parameter ec3_vcal is set, then brutally hijack the page and replace
* it with vCalendar data.
* (Includes fixes contributed by Matthias Tarasiewicz.)*/
function ec3_filter_query_vars_vcal($wpvarstoreset)
{
if(isset($_GET['ec3_vcal']))
{
//
// Generate the vCalendar
$default_duration=3; // hours
$name=preg_replace('/[^0-9a-zA-Z]/','',get_bloginfo_rss('name'));
header("Content-Type: text/x-vCalendar");
header("Content-Disposition: inline; filename=$name.vcs");
header('Expires: Wed, 11 Jan 1984 05:00:00 GMT');
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header('Cache-Control: no-cache, must-revalidate, max-age=0');
header('Pragma: no-cache');
echo "BEGIN:VCALENDAR\r\n";
echo "VERSION:1.0\r\n";
global $ec3,$tableposts,$tablepost2cat,$tableusers,$wpdb;
$calendar_entries = $wpdb->get_results(
"SELECT
p.id as id,
post_title,
post_excerpt,
DATE_FORMAT(post_date_gmt,'%Y%m%dT%H%i%sZ') as dt_start,
user_nickname
FROM $tableposts p, $tablepost2cat p2c
LEFT JOIN $tableusers u
ON u.ID=p.post_author
WHERE post_status = 'publish'
AND p.id = post_id
AND category_id = $ec3->event_category"
);
foreach($calendar_entries as $entry)
{
global $id;
$id=$entry->id;
$meta=get_post_custom($entry->id);
$duration=$default_duration;
if(is_array($meta) && array_key_exists('duration',$meta))
{
$values=$meta['duration'];
if(count($values))
$duration=end($values);
}
echo "BEGIN:VEVENT\r\n";
echo "SUMMARY:$entry->post_title\r\n";
echo "URL;VALUE=URI:". get_permalink($entry->id) . "\r\n";
if(strlen($entry->post_excerpt)>0)
{
// I can't get iCal to understand vCalendar encoding.
// So just strip out newlines here:
echo "DESCRIPTION:"
. preg_replace('/[\r\n]+/',' ',$entry->post_excerpt) . "\r\n";
}
if($duration)
{
echo "DURATION:PT$duration"."H\r\n";
}
echo "DTSTART:$entry->dt_start\r\n";
echo "DTEND:$entry->dt_start\r\n";
echo "END:VEVENT\r\n";
}
echo "END:VCALENDAR\r\n";
exit(0);
}
// else...
return $wpvarstoreset;
}
//
// Hook in...
add_action('wp_head', 'ec3_action_wp_head');
add_action('admin_menu', 'ec3_action_admin_menu');
add_filter('posts_where', 'ec3_filter_where',11);
add_filter('query_vars', 'ec3_filter_query_vars_xml');
add_filter('query_vars', 'ec3_filter_query_vars_vcal');
if($ec3->advanced)
add_filter('posts_orderby','ec3_filter_posts_orderby');
?>
![spinner]("
. $ec3->relbase . "/wp-content/plugins/eventcalendar3/wait.gif)