When an SMF member deletes their account and then contacts you to delete their posts it’s not an easy request because the posts are no longer attached to a user account. What can you do? You can query the database
A handy drupal snippet, when someone’s added hundreds of nodes with comments allowed and you need to bulk disable them without editing them each by hand.
Recently I needed to empty the Drupal sessions and cache tables which had grown to some million+ rows and were causing weekly database errors on a busy health community website. In PhpMyAdmin, permissions to empty tables weren’t available.