<?
include("../include/mysql_func.php");
include("../include/comm_func.php");
include("../include/constants.php");
include("../include/bbcode.php");
?>
<?
//print_r($_POST);
//phpinfo();
$title = "newstarnet index page";
$right_field_width = 240;

$conn = connect_database($NEWS_DB);

$settings = get_query_row($conn, "select * from layout_setting" );

//$timestamp = strtotime( substr($news_list[$i][update_date],0,8) );
/*
$where = "";
if( !empty($_POST[start_date]) ) { $start_date =strtotime( $_POST[start_date] ); $where .= " and news_art_post_time >=$start_date "; }
if( !empty($_POST[end_date]  ) ) { $end_date   =strtotime( $_POST[end_date] );   $where .= " and news_art_post_time <=$end_date "; }
$sql = "select * from $NEWS_ARTICLES_TABLE where news_art_status=4 $where  order by news_art_id desc limit 100";
$news_list = get_query_list($conn, $sql);
for($i=0; $i<sizeof($news_list); $i++)
    if( strlen($news_list[$i][news_art_title]) > 42 ) $news_list[$i][news_art_title] = substr($news_list[$i][news_art_title], 0, 40) . "...";
*/
$sql = "select * from news_website_categories where news_center_id=0 and status=1 order by news_cat_order";
$news_center_column_list = get_query_list($conn, $sql);
for($i=0; $i<sizeof($news_center_column_list); $i++)
{
    $limit = 10;
    if($i<2) $limit = 15;
//    $sql = "select * from $NEWS_ARTICLES_TABLE where news_art_status=4 and news_art_type_id=1 ".
//            " and news_website_cat_id=" . $news_center_column_list[$i][news_cat_id] . " order by news_art_post_time desc, news_art_id desc limit $limit";
    $sql = "select * from $NEWS_ARTICLES_TABLE where news_art_status=4 and news_art_type_id=1 ".
            " and news_website_cat_id=" . $news_center_column_list[$i][news_cat_id] . " order by news_art_id desc limit $limit";
    $news_list[$i] = get_query_list($conn, $sql);
}

/************************
*   top_fixed picture   *
************************/
/*
$sql = "select * from $NEWS_ARTICLES_TABLE where news_art_status=4 and top_fixed_1>0 and news_art_type_id=2 order by news_art_post_time desc limit 1";
$top_fixed_1_news_pic_list = get_query_list($conn, $sql);
for($i=0; $i<sizeof($top_fixed_1_news_pic_list); $i++)
    if( strlen($top_fixed_1_news_pic_list[$i][news_art_title]) > 38 ) $top_fixed_1_news_pic_list[$i][news_art_title] = substr($top_fixed_1_news_pic_list[$i][news_art_title], 0, 38);
$pic_path = "../../news_pictures/" . $top_fixed_1_news_pic_list[0][news_art_id]%100 . "/" . $top_fixed_1_news_pic_list[0][news_art_id];
if ( $handle = @opendir($pic_path) )
{
    while( false !== ( $file = readdir($handle) ) ) if(substr($file, 0, 1) == "1") break;
    closedir($handle); 
}
$top_fixed_1_news_pic_list[0][pic] = $pic_path . "/" . $file;
if( !is_file($top_fixed_1_news_pic_list[0][pic]) ) $top_fixed_1_news_pic_list[0][pic] = "../images/no_pic.gif";
    if( strlen($top_fixed_1_news_pic_list[0][news_art_text]) > 150 ) $top_fixed_1_news_pic_list[0][news_art_text] = substr($top_fixed_1_news_pic_list[0][news_art_text], 0, 148) . "...";
*/
//置顶文章
/*
$sql = "select * from $NEWS_ARTICLES_TABLE where news_art_status=4 and top_fixed_1>0 and news_art_type_id=1 order by news_art_post_time desc limit 1";
$top_fixed_1_news_list = get_query_list($conn, $sql);
for($i=0; $i<sizeof($top_fixed_1_news_list); $i++)
    if( strlen($top_fixed_1_news_list[$i][news_art_title]) > 38 ) $top_fixed_1_news_list[$i][news_art_title] = substr($top_fixed_1_news_list[$i][news_art_title], 0, 38);
*/
//置顶图片
$sql = "select * from $NEWS_ARTICLES_TABLE where news_art_status=4 and top_fixed_1>0 and news_art_type_id=2 order by news_art_post_time desc limit 1";
$top_fixed_1_news_pic_list = get_query_list($conn, $sql);
for($i=0; $i<sizeof($top_fixed_1_news_pic_list); $i++)
    if( strlen($top_fixed_1_news_pic_list[$i][news_art_title]) > 38 ) $top_fixed_1_news_pic_list[$i][news_art_title] = substr($top_fixed_1_news_pic_list[$i][news_art_title], 0, 38);
