/", ">", $str); return $str; } $day_limit_all = 7; $day_limit_single = 30; $do_all = 0; if(strlen($bo_table) == 0) { // "do all boards" function added by JesusReigns, 9/15/2009 $do_all = 1; $sql = " select bo_table, bo_subject from g4_board where bo_read_level < 2 and bo_use_rss_view = 1 "; $result = sql_query($sql); $tables_str = ""; for(;$row = sql_fetch_array($result);) { $tables_str = $tables_str . " (select *, '$row[bo_table]' as bo_table, '$row[bo_subject]' as bo_subject from $g4[write_prefix]$row[bo_table]) union "; } $tables_str = substr($tables_str, 0, strlen($tables_str) - 7); $title = "All postings"; $lines = 100; $sql = "select t1.wr_id, t2.wr_subject, t1.wr_content, t1.wr_name, t1.wr_datetime, t1.wr_option, t1.wr_is_comment, t3.wr_content as original, length(t1.wr_comment_reply) as len_reply, t1.bo_table, t1.bo_subject from ( $tables_str ) as t1, ( $tables_str ) as t2, ( $tables_str ) as t3 where t1.wr_option not like '%secret%' and t1.wr_parent = t2.wr_id and t1.wr_comment = t3.wr_comment and t1.wr_parent = t3.wr_parent and left(t1.wr_comment_reply, length( t1.wr_comment_reply) -1) = t3.wr_comment_reply and datediff(now(), t1.wr_datetime) <= $day_limit_all order by t1.wr_datetime desc"; $link_stub = ""; } else { $sql = " select gr_id, bo_subject, bo_page_rows, bo_read_level, bo_use_rss_view from $g4[board_table] where bo_table = '$bo_table' "; $row = sql_fetch($sql); $subj2 = specialchars_replace($row[bo_subject], 255); //$lines = $row[bo_page_rows]; $lines = 100; // 비회원 읽기가 가능한 게시판만 RSS 지원 if ($row[bo_read_level] >= 2) { echo "비회원 읽기가 가능한 게시판만 RSS 지원합니다."; exit; } // RSS 사용 체크 if (!$row[bo_use_rss_view]) { echo "RSS 보기가 금지되어 있습니다."; exit; } $tables_str = "$g4[write_prefix]$bo_table"; $sql = " select gr_subject from $g4[group_table] where gr_id = '$row[gr_id]' "; $row = sql_fetch($sql); $subj1 = specialchars_replace($row[gr_subject], 255); $title = "$subj1 > $subj2"; //$sql = " select wr_id, wr_subject, wr_content, wr_name, wr_datetime, wr_option, wr_is_comment // from $g4[write_prefix]$bo_table // where wr_is_comment = 0 // and wr_option not like '%secret%' // order by wr_num, wr_reply limit 0, $lines "; $sql = "select t1.wr_id, t2.wr_subject, t1.wr_content, t1.wr_name, t1.wr_datetime, t1.wr_option, t1.wr_is_comment, t3.wr_content as original, length(t1.wr_comment_reply) as len_reply from $tables_str as t1, $tables_str as t2, $tables_str as t3 where t1.wr_option not like '%secret%' and t1.wr_parent = t2.wr_id and t1.wr_comment = t3.wr_comment and t1.wr_parent = t3.wr_parent and left(t1.wr_comment_reply, length( t1.wr_comment_reply) -1) = t3.wr_comment_reply and datediff(now(), t1.wr_datetime) <= $day_limit_single order by t1.wr_datetime desc"; $link_stub = "$g4[bbs]/board.php?bo_table=$bo_table"; } Header("Content-type: text/xml"); header("Cache-Control: no-cache, must-revalidate"); header("Pragma: no-cache"); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "".specialchars_replace("$g4[url]/$link_stub")."\n"; echo "테스트 버전 0.3j (2009-09-15)\n"; echo "ko\n"; $result = sql_query($sql); for ($i=0; $row=sql_fetch_array($result); $i++) { $file = ""; if (strstr($row[wr_option], 'html')) $html = 1; else $html = 0; echo "\n"; if($do_all) { echo "\n"; echo "".specialchars_replace("$g4[url]/$g4[bbs]/board.php?bo_table=$row[bo_table]&wr_id=$row[wr_id]")."\n"; } else { echo "\n"; echo "".specialchars_replace("$g4[url]/$g4[bbs]/board.php?bo_table=$bo_table&wr_id=$row[wr_id]")."\n"; } echo "앞글 내용 :
".conv_content($row[original], $html); } echo "]]>\n"; echo "".specialchars_replace($row[wr_name])."\n"; $date = $row[wr_datetime]; // rss 리더 스킨으로 호출하면 날짜가 제대로 표시되지 않음 //$date = substr($date,0,10) . "T" . substr($date,11,8) . "+09:00"; $date = date('r', strtotime($date)); echo "$date\n"; echo "\n"; } echo "\n"; echo "\n"; ?>