修改wp cms主题green-island

<li <?php if(is_home()) { echo ' class="current_page_item"'; } ?>><a href="<?php bloginfo('siteurl'); ?>">Home</a></li>

<li><a href="http://bbs.fengyeting.cn/" target="_BLANK">论坛</a></li>
<li><?php wp_list_categories('show_count=1&title_li=&show_count=0'); ?></li>

    <div id="sidebar">

    <div id="sidebar_main">
       
        <?php if(function_exists(dynamic_sidebar))
               dynamic_sidebar();
        ?>
<?php
require_once('D:\htdocs\wordpress\wp-load.php');   //wp-load.php文件,路径自己根据具体情况改
$bbsURL='http://127.0.0.1/dz7/bbs/';    //论坛URL路径自己根据具体情况改
$dateformat='Y-m-d';
$timeformat='h:m:s';
$timeoffset=8;
$dztablepre='cdb_';    //discuz论坛表前缀
global $wpdb;
       
       
/////////////////////////////////////////////////////////////
function gbk2utf8($str)
{
    if(function_exists(iconv))
{
$str=iconv("GBK", "UTF-8",$str);
}
else if(function_exists(mb_convert_encoding))
{
$str=mb_convert_encoding($str,"UTF-8","GBK");  //GBK 编码的转成UTF-8编码
}
else
{
echo "<script>alert('您的服务器不支持相应的的函数（iconv，mb_convert_encoding等），程序不行继续运行~！');</scritp>";
}
return $str;
}



function cutstr($string, $length, $dot = ' ...') {
    global $charset;

    if(strlen($string) <= $length) {
        return $string;
    }

    $string = str_replace(array('&amp;', '&quot;', '&lt;', '&gt;'), array('&', '"', '<', '>'), $string);

    $strcut = '';
    if(strtolower($charset) == 'utf-8') {

        $n = $tn = $noc = 0;
        while($n < strlen($string)) {

            $t = ord($string[$n]);
            if($t == 9 || $t == 10 || (32 <= $t && $t <= 126)) {
                $tn = 1; $n++; $noc++;
            } elseif(194 <= $t && $t <= 223) {
                $tn = 2; $n += 2; $noc += 2;
            } elseif(224 <= $t && $t <= 239) {
                $tn = 3; $n += 3; $noc += 2;
            } elseif(240 <= $t && $t <= 247) {
                $tn = 4; $n += 4; $noc += 2;
            } elseif(248 <= $t && $t <= 251) {
                $tn = 5; $n += 5; $noc += 2;
            } elseif($t == 252 || $t == 253) {
                $tn = 6; $n += 6; $noc += 2;
            } else {
                $n++;
            }

            if($noc >= $length) {
                break;
            }

        }
        if($noc > $length) {
            $n -= $tn;
        }

        $strcut = substr($string, 0, $n);

    } else {
        for($i = 0; $i < $length; $i++) {
            $strcut .= ord($string[$i]) > 127 ? $string[$i].$string[++$i] : $string[$i];
        }
    }

    $strcut = str_replace(array('&', '"', '<', '>'), array('&amp;', '&quot;', '&lt;', '&gt;'), $strcut);

    return $strcut.$dot;
}

//////////////////////////////////////////////////////////////////////////////////////////////////
//新贴
        $colorarray = array('', 'red', 'orange', 'yellow', 'green', 'cyan', 'blue', 'purple', 'gray');
$hack_cut_str = 26; //标题字数
$hack_cut_strauthor = 9;
$new_post_threadlist = array();
$nthread = array();

    //  $query=$wpdb->query("SELECT t.*, f.name FROM {$dztablepre}threads t, {$dztablepre}forums f WHERE  f.fid=t.fid AND t.displayorder not in (-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10");
    $wpdb->query("SET NAMES 'gbk'");
        $query="SELECT t.*, f.name FROM {$dztablepre}threads t, {$dztablepre}forums f WHERE  f.fid=t.fid AND t.displayorder not in (-1,-2) ORDER BY t.dateline DESC LIMIT 0, 10";
