<?php
//GroupAware
//Team 7
?>
<html>
<head>
<title>GroupAware</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="group.css" rel="stylesheet" type="text/css">
<link href="blocks.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
@import url("tabs.css");
-->
</style>
</head>
<body link="#003366" vlink="#003366" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" height="125" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="75" valign="bottom" bgcolor="#CCCCCC"><table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="125" height="110"><font size="7" face="Arial, Helvetica, sans-serif"><strong><a href="index.php"><img src="groupAwareLogoSm2.gif" alt="logo" width="103" height="99" border="0" align="absmiddle"></a></strong></font></td>
<td><img src="spacer.gif" width="20" height="8"><font size="7" face="Arial, Helvetica, sans-serif"><strong>Group<font color="#003366">Aware</font>
<font size="4"><br>
<img src="spacer.gif" width="150" height="1">Meeting Time Organizer</font></strong></font></td>
<td width="200" valign="top" class="css">
<div align="right"><strong><font size="1"><a href="about.php"> <font size="2">About</font></a><font size="2">
| <a href="faq.php">FAQ</a> | <a href="contact.php">Contact</a><img src="spacer.gif" width="10" height="8"></font></font></strong> </div></td>
</tr>
</table>
<div align="right">
<table width="200" height="25" border="0" cellpadding="0" cellspacing="0" bordercolor="#660000" class="tabs">
<tr valign="middle" class="tabs">
<td width="100" bgcolor="#FFFFFF" class="tabs">
<div align="center"><a href="index.php"><strong>Log In </strong></a></div></td>
<td width="100" bgcolor="#660000" class="tabs">
<div align="center"><strong><font color="#FFFFFF">Register</font></strong></div></td>
</tr>
</table>
</div>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5" bgcolor="#660000"><img src="spacer.gif" width="1" height="1"></td>
</tr>
</table>
</td>
</tr>
<!--
<tr>
<td height="7" colspan="2" bgcolor="#660000"><img src="spacer.gif" width="1" height="1"></td>
</tr>
-->
</table>
<table width="100%" height="80%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" valign="top"><div align="left"> <span class="headerNav"><strong><font size="1"><a href="index.php"><font color="#660000">Home</font></a>
> Register</font></strong></span></p>
<p align="center"><span class="css"><strong><br>
<font color="#003366" size="3">Please regsister here to use this site<br>
</font></strong><font color="#003366" size="3"><font color="#333333" size="2">*
indicates required fields</font></font></span></p>
</div>
<!-- -->
<?php
require_once('Connections/dbsvr.php'); //connect to database.
if ($_POST['type'] != "add")
{?>
<div align="center"></div>
<div align="center"></div>
<div align="center">
<table width="400" border="0" class="css">
<form name="adduser" method="post" action="register.php">
<tr>
<td width="150"><div align="right">Username:</div></td>
<td> <input type="text" name="user"></td>
</tr>
<tr>
<td width="150"><div align="right">Password:</div></td>
<td> <input type="password" name="pass"></td>
</tr>
<tr>
<td width="150"><div align="right">Confirm Password: </div></td>
<td> <input type="password" name="confirmpass"></td>
</tr>
<tr>
<td width="150"><div align="right">Email:</div></td>
<td> <input type="text" name="email"></td>
</tr>
<tr>
<td width="150"><div align="right">First Name:</div></td>
<td> <input type="text" name="fname"></td>
</tr>
<tr>
<td width="150"><div align="right">Last Name:</div></td>
<td> <input type="text" name="lname"></td>
</tr>
<tr>
<td width="150"><div align="right">Address:</div></td>
<td> <input type="text" name="address"></td>
</tr>
<tr>
<td width="150"><div align="right">City:</div></td>
<td> <input type="text" name="city"></td>
</tr>
<tr>
<td width="150"><div align="right">State:</div></td>
<td> <input type="text" name="state"></td>
</tr>
<tr>
<td width="150"><div align="right">Zipcode:</div></td>
<td> <input name="zip" type="text" size="6"></td>
</tr>
<tr>
<td width="150"><div align="right">Phone:</div></td>
<td> <input name="phone" type="text" size="14"></td>
</tr>
<tr>
<td colspan="2"> <div align="center">
<input type="hidden" name="type" value="add">
<input type="submit" name="submit" value="Submit">
</div></td>
</tr>
</form>
</table>
<span class="css">
<?php
}
if ($_POST['type'] == "add")
{
//sets local variables to passed form values
$user = $_POST['user'];
$pass = $_POST['pass'];
$confpass = $_POST['confirmpass'];
$email = $_POST['email'];
$f_name = $_POST['fname'];
$l_name = $_POST['lname'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$zipcode = $_POST['zip'];
$phone = $_POST['phone'];
if ($pass != $confirmpass) //the two password fields do not match so validation fails
{?>
Passwords do not match. </span></div>
<form name="return" method="post" action="new_user.php">
<div align="center"> <span class="css">
<input type="hidden" name="type" value="add">
<input type="submit" name="submit" value="Try Again">
</span></div>
</form>
<div align="center"> <span class="css">
<?php
}
//checks to make sure there are no other users by the same name - if there is validation fails
mysql_select_db($database_dbsvr, $dbsvr);
$query_auth = "SELECT username FROM users WHERE username = '$user';";
$auth = mysql_query($query_auth, $dbsvr) or die(mysql_error());
$row_auth = mysql_fetch_assoc($auth);
$auth_TotalRows = mysql_num_rows($auth);
if ($auth_TotalRows > 0)
{?>
Username already exists. Please select another. </span></div>
<form name="return" method="post" action="register.php">
<div align="center"> <span class="css">
<input type="hidden" name="type" value="">
<input type="submit" name="submit" value="Try Again">
</span></div>
</form>
<div align="center"> <span class="css">
<?php
}
else
{
//if validation successful enter information into database
mysql_select_db($database_dbsvr, $dbsvr);
$query_insert = "INSERT INTO users SET
username = '$user',
password = '$pass',
email = '$email',
f_name = '$f_name',
l_name = '$l_name',
street = '$address',
city = '$city',
state = '$state',
zipcode = '$zipcode',
phone = '$phone';";
$insert = mysql_query($query_insert, $dbsvr) or die(mysql_error());
?>
Account created, Return to main page to log in. </span></div>
<form name="return" method="post" action="index.php">
<div align="center"> <span class="css">
<input type="hidden" name="type" value="">
<input type="submit" name="submit" value="Return">
</span></div>
</form>
<div align="center">
<?php
}
}?>
</div></td>
</tr>
<tr>
<td height="20" colspan="2" valign="top"><div align="center"><font size="1" face="Arial, Helvetica, sans-serif"><br>
<br>
This site was created by IST students at The Pennsylvania State University.
Use of this system is subject to the terms and conditions set forth.<br>
Copyright 2005</font><font size="1"><br>
<br>
</font></div></td>
</tr>
</table>
</body>
</html>