Online and offline Notice

[CritYouDown]

انت مش شارح الناس تحدد الـ MSG منين
دى حاجه منظمه شويه

DECLARE @Msg varchar(max);
DECLARE @Charn varchar(64) = (Select Charname16 from SRO_VT_SHARD.._Char Where CharID = @CharID)
IF (@EventID = 4)
	begin
	SET @msg = '+ @Charn + ' <== has logged in '
	end
	BEGIN
	INSERT INTO PlusNotice VALUES (0, @Msg, GETDATE())
	UPDATE PlusNotice SET [Sent] = 1 WHERE [Date] < DATEADD(MINUTE, -5, GETDATE())
	END


IF (@EventID = 6)
	begin
	SET @msg = '+ @Charn + ' <== has logged out '
	end
	BEGIN
	INSERT INTO PlusNotice VALUES (0, @Msg, GETDATE())
	UPDATE PlusNotice SET [Sent] = 1 WHERE [Date] < DATEADD(MINUTE, -5, GETDATE())
	END

مع العلم لازم تكون شغال بـ Plus Notice
علشان السيسيم يشتغل