phpBB.de

Code: Alles auswählen

		$sql_auth_id = "SELECT g.group_id FROM " . GROUPS_TABLE . " g, " . USER_GROUP_TABLE . " ug
					WHERE g.group_id = $meeting_group
					AND g.group_id = ug.group_id
					AND ug.user_pending <> " . TRUE . "
					AND g.group_single_user <> " . TRUE . "
					AND ug.user_id = " . $userdata['user_id'];
			if ( !$result_auth_id = $db->sql_query($sql_auth_id) )
			{
				message_die(GENERAL_ERROR, 'Could not get meeting access data', '', __LINE__, __FILE__, $sql_auth_id);

Code: Alles auswählen

#
#-----[ OPEN ]------------------------------------------
#
includes/page_header.php

#
#-----[ FIND ]------------------------------------------
#
//
// Parse and show the overall header.
//

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// START Meeting Mod
if ( $gen_meeting_header !== FALSE )
{
	// Get access status for all meetings
	$sql = "SELECT m.meeting_id, mg.meeting_group FROM " . MEETING_DATA_TABLE . " m, " . MEETING_USERGROUP_TABLE . " mg
		WHERE mg.meeting_id = m.meeting_id";
	if ( !$result = $db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, 'Could not get meeting usergroups', '', __LINE__, __FILE__, $sql);
	}

	$meetings_access_ids = array();

	while ( $row = $db->sql_fetchrow($result) )
	{
		$meeting_id = $row['meeting_id'];
		$meeting_group = $row['meeting_group'];

		if ( $meeting_group == -1 )
		{
			$meetings_access_ids[] = $meeting_id;
		}
		else
		{
			$sql_auth_id = "SELECT g.group_id FROM " . GROUPS_TABLE . " g, " . USER_GROUP_TABLE . " ug
					WHERE g.group_id = $meeting_group
					AND g.group_id = ug.group_id
					AND ug.user_pending <> " . TRUE . "
					AND g.group_single_user <> " . TRUE . "
					AND ug.user_id = " . $userdata['user_id'];
			if ( !$result_auth_id = $db->sql_query($sql_auth_id) )
			{
				message_die(GENERAL_ERROR, 'Could not get meeting access data', '', __LINE__, __FILE__, $sql_auth_id);
			}

			$count_usergroups = $db->sql_numrows($result_auth_id);
			$db->sql_freeresult($result_auth_id);

			if ( $count_usergroups > 0 )
			{
				$meetings_access_ids[] = $meeting_id;
			}
		}
	}

	$db->sql_freeresult($result);

	include($phpbb_root_path.'language/lang_'.$board_config['default_lang'].'/lang_meeting.'.$phpEx);

	if ( count($meetings_access_ids) > 0 )
	{
		$meeting_ids = ( count($meetings_access_ids) == 1 ) ? $meetings_access_ids[0] : implode(',', $meetings_access_ids);
		$sql_meeting_access = ' WHERE meeting_id IN ('.$meeting_ids.') AND meeting_time > '.time();
	}
	else if ($userdata['user_level'] == ADMIN)
	{
		$sql_meeting_access = ' WHERE meeting_time > '.time();
	}
	else
	{
		$sql_meeting_access = '';
	}

	if ($sql_meeting_access != '')
	{
		$sql = "SELECT count(meeting_id) as total_meetings FROM " . MEETING_DATA_TABLE . "
			$sql_meeting_access";
		if ( !$result = $db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, 'Could not get meeting data', '', __LINE__, __FILE__, $sql);
		}

		while ( $row = $db->sql_fetchrow($result) )
		{
			$meeting_active_ids = $row['total_meetings'];
		}

		$db->sql_freeresult($result);
	}
	else
	{
		$meeting_active_ids = 0;
	}

	if ( $meeting_active_ids == 0 )
	{
		$meeting_active_string = $lang['No_active_meetings'];
	}
	else if ( $meeting_active_ids == 1 )
	{
		$meeting_active_string = $lang['One_active_meeting'];
	}
	else
	{
		$meeting_active_string = sprintf($lang['Active_meetings'], $meeting_active_ids);
	}

	$meeting_link = '<a href="'.append_sid("meeting.$phpEx").'" class="mainmenu">'.$meeting_active_string.'</a>';

	$template->assign_vars(array(
		'MEETING_LINK' => $meeting_link)
	);
}
// END Meeting Mod