list.skin.php 정렬 순서 / 글쓴순서로 바꾸고 싶어요 > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

list.skin.php 정렬 순서 / 글쓴순서로 바꾸고 싶어요 정보

list.skin.php 정렬 순서 / 글쓴순서로 바꾸고 싶어요

본문

lisk.skin.php 에서
현재 특정값에(지정날짜) 따라 정렬이 되는데
글쓴 순서대로 정렬하고 싶습니다.

이런식이에요.
5번 울하찡 2012.05.09~2012.05.11 ########
1번 울하질 2012.05.11~2012.05.13 ########

위의 순서 처럼  2012.05.09 -> 지정날짜 가 빠른순서로 정렬이 되고있습니다.

아래 내용중 어느부분이 위순서로 정렬은 담당하는걸까요?


<?php

sql_query("CREATE TABLE IF NOT EXISTS `{$g4['table_prefix']}expo` (`code` int(11) NOT NULL AUTO_INCREMENT, `field01` int(11) NOT NULL, `field02` varchar(255) NOT NULL, `field03` varchar(255) NOT NULL, `field04` text NOT NULL, `field05` varchar(255) NOT NULL, `bo_table` varchar(255) NOT NULL, `wr_id` int(11) NOT NULL, PRIMARY KEY (`code`), KEY `bo_table` (`bo_table`,`wr_id`)) CHARSET=utf8", false);
$list = array();
$where = "`wr_is_comment` = '0'";
if(!$_GET['sca']) $where .= " AND SUBSTRING(`wr_1`, 1, 6) = '" . date('Ym', $g4['server_time']) . "'";
else if($_GET['sca'] != 'all') $where .= " AND SUBSTRING(`wr_1`, 1, 6) = '{$_GET['sca']}'";
if($_GET['stx']) $where .= " AND INSTR(`wr_subject`, '{$_GET['stx']}') > 0";
$page = max(1, $_GET['page']);
$result = sql_query("SELECT * FROM `{$write_table}` WHERE {$where} ORDER BY `wr_1` ASC, `wr_2` ASC, `wr_num` ASC, `wr_reply` ASC LIMIT " . (($page - 1) * $board['bo_page_rows']) . ", {$board['bo_page_rows']}");
while($row = sql_fetch_array($result)) $list[] = get_list($row, $board, $board_skin_path, $board['bo_subject_len']);

