Skip to content

Instantly share code, notes, and snippets.

View petskratt's full-sized avatar

Peeter Marvet petskratt

31 followers · 3 following
View GitHub Profile
@petskratt
petskratt / .htaccess
Last active May 22, 2019 07:10
Perishable Press 6G firewall with slight modifications (archive.org bot enabled, no IP blocking part)
# 6G FIREWALL/BLACKLIST
# @ https://perishablepress.com/6g/
# 6G:[QUERY STRINGS]
<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]
@petskratt
petskratt / tables_and_indexes.sql
Last active November 22, 2018 17:51
List of all tables and indexes in db
-- created to find tables with missing indexes on a WordPress install
SET @db = 'some_database';
SELECT
tbl.table_name,
idx.indexes
FROM
information_schema.tables AS tbl
LEFT JOIN(
SELECT table_name,
@petskratt
petskratt / zone-cachebuster.php
Last active September 22, 2018 14:32
<?php
/*
Plugin Name: Zone Cachebuster
Plugin URI: https://gist.github.com/petskratt/3acd7166297ff4451a606115b49ad22c
Description: Replace JS and CSS version parameters with hash - for obfuscation or quick cachebusting.
Author: Peeter Marvet
Version: 0.1
Author URI: https://www.zone.ee/
*/
@petskratt
petskratt / zone-updateall.php
Created August 15, 2018 08:29
<?php
/*
Plugin Name: Zone Updateall
Plugin URI: https://gist.github.com/petskratt/1d3e29fb4e6224e1a73b2422c8363044
Description: Allow automatic WP and plugin updates. No fancy settings, just does the job.
Author: Peeter Marvet
Version: 0.1
Author URI: https://www.zone.ee/
*/
@petskratt
petskratt / humpty-dump.php
Created November 14, 2017 12:46
Humpty-dump - dump WP or Magneto 1.x database from PHP
<?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, http://tehnokratt.net
// v 1.4 (2017-11-14) added autorenamer
if ( basename( __FILE__, '.php' ) === 'humpty-dump' ) {
@petskratt
petskratt / wp-config-sample.php
Created February 1, 2013 10:23
WordPress config file that I have been using in both dev and live - based on innumerable examples... that I'll try to recall and properly attribute later.
<?php
define( 'PROD_HOST', '' );
define( 'CURRENT_HOST', $_SERVER['SERVER_NAME'] );
define( 'CURRENT_IP', $_SERVER['SERVER_ADDR'] );
define( 'WP_DEBUG', false ) ;
define( 'DB_CHARSET', 'utf8' );
define( 'DB_COLLATE', '' );
$table_prefix = 'wp_';
@petskratt
petskratt / nimbusec_explorer.php
Created August 26, 2016 08:11
<?php
/**
* Parse Nimbusec JSON raport
* User: petskratt (peeter@zone.ee)
* Date: 26.08.2016
* Time: 11:07
* v1.0
* - initial version (a quick hack and proof of idea)
*/
@petskratt
petskratt / e-smaspaev.php
Created May 6, 2016 09:59
<?php
/**
* HTTP 1.1 vs HTTP/2 test
* User: petskratt
* Date: 06/05/16
* Time: 12:53
*/
$merchants = [
'kuivtoit.ee' => '/img/Kuivtoit2.jpg',
@petskratt
petskratt / Codeacademy-edit-bookmarklet.md
Last active August 29, 2015 13:56
Edit Exercise bookmarklet for Codeacademy

Bookmarklet for easy access to edit mode on Codeacademy course exercises (where you have author / contributor rights).

Based on SCT viewer.

Drag editCA to the bookmarks bar, edit to replace the target with this code.