<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var Recordset1 = Server.CreateObject("ADODB.Recordset"); Recordset1.ActiveConnection = MM_Ramblers_STRING; Recordset1.Source = "SELECT FirstName, Password FROM Members"; 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("textfield")); if (MM_valUsername != "undefined") { var MM_fldUserAuthorization=""; var MM_redirectLoginSuccess="members_main.asp"; var MM_redirectLoginFailed="memberslogin_error.asp"; var MM_flag="ADODB.Recordset"; var MM_rsUser = Server.CreateObject(MM_flag); MM_rsUser.ActiveConnection = MM_Ramblers_STRING; MM_rsUser.Source = "SELECT FirstName, Password"; if (MM_fldUserAuthorization != "") MM_rsUser.Source += "," + MM_fldUserAuthorization; MM_rsUser.Source += " FROM Members WHERE FirstName='" + MM_valUsername.replace(/'/g, "''") + "' AND Password='" + String(Request.Form("textfield2")).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" && false) { MM_redirectLoginSuccess = Request.QueryString("accessdenied"); } MM_rsUser.Close(); Response.Redirect(MM_redirectLoginSuccess); } MM_rsUser.Close(); Response.Redirect(MM_redirectLoginFailed); } %>
Purveyors
of Finest
Jewellery
 First for Jewellery Home    About Us   Contact Us   Quality Guarantee 
Jewellery
   
 Specialist suppliers of Rough, Cut and Mounted Gemstones to Trade Buyers, Wholesalers, Retailers and the General Public
 We source our products personally & directly from the mines
Visit our shop at ShenZhen Permanent Jewellery Exhibition Centre:
Huafa South Rd.2A-29
China & Hongkong International Jewellry Trade Centre
Shenzhen city, Guangdong, China. 518031
 
 
Links
Free Newsletter
Member Login

User Name
Password

Sign-up for free


Ebay

Paypal Sign-up
VisaMaster CardAmerican ExpressDiscover
Contact Us
Terms and conditions may apply. All prices correct at time of publication. Currency exchange rate fluctuations, International Shipping charges and oil surcharges may apply
Webmaster @ Pearl Dragon