
mysql_connect("localhost", "eliteCust", "Tunafish1"); mysql_select_db("elite_custFiles"); ?> if(isset($_POST["login"])){ $query = "select * from `user` where `username` = '".$_POST["username"]."' and `password` = '".$_POST["password"]."' and `active` = 1"; //echo $query; $result = mysql_query($query); if(mysql_num_rows($result) == 1){ $_SESSION["logged_in"] = TRUE; $data = mysql_fetch_assoc($result); $_SESSION["id"] = $data["id"]; $_SESSION["first"] = $data["first"]; $_SESSION["last"] = $data["last"]; $_SESSION["user_class"] = $data["user_class_id"]; $_SESSION["brands"] = $data["brands"]; $query2 = "update `user` set `last_login` = NOW() where `id` = ".$data["id"]; $result2 = mysql_query($query2); $query2 = "update `user_current_status` set `last_login` = NOW(), `last_report` = NOW(), `last_page` = '".$_SERVER["REQUEST_URI"]."', `remote_ip` = '".$_SERVER["REMOTE_ADDR"]."' where `user_id` = ".$data["id"]; //echo $query2; $result2 = mysql_query($query2); }else{ $error = "Login Incorrect, Please try again."; } } if(isset($_SESSION["logged_in"])){ }else{ ?>
