Cho mình hỏi về Thế Hệ của web NBB

[Hào Hoa Công Tử]

pm chữ ký mình làm cho
30 charrrrrrrrrrrrrrrrrrrrrrrrr

[heroviet2301]

pm chữ ký mình làm cho
30 charrrrrrrrrrrrrrrrrrrrrrrrr

Tks, bác Hào Hoa đã giúp đỡ mình đã hiểu và làm được

[YouTobe]

Bạn làm được rồi à. Đang định úp nốt bài hướng dẫn.
P/s : Nghiên cứu trigger làm cái chia thế hệ 3 mà chưa được. Bạn nào có làm tiếp được thế hệ 3 không nhỉ ?

[heroviet2301]

Bạn ơi mình làm Triger rồi, Thế Hệ 1 và 2 rồi , đến khi đăng ký ID Thế Hệ 2 khi đăng nhập vào game Thế Hệ 2 lại bị 5 nhân vật block NhamSV , chỉ đăng nhập được vào Thế Hệ 1 là bình thường
Như trên là còn thiếu gì và ở đâu bạn nhỉ .

[bistro007_hp]

Bạn ơi mình làm Triger rồi, Thế Hệ 1 và 2 rồi , đến khi đăng ký ID Thế Hệ 2 khi đăng nhập vào game Thế Hệ 2 lại bị 5 nhân vật block NhamSV , chỉ đăng nhập được vào Thế Hệ 1 là bình thường
Như trên là còn thiếu gì và ở đâu bạn nhỉ .

Đơn giản là do sai Triger .................................................

[YouTobe]

Nghiên cứu trigger làm cái chia thế hệ 3 mà chưa được. Bạn nào có làm tiếp được thế hệ 3 không nhỉ ?

[heroviet2301]

Đơn giản là do sai Triger .................................................

Mình pate query vài The He (dbo) chứ ko pate vào (new)

CREATE TRIGGER TheHe
ON [dbo].[MEMB_STAT]
FOR UPDATE
AS
BEGIN
DECLARE 
@slg_thehe tinyint,
@Acc nvarchar(10),
@TheHe nvarchar(50),
@SV nvarchar (20)

SET @slg_thehe =2


-- Check tai khoan adm_block
IF NOT EXISTS (SELECT memb___id FROM MEMB_INFO WHERE memb___id='adm_block')
BEGIN
	INSERT INTO MEMB_INFO (memb___id,memb__pwd,memb_name) VALUES ('adm_block',[dbo].[fn_md5]('132465798','adm_block'),'ADMBLOCK')
END

-- Block tai khoan
UPDATE MEMB_INFO SET bloc_code=1 WHERE memb___id='adm_block' AND bloc_code<>1

-- Tao nhan vat 1
IF NOT EXISTS (SELECT Name FROM Character WHERE Name='NhamSV1' AND AccountID='adm_block')
BEGIN
	DELETE Character WHERE Name='NhamSV1' AND AccountID<>'adm_block'
	EXEC WZ_CreateCharacter 'adm_block', 'NhamSV1', 0
END
-- Tao nhan vat 2
IF NOT EXISTS (SELECT Name FROM Character WHERE Name='NhamSV2' AND AccountID='adm_block')
BEGIN
	DELETE Character WHERE Name='NhamSV2' AND AccountID<>'adm_block'
	EXEC WZ_CreateCharacter 'adm_block', 'NhamSV2', 32
END
-- Tao nhan vat 3
IF NOT EXISTS (SELECT Name FROM Character WHERE Name='NhamSV3' AND AccountID='adm_block')
BEGIN
	DELETE Character WHERE Name='NhamSV3' AND AccountID<>'adm_block'
	EXEC WZ_CreateCharacter 'adm_block', 'NhamSV3', 64
END
-- Tao nhan vat 4
IF NOT EXISTS (SELECT Name FROM Character WHERE Name='NhamSV4' AND AccountID='adm_block')
BEGIN
	DELETE Character WHERE Name='NhamSV4' AND AccountID<>'adm_block'
	EXEC WZ_CreateCharacter 'adm_block', 'NhamSV4', 80
END
-- Tao nhan vat 5
IF NOT EXISTS (SELECT Name FROM Character WHERE Name='NhamSV5' AND AccountID='adm_block')
BEGIN
	DELETE Character WHERE Name='NhamSV5' AND AccountID<>'adm_block'
	EXEC WZ_CreateCharacter 'adm_block', 'NhamSV5', 16
