Skip to content

Instantly share code, notes, and snippets.

View johnparn's full-sized avatar

Rover johnparn

1 follower · 0 following
View GitHub Profile
@johnparn
johnparn / remove_wp_users_by_role.md
Created April 12, 2022 06:15

Remove Wordpress users by role

This scripts removes users with the role subscriber or customer using SQL-script in MySQL.

-- Identify users to be removed
SELECT wp_users.ID, wp_users.user_nicename 
FROM wp_users INNER JOIN wp_usermeta 
ON wp_users.ID = wp_usermeta.user_id
@johnparn
johnparn / server.js
Created October 23, 2019 11:47
Custom server.js for NextJS in order to proxy requests to backend api
/**
* Custom server.js for NextJS in order to proxy requests to backend api
*
* Create server.js in root dir, adjust scripts in package.json
*
* "scripts": {
* "dev": "node server.js",
* "start": "NODE_ENV=production node server.js"
* }
*/
@johnparn
johnparn / progressbar.html
Created July 3, 2019 18:59
<html>
<head>
<title>Progress bar</title>
<style>
progress {
width: 100%;
height: 2px;
-webkit-appearance: none;
}
@johnparn
johnparn / add_existing_project_to_github.md
Last active January 29, 2018 08:16

Add existing project to Github

Initialize the directory as a Git repository.

git init

Add files to local repository.

@johnparn
johnparn / gist:5caf58ce9eeb898645ca31423669646c
Created January 29, 2018 06:59 — forked from CristinaSolana/gist:1885435
Keeping a fork up to date

1. Clone your fork:

git clone [email protected]:YOUR-USERNAME/YOUR-FORKED-REPO.git

2. Add remote from original repository in your forked repository:

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream
@johnparn
johnparn / index.js.diff
Last active January 18, 2018 12:04
Diff of /storage-adapter/packages/oc-s3-storage-adapter/
diff --git a/packages/oc-s3-storage-adapter/index.js b/packages/oc-s3-storage-adapter/index.js
index d6a552c..aebc7ed 100644
--- a/packages/oc-s3-storage-adapter/index.js
+++ b/packages/oc-s3-storage-adapter/index.js
@@ -27,26 +27,42 @@ module.exports = function(conf) {
return true;
};
+ // Defaults
+ const bucket = (conf.bucket) ? conf.bucket : '';
@johnparn
johnparn / create-registry index.js
Last active January 18, 2018 12:12
Update of oc-s3-storage-adapter to connect to RiakCS
"use strict";
// Same config as the direct connection script above, however tries to connect to s3.amazonaws.com
const AWS = require('aws-sdk');
const oc = require('oc');
var configuration = {
verbosity: 0,
baseUrl: 'http://localhost',
port: 3333,
@johnparn
johnparn / age.sql
Created January 18, 2016 09:05
-- Get age from birthdate
select (
case when
datepart(year,[BirthDate])>(1900)
AND datepart(year,[BirthDate])<datepart(year,getdate())
AND (datepart(month,[BirthDate])>=(1)
AND datepart(month,[BirthDate])<=(12))
AND (datepart(day,[BirthDate])>=(1)
AND datepart(day,[BirthDate])<=(31))
then