Seite 1 von 1

Calite Events - Portal

Verfasst: 26.04.2007 23:32
von phillip
Hallo
Ich würde gerne den Teil, der normalerweise in die portal.php käme, in den page_header versetzen, da die events auf jeder seite geladen werden (müssen)

Ich habe das also gemacht, aber bei jedem Login kam dieses

Code: Alles auswählen

message_die() was called multiple times.
Zeugs.

Also habe ich mir den
Fix message_die for multiple errors Mod
(hier)
reingehauen.

Er zeigte mir demnach folgende Meldung:

Code: Alles auswählen

Critical Error!
message_die() was called multiple times.
 
Error #1 
Du hast Dich erfolgreich eingeloggt.

Klicke hier um zur letzten Seite zurückzukehren. 

 
Error #2 
Could not select event data 

Line : 116
File : /home/httpd/vhosts/myqube.ch/httpdocs/includes/page_header.php 
SQL : SELECT * FROM calendar WHERE valid = 'yes' AND eventspan >= '2007-04-26 00:00:00' AND stamp <= '2007-05-6 23:59:59' ORDER BY stamp 

Demnach stimmt etwas an diesem Ausschnitt, der in die page_header eingefügt werden muss etwas nicht...

Kann mir jemand helfen, bzw. für die page_header anpassen?

Vielen Dank.

Hier der Ausschnitt:

Code: Alles auswählen

//
// Events
//
include_once($phpbb_root_path . 'cal_lite_settings.php');
include_once($phpbb_root_path . 'cal_lite_functions.php');

$cal_config = array();

$sql = "SELECT * FROM ". CAL_CONFIG;
if(!$result = $db->sql_query($sql))
{
	message_die(GENERAL_ERROR, "Couldn't query calendar config table", "", __LINE__, __FILE__, $sql);
}
else
{
	while( $row = $db->sql_fetchrow($result) )
	{
		$cal_config[$row['config_name']] = $row['config_value'];
	}
}

if ($cal_config['number_events'] <> 0)
{
	$day = create_date("d", time(), $userdata['user_timezone']);
	$month = create_date("m", time(), $userdata['user_timezone']);
	$year = create_date("Y", time(), $userdata['user_timezone']);

	if ($cal_config['day_number'] == 0)
	{
		$sql_limit = ' LIMIT 0, ' . $cal_config['number_events'];
		$event_span_date = '';
		$sql_span = '';
	}
	else
	{
		$sql_limit = '';
		$cal_days = $cal_config['number_events'];
		$event_span_date = strtotime("$year-$month-$day 23:59:59 + $cal_days days"); 
		$event_span_date = create_date("Y", $event_span_date, $userdata['user_timezone']).'-'.create_date("m", $event_span_date, $userdata['user_timezone']).'-'.create_date("j", $event_span_date, $userdata['user_timezone']).' 23:59:59'; 
		$sql_span = " AND stamp <= '$event_span_date'";
	}

	$sql = "SELECT * FROM ".$table_prefix."calendar WHERE valid = 'yes'
			AND eventspan >= '$year-$month-$day 00:00:00'
			$sql_span
			ORDER BY stamp" . $sql_limit;

	$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']);

			$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);

			if ( $start_date == $end_date )
			{
				$span = $start_date;
			}
			else
			{
				$span = $start_date . " - " . $end_date;
			}
			$subject = ( $userdata['session_logged_in'] ) ? '<a href="'. append_sid('calendar.'.$phpEx.'?id='. $row['id'] .'&mode=display&cl_d='. substr($row['stamp'],8,2). '&cl_m='.substr($row['stamp'],5,2).'&cl_y='.substr($row['stamp'],0,4)).'">'. $subject .'</a>' : $subject;
			$author = ( $userdata['session_logged_in'] ) ? '<a href="'. append_sid('profile.'.$phpEx.'?mode=viewprofile&'. POST_USERS_URL .'='. $row['user_id']) .'">('. stripslashes($row['username']) .')</a>' : '('. stripslashes($row['username']) .')';
			$template->assign_block_vars('event', array(
				'SUBJECT' => $subject,
				'SPAN' => $span,
				'AUTHOR' => $author));
		}
		if ( $check == 0 )
		{
		   $template->assign_block_vars('event', array(
			'SUBJECT' => $lang["No_events"]));
		}
	}
}

if ($cal_config['number_events'] <> 0 && $cal_config['view_new_events'] == 1)
{
	$template->assign_block_vars('event_list', array(
	'EVENTS' => '<a href="'. $phpbb_root_path .'calendar.'.$phpEx.'?mode=View_New">'. $lang["Events"] .'</a>'));
}
else if ($cal_config['number_events'] <> 0)
{
	$template->assign_block_vars('event_list', array(
	'EVENTS' => $lang['Events']));
}