여러게시판의 최신글 추출중 null값 문의 채택완료
아기강도
7년 전
조회 1,768
안녕하세요.
회원님께서 올려주신 latest_all 함수를 이용하여 게시판 두개의 최신글을 합쳐서 불러오려합니다.
news 와 visit 게시판 두개인데요
이중 news에는 예약게시글 기능이있어 wr_2 값에 게시날짜를 넣어두었습니다.
아래 코드를 실행시 news부분에서 해당날짜가 안되는 값들이 나중에 list에서 null값으로 나옵니다..
null값을 빼고 나오는 방법이 따로 있을까요?./.
</p>
<div style="color: rgb(212, 212, 212); line-height: 19px; font-family: Consolas, "Courier New", monospace; font-size: 14px; font-weight: normal; white-space: pre; background-color: rgb(30, 30, 30);">
<div><span style="color:#608b4e">// $bo_tables 테이블들 사이 콤마(,) 단위로 구분해서 넣을 것, 콤마 사이에 공백 없이 (ex aaa,bbb,)</span></div>
<div><span style="color:#569cd6">function</span><span style="color:#d4d4d4"> </span><span style="color:#dcdcaa">latest_all</span><span style="color:#d4d4d4">(</span><span style="color:#9cdcfe">$skin_dir</span><span style="color:#d4d4d4">=</span><span style="color:#ce9178">''</span><span style="color:#d4d4d4">,</span><span style="color:#9cdcfe"> $bo_tables</span><span style="color:#d4d4d4">,</span><span style="color:#9cdcfe"> $rows</span><span style="color:#d4d4d4">=</span><span style="color:#b5cea8">10</span><span style="color:#d4d4d4">,</span><span style="color:#9cdcfe"> $subject_len</span><span style="color:#d4d4d4">=</span><span style="color:#b5cea8">40</span><span style="color:#d4d4d4">,</span><span style="color:#9cdcfe"> $cache_time</span><span style="color:#d4d4d4">=</span><span style="color:#b5cea8">1</span><span style="color:#d4d4d4">,</span><span style="color:#9cdcfe"> $options</span><span style="color:#d4d4d4">=</span><span style="color:#ce9178">''</span><span style="color:#d4d4d4">)</span></div>
<div><span style="color:#d4d4d4">{</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#569cd6">global</span><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$g5</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#c586c0">if</span><span style="color:#d4d4d4"> (!</span><span style="color:#9cdcfe">$skin_dir</span><span style="color:#d4d4d4">) </span><span style="color:#9cdcfe">$skin_dir</span><span style="color:#d4d4d4"> = </span><span style="color:#ce9178">'basic'</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#c586c0">if</span><span style="color:#d4d4d4">(</span><span style="color:#dcdcaa">preg_match</span><span style="color:#d4d4d4">(</span><span style="color:#ce9178">'#^theme/(.+)$#'</span><span style="color:#d4d4d4">, </span><span style="color:#9cdcfe">$skin_dir</span><span style="color:#d4d4d4">, </span><span style="color:#9cdcfe">$match</span><span style="color:#d4d4d4">)) {</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#c586c0">if</span><span style="color:#d4d4d4"> (G5_IS_MOBILE) {</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$latest_skin_path</span><span style="color:#d4d4d4"> = G5_THEME_MOBILE_PATH</span><span style="color:#d4d4d4">.</span><span style="color:#ce9178">'/'</span><span style="color:#d4d4d4">.</span><span style="color:#d4d4d4">G5_SKIN_DIR</span><span style="color:#d4d4d4">.</span><span style="color:#d16969">'/latest/'</span><span style="color:#d4d4d4">.</span><span style="color:#9cdcfe">$match</span><span style="color:#d4d4d4">[</span><span style="color:#b5cea8">1</span><span style="color:#d4d4d4">];</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#c586c0">if</span><span style="color:#d4d4d4">(!</span><span style="color:#dcdcaa">is_dir</span><span style="color:#d4d4d4">(</span><span style="color:#9cdcfe">$latest_skin_path</span><span style="color:#d4d4d4">))</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$latest_skin_path</span><span style="color:#d4d4d4"> = G5_THEME_PATH</span><span style="color:#d4d4d4">.</span><span style="color:#ce9178">'/'</span><span style="color:#d4d4d4">.</span><span style="color:#d4d4d4">G5_SKIN_DIR</span><span style="color:#d4d4d4">.</span><span style="color:#d16969">'/latest/'</span><span style="color:#d4d4d4">.</span><span style="color:#9cdcfe">$match</span><span style="color:#d4d4d4">[</span><span style="color:#b5cea8">1</span><span style="color:#d4d4d4">];</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$latest_skin_url</span><span style="color:#d4d4d4"> = </span><span style="color:#dcdcaa">str_replace</span><span style="color:#d4d4d4">(G5_PATH, G5_URL, </span><span style="color:#9cdcfe">$latest_skin_path</span><span style="color:#d4d4d4">);</span></div>
<div><span style="color:#d4d4d4"> } </span><span style="color:#c586c0">else</span><span style="color:#d4d4d4"> {</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$latest_skin_path</span><span style="color:#d4d4d4"> = G5_THEME_PATH</span><span style="color:#d4d4d4">.</span><span style="color:#ce9178">'/'</span><span style="color:#d4d4d4">.</span><span style="color:#d4d4d4">G5_SKIN_DIR</span><span style="color:#d4d4d4">.</span><span style="color:#d16969">'/latest/'</span><span style="color:#d4d4d4">.</span><span style="color:#9cdcfe">$match</span><span style="color:#d4d4d4">[</span><span style="color:#b5cea8">1</span><span style="color:#d4d4d4">];</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$latest_skin_url</span><span style="color:#d4d4d4"> = </span><span style="color:#dcdcaa">str_replace</span><span style="color:#d4d4d4">(G5_PATH, G5_URL, </span><span style="color:#9cdcfe">$latest_skin_path</span><span style="color:#d4d4d4">);</span></div>
<div><span style="color:#d4d4d4"> }</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$skin_dir</span><span style="color:#d4d4d4"> = </span><span style="color:#9cdcfe">$match</span><span style="color:#d4d4d4">[</span><span style="color:#b5cea8">1</span><span style="color:#d4d4d4">];</span></div>
<div><span style="color:#d4d4d4"> } </span><span style="color:#c586c0">else</span><span style="color:#d4d4d4"> {</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#c586c0">if</span><span style="color:#d4d4d4">(G5_IS_MOBILE) {</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$latest_skin_path</span><span style="color:#d4d4d4"> = G5_MOBILE_PATH</span><span style="color:#d4d4d4">.</span><span style="color:#ce9178">'/'</span><span style="color:#d4d4d4">.</span><span style="color:#d4d4d4">G5_SKIN_DIR</span><span style="color:#d4d4d4">.</span><span style="color:#d16969">'/latest/'</span><span style="color:#d4d4d4">.</span><span style="color:#9cdcfe">$skin_dir</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$latest_skin_url</span><span style="color:#d4d4d4"> = G5_MOBILE_URL</span><span style="color:#d4d4d4">.</span><span style="color:#ce9178">'/'</span><span style="color:#d4d4d4">.</span><span style="color:#d4d4d4">G5_SKIN_DIR</span><span style="color:#d4d4d4">.</span><span style="color:#d16969">'/latest/'</span><span style="color:#d4d4d4">.</span><span style="color:#9cdcfe">$skin_dir</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4"> } </span><span style="color:#c586c0">else</span><span style="color:#d4d4d4"> {</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$latest_skin_path</span><span style="color:#d4d4d4"> = G5_SKIN_PATH</span><span style="color:#d4d4d4">.</span><span style="color:#d16969">'/latest/'</span><span style="color:#d4d4d4">.</span><span style="color:#9cdcfe">$skin_dir</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$latest_skin_url</span><span style="color:#d4d4d4"> = G5_SKIN_URL</span><span style="color:#d4d4d4">.</span><span style="color:#d16969">'/latest/'</span><span style="color:#d4d4d4">.</span><span style="color:#9cdcfe">$skin_dir</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4"> }</span></div>
<div><span style="color:#d4d4d4"> }</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$list</span><span style="color:#d4d4d4"> = </span><span style="color:#dcdcaa">array</span><span style="color:#d4d4d4">();</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$sql_common</span><span style="color:#d4d4d4"> = </span><span style="color:#ce9178">" from {</span><span style="color:#9cdcfe">$g5</span><span style="color:#ce9178">['board_new_table']} a where find_in_set(a.bo_table, '{</span><span style="color:#9cdcfe">$bo_tables</span><span style="color:#ce9178">}')"</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$sql_common</span><span style="color:#d4d4d4"> </span><span style="color:#d4d4d4">.=</span><span style="color:#d4d4d4"> </span><span style="color:#ce9178">" and a.wr_id = a.wr_parent "</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$sql_order</span><span style="color:#d4d4d4"> = </span><span style="color:#ce9178">" order by a.bn_id desc "</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$sql</span><span style="color:#d4d4d4"> = </span><span style="color:#ce9178">" select a.* {</span><span style="color:#9cdcfe">$sql_common</span><span style="color:#ce9178">} {</span><span style="color:#9cdcfe">$sql_order</span><span style="color:#ce9178">} limit 0, {</span><span style="color:#9cdcfe">$rows</span><span style="color:#ce9178">}"</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$result</span><span style="color:#d4d4d4"> = </span><span style="color:#dcdcaa">sql_query</span><span style="color:#d4d4d4">(</span><span style="color:#9cdcfe">$sql</span><span style="color:#d4d4d4">);</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#c586c0">for</span><span style="color:#d4d4d4"> (</span><span style="color:#9cdcfe">$i</span><span style="color:#d4d4d4">=</span><span style="color:#b5cea8">0</span><span style="color:#d4d4d4">; </span><span style="color:#9cdcfe">$row</span><span style="color:#d4d4d4">=</span><span style="color:#dcdcaa">sql_fetch_array</span><span style="color:#d4d4d4">(</span><span style="color:#9cdcfe">$result</span><span style="color:#d4d4d4">); </span><span style="color:#9cdcfe">$i</span><span style="color:#d4d4d4">++) {</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$sql</span><span style="color:#d4d4d4"> = </span><span style="color:#ce9178">" select * from {</span><span style="color:#9cdcfe">$g5</span><span style="color:#ce9178">['board_table']} where bo_table = '{</span><span style="color:#9cdcfe">$row</span><span style="color:#ce9178">['bo_table']}' "</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$board</span><span style="color:#d4d4d4"> = </span><span style="color:#dcdcaa">sql_fetch</span><span style="color:#d4d4d4">(</span><span style="color:#9cdcfe">$sql</span><span style="color:#d4d4d4">);</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$tmp_write_table</span><span style="color:#d4d4d4"> = </span><span style="color:#9cdcfe">$g5</span><span style="color:#d4d4d4">[</span><span style="color:#ce9178">'write_prefix'</span><span style="color:#d4d4d4">] </span><span style="color:#d4d4d4">.</span><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$row</span><span style="color:#d4d4d4">[</span><span style="color:#ce9178">'bo_table'</span><span style="color:#d4d4d4">];</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#c586c0">if</span><span style="color:#d4d4d4">(</span><span style="color:#dcdcaa">substr</span><span style="color:#d4d4d4">(</span><span style="color:#9cdcfe">$tmp_write_table</span><span style="color:#d4d4d4">,</span><span style="color:#b5cea8">9</span><span style="color:#d4d4d4">,</span><span style="color:#b5cea8">4</span><span style="color:#d4d4d4">) == </span><span style="color:#ce9178">'news'</span><span style="color:#d4d4d4">){</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$row2</span><span style="color:#d4d4d4"> = </span><span style="color:#dcdcaa">sql_fetch</span><span style="color:#d4d4d4">(</span><span style="color:#ce9178">" select * from {</span><span style="color:#9cdcfe">$tmp_write_table</span><span style="color:#ce9178">} where wr_id = '{</span><span style="color:#9cdcfe">$row</span><span style="color:#ce9178">['wr_id']}' and date_format(now(), '%Y%m%d %H:%i') > REPLACE( wr_2, '-', '') "</span><span style="color:#d4d4d4">);</span></div>
<div><span style="color:#d4d4d4"> }</span><span style="color:#c586c0">else</span><span style="color:#d4d4d4"> </span><span style="color:#c586c0">if</span><span style="color:#d4d4d4">(</span><span style="color:#dcdcaa">substr</span><span style="color:#d4d4d4">(</span><span style="color:#9cdcfe">$tmp_write_table</span><span style="color:#d4d4d4">,</span><span style="color:#b5cea8">9</span><span style="color:#d4d4d4">,</span><span style="color:#b5cea8">4</span><span style="color:#d4d4d4">) == </span><span style="color:#ce9178">'visit'</span><span style="color:#d4d4d4">){</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$row2</span><span style="color:#d4d4d4"> = </span><span style="color:#dcdcaa">sql_fetch</span><span style="color:#d4d4d4">(</span><span style="color:#ce9178">" select * from {</span><span style="color:#9cdcfe">$tmp_write_table</span><span style="color:#ce9178">} where wr_id = '{</span><span style="color:#9cdcfe">$row</span><span style="color:#ce9178">['wr_id']}' "</span><span style="color:#d4d4d4">);</span></div>
<div><span style="color:#d4d4d4"> }</span><span style="color:#c586c0">else</span><span style="color:#d4d4d4"> {</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$row2</span><span style="color:#d4d4d4"> = </span><span style="color:#dcdcaa">sql_fetch</span><span style="color:#d4d4d4">(</span><span style="color:#ce9178">" select * from {</span><span style="color:#9cdcfe">$tmp_write_table</span><span style="color:#ce9178">} where wr_id = '{</span><span style="color:#9cdcfe">$row</span><span style="color:#ce9178">['wr_id']}' "</span><span style="color:#d4d4d4">);</span></div>
<div><span style="color:#d4d4d4"> }</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$list</span><span style="color:#d4d4d4">[</span><span style="color:#9cdcfe">$i</span><span style="color:#d4d4d4">] = </span><span style="color:#9cdcfe">$row2</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$list</span><span style="color:#d4d4d4">[</span><span style="color:#9cdcfe">$i</span><span style="color:#d4d4d4">] = </span><span style="color:#dcdcaa">get_list</span><span style="color:#d4d4d4">(</span><span style="color:#9cdcfe">$row2</span><span style="color:#d4d4d4">, </span><span style="color:#9cdcfe">$board</span><span style="color:#d4d4d4">, </span><span style="color:#9cdcfe">$latest_skin_url</span><span style="color:#d4d4d4">, </span><span style="color:#9cdcfe">$subject_len</span><span style="color:#d4d4d4">);</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$list</span><span style="color:#d4d4d4">[</span><span style="color:#9cdcfe">$i</span><span style="color:#d4d4d4">][</span><span style="color:#ce9178">'bo_subject'</span><span style="color:#d4d4d4">] = </span><span style="color:#9cdcfe">$row</span><span style="color:#d4d4d4">[</span><span style="color:#ce9178">'bo_subject'</span><span style="color:#d4d4d4">];</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$list</span><span style="color:#d4d4d4">[</span><span style="color:#9cdcfe">$i</span><span style="color:#d4d4d4">][</span><span style="color:#ce9178">'bo_table'</span><span style="color:#d4d4d4">] = </span><span style="color:#9cdcfe">$row</span><span style="color:#d4d4d4">[</span><span style="color:#ce9178">'bo_table'</span><span style="color:#d4d4d4">];</span></div>
<div><span style="color:#d4d4d4"> }</span></div>
<div><span style="color:#d4d4d4"> </span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#dcdcaa">ob_start</span><span style="color:#d4d4d4">();</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#c586c0">include</span><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$latest_skin_path</span><span style="color:#d4d4d4">.</span><span style="color:#ce9178">'/latest.skin.php'</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$content</span><span style="color:#d4d4d4"> = </span><span style="color:#dcdcaa">ob_get_contents</span><span style="color:#d4d4d4">();</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#dcdcaa">ob_end_clean</span><span style="color:#d4d4d4">();</span></div>
<div><span style="color:#d4d4d4"> </span><span style="color:#c586c0">return</span><span style="color:#d4d4d4"> </span><span style="color:#9cdcfe">$content</span><span style="color:#d4d4d4">;</span></div>
<div><span style="color:#d4d4d4">}</span></div>
</div>
<p>
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
답변을 작성하려면 로그인이 필요합니다.
로그인