G4팁란에 올라온 유창화님의 rss관련팁

 

 

이눔을 G3용으로 해석부탁드립니다..

 

<?

//환경설정
$Ynum = 20;//몇개를 보여줄것인지 셑팅하세요
$Ytitle = '팔봉이의 전체 새글';//기본 환경 설정의 사이트 제목 말고, 다르게 사이트 제목을 출력하고 싶을때 사용하세요. 비워두면 기본 환경설정 사이트 제목이 들어갑니다.



include_once './_common.php';

// 특수문자 변환
function specialchars_replace($str, $len=0){

  if ($len)
    $str = substr($str, 0, $len);

  $str = preg_replace("/&/", "&amp;", $str);
  $str = preg_replace("/</", "&lt;", $str);
  $str = preg_replace("/>/", "&gt;", $str);
  return $str;
}

if (empty($g4['title']))
  $g4['title'] = $config['cf_title'];

if (!empty($Ytitle))
  $g4['title'] = $Ytitle;

$SiteTitle = specialchars_replace($g4['title']);
$SiteUrl = specialchars_replace($g4['url'] . '/');



Header("Content-type: text/xml");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");

echo "<?xml version=\"1.0\" encoding=\"" . $g4['charset'] . "\"?>\n";
echo "<rss version=\"2.0\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\">\n";
echo "<channel>\n";
echo "<title>" . $SiteTitle . "</title>\n";
echo "<link>" . $SiteUrl . "</link>\n";
echo "<description>" . $SiteTitle . "</description>\n";
echo "<language>ko</language>\n";

$sql_common = " from " . $g4['board_new_table'] . " a, " . $g4['board_table'] . " b, " . $g4['group_table'] . " c where a.bo_table = b.bo_table and b.gr_id = c.gr_id and b.bo_use_search = '1' ";

if (!empty($gr_id))
  $sql_common .= " and b.gr_id = '$gr_id' ";

$sql_common .= " and a.wr_id = a.wr_parent ";

$sql_order = " order by a.bn_id desc ";

$sql = " select a.*, b.bo_subject, c.gr_subject
                      $sql_common
                      $sql_order
                      limit $Ynum ";

$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {

  $tmp_write_table = $g4['write_prefix'] . $row['bo_table'];

  $row2 = sql_fetch(" select * from $tmp_write_table where wr_id = '" . $row['wr_id'] . "' ");

  //비밀글이면 통과
  if (preg_match("`secret`", $row2['wr_option'])) continue;

  $title = specialchars_replace($row2['wr_subject']);
  $link = specialchars_replace($g4['url'] . "/" . $g4['bbs'] . "/board.php?bo_table=" . $row['bo_table'] . "&wr_id=" . $row['wr_id']);

  $html = 0;
  if (strstr($row2['wr_option'], 'html1'))
    $html = 1;
  else if (strstr($row2['wr_option'], 'html2'))
    $html = 2;

  $row2['content'] = conv_content($row2['wr_content'], $html);
  $content = '<span>';

  $row2['file'] = get_file($row['bo_table'], $row['wr_id']);
  for ($j=0; $j<=count($row2['file']); $j++) {

    if ($row2['file'][$j]['view'])
      $content .= preg_replace("'([^:])//'", '\\1/' . $row['bo_table'] . '/', str_replace($g4['path'] . '/', $g4['url'] . '/', $row2['file'][$j]['view'])) . "<p>";
  }
  $content .= $row2['content'] . '</span>';

  $name = specialchars_replace($row2['wr_name']);
  $cate1 = specialchars_replace(preg_replace("` *?게시판`", "", $row['gr_subject']));
  $cate2 = specialchars_replace(preg_replace("` *?게시판`", "", $row['bo_subject']));

  $date = $row2['wr_datetime'];
  $date = date('r', strtotime($date));

  echo "<item>\n";
  echo "<title>" . $title . "</title>\n";
  echo "<link>" . $link . "</link>\n";
  echo "<description><![CDATA[" . $content . "]]></description>\n";
  echo "<dc:creator>" . $name . "</dc:creator>\n";
  echo "<category>" . $cate1 . "</category>\n";
  echo "<category>" . $cate2 . "</category>\n";
  echo "<dc:date>" . $date . "</dc:date>\n";
  echo "</item>\n";
}

echo "</channel>\n";
echo "</rss>\n";

?>