balibali

The following ports are currently installed:
  apache2 @2.2.13_2+darwin+preforkmpm (active)
  apr @1.3.8_0 (active)
  apr-util @1.3.9_0 (active)
  autoconf @2.64_2 (active)
  autoconf213 @2.13_1 (active)
  automake @1.11_0 (active)
  bzip2 @1.0.5_2+darwin (active)
  coreutils @7.5_0+with_default_names (active)
  ctags @5.8_0 (active)

balibali

Redmine Setup on Rackspace CentOS 5.4

2010-02-09

Base Package

# yum update

balibali

Setup PHP for opPluginChannelServerPlugin on CentOS 5.4

Install packages

# yum install libxml2-devel curl-devel libjpeg-devel libpng-devel libmcrypt-devel

balibali

<?php
/** Public Domain Software */

$html = file_get_contents('http://www.teriyaki.jp/odai/karaoke/index.php');
$html = mb_convert_encoding($html, 'UTF-8', 'EUC-JP');
$html = str_replace('</head>', '<meta name="viewport" content="width=device-width; initial-scale=1.0;"></head>', $html);

header('Content-Type: text/html; charset=utf-8');
echo $html;

balibali

#!/bin/bash

yum -y update

yum -y install screen sysstat vim-enhanced subversion

rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/x86_64/epel-release-5-3.noarch.rpm
yum -y install git

# Postfix

balibali

#!/bin/bash

yum -y update

yum -y install screen sysstat vim-enhanced subversion

rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/x86_64/epel-release-5-3.noarch.rpm
yum -y install git

# Postfix

balibali

Index: webapp/lib/db/member.php
===================================================================
--- webapp/lib/db/member.php    (リビジョン 20393)
+++ webapp/lib/db/member.php    (作業コピー)
@@ -293,16 +293,13 @@
     $order = " ORDER BY c_member_id DESC";
     $sql = "SELECT c_member_id" . $from . $where . $order;

-    // 検索設定を公開にしていないメンバーを除外
     $result_ids = db_get_col($sql, $params);

balibali

$ php -r "var_dump(date_diff(new DateTime('2010-05-10'), new DateTime('2010-03-19'))->format('%a'));"
string(2) "52"

$ php -r "var_dump(date_create('2010-05-10')->diff(date_create('2010-03-19'))->format('%a'));"
string(2) "52"

$ php -r "var_dump((strtotime('2010-05-10') - strtotime('2010-03-19')) / (60 * 60 * 24));"
int(52)

balibali

<?php
$dry_run = false;

// http://php.net/manual/ref.pdo-mysql.connection.php
$pdo_dsn  = 'mysql:xxx';
$pdo_user = 'xxx';
$pdo_pass = 'xxx';

$dbh = new PDO($pdo_dsn, $pdo_user, $pdo_pass);
$sth = $dbh->query('SELECT id FROM member WHERE is_active = 1 AND is_login_rejected = 0 ORDER BY id');

balibali

diff --git a/lib/model/doctrine/PluginDiary.class.php b/lib/model/doctrine/PluginDiary.class.php
index 4928da5..6815b21 100644
--- a/lib/model/doctrine/PluginDiary.class.php
+++ b/lib/model/doctrine/PluginDiary.class.php
@@ -128,4 +128,18 @@ abstract class PluginDiary extends BaseDiary
       $image->delete();
     }
   }
+
+  public function postInsert($event)