Example #1
0
function MemberFav()
{
    global $fsql, $tsql;
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $memberid = $_COOKIE["MEMBERID"];
    $scl = " memberid='{$memberid}' ";
    //Ä£°å½âÊÍ
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    include ROOTPATH . "includes/pages.inc.php";
    $pages = new pages();
    $totalnums = TblCount("_member_fav", "id", $scl);
    $pages->setvar(array("key" => $key));
    $pages->set(20, $totalnums);
    $pagelimit = $pages->limit();
    $fsql->query("select * from {P}_member_fav where {$scl} order by id desc limit {$pagelimit}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $url = $fsql->f('url');
        $var = array('id' => $id, 'title' => $title, 'url' => $url);
        $str .= ShowTplTemp($TempArr["list"], $var);
    }
    $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($TempArr["end"], $var);
    return $str;
}
Example #2
0
function MemberCentLog()
{
    global $msql, $fsql, $strCentFormAdmin;
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $memberid = $_COOKIE["MEMBERID"];
    //模板解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    //取出当前积分
    $msql->query("select * from {P}_member where memberid='" . $_COOKIE["MEMBERID"] . "'");
    if ($msql->next_record()) {
        $cent1 = $msql->f('cent1');
        $cent2 = $msql->f('cent2');
        $cent3 = $msql->f('cent3');
        $cent4 = $msql->f('cent4');
        $cent5 = $msql->f('cent5');
    }
    $cw1 = MemberCentWidth($cent1);
    $cw2 = MemberCentWidth($cent2);
    $cw3 = MemberCentWidth($cent3);
    $cw4 = MemberCentWidth($cent4);
    $cw5 = MemberCentWidth($cent5);
    $var = array('centname1' => $GLOBALS["MEMBERCONF"]["centname1"], 'centname2' => $GLOBALS["MEMBERCONF"]["centname2"], 'centname3' => $GLOBALS["MEMBERCONF"]["centname3"], 'centname4' => $GLOBALS["MEMBERCONF"]["centname4"], 'centname5' => $GLOBALS["MEMBERCONF"]["centname5"], 'cw1' => $cw1, 'cw2' => $cw2, 'cw3' => $cw3, 'cw4' => $cw4, 'cw5' => $cw5, 'cent1' => $cent1, 'cent2' => $cent2, 'cent3' => $cent3, 'cent4' => $cent4, 'cent5' => $cent5);
    $str = ShowTplTemp($TempArr["start"], $var);
    $scl = " memberid='{$memberid}' ";
    include ROOTPATH . "includes/pages.inc.php";
    $pages = new pages();
    $totalnums = TblCount("_member_centlog", "id", $scl);
    $pages->setvar(array("key" => $key));
    $pages->set(20, $totalnums);
    $pagelimit = $pages->limit();
    $msql->query("select * from {P}_member_centlog where {$scl} order by dtime desc limit {$pagelimit}");
    while ($msql->next_record()) {
        $id = $msql->f('id');
        $event = $msql->f('event');
        $dtime = $msql->f('dtime');
        $cent1 = $msql->f('cent1');
        $cent2 = $msql->f('cent2');
        $cent3 = $msql->f('cent3');
        $cent4 = $msql->f('cent4');
        $cent5 = $msql->f('cent5');
        $memo = $msql->f('memo');
        if ($event == "0") {
            $eventname = $memo;
        } else {
            $fsql->query("select name from {P}_member_centrule where event='{$event}' ");
            if ($fsql->next_record()) {
                $eventname = $fsql->f('name');
            }
        }
        $dtime = date("Y/m/d H:i:s", $dtime);
        $var = array('id' => $id, 'eventname' => $eventname, 'dtime' => $dtime, 'cent1' => $cent1, 'cent2' => $cent2, 'cent3' => $cent3, 'cent4' => $cent4, 'cent5' => $cent5);
        $str .= ShowTplTemp($TempArr["list"], $var);
    }
    $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($TempArr["end"], $var);
    return $str;
}
Example #3
0
function MemberComment()
{
    global $fsql, $tsql;
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $memberid = $_COOKIE["MEMBERID"];
    $scl = " pid='0' and memberid='{$memberid}' ";
    //模板解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    include ROOTPATH . "includes/pages.inc.php";
    $pages = new pages();
    $totalnums = TblCount("_comment", "id", $scl);
    $pages->setvar(array("key" => $key));
    $pages->set(20, $totalnums);
    $pagelimit = $pages->limit();
    $fsql->query("select * from {P}_comment where {$scl} order by uptime desc limit {$pagelimit}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $title = $fsql->f('title');
        $iffb = $fsql->f('iffb');
        $rid = $fsql->f('rid');
        $catid = $fsql->f('catid');
        $dtime = $fsql->f('dtime');
        $uptime = $fsql->f('uptime');
        $cl = $fsql->f('cl');
        $lastname = $fsql->f('lastname');
        $lastmemberid = $fsql->f('lastmemberid');
        $backcount = $fsql->f('backcount');
        $title = csubstr($title, 0, 23);
        //是否今日新贴
        if ($uptime > time() - 86400) {
            $querycss = "binew";
        } else {
            $querycss = "bi";
        }
        $dtime = date("Y-m-d", $dtime);
        $uptime = date("Y-m-d", $uptime);
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "comment/html/" . $id . ".html")) {
            $link = ROOTPATH . "comment/html/" . $id . ".html";
        } else {
            $link = ROOTPATH . "comment/html/?" . $id . ".html";
        }
        //回复者网址
        if ($lastmemberid == "-1") {
            $lastmemberurl = "#";
        } else {
            $lastmemberurl = ROOTPATH . "member/home.php?mid=" . $lastmemberid;
        }
        $var = array('id' => $id, 'title' => $title, 'dtime' => $dtime, 'uptime' => $uptime, 'backcount' => $backcount, 'querycss' => $querycss, 'cl' => $cl, 'link' => $link, 'lastname' => $lastname, 'lastmemberurl' => $lastmemberurl, 'face' => $face);
        $str .= ShowTplTemp($TempArr["list"], $var);
    }
    $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($TempArr["end"], $var);
    return $str;
}
Example #4
0
function MemberMsn()
{
    global $fsql, $tsql, $strMemberMsnNtc2;
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $memberid = $_COOKIE["MEMBERID"];
    $scl = " tomemberid='{$memberid}' ";
    //模板解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    include ROOTPATH . "includes/pages.inc.php";
    $pages = new pages();
    $totalnums = TblCount("_member_msn", "id", $scl);
    $pages->setvar(array("key" => $key));
    $pages->set(10, $totalnums);
    $pagelimit = $pages->limit();
    $fsql->query("select * from {P}_member_msn where {$scl} order by dtime desc limit {$pagelimit}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $body = $fsql->f('body');
        $dtime = $fsql->f('dtime');
        $frommemberid = $fsql->f('frommemberid');
        $dtime = date("Y-m-d h:i:s", $dtime);
        $body = nl2br($body);
        if ($frommemberid != "0") {
            $tsql->query("select * from {P}_member where memberid='{$frommemberid}'");
            if ($tsql->next_record()) {
                $pname = $tsql->f("pname");
                $nowface = $tsql->f("nowface");
            }
            $face = ROOTPATH . "member/face/" . $nowface . ".gif";
            $memberurl = ROOTPATH . "member/home.php?mid=" . $frommemberid;
            $showback = "block";
        } else {
            $pname = $strMemberMsnNtc2;
            $face = ROOTPATH . "member/face/1.gif";
            $memberurl = "#";
            $showback = "none";
        }
        $var = array('id' => $id, 'body' => $body, 'dtime' => $dtime, 'mid' => $frommemberid, 'face' => $face, 'memberurl' => $memberurl, 'showback' => $showback, 'pname' => $pname);
        $str .= ShowTplTemp($TempArr["list"], $var);
    }
    //标注为已读
    $tsql->query("update {P}_member_msn set iflook='1' where tomemberid='{$memberid}'");
    $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($TempArr["end"], $var);
    return $str;
}
Example #5
0
function MemberBuyList()
{
    global $msql, $fsql;
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $memberid = $_COOKIE["MEMBERID"];
    //模板解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    //取出当前帐户信息
    $msql->query("select * from {P}_member where memberid='" . $_COOKIE["MEMBERID"] . "'");
    if ($msql->next_record()) {
        $account = $msql->f('account');
        $paytotal = $msql->f('paytotal');
        $buytotal = $msql->f('buytotal');
    }
    $var = array('account' => $account, 'paytotal' => $paytotal, 'buytotal' => $buytotal);
    $str = ShowTplTemp($TempArr["start"], $var);
    $scl = " memberid='{$memberid}' ";
    include ROOTPATH . "includes/pages.inc.php";
    $pages = new pages();
    $totalnums = TblCount("_member_buylist", "id", $scl);
    $pages->setvar(array("key" => $key));
    $pages->set(20, $totalnums);
    $pagelimit = $pages->limit();
    $msql->query("select * from {P}_member_buylist where {$scl} order by id desc limit {$pagelimit}");
    while ($msql->next_record()) {
        $id = $msql->f('id');
        $payid = $msql->f('payid');
        $paytype = $msql->f('paytype');
        $buyfrom = $msql->f('buyfrom');
        $paytotal = $msql->f('paytotal');
        $daytime = $msql->f('daytime');
        $ip = $msql->f('ip');
        $orderid = $msql->f('orderid');
        $OrderNo = $msql->f('OrderNo');
        $logname = $msql->f('logname');
        $daytime = date("Y-n-j H:i:s", $daytime);
        $var = array('id' => $id, 'payid' => $payid, 'paytype' => $paytype, 'buyfrom' => $buyfrom, 'paytotal' => $paytotal, 'daytime' => $daytime, 'ip' => $ip, 'OrderNo' => $OrderNo, 'logname' => $logname, 'orderid' => $orderid);
        $str .= ShowTplTemp($TempArr["list"], $var);
    }
    $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($TempArr["end"], $var);
    return $str;
}
Example #6
0
    $sc = "desc";
}
$scl = " id!='0' ";
if ($key != "") {
    $scl .= " and (title regexp '{$key}' or body regexp '{$key}') ";
}
if ($showtj != "" && $showtj != "all") {
    $scl .= " and tj='{$showtj}' ";
}
if ($showfb != "" && $showfb != "all") {
    $scl .= " and iffb='{$showfb}' ";
}
if ($gid != "" && $pid != "0") {
    $scl .= " and poll_id='{$gid}' ";
}
$totalnums = TblCount("_tools_photopolldata", "id", $scl);
$pages = new pages();
$pages->setvar(array("shownum" => $shownum, "gid" => $gid, "sc" => $sc, "ord" => $ord, "showtj" => $showtj, "showfb" => $showfb, "key" => $key));
$pages->set($shownum, $totalnums);
$pagelimit = $pages->limit();
?>

