i cant ban

**flyffhelper** · 17-08-11

thanks for the help problem solved!

**MentaL**

**Phoenix** · 17-08-11

Originally Posted by flyffhelper

when i try to admin_ban a hacker

it dont work cause he got spaces in his name how can i fix this?

/admin_ban is for disconnecting a player, not banning, unless you're using GUNZ2830's modification.

Secondly, if you can't do it in-game, ban him via the Administration panel (if you have one) or directly from the database. And if you're talking about "space" as a special character, try Alt + 0160 (num. pad). If it's a regular space, do what I said above.

**flyffhelper** · 17-08-11

Originally Posted by Phoenix

/admin_ban is for disconnecting a player, not banning, unless you're using GUNZ2830's modification.

Secondly, if you can't do it in-game, ban him via the Administration panel (if you have one) or directly from the database. And if you're talking about "space" as a special character, try Alt + 0160 (num. pad). If it's a regular space, do what I said above.

ok thanks but if i ban him how i d/c him or he stays ingame?

**ETTETT** · 17-08-11

Why the hell my reply is deleted?

**Phoenix** · 17-08-11

Originally Posted by ETTETT

Why the hell my reply is deleted?

Because it absolutely didn't make any sense. How will a "_" work if it isn't even in the player's name? How can a _ replace a space?

**ETTETT** · 17-08-11

Originally Posted by Phoenix

Because it absolutely didn't make any sense. How will a "_" work if it isn't even in the player's name? How can a _ replace a space?

At least i tried to help and find a solution, but you delete my post for the reason it's useless? You do same for everyone?

**Phoenix** · 17-08-11

Originally Posted by ETTETT

At least i tried to help and find a solution, but you delete my post for the reason it's useless? You do same for everyone?

It was totally misguiding.

**El Jamie** · 17-08-11

Originally Posted by ETTETT

At least i tried to help and find a solution, but you delete my post for the reason it's useless? You do same for everyone?

Respect what Phoenix has done. If he thinks your post was stupid, and misleading then it should of been deleted. Therefore his decision was the correct choice. Use some knowledge before you post, if you know how to fix it then put the correct thing, instead of a silly answer that there was no need for.

**flyffhelper** · 18-08-11

Is there way to delete the ASIC codes like alt + 255 or everything it's really anoying how can i delete that pls help me thanks you!

**flyffhelper** · 18-08-11

Bumppppppppppppppp!

**Vusion** · 18-08-11

Use the abuse.txt , and Rotana has made a database modification to block the ascii codes but I'm not sure if it works...

Part 1 of it.

Code:

USE [GunzDB]
GO
/****** Object:  UserDefinedFunction [dbo].[fnCheckString]    Script Date: 11/21/2008 05:23:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[fnCheckString](@P_String VARCHAR(500))

RETURNS BIT

AS

BEGIN


DECLARE @V_RetValue BIT

DECLARE @V_Position INT

 

SET @V_Position = 1

SET @V_RetValue = 0   


WHILE @V_Position <= DATALENGTH(@P_String)

           AND @V_RetValue = 0

BEGIN


     IF ASCII(SUBSTRING(@P_String, @V_Position, 1))

            BETWEEN 48 AND 122

        SELECT @V_RetValue = 0

    ELSE

       SELECT @V_RetValue = 1      
   SET @V_Position = @V_Position + 1

END

RETURN @V_RetValue

 

END

Part 2.

Code:

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spInsertChar]    Script Date: 11/21/2008 05:26:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****** Object:  Stored Procedure dbo.spInsertChar    Script Date: 5/10/2007 3:42:11 PM ******/


/* 캐릭터 추가 */
ALTER PROC [dbo].[spInsertChar]
    @AID        int,
    @CharNum    smallint,
    @Name        varchar(24),
    @Sex        tinyint,
    @Hair        int,  
    @Face        int,
    @Costume    int
AS
SET NOCOUNT ON
BEGIN TRAN
IF EXISTS (SELECT CID FROM Character where (AID=@AID AND CharNum=@CharNum) OR (Name=@Name))
BEGIN    
    ROLLBACK TRAN
    return(-1)
