답변 2개
채택된 답변
+20 포인트
11년 전
latest.lib.php 관련함수 입니다. 나머지는 조금만 노력해보시면 될껍니다.
</div>
<div>
</div>
<div>
</div>
<div>
</div>
<div>
<div>function latest_all($skin_dir="", $bo_table="", $rows=10, $subject_len=40, $options="", $page=1, $dataonly=false)</div>
<div>{</div>
<div> global $g4;</div>
<div>
</div>
<div> if ($skin_dir)</div>
<div> $latest_skin_path = "$g4[path]/skin/latest/$skin_dir";</div>
<div> else</div>
<div> $latest_skin_path = "$g4[path]/skin/latest/basic";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$where = "";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bo_subject = "전체최신글";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bo_new = 7;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$more_link = $g4[bbs_path] ."/new.php";</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$from_record = ($page-1) * $rows; // 시작 열을 구함</div>
<div>
</div>
<div> $list = array();</div>
<div>
</div>
<div> $sql = " SELECT </div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>a.bo_table, a.wr_id, a.bn_datetime, b.bo_subject , b.bo_subject_len</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>from $g4[board_new_table] a, $g4[board_table] b</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>WHERE a.bo_table = b.bo_table and b.bo_use_search = '1' and wr_id = wr_parent and b.bo_display = 'Y' {$where} </div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>ORDER BY bn_id DESC LIMIT $from_record, $rows ";</div>
<div> $result = sql_query($sql);</div>
<div> for ($i=0; $row = sql_fetch_array($result); $i++) {</div>
<div> $list[$i] = $row;</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$tmp_write_table = $g4[write_prefix] . $row[bo_table];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$row2 = sql_fetch(" select wr_subject, wr_comment, wr_name, wr_option from $tmp_write_table where wr_id = '$row[wr_id]' ");</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$list[$i]["bo_new"] = $bo_new;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$list[$i]["subject"] = conv_subject($row2["wr_subject"], $subject_len, "…");</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>// 당일인 경우 시간으로 표시함</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$datetime = $row["bn_datetime"];</div>
<div> $datetime2 = substr($datetime,0,10);</div>
<div> if ($datetime2 == $g4[time_ymd])</div>
<div> $datetime2 = substr($datetime,11,5);</div>
<div> else</div>
<div> $datetime2 = substr($datetime,5,5);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$list[$i]["bn_datetime"] = $datetime2;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$list[$i]["bn_datetime2"] = $datetime;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$list[$i]["wr_name"] = $row2["wr_name"];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$list[$i]["wr_comment"] = $row2["wr_comment"];</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$list[$i]["icon_secret"] = false;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if (strstr($row2["wr_option"], "secret"))</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$list[$i]["icon_secret"] = true;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>// 파일아이콘 출력만을 위한 퀴리를 작성.</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$list[$i]["iconf"] = "";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$row2 = sql_fetch(" select bf_type from $g4[board_file_table] where bo_table = '". $row["bo_table"] ."' and wr_id = '". $row["wr_id"] ."' order by bf_type desc limit 1 "); </div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if ($row2["bf_type"] != "") { </div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span> $list[$i]["iconf"] = $row2["bf_type"];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span></div>
<div>
</div>
<div> }</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>ob_start();</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>include "$latest_skin_path/latest.skin.php";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$content = ob_get_contents();</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>ob_end_clean();</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>return $content;</div>
<div>
</div>
<div>}</div></div>
<div>
</div>
<div>
</div>
<div>
</div>
<div>
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인