mackensen

with qincourse as (
    SELECT 
        q.id AS question_id,
        q.name AS question_name,
        q.stamp as question_stamp,
        qc.id AS quiz_category_id,
        qc.name AS quiz_category_name,
        c.id AS course_id,
        c.fullname AS course_name
        , row_number() over (partition by q.stamp order by q.id) as row_num

mackensen

-- Textconvert
-- Capitalized case adapted from http://stackoverflow.com/questions/20284515/capitalize-first-letter-of-every-word-in-lua
-- Slug code adapted from https://dracoblue.net/dev/convert-titlestring-to-url-slug-in-php-or-lua/
hs.hotkey.bind({"cmd", "alt", "ctrl"}, "T", function()
    local current = hs.application.frontmostApplication()

    local chooser = hs.chooser.new(function(chosen)
        current:activate()
        hs.pasteboard.setContents(chosen.text)
    end)

mackensen

SELECT c.fullname,
       c.shortname,
       c.idnumber,
       CASE
           WHEN EXISTS
                  (SELECT id
                   FROM prefix_logstore_standard_log lsl
                   WHERE lsl.courseid=c.id
                     AND (lsl.crud='c'
                          OR lsl.crud='u')

mackensen

SELECT department,
       COUNT(*) AS courses,
       SUM(CASE
               WHEN active=1 THEN 1
               ELSE 0
           END) active,
       SUM(CASE
               WHEN active=0 THEN 1
               ELSE 0
           END) inactive

mackensen

SELECT c.fullname,
       c.shortname,
       c.idnumber
FROM prefix_course c
WHERE EXISTS
    (SELECT cc.id
     FROM prefix_course_categories cc
     WHERE cc.id=c.category
       AND cc.parent=:term
     LIMIT 1)

mackensen

# Custom docker image which exposes 8080
image: lafayette/hoth:5.5

services:
  - selenium/standalone-chrome:latest

before_script:
  # Use 0.0.0.0 instead of localhost to allow external connections
  - php -S 0.0.0.0:8080 -t ../ &> /dev/null &

mackensen

{
	"translatorID": "3f4f0a1c-f542-4b44-8824-40ee1f921373",
	"label": "Trains News Wire",
	"creator": "Charles Fulton",
	"target": "https?://trn.trains.com/news/news-wire/[0-9]+",
	"minVersion": "3.0",
	"maxVersion": "",
	"priority": 100,
	"inRepository": true,
	"translatorType": 4,

mackensen

<?php

/**
 * @file
 * homebox.tpl.php
 * Default layout for homebox.
 */

?>
<?php global $user; ?>

mackensen

<?php
/**
 * @file
 * Output for main HTML page content.
 */

if ($tabs = render($tabs)):
  ?>
  <div class="tabs">
  <?php

mackensen

// List of modules used.
var gulp    = require('gulp'),
    bump    = require('gulp-bump'),     // Generates new version.
    argv    = require('yargs')
        .default('release', 'patch')
        .argv,                          // CLI parser.
    fs      = require('fs'),            // Used by bump.
    semver  = require('semver'),        // Used by bump.
    git     = require('gulp-git'),      // Git wrapper.
    jshint  = require('gulp-jshint'),   // Lints JS.