<?
include (str_replace("/public","",$_SERVER['DOCUMENT_ROOT'])."/setup/dblib.php");
//include $_SERVER[DOCUMENT_ROOT]."/abba/richlib/genesis.php";
if($_COOKIE['cLang']) $cLang=$_COOKIE['cLang'];
else $cLang=$_hbDefaultSetup['site_language'];
//$cLang=check_language($cLang);
if(!$lan) $lan=$cLang;

include $_SERVER['DOCUMENT_ROOT']."/abba/_head.php";
global $connect,$_hbDefaultSetup, $cLang, $is_admin, $prevdivpage, $nextdivpage;

if($setup['grant_list']<$member['level'] && !$is_admin) error("No access authority","/login/$id/?lan=$lan&category=$category&page=$page&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&no=$no&s_url=".urlencode($_SERVER['REQUEST_URI']),TRUE,"","ERR","/abba/holyboard.php");
if($s_que) { 
 $_dbTimeStart = getmicrotime();
 if(preg_match('/rich_people/i',$setup['skinname'])) {
  $que="SELECT * FROM ".$t_board."_".$id." ".$s_que." ORDER BY seq_no ASC ".$add_on." LIMIT ".$start_num.", ".$page_num;
 } else {
  $que="SELECT * FROM ".$t_board."_".$id." ".$s_que." ORDER BY ".$select_arrange." ".$desc." LIMIT ".$start_num.", ".$page_num;
 }
 $result=mysqli_query($connect,$que) or error(mysqli_error($connect));
 $_dbTime += getmicrotime()-$_dbTimeStart;
} else {
 if(preg_match('/rich_people/i',$setup['skinname'])) {
  $que="SELECT * FROM {$t_board}_{$id} {$s_que} ORDER BY seq_no ASC {$add_on} LIMIT {$start_num},{$page_num}";
  $_dbTimeStart = getmicrotime();
  $result=mysqli_query($connect,$que) or error(mysqli_error($connect),"","ERR","/abba/holyboard.php",TRUE);
  $_dbTime += getmicrotime()-$_dbTimeStart;
 } else if ($select_arrange=="headnum"&&$desc=="asc") {
  while($division_data=mysqli_fetch_array($division_result)) {
   $sum=$sum+$division_data['num'];
   $division=$division_data['division'];

   if($sum>=$start_num) {
    $start_num=$start_num-($sum-$division_data['num']);
    $_dbTimeStart = getmicrotime();
    $que="SELECT * FROM {$t_board}_{$id} WHERE `division`='{$division}' AND `headnum`<0 ORDER BY headnum,arrangenum LIMIT {$start_num}, {$page_num}";
    $result=mysqli_query($connect,$que) or error(mysqli_error($connect));
    $_dbTime += getmicrotime()-$_dbTimeStart;
    $check1=1;

    $returnNum = mysqli_num_rows($result);

    if($returnNum>=$page_num) { 
     break;
    } else {
     if($division>1) {
      $division--;
      $minus=$page_num-$returnNum;
      $_dbTimeStart=getmicrotime();
      $que2="SELECT * from $t_board"."_$id where division=$division and headnum!=0 order by headnum,arrangenum limit $minus";
      $result2=mysqli_query($connect,$que2) or error(mysqli_error($connect));
      $_dbTime += getmicrotime()-$_dbTimeStart;
      $check2=1;
      break;
     }
    }
   }
  }
 } else {
  $que="SELECT * FROM {$t_board}_{$id} {$s_que} ORDER BY {$select_arrange} {$desc} {$add_on} LIMIT {$start_num}, {$page_num}";
  $_dbTimeStart = getmicrotime();
  $result=mysqli_query($connect,$que) or error(mysqli_error($connect),"","ERR","/abba/holyboard.php",TRUE);
  $_dbTime += getmicrotime()-$_dbTimeStart;
 }
}

if($is_admin) {
 $_dbTimeStart = getmicrotime();
 $board_result=mysqli_query($connect,"SELECT no,name from $admin_table where no!='$setup[no]'");
 $_dbTime += getmicrotime()-$_dbTimeStart;
}

$print_page="";
$show_page_num=$setup['page_num'];
$start_page=(int)(($page-1)/$show_page_num)*$show_page_num;
$i=1;

$a_1_prev_page= "<!-- a>";
$a_1_next_page= "<!-- a>";
$a_prev_page = "<!-- a>";
$a_next_page = "<!-- a>";

