if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_AdGet_Proc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CFWztg_AdGet_Proc]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_AdGoto_Proc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CFWztg_AdGoto_Proc]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_Clear_Proc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CFWztg_Clear_Proc]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_AD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_AD]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_AD_Counter_Day]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_AD_Counter_Day]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_AD_Counter_Hour]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_AD_Counter_Hour]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_AdUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_AdUser]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_AdUser_Enough]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_AdUser_Enough]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_AdUser_Expend]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_AdUser_Expend]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_AdUser_Order]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_AdUser_Order]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_Admin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_Admin]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_Alexa_Day]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_Alexa_Day]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_Area_Day]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_Area_Day]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_Gbook]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_Gbook]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_IpAddress]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_IpAddress]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_LowUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_LowUser]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_OtherSet]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_OtherSet]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_SiteClass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_SiteClass]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_Spend]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_Spend]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_SysInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_SysInfo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_Temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_Temp]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_User]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_UserDeduct]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_UserDeduct]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_UserSite]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_UserSite]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_Visit_Ip]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_Visit_Ip]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_Visit_Ly]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_Visit_Ly]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_WebHeight_Day]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_WebHeight_Day]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_WebLeft_Day]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_WebLeft_Day]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_WebTop_Day]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_WebTop_Day]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CFWztg_WebWidth_Day]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CFWztg_WebWidth_Day]
GO

