신규블로그와 그 신규블로그의 최신글 추출

 

 

신규블로그 셋과 글 두개를 지정한 경우의 예 

헤드,풋은 자신의 상황에 맞게 알아서 지정...

이미지도 알아서 저장...

-------------------------------------------------------------------------

<?
$g4_path = ".";
include_once("$g4_path/_common.php");
$g4[title] = "블로그 홈";
include_once("$g4[path]/lib/blog.lib.php");
include_once("$g4[path]/gblog.config.php");
include_once("$g4[path]/head2.php");

?>
<table width=96% cellpadding=0 cellspacing=0>
<tr>
<td width=2></td>
<td width=300>
        <table width=300 cellpadding=0 cellspacing=0>

        <tr>
            <td><img src='<?=$gb4['blog_path']?>/img/new_blogger2.gif' border=0></td>
        </tr>
        <tr>
            <td height=5></td>
        </tr>

        <tr>
            <td bgcolor=#f7f7f7>
<?
$sql  = " select * from $gb4[blog_table] order by id desc limit 3 ";
$result = sql_query($sql);
for($i=0; $row = sql_fetch_array($result); $i++) {
?>
<table width=97% cellpadding=0 cellspacing=0 align=center  style='word-break:break-all;height:30px;padding:0 0 0 5px;'>
 <tr><td height=5></td></tr>
<?
$newdate = date("Y년 n월 j일", strtotime($row[regdate]));
$last_update = date("Y년 n월 j일", strtotime($row[last_update]));
$style1 = "font-family:돋움; font-weight:bold; font-size:9pt; color:#383838;";
$style2 = "font-size:9pt; color:#66AEAD;";
$style3 = "font-family:돋움; font-size:11px; color:#454545;";

?>

 <tr>
  <td><a href='<?=get_blog_url($row[mb_id])?>'><span style='<?=$style1?>'><?=$row[writer]?></span>
       <span style='<?=$style2?>'>[<?=$row[blog_name]?>]</span></a>
       <span style='<?=$style3?>'>(<?=(int)$row[post_count]?>)</span>
  </td>
 </tr>
 <tr>
 <td>
  <span class='small cloudy'><img src='<?=$g4['path']?>/<?=$gb4['blog']?>/img/open.gif' align='absolmiddle' border=0> <?=$newdate?>  </span> 
  <span class='small cloudy'><img src='<?=$g4['path']?>/<?=$gb4['blog']?>/img/update.gif' align='absolmiddle' border=0> <?=$last_update?></span>
 </td>
 </tr>
 <tr>
  <td>
   <table>
    <?
     $current = sql_fetch("select * from {$gb4[blog_table]} where mb_id='$row[mb_id]'");
     $sql2 = " select * from $gb4[post_table] where blog_id=$current[id] $sql_secret order by post_date desc limit 2";
     $result2 = sql_query($sql2);
     for($i=0;$row2=sql_fetch_array($result2);$i++) {
            $sql3 = " select category_name from {$gb4['category_table']} where id = '$row2[category_id]' ";
            $row3 = sql_fetch($sql3);

            if( empty($row3[category_name]) ) $row3[category_name] = '전체';
           //$mmdd = date("m-d", strtotime($row[post_date]));
            $yymmdd = date("y-m-d", strtotime($row2[post_date]));
            echo "";
            echo " <tr><td>
<a href='".get_category_url($row3[category_name], $row2[mb_id])."' class='cloudy small'>[$row3[category_name]]</a> 
<a href='".get_post_url($row[id],$row2[mb_id])."'>{$row2[title]}  <span class='cloudy small'>$yymmdd (Cc:{$row2[comment_count]}, Tc:{$row2[trackback_count]})</span></a></td></tr>";

    }
   ?>

   </table>
  </td>
 </tr>
        <tr><td height=5></td></tr>
        <tr><td height=1 bgcolor=#d2d2d2></td></tr>
        <tr><td height=5></td></tr>
<? } ?>

                </table>
            </td>
        </tr>
        <tr>
            <td><img src='<?=$gb4['blog_path']?>/img/new_blogger_tail.gif' border=0></td>
        </tr>

 

        <tr>
            <td height=25></td>
        </tr>

        </table>
</td>
</tr>
</table>
<?
include_once("$g4[path]/tail2.php");
?>

-------------------------------------------------------------------------