Updated Ban Procedure

[Alexsh]

I've decided to update the current ban procedure in the account_dbf, i've updated it so you can set an unban time or "length" on it. By entering a certain date for length such as 20100218 this means that February 18th would be the last ban day, the account would then be able to login the next day, being February 19th.

So anyway, here it is. Thank me if you use it.

USE [ACCOUNT_DBF]
GO
/****** Object:  StoredProcedure [dbo].[usp_BAN_UNBAN]    Script Date: 02/19/2010 10:20:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[usp_BAN_UNBAN]
@section int,	-- 1 : BAN, 2 : UNBAN
@account varchar(32),
@gPotatoID int,	-- Not Used
@reason varchar(500),
@length char(8)
as
/*
	Created By soondai@aeonsoft.co.kr
	Create Date : 2008-01-24

	@section   =>   1 : BAN,  2 : UNBAN
	@gPotatoID   =>   Not Used Parameter for Flyff
	@length   =>   length of ban
*/
set nocount on
set xact_abort on

-- Check Account
if not exists (select * from ACCOUNT_TBL where account = @account)
begin
	select -1	-- The account does not exist
end
else
begin
/*****************************************************
			BAN
*****************************************************/
	if (@section = 1)
	begin
		update ACCOUNT_TBL_DETAIL
		set BlockTime = @length, WebTime = '21000101'
		where account = @account

		--  LOGGING
		insert into TBL_LOG_BLOCK_ACCOUNT
			(account, code1, code2, code3, old_block_day, old_web_day, block_day, web_day, input_id, input_day, reason)
		values (@account, 0, 0, 3, '', '', @length, @length, 'Ban', getdate(), @reason)

		--   return results
		if @@error <> 0
		begin
			select 'BAN Error : ' + @@error	-- Error
		end
		else
		begin
			select 1		-- Success
		end
	end
/*****************************************************
			UNBAN
*****************************************************/
	if (@section = 2)
	begin
		update ACCOUNT_TBL_DETAIL
		set BlockTime = convert(char(8), dateadd(d, -1, getdate()), 112), WebTime = convert(char(8), dateadd(d, -1, getdate()), 112)
		where account = @account

		--   LOGGING
		update TBL_LOG_BLOCK_ACCOUNT
		set old_block_day = block_day, old_web_day = web_day
			, r_web_day = convert(char(8), dateadd(d, -1, getdate()), 112), r_block_day = convert(char(8), dateadd(d, -1, getdate()), 112)
			, r_input_day = getdate(), r_reason = @reason, r_input_id = '1'
		where account = @account
			and num = (select max(num) from TBL_LOG_BLOCK_ACCOUNT where account = @account)

		--   return results
		if @@error <> 0
		begin
			select 'UNBAN Error : ' + @@error	-- Error
		end
		else
		begin
			select 1		-- Success
		end
	end
end

[MentaL]

[PascoalBR]

Nice release!
thx! :D

[shappy23]

how to use lol haha

[ancelmylove]

yeahh how to used this ingame?

[ecKo9321]

you cant use this in game

this is a stored procedure, wich you can ban players in SQL SERVER MANAGEMENT STUDIO :3

[caja]

You have to run on database, not in game xD

[ecKo9321]

You have to run on database, not in game xD

hah I was 1st :O

1 second faster xD

[ancelmylove]

so how can i used that in my database?

[Alexsh]

I'm currently working on a php script for it.

[TheGrea]

I'm currently working on a php script for it.

thanks waiting for it to realease

[ecKo9321]

thanks waiting for it to realease

leacher

[Alexsh]

thanks waiting for it to realease

Who said I was going to release it? Lol.

[Detox]

Nice Alex. ;)

[TheGrea]

Who said I was going to release it? Lol.

OMG... huhuhuhu ok fine if you dont want to release it huhuhu

[ecKo9321]

OMG... huhuhuhu ok fine if you dont want to release it huhuhu

I lol`d