scout24 
geschrieben 24. April 2005 - 11:31
Floele
geschrieben 24. April 2005 - 13:27
scout24
geschrieben 24. April 2005 - 13:37
Floele
geschrieben 24. April 2005 - 13:51
Hilfe
Neues Thema
Antworten
Nach oben
<?php
require_once('sql_class.inc.php');
$out = '';
$text[1] = 'Thank you for subscribing to the *** Newsletter. You will be informed as soon as something happens.
Please open the URL below to confirm your subscription. If you do not confirm, you will not get our newsletter.
Confirmation link:
http://wwwyourdomain.com/newsletter.php?confirm=';
$text[2] = '
Regards,
**** Team';
if(isset($_GET['confirm']))
{
$confirm = sql::safe($_GET['confirm']);
$sql->ex('UPDATE newsletter SET validated=1 WHERE mailkey=\''.$confirm.'\'');
if(mysql_affected_rows() > 0)
$out = 'Confirmation successfull!';
else $out = 'Confirmation failed!';
}
if(isset($_POST['action']))
{
$email = $_POST['email'];
if(sql::check_mail($email))
{
if($_POST['action']=='subscribe')
{
$mailkey = md5(rand().$email);
if($sql->ex('INSERT INTO newsletter (address,validated,mailkey) VALUES (\''.$email.'\',0,\''.$mailkey.'\')'))
{
$out = 'Subscription successful!';
mail($email,'Newsletter Confirmation',$text[1].$mailkey.$text[2],'FROM: [email protected]');
}
else
$out = 'E-Mail address already exists!';
}
else
{
$sql->ex('DELETE FROM newsletter WHERE address=\''.$email.'\'');
if(mysql_affected_rows() > 0)
$out = 'You have been removed from our mailing list!';
else $out = 'Your email address did not exist in our database.';
}
}
else $out = 'You entered an invalid email address!';
}
?>
<h3 class="box">Subscribe/Unsubscribe Newsletter</h3>
<p>By subscribing our newsletter, you will always be notified as soon as something happens.<br />
Your email address will not be exposed to third parties.
</p>
<form method="post" action="">
<div>
<label for="email">E-mail address:</label> <input id="email" type="text" name="email" />
<select name="action">
<option value="subscribe">Subscribe</option>
<option value="unsubscribe">Unsubscribe</option>
</select>
<input type="submit" value="Go!" />
</div>
</form>
CREATE TABLE `newsletter` ( `mailid` bigint(20) NOT NULL auto_increment, `address` varchar(255) NOT NULL default '', `validated` int(11) NOT NULL default '0', `mailkey` varchar(255) NOT NULL default '', `mailed` int(11) NOT NULL default '0', PRIMARY KEY (`mailid`) ) TYPE=MyISAM;
scout24
geschrieben 24. April 2005 - 14:00
