ajbonner

<?xml version="1.0"?>

<!-- Disable Catalog Price Rules Menu Entry -->
<config>
    <menu>
        <promo translate="title" module="catalogrule">
            <children>
                <catalog translate="title" module="catalogrule">
                    <depends>
                        <module>Disable_This_Module</module>

ajbonner

DROP TABLE IF EXISTS core_file_storage;
CREATE TABLE IF NOT EXISTS core_file_storage (
  `file_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content` LONGBLOB NOT NULL,
  `upload_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  `filename` varchar(255) NOT NULL DEFAULT '',
  `directory_id` int(10) unsigned DEFAULT NULL,
  `directory` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`file_id`),
  UNIQUE KEY `IDX_FILENAME` (`filename`, `directory`),

ajbonner

SELECT count(*) tables,
  concat(round(sum(table_rows)/1000000,2),'M') rows,
  concat(round(sum(data_length)/(1024*1024*1024),2),'G') data,
  concat(round(sum(index_length)/(1024*1024*1024),2),'G') idx,
  concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') total_size,
  round(sum(index_length)/sum(data_length),2) idxfrac
FROM information_schema.TABLES
WHERE table_schema = 'database-name'
ORDER BY data_length+index_length DESC LIMIT 10;

ajbonner

<?php

$mail = new Zend_Mail();

$mail->setFrom('[email protected]', 'Me')
     ->addTo($to)
     ->setSubject($subject)
     ->setBodyText($message);

$file = '/path/to/a/file';

ajbonner

#!/usr/bin/env ruby

require 'image_size'

pwd = File.dirname(__FILE__)

Dir.glob(pwd+'/*') do |file|
  if (File.extname(file) == '.jpg')
    fh = File.open(file, 'rb')
    size = ImageSize.new(fh.read)

ajbonner

#!/bin/bash

if [ $# -lt 5 ]; then
  echo "Exports data from mysql database in tables matching a like pattern e.g. 'table_%'"
  echo "Usage: $0 dbname dbuser dbpass pattern outputfile"
  exit 1
fi

DBNAME=$1
DBUSER=$2