#SQL
ALTER TABLE '.PREFIX.'users ADD Newsletter TINYINT(1) UNSIGNED NOT NULL;
#OPEN
member.php
#FIND
function editsettings()
#FIND
				EmailNotifyPrivMsg=\''.$Newprofile['EmailNotifyPrivMsg'].'\'
#REPLACE
				EmailNotifyPrivMsg=\''.$Newprofile['EmailNotifyPrivMsg'].'\',
				Newsletter=\''.$Newprofile['Newsletter'].'\'
#FIND
		$ent['EmailNotifyPrivMsg'] = MakeRadioBoxArray('profile[EmailNotifyPrivMsg]',array('1'=>$txt['yes'],'0'=>$txt['no']),$CurrentUser['EmailNotifyPrivMsg']);
#ADDAFTER
		$ent['Newsletter'] = MakeRadioBoxArray('profile[Newsletter]',array('1'=>$txt['yes'],'0'=>$txt['no']),$CurrentUser['Newsletter']);
#FIND
function register()
#FIND
				EmailSubbedTopics,ViewLastXDays,SaveCookie,TimeZone,Bio,Location,LastActive,RegDate,RegIP,TitleID,Birthday)
#REPLACE
				EmailSubbedTopics,ViewLastXDays,SaveCookie,TimeZone,Bio,Location,LastActive,RegDate,RegIP,TitleID,Birthday,
				Newsletter)
#FIND
				\''.$_POST['userinfo']['usertitle'].'\',\''.$_POST['userinfo']['Birthday'].'\')';
#REPLACE
				\''.$_POST['userinfo']['usertitle'].'\',\''.$_POST['userinfo']['Birthday'].'\',
				\''.$_POST['userinfo']['Newsletter'].'\')';
#FIND
		$ent['EmailNotifyPrivMsg'] = MakeRadioBoxArray('userinfo[EmailNotifyPrivMsg]',array(1=>'Yes',0=>'No'),0);
#ADDAFTER
		$ent['Newsletter'] = MakeRadioBoxArray('userinfo[Newsletter]',array(1=>'Yes',0=>'No'),0);
#FIND
}

switch ($action)
#REPLACE
}
function Unsubscribe()
{	global $fSettings,$ent,$txt,$code,$username;
	$sql = new DB_SQL;
	$code = preg_replace("#[^a-z0-9]#is",'',$code);
	$query = 'SELECT UserName,Email,Password FROM '.PREFIX.'users WHERE UserName=\''.$username.'\'';
	$sql->query($query);
	if(!$sql->num_rows())
	{	UhOh($txt['errNewsletterInvalidConfirm']);
	}
	list($name,$email,$password) = $sql->get_numeric();
	if ($code != md5($name.$password.$email))
	{	UhOh($txt['errNewsletterInvalidConfirm']);
	}
	$query = 'UPDATE '.PREFIX.'users SET Newsletter=0 WHERE UserName=\''.$username.'\'';
	$sql->query($query);
	SomeMessage($txt['Newsletter'],$txt['NewsletterUnsubscribed']);
}

switch ($action)
#FIND
	case 'editavatar':
		@require('./includes/avatars.php');
		editavatar();
		break;
#ADDAFTER
	case 'unsubscribe':
		Unsubscribe();
		break;
#OPEN
templates/editsettings.html
#FIND
	<tr valign="top">
		<td width="160" nowrap class="MsgBG1"><!txt_SaveCookie>: </td>
		<td align="left" class="MsgBG1"><!SaveCookie></td>
	</tr>
#ADDAFTER
	<tr valign="top">
		<td width="160" nowrap class="MsgBG1"><!txt_Newsletter>: </td>
		<td align="left" class="MsgBG1"><!Newsletter></td>
	</tr>
#OPEN
admin/index.php
#FIND
	&nbsp;&nbsp;<a href="adminfunctions.php?action=mdelusers" target="mainframe">Mass Delete</a><br>
#ADDAFTER
	&nbsp;&nbsp;<a href="adminfunctions.php?action=massmail" target="mainframe">Send Mass Mail/PM</a><br>
#OPEN
admin/adminfunctions.php
#FIND
		case 'mdelattach':
			@require('./attachments.php');
			MDelAttach();
			break;
#ADDAFTER
		case 'massmail':
			@require('./massmail.php');
			MassMail();
			break;
