'."\n";
if (pg_numrows($res) == 0) {
$mlist .= "
\n".
"- - 現在、予定は登録されていません -
\n
\n";
} else {
$mlist .= "
\n";
while ($row = pg_fetch_array( $res )) {
// 標示用
while (list($k,$v)=each($row)) {
$tags[ $row['date_ymd'] ][ $row['id'] ][$k] = $v;
}
list($y,$m,$d) = split("\-", $row['date_ymd']);
$mlist .= "- \n";
$mlist .= "";
$mlist .= $m."/".$d." (".$array_week[ date("w",strtotime($row['date_ymd'])) ].")";
if ($row['ken'] != '') {
$mlist .= " ".$row['ken'];
}
if ($row['locate'] != '') {
$mlist .= " ".$row['locate'];
}
if ($row['shop'] != '') {
$mlist .= ":".$row['shop'];
}
$mlist .= "";
// link
if ($row['url'] != '') {
// $mlist .= " → Homepage";
$mlist .= " → Homepage";
}
// google map
if ($row['gmap'] == 1 && $row['address'] != '') {
$mlist .= " ".
"→ GoogleMaps";
}
// フライヤー
if ($row['flyer'] != '') {
$mlist .= " → フライヤー";
}
$mlist .= "
\n";
if ($row['live_title'] != '') {
// $mlist .= "- 【".$row['live_title']."】
\n";
}
if ($row['information'] != '') {
$row['information'] = preg_replace("/(https?:\/\/[a-zA-Z0-9;\/?:@&=\+$,\-_\.!~*'\(\)%#]+)/","\\0",$row['information']);
$mlist .= "- ".nl2br($row['information'])."
";
}
}
$mlist .= "
\n\n";
}
$mlist .= "