phpBB.de

Code: Alles auswählen

593 // Work around for "current" Apache 2 + PHP module which seems to not
594 // cope with private cache control setting
595 if (!empty($HTTP_SERVER_VARS['SERVER_SOFTWARE']) && strstr($HTTP_SERVER_VARS['SERVER_SOFTWARE'], 'Apache/2'))
596 {
597 	header ('Cache-Control: no-cache, pre-check=0, post-check=0');
598 }
599 else
600 {
601	header ('Cache-Control: private, pre-check=0, post-check=0, max-age=0');
602 }
603 header ('Expires: 0');
604 header ('Pragma: no-cache');
605
606 $template->pparse('overall_header');
607 
608 ?>

Code: Alles auswählen

64 // START Meeting Mod
65 if ( $gen_meeting_header !== FALSE )
66 {
67	// Get access status for all meetings
68	$sql = "SELECT m.meeting_id, mg.meeting_group FROM " . MEETING_DATA_TABLE . " m, " . MEETING_USERGROUP_TABLE . " mg
69		WHERE mg.meeting_id = m.meeting_id";
70	if ( !$result = $db->sql_query($sql) )
71	{
72		message_die(GENERAL_ERROR, 'Could not get meeting usergroups', '', __LINE__, __FILE__, $sql);
73	}
74
75	$meetings_access_ids = array();
76
77	while ( $row = $db->sql_fetchrow($result) )
78	{
79		$meeting_id = $row['meeting_id'];
80		$meeting_group = $row['meeting_group'];
81
82		if ( $meeting_group == -1 )
83		{
84			$meetings_access_ids[] = $meeting_id;
85		}
86		else
87		{
88			$sql_auth_id = "SELECT g.group_id FROM " . GROUPS_TABLE . " g, " . USER_GROUP_TABLE . " ug
89					WHERE g.group_id = $meeting_group
90					AND g.group_id = ug.group_id
91					AND ug.user_pending <> " . TRUE . "
92					AND g.group_single_user <> " . TRUE . "
93					AND ug.user_id = " . $userdata['user_id'];
94			if ( !$result_auth_id = $db->sql_query($sql_auth_id) )
95			{
96				message_die(GENERAL_ERROR, 'Could not get meeting access data', '', __LINE__, __FILE__, $sql_auth_id);
97			}
98
99			$count_usergroups = $db->sql_numrows($result_auth_id);
100			$db->sql_freeresult($result_auth_id);
101
102			if ( $count_usergroups > 0 )
103			{
104				$meetings_access_ids[] = $meeting_id;
105			}
106		}
107	}
108
109	$db->sql_freeresult($result);
110
111	include($phpbb_root_path.'language/lang_'.$board_config['default_lang'].'/lang_meeting.'.$phpEx);
112
113	if ( count($meetings_access_ids) > 0 )
114	{
115		$meeting_ids = ( count($meetings_access_ids) == 1 ) ? $meetings_access_ids[0] : implode(',', $meetings_access_ids);
116		$sql_meeting_access = ' WHERE meeting_id IN ('.$meeting_ids.') AND meeting_time > '.time();
117	}
118	else if ($userdata['user_level'] == ADMIN)
119	{
120		$sql_meeting_access = ' WHERE meeting_time > '.time();
121	}
122	else
123	{
124		$sql_meeting_access = '';
125	}
126
127	if ($sql_meeting_access != '')
128	{
129		$sql = "SELECT count(meeting_id) as total_meetings FROM " . MEETING_DATA_TABLE . "
130			$sql_meeting_access";
131		if ( !$result = $db->sql_query($sql) )
132		{
133			message_die(GENERAL_ERROR, 'Could not get meeting data', '', __LINE__, __FILE__, $sql);
134		}
135
136		while ( $row = $db->sql_fetchrow($result) )
137		{
138			$meeting_active_ids = $row['total_meetings'];
139		}
140
141		$db->sql_freeresult($result);
142	}
143	else
144	{
145		$meeting_active_ids = 0;
146	}
147
148	if ( $meeting_active_ids == 0 )
149	{
150		$meeting_active_string = $lang['No_active_meetings'];
151	}
152	else if ( $meeting_active_ids == 1 )
153	{
154		$meeting_active_string = $lang['One_active_meeting'];
155	}
156	else
157	{
158		$meeting_active_string = sprintf($lang['Active_meetings'], $meeting_active_ids);
159	}
160
161	$meeting_link = '<a href="'.append_sid("meeting.$phpEx").'" class="mainmenu">'.$meeting_active_string.'</a>';
162
163	$template->assign_vars(array(
164		'MEETING_LINK' => $meeting_link)
165	);
166 }
167 // END Meeting Mod

Code: Alles auswählen

while ( $row = $db->sql_fetchrow($result) )
{

Code: Alles auswählen

echo $sql;exit;