<%@LANGUAGE="JAVASCRIPT"%> 
<%
// *** Logout the current user.
MM_Logout = String(Request.ServerVariables("URL")) + "?MM_Logoutnow=1";
if (String(Request("MM_Logoutnow"))=="1") {
  Session.Contents.Remove("MM_Username");
  Session.Contents.Remove("MM_UserAuthorization");
  var MM_logoutRedirectPage = "../index.htm";
  // redirect with URL parameters (remove the "MM_Logoutnow" query param).
  if (MM_logoutRedirectPage == "") MM_logoutRedirectPage = String(Request.ServerVariables("URL"));
  if (String(MM_logoutRedirectPage).indexOf("?") == -1 && Request.QueryString != "") {
    var MM_newQS = "?";
    for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) {
      if (String(items.item()) != "MM_Logoutnow") {
        if (MM_newQS.length > 1) MM_newQS += "&";
        MM_newQS += items.item() + "=" + Server.URLencode(Request.QueryString(items.item()));
      }
    }
    if (MM_newQS.length > 1) MM_logoutRedirectPage += MM_newQS;
  }
  Response.Redirect(MM_logoutRedirectPage);
}
%>
<!--#include file="../Connections/DB2.asp" -->
<!--#include file="../Connections/cslogin.asp" -->
<%
// *** Edit Operations: declare variables

// set the form action variable
var MM_editAction = Request.ServerVariables("SCRIPT_NAME");
if (Request.QueryString) {
  MM_editAction += "?" + Request.QueryString;
}

// boolean to abort record edit
var MM_abortEdit = false;

// query string to execute
var MM_editQuery = "";
%>
<%
// *** Redirect if username exists
var MM_flag="MM_insert";
if (String(Request(MM_flag)) != "undefined") {
  var MM_dupKeyRedirect="loginfailemail.htm";
  var MM_rsKeyConnection=MM_DB2_STRING;
  var MM_dupKeyUsernameValue = String(Request.Form("emailaddress"));
  var MM_dupKeySQL = "SELECT EmailAddress FROM Customer WHERE EmailAddress='" + MM_dupKeyUsernameValue + "'"
  var MM_adodbRecordset = "ADODB.Recordset";
  var MM_rsKey = Server.CreateObject(MM_adodbRecordset);
  MM_rsKey.ActiveConnection = MM_rsKeyConnection;
  MM_rsKey.Source = MM_dupKeySQL;
  MM_rsKey.CursorType=0;
  MM_rsKey.CursorLocation=2;
  MM_rsKey.LockType=3;
  MM_rsKey.Open();
  if (!MM_rsKey.EOF || !MM_rsKey.BOF) {
    // the username was found - can not add the requested username
    var MM_qsChar = "?";
    if (MM_dupKeyRedirect.indexOf("?") >= 0) MM_qsChar = "&";
    MM_dupKeyRedirect = MM_dupKeyRedirect + MM_qsChar + "requsername=" + MM_dupKeyUsernameValue;
    Response.Redirect(MM_dupKeyRedirect);
  }
  MM_rsKey.Close();
}
%>
<%
// *** Insert Record: set variables

if (String(Request("MM_insert")) == "form3") {

  var MM_editConnection = MM_DB2_STRING;
  var MM_editTable  = "Customer";
  var MM_editRedirectUrl = "userconfirm.htm";
  var MM_fieldsStr = "name|value|address1|value|address2|value|city|value|county|value|postcode|value|phone|value|emailaddress|value|password|value|select2|value|Newsletter|value";
  var MM_columnsStr = "CustomerName|',none,''|Address|',none,''|Address2|',none,''|City|',none,''|County|',none,''|Postcode|',none,''|PhoneNumber|',none,''|EmailAddress|',none,''|Password|',none,''|Hearaboutus|',none,''|NewsLetter|none,none,NULL";

  // create the MM_fields and MM_columns arrays
  var MM_fields = MM_fieldsStr.split("|");
  var MM_columns = MM_columnsStr.split("|");
  
  // set the form values
  for (var i=0; i+1 < MM_fields.length; i+=2) {
    MM_fields[i+1] = String(Request.Form(MM_fields[i]));
  }

  // append the query string to the redirect URL
  if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.Count > 0) {
    MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + Request.QueryString;
  }
}
%>
<%
// *** Insert Record: construct a sql insert statement and execute it

