";
//echo mktime(12,0,0,10,27,2003);
#########게시물총수############
if(!$find){
$q1="select count(no) from $board where wtype2 is null";
}else{
$sq=" wtype2 is null and ";
if($wtype1=="en"){
if($find=="all"){$sq.="en_title like '%$word%' or id like '%$word%' or en_name like '%$word%' or en_contents like '%$word%'";}
else if($find=="title"){$sq.="en_title like '%$word%'";}
else if($find=="id"){$sq.="id like '%$word%'";}
else if($find=="name"){$sq.="en_name like '%$word%'";}
else if($find=="contents"){$sq.="en_contents like '%$word%'";}
}else{
if($find=="all"){$sq.="n_title like '%$word%' or id like '%$word%' or n_name like '%$word%' or n_contents like '%$word%'";}
else if($find=="title"){$sq.="n_title like '%$word%'";}
else if($find=="id"){$sq.="id like '%$word%'";}
else if($find=="name"){$sq.="n_name like '%$word%'";}
else if($find=="contents"){$sq.="n_contents like '%$word%'";}
}
$q1="select count(no) from $board where ($sq)";
}
$total_rows=queryone($q1);
//echo "total_row=$total_rows ";
#########게시물총수############
if (!$starts){
$starts=0;
$sqc=$total_rows;
}else{
$sqc=$total_rows-$starts;
}
$numbers=10;//한페이지당 게시물수
if($total_rows)
{
$cols="rownum as rnum,no,wtype1,en_title,n_title,wdate,wsee,sfilename,ino,id,en_name,n_name,en_contents,n_contents,wtype2";
if(!$find){
$q1="select $cols from (select $cols from $board where wtype2 is null order by no desc) WHERE rnum>$starts and rownum <=$numbers order by ino desc";
}else{
$sq=" wtype2 is null and ";
if($wtype1=="en"){
if($find=="all"){$sq.="en_title like '%$word%' or id like '%$word%' or en_name like '%$word%' or en_contents like '%$word%'";}
else if($find=="title"){$sq.="en_title like '%$word%'";}
else if($find=="id"){$sq.="id like '%$word%'";}
else if($find=="name"){$sq.="en_name like '%$word%'";}
else if($find=="contents"){$sq.="en_contents like '%$word%'";}
}else{
if($find=="all"){$sq.="n_title like '%$word%' or id like '%$word%' or n_name like '%$word%' or n_contents like '%$word%'";}
else if($find=="title"){$sq.="n_title like '%$word%'";}
else if($find=="id"){$sq.="id like '%$word%'";}
else if($find=="name"){$sq.="n_name like '%$word%'";}
else if($find=="contents"){$sq.="n_contents like '%$word%'";}
}
$q1="select $cols from (select $cols from $board where ($sq) order by no desc) WHERE rnum>$starts and rownum <=$numbers and ($sq) order by ino desc";
}
//echo "q1=$q1 ";
//echo "starts=$starts numbers=$numbers";
ora_parse($cur,$q1);
ora_exec($cur);
while(ora_fetch($cur)) {
$no=ora_getcolumn($cur,1);
$wtype1=ora_getcolumn($cur,2);
$wnation=nation($wtype1);
$en_title=ora_getcolumn($cur,3);
$en_title=cut_str($en_title,50);
$n_title=ora_getcolumn($cur,4);
$wdate=contime(ora_getcolumn($cur,5),"/");
$wsee=ora_getcolumn($cur,6);
$filename=explode("|",ora_getcolumn($cur,7));
$n_contents=ora_getcolumn($cur,13);
$file1=explode(".",$filename[0]);
if($board!="notice_hboard")
{
if(trim($n_contents)){$read="nread2.html";}
else{$read="nread.html";$wnation="English";}
?>
";}
}
?>