<!----------------------------图片搜索部分----------------------------------> 
<div class="searchzone">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="30">
  <tr> 
    <form method="get" action="photopoll_con.php" >
                  
      <td  height="30"> 
        <select name="gid">
          <option value='all'><?php 
Example #7
0
      </form>
	  <div  id="notice" class="noticediv"></div>
	  </td>
      
    
  </tr>
</table>
</div>


<?php 
$scl = "  id!='0' ";
if ($key != "") {
    $scl .= " and project regexp '{$key}'  ";
}
$totalnums = TblCount("_news_proj", "id", $scl);
$pages = new pages();
$pages->setvar(array("key" => $key));
$pages->set(10, $totalnums);
$pagelimit = $pages->limit();
?>
<div class="listzone">
<table width="100%" border="0" cellspacing="0" cellpadding="5" align="center">
  <tr>
    <td  class="biaoti" width="50" align="center"><?php 
echo $strNumber;
?>
</td>
    <td  class="biaoti" width="130" height="26"><?php 
echo $strProjName;
?>
Example #8
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;
}
Example #9
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;
}
Example #10
0
function ToolsPhotoPollQuery()
{
    global $fsql, $msql;
    $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"];
    $poll_id = $GLOBALS["PLUSVARS"]["catid"];
    $ord = $GLOBALS["PLUSVARS"]["ord"];
    $key = $_GET["key"];
    $showtj = $_GET["showtj"];
    $page = $_GET["page"];
    //Ä£°æ½âÊÍ
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    $scl = " iffb='1' and poll_id!='0' ";
    if ($poll_id != "0" && $poll_id != "") {
        $scl .= " and poll_id='{$poll_id}' ";
    }
    if ($showtj != "" && $showtj != "all") {
        $scl .= " and tj='{$showtj}' ";
    }
    if ($key != "") {
        $scl .= " and (title regexp '{$key}' or body regexp '{$key}') ";
    }
    include ROOTPATH . "includes/pages.inc.php";
    $pages = new pages();
    $totalnums = TblCount("_tools_photopolldata", "id", $scl);
    $pages->setvar(array("catid" => $catid, "ord" => $ord, "shownums" => $shownums, "showtj" => $showtj, "author" => $author, "key" => $key));
    $pages->set($shownums, $totalnums);
    $pagelimit = $pages->limit();
    $fsql->query("select * from {P}_tools_photopolldata where {$scl} order by {$ord} desc limit {$pagelimit}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $catid = $fsql->f('poll_id');
        $title = $fsql->f('title');
        $dtime = $fsql->f('dtime');
        $author = $fsql->f('author');
        $type = $fsql->f('type');
        $src = $fsql->f('src');
        $body = $fsql->f('body');
        $votesinfo = $fsql->f('votesinfo');
        $votes = $fsql->f('votes');
        $dtime = date("Y-m-d", $dtime);
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists("../html/" . $id . ".html")) {
            $link = "../html/" . $id . ".html";
        } else {
            $link = "../html/?" . $id . ".html";
        }
        if ($cutword != "0") {
            $title = csubstr($title, 0, $cutword);
        }
        if ($src == "") {
            $src = "photo/pics/nopic.gif";
        }
        $src = ROOTPATH . $src;
        $var = array('id' => $id, 'title' => $title, 'dtime' => $dtime, 'red' => $red, 'author' => $author, 'src' => $src, 'link' => $link, 'target' => $target, 'body' => $body, 'picw' => $picw, 'pich' => $pich, 'votes' => $votes, 'catid' => $catid);
        $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;
}
Example #11
0
</title>
</head>

