$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']}'");
}