$pic_path = "../../news_pictures/" . $top_fixed_1_news_pic_list[0][news_art_id]%100 . "/" . $top_fixed_1_news_pic_list[0][news_art_id];
if ( $handle = @opendir($pic_path) )
{
    while( false !== ( $file = readdir($handle) ) ) if(substr($file, 0, 1) == "1") break;
    closedir($handle); 
}
$top_fixed_1_news_pic_list[0][pic] = $pic_path . "/" . $file;
if( !is_file($top_fixed_1_news_pic_list[0][pic]) ) $top_fixed_1_news_pic_list[0][pic] = "../images/no_pic.gif";
    if( strlen($top_fixed_1_news_pic_list[0][news_art_text]) > 150 ) $top_fixed_1_news_pic_list[0][news_art_text] = substr($top_fixed_1_news_pic_list[0][news_art_text], 0, 148) . "...";

//图片短讯
$sql = "select * from $NEWS_ARTICLES_TABLE where news_art_status=4 and news_art_type_id=2 order by news_art_post_time desc limit 10";
$news_picture_short_list = get_query_list($conn, $sql);
for($i=0; $i<sizeof($news_picture_short_list); $i++)
{
    if( strlen($news_picture_short_list[$i][news_art_title]) > 38 ) $news_picture_short_list[$i][news_art_title] = substr($news_picture_short_list[$i][news_art_title], 0, 38);
    $pic_path = "../../news_pictures/" . $news_picture_short_list[$i][news_art_id]%100 . "/" . $news_picture_short_list[$i][news_art_id];
    if ( $handle = @opendir($pic_path) )
    {
        while( false !== ( $file = readdir($handle) ) ) if(substr($file, 0, 7) == "thumb_1") break;
        closedir($handle);
    }
    if ( (substr($file, 0, 7) != "thumb_1") && ($handle = @opendir($pic_path)) )
    {
        while( false !== ( $file = readdir($handle) ) ) if(substr($file, 0, 1) == "1") break;
        closedir($handle);
    }

    $news_picture_short_list[$i][pic] = $pic_path . "/" . $file;
    if( !is_file($news_picture_short_list[$i][pic]) ) $news_picture_short_list[$i][pic] = "../images/no_pic.gif";
        if( strlen($news_picture_short_list[$i][news_art_text]) > 120 ) $news_picture_short_list[$i][news_art_text] = substr($news_picture_short_list[$i][news_art_text], 0, 118) . "...";
}

//视频新闻
$sql = "select * from $NEWS_ARTICLES_TABLE where news_art_status=4 and news_art_type_id=3 order by news_art_post_time desc limit 10";
$news_video_list = get_query_list($conn, $sql);
for($i=0; $i<sizeof($news_video_list); $i++)
{
//    if( strlen($news_video_list[$i][news_art_title]) > 38 ) $news_video_list[$i][news_art_title] = substr($news_video_list[$i][news_art_title], 0, 38);
}

//置顶文章
/***************************
*   top_fixed text news    *
***************************/
$sql = "select * from $NEWS_ARTICLES_TABLE where news_art_status=4 and top_fixed_1>0 and news_art_type_id=1 order by news_art_post_time desc limit 1";
$top_fixed_1_news_text_list = get_query_list($conn, $sql);
if( strlen($top_fixed_1_news_text_list[0][news_art_text]) > 600 ) $top_fixed_1_news_text_list[0][news_art_text] = substr($top_fixed_1_news_text_list[0][news_art_text], 0, 598) . "...";