if (String(Request("MM_insert")) != "undefined") {

  // create the sql insert statement
  var MM_tableValues = "", MM_dbValues = "";
  for (var i=0; i+1 < MM_fields.length; i+=2) {
    var formVal = MM_fields[i+1];
    var MM_typesArray = MM_columns[i+1].split(",");
    var delim =    (MM_typesArray[0] != "none") ? MM_typesArray[0] : "";
    var altVal =   (MM_typesArray[1] != "none") ? MM_typesArray[1] : "";
    var emptyVal = (MM_typesArray[2] != "none") ? MM_typesArray[2] : "";
    if (formVal == "" || formVal == "undefined") {
      formVal = emptyVal;
    } else {
      if (altVal != "") {
        formVal = altVal;
      } else if (delim == "'") { // escape quotes
        formVal = "'" + formVal.replace(/'/g,"''") + "'";
      } else {
        formVal = delim + formVal + delim;
      }
    }
    MM_tableValues += ((i != 0) ? "," : "") + MM_columns[i];
    MM_dbValues += ((i != 0) ? "," : "") + formVal;
  }
  MM_editQuery = "insert into " + MM_editTable + " (" + MM_tableValues + ") values (" + MM_dbValues + ")";

  if (!MM_abortEdit) {
    // execute the insert
    var MM_editCmd = Server.CreateObject('ADODB.Command');
    MM_editCmd.ActiveConnection = MM_editConnection;
    MM_editCmd.CommandText = MM_editQuery;
    MM_editCmd.Execute();
    MM_editCmd.ActiveConnection.Close();

    if (MM_editRedirectUrl) {
      Response.Redirect(MM_editRedirectUrl);
    }
  }

}
%>
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_DB2_STRING;
Recordset1.Source = "SELECT *  FROM Customer";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>
<%
// *** Validate request to log in to this site.
var MM_LoginAction = Request.ServerVariables("URL");
if (Request.QueryString!="") MM_LoginAction += "?" + Request.QueryString;
var MM_valUsername=String(Request.Form("emailexist"));
if (MM_valUsername != "undefined") {
  var MM_fldUserAuthorization="LevelID";
  var MM_redirectLoginSuccess="loggedinOrder.asp";
  var MM_redirectLoginFailed="fail.htm";
  var MM_flag="ADODB.Recordset";
  var MM_rsUser = Server.CreateObject(MM_flag);
  MM_rsUser.ActiveConnection = MM_cslogin_STRING;
  MM_rsUser.Source = "SELECT EmailAddress, Password";
  if (MM_fldUserAuthorization != "") MM_rsUser.Source += "," + MM_fldUserAuthorization;
  MM_rsUser.Source += " FROM Customer WHERE EmailAddress='" + MM_valUsername.replace(/'/g, "''") + "' AND Password='" + String(Request.Form("passwordexist")).replace(/'/g, "''") + "'";
  MM_rsUser.CursorType = 0;
  MM_rsUser.CursorLocation = 2;
  MM_rsUser.LockType = 3;
  MM_rsUser.Open();
  if (!MM_rsUser.EOF || !MM_rsUser.BOF) {
    // username and password match - this is a valid user
    Session("MM_Username") = MM_valUsername;
    if (MM_fldUserAuthorization != "") {
      Session("MM_UserAuthorization") = String(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value);
    } else {
      Session("MM_UserAuthorization") = "";
    }
    if (String(Request.QueryString("accessdenied")) != "undefined" && true) {
      MM_redirectLoginSuccess = Request.QueryString("accessdenied");
    }
    MM_rsUser.Close();
    Response.Redirect(MM_redirectLoginSuccess);
  }
  MM_rsUser.Close();
  Response.Redirect(MM_redirectLoginFailed);
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<!-- TemplateBeginEditable name="doctitle" --> 
<title>Character Shop for character merchandise</title>
<!-- TemplateEndEditable --> 
<META name="description" content="For Childrens merchandise, including bagpuss, clangers, thunderbirds, carry on, Dr who, Muppets, fraggle rock, basil brush, button moon, magic roundabout, thomas the tank engine, noddy.">
<META name="keywords" content="Bagpuss, dalek, dr who, sonic screwdriver, ood, the doctor, cybermen, dalek remote, dr who bedding, bagpuss merchandise, bagpuss toys, bagpuss beanies, character merchandsie, bagpuss glasses, bagpuss keyrings, bagpuss tshirts, bagpuss golf covers, bagpuss FDC, bagpuss china, bagpuss mousemat, bagpuss car accessories, clangers, thunderbirds, carry on, Dr who, Muppets, fraggle rock, basil brush, button moon, magic roundabout, thomas the tank engine, noddy.">
<!-- TemplateBeginEditable name="head" --><!-- TemplateEndEditable --> 
<script language="JavaScript" type="text/JavaScript">
<!--

function mmLoadMenus() {
  if (window.mm_menu_0612143756_0) return;
    window.mm_menu_0612143756_0 = new Menu("root",94,20,"",14,"#000000","#FFFFFF","#D0E4FD","#000084","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
  mm_menu_0612143756_0.addMenuItem("Characters","location='../index.htm'");
   mm_menu_0612143756_0.hideOnMouseOut=true;
   mm_menu_0612143756_0.bgColor='#555555';
   mm_menu_0612143756_0.menuBorder=1;
   mm_menu_0612143756_0.menuLiteBgColor='#FFFFFF';
   mm_menu_0612143756_0.menuBorderBgColor='#777777';

mm_menu_0612143756_0.writeMenus();
} // mmLoadMenus()
<!--

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_validateForm() { //v4.0
  var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
  for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]);
    if (val) { nm=val.name; if ((val=val.value)!="") {
      if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
        if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
      } else if (test!='R') { num = parseFloat(val);
        if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';
        if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
          min=test.substring(8,p); max=test.substring(p+1);
          if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
    } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }
  } if (errors) alert('The following error(s) occurred:\n'+errors);
  document.MM_returnValue = (errors == '');
}
//-->
//-->
</script>
<style type="text/css">
<!--
.borderright {
	background-image: url(../Images/bottomright.gif);
	background-repeat: repeat;
}
-->
</style>
<style type="text/css">
<!--
.top {
	background-image: url(../Images/right.gif);
	background-repeat: repeat;
}
-->
</style>
<script language="JavaScript" src="mm_menu.js"></script>
</HEAD>


