phillipwilhelm

//As referenced in this solution


import { number } from "prop-types";

//https://codepen.io/sosuke/pen/Pjoqqp


interface HSL {
  h: number;

phillipwilhelm

-- split-string-into-rows.sql
-- Duane Hutchins
-- https://www.github.com/duanehutchins
-- Split a string into a mysql resultset of rows
-- This is designed to work with a comma-separated string (csv, SET, array)

-- To use a delimiter other than a comma:
--      Just change all the occurrences of ',' to the new delimiter
--      (four occurrences in SET_EXTRACT and one occurrence in SET_COUNT)

phillipwilhelm

Enhanced onEdit(e) using Google Apps Script

onEdit(e) which is used for the Edit event on Spreadsheet has the old value as e.oldValue. The specifications for this are as follows.

1. When an user edited a single "A1" cell, e of onEdit(e) shows hoge for e.oldValue and fuga for e.value.
2. When an user edited the "A1:A2" multiple cells, e.oldValue and e.value of onEdit(e) are not shown anything.
3. When an user copied and pasted from other cell, e.oldValue and e.value of onEdit(e) are not shown anything.

This sample script was created to retrieve both the edited values and the old values for the range of edited cells. This is the modified e.oldValue.

phillipwilhelm

Introduction

This tuturial will help you configure network for your fresh Proxmox istallation.
Be aware that Proxmox configuration was made using this tutorial.

Installation

Backup your current /etc/network/interfaces using this command:

cp /etc/network/interfaces /etc/network/interfaces.backup

phillipwilhelm

<?php
/**
 *  Add a blank option to a Gravity Forms dropdown
 *
 *  @param   object  $form  The Gravity Form
 *  @return  object  $form  The modified Gravity Form
 */
function wp_gravity_forms_add_empty_dropdown_option( $form ) {
    // Select the correct form, then set the id of the field(s) we need to change
    if( $form['id'] == 1 ) {

phillipwilhelm

function arrayToTable(array $values, array $headers = [])
{
    $options = [
        'tableStyle' => 'border: 1px solid black;border-collapse: collapse;',
        'thStyle'    => 'border: 1px solid black;padding: 5px 7px;text-align: center;',
        'tdStyle'    => 'border: 1px solid black;padding: 5px 7px;text-align: center;',
    ];

    $th = "<th style='" . $options['thStyle'] . "'>";
    $td = "<td style='" . $options['tdStyle'] . "'>";

phillipwilhelm

-- Create the table
CREATE TABLE IF NOT EXISTS `StateBoundaries` (
  `State` varchar(10) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `MinLat` varchar(50) DEFAULT NULL,
  `MaxLat` varchar(50) DEFAULT NULL,
  `MinLon` varchar(50) DEFAULT NULL,
  `MaxLon` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

phillipwilhelm

scriptencoding utf-8

let s:calendar_list = [
      \ ['Australian Holidays', 'en.australian#holiday@group.v.calendar.google.com'],
      \ ['Austrian Holidays', 'en.austrian#holiday@group.v.calendar.google.com'],
      \ ['Brazilian Holidays', 'en.brazilian#holiday@group.v.calendar.google.com'],
      \ ['Canadian Holidays', 'en.canadian#holiday@group.v.calendar.google.com'],
      \ ['China Holidays', 'en.china#holiday@group.v.calendar.google.com'],
      \ ['Christian Holidays', 'en.christian#holiday@group.v.calendar.google.com'],
      \ ['Danish Holidays', 'en.danish#holiday@group.v.calendar.google.com'],

phillipwilhelm

📘 LAMP 📕 MySQL 📘 Terminal 📘 htaccess

---

FIND + REPLACE

phillipwilhelm

<?php
/**
 * PHP GeoJSON Constructor, adpated from https://github.com/bmcbride/PHP-Database-GeoJSON
 */

# Connect to MySQL database
$conn = new PDO('mysql:host=localhost;dbname=mydatabase','myusername','mypassword');

# However the User's Query will be passed to the DB:
$sql = 'SELECT * from GDA_database WHERE user_query = whatever';