Cho hỏi về trigger chia 3 thế hệ

[LHB_LOVE]

Ai có trigger chia 3 thế hệ cho xin với 2 thế hệ thì có rồi còn 3 cái thì bị lỗi thế hệ này vào thế hệ kia không khóa

[hieutham]

Ai có trigger chia 3 thế hệ cho xin với

[thanh_ca]

Tự mò thôi. Cái này chưa ai share thì phải ^^!. Dựa vào cái 2 thế hệ mà code ra. Tớ mới nghĩ là code nhưng chưa có time test

[Hào Hoa Công Tử]

Cũng đang cần cái này.............................

[thienthong]

Nghe đâu sắp open sv mới để gọp sv của MU cửu đỉnh thì phải mà phải ko Đào Hoa Công Tử

[mrrainnt]

Post cái triger của TH 2 lên mình xem code thử @.@! Quăng đâu mất cái triger rồi

[hieutham]

Post cái triger của TH 2 lên mình xem code thử @.@! Quăng đâu mất cái triger rồi

đây bạn ơi



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
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!='admin_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='admin_block'
UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='admin_block'
UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='admin_block'
UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='admin_block'
UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='admin_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!='admin_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!='admin_block'
UPDATE AccountCharacter SET GameID2='NhamSV2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='') AND Id!='admin_block'
UPDATE AccountCharacter SET GameID3='NhamSV3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='') AND Id!='admin_block'
UPDATE AccountCharacter SET GameID4='NhamSV4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='') AND Id!='admin_block'
UPDATE AccountCharacter SET GameID5='NhamSV5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='') AND Id!='admin_block'
END
ELSE
BEGIN
UPDATE Character SET CtlCode=0 WHERE AccountID!='admin_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='admin_block'
UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='admin_block'
UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='admin_block'
UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='admin_block'
UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='admin_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!='admin_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='admin_block'
UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='admin_block'
UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='admin_block'
UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='admin_block'
UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='admin_block'
END
ELSE
BEGIN
UPDATE Character SET CtlCode=99 WHERE AccountID!='admin_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!='admin_block'
UPDATE AccountCharacter SET GameID2='NhamSV2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='') AND Id!='admin_block'
UPDATE AccountCharacter SET GameID3='NhamSV3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='') AND Id!='admin_block'
UPDATE AccountCharacter SET GameID4='NhamSV4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='') AND Id!='admin_block'
UPDATE AccountCharacter SET GameID5='NhamSV5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='') AND Id!='admin_block'
END
END
-- END ap dung the he
END
END

[mattroilan]

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
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!='admin_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
    UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='admin_block'
    UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='admin_block'
    UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='admin_block'
    UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='admin_block'
    UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='admin_block'
    END
-- END Khong ap dung The he
ELSE
    BEGIN
        -- BEGIN Ap dung the he
        -- The he moi
        IF(@TheHe=1)
            BEGIN
                IF(@SV<='Sub-5')
                    BEGIN
                        UPDATE Character SET CtlCode=0 WHERE AccountID!='admin_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
                        UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='admin_block'
                    END
                ELSE
                    BEGIN                        
                        UPDATE Character SET CtlCode=99 WHERE AccountID!='admin_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!='admin_block'
                        UPDATE AccountCharacter SET GameID2='NhamSV2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='') AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID3='NhamSV3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='') AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID4='NhamSV4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='') AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID5='NhamSV5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='') AND Id!='admin_block'
                    END
            END
        IF(@TheHe=2)
            BEGIN
                IF ((@SV > 'Sub-5') AND (@SV <= 'Sub-10'))
                    BEGIN
                        UPDATE Character SET CtlCode=0 WHERE AccountID!='admin_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
                        UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='admin_block'
                    END
                ELSE
                    BEGIN                        
                        UPDATE Character SET CtlCode=99 WHERE AccountID!='admin_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!='admin_block'
                        UPDATE AccountCharacter SET GameID2='NhamSV2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='') AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID3='NhamSV3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='') AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID4='NhamSV4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='') AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID5='NhamSV5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='') AND Id!='admin_block'
                    END
            END
        IF(@TheHe=3)
            BEGIN
                IF ((@SV > 'Sub-10') AND (@SV <= 'Sub-15'))
                    BEGIN
                        UPDATE Character SET CtlCode=0 WHERE AccountID!='admin_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
                        UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='admin_block'
                    END
                ELSE
                    BEGIN                        
                        UPDATE Character SET CtlCode=99 WHERE AccountID!='admin_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!='admin_block'
                        UPDATE AccountCharacter SET GameID2='NhamSV2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='') AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID3='NhamSV3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='') AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID4='NhamSV4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='') AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID5='NhamSV5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='') AND Id!='admin_block'
                    END
            END
    
    END
END 

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

nhớ cái

SET @slg_thehe = 2 

bao nhiêu thế hệ thì sửa thành bấy nhiêu

rồi còn nếu muốn thêm thì copy và paste đoạn này sửa lại 1 chút là ok

IF(@TheHe=3)
            BEGIN
                IF ((@SV > 'Sub-10') AND (@SV <= 'Sub-15'))
                    BEGIN
                        UPDATE Character SET CtlCode=0 WHERE AccountID!='admin_block' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
                        UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc AND Id!='admin_block'
                    END
                ELSE
                    BEGIN                        
                        UPDATE Character SET CtlCode=99 WHERE AccountID!='admin_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!='admin_block'
                        UPDATE AccountCharacter SET GameID2='NhamSV2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='') AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID3='NhamSV3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='') AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID4='NhamSV4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='') AND Id!='admin_block'
                        UPDATE AccountCharacter SET GameID5='NhamSV5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='') AND Id!='admin_block'
                    END
            END 

[YouTobe]

Sao mình vẫn thấy Thế hệ 1 vào được cả Thế hệ 2 và 3 nhỉ.

Bây giờ mình có
Thế hệ 1 gồm : SV-1,SV-2,SV-3
Thế hệ 2 gồm : SV-4,SV-5,SV-6
Giờ muốn thêm Thế hệ 3 gồm : SV-7,SV-8,SV-9

Thì thay cụ thể vào Trigger trên như thế nào vậy.
Mong bạn nào đã chia thành công chỉ giúp, hoặc thay tên Sub vào đoạn Trigger giúp mình.
Xin cảm ơn !

[hieutham]

làm y vậy mà các thế hệ vẫn vào được sub của nhau.