Experienced Elementalist
- Joined
- Sep 8, 2009
- Messages
- 296
- Reaction score
- 78
This is a script to ban in-game accounts, using it you can ban accounts for a period of time or permanently. Before using it, please ensure that all accounts on your server (Current Ones and Ones Being Registered) have the following values:
***Edit your register script so that when new accounts are made all of the above fields are set to '' so that they are empty, yet NOT NULL.***
Table:
TBL_LOG_BLOCK_ACCOUNT
Screenies:
Ban Script: Download
Note: All End Dates for periodic banning must be entered in YYYYMMDD format!
Code:
UPDATE account_tbl_detail set BlockTime = ''
UPDATE account_tbl_detail set WebTime = ''
UPDATE account_tbl_detail set EndTime = ''
***Edit your register script so that when new accounts are made all of the above fields are set to '' so that they are empty, yet NOT NULL.***
Table:
TBL_LOG_BLOCK_ACCOUNT
Code:
USE [ACCOUNT_DBF]
GO
/****** Object: Table [dbo].[TBL_LOG_BLOCK_ACCOUNT] Script Date: 02/05/2011 18:50:47 ******/
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
Screenies:
Ban Script: Download
You must be registered to see links
Note: All End Dates for periodic banning must be entered in YYYYMMDD format!
Last edited: