Skip to content

Instantly share code, notes, and snippets.

Avatar

Benji Bilheimer benjibee

9 followers · 15 following
View GitHub Profile
@benjibee
benjibee / convert_excel_to_date.php
Last active Oct 12, 2021
Convert Excel date / time to PHP date
View convert_excel_to_date.php
<?php
/**
* Convert date and time from Excel into a PHP DateTime object
*
* Based on similar function from PHPExcel library.
*
* @see https://stackoverflow.com/a/11172688/401980
* @see http://www.cpearson.com/excel/datetime.htm
*/
@benjibee
benjibee / update_meta.php
Created Dec 16, 2020
Update WordPress attachment meta
View update_meta.php
$args = [
'post_type' => 'attachment',
'post_mime_type' => 'image',
'numberposts' => -1,
'post_status' => null,
'post_parent' => null,
];
$attachments = get_posts($args);
@benjibee
benjibee / functions.php
Last active Apr 21, 2020
Wordpress: Move adminbar to bottom, expand on hover
View functions.php
<?php
// move admin bar to bottom of screen when viewing site
function benjibee_modify_adminbar()
{
?>
<style>
div#wpadminbar {
top: auto;
bottom: 0;
@benjibee
benjibee / maintenance.php
Last active Nov 25, 2019
Default Maintenance Page for Wordpress
View maintenance.php
<?php
// place in wp-content directory to
// automatically override default page
http_response_code(503);
wp_load_translations_early();
?><!DOCTYPE html>
<html>
@benjibee
benjibee / scrape.js
Created Feb 10, 2018
A little script to import starred places saved as geoJSON data from Google Maps. Could be better. Works.
View scrape.js
// This script is meant to import Google Maps starred places into
// another Google account.
// Given a geoJSON file of Google Maps starred places (places.json)
// exported by Google takeout (account backup) this script should
// open each place URL and manually click save.
// Upon first run, it's best to stop it and manually login to your
// Google account otherwise you'll run into a non-verified device
// issue. Run again and it should continue through with problems.
@benjibee
benjibee / functions.php
Created Sep 15, 2016
View functions.php
/*
*
* NOT YET IMPLEMENTED FUNCTIONALITY!! EEEEEEP!!!!
*
* Taken from ticket: #16784
* https://core.trac.wordpress.org/attachment/ticket/16784/16784.diff
*
* NOT YET IMPLEMENTED FUNCTIONALITY!! EEEEEEP!!!!
*
*
@benjibee
benjibee / index.php
Created Feb 2, 2015
BitBucket Webhook
View index.php
<?php
/*
* ButBucket Webhook `git pull` automation v0.1
* @author Benji Bilheimer
*
* If a directory matching the repository name is found
* in BASE_PATH, CD into that directory and run a git pull.
*
*/
@benjibee
benjibee / deploy.php
Created Aug 6, 2014
Bitbucket Deploy Hook
View deploy.php
<?php
define('REPO_PATH', '/repositories/');
define('STAGING_PATH', '/htdocs/dev/');
define('PRODUCTION_PATH', '/htdocs/');
$git = 'git';
$update = false;
@benjibee
benjibee / flac_to_mp3
Created Jun 23, 2014
Convert FLAC to Mp3 (AAC)
View flac_to_mp3
brew install ffmpeg
## cd into the folder containing the FLAC files
for f in *.flac; do ffmpeg -i "$f" -aq 1 "${f%flac}mp3"; done
@benjibee
benjibee / url_matcher.php
Last active Apr 8, 2018
Extracts any one URL in the given string and assigns it to a variable.
View url_matcher.php
<?php
$new_entry['url'] = FALSE;
$new_entry['description'] = 'Hello there! example.com';
$pattern_url = "`("
. "(https?://)?"
. "([a-z\d-]+\.)+"
. "(MUSEUM|TRAVEL|AERO|ARPA|ASIA|EDU|GOV|MIL|MOBI|COOP|INFO|NAME|BIZ|CAT|COM|INT|JOBS|NET|ORG|PRO|TEL|A[CDEFGILMNOQRSTUWXZ]|B[ABDEFGHIJLMNORSTVWYZ]|C[ACDFGHIKLMNORUVXYZ]|D[EJKMOZ]|E[CEGHRSTU]|F[IJKMOR]|G[ABDEFGHILMNPQRSTUWY]|H[KMNRTU]|I[DELMNOQRST]|J[EMOP]|K[EGHIMNPRWYZ]|L[ABCIKRSTUVY]|M[ACDEFGHKLMNOPQRSTUVWXYZ]|N[ACEFGILOPRUZ]|OM|P[AEFGHKLMNRSTWY]|QA|R[EOSUW]|S[ABCDEGHIJKLMNORTUVYZ]|T[CDFGHJKLMNOPRTVWZ]|U[AGKMSYZ]|V[ACEGINU]|W[FS]|Y[ETU]|Z[AMW])+"
. "(:\d+)?"
. "((/([a-z0-9\._/~%\-\+&\#\?!=\(\)@]+)?)*)"