require_once("../inc/db.php");
require_once("../inc/statics.inc");
require_once("../inc/init.php");
require_once("../inc/wiki.php");
$title="EVENTS";
define("DEFOFFSET",15);
if($_GET["page"]=="end")
{
jumpend();
}
function jumpend()
{
global $conn;
// $sql = " select * from events where valid=true order by daybegin desc "
$sql = "select count(*) from events where valid=true;";
$res = pg_exec($conn, $sql);
$count = pg_result($res,0,"count");
$page = (int)($count/DEFOFFSET);
$sql = "select min(daybegin) from events where valid=true;";
$res = pg_exec($conn, $sql);
$min = pg_result($res,0,0);
header("Location: /events/?page=".$page."#".date("Y/m/d",$min));
exit();
#header("Location: http://www.php.net/"); /* ブラウザをPHP Web サイトに
}
$colors = getColors(DEFOFFSET);
?>
イセネエヒヒネエ(他社比)-EVENTS-
| |
|
|
=$sitemenu?>
|
=printPages()?>
|
printEvents(); ?>
|
=printPages()?>
|
|
|
| '
.''
.''
.'● %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;
}
?>