Ejemplo n.º 1
0
 function create_poll()
 {
     global $msql;
     $logging = $_POST["logging"];
     $expire = $_POST["expire"];
     $day = $_POST["day"];
     $status = $_POST["status"];
     $groupname = $_POST["groupname"];
     $timestamp = time();
     if (!isset($expire)) {
         $expire = 0;
     }
     if (!isset($day)) {
         $day = $timestamp;
     } else {
         $exp_time = $timestamp + $day * 86400;
     }
     if (!get_magic_quotes_gpc()) {
         $groupname = addslashes($groupname);
     }
     $msql->query(" INSERT INTO {P}_tools_photopollindex set\r\n\t\t\tcatpath='{$catpath}',\r\n\t\t\tcat='{$groupname}',\r\n\t\t    groupname='{$groupname}',\r\n\t\t    timestamp='{$timestamp}',\r\n\t\t    status='{$status}',\r\n\t\t    exp_time='{$exp_time}',\r\n\t\t    expire='{$expire}'\r\n\t\t");
     $nowcatid = $msql->instid();
     $nowpath = fmpath($nowcatid);
     $catpath = $nowpath . ":";
     $msql->query("update {P}_tools_photopollindex set catpath='{$catpath}' where id='{$nowcatid}'");
 }
Ejemplo n.º 2
0
function PhotoFabu()
{
    global $msql, $fsql, $tsql;
    $coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $memberid = $_COOKIE["MEMBERID"];
    $memberid = htmlspecialchars($memberid);
    //个人分类
    $fsql->query("select * from {P}_photo_pcat where memberid='{$memberid}' order by xuhao");
    while ($fsql->next_record()) {
        $pcatid = $fsql->f("catid");
        $pcat = $fsql->f("cat");
        $pcatlist .= "<option value='" . $pcatid . "'>" . $pcat . "</option>";
    }
    //获取公共分类授权
    $secureset = SecureClass("156");
    //公共分类
    $fsql->query("select * from {P}_photo_cat order by catpath");
    while ($fsql->next_record()) {
        $lpid = $fsql->f("pid");
        $lcatid = $fsql->f("catid");
        $cat = $fsql->f("cat");
        $catpath = $fsql->f("catpath");
        $lcatpath = explode(":", $catpath);
        //当主分类有授权时读取下级分类
        if (strstr($secureset, ":" . intval($lcatpath[0]) . ":")) {
            for ($i = 0; $i < sizeof($lcatpath) - 2; $i++) {
                $lcatpath[$i] = intval($lcatpath[$i]);
                $tsql->query("select catid,cat from {P}_photo_cat where catid='{$lcatpath[$i]}'");
                if ($tsql->next_record()) {
                    $ncatid = $tsql->f('cat');
                    $ncat = $tsql->f('cat');
                    $ppcat .= $ncat . "/";
                }
            }
            if ($pid == $lcatid) {
                $catlist .= "<option value='" . $lcatid . "' selected>" . $ppcat . $cat . "</option>";
            } else {
                $catlist .= "<option value='" . $lcatid . "'>" . $ppcat . $cat . "</option>";
            }
            $ppcat = "";
        }
    }
    //专题
    $fsql->query("select * from {P}_photo_proj order by id desc");
    while ($fsql->next_record()) {
        $projid = $fsql->f("id");
        $project = $fsql->f("project");
        $NowPath = fmpath($projid);
        $musellist .= "<option value=" . $NowPath . ">" . $project . "</option>";
    }
    //模版解释
    $Temp = LoadTemp($tempname);
    $var = array('pname' => $_COOKIE["MEMBERPNAME"], 'catlist' => $catlist, 'pcatlist' => $pcatlist, 'musellist' => $musellist);
    $str .= ShowTplTemp($Temp, $var);
    return $str;
}
Ejemplo n.º 3
0
function NewsTreeClass()
{
    global $msql, $fsql;
    $catid = $GLOBALS["PLUSVARS"]["catid"];
    $coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
    $showtj = $GLOBALS["PLUSVARS"]["showtj"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $scl = " catid!='0' ";
    if ($showtj != "" && $showtj != "0") {
        $scl .= " and tj='1' ";
    }
    if ($catid != 0 && $catid != "") {
        $catid = fmpath($catid);
        $scl .= " and catpath regexp '{$catid}' ";
    }
    //模版解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    //循环开始
    $var = array('coltitle' => $coltitle, 'target' => $target);
    $str = ShowTplTemp($TempArr["start"], $var);
    $msql->query("select * from {P}_news_cat where {$scl} order by xuhao");
    while ($msql->next_record()) {
        $pid = $msql->f("pid");
        $catid = $msql->f("catid");
        $cat = $msql->f("cat");
        $catpath = $msql->f("catpath");
        $ifchannel = $msql->f('ifchannel');
        $fsql->query("select count(id) from {P}_news_con where catpath regexp '" . fmpath($catid) . "'");
        if ($fsql->next_record()) {
            $nums = $fsql->f('count(id)');
        }
        if ($ifchannel == "1") {
            $url = ROOTPATH . "news/class/" . $catid . "/";
        } else {
            if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "news/class/" . $catid . ".html")) {
                $url = ROOTPATH . "news/class/" . $catid . ".html";
            } else {
                $url = ROOTPATH . "news/class/?" . $catid . ".html";
            }
        }
        $var = array('url' => $url, 'catid' => $catid, 'pid' => $pid, 'cat' => $cat, 'nums' => $nums, 'target' => $target);
        $str .= ShowTplTemp($TempArr["list"], $var);
    }
    $str .= $TempArr["end"];
    return $str;
}
Ejemplo n.º 4
0
function DownFabu()
{
    global $msql, $fsql, $tsql;
    $coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $memberid = $_COOKIE["MEMBERID"];
    $memberid = htmlspecialchars($memberid);
    //个人分类
    $fsql->query("select * from {P}_down_pcat where memberid='{$memberid}' order by xuhao");
    while ($fsql->next_record()) {
        $pcatid = $fsql->f("catid");
        $pcat = $fsql->f("cat");
        $pcatlist .= "<option value='" . $pcatid . "'>" . $pcat . "</option>";
    }
    //获取公共分类授权
    $secureset = SecureClass("166");
    //公共分类
    $fsql->query("select * from {P}_down_cat order by catpath");
    while ($fsql->next_record()) {
        $lpid = $fsql->f("pid");
        $lcatid = $fsql->f("catid");
        $cat = $fsql->f("cat");
        $catpath = $fsql->f("catpath");
        $lcatpath = explode(":", $catpath);
        //当主分类有授权时读取下级分类
        if (strstr($secureset, ":" . intval($lcatpath[0]) . ":")) {
            for ($i = 0; $i < sizeof($lcatpath) - 2; $i++) {
                $lcatpath[$i] = intval($lcatpath[$i]);
                $tsql->query("select catid,cat from {P}_down_cat where catid='{$lcatpath[$i]}'");
                if ($tsql->next_record()) {
                    $ncatid = $tsql->f('cat');
                    $ncat = $tsql->f('cat');
                    $ppcat .= $ncat . "/";
                }
            }
            if ($pid == $lcatid) {
                $catlist .= "<option value='" . $lcatid . "' selected>" . $ppcat . $cat . "</option>";
            } else {
                $catlist .= "<option value='" . $lcatid . "'>" . $ppcat . $cat . "</option>";
            }
            $ppcat = "";
        }
    }
    //专题
    $fsql->query("select * from {P}_down_proj order by id desc");
    while ($fsql->next_record()) {
        $projid = $fsql->f("id");
        $project = $fsql->f("project");
        $NowPath = fmpath($projid);
        $musellist .= "<option value=" . $NowPath . ">" . $project . "</option>";
    }
    //积分名称
    $defcentid = $GLOBALS["DOWNCONF"]["DefaultCentId"];
    $centyj = $GLOBALS["DOWNCONF"]["CentYj"] * 100;
    if ($defcentid < 1 || $defcentid > 5) {
        $defcentid = "1";
    }
    $msql->query("select * from {P}_member_centset");
    if ($msql->next_record()) {
        $centname1 = $msql->f('centname1');
        $centname2 = $msql->f('centname2');
        $centname3 = $msql->f('centname3');
        $centname4 = $msql->f('centname4');
        $centname5 = $msql->f('centname5');
    }
    $centstr = "centname" . $defcentid;
    $centlist = "<option value='" . $defcentid . "'>" . ${$centstr} . "</option>";
    //模版解释
    $Temp = LoadTemp($tempname);
    $var = array('pname' => $_COOKIE["MEMBERPNAME"], 'catlist' => $catlist, 'pcatlist' => $pcatlist, 'centlist' => $centlist, 'centyj' => $centyj, 'musellist' => $musellist);
    $str .= ShowTplTemp($Temp, $var);
    return $str;
}
Ejemplo n.º 5
0
function NewsPicLb()
{
    global $msql;
    $shownums = $GLOBALS["PLUSVARS"]["shownums"];
    $ord = $GLOBALS["PLUSVARS"]["ord"];
    $sc = $GLOBALS["PLUSVARS"]["sc"];
    $showtj = $GLOBALS["PLUSVARS"]["showtj"];
    $cutword = $GLOBALS["PLUSVARS"]["cutword"];
    $catid = $GLOBALS["PLUSVARS"]["catid"];
    $projid = $GLOBALS["PLUSVARS"]["projid"];
    $tags = $GLOBALS["PLUSVARS"]["tags"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $w = $GLOBALS["PLUSVARS"]["w"];
    $h = $GLOBALS["PLUSVARS"]["h"];
    //默认条件
    $scl = " iffb='1' and catid!='0' and src!='' ";
    if ($showtj != "" && $showtj != "0") {
        $scl .= " and tj='1' ";
    }
    //显示分类规则:如果后台不指定分类,则显示当前所在分类,否则不限分类
    if ($catid != 0 && $catid != "") {
        $catid = fmpath($catid);
        $scl .= " and catpath regexp '{$catid}' ";
    }
    //匹配专题
    if ($projid != 0 && $projid != "") {
        $projid = fmpath($projid);
        $scl .= " and proj regexp '{$projid}' ";
    }
    //判断匹配标签
    if ($tags != "") {
        $tags = $tags . ",";
        $scl .= " and tags regexp '{$tags}' ";
    }
    //模版解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    $h1 = $h - 22;
    $p = 1;
    $msql->query("select * from {P}_news_con where {$scl} order by {$ord} {$sc} limit 0,{$shownums}");
    while ($msql->next_record()) {
        $id = $msql->f('id');
        $src = $msql->f('src');
        $title = $msql->f('title');
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "news/html/" . $id . ".html")) {
            $url = ROOTPATH . "news/html/" . $id . ".html";
        } else {
            $url = ROOTPATH . "news/html/?" . $id . ".html";
        }
        if ($cutword != "0") {
            $title = csubstr($title, 0, $cutword);
        }
        $src = ROOTPATH . $src;
        if ($p == 1) {
            $pic = $src;
            $purl = $url;
            $ptitle = $title;
        } else {
            $pic .= "|" . $src;
            $purl .= "|" . $url;
            $ptitle .= "|" . $title;
        }
        $p++;
    }
    $var = array('ptitle' => $ptitle, 'pic' => $pic, 'purl' => $purl, 'w' => $w, 'h' => $h, 'h1' => $h1);
    $str .= ShowTplTemp($TempArr["end"], $var);
    return $str;
}
Ejemplo n.º 6
0
function PhotoTwoClass()
{
    global $msql, $fsql, $tsql;
    $catid = $GLOBALS["PLUSVARS"]["catid"];
    $showtj = $GLOBALS["PLUSVARS"]["showtj"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    if ($catid != 0 && $catid != "") {
        $scl = " pid='{$catid}' ";
    } else {
        $scl = " pid='0' ";
    }
    if ($showtj != "" && $showtj != "0") {
        $scl .= " and tj='1' ";
        $subscl = " and tj='1' ";
    }
    //模版解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    $msql->query("select * from {P}_photo_cat where {$scl} order by xuhao");
    while ($msql->next_record()) {
        $catid = $msql->f("catid");
        $cat = $msql->f("cat");
        $catpath = $msql->f("catpath");
        $ifchannel = $msql->f('ifchannel');
        if ($ifchannel == "1") {
            $toplink = ROOTPATH . "photo/class/" . $catid . "/";
        } else {
            if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "photo/class/" . $catid . ".html")) {
                $toplink = ROOTPATH . "photo/class/" . $catid . ".html";
            } else {
                $toplink = ROOTPATH . "photo/class/?" . $catid . ".html";
            }
        }
        $tsql->query("select count(id) from {P}_photo_con where iffb='1' and catid!='0' and  catpath regexp '" . fmpath($catpath) . "'");
        if ($tsql->next_record()) {
            $topcount = $tsql->f('count(id)');
        }
        $sublinkstr = "";
        $fsql->query("select * from {P}_photo_cat where pid='{$catid}' {$subscl} order by xuhao");
        while ($fsql->next_record()) {
            $scatid = $fsql->f("catid");
            $scat = $fsql->f("cat");
            $scatpath = $fsql->f("catpath");
            $sifchannel = $fsql->f('ifchannel');
            if ($sifchannel == "1") {
                $slink = ROOTPATH . "photo/class/" . $scatid . "/";
            } else {
                if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "photo/class/" . $scatid . ".html")) {
                    $slink = ROOTPATH . "photo/class/" . $scatid . ".html";
                } else {
                    $slink = ROOTPATH . "photo/class/?" . $scatid . ".html";
                }
            }
            $tsql->query("select count(id) from {P}_photo_con where iffb='1' and catid!='0' and  catpath regexp '" . fmpath($scatpath) . "'");
            if ($tsql->next_record()) {
                $subcount = $tsql->f('count(id)');
            }
            $substr = str_replace("{#slink#}", $slink, $TempArr["list"]);
            $substr = str_replace("{#target#}", $target, $substr);
            $substr = str_replace("{#scat#}", $scat, $substr);
            $substr = str_replace("{#subcount#}", $subcount, $substr);
            $sublinkstr .= $substr;
        }
        $var = array('toplink' => $toplink, 'cat' => $cat, 'topcount' => $topcount, 'sublinkstr' => $sublinkstr, 'target' => $target);
        $str .= ShowTplTemp($TempArr["menu"], $var);
    }
    $str .= $TempArr["end"];
    return $str;
}
Ejemplo n.º 7
0
function PhotoHot()
{
    global $fsql, $msql;
    $coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
    $shownums = $GLOBALS["PLUSVARS"]["shownums"];
    $showtj = $GLOBALS["PLUSVARS"]["showtj"];
    $cutword = $GLOBALS["PLUSVARS"]["cutword"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $catid = $GLOBALS["PLUSVARS"]["catid"];
    $projid = $GLOBALS["PLUSVARS"]["projid"];
    $tags = $GLOBALS["PLUSVARS"]["tags"];
    $pagename = $GLOBALS["PLUSVARS"]["pagename"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    //地址栏参数
    if ($pagename == "query" && strstr($_SERVER["QUERY_STRING"], ".html")) {
        $Arr = explode(".html", $_SERVER["QUERY_STRING"]);
        $nowcatid = $Arr[0];
    } elseif ($_GET["catid"] > 0) {
        $nowcatid = $_GET["catid"];
    } else {
        $nowcatid = 0;
    }
    $nowcatid = htmlspecialchars($nowcatid);
    //默认条件
    $scl = " iffb='1' and catid!='0' ";
    if ($showtj != "" && $showtj != "0") {
        $scl .= " and tj='1' ";
    }
    //显示分类规则:如果后台不指定分类,则显示当前所在分类,否则不限分类
    if ($catid != 0 && $catid != "") {
        $catid = fmpath($catid);
        $scl .= " and catpath regexp '{$catid}' ";
    } elseif ($nowcatid != 0 && $nowcatid != "") {
        $catid = fmpath($nowcatid);
        $scl .= " and catpath regexp '{$catid}' ";
    }
    //匹配专题
    if ($projid != 0 && $projid != "") {
        $projid = fmpath($projid);
        $scl .= " and proj regexp '{$projid}' ";
    }
    //判断匹配标签
    if ($tags != "") {
        $tags = $tags . ",";
        $scl .= " and tags regexp '{$tags}' ";
    }
    //模版解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $var = array('coltitle' => $coltitle, 'morelink' => $morelink);
    $str = ShowTplTemp($TempArr["start"], $var);
    $picnum = 1;
    $fsql->query("select * from {P}_photo_con where {$scl} order by cl desc limit 0,{$shownums}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $catpath = $fsql->f('catpath');
        $dtime = $fsql->f('dtime');
        $nowcatid = $fsql->f('catid');
        $ifnew = $fsql->f('ifnew');
        $ifred = $fsql->f('ifred');
        $ifbold = $fsql->f('ifbold');
        $author = $fsql->f('author');
        $source = $fsql->f('source');
        $cl = $fsql->f('cl');
        $src = $fsql->f('src');
        $cl = $fsql->f('cl');
        $prop1 = $fsql->f('prop1');
        $prop2 = $fsql->f('prop2');
        $prop3 = $fsql->f('prop3');
        $prop4 = $fsql->f('prop4');
        $prop5 = $fsql->f('prop5');
        $prop6 = $fsql->f('prop6');
        $prop7 = $fsql->f('prop7');
        $prop8 = $fsql->f('prop8');
        $prop9 = $fsql->f('prop9');
        $prop10 = $fsql->f('prop10');
        $prop11 = $fsql->f('prop11');
        $prop12 = $fsql->f('prop12');
        $prop13 = $fsql->f('prop13');
        $prop14 = $fsql->f('prop14');
        $prop15 = $fsql->f('prop15');
        $prop16 = $fsql->f('prop16');
        $prop17 = $fsql->f('prop17');
        $prop18 = $fsql->f('prop18');
        $prop19 = $fsql->f('prop19');
        $prop20 = $fsql->f('prop20');
        $memo = $fsql->f('memo');
        $mid = $fsql->f('memberid');
        if ($mid > 0) {
            $memberurl = ROOTPATH . "member/home.php?mid=" . $mid;
        } else {
            $memberurl = "#";
        }
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "photo/html/" . $id . ".html")) {
            $link = ROOTPATH . "photo/html/" . $id . ".html";
        } else {
            $link = ROOTPATH . "photo/html/?" . $id . ".html";
        }
        $dtime = date("m/d", $dtime);
        if ($ifbold == "1") {
            $bold = " style='font-weight:bold' ";
        } else {
            $bold = "";
        }
        if ($ifred != "0") {
            $red = " style='color:" . $ifred . "' ";
        } else {
            $red = "";
        }
        if ($cutword != "0") {
            $title = csubstr($title, 0, $cutword);
        }
        if ($src == "") {
            $src = "photo/pics/nopic.gif";
        }
        $src = ROOTPATH . $src;
        //模版标签解释
        $var = array('title' => $title, 'memo' => $memo, 'dtime' => $dtime, 'red' => $red, 'bold' => $bold, 'link' => $link, 'target' => $target, 'author' => $author, 'memberurl' => $memberurl, 'source' => $source, 'cat' => $cat, 'src' => $src, 'cl' => $cl, 'picnum' => $picnum, 'downurl' => $downurl, 'fileurl' => $fileurl, 'downcount' => $downcount, 'prop1' => $prop1, 'prop2' => $prop2, 'prop3' => $prop3, 'prop4' => $prop4, 'prop5' => $prop5, 'prop6' => $prop6, 'prop7' => $prop7, 'prop8' => $prop8, 'prop9' => $prop9, 'prop10' => $prop10, 'prop11' => $prop11, 'prop12' => $prop12, 'prop13' => $prop13, 'prop14' => $prop14, 'prop15' => $prop15, 'prop16' => $prop16, 'prop17' => $prop17, 'prop18' => $prop18, 'prop19' => $prop19, 'prop20' => $prop20, 'propname1' => $propname1, 'propname2' => $propname2, 'propname3' => $propname3, 'propname4' => $propname4, 'propname5' => $propname5, 'propname6' => $propname6, 'propname7' => $propname7, 'propname8' => $propname8, 'propname9' => $propname9, 'propname10' => $propname10, 'propname11' => $propname11, 'propname12' => $propname12, 'propname13' => $propname13, 'propname14' => $propname14, 'propname15' => $propname15, 'propname16' => $propname16, 'propname17' => $propname17, 'propname18' => $propname18, 'propname19' => $propname19, 'propname20' => $propname20);
        $str .= ShowTplTemp($TempArr["list"], $var);
        $picnum++;
    }
    $str .= $TempArr["end"];
    return $str;
}
Ejemplo n.º 8
0
function ProductList()
{
    global $fsql, $msql;
    $coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
    $shownums = $GLOBALS["PLUSVARS"]["shownums"];
    $ord = $GLOBALS["PLUSVARS"]["ord"];
    $sc = $GLOBALS["PLUSVARS"]["sc"];
    $showtj = $GLOBALS["PLUSVARS"]["showtj"];
    $cutword = $GLOBALS["PLUSVARS"]["cutword"];
    $cutbody = $GLOBALS["PLUSVARS"]["cutbody"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $catid = $GLOBALS["PLUSVARS"]["catid"];
    $projid = $GLOBALS["PLUSVARS"]["projid"];
    $tags = $GLOBALS["PLUSVARS"]["tags"];
    $pagename = $GLOBALS["PLUSVARS"]["pagename"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $picw = $GLOBALS["PLUSVARS"]["picw"];
    $pich = $GLOBALS["PLUSVARS"]["pich"];
    $fittype = $GLOBALS["PLUSVARS"]["fittype"];
    //地址栏参数
    if ($pagename == "query" && strstr($_SERVER["QUERY_STRING"], ".html")) {
        $Arr = explode(".html", $_SERVER["QUERY_STRING"]);
        $nowcatid = $Arr[0];
    } elseif ($_GET["catid"] > 0) {
        $nowcatid = $_GET["catid"];
    } else {
        $nowcatid = 0;
    }
    $nowcatid = htmlspecialchars($nowcatid);
    //默认条件
    $scl = " iffb='1' and catid!='0' ";
    if ($showtj != "" && $showtj != "0") {
        $scl .= " and tj='1' ";
    }
    //显示分类规则:如果后台不指定分类,则显示当前所在分类,否则不限分类
    if ($catid != 0 && $catid != "") {
        $catid = fmpath($catid);
        $scl .= " and catpath regexp '{$catid}' ";
    } elseif ($nowcatid != 0 && $nowcatid != "") {
        $catid = fmpath($nowcatid);
        $scl .= " and catpath regexp '{$catid}' ";
    }
    //匹配专题
    if ($projid != 0 && $projid != "") {
        $projid = fmpath($projid);
        $scl .= " and proj regexp '{$projid}' ";
    }
    //判断匹配标签
    if ($tags != "") {
        $tags = $tags . ",";
        $scl .= " and tags regexp '{$tags}' ";
    }
    //模版解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $var = array('coltitle' => $coltitle, 'morelink' => $morelink);
    $str = ShowTplTemp($TempArr["start"], $var);
    $picnum = 1;
    $fsql->query("select * from {P}_product_con where {$scl} order by {$ord} {$sc} limit 0,{$shownums}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $catpath = $fsql->f('catpath');
        $dtime = $fsql->f('dtime');
        $nowcatid = $fsql->f('catid');
        $ifnew = $fsql->f('ifnew');
        $ifred = $fsql->f('ifred');
        $ifbold = $fsql->f('ifbold');
        $author = $fsql->f('author');
        $source = $fsql->f('source');
        $cl = $fsql->f('cl');
        $src = $fsql->f('src');
        $cl = $fsql->f('cl');
        $prop1 = $fsql->f('prop1');
        $prop2 = $fsql->f('prop2');
        $prop3 = $fsql->f('prop3');
        $prop4 = $fsql->f('prop4');
        $prop5 = $fsql->f('prop5');
        $prop6 = $fsql->f('prop6');
        $prop7 = $fsql->f('prop7');
        $prop8 = $fsql->f('prop8');
        $prop9 = $fsql->f('prop9');
        $prop10 = $fsql->f('prop10');
        $prop11 = $fsql->f('prop11');
        $prop12 = $fsql->f('prop12');
        $prop13 = $fsql->f('prop13');
        $prop14 = $fsql->f('prop14');
        $prop15 = $fsql->f('prop15');
        $prop16 = $fsql->f('prop16');
        $prop17 = $fsql->f('prop17');
        $prop18 = $fsql->f('prop18');
        $prop19 = $fsql->f('prop19');
        $prop20 = $fsql->f('prop20');
        $memo = $fsql->f('memo');
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "product/html/" . $id . ".html")) {
            $link = ROOTPATH . "product/html/" . $id . ".html";
        } else {
            $link = ROOTPATH . "product/html/?" . $id . ".html";
        }
        $dtime = date("Y-m-d", $dtime);
        if ($ifbold == "1") {
            $bold = " style='font-weight:bold' ";
        } else {
            $bold = "";
        }
        if ($ifred != "0") {
            $red = " style='color:" . $ifred . "' ";
        } else {
            $red = "";
        }
        if ($cutword != "0") {
            $title = csubstr($title, 0, $cutword);
        }
        if ($cutbody != "0") {
            $memo = csubstr($memo, 0, $cutbody);
        }
        if ($src == "") {
            $src = "product/pics/nopic.gif";
        }
        $src = ROOTPATH . $src;
        //参数列
        $propstr = "";
        $i = 1;
        $msql->query("select * from {P}_product_prop where catid='{$nowcatid}' order by xuhao");
        while ($msql->next_record()) {
            $propname = $msql->f('propname');
            $pn = "prop" . $i;
            $pstr = str_replace("{#propname#}", $propname, $TempArr["m1"]);
            $pstr = str_replace("{#prop#}", ${$pn}, $pstr);
            $propstr .= $pstr;
            $i++;
        }
        //模版标签解释
        $var = array('title' => $title, 'memo' => $memo, 'propstr' => $propstr, 'dtime' => $dtime, 'red' => $red, 'bold' => $bold, 'link' => $link, 'target' => $target, 'author' => $author, 'source' => $source, 'cat' => $cat, 'src' => $src, 'picw' => $picw, 'pich' => $pich, 'cl' => $cl);
        $str .= ShowTplTemp($TempArr["list"], $var);
        $picnum++;
    }
    $var = array('fittype' => $fittype);
    $str .= ShowTplTemp($TempArr["end"], $var);
    return $str;
}
Ejemplo n.º 9
0
        <input name="tags[]" type="text" class="input" id="tags"  value="" size="10" /></td>
    </tr>
    
	<tr> 
      <td height="30" width="100" align="center" ><?php 
