Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P278
(An Untitled Masterwork)
Active
Public
Actions
Authored by
stwalkerster
on Oct 16 2020, 12:20 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Tags
None
Subscribers
None
-- duplicate the "removed private information" row into a comment log entry for the requester comment.
insert
into
log
select
null
id
,
c
.
id
objectid
,
'Comment'
objecttype
,
l
.
user
,
'EditComment-c'
action
,
l
.
timestamp
,
null
comment
,
0
updateversion
from
log
l
inner
join
request
r
on
l
.
objectid
=
r
.
id
and
l
.
objecttype
=
'Request'
inner
join
comment
c
on
r
.
id
=
c
.
request
where
l
.
action
in
(
'Removed private information via database'
)
and
c
.
visibility
=
'requester'
;
-- change the existing "remove private information" log entries to the correct action for the request log
update
log
l
set
action
=
'EditComment-r'
where
l
.
action
in
(
'Removed private information via database'
);
-- add a comment on the requests for the discarded requests
insert
into
comment
select
null
,
l
.
timestamp
,
l
.
user
,
l
.
action
,
'user'
,
l
.
objectid
,
0
from
log
l
where
action
=
'Discarded as likely a spambot'
;
-- change the log action to a drop for the discarded requests
update
log
set
action
=
'Closed 0'
where
action
=
'Discarded as likely a spambot'
;
Event Timeline
stwalkerster
created this paste.
Oct 16 2020, 12:20 PM
2020-10-16 12:20:03 (UTC+0)
stwalkerster
created this object with visibility "Public (No Login Required)".
stwalkerster
edited the content of this paste.
(Show Details)
Log In to Comment