최신글에서 공지 고정하는 소스를 알 수 있을까요.. 정보
최신글에서 공지 고정하는 소스를 알 수 있을까요..본문
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
?>
<div style="text-align:center;">
<div id="Layer0" style="width: 100%; border: 1 solid #cccccc">
<table align="center" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td>
<table width=100% border=0 cellpadding=0 cellspacing=0 <?=$options?>>
<tr>
<td align=center valign=top>
<? for ($i=0; $i<$rows; $i++) { ?>
<table width=95% border=0 cellpadding=0 cellspacing=0>
<tr>
<td height=25 <?if ($i<$rows-1) {?> style="padding:3px 0 0 0; border-bottom:1px dotted #ebebeb;" <?}?> >
<?
echo $list[$i]['icon_reply'] . " ";
echo "<a href='{$list[$i]['href']}'>";
echo "- {$list[$i]['subject']}";
echo "</a>";
if ($list[$i]['comment_cnt'])
echo " <a href=\"{$list[$i]['comment_href']}\"><span style='font-size:10px; color:#FF6600;'>{$list[$i]['comment_cnt']}</span></a>";
// if ($list[$i]['link']['count']) { echo "[{$list[$i]['link']['count']}]"; }
// if ($list[$i]['file']['count']) { echo "<{$list[$i]['file']['count']}>"; }
//echo " " . $list[$i]['icon_new'];
//echo " " . $list[$i]['icon_file'];
//echo " " . $list[$i]['icon_link'];
//echo " " . $list[$i]['icon_hot'];
//echo " " . $list[$i]['icon_secret'];
?>
</td>
</tr>
</table>
<? } ?>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</div>
-------------------------------------------------------
제가 사용하고 있는 최신글 소스입니다
게시판에서 글쓰기 공지 체크하면
최신글 상단에 항상 고정되게 할 수 있을까요...
부탁드립니다 ㅠㅠ
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
?>
<div style="text-align:center;">
<div id="Layer0" style="width: 100%; border: 1 solid #cccccc">
<table align="center" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td>
<table width=100% border=0 cellpadding=0 cellspacing=0 <?=$options?>>
<tr>
<td align=center valign=top>
<? for ($i=0; $i<$rows; $i++) { ?>
<table width=95% border=0 cellpadding=0 cellspacing=0>
<tr>
<td height=25 <?if ($i<$rows-1) {?> style="padding:3px 0 0 0; border-bottom:1px dotted #ebebeb;" <?}?> >
<?
echo $list[$i]['icon_reply'] . " ";
echo "<a href='{$list[$i]['href']}'>";
echo "- {$list[$i]['subject']}";
echo "</a>";
if ($list[$i]['comment_cnt'])
echo " <a href=\"{$list[$i]['comment_href']}\"><span style='font-size:10px; color:#FF6600;'>{$list[$i]['comment_cnt']}</span></a>";
// if ($list[$i]['link']['count']) { echo "[{$list[$i]['link']['count']}]"; }
// if ($list[$i]['file']['count']) { echo "<{$list[$i]['file']['count']}>"; }
//echo " " . $list[$i]['icon_new'];
//echo " " . $list[$i]['icon_file'];
//echo " " . $list[$i]['icon_link'];
//echo " " . $list[$i]['icon_hot'];
//echo " " . $list[$i]['icon_secret'];
?>
</td>
</tr>
</table>
<? } ?>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</div>
-------------------------------------------------------
제가 사용하고 있는 최신글 소스입니다
게시판에서 글쓰기 공지 체크하면
최신글 상단에 항상 고정되게 할 수 있을까요...
부탁드립니다 ㅠㅠ
( select a.* , ( select sum(co_count) as co_count from g4_qa_choose where mb_id=a.mb_id and bo_table = 'g4_qa' ) as q_co_count from `g4_write_g4_qa` a where wr_parent = '188224' and wr_8 != '' and wr_is_comment = 1 and CONVERT(wr_7, UNSIGNED) >= 5 group by wr_content having max(wr_7) order by CONVERT(wr_7, UNSIGNED) desc limit 3 )
1055 : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sir.a.wr_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
error file : /15sir/bbs/board.php