갤러리 스킨에서 체크해준글들을 위에서부터 출력 하고 십습니다
본문
갤러리 스킨에서 체크해준글들을 위에서부터 나타 나게 하고 십습니다
wr_3을 체크하면은 리스트에서 위에서부터 출력 하고 싶습니다.
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
include_once("$board_skin_path/skin.lib.php");
if (!function_exists("imagecopyresampled")) alert("GD 2.0.1 이상 버전이 설치되어 있어야 사용할 수 있는 갤러리 게시판 입니다.");
if (!$board[bo_1]) {
$board[bo_1] = "210";
$sql = " update $g4[board_table] set bo_1 = '$board[bo_1]', bo_1_subj = '목록 가로 픽셀' where bo_table = '$bo_table' ";
sql_query($sql);
}
if (!$board[bo_2]) {
$board[bo_2] = "120";
$sql = " update $g4[board_table] set bo_2 = '$board[bo_2]', bo_2_subj = '목록 세로 픽셀' where bo_table = '$bo_table' ";
sql_query($sql);
}
$mod = $board[bo_gallery_cols];
$td_width = (int)(100 / $mod);
// 선택옵션으로 인해 셀합치기가 가변적으로 변함
$colspan = 5;
if ($is_category) $colspan++;
if ($is_checkbox) $colspan++;
if ($is_good) $colspan++;
if ($is_nogood) $colspan++;
// 제목이 두줄로 표시되는 경우 이 코드를 사용해 보세요.
// <nobr style='display:block; overflow:hidden; width:000px;'>제목</nobr>
?>
<style>
<!--
.board_line {background-color:#d9e5f2;}
.board_top { display:inline-block; width:98%; height:25px; margin:5px;}
.board_page { clear:both; text-align:center; }
.board_page a:link { color:#777; }
.board_list .notice { font-weight:normal; font:bold 11px tahoma; color:#2C88B9; }
.board_list .current { font:bold 11px tahoma; color:#E15916; }
.board_list .comment { font-family:Tahoma; font-size:10px; color:#EE5A00; }
.board_search { text-align:center; margin:10px 0 0 0; }
.board_search .stx { height:21px; border:1px solid #9A9A9A; border-right:1px solid #D8D8D8; border-bottom:1px solid #D8D8D8; }
-->
</style>
<link rel="stylesheet" href="<?=$board_skin_path?>/basic.css" type="text/css">
<!-- 게시판 목록 시작 -->
<table width="<?=$width?>" align="center" cellpadding="0" cellspacing="0"><tr><td>
<!-- 분류 셀렉트 박스, 게시물 몇건, 관리자화면 링크 -->
<div class="board_top">
<div style="float:left;">
<form name="fcategory" method="get" style="margin:0px;">
<? if ($is_category) { ?>
<select name=sca onchange="location='<?=$category_location?>'+<?=strtolower($g4[charset])=='utf-8' ? "encodeURIComponent(this.value)" : "this.value"?>;">
<option value=''>전체</option>
<?=$category_option?>
</select>
<? } ?>
<?=subject_sort_link('wr_good', $qstr2, 1)?>추천순</a> <span style='font-size:11px; color:#D2D2D2;'>|</span> <?=subject_sort_link('wr_hit', $qstr2, 1)?>조회순</a> <span style='font-size:11px; color:#D2D2D2;'>|</span> <?=subject_sort_link('wr_comment', $qstr2, 1)?>코멘트순</a> <? if ($is_checkbox) { ?> <input onclick="if (this.checked) all_checked(true); else all_checked(false);" type=checkbox><?}?>
</form>
</div>
<div style="float:right;">
<span style="font-size:8pt;"><font face="Tahoma" color="#999999">Total. <?=number_format($total_count)?></font></span>
<? if ($rss_href) { ?><a href='<?=$rss_href?>'><img src='<?=$board_skin_path?>/img/btn_rss.gif' border=0 align=absmiddle></a><?}?>
<? if ($admin_href) { ?><a href="<?=$admin_href?>"><img src="<?=$board_skin_path?>/img/btn_admin.gif" title="관리자" border="0" align="absmiddle"></a><?}?>
</div>
</div>
<div style="border-bottom:2px solid #ff3e00; height:2px;"></div>
<!-- 목록 -->
<form name="fboardlist" method="post">
<input type='hidden' name='bo_table' value='<?=$bo_table?>'>
<input type='hidden' name='sfl' value='<?=$sfl?>'>
<input type='hidden' name='stx' value='<?=$stx?>'>
<input type='hidden' name='spt' value='<?=$spt?>'>
<input type='hidden' name='page' value='<?=$page?>'>
<input type='hidden' name='sw' value=''>
<table width=100% cellpadding=0 cellspacing=0 align=center>
<tr>
<? for ($i=0; $i<count($list); $i++) { ?>
<?
if ($i && $i%$mod==0)
echo "</tr><tr>";
$style = "";
$subject = "<span $style>{$list[$i][subject]}</span>";
$comment_cnt = "";
if ($list[$i][comment_cnt])
$comment_cnt = "<a href=\"{$list[$i][comment_href]}\"><span style='font-size:10px;'><font face='Tahoma' color='#EE5A00'>{$list[$i][comment_cnt]}</span></a>";
$list[$i][name] = preg_replace("/<img /", "<img style='display:none;' ", $list[$i][name]);
$list[$i][name] = preg_replace("/> <span/", "><span", $list[$i][name]);
$list[$i][name] = preg_replace("/class='member'/", "", $list[$i][name]);
?>
<td width="<?=$td_width?>%" valign=top style="padding:10px 0px 0 0;">
<div class="bl-wrap">
<ul>
<li class="bl-box">
<div class="bl">
<div class="bl-list">
<table width="210" border="0" align="center" cellpadding="0" cellspacing="0">
<tr><td align=center width="210" height="120">
<div style='float:left; border:1px solid #e3e3e3; background:#fff; padding:0px; font-size:0; line-height:0;'><a href='<?=$list[$i][href]?>'><?=makeThumbs($g4[path]."/data/file/$bo_table", $list[$i][file][0][file], $board[bo_1], $board[bo_2], cut_str($list[$i][subject],20))?></a></div>
</td></tr>
<tr><td height='40' align=center>
<? if($list[$i][wr_1]==1){?>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr><td height="23" background="<?=$board_skin_path?>/img/upso.jpg" style="padding:0px 0 0 10px;"><a href="<?=$g4[bbs_path]?>/board.php?bo_table=<?=$bo_table?>&sfl=wr_1&stx=1"><span style="color:#ffffff;font-weight:bold;font-size:13;">오피걸닷컴 제휴업소</span></a></td></tr>
</table>
<? } if($list[$i][wr_1]==2){?>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr><td height="23" background="<?=$board_skin_path?>/img/no_upso.jpg" style="padding:0 0 0 10px;"><a href="<?=$g4[bbs_path]?>/board.php?bo_table=<?=$bo_table?>&sfl=wr_1&stx=2"><span style="color:#ffffff;font-weight:bold;font-size:13;">오피걸닷컴 비제휴업소</span></a></td></tr>
</table><? }?>
</td></tr>
<tr><td height="1" align=center bgcolor="#CCCCCC"></td></tr>
<tr><td align=center><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><td height="24"><a href='<?=$list[$i][ca_name_href]?>'><span style="color:#e52518;font-weight:bold;font-size:13;"><?=$list[$i][ca_name]?></span></a></td></tr>
<tr><td height="24"><a href='<?=$list[$i][href]?>'><span style="color:#444444;font-size:13;font-weight:bold;"><?=$subject?></span></a></td></tr>
<tr><td height="24"><span style="color:#888888;font-size:13;">전화번호:</span><a href='<?=$list[$i][href]?>'><?=$list[$i][wr_2]?></a></td></tr>
</table></td></tr>
<? if ($is_checkbox) {?><tr><td align=center><input type=checkbox name=chk_wr_id[] value='<?=$list[$i][wr_id]?>'></td></tr><? }?>
</table>
</div>
</div>
</li>
</ul>
</div>
<?
}
// 나머지 td
$cnt = $i%$mod;
if ($cnt)
for ($i=$cnt; $i<$mod; $i++)
echo "<td width='{$td_width}%'> </td>";
?>
<? if (count($list) == 0) { echo "<tr><td colspan='$mod' height=100 align=center>게시물이 없습니다.</td></tr>"; } ?>
</td></tr>
</table>
</form>
<!-- 버튼 링크 -->
<div style="margin:10px 0 0 0;">
<div style="float:left;">
<? if ($list_href) { ?>
<a href="<?=$list_href?>"><img src="<?=$board_skin_path?>/img/btn_list.gif" align="absmiddle" border='0'></a>
<? } ?>
<? if ($is_checkbox) { ?>
<a href="javascript:select_delete();"><img src="<?=$board_skin_path?>/img/btn_select_delete.gif" align="absmiddle" border='0'></a>
<a href="javascript:select_copy('copy');"><img src="<?=$board_skin_path?>/img/btn_select_copy.gif" align="absmiddle" border='0'></a>
<a href="javascript:select_copy('move');"><img src="<?=$board_skin_path?>/img/btn_select_move.gif" align="absmiddle" border='0'></a>
<? } ?>
</div>
<div style="float:right;">
<? if ($write_href) { ?><a href="<?=$write_href?>"><img src="<?=$board_skin_path?>/img/btn_write.gif" border='0'></a><? } ?>
</div>
</div>
<!-- 페이지 표시 시작 -->
<? if ($write_pages) { ?>
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="middle" background="<?=$board_skin_path?>/img/number_line.gif">
<table width="100%" height="36" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" align="center">
<? if ($prev_part_href) { echo "<a href='$prev_part_href'><img src='$board_skin_path/img/page_search_prev.gif' border='0' align=absmiddle title='이전검색'></a>"; } ?>
<?
// 기본으로 넘어오는 페이지를 아래와 같이 변환하여 이미지로도 출력할 수 있습니다.
//echo $write_pages;
$write_pages = str_replace("처음", "<img src='$board_skin_path/img/page_begin.gif' border='0' align='absmiddle' title='처음'>", $write_pages);
$write_pages = str_replace("이전", "<img src='$board_skin_path/img/page_prev.gif' border='0' align='absmiddle' title='이전'>", $write_pages);
$write_pages = str_replace("다음", "<img src='$board_skin_path/img/page_next.gif' border='0' align='absmiddle' title='다음'>", $write_pages);
$write_pages = str_replace("맨끝", "<img src='$board_skin_path/img/page_end.gif' border='0' align='absmiddle' title='맨끝'>", $write_pages);
//$write_pages = preg_replace("/<span>([0-9]*)<\/span>/", "$1", $write_pages);
$write_pages = preg_replace("/<b>([0-9]*)<\/b>/", "<b><span style=\"color:#4D6185; font-size:12px; text-decoration:underline;\">$1</span></b>", $write_pages);
?>
<?=$write_pages?>
<? if ($next_part_href) { echo "<a href='$next_part_href'><img src='$board_skin_path/img/page_search_next.gif' border='0' align=absmiddle title='다음검색'></a>"; } ?> </td>
</tr>
</table></td>
</tr>
</table>
<? } ?>
<!-- 페이지 표시 끝 -->
<!-- 검색 -->
<table cellSpacing=1 cellPadding="10" width="100%" bgColor=#dfe4e9 border=0 height="21">
<tr>
<td align=middle bgColor=#f6f9fb>
<form name="fsearch" method="get">
<input type="hidden" name="bo_table" value="<?=$bo_table?>">
<input type="hidden" name="sca" value="<?=$sca?>">
<select name="sfl" class="sel">
<option value="wr_subject">제목</option>
<option value="wr_content">내용</option>
<option value="wr_subject||wr_content">제목+내용</option>
<option value="mb_id,1">아이디</option>
<option value="mb_id,0">아이디(코)</option>
<option value="wr_name,1">글쓴이</option>
<option value="wr_name,0">글쓴이(코)</option>
</select>
<input name="stx" class="stx" maxlength="28" itemname="검색어" required value='<?=stripslashes($stx)?>'>
<input type="image" src="<?=$board_skin_path?>/img/btn_search.gif" border='0' align="absmiddle">
<input type="radio" name="sop" value="and">AND
<input type="radio" name="sop" value="or">OR
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
<script type="text/javascript">
if ('<?=$sca?>') document.fcategory.sca.value = '<?=$sca?>';
if ('<?=$stx?>') {
document.fsearch.sfl.value = '<?=$sfl?>';
if ('<?=$sop?>' == 'and')
document.fsearch.sop[0].checked = true;
if ('<?=$sop?>' == 'or')
document.fsearch.sop[1].checked = true;
} else {
document.fsearch.sop[0].checked = true;
}
</script>
<? if ($is_checkbox) { ?>
<script type="text/javascript">
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 check_confirm(str) {
var f = document.fboardlist;
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(str + "할 게시물을 하나 이상 선택하세요.");
return false;
}
return true;
}
// 선택한 게시물 삭제
function select_delete() {
var f = document.fboardlist;
str = "삭제";
if (!check_confirm(str))
return;
if (!confirm("선택한 게시물을 정말 "+str+" 하시겠습니까?\n\n한번 "+str+"한 자료는 복구할 수 없습니다"))
return;
f.action = "./delete_all.php";
f.submit();
}
// 선택한 게시물 복사 및 이동
function select_copy(sw) {
var f = document.fboardlist;
if (sw == "copy")
str = "복사";
else
str = "이동";
if (!check_confirm(str))
return;
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>
<? } ?>
<!-- 게시판 목록 끝 -->
답변 1
1 게시물 리스트 2번뿌리기
wr_3 채크 한걸 한번 더 뿌려준다
2 sql 커리문 에서 wr_3을 기준으로 뿌려 주도로 고친다
커리문에 조건 을 보면 오더 바이 등등 같은 문구를 고처주면 될듯합니다
