게시판 Slider-TosRUs02 스킨 목록에서 첨부한 파일 모두 출력 채택완료
이시태
7년 전
조회 4,178

Slider-TosRUs02 스킨
목록에서 모든 게시물에 첨부 한 파일을 불러 오는데 까지 성공했는데
특정 게시물 클릭 후 tosrus 라이브러리 실행하면
모든 게시물에 첨부 한 파일들이 전부 출력이 됩니다.
이걸 특정 글 클릭시 해당 게시물에 첨부 한 내용만 출력하고자 하는데
잘 안되네요.
어떻게 하면 될까요?
</p>
<div class="line number2 index1 alt1">function get_file_2($bo_table, $wr_id){</div>
<div class="line number3 index2 alt2"> </div>
<div class="line number4 index3 alt1"> global $g5, $qstr;</div>
<div class="line number5 index4 alt2"> </div>
<div class="line number6 index5 alt1"> $file['count'] = 0;</div>
<div class="line number7 index6 alt2"> $sql = " select * from {$g5['board_file_table']} where bo_table = '$bo_table' and wr_id = '$wr_id' order by bf_no ";</div>
<div class="line number8 index7 alt1"> /**</div>
<div class="line number9 index8 alt2"> $sql = " select ";</div>
<div class="line number10 index9 alt1"> $sql .= " a.* ";</div>
<div class="line number11 index10 alt2"> $sql .= " , b.* ";</div>
<div class="line number12 index11 alt1"> $sql .= " {$g5['board_file_table']} ";</div>
<div class="line number13 index12 alt2"> $sql .= " where ";</div>
<div class="line number14 index13 alt1"> $sql .= " a left join g5_building2write_0201 b on (a.wr_id = b.wr_id) ";</div>
<div class="line number15 index14 alt2"> $sql .= " 1 = 1 ";</div>
<div class="line number16 index15 alt1"> $sql .= " and ";</div>
<div class="line number17 index16 alt2"> $sql .= " a.bo_table = '$bo_table' ";</div>
<div class="line number18 index17 alt1"> $sql .= " and ";</div>
<div class="line number19 index18 alt2"> $sql .= " a.wr_id = '$wr_id' ";</div>
<div class="line number20 index19 alt1"> $sql .= " and ";</div>
<div class="line number21 index20 alt2"> $sql .= " b.wr_id = '$wr_id' ";</div>
<div class="line number22 index21 alt1"> $sql .= " order by a.bf_o ";</div>
<div class="line number23 index22 alt2"> **/</div>
<div class="line number24 index23 alt1"> </div>
<div class="line number25 index24 alt2"> //echo $sql;</div>
<div class="line number26 index25 alt1"> </div>
<div class="line number27 index26 alt2"> $result = sql_query($sql);</div>
<div class="line number28 index27 alt1"> </div>
<div class="line number29 index28 alt2"> while ($row = sql_fetch_array($result)){</div>
<div class="line number30 index29 alt1"> </div>
<div class="line number31 index30 alt2"> $no = $row['bf_no'];</div>
<div class="line number32 index31 alt1"> $file[$no]['href'] = G5_BBS_URL."/download.php?bo_table=$bo_table&wr_id=$wr_id&no=$no" . $qstr;</div>
<div class="line number33 index32 alt2"> $file[$no]['download'] = $row['bf_download'];</div>
<div class="line number34 index33 alt1"> </div>
<div class="line number35 index34 alt2"> // 4.00.11 - 파일 path 추가</div>
<div class="line number36 index35 alt1"> $file[$no]['path'] = G5_DATA_URL.'/file/'.$bo_table;</div>
<div class="line number37 index36 alt2"> $file[$no]['size'] = get_filesize($row['bf_filesize']);</div>
<div class="line number38 index37 alt1"> $file[$no]['datetime'] = $row['bf_datetime'];</div>
<div class="line number39 index38 alt2"> $file[$no]['source'] = addslashes($row['bf_source']);</div>
<div class="line number40 index39 alt1"> $file[$no]['bf_content'] = $row['bf_content'];</div>
<div class="line number41 index40 alt2"> $file[$no]['content'] = get_text($row['bf_content']);</div>
<div class="line number42 index41 alt1"> </div>
<div class="line number43 index42 alt2"> //$file[$no]['view'] = view_file_link($row['bf_file'], $file[$no]['content']);</div>
<div class="line number44 index43 alt1"> $file[$no]['view'] = view_file_link($row['bf_file'], $row['bf_width'], $row['bf_height'], $file[$no]['content']);</div>
<div class="line number45 index44 alt2"> $file[$no]['file'] = $row['bf_file'];</div>
<div class="line number46 index45 alt1"> $file[$no]['image_width'] = $row['bf_width'] ? $row['bf_width'] : 640;</div>
<div class="line number47 index46 alt2"> $file[$no]['image_height'] = $row['bf_height'] ? $row['bf_height'] : 480;</div>
<div class="line number48 index47 alt1"> $file[$no]['image_type'] = $row['bf_type'];</div>
<div class="line number49 index48 alt2"> $file[$no]['wr_id'] = $row['wr_id'];</div>
<div class="line number50 index49 alt1"> </div>
<div class="line number51 index50 alt2"> $file['count']++;</div>
<div class="line number52 index51 alt1"> </div>
<div class="line number53 index52 alt2"> }</div>
<div class="line number54 index53 alt1"> </div>
<div class="line number55 index54 alt2"> return $file;</div>
<div class="line number56 index55 alt1">}</div>
<div class="line number57 index56 alt2"> </div>
<div class="line number58 index57 alt1">/////////////////////////////////////////////////////</div>
<div class="line number59 index58 alt2"> </div>
<div class="line number60 index59 alt1"> </div>
<div class="line number61 index60 alt2">for ($i = 0; $i < count($list); $i++){</div>
<div class="line number62 index61 alt1">$thumb = get_list_thumbnail($board['bo_table'], $list[$i]['wr_id'], $board['bo_gallery_width'], $board['bo_gallery_height']);</div>
<div class="line number63 index62 alt2">$thumb2 = get_file_2($board['bo_table'], $list[$i]['wr_id']);</div>
<div class="line number64 index63 alt1">}</div>
<div class="line number65 index64 alt2">for($a = 0; $a <= count($thumb2); $a++){</div>
<div class="line number66 index65 alt1"> <a href="<?=$thumb2[$a]['path']?>/<?=$thumb2[$a]['file']?>"></div>
<div class="line number67 index66 alt2">if($a == 0){</div>
<div class="line number68 index67 alt1"><img src="<?=$thumb2[$a]['path']?>/<?=$thumb2[$a]['file']?>" /></div>
<div class="line number69 index68 alt2">}</div>
<div class="line number70 index69 alt1"></a></div>
<div class="line number71 index70 alt2">}</div>
<div class="line number72 index71 alt1">$a = "";</div>
<div class="line number73 index72 alt2">?></div>
<p>
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
답변을 작성하려면 로그인이 필요합니다.
로그인