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	ravilov	1.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			?>