예전에 연재 소스에서 최근게시물 옆에 날짜 출력할려면 ..? 정보
그누보드 예전에 연재 소스에서 최근게시물 옆에 날짜 출력할려면 ..?본문
<!-- 연재 -->
<table width=100% cellpadding=0 cellspacing=0>
<tr><td height=1 background='./bbs/line.gif'></td></tr>
<tr class='subject subjectbg ht'><td colspan=2> 연재</td></tr>
<tr><td height=1 background='./bbs/line.gif'></td></tr>
<?
$max_i = 7; // 출력갯수
$wtime = date("Y-m-d H:i:s", time()-86400*14);
$arr_series = array("bbking", "kevin", "cgirl", "jktclc", "eric", "wowman", "sung63", "mizobata");
for ($i=0; $i<count($arr_series); $i++) {
$sql = " select wr_id, wr_subject, wr_datetime, wr_commentcnt from $cfg[write_table_prefix]{$arr_series[$i]} where wr_comment = 0 and wr_datetime > '$wtime' ";
$result = sql_query($sql);
while ($row=mysql_fetch_array($result)) {
$aseries[$row[wr_datetime].$arr_series[$i]][table] = $arr_series[$i];
$aseries[$row[wr_datetime].$arr_series[$i]][datetime] = $row[wr_datetime];
$aseries[$row[wr_datetime].$arr_series[$i]][id] = $row[wr_id];
$aseries[$row[wr_datetime].$arr_series[$i]][subject] = $row[wr_subject];
$aseries[$row[wr_datetime].$arr_series[$i]][cnt] = $row[wr_commentcnt];
}
}
@krsort($aseries);
$xtime = date("Y-m-d H:i:s", time()-86400*3);
$i=0;
foreach ($aseries as $key=>$value) {
if ($i++ >= $max_i) break;
$subject = conv_subject($value[subject], 60,"…");
$new = "";
if ($value[datetime] > $xtime) {
$new = "<img src='$latest_skin/icon_new.gif' align=absmiddle> ";
}
$cnt = "";
if ($value[cnt]) {
$cnt = " ($value[cnt])";
}
echo "<tr><td height=22>$new<a href='./?doc=$cfg[bbs_dir]/gnuboard.php&bo_table=$value[table]&wr_id=$value[id]'>$subject$cnt</a></td></tr>";
}
?>
</table>
예전에 관리자님이 올려 주신 연재 소스인데요.. 최근게시물옆에 날짜 나오게 할려면 어떻게 하나요..
수고하십시요.
최강그누보드..
<table width=100% cellpadding=0 cellspacing=0>
<tr><td height=1 background='./bbs/line.gif'></td></tr>
<tr class='subject subjectbg ht'><td colspan=2> 연재</td></tr>
<tr><td height=1 background='./bbs/line.gif'></td></tr>
<?
$max_i = 7; // 출력갯수
$wtime = date("Y-m-d H:i:s", time()-86400*14);
$arr_series = array("bbking", "kevin", "cgirl", "jktclc", "eric", "wowman", "sung63", "mizobata");
for ($i=0; $i<count($arr_series); $i++) {
$sql = " select wr_id, wr_subject, wr_datetime, wr_commentcnt from $cfg[write_table_prefix]{$arr_series[$i]} where wr_comment = 0 and wr_datetime > '$wtime' ";
$result = sql_query($sql);
while ($row=mysql_fetch_array($result)) {
$aseries[$row[wr_datetime].$arr_series[$i]][table] = $arr_series[$i];
$aseries[$row[wr_datetime].$arr_series[$i]][datetime] = $row[wr_datetime];
$aseries[$row[wr_datetime].$arr_series[$i]][id] = $row[wr_id];
$aseries[$row[wr_datetime].$arr_series[$i]][subject] = $row[wr_subject];
$aseries[$row[wr_datetime].$arr_series[$i]][cnt] = $row[wr_commentcnt];
}
}
@krsort($aseries);
$xtime = date("Y-m-d H:i:s", time()-86400*3);
$i=0;
foreach ($aseries as $key=>$value) {
if ($i++ >= $max_i) break;
$subject = conv_subject($value[subject], 60,"…");
$new = "";
if ($value[datetime] > $xtime) {
$new = "<img src='$latest_skin/icon_new.gif' align=absmiddle> ";
}
$cnt = "";
if ($value[cnt]) {
$cnt = " ($value[cnt])";
}
echo "<tr><td height=22>$new<a href='./?doc=$cfg[bbs_dir]/gnuboard.php&bo_table=$value[table]&wr_id=$value[id]'>$subject$cnt</a></td></tr>";
}
?>
</table>
예전에 관리자님이 올려 주신 연재 소스인데요.. 최근게시물옆에 날짜 나오게 할려면 어떻게 하나요..
수고하십시요.
최강그누보드..
댓글 전체