on some servers u can hack the names like [GM]/[ADM]/[GS] etc so to avoid that.
1. Open [dbo].[usp_Create_Char_R]
and Add this after: SET NOCOUNT ON
Code:
DECLARE @Ret int
SET @CharName = LTRIM(RTRIM(@CharName))
SET @Ret = 0
DECLARE @charcheck AS INT
SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)
SET @charcheck = PATINDEX('%[^a-zA-Z0-9]%',@CharName)
IF @charcheck > 0
RETURN -1
2. click execute and ur done
Good Luck
1. Open [dbo].[usp_Create_Char_R]
and Add this after: SET NOCOUNT ON
Code:
DECLARE @Ret int
SET @CharName = LTRIM(RTRIM(@CharName))
SET @Ret = 0
DECLARE @charcheck AS INT
SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)
SET @charcheck = PATINDEX('%[^a-zA-Z0-9]%',@CharName)
IF @charcheck > 0
RETURN -1
2. click execute and ur done
Good Luck