Simple Ban Script

[Alexsh]

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:

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

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!

 

[Xakzi]

looks pretty awesome, works perfectly +1

Edit: IT IS PRETTY AWESOME***

 

[Alexsh]

Thanks :]

 

[Sanctin]

Cool. Thanked

 

[Hexadecimal]

Looks nice. Well done.

-BGxApixen

 

[Alexsh]

As a side not to anyone using this, reomove the antisql() around the $_POST and $_GET values. This was a function that I did not include in this script.

 

[ThePecko]

how to ban someones ip?

 

[Alexsh]

how to ban someones ip?

To ban it in-game use IPCut.ini, to ban someone via your website use a simple IP ban script to disallow their IP address to view your website. For example:

1st Get their IP:

function getIp()
{
    if (!empty($_SERVER['HTTP_CLIENT_IP']))
    {
      $ip=$_SERVER['HTTP_CLIENT_IP'];
    }
    elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))
    {
      $ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
    }
    else
    {
      $ip=$_SERVER['REMOTE_ADDR'];
    }
    return $ip;
}

2nd Make a table in the ACCOUNT_DBF to insert IP addresses

You can make this yourself

3rd Disallow it from the website:

$ip = getIp();
$checkban = mssql_query("SELECT * FROM ACCOUNT_DBF.dbo.WEB_BAN_TBL WHERE ip = '$ip'");
if(mssql_num_rows($checkban) != '0'){ 
header("Location: http://google.com");
}

 

[Langstra]

Is this script also available in SQL, for MSSQL.

 

[rad92]

yes it is

 

[Mootie]

To ban it in-game use IPCut.ini, to ban someone via your website use a simple IP ban script to disallow their IP address to view your website. For example:

1st Get their IP:

function getIp()
{
    if (!empty($_SERVER['HTTP_CLIENT_IP']))
    {
      $ip=$_SERVER['HTTP_CLIENT_IP'];
    }
    elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))
    {
      $ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
    }
    else
    {
      $ip=$_SERVER['REMOTE_ADDR'];
    }
    return $ip;
}

2nd Make a table in the ACCOUNT_DBF to insert IP addresses

You can make this yourself

3rd Disallow it from the website:

$ip = getIp();
$checkban = mssql_query("SELECT * FROM ACCOUNT_DBF.dbo.WEB_BAN_TBL WHERE ip = '$ip'");
if(mssql_num_rows($checkban) != '0'){ 
header("Location: http://google.com");
}

You can just check the IP at LOGIN_STR. That allows you to not have to duck with inis.

 

[Prkchop]

All my functions are undefined? so it wont work?

 

[anth0ny989]

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:

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

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!

yoww, i got this weird problem, when i go to 127.0.0.1/ban.php
my apache gets crashed. i dont know why. but some of my php script are working like my register script.

have an idea on what's wrong? i used xampp 1.7.3
help me please :

 

[Frostivus]

Can someone please reupload the ban script? thanks