CREATE TABLE [dbo].[CFWztg_AD] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[AdUserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdState] [int] NOT NULL ,
	[Ad_Class] [int] NOT NULL ,
	[AD] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AD_Url] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdWidth] [int] NOT NULL ,
	[AdHeight] [int] NOT NULL ,
	[AdShowType] [int] NOT NULL ,
	[ClickState] [int] NOT NULL ,
	[Unit_Cent_First] [numeric](18, 5) NOT NULL ,
	[Unit_Cent] [numeric](18, 5) NOT NULL ,
	[TotalClick] [int] NOT NULL ,
	[OverClick] [int] NOT NULL ,
	[AdRegUserState] [smallint] NOT NULL ,
	[AdRegUserDouble] [int] NOT NULL ,
	[AdDesc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdListShowState] [smallint] NOT NULL ,
	[AdSpareShowState] [smallint] NOT NULL ,
	[AdDeDuct_Rate] [int] NOT NULL ,
	[OtherSet] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_AD_Counter_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ad_ID] [int] NOT NULL ,
	[Display_Counter] [int] NOT NULL ,
	[Click_Counter] [int] NOT NULL ,
	[Reg_Counter] [int] NOT NULL ,
	[Display_2_Counter] [int] NOT NULL ,
	[Click_2_Counter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_AD_Counter_Hour] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ad_ID] [int] NOT NULL ,
	[Display_Counter] [int] NOT NULL ,
	[Click_Counter] [int] NOT NULL ,
	[Reg_Counter] [int] NOT NULL ,
	[Display_2_Counter] [int] NOT NULL ,
	[Click_2_Counter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddHour] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_AdUser] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[AdUserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EMail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[QQ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Mobile] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[WebSite] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdShowNum] [int] NOT NULL ,
	[ComVisit] [int] NOT NULL ,
	[ComReg] [int] NOT NULL ,
	[Total_Cent] [numeric](18, 5) NOT NULL ,
	[Spend_Cent] [numeric](18, 5) NOT NULL ,
	[Spare_Cent] [numeric](18, 5) NOT NULL ,
	[OrderRecCode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Logintotal] [int] NOT NULL ,
	[LastLoginTime] [datetime] NOT NULL ,
	[LastLoginIp] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[State] [smallint] NOT NULL ,
	[OtherSet] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[Cookies] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_AdUser_Enough] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[AdUserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Enough_Cent] [numeric](18, 5) NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[AdminDesc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_AdUser_Expend] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Ad_ID] [int] NOT NULL ,
	[AdUserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Expend_Cent] [numeric](18, 5) NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[ExpendDesc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ChaseState] [smallint] NOT NULL ,
	[ChaseClickNum] [int] NOT NULL ,
	[ExpendState] [int] NOT NULL ,
	[ExPendAbortFeedBack] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdminCheck] [smallint] NOT NULL ,
	[AdminDesc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[AdminSpendTime] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_AdUser_Order] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[AdUserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[OrderCode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[OrderUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[OrderCent] [numeric](18, 5) NOT NULL ,
	[TcObject] [int] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[OrderOver] [smallint] NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SpendID] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_Admin] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Admin] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EffectTime] [int] NOT NULL ,
	[LyMaxTotal] [int] NOT NULL ,
	[IpMaxTotal] [int] NOT NULL ,
	[LastDelTime] [datetime] NOT NULL ,
	[LastCleanTime] [datetime] NOT NULL ,
	[LowSpendCent] [int] NOT NULL ,
	[UserTcRate] [int] NOT NULL ,
	[UserOrderTcRate] [int] NOT NULL ,
	[AdClickRate] [int] NOT NULL ,
	[ShowClickInfo] [smallint] NOT NULL ,
	[UserDeDuctState] [smallint] NOT NULL ,
	[UserValid] [smallint] NOT NULL ,
	[AdUserValid] [smallint] NOT NULL ,
	[IncomeTop] [smallint] NOT NULL ,
	[SpendTop] [smallint] NOT NULL ,
	[QQ_State] [smallint] NOT NULL ,
	[QQ_Code] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[RegType] [int] NOT NULL ,
	[AccessPath] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SqlServerIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SqlServerDbName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SqlServerLinkName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SqlServerLinkPassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SaveRegTable] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SaveRegUserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SaveRegPassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PassWordType] [int] NOT NULL ,
	[RegUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LoginUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SkinType] [int] NOT NULL ,
	[SkinColor] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EmailSendType] [int] NOT NULL ,
	[JmailAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JmailUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JmailPassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[OtherSet] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LicensedCode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LoginTotal] [int] NOT NULL ,
	[LastLoginTime] [datetime] NOT NULL ,
	[Cookies] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_Alexa_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ad_ID] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AlexaCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_Area_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ad_ID] [int] NOT NULL ,
	[IpArea] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_Gbook] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Assort] [int] NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Content] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[Reply] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[ReplyTime] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_IpAddress] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Ip_1] [float] NOT NULL ,
	[Ip_2] [float] NOT NULL ,
	[Area] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Area_2] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_LowUser] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[AdUserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LowUserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_OtherSet] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[BName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[HName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ZValue] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_SiteClass] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SiteClassName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_Spend] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Spend_Cent] [numeric](18, 5) NOT NULL ,
	[SpendDesc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SpendTime] [datetime] NOT NULL ,
	[SpendState] [int] NOT NULL ,
	[SpendAbortFeedBack] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SpendType] [int] NOT NULL ,
	[AdminCheck] [smallint] NOT NULL ,
	[AdminDesc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[AdminSpendTime] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_SysInfo] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Assort] [int] NOT NULL ,
	[Title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Content] [varchar] (6000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_Temp] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MyID] [int] NULL ,
	[MyStr] [varchar] (6000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_User] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PasswordAsk] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PasswordAnswer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EMail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[QQ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Mobile] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[WebSite] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdUserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PayType] [int] NOT NULL ,
	[Bank_Address] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Bank_UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Bank_UserCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pay_B] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pay_C] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pay_D] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Total_Cent] [numeric](18, 5) NOT NULL ,
	[Spend_Cent] [numeric](18, 5) NOT NULL ,
	[Spare_Cent] [numeric](18, 5) NOT NULL ,
	[AdShowNum] [int] NOT NULL ,
	[ComVisit] [int] NOT NULL ,
	[ComReg] [int] NOT NULL ,
	[DeDuct_Rate] [int] NOT NULL ,
	[UserAllSite] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Logintotal] [int] NOT NULL ,
	[LastLoginTime] [datetime] NOT NULL ,
	[LastLoginIp] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[State] [smallint] NOT NULL ,
	[OtherSet] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[AdminDesc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Cookies] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_UserDeduct] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Deduct_Cent] [numeric](18, 5) NOT NULL ,
	[AddTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_UserSite] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteUrl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteState] [int] NOT NULL ,
	[SiteClassName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_Visit_Ip] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AD_ID] [int] NOT NULL ,
	[Ip_1] [int] NOT NULL ,
	[Ip_2] [int] NOT NULL ,
	[Ip_3] [int] NOT NULL ,
	[Ip_4] [int] NOT NULL ,
	[Ip_All] [bigint] NOT NULL ,
	[Ip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpArea] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpArea_2] [int] NOT NULL ,
	[Ly] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AgentStr] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Alexa] [smallint] NOT NULL ,
	[WebWidth] [int] NOT NULL ,
	[WebHeight] [int] NOT NULL ,
	[WebTop] [int] NOT NULL ,
	[WebLeft] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_Visit_Ly] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AD_ID] [int] NOT NULL ,
	[Ip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ly] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[IpCounter_2] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL ,
	[AddTime] [datetime] NOT NULL ,
	[LastTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_WebHeight_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ad_ID] [int] NOT NULL ,
	[WebHeight] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_WebLeft_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ad_ID] [int] NOT NULL ,
	[WebLeft] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_WebTop_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ad_ID] [int] NOT NULL ,
	[WebTop] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CFWztg_WebWidth_Day] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ad_ID] [int] NOT NULL ,
	[WebWidth] [int] NOT NULL ,
	[IpCounter] [int] NOT NULL ,
	[AddDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFWztg_AD] WITH NOCHECK ADD 
	CONSTRAINT [PK_CFWztg_AD] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_AdUser_Enough] WITH NOCHECK ADD 
	CONSTRAINT [PK_CFWztg_AdUser_Enough] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_AdUser_Expend] WITH NOCHECK ADD 
	CONSTRAINT [PK_CFWztg_AdUser_Expend] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_Gbook] WITH NOCHECK ADD 
	CONSTRAINT [PK_CFWztg_Gbook] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_Spend] WITH NOCHECK ADD 
	CONSTRAINT [PK_CFWztg_Spend] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_SysInfo] WITH NOCHECK ADD 
	CONSTRAINT [PK_CFWztg_SysInfo] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_Temp] WITH NOCHECK ADD 
	CONSTRAINT [PK_CFWztg_Temp] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_UserDeduct] WITH NOCHECK ADD 
	CONSTRAINT [PK_CFWztg_UserDeduct] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_Visit_Ip] WITH NOCHECK ADD 
	CONSTRAINT [PK_CFWztg_Visit_Ip] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_AD_Counter_Day] ON [dbo].[CFWztg_AD_Counter_Day]([UserName], [Ad_ID], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_AD_Counter_Hour] ON [dbo].[CFWztg_AD_Counter_Hour]([UserName], [Ad_ID], [AddDate], [AddHour]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_AdUser] ON [dbo].[CFWztg_AdUser]([AdUserName]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_AdUser_Order] ON [dbo].[CFWztg_AdUser_Order]([AdUserName], [OrderCode]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_Admin] ON [dbo].[CFWztg_Admin]([Admin]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_Alexa_Day] ON [dbo].[CFWztg_Alexa_Day]([UserName], [Ad_ID], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_Area_Day] ON [dbo].[CFWztg_Area_Day]([UserName], [Ad_ID], [IpArea], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  CLUSTERED  INDEX [IX_CFWztg_IpAddress] ON [dbo].[CFWztg_IpAddress]([Ip_1], [Ip_2]) ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_LowUser] ON [dbo].[CFWztg_LowUser]([AdUserName], [LowUserName]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_OtherSet] ON [dbo].[CFWztg_OtherSet]([BName], [HName], [LName]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_SiteClass] ON [dbo].[CFWztg_SiteClass]([SiteClassName]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_User] ON [dbo].[CFWztg_User]([UserName]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_UserSite] ON [dbo].[CFWztg_UserSite]([UserName], [SiteUrl]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_Visit_Ly_Ly] ON [dbo].[CFWztg_Visit_Ly]([UserName], [AD_ID], [Ly], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_WebHeight_Day] ON [dbo].[CFWztg_WebHeight_Day]([UserName], [Ad_ID], [WebHeight], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_WebLeft_Day] ON [dbo].[CFWztg_WebLeft_Day]([UserName], [Ad_ID], [WebLeft], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_WebTop_Day] ON [dbo].[CFWztg_WebTop_Day]([UserName], [Ad_ID], [WebTop], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_CFWztg_WebWidth_Day] ON [dbo].[CFWztg_WebWidth_Day]([UserName], [Ad_ID], [WebWidth], [AddDate]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFWztg_AD] ADD 
	CONSTRAINT [DF_CFWztg_AD_AdState] DEFAULT (1) FOR [AdState],
	CONSTRAINT [DF_CFWztg_AD_AdWidth] DEFAULT (0) FOR [AdWidth],
	CONSTRAINT [DF_CFWztg_AD_AdHeight] DEFAULT (0) FOR [AdHeight],
	CONSTRAINT [DF_CFWztg_AD_AdShowType] DEFAULT (1) FOR [AdShowType],
	CONSTRAINT [DF_CFWztg_AD_ClickState] DEFAULT (1) FOR [ClickState],
	CONSTRAINT [DF_CFWztg_AD_OverClick] DEFAULT (0) FOR [OverClick],
	CONSTRAINT [DF_CFWztg_AD_AdRegUserState] DEFAULT (0) FOR [AdRegUserState],
	CONSTRAINT [DF_CFWztg_AD_AdRegUserDouble] DEFAULT (0) FOR [AdRegUserDouble],
	CONSTRAINT [DF_CFWztg_AD_AdDesc] DEFAULT ('-') FOR [AdDesc],
	CONSTRAINT [DF_CFWztg_AD_AdListShowState] DEFAULT ((-1)) FOR [AdListShowState],
	CONSTRAINT [DF_CFWztg_AD_AdSpareShowState] DEFAULT ((-1)) FOR [AdSpareShowState],
	CONSTRAINT [DF_CFWztg_AD_AdDeDuct_Rate] DEFAULT (0) FOR [AdDeDuct_Rate],
	CONSTRAINT [DF_CFWztg_AD_OtherSet] DEFAULT ('-') FOR [OtherSet],
	CONSTRAINT [DF_CFWztg_AD_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate]