echo $strProductAddProj;
?>
</td>
      <td height="30" ><?php 
$catstr .= "<SCRIPT language=javascript src='js/multicat.js'></SCRIPT>";
$catstr .= "<table cellspacing=0 cellpadding=0><tr><td ><select style='WIDTH: 239px;font-size:12px;' multiple size=5 name=spe_funct>";
$fsql->query("select * from {P}_product_proj order by id desc");
while ($fsql->next_record()) {
    $projid = $fsql->f("id");
    $project = $fsql->f("project");
    $NowPath = fmpath($projid);
    $catstr .= "<option value=" . $NowPath . ">" . $project . "</option>";
    $ppcat = "";
}
$catstr .= "</select></td><td width=20>\r\n<input style='width:20px;height=37px;font-size:12px;border:1px outset;' onClick=\"JavaScript:AddItem('spe_funct', 'spe_selec[]')\" type=button value='+' name='Input'>\r\n<input style='width:20px;height=37px;font-size:12px;border:1px outset;' onClick=\"JavaScript:DelItem('spe_selec[]')\" type=button value='-' name='Input'>\r\n\t\t\t\t</td>\r\n\t\t\t\t<td>\r\n\t\t\t\t  <select  style='WIDTH: 239px;font-size:12px' multiple size=5 name=spe_selec[]>";
$catstr .= "</select></td><td valign=bottom></td><td width=20 align=center  valign='bottom'></td></tr></table>";
echo $catstr;
?>
</td>
    </tr>
  
   