END
IF  (SELECT dbo.fnCheckString(@Name) as Test)= 1
BEGIN 
ROLLBACK TRAN
return (-1)
END
DECLARE @CharIdent     int
DECLARE @ChestCIID    int
DECLARE @LegsCIID    int
DECLARE @MeleeCIID    int
DECLARE @PrimaryCIID    int
DECLARE @SecondaryCIID  int
DECLARE @Custom1CIID    int
DECLARE @Custom2CIID    int

DECLARE @ChestItemID    int
DECLARE @LegsItemID    int
DECLARE @MeleeItemID    int
DECLARE @PrimaryItemID    int
DECLARE @SecondaryItemID  int
DECLARE @Custom1ItemID    int
DECLARE @Custom2ItemID    int

SET @SecondaryCIID = NULL
SET @SecondaryItemID = NULL

SET @Custom1CIID = NULL
SET @Custom1ItemID = NULL

SET @Custom2CIID = NULL
SET @Custom2ItemID = NULL

INSERT INTO Character (AID, Name, CharNum, Level, Sex, Hair, Face, XP, BP, FR, CR, ER, WR, 
                            GameCount, KillCount, DeathCount, RegDate, PlayTime, DeleteFlag)
Values (@AID, @Name, @CharNum, 1, @Sex, @Hair, @Face, 0, 0, 0, 0, 0, 0, 0, 0, 0, GETDATE(), 0, 0)
IF 0 <> @@ERROR BEGIN
    ROLLBACK TRAN
    RETURN (-1)
END


SET @CharIdent = @@IDENTITY

  /* Melee */
  SET @MeleeItemID = 
    CASE @Costume
    WHEN 0 THEN 1
    WHEN 1 THEN 2
    WHEN 2 THEN 1
    WHEN 3 THEN 2
    WHEN 4 THEN 2
    WHEN 5 THEN 1
    END

  INSERT INTO CharacterItem (CID, ItemID) Values (@CharIdent, @MeleeItemID)
  IF 0 <> @@ERROR BEGIN
    ROLLBACK TRAN
    RETURN (-1)
  END

  SET @MeleeCIID = @@IDENTITY

  /* Primary */
  SET @PrimaryItemID = 
    CASE @Costume
    WHEN 0 THEN 5001
    WHEN 1 THEN 5002
    WHEN 2 THEN 4005
    WHEN 3 THEN 4001
    WHEN 4 THEN 4002
    WHEN 5 THEN 4006
    END

  INSERT INTO CharacterItem (CID, ItemID) Values (@CharIdent, @PrimaryItemID)
  IF 0 <> @@ERROR BEGIN
    ROLLBACK TRAN
    RETURN (-1)
  END

  SET @PrimaryCIID = @@IDENTITY

  /* Secondary */
IF @Costume = 0 OR @Costume = 2 BEGIN
  SET @SecondaryItemID =
    CASE @Costume
    WHEN 0 THEN 4001
    WHEN 1 THEN 0
    WHEN 2 THEN 5001
    WHEN 3 THEN 4006
    WHEN 4 THEN 0
    WHEN 5 THEN 4006
    END

  IF @SecondaryItemID <> 0 BEGIN
    INSERT INTO CharacterItem (CID, ItemID) Values (@CharIdent, @SecondaryItemID)
    IF 0 <> @@ERROR BEGIN
    ROLLBACK TRAN
    RETURN (-1)
    END

    SET @SecondaryCIID = @@IDENTITY
  END
END
  SET @Custom1ItemID = 
    CASE @Costume
    WHEN 0 THEN 30301
    WHEN 1 THEN 30301
    WHEN 2 THEN 30401
    WHEN 3 THEN 30401
    WHEN 4 THEN 30401
    WHEN 5 THEN 30101
    END

  /* Custom1 */
  INSERT INTO CharacterItem (CID, ItemID) Values (@CharIdent, @Custom1ItemID)
  IF 0 <> @@ERROR BEGIN
    ROLLBACK TRAN
    RETURN (-1)
  END

  SET @Custom1CIID = @@IDENTITY

  /* Custom2 */
IF @Costume = 4 OR @Costume = 5
BEGIN
  SET @Custom2ItemID =
    CASE @Costume
    WHEN 0 THEN 0
    WHEN 1 THEN 0
    WHEN 2 THEN 0
    WHEN 3 THEN 0
    WHEN 4 THEN 30001
    WHEN 5 THEN 30001
    END

  IF @Custom2ItemID <> 0
  BEGIN
    INSERT INTO CharacterItem (CID, ItemID) Values (@CharIdent, @Custom2ItemID)
    IF 0 <> @@ERROR BEGIN
    ROLLBACK TRAN
    RETURN (-1)
    END

    SET @Custom2CIID = @@IDENTITY
  END