GO

ALTER TABLE [dbo].[CFWztg_AD_Counter_Day] ADD 
	CONSTRAINT [DF_CFWztg_AD_Counter_Day_Display_Counter] DEFAULT (0) FOR [Display_Counter],
	CONSTRAINT [DF_CFWztg_AD_Counter_Day_Click_Counter] DEFAULT (0) FOR [Click_Counter],
	CONSTRAINT [DF_CFWztg_AD_Counter_Day_Reg_Counter] DEFAULT (0) FOR [Reg_Counter],
	CONSTRAINT [DF_CFWztg_AD_Counter_Day_Display_2_Counter] DEFAULT (0) FOR [Display_2_Counter],
	CONSTRAINT [DF_CFWztg_AD_Counter_Day_Click_2_Counter] DEFAULT (0) FOR [Click_2_Counter],
	CONSTRAINT [DF_CFWztg_AD_Counter_Day_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_CFWztg_AD_Counter_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_AD_Counter_Hour] ADD 
	CONSTRAINT [DF_CFWztg_AD_Counter_Hour_Display_Counter] DEFAULT (0) FOR [Display_Counter],
	CONSTRAINT [DF_CFWztg_AD_Counter_Hour_Click_Counter] DEFAULT (0) FOR [Click_Counter],
	CONSTRAINT [DF_CFWztg_AD_Counter_Hour_Reg_Counter] DEFAULT (0) FOR [Reg_Counter],
	CONSTRAINT [DF_CFWztg_AD_Counter_Hour_Display_2_Counter] DEFAULT (0) FOR [Display_2_Counter],
	CONSTRAINT [DF_CFWztg_AD_Counter_Hour_Click_2_Counter] DEFAULT (0) FOR [Click_2_Counter],
	CONSTRAINT [DF_CFWztg_AD_Counter_Hour_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_CFWztg_AD_Counter_Hour_AddHour] DEFAULT (convert(numeric(2),convert(varchar(2),getdate(),114))) FOR [AddHour],
	CONSTRAINT [PK_CFWztg_AD_Counter_Hour] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_AdUser] ADD 
	CONSTRAINT [DF_CFWztg_AdUser_Pwd] DEFAULT ('254a978baaa071ad') FOR [Pwd],
	CONSTRAINT [DF_CFWztg_AdUser_EMail] DEFAULT ('-') FOR [EMail],
	CONSTRAINT [DF_CFWztg_AdUser_QQ] DEFAULT ('-') FOR [QQ],
	CONSTRAINT [DF_CFWztg_AdUser_PageName] DEFAULT ('-') FOR [Phone],
	CONSTRAINT [DF_CFWztg_AdUser_PageUrl] DEFAULT ('-') FOR [Mobile],
	CONSTRAINT [DF_CFWztg_AdUser_WebSite] DEFAULT ('-') FOR [WebSite],
	CONSTRAINT [DF_CFWztg_AdUser_AdShowNum] DEFAULT (0) FOR [AdShowNum],
	CONSTRAINT [DF_CFWztg_AdUser_ComVisit] DEFAULT (0) FOR [ComVisit],
	CONSTRAINT [DF_CFWztg_AdUser_ComReg] DEFAULT (0) FOR [ComReg],
	CONSTRAINT [DF_CFWztg_AdUser_Total_Cent] DEFAULT (0) FOR [Total_Cent],
	CONSTRAINT [DF_CFWztg_AdUser_Spend_Cent] DEFAULT (0) FOR [Spend_Cent],
	CONSTRAINT [DF_CFWztg_AdUser_Spare_Cent] DEFAULT (0) FOR [Spare_Cent],
	CONSTRAINT [DF_CFWztg_AdUser_CheckCode] DEFAULT ('-') FOR [OrderRecCode],
	CONSTRAINT [DF_CFWztg_AdUser_Logintotal] DEFAULT (0) FOR [Logintotal],
	CONSTRAINT [DF_CFWztg_AdUser_LastLoginTime] DEFAULT (getdate()) FOR [LastLoginTime],
	CONSTRAINT [DF_CFWztg_AdUser_LastLoginIp] DEFAULT ('-') FOR [LastLoginIp],
	CONSTRAINT [DF_CFWztg_AdUser_State] DEFAULT ((-1)) FOR [State],
	CONSTRAINT [DF_CFWztg_AdUser_OtherSet] DEFAULT ('-') FOR [OtherSet],
	CONSTRAINT [DF_CFWztg_AdUser_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFWztg_AdUser_Cookies] DEFAULT (convert(varchar,datediff(second,'2000-1-1',getdate()))) FOR [Cookies],
	CONSTRAINT [PK_CFWztg_AdUser] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_CFWztg_AdUser_1] ON [dbo].[CFWztg_AdUser]([Cookies]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFWztg_AdUser_Enough] ADD 
	CONSTRAINT [DF_CFWztg_AdUser_Enough_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFWztg_AdUser_Enough_AdminDesc] DEFAULT ('-') FOR [AdminDesc]
GO

ALTER TABLE [dbo].[CFWztg_AdUser_Expend] ADD 
	CONSTRAINT [DF_CFWztg_AdUser_Expend_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFWztg_AdUser_Expend_ChaseState] DEFAULT (0) FOR [ChaseState],
	CONSTRAINT [DF_CFWztg_AdUser_Expend_ChaseClickNum] DEFAULT (0) FOR [ChaseClickNum],
	CONSTRAINT [DF_CFWztg_AdUser_Expend_ExpendState] DEFAULT (1) FOR [ExpendState],
	CONSTRAINT [DF_CFWztg_AdUser_Expend_ExPendAbortFeedBack] DEFAULT ('-') FOR [ExPendAbortFeedBack],
	CONSTRAINT [DF_CFWztg_AdUser_Expend_AdminCheck] DEFAULT (0) FOR [AdminCheck]
GO