</table>
</div>
<div class="adminsubmit">
Ejemplo n.º 10
0
function DownQuery()
{
    global $fsql, $msql, $strDownperson;
    $shownums = $GLOBALS["PLUSVARS"]["shownums"];
    $cutword = $GLOBALS["PLUSVARS"]["cutword"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    //地址栏参数
    if (strstr($_SERVER["QUERY_STRING"], ".html")) {
        $Arr = explode(".html", $_SERVER["QUERY_STRING"]);
        $catid = $Arr[0];
    } elseif ($_GET["catid"] > 0) {
        $catid = $_GET["catid"];
    } else {
        $catid = 0;
    }
    $key = $_GET["key"];
    $showtj = $_GET["showtj"];
    $page = $_GET["page"];
    $myord = $_GET["myord"];
    $myshownums = $_GET["myshownums"];
    $memberid = $_GET["memberid"];
    $showtag = $_GET["showtag"];
    if ($myord == "") {
        $myord = "dtime";
    }
    if ($myshownums != "" && $myshownums != "0") {
        $shownums = $myshownums;
    }
    //积分名称
    $msql->query("select * from {P}_member_centset");
    if ($msql->next_record()) {
        $centname1 = $msql->f('centname1');
        $centname2 = $msql->f('centname2');
        $centname3 = $msql->f('centname3');
        $centname4 = $msql->f('centname4');
        $centname5 = $msql->f('centname5');
    }
    //模版解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    $scl = " iffb='1' and catid!='0' ";
    if ($catid != "0" && $catid != "") {
        $fmdpath = fmpath($catid);
        $scl .= " and catpath regexp '{$fmdpath}' ";
    }
    if ($showtj != "" && $showtj != "all") {
        $scl .= " and tj='{$showtj}' ";
    }
    if ($memberid != "" && $memberid != "all") {
        $scl .= " and memberid='{$memberid}' ";
    }
    if ($key != "") {
        $scl .= " and (title regexp '{$key}' or body regexp '{$key}') ";
    }
    if ($showtag != "") {
        $scl .= " and tags regexp '{$showtag}' ";
    }
    include ROOTPATH . "includes/pages.inc.php";
    $pages = new pages();
    $totalnums = TblCount("_down_con", "id", $scl);
    $pages->setvar(array("catid" => $catid, "myord" => $myord, "myshownums" => $myshownums, "showtj" => $showtj, "author" => $author, "key" => $key));
    $pages->set($shownums, $totalnums);
    $pagelimit = $pages->limit();
    $fsql->query("select * from {P}_down_con where {$scl} order by {$myord} desc limit {$pagelimit}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $catid = $fsql->f('catid');
        $catpath = $fsql->f('catpath');
        $dtime = $fsql->f('dtime');
        $nowcatid = $fsql->f('catid');
        $ifbold = $fsql->f('ifbold');
        $ifred = $fsql->f('ifred');
        $author = $fsql->f('author');
        $source = $fsql->f('source');
        $type = $fsql->f('type');
        $src = $fsql->f('src');
        $cl = $fsql->f('cl');
        $fileurl = $fsql->f('fileurl');
        $downcount = $fsql->f('downcount');
        $prop1 = $fsql->f('prop1');
        $prop2 = $fsql->f('prop2');
        $prop3 = $fsql->f('prop3');
        $prop4 = $fsql->f('prop4');
        $prop5 = $fsql->f('prop5');
        $prop6 = $fsql->f('prop6');
        $prop7 = $fsql->f('prop7');
        $prop8 = $fsql->f('prop8');
        $prop9 = $fsql->f('prop9');
        $prop10 = $fsql->f('prop10');
        $prop11 = $fsql->f('prop11');
        $prop12 = $fsql->f('prop12');
        $prop13 = $fsql->f('prop13');
        $prop14 = $fsql->f('prop14');
        $prop15 = $fsql->f('prop15');
        $prop16 = $fsql->f('prop16');
        $prop17 = $fsql->f('prop17');
        $prop18 = $fsql->f('prop18');
        $prop19 = $fsql->f('prop19');
        $prop20 = $fsql->f('prop20');
        $memo = $fsql->f('memo');
        $downcent = $fsql->f('downcent');
        $downcentid = $fsql->f('downcentid');
        $centincome = $fsql->f('centincome');
        $dtime = date("Y-m-d", $dtime);
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "down/html/" . $id . ".html")) {
            $link = ROOTPATH . "down/html/" . $id . ".html";
        } else {
            $link = ROOTPATH . "down/html/?" . $id . ".html";
        }
        if ($ifbold == "1") {
            $bold = " style='font-weight:bold' ";
        } else {
            $bold = "";
        }
        if ($ifred != "0") {
            $red = " style='color:" . $ifred . "' ";
        } else {
            $red = "";
        }
        if ($cutword != "0") {
            $title = csubstr($title, 0, $cutword);
        }
        //参数列
        $i = 1;
        $msql->query("select * from {P}_down_prop where catid='{$catid}' order by xuhao");
        while ($msql->next_record()) {
            $pn = "propname" . $i;
            ${$pn} = $msql->f('propname');
            $i++;
        }
        //分类树
        $arr = explode(":", $catpath);
        if ($catpath == "") {
            $catstr = $strDownperson;
        } else {
            $catstr = "";
            for ($i = 0; $i < sizeof($arr); $i++) {
                if ($arr[$i] != "" && $arr[$i] != "0") {
                    $msql->query("select cat from {P}_down_cat where catid='" . intval($arr[$i]) . "'");
                    if ($msql->next_record()) {
                        $cat = $msql->f('cat');
                        $catstr .= $cat . "&gt;";
                    }
                }
            }
            $catstr = substr($catstr, 0, -4);
        }
        //交易积分
        $cenv = "centname" . $downcentid;
        $centname = ${$cenv};
        $var = array('title' => $title, 'dtime' => $dtime, 'red' => $red, 'author' => $author, 'source' => $source, 'cat' => $cat, 'src' => $src, 'cl' => $cl, 'catstr' => $catstr, 'fileurl' => $fileurl, 'downcount' => $downcount, 'link' => $link, 'target' => $target, 'centname' => $centname, 'downcent' => $downcent, 'centincome' => $centincome, 'memo' => $memo, 'bold' => $bold, 'prop1' => $prop1, 'prop2' => $prop2, 'prop3' => $prop3, 'prop4' => $prop4, 'prop5' => $prop5, 'prop6' => $prop6, 'prop7' => $prop7, 'prop8' => $prop8, 'prop9' => $prop9, 'prop10' => $prop10, 'prop11' => $prop11, 'prop12' => $prop12, 'prop13' => $prop13, 'prop14' => $prop14, 'prop15' => $prop15, 'prop16' => $prop16, 'prop17' => $prop17, 'prop18' => $prop18, 'prop19' => $prop19, 'prop20' => $prop20, 'propname1' => $propname1, 'propname2' => $propname2, 'propname3' => $propname3, 'propname4' => $propname4, 'propname5' => $propname5, 'propname6' => $propname6, 'propname7' => $propname7, 'propname8' => $propname8, 'propname9' => $propname9, 'propname10' => $propname10, 'propname11' => $propname11, 'propname12' => $propname12, 'propname13' => $propname13, 'propname14' => $propname14, 'propname15' => $propname15, 'propname16' => $propname16, 'propname17' => $propname17, 'propname18' => $propname18, 'propname19' => $propname19, 'propname20' => $propname20);
        $str .= ShowTplTemp($TempArr["list"], $var);
    }
    $str .= $TempArr["end"];
    $pagesinfo = $pages->ShowNow();
    $var = array('showpages' => $pages->output(1), 'pagestotal' => $pagesinfo["total"], 'pagesnow' => $pagesinfo["now"], 'pagesshownum' => $pagesinfo["shownum"], 'pagesfrom' => $pagesinfo["from"], 'pagesto' => $pagesinfo["to"], 'totalnums' => $totalnums);
    $str = ShowTplTemp($str, $var);
    return $str;
}
Ejemplo n.º 11
0
function PhotoGl()
{
    global $fsql, $tsql;
    $coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $memberid = $_COOKIE["MEMBERID"];
    $memberid = htmlspecialchars($memberid);
    $showcatid = htmlspecialchars($_GET["showcatid"]);
    $shownum = htmlspecialchars($_GET["shownum"]);
    $showpcatid = htmlspecialchars($_GET["showpcatid"]);
    $key = htmlspecialchars($_GET["key"]);
    $page = htmlspecialchars($_GET["page"]);
    $step = htmlspecialchars($_GET["step"]);
    if ($step == "update") {
        $id = $_GET["id"];
        $now = time();
        $fsql->query("update {P}_photo_con set uptime='{$now}' where id='{$id}' and memberid='{$memberid}'");
    }
    if ($step == "del") {
        $id = $_GET["id"];
        //删除原图
        $fsql->query("select src from {P}_photo_con where memberid='{$memberid}' and id='{$id}'");
        if ($fsql->next_record()) {
            $oldsrc = $fsql->f('src');
            if (file_exists(ROOTPATH . $oldsrc) && $oldsrc != "" && !strstr($oldsrc, "../")) {
                unlink(ROOTPATH . $oldsrc);
            }
            $candel = "yes";
        } else {
            $candel = "no";
        }
        if ($candel == "yes") {
            //删除组图
            $fsql->query("select src from {P}_photo_pages where photoid='{$id}'");
            while ($fsql->next_record()) {
                $oldsrc = $fsql->f('src');
                if (file_exists(ROOTPATH . $oldsrc) && $oldsrc != "" && !strstr($oldsrc, "../")) {
                    unlink(ROOTPATH . $oldsrc);
                }
            }
            $fsql->query("delete from {P}_photo_pages where photoid='{$id}'");
        }
        $fsql->query("delete from {P}_photo_con where id='{$id}' and memberid='{$memberid}'");
    }
    //模板解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    //自定义分类
    $fsql->query("select * from {P}_photo_pcat where memberid='{$memberid}' order by xuhao");
    while ($fsql->next_record()) {
        $pcatid = $fsql->f("catid");
        $pcat = $fsql->f("cat");
        if ($showpcatid == $pcatid) {
            $pcatlist .= "<option value='" . $pcatid . "' selected>" . $pcat . "</option>";
        } else {
            $pcatlist .= "<option value='" . $pcatid . "'>" . $pcat . "</option>";
        }
    }
    //图片分类
    $fsql->query("select * from {P}_photo_cat order by catpath");
    while ($fsql->next_record()) {
        $lpid = $fsql->f("pid");
        $lcatid = $fsql->f("catid");
        $cat = $fsql->f("cat");
        $catpath = $fsql->f("catpath");
        $lcatpath = explode(":", $catpath);
        for ($i = 0; $i < sizeof($lcatpath) - 2; $i++) {
            $tsql->query("select catid,cat from {P}_photo_cat where catid='{$lcatpath[$i]}'");
            if ($tsql->next_record()) {
                $ncatid = $tsql->f('cat');
                $ncat = $tsql->f('cat');
                $ppcat .= $ncat . "/";
            }
        }
        if ($showcatid == $lcatid) {
            $catlist .= "<option value='" . $lcatid . "' selected>" . $ppcat . $cat . "</option>";
        } else {
            $catlist .= "<option value='" . $lcatid . "'>" . $ppcat . $cat . "</option>";
        }
        $ppcat = "";
    }
    $var = array('catlist' => $catlist, 'pcatlist' => $pcatlist);
    $str = ShowTplTemp($TempArr["start"], $var);
    $scl = " memberid='{$memberid}' ";
    if ($showcatid != "" && $showcatid != "0") {
        $fmdpath = fmpath($showcatid);
        $scl .= " and catpath regexp '{$fmdpath}' ";
    }
    if ($showpcatid != "" && $showpcatid != "0") {
        $scl .= " and pcatid ='{$showpcatid}' ";
    }
    if ($key != "") {
        $scl .= " and (title regexp '{$key}' or body regexp '{$key}') ";
    }
    if ($shownum == "") {
        $shownum = "10";
    }
    include ROOTPATH . "includes/pages.inc.php";
    $pages = new pages();
    $totalnums = TblCount("_photo_con", "id", $scl);
    $pages->setvar(array("key" => $key, "shownum" => $shownum, "showcatid" => $showcatid, "showpcatid" => $showpcatid));
    $pages->set($shownum, $totalnums);
    $pagelimit = $pages->limit();
    $fsql->query("select * from {P}_photo_con where {$scl} order by uptime desc limit {$pagelimit}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $dtime = $fsql->f('dtime');
        $src = $fsql->f('src');
        $uptime = $fsql->f('uptime');
        $iffb = $fsql->f('iffb');
        $dtime = date("Y-m-d", $dtime);
        $uptime = date("Y-m-d", $uptime);
        if ($iffb == "1") {
            $check = "<img src='" . ROOTPATH . "photo/templates/images/yes.gif'>";
        } else {
            $check = "<img src='" . ROOTPATH . "photo/templates/images/no.gif'>";
        }
        if ($src != "") {
            $icon = "image.gif";
            $src = ROOTPATH . $src;
        } else {
            $icon = "noimage.gif";
        }
        $link = ROOTPATH . "photo/html/?" . $id . ".html";
        $var = array('page' => $page, 'title' => $title, 'dtime' => $dtime, 'src' => $src, 'icon' => $icon, 'uptime' => $uptime, 'check' => $check, 'target' => "_blank", 'link' => $link, 'id' => $id);
        $str .= ShowTplTemp($TempArr["list"], $var);
    }
    $str .= $TempArr["end"];
    $pagesinfo = $pages->ShowNow();
    $var = array('key' => $key, 'showcatid' => $showcatid, 'shownum' => $shownum, 'showpages' => $pages->output(1), 'pagestotal' => $pagesinfo["total"], 'pagesnow' => $pagesinfo["now"], 'pagesshownum' => $pagesinfo["shownum"], 'pagesfrom' => $pagesinfo["from"], 'pagesto' => $pagesinfo["to"], 'totalnums' => $totalnums);
    $str = ShowTplTemp($str, $var);
    return $str;
}
Ejemplo n.º 12
0
function NewsPicRollx3()
{
    global $fsql, $msql;
    $coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
    $showtj = $GLOBALS["PLUSVARS"]["showtj"];
    $cutword = $GLOBALS["PLUSVARS"]["cutword"];
    $cutbody = $GLOBALS["PLUSVARS"]["cutbody"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $catid = $GLOBALS["PLUSVARS"]["catid"];
    $projid = $GLOBALS["PLUSVARS"]["projid"];
    $tags = $GLOBALS["PLUSVARS"]["tags"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $tempcolor = $GLOBALS["PLUSVARS"]["tempcolor"];
    //本插件固定3张图片
    $shownums = 3;
    //默认条件
    $scl = " iffb='1' and src!='' and catid!='0' ";
    if ($showtj != "" && $showtj != "0") {
        $scl .= " and tj='1' ";
    }
    //显示分类规则:如果后台不指定分类,则显示当前所在分类,否则不限分类
    if ($catid != 0 && $catid != "") {
        $catid = fmpath($catid);
        $scl .= " and catpath regexp '{$catid}' ";
    }
    //匹配专题
    if ($projid != 0 && $projid != "") {
        $projid = fmpath($projid);
        $scl .= " and proj regexp '{$projid}' ";
    }
    //判断匹配标签
    if ($tags != "") {
        $tags = $tags . ",";
        $scl .= " and tags regexp '{$tags}' ";
    }
    //模版解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $var = array('coltitle' => $coltitle, 'tempcolor' => $tempcolor);
    $str = ShowTplTemp($TempArr["start"], $var);
    $picnum = 1;
    $fsql->query("select * from {P}_news_con where {$scl} order by uptime desc limit 0,{$shownums}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $catpath = $fsql->f('catpath');
        $dtime = $fsql->f('dtime');
        $nowcatid = $fsql->f('catid');
        $ifnew = $fsql->f('ifnew');
        $ifred = $fsql->f('ifred');
        $ifbold = $fsql->f('ifbold');
        $author = $fsql->f('author');
        $source = $fsql->f('source');
        $cl = $fsql->f('cl');
        $src = $fsql->f('src');
        $memo = $fsql->f('memo');
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "news/html/" . $id . ".html")) {
            $link = ROOTPATH . "news/html/" . $id . ".html";
        } else {
            $link = ROOTPATH . "news/html/?" . $id . ".html";
        }
        if ($cutword != "0") {
            $title = csubstr($title, 0, $cutword);
        }
        if ($cutbody != "0") {
            $memo = csubstr($memo, 0, $cutbody);
        }
        if ($src == "") {
            $src = "news/pics/nopic.gif";
        }
        $src = ROOTPATH . $src;
        //模版标签解释
        $var = array('title' => $title, 'memo' => $memo, 'dtime' => $dtime, 'red' => $red, 'bold' => $bold, 'link' => $link, 'target' => $target, 'author' => $author, 'source' => $source, 'cat' => $cat, 'src' => $src, 'cl' => $cl, 'picnum' => $picnum);
        $str .= ShowTplTemp($TempArr["list"], $var);
        $picnum++;
    }
    $str .= $TempArr["end"];
    return $str;
}
Ejemplo n.º 13
0
echo $strAdminTitle;
?>
</title>
<script type="text/javascript" src="../../base/js/base.js"></script>
<script type="text/javascript" src="../../base/js/form.js"></script>
<script type="text/javascript" src="../../base/js/blockui.js"></script>
<script type="text/javascript" src="js/news.js"></script>
</head>