<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.Border {
	background-image: url(../Images/borderblue.gif);
	background-repeat: repeat;
	border: thin;
	background-position: left;
}
.Text {
	left: 0px;
	clip:       rect(auto auto auto auto);
	font-family: Arial, Helvetica, sans-serif;
	font-weight: normal;
	color: #333333;
	font-style: normal;
	line-height: normal;
	letter-spacing: normal;
	vertical-align: top;
	word-spacing: normal;
	text-align: left;
	list-style-type: none;
	list-style-position: outside;
	list-style-image: none;
	text-indent: 0cm;
	margin-left: 18px;
	font-size: 14px;
	height: auto;
	background-repeat: no-repeat;
	background-position: top;
}
.search {
	background-repeat: no-repeat;
	background-attachment: fixed;
	background-position: center center;
	display: inline-table;
	list-style-position: inside;
	visibility: visible;
	z-index: auto;
	overflow: visible;
	position: static;
	line-height: normal;
	letter-spacing: normal;
	vertical-align: middle;
	word-spacing: normal;
	text-align: left;
	white-space: normal;
	background-color: #B8CFE7;
}
.Main {
	background-color: #FFFFFF;
	background-position: top;
}
.Bagpuss {
	background-repeat: no-repeat;
}
.Info {
	background-image: url(../Images/info_table.png);
}
.Extras {
	background-image: url(../Images/extra_table.png);
}
.Login {
	background-image: url(../Images/login_table.png);
	background-repeat: no-repeat;
}
-->
</style>
</head>

<body bgcolor="#D7E4EC" background="/Images/background1.gif">
<script language="JavaScript1.2">mmLoadMenus();</script>
<table width="860" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td><img src="../Images/cstop.gif" width="860" height="100" border="0" usemap="#Map2"></td>
  </tr>
</table>
<table width="860" height="63" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr valign="bottom"> 
    <td width="67%" height="63" valign="top" class="Top">