$orig_word = array();
$replacement_word = array();
$bbcode_uid = $news[bbcode_uid];
$preview_message = stripslashes(prepare_message($top_fixed_1_news_text_list[0][news_art_text], 1, 1, 1, $bbcode_uid));
$preview_message = bbencode_second_pass($preview_message, $bbcode_uid);

if( !empty($orig_word) )
{
    $preview_username = ( !empty($username) ) ? preg_replace($orig_word, $replacement_word, $preview_username) : "";
    $preview_subject = ( !empty($preview_subject) ) ? preg_replace($orig_word, $replacement_word, $preview_subject) : "";
    $preview_subhead = ( !empty($preview_subhead) ) ? preg_replace($orig_word, $replacement_word, $preview_subhead) : "";
    $preview_author = ( !empty($preview_author) ) ? preg_replace($orig_word, $replacement_word, $preview_author) : "";
    $preview_source = ( !empty($preview_source) ) ? preg_replace($orig_word, $replacement_word, $preview_source) : "";
    $preview_message = ( !empty($preview_message) ) ? preg_replace($orig_word, $replacement_word, $preview_message) : "";
    $preview_note = ( !empty($preview_note) ) ? preg_replace($orig_word, $replacement_word, $preview_note) : "";
}

$top_fixed_1_news_text_list[0][news_art_text] = make_clickable($preview_message);

?>
<? include("header.php"); ?> 
<? include("ad.php"); ?>
<script language="JavaScript" src="../js/ckDate.js"></script>

<td valign="top"  bgcolor="#ffffff" align="center">

<!--first news-->
<table width="695" cellspacing="2" cellpadding="2" border="0" align="center">
<tr>
<td align="left" valign="top" width="250">
    <a class=emaintextlink href="../web/view_detail.php?news_art_id=<?= $top_fixed_1_news_pic_list[0][news_art_id]?>" target="_blank" >
        <img src="<?= $top_fixed_1_news_pic_list[0][pic]?>" width="300" border="1"></a></td>
<td align="left" valign="top" width="10"><img src=" width="10" height="0"></td>
<td align="left" valign="top" width="100%"><br>
    <a class="etitletextlink" href="view_detail.php?news_art_id=<?= $top_fixed_1_news_text_list[0][news_art_id]?>" target="_balnk"><?= $top_fixed_1_news_text_list[0][news_art_title]?>
    <P><a class="emaintextlink" href="view_detail.php?news_art_id=<?= $top_fixed_1_news_text_list[0][news_art_id]?>" target="_balnk"><?= $top_fixed_1_news_text_list[0][news_art_text]?></font></a>
    <p align="right"><a class="emaintextlink" href="view_detail.php?news_art_id=<?= $top_fixed_1_news_text_list[0][news_art_id]?>" target="_balnk">详细内容&gt;&gt;</a></p>
    	 
	</td>
  </tr>
</table>
<!-- first news end-->

<!--photo news and list news-->
<table width="695" cellpadding="2" cellspacing="0" border="0" align="center">

<tr>
<td valign="top">
    <table width="450" cellpadding="2" cellspacing="0" border="0" align="center">