$href_a1="";
$href_a1.=(isset($pid))?"&amp;pid=".$pid:"";
$href_a1.=(isset($category))?"&amp;category=".$category:"";
$href_a1.=(isset($list_style))?"&amp;list_style=".$list_style:"";
$href_a1.=(isset($sn1))?"&amp;sn1=".$sn1:"";
$href_a1.=(isset($sn))?"&amp;sn=".$sn:"";
$href_a1.=(isset($ss))?"&amp;ss=".$ss:"";
$href_a1.=(isset($sc))?"&amp;sc=".$sc:"";
$href_a1.=(isset($selected))?"&amp;selected=".$selected:"";
$href_a1.=(isset($selectB))?"&amp;selectB=".$selectB:"";
$href_a1.=(isset($keyword))?"&amp;keyword=".$keyword:"";
$href_a2="";
$href_a2.=(isset($select_arrange))?"&amp;select_arrange=".$select_arrange:"";
$href_a2.=(isset($desc))?"&amp;desc=".$desc:"";
$href_a3="";
$href_a3=(isset($divpage))?"&amp;divpage=".$divpage:"";
$href_attrib=$href_a1.$href_a2.$href_a3;

if($page>1) $a_1_prev_page="<a onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1.$href_a2."&amp;page=".($page-1)."\">";

if($page<$total_page) $a_1_next_page="<a onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1.$href_a2."&amp;page=".($page+1)."\">";

if($page>$show_page_num) {
 $prev_page=$start_page;
 $a_prev_page="<a class=\"a_prev_page\" onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1.$href_a2."&amp;page=".$prev_page."\">";
 $print_page.="<a class=\"print_page\" onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1.$href_a2."&amp;page=1\">1&nbsp;</a><span class=\"print_page\">&middot;&middot;&middot;</span>";
 $prev_page_exists=true;
 }

while($i+$start_page<=$total_page&&$i<=$show_page_num) {
 $move_page=$i+$start_page;
 if($page==$move_page) $print_page.=" <span class=\"cr_print_page\">".$move_page."</span> ";
 else $print_page.="<span class=\"print_page\"><a class=\"print_page\" onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1.$href_a2."&amp;page=".$move_page."\">&nbsp;&nbsp;".$move_page."&nbsp;&nbsp;</a></span>";
 $i++;
}

if($total_page>$move_page) {
 $next_page=$move_page+1;
 $a_next_page="<a class=\"a_next_page\" onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1.$href_a2."&amp;page=".$next_page."\">";
 $print_page.="<span class=\"print_page\">&middot;&middot;&middot;</span><a class=\"print_page\" onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1.$href_a2."&amp;page=".$total_page."\">&nbsp;".$total_page."</a>";
 $next_page_exists = true;
}

if($use_division) {
 if($prevdivpage&&!$prev_page_exists) $a_div_prev_page="<a class=\"a_div_prev_page\" onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1.$href_a2."&amp;divpage=".$prevdivpage."\">[이전 검색]</a>...";
 else $a_div_prev_page="";
 if($nextdivpage&&!$next_page_exists) $a_div_next_page="...<a class=\"a_div_next_page\" onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1.$href_a2."&amp;divpage=".$nextdivpage."\">[계속 검색]</a>";
 else $a_div_next_page="";
 $print_page = $a_div_prev_page.$print_page.$a_div_next_page;
}

if($is_admin||$member['level']<=$setup['grant_write']) $a_write="<a onfocus=\"blur()\" href=\"/write/".$id."/?lan=".$lan.$href_a1.$href_a2.$href_a3."&amp;page=".$page."&mode=write\" class=\"positive\" >";
else $a_write="<a href=\"\" class=\"disabled\">";

$a_prev_no=(isset($no))?"&prev_no=".$no:"";
if($is_admin||$member['level']<=$setup['grant_list']) $a_list="<a onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1.$href_a2.$href_a3."&amp;page=".$page.$a_prev_no."\" class=\"regular\">";
else $a_list="<a href=\"\" class=\"disabled\">";

$a_cancel="<a onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan."\">";

if(strtolower($desc)=="desc") $t_desc="asc"; else $t_desc="desc";

$a_no="<a onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1."&amp;select_arrange=headnum&amp;desc=".$t_desc."\">";
$a_subject="<a onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1."&amp;select_arrange=subject&amp;desc=".$t_desc."\">";
$a_name="<a onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1."&amp;select_arrange=name&amp;desc=".$t_desc."\">";
$a_hit="<a onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1."&amp;select_arrange=hit&amp;desc=".$t_desc."\">";
$a_vote="<a onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1."&amp;select_arrange=vote&amp;desc=".$t_desc."\">";
$a_date="<a onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1."&amp;select_arrange=reg_date&amp;desc=".$t_desc."\">";