<body >

<?php 
$step = $_REQUEST["step"];
$memberid = $_REQUEST["memberid"];
$id = $_REQUEST["id"];
if ($memberid == "") {
    echo "ERROR:NO MEMBERID";
    exit;
}
//查询
$scl = " memberid='{$memberid}' ";
$totalnums = TblCount("_member_buylist", "id", $scl);
$pages = new pages();
$pages->setvar(array("memberid" => $memberid));
$pages->set(20, $totalnums);
$pagelimit = $pages->limit();
?>
<div class="formzone">
<div class="namezone" ><?php 
echo $strAccBuyList;
?>
 - [ <?php 
echo Memberid2User($memberid);
?>
 ]</div>

<div class="tablezone">
Example #12
0
<?php 
if (!isset($fromM) || !isset($toM)) {
    $fromY = date("Y", time());
    $fromM = date("n", time());
    $fromD = date("j", time());
    $toY = date("Y", time());
    $toM = date("n", time());
    $toD = date("j", time());
}
$fromtime = mktime(0, 0, 0, $fromM, $fromD, $fromY);
$totime = mktime(23, 59, 59, $toM, $toD, $toY);
$scl = " time>={$fromtime} and time<={$totime} ";
if ($key != "") {
    $scl .= " and urlform  regexp '{$key}' ";
}
$totalnums = TblCount("_tools_statcount", "id", $scl);
$pages = new pages();
$pages->setvar(array("key" => $key, "tp" => $tp, "fromY" => $fromY, "fromM" => $fromM, "fromD" => $fromD, "toY" => $toY, "toM" => $toM, "toD" => $toD));
$pages->set(10, $totalnums);
$pagelimit = $pages->limit();
?>
<div class="tablezone">
<table width="100%" border="0" cellpadding="5" cellspacing="0">
    <tr> 
      <td  class="innerbiaoti" width="160" height="25"><?php 
