jomaxro
(Joshua Rosenfeld)
14 فبراير 2016، 5:18ص
1
Is it possible to get a list of users who were suspended at one time or another (not neccessarily actively suspended)?
cpradio
(cpradio)
14 فبراير 2016، 1:59م
2
I think you can use this in the data explorer plugin
SELECT * FROM user_histories
WHERE action = 10
I’m validating that 10 is suspended, but I believe it is.
And I found it is
@actions ||= Enum.new(delete_user: 1,
change_trust_level: 2,
change_site_setting: 3,
change_site_customization: 4,
delete_site_customization: 5,
checked_for_custom_avatar: 6, # not used anymore
notified_about_avatar: 7,
notified_about_sequential_replies: 8,
notified_about_dominating_topic: 9,
suspend_user: 10,
unsuspend_user: 11,
3 إعجابات
jomaxro
(Joshua Rosenfeld)
14 فبراير 2016، 9:47م
3
OK, can it be done by a Moderator? To the best of my knowledge mods don’t have access to run queries.
cpradio
(cpradio)
14 فبراير 2016، 10:40م
4
No, it can’t. But if you give it to your Admin, they can create the query, and you could use a master API key to access the queried data
إعجاب واحد (1)
jomaxro
(Joshua Rosenfeld)
14 فبراير 2016، 10:42م
5
Thanks @cpradio , this is less of an issue after I discovered that suspensions are logged…but no names are stored in logs. I would rather see a fix to that then need to bother the admins:
Summary:
Exporting the staff logs and looking at suspensions and blocks does not show who the suspension/block was applied to. Automatic unsuspensions are not logged.
Steps to reproduce:
Suspend, block, un-suspend, or un-block at least one user.
Visit /admin/logs/staff_action_logs
Click Export
Expected Results:
Logs will show who each action was applied to.
Actual Results:
No user is given for each log entry. Automatic un-suspensions (due to a date being entered when suspended) are n…
Is that still the case @jomaxro ?
jomaxro
(Joshua Rosenfeld)
19 ديسمبر 2018، 10:49م
8
I doubt it. That was 3 years ago, and the linked bug was fixed/closed. Will check to be sure.
إعجابَين (2)
jomaxro
(Joshua Rosenfeld)
19 ديسمبر 2018، 11:09م
10
Suspensions are definitely logged now, checked both /admin/logs/staff_action_logs and the downloaded CSV. Found a separate bug, but I’ll open a new topic for that.
4 إعجابات