phpBB.de

Code: Alles auswählen

$user_allow_mass_email = ( isset( $HTTP_POST_VARS['user_allow_mass_email']) ) ? ( ( $HTTP_POST_VARS['user_allow_mass_email'] ) ? TRUE : 0 ) : 1;

Code: Alles auswählen

//
// Initial selection
//

$sql = "SELECT m.*, u.username, g.group_name
	FROM ".MEGAMAIL_TABLE." m
	LEFT JOIN ". USERS_TABLE." u ON (m.user_id=u.user_id)
	LEFT JOIN ". GROUPS_TABLE." g ON (m.group_id=g.group_id)";

if ( !($result = $db->sql_query($sql)) ) 
{
	message_die(GENERAL_MESSAGE, sprintf('Could not obtain list of email-sessions. If you want to create the table, click <a href=%s>here to install</a>', append_sid('admin_megamail.php?mode=install')), '', __LINE__, __FILE__, $sql);
}

$row_class=0;
if ( $mail_data = $db->sql_fetchrow($result) )
	do
	{
		$url= append_sid("admin_megamail.$phpEx?mail_id=".$mail_data['mail_id']."&mail_session_id=".$mail_data['mailsession_id']);

		$template->assign_block_vars('mail_sessions',array(
			'ROW' => ($row_class % 2) ? 'row2' : 'row1',
			'ID' => $mail_data['mail_id'],
			'GROUP' => ($mail_data['group_id'] != -1) ? $mail_data['group_name'] : $lang['All_users'],
			'SUBJECT' => $mail_data['email_subject'],
			'BATCHSTART' => $mail_data['batch_start'],
			'BATCHSIZE' => $mail_data['batch_size'],
			'BATCHWAIT' => $mail_data['batch_wait'].' sec',
			'EMAIL_INCLUDE_TO' => ( $mail_data['email_include_to'] == '1' ) ? 'Yes' : 'No',
			'EMAIL_FORMAT' => ( $mail_data['email_format'] == '1' ) ? 'HTML' : 'TEXT',
			'SENDER' => $mail_data['username'],
			'STATUS' => ($mail_data['status'] == 0 ) ? sprintf($lang['megamail_proceed'],  '<a href="' . $url . '">', '</a>') : 'Done',
		));
	}
	while( $mail_data = $db->sql_fetchrow($result) );
else
	$template->assign_block_vars('switch_no_sessions',array(
		'EMPTY' => $lang['megamail_none'],
	));



$sql = "SELECT group_id, group_name 
	FROM ".GROUPS_TABLE . "  
	WHERE group_single_user <> 1";

if ( !($result = $db->sql_query($sql)) ) 
{
	message_die(GENERAL_ERROR, 'Could not obtain list of groups', '', __LINE__, __FILE__, $sql);
}

$select_list = '<select name = "' . POST_GROUPS_URL . '"><option value = "-1">' . $lang['All_users'] . '</option>';
if ( $row = $db->sql_fetchrow($result) )
{
	do
	{
		$select_list .= '<option value = "' . $row['group_id'] . '">' . $row['group_name'] . '</option>';
	}
	while ( $row = $db->sql_fetchrow($result) );
}
$select_list .= '</select>';