Skip to content

Instantly share code, notes, and snippets.

View jarodthornton's full-sized avatar

Jarod Thornton jarodthornton

View GitHub Profile
@jarodthornton
jarodthornton / review-robin.txt
Created May 5, 2022 03:27
ReviewRobin Reviews Widget - Hide white label and remove border radius
<style>
span.review-verified {
display: none;
}
div#widget_div {
border-radius: 0px;
}
</style>
@jarodthornton
jarodthornton / embed-loom-kbee.txt
Created October 13, 2021 15:57
Loom Embed Code for Google Docs using Kbee
<iframe width="720" height="405" src="https://www.loom.com/embed/3110e657b2c6410a96bc7700d5b5e18f" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
@jarodthornton
jarodthornton / clear_prod_db.sql
Created September 16, 2021 16:33
WooCommerce Clear Product Database
DELETE relations.*, taxes.*, terms.*
FROM wpa12_term_relationships AS relations
INNER JOIN wpa12_term_taxonomy AS taxes
ON relations.term_taxonomy_id=taxes.term_taxonomy_id
INNER JOIN wpa12_terms AS terms
ON taxes.term_id=terms.term_id
WHERE object_id IN (SELECT ID FROM wpa12_posts WHERE post_type='product');
DELETE FROM wpa12_postmeta WHERE post_id IN (SELECT ID FROM wpa12_posts WHERE post_type = 'product');
DELETE FROM wpa12_posts WHERE post_type = 'product';
DELETE a,c FROM wpa12_terms AS a
@jarodthornton
jarodthornton / gsheets-json.php
Last active April 16, 2021 13:51
Google Spreadsheets to HTML via JSON
<html>
<head>
<title>GameWeek Winners</title>
<style>
</style>
</head>
<body>
<div class="header">
<h1>GameWeek Winners</h1>
</div>
@jarodthornton
jarodthornton / gmb-hours.php
Last active January 19, 2024 00:41
WordPress Shortcode to output Google My Business Hours
<?php
// Shortcode to output GMB hours
// Use [hours] shortcode
// By Jarod Thornton https://jarodthornton.com
// And Adopt the Web https://adopttheweb.com
function atw_gmb_hours() {
// Get Google Places ID here: https://developers.google.com/maps/documentation/places/web-service/place-id#save-id
// Input the Google Places ID here
$gmb_place_id = '_id_';
// Input the API key here