<?
session_start();
$_POST['username']="test";
$_POST['password']="test";
require_once("./MyAuth2.php");
$db=$o_smarty->getDb();
unset($_SESSION['sheettitle']);
unset($_SESSION['sheetkrtid']);
unset($_SESSION['sheetpetid']);
unset($_SESSION['sheetpetname']);
unset($_SESSION['sheetkind']);
unset($_SESSION['updateid']);
unset($_SESSION['sheettxt']);
unset($_SESSION['sheetattr']);
unset($_SESSION['datattr2']);
unset($datattr);
$_SESSION['inpxy']=0;
$_SESSION['sthani']="";
$_SESSION['enhani']="";
$_SESSION['maxrow']=10;
$_SESSION['maxcol']=10;

for($y=0;$y<=$_SESSION['ycnt'];$y++){
unset($_SESSION["y".substr(100+$y,1,2)]);
}
unset($_SESSION['ycnt']);
unset($_SESSION['xcnt']);

$SQL="SELECT * FROM websheet WHERE websheet_authid=".$_SESSION['authoridw']." ORDER BY websheet_id";

$rs=$db->query($SQL);
if($rs->numRows()>0){
while($row = $rs->fetchRow(DB_FETCHMODE_ASSOC)){
	$firstgyo=substr($row['websheet_txt'],0,strpos($row['websheet_txt'],chr(13)));
	//$firstgyo=$row['websheet_txt'];
	$dispid=$row['websheet_id']+$row['websheet_authid']*10000;
	$data[]=array("sheetid"=>$row['websheet_id'],
		"dispsheetid"=>$dispid,
		"sheettitle"=>$row['websheet_title'],
		"firstgyo"=>$firstgyo,
		"update"=>$row['websheet_update']);

}
}
for($i=1;$i<=30;$i++){
	$datax[]=array("cnt"=>$i-1,"cntdisp"=>$i);
}
$o_smarty->assign("datax",$datax);
$o_smarty->assign("username",$_SESSION['profile']);
$o_smarty->assign("data",$data);
$o_smarty->display("sheetlist.tpl");
?>