health_html/inc/pgPrijava-zaboravio.php

<?php
        $error = "";
        if ($posalji) {
                include("inc/conn.php");
                $sql = "SELECT email FROM users WHERE (username = '$username')";
                $sth = $dbh->prepare($sql);
                if (!$sth) error("Cannot prepare query: \"$sql\"");
                if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
                $email = $sth->fetchrow_array();
                $sth->finish();
                if ($email) $email = array_shift($email);
                if (!$email) $error = "Nepoznato korisnièko ime.";
                if (!$error) {
                        $pass = GeneratePassword();
                        $sql = "UPDATE users SET password = '".md5($pass)."' WHERE (username = '$username')";
                        $dbh->dbh_do($sql);
                        $error = mail($email, "PLIVAmed.net - Registracija", "\nNova lozinka: $pass\n", "From: registracija@plivamed.net") ? "" : "Gre¹ka prilikom slanja e-mail poruke.";
                }
        }
        $tpl->assign("username", $username);
        $tpl->assign("error", $error);
        $tpl->assign("done", $error ? false : true);
?>
1	<?php
2	$error = "";
3	if ($posalji) {
4	include("inc/conn.php");
5	$sql = "SELECT email FROM users WHERE (username = '$username')";
6	$sth = $dbh->prepare($sql);
7	if (!$sth) error("Cannot prepare query: \"$sql\"");
8	if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
9	$email = $sth->fetchrow_array();
10	$sth->finish();
11	if ($email) $email = array_shift($email);
12	if (!$email) $error = "Nepoznato korisnièko ime.";
13	if (!$error) {
14	$pass = GeneratePassword();
15	$sql = "UPDATE users SET password = '".md5($pass)."' WHERE (username = '$username')";
16	$dbh->dbh_do($sql);
17	$error = mail($email, "PLIVAmed.net - Registracija", "\nNova lozinka: $pass\n", "From: registracija@plivamed.net") ? "" : "Gre¹ka prilikom slanja e-mail poruke.";
18	}
19	}
20	$tpl->assign("username", $username);
21	$tpl->assign("error", $error);
22	$tpl->assign("done", $error ? false : true);
23	?>