if($nthread = $wpdb->get_results($query,ARRAY_A)) {
         //print_r($nthread);die();
            foreach($nthread as $key =>$data)
{
    if($data['tid'])
    {
        //$nthread[$key]['tid']=$data['tid'];
        $nthread[$key]['forumname'] = gbk2utf8(ereg_replace('<[^>]*>','',$data['name']));
        $nthread[$key]['subject']=gbk2utf8($data['subject']);
        $nthread[$key]['view_subject'] = gbk2utf8(cutstr($data['subject'],$hack_cut_str));
        $nthread[$key]['author'] =gbk2utf8($data['author']);
        $nthread[$key]['view_author'] = gbk2utf8(cutstr($data['author'],$hack_cut_strauthor));
        $nthread[$key]['view_lastposter']=gbk2utf8(cutstr($data['lastposter'],$hack_cut_strauthor));
        $nthread[$key]['lastreplytime']= gmdate("$dateformat $timeformat", $data['lastpost'] + ($timeoffset * 3600));
        if($nthread[$key]['highlight']) {
                $string = sprintf('%02d', $data['highlight']);
                $stylestr = sprintf('%03b', $string[0]);
                $nthread[$key]['highlight'] = 'style="';
                $nthread[$key]['highlight'] .= $stylestr[0] ? 'font-weight: bold;' : '';
                $nthread[$key]['highlight'] .= $stylestr[1] ? 'font-style: italic;' : '';
                $nthread[$key]['highlight'] .= $stylestr[2] ? 'text-decoration: underline;' : '';
                $nthread[$key]['highlight'] .= $string[1] ? 'color: '.$colorarray[$string[1]] : '';
                $nthread[$key]['highlight'] .= '"';
        } else {
                $nthread[$key]['highlight'] = '';
        }
        //$new_post_threadlist =&$nthread;


       }
            }
           

    }

//print_r($new_post_threadlist);die();

//新回复
$hack_cut_str = 26; //标题字数
$hack_cut_strauthor = 9;
$new_reply_threadlist = array();
$rthread = array();
$query="SELECT t.*, f.name FROM {$dztablepre}threads t, {$dztablepre}forums f WHERE  f.fid=t.fid AND t.displayorder not in (-1,-2) AND t.closed NOT LIKE 'moved|%' AND t.replies !=0 ORDER BY t.lastpost DESC LIMIT 0, 10";
if($rthread = $wpdb->get_results($query,ARRAY_A)) {
        foreach($rthread as $key =>$data)
{
        if($data['tid'])
    {
        $rthread[$key]['forumname'] =gbk2utf8( ereg_replace('<[^>]*>','',$data['name']));
        $rthread[$key]['view_subject'] =gbk2utf8( cutstr($data['subject'],$hack_cut_str));
        $rthread[$key]['subject']=gbk2utf8($data['subject']);
        $nthread[$key]['author'] =gbk2utf8($data['author']);
        $rthread[$key]['view_author'] = gbk2utf8(cutstr($data['author'],$hack_cut_strauthor));
        $rthread[$key]['view_lastposter'] = gbk2utf8(cutstr($data['lastposter'],$hack_cut_strauthor));
          $rthread[$key]['date']= gmdate("$dateformat $timeformat", $data['dateline'] + $timeoffset * 3600);
        $rthread[$key]['lastreplytime']= gmdate("$dateformat $timeformat", $data['lastpost'] + ($timeoffset * 3600));
        if($data['highlight']) {
                $string = sprintf('%02d', $data['highlight']);
                $stylestr = sprintf('%03b', $string[0]);
                $rthread[$key]['highlight'] = 'style="';
                $rthread[$key]['highlight'] .= $stylestr[0] ? 'font-weight: bold;' : '';
                $rthread[$key]['highlight'] .= $stylestr[1] ? 'font-style: italic;' : '';
                $rthread[$key]['highlight'] .= $stylestr[2] ? 'text-decoration: underline;' : '';
                $rthread[$key]['highlight'] .= $string[1] ? 'color: '.$colorarray[$string[1]] : '';
                $rthread[$key]['highlight'] .= '"';
        } else {
                $rthread[$key]['highlight'] = '';
        }
        $new_reply_threadlist[] = $rthread;
}
        }
    }


