<?
require_once("JiiaPage.inc");
require_once("OhbaDatabasePg_member.inc");
require_once "OhbaTemplate.inc";

class ThisPage extends SessionPage {

	function On_Default()
	{
		return array("_tmp_pass.html",array());
	}

	function On_remind()
	{
		$t = new PgTable_member2();
		$email = pg_escape_string($_POST['email']);
		$r = $t->query_records('member2.id,member2.email,name_s,name_m,member.account,member.passwd,suspend,ctime',
			"member2.email = '$email' and status=1 and member.account !='' ",null,null,null," join member on member2.m_id=member.id"  );
//print_r($r);

		if ($r == null or count($r)>1
		  ||($r[0]['suspend']!='' && $r[0]['suspend']!=' ')){
			sleep(1);
			return array("_tmp_pass.html",array('msg'=>1));
		}
		$r = $r[0];
		//HtmlTemplate::t_include("_mailtmp_pass.txt",$r);
		mb_language("Ja") ;
		mb_internal_encoding("UTF-8") ;
		mb_send_mail($r['email'],'日本国際問題研究所から登録情報のお知らせ',
			HtmlTemplate::t_buffer("_mailtmp_pass.txt",$r),
join("\n",array("From: kojin@jiia.or.jp")),"-f kojin@jiia.or.jp");
			
		$args[sent]=1;
		return array("_tmp_pass.html",$args);
	}

}
//print_r($_SERVER);

$page = new ThisPage;
$page->dispatch();