
<!sql if $mode == "Edit">

<html>
<head>
<title>ECE 4512: Project Proposal Database</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<style type="text/css">
<!--
a {  text-decoration: underline}
table {  background-color: #FFFFFF}
a:active {  text-decoration: none}
a:hover {  text-decoration: none}
a:visited {  #6699CC}
td {  font-size: 12pt; font-family: Verdana, Arial, Helvetica, sans-serif}
h3 {  font-size: 14pt; font-weight: bold; color: #336699}
h4 {  font-size: 12pt; color: #6699CC}
input { background-color: #FFFFFF}
-->
</style>
</head>

<body link=#336699 alink=#6699CC vlink=#6699CC bgcolor="#336699" text="black" background="./images/bg.jpg">
<center>
<form action="./password.sql" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td valign="top"><img src="./images/top_left.gif" width="12" height="12" align="left" vspace="0" hspace="0"></td>
    <td valign="middle"> 
<img src="./images/line_1000.gif" width="630" height="1" border=0><br>
      <div align="right">
<img src="./images/ece.jpg" width="190" height="30" align="right">
      </div>
	  <div align="left">
<img src="./images/title.jpg" width="350" height="55" align="absmiddle">
	 </div>
    </td>
    <td valign="top"><img src="./images/top_right.gif" width="12" height="12" align="right" vspace="0" hspace="0"></td>
  </tr>
<tr>
<td rowspan="3">&nbsp;</td>
<td rowspan="3">
<div align="center">
<br><h3>Change Proposal Password</h3><br>
</div>
<div align="left">
Please enter the proposal number.<br>
<table border=0>
<tr><td>Proposal #:</td><td><input type="text" length="4" name="viewnum"></td></tr>
<tr><td>Old Password:</td><td><input type="password" name="old"></td></tr>
<tr><td>New Password:</td><td><input type="password" name="password"></td></tr>
<tr><td>Verify New Password:</td><td><input type="password" name="verify"></td></tr>
</table>
</div>
</td>
<td rowspan="3">&nbsp;</td>
</tr>
  <tr> </tr>
  <tr> </tr>

<tr>
<td valign="bottom"><img src="./images/bot_left.gif" width="12" height="12" align="left" vspace="0" hspace="0"></td>
<td>
<div align="center">
	<input type="submit" name="mode" value="Submit">
</form>
</div>
<div align="center">
          <a href="./input.sql?mode=Add&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/add_proposal.jpg" alt="Add A Proposal" border=0></a>
<a href="./input.sql?mode=Update&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/update_proposal.jpg" alt="Update Proposal" border=0></a>
<a href="./input.sql?mode=Delete&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/delete_proposal.jpg" alt="Delete Proposal" border=0></a>
<a href="./display.sql?mode=View&viewnum=ALL"><img src="./images/view_all.jpg" alt="View All Proposals" border=0></a>
<a href="./index.html"><img src="./images/home.jpg" alt="Return Home" border=0></a>

</div>
</td>
    <td valign="bottom"><img src="./images/bot_right.gif" width="11" height="12" align="right" vspace="0" hspace="0"></td>
  </tr>
</table>
</center>
</body>
</html>

<!sql endif>

<!sql if $mode == "Submit">

<!sql connect localhost www DataBase>
<!sql database ece_4512_ppd>

<!sql if $viewnum != "">

<!sql query "select pWord from p?viewnum" q0>

<!sql query "select password('?old') and pWord" q1>

<!sql if @q0.pWord == @q1.pWord>

<!sql if $password == $verify>

<!sql query "update p?viewnum set pWord = password('?password')">

<html>
<head>
<title>ECE 4512: Project Proposal Database</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<style type="text/css">
<!--
a {  text-decoration: underline}
table {  background-color: #FFFFFF}
a:active {  text-decoration: none}
a:hover {  text-decoration: none}
a:visited {  #6699CC}
td {  font-size: 12pt; font-family: Verdana, Arial, Helvetica, sans-serif}
h3 {  font-size: 14pt; font-weight: bold; color: #336699}
h4 {  font-size: 12pt; color: #6699CC}
input { background-color: #FFFFFF}
-->
</style>
</head>

<body link=#336699 alink=#6699CC vlink=#6699CC bgcolor="#336699" text="black" background="./images/bg.jpg">
<center>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td valign="top"><img src="./images/top_left.gif" width="12" height="12" align="left" vspace="0" hspace="0"></td>
     <td valign="middle"> 
<img src="./images/line_1000.gif" width="630" height="1" border=0><br>
      <div align="right">
<img src="./images/ece.jpg" width="190" height="30" align="right">
      </div>
	  <div align="left">
<img src="./images/title.jpg" width="350" height="55" align="absmiddle">
	 </div>
    </td>
    <td valign="top"><img src="./images/top_right.gif" width="12" height="12" align="right" vspace="0" hspace="0"></td>
  </tr>
<tr>
<td rowspan="3">&nbsp;</td>
<td rowspan="3"><div align="center">
<br><h3>Change Proposal Password</h3><br>
The password for Proposal #<!sql print $viewnum><br>
has been changed to <b><!sql print $password></b>.<br><br>
</div>
</td>
<td rowspan="3">&nbsp;</td>
</tr>
  <tr> </tr>
  <tr> </tr>

<tr>
<td valign="bottom"><img src="./images/bot_left.gif" width="12" height="12" align="left" vspace="0" hspace="0"></td>
<td>

<div align="center">
          <a href="./input.sql?mode=Add&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/add_proposal.jpg" alt="Add A Proposal" border=0></a>
<a href="./input.sql?mode=Update&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/update_proposal.jpg" alt="Update Proposal" border=0></a>
<a href="./input.sql?mode=Delete&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/delete_proposal.jpg" alt="Delete Proposal" border=0></a>
<a href="./display.sql?mode=View&viewnum=ALL"><img src="./images/view_all.jpg" alt="View All Proposals" border=0></a>
<a href="./index.html"><img src="./images/home.jpg" alt="Return Home" border=0></a>

</div>
</td>
    <td valign="bottom"><img src="./images/bot_right.gif" width="11" height="12" align="right" vspace="0" hspace="0"></td>
  </tr>
</table>
</center>
</body>
</html>

<!sql close>

<!sql endif>

<!sql if $password != $verify>

<html>
<head>
<title>ECE 4512: Project Proposal Database</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<style type="text/css">
<!--
a {  text-decoration: underline}
table {  background-color: #FFFFFF}
a:active {  text-decoration: none}
a:hover {  text-decoration: none}
a:visited {  #6699CC}
td {  font-size: 12pt; font-family: Verdana, Arial, Helvetica, sans-serif}
h3 {  font-size: 14pt; font-weight: bold; color: #336699}
h4 {  font-size: 12pt; color: #6699CC}
input { background-color: #FFFFFF}
-->
</style>
</head>

<body link=#336699 alink=#6699CC vlink=#6699CC bgcolor="#336699" text="black" background="./images/bg.jpg">
<center>
<form action="./password.sql" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td valign="top"><img src="./images/top_left.gif" width="12" height="12" align="left" vspace="0" hspace="0"></td>
    <td valign="middle"> 
<img src="./images/line_1000.gif" width="630" height="1" border=0><br>
      <div align="right">
<img src="./images/ece.jpg" width="190" height="30" align="right">
      </div>
	  <div align="left">
<img src="./images/title.jpg" width="350" height="55" align="absmiddle">
	 </div>
    </td>
    <td valign="top"><img src="./images/top_right.gif" width="12" height="12" align="right" vspace="0" hspace="0"></td>
  </tr>
<tr>
<td rowspan="3">&nbsp;</td>
<td rowspan="3">
<div align="center">
<br><h3>Change Proposal Password</h3><br>
</div>
<div align="left">
<h4>New password not verified.  Please try again.</h4>
Please enter the proposal number.<br>
Proposal#: <input type="text" length="4" name="viewnum">
<br>
Old Password:<input type="password" name="old"><br>
New Password: <input type="password" name="password"><br>
Verify New Password: <input type="password" name="verify"><br>
</div>
</td>
<td rowspan="3">&nbsp;</td>
</tr>
  <tr> </tr>
  <tr> </tr>

<tr>
<td valign="bottom"><img src="./images/bot_left.gif" width="12" height="12" align="left" vspace="0" hspace="0"></td>
<td>
<div align="center">
	<input type="submit" name="mode" value="Submit">
</form>
</div>
<div align="center">
          <a href="./input.sql?mode=Add&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/add_proposal.jpg" alt="Add A Proposal" border=0></a>
<a href="./input.sql?mode=Update&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/update_proposal.jpg" alt="Update Proposal" border=0></a>
<a href="./input.sql?mode=Delete&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/delete_proposal.jpg" alt="Delete Proposal" border=0></a>
<a href="./display.sql?mode=View&viewnum=ALL"><img src="./images/view_all.jpg" alt="View All Proposals" border=0></a>
<a href="./index.html"><img src="./images/home.jpg" alt="Return Home" border=0></a>

</div>
</td>
    <td valign="bottom"><img src="./images/bot_right.gif" width="11" height="12" align="right" vspace="0" hspace="0"></td>
  </tr>
</table>
</center>
</body>
</html>

<!sql endif>

<!sql endif>

<!sql if @q0.pWord != @q1.pWord>
<html>
<head>
<title>ECE 4512: Project Proposal Database</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<style type="text/css">
<!--
a {  text-decoration: underline}
table {  background-color: #FFFFFF}
a:active {  text-decoration: none}
a:hover {  text-decoration: none}
a:visited {  #6699CC}
td {  font-size: 12pt; font-family: Verdana, Arial, Helvetica, sans-serif}
h3 {  font-size: 14pt; font-weight: bold; color: #336699}
h4 {  font-size: 12pt; color: #6699CC}
input { background-color: #FFFFFF}
-->
</style>
</head>

<body link=#336699 alink=#6699CC vlink=#6699CC bgcolor="#336699" text="black" background="./images/bg.jpg">
<center>
<form action="./password.sql" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td valign="top"><img src="./images/top_left.gif" width="12" height="12" align="left" vspace="0" hspace="0"></td>
    <td valign="middle"> 
<img src="./images/line_1000.gif" width="630" height="1" border=0><br>
      <div align="right">
<img src="images/ece.jpg" width="190" height="30" align="right">
      </div>
	  <div align="left">
<img src="images/title.jpg" width="350" height="55" align="absmiddle">
	 </div>
    </td>
    <td valign="top"><img src="./images/top_right.gif" width="12" height="12" align="right" vspace="0" hspace="0"></td>
  </tr>
<tr>
<td rowspan="3">&nbsp;</td>
<td rowspan="3">
<div align="center">
<br><h3>Change Proposal Password</h3><br>
</div>
<div align="left">
<h4>Old password incorrect.  Please try again.</h4>
Please enter the proposal number.<br>
Proposal#: <input type="text" length="4" name="viewnum">
<br>
Old Password:<input type="password" name="old"><br>
New Password: <input type="password" name="password"><br>
Verify New Password: <input type="password" name="verify"><br>
</div>
</td>
<td rowspan="3">&nbsp;</td>
</tr>
  <tr> </tr>
  <tr> </tr>

<tr>
<td valign="bottom"><img src="./images/bot_left.gif" width="12" height="12" align="left" vspace="0" hspace="0"></td>
<td>
<div align="center">
	<input type="submit" name="mode" value="Submit">
</form>
</div>
<div align="center">
          <a href="./input.sql?mode=Add&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/add_proposal.jpg" alt="Add A Proposal" border=0></a>
<a href="./input.sql?mode=Update&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/update_proposal.jpg" alt="Update Proposal" border=0></a>
<a href="./input.sql?mode=Delete&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/delete_proposal.jpg" alt="Delete Proposal" border=0></a>
<a href="./display.sql?mode=View&viewnum=ALL"><img src="./images/view_all.jpg" alt="View All Proposals" border=0></a>
<a href="./index.html"><img src="./images/home.jpg" alt="Return Home" border=0></a>

</div>
</td>
    <td valign="bottom"><img src="./images/bot_right.gif" width="11" height="12" align="right" vspace="0" hspace="0"></td>
  </tr>
</table>
</center>
</body>
</html>

<!sql endif>

<!sql endif>

<!sql if $viewnum == "">
<html>
<head>
<title>ECE 4512: Project Proposal Database</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<style type="text/css">
<!--
a {  text-decoration: underline}
table {  background-color: #FFFFFF}
a:active {  text-decoration: none}
a:hover {  text-decoration: none}
a:visited {  #6699CC}
td {  font-size: 12pt; font-family: Verdana, Arial, Helvetica, sans-serif}
h3 {  font-size: 14pt; font-weight: bold; color: #336699}
h4 {  font-size: 12pt; color: #6699CC}
input { background-color: #FFFFFF}
-->
</style>
</head>

<body link=#336699 alink=#6699CC vlink=#6699CC bgcolor="#336699" text="black" background="./images/bg.jpg">
<center>
<form action="./password.sql" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td valign="top"><img src="./images/top_left.gif" width="12" height="12" align="left" vspace="0" hspace="0"></td>
    <td valign="middle"> 
<img src="./images/line_1000.gif" width="630" height="1" border=0><br>
      <div align="right">
<img src="images/ece.jpg" width="190" height="30" align="right">
      </div>
	  <div align="left">
<img src="images/title.jpg" width="350" height="55" align="absmiddle">
	 </div>
    </td>
    <td valign="top"><img src="./images/top_right.gif" width="12" height="12" align="right" vspace="0" hspace="0"></td>
  </tr>
<tr>
<td rowspan="3">&nbsp;</td>
<td rowspan="3">
<div align="center">
<br><h3>Change Proposal Password</h3><br>
</div>
<div align="left">
<h4>You must enter a proposal number.<br>  Please try again.</h4>
Please enter the proposal number.<br>
Proposal#: <input type="text" length="4" name="viewnum">
<br>
Old Password:<input type="password" name="old"><br>
New Password: <input type="password" name="password"><br>
Verify New Password: <input type="password" name="verify"><br>
</div>
</td>
<td rowspan="3">&nbsp;</td>
</tr>
  <tr> </tr>
  <tr> </tr>

<tr>
<td valign="bottom"><img src="./images/bot_left.gif" width="12" height="12" align="left" vspace="0" hspace="0"></td>
<td>
<div align="center">
	<input type="submit" name="mode" value="Submit">
</form>
</div>
<div align="center">
          <a href="./input.sql?mode=Add&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/add_proposal.jpg" alt="Add A Proposal" border=0></a>
<a href="./input.sql?mode=Update&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/update_proposal.jpg" alt="Update Proposal" border=0></a>
<a href="./input.sql?mode=Delete&mode2=Edit&viewnum=<!sql print #viewnum>"><img src="./images/delete_proposal.jpg" alt="Delete Proposal" border=0></a>
<a href="./display.sql?mode=View&viewnum=ALL"><img src="./images/view_all.jpg" alt="View All Proposals" border=0></a>
<a href="./index.html"><img src="./images/home.jpg" alt="Return Home" border=0></a>

</div>
</td>
    <td valign="bottom"><img src="./images/bot_right.gif" width="11" height="12" align="right" vspace="0" hspace="0"></td>
  </tr>
</table>
</center>
</body>
</html>

<!sql endif>

<!sql endif>