//热帖
$hack_cut_str = 26; //标题字数
$hack_cut_strauthor = 9;
$new_hot_threadlist = array();
$mthread = array();
$query ="SELECT t.*, f.name FROM {$dztablepre}threads t, {$dztablepre}forums f WHERE  f.fid=t.fid  AND t.closed NOT LIKE 'moved|%' AND t.replies !=0 AND f.fid not in (0) AND t.displayorder not in (-1,-2) ORDER BY t.replies DESC LIMIT 0, 10";
if($mthread = $wpdb->get_results($query,ARRAY_A)) {
   
    foreach($mthread as $key =>$data)
{
        if($data['tid'])
    {
        $mthread[$key]['forumname'] = gbk2utf8(ereg_replace('<[^>]*>','',$data['name']));
        $mthread[$key]['view_subject'] =gbk2utf8(cutstr($data['subject'],$hack_cut_str));
         $mthread[$key]['subject']=gbk2utf8($data['subject']);
         $mthread[$key]['author'] =gbk2utf8($data['author']);
          $mthread[$key]['view_author'] =gbk2utf8(cutstr($data['author'],$hack_cut_strauthor));
        $mthread[$key]['view_lastposter'] = gbk2utf8(cutstr($data['lastposter'],$hack_cut_strauthor));
  $mthread[$key]['date']= gmdate("$dateformat $timeformat", $data['dateline'] + $timeoffset * 3600);
        $mthread[$key]['lastreplytime']= gmdate("$dateformat $timeformat", $data['lastpost'] + ($timeoffset * 3600));
        if($data['highlight']) {
                $string = sprintf('%02d', $data['highlight']);
                $stylestr = sprintf('%03b', $string[0]);
                $mthread[$key]['highlight'] = 'style="';
                $mthread[$key]['highlight'] .= $stylestr[0] ? 'font-weight: bold;' : '';
                $mthread[$key]['highlight'] .= $stylestr[1] ? 'font-style: italic;' : '';
                $mthread[$key]['highlight'] .= $stylestr[2] ? 'text-decoration: underline;' : '';
                $mthread[$key]['highlight'] .= $string[1] ? 'color: '.$colorarray[$string[1]] : '';
                $mthread[$key]['highlight'] .= '"';
        } else {
                $mthread[$key]['highlight'] = '';
        }
       
        $new_hot_threadlist[] = $mthread;
}
}

}
//print_r($mthread);die();

//print_r($nthread);die();

?>
<div class="sidebox">
<h2>最新帖子</h2>
<ul>
<?php   foreach($nthread as $key =>$data)
{
echo "<li><a href=\"{$bbsURL}viewthread.php?tid={$data['tid']} {$data['highlight']}\"
     target=\"_blank\"      title=\"最新帖子 所在论坛: {$data['forumname']} 主题标题: {$data['subject']} ~By {$data['view_author']}  发表时间: {$data['date']} 浏览次数: {$data['views']}次\"; >{$data['view_subject']}</a></li>";
}
?>
</ul>
</div>


<div class="sidebox">
<h2>最新回复</h2>
<ul>
<?php   foreach($rthread as $key =>$data)
{
echo "<li><a href=\"{$bbsURL}viewthread.php?tid={$data['tid']} {$data['highlight']}\"
     target=\"_blank\"      title=\"帖子 所在论坛: {$data['forumname']} 主题标题: {$data['subject']} ~By {$data['view_author']} 发表时间: {$data['date']} 浏览次数: {$data['views']}次 由[{$data['view_lastposter']}]于{$data['lastreplytime']} 最后回复\"; >{$data['view_subject']}</a></li>";
}
?>
</ul>
</div>
       
       
   
<div class="sidebox">
<h2>热门帖子</h2>
<ul>
<?php   foreach($mthread as $key =>$data)
{
echo "<li><a href=\"{$bbsURL}viewthread.php?tid={$data['tid']} {$data['highlight']}\"
     target=\"_blank\"      title=\"最新帖子 所在论坛: {$data['forumname']} 主题标题: {$data['subject']} ~By {$data['view_author']} 发表时间: {$data['date']} 浏览次数: {$data['views']}次 由[{$data['view_lastposter']}]于{$data['lastreplytime']} 最后回复\"; >{$data['view_subject']}</a></li>";
}
?>
</ul>
</div>
   
                <div class="clear"></div>
   
    </div>
   
    <div id="sidebar_bottom"></div>
    </div>