Hi,
today i'd like to release my own register script created since 4 years, working fine without any problem
Here is a photos
note : Captcha not appear cause the captcha script connected online so not working in local :)
this after register successfully
insert this code in kal_auth as stored
Download linkCode:USE [kal_auth]GO IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Login_Type]') AND type = 'D') BEGIN ALTER TABLE [dbo].[Login] DROP CONSTRAINT [DF_Login_Type] END GO IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Login_ExpTime]') AND type = 'D') BEGIN ALTER TABLE [dbo].[Login] DROP CONSTRAINT [DF_Login_ExpTime] END GO USE [kal_auth] GO /****** Object: Table [dbo].[Login] Script Date: 07/18/2012 00:51:04 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Login]') AND type in (N'U')) DROP TABLE [dbo].[Login] GO USE [kal_auth] GO /****** Object: Table [dbo].[Login] Script Date: 07/18/2012 00:51:04 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Login]( [UID] [int] IDENTITY(1,1) NOT NULL, [ID] [varchar](16) NOT NULL, [PWD] [varbinary](16) NOT NULL, [EMAIL] [varchar](100) NULL, [question] [varchar](30) NULL, [answer] [varchar](30) NULL, [REFERNAME] [varchar](30) NULL, [Birth] [smalldatetime] NULL, [Type] [tinyint] NULL, [ExpTime] [int] NULL, [Info] [int] NULL, CONSTRAINT [PK_Login] PRIMARY KEY CLUSTERED ( [UID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_Login] UNIQUE NONCLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[Login] ADD CONSTRAINT [DF_Login_Type] DEFAULT ((4)) FOR [Type] GO ALTER TABLE [dbo].[Login] ADD CONSTRAINT [DF_Login_ExpTime] DEFAULT ((0)) FOR [ExpTime] GO
http://speedy.sh/H24AA/Avenger-Reg.rar
enjoy
Credit : DELUXX





Reply With Quote


