Devlog

Yuzupapa's Development logs.

[yuzudev-blog]

Cron job running in second

Lunch every 30 second.

*/1 * * * * touch /tmp/test.txt & sleep 30; touch /tmp/test.txt

If you want to run when every 15 second, command with sleep 4 times, every 5 second, 12 times.

References:

http://www.digimoon.net/blog/359

http://d.hatena.ne.jp/folds5/20060805

http://d.hatena.ne.jp/rx7/20090226/p0

[yuzudev-blog]

Sudo setting

to specific user and specific commends

$ visudo

root ALL=(ALL) ALL gardener ALL=/var/www/apps/update.sh, /usr/local/bin/mongrel_rails, /usr/bin/git #gardener ALL=(ALL) ALL

Resources:

http://d.hatena.ne.jp/LukeSilvia/20080716/p1

http://www.atmarkit.co.jp/flinux/rensai/linuxtips/221rootcomuse.html

http://linux.kororo.jp/cont/intro/sudo.php

http://blog.naver.com/PostView.nhn?blogId=kwonj1&logNo=110001076784

http://www.ducea.com/2006/06/18/linux-tips-password-usage-in-sudo-passwd-nopasswd/

[yuzudev-blog]

Switch to specific input source in OSX

Switch to specific input source in OSX with Global Hotkeys.

