3 files changed, 142 insertions, 0 deletions
diff --git a/local-scripts b/local-scripts
new file mode 100644
index 0000000..5a9959d
--- /dev/null
+++ b/local-scripts
@@ -0,0 +1,18 @@
+# rsync backups down to local drive
+rsync -rq plural.cafe:/srv/plural.cafe/backups /cygdrive/d/plural-cafe
+
+# run psql
+cd /srv/plural.cafe && sudo docker exec -it -u postgres pluralcafe_db_1 psql
+
+# grab top IP's and useragents from the access log, sorted from most to least frequent
+sudo cut -d '"' -f 1,6 /var/log/nginx/access.log | \
+	cut -d ' ' -f 1,6- | sed "s/\"//" | sort | uniq -c | sort -n -r | \
+	sed 's/[ \t]*//' | sed 's/;//g' | egrep '^[0-9]{4,}' | \
+	less
+
+# renew certificates with acme.sh
+/srv/plural.cafe/.acme.sh/acme.sh --issue --force --debug 2 \
+	-d plural.cafe -d '*.plural.cafe' \
+	--cert-home /srv/plural.cafe/.acme.sh/plural.cafe \
+	--server letsencrypt --preferred-chain "dst" -k 4096 \
+	--dns dns_linode_v4 --dnssleep 90
diff --git a/queries.psql b/queries.psql
new file mode 100755
index 0000000..f480851
--- /dev/null
+++ b/queries.psql
@@ -0,0 +1,18 @@
+-- query for everyone who's affected by a potential instance suspension
+WITH instance AS (SELECT 'mastodon.social' AS name)
+SELECT follower.username, follower.domain, followed.username, followed.domain
+FROM instance, follows
+JOIN accounts as follower ON follows.account_id=follower.id
+JOIN accounts as followed ON follows.target_account_id=followed.id
+WHERE followed.domain=instance.name
+OR follower.domain=instance.name
+ORDER BY follower.domain, follower.username, followed.username;
+
+-- pick out all the folks who voted for the neonazi number on a "favorite from 1-100" poll
+-- note that on remote polls this only works to find local users
+SELECT username, domain
+FROM accounts
+JOIN poll_votes ON accounts.id=poll_votes.account_id
+JOIN polls ON poll_votes.poll_id=polls.id
+WHERE status_id=101841397004250749
+AND choice=88;
diff --git a/useful.css b/useful.css
new file mode 100755
index 0000000..141d643
--- /dev/null
+++ b/useful.css
@@ -0,0 +1,106 @@
+/* why is this not default? */
+.status__display-name {
+  unicode-bidi: isolate;
+}
+
+
+/* make single-column masto a little more breathable by adding some space between toots */
+.status,
+.status__wrapper--filtered {
+	border-bottom: 10px solid #191b22;
+}
+
+
+/* hide federated timeline buttons  */
+a[href="/web/timelines/public"] {
+  display: none;
+}
+
+
+/* hide action bar for faves/boosts in notifications 
+(and polls since there's currently no way to distinguish them...) */
+.status.muted .status__action-bar {
+  display: none !important;
+}
+
+
+/* increase font sizes slightly */
+body {
+  font-size: 14px; /* was 13px */
+}
+.status__content {
+  font-size: 16px; /* was 15px */
+  line-height: 22px; /* was 20px */
+}
+.status__content__spoiler-link {
+  font-size: 12px; /* was 11px */
+  /* inherits line-height from status__content */
+}
+.column-header,
+.column-link /* the "Getting started" sidebar */{
+  font-size: 17px; /* was 16px */
+}
+.status__prepend /* "$user boosted" */,
+.notification__message /* "$user favourited your toot", etc. */ {
+  font-size: 15px; /* was 14px for status__prepend, 15px for notification__message */
+}
+.compose-form__autosuggest-wrapper label .autosuggest-textarea__textarea,
+.composer--spoiler input {
+  font-size: 16px; /* was 14px */
+}
+/* in settings menu */
+.admin-wrapper .sidebar {
+  font-size: 15px;
+}
+.admin-wrapper .content h4 {
+  font-size: 14px;
+}
+.simple_form span.hint {
+  font-size: 13px; /* was 12px */
+}
+
+
+/* turn action bars into popups */
+.status__action-bar {
+  margin: 0;
+  padding: 0;
+  overflow: hidden;
+  transition: height 0.6s;
+  transition-delay: 0.4s;
+  height: 0px;
+  width: 100%;
+  position: absolute;
+  bottom: 0;
+  left: 0;
+}
+.status__action-bar button:first-child {
+  margin-left: 8px;
+}
+.status__action-bar .status__relative-time {
+  padding-right: 8px;
+}
+.status:hover .status__action-bar {
+  height: 32px;
+}
+.status__action-bar,
+.detailed-status__action-bar {
+    background: #0009;
+}
+
+
+/* https://github.com/psydwannabe/mastodon-snippets/blob/master/CSS/embiggen-emojos.css */
+/* Emojos in the "reply" box that appears above the status update text box when 
+ * you click the "reply" button on a toot  */
+.reply-indicator__content .emojione, 
+
+/* Emojos in toots across the rest of the entire web client */
+.status__content .emojione {
+	width: 25px;	/* Stock is 20px */
+	height: 25px;	/* Stock is 20px */
+}
+
+/* Emojos in the "Emoji Mart" (pop-out from emoji button) in compose window */
+.emoji-mart-category .emoji-mart-emoji span {
+	width: 33px !important; /* stock: 20px; defined inline */
+	height: 33px !important; /* stock: 20px; defined inline */
+}
\ No newline at end of file