<?  for($i=0; $i<sizeof($news_center_column_list); $i++)
    {
        echo "<tr><td height='40' valign='bottom' colspan='4'><b><a href='../web/news_web_category.php?id=" . 
            $news_center_column_list[$i][news_cat_id] . "' target='_blank'>" . $news_center_column_list[$i][news_cat_title] . "</a></b></td>";
        for($j=0; $j<sizeof($news_list[$i]); $j++)
        {
            $news_list[$i][$j][news_art_post_date] = date("Y年m月d日", $news_list[$i][$j][news_art_post_time]);
            $news_list[$i][$j][post_date] = Date("Y-M-d", $news_list[$i][$j][news_art_post_time]);
            ?>
            <tr>
    		<td width="1%" valign="top"><img src="../images/icon1.gif" > </td>
    		<td width="100%" valign="top">
    		    <a href="view_detail.php?news_art_id=<?= $news_list[$i][$j][news_art_id] ?>" class="emaintextlink" target="_blank"><?= $news_list[$i][$j][news_art_title] ?></a>
    			<span class="gensmall"><span class="smallfont">[<?= $news_list[$i][$j][news_art_post_date] ?>] </td>
<!--
    		    <a href="view_detail.php?news_art_id=<?= $news_list[$i][$j][news_art_id] ?>" class="emaintextlink" target="_blank"><?= $news_list[$i][$j][news_art_title] ?></a>
    			<span class="gensmall"><span class="smallfont">[<?= $news_list[$i][$j][news_art_post_date] ?>](<?= $news_list[$i][$j][news_art_views] ?>) </td>
-->
    		</tr>
<?      }
    }   ?>
    </table>
</td>

<td valign="top">
    <table border="0" bordercolorlight="#C6C7C6" cellspacing="0" cellpadding="0" bordercolordark="#FFFAFF" width="<?= $right_field_width?>" height="30" background="../images/gray_bg.gif" bgcolor="#7788AA">
        <tr>
        <td width="300" valign="middle" bgcolor="#7788AA" height="30"><a href="../web/news_web_category.php"><font class=ewhitetext>&nbsp;:: 按分类浏览 ::  GO>></font></a></td>
        </tr>
    </table>
<br>

        <form name="myform" action="news_search.php" method="post" encType="multipart/form-data" OnSubmit="">
        <input type="hidden" name="operation"    value="">
        <table border="0" bordercolorlight="#C6C7C6" cellspacing="0" cellpadding="0" bordercolordark="#FFFAFF" width="<?= $right_field_width?>" height="100" background="../images/gray_bg.gif" bgcolor="#7788AA">

        <tr>
        <td width="300" valign="middle" bgcolor="#7788AA" height="30"><font class=ewhitetext>&nbsp;:: 按关键字搜索新闻 ::</font></td>
        </tr>

        <tr>
        <td align="center" nowrap><b>&nbsp;关键字词: </b><input class="bginput" type="text" name="key_words" value="<?= $_POST[start_date] ?>" size="30">
        </tr>

        <tr>
        <td align="center" nowrap>
            <input class="input_01" type="submit" name="view_by_date"  value="搜索新闻"  onclick="javascript:f_by_date('view') ">
        </tr>
        </table>

<!--
        <form name="myform" action="news_center.php" method="post" encType="multipart/form-data" OnSubmit="">
        <input type="hidden" name="operation"    value="">
        <table border="0" bordercolorlight="#C6C7C6" cellspacing="0" cellpadding="0" bordercolordark="#FFFAFF" width="<?= $right_field_width?>" height="120" background="../images/gray_bg.gif" bgcolor="#7788AA">

        <tr>
        <td width="300" valign="middle" bgcolor="#7788AA" height="30"><font class=ewhitetext>&nbsp;:: 按日期浏览 :: (YYYY-MM-DD)</font></td>
        </tr>

        <tr>
        <td align="center" nowrap><b>&nbsp;起始日期</b>: <input class="bginput" type="text" name="start_date" value="<?= $_POST[start_date] ?>" size="10">
            <a href="javascript:show_calendar('myform.start_date');" onmouseover="window.status='Date Picker';return true;" onmouseout="window.status=' ';return true;"><img src="../images/calendar.gif" border="0"></a></td>
        </tr>
        <tr>
        <td align="center" nowrap><b>&nbsp;截止日期</b>: <input class="bginput" type="text" name="end_date"   value="<?= $_POST[  end_date] ?>" size="10">
            <a href="javascript:show_calendar('myform.end_date');"   onmouseover="window.status='Date Picker';return true;" onmouseout="window.status=' ';return true;"><img src="../images/calendar.gif" border="0"></a></td>
        </tr>
        <tr>
        <td align="center" nowrap>
            <input class="input_01" type="submit" name="view_by_date"  value="GO"  onclick="javascript:f_by_date('view') ">
        </tr>
        </table>
