query("SELECT * FROM `".$currdb->prefix("announcement_new")."`"); if((int)($currdb->num_rows($page)/10)==$currdb->num_rows($page)/10) $pageTotal=$currdb->num_rows($page)/10; else $pageTotal=(int)($currdb->num_rows($page)/10)+1; $announcement=$currdb->query("SELECT * FROM `".$currdb->prefix("announcement_new")."` ORDER BY time DESC LIMIT ".$dataFirst.",10"); if($currdb->num_rows($announcement)!=0) { $announcementTotal=array(); for($m=0;$announcementFlag=$currdb->fetch_array($announcement);$m++) array_push($announcementTotal,$announcementFlag); } } elseif($_POST['search']=="2") { $tag=0; $num=0; $announcement=$currdb->query("SELECT * FROM `".$currdb->prefix("announcement_new")."` ORDER BY time DESC"); if($currdb->num_rows($announcement)!=0) { $announcementTotal=array(); for($m=0;$announcementFlag=$currdb->fetch_array($announcement);$m++) { if(substr_count($announcementFlag['title'],$_REQUEST['content'])!=0 || substr_count($announcementFlag['detail'],$_REQUEST['content'])!=0) { if($tag>=$dataFirst && $tag<($dataFirst+10)) { array_push($announcementTotal,$announcementFlag); $tag++; } else { $tag++; } } } } if((int)($tag/10)==$tag/10) $pageTotal=$tag/10; else $pageTotal=(int)($tag/10)+1; $tpl->assign("content",$_REQUEST['content']); } elseif($_POST['search']=="1") { $page=$currdb->query("SELECT * FROM `".$currdb->prefix("announcement_new")."` WHERE month='".$_REQUEST['month']."'"); if((int)($currdb->num_rows($page)/10)==$currdb->num_rows($page)/10) $pageTotal=$currdb->num_rows($page)/10; else $pageTotal=(int)($currdb->num_rows($page)/10)+1; $announcement=$currdb->query("SELECT * FROM `".$currdb->prefix("announcement_new")."` WHERE month='".$_REQUEST['month']."' ORDER BY time DESC LIMIT ".$dataFirst.",10"); if($currdb->num_rows($announcement)!=0) { $announcementTotal=array(); for($m=0;$announcementFlag=$currdb->fetch_array($announcement);$m++) array_push($announcementTotal,$announcementFlag); } $tpl->assign("month",$_REQUEST['month']); } $tag=$currdb->query("SELECT * FROM `".$currdb->prefix("tag")."` WHERE parent='1'"); $tagTotal=array(); for($n=0;$tagFlag=$currdb->fetch_array($tag);$n++) array_push($tagTotal,$tagFlag); $tpl->assign("announcementTotal",$announcementTotal); $tpl->assign("nowPage","³Ì·s¸ê°T"); $tpl->assign("location","informationNew.php"); $tpl->assign("type",2); $tpl->assign("pageTotal",$pageTotal); $tpl->assign("pageNow",$pageNow); $tpl->assign("search",$_POST['search']); $tpl->assign("tagTotal",$tagTotal); $tpl->assign("admin",$_SESSION['admin']); $tpl->display("information.tpl"); ?>