Tbl_log_block_account

[Alexsh]

I got bored and decided to look through some of the procedures for the account database, whilst looking I came across the ban/unban procedure. I then re-created the table to make it function correctly to ban/unban accounts. Simply execute the following query into your account database and enjoy

USE [ACCOUNT_DBF]
GO

/****** Object:  Table [dbo].[TBL_LOG_BLOCK_ACCOUNT]    Script Date: 02/19/2010 05:33:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[TBL_LOG_BLOCK_ACCOUNT](
	[account] [varchar](50) NOT NULL,
	[code1] [char](8) NOT NULL,
	[code2] [char](8) NOT NULL,
	[code3] [char](8) NOT NULL,
	[old_block_day] [char](8) NOT NULL,
	[old_web_day] [char](8) NOT NULL,
	[block_day] [char](8) NOT NULL,
	[web_day] [char](8) NOT NULL,
	[input_id] [char](20) NOT NULL,
	[input_day] [datetime] NOT NULL,
	[reason] [varchar](500) NOT NULL,
	[num] [nchar](10) NOT NULL,
	[r_web_day] [char](8) NULL,
	[r_block_day] [char](8) NULL,
	[r_input_day] [char](8) NULL,
	[r_reason] [varchar](500) NULL,
	[r_input_id] [varchar](30) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[TBL_LOG_BLOCK_ACCOUNT] ADD  CONSTRAINT [DF_TBL_LOG_BLOCK_ACCOUNT_num]  DEFAULT ((0)) FOR [num]
GO

Thank me if it helped? <3

[MentaL]

[ancelmylove]

how to ban character?

[Alexsh]

A stored procedure in the ACCOUNT_DBF called "usp_BAN_UNBAN"

[ecKo9321]

gg nab

[Alexsh]

gg nab

You're the nab.

when you get bored, you can give me it