Skip to content

Instantly share code, notes, and snippets.

🍜
Ramen connoisseur

Jess Green jesgs

🍜
Ramen connoisseur
Block or report user

Report or block jesgs

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@jesgs
jesgs / Three Wise Monkeys.md
Created May 8, 2018 — forked from malarkey/Three Wise Monkeys.md
Three Wise Monkeys (NDA)
View Three Wise Monkeys.md

Date: [date]

Between us [company name] and you [customer name].

Summary:

In short; neither of us will share any confidential information about each-other, by any means, with anyone else.

What’s confidential information?

@jesgs
jesgs / Contract Killer 3.md
Created May 8, 2018 — forked from malarkey/Contract Killer 3.md
The latest version of my ‘killer contract’ for web designers and developers
View Contract Killer 3.md

Contract Killer

The popular open-source contract for web professionals by Stuff & Nonsense

  • Originally published: 23rd December 2008
  • Revised date: March 15th 2016
  • Original post

@jesgs
jesgs / deploying-from-github-to-vps-using-travis-ci.md
Last active Feb 9, 2020
Deploying from Github to VPS using Travis CI
View deploying-from-github-to-vps-using-travis-ci.md

From: https://www.jesgs.com/blog/2017/12/18/deploying-from-github-to-vps-using-travis-ci

Recently, I spent around 14 to 16 hours learning all of the necessary steps to getting an existing repo set up with Travis CI to run unit tests, and then once successful, connect to a remote server that isn't a PaaS (in this case, Linode) and then proceeds to use Git hooks to do post deployment things.

Starting with your local machine and you have your project already checked out from Github.

Setting Up

  • Assuming you have Ruby (at least 2.3.1) installed, run gem install travis. This installs the Travis CI command-line tools. We're going to use these tools to encrypt RSA keys that Travis will use to connect to your remote server.
  • This tutorial also assumes that you have a working repo and a Travis-CI account set up.
@jesgs
jesgs / README-WordPress-FULLTEXT-Search.md
Last active Jan 18, 2020
WordPress Full Text Search Examples
View README-WordPress-FULLTEXT-Search.md

Adding MySQL FULLTEXT Support to WordPress

FULLTEXT support to WordPress is simple if you have access to phpMyAdmin. If not, it can still be done but is a little trickier if you’re not used to command-line. We’ll demonstrate how to modify your WordPress database using phpMyAdmin.

How To Modify Database

  1. Start out by having a set of keywords to test against. You’ll need ‘before’ and ‘after’ test results. Also, I can’t stress this enough but back up your database before proceeding!

  2. Next, log into your phpMyAdmin page and navigate to your {prefix}_posts table.

  3. Click on the “Structure” tab.

@jesgs
jesgs / .travis.yml
Last active Apr 21, 2019
Bare-bones .travis.yml file.
View .travis.yml
language: php
php:
- 7.1.11
dist: trusty
sudo: false
services:
- mysql
@jesgs
jesgs / README-git-hooks.md
Last active Dec 8, 2017
Git post-receive hook for running npm run production on Laravel installs
View README-git-hooks.md

Just some git hooks I'm putting together

View theme-template-example.php
<?php
/**
* Theme view template example using locate_template
*
* @return string
*/
function my_theme_template()
{
// do view related stuff
@jesgs
jesgs / create_php_array.sql
Created Jun 10, 2017
Generate a PHP array from a sql query
View create_php_array.sql
-- I'm lazy so this is what I did
SELECT CONCAT("['id' => ", id, ", 'some_column_string' => '", some_column, "'],") FROM mytable;
@jesgs
jesgs / config
Created Jun 6, 2017 — forked from ThatGerber/config
SSH Config
View config
Host *
Compression yes
ControlMaster auto
ControlPath /tmp/ssh-conn-%r@%h:%p.con
ControlPersist 30
ForwardAgent yes
ServerAliveInterval 100
IdentityFile ~/.ssh/id_rsa
AddKeysToAgent yes
UseKeychain yes
View explode-stored-procedure.sql
DELIMITER |
CREATE PROCEDURE explode( pDelim VARCHAR(32), pStr TEXT)
BEGIN
DROP TABLE IF EXISTS temp_explode;
CREATE TEMPORARY TABLE temp_explode (id INT AUTO_INCREMENT PRIMARY KEY NOT NULL, word VARCHAR(40));
SET @sql := CONCAT('INSERT INTO temp_explode (word) VALUES (', REPLACE(QUOTE(pStr), pDelim, '\'), (\''), ')');
PREPARE myStmt FROM @sql;
EXECUTE myStmt;
END |
You can’t perform that action at this time.