I would like to limit charcter names but I don't know how to do that.
Rules:
-min 3 chars
-no !@#$%^&*()_.<>:; and stuff like that
-no other custom stuff just the alphanumeric
Here is my procedure:
SET @char_name= RTRIM(@char_name)
DECLARE @char_idint
SET @char_id=0-- debug code deletein commercial
IF (GETDATE()<'2004-1-1')
SET @builder=1
IF @char_name LIKE N' 'BEGIN
RAISERROR ('Character name has space : name = [%s]',16,1,@char_name)
RETURN -1END-- check user_prohibit
if exists(select char_name from user_prohibit (nolock)where char_name =@char_name)begin
RAISERROR ('Character name is prohibited: name = [%s]',16,1,@char_name)
RETURN -1end
declare @user_prohibit_word nvarchar(20)select top 1@user_prohibit_word= words from user_prohibit_word (nolock)where PATINDEX('%'+ words +'%',@char_name)>0if@user_prohibit_wordisnotnullbegin
RAISERROR ('Character name has prohibited word: name = [%s], word[%s]',16,1,@char_name,@user_prohibit_word)
RETURN -1end-- check reserved name
declare @reserved_name nvarchar(50)
declare @reserved_account_idintselect top 1@reserved_name= char_name,@reserved_account_id= account_id from user_name_reserved (nolock)where used =0and char_name =@char_nameifnot@reserved_nameisnullbeginifnot@reserved_account_id=@account_idbegin
RAISERROR ('Character name is reserved by other player: name = [%s]',16,1,@char_name)
RETURN -1endend
sorry for my bad english, I hope you understand me
I'm just testing the extender) I couldn't find any critical issues.
I found my own error due to which the autoloot function was not active:
just a syntax error, case-sensitive. You can't use a capital letter in the Myext.ini settings.
AutoLootMobDrop = true. (parameter true must necessarily be with a lowercase letter)
DISCORD :
utchiha_market
telegram :
https://t.me/utchiha_market
SELLIX STORE :
https://utchihamkt.mysellix.io/
Join our server for more products :
https://discord.gg/hood-services
https://campsite.bio/utchihaamkt
Question
koziolekl
Hello
I would like to limit charcter names but I don't know how to do that.
Rules:
-min 3 chars
-no !@#$%^&*()_.<>:; and stuff like that
-no other custom stuff just the alphanumeric
Here is my procedure:
sorry for my bad english, I hope you understand me
2 answers to this question
Recommended Posts