ALTER TABLE [dbo].[CFWztg_AdUser_Order] ADD 
	CONSTRAINT [DF_CFWztg_AdUser_Order_TcObject] DEFAULT (1) FOR [TcObject],
	CONSTRAINT [DF_CFWztg_AdUser_Order_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFWztg_AdUser_Order_OrderOver] DEFAULT (0) FOR [OrderOver],
	CONSTRAINT [DF_CFWztg_AdUser_Order_UpUserName] DEFAULT ('-') FOR [UserName],
	CONSTRAINT [DF_CFWztg_AdUser_Order_SpendID] DEFAULT (0) FOR [SpendID],
	CONSTRAINT [PK_CFWztg_AdUser_Order] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_Admin] ADD 
	CONSTRAINT [DF_CFWztg_Admin_Pwd] DEFAULT ('254a978baaa071ad') FOR [Pwd],
	CONSTRAINT [DF_CFWztg_Admin_Title] DEFAULT ('˷վƹϵͳhttp://www.qqcf.com') FOR [Title],
	CONSTRAINT [DF_CFWztg_Admin_EffectTime] DEFAULT (24) FOR [EffectTime],
	CONSTRAINT [DF_CFWztg_Admin_LyMaxTotal] DEFAULT (1000) FOR [LyMaxTotal],
	CONSTRAINT [DF_CFWztg_Admin_IpMaxTotal] DEFAULT (1000) FOR [IpMaxTotal],
	CONSTRAINT [DF_CFWztg_Admin_LastDelTime] DEFAULT (getdate()) FOR [LastDelTime],
	CONSTRAINT [DF_CFWztg_Admin_LastCleanTime] DEFAULT (getdate()) FOR [LastCleanTime],
	CONSTRAINT [DF_CFWztg_Admin_LowSpendCent] DEFAULT (100) FOR [LowSpendCent],
	CONSTRAINT [DF_CFWztg_Admin_UserTcRate] DEFAULT (0) FOR [UserTcRate],
	CONSTRAINT [DF_CFWztg_Admin_UserOrderTcRate] DEFAULT (0) FOR [UserOrderTcRate],
	CONSTRAINT [DF_CFWztg_Admin_AdClickRate] DEFAULT (3) FOR [AdClickRate],
	CONSTRAINT [DF_CFWztg_Admin_ShowClickInfo] DEFAULT (0) FOR [ShowClickInfo],
	CONSTRAINT [DF_CFWztg_Admin_UserDeDuctState] DEFAULT ((-1)) FOR [UserDeDuctState],
	CONSTRAINT [DF_CFWztg_Admin_UserValid] DEFAULT (0) FOR [UserValid],
	CONSTRAINT [DF_CFWztg_Admin_AdUserValid] DEFAULT (0) FOR [AdUserValid],
	CONSTRAINT [DF_CFWztg_Admin_IncomeTop] DEFAULT ((-1)) FOR [IncomeTop],
	CONSTRAINT [DF_CFWztg_Admin_SpendTop] DEFAULT ((-1)) FOR [SpendTop],
	CONSTRAINT [DF_CFWztg_Admin_QQ_State] DEFAULT ((-1)) FOR [QQ_State],
	CONSTRAINT [DF_CFWztg_Admin_QQ_Code] DEFAULT ('10000') FOR [QQ_Code],
	CONSTRAINT [DF_CFWztg_Admin_RegType] DEFAULT (1) FOR [RegType],
	CONSTRAINT [DF_CFWztg_Admin_AccessPath] DEFAULT ('-') FOR [AccessPath],
	CONSTRAINT [DF_CFWztg_Admin_SqlServerIP] DEFAULT ('-') FOR [SqlServerIP],
	CONSTRAINT [DF_CFWztg_Admin_SqlServerDbName] DEFAULT ('-') FOR [SqlServerDbName],
	CONSTRAINT [DF_CFWztg_Admin_SqlServerLinkName] DEFAULT ('-') FOR [SqlServerLinkName],
	CONSTRAINT [DF_CFWztg_Admin_SqlServerLinkPassword] DEFAULT ('-') FOR [SqlServerLinkPassword],
	CONSTRAINT [DF_CFWztg_Admin_SaveRegTable] DEFAULT ('-') FOR [SaveRegTable],
	CONSTRAINT [DF_CFWztg_Admin_SaveRegUserName] DEFAULT ('-') FOR [SaveRegUserName],
	CONSTRAINT [DF_CFWztg_Admin_SaveRegPassword] DEFAULT ('-') FOR [SaveRegPassword],
	CONSTRAINT [DF_CFWztg_Admin_PassWordType] DEFAULT (1) FOR [PassWordType],
	CONSTRAINT [DF_CFWztg_Admin_RegUrl] DEFAULT ('http://www.qqcf.com') FOR [RegUrl],
	CONSTRAINT [DF_CFWztg_Admin_LoginUrl] DEFAULT ('http://www.qqcf.com') FOR [LoginUrl],
	CONSTRAINT [DF_CFWztg_Admin_SkinType] DEFAULT (2) FOR [SkinType],
	CONSTRAINT [DF_CFWztg_Admin_SkinColor] DEFAULT ('-') FOR [SkinColor],
	CONSTRAINT [DF_CFWztg_Admin_EmailSendType] DEFAULT (1) FOR [EmailSendType],
	CONSTRAINT [DF_CFWztg_Admin_JmailAddress] DEFAULT ('-') FOR [JmailAddress],
	CONSTRAINT [DF_CFWztg_Admin_JmailUser] DEFAULT ('-') FOR [JmailUser],
	CONSTRAINT [DF_CFWztg_Admin_JmailPassword] DEFAULT ('-') FOR [JmailPassword],
	CONSTRAINT [DF_CFWztg_Admin_OtherSet] DEFAULT ('-') FOR [OtherSet],
	CONSTRAINT [DF_CFWztg_Admin_LicensedCode] DEFAULT ('-') FOR [LicensedCode],
	CONSTRAINT [DF_CFWztg_Admin_Ip] DEFAULT ('-') FOR [Ip],
	CONSTRAINT [DF_CFWztg_Admin_LoginTotal] DEFAULT (0) FOR [LoginTotal],
	CONSTRAINT [DF_CFWztg_Admin_LastLoginTime] DEFAULT (getdate()) FOR [LastLoginTime],
	CONSTRAINT [DF_CFWztg_Admin_Cookies] DEFAULT ('-') FOR [Cookies],
	CONSTRAINT [PK_CFWztg_Admin] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_CFWztg_Admin_1] ON [dbo].[CFWztg_Admin]([Cookies]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFWztg_Alexa_Day] ADD 
	CONSTRAINT [DF_CFWztg_Alexa_Day_IpCounter_1] DEFAULT (0) FOR [IpCounter],
	CONSTRAINT [DF_CFWztg_Alexa_Day_IpCounter] DEFAULT (0) FOR [AlexaCounter],
	CONSTRAINT [DF_CFWztg_Alexa_Day_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_CFWztg_Alexa_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_Area_Day] ADD 
	CONSTRAINT [DF_CFWztg_Area_Day_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFWztg_Area_Day_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_CFWztg_Area_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_Gbook] ADD 
	CONSTRAINT [DF_CFWztg_Gbook_Assort] DEFAULT (1) FOR [Assort],
	CONSTRAINT [DF_CFWztg_Gbook_AddTime] DEFAULT (getdate()) FOR [AddTime]
