kikoseijo

Consultas MYSQL para limpiar bases de datos de wordpress

WORDPRESS R.I.P

• Orphan rows
  • wp_posts -> wp_posts (parent/child)
  • wp_postmeta -> wp_posts
  • wp_term_taxonomy -> wp_terms

kikoseijo

/**
 * Continents and Countries MySQL Tables compiled from Wikipedia, Braintree Payments documentation 
 * and a couple other places I don't recall at the moment.  This data is compatible with the Braintree
 * Payment API as of Dec 2011
 *
 * Compiled by Steve Kamerman, 2011
 */
SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

kikoseijo

<?php
error_reporting(E_ALL);

class AsyncWebRequest extends Thread {
        public $url;
        public $num;
        public $data;

        public function __construct($url, $num){
                $this->url = $url;

kikoseijo

#!/bin/bash

IFS=$'\n'

while read writable_dir
do
    find "$writable_dir" -type f -not -iname '*.php' -print0 | xargs -0 egrep -i "(<\?php|<\?=|<\? *(?!(xml)))" --color
done < writable_dirs.txt

kikoseijo

#!/bin/bash

search_dir=$(pwd)
writable_dirs=$(find $search_dir -type d -perm 0777)

for dir in $writable_dirs
do
    #echo $dir
    find $dir -type f -name '*.php'
done

kikoseijo

#!/bin/bash

IFS=$'\n'

while read php_file
do
    egrep -i "(mail|eval|base64_decode|str_rot13|chmod|fwrite|exec|passthru|shell_exec|system|proc_open|popen|curl_exec|curl_multi_exec|show_source|fsockopen|pfsockopen|stream_socket_client) *\(" "$php_file"
done < php_in_writable.txt

kikoseijo

git rm -r --cached .
git add .
git commit -m ".gitignore is now working"

kikoseijo

@servers(['remote' => 'ks1.xxxxx.com', 'local' => '127.0.0.1'])

@include('vendor/autoload.php')

@setup
    # customize this keys...
    # USERNAME_HERE, DOMAIN_NAME_HERE, REPO_GROUP, REPO_NAME
    $dotenv = Dotenv\Dotenv::create(__DIR__, '.env');
    $dotenv->load();

kikoseijo

<?php

use Swagger\Annotations as SWG;

/**
 * @SWG\Swagger(
 * 		basePath="/v1",
 * 		host="api.local",
 * 		schemes={"http"},
 * 		produces={"application/json"},

kikoseijo

<?php

namespace App\Http\Requests;

use Illuminate\Foundation\Http\FormRequest;
use App\Models\Vehicle;

class VehicleRequest extends FormRequest
{