14 January 2021, 9:40

someone has stolen a mahara-account and postet and created content an comments that should be deleted.

what is the "best" way? if I only delete the own created pages portfolio, then the comments are still existing.

Is there a way to see all content that a user has created (including comments, ...) as administrator or as the user?

What  happens to the date if I delete the hole useraccount?

18 January 2021, 13:31

Hi Andreas,

The best way to check the user account's activity is by searching through the database, so you'll need to contact the administrator of the site.

To check all the content this person might have created, they should find out the user id on the database by name or email. Below you can find the scripts to find everything.

To see the portfolios associated with this account:

select * from view where owner=<userid>

select * from collection where owner=<userid>

To see artefacts (this includes comments, please check the column artefacttype)

select * from artefact where owner=<userid>

To see forum posts

select * from interaction_forum_post where poster=<userid>

If you delete the user account, the comments will not be deleted, just the name of the author will be set to 'deleted account', but the text will remain.

Please let me know if I've missed anything and I'll post the query for it.

Hope you can solve this,

Cecilia