Skip to content

Instantly share code, notes, and snippets.

View pkdavies's full-sized avatar

Peter Davies pkdavies

5 followers · 28 following
View GitHub Profile
@pkdavies
pkdavies / showbanner.php
Created March 28, 2013 09:59
OpenX and Campaign Monitor banner delivery for automated RSS feed reader
<?php
/*
* Create a unique link/image everytime
*
* ----------- Original -----------
* <a href='http://ads.domain.com/www/delivery/ck.php?n=<?php echo $campaign; ?>&cb=<?php echo $cache_buster; ?>' target='_blank' cm_dontconvertlink >
* <img src='http://ads.domain.com/www/delivery/avw.php?zoneid=<?php echo $zone; ?>&n=<?php echo $campaign; ?>&cb=<?php echo $cache_buster; ?>' border='0' alt='' cm_dontimportimage />
* </a>
*
* ----------- New -----------
@pkdavies
pkdavies / gist:5196234
Created March 19, 2013 13:47
Zend-Framework force-download for IE
<?php
$userAgent = new Zend_Http_UserAgent();
$device = $userAgent->getDevice();
$browser = $device->getBrowser();
if ($browser == "Internet Explorer") {
header("Content-Type: application/force-download");
}
@pkdavies
pkdavies / strip.pl
Created March 13, 2013 10:30
Perl script for XML to TSV (tab separated) allowing fast MySQL import
#!/usr/bin/perl -w
use strict;
### Begin
my $file = shift;
open (XML, "</home/scripts/cod/" . $file . ".xml") || die($!);
open (TSV, ">/home/scripts/cod/" . $file . ".tsv") || die($!);
@pkdavies
pkdavies / rfid.php
Created March 11, 2013 18:30
This takes posted data from the RFID app and e-mails the result
<?php
$salt = "thesaltvalue";
if (isset($_POST["rfid_data"]) && isset($_POST["rfid_user"])
&& $_POST["rfid_key"] == md5($_POST["rfid_user"].$_POST["rfid_data"].$salt)){
$message = "RFID Data"."\n";
$message .= $_POST["rfid_data"]."\n";
$message .= "User ------------------------------"."\n";
@pkdavies
pkdavies / magento-clean.sql
Created March 4, 2013 15:07
Cleanup Magento database tables, including old quotes that never made it to checkout
USE magentositedb;
TRUNCATE `magento_dataflow_batch_export`;
TRUNCATE `magento_dataflow_batch_import`;
TRUNCATE `magento_log_customer`;
TRUNCATE `magento_log_quote`;
TRUNCATE `magento_log_summary`;
TRUNCATE `magento_log_summary_type`;
TRUNCATE `magento_log_url`;
TRUNCATE `magento_log_url_info`;
@pkdavies
pkdavies / mbak.sh
Created March 4, 2013 12:28
Simple script to backup a MySQL database and delete files older than two days:
#!/bin/sh
bkpdate=`/bin/date +%Y%m%d-%H`
/usr/bin/mysqldump --user=root --password=yourpass --lock-tables=false --databases list_dbs_here > /databases/backup-${bkpdate}.sql
/usr/bin/zip /databases/backup-${bkpdate}.zip /databases/backup-${bkpdate}.sql
for file in "$( /usr/bin/find /databases -type f -mtime +2 )"
do
/bin/rm -f $file
@pkdavies
pkdavies / PATCH_SUPEE-991_EE_1.12.0.2_v2.sh
Created March 4, 2013 09:29
First please revert the previous patch we sent you by running the command below from within your Magento directory: patch -p0 -R < SUPEE-991_EE_1.12.0.2_v1.patch Once that has been completed, upload the new patch in your Magento (root) directory, log in via SSH and cd /magento (or root). Once there, run the following command: sh PATCH_SUPEE-991…
#!/bin/bash
# Patch apllying tool template
# v0.1.2
# (c) Copyright 2013. Magento Inc.
#
# DO NOT CHANGE ANY LINE IN THIS FILE.
# 1. Check required system tools
_check_installed_tools() {
local missed=""
@pkdavies
pkdavies / fix-ssh-raspberry-pi
Created January 31, 2013 11:16
Fresh Raspberry Pi had issues with starting SSH
# on command line:
ssh-keygen -t 'rsa'
ssh-keygen -t 'dsa'
ssh-keygen -t 'ecdsa'
#When asked to set path use the following for each corresponding key type and overwrite when asked:
/etc/ssh/ssh_host_rsa_key
/etc/ssh/ssh_host_dsa_key
@pkdavies
pkdavies / SUPEE-991_EE_1.12.0.2_v1.patch
Created January 31, 2013 09:45
workaround in case if item subtotal precision is not compatible with PayPal (.2)
diff --git app/code/core/Mage/Paypal/Model/Cart.php app/code/core/Mage/Paypal/Model/Cart.php
index 999d3b8..4d625ca 100644
--- app/code/core/Mage/Paypal/Model/Cart.php
+++ app/code/core/Mage/Paypal/Model/Cart.php
@@ -281,9 +281,11 @@ class Mage_Paypal_Model_Cart
// regular items from the sales entity
$this->_items = array();
+ $excludeTaxSum = 0;
foreach ($this->_salesEntity->getAllItems() as $item) {
@pkdavies
pkdavies / zooextract.php
Created January 29, 2013 11:14
<?php
define('_JEXEC', 1);
define('DS', DIRECTORY_SEPARATOR);
if (file_exists(dirname(__FILE__) . '/defines.php')) {
include_once dirname(__FILE__) . '/defines.php';
}
if (!defined('_JDEFINES')) {