corp_html/inc/newsletter.php

<?php

$smarty->assign("PHP_SELF",$PHP_SELF);
if (isset($email)) {

        $sql="select count(email) as nr from news_sub where email = '$email'";
        $sth = $dbh->prepare("$sql");
        $sth->execute();
        if ($row=$sth->fetchrow_hash()) {
                if ($row[nr] == 0) {
                        $dbh->dbh_do("insert into news_sub (email) values ('$email')");
                        $what="sub";
                } else {
                        $what="unsub";
                }
                include_once("quoted-printable.inc");
                $smarty->assign(array(
                        "what"=>$what,
                        "email"=>$email
                ));
                iso_sendmail_t($smarty->fetch("newsletter_request.tpl"));
                #print "<pre>".$smarty->fetch("newsletter_request.tpl")."</pre>";

        } else {
                $what="error";
        }

        $smarty->assign(array(
                "what"=>$what,
                "email"=>$email
        ));
}
$smarty->assign("left_box",$smarty->fetch("newsletter.tpl"));

?>
1	<?php
2
3	$smarty->assign("PHP_SELF",$PHP_SELF);
4	if (isset($email)) {
5
6	$sql="select count(email) as nr from news_sub where email = '$email'";
7	$sth = $dbh->prepare("$sql");
8	$sth->execute();
9	if ($row=$sth->fetchrow_hash()) {
10	if ($row[nr] == 0) {
11	$dbh->dbh_do("insert into news_sub (email) values ('$email')");
12	$what="sub";
13	} else {
14	$what="unsub";
15	}
16	include_once("quoted-printable.inc");
17	$smarty->assign(array(
18	"what"=>$what,
19	"email"=>$email
20	));
21	iso_sendmail_t($smarty->fetch("newsletter_request.tpl"));
22	#print "<pre>".$smarty->fetch("newsletter_request.tpl")."</pre>";
23
24	} else {
25	$what="error";
26	}
27
28	$smarty->assign(array(
29	"what"=>$what,
30	"email"=>$email
31	));
32	}
33	$smarty->assign("left_box",$smarty->fetch("newsletter.tpl"));
34
35	?>