조회순으로 인기 포스트 뽑아봅니다...

헤드풋 경로나 지정은 사용자에 맞게 알아서...

타이틀과 순위(넘버링) 이미지 저장도 알아서...

 

$sql = " select * from {$gb4['post_table']} where secret=1 order by hit desc limit 5 ";

 

에서 뽑아올 갯수를 지정...

 

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

<?
$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]/head.php");
?>

 

<img src='<?=$gb4['blog_path']?>/img/new_blogger3.gif' border=0>
<table width=97% cellpadding=0 cellspacing=0 align=center>
<?
$sql = " select * from {$gb4['post_table']} where secret=1 order by hit desc limit 5 ";
$result = sql_query($sql);
        for($i=0;$row=sql_fetch_array($result);$i++) {
            if ($i>0) {
                echo "<tr><td height=5></td></tr>";
            }

            $sql2 = " select mb_id, writer, blog_name from {$gb4['blog_table']} where id = '$row[blog_id]' ";
            $row2 = sql_fetch($sql2);

            echo "<tr><td height=18><img src='{$g4[path]}/blog/img/rank_{$i}.gif' align='absmiddle'> <span style='font-size:11pt;font-weight:bold;letter-spacing:-1px;'>";
            echo "<a href='".get_post_url($row[id],$row2[mb_id])."'>$row[title]</a>  <span class='small cloudy'>hit ( $row[hit] )</span></td></tr></span>";
            echo "<tr><td height=15 align=center><a href='".get_blog_url($row2[mb_id])."'>  <span class='small cloudy'>[ $row2[blog_name] - $row2[writer]님 Blog ]</span></a></td></tr>";
        }

        if ($i==0) {
            echo "<tr><td height=100>새로 올라온 글이 아직 없습니다.</td></tr>";
        }
        ?>
        <tr><td height=5></td></tr>
        <tr><td height=1 bgcolor=#d2d2d2></td></tr>
        <tr>
            <td><img src='<?=$gb4['blog_path']?>/img/new_blogger_tail.gif' border=0></td>
        </tr>
        </table>

<?
include_once("./_tail2.php");
?>

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