Skip to content

Instantly share code, notes, and snippets.

@ozero
ozero / AutoSize_Example.vba
Last active August 29, 2015 13:56
Powerpoint vba AutoSize_Example. For all TextShapes in all slides, all presentation windows, shrink font size to fit with textbox.
' mod from msdn http://msdn.microsoft.com/en-us/library/office/ff744773.aspx
Public Sub AutoSize_Example()
Dim prs As Presentation
Dim pptSlide As Slide
For Each prs In Presentations
Debug.Print prs.Name
遠藤会 - [360bpm] 健全ロボ ダイミダラー (crabMixx) ____ 260410-144085597
fhana - [99bpm] いつかの、いくつかのきみとのせかい (crabMixx) ____ 260408-143721890
内田真礼 - [205bpm] 創傷イノセンス (crabMixx) ____ 260404-143051765
blancmange - [138.75bpm] that's love that it is (crabMixx) ____ 260325-141242719
種ともこ - [68.92bpm] LOVE SONG (crabMixx) ____ 260319-140346965
NEW JACK拓郎 - [123.98bpm] 五星戦隊ダイレンジャー (crabMixx) ____ 260317-140008810
nonSectRadicals - [1bpm] 私の恋は1拍1分 ____ 260312-139225338
仲谷明香 - [175bpm] ハピネスチャージプリキュア!WOW! (crabMixx) ____ 260220-135804677
KMM団 - [81bpm] ウィッチ☆アクティビティ (crabMixx) ____ 260218-135427864
ゆず - [124bpm] REASON (crabMixx) ____ 260214-134781702
@ozero
ozero / mojie.php
Last active August 29, 2015 14:04
strangeworld [at]mojie ( http://mojie.s1.xrea.com/ ) archive parsing
<?php
//@文字絵小屋の過去ログを構造化してみる試み
main();
function main(){
$data = array();
@ozero
ozero / gist:7760c8fd616643272a85
Last active August 29, 2015 14:13
dump portal member
// add below at the end of window.plugin.keys.addToSidebar = function() { ... }
// https://secure.jonatkins.com/iitc/release/plugins/keys.user.js
var lv = [];
$("span.meter").each(function(index){
lv[index]= $(this).attr("title");
});
for(var i in lv){
var owner = lv[i].match(/owner:\t[\w]+/)
var level = lv[i].match(/level:\t[\w]+/)
console.log("pt("+i+"):\t"+owner+"\t"+level);
@ozero
ozero / iitc4webhub.user.js
Last active August 29, 2015 14:14
Run IITC userscript for WEBHUB iPhone app. #ingress
// ==UserScript==
// @name IITC
// @description Run IITC Bookmarklet
// @include https://www.ingress.com/intel*
// ==/UserScript==
var urls = ['total-conversion-build.user.js',
'plugins/portal-highlighter-high-level.user.js',
'plugins/player-tracker.user.js',
'plugins/show-less-portals-zoomed-out.user.js'];
@ozero
ozero / DamageReportExctract.php
Created March 10, 2015 00:24
extract from damage report html
<?php
/*
Ingress: extract portal name, lat&long, address, agent name and date
from html files of Ingress damage report email which exported
from thunderbird addon 'Import/Export tools'.
*/
$files=glob("./*/*.*");
$regx_agent="\sby\s.*?<span.*?>(.*?)<";
$regx_date="Date:\s</div>(.*?)<";
$regx_portal='em;"><div>(.*?)</div><div><a.*?pll=(.*?)&z=.*?>(.*?)</a></div>';
@ozero
ozero / IITC2GoogleMap.js
Last active August 29, 2015 14:18
Bookmarklet to open GoogleMap in current IITC view
javascript:(function(){
var e=$("a:contains('Permalink')");
setPermaLink(e);
var f=e.attr("href").replace(/.*?ll=(.*?),(.*?)&z=([0-9]+)/g,"https://www.google.co.jp/maps/@$1,$2,$3z?hl=ja");
window.open(f);
})();
@ozero
ozero / Eijirou2pgSql.php
Created February 24, 2011 06:06
Load Eijirou-XML into PostgreSQL
<?php
require_once 'Zend/Db.php';
require_once 'Zend/Config/Ini.php';
//connect db
$db=dbfactory();
// Parsing a large document with XMLReader with Expand - DOM/DOMXpath
$reader = new XMLReader();
$reader->open("EIJI-127.xml");
@ozero
ozero / addEiji2words.php
Created February 28, 2011 10:42
add desc from eijirou to words
<?php
require_once 'Zend/Db.php';
require_once 'Zend/Config/Ini.php';
//connect db
$db=dbfactory();
$fhf=fopen('./src.txt','r');
$fht=fopen('./ext.txt','w');
@ozero
ozero / gist:1002303
Created June 1, 2011 13:38
sencha touch + pinch zoom test (raw bake
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<link rel="stylesheet" href="resources/css-debug/sencha-touch.css" type="text/css" />
<script type="text/javascript" src="resources/sencha-touch-debug.js"></script>
<script>
//global vals