<?php
require_once ("paths.inc.php");
require_once ($path_root."lib/octoploid/php/basic_set_up.inc.php");
require_once ($path_lib_main_php."header.inc.php");
require_once ($path_lib_main_php."include_pear.inc.php");
require_once ($path_lib_main_php."config.inc.php");
require_once ($path_lib_main_php."logged_in_message.inc.php");
require_once ($path_lib_main_php."sessions.inc.php");

$app_name = "Log In";
include_header($path_root, $path_app, $app_name);
title_image($path_root);
render_app_title($app_name);
?>

<p>
<center>
<TABLE border="1" cellpadding="8" cellspacing="10">
<TR>
<TD>

<?php
$target = $_GET['target'];

if (isset($password_rejected)) {
  echo "<H4 align='center'><font color='red'>Your password was rejected</font></h4>";
}

if (isset($no_user_specified)) {
  echo "<H4 align='center'><font color='red'>You <em>must</em> choose a user name</font></h4>";
}

if (isset($no_session)) {
  echo "<H4 align='center'><font color='green'>No session found so far</font></h4>";
}

if (isset($no_session_id)) {
  echo "<H4 align='center'><font color='green'>No session ID found so far</font></h4>";
}

if (isset($no_session_valid)) {
  echo "<H4 align='center'><font color='green'>No valid session ID found so far</font></h4>";
}

?>

<H4 align="center">Please identify yourself</H4>

<form action="login.php" method="get">

<?php

$connection = new DatabaseConnection($data_source_name);

$query = "SELECT email, name FROM ".$table_name_workers." WHERE coach = '1' ORDER BY name";

$result = $connection -> query($query);
?>

<CENTER>
<table>
<TR>
<TD align="right" valign="top">User:</TD>
<TD>
<select name="coach_email" size="6">

<?php

while ($row = $result -> fetchRowAssoc()) {
  $email = $row['email'];
  $name  = $row['name'];
  echo "<option value='$email'>$name<BR>";
}
?>

</select>
</TD>
</TR>
<TR>
<TD>Password:</TD>
<TD><input type="password" name="password" size="30" value=""></TD>
<input type="hidden" name="target" value="<?php echo $target; ?>">
</TD>
</TR>
</table>

<input type="submit" name="" value="Log in"></TD>

</form>
</CENTER>

</TD>
</TR>
</table>

<?php include_footer(); ?>
