ccc님껄 제나름대로 수정해본 최신글추출 > 그누3 팁자료실

그누3 팁자료실

ccc님껄 제나름대로 수정해본 최신글추출 정보

일반 ccc님껄 제나름대로 수정해본 최신글추출

본문

userlib.inc.php의 내용입니다....######################
<? ccc님껄 제나름대로 수정해본 최신글추출

저의 경우는 /index.php
--[board]
--[list_skin]/[images]
/notice_skin.php
/main_skin.php
/photo_skin.php
--[include] &nbsp;/userlib.inc.php
요렇게 구성하고, $cfg[url] 을 사용하지 않았습니다.
어짜피 설치시에 config.inc.php를 다 건드려서 수정하시는분은 드물기 때문에
$filedir="/board/data/file"; 요렇게 직접 줫습니다.
글구 테이블을 자꾸 반복하는거가 좀 그래서 중간에 newlist함수 안에서 테이블로 감싸고
스킨에서는 <tr>내용</tr>만 반복하도록 했습니다.

// 최신글 추출
function newlist($skins, $bo_table, $rows, $subjectlen='')
{
 global $cfg;

 $sql = " select * from $cfg[table_board] where bo_table = '$bo_table' ";
 $bd = sql_fetch_array($sql);

 if ($subjectlen == '') $subjectlen = $bd[bo_subject_len];


 $cfg[board_table_prefix] = "사용자지정_"; // 게시판 테이블의 접두사

 // $cfg[url] &nbsp; &nbsp; = "http://www.ibokzi.com"; &nbsp; &nbsp;// 개인설정그누보드 경로에 맞게수정하세요 -- 전 사용안해요 절대경로

 // $skindir &nbsp; &nbsp; &nbsp;= "$cfg[url]/$cfg[list_skin]/$skins";
 $skinimg &nbsp; &nbsp; &nbsp;= "/list_skin/images"; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;// 이미지파일을 images폴더에 넣는걸 기본으로했습니다.
 $filedir &nbsp; &nbsp; &nbsp;= "/board/data/file"; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;//파일디렉토리

 $table = "{$cfg[board_table_prefix]}{$bo_table}";
 $result = sql_query_error(" select * from $table where wr_comment = 0 order by wr_id desc limit {$rows} ");
 echo "<table>";
 for ($i = 0; $row = mysql_fetch_array($result); $i++) {

 &nbsp; &nbsp; &nbsp; &nbsp; $wr_subject &nbsp; &nbsp; = get_text(cut_str($row[wr_subject], $subjectlen, '…'));
 &nbsp; &nbsp; &nbsp; &nbsp; $wr_content &nbsp; &nbsp; = get_text(cut_str($row[wr_content], 60, '…')); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // 내용 미리보기를 위해 넣었습니다. 400자까지만 짜르기했습니다.
 &nbsp; &nbsp; &nbsp; &nbsp; $wr_memo &nbsp; &nbsp; &nbsp; &nbsp;= $row[wr_content]; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;// 내용 미리보기를 위해 넣었습니다. 400자까지만 짜르기했습니다.
 &nbsp; &nbsp; &nbsp; &nbsp; $wr_id &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= $row[wr_id]; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // 게시판번호
 &nbsp; &nbsp; &nbsp; &nbsp; $wr_name &nbsp; &nbsp; &nbsp; &nbsp;= $row[wr_name]; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // 게시자이름 혹 최신글에 이름출력을 위해 변수선언했습니다.
 &nbsp; &nbsp; &nbsp; &nbsp; $wr_datetime &nbsp; &nbsp;= $row[wr_datetime]; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // 최신글에 날짜까지 출력하고싶을때를 위해 변수선언했습니다.
 &nbsp; &nbsp; &nbsp; &nbsp; $wr_commentcnt = $row[wr_commentcnt];
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if(0<$wr_commentcnt != ""){
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $wr_commentcnt = "($wr_commentcnt)";
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;}else{
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $wr_commentcnt = "";
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;}
 &nbsp; &nbsp; &nbsp; &nbsp; $image = $row[wr_file1]; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // 이미지를 뽑을 때 사용
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if(0<$image != ""){
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $image = "<img src=$filedir/$image height=35 width=35 border=1>";
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;}else{
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $image = "<img src=$filedir/noimage.gif height=35 width=35 border=1>";
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;}
 &nbsp; &nbsp; /* &nbsp; &nbsp;$icon = $row[wr_icon]; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // 아이콘을 뽑을때 사용
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if(0<$icon != ""){
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $icon = "<img src=$skindir/icon/icon_$icon.gif height=35 width=35 border=1>";
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;}else{
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $icon = "";
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;}
*/
 &nbsp; &nbsp; &nbsp; &nbsp; $mb_icon = $mb_id = ""; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;// 멤버 아이콘을 뽑을 때 사용
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if ($row[mb_id]) {
 &nbsp; &nbsp; &nbsp; &nbsp; $sql2 = " select mb_icon from gb_member where mb_id = '$row[mb_id]' ";
 &nbsp; &nbsp; &nbsp; &nbsp; $row2 = sql_fetch_array($sql2);
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if ($row2[mb_icon])
 &nbsp; &nbsp; &nbsp; &nbsp; $mb_icon = "<img src='/board/data/member/$row2[mb_icon]' align=absmiddle'>";
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;}

 &nbsp; &nbsp; &nbsp; &nbsp; $ca_name = $wr_id = ""; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;// 분류를 뽑을 때 사용
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if ($row[wr_id]) {
 &nbsp; &nbsp; &nbsp; &nbsp; $sql1 = " select ca_name from {$table}_cat where ca_id = '$row[ca_id]'";
 &nbsp; &nbsp; &nbsp; &nbsp; $row1 = sql_fetch_array($sql1);
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if ($row1[ca_name])
 &nbsp; &nbsp; &nbsp; &nbsp; $ca_name = "[$row1[ca_name]]";
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;}

 $icon_file = "";
 &nbsp; &nbsp; if ($row[wr_file1] || $row[wr_file2])
 &nbsp; &nbsp; &nbsp; &nbsp; $icon_file = "<img src='$skinimg/icon_file.gif' align=absmiddle>";

 &nbsp; &nbsp; $icon_link = "";
 &nbsp; &nbsp; if ($row[wr_link1] || $row[wr_link2])
 &nbsp; &nbsp; &nbsp; &nbsp; $icon_link = "<img src='$skinimg/icon_link.gif' align=absmiddle>";

 &nbsp; &nbsp; $a_list_link = "<a href='/board/gbview.php?bo_table=$bo_table&wr_id=$row[wr_id]' class=s_a>";

 &nbsp; &nbsp; $icon_new = "";
 &nbsp; &nbsp; if ($row[wr_datetime] >= date("Y-m-d H:i:s", time() - $bd[bo_new] * 3600))
 &nbsp; &nbsp; &nbsp; &nbsp; $icon_new = "<img src='$skinimg/icon_new.gif' align=absmiddle'>";

 &nbsp; &nbsp; $icon_hot = "";
 &nbsp; &nbsp; if ($row[wr_hit] >= $bd[bo_hot])
 &nbsp; &nbsp; &nbsp; &nbsp; $icon_hot = "<img src='$skinimg/icon_hot.gif' align=absmiddle'>";

 &nbsp; &nbsp; $icon_battle = "";
 &nbsp; &nbsp; if ($row[wr_commentcnt] >= $bd[bo_battle])
 &nbsp; &nbsp; &nbsp; &nbsp; $icon_battle = "<img src='$skinimg/icon_battle.gif' align=absmiddle'>";
 &nbsp; &nbsp; $icon_secret = "";
 &nbsp; &nbsp; if ($row[wr_secret])
 &nbsp; &nbsp; &nbsp; &nbsp; $icon_secret = "<img src='$skinimg/icon_secret.gif' align=absmiddle'>";

 // include "./$cfg[list_skin]/$skins/newlist_main.skin.php";
include "/home/hosting_users/user_id/html/list_skin/$skin_skin.php";
// &nbsp;$skin은 공지사항 notice, 일반형 nomal, 사진형 photo_skin.php
echo "</table>";
 }
 mysql_free_result($result);

}

?>
추천
9
  • 복사

댓글 전체

// include "./$cfg[list_skin]/$skins/newlist_main.skin.php";
include "/home/hosting_users/user_id/html/list_skin/$skin_skin.php";
//  $skin은 공지사항 notice, 일반형 nomal, 사진형 photo_skin.php
이부분의 사용법이 명확히 안나와 있군요.... 공지 사항 일때 메모형태로 1개와 나머지 제목갯수로 뽑을 수 있나요.?
© SIRSOFT
현재 페이지 제일 처음으로