Skip to content

Instantly share code, notes, and snippets.

View bschulz87's full-sized avatar
🍉

Benjamin Schulz bschulz87

🍉
  • Germany, Berlin
View GitHub Profile
@bschulz87
bschulz87 / gist:74315bc555b502250200ee79a0ad3a7b
Created October 23, 2023 14:34
Simple case insensitive search replace wordpress meta values
SET @old = "Holzbraun";
SET @new = "wooden";
SET @meta_key = "color";
UPDATE wp_postmeta
SET meta_value = REPLACE(REPLACE(meta_value,@old,@new),LOWER(@old),@new)
WHERE LOWER(meta_value) LIKE LOWER(CONCAT('%',@old,'%')) AND meta_key = @meta_key;
SELECT meta_id, post_id, meta_key, meta_value
FROM wp_postmeta
From 7f8939186cb26bf950c6326657edc0b973a8709c Mon Sep 17 00:00:00 2001
From: Benjamin Schulz <benjamin.schulz@apprime.de>
Date: Wed, 14 Sep 2022 14:29:28 +0200
Subject: [PATCH] Fix starqltechn
---
META-INF/com/google/android/update-binary | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/META-INF/com/google/android/update-binary b/META-INF/com/google/android/update-binary
@bschulz87
bschulz87 / Time-based-auto-scaling-on-fargate.md
Created April 10, 2020 08:44 — forked from toricls/Time-based-auto-scaling-on-fargate.md
Example: Time-based Auto Scaling on Amazon ECS + AWS Fargate

Set parameters

$ export ECS_CLUSTER_NAME={YOUR_ECS_CLUSTER_NAME}
$ export ECS_SERVICE_NAME={YOUR_ECS_SERVICE_NAME}

RegisterScalableTarget

@bschulz87
bschulz87 / index.html
Created February 12, 2019 15:15
vue-matomo with external tracking client
<!DOCTYPE html>
<html lang="en">
<head>
<!-- ... --->
<script src="https://my.matomo.cloud/matomo.js"></script>
<!-- ... --->
</head>
<body>
<!-- ... --->
</body>
@bschulz87
bschulz87 / controls.php
Last active February 5, 2020 16:12
Elementor Custom Control
<?php
namespace ElementorControls;
if ( ! defined( 'ABSPATH' ) ) exit; // Exit if accessed directly
class Elementor_Custom_Controls {
private static $_instance = null;
@bschulz87
bschulz87 / Query.vue
Last active October 7, 2019 09:04
Squidex GraphQL Query
<template lang="pug">
div {{ api }}
</template>
<script>
import { queryCMS } from '@/api'
export default {
data: () => ({
api: null
}),
@bschulz87
bschulz87 / .env
Last active September 14, 2021 12:18
Pydio Cells Docker Compose
PYDIO_URL=my.pydio.cells
MYSQL_ROOT_PASSWORD=rootPassword
MYSQL_DATABASE=pydio
MYSQL_USER=cells
MYSQL_PASSWORD=password
@bschulz87
bschulz87 / backup.sh
Last active May 26, 2018 20:46
Docker Volume Backup
#loomchild
docker run -v MYVOLUME:/volume -v /tmp:/backup loomchild/volume-backup \
backup MYVOLUME
#alpine
docker run -it -v MYVOLUME:/volume -v /tmp:/backup alpine \
tar -cjf /backup/MYVOLUME.tar.bz2 -C /volume ./
@bschulz87
bschulz87 / actions.js
Created May 23, 2018 13:56
Vuex API Example
import api from '@/api'
const getArticle = ({commit}) => {
return new Promise((resolve, reject) => {
api.getArticle().then((result) => {
if (result) {
commit('UPDATE_ARTICLE', result)
resolve('Successfully got article')
} else {
reject(Error('Could not get article'))
@bschulz87
bschulz87 / _id.vue
Last active November 17, 2021 18:45
Nuxt.js Static GraphQL Queries powered by Axios
<template>
<div v-if="Car">
<h3>{{ Car.make }} {{ Car.model }}</h3>
<img :src="Car.photoURL" :alt="`${Car.model} photo`">
<p><nuxt-link to="/">Home page</nuxt-link></p>
</div>
</template>
<script>
import staticData from '~/plugins/axios-ecstatic'