$query = "select " . ReturnSqlListF($modid) . " from {$dbtbpre}ecms_" . $class_r[$classid]['tbname'] . " where " . $yhadd . $add; $totalnum = intval($_GET['totalnum']); if ($totalnum < 1) { $totalquery = "select count(*) as total from {$dbtbpre}ecms_" . $class_r[$classid]['tbname'] . " where " . $yhadd . $add; $num = $empire->gettotal($totalquery); //取得总条数 } else { $num = $totalnum; } $search .= "&totalnum={$num}"; //排序 if (empty($class_r[$classid][reorder])) { $addorder = "newstime desc"; } else { $addorder = $class_r[$classid][reorder]; } $query .= " order by " . ReturnSetTopSql('list') . $addorder . " limit {$offset},{$line}"; $sql = $empire->query($query); $returnpage = DoWapListPage($num, $line, $page, $search); //系统模型 $ret_r = ReturnAddF($modid, 2); //参数 $ecmsvar_mbr = array(); $ecmsvar_mbr['wapstyle'] = $wapstyle; $ecmsvar_mbr['fbclassid'] = $bclassid; $ecmsvar_mbr['fclassid'] = $classid; $ecmsvar_mbr['fcpage'] = $page; $ecmsvar_mbr['urladdcs'] = ewap_UrlAddCs(); require 'template/' . $usewapstyle . '/list.temp.php'; db_close(); $empire = null;
function DoDocInfo($tb, $r, $ecms = 0) { global $empire, $dbtbpre, $class_r, $emod_r; if ($ecms == 1) { $table = $dbtbpre . 'ecms_' . $tb . '_doc_index'; //索引表 $table1 = $dbtbpre . 'ecms_' . $tb . '_doc'; //主表 $table2 = $dbtbpre . 'ecms_' . $tb . '_doc_data'; //副表 $ytable = $dbtbpre . 'ecms_' . $tb . '_index'; //目标索引表 $ytable1 = $dbtbpre . 'ecms_' . $tb; //目标主表 $ytable2 = $dbtbpre . 'ecms_' . $tb . '_data_' . $r[stb]; //目标副表 } else { $table = $dbtbpre . 'ecms_' . $tb . '_index'; //索引表 $table1 = $dbtbpre . 'ecms_' . $tb; //主表 $table2 = $dbtbpre . 'ecms_' . $tb . '_data_' . $r[stb]; //副表 $ytable = $dbtbpre . 'ecms_' . $tb . '_doc_index'; //目标索引表 $ytable1 = $dbtbpre . 'ecms_' . $tb . '_doc'; //目标主表 $ytable2 = $dbtbpre . 'ecms_' . $tb . '_doc_data'; //目标副表 } $mid = $class_r[$r[classid]][modid]; //索引表 $index_r = $empire->fetch1("select * from " . $table . " where id='{$r['id']}' limit 1"); if ($index_r['checked'] == 0) { return ''; } //副表 $fr = $empire->fetch1("select " . ReturnSqlFtextF($mid) . " from " . $table2 . " where id='{$r['id']}' limit 1"); $r = array_merge($r, $fr); $ret_r = ReturnAddF($r, $mid, $userid, $username, 10, 0, 0); //返回自定义字段 //索引表 $empire->query("insert into " . $ytable . "(id,classid,checked,newstime,truetime,lastdotime,havehtml) values('{$index_r['id']}','{$index_r['classid']}','{$index_r['checked']}','{$index_r['newstime']}','{$index_r['truetime']}','{$index_r['lastdotime']}','{$index_r['havehtml']}');"); //主表 $empire->query("replace into " . $ytable1 . "(id,classid,ttid,onclick,plnum,totaldown,newspath,filename,userid,username,firsttitle,isgood,ispic,istop,isqf,ismember,isurl,truetime,lastdotime,havehtml,groupid,userfen,titlefont,titleurl,stb,fstb,restb,keyboard" . $ret_r[fields] . ") values('{$r['id']}','{$r['classid']}','{$r['ttid']}','{$r['onclick']}','{$r['plnum']}','{$r['totaldown']}','" . StripAddsData($r[newspath]) . "','" . StripAddsData($r[filename]) . "','{$r['userid']}','" . StripAddsData($r[username]) . "','{$r['firsttitle']}','{$r['isgood']}','{$r['ispic']}','{$r['istop']}','{$r['isqf']}','{$r['ismember']}','{$r['isurl']}','{$r['truetime']}','{$r['lastdotime']}','{$r['havehtml']}','{$r['groupid']}','{$r['userfen']}','" . StripAddsData($r[titlefont]) . "','" . StripAddsData($r[titleurl]) . "','{$r['stb']}','{$r['fstb']}','{$r['restb']}','" . StripAddsData($r[keyboard]) . "'" . $ret_r[values] . ");"); //副表 $empire->query("replace into " . $ytable2 . "(id,classid,keyid,dokey,newstempid,closepl,haveaddfen,infotags" . $ret_r[datafields] . ") values('{$r['id']}','{$r['classid']}','{$r['keyid']}','{$r['dokey']}','{$r['newstempid']}','{$r['closepl']}','{$r['haveaddfen']}','" . StripAddsData($r[infotags]) . "'" . $ret_r[datavalues] . ");"); //删除 $empire->query("delete from " . $table . " where id='{$r['id']}'"); $empire->query("delete from " . $table1 . " where id='{$r['id']}'"); $empire->query("delete from " . $table2 . " where id='{$r['id']}'"); //更新栏目信息数 if ($ecms == 1) { AddClassInfos($r['classid'], '+1', '+1'); } else { AddClassInfos($r['classid'], '-1', '-1'); } }
$cid = $classid; } $listurl = "list.php?classid=" . $cid . "&style=" . $wapstyle . "&bclassid=" . $bclassid . "&page=" . $cpage; $r = $empire->fetch1("select * from {$dbtbpre}ecms_" . $class_r[$classid]['tbname'] . " where id='{$id}' limit 1"); if (!$r['id'] || $classid != $r[classid]) { DoWapShowMsg('您来自的链接不存在', $listurl); } if ($r['groupid'] || $class_r[$classid]['cgtoinfo']) { DoWapShowMsg('此信息不能查看', $listurl); } //系统模型 $modid = $class_r[$classid][modid]; //副表 $finfor = $empire->fetch1("select " . ReturnSqlFtextF($modid) . " from {$dbtbpre}ecms_" . $class_r[$classid]['tbname'] . "_data_" . $r[stb] . " where id='{$r['id']}' limit 1"); $r = array_merge($r, $finfor); $ret_r = ReturnAddF($modid, 1); //更新点击 $empire->query("update {$dbtbpre}ecms_" . $class_r[$classid]['tbname'] . " set onclick=onclick+1 where id='{$id}' limit 1"); $r['onclick'] = $r['onclick'] + 1; $pagetitle = DoWapClearHtml($r['title']); //存文本内容 $savetxtf = $emod_r[$modid]['savetxtf']; if ($savetxtf && $r[$savetxtf]) { $r[$savetxtf] = GetTxtFieldText($r[$savetxtf]); } //分页字段 $pagef = $emod_r[$modid]['pagef']; if ($pagef && $r[$pagef]) { //替换掉分页符 $r[$pagef] = str_replace('[!--empirenews.page--]', '', $r[$pagef]); $r[$pagef] = str_replace('[/!--empirenews.page--]', '', $r[$pagef]);
function DoDocInfo($tb, $r, $ecms = 0) { global $empire, $dbtbpre, $class_r, $emod_r; if ($ecms == 1) { $table1 = $dbtbpre . 'ecms_' . $tb . '_doc'; //主表 $table2 = $dbtbpre . 'ecms_' . $tb . '_doc_data'; //副表 $ytable1 = $dbtbpre . 'ecms_' . $tb; //目标主表 $ytable2 = $dbtbpre . 'ecms_' . $tb . '_data_' . $r[stb]; //目标副表 } else { $table1 = $dbtbpre . 'ecms_' . $tb; //主表 $table2 = $dbtbpre . 'ecms_' . $tb . '_data_' . $r[stb]; //副表 $ytable1 = $dbtbpre . 'ecms_' . $tb . '_doc'; //目标主表 $ytable2 = $dbtbpre . 'ecms_' . $tb . '_doc_data'; //目标副表 } $mid = $class_r[$r[classid]][modid]; //副表 if ($emod_r[$mid]['tbdataf'] && $emod_r[$mid]['tbdataf'] != ',') { $selectdataf = substr($emod_r[$mid]['tbdataf'], 1, -1); $fr = $empire->fetch1("select " . $selectdataf . " from " . $table2 . " where id='{$r['id']}'"); $r = array_merge($r, $fr); } $ret_r = ReturnAddF($r, $mid, $userid, $username, 10, 0, 0); //返回自定义字段 //主表 $empire->query("replace into " . $ytable1 . "(id,classid,onclick,newspath,keyboard,keyid,userid,username,ztid,checked,istop,truetime,ismember,dokey,userfen,isgood,titlefont,titleurl,filename,groupid,newstempid,plnum,firsttitle,isqf,totaldown,closepl,havehtml,lastdotime,haveaddfen,infopfen,infopfennum,votenum,stb,copyids,ttid,infotags,ispic" . $ret_r[fields] . ") values('{$r['id']}','{$r['classid']}','{$r['onclick']}','" . StripAddsData($r[newspath]) . "','" . StripAddsData($r[keyboard]) . "','{$r['keyid']}','{$r['userid']}','" . StripAddsData($r[username]) . "','{$r['ztid']}','{$r['checked']}','{$r['istop']}','{$r['truetime']}','{$r['ismember']}','{$r['dokey']}','{$r['userfen']}','{$r['isgood']}','" . StripAddsData($r[titlefont]) . "','" . StripAddsData($r[titleurl]) . "','" . StripAddsData($r[filename]) . "','{$r['groupid']}','{$r['newstempid']}','{$r['plnum']}','{$r['firsttitle']}','{$r['isqf']}','{$r['totaldown']}','{$r['closepl']}','{$r['havehtml']}','{$r['lastdotime']}','{$r['haveaddfen']}','{$r['infopfen']}','{$r['infopfennum']}','{$r['votenum']}','{$r['stb']}','{$r['copyids']}','{$r['ttid']}','" . StripAddsData($r[infotags]) . "','{$r['ispic']}'" . $ret_r[values] . ");"); //副表 $empire->query("replace into " . $ytable2 . "(id,classid" . $ret_r[datafields] . ") values('{$r['id']}','{$r['classid']}'" . $ret_r[datavalues] . ");"); //删除 $empire->query("delete from " . $table1 . " where id='{$r['id']}'"); $empire->query("delete from " . $table2 . " where id='{$r['id']}'"); }