END


IF @Sex = 0        /* 남자일 경우 */
BEGIN

  /* Chest */
  SET @ChestItemID =
    CASE @Costume
    WHEN 0 THEN 21001
    WHEN 1 THEN 21001
    WHEN 2 THEN 21001
    WHEN 3 THEN 21001
    WHEN 4 THEN 21001
    WHEN 5 THEN 21001
    END


  INSERT INTO CharacterItem (CID, ItemID) Values (@CharIdent, @ChestItemID)
  IF 0 <> @@ERROR BEGIN
    ROLLBACK TRAN
    RETURN (-1)
  END

  SET @ChestCIID = @@IDENTITY

  /* Legs */
  SET @LegsItemID =
    CASE @Costume
    WHEN 0 THEN 23001
    WHEN 1 THEN 23001
    WHEN 2 THEN 23001
    WHEN 3 THEN 23001
    WHEN 4 THEN 23001
    WHEN 5 THEN 23001
    END


  INSERT INTO CharacterItem (CID, ItemID) Values (@CharIdent, @LegsItemID)
  IF 0 <> @@ERROR BEGIN 
    ROLLBACK TRAN
    RETURN (-1)
  END

  SET @LegsCIID = @@IDENTITY

END
ELSE
BEGIN            /* 여자일 경우 */

  /* Chest */
  SET @ChestItemID =
    CASE @Costume
    WHEN 0 THEN 21501
    WHEN 1 THEN 21501
    WHEN 2 THEN 21501
    WHEN 3 THEN 21501
    WHEN 4 THEN 21501
    WHEN 5 THEN 21501
    END


  INSERT INTO CharacterItem (CID, ItemID) Values (@CharIdent, @ChestItemID)
  IF 0 <> @@ERROR BEGIN
    ROLLBACK TRAN
    RETURN (-1)
  END
  SET @ChestCIID = @@IDENTITY

  /* Legs */
  SET @LegsItemID =
    CASE @Costume
    WHEN 0 THEN 23501
    WHEN 1 THEN 23501
    WHEN 2 THEN 23501
    WHEN 3 THEN 23501
    WHEN 4 THEN 23501
    WHEN 5 THEN 23501
    END


  INSERT INTO CharacterItem (CID, ItemID) Values (@CharIdent, @LegsItemID)
  IF 0 <> @@ERROR BEGIN
    ROLLBACK TRAN
    RETURN (-1)
  END
  SET @LegsCIID = @@IDENTITY

END  

UPDATE Character
SET chest_slot = @ChestCIID, legs_slot = @LegsCIID, melee_slot = @MeleeCIID,
    primary_slot = @PrimaryCIID, secondary_slot = @SecondaryCIID, custom1_slot = @Custom1CIID,
    custom2_slot = @Custom2CIID,
    chest_itemid = @ChestItemID, legs_itemid = @LegsItemID, melee_itemid = @MeleeItemID,
    primary_itemid = @PrimaryItemID, secondary_itemid = @SecondaryItemID, custom1_itemid = @Custom1ItemID,
    custom2_itemid = @Custom2ItemID
WHERE CID=@CharIdent
IF 0 = @@ROWCOUNT BEGIN
    ROLLBACK TRAN
    RETURN (-1)
END
COMMIT TRAN

**ThroneX** · 18-08-11

If you want to disconnect player with spaces and special characters,Right click on the hacker name>Whisper then delete the part of 'whisper' and write admin_ban.Don't forget to first ban his account then give dc.

**flyffhelper** · 18-08-11

Originally Posted by ThroneX

If you want to disconnect player with spaces and special characters,Right click on the hacker name>Whisper then delete the part of 'whisper' and write admin_ban.Don't forget to first ban his account then give dc.

i did that already but doesnt seems to work i try the query

Edit fixed :)

i cant ban

Thread Tools

Search Thread

i cant ban

Re: i cant ban

Re: i cant ban

Re: i cant ban

Re: i cant ban

Re: i cant ban

Re: i cant ban

Re: i cant ban

Re: i cant ban

Re: i cant ban

Re: i cant ban

Re: i cant ban

Re: i cant ban

Advertisement