갤러리 게시판
본문
현재 갤러리 게시판인데요.. 돋보기 버튼을 누르면 큰 첨부파일의 큰 이미지가 나옵니다..
이거를 만약에 첨부파일이 두개가 있다면 2번째 첨부파일의 큰 이미지를 보여주게 하고싶습니다..
어떻게 해야 되는걸까요?..
<?php
if (!defined('_GNUBOARD_')) exit; //禁止单独访问此页
include_once(G5_LIB_PATH.'/thumbnail.lib.php');
include_once($board_skin_path.'/list.include.php');
// add_stylesheet('css 文本', 显示顺序); 数字越小的优先显示
if ($bo_table != 'event') {
add_stylesheet('<link rel="stylesheet" href="'.$board_skin_url.'/style.css">', 0);
add_javascript('<script type="text/javascript" src="'.$board_skin_url.'/highslide/highslide.js"></script>', 0);
} else {
add_stylesheet('<link rel="stylesheet" href="'.$board_skin_url.'/event.css">', 0);
}
$kb_zoom = '1'; //pc확대기능 (1일 경우 zoom기능 사용.)
$mo_zoom = '1'; //mobile 확대기능 (1일 경우 zoom기능 사용.)
/* 모바일 설정 */
$colgallnum = '2'; // 한줄 당 이미지 수
//아래에서 계산을 해놨기에 의미는 없지만
//큰썸네일을 만들어야 화면이 큰 모바일에서 깨지지 않아요.
$board['bo_mobile_gallery_width'] = '800';//모바일 썸네일 너비
$board['bo_mobile_gallery_height'] = '600';//모바일 썸네일 높이
/* 모바일 설정 */
if (G5_IS_MOBILE){
$kb_zoom = $mo_zoom;
$bo_gallery_cols = $colgallnum;
if($colgallnum == '1'){$colgallnum_persnet = "95";}else{$colgallnum_persnet = floor(80/$colgallnum);}
if($colgallnum == '1'){$colgallnum_margin = "0";}else{$colgallnum_margin = floor(10/$colgallnum);}
$board['bo_gallery_width'] = $board['bo_mobile_gallery_width'] / $colgallnum;
$board['bo_gallery_height'] = $board['bo_mobile_gallery_height'] / $colgallnum;
$mobile_stylesul = 'width:'.$colgallnum_persnet.'%;text-align:left;margin-right:'.$colgallnum_margin.'%;display:inline-block; float:none;';
$mobile_stylesli = 'width:100%;';
$mobile_img_st = ' style="width:100%; height:auto" ';
$mobile_zoom_img = ' style="width:'.($colgallnum_persnet).'%" ';
}
?>
<script type="text/javascript">
hs.graphicsDir = '<?php echo $board_skin_url?>/highslide/graphics/';
// Identify a caption for all images. This can also be set inline for each image.
hs.captionId = 'the-caption';
hs.outlineType = 'rounded-white';
window.onload = function() {
hs.preloadImages(5);
}
</script>
<!--
<h2 id="container_title"><?php echo $board['bo_subject'] ?><span class="sound_only"> 目录</span></h2>
-->
<!-- 论坛版块目录开始 { -->
<div id="bo_gall" style="width:<?php echo $width; ?>">
<?php if ($is_category) { ?>
<nav id="bo_cate">
<h2><?php echo $board['bo_subject'] ?> 分类</h2>
<ul id="bo_cate_ul">
<?php echo $category_option ?>
</ul>
</nav>
<?php } ?>
<div class="bo_fx">
<div id="bo_list_total">
<!-- <span>Total <?php echo number_format($total_count) ?>件</span> -->
<!-- <?php echo $page ?> 页 -->
</div>
<?php if ($rss_href || $write_href) { ?>
<ul class="btn_bo_user">
<?php if ($rss_href) { ?><li><a href="<?php echo $rss_href ?>" class="btn_b01">RSS</a></li><?php } ?>
<?php if ($admin_href) { ?><li><a href="<?php echo $admin_href ?>" class="btn_admin">管理员</a></li><?php } ?>
<?php if ($write_href) { ?><li><a href="<?php echo $write_href ?>" class="btn_b02">发表主题</a></li><?php } ?>
</ul>
<?php } ?>
</div>
<form name="fboardlist" id="fboardlist" action="./board_list_update.php" onsubmit="return fboardlist_submit(this);" method="post">
<input type="hidden" name="bo_table" value="<?php echo $bo_table ?>">
<input type="hidden" name="sfl" value="<?php echo $sfl ?>">
<input type="hidden" name="stx" value="<?php echo $stx ?>">
<input type="hidden" name="spt" value="<?php echo $spt ?>">
<input type="hidden" name="sst" value="<?php echo $sst ?>">
<input type="hidden" name="sod" value="<?php echo $sod ?>">
<input type="hidden" name="page" value="<?php echo $page ?>">
<input type="hidden" name="sw" value="">
<?php if ($is_checkbox) { ?>
<div id="gall_allchk">
<label for="chkall" class="sound_only">当前所有主题</label>
<input type="checkbox" id="chkall" onclick="if (this.checked) all_checked(true); else all_checked(false);">
</div>
<?php } ?>
<ul id="gall_ul">
<?php for ($i=0; $i<count($list); $i++) {
if($i>0 && ($i % $bo_gallery_cols == 0))
$style = 'clear:both;';
else
$style = '';
if ($i == 0) $k = 0;
$k += 1;
if ($k % $bo_gallery_cols == 0) $style .= "margin:0 !important;";
?>
<li class="gall_li <?php if ($wr_id == $list[$i]['wr_id']) { ?>gall_now<?php } ?>" style="<?php echo $style ?>width:<?php echo $board['bo_gallery_width'] ?>px">
<?php if ($is_checkbox) { ?>
<label for="chk_wr_id_<?php echo $i ?>" class="sound_only"><?php echo $list[$i]['subject'] ?></label>
<input type="checkbox" name="chk_wr_id[]" value="<?php echo $list[$i]['wr_id'] ?>" id="chk_wr_id_<?php echo $i ?>">
<?php } ?>
<span class="sound_only">
<?php
if ($wr_id == $list[$i]['wr_id'])
echo "<span class=\"bo_current\">浏览中</span>";
else
echo $list[$i]['num'];
?>
</span>
<ul class="gall_con">
<li class="gall_href">
<?php
$wrid = $list[$i][wr_id];
$sql_img = sql_fetch ("select* from g5_board_file where wr_id = '$wrid' and bo_table='$bo_table' and bf_no = '0'");
$zoomimg_style= 'cursor: url('.$board_skin_url.'/highslide/graphics/zoomin.cur), pointer;outline: none;position:absolute;right:5px;bottom:5px;';
if($sql_img['bf_file']){
$img_links = '/data/file/'.$bo_table.'/'.$sql_img[bf_file];
}else{
$matches = get_editor_image($list[$i]['wr_content']);
preg_match("/src=[\'\"]?([^>\'\"]+[^>\'\"]+)/i", $matches[1][0], $m);
// 이미지 path 구함
$p = parse_url($m[1]);
if(strpos($p['path'], '/'.G5_DATA_DIR.'/') != 0)
$data_path = preg_replace('/^\/.*\/'.G5_DATA_DIR.'/', '/'.G5_DATA_DIR, $p['path']);
else
$data_path = $p['path'];
$img_links = $data_path;
}
if($img_links and $kb_zoom == '1'){
if($bo_table!='event') { //썸네일 확대기능 링크 ?>
<a href="<?php echo $img_links?>" style="<?php echo $zoomimg_style?>" class='highslide' onclick='return hs.expand(this)'>
<img src="<?php echo $board_skin_url ?>/img/btn_photo.png" alt="이미지확대" /></a>
<?php }
}?>
<a href="<?php echo $list[$i]['href'] ?>">
<?php
if ($list[$i]['is_notice']) { // 公告 ?>
<strong style="width:<?php echo $board['bo_gallery_width'] ?>px;height:<?php echo $board['bo_gallery_height'] ?>px">公告</strong>
<?php } else {
$thumb = get_list_thumbnail($board['bo_table'], $list[$i]['wr_id'], $board['bo_gallery_width'], $board['bo_gallery_height']);
if($thumb['src']) {
$img_content = '<img '.$mobile_img_st.' src="'.$thumb['src'].'" alt="'.$thumb['alt'].'" width="'.($board['bo_gallery_width']-1).'" height="'.$board['bo_gallery_height'].'">';
} else {
$img_content = '<img src="'.$board_skin_url.'/img/noimg.gif" alt="no_imgage" style="width:100%;height:auto" ">';
}
echo $img_content;
}
?>
</a>
</li>
<li class="gall_text_href" style="width:<?php echo $board['bo_gallery_width'] ?>px">
<?php
// echo $list[$i]['icon_reply']; 相册将不使用主题回复Replay功能 - 子云爸爸 2013-03-04
if ($is_category && $list[$i]['ca_name']) {
?>
<a href="<?php echo $list[$i]['ca_name_href'] ?>" class="bo_cate_link"><?php echo $list[$i]['ca_name'] ?></a>
<?php } ?>
<a href="<?php echo $list[$i]['href'] ?>">
<?php if($bo_table=="event") { echo $list[$i]['subject'] ?>
<?php if ($list[$i]['comment_cnt']) { ?><span class="sound_only">评论</span><?php echo $list[$i]['comment_cnt']; ?><span class="sound_only">个</span><?php } ?>
</a>
<?php
// if ($list[$i]['link']['count']) { echo '['.$list[$i]['link']['count']}.']'; }
// if ($list[$i]['file']['count']) { echo '<'.$list[$i]['file']['count'].'>'; }
if (isset($list[$i]['icon_new'])) echo $list[$i]['icon_new'];
if (isset($list[$i]['icon_hot'])) echo $list[$i]['icon_hot'];
//if (isset($list[$i]['icon_file'])) echo $list[$i]['icon_file'];
//if (isset($list[$i]['icon_link'])) echo $list[$i]['icon_link'];
//if (isset($list[$i]['icon_secret'])) echo $list[$i]['icon_secret'];
?>
</li>
<?php } if ($is_good) { ?><li><span class="gall_subject">推荐</span><strong><?php echo $list[$i]['wr_good'] ?></strong></li><?php } ?>
<?php if ($is_nogood) { ?><li><span class="gall_subject">反对</span><strong><?php echo $list[$i]['wr_nogood'] ?></strong></li><?php } ?>
</ul>
</li>
<?php if($bo_table!="event") { ?>
<div class='highslide-caption' id='the-caption'>
<a href="#" onclick="return hs.previous(this)" class="control" style="float:left; display: block">이전</a>
<a href="#" onclick="return hs.next(this)" class="control" style="float:left; display: block; text-align: right; margin-left: 4px">다음</a>
<a href="#" onclick="return hs.close(this)" class="control">닫기</a>
<nobr><a href="#" class="highslide-move control" onclick="return false">위치이동</a></nobr>
<div style="clear:both"></div>
</div>
<?php }//if ($list[$i]['is_notice']) { ?>
<?php }//for ?>
<?php if (count($list) == 0) { echo "<li class=\"empty_list\">没有主题内容可以显示</li>"; } ?>
</ul>
<?php if($is_admin) { //관리자만 체크박스가 보이도록 설정 ?>
<?php if ($list_href || $is_checkbox || $write_href) { ?>
<div class="bo_fx">
<?php if ($is_checkbox) { ?>
<ul class="btn_bo_adm">
<li><input type="submit" name="btn_submit" value="删除所选" onclick="document.pressed=this.value"></li>
<li><input type="submit" name="btn_submit" value="复制所选" onclick="document.pressed=this.value"></li>
<li><input type="submit" name="btn_submit" value="移动所选" onclick="document.pressed=this.value"></li>
</ul>
<?php }
}
?>
<?php if ($list_href || $write_href) { ?>
<ul class="btn_bo_user">
<?php if ($list_href) { ?><li><a href="<?php echo $list_href ?>" class="btn_b01">目录</a></li><?php } ?>
<?php if ($write_href) { ?><li><a href="<?php echo $write_href ?>" class="btn_b02">发表主题</a></li><?php } ?>
</ul>
<?php } ?>
</div>
<?php } ?>
</form>
</div>
<?php if($is_checkbox) { ?>
<noscript>
<p>浏览器中屏蔽javascript代码运行时<br>将不会出现操作提示直接执行所选操作,请务必谨慎操作!</p>
</noscript>
<?php } ?>
<?php
// 评论输入及输出
include_once('./view_comment.php');
?>
<!-- 页 -->
<?php echo $write_pages; ?>
<!-- 搜索主题开始 {
<fieldset id="bo_sch">
<legend>搜索主题</legend>
<form name="fsearch" method="get">
<input type="hidden" name="bo_table" value="<?php echo $bo_table ?>">
<input type="hidden" name="sca" value="<?php echo $sca ?>">
<input type="hidden" name="sop" value="and">
<label for="sfl" class="sound_only">搜索类型</label>
<select name="sfl" id="sfl">
<option value="wr_subject"<?php echo get_selected($sfl, 'wr_subject', true); ?>>主题</option>
<option value="wr_content"<?php echo get_selected($sfl, 'wr_content'); ?>>内容</option>
<option value="wr_subject||wr_content"<?php echo get_selected($sfl, 'wr_subject||wr_content'); ?>>标题+内容</option>
<option value="mb_id,1"<?php echo get_selected($sfl, 'mb_id,1'); ?>>会员ID</option>
<option value="mb_id,0"<?php echo get_selected($sfl, 'mb_id,0'); ?>>会员ID(评论)</option>
<option value="wr_name,1"<?php echo get_selected($sfl, 'wr_name,1'); ?>>作者</option>
<option value="wr_name,0"<?php echo get_selected($sfl, 'wr_name,0'); ?>>评论作者</option>
</select>
<label for="stx" class="sound_only">关键词<strong class="sound_only"> 必选项</strong></label>
<input type="text" name="stx" value="<?php echo stripslashes($stx) ?>" required id="stx" class="frm_input required" size="15" maxlength="20">
<input type="submit" value="搜索" class="btn_submit">
</form>
</fieldset>
-->
<!-- } 搜索主题结束 -->
<?php if ($is_checkbox) { ?>
<script>
function all_checked(sw) {
var f = document.fboardlist;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]")
f.elements[i].checked = sw;
}
}
function fboardlist_submit(f) {
var chk_count = 0;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]" && f.elements[i].checked)
chk_count++;
}
if (!chk_count) {
alert("请选择需要"+document.pressed+"内容");
return false;
}
if(document.pressed == "复制所选") {
select_copy("copy");
return;
}
if(document.pressed == "移动所选") {
select_copy("move");
return;
}
if(document.pressed == "删除所选") {
if (!confirm("确定删除所选内容吗?\n\n删除后的内容将无法进行恢复\n\n如主题包含评论内容\n只有在选择的情况下才能删除主题"))
return false;
f.removeAttribute("target");
f.action = "./board_list_update.php";
}
return true;
}
// 所选主题复制及移动
function select_copy(sw) {
var f = document.fboardlist;
if (sw == 'copy')
str = "复制";
else
str = "移动";
var sub_win = window.open("", "move", "left=50, top=50, width=500, height=550, scrollbars=1");
f.sw.value = sw;
f.target = "move";
f.action = "./move.php";
f.submit();
}
</script>
<?php } ?>
<!-- } 论坛版块目录结束 -->
답변 1
방법이야 많겠지만..
$sql_img = sql_fetch ("select* from g5_board_file where wr_id = '$wrid' and bo_table='$bo_table' and bf_no = '0'");
수정
$sql_img = sql_fetch ("select* from g5_board_file where wr_id = '$wrid' and bo_table='$bo_table' and bf_no = '1'");
if(!$sql_img['bf_no']){
$sql_img = sql_fetch ("select* from g5_board_file where wr_id = '$wrid' and bo_table='$bo_table' and bf_no = '0'");
}
이게 가장 쉬울거 같습니다만....
추가하자면...이미지파일인지 등도 체크를 해야 하지 않을까 싶네요.