GO

ALTER TABLE [dbo].[CFWztg_IpAddress] ADD 
	CONSTRAINT [PK_CFWztg_IpAddress] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_LowUser] ADD 
	CONSTRAINT [DF_CFWztg_LowUser_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_CFWztg_LowUser_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [PK_CFWztg_LowUser] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_OtherSet] ADD 
	CONSTRAINT [PK_CFWztg_OtherSet] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_SiteClass] ADD 
	CONSTRAINT [PK_CFWztg_SiteClass] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_Spend] ADD 
	CONSTRAINT [DF_CFWztg_Spend_Spend_Desc] DEFAULT ('-') FOR [SpendDesc],
	CONSTRAINT [DF_CFWztg_Spend_SpendTime] DEFAULT (getdate()) FOR [SpendTime],
	CONSTRAINT [DF_CFWztg_Spend_SpendState] DEFAULT (1) FOR [SpendState],
	CONSTRAINT [DF_CFWztg_Spend_SpendAbortFeedBack] DEFAULT ('-') FOR [SpendAbortFeedBack],
	CONSTRAINT [DF_CFWztg_Spend_SpendType] DEFAULT (0) FOR [SpendType],
	CONSTRAINT [DF_CFWztg_Spend_AdminCheck] DEFAULT (0) FOR [AdminCheck],
	CONSTRAINT [DF_CFWztg_Spend_AdminDesc] DEFAULT ('-') FOR [AdminDesc],
	CONSTRAINT [DF_CFWztg_Spend_AdminSpendTime] DEFAULT (getdate()) FOR [AdminSpendTime]
GO

ALTER TABLE [dbo].[CFWztg_SysInfo] ADD 
	CONSTRAINT [DF_CFWztg_SysInfo_Assort] DEFAULT (1) FOR [Assort],
	CONSTRAINT [DF_CFWztg_SysInfo_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate]
GO

ALTER TABLE [dbo].[CFWztg_Temp] ADD 
	CONSTRAINT [DF_CFWztg_Temp_MyID] DEFAULT (0) FOR [MyID],
	CONSTRAINT [DF_CFWztg_Temp_MyStr] DEFAULT ('-') FOR [MyStr]
GO

ALTER TABLE [dbo].[CFWztg_User] ADD 
	CONSTRAINT [DF_CFWztg_User_Pwd] DEFAULT ('254a978baaa071ad') FOR [Pwd],
	CONSTRAINT [DF_CFWztg_User_PasswordAsk] DEFAULT ('Ĭش1234,޸ĳɱ!') FOR [PasswordAsk],
	CONSTRAINT [DF_CFWztg_User_PasswordAnswer] DEFAULT ('52d04dc20036dbd8') FOR [PasswordAnswer],
	CONSTRAINT [DF_CFWztg_User_EMail] DEFAULT ('-') FOR [EMail],
	CONSTRAINT [DF_CFWztg_User_QQ] DEFAULT ('-') FOR [QQ],
	CONSTRAINT [DF_CFWztg_User_PageName] DEFAULT ('-') FOR [Phone],
	CONSTRAINT [DF_CFWztg_User_PageUrl] DEFAULT ('-') FOR [Mobile],
	CONSTRAINT [DF_CFWztg_User_WebSite] DEFAULT ('-') FOR [WebSite],
	CONSTRAINT [DF_CFWztg_User_AdUserName] DEFAULT ('-') FOR [AdUserName],
	CONSTRAINT [DF_CFWztg_User_PayType] DEFAULT (1) FOR [PayType],
	CONSTRAINT [DF_CFWztg_User_Bank_Address] DEFAULT ('-') FOR [Bank_Address],
	CONSTRAINT [DF_CFWztg_User_Bank_UserName] DEFAULT ('-') FOR [Bank_UserName],
	CONSTRAINT [DF_CFWztg_User_Bank_UserCode] DEFAULT ('-') FOR [Bank_UserCode],
	CONSTRAINT [DF_CFWztg_User_Post_Address] DEFAULT ('-') FOR [Pay_B],
	CONSTRAINT [DF_CFWztg_User_Post_UserNmae] DEFAULT ('-') FOR [Pay_C],
	CONSTRAINT [DF_CFWztg_User_Pay_C1] DEFAULT ('-') FOR [Pay_D],
	CONSTRAINT [DF_CFWztg_User_Total_Cent] DEFAULT (0) FOR [Total_Cent],
	CONSTRAINT [DF_CFWztg_User_Spend_Cent] DEFAULT (0) FOR [Spend_Cent],
	CONSTRAINT [DF_CFWztg_User_Spare_Cent] DEFAULT (0) FOR [Spare_Cent],
	CONSTRAINT [DF_CFWztg_User_AdShowNum] DEFAULT (0) FOR [AdShowNum],
	CONSTRAINT [DF_CFWztg_User_ComVisit] DEFAULT (0) FOR [ComVisit],
	CONSTRAINT [DF_CFWztg_User_ComReg] DEFAULT (0) FOR [ComReg],
	CONSTRAINT [DF_CFWztg_User_DeDuct_Rate] DEFAULT (0) FOR [DeDuct_Rate],
	CONSTRAINT [DF_CFWztg_User_UserAllSite] DEFAULT ('-') FOR [UserAllSite],
	CONSTRAINT [DF_CFWztg_User_Logintotal] DEFAULT (0) FOR [Logintotal],
	CONSTRAINT [DF_CFWztg_User_LastLoginTime] DEFAULT (getdate()) FOR [LastLoginTime],
	CONSTRAINT [DF_CFWztg_User_LastLoginIp] DEFAULT ('-') FOR [LastLoginIp],
	CONSTRAINT [DF_CFWztg_User_State] DEFAULT ((-1)) FOR [State],
	CONSTRAINT [DF_CFWztg_User_OtherSet] DEFAULT ('-') FOR [OtherSet],
	CONSTRAINT [DF_CFWztg_User_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFWztg_User_AdminDesc] DEFAULT ('-') FOR [AdminDesc],
	CONSTRAINT [DF_CFWztg_User_Cookies] DEFAULT (convert(varchar,datediff(second,'2000-1-1',getdate()))) FOR [Cookies],
	CONSTRAINT [PK_CFWztg_User] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_CFWztg_User_1] ON [dbo].[CFWztg_User]([Cookies]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
GO

ALTER TABLE [dbo].[CFWztg_UserDeduct] ADD 
	CONSTRAINT [DF_CFWztg_UserDeduct_AddTime] DEFAULT (getdate()) FOR [AddTime]
GO

ALTER TABLE [dbo].[CFWztg_UserSite] ADD 
	CONSTRAINT [DF_CFWztg_UserSite_SiteState] DEFAULT (1) FOR [SiteState],
	CONSTRAINT [DF_CFWztg_UserSite_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_CFWztg_UserSite] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_Visit_Ip] ADD 
	CONSTRAINT [DF_CFWztg_Visit_Ip_IpArea] DEFAULT ('-') FOR [IpArea],
	CONSTRAINT [DF_CFWztg_Visit_Ip_IpArea_2] DEFAULT (1) FOR [IpArea_2],
	CONSTRAINT [DF_CFWztg_Visit_Ip_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_CFWztg_Visit_Ip_AddTime] DEFAULT (getdate()) FOR [AddTime]
