Code:
portal.php:
Code: Selecteer alles
//
//kalender
//
//
// Events
//
if ($userdata['session_logged_in'])
{
if ($cal_config['number_events'] <> 0)
{
$day = create_date("j", time(), $userdata['user_timezone']);
$month = create_date("m", time(), $userdata['user_timezone']);
$year = create_date("Y", time(), $userdata['user_timezone']);
$sql = "SELECT * FROM ".$table_prefix."calendar WHERE valid = 'yes'
AND eventspan >= '$year-$month-$day 00:00:00'
ORDER BY stamp
LIMIT 0, " . $cal_config['number_events'];
$check = 0;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not select Event data', '', __LINE__, __FILE__, $sql);
}
else
{
while ($row = $db->sql_fetchrow($result))
{
$check++;
$subject = stripslashes($row['subject']);
if ( strlen($subject) > $cal_config['subject_length']) {
if ((substr($subject,-3,1) == '(') && (substr($subject,-1,1) == ')')) {
// store the number of permits and tack them on the end of the shortened subject
$subjectnum = substr($subject,-2,1);
$subject = substr($subject, 0, -3);
}
$subject = substr($subject, 0, $cal_config['subject_length']);
$subject .= '..';
}
$start_date = substr($row['stamp'],8,2).".".substr($row['stamp'],5,2).".".substr($row['stamp'],0,4);
$end_date = substr($row['eventspan'],8,2).".".substr($row['eventspan'],5,2).".".substr($row['eventspan'],0,4);
$month =
$template->assign_block_vars('event', array(
'SUBJECT' => '<a href="'. $phpbb_root_path .'calendar.'.$phpEx.'?id='. $row['id'] .'&mode=display&day='. substr($row['stamp'],8,2). '&month='.substr($row['stamp'],5,2).'&year='.substr($row['stamp'],0,4).'">'. $subject .'</a>',
'SPAN' => $start_date . " - " . $end_date,
'AUTHOR' => '<a href="'. $phpbb_root_path .'profile.'.$phpEx.'?mode=viewprofile&'. POST_USERS_URL .'='. $row['user_id'] .'">('. stripslashes($row['username']) .')</a>'));
}
if ( $check == 0 )
{
$template->assign_block_vars('event', array(
'SUBJECT' => $lang["No_events"]));
}
}
}
if ($cal_config['number_events'] <> 0)
{
$template->assign_block_vars('event_list', array(
'EVENTS' => $lang["Events"]));
}
}
//
//einde kalender
//Code: Selecteer alles
<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
<!-- BEGIN event_list -->
<tr>
<td class="catHead" height="25"><span class="genmed"><b>{event_list.EVENTS}</b></span></td>
</tr>
<!-- END event_list -->
<!-- BEGIN event -->
<tr>
<td class="row1" align="left"><span class="gensmall">{event.SPAN} {event.AUTHOR}<br /><b>{event.SUBJECT}</b></span></td>
</tr>
<!-- END event -->
</table>
<!-- BEGIN event_list -->
<br />
<!-- END event_list -->