Werner Smit wernersmit

wernersmit / pv-zcat-mysql.sh

Last active August 29, 2015 14:02

Import mysql db from compressed archive and display progress

	# Import mysql db from compressed archive and display progress
	pv -f mysql-db.gz \| zcat \| mysql -u root -p db_name

wernersmit / free-mem.sh

Created June 8, 2014 07:36

Free memory on a running Linux system without rebooting

	###########################################################
	# Free memory on a running Linux system without rebooting #
	###########################################################

	#!/bin/sh
	# sh -c "sync; echo 3 > /proc/sys/vm/drop_caches"

	# Flush file system buffers by executing
	sync;

wernersmit / selenium_with_python.rst

Created July 3, 2014 02:50 — forked from daemianmack/selenium_with_python.rst

Selenium with Python

wernersmit / get-row-count-all-tables-in-db.sql

Created July 17, 2014 11:03

Get total row count by table name for all tables in a db.

SELECT SUM(TABLE_ROWS), TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '{DB_NAME}' GROUP BY TABLE_NAME;

wernersmit / gist:c27f6ee04a95e0f73a45

Created December 17, 2014 12:57

Wordpress CSS reference in theme


	<link rel="stylesheet" type="text/css" href="<?php echo get_template_directory_uri(); ?>/css/default.css" media="all" />

wernersmit / wp-query-ref.php

Created December 4, 2015 16:23 — forked from luetkemj/wp-query-ref.php

WP: Query $args

	<?php
	/**
	* WordPress Query Comprehensive Reference
	* Compiled by luetkemj - luetkemj.com
	*
	* CODEX: http://codex.wordpress.org/Class_Reference/WP_Query#Parameters
	* Source: https://core.trac.wordpress.org/browser/tags/3.9/src/wp-includes/query.php
	*/

	$args = array(

wernersmit / xmlrpc-debug.php

Created April 21, 2016 10:06

Debug XMLRPC requests received by WordPress by logging request to a log file

	<?php

	// -- For debugging enable XML Logging for specfic site_id

	function ws_debug_xml_post() {

	// Only capture XMLRPC requests.
	if (XMLRPC_REQUEST) {

	$logline = "XML POST: ".date('Y-m-d H:i:s')." ".str_repeat('-', 30)."\n";

wernersmit / find-php-cookie.sh

Created June 1, 2016 17:13

wernersmit / nginx-site-available-template

Last active July 18, 2016 10:09

Nginx Site Declaration


	server {
	listen 80;
	server_name fqdn.domain.com;
	access_log /var/log/nginx/fqdn.domain.com-access.log;

	gzip on;
	gzip_static on;

	gzip_http_version 1.1;

wernersmit / nginx-site-available-template-basic

Created July 18, 2016 10:09

Nginx Basic Site Proxy Template


	server {
	listen 80;
	server_name fqdn.domain.com;
	access_log /var/log/nginx/fqdn.domain.com-access.log;

	gzip on;
	gzip_static on;

	gzip_http_version 1.1;

	# Use for finding =$_COOKIE in php scripts under /var/www/vhosts/
	# =$_COOKIE is commonly used in exploit scripts.
	#!/bin/bash
	find /var/www/vhosts/ -name '*.php' -exec grep -l '=$_COOKIE' {} \;