root 님 좀 봐주세요..
고맙습니다..일단 추천수가 10넘으니 게시물이 나타나네요..
근데 정렬이 마음대로 되는듯 해요..
추천수가 높을 순으로 정렬이 되야 되는데..
엉켜서 정렬이 되는데..order by a.wr_good,a.wr_id desc 이부분을 손대야 하는지
너무 복잡하네요..도움 좀 부탁드리겟습니다..
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
define("_DOCTYPE_", "STYLE");
?>
<body leftmargin=0 topmargin=0 >
<?
//if ($hours < 1 || $hours > 72) {
//if ($hours < 1 || $hours > 6) {
// $hours = 1;
//}
$hours = 720;
$intime = date("Y-m-d H:i:s", time() - (int)(60 * 60 * $hours));
$sql = " select a.bo_subject, a.bo_table, b.gr_subject
from $cfg[table_board] a, $cfg[table_group] b
where a.gr_id = b.gr_id AND b.gr_id = '그룹명'
order by b.gr_id, a.bo_table ";
$result = sql_query($sql);
while ($row = mysql_fetch_array($result)) {
$tbl = "{$cfg[write_table_prefix]}{$row[bo_table]}";
$sql2 = " select a.wr_id,
a.wr_parent_id,
a.mb_id,
a.wr_name,
a.wr_email,
a.wr_num,
a.wr_file1,
a.wr_subject,
a.wr_comment,
a.wr_commentcnt,
a.wr_datetime,
a.wr_good,
b.mb_icon
from $tbl a left join $cfg[table_member] b on (a.mb_id = b.mb_id)
where a.wr_datetime >= '$intime' and a.wr_good >0
order by a.wr_good,a.wr_id desc ";
$result2 = sql_query($sql2);
for ($i = 0; $row2 = mysql_fetch_array($result2); $i++) {
if ($row2[wr_comment] > 0) {
$sql3 = " select wr_subject
from $tbl
where wr_comment = 0
and wr_parent_id = '$row2[wr_parent_id]' ";
$row3 = sql_fetch_array($sql3);
$wr_subject = $row3[wr_subject];
} else {
$wr_subject = $row2[wr_subject];
}
$wr_subject = get_text($wr_subject);
$key = $row2[wr_good] .$row2[wr_datetime] . $row[bo_table] . $row2[wr_id];
$list[$key]->bo_table = $row[bo_table];
$list[$key]->bo_subject = $row[bo_subject];
$list[$key]->mb_id = $row2[mb_id];
$list[$key]->mb_icon = $row2[mb_icon];
$list[$key]->wr_id = $row2[wr_id];
$list[$key]->wr_parent_id = $row2[wr_parent_id];
$list[$key]->wr_email = $row2[wr_email];
$list[$key]->wr_name = get_text(cut_str($row2[wr_name],12));
$list[$key]->wr_subject = get_text(cut_str($wr_subject,77,''));
$list[$key]->wr_comment = $row2[wr_comment];
$list[$key]->wr_commentcnt = $row2[wr_commentcnt];
$list[$key]->wr_datetime = substr($row2[wr_datetime],0,10);
$list[$key]->wr_good = $row2[wr_good];
$list[$key]->wr_file1 = $row2[wr_file1];
}
mysql_free_result($result2);
}
mysql_free_result($result);
?>
<table border=0 cellspacing=0 cellpadding=0 width=100% bgcolor>
<?
if (count($list) > 0) {
//krsort($list); // 주석처리
natsort($list); // natsort()로 소팅하도록 변경
$good_rank=0;
foreach ($list as $key=>$value) {
$comment = "";
$atag_comment = "";
if ($value->wr_comment > 0) {
$comment = "<span style='font-size:8pt;'>[c]</span> ";
$atag_comment = "#c{$value->wr_id}";
}
$commentcnt = "";
if ($value->wr_commentcnt > 0)
$commentcnt = "<font size=-1>({$value->wr_commentcnt})</font>";
$wr_name = gblayer($value->mb_id, $value->wr_name, $value->wr_email);
$good_rank ++;
echo "<tr><td valign=top style=padding-left:3<a href='./?doc=$cfg[bbs_dir]/gnuboard.php&bo_table=".$value->bo_table."&wr_id=".$value->wr_parent_id."$atag_comment'>{$value->bo_subject}</font>...<font style=font-size:9pt color=black>{$value->wr_subject}</b></font></a> <font color=#3366FF style=font-size:8pt>({$value->wr_good})</font></td>";
echo "<tr><td height=1 colspan=2></td>";
//echo "<tr><td height=1 background=/img/dot03.gif></td>";
}
} else
echo "<td height=25 align=center>등록된 글이 없습니다.</td>";
?>
</table>
근데 정렬이 마음대로 되는듯 해요..
추천수가 높을 순으로 정렬이 되야 되는데..
엉켜서 정렬이 되는데..order by a.wr_good,a.wr_id desc 이부분을 손대야 하는지
너무 복잡하네요..도움 좀 부탁드리겟습니다..
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
define("_DOCTYPE_", "STYLE");
?>
<body leftmargin=0 topmargin=0 >
<?
//if ($hours < 1 || $hours > 72) {
//if ($hours < 1 || $hours > 6) {
// $hours = 1;
//}
$hours = 720;
$intime = date("Y-m-d H:i:s", time() - (int)(60 * 60 * $hours));
$sql = " select a.bo_subject, a.bo_table, b.gr_subject
from $cfg[table_board] a, $cfg[table_group] b
where a.gr_id = b.gr_id AND b.gr_id = '그룹명'
order by b.gr_id, a.bo_table ";
$result = sql_query($sql);
while ($row = mysql_fetch_array($result)) {
$tbl = "{$cfg[write_table_prefix]}{$row[bo_table]}";
$sql2 = " select a.wr_id,
a.wr_parent_id,
a.mb_id,
a.wr_name,
a.wr_email,
a.wr_num,
a.wr_file1,
a.wr_subject,
a.wr_comment,
a.wr_commentcnt,
a.wr_datetime,
a.wr_good,
b.mb_icon
from $tbl a left join $cfg[table_member] b on (a.mb_id = b.mb_id)
where a.wr_datetime >= '$intime' and a.wr_good >0
order by a.wr_good,a.wr_id desc ";
$result2 = sql_query($sql2);
for ($i = 0; $row2 = mysql_fetch_array($result2); $i++) {
if ($row2[wr_comment] > 0) {
$sql3 = " select wr_subject
from $tbl
where wr_comment = 0
and wr_parent_id = '$row2[wr_parent_id]' ";
$row3 = sql_fetch_array($sql3);
$wr_subject = $row3[wr_subject];
} else {
$wr_subject = $row2[wr_subject];
}
$wr_subject = get_text($wr_subject);
$key = $row2[wr_good] .$row2[wr_datetime] . $row[bo_table] . $row2[wr_id];
$list[$key]->bo_table = $row[bo_table];
$list[$key]->bo_subject = $row[bo_subject];
$list[$key]->mb_id = $row2[mb_id];
$list[$key]->mb_icon = $row2[mb_icon];
$list[$key]->wr_id = $row2[wr_id];
$list[$key]->wr_parent_id = $row2[wr_parent_id];
$list[$key]->wr_email = $row2[wr_email];
$list[$key]->wr_name = get_text(cut_str($row2[wr_name],12));
$list[$key]->wr_subject = get_text(cut_str($wr_subject,77,''));
$list[$key]->wr_comment = $row2[wr_comment];
$list[$key]->wr_commentcnt = $row2[wr_commentcnt];
$list[$key]->wr_datetime = substr($row2[wr_datetime],0,10);
$list[$key]->wr_good = $row2[wr_good];
$list[$key]->wr_file1 = $row2[wr_file1];
}
mysql_free_result($result2);
}
mysql_free_result($result);
?>
<table border=0 cellspacing=0 cellpadding=0 width=100% bgcolor>
<?
if (count($list) > 0) {
//krsort($list); // 주석처리
natsort($list); // natsort()로 소팅하도록 변경
$good_rank=0;
foreach ($list as $key=>$value) {
$comment = "";
$atag_comment = "";
if ($value->wr_comment > 0) {
$comment = "<span style='font-size:8pt;'>[c]</span> ";
$atag_comment = "#c{$value->wr_id}";
}
$commentcnt = "";
if ($value->wr_commentcnt > 0)
$commentcnt = "<font size=-1>({$value->wr_commentcnt})</font>";
$wr_name = gblayer($value->mb_id, $value->wr_name, $value->wr_email);
$good_rank ++;
echo "<tr><td valign=top style=padding-left:3<a href='./?doc=$cfg[bbs_dir]/gnuboard.php&bo_table=".$value->bo_table."&wr_id=".$value->wr_parent_id."$atag_comment'>{$value->bo_subject}</font>...<font style=font-size:9pt color=black>{$value->wr_subject}</b></font></a> <font color=#3366FF style=font-size:8pt>({$value->wr_good})</font></td>";
echo "<tr><td height=1 colspan=2></td>";
//echo "<tr><td height=1 background=/img/dot03.gif></td>";
}
} else
echo "<td height=25 align=center>등록된 글이 없습니다.</td>";
?>
</table>
|
댓글을 작성하시려면 로그인이 필요합니다.
로그인
댓글 1개
답변자가 어떤상황인지 하나하나 만들어 테스트를 해야하는데... 어떤상황인지 인지하는것이 쉽지가 않기 때문에..
어떤식으로 나와야 하는데... 어떤식으로 나오고 있다의 좀더 구체적인 설명이 필요하며...
참고 테스트 URL 정도라도 알려주시면 더 좋습니다.
지난번 테스트같은 경우도 추천수를 일일이 만들어서 테스트 했는데... 경우의 수에 다 안걸린것 같군요.ㅋㅋ