-->
<br>
    <!-- video news-->
    <table border="0" bordercolorlight="#C6C7C6" cellspacing="0" cellpadding="0" bordercolordark="#FFFAFF" width="<?= $right_field_width?>" height="120" background="../images/gray_bg.gif">
        <tr height="1"><td bgcolor="#C6C7C6" colspan="3"><img src="../images/spacer.gif" height="1" width="0"></td></tr>

        <tr height="20">
        <td width="1" bgcolor="#C6C7C6"></td>
        <td width="300" valign="middle" bgcolor="#7788AA"><a href="news_movie.php"><font class=ewhitetext>&nbsp;:: 视频新闻 ::</font></a></td>
        <td width="0" bgcolor="#C6C7C6"><img src="../images/spacer.gif" height="1" width="0"></td>
        </tr>

        <tr>
        <td width="1" bgcolor="#C6C7C6"></td>
        <td valign="top" align="center">
            <table border="0" bordercolorlight="#C6C7C6" cellspacing="0" cellpadding="5" bordercolordark="#FFFAFF" width="90%" height="90%">
<?      for($i=0; $i<sizeof($news_video_list); $i++)
        {   ?>
                <tr>
                <td valign="top"><a href="view_detail.php?news_art_id=<?= $news_video_list[$i][news_art_id] ?>" target="_blank"><?= $news_video_list[$i][news_art_title]?></a></td>
                </tr>
<?      }   ?>
            </table>
        <td width="0" bgcolor="#C6C7C6"><img src="../images/spacer.gif" height="1" width="0"></td>
        </tr>
        <tr height="1"><td bgcolor="#C6C7C6" colspan="3"><img src="../images/spacer.gif" height="1" width="0"></td></tr>
    </table>
    <!--video news end-->  
<br>
    <!-- photo news-->
    <table border="0" bordercolorlight="#C6C7C6" cellspacing="0" cellpadding="0" bordercolordark="#FFFAFF" width="<?= $right_field_width?>" height="120" background="../images/gray_bg.gif">
        <tr height="1"><td bgcolor="#C6C7C6" colspan="3"><img src="../images/spacer.gif" height="1" width="0"></td></tr>

        <tr height="20">
        <td width="1" bgcolor="#C6C7C6"></td>
        <td width="300" valign="middle" bgcolor="#7788AA"><a href="news_picture.php"><font class=ewhitetext>&nbsp;:: 图片短讯 ::</font></a></td>
        <td width="0" bgcolor="#C6C7C6"><img src="../images/spacer.gif" height="1" width="0"></td>
        </tr>

        <tr>
        <td width="1" bgcolor="#C6C7C6"></td>
        <td valign="top" align="center">
            <table border="0" bordercolorlight="#C6C7C6" cellspacing="0" cellpadding="5" bordercolordark="#FFFAFF" width="90%" height="90%">
<?      for($i=0; $i<sizeof($news_picture_short_list); $i++)
        {   ?>
                <tr>
                <td valign="top"><a href="view_detail.php?news_art_id=<?= $news_picture_short_list[$i][news_art_id] ?>" target="_blank"><img src="<?= $news_picture_short_list[$i][pic] ?>" width="80" height="80" border="1"></a></td>
                <td valign="top"><a href="view_detail.php?news_art_id=<?= $news_picture_short_list[$i][news_art_id] ?>" target="_blank"><?= $news_picture_short_list[$i][news_art_text]?></a></td>
                </tr>
<?      }   ?>
            </table>
        <td width="0" bgcolor="#C6C7C6"><img src="../images/spacer.gif" height="1" width="0"></td>
        </tr>
        <tr height="1"><td bgcolor="#C6C7C6" colspan="3"><img src="../images/spacer.gif" height="1" width="0"></td></tr>
    </table>
    <!--photo news end-->  
<br>
    </td>
    </tr>
</table>
 
<!--list news end-->

</td>

<? include("menu.php"); ?>

<?// include("ad.php"); ?>
<? include("footer.php"); ?>