[HELP] invalid name to create character

Results 1 to 7 of 7
  1. #1
    number14 ryruz is offline
    MemberRank
    Mar 2011 Join Date
    Www.ryruz.phLocation
    571Posts

    [HELP] invalid name to create character

    hallo guyz, can you please help me to fix this kind of error,.thnk you Rz!

    [Server info: ep7v1]
    Attached Thumbnails Attached Thumbnails help.jpg  


  2. #2
    Account Upgraded | Title Enabled! UraGonZ is offline
    MemberRank
    Apr 2011 Join Date
    In Your Face :)Location
    244Posts

    Re: [HELP] invalid name to create character

    gui problem!!!

  3. #3
    number14 ryruz is offline
    MemberRank
    Mar 2011 Join Date
    Www.ryruz.phLocation
    571Posts

    Re: [HELP] invalid name to create character

    i try to change gui but nothing happen. same error appear, can u please give me some fix gui

  4. #4
    Banned xXx`Jhopz`xXx is offline
    BannedRank
    Sep 2011 Join Date
    Loading........Location
    222Posts

    Re: [HELP] invalid name to create character

    i think need to find the compatible ' gui ' for that client . i really hope someone help you to share gui files for that client..

  5. #5
    Account Upgraded | Title Enabled! ExisyServer is offline
    MemberRank
    Jan 2012 Join Date
    Occ MindoroLocation
    382Posts

    Re: [HELP] invalid name to create character

    That Problem is on Ur Database.. Try To Re-Database ..

    or
    try to exicute this on ur SQl
    USE [RanUser]
    GO
    /****** Object: StoredProcedure [dbo].[user_verify] Script Date: 07/17/2011 09:58:24 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO


    ALTER PROCEDURE [dbo].[user_verify]
    @userId char(25),
    @userPass char(25),
    @userIp char(25),
    @SvrGrpNum int,
    @SvrNum int,
    @proPass varchar(6), -- Ran dynamic password
    @proNum varchar(2), -- Ran dynamic password random number
    @nReturn int OUTPUT

    AS
    DECLARE
    @nAvailable int,
    @nUserNum int,
    @nState int,
    -- Declare variables used in error checking.
    @error_var int,
    @rowcount_var int,
    @nBlock int,
    @BlockDate datetime,
    @EndDate datetime,
    @StrSql nvarchar(100)

    SET NOCOUNT ON

    SET @nReturn = 0
    SET @nUserNum = 0

    SELECT @nUserNum=UserInfo.UserNum,
    @nState=UserInfo.UserLoginState,
    @nBlock=UserInfo.UserBlock,
    @BlockDate=UserInfo.UserBlockDate

    FROM UserInfo
    WHERE UserID = @userId AND UserPass = @userPass AND UserAvailable = 1


    -----------------------------------------------------------------
    -- ID / PWD check...
    IF @nUserNum = 0
    BEGIN
    SET @nReturn = 0
    RETURN @nReturn
    END
    ELSE
    BEGIN
    SET @nReturn = 1
    IF @nState = 1
    BEGIN
    SET @nReturn = 5
    RETURN @nReturn
    END
    END


    IF (SELECT COUNT(*) FROM BlockAddress WITH (NOLOCK) WHERE BlockAddress = @userIp) > 0

    BEGIN
    declare @params as nvarchar(100)
    SET @StrSQL = 'SELECT @ordercnt=count(userid) FROM Randpass WHERE userid='''+@userId+''' AND pwd'+@proNum + '='''+@proPass + ''''
    SET @params = '@ordercnt as int OUTPUT' -- OUTPUT ???? ??

    exec sp_executesql @StrSQL, @params, @ordercnt = @rowcount_var OUTPUT

    SELECT @error_var = @@ERROR
    IF @error_var = 0 AND @rowcount_var = 1
    BEGIN
    SET @nReturn = 1 -- Dynamic password correct
    END
    ELSE
    BEGIN
    SET @nReturn = 7 -- Dynamic password error
    RETURN @nReturn
    END
    END


    -----------------------------------------------------------------
    -- IP Address ??
    IF (SELECT COUNT(*) FROM IPInfo WITH (NOLOCK) WHERE ipAddress = @userIp) > 0
    -- IP ?? ??
    BEGIN
    SELECT @nAvailable = useAvailable
    FROM IPInfo
    WHERE ipAddress = @userIp

    IF @nAvailable = 1
    BEGIN
    SET @nReturn = 2 -- ID/PWD ? ????, IP ? ????
    END
    ELSE
    BEGIN
    SET @nReturn = 4 -- ID/PWD ? ????, IP ? ????? ??
    END
    END
    ELSE
    -- IP ?? ??
    BEGIN
    SET @nReturn = 3 -- ID/PWD ? ????, IP ??? ??
    END

    -----------------------------------------------------------------
    -- Block ?? ??
    IF (@nBlock = 1)
    BEGIN
    IF (@BlockDate > GetDate())
    BEGIN
    SET @nReturn = 6
    END
    ELSE
    BEGIN
    UPDATE UserInfo
    SET UserBlock=0
    WHERE UserNum = @nUserNum

    SET @nReturn = 2
    END
    END

    -----------------------------------------------------------------
    -- ??? ???? ??
    IF (@nReturn = 1) OR (@nReturn = 2) OR (@nReturn = 3)
    BEGIN
    -- ???, ??? ????? ??
    UPDATE UserInfo
    SET UserLoginState=1, LastLoginDate=getdate(), SGNum=@SvrGrpNum, SvrNum=@SvrNum
    WHERE UserNum = @nUserNum

    -- ???? ???
    INSERT INTO LogLogin (UserNum, UserID, LogInOut, LogIpAddress)
    VALUES (@nUserNum, @userId, 1, @userIp)

    -- ?? ????
    UPDATE StatLogin
    SET LCount = LCount+1
    WHERE LYear=Year(GetDate()) AND LMonth=Month(GetDate()) AND LDay=Day(GetDate()) AND LHour=DatePart(hour, GetDate())

    SELECT @error_var = @@ERROR, @rowcount_var = @@ROWCOUNT
    IF @error_var <> 0 OR @rowcount_var = 0
    BEGIN
    INSERT INTO StatLogin (LYEAR)
    VALUES (YEAR(GetDate()))
    END
    END

    SET NOCOUNT OFF

    RETURN @nReturn

  6. #6
    Banned xXx`Jhopz`xXx is offline
    BannedRank
    Sep 2011 Join Date
    Loading........Location
    222Posts

    Re: [HELP] invalid name to create character

    so what is the compatible data base for this client?

  7. #7
    number14 ryruz is offline
    MemberRank
    Mar 2011 Join Date
    Www.ryruz.phLocation
    571Posts

    Re: [HELP] invalid name to create character

    Quote Originally Posted by ExisyServer View Post
    That Problem is on Ur Database.. Try To Re-Database ..

    or
    try to exicute this on ur SQl
    can u please guide me on how to exucute that code.or any idea.tnx



Advertisement