<?
// session_start();
// $start_var = 1;
// session_register(start_var);

//print header
$page_name = "client";
require("header.php");
?>

<td valign="top">
<center>
<br><table border=0 width=100% cellspacing=0 cellpadding=0>
<tr><td valign="middle" align="center"><img src="images/delim.gif" width=50 height=15 align="middle"><img src="images/t_clientarea.gif" align="middle"><img src="images/delim.gif" width=50 height=15 align="middle"></td></tr>
<tr><td height="5"><img src="images/clear.gif" height=5 width=5></td></tr>
</table>
<center><P>

<? 
if ($username && $password) {
   $db = odbc_connect("DB5338A", "5338", "miff0609");
   $query = "SELECT * FROM qselClientDetails WHERE (Username = '$username') AND (Password = '$password')";
   $rsx = odbc_exec($db,$query);
   
   $client_id = (odbc_result($rsx, "ClientID"));
   if ($client_id > 0)  // IF CLIENT EXISTS
   {
      echo "<P><table border=0 width=95%>\n";
      echo "<tr>\n";
      echo "<td class=\text\" width=35% valign=top>\n";
      echo "   <center><table width=\"98%\" border=0 cellspacing=0 cellpadding=0 bgcolor=#000000>\n";
      echo "           <tr><td width=10 background=\"images/shadow_left.gif\" valign=\"top\"><img src=\"images/shadow_top.gif\"></td>\n";
      echo "               <td width=*><table width=\"100%\" border=0 cellspacing=1 cellpadding=3 bgcolor=#000000>\n";
      echo "                   <tr><td class=\"client-header\" align=\"center\">Client Information</td></tr>\n";
      echo "                   <tr><td class=\"client-data\">\n";
      echo "                       <b>" . (odbc_result($rsx, "BusName")) . "</b>\n";
      echo "		           <br>" . (odbc_result($rsx, "Address1")) . "\n";
          if (odbc_result($rsx, "Address2")) {
      	     echo "                    <br>" . (odbc_result($rsx, "Address2")) . "\n";
          }
      echo "		           <br>" . (odbc_result($rsx, "City")) . ", " . (odbc_result($rsx, "State")) . "\n";
      echo "                       <br>" . (odbc_result($rsx, "Zip")) . "<img src=\"images/clear.gif\" width=\"100%\" height=\"5\">\n";
      echo "                       <b><u>Point of Contact</u></b>\n";
      echo "                       <br>" . (odbc_result($rsx, "POC")) . "\n";
      echo "		           <br>Phone: " . (odbc_result($rsx, "Phone")) . "\n";
          if (odbc_result($rsx, "Fax")) {
      	     echo "                    <br>Fax: " . (odbc_result($rsx, "Fax")) . "\n";
          }
      echo "		           <br>Email: " . (odbc_result($rsx, "Email")) . "<img src=\"images/clear.gif\" width=\"100%\" height=\"5\">\n";
      echo "			   <center><form action=\"client_edit.php\" method=\"post\" name=\"edit\"><input type=\"hidden\" name=\"client_id\">( <a href=\"javascript:linksubmit('" . $client_id . "')\" class=\"service-link\">Edit Client Information</a> )</form></center>\n";
      echo "                       <center><form action=\"client_pop3.php\" method=\"post\" name=\"pop3\"><input type=\"hidden\" name=\"client_id\">( <a href=\"javascript:linksubmit('" . $client_id . "')\" class=\"service-link\">Edit Client Information 2</a> )</form></center>\n";
      echo "                       </td>\n";
      echo "                   </tr></table>\n";
      echo "               </td>\n";
      echo "           </tr>\n";
      echo "           <tr><td width=10><img src=\"images/shadow_corner.gif\"></td>\n";
      echo "               <td width=* background=\"images/shadow_bot.gif\" align=\"right\"><img src=\"images/shadow_bot_rt.gif\"></td>\n";
      echo "           </tr>\n";
      echo "           </table>\n";
      echo "   </center>\n";
      echo "</td><td class=\text\" width=65% valign=top>\n";

      echo "</td></tr></table>\n";
   } 
   else {
      echo "<P>Invalid Username and/or Password";
      require("login_form.php");
   }
} 
else {
    // provide form to log in 
    require("login_form.php");
  }
?>

</center>
</td>

<?
   if ($client_id > 0) {
      $right_nav = array("none");
      require("footer.php");
   } else {
      $right_nav = array("forgot", "help");
      require("footer.php");   	
   }
?>