Kết quả 1 đến 6 của 6
Chủ đề: Lỗi web NBB sau khi cài web Help
-
16-03-12, 05:29 PM #1AlexandriaGuest
Lỗi web NBB sau khi cài web Help
Lần sửa cuối bởi Alexandria, ngày 16-03-12 lúc 05:31 PM.
Khách viếng thăm hãy cùng Alexandria xây dựng diễn đàn CLBGAMESVN vững mạnh nhé!
-
16-03-12, 05:35 PM #2
-
16-03-12, 05:42 PM #3AlexandriaGuest
Ðề: Lỗi web NBB sau khi cài web Help
Pm yahoo cái tuấn xem coi nào là xóa 1 nv này đi à
Khách viếng thăm hãy cùng Alexandria xây dựng diễn đàn CLBGAMESVN vững mạnh nhé!
-
16-03-12, 05:46 PM #4
-
16-03-12, 05:52 PM #5
- Ngày tham gia
- Jun 2011
- Bài viết
- 87
- Thanks
- 29
- Thanked 63 Times in 24 Posts
Ðề: Lỗi web NBB sau khi cài web Help
thêm cái Trigger này vào TAP MEMB_STAT
PHP Code: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
if(@slg_thehe=1)
BEGIN
UPDATE Character SET CtlCode=17 WHERE AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc
UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc
UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc
UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc
UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc
END
ELSE
BEGIN
IF(@TheHe=1)
BEGIN
IF(@SV='Sub-3')
BEGIN
UPDATE Character SET CtlCode=17 WHERE AccountID=@Acc AND CtlCode=0 AND ErrorSubBlock!=99
UPDATE AccountCharacter SET GameID1='NhamSV1' WHERE Id=@Acc AND (GameID1 IS NULL OR GameID1='')
UPDATE AccountCharacter SET GameID2='NhamSV2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='')
UPDATE AccountCharacter SET GameID3='NhamSV3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='')
UPDATE AccountCharacter SET GameID4='NhamSV4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='')
UPDATE AccountCharacter SET GameID5='NhamSV5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='')
END
ELSE
BEGIN
UPDATE Character SET CtlCode=17 WHERE AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc
UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc
UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc
UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc
UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc
END
END
ELSE
BEGIN
IF(@SV='Sub-3' )
BEGIN
UPDATE Character SET CtlCode=17 WHERE AccountID=@Acc AND CtlCode=99 AND ErrorSubBlock!=99
UPDATE AccountCharacter SET GameID1='' WHERE GameID1='NhamSV1' AND Id=@Acc
UPDATE AccountCharacter SET GameID2='' WHERE GameID2='NhamSV2' AND Id=@Acc
UPDATE AccountCharacter SET GameID3='' WHERE GameID3='NhamSV3' AND Id=@Acc
UPDATE AccountCharacter SET GameID4='' WHERE GameID4='NhamSV4' AND Id=@Acc
UPDATE AccountCharacter SET GameID5='' WHERE GameID5='NhamSV5' AND Id=@Acc
END
ELSE
BEGIN
UPDATE Character SET CtlCode=17 WHERE AccountID=@Acc AND CtlCode=0 AND ErrorSubBlock!=99
UPDATE AccountCharacter SET GameID1='NhamSV1' WHERE Id=@Acc AND (GameID1 IS NULL OR GameID1='')
UPDATE AccountCharacter SET GameID2='NhamSV2' WHERE Id=@Acc AND (GameID2 IS NULL OR GameID2='')
UPDATE AccountCharacter SET GameID3='NhamSV3' WHERE Id=@Acc AND (GameID3 IS NULL OR GameID3='')
UPDATE AccountCharacter SET GameID4='NhamSV4' WHERE Id=@Acc AND (GameID4 IS NULL OR GameID4='')
UPDATE AccountCharacter SET GameID5='NhamSV5' WHERE Id=@Acc AND (GameID5 IS NULL OR GameID5='')
END
END
END
END
Hì hì vừa Run ok rồi mà vẫn hỏi anh nữa .Khách viếng thăm hãy cùng thangvtv xây dựng diễn đàn CLBGAMESVN vững mạnh nhé!
-
Các thành viên gởi lời cảm ơn đến thangvtv vì bài viết này !
-
16-03-12, 06:01 PM #6AlexandriaGuest
Ðề: Lỗi web NBB sau khi cài web Help
Thank bác nha ko có bác chắc chết quá
Khách viếng thăm hãy cùng Alexandria xây dựng diễn đàn CLBGAMESVN vững mạnh nhé!