Skip to content

Instantly share code, notes, and snippets.

View nurtext's full-sized avatar
🚀
Don't tell me the sky is the limit, when there are footprints on the moon

Cedric Kastner nurtext

🚀
Don't tell me the sky is the limit, when there are footprints on the moon
12 followers · 4 following
View GitHub Profile
@nurtext
nurtext / additional_queries.sql
Last active January 8, 2019 11:07 — forked from jashk/wp_offload_media_db_migrate.json
Migrate a WordPress database so that existing media items are served from Amazon S3 or CloudFront. Requires the WP Offload S3 Lite plugin.
--- Updated queries for a bedrock-setup which doesn't use the default path settings
UPDATE wp_posts SET post_content = REPLACE(post_content, 'href="https://your-domain.tld/app/uploads/', 'href="https://your-cdn-url.tld/');
UPDATE wp_posts SET post_content = REPLACE(post_content, 'src="https://your-domain.tld/app/uploads/', 'src="https://your-cdn-url.tld/');
UPDATE wp_posts SET post_content = REPLACE(post_content, 'https://your-domain.tld/app/uploads/', 'https://your-cdn-url.tld/');
-- Plugins/Themes that use wp_options to store settings like logo file, etc.
UPDATE wp_options SET option_value = REPLACE(option_value, 'https://your-domain.tld/app/uploads/', 'https://your-cdn-url.tld/');
--- VisualComposer custom CSS
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'https://your-domain.tld/app/uploads/', 'https://your-cdn-url.tld/') WHERE meta_key = '_wpb_shortcodes_custom_css';
@nurtext
nurtext / .htaccess
Last active May 1, 2023 19:24
Tell apache we're on HTTPS if reverse proxy is serving the site using SSL
# Let apache know we're behind a SSL reverse proxy
SetEnvIf X-Forwarded-Proto "https" HTTPS=on
# Redirect to HTTPS
<IfModule mod_rewrite.c>
RewriteEngine on
RewriteCond %{HTTPS} !=on
RewriteCond %{HTTP:X-Forwarded-Proto} !https [NC]
RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
</IFModule>
@nurtext
nurtext / queue.h
Created June 7, 2015 10:59
sys/queue.h from gcc420_glibc236_x64_bromolow-GPL.tgz
/*
* Copyright (c) 1991, 1993
* The Regents of the University of California. All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
* 1. Redistributions of source code must retain the above copyright
* notice, this list of conditions and the following disclaimer.
* 2. Redistributions in binary form must reproduce the above copyright
@nurtext
nurtext / wp-migrate.sh
Created October 6, 2014 14:12
Migrate Wordpress using wp-cli
#!/bin/bash
# Check if wp-cli is installed
command -v wp >/dev/null 2>&1 || { echo >&2 "wp-cli not found. Visit http://wp-cli.org for more details."; exit 1; }
# Show usage info if wrong argument count
if [ $# -ne 2 ]; then
printf "WordPress migration script\n\n"
printf "Usage:\n"
printf " migrate.sh <from url> <to url>\n\n"
@nurtext
nurtext / keybase.md
Created October 1, 2014 12:12
keybase.md

Keybase proof

I hereby claim:

  • I am nurtext on github.
  • I am nurtext (https://keybase.io/nurtext) on keybase.
  • I have a public key whose fingerprint is 2E24 B2EC 678A E429 6488 0477 5286 0A8C 6B1C 2706

To claim this, I am signing this object:

@nurtext
nurtext / accordion.html
Created October 22, 2013 15:56
Simple CSS3 based horizontal accordion
<!doctype html>
<html lang="de">
<head>
<meta charset="utf-8">
<title>CSS3 Accordion</title>
<style>
#accordion {
width: 810px;
height: 600px;
margin: 20px auto;
@nurtext
nurtext / shorthand_return_values.php
Last active December 26, 2015 02:49
Shorthand return values without variable assignment
<?php
// Example class
class Hello
{
// Just a simple function wich returns a string
public function World($name = 'World')
{
return sprintf("Hello %s\n", $name);
}
@nurtext
nurtext / fonts.jsx
Created April 24, 2013 09:52
Javascript to list all fonts used within a Photoshop document. May take a while on large documents to finish…
#target photoshop
function sort_unique(arr)
{
arr = arr.sort();
var ret = [arr[0]];
for (var i = 1; i < arr.length; i++)
{
if (arr[i-1] !== arr[i]) { ret.push(arr[i]); }
@nurtext
nurtext / tomorrow.php
Last active December 16, 2015 13:39
Get tomorrow's date
<?php
// Optional
date_default_timezone_set('Europe/Berlin');
// Set the date to tomorrow (midnight)
$tomorrow = new DateTime('tomorrow');
// Print the result
print_r($tomorrow);
@nurtext
nurtext / brothers_in_binary.php
Last active December 16, 2015 03:39
This code sample tries to find perfect numbers using the „Brothers in Binary“ theorem. For more information visit: http://www.futilitycloset.com/2013/04/09/brothers-in-binary/
<?php
// Loop until the 20th binary digit of 0
for ($bin = 1; $bin < 20; $bin++)
{
// 1 has always one digit more than 0
$bin_str = str_repeat('1', $bin +1) . str_repeat('0', $bin);
// Convert binary to decimal
$dec = bindec($bin_str);