aiiddqd

<?php

if(empty($_GET['username']) ){
        $_GET['username'] = 'vagrant';
}

function adminer_object() {
  class AdminerSoftware extends Adminer {
                function credentials() {

aiiddqd

/**
* AJAX обертка для WordPress REST API
*/

let sb_ajax = function ( ep, success, error, type = 'GET', data = '' ) {

    url = wpApiSettings.root + ep;
    // Feature detection
    if ( !window.XMLHttpRequest ) return;

aiiddqd

 gzip -d backup-20100910164109.sql.gz

aiiddqd

Search and replace
https://wp-cli.org/commands/search-replace/
wp search-replace
wp search-replace 'http://example.dev' 'http://example.com'

Optmize database
https://wp-cli.org/commands/db/optimize/
wp db optimize

Repair database

aiiddqd

DELETE cm
FROM wp_commentmeta as cm
LEFT JOIN wp_comments as c ON c.comment_ID = cm.comment_id
WHERE c.comment_ID is null

aiiddqd

-- WordPress - Comments 1 year ago
SELECT * 
FROM wp_comments as c 
WHERE c.comment_date_gmt < DATE_SUB(NOW(),INTERVAL 1 YEAR)
ORDER BY c.comment_date_gmt DESC
LIMIT 50

aiiddqd

-- delete comments 1 year ago
DELETE c
FROM wp_comments as c 
WHERE c.comment_date_gmt < DATE_SUB(NOW(),INTERVAL 1 YEAR)

aiiddqd

function getCookie(name) {
  let matches = document.cookie.match(new RegExp(
    "(?:^|; )" + name.replace(/([\.$?*|{}\(\)\[\]\\\/\+^])/g, '\\$1') + "=([^;]*)"
  ));
  return matches ? decodeURIComponent(matches[1]) : undefined;
}

function setCookie(name, value, options = {}) {

  options = {

aiiddqd

<?php

add_action('u/log', function($msg, $data = []){

    error_log( PHP_EOL . $msg);
    if(!empty($data)){
        ob_start();
        echo PHP_EOL;
        var_dump($data);
        error_log(ob_get_clean());

aiiddqd

<?php
namespace SB\Models;

/**
 * Class Event model for map data
 *
 * @package SB
 */
class Event {
  /**