echo $strStatFtime;
?>
</td>
      <td  class="innerbiaoti" width="100" height="25"><?php 
echo $strStatFIP;
?>
Example #13
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;
}
Example #14
0
function MemberPhotoQuery()
{
    global $fsql, $msql;
    $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"];
    //µØÖ·À¸²ÎÊý
    if (isset($_GET["mid"]) && $_GET["mid"] != "" && $_GET["mid"] != "0") {
        $mid = $_GET["mid"];
    } else {
        return "";
    }
    $key = $_GET["key"];
    $page = $_GET["page"];
    $myord = $_GET["myord"];
    $myshownums = $_GET["myshownums"];
    $showtag = $_GET["showtag"];
    $pcatid = $_GET["pcatid"];
    if ($myord == "") {
        $myord = "uptime";
    }
    if ($myshownums != "" && $myshownums != "0") {
        $shownums = $myshownums;
    }
    //Ä£°æ½âÊÍ
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    //ĬÈÏÌõ¼þ
    $scl = " iffb='1' and memberid='{$mid}' ";
    if ($pcatid != "0" && $pcatid != "") {
        $scl .= " and pcatid='{$pcatid}' ";
    }
    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("_photo_con", "id", $scl);
    $pages->setvar(array("mid" => $mid, "pcatid" => $pcatid, "myord" => $myord, "myshownums" => $myshownums, "key" => $key));
    $pages->set($shownums, $totalnums);
    $pagelimit = $pages->limit();
    $fsql->query("select * from {P}_photo_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');
        $memo = $fsql->f('memo');
        $dtime = date("Y-m-d", $dtime);
        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 ($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, 'dtime' => $dtime, 'red' => $red, 'author' => $author, 'source' => $source, 'src' => $src, 'picw' => $picw, 'pich' => $pich, 'cl' => $cl, 'link' => $link, 'target' => $target, 'memo' => $memo, '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;
}
Example #15
0
      </form>
	  <div  id="notice" class="noticediv"></div>
	  </td>
      
    
  </tr>
</table>
</div>


<?php 
$scl = "  id!='0' ";
if ($key != "") {
    $scl .= " and project regexp '{$key}'  ";
}
$totalnums = TblCount("_photo_proj", "id", $scl);
$pages = new pages();
$pages->setvar(array("key" => $key));
$pages->set(10, $totalnums);
$pagelimit = $pages->limit();
?>
<div class="listzone">
<table width="100%" border="0" cellspacing="0" cellpadding="5" align="center">
  <tr>
    <td  class="biaoti" width="50" align="center"><?php 
echo $strNumber;
?>
</td>
    <td  class="biaoti" width="130" height="26"><?php 
echo $strProjName;
?>
Example #16
0
    $sc = "desc";
}
$scl = " memberid!='0' ";
if ($membertypeid != "" && $membertypeid != "0") {
    $scl .= " and membertypeid='{$membertypeid}' ";
}
if ($showcheck != "" && $showcheck != "all") {
    $scl .= " and checked='{$showcheck}' ";
}
if ($showrz != "" && $showrz != "all") {
    $scl .= " and rz='{$showrz}' ";
}
if ($key != "") {
    $scl .= " and (name regexp '{$key}' or pname regexp '{$key}'  or user regexp '{$key}' or tags regexp '{$key}'  or tel regexp '{$key}' )";
}
$totalnums = TblCount("_member", "memberid", $scl);
$pages = new pages();
$pages->setvar(array("key" => $key, "shownum" => $shownum, "showcheck" => $showcheck, "showrz" => $showrz, "searchmodle" => $searchmodle, "ord" => $ord, "sc" => $sc, "membertypeid" => $membertypeid));
$pages->set($shownum, $totalnums);
$pagelimit = $pages->limit();
//根据查询类型显示不同列
switch ($searchmodle) {
    case "common":
        $colcommon = "";
        $colcent = "display:none";
        $colaccount = "display:none";
        break;
    case "cent":
        $colcommon = "display:none";
        $colcent = "";
        $colaccount = "display:none";
Example #17
0
function JobQuery()
{
    global $fsql, $msql;
    $shownums = $GLOBALS["PLUSVARS"]["shownums"];
    $cutword = $GLOBALS["PLUSVARS"]["cutword"];
    $cutbody = $GLOBALS["PLUSVARS"]["cutbody"];
    $target = $GLOBALS["PLUSVARS"]["target"];
    $tempname = $GLOBALS["PLUSVARS"]["tempname"];
    $key = $_GET["key"];
    $page = $_GET["page"];
    //模版解释
    $Temp = LoadTemp($tempname);
    $TempArr = SplitTblTemp($Temp);
    $str = $TempArr["start"];
    //默认条件
    $scl = " iffb='1' and jobstat='1' ";
    if ($key != "") {
        $scl .= " and (jobname regexp '{$key}' or jobintro regexp '{$key}') ";
    }
    include ROOTPATH . "includes/pages.inc.php";
    $pages = new pages();
    $totalnums = TblCount("_job", "id", $scl);
    $pages->setvar(array("key" => $key));
    $pages->set($shownums, $totalnums);
    $pagelimit = $pages->limit();
    $fsql->query("select * from {P}_job where {$scl} order by uptime desc limit {$pagelimit}");
    while ($fsql->next_record()) {
        $id = $fsql->f('id');
        $jobname = $fsql->f('jobname');
        $jobtype = $fsql->f('jobtype');
        $experience = $fsql->f('experience');
        $education = $fsql->f('education');
        $langneed = $fsql->f('langneed');
        $langlevel = $fsql->f('langlevel');
        $pnums = $fsql->f('pnums');
        $jobaddr = $fsql->f('jobaddr');
        $jobintro = $fsql->f('jobintro');
        $jobrequest = $fsql->f('jobrequest');
        $jobstat = $fsql->f('jobstat');
        $contact = $fsql->f('contact');
        $tel = $fsql->f('tel');
        $email = $fsql->f('email');
        $dtime = $fsql->f('dtime');
        $uptime = $fsql->f('uptime');
        $dtime = date("Y-m-d", $dtime);
        $uptime = date("Y-m-d", $uptime);
        if ($GLOBALS["CONF"]["CatchOpen"] == "1" && file_exists(ROOTPATH . "job/html/" . $id . ".html")) {
            $link = ROOTPATH . "job/html/" . $id . ".html";
        } else {
            $link = ROOTPATH . "job/html/?" . $id . ".html";
        }
        if ($cutword != "0") {
            $jobname = csubstr($jobname, 0, $cutword);
        }
        if ($cutbody != "0") {
            $jobintro = csubstr($jobintro, 0, $cutbody);
        }
        $jobintro = nl2br($jobintro);
        $jobrequest = nl2br($jobrequest);
        $var = array('jobid' => $id, 'jobname' => $jobname, 'dtime' => $dtime, 'uptime' => $uptime, 'jobtype' => $jobtype, 'experience' => $experience, 'education' => $education, 'langneed' => $langneed, 'langlevel' => $langlevel, 'pnums' => $pnums, 'jobaddr' => $jobaddr, 'jobintro' => $jobintro, 'jobrequest' => $jobrequest, 'link' => $link, 'target' => $target, 'contact' => $contact, 'tel' => $tel, 'email' => $email);
        $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;
}
Example #18
0
$memo = $_REQUEST["memo"];
$ip = $_SERVER["REMOTE_ADDR"];
$id = $_REQUEST["id"];
$fpnum = $_REQUEST["fpnum"];
$memo = $_REQUEST["memo"];
if ($memberid == "") {
    echo "ERROR:NO MEMBERID";
    exit;
}
if ($step == "modify") {
    NeedAuth(67);
    $msql->query("update {P}_member_pay set fpnum='{$fpnum}',memo='{$memo}' where id='{$id}' and memberid='{$memberid}'");
}
//查询
$scl = " memberid='{$memberid}' ";
$totalnums = TblCount("_member_pay", "id", $scl);
$pages = new pages();
$pages->setvar(array("memberid" => $memberid));
$pages->set(20, $totalnums);
$pagelimit = $pages->limit();
?>
<div class="formzone">
<div class="namezone" ><?php 
echo $strAccList;
?>
 - [ <?php 
echo Memberid2User($memberid);
?>
 ]</div>

<div class="tablezone">
Example #19
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;
}
Example #20
0
File: group.php Project: noikiy/cxe
      </form>
	  <div  id="notice" class="noticediv"></div>
	  </td>
      
    
  </tr>
</table>
</div>


<?php 
$scl = "  id!='0' ";
if ($key != "") {
    $scl .= " and groupname regexp '{$key}'  ";
}
$totalnums = TblCount("_feedback_group", "id", $scl);
$pages = new pages();
$pages->setvar(array("key" => $key));
$pages->set(10, $totalnums);
$pagelimit = $pages->limit();
?>
<div class="listzone">
<table width="100%" border="0" cellspacing="0" cellpadding="5" align="center">
  <tr>
    <td  class="biaoti" width="50" align="center"><?php 
echo $strNumber;
?>
</td>
    <td  class="biaoti" width="50"><?php 
echo $strXuhao;
?>
Example #21
0
      </form>
	  <div  id="notice" class="noticediv"></div>
	  </td>
      
    
  </tr>
</table>
</div>


<?php 
$scl = "  id!='0' ";
if ($key != "") {
    $scl .= " and project regexp '{$key}'  ";
}
$totalnums = TblCount("_down_proj", "id", $scl);
$pages = new pages();
$pages->setvar(array("key" => $key));
$pages->set(10, $totalnums);
$pagelimit = $pages->limit();
?>
<div class="listzone">
<table width="100%" border="0" cellspacing="0" cellpadding="5" align="center">
  <tr>
    <td  class="biaoti" width="50" align="center"><?php 
echo $strNumber;
?>
</td>
    <td  class="biaoti" width="130" height="26"><?php 
echo $strProjName;
?>
Example #22
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;
}
Example #23
0
      </form>
	  <div  id="notice" class="noticediv"></div>
	  </td>
      
    
  </tr>
</table>
</div>


<?php 
$scl = "  id!='0' ";
if ($key != "") {
    $scl .= " and project regexp '{$key}'  ";
}
$totalnums = TblCount("_product_proj", "id", $scl);
$pages = new pages();
$pages->setvar(array("key" => $key));
$pages->set(10, $totalnums);
$pagelimit = $pages->limit();
?>
<div class="listzone">
<table width="100%" border="0" cellspacing="0" cellpadding="5" align="center">
  <tr>
    <td  class="biaoti" width="50" align="center"><?php 
echo $strNumber;
?>
</td>
    <td  class="biaoti" width="130" height="26"><?php 
echo $strProjName;
?>
Example #24
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;
}
Example #25
0
File: qq.php Project: noikiy/cxe
    $ord = "uptime";
}
if (!isset($sc) || $sc == "") {
    $sc = "desc";
}
$scl = " id!='0' and cat='qq' ";
if ($showtj != "" && $showtj != "all") {
    $scl .= " and tj='{$showtj}' ";
}
if ($showfb != "" && $showfb != "all") {
    $scl .= " and iffb='{$showfb}' ";
}
if ($key != "") {
    $scl .= " and (qq regexp '{$key}' or name regexp '{$key}' or position regexp '{$key}' or memo regexp '{$key}') ";
}
$totalnums = TblCount("_tools_code", "id", $scl);
$pages = new pages();
$pages->setvar(array("shownum" => $shownum, "sc" => $sc, "ord" => $ord, "showtj" => $showtj, "showfb" => $showfb, "key" => $key));
$pages->set($shownum, $totalnums);
$pagelimit = $pages->limit();
?>

<!----------------------------QQ搜索部分----------------------------------> 
<div class="searchzone">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="30">
  <tr> 
    <form method="get" action="qq.php" >
                  
      <td width="84%"  height="30"><select name="showtj">
          <option value="all" ><?php 
echo $strVoteInfo4;