session_start(); session_register("uname"); session_register("uid"); session_register("redirect"); session_register("qnav"); $connect=odbc_connect("ITLog","anon","anon1"); //script updated 3/5/02 tsf //script revised 7/23/06 tsf for To Do List, Project Mgmt //echo var_dump($_GET); //echo var_dump($_SESSION); if((!isset($nav) or ($nav=="") or ($nav==0)) and ($uid=="")) { require("help_desk/login.inc"); } else { $sql="SELECT COUNT(user_id) FROM pwd_master_tbl WHERE username = '".$_POST['user']."' AND password = '".$_POST['pword']."';"; //echo $sql; $cnt=odbc_exec($connect,$sql); $test=odbc_result($cnt,1); if($test!=0) {//valid login $sql="SELECT * from pwd_master_tbl where username='".$_POST['user']."' and password='".$_POST['pword']."';"; //echo $sql; $logins=odbc_exec($connect,$sql); //$uname=odbc_result($logins,6).odbc_result($logins,5); $uid=odbc_result($logins,1); $uname=odbc_result($logins,2); //$quick=odbc_result($logins,4); switch($_POST['redirect']) { case 1://project management $header=""; require("blank.inc"); break; case 20://to do list $header=""; require("blank.inc"); break; default: //$DSN="pwd"; $header=""; require("blank.inc"); break; } } else {//error $error="
Your username or password is invalid. Please try again
"; $error=$error."