Skip to content

Instantly share code, notes, and snippets.

View phillipadsmith's full-sized avatar

Phillip Smith phillipadsmith

189 followers · 455 following
View GitHub Profile
@phillipadsmith
phillipadsmith / keybase.md
Created October 5, 2014 04:46

Keybase proof

I hereby claim:

  • I am phillipadsmith on github.
  • I am phillipadsmith (https://keybase.io/phillipadsmith) on keybase.
  • I have a public key whose fingerprint is 25F7 F458 C261 B25B 5297 8F0A 518B F15D D63C 5D49

To claim this, I am signing this object:

@phillipadsmith
phillipadsmith / README.md
Created August 29, 2015 19:11
Test block!

hello markdown

@phillipadsmith
phillipadsmith / README.md
Last active August 29, 2015 19:35
Canada's GHGs since 1990

Canada's Greenhouse Gas Emissions

A quick look at Canada's GHG emissions since 1990.

@phillipadsmith
phillipadsmith / paragraph.mc
Created April 24, 2009 23:36
<%perl>;
foreach my $e ( $element->get_elements(qw(paragraph))) {
$m->print('<p>', $e->get_data, "</p>\n");
}
</%perl>
@phillipadsmith
phillipadsmith / gist:101402
Created April 24, 2009 23:39
autohandler.mc
<html>
<body>
% $burner->chain_next;
</body>
</html>
@phillipadsmith
phillipadsmith / delete-all.user.js
Created April 24, 2009 23:41
Allows you to check all of the delete checkboxes in the Story Profile
// ==UserScript==
// @name Bricolage Delete All
// @namespace http://wiki.bricolage.cc/greasemonkey
// @description Allows you to check all of the delete checkboxes in the Story Profile
// @include *
// ==/UserScript==
(function () {
var spans = document.getElementsByTagName("span");
@phillipadsmith
phillipadsmith / gist:101435
Created April 25, 2009 01:04
Reactivate deactivated contributor
update member
set active = True
where id in (
select distinct sc.member__id
from story__contributor sc
inner join story_instance si on sc.story_instance__id = si.id
where si.story__id = ID OF YOUR STORY
);
@phillipadsmith
phillipadsmith / Delete old site groups
Created April 25, 2009 01:03
UPDATE "grp"
SET "active" = 'FALSE'
WHERE "name" ~ '2nd test site'
@phillipadsmith
phillipadsmith / gist:101436
Created April 25, 2009 01:04
Display the first-level elements of a story given its 'id'
SELECT f.id,ft.name,ft.key_name,f.place,f.object_order
FROM story_field f,field_type ft
WHERE f.field_type__id = ft.id and ft.active = 't'
and f.parent_id = (
select t.id from story_element t,element_type et,at_type at
where t.element_type__id=et.id and t.active='t' and et.active='t'
and et.type__id=at.id and t.object_instance_id = (
select max(id) from story_instance where story__id = 50706
)
and at.top_level='t'
@phillipadsmith
phillipadsmith / gist:101445
Created April 25, 2009 01:30
also_this_topic_march_27.mc
<%args>
@secondary_categories
$skip_story_id => undef
$max_return => 5
</%args>
<%perl>
# setting max_return to "0" (either by passing in value when calling, or adjusting above), means return everything.
my $count_returned=0; # default to returning everything found.
my $return_limit; #this is passed to the Bric::Biz... call -- requires special handling.
if(0==$max_return){ #unlimited