GO

ALTER TABLE [dbo].[CFWztg_Visit_Ly] ADD 
	CONSTRAINT [DF_CFWztg_Visit_Ly_Counter] DEFAULT (0) FOR [IpCounter],
	CONSTRAINT [DF_CFWztg_Visit_Ly_IpCounter_2] DEFAULT (0) FOR [IpCounter_2],
	CONSTRAINT [DF_CFWztg_Visit_Ly_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [DF_CFWztg_Visit_Ly_AddTime] DEFAULT (getdate()) FOR [AddTime],
	CONSTRAINT [DF_CFWztg_Visit_Ly_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [PK_CFWztg_Visit_Ly] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_WebHeight_Day] ADD 
	CONSTRAINT [DF_CFWztg_WebHeight_Day_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFWztg_WebHeight_Day_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_CFWztg_WebHeight_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_WebLeft_Day] ADD 
	CONSTRAINT [DF_CFWztg_WebLeft_Day_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFWztg_WebLeft_Day_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_CFWztg_WebLeft_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_WebTop_Day] ADD 
	CONSTRAINT [DF_CFWztg_WebTop_Day_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFWztg_WebTop_Day_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_CFWztg_WebTop_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CFWztg_WebWidth_Day] ADD 
	CONSTRAINT [DF_CFWztg_WebWidth_Day_IpCounter] DEFAULT (1) FOR [IpCounter],
	CONSTRAINT [DF_CFWztg_WebWidth_Day_AddDate] DEFAULT (convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))) FOR [AddDate],
	CONSTRAINT [PK_CFWztg_WebWidth_Day] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE Proc CFWztg_AdGet_Proc
@AdDuct Int,
@UserName Varchar(50),
@Ad_ID Int,
@ClickState Int,
@Unit_Cent Numeric(18,5),
@OverClick Int,
@TotalClick Int,
@DayTj Int,
@HourTj Int
As
/*
====================================================
 *  @Author      
 *  @Web        http://www.qqcf.com
 *  @Describe   ʾ
====================================================
 */
Declare 	 
@ReturnFlag int,
@RowNum int,
@AddDate datetime,
@AddHour int
Set @AddDate=convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))
Set @AddHour=convert(numeric(2),convert(varchar(2),getdate(),114))
Set nocount on
IF @@TRANCOUNT > 0 ROLLBACK
BEGIN Transaction AdGetTrans
Set @ReturnFlag=0
If @AdDuct<>0
Begin
If @ClickState = 2
Begin
Update CFWztg_AD Set OverClick = OverClick+1 Where ID = @Ad_ID
End 
If @DayTj = 1
Begin
Update CFWztg_AD_Counter_Day Set Display_2_Counter = Display_2_Counter+1 Where UserName = @UserName And Ad_ID = @Ad_ID And AddDate = @AddDate
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_AD_Counter_Day (UserName,Ad_ID,Display_2_Counter) Values (@UserName, @Ad_ID, 1)
End
End
If @HourTj = 1
Begin
Update CFWztg_AD_Counter_Hour Set Display_2_Counter = Display_2_Counter + 1 Where UserName = @UserName And Ad_ID = @Ad_ID And AddDate = @AddDate And AddHour = @AddHour
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_AD_Counter_Hour (UserName,Ad_ID,Display_2_Counter) Values (@UserName , @Ad_ID ,1)
End
End
If @OverClick >= @TotalClick
Begin
Update CFWztg_AD Set AdState=4 Where ID = @Ad_ID
End
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
Commit Transaction AdGetTrans
Return
End
Update CFWztg_User Set AdShowNum=AdShowNum+1 Where UserName = @UserName
If @DayTj = 1
Begin
Update CFWztg_AD_Counter_Day Set Display_Counter = Display_Counter+1,Display_2_Counter = Display_2_Counter+1 Where UserName = @UserName And Ad_ID = @Ad_ID And AddDate = @AddDate
Set @RowNum = @@rowcount
If @RowNum = 0
Begin
Insert Into CFWztg_AD_Counter_Day (UserName,Ad_ID,Display_Counter,Display_2_Counter) values(@UserName, @Ad_ID, 1 ,1)
End
End
If @HourTj = 1
Begin
Update CFWztg_AD_Counter_Hour Set Display_Counter = Display_Counter+1,Display_2_Counter = Display_2_Counter+1 Where UserName = @UserName And Ad_ID = @Ad_ID And AddDate = @AddDate And AddHour = @AddHour
Set @RowNum = @@rowcount
If @RowNum = 0
Begin
Insert Into CFWztg_AD_Counter_Hour (UserName,Ad_ID,Display_Counter,Display_2_Counter) values(@UserName, @Ad_ID, 1, 1)
End
End
If @ClickState = 2
Begin
Update CFWztg_User Set AdShowNum = AdShowNum +1,Total_Cent=Total_Cent + @Unit_Cent,Spare_Cent=Spare_Cent + @Unit_Cent Where UserName = @UserName
Update CFWztg_AD Set OverClick = OverClick +1 Where ID = @Ad_ID
If @OverClick >= @TotalClick
Begin
Update CFWztg_AD Set AdState=4 Where ID = @Ad_ID
End
End
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
Commit Transaction AdGetTrans
Return
Error_handler: 
BEGIN
RollBack Transaction AdGetTrans
Return 
END

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE Proc CFWztg_AdGoto_Proc
@IpGuardLevel Int,
@IpSegmentGuard Int,
@DbOutDateAutoDel_2 Int,
@OutDateAutoDelTimes Int,
@IpAreaSwitch Int,
@DayTj Int,
@HourTj Int,
@AreaTj Int,
@LyTj Int,
@AlexaTj Int,
@WebHeightTj Int,
@WebLeftTj Int,
@WebTopTj Int,
@WebWidthTj Int,
@EffectTime Int,
@LastDelTime Varchar(50),
@DeDuctClick Int,
@LyMaxTotal Int,
@IpMaxTotal Int,
@UserName Varchar(50),
@Ad_ID Int,
@ClickState Int,
@Unit_Cent Numeric(18,5),
@OverClick Int,
@TotalClick Int,
@Ip_1 Int,
@Ip_2 Int,
@Ip_3 Int,
@Ip_4 Int,
@Ip_All BigInt,
@IpNum BigInt,
@Ip Varchar(50),
@Ly Varchar(255),
@AgentStr Varchar(1000),
@Alexa Int,
@WebWidth Int,
@WebHeight Int,
@WebTop Int,
@WebLeft Int
As
/*
====================================================
 *  @Author     ˷
 *  @Web        http://www.qqcf.com
 *  @Describe   
====================================================
 */
