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 / 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
//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 / 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 / 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")
)
@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 / scrape-nrf.js
Created January 11, 2018 05:26
Run in browser console to scrape exhibitor list found at https://nrfbigshow.nrf.com/exhibitors
function tabValues(array) {
var keys = Object.keys(array[0]);
var result = keys.join("\t") + "\n";
array.forEach(function(obj){
keys.forEach(function(k, ix){
if (ix) result += "\t";
@jaseclamp
jaseclamp / linkedin.js
Last active August 26, 2019 06:32
linkedin search results pager
/*
what this script does:
it pages through linkedin search results and copies names, images, company, location, position into a javascript array
once it reaches the end of the results it will prompt to download all the names as a tab delimited csv.
to use:
go to linkedin, run a search exactly how you want it
go to page 2 of those results
paste the below script into console and hit enter
paste this line into console to enable the script: