mydb.php

1.增加了近40项后台核心设置

<?php
//获得某个栏目读取文章列表的SQL语句，参数分别为：栏目LID，条数，种类（最新推荐，点击排行等，可为空），是否为index.php特殊栏目（可为空）
function GetSql($lanmuk,$limit,$a='0',$b=''){
         global $lanmuindex,$lanmuindexb,$rootindex,$blid;
         $lanmuindex or (@include R_P."data/cache/lanmu.php");
         if($lanmuindex[$lanmuk][type]==1){
            foreach($lanmuindexb[$lanmuk] as $lanmus){
               // $sql .= "lid='$lanmus' OR "; 不限制，将重复第一个栏目
               if($blid || !@in_array($rootindex['first'],$lanmuindexb[$lanmuk]) || $lanmus != $rootindex['first']){
                  $sql .= "lid='$lanmus' OR ";
               }
            }
            $sql = substr($sql,0,-4);
            $sql && $sql = " AND ($sql)";
         } else $sql = " AND lid='$lanmuk'";
         if($b || !$lanmuk) $sql = "";
         $a == 1 && $sql .= " AND lid!='$rootindex[first]'";
         $a == 2 && $sql .= " AND good='2'";
         $sql = substr($sql,4);
         $sql or $sql="wid!=''";
         if($a != 3){
            $sql = "SELECT wid,name,date,good,lid,visit,comment,color FROM xydw_art WHERE $sql AND xianshi='1' ORDER BY date DESC LIMIT $limit";
         } else $sql = "SELECT wid,name,date,good,lid,visit,comment,color FROM xydw_art WHERE $sql AND xianshi='1' ORDER BY visit DESC LIMIT $limit";
         return $sql;

}



//返回SQL语句所读取的文章列表，参数分别为：SQL语句，是否显示时间，列表前图标（1，!1），连接前缀（主要在于静态HTML文件路径，可为空），标题指定长度截取（可为空，1为不截取，故指定长度必须大于1）
function OutPut($s,$d,$f,$urlp='',$len=''){
         global $ishtml,$imgpath,$lid,$db,$rootindex,$timestamp;
         $newtime = $rootindex['newtime'];$newcolor = $rootindex['newcolor'];
         $query = $db->query($s);
         $urlp ? $urlp = '../../..' : $urlp = '.';
         while($row = $db->fetch_array($query)){
             $d && $date= "<span class=date>".date("m-d",$row['date'])."</span>";
             $title = $row['name']."\n日期:".date("Y年m月d日",$row['date'])."";
             if($f == 1){
                $img = "<img src='$urlp/images/$imgpath/i5.gif' border=0>";
                $len or $row['name']=xsubstr($row['name'],$rootindex['rightlen']);
             } else {
                $img = "<img src='$urlp/images/$imgpath/i6.gif' border=0>";
                $len or $row['name']=xsubstr($row['name'],$rootindex['leftlen']);
             }
             $len && $len = (int)$len;
             if($len > 1){
                $row['name'] = xsubstr($row['name'],$len);
             }
             if($date){
                $timestamp-$row['date']<60*60*$newtime && $date = "<font color='$newcolor'>$date</font>";
                $date = "<td align=right width=50px>$date </td>";
                $td .= "<tr><td align=left>";
             } else $td .= "<tr><td align=left>";
             $row['good'] == 2 ? $good = "<img src='$urlp/images/$imgpath/good.gif' alt='推荐' border=0>" : $good = "";
             $hdate = date('ym',$row['date']);
             $row['color'] &&  $row['name'] = "<font color=".$row['color'].">".$row['name']."</font>";
             if($ishtml && file_exists("./html_data/".$row['lid']."/".$hdate."/".$row['wid'].".htm")){
                $tdlink = $urlp."/html_data/".$row['lid']."/".$hdate."/".$row['wid'].".htm";
             } else $tdlink = $urlp."/read.php?wid=".$row['wid'];
             $td .= "$img<a href='$tdlink' title='$title'>".$row['name']."</a>$good</td>$date</tr>\n";
         }
         $td = "<table width=100% border='0' cellspacing='0px' cellpadding='0px'>\n$td\n</table>";
         return $td;
}

//调用某个栏目最新图片，参数分别为LID，标题长度限制（可为空）。注意返回值为数组：n（文章标题）,url（文章路径），img(图片路径）
function GetImg($lanmuk,$len=""){
         global $lanmuindex,$lanmuindexb,$ishtml,$imgpath,$lid,$db,$rootindex,$timestamp;
         if($lanmuindex[$lanmuk][type]==1){
            foreach($lanmuindexb[$lanmuk] as $lanmus){
               $sql .= "lid='$lanmus' OR ";
            }
            $sql = substr($sql,0,-4);
            $sql && $sql = " AND ($sql)";
         } else $sql = " AND lid='$lanmuk'";
         if(!$lanmuk) $sql = "";
         $img = $db->getone("SELECT wid,lid,name,date,newsurl FROM xydw_art WHERE newsurl!='' $sql ORDER BY date DESC LIMIT 1");
         if($len) $img['name'] = xsubstr($img['name'],$len);
         $url = "./htmldata/".$img['lid']."/".date('ym',$img['date'])."/".$img['wid'].".htm";
         if(!$ishtml || !file_exists($url)) $url = "read.php?wid=".$img['wid'];
         $arr = array("n" => "$img[name]","url" => "$url","img" => "$img[newsurl]");
         return $arr;

}
?>