Declare
@ReturnFlag int,
@SysSetGet int,
@IpArea varchar(100),
@IpArea_2 Int,
@sql varchar(1000),
@Mycounter int,
@Mycounter_2 int,
@RowNum int,
@AddDate varchar(50),
@AddHour int
Set nocount on
IF @@TRANCOUNT > 0 ROLLBACK
BEGIN Transaction AdGotoTrans
Set @ReturnFlag = 0
Set @SysSetGet = 0
Set @AddDate=convert(datetime,(datename(year,getdate()) + '-' + datename(month,getdate()) + '-' + datename(day,getdate())))
Set @AddHour=convert(numeric(2),convert(varchar(2),getdate(),114))
If @IpGuardLevel=1
Begin
Select @Mycounter = Count(ID) From CFWztg_Visit_Ip Where Ip_All = @Ip_All And DateDiff(n,Addtime,Getdate()) <= @EffectTime
End
If @IpGuardLevel=2
Begin
Select @Mycounter = Count(ID) From CFWztg_Visit_Ip Where UserName = @UserName And Ip_All = @Ip_All And DateDiff(n,Addtime,Getdate()) <= @EffectTime
End
If @IpGuardLevel=3
Begin
Select @Mycounter = Count(ID) From CFWztg_Visit_Ip Where UserName = @UserName And Ad_ID = @Ad_ID And Ip_All = @Ip_All And DateDiff(n,Addtime,Getdate()) <= @EffectTime
End
If @Mycounter>0
Begin
Set @ReturnFlag = 1
Commit Transaction AdGotoTrans
Select @ReturnFlag As ReturnFlag
Return
End
If @IpSegmentGuard=1
Begin
Select Top 10 @Mycounter = Count(ID) From CFWztg_Visit_Ip Where ID IN (Select Top 10 ID From CFWztg_Visit_Ip Where UserName = @UserName Order By ID Desc) And Ip_1 = @Ip_1 And Ip_2 = @Ip_2
If @Mycounter>=2
Begin
Set @ReturnFlag = 1
Commit Transaction AdGotoTrans
Select @ReturnFlag As ReturnFlag
Return
End
Select Top 10 @Mycounter = Count(ID) From CFWztg_Visit_Ip Where ID IN (Select Top 10 ID From CFWztg_Visit_Ip Where UserName = @UserName Order By ID Desc) And Ip_1 = @Ip_1
If @Mycounter>=5
Begin
Set @ReturnFlag = 1
Commit Transaction AdGotoTrans
Select @ReturnFlag As ReturnFlag
Return
End
End
If @DeDuctClick <>0
Begin
If @ClickState = 1
Begin
Update CFWztg_AD Set OverClick=OverClick+1 Where ID = @Ad_ID
End
If @LyTj=1
Begin
Update CFWztg_Visit_Ly Set IpCounter_2=IpCounter_2+1,Ip = @Ip, LastTime = getdate() Where UserName = @UserName And Ad_ID = @Ad_ID And Ly = @Ly And DateDiff(d,AddDate,GetDate())=0
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_Visit_Ly (UserName,Ad_ID,Ip,Ly,IpCounter,IpCounter_2) Values (@UserName, @Ad_ID, @Ip , @Ly ,0 ,1)
End
End
If @DayTj = 1
Begin
Update CFWztg_AD_Counter_Day Set Click_2_Counter=Click_2_Counter+1 Where UserName = @UserName And Ad_ID = @Ad_ID And AddDate = @AddDate
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_AD_Counter_Day (UserName,Ad_ID,Click_2_Counter) Values (@UserName, @Ad_ID, 1)
End
End
If @HourTj = 1
Begin
Update CFWztg_AD_Counter_Hour Set Click_2_Counter = Click_2_Counter + 1 Where UserName = @UserName And Ad_ID = @Ad_ID And AddDate = @AddDate And AddHour = @AddHour
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_AD_Counter_Hour (UserName,Ad_ID,Click_2_Counter) Values (@UserName , @Ad_ID ,1)
End
End
If @DeDuctClick = 1
Begin
Set @ReturnFlag = 2
End
If @DeDuctClick = 2
Begin
Set @ReturnFlag = 3
End
If @OverClick >= @TotalClick
Begin
Update CFWztg_AD Set AdState=4 Where ID = @Ad_ID
End
Commit Transaction AdGotoTrans
Select @ReturnFlag As ReturnFlag
Return
End
Set @IpArea = '-'
Set @IpArea_2=1
If @IpAreaSwitch=1
Begin
Select @IpArea = Area , @IpArea_2 = Area_2 from CFWztg_IpAddress where Ip_1 <= @IpNum and Ip_2 >= @IpNum
If @IpArea Is Null
Begin
Set @IpArea = '-'
Set @IpArea_2=1
End
End
Insert Into CFWztg_Visit_Ip (UserName,Ad_ID,Ip_1,Ip_2,Ip_3,Ip_4,Ip_All,Ip,IpArea,IpArea_2,Ly,AgentStr,Alexa,WebWidth,WebHeight,WebTop,WebLeft) Values (@UserName, @Ad_ID, @Ip_1 , @Ip_2 , @Ip_3 , @Ip_4 , @Ip_All , @Ip, @IpArea, @IpArea_2, @Ly, @AgentStr , @Alexa, @WebWidth, @WebHeight, @WebTop, @WebLeft)
If @LyTj=1
Begin
Update CFWztg_Visit_Ly Set IpCounter=IpCounter+1,IpCounter_2=IpCounter_2+1,Ip = @Ip, LastTime = getdate() Where UserName = @UserName And Ad_ID = @Ad_ID And Ly = @Ly And DateDiff(d,AddDate,GetDate())=0
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_Visit_Ly (UserName,Ad_ID,Ip,Ly,IpCounter,IpCounter_2) Values (@UserName, @Ad_ID, @Ip , @Ly ,1 ,1)
End
End
If @AlexaTj=1
Begin
If @Alexa = -1
Begin
Update CFWztg_Alexa_Day Set IpCounter = IpCounter+1,AlexaCounter = AlexaCounter +1 Where UserName = @UserName And Ad_ID = @Ad_ID And DateDiff(d,AddDate,GetDate())=0
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_Alexa_Day (UserName , Ad_ID , IpCounter , AlexaCounter) Values (@UserName , @Ad_ID , 1 , 1)
End
End
Else
Begin
Update CFWztg_Alexa_Day Set IpCounter = IpCounter+1 Where UserName = @UserName And Ad_ID = @Ad_ID And DateDiff(d,AddDate,GetDate())=0
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_Alexa_Day (UserName , Ad_ID , IpCounter) Values (@UserName , @Ad_ID ,1)
End
End
End
If @AreaTj=1
Begin
Update CFWztg_Area_Day Set IpCounter = IpCounter+1 Where UserName = @UserName And Ad_ID = @Ad_ID And IpArea = @IpArea And DateDiff(d,AddDate,GetDate())=0
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_Area_Day (UserName , Ad_ID , IpArea) Values (@UserName , @Ad_ID , @IpArea)
End
End
If @WebWidthTj=1
Begin
Update CFWztg_WebWidth_Day Set IpCounter=IpCounter+1 Where UserName = @UserName And Ad_ID = @Ad_ID And DateDiff(d,AddDate,GetDate())=0 And WebWidth = @WebWidth
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_WebWidth_Day (UserName , Ad_ID , WebWidth) Values (@UserName , @Ad_ID , @WebWidth)
End
End
If @WebHeightTj=1
Begin
Update CFWztg_WebHeight_Day Set IpCounter=IpCounter+1 Where UserName = @UserName And Ad_ID = @Ad_ID And DateDiff(d,AddDate,GetDate())=0 And WebHeight = @WebHeight
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_WebHeight_Day (UserName , Ad_ID , WebHeight) Values (@UserName , @Ad_ID , @WebHeight)
End
End
If @WebTopTj=1
Begin
Update CFWztg_WebTop_Day Set IpCounter=IpCounter+1 Where UserName = @UserName And Ad_ID = @Ad_ID And DateDiff(d,AddDate,GetDate())=0 And WebTop = @WebTop
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_WebTop_Day (UserName , Ad_ID , WebTop) Values (@UserName , @Ad_ID , @WebTop)
End
End
If @WebLeftTj=1
Begin
Update CFWztg_WebLeft_Day Set IpCounter=IpCounter+1 Where UserName = @UserName And Ad_ID = @Ad_ID And DateDiff(d,AddDate,GetDate())=0 And WebLeft = @WebLeft
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_WebLeft_Day (UserName , Ad_ID , Webleft) Values (@UserName , @Ad_ID , @Webleft)
End
End
If @DayTj=1
Begin
Update CFWztg_AD_Counter_Day Set Click_Counter=Click_Counter+1,Click_2_Counter=Click_2_Counter+1 Where UserName = @UserName And Ad_ID = @Ad_ID And AddDate = @AddDate
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_AD_Counter_Day (UserName,Ad_ID,Click_Counter,Click_2_Counter) Values (@UserName, @Ad_ID, 1 ,1)
End
End
If @HourTj=1
Begin
Update CFWztg_AD_Counter_Hour Set Click_Counter=Click_Counter+1,Click_2_Counter=Click_2_Counter+1 Where UserName = @UserName And Ad_ID = @Ad_ID And AddDate = @AddDate And AddHour = @AddHour
Set @RowNum = @@rowcount
If @RowNum=0
Begin
Insert Into CFWztg_AD_Counter_Hour (UserName,Ad_ID,Click_Counter,Click_2_Counter) Values (@UserName , @Ad_ID ,1 ,1)
End
End
If @DbOutDateAutoDel_2 = 1
Begin
If DateDiff(n, @LastDelTime,GetDate())>@OutDateAutoDelTimes Or DateDiff(n,GetDate(), @LastDelTime)>@OutDateAutoDelTimes
Begin
Set @Sql='Delete From CFWztg_Visit_Ly Where ID<(Select Min(id) From CFWztg_Visit_Ly Where ID In (Select Top ' +  convert(varchar, @LyMaxTotal ) +  ' Id From CFWztg_Visit_Ly Order By Id Desc))'
Exec(@sql)
Set @Sql='Delete From CFWztg_Visit_Ip Where ID<(Select Min(id) From CFWztg_Visit_Ip Where ID In (Select Top ' + convert(varchar, @IpMaxTotal ) + ' Id From CFWztg_Visit_Ip Order By Id Desc))'
Exec(@sql)    
Update CFWztg_Admin Set LastDelTime=GetDate()
Set @SysSetGet = 1
End
End
If @ClickState = 1
Begin
Update CFWztg_User Set ComVisit=ComVisit+1,Total_Cent=Total_Cent + @Unit_Cent,Spare_Cent=Spare_Cent + @Unit_Cent Where UserName = @UserName
Update CFWztg_AD Set OverClick=OverClick+1 Where ID = @Ad_ID
If @OverClick >= @TotalClick
Begin
Update CFWztg_AD Set AdState=4 Where ID = @Ad_ID
End
End
IF @@error<>0
Begin
Set @ReturnFlag=-1
goto error_handler
End
Commit Transaction AdGotoTrans
Select @ReturnFlag As ReturnFlag , @SysSetGet As SysSetGet
Return
Error_handler: 
BEGIN
RollBack Transaction AdGotoTrans
Return 
END

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE Proc CFWztg_Clear_Proc
@HourKeepDay Int,
@DayKeepDay Int,
@AlexaKeepDay Int,
@IpAreaKeepDay Int,
@WebWidthKeepDay Int,
@WebHeightKeepDay Int,
@WebTopKeepDay Int,
@WebLeftKeepDay Int
As
/*
====================================================
 *  @Author     ˷
 *  @Web      http://www.qqcf.com
 *  @Describe   
====================================================
 */
