Xin Triger Chia Sub Thế Hệ Web NBB

[GateBol]

Do diễn đàn Mu Web NBB không vào được hơn cả tuần nay nên không lấy được triger chia thế hệ của nó

Bạn nào dùng hoặc có share cho mình với nhé

cảm ơn nhiều

[thanh_ca]

Không Biết phải DB này k ?.Pác xem thử nhá

[Only registered and activated users can see links. ]

[dongahchu]

Data này để làm gì ?
Nếu sử dụng data này thì khác gì làm riêng mu mới .
Help !!!
Ai biết chia Thế hệ không vậy

[sieuga]

có phải triger này ko :

Mình muấn mở thế hệ 2 ,và đã làm các bước như sau :

Tạo trước 5 nhân vật trong tai khoan admin : admin1, admin2, admin3, admin4, admin5 5 ,rồi block cả 5 nhân vật trên.

Sau đó chạy Query

Code:


UPDATE Character SET CtlCode=99 WHERE AccountID='admin'UPDATE Character SET CtlCode=99 WHERE CtlCode=1 AND uythacoffline_stat!=1

Với mong muốn Thế hệ cũ được vào Sub 4,5,6
Thế hệ mới được vào Sub 1,2,3

Sau đó mình vào :

Table MuOnline > Table > MEMB_STAT > (Chuột phải) All Tasks > Manage Triggers
Rồi add đoạn code này vào :

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 = 1
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' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
UPDATE AccountCharacter SET GameID1='' WHERE GameID1='admin1' AND Id=@Acc AND Id!='admin'
UPDATE AccountCharacter SET GameID2='' WHERE GameID2='admin2' AND Id=@Acc AND Id!='admin'
UPDATE AccountCharacter SET GameID3='' WHERE GameID3='admin3' AND Id=@Acc AND Id!='admin'
UPDATE AccountCharacter SET GameID4='' WHERE GameID4='admin4' AND Id=@Acc AND Id!='admin'
UPDATE AccountCharacter SET GameID5='' WHERE GameID5='admin5' AND Id=@Acc AND Id!='admin'
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')
BEGIN
UPDATE Character SET CtlCode=99 WHERE AccountID!='admin' AND AccountID=@Acc AND (CtlCode=0 OR CtlCode=18) AND ErrorSubBlock!=99
UPDATE AccountCharacter SET GameID1='admin1' WHERE Id=@Acc AND (GameID1 IS NULL OR GameID1='') AND Id!='admin'
UPDATE AccountCharacter SET GameID2='admin2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='') AND Id!='admin'
UPDATE AccountCharacter SET GameID3='admin3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='') AND Id!='admin'
UPDATE AccountCharacter SET GameID4='admin4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='') AND Id!='admin'
UPDATE AccountCharacter SET GameID5='admin5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='') AND Id!='admin'
END
ELSE
BEGIN
UPDATE Character SET CtlCode=0 WHERE AccountID!='admin' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
UPDATE AccountCharacter SET GameID1='' WHERE GameID1='admin1' AND Id=@Acc AND Id!='admin'
UPDATE AccountCharacter SET GameID2='' WHERE GameID2='admin2' AND Id=@Acc AND Id!='admin'
UPDATE AccountCharacter SET GameID3='' WHERE GameID3='admin3' AND Id=@Acc AND Id!='admin'
UPDATE AccountCharacter SET GameID4='' WHERE GameID4='admin4' AND Id=@Acc AND Id!='admin'
UPDATE AccountCharacter SET GameID5='' WHERE GameID5='admin5' AND Id=@Acc AND Id!='admin'
END
END
ELSE
-- The he cu
BEGIN
IF(@SV='Sub-4' OR @SV='Sub-5' OR @SV='Sub-6')
BEGIN
UPDATE Character SET CtlCode=0 WHERE AccountID!='admin' AND AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
UPDATE AccountCharacter SET GameID1='' WHERE GameID1='admin1' AND Id=@Acc AND Id!='admin'
UPDATE AccountCharacter SET GameID2='' WHERE GameID2='admin2' AND Id=@Acc AND Id!='admin'
UPDATE AccountCharacter SET GameID3='' WHERE GameID3='admin3' AND Id=@Acc AND Id!='admin'
UPDATE AccountCharacter SET GameID4='' WHERE GameID4='admin4' AND Id=@Acc AND Id!='admin'
UPDATE AccountCharacter SET GameID5='' WHERE GameID5='admin5' AND Id=@Acc AND Id!='admin'
END
ELSE
BEGIN
UPDATE Character SET CtlCode=99 WHERE AccountID!='admin' AND AccountID=@Acc AND (CtlCode=0 OR CtlCode=18) AND ErrorSubBlock!=99
UPDATE AccountCharacter SET GameID1='admin1' WHERE Id=@Acc AND (GameID1 IS NULL OR GameID1='') AND Id!='admin'
UPDATE AccountCharacter SET GameID2='admin2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='') AND Id!='admin'
UPDATE AccountCharacter SET GameID3='admin3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='') AND Id!='admin'
UPDATE AccountCharacter SET GameID4='admin4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='') AND Id!='admin'
UPDATE AccountCharacter SET GameID5='admin5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='') AND Id!='admin'
END
END
-- END ap dung the he
END
END