<body>

<?php 
$step = $_REQUEST["step"];
if ($step == "del") {
    $id = $_GET["id"];
    $fmpath = fmpath($id) . ":";
    $msql->query("select id from {P}_news_con where proj regexp '{$fmpath}' ");
    if ($msql->next_record()) {
        err($strProjNTC5, "", "");
        exit;
    }
    $msql->query("select folder from {P}_news_proj where id='{$id}'");
    if ($msql->next_record()) {
        $delfolder = $msql->f('folder');
    } else {
        err($strProjNTC6, "", "");
        exit;
    }
    $pagename = "proj_" . $delfolder;
    //删除页面记录
    $msql->query("delete from {P}_base_pageset where coltype='news' and pagename='{$pagename}'");
Ejemplo n.º 14
0
function PhotoModify()
{
    global $msql, $fsql, $tsql;
    $coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    //模版解释
    $Temp = LoadTemp($tempname);
    $id = $_REQUEST["id"];
    $id = htmlspecialchars($id);
    $memberid = $_COOKIE["MEMBERID"];
    $memberid = htmlspecialchars($memberid);
    $msql->query("select * from {P}_photo_con where id='{$id}' and memberid='{$memberid}'");
    if ($msql->next_record()) {
        $catid = $msql->f('catid');
        $mypcatid = $msql->f('pcatid');
        $title = $msql->f('title');
        $src = $msql->f('src');
        $author = $msql->f('author');
        $source = $msql->f('source');
        $memo = $msql->f('memo');
        $tags = $msql->f('tags');
        $proj = $msql->f('proj');
    } else {
        return "Invalied ID";
    }
    if ($src != "") {
        $icon = "image.gif";
        $src = ROOTPATH . $src;
    } else {
        $icon = "noimage.gif";
    }
    //个人分类
    $fsql->query("select * from {P}_photo_pcat where memberid='{$memberid}' order by xuhao");
    while ($fsql->next_record()) {
        $pcatid = $fsql->f("catid");
        $pcat = $fsql->f("cat");
        if ($mypcatid == $pcatid) {
            $pcatlist .= "<option value='" . $pcatid . "' selected>" . $pcat . "</option>";
        } else {
            $pcatlist .= "<option value='" . $pcatid . "'>" . $pcat . "</option>";
        }
    }
    //获取公共分类授权
    $secureset = SecureClass("156");
    //公共分类
    $fsql->query("select * from {P}_photo_cat order by catpath");
    while ($fsql->next_record()) {
        $lpid = $fsql->f("pid");
        $lcatid = $fsql->f("catid");
        $cat = $fsql->f("cat");
        $catpath = $fsql->f("catpath");
        $lcatpath = explode(":", $catpath);
        //当主分类有授权时读取下级分类
        if (strstr($secureset, ":" . intval($lcatpath[0]) . ":")) {
            for ($i = 0; $i < sizeof($lcatpath) - 2; $i++) {
                $tsql->query("select catid,cat from {P}_photo_cat where catid='{$lcatpath[$i]}'");
                if ($tsql->next_record()) {
                    $ncatid = $tsql->f('cat');
                    $ncat = $tsql->f('cat');
                    $ppcat .= $ncat . "/";
                }
            }
            if ($catid == $lcatid) {
                $catlist .= "<option value='" . $lcatid . "' selected>" . $ppcat . $cat . "</option>";
            } else {
                $catlist .= "<option value='" . $lcatid . "'>" . $ppcat . $cat . "</option>";
            }
            $ppcat = "";
        }
    }
    //标签处理
    $tags = explode(",", $tags);
    //专题
    $fsql->query("select * from {P}_photo_proj order by id desc");
    while ($fsql->next_record()) {
        $projid = $fsql->f("id");
        $project = $fsql->f("project");
        $NowPath = fmpath($projid);
        $musellist .= "<option value=" . $NowPath . ">" . $project . "</option>";
    }
    //已选专题
    $arrs = explode(":", $proj);
    for ($k = 0; $k < sizeof($arrs) - 1; $k++) {
        $projid = $arrs[$k] + 0;
        $tsql->query("select project from {P}_photo_proj where id='{$projid}'");
        if ($tsql->next_record()) {
            $project = $tsql->f('project');
        }
        $munowlist .= "<option value=" . $arrs[$k] . ">" . $project . "</option>";
    }
    //模版解释
    $var = array('catlist' => $catlist, 'pcatlist' => $pcatlist, 'author' => $author, 'source' => $source, 'memo' => $memo, 'icon' => $icon, 'src' => $src, 'title' => $title, 'id' => $id, 'musellist' => $musellist, 'munowlist' => $munowlist, 'tags0' => $tags[0], 'tags1' => $tags[1], 'tags2' => $tags[2], 'tags3' => $tags[3], 'tags4' => $tags[4]);
    $str = ShowTplTemp($Temp, $var);
    return $str;
}
Ejemplo n.º 15
0
function ProductQuery()
{
    global $fsql, $msql, $tsql;
    $shownums = $GLOBALS["PLUSVARS"]["shownums"];
    $cutword = $GLOBALS["PLUSVARS"]["cutword"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $picw = $GLOBALS["PLUSVARS"]["picw"];
    $pich = $GLOBALS["PLUSVARS"]["pich"];
    $fittype = $GLOBALS["PLUSVARS"]["fittype"];
    $cutbody = $GLOBALS["PLUSVARS"]["cutbody"];
    //地址栏参数
    if (strstr($_SERVER["QUERY_STRING"], ".html")) {
        $Arr = explode(".html", $_SERVER["QUERY_STRING"]);
        $catid = $Arr[0];
    } elseif ($_GET["catid"] > 0) {
        $catid = $_GET["catid"];
    } else {
        $catid = 0;
    }
    $key = $_GET["key"];
    $showtj = $_GET["showtj"];
    $page = $_GET["page"];
    $myord = $_GET["myord"];
    $myshownums = $_GET["myshownums"];
    $memberid = $_GET["memberid"];
    $showtag = $_GET["showtag"];
    if ($myord == "") {
        $myord = "uptime";
    }
    if ($myshownums != "" && $myshownums != "0") {
        $shownums = $myshownums;
    }
    //模版解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    $scl = " iffb='1' and catid!='0' ";
    if ($catid != "0" && $catid != "") {
        $fmdpath = fmpath($catid);
        $scl .= " and catpath regexp '{$fmdpath}' ";
    }
    if ($showtj != "" && $showtj != "all") {
        $scl .= " and tj='{$showtj}' ";
    }
    if ($memberid != "" && $memberid != "all") {
        $scl .= " and memberid='{$memberid}' ";
    }
    if ($key != "") {
        $scl .= " and (title regexp '{$key}' or memo regexp '{$key}') ";
    }
    if ($showtag != "") {
        $scl .= " and tags regexp '{$showtag}' ";
    }
    include ROOTPATH . "includes/pages.inc.php";
    $pages = new pages();
    $totalnums = TblCount("_product_con", "id", $scl);
    $pages->setvar(array("catid" => $catid, "myord" => $myord, "myshownums" => $myshownums, "showtj" => $showtj, "author" => $author, "key" => $key));
    $pages->set($shownums, $totalnums);
    $pagelimit = $pages->limit();
    $fsql->query("select * from {P}_product_con where {$scl} order by {$myord} desc limit {$pagelimit}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $catid = $fsql->f('catid');
        $catpath = $fsql->f('catpath');
        $dtime = $fsql->f('dtime');
        $nowcatid = $fsql->f('catid');
        $ifbold = $fsql->f('ifbold');
        $ifred = $fsql->f('ifred');
        $author = $fsql->f('author');
        $source = $fsql->f('source');
        $type = $fsql->f('type');
        $src = $fsql->f('src');
        $cl = $fsql->f('cl');
        $prop1 = $fsql->f('prop1');
        $prop2 = $fsql->f('prop2');
        $prop3 = $fsql->f('prop3');
        $prop4 = $fsql->f('prop4');
        $prop5 = $fsql->f('prop5');
        $prop6 = $fsql->f('prop6');
        $prop7 = $fsql->f('prop7');
        $prop8 = $fsql->f('prop8');
        $prop9 = $fsql->f('prop9');
        $prop10 = $fsql->f('prop10');
        $prop11 = $fsql->f('prop11');
        $prop12 = $fsql->f('prop12');
        $prop13 = $fsql->f('prop13');
        $prop14 = $fsql->f('prop14');
        $prop15 = $fsql->f('prop15');
        $prop16 = $fsql->f('prop16');
        $prop17 = $fsql->f('prop17');
        $prop18 = $fsql->f('prop18');
        $prop19 = $fsql->f('prop19');
        $prop20 = $fsql->f('prop20');
        $memo = $fsql->f('memo');
        $dtime = date("Y-m-d", $dtime);
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "product/html/" . $id . ".html")) {
            $link = ROOTPATH . "product/html/" . $id . ".html";
        } else {
            $link = ROOTPATH . "product/html/?" . $id . ".html";
        }
        if ($ifbold == "1") {
            $bold = " style='font-weight:bold' ";
        } else {
            $bold = "";
        }
        if ($ifred != "0") {
            $red = " style='color:" . $ifred . "' ";
        } else {
            $red = "";
        }
        if ($cutword != "0") {
            $title = csubstr($title, 0, $cutword);
        }
        if ($cutbody != "0") {
            $memo = csubstr($memo, 0, $cutbody);
        }
        if ($src == "") {
            $src = "product/pics/nopic.gif";
        }
        $src = ROOTPATH . $src;
        $tsql->query("select cat from {P}_product_cat where catid='{$catid}'");
        if ($tsql->next_record()) {
            $cat = $tsql->f('cat');
        }
        //参数列
        $propstr = "";
        $i = 1;
        $msql->query("select * from {P}_product_prop where catid='{$catid}' order by xuhao");
        while ($msql->next_record()) {
            $propname = $msql->f('propname');
            $pn = "prop" . $i;
            $pstr = str_replace("{#propname#}", $propname, $TempArr["m1"]);
            $pstr = str_replace("{#prop#}", ${$pn}, $pstr);
            $propstr .= $pstr;
            $i++;
        }
        $var = array('cat' => $cat, 'id' => $id, 'title' => $title, 'propstr' => $propstr, 'dtime' => $dtime, 'red' => $red, 'author' => $author, 'source' => $source, 'src' => $src, 'cl' => $cl, 'link' => $link, 'target' => $target, 'memo' => $memo, 'picw' => $picw, 'pich' => $pich, 'bold' => $bold);
        $str .= ShowTplTemp($TempArr["list"], $var);
    }
    $str .= $TempArr["end"];
    $pagesinfo = $pages->ShowNow();
    $var = array('fittype' => $fittype, 'showpages' => $pages->output(1), 'pagestotal' => $pagesinfo["total"], 'pagesnow' => $pagesinfo["now"], 'pagesshownum' => $pagesinfo["shownum"], 'pagesfrom' => $pagesinfo["from"], 'pagesto' => $pagesinfo["to"], 'totalnums' => $totalnums);
    $str = ShowTplTemp($str, $var);
    return $str;
}
Ejemplo n.º 16
0
function NewsQuery()
{
    global $fsql, $msql;
    $shownums = $GLOBALS["PLUSVARS"]["shownums"];
    $cutword = $GLOBALS["PLUSVARS"]["cutword"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    //µØÖ·À¸²ÎÊý
    if (strstr($_SERVER["QUERY_STRING"], ".html")) {
        $Arr = explode(".html", $_SERVER["QUERY_STRING"]);
        $catid = $Arr[0];
    } elseif ($_GET["catid"] > 0) {
        $catid = $_GET["catid"];
    } else {
        $catid = 0;
    }
    $key = $_GET["key"];
    $showtj = $_GET["showtj"];
    $page = $_GET["page"];
    $myord = $_GET["myord"];
    $myshownums = $_GET["myshownums"];
    $memberid = $_GET["memberid"];
    $showtag = $_GET["showtag"];
    $showdate = $_GET["showdate"];
    if ($myord == "") {
        $myord = "uptime";
    }
    if ($myshownums != "" && $myshownums != "0") {
        $shownums = $myshownums;
    }
    //Ä£°æ½âÊÍ
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    //ĬÈÏÌõ¼þ
    $scl = " iffb='1' and catid!='0' ";
    if ($catid != "0" && $catid != "") {
        $fmdpath = fmpath($catid);
        $scl .= " and catpath regexp '{$fmdpath}' ";
    }
    if ($showtj != "" && $showtj != "all") {
        $scl .= " and tj='{$showtj}' ";
    }
    if ($memberid != "" && $memberid != "all") {
        $scl .= " and memberid='{$memberid}' ";
    }
    if ($key != "") {
        $scl .= " and (title regexp '{$key}' or body regexp '{$key}') ";
    }
    if ($showtag != "") {
        $scl .= " and tags regexp '{$showtag}' ";
    }
    if ($showdate != "" && strlen($showdate) == 8 && intval($showdate) > 19700101) {
        $timestart = mktime(0, 0, 0, substr($showdate, 4, 2), substr($showdate, 6, 2), substr($showdate, 0, 4));
        $timeend = mktime(23, 59, 59, substr($showdate, 4, 2), substr($showdate, 6, 2), substr($showdate, 0, 4));
        $scl .= " and dtime>{$timestart} and dtime<{$timeend} ";
    }
    include ROOTPATH . "includes/pages.inc.php";
    $pages = new pages();
    $totalnums = TblCount("_news_con", "id", $scl);
    $pages->setvar(array("catid" => $catid, "myord" => $myord, "myshownums" => $myshownums, "showtj" => $showtj, "showdate" => $showdate, "author" => $author, "key" => $key));
    $pages->set($shownums, $totalnums);
    $pagelimit = $pages->limit();
    $fsql->query("select * from {P}_news_con where {$scl} order by {$myord} desc limit {$pagelimit}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $catid = $fsql->f('catid');
        $catpath = $fsql->f('catpath');
        $dtime = $fsql->f('dtime');
        $nowcatid = $fsql->f('catid');
        $ifbold = $fsql->f('ifbold');
        $ifred = $fsql->f('ifred');
        $author = $fsql->f('author');
        $source = $fsql->f('source');
        $type = $fsql->f('type');
        $src = $fsql->f('src');
        $cl = $fsql->f('cl');
        $fileurl = $fsql->f('fileurl');
        $downcount = $fsql->f('downcount');
        $prop1 = $fsql->f('prop1');
        $prop2 = $fsql->f('prop2');
        $prop3 = $fsql->f('prop3');
        $prop4 = $fsql->f('prop4');
        $prop5 = $fsql->f('prop5');
        $prop6 = $fsql->f('prop6');
        $prop7 = $fsql->f('prop7');
        $prop8 = $fsql->f('prop8');
        $prop9 = $fsql->f('prop9');
        $prop10 = $fsql->f('prop10');
        $prop11 = $fsql->f('prop11');
        $prop12 = $fsql->f('prop12');
        $prop13 = $fsql->f('prop13');
        $prop14 = $fsql->f('prop14');
        $prop15 = $fsql->f('prop15');
        $prop16 = $fsql->f('prop16');
        $prop17 = $fsql->f('prop17');
        $prop18 = $fsql->f('prop18');
        $prop19 = $fsql->f('prop19');
        $prop20 = $fsql->f('prop20');
        $memo = $fsql->f('memo');
        $dtime = date("Y-m-d", $dtime);
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "news/html/" . $id . ".html")) {
            $link = ROOTPATH . "news/html/" . $id . ".html";
        } else {
            $link = ROOTPATH . "news/html/?" . $id . ".html";
        }
        if ($ifbold == "1") {
            $bold = " style='font-weight:bold' ";
        } else {
            $bold = "";
        }
        if ($ifred != "0") {
            $red = " style='color:" . $ifred . "' ";
        } else {
            $red = "";
        }
        if ($cutword != "0") {
            $title = csubstr($title, 0, $cutword);
        }
        if ($src == "") {
            $src = "news/pics/nopic.gif";
        }
        $src = ROOTPATH . $src;
        $downurl = ROOTPATH . "news/download.php?id=" . $id;
        $i = 1;
        $msql->query("select * from {P}_news_prop where catid='{$catid}' order by xuhao");
        while ($msql->next_record()) {
            $pn = "propname" . $i;
            ${$pn} = $msql->f('propname');
            $i++;
        }
        $var = array('title' => $title, 'dtime' => $dtime, 'red' => $red, 'author' => $author, 'source' => $source, 'src' => $src, 'cl' => $cl, 'downurl' => $downurl, 'fileurl' => $fileurl, 'downcount' => $downcount, 'link' => $link, 'target' => $target, 'memo' => $memo, 'bold' => $bold, 'prop1' => $prop1, 'prop2' => $prop2, 'prop3' => $prop3, 'prop4' => $prop4, 'prop5' => $prop5, 'prop6' => $prop6, 'prop7' => $prop7, 'prop8' => $prop8, 'prop9' => $prop9, 'prop10' => $prop10, 'prop11' => $prop11, 'prop12' => $prop12, 'prop13' => $prop13, 'prop14' => $prop14, 'prop15' => $prop15, 'prop16' => $prop16, 'prop17' => $prop17, 'prop18' => $prop18, 'prop19' => $prop19, 'prop20' => $prop20, 'propname1' => $propname1, 'propname2' => $propname2, 'propname3' => $propname3, 'propname4' => $propname4, 'propname5' => $propname5, 'propname6' => $propname6, 'propname7' => $propname7, 'propname8' => $propname8, 'propname9' => $propname9, 'propname10' => $propname10, 'propname11' => $propname11, 'propname12' => $propname12, 'propname13' => $propname13, 'propname14' => $propname14, 'propname15' => $propname15, 'propname16' => $propname16, 'propname17' => $propname17, 'propname18' => $propname18, 'propname19' => $propname19, 'propname20' => $propname20);
        $str .= ShowTplTemp($TempArr["list"], $var);
    }
    $str .= $TempArr["end"];
    $pagesinfo = $pages->ShowNow();
    $var = array('showpages' => $pages->output(1), 'pagestotal' => $pagesinfo["total"], 'pagesnow' => $pagesinfo["now"], 'pagesshownum' => $pagesinfo["shownum"], 'pagesfrom' => $pagesinfo["from"], 'pagesto' => $pagesinfo["to"], 'totalnums' => $totalnums);
    $str = ShowTplTemp($str, $var);
    return $str;
}
Ejemplo n.º 17
0
function DownModify()
{
    global $msql, $fsql, $tsql;
    $coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    //模版解释
    $Temp = LoadTemp($tempname);
    $id = $_REQUEST["id"];
    $id = htmlspecialchars($id);
    $memberid = $_COOKIE["MEMBERID"];
    $msql->query("select * from {P}_down_con where id='{$id}' and memberid='{$memberid}'");
    if ($msql->next_record()) {
        $catid = $msql->f('catid');
        $mypcatid = $msql->f('pcatid');
        $title = $msql->f('title');
        $body = $msql->f('body');
        $fileurl = $msql->f('fileurl');
        $author = $msql->f('author');
        $source = $msql->f('source');
        $memo = $msql->f('memo');
        $tags = $msql->f('tags');
        $proj = $msql->f('proj');
        $downcent = $msql->f('downcent');
        $downcentid = $msql->f('downcentid');
    } else {
        return "Invalied ID";
    }
    if ($src != "") {
        $icon = "image.gif";
        $src = ROOTPATH . $src;
    } else {
        $icon = "noimage.gif";
    }
    $body = htmlspecialchars($body);
    $body = Path2Url($body);
    //个人分类
    $fsql->query("select * from {P}_down_pcat where memberid='{$memberid}' order by xuhao");
    while ($fsql->next_record()) {
        $pcatid = $fsql->f("catid");
        $pcat = $fsql->f("cat");
        if ($mypcatid == $pcatid) {
            $pcatlist .= "<option value='" . $pcatid . "' selected>" . $pcat . "</option>";
        } else {
            $pcatlist .= "<option value='" . $pcatid . "'>" . $pcat . "</option>";
        }
    }
    //获取公共分类授权
    $secureset = SecureClass("166");
    //公共分类
    $fsql->query("select * from {P}_down_cat order by catpath");
    while ($fsql->next_record()) {
        $lpid = $fsql->f("pid");
        $lcatid = $fsql->f("catid");
        $cat = $fsql->f("cat");
        $catpath = $fsql->f("catpath");
        $lcatpath = explode(":", $catpath);
        //当主分类有授权时读取下级分类
        if (strstr($secureset, ":" . intval($lcatpath[0]) . ":")) {
            for ($i = 0; $i < sizeof($lcatpath) - 2; $i++) {
                $tsql->query("select catid,cat from {P}_down_cat where catid='{$lcatpath[$i]}'");
                if ($tsql->next_record()) {
                    $ncatid = $tsql->f('cat');
                    $ncat = $tsql->f('cat');
                    $ppcat .= $ncat . "/";
                }
            }
            if ($catid == $lcatid) {
                $catlist .= "<option value='" . $lcatid . "' selected>" . $ppcat . $cat . "</option>";
            } else {
                $catlist .= "<option value='" . $lcatid . "'>" . $ppcat . $cat . "</option>";
            }
            $ppcat = "";
        }
    }
    //标签处理
    $tags = explode(",", $tags);
    //专题
    $fsql->query("select * from {P}_down_proj order by id desc");
    while ($fsql->next_record()) {
        $projid = $fsql->f("id");
        $project = $fsql->f("project");
        $NowPath = fmpath($projid);
        $musellist .= "<option value=" . $NowPath . ">" . $project . "</option>";
    }
    //已选专题
    $arrs = explode(":", $proj);
    for ($k = 0; $k < sizeof($arrs) - 1; $k++) {
        $projid = $arrs[$k] + 0;
        $tsql->query("select project from {P}_down_proj where id='{$projid}'");
        if ($tsql->next_record()) {
            $project = $tsql->f('project');
        }
        $munowlist .= "<option value=" . $arrs[$k] . ">" . $project . "</option>";
    }
    //积分名称
    $defcentid = $GLOBALS["DOWNCONF"]["DefaultCentId"];
    $centyj = $GLOBALS["DOWNCONF"]["CentYj"] * 100;
    if ($defcentid < 1 || $defcentid > 5) {
        $defcentid = "1";
    }
    $msql->query("select * from {P}_member_centset");
    if ($msql->next_record()) {
        $centname1 = $msql->f('centname1');
        $centname2 = $msql->f('centname2');
        $centname3 = $msql->f('centname3');
        $centname4 = $msql->f('centname4');
        $centname5 = $msql->f('centname5');
    }
    $centstr = "centname" . $defcentid;
    $centlist = "<option value='" . $defcentid . "'>" . ${$centstr} . "</option>";
    //模版解释
    $var = array('catlist' => $catlist, 'pcatlist' => $pcatlist, 'author' => $author, 'source' => $source, 'memo' => $memo, 'icon' => $icon, 'fileurl' => $fileurl, 'title' => $title, 'id' => $id, 'musellist' => $musellist, 'munowlist' => $munowlist, 'tags0' => $tags[0], 'tags1' => $tags[1], 'tags2' => $tags[2], 'tags3' => $tags[3], 'tags4' => $tags[4], 'centlist' => $centlist, 'centyj' => $centyj, 'downcent' => $downcent, 'body' => $body);
    $str = ShowTplTemp($Temp, $var);
    return $str;
}
Ejemplo n.º 18
0
function NewsGlobalQuery()
{
    global $fsql, $msql;
    $shownums = $GLOBALS["PLUSVARS"]["shownums"];
    $ord = $GLOBALS["PLUSVARS"]["ord"];
    $sc = $GLOBALS["PLUSVARS"]["sc"];
    $showtj = $GLOBALS["PLUSVARS"]["showtj"];
    $cutword = $GLOBALS["PLUSVARS"]["cutword"];
    $cutbody = $GLOBALS["PLUSVARS"]["cutbody"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $catid = $GLOBALS["PLUSVARS"]["catid"];
    $projid = $GLOBALS["PLUSVARS"]["projid"];
    $tags = $GLOBALS["PLUSVARS"]["tags"];
    $pagename = $GLOBALS["PLUSVARS"]["pagename"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    //默认条件
    $scl = " iffb='1' and catid!='0' ";
    if ($showtj != "" && $showtj != "0") {
        $scl .= " and tj='1' ";
    }
    //匹配所选分类
    if ($catid != 0 && $catid != "") {
        $catid = fmpath($catid);
        $scl .= " and catpath regexp '{$catid}' ";
    }
    //匹配专题
    if ($projid != 0 && $projid != "") {
        $projid = fmpath($projid);
        $scl .= " and proj regexp '{$projid}' ";
    }
    //判断匹配标签
    if ($tags != "") {
        $tags = $tags . ",";
        $scl .= " and tags regexp '{$tags}' ";
    }
    //模版解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    //翻页
    include ROOTPATH . "includes/pages.inc.php";
    $pages = new pages();
    $totalnums = TblCount("_news_con", "id", $scl);
    $pages->setvar(array("key" => $key));
    $pages->set($shownums, $totalnums);
    $pagelimit = $pages->limit();
    $picnum = 1;
    $fsql->query("select * from {P}_news_con where {$scl} order by {$ord} {$sc} limit {$pagelimit}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $catpath = $fsql->f('catpath');
        $dtime = $fsql->f('dtime');
        $nowcatid = $fsql->f('catid');
        $ifnew = $fsql->f('ifnew');
        $ifred = $fsql->f('ifred');
        $ifbold = $fsql->f('ifbold');
        $author = $fsql->f('author');
        $source = $fsql->f('source');
        $cl = $fsql->f('cl');
        $src = $fsql->f('src');
        $cl = $fsql->f('cl');
        $fileurl = $fsql->f('fileurl');
        $downcount = $fsql->f('downcount');
        $prop1 = $fsql->f('prop1');
        $prop2 = $fsql->f('prop2');
        $prop3 = $fsql->f('prop3');
        $prop4 = $fsql->f('prop4');
        $prop5 = $fsql->f('prop5');
        $prop6 = $fsql->f('prop6');
        $prop7 = $fsql->f('prop7');
        $prop8 = $fsql->f('prop8');
        $prop9 = $fsql->f('prop9');
        $prop10 = $fsql->f('prop10');
        $prop11 = $fsql->f('prop11');
        $prop12 = $fsql->f('prop12');
        $prop13 = $fsql->f('prop13');
        $prop14 = $fsql->f('prop14');
        $prop15 = $fsql->f('prop15');
        $prop16 = $fsql->f('prop16');
        $prop17 = $fsql->f('prop17');
        $prop18 = $fsql->f('prop18');
        $prop19 = $fsql->f('prop19');
        $prop20 = $fsql->f('prop20');
        $memo = $fsql->f('memo');
        $mid = $fsql->f('memberid');
        if ($mid > 0) {
            $memberurl = ROOTPATH . "member/home.php?mid=" . $mid;
        } else {
            $memberurl = "#";
        }
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "news/html/" . $id . ".html")) {
            $link = ROOTPATH . "news/html/" . $id . ".html";
        } else {
            $link = ROOTPATH . "news/html/?" . $id . ".html";
        }
        $dtimey = date("Y-m-d", $dtime);
        $dtime = date("m/d", $dtime);
        if ($ifbold == "1") {
            $bold = " style='font-weight:bold' ";
        } else {
            $bold = "";
        }
        if ($ifred != "0") {
            $red = " style='color:" . $ifred . "' ";
        } else {
            $red = "";
        }
        if ($cutword != "0") {
            $title = csubstr($title, 0, $cutword);
        }
        if ($cutbody != "0") {
            $memo = csubstr($memo, 0, $cutbody);
        }
        if ($src == "") {
            $src = "news/pics/nopic.gif";
        }
        $src = ROOTPATH . $src;
        $downurl = ROOTPATH . "news/download.php?id=" . $id;
        //显示所属分类
        $msql->query("select cat from {P}_news_cat where catid='{$nowcatid}'");
        if ($msql->next_record()) {
            $cat = $msql->f('cat');
        }
        //参数列
        $i = 1;
        $msql->query("select * from {P}_news_prop where catid='{$nowcatid}' order by xuhao");
        while ($msql->next_record()) {
            $pn = "propname" . $i;
            ${$pn} = $msql->f('propname');
            $i++;
        }
        //模版标签解释
        $var = array('title' => $title, 'memo' => $memo, 'dtime' => $dtime, 'dtimey' => $dtimey, 'red' => $red, 'bold' => $bold, 'link' => $link, 'target' => $target, 'author' => $author, 'source' => $source, 'cat' => $cat, 'src' => $src, 'cl' => $cl, 'memberurl' => $memberurl, 'picnum' => $picnum, 'downurl' => $downurl, 'fileurl' => $fileurl, 'downcount' => $downcount, 'prop1' => $prop1, 'prop2' => $prop2, 'prop3' => $prop3, 'prop4' => $prop4, 'prop5' => $prop5, 'prop6' => $prop6, 'prop7' => $prop7, 'prop8' => $prop8, 'prop9' => $prop9, 'prop10' => $prop10, 'prop11' => $prop11, 'prop12' => $prop12, 'prop13' => $prop13, 'prop14' => $prop14, 'prop15' => $prop15, 'prop16' => $prop16, 'prop17' => $prop17, 'prop18' => $prop18, 'prop19' => $prop19, 'prop20' => $prop20, 'propname1' => $propname1, 'propname2' => $propname2, 'propname3' => $propname3, 'propname4' => $propname4, 'propname5' => $propname5, 'propname6' => $propname6, 'propname7' => $propname7, 'propname8' => $propname8, 'propname9' => $propname9, 'propname10' => $propname10, 'propname11' => $propname11, 'propname12' => $propname12, 'propname13' => $propname13, 'propname14' => $propname14, 'propname15' => $propname15, 'propname16' => $propname16, 'propname17' => $propname17, 'propname18' => $propname18, 'propname19' => $propname19, 'propname20' => $propname20);
        $str .= ShowTplTemp($TempArr["list"], $var);
        $picnum++;
    }
    $str .= $TempArr["end"];
    $pagesinfo = $pages->ShowNow();
    $var = array('showpages' => $pages->output(1), 'pagestotal' => $pagesinfo["total"], 'pagesnow' => $pagesinfo["now"], 'pagesshownum' => $pagesinfo["shownum"], 'pagesfrom' => $pagesinfo["from"], 'pagesto' => $pagesinfo["to"], 'totalnums' => $totalnums);
    $str = ShowTplTemp($str, $var);
    return $str;
}
Ejemplo n.º 19
0
function DownGlobalQuery()
{
    global $fsql, $msql;
    $shownums = $GLOBALS["PLUSVARS"]["shownums"];
    $ord = $GLOBALS["PLUSVARS"]["ord"];
    $sc = $GLOBALS["PLUSVARS"]["sc"];
    $showtj = $GLOBALS["PLUSVARS"]["showtj"];
    $cutword = $GLOBALS["PLUSVARS"]["cutword"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $catid = $GLOBALS["PLUSVARS"]["catid"];
    $projid = $GLOBALS["PLUSVARS"]["projid"];
    $tags = $GLOBALS["PLUSVARS"]["tags"];
    $pagename = $GLOBALS["PLUSVARS"]["pagename"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    //ĬÈÏÌõ¼þ
    $scl = " iffb='1' and catid!='0' ";
    if ($showtj != "" && $showtj != "0") {
        $scl .= " and tj='1' ";
    }
    //Æ¥Åä·ÖÀà
    if ($catid != 0 && $catid != "") {
        $catid = fmpath($catid);
        $scl .= " and catpath regexp '{$catid}' ";
    }
    //Æ¥ÅäרÌâ
    if ($projid != 0 && $projid != "") {
        $projid = fmpath($projid);
        $scl .= " and proj regexp '{$projid}' ";
    }
    //ÅжÏÆ¥Åä±êÇ©
    if ($tags != "") {
        $tags = $tags . ",";
        $scl .= " and tags regexp '{$tags}' ";
    }
    //Ä£°æ½âÊÍ
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    //·­Ò³
    include ROOTPATH . "includes/pages.inc.php";
    $pages = new pages();
    $totalnums = TblCount("_down_con", "id", $scl);
    $pages->setvar(array("key" => $key));
    $pages->set($shownums, $totalnums);
    $pagelimit = $pages->limit();
    $picnum = 1;
    $fsql->query("select * from {P}_down_con where {$scl} order by {$ord} {$sc} limit {$pagelimit}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $catpath = $fsql->f('catpath');
        $dtime = $fsql->f('dtime');
        $nowcatid = $fsql->f('catid');
        $ifnew = $fsql->f('ifnew');
        $ifred = $fsql->f('ifred');
        $ifbold = $fsql->f('ifbold');
        $author = $fsql->f('author');
        $source = $fsql->f('source');
        $cl = $fsql->f('cl');
        $fileurl = $fsql->f('fileurl');
        $downcount = $fsql->f('downcount');
        $prop1 = $fsql->f('prop1');
        $prop2 = $fsql->f('prop2');
        $prop3 = $fsql->f('prop3');
        $prop4 = $fsql->f('prop4');
        $prop5 = $fsql->f('prop5');
        $prop6 = $fsql->f('prop6');
        $prop7 = $fsql->f('prop7');
        $prop8 = $fsql->f('prop8');
        $prop9 = $fsql->f('prop9');
        $prop10 = $fsql->f('prop10');
        $prop11 = $fsql->f('prop11');
        $prop12 = $fsql->f('prop12');
        $prop13 = $fsql->f('prop13');
        $prop14 = $fsql->f('prop14');
        $prop15 = $fsql->f('prop15');
        $prop16 = $fsql->f('prop16');
        $prop17 = $fsql->f('prop17');
        $prop18 = $fsql->f('prop18');
        $prop19 = $fsql->f('prop19');
        $prop20 = $fsql->f('prop20');
        $memo = $fsql->f('memo');
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "down/html/" . $id . ".html")) {
            $link = ROOTPATH . "down/html/" . $id . ".html";
        } else {
            $link = ROOTPATH . "down/html/?" . $id . ".html";
        }
        $dtime = date("Y-m-d H:i", $dtime);
        if ($ifbold == "1") {
            $bold = " style='font-weight:bold' ";
        } else {
            $bold = "";
        }
        if ($ifred != "0") {
            $red = " style='color:" . $ifred . "' ";
        } else {
            $red = "";
        }
        if ($cutword != "0") {
            $title = csubstr($title, 0, $cutword);
        }
        //ÏÔʾËùÊô·ÖÀà
        $msql->query("select cat from {P}_down_cat where catid='{$nowcatid}'");
        if ($msql->next_record()) {
            $cat = $msql->f('cat');
        }
        //Ä£°æ±êÇ©½âÊÍ
        $var = array('title' => $title, 'memo' => $memo, 'dtime' => $dtime, 'red' => $red, 'bold' => $bold, 'link' => $link, 'target' => $target, 'author' => $author, 'source' => $source, 'cat' => $cat, 'cl' => $cl, 'fileurl' => $fileurl, 'downcount' => $downcount, 'prop1' => $prop1, 'prop2' => $prop2, 'prop3' => $prop3, 'prop4' => $prop4, 'prop5' => $prop5, 'prop6' => $prop6, 'prop7' => $prop7, 'prop8' => $prop8, 'prop9' => $prop9, 'prop10' => $prop10, 'prop11' => $prop11, 'prop12' => $prop12, 'prop13' => $prop13, 'prop14' => $prop14, 'prop15' => $prop15, 'prop16' => $prop16, 'prop17' => $prop17, 'prop18' => $prop18, 'prop19' => $prop19, 'prop20' => $prop20, 'propname1' => $propname1, 'propname2' => $propname2, 'propname3' => $propname3, 'propname4' => $propname4, 'propname5' => $propname5, 'propname6' => $propname6, 'propname7' => $propname7, 'propname8' => $propname8, 'propname9' => $propname9, 'propname10' => $propname10, 'propname11' => $propname11, 'propname12' => $propname12, 'propname13' => $propname13, 'propname14' => $propname14, 'propname15' => $propname15, 'propname16' => $propname16, 'propname17' => $propname17, 'propname18' => $propname18, 'propname19' => $propname19, 'propname20' => $propname20);
        $str .= ShowTplTemp($TempArr["list"], $var);
        $picnum++;
    }
    $str .= $TempArr["end"];
    $pagesinfo = $pages->ShowNow();
    $var = array('showpages' => $pages->output(1), 'pagestotal' => $pagesinfo["total"], 'pagesnow' => $pagesinfo["now"], 'pagesshownum' => $pagesinfo["shownum"], 'pagesfrom' => $pagesinfo["from"], 'pagesto' => $pagesinfo["to"], 'totalnums' => $totalnums);
    $str = ShowTplTemp($str, $var);
    return $str;
}
Ejemplo n.º 20
0
function PhotoCarousel()
{
    global $fsql, $msql;
    $coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
    $showtj = $GLOBALS["PLUSVARS"]["showtj"];
    $cutword = $GLOBALS["PLUSVARS"]["cutword"];
    $cutbody = $GLOBALS["PLUSVARS"]["cutbody"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $catid = $GLOBALS["PLUSVARS"]["catid"];
    $projid = $GLOBALS["PLUSVARS"]["projid"];
    $tags = $GLOBALS["PLUSVARS"]["tags"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $tempcolor = $GLOBALS["PLUSVARS"]["tempcolor"];
    //本插件固定3张图片
    $shownums = 6;
    //默认条件
    $scl = " iffb='1' and catid!='0' ";
    if ($showtj != "" && $showtj != "0") {
        $scl .= " and tj='1' ";
    }
    //显示分类规则:如果后台不指定分类,则显示当前所在分类,否则不限分类
    if ($catid != 0 && $catid != "") {
        $catid = fmpath($catid);
        $scl .= " and catpath regexp '{$catid}' ";
    }
    //匹配专题
    if ($projid != 0 && $projid != "") {
        $projid = fmpath($projid);
        $scl .= " and proj regexp '{$projid}' ";
    }
    //判断匹配标签
    if ($tags != "") {
        $tags = $tags . ",";
        $scl .= " and tags regexp '{$tags}' ";
    }
    //模版解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $var = array('coltitle' => $coltitle, 'tempcolor' => $tempcolor);
    $str = ShowTplTemp($TempArr["start"], $var);
    $fsql->query("select * from {P}_photo_con where {$scl} order by uptime desc limit 0,{$shownums}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $catpath = $fsql->f('catpath');
        $dtime = $fsql->f('dtime');
        $nowcatid = $fsql->f('catid');
        $ifnew = $fsql->f('ifnew');
        $ifred = $fsql->f('ifred');
        $ifbold = $fsql->f('ifbold');
        $author = $fsql->f('author');
        $source = $fsql->f('source');
        $cl = $fsql->f('cl');
        $src[] = $fsql->f('src');
        $memo = $fsql->f('memo');
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "photo/html/" . $id . ".html")) {
            $link[] = ROOTPATH . "photo/html/" . $id . ".html";
        } else {
            $link[] = ROOTPATH . "photo/html/?" . $id . ".html";
        }
        if ($cutword != "0") {
            $title = csubstr($title, 0, $cutword);
        }
        if ($cutbody != "0") {
            $memo = csubstr($memo, 0, $cutbody);
        }
        //if($src==""){$src="photo/pics/nopic.gif";}
    }
    //模版标签解释
    $var = array('src1' => ROOTPATH . $src[0], 'src2' => ROOTPATH . $src[1], 'src3' => ROOTPATH . $src[2], 'src4' => ROOTPATH . $src[3], 'src5' => ROOTPATH . $src[4], 'src6' => ROOTPATH . $src[5], 'link1' => ROOTPATH . $link[0], 'link2' => ROOTPATH . $link[1], 'link3' => ROOTPATH . $link[2], 'link4' => ROOTPATH . $link[3], 'link5' => ROOTPATH . $link[4], 'link6' => ROOTPATH . $link[5]);
    $str .= ShowTplTemp($TempArr["list"], $var);
    $str .= $TempArr["end"];
    return $str;
}
Ejemplo n.º 21
0
    }
    if ($ifchannel != 0) {
        err($strProductNotice9, "", "");
        exit;
    }
    $msql->query("delete from {P}_product_cat where catid='{$catid}'");
}
if ($step == "modi") {
    $cat = $_GET["cat"];
    $catid = $_GET["catid"];
    $pid = $_GET["pid"];
    $xuhao = $_GET["xuhao"];
    $tj = $_GET["tj"];
    $cat = htmlspecialchars($cat);
    $msql->query("update {P}_product_cat set cat='{$cat}',xuhao='{$xuhao}' where catid='{$catid}' ");
    $msql->query("update {P}_product_cat set tj='{$tj}' where catpath regexp '" . fmpath($catid) . "' ");
}
?>
 
