--C2C_V2008_2.1Աݿ
--һ	ݿ½
--1.	
if exists (select * from sysobjects where id = object_id(N'[Pro_ShowBuyProduct]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [Pro_ShowBuyProduct]
;
if exists (select * from sysobjects where id = object_id(N'[YX_ViewBuyvote]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [YX_ViewBuyvote]
;

If not exists(select * from sysobjects where name='yx_bankcard')   
CREATE TABLE [yx_bankcard] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_userid] [int] NULL ,
	[yx_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_bankname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_cardno] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_yx_bankcard] PRIMARY KEY  CLUSTERED 
	(
		[yx_id]
	)  ON [PRIMARY] ,
	CONSTRAINT [IX_yx_bankcard] UNIQUE  NONCLUSTERED 
	(
		[yx_cardno]
	)  ON [PRIMARY] 
) ON [PRIMARY]
;

--2.	ֱ
If not exists(select * from sysobjects where name='YX_Rui') 
CREATE TABLE [YX_Rui] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_userid] [int] NULL ,
	[yx_rui] [money] NULL CONSTRAINT [DF_YX_Rui_yx_rui] DEFAULT (0),
	[yx_money] [money] NULL ,
	[yx_start] [int] NULL CONSTRAINT [DF_YX_Rui_yx_start] DEFAULT (0),
	[yx_time] [datetime] NOT NULL ,
	[yx_orderid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_YX_Rui] PRIMARY KEY  CLUSTERED 
	(
		[yx_id]
	)  ON [PRIMARY] 
) ON [PRIMARY]
;
--3.	󹺱
If not exists(select * from sysobjects where name='yx_buyproduct') 
CREATE TABLE [yx_buyproduct] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_Class] [int] NULL ,
	[YX_Userid] [int] NULL ,
	[YX_ProductName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_prosxid] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_proskin] [int] NULL ,
	[YX_KeysWord] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Spic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProCon] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_KcNum] [int] NULL ,
	[YX_ProPrice] [float] NULL ,
	[YX_Veri] [int] NULL ,
	[YX_ViewNum] [int] NULL CONSTRAINT [DF_yx_buyproduct_YX_ViewNum] DEFAULT (0),
	[YX_AddTime] [datetime] NULL ,
	[YX_PinPai] [int] NULL ,
	[YX_proyxq] [int] NULL ,
	[YX_sf] [int] NULL ,
	[YX_cs] [int] NULL ,
	[YX_yb] [int] NULL ,
	[YX_sj] [int] NULL CONSTRAINT [DF_yx_buyproduct_YX_sj] DEFAULT (0),
	[YX_zt] [int] NULL ,
	[yx_sstart] [int] NULL ,
	[yx_openstart] [int] NULL CONSTRAINT [DF_yx_buyproduct_yx_openstart] DEFAULT (0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;
--4.	֧
If not exists(select * from sysobjects where name='YX_Worth') 
CREATE TABLE [YX_Worth] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_orderid] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_userid] [int] NULL ,
	[yx_money] [money] NULL ,
	[yx_time] AS (getdate()) ,
	[yx_start] [int] NOT NULL CONSTRAINT [DF_YX_Worth_yx_start] DEFAULT (0),
	[yx_orderidstart] [int] NULL CONSTRAINT [DF_YX_Worth_yx_orderidstart] DEFAULT (0),
	CONSTRAINT [PK_YX_Worth] PRIMARY KEY  CLUSTERED 
	(
		[yx_id]
	)  ON [PRIMARY] 
) ON [PRIMARY]
;
--5.    ʵ
if not exists (select * from sysobjects where id = object_id(N'[yx_postform]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
CREATE TABLE [yx_postform] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_orderid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_fhsj] [datetime] NULL ,
	[yx_dhsj] [datetime] NULL ,
	[yx_ydgs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_lxfs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;
--	ݿ޸
--1.	yx_shopһֶε̵ȼĬֵΪ0 ʾ̵ͨȼ
If  not  exists (select  1   from   syscolumns where id=object_id('yx_shop') and name='yx_shopdj')   
Alter table yx_shop add yx_shopdj int default 0 with values  
;

--2.	YX_UserInfoһֶYX_Moneyyx_userrank Ĭֵ(0)
If  not exists(select 1 from syscolumns where id=object_id('yx_userinfo') and name='yx_money')
Alter table yx_userinfo add yx_money money default 0 with values
;

If  not exists(select 1 from syscolumns where id=object_id('yx_userinfo') and name='yx_userrank')
Alter table yx_userinfo add yx_userrank int default 0 with values
;

--3.	YX_ProductClass һֶ yx_money ߱Ͻ
If  not exists(select 1 from syscolumns where id=object_id('yx_productclass') and name='yx_money')
Alter table yx_productclass add yx_money money default 0 with values
;

--4.	YX_Webinfo YX_ShopOpen ̵ȼ YX_ComsOpen߱ϼƻ,YX_GuaOpen (ٷ) YX_RuiOpen 0Ϊ YX_RuiС YX_RatioӶ
If not exists(select 1 from syscolumns where id = object_id('yx_webinfo') and name ='yx_shopopen')
Alter table yx_webinfo add yx_shopopen int default 0
;
If not exists(select 1 from syscolumns where id=object_id('yx_webinfo') and name='yx_comsopen')
Alter table yx_webinfo add yx_comsopen int default 0
;
If not exists(select 1 from syscolumns where id=object_id('yx_webinfo') and name='yx_guaopen')
Alter table yx_webinfo add yx_guaopen int default 0
;
If not exists(select 1 from syscolumns where id=object_id('yx_webinfo') and name='yx_ruiopen')
Alter table yx_webinfo add yx_ruiopen int default 0
;
If not exists(select 1 from syscolumns where id=object_id('yx_webinfo') and name='yx_rui')
Alter table yx_webinfo add yx_rui money default 0
;
If not exists(select 1 from syscolumns where id=object_id('yx_webinfo') and name='yx_ratio')
Alter table yx_webinfo add yx_ratio int default 0
;

--5.	YX_OrderFormֶ yx_zfType֧ 0ʾ֧ 1ʾٷ
If not exists(select 1 from syscolumns where id=object_id('yx_orderform') and name='yx_zftype')
Alter table yx_orderform add yx_zftype int default 0
;

--6.    yx_webinfoֶyx_edition,yx_jackclose,yx_close汾ѹرվ˵رվ˵
If not exists(select 1 from syscolumns where id=object_id('yx_webinfo') and name='yx_edition')
Alter table yx_webinfo add yx_edition varchar(50) default 'V2008_2.1'
;
If not exists(select 1 from syscolumns where id=object_id('yx_webinfo') and name='yx_jackclose')
Alter table yx_webinfo add yx_jackclose ntext default 'Closing'
;
If not exists(select 1 from syscolumns where id=object_id('yx_webinfo') and name='yx_close')
Alter table yx_webinfo add yx_close ntext default 'Closed'
;

--ģҳݵ޸

UPDATE YX_CMSModel SET YX_CMSContent='<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml">
<HEAD>
<TITLE>{$Hope_Context$}{$Hope_Brand$}{$Hope_Type$}{$Hope_Title$}</TITLE>
<META http-equiv=keywords content={$Hope_KeysWord$} />
<meta name="description" content="{$Hope_SiteExc$}" />
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/v2.0.css" type="text/css">
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/forum_v2.css" type="text/css">
<LINK href="{$Hope_SitUrl$}{$Hope_Skin$}index.css" type=text/css rel=stylesheet>
<LINK href="{$Hope_SitUrl$}{$Hope_Skin$}help.css" type=text/css rel=stylesheet>
<style type="text/css">
<!--
#m2{background:url({$Hope_SitUrl$}{$Hope_Skin$}images/menuactive.gif) left; width:60px;padding-left:5px}
#m2 a{color:#fff; font-size:14px; font-weight:600}
-->
</style></head>
<body class="W950 kk">
{$Hope_Top$}
<table width="100%"><tr><td  valign="top">
    <table width="100%" border="0" cellpadding="0" cellspacing="0" style=" margin-top:2px">
          <tr>
            <td height="20" align="center"bgcolor="#E6F5FF"><table width="93%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td width="78%" height="24" align="left" class="link1">Ϣ</td>
                  <td width="22%" class="link1"></td>
                </tr>
            </table></td>
          </tr>
          <tr>
            <td align="left" valign="top" bgcolor="#f5f5f5" class="pdpadding">
              {$Hope_FindProBuy$}
            </td>
          </tr>
        </table>	    
	    <table width="100%" border="0" cellpadding="0" cellspacing="0" class="bder1">
          <tr>
            <td height="20" align="center" bgcolor="#E6F5FF">
			<table width="93%" border="0" cellspacing="0" cellpadding="0" class="link1">
                <tr>
                  <td width="78%" height="24" align="left">ϢĿ</td>
                  <td width="22%" class="link1"></td>
                </tr>
            </table></td>
          </tr>
          <tr>
            <td align="left" width="100%" valign="top" bgcolor="#f5f5f5" class="pdpadding">{#Hope_ShowProClass*#}</td>
          </tr>
        </table> 	</td><td valign="top">
	   <table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td  height="35" background="{$Hope_SitUrl$}{$Hope_Skin$}images/sort_head_main.gif"><table width="100%" height="35" border="0" cellpadding="0" cellspacing="0">
              <tr>
                <td width="100%" align="left"><img src="{$Hope_SitUrl$}{$Hope_Skin$}images/buy_sort_head_left.gif" height="35" width="100%" /></td>
                <td align="right"><img src="{$Hope_SitUrl$}{$Hope_Skin$}images/sort_head_side.gif" width="5" height="35" /></td>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td valign="top" style="border-left:#C4CE1C 2px solid; border-right:#C4CE1C 2px solid; padding:10px">{#Hope_PageBuyPro_List*10,20,ClassId,Protitle,ProListCon#}</td> 
          </tr>
<!--          <tr>
          <td valign="top" style="border-left:#C4CE1C 2px solid; border-right:#C4CE1C 2px solid; padding:10px">{$Hope_BuyProList$}</td>
          </tr>
-->          <tr>
            <td valign="top">
			<table width="100%" border="0" cellpadding="0" cellspacing="0">
              <tr>
                <td width="1%" align="left"><img src="{$Hope_SitUrl$}{$Hope_Skin$}images/sort_head_left.gif" width="10" height="4" /></td>
                <td  width="98%"><img src="{$Hope_SitUrl$}{$Hope_Skin$}images/sort_head_left.gif" width="100%" height="4" /></td>
                <td width="1%" align="right"><img src="{$Hope_SitUrl$}{$Hope_Skin$}images/sort_head_left.gif" width="10" height="4" /></td>
              </tr>
            </table></td>
          </tr>
      </table></td></tr></table>
{$Hope_Bottom$}

</body>
</html>
' WHERE YX_CMSModelName='browse_offer'
;

UPDATE YX_CMSModel SET YX_CMSContent='<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml">
<HEAD>
<TITLE>{$Hope_Context$}{$Hope_Brand$}{$Hope_Type$}{$Hope_Title$}</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<META http-equiv=keywords content={$Hope_KeysWord$} />
<meta name="description" content="{$Hope_SiteExc$}" />
<link rel="shortcut icon" href="{$Hope_SitUrl$}favicon.ico" type="image/x-icon" />
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/v2.0.css" type="text/css">
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/layout.css" type="text/css">
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/component.css" type="text/css">
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/level1.css" type="text/css">
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/sell.css" type="text/css">
<SCRIPT src="{$Hope_SitUrl$}{$Hope_Skin$}JS/common.js" type=text/javascript></SCRIPT>
<SCRIPT src="{$Hope_SitUrl$}{$Hope_Skin$}JS/atpanel.js" type=text/javascript></SCRIPT>
<SCRIPT src="{$Hope_SitUrl$}{$Hope_Skin$}JS/top_new.js" type=text/javascript></SCRIPT>
<BODY class=W950>
{$Hope_Top$} 
<!-- Head end -->

<DIV class=main>
<div style="float:left; width:80%; text-align:left"><img src="{$Hope_SitUrl$}{$Hope_Skin$}image/title_login_2.gif"/></div>
<DIV id=loginLeft>
<DIV id=loginMain>

<DIV style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 5px; PADDING-TOP: 15px"></DIV>
<DIV id=errormsg style="DISPLAY: none"><SPAN class=fontOrange id=errorInfo>
</SPAN>
</DIV>
 <script language="javascript">
function loginSubmit(form2){
var userName = form2.elements["Yx_vipName"];
var password = form2.elements["Yx_vipPassword"];
if(userName.value == ""){alert("û");return false}
if(password.value == ""){alert("");password.focus();return false}
location.href="?usrname="+userName.value;
}
</script>
<form action="login.aspx?flag=login" method=post name=form2 onSubmit="return loginSubmit(this);">
<UL>
  <LI>&nbsp;&nbsp;&nbsp;&nbsp; 
    <INPUT  name=Yx_vipName class=inputMain size="30">
    &nbsp;<A 
  href="VipUser/VipReg.aspx" target=_blank>˺&gt;&gt;</A> 
  <LI><span style="margin-left:25px!important; margin-left:18px;"></span>
    <INPUT name=Yx_vipPassword  type=password class=inputMain size="30" maxLength=16>
    &nbsp;<A 
  href="VipUser/Yx_FindPass.aspx" 
  target=_blank>&gt;&gt;</A>
  <LI style="PADDING-LEFT: 100px"><INPUT id=Submit tabIndex=4 type=image  src="{$Hope_SitUrl$}{$Hope_Skin$}image/login_submit2.gif" value="   ¼  " name=Submit> 
  </LI>
  <LI style="PADDING-LEFT: 100px">
 </LI></UL>
</FORM></DIV>
</DIV>
<DIV style="FLOAT: left; WIDTH: 40px;"><IMG height=194 
src="{$Hope_SitUrl$}{$Hope_Skin$}image/login_v_line.jpg" width=49></DIV>
<DIV id=loginSide>
  <DIV 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 10px; PADDING-BOTTOM: 0px; WIDTH: 240; PADDING-TOP: 0px; POSITION: relative; HEIGHT: 148px">
<UL>
  <LI><IMG src="{$Hope_SitUrl$}{$Hope_Skin$}image/login_btn_02.gif" 
  align=absMiddle>&nbsp;&nbsp;&nbsp;кû5000Ʒѡ
  <LI><IMG src="{$Hope_SitUrl$}{$Hope_Skin$}image/login_btn_03.gif" align=absMiddle 
  vspace=5>&nbsp;&nbsp;&nbsp;ģ֧׳ȫ 
  <LI><IMG src="{$Hope_SitUrl$}{$Hope_Skin$}image/login_btn_04.gif" 
  align=absMiddle>&nbsp;&nbsp;&nbsp;׬Ǯѡ
  <LI><IMG src="{$Hope_SitUrl$}{$Hope_Skin$}image/login_btn_05.gif" align=absMiddle 
  vspace=5>&nbsp;&nbsp;&nbsp;ʻÿһ졣 </LI>
  <LI>&nbsp;&nbsp;&nbsp;<a href={$Hope_SitUrl$}vipuser/VipReg.aspx><img src="{$Hope_SitUrl$}{$Hope_Skin$}image/register_submit002.gif" width="157" height="34"></a></LI>
</UL></DIV>
</DIV></DIV>
<DIV style="MARGIN-BOTTOM: 15px; clear:both;"></DIV>
{$Hope_Bottom$} 
</BODY></HTML>
' WHERE YX_CMSModelName='VipLogin'
;

UPDATE YX_CMSModel SET YX_CMSContent='<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml">
<HEAD>
<TITLE>{$Hope_Context$}{$Hope_Brand$}{$Hope_Type$}{$Hope_Title$}</TITLE>
<META http-equiv=keywords content={$Hope_KeysWord$} />
<meta name="description" content="{$Hope_SiteExc$}" />
<link rel="shortcut icon" href="{$Hope_SitUrl$}favicon.ico" type="image/x-icon" />
<link href="{$Hope_SitUrl$}{$Hope_Skin$}/index.css" rel="stylesheet" charset="gb2312" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/v2.0.css" type="text/css">
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/layout.css" type="text/css">
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/component.css" type="text/css">
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/level1.css" type="text/css">
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/sell.css" type="text/css">
<SCRIPT src="{$Hope_SitUrl$}{$Hope_Skin$}JS/common.js" type=text/javascript></SCRIPT>
<SCRIPT src="{$Hope_SitUrl$}{$Hope_Skin$}JS/common(1).js" type=text/javascript></SCRIPT>
<SCRIPT src="{$Hope_SitUrl$}{$Hope_Skin$}JS/atpanel.js" type=text/javascript></SCRIPT>
<SCRIPT src="{$Hope_SitUrl$}{$Hope_Skin$}JS/top_new.js" type=text/javascript></SCRIPT>
<script language="javascript" src="{$Hope_SitUrl$}Include/area.js"></script>
<script language="javascript" defer="defer">
function checkfrm(){
var regm =/^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+((\.[a-zA-Z0-9_-]{2,3}){1,2})$/;
var vipname=document.getElementById("vipname");
var vippassword=document.getElementById("vippassword");
var vippasswordb=document.getElementById("vippasswordb");
var vippwdquestion=document.getElementById("vippwdquestion");
var vippwdanswer=document.getElementById("vippwdanswer");
var vipemail=document.getElementById("vipemail");
var prov=document.getElementById("prov");
  function   isChinese(str){   
  var   lst   =   /[u00-uFF]/;                 
  return   !lst.test(str);               
  }   
  if(isChinese(vipname.value))   
  {
     if(vipname.value.length>=3 && vipname.value.length<=16){
	 if(vipname.value.replace(/^\s+|\s+$/igm,"")=="")
	 {
		alert("дʺ");
		vipname.focus();
		return false;
	  }
   }else{
	alert("ûȲС3λ16λ")
	vipname.focus();
	return false;
   }
  }  
  else   
  {
   if(vipname.value.length>=3 && vipname.value.length<=16){
	 if(vipname.value.replace(/^\s+|\s+$/igm,"")=="")
	 {
		alert("дʺ");
		vipname.focus();
		return false;
	  }
   }else{
	alert("ûȲС6λ16λ")
	vipname.focus();
	return false;
   }
  }
	if(vippassword.value.replace(/^\s+|\s+$/igm,"")==""){
	alert("д");
	vippassword.focus();
	return false;
	}else{
	if(vippassword.value.length<6||vippassword.value.length>15){
	alert("볤Ȳ6λ15");
	vippassword.focus();
	return false;
	}
}
if(vippasswordb.value.replace(/^\s+|\s+$/igm,"")==""|| vippasswordb.value!=vippassword.value){
alert("벻һ");
vippasswordb.focus();
return false;
}
if(vippwdquestion.value.replace(/^\s+|\s+$/igm,"")==""){
alert("д뱣ϵ");
vippwdquestion.focus();
return false;
}
if(vippwdanswer.value.replace(/^\s+|\s+$/igm,"")==""){
alert("д뱣ϵĴ");
vippwdanswer.focus();
return false;
}
if(vipemail.value.replace(/^\s+|\s+$/igm,"")==""){
	 alert("дEmailַ");
	vipemail.focus();
	return false;
 }else{
	 if (!regm.test(vipemail.value))
   {
     alert("EmailַʽзǷַ!\n飡");
     vipemail.focus(); 
     return false;
    }  
 }
 if(prov.value=="0"){
  alert("ѡ");
     prov.focus(); 
     return false;
 }
if(document.frmreg.vipqq.value.replace(/\s+/g,"").length>=5 && document.frmreg.vipqq.value.replace(/\s+/g,"").length<=9){
	  if(document.frmreg.vipqq.value.replace(/\s+/g,"")=="")
	  {
	   alert("뼴ʱͨѶQQţ");
	   document.frmreg.vipqq.focus();
	   return false;
	  }  
}else{
	alert("ȷļʱͨѶQQ")
	document.frmreg.vipqq.focus();
	   return false;
}
}

</script>
<META content="MSHTML 6.00.2900.3086" name=GENERATOR>
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
.inputwi{
	width:160px;
	height:20px;
}
.tab{
	font-size:14px;
}
-->
</style>
</HEAD>
<BODY class=W950>
{$Hope_Top$} 
<!-- Head end -->



<DIV class=main>
<table width="100%" border="0" align="center" cellpadding="00" cellspacing="0">
  <tr>
    
    <td  valign="top" align="center">
<form id="frmreg" name="frmreg" method="post" action="?Action=Add" onSubmit="return checkfrm()">
	  <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
                                <tr>
                                  <td height="25" align="center">&nbsp;</td>
                                </tr>
                                <tr>
                                    <td height="25" align="center">
                                        <div align="left"><span class="9font1" style="color: #ff6200"><strong><span
                                            style="color: #ff7000"><img src="{$Hope_SitUrl$}{$Hope_Skin$}IMAGE/inputREG.jpg"/></span></strong></span> </div></td>
                                </tr>
                                <tr>
                                    <td align="left">
                                        <table width="100%" height="214" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" class="tab">
                                            
                                            
                                            <tr>
                                              <td height="25" colspan="3" align="right" style=" color: #7e7777;">&nbsp;</td>
                                            </tr>
                                            <tr>
                                                <td width="142" height="25" align="right" style=" color: #7e7777;">
                                                    û&nbsp; &nbsp;</td>
                                              <td height="25" colspan="2" >
                                                <span style="color: #ff0000">                                                  
<input name="vipname" type="text" class="input1 inputwi" id="vipname"  maxlength="30"/>                                            
                                                  *</span>&nbsp;<span style="">淶û<span id="RequiredFieldValidator2" style="color:Red;display:none;">û!</span></span> </div>
                                                  </td>    
                                            </tr>
                             
                                            <tr>
                                                <td height="25" align="right" style=" color: #7e7777; ">
                                                    &nbsp; &nbsp;</td>
                                                <td height="25" colspan="2" >
                                                  <span style="color: #ff0000">
                                                       <input name="vippassword" type="password" class="input1 inputwi" id="vippassword" maxlength="21" />
                                              *</span>&nbsp;<span style="">6ַ15ַ<span id="Span1" style="color:Red;display:none;">!</span></span>                                              </td>    
                                            </tr>
                            
                                            <tr>
                                                <td height="25" align="right" style=" color: #7e7777;">
                                                    ظ&nbsp; &nbsp;</td>
                                                <td width="361" height="25" style=" height: 19px">
                                                    <span style="color: #ff0000">
                                                        <input name="vippasswordb" type="password" class="input1 inputwi" id="vippasswordb" maxlength="21" />
                                                  *</span>
                                                  <span id="RequiredFieldValidator6" style="color:Red;display:none;">ظ!</span>
                                              <span id="CompareValidator1" style="color:Red;display:none;">벻һ£</span></td>    <td width="337" style="">
                                                </td>
                                            </tr>
<tr>
                                                <td height="25" align="right" style=" color: #7e7777; ">
                                                    ûǳ&nbsp; &nbsp;</td>
                                                <td height="25" colspan="2">                                             
                                                       <input name="nickname" type="text" class="input1 inputwi" id="nickname" maxlength="21" />
                                                                                         </td>    
                                            </tr>

                                            
                                            <tr>
                                                <td height="25" align="right" style=" color: #7e7777; ">
                                                    뱣&nbsp; &nbsp;</td>
                                                <td height="25" colspan="2" >
                                                  <span style="color: #ff0000">
                                                       <input name="vippwdquestion" type="text" class="input1 inputwi" id="Text1" maxlength="21" />
                                              *</span>&nbsp;<span style="">һʱ<span id="Span2" style="color:Red;display:none;">뱣!</span></span>                                              </td>    
                                            </tr>
                            
                                            <tr>
                                                <td height="25" align="right" style=" color: #7e7777;">
                                                    뱣&nbsp; &nbsp;</td>
                                                <td width="361" height="25" style=" height: 19px">
                                                    <span style="color: #ff0000">
                                                        <input name="vippwdanswer" type="text" class="input1 inputwi" id="Text2" maxlength="21" />
                                                  *</span>&nbsp;<span style="">һʱĴ<span id="RequiredFieldValidator3" style="color:Red;display:none;">뱣Ĵ!</span></span> </td>    <td width="337" style="">
                                                </td>
                                            </tr>
                

                                            <tr>
                                                <td height="25" align="right" style=" color: #7e7777;">
                                                    E-mailַ&nbsp; &nbsp;</td>
                                              <td height="25" colspan="2" style=""><input name="vipemail" type="text" class="input1 inputwi" id="vipemail" maxlength="30"  /> 
                                                      <span class="STYLE1">*</span>
                                              <div id="showare2" name="showare2" style="color:red;width:200px; padding-top:5px; height:25px; float:right; display:none; background-color:#DEF4FE" >											  </div>                                               
                                               дõĵʼַ                                              </td>
                                            </tr>
                                                    
                                         
											  <tr>
            <td height="25" align="right" style="color: #7e7777; ">
              ڵ&nbsp;&nbsp;&nbsp;</td>
            <td align="left" >   
             <span style="color: #ff0000">
            <select id="prov" name="prov" sytle="height:18px" onChange="cityName(document.frmreg.prov.options[document.frmreg.prov.selectedIndex].value)">
<option value="0">ѡ</option>
</select>
<select name="city" id="city">
</select>
<script language=javascript>function window.onload(){province(0);cityName(document.frmreg.prov.value,0);}</script> 
 *</span>&nbsp;<span style="">ѡڵ<span id="Span3" style="color:Red;display:none;">ѡڵ!</span></span>            </td>
				<td>				</td>
        </tr>
				
                                            <tr>
                                                <td align="right" style="color: #7e7777; ">
                                                    QQ&nbsp; &nbsp;</td>
                                                <td height="25" >
                                                 <span style="color: #ff0000">
                                              <input name="vipqq" type="text" onKeyUp="value=value.replace(/[^\d]/g," ")"   class="input1 inputwi" id="vipqq" maxlength="15" />
                                               *</span>&nbsp;<span style="">ļʱQQ<span id="Span4" style="color:Red;display:none;">ļʱQQ!</span></span>
                                              </td>    <td style="">
                                                </td>
                                            </tr>
                                          
                                      </table>                                    </td>
                                </tr><tr><td height="25"></td></tr>
                                <tr><td bgcolor="#E7E7E7" height="1"></td></tr>
                                <tr>
                                    <td align="center" >

                                        <br />
                                        <input style="width:250px;height:30px" type="submit" name="regcheckbtn" value="ͬ·,ύעϢ" />&nbsp;
									   <ul id="FromReadContract" class="Form_Advance">
      <li class="Seperator"><hr /></li>
      <li class="Title">ĶԱЭ</li>
      <li id="ReadContract">
		<div id="ContractContent">
<textarea rows=5 cols=100>{$Hope_UserAgreement$}</textarea>
		</div>
      </li>
    </ul>

    <ul id="AlipayContract" class="Form_Advance">
        <li class="Title">֧Э</li>
        <li id="Li1">
            <div id="Div1"><textarea rows=5 cols=100>{$Hope_ZFBAgreement$}</textarea></div>
        </li>
      </ul></td>
                                </tr><tr>
                                    <td align="center" >                                  </td>

                                </tr>
        </table>
	  </form>
    </td>
  </tr>
</table>
</DIV>

<DIV style="MARGIN-BOTTOM: 15px; clear:both;"></DIV>
{$Hope_Bottom$} 
</BODY></HTML>
' WHERE YX_CMSModelName='VipReg'
;

UPDATE YX_CMSModel SET YX_CMSContent = '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml">
<HEAD>
<TITLE>{$Hope_Title$}</TITLE>
<META http-equiv=keywords content={$Hope_KeysWord$} />
<meta name="description" content="{$Hope_SiteExc$}" />
<link rel="shortcut icon" href="{$Hope_SitUrl$}favicon.ico" type="image/x-icon" />
<link href="{$Hope_SitUrl$}{$Hope_Skin$}/index.css" rel="stylesheet" charset="gb2312" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/v2.0.css" type="text/css">
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/layout.css" type="text/css">
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/component.css" type="text/css">
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/level1.css" type="text/css">
<link rel="stylesheet" href="{$Hope_SitUrl$}{$Hope_Skin$}CSS/sell.css" type="text/css">
<SCRIPT src="{$Hope_SitUrl$}{$Hope_Skin$}JS/common.js" type=text/javascript></SCRIPT>
<SCRIPT src="{$Hope_SitUrl$}{$Hope_Skin$}JS/common(1).js" type=text/javascript></SCRIPT>
<SCRIPT src="{$Hope_SitUrl$}{$Hope_Skin$}JS/atpanel.js" type=text/javascript></SCRIPT>
<SCRIPT src="{$Hope_SitUrl$}{$Hope_Skin$}JS/top_new.js" type=text/javascript></SCRIPT>
<script language="javascript" src="{$Hope_SitUrl$}Include/area.js"></script>
<script language="javascript" type="text/javascript" defer="defer">
var xmlHttp;

function createXMLHttpRequest()
{
if(window.ActiveXObject)
{ 
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
else if(window.XMLHttpRequest)
{
xmlHttp = new XMLHttpRequest();
}
}
function checkname(){
document.getElementById("vipname").value=document.getElementById("vipname").value.replace(/\s/igm,"");
var name=document.getElementById("vipname").value;
url = "{$Hope_SitUrl$}Admin/YX_user/CheckUserName.aspx?Uname="+name;
xmlHttp.open("GET",url,true);
xmlHttp.onreadystatechange = docheckname;
xmlHttp.send(null);
return false;}
function checkemail(){
document.getElementById("vipemail").value=document.getElementById("vipemail").value.replace(/\s/igm,"");
var vipemail=document.getElementById("vipemail").value;
url = "{$Hope_SitUrl$}Admin/YX_user/CheckUserEmail.aspx?UEmail="+vipemail;
xmlHttp.open("GET",url,true);
xmlHttp.onreadystatechange = docheckemail;
xmlHttp.send(null);
return false;}
function docheckname(){
if(xmlHttp.readyState==4)
{
	if(xmlHttp.responseText=="False"){
	document.getElementById("showare").style.display="";
	document.getElementById("showare").innerText="ע";
	}
	else{
	document.getElementById("showare").style.display="";
	document.getElementById("showare").innerText="û";
	}
}

}
function docheckemail(){
if(xmlHttp.readyState==4)
{
	if(xmlHttp.responseText=="False"){
	document.getElementById("showare2").style.display="";
	document.getElementById("showare2").innerText="ʹַ";
	}
	else{
	document.getElementById("showare2").style.display="";
	document.getElementById("showare2").innerText="ַѾʹ";
	}
}

}

</script>
<script language="javascript" defer="defer">
function checkfrm(){
 var regm =/^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+((\.[a-zA-Z0-9_-]{2,3}){1,2})$/;
var vipname=document.getElementById("vipname");
var vippassword=document.getElementById("vippassword");
var vippasswordb=document.getElementById("vippasswordb");
var vipquestion=document.getElementById("vipquestion");
var vipemail=document.getElementById("vipemail");
var prov=document.getElementById("prov");
var vipmobile=document.getElementById("vipmobile");

if(vipname.value.replace(/^\s+|\s+$/igm,"")==""){
alert("дʺ");
vipname.focus();
return false;
}
	if(vippassword.value.replace(/^\s+|\s+$/igm,"")==""){
	alert("д");
	vippassword.focus();
	return false;
	}else{
	if(vippassword.value.length<6||vippassword.value.length>15){
	alert("볤Ȳ6λ15");
	vippassword.focus();
	return false;
	}
	}
if(vippasswordb.value.replace(/^\s+|\s+$/igm,"")==""|| vippasswordb.value!=vippassword.value){
alert("벻һ");
vippasswordb.focus();
return false;
}
if(vipquestion.value.replace(/^\s+|\s+$/igm,"")==""){
alert("дȡ");
vipquestion.focus();
return false;
}
 if(vipemail.value.replace(/^\s+|\s+$/igm,"")==""){
 alert("дEmailַ");
vipemail.focus();
return false;
 }else{
 if (!regm.test(vipemail.value))
   {
     alert("EmailַʽзǷַ!\n飡");
     vipemail.focus(); 
     return false;
    }  
 }
 if(prov.value=="0"){
  alert("ѡ");
     prov.focus(); 
     return false;
 }
 if(vipaddr.replace(/^\s+|\s+$/igm,"")==""){
  alert("дϵַ");
     vipaddr.focus(); 
     return false;
 }
if(vipmobile.value.replace(/^\s+|\s+$/igm,"")==""){


alert("дȷֻ");
     vipmobile.focus(); 
     return false;
 }
}
function window.onload()
{
   province(0);
   cityName(document.frmreg.prov.selectedIndex,0);//óʼֵ
   createXMLHttpRequest()
}
</script>
<META content="MSHTML 6.00.2900.3086" name=GENERATOR>
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
-->
</style>
</HEAD>
<BODY class=W950>
{$Hope_Top$} 
<!-- Head end -->



<DIV class=main>


<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" class="tab01">
            <tr>
              <td><!---------#λ-------></td>
            </tr>
            <tr>
              <td valign="top"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
                <tr>
                  <th align="left" scope="col">&nbsp;</th>
                </tr>
                <tr>
                  <th height="150" valign="top" ><br />
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td valign="top"><br />
                          <table width="100%" border="0" cellspacing="0" cellpadding="0">
                            <tr>
                              <td> 
                                <!----------------------------------------->
                                {$Hope_RegSuccess$}
                                <!------------------------------------------>
                              </td>
                            </tr>
                            <tr>
                              <td>&nbsp;</td>
                            </tr>
                            <tr>
                              <td align="center></td>
      </tr>
      
           <tr>
        <td align="left" style="background-color:#ECECEC"></td>
                            </tr>
                          </table>
                        <!------------------------------------------>                        </td>
                      </tr>
                    </table>
				  </th>
                </tr>

              </table></td>
            </tr>
</table>


</DIV>

<DIV style="MARGIN-BOTTOM: 15px; clear:both;"></DIV>
{$Hope_Bottom$} 
</BODY></HTML>' WHERE YX_CMSModelName='VipRegOk'
;