Skip to content

Instantly share code, notes, and snippets.

View bstonedev's full-sized avatar

Brett Stone bstonedev

4 followers · 2 following
View GitHub Profile
@bstonedev
bstonedev / make-the-$-issues-go-away.js
Created June 29, 2020 00:13
Make the $ Issues Go Away
var $ = jQuery.noConflict();
@bstonedev
bstonedev / fav-excel-formulas.md
Last active July 11, 2020 04:16
Favourite Excel Formulas (Work In Progress)

TEXTJOIN

Combine text across a bunch of cells into one cell =TEXTJOIN("",TRUE,A2:A10)

EXCTRACT FIRST N NUMBER OF SENTENCES OUT OF STRING IN CELL

Replace 3 with the number of sentences you wish to extract. =TRIM(LEFT(A2,FIND("^",SUBSTITUTE(TRIM(A2)&".",".","^",3))-1))&"."

@bstonedev
bstonedev / mac-keyboard-shortcuts-to-reduce-stress.md
Last active June 24, 2020 03:53
Mac keyboard shortcuts that save a lot of stress!

Alternate between open programs

⌘ + Tab

Alternate between open windows of the same program

⌘ + `

Paste Special -> Values within Excel (AMAZING)

⌘ + option + V THEN V THEN enter

Quit application

⌘ + Q

Close current tab in Chrome

⌘ + W

@bstonedev
bstonedev / hide-scrollbar.css
Created June 20, 2020 08:51
Hide Scrollbar with CSS
::-webkit-scrollbar {
display: none;
}
@bstonedev
bstonedev / wp-security-checklist.md
Last active June 19, 2020 22:29
WordPress Security Checklist
  • use SFTP (Port: 22) to tranfer files
  • scan for vulnerabilities using WPScan: https://wpscan.org/
  • require 2FA for any users with 'Administrator' access
  • give clients 'Editor' access and below
  • revoke DROP, ALTER and GRANT privileges in MySQL database
  • add define('DISALLOW_FILE_EDIT', true); to wp-config.php
  • setup regular backups via installatron or preferred wp plugin
  • setup firewalls at WordPress level (Wordfence), Web Application level and CDN (if required)
  • remove WordPress version number from header
@bstonedev
bstonedev / terminal-commands.txt
Created June 7, 2020 00:33
MacOS Terminal Commands - Quick Reference
## Controls ##
control D # exit bash session
## Commands ##
file # show file type
cat # show file content in terminal
less # use page reader in termainl
open # open file
ls # list files in directory
ls a* # list all files that start with an 'a'
@bstonedev
bstonedev / tasks-in-mac-os-activity-mointor-that-are-ok.md
Last active November 16, 2021 00:34
List of Tasks in macOS activity monitor that are ok

For another great resource on this topic, see https://gist.github.com/miguelmota/201895350b8fd10622032e0fbad8cee4

Task Description Reference
launchd macOS 'service management framework' howtogeek.com
sysmond System Monitor Daemon, monitors all system activity in background and automated by launchd stackoverflow.com
kernel_task It's the kernel! howtogeek.com
hidd This daemon interprets all of your mouse movements and keyboard taps howtogeek.com
mds / mdworker / mds_stores These processes are part of macOS's Spotlight search tool [howtogeek.com](https://www.howtogeek.com/
@bstonedev
bstonedev / www-to-non-www-https.txt
Last active May 14, 2020 22:13
My fav 'redirect www URLs to non-www https URLs' .htaccess snippet
RewriteEngine On
RewriteCond %{HTTP_HOST} ^www.yourdomain.com [NC]
RewriteRule ^(.*)$ http://yourdomain.com/$1 [L,R=301]
RewriteCond %{HTTP_HOST} ^yourdomain.com [NC]
RewriteRule ^(.*)$ http://yourdomain.com/$1 [L,R=301]
@bstonedev
bstonedev / theme-kit-commands.md
Created April 15, 2020 07:39
Top 3 Shopify Theme Kit Commands

https://shopify.github.io/themekit/commands/

Get

theme get --password=[your-api-password] --store=[your-store.myshopify.com] --themeid=[your-theme-id]

Watch

theme watch --password=[your-api-password] --store=[your-store.myshopify.com] --themeid=[your-theme-id]

Get Theme ID

theme get --list -p=[your-api-password] -s=[your-store.myshopify.com]

@bstonedev
bstonedev / acf-repeater-field-loop-methods.php
Created April 13, 2020 01:52
Different loops thru ACF Repeater Fields
<?php
/*
// Method 0: while-loop
*/
if( have_rows('repeater_field_name') ):
while ( have_rows('repeater_field_name') ) : the_row();
?>
<h2>Sub Field: <?php the_sub_field('sub_field_name'); ?></h2>