?>
<script type="text/javascript">
//<![CDATA[
function expo_execute(command)
{
if($('#form').find('[name="chk_wr_id[]"]:checked').size() == 0)
{
alert('먼저 게시글을 선택해주세요.');
return false;
}
if(command == 'drop')
{
if(confirm('선택한 게시글을 삭제하시겠습니까?') == true)
{
$('#form').attr('action', '<?php echo $g4['bbs_path']; ?>/delete_all.php');
$('#form').submit();
}
}
else
{
var popup = window.open('', 'popup', 'top=50px, left=50px, width=500, height=550, scrollbars=1');
$('#form').find('[name="sw"]').attr('value', command);
$('#form').attr('target', 'popup');
$('#form').attr('action', '<?php echo $g4['bbs_path']; ?>/move.php');
$('#form').submit();
}
return false;
}
//]]>
</script>
<style type="text/css">
a.subject:link, a.subject:visited, a.subject:active{color:#626262; font-weight:bold; text-decoration:none;}
a.subject:hover{color:#D40A80; font-weight:bold; text-decoration:underline;}
</style>
<table width="<?php echo $width; ?>" border="0" cellpadding="0" cellspacing="0" align="center">
<?php if($is_checkbox || $admin_href || $write_href){ ?>
<tr><td height="10"></td></tr>
<?php } ?>
<tr><td>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="13" style="border-bottom:1px solid #C9C9C9;">&nbsp;</td>
<?php for($i = -2; $i < 12; $i++){ ?>
<?php $result = strtotime("{$i} MONTH", strtotime(date('Y-m-01', $g4['server_time']))); ?>
<?php if(date('Ym', $result) == $_GET['sca'] || ($i == 0 && !$_GET['sca'])){ ?>
<td width="53" valign="bottom"><img src="<?php echo $board_skin_path; ?>/img/b_<?php echo date('m', $result); ?>_on.gif"></td>
<?php } else{ ?>
<td width="53" valign="bottom"><a href="<?php echo $g4['bbs_path']; ?>/board.php?bo_table=<?php echo $board['bo_table']; ?>&sca=<?php echo date('Ym', $result); ?>"><img src="<?php echo $board_skin_path; ?>/img/b_<?php echo date('m', $result); ?>_off.gif"></a></td>
<?php } ?>
<?php } ?>
<td width="" style="border-bottom:1px solid #C9C9C9;">&nbsp;</td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td style="padding:12px; border-right:1px solid #C9C9C9; border-bottom:1px solid #C9C9C9; border-left:1px solid #C9C9C9;">
<form id="form" method="post">
<input type="hidden" name="bo_table" value="<?php echo $board['bo_table']; ?>">
<input type="hidden" name="sw" value="">
<input type="hidden" name="sca" value="<?php echo $sca; ?>">
<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="sop" value="<?php echo $sop; ?>">
<input type="hidden" name="page" value="<?php echo $page; ?>">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<?php for($i = 0; $i < count($list); $i++){ ?>
<?php if($i > 0){ ?>
<tr><td height="9" colspan="3"></td></tr>
<tr><td height="1" bgcolor="#D7D7D7" colspan="3"></td></tr>
<tr><td height="12" colspan="3"></td></tr>
<?php } ?>
<tr>
<td width="130" valign="top">
<table width="100%" border="0" cellpadding="4" cellspacing="1" bgcolor="#D7D7D7">
<?php if($list[$i]['file']['0']['view']){; ?>
<tr><td bgcolor="#FFFFFF"><a href="<?php echo $list[$i]['href']; ?>" title="클릭하시면 박람회내용을 자세히 볼 수 있습니다"><img src="<?php echo "{$list[$i]['file']['0']['path']}/{$list[$i]['file']['0']['file']}"; ?>" style="width:120px; border:none;"></a></td></tr>
<?php } else{ ?>
<tr><td bgcolor="#FFFFFF"><a href="<?php echo $list[$i]['href']; ?>" title="클릭하시면 박람회내용을 자세히 볼 수 있습니다"><img src="<?php echo $board_skin_path; ?>/img/p_none.gif" style="border:none;"></a></td></tr>
<?php } ?>
</table>
<?php if($is_checkbox){ ?>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td height="10"></td></tr>
<tr><td align="center"><input type="checkbox" name="chk_wr_id[]" value="<?php echo $list[$i]['wr_id']; ?>" style="width:13px; height:13px;"></td></tr>
</table>
<?php } ?>
</td>
<td width="15"></td>
<td width="" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr height="26">
<td style="padding:0px 5px 0px 5px;"><a href="<?php echo $list[$i]['href']; ?>" class="subject" title="클릭하시면 박람회내용을 자세히 볼 수 있습니다"><?php echo $list[$i]['wr_subject']; ?></a></td>
<td style="padding:0px 5px 0px 5px; color:#D31748; text-align:right;">
<font color="#666666">조회수</font>
<?php echo number_format($list[$i]['wr_hit']); ?>
</td>
</tr>
<tr><td height="1" background="<?php echo $board_skin_path; ?>/img/g_line.gif" colspan="2"></td></tr>
<tr height="26">
<td style="padding:0px 5px 0px 5px; color:#666666;">
<span style="font-size:8pt; font-family:dotum;">전시기간: </span>
<span style="font-size:8pt; font-family:verdana;"><?php echo preg_replace('/([0-9]{4})([0-9]{2})([0-9]{2})/', '\1-\2-\3', $list[$i]['wr_1']); ?> ~ <?php echo preg_replace('/([0-9]{4})([0-9]{2})([0-9]{2})/', '\1-\2-\3', $list[$i]['wr_2']); ?></span>
</td>
<td></td>
</tr>
<?php
$int = 0;
$result = sql_query("SELECT * FROM `{$write_table}` WHERE `wr_parent` = '{$list[$i]['wr_id']}' AND `wr_is_comment` = '1' ORDER BY `wr_1` ASC, `wr_5` ASC");
while($row = mysql_fetch_assoc($result)){
?>
<?php if($int > 0){ ?>
<tr><td height="5" colspan="2"></td></tr>
<?php } ?>
<tr><td height="1" background="<?php echo $board_skin_path; ?>/img/g_line.gif" colspan="2"></td></tr>
<tr><td height="5" colspan="2"></td></tr>
<tr height="20">
<td style="padding:0px 5px 0px 5px; color:#A5A5A5;">
<font color="#333333"><b>행사명:</b></font>
<a href="<?php echo $list[$i]['href']; ?>" class="subject" title="클릭하시면 박람회내용을 자세히 볼 수 있습니다"><?php echo $row['wr_subject']; ?></a>
</td>
<?php if($row['wr_3'] == '아시아나항공'){ ?>
<td style="padding:0px 5px 0px 5px; text-align:right;"><img src="<?php echo $board_skin_path; ?>/img/i_air_asiana.gif"></td>
<?php } else{ ?>
<td style="padding:0px 5px 0px 5px; text-align:right;"><img src="<?php echo $board_skin_path; ?>/img/i_air_korea.gif"></td>
<?php } ?>
</tr>
<tr height="20">
<td style="padding:0px 5px 0px 5px;">
<font color="#333333"><b>출발일:</b></font>
<span style="color:#666666;"><?php echo preg_replace('/([0-9]{4})([0-9]{2})([0-9]{2})/', '\1-\2-\3', $row['wr_1']); ?></span>
</td>
</tr>
<?php
$int++;
}
?>
</table>
</td>
</tr>
<?php } ?>
<?php if(count($list) == 0){ ?>
<tr><td height="300" align="center"><img src="<?php echo $board_skin_path; ?>/img/p_null.gif"></td></tr>
<?php } ?>
</table>
</form>
</td></tr>
</table><br><br>
</td></tr>
<tr><td style="padding:12px 15px 10px 15px; border:5px solid #EBEBEB; text-align:center;">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="left">
<?php if($is_checkbox){ ?>
<img src="<?php echo $board_skin_path; ?>/img/b_delete.gif" onclick="expo_execute('drop');" style="cursor:pointer;">
<img src="<?php echo $board_skin_path; ?>/img/b_copy.gif" onclick="expo_execute('copy');" style="cursor:pointer;">
<img src="<?php echo $board_skin_path; ?>/img/b_move.gif" onclick="expo_execute('move');" style="cursor:pointer;">
<?php } ?>
</td>
<td align="right">
<?php if($admin_href){ ?><a href="<?php echo $admin_href; ?>"><img src="<?php echo $board_skin_path; ?>/img/b_config.gif"></a><?php } ?>
<?php if($is_checkbox){ ?><a href="<?php echo $g4['bbs_path']; ?>/board.php?bo_table=<?php echo $board['bo_table']; ?>&sca=all"><img src="<?php echo $board_skin_path; ?>/img/b_all.gif"></a><?php } ?>
<?php if($write_href){ ?><a href="<?php echo $write_href; ?>"><img src="<?php echo $board_skin_path; ?>/img/b_write.gif"></a><?php } ?>
</td>
</tr>
</table>
</td></tr>
<?php if($write_pages){ ?>
<tr><td height="20"></td></tr>
<tr><td align="center"><?php echo $write_pages; ?></td></tr>
<?php } ?>
</table>
  • 복사

댓글 전체

흐음?
질문의 의도를 모르겠군요.

코드를 보니까 생성문이 왜인지 모르게 맨위에 있고..
셀렉문이 다중 쓰이는거 같은데..

어디쪽을 수정하고 싶으신건지..

정렬의 경우는 order by문을 수정하시면 될겁니다.

그누보드가 날자 관련 필드가..

datetime이었던가.. 했었던거 같은데..
© SIRSOFT
현재 페이지 제일 처음으로