Skip to content

Instantly share code, notes, and snippets.

View jaseclamp's full-sized avatar

Jase Clamp jaseclamp

  • Brisbane, Australia
View GitHub Profile
@jaseclamp
jaseclamp / pinnaclecart2magento-phase2.php
Created April 15, 2013 05:55
Migrates data from Pinnacle Cart to Magento. Put this script in your Magento root and edit DB connection details to point to Pinnacle Cart site. This is script 2 of 3.
<?php
//Migrate data from Pinnacle Cart to Magento Part TWO
require_once 'app/Mage.php';
Mage::app(0); // best to leave as default as prods are created in admin and you can apply to stores as needed
include_once('simple_html_dom.php');
include_once('import-filter.php');
@jaseclamp
jaseclamp / pinnacle2magento-phase1.php
Created April 15, 2013 05:59
This script migrates data from pinnacle cart to magento. Put this file in Magento root and edit db connection details. This script migrates categories. It's script one of three.
<?php
//this script migrates categories from pinnacle cart to magento
//it's part one of three
require_once 'app/Mage.php';
Mage::app('default'); // Default or your store view name.
mysql_connect("host", "user", "pass") or die(mysql_error());
mysql_select_db("db") or die(mysql_error());
@jaseclamp
jaseclamp / pinnacle2magento-phase3.php
Created April 15, 2013 06:02
Migrate data from pinnacle cart to magento. Put script in magento root and update db connection details. This script migrates product relationships / recommendations. It's the third out of three scripts because you need the products to be there before relating them.
<?php
require_once 'app/Mage.php';
Mage::app(0); // best to leave as default as prods are created in admin and you can apply to stores as needed
//connect to your pinnacle cart database
mysql_connect("host", "user", "pass") or die(mysql_error());
//your pinnacle cart database name
mysql_select_db("db") or die(mysql_error());
@jaseclamp
jaseclamp / acc.mx_cloner.php
Created November 20, 2013 04:46
Updated mx_cloner for expressionengine to work with zenbu
function set_sections()
{
$EE =& get_instance();
$out = '<script type="text/javascript" charset="utf-8">$("#accessoryTabs a.mx_cloner").parent().remove();';
//changed this line to activate cloner with zenbu
if ($EE->input->get('module') == 'zenbu' && $EE->input->get('M') == 'show_module_cp' && $EE->input->get('C') == 'addons_modules') {
$out .='
@jaseclamp
jaseclamp / Fulltext.php
Created April 8, 2014 02:25
/app/code/local/Mage/CatalogSearch/Model/Resource/Fulltext.php
<?php
/**
* Magento
*
* NOTICE OF LICENSE
*
* This source file is subject to the Open Software License (OSL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/osl-3.0.php
<?php
$sites = "http://www.broadcastsolutions.com.au/
http://www.kvm.com.au/
http://www.ambertech.com.au/";
$sites = preg_split('/\r\n|\r|\n/', $sites);
echo "
@jaseclamp
jaseclamp / warm_varnish
Created February 18, 2015 04:56
Warm Varnish Cache
#!/bin/bash
# this script will
# a. crawl the designated site X levels deep to generate a urls list
# b. completely purge all urls on the desisgnated varnish servers for the designated url
# c. clear cache on nginx / mod pagespeed for the designated app servers
# d. individually warm all the listed urls on each designated varnish server
# e. rewarm them in case pagespeed sent a purge request
# define some variables
<?php
//this script duplicates channel entries with category assignments from one MSM site to another.
//set the from/to site id below.
//it assumes you've already duplicated your channels, channel fields, and categories between sites perfectly preserving url_titles for all. (see note on categories at end)
//run in staging before production! (and backup!)
//using nsm config bootstrap http://ee-garage.com/nsm-config-bootstrap
//otherwise manually set your db connection details following
@jaseclamp
jaseclamp / SO-scraperwiki.php
Created March 13, 2015 00:01
Scrap Stackoverflow on a certain topic so top users can be mapped
<?php
//house cleaning
//scraperwiki::save_sqlite(array('id'), array('id'=>1, 'lat'=>1, 'lng'=>1), "users2");
//die;
require 'scraperwiki/simple_html_dom.php';
function neat_r($arr, $return = false) {
$out = array();
@jaseclamp
jaseclamp / cleanse_deleted_jira_issues_from_stitch.php
Last active March 31, 2017 05:19
Stitch data does not delete issues from postgres sql when issues are deleted from jira. This script cleans that up.
<?php
//REPLACE ALL XXX !!
// Create a stream
$opts = array(
'http'=>array(
'method'=>"GET",
'header' => "Content-Type: application/json\r\nAuthorization: Basic " . base64_encode("xxx:xxx")
)