Skip to content

Instantly share code, notes, and snippets.

Peeter Marvet petskratt

Block or report user

Report or block petskratt

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
petskratt / tables_and_indexes.sql
Last active Nov 22, 2018
List of all tables and indexes in db
View tables_and_indexes.sql
-- created to find tables with missing indexes on a WordPress install
SET @db = 'some_database';
information_schema.tables AS tbl
SELECT table_name,
View zone-updateall.php
Plugin Name: Zone Updateall
Plugin URI:
Description: Allow automatic WP and plugin updates. No fancy settings, just does the job.
Author: Peeter Marvet
Version: 0.1
Author URI:
View zone-cachebuster.php
Plugin Name: Zone Cachebuster
Plugin URI:
Description: Replace JS and CSS version parameters with hash - for obfuscation or quick cachebusting.
Author: Peeter Marvet
Version: 0.1
Author URI:
petskratt / clinup
Last active May 16, 2019
Use wp-cli to clean up WordPress installs (force core & plugins reinstall, track changes in git allowing easy reverts etc)
View clinup
#!/usr/bin/env bash
# for debug output, uncomment:
#set -x
function help {
echo "WordPress cleanup -v 0.5 2018-06-26 /
petskratt / humpty-dump.php
Created Nov 14, 2017
Humpty-dump - dump WP or Magneto 1.x database from PHP
View humpty-dump.php
// dump database - either using WordPress config from same directory or locally configured parameters
// ... or Magento's local.xml
// v 1.3 (2015-03-18) Peeter Marvet,
// v 1.4 (2017-11-14) added autorenamer
if ( basename( __FILE__, '.php' ) === 'humpty-dump' ) {
petskratt / .htaccess
Last active May 22, 2019
Perishable Press 6G firewall with slight modifications ( bot enabled, no IP blocking part)
View .htaccess
# @
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{QUERY_STRING} (eval\() [NC,OR]
RewriteCond %{QUERY_STRING} (127\.0\.0\.1) [NC,OR]
RewriteCond %{QUERY_STRING} ([a-z0-9]{2000}) [NC,OR]
RewriteCond %{QUERY_STRING} (javascript:)(.*)(;) [NC,OR]
View nimbusec_explorer.php
* Parse Nimbusec JSON raport
* User: petskratt (
* Date: 26.08.2016
* Time: 11:07
* v1.0
* - initial version (a quick hack and proof of idea)
petskratt / .gitignore
Last active Oct 18, 2019
Group file change times by inode ctime
View .gitignore
View e-smaspaev.php
* HTTP 1.1 vs HTTP/2 test
* User: petskratt
* Date: 06/05/16
* Time: 12:53
$merchants = [
'' => '/img/Kuivtoit2.jpg',
petskratt / xkcd_pwd_gen.php
Last active Aug 23, 2016
Generate xkcd style password using most common 1000 Estonian words (Ansip and Savisaar excluded)
View xkcd_pwd_gen.php
* Generate xkcd style password using most common 1000 Estonian words (Ansip and Savisaar excluded)
* based on (removed names, countries, words with umlauts)
function xkcd_password_generator() {
You can’t perform that action at this time.