Pathoschild

using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Linq;
using System.Net;
using Microsoft.TeamFoundation.Client;
using Microsoft.TeamFoundation.Framework.Client;
using Microsoft.TeamFoundation.Framework.Common;
using Microsoft.TeamFoundation.Server;
using Microsoft.TeamFoundation.VersionControl.Client;

Pathoschild

#!/usr/bin/env bash

# Retrieves the dates of the latest edit and log action for every bureaucrat
# across every Wikimedia wiki. This generates a TSV dataset that can be imported
# into Google Fusion Tables or processed into another format.

# SQL which generates TSV data (with fields for Google Fusion)
wikiSql="SELECT dbname, server, lang, family, domain, size, is_closed FROM toolserver.wiki ORDER BY dbname"
scanSql="SELECT /* SLOW_OK */ *, GREATEST(last_edit, last_log) AS last_edit_or_log, COALESCE(DATE_FORMAT(last_edit, '%d/%m/%y %H:%i'), 'never') AS last_edit_us, COALESCE(DATE_FORMAT(last_log, '%d/%m/%y %H:%i'), 'never') AS last_log_us, COALESCE(DATE_FORMAT(GREATEST(last_edit, last_log), '%d/%m/%y %H:%i'), 'never') AS last_edit_or_log_us FROM (SELECT user_name, (SELECT COALESCE(MAX(rev_timestamp), 'never') FROM revision WHERE rev_user = user_id) AS last_edit, (SELECT COALESCE(MAX(log_timestamp), 'never') FROM logging_ts_alternative WHERE log_user = user_id AND log_type IN ('abusefilter', 'block', 'delete'

Pathoschild

/*

This script is meant to be used with a Google Sheets spreadsheet. When you edit a cell containing a
valid CSS hexadecimal color code (like #000 or #000000), the background color will change to that
color and the font color will be changed to the inverse color for readability.

To use this script in a Google Sheets spreadsheet:
1. go to Tools » Script Editor;
2. replace everyting in the text editor with this code;
3. click File » Save;

Pathoschild

/**
 * This script generates a Markdown table of contents for a GitHub wiki page.
 * The end result is a block like this:
 * 
 *     ## Contents
 *     * [Header](#header)
 *       * [Subheader](#subheader)
 *         * [Sub-subheader](#sub-subheader)
 *         * [Sub-subheader 2](#sub-subheader-2)
 *     * [Header 2](#header-2)

Pathoschild

var input = "95/e 93/k 94/t 1800 1950/i 136/y 2";
(function(conditionString) {
	"use strict";

	let conditions = conditionString.split("/");

	// define parsers
	let parsers = [
		// event ID
		// <id>

Pathoschild

Here are the mods I recommend. These are all compatible with the latest versions of SMAPI and Stardew Valley on Linux/macOS/Windows. See the player's guide to using mods if you're interested.

Quality of life

I think the best mods are those which improve the game while maintaining its balance, lore, and style.

• AutoGate
  Gates open automatically when you approach and close behind you.

• Better Sprinklers Plus
  Customise the sprinkler radius, with a proportional change to their cost. If you're willing to mine all the ores you'll need, that makes the basic sprinklers useful early in the game and lets you do more than just watering crops every day.

Pathoschild

Merged into Pathoschild/StardewScripts.

Pathoschild

Merged into Pathoschild/StardewScripts.

Pathoschild

Merged into Pathoschild/StardewScripts.

Pathoschild

Merged into Pathoschild/StardewScripts.