$calsql_tbl = $_TABLES['personal_eventsjp'];
$calsql_filt = "AND (uid = {$_USER['uid']})";
} else {
$calsql_tbl = $_TABLES['eventsjp'];
$calsql_filt = COM_getPermSql('AND');
}
$calsql = "SELECT eid,title,datestart,dateend,timestart,timeend,allday,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon FROM {$calsql_tbl} WHERE " . "((datestart >= '{$year}-{$month}-{$curday->daynumber} 00:00:00' " . "AND datestart <= '{$year}-{$month}-{$curday->daynumber} 23:59:59') " . "OR (dateend >= '{$year}-{$month}-{$curday->daynumber} 00:00:00' " . "AND dateend <= '{$year}-{$month}-{$curday->daynumber} 23:59:59') " . "OR ('{$year}-{$month}-{$curday->daynumber}' BETWEEN datestart AND dateend))" . $calsql_filt . " ORDER BY datestart,timestart";
$query2 = DB_query($calsql);
$q2_numrows = DB_numRows($query2);
if ($q2_numrows > 0) {
$entries = '';
for ($z = 1; $z <= $q2_numrows; $z++) {
$results = DB_fetchArray($query2);
if ($results['title']) {
$cal_templates->set_var('cal_day_entries', '');
$entries .= COM_createLink(stripslashes($results['title']), $_CONF['site_url'] . '/calendarjp/event.php?' . addMode($mode) . 'eid=' . $results['eid'], array('class' => 'cal-event')) . '<hr' . XHTML . '>';
}
}
for ($z = $z; $z <= 4; $z++) {
$entries .= '<br' . XHTML . '>';
}
$cal_templates->set_var('event_anchortags', $entries);
} else {
if ($q2_numrows < 4) {
for ($t = 0; $t < 4 - $q2_numrows; $t++) {
$cal_templates->set_var('cal_day_entries', '<br' . XHTML . '><br' . XHTML . '><br' . XHTML . '><br' . XHTML . '>');
}
}
}
$cal_templates->parse('cal_day_entries', 'event', true);
$cal_templates->set_var('event_anchortags', '');
$calsql_tbl = $_TABLES['personal_events'];
$calsql_filt = "AND (uid = {$_USER['uid']})";
} else {
$calsql_tbl = $_TABLES['events'];
$calsql_filt = COM_getPermSql('AND');
}
$calsql = "SELECT eid,title,datestart,dateend,timestart,timeend,allday,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon FROM {$calsql_tbl} WHERE " . "(status = 1) " . "AND ((datestart >= \"{$year}-{$month}-{$curday->daynumber} 00:00:00\" " . "AND datestart <= \"{$year}-{$month}-{$curday->daynumber} 23:59:59\") " . "OR (dateend >= \"{$year}-{$month}-{$curday->daynumber} 00:00:00\" " . "AND dateend <= \"{$year}-{$month}-{$curday->daynumber} 23:59:59\") " . "OR (\"{$year}-{$month}-{$curday->daynumber}\" BETWEEN datestart AND dateend))" . $calsql_filt . " ORDER BY datestart,timestart";
$query2 = DB_query($calsql);
$q2_numrows = DB_numRows($query2);
if ($q2_numrows > 0) {
$entries = '';
for ($z = 1; $z <= $q2_numrows; $z++) {
$results = DB_fetchArray($query2);
if ($results['title']) {
$cal_templates->set_var('cal_day_entries', '');
$entries .= COM_createLink($results['title'], $_CONF['site_url'] . '/calendar/event.php?' . addMode($mode) . 'eid=' . $results['eid'], array('class' => 'cal-event', 'rel' => 'nofollow')) . '<div style="margin:5px 0 5px;border-bottom:1px solid #bbbbbb"></div>';
}
}
for ($z = $z; $z <= 4; $z++) {
$entries .= '<br/>';
}
$cal_templates->set_var('event_anchortags', $entries);
} else {
if ($q2_numrows < 4) {
for ($t = 0; $t < 4 - $q2_numrows; $t++) {
$cal_templates->set_var('cal_day_entries', '<br/><br/><br/><br/>');
}
}
}
$cal_templates->parse('cal_day_entries', 'event', true);
$cal_templates->set_var('event_anchortags', '');
