Radon8472

#!/usr/bin/env bash

#
# Script copies the whole database from one server to another on the same host
#
# on import-time occours an error 1227 '... Access denied; you need the SUPER privilege(s) ...' 
# if you have views in your source db.
# the reason is an enabled the binary log on the sql server.
#
# because only the `DEFINER user@host` line is the problem, we fix id with sed-replacement

Radon8472

-- Queries for Shopware 5.2.1

SET @templateID = (SELECT `id` FROM `s_core_templates` WHERE
                   `template` = 'Theme_Directory'
                   -- `name`     ='Themename'
                   LIMIT 1);


-- SELECT DISTINCT *
DELETE `s_core_templates`, `s_core_templates_config_set`, `s_core_templates_config_layout`, `s_core_templates_config_elements`, `s_core_templates_config_values`, `s_core_snippets`

Radon8472

<?php

class Mailer extends PHPMailer {

    /**
     * Save email to a folder (via IMAP)
     *
     * This function will open an IMAP stream using the email
     * credentials previously specified, and will save the email
     * to a specified folder. Parameter is the folder name (ie, Sent)

Radon8472

<?php

  /**
   * prints the php errorlevel for phpinfo
   *
   * @param int [$errorlevel]
   *
   * @todo add format option, or implement diffent displays for Commandline and Server (check sapi)
   */
  function phpinfo_block_errorlevel($errorlevel = null)

Radon8472

<?php
  /**
   * @see: https://github.com/guzzle/guzzle/blob/master/UPGRADING.md#migrating-to-middleware
   * @see: http://docs.guzzlephp.org/en/stable/handlers-and-middleware.html
   **/

	$handler = \GuzzleHttp\HandlerStack::create();

	// watch request
	$handler->push(\GuzzleHttp\Middleware::mapRequest(function (\psr\Http\Message\RequestInterface $request) {

Radon8472

{
  "comments": [
      "in some situations a '.git' folder is created in target-dir. Specially for custom-modul type e.g. 'pw-module'",
      "this is a big problem. Sometimes even the config 'preferred-install' has no effect."
      "So this scripts will remove the folders after install/update. It works, but is not the best solution, because"
      "custom-package types could be installed somewhere else."
      "@see: https://github.com/composer/composer/issues/7058#issuecomment-588162369"
    ],
  
  

Radon8472

#
# this file should ask for password, but only when we are on develop-domain
# on all other hosts it should allow access without requsting user data
#

# SetEnvIf Host develop.myserver.de passreq
SetEnvIf Host "^develop\.([^\.]*)\.de$" passreqprev

AuthType Basic
AuthName "Password Required"

Radon8472

<?php
  /**
   * Helper function to avoid problems with the switches argument order of implode since php 7.4.0
   *
   * @see: https://www.php.net/manual/function.implode.php
   * @see: https://3v4l.org/MZRZA
   *
   * @param String $glue
   * @param array  $pieces
   *

Radon8472

#
# exports multiple patches for a commit-range
# you can choose to select only commits matching a specific sub_dir
#
# usage: export-git-patches [commit_range] [sub_dir]
#

if [ $# -gt 1 ]; then
  commit_range=$1
  commit_path="$2"

Radon8472

<?php
/**
 * test - gitdiff.cmd.php
 *
 * written      : 2018-05-01 by Radon8472
 * last modified: 2019-06-22 by Radon8472
 *
 * @requires: https://github.com/TheFrozenFire/PHP-NBT-Decoder-Encoder
 *
 * reads nbt or dat-file from commdline parameter or Standard-input, to use it in git-diff textconv