on changeKeyboardLayout(layoutName) tell application "System Events" to tell process "SystemUIServer" tell (1st menu bar item of menu bar 1 whose description is "text input") to {click, click (menu 1's menu item layoutName)} end tell end changeKeyboardLayout

References

http://superuser.com/questions/224161/switch-to-specific-input-source

[yuzudev-blog]

ISO 639-1

The 'iso_639' textual domain

http://translationproject.org/domain/iso_639.html

ISO 639 언어코드와 언어 명 등의 한국어 번역

http://groups.google.com/group/gnome-kr/browse_thread/thread/2378b26773b0cf1a

ISO 639-1代码表

http://zh.wikipedia.org/wiki/ISO_639-1代码表

W3C - Language codes，ISO 639 語言代碼，ISO 3166 標準國家代碼，ISO 4217 貨幣代碼

http://ianjung1974.blogspot.com/2008/04/iso-639-iso-3166-iso-4217.html

國際標準化組織

http://zh.wikipedia.org/w/index.php?title=ISO&variant=zh-tw

中文简体繁体在线转换服务

http://www.idogicat.com/misc/cctrans.html

http://xh.5156edu.com/jtof.php

Code: http://xh.5156edu.com/zmj1.php.js

言語コード表 - ブラウザの言語設定の挙動を説明

http://www.marbacka.net/msearch/sprakkod.html

[slashpoundbang-deactivated20150]

If I geocode a user’s location with the Google Maps API, I can get the time zone in the format used by the tz database (or zoneinfo database); for example, “America/New_York”. However, Rails uses identifiers like “Eastern Time (US & Canada)”. In order to store time zones in the database in a...

[yuzudev-blog]

Delay launch function with jQuery

Sometime, I want to delay function launch in JavaScript. Like, string duplicate check with MySQL. How to make it?

clearTimeout

setTimeout

Full code

<script type="text/javascript"> var DelayedFunc = false; $('input[name="key"]').live('keyup', function () { var value = $(this).val(); window.clearTimeout(DelayedFunc); DelayedFunc = window.setTimeout(function() { if ( value == '' ) { return false; } $.post('check/', {'key': key, 'value': value}, function(json){ if ( json.status == 1 ) { // ... Some Working ... } }, "json"); }, 500 ); }); </script>

Value DelayFunc must be locate out of jQuery callback function (make global).

Reference:

clearTimeout

http://itpro.nikkeibp.co.jp/article/Reference/20081127/320254/

Key event

http://mytory.co.kr/archives/697

http://www.sqler.com/390796

http://ultteky.egloos.com/m/10767025

jQuery Delay Method

http://stacktrace.jp/jquery/api/effects/delay.html

[yuzudev-blog]

Numbers CSV File Export in iWork

I want to export CSV file in iWork, and I found this post - iWork Numbers CSV file Export. But, I can't found Export in File menu, in my Numbers `09. So, here is where.

Numbers `09 >> Share >> Export

Wow, Numbers support UTF-8 CSV file!

Reference:

http://www.macmassmailer.com/export-csv-iwork-numbers.html

[yuzudev-blog]

Select and Insert or Update in MySQL

I forget this every time.

1. Select and Insert

INSERT INTO table1 ( table1.column1, table1.column2 ) SELECT table2.code, table2.name FROM table2;

2. Select and Update (actually, JOIN UPDATE)

UPDATE table1, table2 SET table1.column1 = table2.column1 WHERE table1.column_key = table2.column_key;

Reference:

http://entireboy.egloos.com/4657692

[yuzudev-blog]

Float した要素を囲んだ Div の高さ

Float した要素を囲んだ Div の高さを中の要素の高さに合わせ調整する方法。

いろいろ調べたが、これが一番妥当だった。

floatしたdivの高さを揃える

http://scuderia-web.com/tips/xhtml_css/equal_box_heights.php

float解除

http://scuderia-web.com/tips/xhtml_css/clearfix.php

Test

http://scuderia-web.com/tips/xhtml_css/sample/clearfix.html

http://scuderia-web.com/tips/xhtml_css/sample/equal_box_heights_auto.html

別の簡単な方法で、次の方法もあったが、

Clear Float Demo

http://webdesignerwall.com/demo/clear-float/

この場合ブラウザの高さによってスクロールバーが表示される問題と、要素を Position: Absolute にした場合、Index: -99999 ... にしても上位の Layer になれない問題があった。

一つ注意点

囲んだ中の要素が Float なので当然 Width: 100% のように設定しないと、横幅がコンテンツの長さになってしまう。

[yuzudev-blog]

CSS3 Transformation

jQuery Transit

http://ricostacruz.com/jquery.transit/

Reference:

http://gsgd.co.uk/sandbox/jquery/easing/

http://semooh.jp/jquery/cont/doc/easing/

[yuzudev-blog]

What difference of Opacity and RGBA

This can be in only CSS3.

Opacity

RGBA

I love RGBA!

Source: http://www.css3.info/introduction-opacity-rgba/

[yuzudev-blog]

Floating Submenu

I had inspired floating submenu like, http://my-jpn.com/aboutcontest/ and http://lesscss.org/ .

But they have one problem that forgot about footer like below.

Original source code:

/* floating Submenu*/ $(function () { var msie6 = $.browser == 'msie' && $.browser.version < 7; if (!msie6) { var top = $('#Submenu').offset().top - parseFloat($('#Submenu').css('margin-top').replace(/auto/, 0)); $(window).scroll(function (event) { // what the y position of the scroll is var y = $(this).scrollTop(); // whether that's below the form if (y >= top) { // if so, ad the fixed class $('#Submenu').addClass('fixed'); } else { // otherwise remove it $('#Submenu').removeClass('fixed'); } }); } });

Source: http://my-jpn.com/aboutcontest/

So, I've add some fix, here is full source code.

<style> .fixed { position: fixed; top: 0; } </style> <div id="left" style="submenu"> Some menu items here... </div> <script type="text/javascript"> /* floating Submenu*/ $(function () { var $menu = $('#left'); var buttom_margin = 310; // px. normally height of footer. var msie6 = $.browser == 'msie' && $.browser.version < 7; if (!msie6) { var top = $menu.offset().top - parseFloat($menu.css('margin-top').replace(/auto/, 0)); // Remember original top position. var menu_height = $menu.outerHeight(); $(window).scroll(function (event) { // what the y position of the scroll is var y = $(this).scrollTop(); var doc_height = $(document).height() - buttom_margin; var bottom = y + menu_height; // Test code //console.log(y + '/' + top + '/' + bottom + '/' + doc_height + '/' + $(document).height()); // whether that's below the form if (y >= top) { // if so, ad the fixed class $menu.addClass('fixed'); // limit of fix if ( bottom < doc_height ) { $menu.css("top","0"); } else { $menu.css("top","-" + (bottom - doc_height) + "px"); } } else { // otherwise remove it $menu.removeClass('fixed'); } }); } }); </script>

You can set Bottom of Margin. Simply change value, buttom_margin = 000.

DEMO - Cafetalk (Need login.)

Enjoy codding!

Don't you want to jQuery and CSS code? Check it. (but, this code is not considered Bottom of Margin.)

<script type="text/javascript"> (function () { if (/Microsoft/.test(navigator.appName)) { return } window.onload = function () { var menu = document.getElementById('[DOM_ID_HERE]'); var init = menu.offsetTop; var docked; window.onscroll = function () { if (!docked && (menu.offsetTop - scrollTop() < 0)) { menu.style.top = 0; menu.style.position = 'fixed'; menu.className = 'docked'; docked = true; } else if (docked && scrollTop() <= init) { menu.style.position = 'absolute'; menu.style.top = init + 'px'; menu.className = menu.className.replace('docked', ''); docked = false; } }; }; function scrollTop() { return document.body.scrollTop || document.documentElement.scrollTop; } })(); </script>

Source: http://lesscss.org/

問題発見

メニューが Main Content より縦幅が大きい場合、メニューが Floating し始めると（つまり、Position: Fixed されることによって）、Main Content の縦幅が縮んでしまう。それで画面が大きく揺れる（瞬時に歪んで、戻るを繰り返す）バグがあって修正。

解決方法として、Main Content の縦幅を事前に取得し、Menu の縦幅と比較して、Menu が大きい場合、Menu を Fixed しない用に工夫。

Updated Code:

/* floating Submenu*/ $(function () { var $menu = $('#left'); var $main = $('#main'); var buttom_margin = 310; // px. normally height of footer. var msie6 = $.browser == 'msie' && $.browser.version < 7; if (!msie6) { var top = $menu.offset().top - parseFloat($menu.css('margin-top').replace(/auto/, 0)); // Remember original top position. var menu_height = $menu.outerHeight(); var main_height = $main.outerHeight(); $(window).scroll(function (event) { // what the y position of the scroll is var y = $(this).scrollTop(); var doc_height = $(document).height() - buttom_margin; var bottom = y + menu_height; // whether that's below the form if ( y >= top && menu_height < main_height ) { // if so, ad the fixed class $menu.addClass('fixed'); // limit of fix if ( bottom < doc_height ) { $menu.css("top","0"); } else { $menu.css("top","-" + (bottom - doc_height) + "px"); } } else { // otherwise remove it $menu.removeClass('fixed'); } }); } });

[yuzudev-blog]

How to insert source code pretty in Tumblr.

Use google-code-prettify like this.

Yes, looks lik just this post.

<link rel="stylesheet" href="http://google-code-prettify.googlecode.com/svn/trunk/src/prettify.css" type="text/css" media="screen" /> <script type="text/javascript" src="http://google-code-prettify.googlecode.com/svn/trunk/src/prettify.js"></script> <style type="text/css"> pre { padding: 5px 10px; word-wrap: break-word; margin-bottom: 14px; font-family: 'Lucida Console', Monaco, monospace; } pre.prettyprint { padding: 5px 10px; word-wrap: break-word; margin-bottom: 14px; border:1px solid #dedede; font-family: 'Lucida Console', Monaco, monospace; border-radius: 5px; -moz-border-radius: 5px; -webkit-border-radius: 5px; } . . . </style> <body onload="prettyPrint()"> . . . </body>

Reference:

http://google-code-prettify.googlecode.com/svn/trunk/README.html

[yuzudev-blog]

Using Time Zone in PHP (simple)

PHP >= 5.2.x

date_default_timezone_set('Europe/London'); print date("m/d/Y H:i",time());

Reference:

http://www.phpfreaks.com/forums/index.php?topic=223035.0

[yuzudev-blog]

Apache basic authentication

1. Setting in httpd.conf

in Apache httpd.conf or config file

AuthUserFile /var/www/html/.htpasswd AuthName "Hidden Page" AuthType Basic require valid-user

or,

2. Setting in .htaccess

Set 'AllowOverride all' in httpd.conf, and go to .../some_directory/

# vi .htaccess AuthUserFile /var/www/html/.htpasswd AuthName “Hidden page” AuthType Basic require valid-user deny from all #vi .htpasswd someuser:xxxxyyyyzzzz

How to make .htpasswd

# htpasswd -c /etc/httpd/.htpasswd [USER_NAME] New password: Re-type new password: Adding password for user [USER_NAME]

Reference:

http://httpd.apache.org/docs/2.0/en/howto/htaccess.html

http://www.atmarkit.co.jp/flinux/rensai/linuxtips/698apachebasic.html

[yuzudev-blog]

Time Zone list with PHP

Time Zone list.

This code can be used in PHP >= 5.2.x

$continent = ''; $timezone_identifiers = DateTimeZone::listIdentifiers(); asort($timezone_identifiers); foreach( $timezone_identifiers as $timezone ){ if ( preg_match( '/^(Africa|America|Antarctica|Arctic|Asia|Atlantic|Australia|Brazil|Canada|Chile|Etc|Europe|Indian|Mexico|Mideast|Pacific|US)\//', $timezone ) ){ $timezone_slice = explode("/", $timezone); //obtain continent,city if ( $continent != $timezone_slice[0] ) { if ( $continent != '' ) echo ''; echo ''; } $continent = $timezone_slice[0]; array_shift($timezone_slice); $city = implode('/', $timezone_slice); //$city = $timezone_slice[1]; echo ''.$city.''; } }

Reference:

http://php.net/manual/ja/datetimezone.listidentifiers.php