<?
define("MAXCHARS",45);
include("./includes/common.inc");
include("./includes/scriptlog.inc");
include_once(ROOT."/includes/dbaccess.inc");
include("./includes/getplanmenu.inc");

$rssurl="http://yamanakako.info/service/getweblogrss.php?cnt=5&enc=UTF-8";
$f=fopen($rssurl,"r");
$rss=@file_get_contents($rssurl);
$rssitems=@unserialize($rss);
mb_convert_variables('EUC-JP','UTF-8',$rssitems);

$messages=GetMessage();

require_once("Smarty.class.php");
$Smarty=new Smarty();
$Smarty->assign("pagetitle","HOME");
$Smarty->assign("mailaddress",MAIL_MAIN);
$Smarty->assign("news",$rssitems);
$Smarty->assign("messages",$messages);
$Smarty->assign("planmenu",GetPlanMenu());
$Smarty->display("index.tpl");

include("./includes/counter.php");
include("./ctrl/includes/greenlodgebackup.php");

exit;

//20091215 yamanakako.infoのblog借用に変更
function GetNews() {
	$ret=array();
	$db=db_connect();
	$sql="SELECT * FROM NEWS";
	$sql.=" WHERE `無効`=0";
	$sql.=" ORDER BY `日付` DESC,`更新日時` DESC LIMIT ".NEWS_MAXLINE;
	$result=db_execquery($sql,$db);
	while ($myrow=mysqli_fetch_array($result)) {
		$news=array();
		$news["date"]=date("y/m/d",strtotime($myrow["日付"]));
		$news["title"]=stripslashes($myrow["見出"]);
		$text=strip_tags(stripslashes($myrow["本文"]));
		if (mb_strlen($text)>MAXCHARS) $text=mb_substr($text,0,MAXCHARS)." ...";
		$news["text"]=$text;
		$ret[]=$news;
	}
	mysqli_close($db);
	return $ret;
}

function GetMessage() {
	$message=array();
	$db=db_connect();

	$sql="SELECT * FROM TOPMESSAGE WHERE `無効`=0";
	$sql.=" AND `表示開始日時`<='".date("Y-m-d H:i:s")."'";
	$sql.=" AND `表示終了日時`>='".date("Y-m-d H:i:s")."'";
	$sql.=" ORDER BY `表示開始日時`,`表示終了日時`";
	$result=db_execquery($sql,$db);
	while ($myrow=mysqli_fetch_array($result)) {
		$item=array();
		$item["text"]=stripslashes(nl2br($myrow["本文"]));
		$message[]=$item;
	}
	mysqli_close($db);
	return $message;
}

?>