<div class="searchzone">
<table width="100%" border="0" cellspacing="0" cellpadding="2" height="30">
  <tr> 
   
                  
      <td width="80"  height="30"> 
	  <select name="pid" onChange="self.location=this.options[this.selectedIndex].value">
	  <option value='product_cat.php'><?php 
echo $strProductSelCat;
?>
</option>
         <?php 
Ejemplo n.º 22
0
function DownAuthorList()
{
    global $fsql, $msql;
    $shownums = $GLOBALS["PLUSVARS"]["shownums"];
    $showtj = $GLOBALS["PLUSVARS"]["showtj"];
    $cutword = $GLOBALS["PLUSVARS"]["cutword"];
    $catid = $GLOBALS["PLUSVARS"]["catid"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    //获取地址栏参数
    if (strstr($_SERVER["QUERY_STRING"], ".html")) {
        $idArr = explode(".html", $_SERVER["QUERY_STRING"]);
        $id = $idArr[0];
    } elseif (isset($_GET["id"]) && $_GET["id"] != "") {
        $id = $_GET["id"];
    }
    $id = htmlspecialchars($id);
    //查找条件
    $fsql->query("select memberid from {P}_down_con where id='{$id}'");
    if ($fsql->next_record()) {
        $authormemberid = $fsql->f('memberid');
    }
    $scl = " iffb='1' and catid!='0' and memberid='{$authormemberid}' ";
    if ($showtj != "" && $showtj != "0") {
        $scl .= " and tj='1' ";
    }
    //显示分类规则:如果后台不指定分类,则不限分类
    if ($catid != 0 && $catid != "") {
        $catid = fmpath($catid);
        $scl .= " and catpath regexp '{$catid}' ";
    }
    //模版解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    $picnum = 1;
    $fsql->query("select * from {P}_down_con where {$scl} order by uptime desc limit 0,{$shownums}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $catpath = $fsql->f('catpath');
        $dtime = $fsql->f('dtime');
        $nowcatid = $fsql->f('catid');
        $ifnew = $fsql->f('ifnew');
        $ifred = $fsql->f('ifred');
        $ifbold = $fsql->f('ifbold');
        $author = $fsql->f('author');
        $source = $fsql->f('source');
        $cl = $fsql->f('cl');
        $src = $fsql->f('src');
        $cl = $fsql->f('cl');
        $fileurl = $fsql->f('fileurl');
        $downcount = $fsql->f('downcount');
        $prop1 = $fsql->f('prop1');
        $prop2 = $fsql->f('prop2');
        $prop3 = $fsql->f('prop3');
        $prop4 = $fsql->f('prop4');
        $prop5 = $fsql->f('prop5');
        $prop6 = $fsql->f('prop6');
        $prop7 = $fsql->f('prop7');
        $prop8 = $fsql->f('prop8');
        $prop9 = $fsql->f('prop9');
        $prop10 = $fsql->f('prop10');
        $prop11 = $fsql->f('prop11');
        $prop12 = $fsql->f('prop12');
        $prop13 = $fsql->f('prop13');
        $prop14 = $fsql->f('prop14');
        $prop15 = $fsql->f('prop15');
        $prop16 = $fsql->f('prop16');
        $prop17 = $fsql->f('prop17');
        $prop18 = $fsql->f('prop18');
        $prop19 = $fsql->f('prop19');
        $prop20 = $fsql->f('prop20');
        $memo = $fsql->f('memo');
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "down/html/" . $id . ".html")) {
            $link = ROOTPATH . "down/html/" . $id . ".html";
        } else {
            $link = ROOTPATH . "down/html/?" . $id . ".html";
        }
        $dtime = date("Y-m-d", $dtime);
        if ($ifbold == "1") {
            $bold = " style='font-weight:bold' ";
        } else {
            $bold = "";
        }
        if ($ifred != "0") {
            $red = " style='color:" . $ifred . "' ";
        } else {
            $red = "";
        }
        if ($cutword != "0") {
            $title = csubstr($title, 0, $cutword);
        }
        //模版标签解释
        $var = array('title' => $title, 'memo' => $memo, 'dtime' => $dtime, 'red' => $red, 'bold' => $bold, 'link' => $link, 'target' => $target, 'author' => $author, 'source' => $source, 'cat' => $cat, 'catstr' => $catstr, 'src' => $src, 'cl' => $cl, 'picnum' => $picnum, 'fileurl' => $fileurl, 'downcount' => $downcount, 'prop1' => $prop1, 'prop2' => $prop2, 'prop3' => $prop3, 'prop4' => $prop4, 'prop5' => $prop5, 'prop6' => $prop6, 'prop7' => $prop7, 'prop8' => $prop8, 'prop9' => $prop9, 'prop10' => $prop10, 'prop11' => $prop11, 'prop12' => $prop12, 'prop13' => $prop13, 'prop14' => $prop14, 'prop15' => $prop15, 'prop16' => $prop16, 'prop17' => $prop17, 'prop18' => $prop18, 'prop19' => $prop19, 'prop20' => $prop20, 'propname1' => $propname1, 'propname2' => $propname2, 'propname3' => $propname3, 'propname4' => $propname4, 'propname5' => $propname5, 'propname6' => $propname6, 'propname7' => $propname7, 'propname8' => $propname8, 'propname9' => $propname9, 'propname10' => $propname10, 'propname11' => $propname11, 'propname12' => $propname12, 'propname13' => $propname13, 'propname14' => $propname14, 'propname15' => $propname15, 'propname16' => $propname16, 'propname17' => $propname17, 'propname18' => $propname18, 'propname19' => $propname19, 'propname20' => $propname20);
        $str .= ShowTplTemp($TempArr["list"], $var);
        $picnum++;
    }
    $str .= $TempArr["end"];
    return $str;
}
Ejemplo n.º 23
0
function ProductShiftdolphin()
{
    global $fsql, $msql;
    $coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
    $shownums = $GLOBALS["PLUSVARS"]["shownums"];
    $ord = $GLOBALS["PLUSVARS"]["ord"];
    $sc = $GLOBALS["PLUSVARS"]["sc"];
    $showtj = $GLOBALS["PLUSVARS"]["showtj"];
    $cutword = $GLOBALS["PLUSVARS"]["cutword"];
    $cutbody = $GLOBALS["PLUSVARS"]["cutbody"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $catid = $GLOBALS["PLUSVARS"]["catid"];
    $tags = $GLOBALS["PLUSVARS"]["tags"];
    $pagename = $GLOBALS["PLUSVARS"]["pagename"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $picw = $GLOBALS["PLUSVARS"]["picw"];
    $pich = $GLOBALS["PLUSVARS"]["pich"];
    $fittype = $GLOBALS["PLUSVARS"]["fittype"];
    $scl = " iffb='1' and catid!='0' ";
    if ($showtj != "" && $showtj != "0") {
        $scl .= " and tj='1' ";
    }
    //显示分类规则:如果后台不指定分类,则显示当前所在分类,否则不限分类
    if ($catid != 0 && $catid != "") {
        $catid = fmpath($catid);
        $scl .= " and catpath regexp '{$catid}' ";
    }
    $pos = strrpos($catid, '0');
    $str = substr($catid, $pos + 1);
    $n = intval($str) * 20;
    $m = $n + 1;
    //模版解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $var = array('coltitle' => $coltitle, 'morelink' => $morelink, 'm' => $m);
    $str = ShowTplTemp($TempArr["start"], $var);
    $picnum = 1;
    $fsql->query("select * from {P}_product_con where {$scl} order by {$ord} {$sc} limit 0,{$shownums}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $catpath = $fsql->f('catpath');
        $dtime = $fsql->f('dtime');
        $nowcatid = $fsql->f('catid');
        $ifnew = $fsql->f('ifnew');
        $ifred = $fsql->f('ifred');
        $ifbold = $fsql->f('ifbold');
        $author = $fsql->f('author');
        $source = $fsql->f('source');
        $cl = $fsql->f('cl');
        $src = $fsql->f('src');
        $cl = $fsql->f('cl');
        $memo = $fsql->f('memo');
        $n++;
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "product/html/" . $id . ".html")) {
            $link = ROOTPATH . "product/html/" . $id . ".html";
        } else {
            $link = ROOTPATH . "product/html/?" . $id . ".html";
        }
        $dtime = date("Y-m-d", $dtime);
        if ($cutword != "0") {
            $title = csubstr($title, 0, $cutword);
        }
        if ($cutbody != "0") {
            $memo = csubstr($memo, 0, $cutbody);
        }
        if ($src == "") {
            $src = "product/pics/nopic.gif";
        }
        $src = ROOTPATH . $src;
        //模版标签解释
        $var = array('title' => $title, 'memo' => $memo, 'propstr' => $propstr, 'dtime' => $dtime, 'link' => $link, 'target' => $target, 'author' => $author, 'source' => $source, 'cat' => $cat, 'catid' => $catid, 'src' => $src, 'picw' => $picw, 'pich' => $pich, 'cl' => $cl, 'n' => $n);
        $str .= ShowTplTemp($TempArr["list"], $var);
        $picnum++;
    }
    $var = array('fittype' => $fittype);
    $str .= ShowTplTemp($TempArr["end"], $var);
    return $str;
}