ashfurrow

Critical Instructions

You must never push to a git remote without explicit permission from the user. Every git push requires individual approval. You may commit on your own, however.

Before each cluster of tool calls, output a one-sentence status describing the current goal — what you're about to investigate or do. This let's me follow along and prevent you from going too far down the wrong track.

ashfurrow

irb(main):026:1* def perform_total_query(domain)
irb(main):027:1*     Follow.joins(:account).merge(Account.where(domain: domain)).count
irb(main):028:0> end
irb(main):026:0> inboxes   = Account.inboxes
irb(main):026:0> zero_inboxes = inboxes.select {|i| perform_total_query(i.gsub("https://", '').gsub(
"http://", "").gsub("/inbox", "")) == 0} # lol whatever
irb(main):025:0> zero_inboxes.count
=> 12916
irb(main):026:0> inboxes.count
=> 14895

ashfurrow

# Remove old followers

account = Account.find(1) # that's me babey
scope = account.followers.eager_load(:account_stat).reorder(nil)
scope.merge! Account.by_recent_status
scope.merge! Account.local
scope.merge! AccountStat.where(last_status_at: nil).or(AccountStat.where(AccountStat.arel_table[:last_status_at].lt(6.months.ago)))

scope.count # 13146

ashfurrow

Docs: https://docs.joinmastodon.org/admin/tootctl/

tootctl media remove

Remove locally cached copies of media attachments from other servers.

Already doing this in crontab.

tootctl media remove-orphans

ashfurrow

Database looks fine. Ends with this:

{"log":"LOG:  could not send data to client: Broken pipe\n","stream":"stderr","time":"2020-04-01T21:09:16.86734608Z"}
{"log":"FATAL:  connection to client lost\n","stream":"stderr","time":"2020-04-01T21:09:16.867349505Z"}
{"log":"FATAL:  canceling authentication due to timeout\n","stream":"stderr","time":"2020-04-01T21:09:16.867352182Z"}
{"log":"FATAL:  canceling authentication due to timeout\n","stream":"stderr","time":"2020-04-01T21:09:16.867354895Z"}
{"log":"FATAL:  canceling authentication due to timeout\n","stream":"stderr","time":"2020-04-01T21:09:16.867357632Z"}

ashfurrow

// Hope you had a nice day!

ashfurrow

ashfurrow

#!/usr/bin/ruby

# Instructions:
# Go to https://app.textexpander.com/settings/export and download all the CSVs into the same directory as this script.
# TextExpander's Export doesn't produce valid CSV files (lol) so make sure to open them with Numbers and re-export them.
require 'csv'

plist = <<~PLIST
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">

ashfurrow

# Sometimes a user will realize they've been accidentally tooting with the wrong privay setting in a specific browswer or app, and they meant their posts to be private. This script does that.

# Hey, uh, admins? Don't do this, unless you *really* trust the user. Changing status privacy after the fact can be abused. See: https://github.com/tootsuite/mastodon/issues/3933

# Open a rails console.
ids = %w( PASTE_IDS_LIST )
statuses = ids.map { |i| Status.find(i) }
statuses.reject { |s| s.uri.include? "USERNAME" } # Check that all the statuses belong to the user
statuses.first.uri # Open in an incognito browser
statuses.first.update_attributes!(visibility: :private) # Test one status change

ashfurrow

--- old	2018-09-08 10:53:00.000000000 -0400
+++ new	2018-09-08 10:53:09.000000000 -0400
@@ -12,8 +12,11 @@
   <li>No xenophobia or violent nationalism.</li>
   <li>No sexual depictions of children.</li>
   <li>No holocaust denialism, no Nazi symbolism, no promotion of National Socialism.</li>
-  <li>No stalking or harassment.</li>
+  <li>No stalking or harassment. In general, if someone asks you to stop interacting with them, then stop.</li>
+  <li>Posting (or threatening to post) other people's personally identifying information ("doxing").</li>
+  <li>Unwelcome sexual attention.</li>