' .'' .'' .'' .'' .'
 %s%s' .'『 %s 』 %s' .'
%s
'; if( ($events = getEvents()) === -1){ return; } $print = ""; for($i=0; $i<(min(count($events),DEFOFFSET)); $i++) { #dechex(rand(0,255)).dechex(rand(0,255)).dechex(rand(0,255) #$color = sprintf("%02x%02x%02x",rand(0,255),rand(0,255),rand(0,255)); $enddate = ($events[$i]["daybegin"]==$events[$i]["dayend"])? "": "〜".date("Y/m/d",$events[$i]["dayend"]); $print .= sprintf($model, date("Y/m/d",$events[$i]["daybegin"]), $i, date("Y/m/d",$events[$i]["daybegin"]), $enddate, $events[$i]["subject"], $events[$i]["subtitle"], convert_html(stripslashes($events[$i]["cont"])) ); } /*if(count($evnets>DEFOFFSET)) { $color = sprintf("%02x%02x%02x",rand(0,255),rand(0,255),rand(0,255)); $print .= '
next
'; }*/ echo $print; } function getEvents() { global $conn; $page = $_GET["page"]; $offset = $page*DEFOFFSET; $sql = " select * from events where valid=true order by daybegin desc " ." offset ".$offset." limit ".(DEFOFFSET+1).";"; $resEvents = pg_exec($conn, $sql); if( pg_numrows($resEvents) == 0){ return -1; } for($i=0; $i0) { $print .= 'new←'; } #$skel = ''."\n"; $skel = ''."\n"; $count = getEventCount(); for($i=0;$i(($page+1)*DEFOFFSET)) { if(empty($page)) { $print .= '→old'; }else { $print .= '→old'; } } return $print; } function getEventCount() { global $conn; $sql = "select count(*) from events where valid=true;"; $resCount = pg_exec($conn, $sql); if(pg_numrows($resCount)==1) { $arr = pg_fetch_array($resCount,0); return $arr[0]; } return 0; } function getColors($count) { for($i=0;$i<$count;$i++) { #明るさ=R×0.30+G×0.59+B×0.11 do { $r = rand(0,255); $g = rand(0,255); $b = rand(0,255); $brite = $r*0.3+$g*0.59+$b*0.11; $colors[$i] = sprintf("%02x%02x%02x",$r,$g,$b); } while( ($brite<128) || ($brite>160) ); } return $colors; } ?>