Discover gists

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

Note

This does not works in browser for quests which require you to play a game! Use the desktop app to complete those.

How to use this script:

by xero updated 10.29.24

This spec uses a custom CAIP-2 namespace for Hyperliquid L1 (HyperCore):

	;SMBDIS.ASM - A COMPREHENSIVE SUPER MARIO BROS. DISASSEMBLY
	;by doppelganger (doppelheathen@gmail.com)

	;This file is provided for your own use as-is. It will require the character rom data
	;and an iNES file header to get it to work.

	;There are so many people I have to thank for this, that taking all the credit for
	;myself would be an unforgivable act of arrogance. Without their help this would
	;probably not be possible. So I thank all the peeps in the nesdev scene whose insight into
	;the 6502 and the NES helped me learn how it works (you guys know who you are, there's no

	{
	"workbench.startupEditor": "newUntitledFile",
	"editor.fontSize": 16,
	"editor.lineHeight": 1.8,
	"javascript.suggest.autoImports": true,
	"javascript.updateImportsOnFileMove.enabled": "always",
	"editor.rulers": [
	80,
	120
	],

	services:
	vaultwarden:
	image: vaultwarden/server:latest-alpine
	container_name: vaultwarden
	restart: unless-stopped
	environment:
	SIGNUPS_ALLOWED: false
	WEBSOCKET_ENABLED: true
	PUSH_ENABLED: true
	PUSH_INSTALLATION_ID:

	"""
	The most atomic way to train and run inference for a GPT in pure, dependency-free Python.
	This file is the complete algorithm.
	Everything else is just efficiency.

	@karpathy
	"""

	import os # os.path.exists
	import math # math.log, math.exp

	# Disables PowerShell telemetry by setting the environment variable associated with it.
	# More info: https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_telemetry

	#Requires -RunAsAdministrator

	# See this for more info:
	# https://gist.github.com/asheroto/5c1711fcbd888c5a621b1ff0b91dfc00
	# Bypasses the typical delay experienced with Environment.SetEnvironmentVariable, which can be slow due to its broadcasting a message to all top-level windows.
	# These functions offer a more efficient alternative for getting, setting, or deleting environment variables.
	function Set-EnvironmentVariable {

	#!/bin/sh

	# below is based on this forgejo actions admin guide: https://forgejo.codeberg.page/docs/v1.20/admin/actions/

	PORT=8621
	TOKEN=XXXXXXX_REPLACE_TOKEN_HERE_XXXXXXXX
	URL=https://yourinstancehere.org
	UID=`id -u`
	docker=`which docker \|\| which podman`
	test -d data \|\| mkdir data