[Release] How to Ban Player by Character Name [Database]

[ღ ∂ Ropp]

Anyways... it's easier than SMC, just a quick copy+paste query and then your good to go.

You only need to enter the name of the char &
time of the ban (I recommend leaving like this)
Ban reason

PHP Code:

--By Leandro ( nukertube ) --
USE [SRO_VT_SHARD]           
GO
--------------------------------                           
DECLARE @ChrID INT;            
DECLARE @CharName VARCHAR(64); 
DECLARE @AccJID INT;           
---------------------------------
SET @CharName =    'CharNameHere'---
---------------------------------
SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName)
SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID)
-----------------------------------------------------------------
USE SRO_VT_ACCOUNT
DECLARE @ID VARCHAR (64)
DECLARE @Reason VARCHAR(128)
DECLARE @Begin DATETIME
DECLARE @End DATETIME
SET @ID = (Select STRuserID FROM TB_User Where JID = @AccJID)

---------------------------------
SET @Reason    =    'Ban Reason Here'
SET @Begin    =    '2012-05-01 00:00:00.000' --    Time Begin    --
SET @End    =    '2040-01-01 00:00:00.000' --    Time End    --
---------------------------------
---------------------------

INSERT [dbo].[_Punishment]
(
[UserJID],
[Type],
[Executor],
[Shard],
[CharName],
[CharInfo],
[PosInfo] ,
[Guide],
[Description],
[RaiseTime],
[BlockStartTime],
[BlockEndTime],
[PunishTime],
[Status]
)
VALUES 
(
@AccJID,
1,
1,
0,
@CharName,
1,
1,
@Reason,
@Reason,
@Begin,
@Begin,
@End,
@End,
0);
----------------------------------------------------------
DECLARE @ReasonID INT
SET @ReasonID =
(Select SerialNo FROM _Punishment Where UserJID = @AccJID)
----------------------------------------------------------
INSERT [dbo].[_BlockedUser]
(
[UserJID],
[UserID],
[Type],
[SerialNo],
[TimeBegin],
[TimeEnd])
VALUES
(
@AccJID,
@ID,
1,
@ReasonID,
@Begin,
@End);

-----------------------------------------------------------------
SELECT StrUserID FROM TB_User WHERE JID = @AccJID
----------------------------------------------------------------- 


Best Regards,
ღ ∂ Ropp

Credits ; nukertube

[Disco Teka]

#banned




oops i mean
#approved

[•ᵔBeGodOfWarᵔ•]

hey, please Click liked

Coby pasta from rz
but old /ban for dc only better than ban .

[eldanger08]

Cool ...

[GiaNNy.RockZ]

Copycat :/
First I liked your posts,but I noticed u simple copy everything from rz

[ღ ∂ Ropp]

I give credits, and since it's not released here, i'm being helpful by posting here.
If you don't like it, then ciao.

[eldanger08]

Originally Posted by GiaNNy.RockZ

Copycat :/
First I liked your posts,but I noticed u simple copy everything from rz

eumm she trying to help are u mad ?

[✗EpicSoul✗]

just use smc. if you want to ban someone normally.

[supertrilo]

so will this work with /bansel also?

[ღ ∂ Ropp]

No, /bansel just kicks the player offline.

[✗EpicSoul✗]

got a better one

USE [R_BACKUP_001]
GO
/****** Object:  StoredProcedure [dbo].[_REMOVE_ALL_CHAR_DATA]    Script Date: 05/12/2012 19:51:38 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER   PROCEDURE [dbo].[_REMOVE_ALL_CHAR_DATA] 
 AS
	SELECT '장엄한 영혼의 소유' AS 'CRITICAL !!!'
	RETURN