Set nocount on
IF @@TRANCOUNT > 0 ROLLBACK
BEGIN Transaction ClearTrans
Delete From CFWztg_AD_Counter_Hour Where DateDiff(d,AddDate,GetDate()) >= @HourKeepDay
Delete From CFWztg_AD_Counter_Day Where DateDiff(d,AddDate,GetDate()) >= @DayKeepDay
Delete From CFWztg_Alexa_Day Where DateDiff(d,AddDate,GetDate()) >= @AlexaKeepDay
Delete From CFWztg_Area_Day Where DateDiff(d,AddDate,GetDate()) >= @IpAreaKeepDay
Delete From CFWztg_WebWidth_Day Where DateDiff(d,AddDate,GetDate()) >= @WebWidthKeepDay
Delete From CFWztg_WebHeight_Day Where DateDiff(d,AddDate,GetDate()) >= @WebHeightKeepDay
Delete From CFWztg_WebTop_Day Where DateDiff(d,AddDate,GetDate()) >= @WebTopKeepDay
Delete From CFWztg_WebLeft_Day Where DateDiff(d,AddDate,GetDate()) >= @WebLeftKeepDay
IF @@error<>0
Begin
goto error_handler
End
Commit Transaction ClearTrans
Return
Error_handler: 
BEGIN
RollBack Transaction ClearTrans
Return
END

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