for($N=1;$N<=10;$N++) {
 $a_download="a_download".$N;
 $download="download".$N;
 $$a_download="<a onfocus=\"blur()\" href=\"/".$id."/?lan=".$lan.$href_a1."&amp;select_arrange=".$download."&amp;desc=".$t_desc."\">";
}

if(!isset($_skinTime)) $_skinTime="";
$_skinTimeStart=getmicrotime();
head('',"script/script_list");

include $_SERVER['DOCUMENT_ROOT']."/abba/skin/".$setup['skinname']."/setup.php";
$_skinTime += getmicrotime()-$_skinTimeStart;
if($no&&$setup['use_alllist']) {
 $_view_included=true;
 include "view.php";
} else {
 if($category&&!$setup['use_language']) {$where="WHERE `category`='{$category}'";}
 else if($category&&$setup['use_language']&&$lan) {$where="WHERE `category`='{$category}' AND `lan`='{$lan}'";}
 else if(!$category&&preg_match("/rich_html/i",$setup['skinname'])&&$setup['use_category']&&$lan) {
   $tmpCatData=mysqli_fetch_array(mysqli_query($connect,"SELECT no FROM $t_category"."_$id $where ORDER BY seq_no ASC")); 
   $where="WHERE `lan`='{$lan}' AND `category`='{$tmpCatData['no']}'";
 }
 else if(!$category&&$setup['use_language']&&$lan) {$where="WHERE `lan`='{$lan}'";}
 else {$where="";}

 if(preg_match("/rich_html/i",$setup['skinname'])||(!$setup['use_category']&&$setup['use_showarticle'])) {
  $max_no=mysqli_fetch_array(mysqli_query($connect,"SELECT no FROM $t_board"."_$id $where ORDER BY reg_date DESC"));
  if($max_no) {
   $_view_included=true;
   $no=$max_no[0];
   include "view.php";
  }
 } else if($category&&$setup['use_category']) {
  if($setup['use_language'] && $lan) {$WHERE2="AND `lan`='".$lan."'";} else {$WHERE2="";}
  $catQuery="SELECT * FROM `".$t_category."_".$id."` WHERE `category` LIKE '".$category."' ".$WHERE2;
  $catResult=mysqli_query($connect,$catQuery);
  $catData=mysqli_fetch_array($catResult);
  if($catData['use_showartcle']) {
   $max_no=mysqli_fetch_array(mysqli_query($connect,"SELECT no FROM $t_board"."_$id $where ORDER BY reg_date DESC"));
   if($max_no) {
    $_view_included=true;
    $no=$max_no[0];
    include "view.php";
   }
  } 
 }
}

$_skinTimeStart = getmicrotime();
include "skin/".$setup['skinname']."/list_head.php";
$_skinTime += getmicrotime()-$_skinTimeStart;

$loop_number=$total-($page-1)*$page_num;
if($setup['use_alllist']&&!isset($prev_no)) $prev_no=$no;

$prev_cateogy = "1";
while($data=mysqli_fetch_array($result)) {
 list_check($data);
 $_skinTimeStart = getmicrotime();
 if($data['headnum']>-2000000000) {
   include "skin/".$setup['skinname']."/list_main.php";
   $prev_category = $data['category']; 
 } else {
   include "skin/".$setup['skinname']."/list_notice.php";
 }
 $_skinTime += getmicrotime()-$_skinTimeStart;
 $loop_number--;
}

if(isset($check2)) {
 while($data=mysqli_fetch_array($result2)) {
  list_check($data);
  $_skinTimeStart = getmicrotime();
  if($data['headnum']>-2000000000) {include "skin/".$setup['skinname']."/list_main.php";}
  else {include "skin/".$setup['skinname']."/list_notice.php"; }
  $_skinTime += getmicrotime()-$_skinTimeStart;
  $loop_number--;
 }
}

$_skinTimeStart = getmicrotime();
include "skin/".$setup['skinname']."/list_foot.php";
$_skinTime += getmicrotime()-$_skinTimeStart;

if($hbLayer) {
 $_skinTimeStart = getmicrotime();
 echo "\n<script type=\"text/javascript\">".$hbLayer."\n</script>\n\n";
 unset($hbLayer);
 $_skinTime += getmicrotime()-$_skinTimeStart;
}

foot();

include "_foot.php";

?>