le717

SET @year = 2023;

-- Get all hosts
SELECT
	h.handle AS `Host`,
	hd.date AS `Hosting period start date`
FROM hosts h
	INNER JOIN host_dates hd
		ON h._id = hd.host_id
WHERE

le717

SET @year = 2022;

-- Get all hosts
SELECT
	w.handle AS `Host`,
	wd.date AS `Hosting period start date`
FROM writers w
	INNER JOIN writer_dates wd
		ON w.uid = wd.uid
WHERE

le717

"""Transparent app/non-app context Jinja rendering setup.

Use this module whenever you need to render Jinja templates outside
the app context or in code that is shared between app/non-app contexts,
such as in Celery tasks.

If available, the app context renderer will be used. Otherwise, a mostly
identical Jinja render environment will be created, with the caveat that
it may not be as efficient and will not support all Flask-provided
convenience rendering features.

le717

from html import unescape
from pathlib import Path
from xml.etree import ElementTree


all_memos = Path().rglob("memo_content.xml")
output_dir = Path("output")
output_dir.mkdir(exist_ok=True)

for memo in all_memos:

le717

# Get a link to the root AppData folder
$appdata = $(Join-Path -Path $(Resolve-Path ~) -ChildPath "AppData")
Write-Host "Searching for Normal.dotm in $($appdata)"
Write-Host "This may take some time..."

# Search for the Normal.dotm file
$results = Get-ChildItem -Path $appdata -Filter Normal.dotm -Recurse -ErrorAction SilentlyContinue -Force

# It found the file
if ($results -ne $null) {

le717

export function find_parent(element, selector) {
  // The desired element was not found on the page
  if (element === null) {
    return null;
  }

  // We found the desired element
  if (element.matches(selector)) {
    return element;

le717

@current_app.before_request
def detect_ie_browser():
    """Redirect all IE visitors to a special page
    informing them to get a web browser.
    """
    # For this to work, the following conditions must be met:
    # 1. The visitor is using IE (doesn't matter what version)
    # 2. We must not be currently requesting a static file
    # (we still need page styles/resources to load)
    # 3. We don't need to be directly requesting the special page

le717

"""
LEGO Backlot dummy server.

Used to save/load player progress.

Original PHP code by JrMasterModelBuilder.
Ported to Python by le717.
"""

le717

<?php

  function sqlURL($sql_input) {
    $res = parse_url($sql_input);
    
    if(!isset($res['scheme'])) {
      $sql_input = "http://".$sql_input;
    }
    
    $sql_input = str_replace("'","\'",stripslashes($sql_input));

le717

<?php
	function makeSQLsafe($sql_input) {
		$sql_input = str_replace("'","\\'",stripslashes($sql_input));
		$sql_input = str_replace('"','\\"',$sql_input);
		$sql_input = str_replace(';','\\;',$sql_input);
		//$sql_input = str_replace('%','\\%',$sql_input);
		//$sql_input = str_replace('_','\\_',$sql_input);
		$sql_input = str_replace("&","&amp\\;",$sql_input);
		$sql_input = str_replace("<","&lt\\;",$sql_input);
		$sql_input = str_replace(">","&gt\\;",$sql_input);