function PhotoFabu()
{
global $msql, $fsql, $tsql;
$coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
$tempname = $GLOBALS["PLUSVARS"]["tempname"];
$memberid = $_COOKIE["MEMBERID"];
$memberid = htmlspecialchars($memberid);
//个人分类
$fsql->query("select * from {P}_photo_pcat where memberid='{$memberid}' order by xuhao");
while ($fsql->next_record()) {
$pcatid = $fsql->f("catid");
$pcat = $fsql->f("cat");
$pcatlist .= "<option value='" . $pcatid . "'>" . $pcat . "</option>";
}
//获取公共分类授权
$secureset = SecureClass("156");
//公共分类
$fsql->query("select * from {P}_photo_cat order by catpath");
while ($fsql->next_record()) {
$lpid = $fsql->f("pid");
$lcatid = $fsql->f("catid");
$cat = $fsql->f("cat");
$catpath = $fsql->f("catpath");
$lcatpath = explode(":", $catpath);
//当主分类有授权时读取下级分类
if (strstr($secureset, ":" . intval($lcatpath[0]) . ":")) {
for ($i = 0; $i < sizeof($lcatpath) - 2; $i++) {
$lcatpath[$i] = intval($lcatpath[$i]);
$tsql->query("select catid,cat from {P}_photo_cat where catid='{$lcatpath[$i]}'");
if ($tsql->next_record()) {
$ncatid = $tsql->f('cat');
$ncat = $tsql->f('cat');
$ppcat .= $ncat . "/";
}
}
if ($pid == $lcatid) {
$catlist .= "<option value='" . $lcatid . "' selected>" . $ppcat . $cat . "</option>";
} else {
$catlist .= "<option value='" . $lcatid . "'>" . $ppcat . $cat . "</option>";
}
$ppcat = "";
}
}
//专题
$fsql->query("select * from {P}_photo_proj order by id desc");
while ($fsql->next_record()) {
$projid = $fsql->f("id");
$project = $fsql->f("project");
$NowPath = fmpath($projid);
$musellist .= "<option value=" . $NowPath . ">" . $project . "</option>";
}
//模版解释
$Temp = LoadTemp($tempname);
$var = array('pname' => $_COOKIE["MEMBERPNAME"], 'catlist' => $catlist, 'pcatlist' => $pcatlist, 'musellist' => $musellist);
$str .= ShowTplTemp($Temp, $var);
return $str;
}
function DownFabu()
{
global $msql, $fsql, $tsql;
$coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
$tempname = $GLOBALS["PLUSVARS"]["tempname"];
$memberid = $_COOKIE["MEMBERID"];
$memberid = htmlspecialchars($memberid);
//个人分类
$fsql->query("select * from {P}_down_pcat where memberid='{$memberid}' order by xuhao");
while ($fsql->next_record()) {
$pcatid = $fsql->f("catid");
$pcat = $fsql->f("cat");
$pcatlist .= "<option value='" . $pcatid . "'>" . $pcat . "</option>";
}
//获取公共分类授权
$secureset = SecureClass("166");
//公共分类
$fsql->query("select * from {P}_down_cat order by catpath");
while ($fsql->next_record()) {
$lpid = $fsql->f("pid");
$lcatid = $fsql->f("catid");
$cat = $fsql->f("cat");
$catpath = $fsql->f("catpath");
$lcatpath = explode(":", $catpath);
//当主分类有授权时读取下级分类
if (strstr($secureset, ":" . intval($lcatpath[0]) . ":")) {
for ($i = 0; $i < sizeof($lcatpath) - 2; $i++) {
$lcatpath[$i] = intval($lcatpath[$i]);
$tsql->query("select catid,cat from {P}_down_cat where catid='{$lcatpath[$i]}'");
if ($tsql->next_record()) {
$ncatid = $tsql->f('cat');
$ncat = $tsql->f('cat');
$ppcat .= $ncat . "/";
}
}
if ($pid == $lcatid) {
$catlist .= "<option value='" . $lcatid . "' selected>" . $ppcat . $cat . "</option>";
} else {
$catlist .= "<option value='" . $lcatid . "'>" . $ppcat . $cat . "</option>";
}
$ppcat = "";
}
}
//专题
$fsql->query("select * from {P}_down_proj order by id desc");
while ($fsql->next_record()) {
$projid = $fsql->f("id");
$project = $fsql->f("project");
$NowPath = fmpath($projid);
$musellist .= "<option value=" . $NowPath . ">" . $project . "</option>";
}
//积分名称
$defcentid = $GLOBALS["DOWNCONF"]["DefaultCentId"];
$centyj = $GLOBALS["DOWNCONF"]["CentYj"] * 100;
if ($defcentid < 1 || $defcentid > 5) {
$defcentid = "1";
}
$msql->query("select * from {P}_member_centset");
if ($msql->next_record()) {
$centname1 = $msql->f('centname1');
$centname2 = $msql->f('centname2');
$centname3 = $msql->f('centname3');
$centname4 = $msql->f('centname4');
$centname5 = $msql->f('centname5');
}
$centstr = "centname" . $defcentid;
$centlist = "<option value='" . $defcentid . "'>" . ${$centstr} . "</option>";
//模版解释
$Temp = LoadTemp($tempname);
$var = array('pname' => $_COOKIE["MEMBERPNAME"], 'catlist' => $catlist, 'pcatlist' => $pcatlist, 'centlist' => $centlist, 'centyj' => $centyj, 'musellist' => $musellist);
$str .= ShowTplTemp($Temp, $var);
return $str;
}
$downcent = htmlspecialchars($_POST["downcent"]);
$tags = $_POST["tags"];
$spe_selec = $_POST["spe_selec"];
$body = $_POST["body"];
$body = Url2Path($body);
$fileurl = $_POST["fileurl"];
$file = $_FILES["file"];
//分类path
$msql->query("select catpath from {P}_down_cat where catid='{$catid}'");
if ($msql->next_record()) {
$catpath = $msql->f('catpath');
}
$catArr = explode(":", $catpath);
$bigcatid = intval($catArr[0]);
//公共分类发布授权校验
$secureset = SecureClass("166");
if ($_POST["catid"] != "0" && !strstr($secureset, ":" . $bigcatid . ":")) {
echo $Meta . $strNoRights;
exit;
}
if ($title == "") {
echo $Meta . $strDownNTC1;
exit;
}
if (strlen($title) > 200) {
echo $Meta . $strDownNTC2;
exit;
}
if (strlen($body) > 65000) {
echo $Meta . $strDownNTC3;
exit;
function DownModify()
{
global $msql, $fsql, $tsql;
$coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
$tempname = $GLOBALS["PLUSVARS"]["tempname"];
//模版解释
$Temp = LoadTemp($tempname);
$id = $_REQUEST["id"];
$id = htmlspecialchars($id);
$memberid = $_COOKIE["MEMBERID"];
$msql->query("select * from {P}_down_con where id='{$id}' and memberid='{$memberid}'");
if ($msql->next_record()) {
$catid = $msql->f('catid');
$mypcatid = $msql->f('pcatid');
$title = $msql->f('title');
$body = $msql->f('body');
$fileurl = $msql->f('fileurl');
$author = $msql->f('author');
$source = $msql->f('source');
$memo = $msql->f('memo');
$tags = $msql->f('tags');
$proj = $msql->f('proj');
$downcent = $msql->f('downcent');
$downcentid = $msql->f('downcentid');
} else {
return "Invalied ID";
}
if ($src != "") {
$icon = "image.gif";
$src = ROOTPATH . $src;
} else {
$icon = "noimage.gif";
}
$body = htmlspecialchars($body);
$body = Path2Url($body);
//个人分类
$fsql->query("select * from {P}_down_pcat where memberid='{$memberid}' order by xuhao");
while ($fsql->next_record()) {
$pcatid = $fsql->f("catid");
$pcat = $fsql->f("cat");
if ($mypcatid == $pcatid) {
$pcatlist .= "<option value='" . $pcatid . "' selected>" . $pcat . "</option>";
} else {
$pcatlist .= "<option value='" . $pcatid . "'>" . $pcat . "</option>";
}
}
//获取公共分类授权
$secureset = SecureClass("166");
//公共分类
$fsql->query("select * from {P}_down_cat order by catpath");
while ($fsql->next_record()) {
$lpid = $fsql->f("pid");
$lcatid = $fsql->f("catid");
$cat = $fsql->f("cat");
$catpath = $fsql->f("catpath");
$lcatpath = explode(":", $catpath);
//当主分类有授权时读取下级分类
if (strstr($secureset, ":" . intval($lcatpath[0]) . ":")) {
for ($i = 0; $i < sizeof($lcatpath) - 2; $i++) {
$tsql->query("select catid,cat from {P}_down_cat where catid='{$lcatpath[$i]}'");
if ($tsql->next_record()) {
$ncatid = $tsql->f('cat');
$ncat = $tsql->f('cat');
$ppcat .= $ncat . "/";
}
}
if ($catid == $lcatid) {
$catlist .= "<option value='" . $lcatid . "' selected>" . $ppcat . $cat . "</option>";
} else {
$catlist .= "<option value='" . $lcatid . "'>" . $ppcat . $cat . "</option>";
}
$ppcat = "";
}
}
//标签处理
$tags = explode(",", $tags);
//专题
$fsql->query("select * from {P}_down_proj order by id desc");
while ($fsql->next_record()) {
$projid = $fsql->f("id");
$project = $fsql->f("project");
$NowPath = fmpath($projid);
$musellist .= "<option value=" . $NowPath . ">" . $project . "</option>";
}
//已选专题
$arrs = explode(":", $proj);
for ($k = 0; $k < sizeof($arrs) - 1; $k++) {
$projid = $arrs[$k] + 0;
$tsql->query("select project from {P}_down_proj where id='{$projid}'");
if ($tsql->next_record()) {
$project = $tsql->f('project');
}
$munowlist .= "<option value=" . $arrs[$k] . ">" . $project . "</option>";
}
//积分名称
$defcentid = $GLOBALS["DOWNCONF"]["DefaultCentId"];
$centyj = $GLOBALS["DOWNCONF"]["CentYj"] * 100;
if ($defcentid < 1 || $defcentid > 5) {
$defcentid = "1";
}
$msql->query("select * from {P}_member_centset");
if ($msql->next_record()) {
$centname1 = $msql->f('centname1');
$centname2 = $msql->f('centname2');
$centname3 = $msql->f('centname3');
$centname4 = $msql->f('centname4');
$centname5 = $msql->f('centname5');
}
$centstr = "centname" . $defcentid;
$centlist = "<option value='" . $defcentid . "'>" . ${$centstr} . "</option>";
//模版解释
$var = array('catlist' => $catlist, 'pcatlist' => $pcatlist, 'author' => $author, 'source' => $source, 'memo' => $memo, 'icon' => $icon, 'fileurl' => $fileurl, 'title' => $title, 'id' => $id, 'musellist' => $musellist, 'munowlist' => $munowlist, 'tags0' => $tags[0], 'tags1' => $tags[1], 'tags2' => $tags[2], 'tags3' => $tags[3], 'tags4' => $tags[4], 'centlist' => $centlist, 'centyj' => $centyj, 'downcent' => $downcent, 'body' => $body);
$str = ShowTplTemp($Temp, $var);
return $str;
}
function PhotoModify()
{
global $msql, $fsql, $tsql;
$coltitle = $GLOBALS["PLUSVARS"]["coltitle"];
$tempname = $GLOBALS["PLUSVARS"]["tempname"];
//模版解释
$Temp = LoadTemp($tempname);
$id = $_REQUEST["id"];
$id = htmlspecialchars($id);
$memberid = $_COOKIE["MEMBERID"];
$memberid = htmlspecialchars($memberid);
$msql->query("select * from {P}_photo_con where id='{$id}' and memberid='{$memberid}'");
if ($msql->next_record()) {
$catid = $msql->f('catid');
$mypcatid = $msql->f('pcatid');
$title = $msql->f('title');
$src = $msql->f('src');
$author = $msql->f('author');
$source = $msql->f('source');
$memo = $msql->f('memo');
$tags = $msql->f('tags');
$proj = $msql->f('proj');
} else {
return "Invalied ID";
}
if ($src != "") {
$icon = "image.gif";
$src = ROOTPATH . $src;
} else {
$icon = "noimage.gif";
}
//个人分类
$fsql->query("select * from {P}_photo_pcat where memberid='{$memberid}' order by xuhao");
while ($fsql->next_record()) {
$pcatid = $fsql->f("catid");
$pcat = $fsql->f("cat");
if ($mypcatid == $pcatid) {
$pcatlist .= "<option value='" . $pcatid . "' selected>" . $pcat . "</option>";
} else {
$pcatlist .= "<option value='" . $pcatid . "'>" . $pcat . "</option>";
}
}
//获取公共分类授权
$secureset = SecureClass("156");
//公共分类
$fsql->query("select * from {P}_photo_cat order by catpath");
while ($fsql->next_record()) {
$lpid = $fsql->f("pid");
$lcatid = $fsql->f("catid");
$cat = $fsql->f("cat");
$catpath = $fsql->f("catpath");
$lcatpath = explode(":", $catpath);
//当主分类有授权时读取下级分类
if (strstr($secureset, ":" . intval($lcatpath[0]) . ":")) {
for ($i = 0; $i < sizeof($lcatpath) - 2; $i++) {
$tsql->query("select catid,cat from {P}_photo_cat where catid='{$lcatpath[$i]}'");
if ($tsql->next_record()) {
$ncatid = $tsql->f('cat');
$ncat = $tsql->f('cat');
$ppcat .= $ncat . "/";
}
}
if ($catid == $lcatid) {
$catlist .= "<option value='" . $lcatid . "' selected>" . $ppcat . $cat . "</option>";
} else {
$catlist .= "<option value='" . $lcatid . "'>" . $ppcat . $cat . "</option>";
}
$ppcat = "";
}
}
//标签处理
$tags = explode(",", $tags);
//专题
$fsql->query("select * from {P}_photo_proj order by id desc");
while ($fsql->next_record()) {
$projid = $fsql->f("id");
$project = $fsql->f("project");
$NowPath = fmpath($projid);
$musellist .= "<option value=" . $NowPath . ">" . $project . "</option>";
}
//已选专题
$arrs = explode(":", $proj);
for ($k = 0; $k < sizeof($arrs) - 1; $k++) {
$projid = $arrs[$k] + 0;
$tsql->query("select project from {P}_photo_proj where id='{$projid}'");
if ($tsql->next_record()) {
$project = $tsql->f('project');
}
$munowlist .= "<option value=" . $arrs[$k] . ">" . $project . "</option>";
}
//模版解释
$var = array('catlist' => $catlist, 'pcatlist' => $pcatlist, 'author' => $author, 'source' => $source, 'memo' => $memo, 'icon' => $icon, 'src' => $src, 'title' => $title, 'id' => $id, 'musellist' => $musellist, 'munowlist' => $munowlist, 'tags0' => $tags[0], 'tags1' => $tags[1], 'tags2' => $tags[2], 'tags3' => $tags[3], 'tags4' => $tags[4]);
$str = ShowTplTemp($Temp, $var);
return $str;
}
