Skip to content

Instantly share code, notes, and snippets.

View bellamystudio's full-sized avatar

Paul Bellamy bellamystudio

View GitHub Profile
/*
JOBS
populate gmaps_data_locations with legacy data
field_id_448 is the id of the jobs gmaps_data field
56 is the channel_id for jobs channel
All addresses are uk so that's easy
OBVIOUSLY CHECK AND UPDATE FOR OTHER CHANNELS!
*/
INSERT INTO exp_gmaps_data_locations(field_id, channel_id, country, country_code, entry_id, street_name, postal_code, lat, lng)
@bellamystudio
bellamystudio / gist:4805525a97edd1022571c26ddc977eab
Last active February 19, 2018 13:40
List heights (asc) of published woocommerce products
SELECT p.id, p.post_title, p.post_status, m.meta_key, m.meta_value
FROM morvawp_posts p
INNER JOIN morvawp_postmeta m ON p.id=m.post_id
AND m.meta_key='_height'
WHERE p.post_status = 'publish'
ORDER BY m.meta_value * 1 ASC
@bellamystudio
bellamystudio / _flow_text.scss
Created March 1, 2016 16:29
.flow-text class for foundation 6
/* Flow Text - originally borrowed from materialize, reworked for foundation6
makes text with class .flow-text between medium and xxlarge relative size
========================================================================== */
$range : map-get($breakpoints, large) - map-get($breakpoints, medium) !default;
$intervals: 20 !default;
$interval-size: $range / $intervals !default;
.flow-text{
//font-weight: 300; /* optional weight change */
@bellamystudio
bellamystudio / pi.link_format.php
Created March 3, 2014 14:59
EE Plugin to ensure external link format
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
// Simple, single configuration file to override almost all paths and server settings. As used by @airways
// and @litzinger.
// Only check in the default as dist.config.php, set your version control system to ignore config.php so that
// local users and each instance (staging, production) can have their own settings.
// These config files are mainly meant to be used on a shared development server used by all developers,
// although it works almost as well for local development as well.