<div align="center">
        <table width="92%" border="0" cellpadding="0" cellspacing="0">
          <tr align="left"> 
            <td width="32%" height="63"> 
              <div align="left">
                <form name="form3" method="post" action="">
                  <select name="select2" onChange="MM_jumpMenu('parent',this,0)">
                    <option value="deliveryinfo.htm">Delivery</option>
                    <option value="quiz.htm">Quiz</option>
                    <option value="contact_us.htm">Contact Us</option>
                    <option value="aboutus.htm">About Us</option>
                    <option value="privacy.htm">Privacy Policy</option>
                    <option value="t-shirtsizes.htm">Tshirt sizes</option>
                    <option value="help.htm">Help</option>
                    <option value="testimonials.htm">Testimonials</option>
                    <option value="copyright.htm">Copyright</option>
                  </select>
                </form>
                <p class="POPUP">&nbsp;</p>
              </div></td>
            <td width="3%"><div align="center"></div></td>
            <td width="65%"><div align="center"> 
                <form name="form2" method="post" action="">
                  <strong> Search Products 
                  <select name="select" onChange="MM_jumpMenu('parent',this,0)">
                    <option value="bagpusspage.htm">Bagpuss</option>
                    <option value="clangerspage.htm">Clangers</option>
                    <option value="basilpage.htm">Basil Brush</option>
                    <option value="catsearchpage.asp?textfield=Beatrix potter">Beatrix 
                    Potter</option>
                    <option value="catsearchpage.asp?textfield=Bob the builder">Bob 
                    the Builder</option>
                    <option value="catsearchpage.asp?textfield=Button Moon T-Shirt">Button 
                    Moon</option>
                    <option value="carryonpage.htm">Carry on</option>
                    <option value="catsearchpage.asp?textfield=dangermouse">Dangermouse</option>
                    <option value="drwhopage.htm">Dr Who</option>
                    <option value="catsearchpage.asp?textfield=dumbo">Dumbo</option>
                    <option value="catsearchpage.asp?textfield=Fireman Sam">Fireman 
                    Sam</option>
                    <option value="catsearchpage.asp?textfield=Forever Friends">Forever 
                    Friends</option>
                    <option value="catsearchpage.asp?textfield=Fraggle Rock T-Shirts">Fraggle 
                    Rock</option>
                    <option value="catsearchpage.asp?textfield=Ivor the Engine China">Ivor 
                    the Engine</option>
                    <option value="magicpage.htm">Magic Roundabout</option>
                    <option value="catsearchpage.asp?textfield=mickey mouse">Mickey 
                    Mouse</option>
                    <option value="catsearchpage.asp?textfield=miffy">Miffy</option>
                    <option value="catsearchpage.asp?textfield=Mr Benn">Mr Benn</option>
                    <option value="mrmen.htm">Mr Men</option>
                    <option value="catsearchpage.asp?textfield=Noddy">Noddy</option>
                    <option value="catsearchpage.asp?textfield=only fools">Only 
                    Fools</option>
                    <option value="catsearchpage.asp?textfield=postman pat">Postman 
                    Pat</option>
                    <option value="catsearchpage.asp?textfield=paddington">Paddington</option>
                    <option value="catsearchpage.asp?textfield=Pink Panther">Pink 
                    Panther</option>
                    <option value="rainbowpage.htm">Rainbow</option>
                    <option value="catsearchpage.asp?textfield=Ragdoll">Ragdolls</option>
                    <option value="catsearchpage.asp?textfield=Simpsons">Simpsons</option>
                    <option value="catsearchpage.asp?textfield=Strawberry shortcake">Strawberry 
                    Shortcake</option>
                    <option value="catsearchpage.asp?textfield=Tots TV">Tots TV</option>
                    <option value="muppetspage.htm">Muppets</option>
                    <option value="catsearchpage.asp?textfield=Thomas">Thomas</option>
                    <option value="catsearchpage.asp?textfield=winnie the pooh">Winnie 
                    The Pooh</option>
                  </select>
                  </strong> 
                </form>
                
              </div></td>
          </tr>
        </table>
        
      </div></td>
    <td width="33%" height="63" align="center" valign="middle" class="Top"> 
      <form action="searchpage.asp" method="get" name="form1" target="_self">
        <p align="center"> 
          <input type="text" name="textfield">
          <input type="submit" name="Submit" value="Search">
        </p>
      </form></td>
    <td width="0%" align="center" valign="middle" class="search"><div align="right"></div></td>
  </tr>
</table>
<map name="Map">
  <area shape="rect" coords="131,26,380,56" href="../indexaug.htm">