#CREATE
admin/massmail.php
<?PHP
function MassMail()
{	global $fSettings,$txt,$CurrentUser;
	set_time_limit(600);
	$sql = new DB_SQL;
	$sql2 = new DB_SQL;
	if ($_POST['Submit'] == "Send")
	{	$input = $_POST['input'];
		$Subject = $_POST['Subject'];
		$input['posts2'] = doubleval($input['posts2']);
		$input['postsperday2'] = doubleval($input['postsperday2']);
		$input['daysreg2'] = doubleval($input['daysreg2']);
		$input['daysin2'] = doubleval($input['daysin2']);
		$input['level2'] = doubleval($input['level2']);
		if ($input[type] == "pm")
		{	@require('../includes/pmdefs.php');
			$pmMask = SetBit(SetBit(SetBit(0,$PMPostDefs,'outboxdel'),$PMPostDefs,'emoticon'),$PMPostDefs,'tfcode');
		}
		else
		{	@require('../includes/mail.php');
			$mail = new MAIL_OBJECT;
			$crlf = "\r\n";
			$headers = 'From: '.$input['from'];
			$ent['message'] = stripslashes($input['message']);
			$ent['ForumName'] = $fSettings['ForumName'];
			$ent['ScriptURL'] = $fSettings['ScriptURL'];
			if ($input[type] == "newsletter")
			{	$template = ReadTemplate('mail/massmail','newsletter');
				$addquery = ' AND Newsletter!=0 ';
			}
			else
			{	$message = ParseTemp(ReadTemplate('mail/massmail'),$ent);
			}
		}
		$query = 'SELECT UserID,UserName,Email,Password FROM '.PREFIX.'users 
			WHERE NumPost '.$input[posts].' '.$input[posts2].' 
				AND (NumPost/CEILING((('.time().' - RegDate)/86400))) '.$input[postsperday].' '.$input[postsperday2].'
				AND CEILING((('.time().' - RegDate)/86400)) '.$input[daysreg].' '.$input[daysreg2].'
				AND CEILING((('.time().' - LastActive)/86400)) '.$input[daysin].' '.$input[daysin2].'
				AND GroupID '.$input[level].' '.$input[level2].' '.$addquery;
		$sql->query($query);
		echo 'Sending '.$input[type].' to '.$sql->num_rows().' users:<br>';
		while (list($UserID,$name,$email,$password) = $sql->get_numeric())
		{	echo '<br>'.$name;
			if ($input[type] == "pm")
			{	if ($UserID != $CurrentUser['UserID'])
				{	$query = 'INSERT INTO '.PREFIX.'privmsgs
						(FromUserID,ToUserID,Subject,Message,DateSent,PosticonID,pmMask,FromUserIP) VALUES
						(\''.$CurrentUser['UserID'].'\',\''.$UserID.'\',\''.addslashes($Subject).'\',
							\''.addslashes($input['message']).'\',\''.time().'\',\'1\',
							\''.$pmMask.'\',\''.$_SERVER['REMOTE_ADDR'].'\')';
					$sql2->query($query);
					$pmID = $sql2->insert_id();
					$query = 'UPDATE '.PREFIX.'privmsgs
						SET pmRootID=\''.$pmID.'\'
						WHERE pmID=\''.$pmID.'\'';
					$sql2->query($query);
				}
				else
				{	echo '... skipped: Can\'t PM yourself!';
				}
			}
			elseif ($input[type] == "mail")
			{	$mail->send($name,$email,stripslashes($Subject),$headers,$message);
			}
			elseif ($input[type] == "newsletter")
			{	$ent['code'] = md5($name.$password.$email);
				$ent['name'] = $name;
				$message = ParseTemp($template,$ent);
				$mail->send($name,$email,stripslashes($Subject),$headers,$message);
			}
		}
	}
	else
	{?><html>
<head>
	<title>tForum Administration Area</title>
	<meta http-equiv="Content-Type" content="text/html; charset=<?echo $txt['Charset']?>">
<script language="JavaScript">
<!-- Begin
function GenerateSubject(oldsubject,newtype) {
	if (newtype == "pm")
	{	temp = oldsubject.replace(/Mail/,"PM");
		return(temp.replace(/Newsletter/,"PM"));
	}
	else if (newtype == "mail")
	{	temp = oldsubject.replace(/PM/,"Mail");
		return(temp.replace(/Newsletter/,"Mail"));
	}
	else
	{	temp = oldsubject.replace(/PM/,"Newsletter");
		return(temp.replace(/Mail/,"Newsletter"));
	}
}
// End -->
</script>
</head>
<body>
<form action="adminfunctions.php" method="post" name="messageform">
<table width="100%" border="1" cellspacing="0" cellpadding="5">
	<tr>
		<td colspan=2>
			<b>Message:</b>
		</td>
	</tr>
	<tr>
		<td>Type</td>
		<td>
				<select name="input[type]" ONCHANGE="document.messageform.Subject.value = GenerateSubject(document.messageform.Subject.value,this.value);">
					<option value="mail" selected>e-Mail</option>
					<option value="pm">PM</option>
					<option value="newsletter">Newsletter</option>
				</select>
		</td>
	</tr>
	<tr valign="top">
		<td>From (only if<br>you chose Mail or Newsletter)</td>
		<td>
			<input type="text" name="input[from]" size=68 value="<?echo $CurrentUser[Email]?>">
		</td>
	</tr>
	<tr>
		<td>Subject</td>
		<td>
			<input type="text" name="Subject" size=68 value="Mail to all users of <?echo $fSettings[ForumName]?>">
		</td>
	</tr>
	<tr>
		<td>Message</td>
		<td>
			<textarea cols=58 rows=20 wrap=virtual name="input[message]"></textarea>
		</td>
	</tr>
	<tr>
		<td colspan=2>
			<b>Send to all users with:</b> (Settings are connected with &quot;AND&quot;; Use &quot;more&quot; and &quot;-1&quot; for all users.)
		</td>
	</tr>
	<tr>
		<td>Total Posts</td>
		<td>
				<select name="input[posts]">
					<option value=">" selected>More than</option>
					<option value="<">Less than</option>
					<option value="=">Equal to</option>
				</select>
				<input type=text name="input[posts2]" value="-1">
		</td>
	</tr>
	<tr>
		<td>Posts Per Day</td>
		<td>
				<select name="input[postsperday]">
					<option value=">" selected>More than</option>
					<option value="<">Less than</option>
					<option value="=">Equal to</option>
				</select>
				<input type=text name="input[postsperday2]" value="-1">
		</td>
	</tr>
	<tr>
		<td>Days Registered</td>
		<td>
				<select name="input[daysreg]">
					<option value=">" selected>More than</option>
					<option value="<">Less than</option>
					<option value="=">Equal to</option>
				</select>
				<input type=text name="input[daysreg2]" value="-1">
		</td>
	</tr>
	<tr>
		<td>Days Inactive</td>
		<td>
				<select name="input[daysin]">
					<option value=">" selected>More than</option>
					<option value="<">Less than</option>
					<option value="=">Equal to</option>
				</select>
				<input type=text name="input[daysin2]" value="-1">
		</td>
	</tr>
	<tr>
		<td>User Level</td>
		<td>
				<select name="input[level]">
					<option value=">" selected>More than</option>
					<option value="<">Less than</option>
					<option value="=">Equal to</option>
				</select>
				<input type=text name="input[level2]" value="-1"><br>
				Remember that admin is the lowest user level (1) and banned user the highest (5). And if you defined your own levels they are perhaps even bigger.
		</td>
	</tr>
	<tr>
		<td>&nbsp;</td>
		<td>
			<input type="hidden" name="action" value="massmail">
			<input type="submit" name="Submit" value="Send">
			<input type="reset" name="Reset" value="Reset">
		</td>
	</tr>
</table></form>
</body></html>
<?	}
}
?>
#CREATE
templates/mail/massmail.html
<!message>

<!~newsletter>

<!txt_NewsletterUnsubscribeLink1> <!ForumName> <!txt_NewsletterUnsubscribeLink2> <!ScriptURL>/member.php?action=unsubscribe&username=<!name>&code=<!code>
#OPEN
language/text.php
#ADD
$txt['Newsletter'] = 'Newsletter';
$txt['errNewsletterInvalidConfirm'] = 'Invalid Username/Confirmation Code!';
$txt['NewsletterUnsubscribed'] = 'You have been unsubscribed from the Newsletter.';
$txt['NewsletterUnsubscribeLink1'] = 'To Unsubscribe from the';
$txt['NewsletterUnsubscribeLink2'] = 'Newsletter go to';
#END