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;
}
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;
}
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;
}
function PageContentFy()
{
global $fsql;
$tempname = $GLOBALS["PLUSVARS"]["tempname"];
$pagename = $GLOBALS["PLUSVARS"]["pagename"];
//»ñÈ¡µØÖ·À¸²ÎÊý
if (strstr($_SERVER["QUERY_STRING"], ".html")) {
$idArr = explode(".html", $_SERVER["QUERY_STRING"]);
$id = $idArr[0];
$fsql->query("select groupid from {P}_page where id='{$id}'");
if ($fsql->next_record()) {
$groupid = $fsql->f('groupid');
}
} elseif (isset($_GET["id"]) && $_GET["id"] != "") {
$id = $_GET["id"];
$fsql->query("select groupid from {P}_page where id='{$id}'");
if ($fsql->next_record()) {
$groupid = $fsql->f('groupid');
}
} elseif (strstr($pagename, "_")) {
$arr = explode("_", $pagename);
$fsql->query("select id from {P}_page_group where folder='{$arr['0']}'");
if ($fsql->next_record()) {
$groupid = $fsql->f('id');
}
} else {
$fsql->query("select id from {P}_page_group where folder='{$pagename}'");
if ($fsql->next_record()) {
$groupid = $fsql->f('id');
}
}
//Ä£°æ½âÊÍ
$Temp = LoadTemp($tempname);
$i = 1;
$fsql->query("select id from {P}_page where groupid='{$groupid}' order by xuhao");
while ($fsql->next_record()) {
$parr[$i] = $fsql->f('id');
if ($parr[$i] == $id) {
$pcurrent = $i;
}
$i++;
}
$totalnums = $i - 1;
include ROOTPATH . "page/includes/contentpages.inc.php";
$pages = new pages();
$pages->setvar(array());
$pages->set(1, $totalnums, $parr, $pcurrent);
$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($Temp, $var);
return $str;
}
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;
}
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;
}
<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">
<table width="100%" border="0" cellspacing="0" cellpadding="5" align="center">
<tr>
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;
}
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;
}
$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;
?>
</td>
<td class="innerbiaoti" height="25"><?php
echo $strStatFUrl;
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
echo $strVoteInfo3;
?>
</option>
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 . ">";
}
}
}
$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;
}
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;
}
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;
}
function Search()
{
global $fsql, $strSearchNtc1;
$cutword = $GLOBALS["PLUSVARS"]["cutword"];
$target = $GLOBALS["PLUSVARS"]["target"];
$tempname = $GLOBALS["PLUSVARS"]["tempname"];
$key = htmlspecialchars($_GET["key"]);
$page = htmlspecialchars($_GET["page"]);
$myord = htmlspecialchars($_GET["myord"]);
$myshownums = htmlspecialchars($_GET["myshownums"]);
if ($myord != "id" && $myord != "xuhao" && $myord != "cl" && $myord != "uptime" && $myord != "dtime") {
$myord = "uptime";
}
if ($myshownums != "" && $myshownums != "0") {
$shownums = $myshownums;
} else {
$shownums = 20;
}
//判断模块是否安装
$fsql->query("select coltype from {P}_base_coltype");
while ($fsql->next_record()) {
$colarr[] = $fsql->f('coltype');
}
if ($key != "") {
if (in_array("news", $colarr) == true) {
$fsql->query("select count(id) from {P}_news_con where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}')");
if ($fsql->next_record()) {
$totalnums = $fsql->f('count(id)');
}
} else {
echo "文章模块未安装,全站搜索不可用";
exit;
}
if (in_array("comment", $colarr) == true) {
$fsql->query("select count(id) from {P}_comment where iffb='1' and pid='0' and (title regexp '{$key}' or body regexp '{$key}') ");
if ($fsql->next_record()) {
$totalnums += $fsql->f('count(id)');
}
}
if (in_array("photo", $colarr) == true) {
$fsql->query("select count(id) from {P}_photo_con where iffb='1' and catid!='0' and (title regexp '{$key}' or memo regexp '{$key}') ");
if ($fsql->next_record()) {
$totalnums += $fsql->f('count(id)');
}
}
if (in_array("down", $colarr) == true) {
$fsql->query("select count(id) from {P}_down_con where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}')");
if ($fsql->next_record()) {
$totalnums += $fsql->f('count(id)');
}
}
if (in_array("product", $colarr) == true) {
$fsql->query("select count(id) from {P}_product_con where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}')");
if ($fsql->next_record()) {
$totalnums += $fsql->f('count(id)');
}
}
if (in_array("shop", $colarr) == true) {
$fsql->query("select count(id) from {P}_shop_con where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}')");
if ($fsql->next_record()) {
$totalnums += $fsql->f('count(id)');
}
}
if (in_array("job", $colarr) == true) {
$fsql->query("select count(id) from {P}_job where iffb='1' and jobstat='1' and (jobname regexp '{$key}' or jobintro regexp '{$key}') ");
if ($fsql->next_record()) {
$totalnums += $fsql->f('count(id)');
}
}
if (in_array("bizinfo", $colarr) == true) {
$fsql->query("select count(id) from {P}_bizinfo_con where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}') ");
if ($fsql->next_record()) {
$totalnums += $fsql->f('count(id)');
}
}
if (in_array("zlinfo", $colarr) == true) {
$fsql->query("select count(id) from {P}_zlinfo_con where iffb='1' and catid!='0' and (fairname regexp '{$key}' or zldescrib regexp '{$key}') ");
if ($fsql->next_record()) {
$totalnums += $fsql->f('count(id)');
}
}
if (in_array("tech", $colarr) == true) {
$fsql->query("select count(id) from {P}_tech_offer where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}') ");
if ($fsql->next_record()) {
$totalnums += $fsql->f('count(id)');
}
$fsql->query("select count(id) from {P}_tech_demand where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}') ");
if ($fsql->next_record()) {
$totalnums += $fsql->f('count(id)');
}
}
if (in_array("news", $colarr) == true) {
$scl = " (select id,title,body,dtime,uptime,author,cl,contype from {P}_news_con where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}') ) ";
} else {
echo "文章模块未安装,全站搜索不可用";
exit;
}
if (in_array("comment", $colarr) == true) {
$scl .= " union (select id,title,body,dtime,uptime,pname as author,cl,contype from {P}_comment where iffb='1' and pid='0' and (title regexp '{$key}' or body regexp '{$key}') ) ";
}
if (in_array("photo", $colarr) == true) {
$scl .= " union (select id,title,memo,dtime,uptime,author,cl,contype from {P}_photo_con where iffb='1' and catid!='0' and (title regexp '{$key}' or memo regexp '{$key}') ) ";
}
if (in_array("down", $colarr) == true) {
$scl .= " union (select id,title,body,dtime,uptime,author,cl,contype from {P}_down_con where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}') ) ";
}
if (in_array("product", $colarr) == true) {
$scl .= " union (select id,title,body,dtime,uptime,author,cl,contype from {P}_product_con where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}') ) ";
}
if (in_array("shop", $colarr) == true) {
$scl .= " union (select id,title,body,dtime,uptime,author,cl,contype from {P}_shop_con where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}') ) ";
}
if (in_array("job", $colarr) == true) {
$scl .= " union (select id,jobname as title,jobintro as body,dtime,uptime,contact as author,cl,contype from {P}_job where iffb='1' and jobstat='1' and (jobname regexp '{$key}' or jobintro regexp '{$key}') ) ";
}
if (in_array("bizinfo", $colarr) == true) {
$scl .= " union (select id,title,body,dtime,uptime,company as author,cl,contype from {P}_bizinfo_con where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}') ) ";
}
if (in_array("zlinfo", $colarr) == true) {
$scl .= " union (select id,fairname as title,zldescrib as body,dtime,uptime,fabucompany as author,cl,contype from {P}_zlinfo_con where iffb='1' and catid!='0' and (fairname regexp '{$key}' or zldescrib regexp '{$key}') ) ";
}
if (in_array("tech", $colarr) == true) {
$scl .= " union (select id,title,body,dtime,uptime,company as author,cl,contype from {P}_tech_offer where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}') ) ";
$scl .= " union (select id,title,body,dtime,uptime,company as author,cl,contype from {P}_tech_demand where iffb='1' and catid!='0' and (title regexp '{$key}' or body regexp '{$key}') ) ";
}
} else {
return err($strSearchNtc1, "", "");
}
//模版解释
$Temp = LoadTemp($tempname);
$TempArr = SplitTblTemp($Temp);
$str = $TempArr["start"];
include ROOTPATH . "includes/pages.inc.php";
$pages = new pages();
$pages->setvar(array("catid" => $mycatid, "myord" => $myord, "myshownums" => $myshownums, "key" => $key));
$pages->set($shownums, $totalnums);
$pagelimit = $pages->limit();
$fsql->query($scl . " order by {$myord} desc limit {$pagelimit} ");
while ($fsql->next_record()) {
$id = $fsql->f('id');
$title = $fsql->f('title');
$body = $fsql->f('body');
$memo = $fsql->f('memo');
$dtime = $fsql->f('dtime');
$uptime = $fsql->f('uptime');
$author = $fsql->f('author');
$cl = $fsql->f('cl');
$contype = $fsql->f('contype');
$dtime = date("Y-m-d", $dtime);
$uptime = date("Y-m-d", $uptime);
//不同contype的兼容处理
switch ($contype) {
case "techoffer":
$link = ROOTPATH . "tech/html/?" . $id . ".html";
break;
case "techdemand":
$link = ROOTPATH . "tech/demandhtml/?" . $id . ".html";
break;
default:
$link = ROOTPATH . $contype . "/html/?" . $id . ".html";
break;
}
$body = csubstr(ltrim(strip_tags($memo . $body)), 0, 100);
$title = csubstr($title, 0, $cutword);
$title = str_replace($key, "<span class='keyword'>" . $key . "</span>", $title);
$body = str_replace($key, "<span class='bodykeyword'>" . $key . "</span>", $body);
$var = array('title' => $title, 'link' => $link, 'target' => $target, 'cl' => $cl, 'author' => $author, 'dtime' => $dtime, 'uptime' => $uptime, 'body' => $body);
$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;
}
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;
}
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;
}
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;
}
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;
}