</map>
<table width="860" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="114" height="954" align="left" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="center"></div>
      <div align="left" class="Text"> 
        <p align="left" class="Text">&nbsp;</p>
        <table width="98%" border="0" align="left" cellpadding="0" cellspacing="0">
          <tr> 
            <td class="Border"><p align="left"><img src="/Images/basket.gif" width="164" height="25"></p>
              <p align="left"><font size="3" face="Times New Roman, Times, serif"><a href="login.asp">Login</a></font></p>
              <p align="left"><font size="3" face="Times New Roman, Times, serif"><a href="<%= MM_Logout %>">Logout</a></font></p>
              <p align="left"><font size="3" face="Times New Roman, Times, serif"><a href="login_check.asp">Check 
                Order</a></font></p>
              <p align="left">&nbsp;</p></td>
          </tr>
        </table>
        <p align="left" class="Text">&nbsp;</p>
        <p align="left" class="Text">&nbsp;</p>
        </div></td>
    <td width="721" align="center" valign="top" bgcolor="#FFFFFF"><div align="left" class="Text"> 
        <p align="center"><strong><font size="+3">LOGIN</font></strong></p>
        <p><font color="#666699" size="5"><strong>Existing Users</strong></font></p>
        <form name="form2" method="POST" action="<%=MM_LoginAction%>">
          <table width="90%" border="0">
            <tr> 
              <td width="23%">E-mail Address</td>
              <td width="77%"><input name="emailexist" type="text" id="email2"></td>
            </tr>
            <tr> 
              <td>Password </td>
              <td><input name="passwordexist" type="password" id="password2"></td>
            </tr>
          </table>
          <p> 
            <input type="submit" name="Submit2" value="Login">
          </p>
        </form>
        <p class="Main">&nbsp;</p>
        <p class="Main"><font color="#666698" size="5"><strong>New users</strong></font></p>
        <form action="<%=MM_editAction%>" method="POST" name="form3" onSubmit="MM_validateForm('name','','R','address13','','R','city2','','R','county3','','R','postcode2','','R','emailadd2','','RisEmail','passwordnew2','','R');return document.MM_returnValue">
          <table width="90%" border="0">
            <tr> 
              <td width="24%">Name</td>
              <td width="76%"><input name="name" type="text" id="name"></td>
            </tr>
            <tr> 
              <td>Address</td>
              <td> <input name="address1" type="text" id="address13"> </td>
            </tr>
            <tr> 
              <td>&nbsp;</td>
              <td><input name="address2" type="text" id="address22" value=" "></td>
            </tr>
            <tr> 
              <td>City </td>
              <td><input name="city" type="text" id="city2"></td>
            </tr>
            <tr> 
              <td>County </td>
              <td><input name="county" type="text" id="county3" value=" "></td>
            </tr>
            <tr> 
              <td>Postcode</td>
              <td><input name="postcode" type="text" id="postcode2"></td>
            </tr>
            <tr> 
              <td>Phone Number</td>
              <td><input name="phone" type="text" id="phone2" value=" "></td>
            </tr>
            <tr> 
              <td>Email Address</td>
              <td><input name="emailaddress" type="text" id="emailadd2">
                (This will be your login ID)</td>
            </tr>
            <tr> 
              <td>Password</td>
              <td><input name="password" type="password" id="passwordnew2"></td>
            </tr>
            <tr> 
              <td>Where did you hear about us?</td>
              <td><select name="select2">
                  <option value="Google">Google</option>
                  <option value="Yahoo">Yahoo</option>
                  <option value="Froogle">Froogle</option>
                  <option value="Other search engine">Other search engine</option>
                  <option value="Recommended">Recommended</option>
                  <option value="Newsletter">Newsletter</option>
                  <option value="Existing customer">Existing customer</option>
                  <option value="Referral website">Referral website</option>
                  <option value="Other">Other</option>
                </select></td>
            </tr>
          </table>
          <p>&nbsp;</p>
          <p>Subscription To CharcterShop Newsletter 
            <label> 
            <input name="Newsletter" type="radio" value="1" checked>
            Yes</label>
            <label> 
            <input type="radio" name="Newsletter" value="0">
            No</label>
          </p>
          <p>&nbsp;</p>
          <p> 
            <label> 
            <input type="submit" name="Submit3" value="Submit">
            </label>
          </p>
          <input type="hidden" name="MM_insert" value="form3">
        </form>
        <p class="Main">&nbsp;</p>
        <p class="Main">&nbsp;</p>
        </div></td>
    <td width="23" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
</table>
<table width="860" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td><img src="../Images/bottomleft.gif" width="128" height="35"></td>
    <td><img src="../Images/bottom.gif" width="709" height="35"></td>
    <td><img src="../Images/rhsbottom.gif" width="23" height="35"></td>
  </tr>
</table>
<p>&nbsp;</p>
<map name="middleMap">
  <area shape="rect" coords="18,6,135,56" href="#" onMouseOver="MM_showMenu(window.mm_menu_0612143756_0,30,43,null,'middle')" onMouseOut="MM_startTimeout();">
</map>
<map name="Map2">
  <area shape="rect" coords="19,10,851,93" href="../index.htm">
</map>
</body>
</html>
<%
Recordset1.Close();
%>