END

-- Block nhan vat thuoc tai khoan adm_block
UPDATE Character SET CtlCode=99 WHERE AccountID='adm_block' AND CtlCode<>99
-- END CHECK ACC ADM_BLOCK

SELECT @Acc=memb___id,@SV=ServerName FROM inserted WHERE ConnectStat='1'
SELECT @TheHe=thehe FROM MEMB_INFO WHERE memb___id=@Acc

-- BEGIN Khong ap dung The he
if(@slg_thehe=1)
BEGIN
	UPDATE Character SET CtlCode=0 WHERE AccountID!='adm_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
	UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='adm_block'
	UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='adm_block'
	UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='adm_block'
	UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='adm_block'
	UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='adm_block'
END
-- END Khong ap dung The he
ELSE
BEGIN
-- BEGIN Ap dung the he
-- The he moi
IF(@TheHe=2)
BEGIN
	IF(@SV='Sub-1' OR @SV='Sub-2' OR @SV='Sub-3' OR @SV='Sub-4' OR @SV='Sub-5')
	BEGIN
		UPDATE Character SET CtlCode=99 WHERE AccountID!='adm_block' AND AccountID=@Acc AND (CtlCode=0 OR CtlCode=18) AND ErrorSubBlock!=99
		UPDATE AccountCharacter SET GameID1='NhamSV1' WHERE Id=@Acc AND (GameID1 IS NULL OR GameID1='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID2='NhamSV2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID3='NhamSV3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID4='NhamSV4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID5='NhamSV5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='') AND Id!='adm_block'
	END
	ELSE
	BEGIN
		UPDATE Character SET CtlCode=0 WHERE AccountID!='adm_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
		UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='adm_block'
	END
END
ELSE
-- The he cu
BEGIN
	IF(@SV='Sub-1' OR @SV='Sub-2' OR @SV='Sub-3' OR @SV='Sub-4' OR @SV='Sub-5')
	BEGIN
		UPDATE Character SET CtlCode=0 WHERE AccountID!='adm_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
		UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='adm_block'
	END
	ELSE
	BEGIN
		UPDATE Character SET CtlCode=99 WHERE AccountID!='adm_block' AND AccountID=@Acc AND (CtlCode=0 OR CtlCode=18) AND ErrorSubBlock!=99
		UPDATE AccountCharacter SET GameID1='NhamSV1' WHERE Id=@Acc AND (GameID1 IS NULL OR GameID1='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID2='NhamSV2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID3='NhamSV3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID4='NhamSV4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID5='NhamSV5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='') AND Id!='adm_block'
	END
END
-- END Ap dung the he
END
END

[nmhonlineyb]

Nghiên cứu trigger làm cái chia thế hệ 3 mà chưa được. Bạn nào có làm tiếp được thế hệ 3 không nhỉ ?

Bạn cho tôi thôn tin sau tôi làm cho bạn ko cần query ( ko thê lập nhân vật đc )

1. Tên Row chứa thế hệ
2. Tên các Thế hệ của bạn
3. Tên Server chứa các thế hệ của bạn


Sau 5 phút tôi làm cho

--- Chế độ gộp bài viết ---

Mình pate query vài The He (dbo) chứ ko pate vào (new)

CREATE TRIGGER TheHe
ON [dbo].[MEMB_STAT]
FOR UPDATE
AS
BEGIN
DECLARE 
@slg_thehe tinyint,
@Acc nvarchar(10),
@TheHe nvarchar(50),
@SV nvarchar (20)

SET @slg_thehe =2


-- Check tai khoan adm_block
IF NOT EXISTS (SELECT memb___id FROM MEMB_INFO WHERE memb___id='adm_block')
BEGIN
	INSERT INTO MEMB_INFO (memb___id,memb__pwd,memb_name) VALUES ('adm_block',[dbo].[fn_md5]('132465798','adm_block'),'ADMBLOCK')
END

-- Block tai khoan
UPDATE MEMB_INFO SET bloc_code=1 WHERE memb___id='adm_block' AND bloc_code<>1

-- Tao nhan vat 1
IF NOT EXISTS (SELECT Name FROM Character WHERE Name='NhamSV1' AND AccountID='adm_block')
BEGIN
	DELETE Character WHERE Name='NhamSV1' AND AccountID<>'adm_block'
	EXEC WZ_CreateCharacter 'adm_block', 'NhamSV1', 0
END
-- Tao nhan vat 2
IF NOT EXISTS (SELECT Name FROM Character WHERE Name='NhamSV2' AND AccountID='adm_block')
BEGIN
	DELETE Character WHERE Name='NhamSV2' AND AccountID<>'adm_block'
	EXEC WZ_CreateCharacter 'adm_block', 'NhamSV2', 32
END
-- Tao nhan vat 3
IF NOT EXISTS (SELECT Name FROM Character WHERE Name='NhamSV3' AND AccountID='adm_block')
BEGIN
	DELETE Character WHERE Name='NhamSV3' AND AccountID<>'adm_block'
	EXEC WZ_CreateCharacter 'adm_block', 'NhamSV3', 64
END
-- Tao nhan vat 4
IF NOT EXISTS (SELECT Name FROM Character WHERE Name='NhamSV4' AND AccountID='adm_block')
BEGIN
	DELETE Character WHERE Name='NhamSV4' AND AccountID<>'adm_block'
	EXEC WZ_CreateCharacter 'adm_block', 'NhamSV4', 80
END
-- Tao nhan vat 5
IF NOT EXISTS (SELECT Name FROM Character WHERE Name='NhamSV5' AND AccountID='adm_block')
BEGIN
	DELETE Character WHERE Name='NhamSV5' AND AccountID<>'adm_block'
	EXEC WZ_CreateCharacter 'adm_block', 'NhamSV5', 16
END

-- Block nhan vat thuoc tai khoan adm_block
UPDATE Character SET CtlCode=99 WHERE AccountID='adm_block' AND CtlCode<>99
-- END CHECK ACC ADM_BLOCK

SELECT @Acc=memb___id,@SV=ServerName FROM inserted WHERE ConnectStat='1'
SELECT @TheHe=thehe FROM MEMB_INFO WHERE memb___id=@Acc

-- BEGIN Khong ap dung The he
if(@slg_thehe=1)
BEGIN
	UPDATE Character SET CtlCode=0 WHERE AccountID!='adm_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
	UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='adm_block'
	UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='adm_block'
	UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='adm_block'
	UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='adm_block'
	UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='adm_block'
END
-- END Khong ap dung The he
ELSE
BEGIN
-- BEGIN Ap dung the he
-- The he moi
IF(@TheHe=2)
BEGIN
	IF(@SV='Sub-1' OR @SV='Sub-2' OR @SV='Sub-3' OR @SV='Sub-4' OR @SV='Sub-5')
	BEGIN
		UPDATE Character SET CtlCode=99 WHERE AccountID!='adm_block' AND AccountID=@Acc AND (CtlCode=0 OR CtlCode=18) AND ErrorSubBlock!=99
		UPDATE AccountCharacter SET GameID1='NhamSV1' WHERE Id=@Acc AND (GameID1 IS NULL OR GameID1='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID2='NhamSV2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID3='NhamSV3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID4='NhamSV4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID5='NhamSV5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='') AND Id!='adm_block'
	END
	ELSE
	BEGIN
		UPDATE Character SET CtlCode=0 WHERE AccountID!='adm_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
		UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='adm_block'
	END
END
ELSE
-- The he cu
BEGIN
	IF(@SV='Sub-1' OR @SV='Sub-2' OR @SV='Sub-3' OR @SV='Sub-4' OR @SV='Sub-5')
	BEGIN
		UPDATE Character SET CtlCode=0 WHERE AccountID!='adm_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
		UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='adm_block'
	END
	ELSE
	BEGIN
		UPDATE Character SET CtlCode=99 WHERE AccountID!='adm_block' AND AccountID=@Acc AND (CtlCode=0 OR CtlCode=18) AND ErrorSubBlock!=99
		UPDATE AccountCharacter SET GameID1='NhamSV1' WHERE Id=@Acc AND (GameID1 IS NULL OR GameID1='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID2='NhamSV2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID3='NhamSV3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID4='NhamSV4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='') AND Id!='adm_block'
		UPDATE AccountCharacter SET GameID5='NhamSV5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='') AND Id!='adm_block'
	END
END
-- END Ap dung the he
END
END

Quá dài và lằng nhằng bạ n ah

[heroviet2301]

Quá dài và lằng nhằng bạ n ah

Người ta đưa và hướng dẫn sao thì làm theo thôi, đâu biết query nào đâu

[nmhonlineyb]

Vào DB MUOnline >>> Stored Procedure >> Click WZ_CreateCharacter và thay thế bằng đoạn sau .

Nhưng hãy đọc kỹ đoạn tôi chú ý sau dấu " ---" dưới đây nhé

 CREATE Procedure [dbo].[WZ_CreateCharacter]  
    @AccountID        varchar(10), 
    @Name            varchar(10), 
    @Class            tinyint 
 AS 
 Begin 
    SET NOCOUNT ON 
    SET    XACT_ABORT ON 
    DECLARE        @Result        tinyint 
    SET @Result = 0x00 
    If EXISTS ( SELECT  Name  FROM  Character WHERE LOWER(Name) = LOWER(@Name) ) 
    begin 
        SET @Result    = 0x01 
        GOTO ProcEnd 
    end 
    If EXISTS ( SELECT  Name  FROM  BotPet WHERE Name = @Name ) 
    begin 
        SET @Result    = 0x01                    
        GOTO ProcEnd                        
    end 
    BEGIN TRAN 
    If NOT EXISTS ( SELECT  Id  FROM  AccountCharacter WHERE Id = @AccountID ) 
        begin 
            INSERT INTO dbo.AccountCharacter(Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC)  
            VALUES(@AccountID, @Name, NULL, NULL, NULL, NULL, NULL) 
            SET @Result  = @@Error 
        end 
    else 
        begin 
            ---@TheHeCuaBan : Khai bao 
            Declare  @TheHeCuaBan        nvarchar(50),
            ---@server : Khia bao Server
            @server        varchar(10)
            --- @bangxephang :  row ( nghia la cot chua the he cua ban )
            --- RowChuaTheHe : thay = row cua ban

            select @bangxephang=RowChuaTheHe from memb_info where memb___id=@Accountid
            select @server=servername from memb_stat where memb___id=@Accountid
            --- So 1 la ten the he cua ban khi dang khi no se ghi vao table

            if(@bangxephang='1')
            begin
            --- TenServerTheHe1 : chinh la ten Server The He thu 1

            --- Dai khai cho nay la : Neu la` the he 1 ma vao cac khac Server khac ten TenServerTheHe1 thi se khong lap duoc nhan vat
            if(@server!='TenServerTheHe1-1' and @server!='TenServerTheHe1-2' and @server!='TenServerTheHe1-3' and @server!='TenServerTheHe1-4' and @server!='TenServerTheHe1-5')
                begin
                        SET @Result    = 0x03                            
                        GOTO TranProcEnd    
                end
            end
            --- Dai khai cho nay la : Neu ma` khac the he 1 vao Server TenServerTheHe1 thi se khong lap duoc nhan vat
            if(@server='TenServerTheHe1-1' or @server='TenServerTheHe1-2' or @server='TenServerTheHe1-3' or @server='TenServerTheHe1-4' or @server='TenServerTheHe1-5')
                begin
                    if(@bangxephang!='1')
                begin
                    SET @Result    = 0x03                            
                    GOTO TranProcEnd    
                end
            end
            if(@bangxephang='2')
            begin

            --- TenServerTheHe2 : chinh la ten Server The He thu 2

            --- Dai khai cho nay la : Neu la` the he 2 ma vao cac Server khac ten TenServerTheHe2 thi se khong lap duoc nhan vat
            if(@server!='TenServerTheHe2-1' and @server!='TenServerTheHe2-2' and @server!='TenServerTheHe2-3' and @server!='TenServerTheHe2-4' and @server!='TenServerTheHe2-5')
                begin
                        SET @Result    = 0x03                            
                        GOTO TranProcEnd    
                end
            end
            --- Dai khai cho nay la : Neu ma` khac the he 2 vao Server co ten TenServerTheHe2 thi se khong lap duoc nhan vat
            if(@server='TenServerTheHe2-1' or @server='TenServerTheHe2-2' or @server='TenServerTheHe2-3' or @server='TenServerTheHe2-4' or @server='TenServerTheHe2-5')
                begin
                    if(@bangxephang!='1')
                begin
                    SET @Result    = 0x03                            
                    GOTO TranProcEnd    
                end
            end

            if(@bangxephang='3')
            begin
            --- TenServerTheHe3 : chinh la ten Server The He thu 3

            --- Dai khai cho nay la : Neu la` the he 3 ma vao cac Server khac ten TenServerTheHe3 thi se khong lap duoc nhan vat
            if(@server!='TenServerTheHe3-1' and @server!='TenServerTheHe3-2' and @server!='TenServerTheHe3-3' and @server!='TenServerTheHe3-4' and @server!='TenServerTheHe3-5')
                begin
                        SET @Result    = 0x03                            
                        GOTO TranProcEnd    
                end
            end
            --- Dai khai cho nay la : Neu ma` khac the he 3 vao Server TenServerTheHe3 thi se khong lap duoc nhan vat
            if(@server='TenServerTheHe3-1' or @server='TenServerTheHe3-2' or @server='TenServerTheHe3-3' or @server='TenServerTheHe3-4' or @server='TenServerTheHe3-5')
                begin
                    if(@bangxephang!='1')
                begin
                    SET @Result    = 0x03                            
                    GOTO TranProcEnd    
                end
            end
            
        
            Declare @g1 varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10)                        
            SELECT @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5 FROM dbo.AccountCharacter Where Id = @AccountID             
            if( ( @g1 Is NULL) OR (Len(@g1) = 0)) 
                begin 
                    UPDATE AccountCharacter SET  GameID1 = @Name 
                    WHERE Id = @AccountID 
                    SET @Result  = @@Error 
                end 
            else     if( @g2  Is NULL OR Len(@g2) = 0) 
                begin 
                    UPDATE AccountCharacter SET  GameID2 = @Name 
                    WHERE Id = @AccountID 
                    SET @Result  = @@Error 
                end 
            else     if( @g3  Is NULL OR Len(@g3) = 0) 
                begin            
                    UPDATE AccountCharacter SET  GameID3 = @Name 
                    WHERE Id = @AccountID 
                    SET @Result  = @@Error 
                end 
            else     if( @g4 Is NULL OR Len(@g4) = 0) 
                begin 
                    UPDATE AccountCharacter SET  GameID4 = @Name 
                    WHERE Id = @AccountID 
                    SET @Result  = @@Error 
                end 
            else     if( @g5 Is NULL OR Len(@g5) = 0) 
                begin 
                    UPDATE AccountCharacter SET  GameID5 = @Name 
                    WHERE Id = @AccountID 
                    SET @Result  = @@Error
                end         
            else 
                begin                    
                    SET @Result    = 0x03                            
                    GOTO TranProcEnd                                
                end              
        end     
    if( @Result <> 0 ) 
        begin 
            GOTO TranProcEnd 
        end 
    else 
        begin 
            INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList, 
                    Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,  MDate, LDate, Quest, DbVersion, Leadership,money,reset ) 
            SELECT @AccountID As AccountID, @Name As Name, 300, 2000, @Class As Class, 
                Strength, Dexterity, Vitality, Energy, Inventory,MagicList,  Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, 
                getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership,20000000,5 
            FROM  DefaultClassType WHERE Class = @Class 
            SET @Result  = @@Error 
        end 
TranProcEnd:    -- GOTO 
    IF ( @Result  <> 0 ) 
        ROLLBACK TRAN 
    ELSE 
        COMMIT    TRAN 
ProcEnd: 
    SET NOCOUNT OFF 
    SET    XACT_ABORT OFF 
    SELECT 
       CASE @Result 
          WHEN 0x00 THEN 0x01 
          WHEN 0x01 THEN 0x00 
          WHEN 0x03 THEN 0x03 
          ELSE 0x02 
       END AS Result 
End
GO 

Sau khi thay thế song bạn chỉ cần làm 1 TRIGGER đơn gian đó là Block sai thế hệ ( và không cần phải thêm tên nhân vật gì nữa đâu vì khi đó nó vào nhầm sẽ không lập đc nhân vật đâu )


To all : Tôi đã chỉ dẫn chi tiết tại đó còn làm thế nào thì các bạn tự tìm hiểu nếu ko biết ( còn tôi dám cá nếu đã làm Admin thì cái trên chắc ko lạ đâu nhỉ