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	dpavlin	1.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	dpavlin	1.2	$smarty->assign("left_box",$smarty->fetch("newsletter.tpl"));
34	dpavlin	1.1
35			?>