|
Server : Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 DAV/2 PHP/5.2.17 System : Linux localhost 2.6.18-419.el5 #1 SMP Fri Feb 24 22:47:42 UTC 2017 x86_64 User : nobody ( 99) PHP Version : 5.2.17 Disable Function : NONE Directory : /home/queenjbs/junsu/ |
Upload File : |
<?
include "$DOCUMENT_ROOT/conf/conf_dir.php";
if(!$pageCount) $pageCount = 8;
$show_one_page = $pageCount;
$show_view_page = 10;
$page = ( $page ) ? $page : 1;
$offset = ($page-1)*$show_one_page;
//총 회원;
if($sessionLevel !=15){ //관리자 일떄 다 보이기.
$where .= " and is_secret='N' ";
}
if($act == 0){
$where .="AND division not in (5,6)";
//$order_by ="order by subtitle desc";
}else{
$where .="AND division='$act'";
}
$order_by ="order by division asc,no desc,subtitle desc";
$tableName = "board_profile";
$total_count = get_db("SELECT count(*) FROM $tableName where is_delete = 'N' $where");
$query_limit = "limit $offset,$show_one_page";
$QUERY_PAGE = "SELECT * FROM $tableName where is_delete = 'N' $where $order_by $query_limit";
$total_page = ceil( $total_count / $show_one_page);
$more_next_page = $page+1;
$viewlist = ( !$total_count ) ? "" : Get_viewpage4($page,$total_count,$show_one_page,$show_view_page,$url_tail);
$start_num = $total_count - $offset; //
$result= mysql_query($QUERY_PAGE,$db_con);
if(!$result) {
error("DB_ERROR");
exit;
}
$total = mysql_affected_rows();
if(!$total)
{
//$BRD_LIST = "END";
}
else
{
for($i=0; $i<$total; $i++)
{
unset($New_icon,$img_file);
$Num = ($total_count-$offset) - $i;
$row = mysql_fetch_array($result);
$regdate = substr($row[reg_date],0,10);
$voted_count = number_format($row[voted_count]);
if($row[is_notice] =='Y'){$New_icon="<strong class='iconew'>NEW</strong>";}
if($row[is_secret] =='Y') $is_secret_chk="<font color=red>[관리자만 보임]</font>";
else $is_secret_chk="";
if($row[img_file1]) $img_file = "/files/muti/profile/$row[img_file1]";
else $img_file = "/images/noimages.jpg";
switch($row[division]){
case 1:
$gubun_title = "ALBUM";
break;
case 2:
$gubun_title = "OST";
break;
case 3:
$gubun_title = "MUSICAL";
break;
case 4:
$gubun_title = "MOVIE";
break;
}
$BRD_LIST .="
<div class='gall_ls_box' style='background-image:url($img_file); background-size: cover; background-repeat:no-repeat; background-position: 90% 50%;'>
<a href='javascript: openshow($row[no],$act);'>
<ul>
<li class='li_gubun'>$gubun_title</li>
<li class='li_like'><img src='../images/sub/icon_main_gallery_01.png' /> $voted_count 名</li>
</ul>
<dl>
<dt>$row[subject]</dt>
<dd>$row[subtitle]</dd>
<dd class='icon'><img src='../images/sub/icon_main_gallery_02.png' /></dd>
</dl>
</a>
</div>
";
}
}
echo $BRD_LIST;
?>
<div class="pagination02">
<ul class="paging">
<?=$viewlist?>
</ul>
</div>