Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [AccountServer]
- GO
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TRIGGER [dbo].[UPD_ACCOUNT_LOGIN]
- ON [AccountServer].[dbo].[account_login]
- AFTER UPDATE
- AS
- BEGIN
- IF @@ROWCOUNT = 0 RETURN
- DECLARE @IP VARCHAR(55)
- DECLARE @MAC VARCHAR(55)
- SELECT @IP = SUBSTRING(last_login_mac,25,15) FROM INSERTED
- SELECT @MAC = SUBSTRING(last_login_mac,0,24) FROM INSERTED
- UPDATE account_login
- SET
- last_login_ip = CASE WHEN @IP='' THEN last_login_ip ELSE @IP END,
- last_login_mac = CASE WHEN @MAC='' THEN last_login_mac ELSE @MAC END
- WHERE id=(SELECT id FROM INSERTED)
- END
- GO
- USE [AccountServer]
- GO
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TRIGGER [dbo].[INS_USER_LOG]
- ON [AccountServer].[dbo].[user_log]
- AFTER INSERT
- AS
- BEGIN
- IF @@ROWCOUNT = 0 RETURN
- DECLARE @IP VARCHAR(55)
- SELECT @IP = last_login_ip FROM account_login WHERE id=(SELECT user_id FROM INSERTED)
- UPDATE user_log
- SET
- login_ip = CASE WHEN @IP='' THEN login_ip ELSE @IP END
- WHERE log_id=(SELECT log_id FROM INSERTED)
- END
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement