}
 //}
 if ($username_flag != 1 && $password_flag != 1) {
     $sql = " SELECT user_id,user_name,password FROM " . $tableprefix . "users\n\t\t\t\tWHERE user_name='" . addslashes($txtUserName) . "' AND password = '******' AND deleted = 'N'";
     $result = mysql_query($sql) or die(mysql_error());
     if (mysql_num_rows($result) > 0) {
         $row = mysql_fetch_array($result);
         $message = "Success!";
         $_SESSION["sess_username"] = $row["user_name"];
         $_SESSION["sess_userid"] = $row["user_id"];
         /*---------------Multicart 2.0 Upgradation------------------*/
         /*-------function call to manage the different sessions--------*/
         manageSession(3);
         /*---------------Multicart 2.0 Upgradation------------------*/
         if (!isVisitorCartEmpty(session_id())) {
             mergeVisitorCartToUserCart(session_id(), $row["user_id"]);
         }
         if ($action != "") {
             if ($action == "checkout") {
                 echo "<script>location.href='viewcart.php';</script>";
                 //header("Location:viewcart.php");
                 exit;
             }
         } else {
             /*--------Multicart 2.0 starts-----------*/
             /*echo "<script>location.href='usermain.php';</script>";*/
             $currentPage = GetCurrentPageName();
             $referer = $_SERVER['HTTP_REFERER'];
             echo "<script>location.href='" . $referer . "';</script>";
             /*--------Multicart 2.0 ends-----------*/
             //header("Location:usermain.php");
         $userinfo['lists'] = array($constantcontactSettings['constantcontactlistId']);
         // print_r($userinfo);exit;
         $_SESSION['constantparam']['data'] = $userinfo;
         $_SESSION['constantparam']['redirecturl'] = SITE_URL . '/index.php';
         header("location:" . $constantcontactSettings['verificationURL']);
         exit;
     }
     //header("Location:index.php");
 }
 //$message = "Registration successfully completed! Please <a class=links href='login.php'><b>login here</b>.</a>";
 /*----------Multicart2.0 Upgradation---------------*/
 if ($action != "") {
     $_SESSION["sess_username"] = $txtUserName;
     $_SESSION["sess_userid"] = $userid;
     if (!isVisitorCartEmpty(session_id())) {
         mergeVisitorCartToUserCart(session_id(), $userid);
     }
     if ($action == "checkout") {
         header("Location:viewcart.php");
         exit;
     }
 }
 $txtUserName = "";
 $txtFirstName = "";
 $txtLastName = "";
 $txtAddress1 = "";
 $txtAddress2 = "";
 $txtCity = "";
 $txtState = "";
 $ddlCountry = "";
 $txtZIP = "";