<?php !function_exists('html') && exit('ERR'); ck_power('joinlist'); $fid = intval($fid); if ($job == "list") { $rows = 20; if ($page < 1) { $page = 1; } $min = ($page - 1) * $rows; $SQL = ""; //搜索的时候 if ($search_type && $keyword) { $SQL = " AND C.{$search_type}='{$keyword}' "; } $query = $db->query("SELECT SQL_CALC_FOUND_ROWS A.*,C.* FROM {$_pre}person A LEFT JOIN {$_pre}content_2 C ON A.id=C.id WHERE 1 {$SQL} ORDER BY A.posttime DESC LIMIT {$min},{$rows}"); $RS = $db->get_one("SELECT FOUND_ROWS()"); $totalNum = $RS['FOUND_ROWS()']; while ($rs = $db->fetch_array($query)) { $Module_db->showfield($module_DB[2][field], $rs, 'list'); $rs[picurl] = tempdir($rs[icon]); $rs[posttime] = date("y-m-d H:i:s", $rs[posttime]); $rs[ifcom] = $rs[levels] ? "<A HREF='{$admin_path}&action=work&jobs=uncom&id={$rs['id']}' style='color:red;'>已推荐</A>" : "<A HREF='{$admin_path}&action=work&jobs=com&id={$rs['id']}'>未推荐</A>"; $listdb[] = $rs; } $showpage = getpage("", "", "{$admin_path}&search_type={$search_type}&keyword={$keyword}", $rows, $totalNum); get_admin_html('list'); } elseif ($action == "del") { $rs = $db->get_one("SELECT * FROM {$_pre}person WHERE id='{$id}'"); $db->query("DELETE FROM {$_pre}person WHERE id='{$id}'");
<?php !function_exists('html') && exit('ERR'); ck_power('form_content'); if ($job == "list") { if (!$mid) { $query = $db->query("SELECT * FROM {$_pre}module ORDER BY list DESC,id ASC"); while ($rs = $db->fetch_array($query)) { @extract($db->get_one("SELECT COUNT(*) AS NUM FROM {$_pre}content WHERE mid='{$rs['id']}'")); $rs[NUM] = $NUM; $Mdb[$rs[id]] = $rs; } get_admin_html('list'); exit; } $mid = intval($mid); $fidDB = $db->get_one("SELECT * FROM {$_pre}module WHERE id='{$mid}'"); $array = unserialize($fidDB[config]); $rows = 20; if ($page < 1) { $page = 1; } $min = ($page - 1) * $rows; $showpage = getpage("{$_pre}content", "WHERE mid='{$mid}'", "{$admin_path}&job=list&mid={$mid}", $rows); $query = $db->query("SELECT C.*,D.* FROM {$_pre}content C LEFT JOIN {$_pre}content_{$mid} D ON C.id=D.id WHERE C.mid='{$mid}' ORDER BY C.id DESC LIMIT {$min},{$rows}"); while ($rs = $db->fetch_array($query)) { foreach ($array[listshow_db] as $key => $rs2) { $rs[$key] = SRC_true_value($array[field_db][$key], $rs[$key]); } $rs[posttime] = date("Y-m-d", $rs[posttime]); $listdb[] = $rs;
<?php !function_exists('html') && exit('ERR'); ck_power('sort'); if ($job == "listsort") { $fid = intval($fid); $listdb = array(); module_list_all_sort(0, 0); $sortdb = $listdb; $sort_fup = $Guidedb->Select("{$_pre}sort", "fup", $fid); get_admin_html('sort'); } elseif ($action == "addsort") { if ($fup) { $rs = $db->get_one("SELECT name,class,type FROM {$_pre}sort WHERE fid='{$fup}' "); if (!$rs[type]) { showmsg('终结栏目下面不能创建分类'); } $class = $rs['class']; $db->query("UPDATE {$_pre}sort SET sons=sons+1 WHERE fid='{$fup}'"); } else { $class = 0; } $class++; $db->query("INSERT INTO {$_pre}sort (name,fup,class,type,allowcomment) VALUES ('{$name}','{$fup}','{$class}','{$type}',1) "); @extract($db->get_one("SELECT fid FROM {$_pre}sort ORDER BY fid DESC LIMIT 0,1")); mod_sort_class("{$_pre}sort", 0, 0); //更新class mod_sort_sons("{$_pre}sort", 0); //更新sons module_fid_cache(); jump("创建成功", $FROMURL);
<?php !function_exists('html') && exit('ERR'); ck_power('form_module'); if ($job == "list") { $query = $db->query("SELECT * FROM {$_pre}module ORDER BY list DESC,id ASC"); while ($rs = $db->fetch_array($query)) { $rss = $db->get_one("SELECT count(*) AS NUM FROM {$_pre}content WHERE mid='{$rs['id']}' "); $rs[NUM] = $rss[NUM]; $listdb[] = $rs; } get_admin_html('list'); } elseif ($job == "set") { $rsdb = $db->get_one("SELECT * FROM {$_pre}module WHERE id='{$id}'"); $group_post = group_box("allowpost", explode(",", $rsdb[allowpost])); $group_view = group_box("allowview", explode(",", $rsdb[allowview])); $rsdb[endtime] = $rsdb[endtime] == 0 ? '' : date("Y-m-d H:i:s", $rsdb[endtime]); $rsdb[about] = editor_replace($rsdb[about]); $usetitle[$rsdb[usetitle]] = ' checked '; $repeatpost[$rsdb[repeatpost]] = ' checked '; get_admin_html('set'); } elseif ($action == "set") { $postdb[endtime] && ($postdb[endtime] = preg_replace("/([\\d]+)-([\\d]+)-([\\d]+) ([\\d]+):([\\d]+):([\\d]+)/eis", "mk_time('\\4','\\5', '\\6', '\\2', '\\3', '\\1')", $postdb[endtime])); $allowpost = implode(",", $allowpost); $allowview = implode(",", $allowview); $db->query("UPDATE {$_pre}module SET allowpost='{$allowpost}',allowview='{$allowview}',endtime='{$postdb['endtime']}',name='{$postdb['name']}',about='{$postdb['about']}',usetitle='{$postdb['usetitle']}',repeatpost='{$postdb['repeatpost']}',statename='{$postdb['statename']}' WHERE id='{$id}'"); jump("修改成功", "{$FROMURL}", 1); } elseif ($action == "editlist") { foreach ($order as $key => $value) { $db->query("UPDATE {$_pre}module SET list='{$value}' WHERE id='{$key}' "); }
<?php function_exists('html') or exit('ERR'); ck_power('comment'); if ($job == "list") { !$page && ($page = 1); $rows = 20; $min = ($page - 1) * $rows; $showpage = getpage("{$_pre}comments", "", "{$admin_path}&job={$job}", "{$rows}"); $query = $db->query(" SELECT * FROM {$_pre}comments ORDER BY cid DESC LIMIT {$min},{$rows} "); while ($rs = $db->fetch_array($query)) { $rs[content] = filtrate(get_word($rs[content], 60)); $rs[posttime] = date("Y-m-d", $rs[posttime]); $rs[username] = $rs[username] ? $rs[username] : $rs[ip]; if ($rs[yz] == 1) { $rs[yz] = "<A HREF='{$admin_path}&action=list&jobs=unyz&ciddb[{$rs[cid]}]={$rs['cid']}' style='color:blue;'>ÒÑÉóºË</A>"; } elseif ($rs[yz] == 0) { $rs[yz] = "<A HREF='{$admin_path}&action=list&jobs=yz&ciddb[{$rs[cid]}]={$rs['cid']}' style='color:red;'>δÉóºË</A>"; } $listdb[] = $rs; } get_admin_html('list'); } elseif ($action == "list") { if (!$ciddb) { showmsg("ÇëÑ¡ÔñÒ»ÌõÆÀÂÛ"); } if ($jobs == "delete") { foreach ($ciddb as $key => $rs) { $rs = $db->get_one("SELECT id FROM {$_pre}comments WHERE cid='{$key}' "); $db->query(" UPDATE {$_pre}content SET comments=comments-1 WHERE id='{$rs['id']}' "); $db->query("DELETE FROM {$_pre}comments WHERE cid='{$key}' ");
<?php !function_exists('html') && exit('ERR'); ck_power('list'); $linkdb = array("全部信息" => "{$admin_path}&job=list", "已审核的信息" => "{$admin_path}&job=list&type=yz&fid={$fid}", "未审核的信息" => "{$admin_path}&job=list&type=unyz&fid={$fid}", "回收站的信息" => "{$admin_path}&job=list&type=del&fid={$fid}", "推荐信息" => "{$admin_path}&job=list&type=levels&fid={$fid}"); $fid = intval($fid); if ($job == "list") { $SQL = " WHERE 1 "; if ($fid > 0) { $SQL .= " AND fid={$fid} "; } if ($type == "yz") { $SQL .= " AND yz=1 "; } elseif ($type == "unyz") { $SQL .= " AND yz=0 "; } elseif ($type == "del") { $SQL .= " AND yz=2 "; } elseif ($type == "levels") { $SQL .= " AND levels=1 "; } elseif ($type == "unlevels") { $SQL .= " AND levels=0 "; } elseif ($type == "pic") { $SQL .= " AND ispic=1 "; } elseif ($type == "my") { $SQL .= " AND uid='{$userdb['uid']}' "; } elseif ($type == "title") { $SQL .= " AND binary title LIKE '%{$keyword}%' "; } elseif ($type == "id") { $SQL .= " AND id='{$keyword}' "; } elseif ($type == "content") { $SQL .= " AND binary content LIKE '%{$keyword}%' ";
<?php !function_exists('html') && exit('ERR'); ck_power('order'); if ($job == 'pay') { $db->query("UPDATE {$_pre}join SET ifpay='{$ifpay}' WHERE id='{$id}'"); } elseif ($job == 'send') { $db->query("UPDATE {$_pre}join SET ifsend='{$ifsend}' WHERE id='{$id}'"); } elseif ($act == 'del') { foreach ($iddb as $key => $value) { $db->query("DELETE FROM {$_pre}join WHERE id='{$value}'"); $db->query("DELETE FROM {$_pre}content_2 WHERE id='{$value}'"); } } $rows = 15; if (!$page) { $page = 1; } $min = ($page - 1) * $rows; unset($listdb, $i); $query = $db->query("SELECT SQL_CALC_FOUND_ROWS B.*,A.* FROM {$_pre}join A LEFT JOIN {$_pre}content_2 B ON A.id=B.id ORDER BY A.id DESC LIMIT {$min},{$rows}"); $RS = $db->get_one("SELECT FOUND_ROWS()"); $totalNum = $RS['FOUND_ROWS()']; $showpage = getpage("", "", "{$admin_path}&job={$job}", $rows, $totalNum); while ($rs = $db->fetch_array($query)) { $_erp = $Fid_db[tableid][$rs[fid]]; $rs[shop] = $db->get_one("SELECT * FROM {$_pre}content{$_erp} WHERE id='{$rs['cid']}'"); $rs[posttime] = date("m-d H:i", $rs[posttime]); if ($job == 'buyer') { $rs[pay] = $rs[ifpay] ? "<A style='color:red;'>已付款</A>" : "<A style='color:blue;'>未付款</A>"; $rs[send] = $rs[ifsend] ? "<A style='color:red;'>已发货</A>" : "<A style='color:blue;'>未发货</A>";
<?php function_exists('html') or exit('ERR'); $linkdb = array("栏目管理" => "{$admin_path}&job=listsort&type=all"); if ($job == "post" && ck_power('sort_post')) { unset($listdb, $linkdb); $listdb = array(); list_m_allsort($fid, 0); get_admin_html('post'); } elseif ($job == "listsort" && ck_power('sort_listsort')) { $type = 'all'; $SQL = ''; $fid = intval($fid); if ($step == 2) { if ($Type == 'name') { $SQL = " S.name LIKE '%{$name}%' "; } else { $SQL = " S.fid='{$name}' "; } } elseif ($type == "all") { $SQL = '1'; } else { $SQL = " S.fup='{$fid}' "; } $fup_select = select_wn_bigsort("fid", $fid); $sortdb = array(); $rows = 500; if (!$page) { $page = 1; } $min = ($page - 1) * $rows;
$query = $db->query("SELECT * FROM {$_pre}content ORDER BY id DESC LIMIT {$min},{$rows}"); while ($rs = $db->fetch_array($query)) { @extract($db->get_one("SELECT COUNT(*) AS NUM FROM {$_pre}apply WHERE cid='{$rs['id']}'")); $NUM = intval($NUM); if ($NUM) { $rs[joinnum] = "<A HREF='{$admin_path}&job=listmember&cid={$rs['id']}'>{$NUM}人(查看)</A>"; } else { $rs[joinnum] = 0; } $rs[posttime] = date('Y-m-d H:i:s', $rs[posttime]); $rs[ifcom] = $rs[levels] ? "<A HREF='{$admin_path}&action=work&jobs=uncom&id={$rs['id']}' style='color:red;'>已推荐</A>" : "<A HREF='{$admin_path}&action=work&jobs=com&id={$rs['id']}'>未推荐</A>"; $listdb[] = $rs; } $showpage = getpage("", "", "{$admin_path}&", $rows, $totalNum); get_admin_html('list'); } elseif ($job == 'listmember' && ck_power('list_listmember')) { $rows = 20; if ($page < 1) { $page = 1; } $min = ($page - 1) * $Lrows; if ($cid) { $SQL = " WHERE B.cid='{$cid}' "; $ORDER = " B.id "; } else { $SQL = " "; $ORDER = " A.id "; } $query = $db->query("SELECT SQL_CALC_FOUND_ROWS C.*,C.id AS person_id,B.posttime,B.id AS apply_id,A.title,A.id,A.fid FROM {$_pre}apply B LEFT JOIN {$_pre}content_2 C ON B.join_id=C.id LEFT JOIN {$_pre}content A ON A.id=B.cid {$SQL} ORDER BY {$ORDER} DESC LIMIT {$min},{$rows}"); $RS = $db->get_one("SELECT FOUND_ROWS()"); $totalNum = $RS['FOUND_ROWS()'];
$Info_GroupPostYZ = group_news_box("webdbs[Info_GroupPostYZ]", explode(",", $webdb[Info_GroupPostYZ]), 1); $InfoShowComment[intval($webdb[InfoShowComment])] = " checked "; $Info_PassCommentType[intval($webdb[Info_PassCommentType])] = " checked "; $Info_ShowCommentType[intval($webdb[Info_ShowCommentType])] = " checked "; $Info_PostCommentType[intval($webdb[Info_PostCommentType])] = " checked "; $yzImgComment[intval($webdb[yzImgComment])] = " checked "; $module_close[intval($webdb[module_close])] = " checked "; get_admin_html('config'); } elseif ($action == "config" && ck_power('center_config')) { if (isset($webdbs[Info_MakeIndexHtmlTime]) && !$webdbs[Info_MakeIndexHtmlTime] && $webdb[Info_MakeIndexHtmlTime]) { @unlink(Mpath . "index.htm.bak"); rename(Mpath . "index.htm", Mpath . "index.htm.bak"); } module_write_config_cache($webdbs); refreshto($FROMURL, "Ð޸ijɹ¦"); } elseif ($job == "label" && ck_power('center_label')) { echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL={$Murl}/index.php?jobs=show'>"; exit; } function group_news_box($name = "postdb[group]", $ckdb = array(), $type = '') { global $db, $pre; if ($type == 1) { $SQL = " WHERE gid NOT IN(2) "; } $query = $db->query("SELECT * FROM {$pre}group {$SQL} ORDER BY gid ASC"); while ($rs = $db->fetch_array($query)) { $checked = in_array($rs[gid], $ckdb) ? "checked" : ""; $show .= "<input type='checkbox' name='{$name}[]' value='{$rs[gid]}' {$checked}> {$rs[grouptitle]} "; } return $show;
<?php !function_exists('html') && exit('ERR'); ck_power('content'); if ($job == "list") { $rows = 20; $page < 1 && ($page = 1); $min = ($page - 1) * $rows; $SQL = " WHERE 1 "; if ($fid) { $SQL .= " AND fid={$fid} "; } require_once Adminpath . "../data/all_fid.php"; $query = $db->query("SELECT SQL_CALC_FOUND_ROWS * FROM `{$_pre}content` {$SQL} ORDER BY id DESC LIMIT {$min},{$rows}"); $RS = $db->get_one("SELECT FOUND_ROWS()"); $totalNum = $RS['FOUND_ROWS()']; $showpage = getpage('', '', "{$admin_path}&job={$job}&fid={$fid}", $rows, $totalNum); while ($rs = $db->fetch_array($query)) { $rs[content] = get_word($rs[content], 50); $rs[ismember] = $rs[uid] ? "会员" : "游客"; $rs[ifyz] = $rs[yz] ? "<A HREF='{$admin_path}&job=check&Yz=0&id={$rs['id']}' style='color:blue;'><img alt='已通过审核,点击取消审核' src='../member/images/check_yes.gif'></A>" : "<A HREF='{$admin_path}&job=check&Yz=1&id={$rs['id']}' style='color:red;'><img alt='还没通过审核,点击通过审核' src='../member/images/check_no.gif'></A>"; $listdb[] = $rs; } get_admin_html('list'); } elseif ($action == "delete") { if (!$listdb && $id) { $db->query("DELETE FROM `{$_pre}content` WHERE id='{$id}'"); jump("删除成功", "{$FROMURL}", 0); } foreach ($listdb as $key => $value) { $db->query("DELETE FROM `{$_pre}content` WHERE id='{$value}'");
<?php !function_exists('html') && exit('ERR'); ck_power('report'); $report_type = explode("\r\n", "\r\n" . $webdb[Info_ReportDB]); unset($report_type[0]); if ($job == 'list') { $rows = 20; $page < 1 && ($page = 1); $min = ($page - 1) * $rows; $showpage = getpage("{$_pre}report", "", "{$admin_path}&job={$job}", $rows); $query = $db->query("SELECT A.*,B.id,B.rid,B.iftrue,B.username AS Rname,B.posttime AS Rtime,B.type AS Rtype,B.content AS about FROM {$_pre}report B LEFT JOIN {$_pre}content A ON A.id=B.id ORDER BY B.rid DESC LIMIT {$min},{$rows}"); while ($rs = $db->fetch_array($query)) { //if(!$rs[title]&&$_rs=get_id_info($rs[id])){ // $rs=$_rs[$rs[id]]+$rs; //} if ($rs[iftrue] == 1) { $rs[iftrue] = "<font color=red>属实</font>"; } elseif ($rs[iftrue] == 2) { $rs[iftrue] = "<font color=blue>不属实</font>"; } else { $rs[iftrue] = "待确认"; } $rs[posttime] = date("m-d H:i", $rs[posttime]); $rs[Rtime] = date("m-d H:i", $rs[Rtime]); $rs[url] = get_info_url($rs[id], $rs[fid], $rs[city_id]); $listdb[] = $rs; } get_admin_html('list'); } elseif ($jobs == "del" || $action == "del") { if ($rid) {
<?php function_exists('html') or exit('ERR'); ck_power('module'); $linkdb["模块管理"] = "{$admin_path}&job=listsort"; if ($id) { $linkdb["全部字段"] = "{$admin_path}&job=editsort&id={$id}"; $linkdb["增加字段"] = "{$admin_path}&job=addfield&id={$id}"; $linkdb["生成模块"] = "{$admin_path}&job=tpl&id={$id}"; } //列出现有模型 if ($job == "listsort") { if ($page < 1) { $page = 1; } $rows = 100; $min = ($page - 1) * $rows; $SQL = " WHERE 1 "; if ($sort_id) { $SQL .= " AND A.sort_id='{$sort_id}' "; } $showpage = getpage("{$_pre}module A", "{$SQL}", "{$admin_path}&job={$job}&sort_id={$sort_id}", "{$rows}"); $query = $db->query("SELECT A.* FROM {$_pre}module A {$SQL} ORDER BY A.sort_id ASC,A.list DESC LIMIT {$min},{$rows}"); while ($rs = $db->fetch_array($query)) { $rss = $db->get_one("SELECT count(*) AS NUM FROM {$_pre}sort WHERE mid='{$rs['id']}' "); $rs[NUM] = $rss[NUM]; $listdb[] = $rs; } get_admin_html('sort'); } elseif ($action == "editlist") { foreach ($order as $key => $value) {
<?php function_exists('html') or exit('ERR'); ck_power('center'); //$linkdb=array("核心设置"=>"center.php?job=config"); if ($job) { $query = $db->query(" SELECT * FROM {$_pre}config "); while ($rs = $db->fetch_array($query)) { $webdb[$rs[c_key]] = $rs[c_value]; } } if ($job == "label") { echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=../{$dirname}/index.php?jobs=show'>"; exit; } elseif ($job == "config") { $showNoPassComment[intval($webdb[showNoPassComment])] = ' checked '; $webdb[Info_webOpen] ? $Info_webOpen1 = 'checked' : ($Info_webOpen0 = 'checked'); $Info_webOpen[intval($webdb[Info_webOpen])] = ' checked '; $yzImgGuestBook[intval($webdb[yzImgGuestBook])] = ' checked '; $viewNoPassGuestBook[intval($webdb[viewNoPassGuestBook])] = ' checked '; $ifOpenGuestBook[intval($webdb[ifOpenGuestBook])] = ' checked '; $groupPassPassGuestBook = group_box("webdbs[groupPassPassGuestBook]", explode(",", $webdb[groupPassPassGuestBook])); $module_close[intval($webdb[module_close])] = " checked "; get_admin_html('config'); } elseif ($action == "config") { if (isset($webdbs[Info_webadmin])) { $webdbs[Info_webadmin] = filtrate($webdbs[Info_webadmin]); $db->query("UPDATE {$pre}module SET adminmember='{$webdbs['Info_webadmin']}' WHERE id='{$webdb['module_id']}'"); } if (isset($webdbs[Info_weburl])) { $webdbs[Info_weburl] = filtrate($webdbs[Info_weburl]);
<?php !function_exists('html') && exit('ERR'); ck_power('city'); if ($job == "list") { $fid = intval($fid); $sortdb = array(); list__allsort($fid); get_admin_html('sort'); } elseif ($action == "addsort") { $class = 1; $type = 1; /*分类标志*/ $detail = explode("\r\n", $name); foreach ($detail as $key => $value) { if ($value) { $db->query("INSERT INTO {$_pre}city (name,fup,class,type,allowcomment) VALUES ('{$value}','{$fup}','{$class}','{$type}',1) "); } } /*更新导航缓存*/ cache_area(); refreshto($FROMURL, "创建成功"); } elseif ($job == "editsort") { $postdb[fid] && ($fid = $postdb[fid]); $rsdb = $db->get_one("SELECT * FROM {$_pre}city WHERE fid='{$fid}'"); $sort_fid = $Guidedb->Select("{$_pre}city", "postdb[fid]", $fid, "{$admin_path}&job={$job}"); get_admin_html('editsort'); } elseif ($action == "editsort") { $db->query("UPDATE {$_pre}city SET fup='{$postdb['fup']}',name='{$postdb['name']}',type='{$postdb['type']}',admin='{$postdb['admin']}',passwd='{$postdb['passwd']}',logo='{$postdb['logo']}',descrip='{$postdb['descrip']}',style='{$postdb['style']}',template='{$postdb['template']}',jumpurl='{$postdb['jumpurl']}',listorder='{$postdb['listorder']}',maxperpage='{$postdb['maxperpage']}',allowcomment='{$postdb['allowcomment']}',allowpost='{$postdb['allowpost']}',allowviewtitle='{$postdb['allowviewtitle']}',allowviewcontent='{$postdb['allowviewcontent']}',allowdownload='{$postdb['allowdownload']}',forbidshow='{$postdb['forbidshow']}',config='{$postdb['config']}'{$SQL} WHERE fid='{$postdb['fid']}' "); /*更新导航缓存*/ cache_area();
<?php !function_exists('html') && exit('ERR'); if ($job) { $query = $db->query("SELECT * FROM {$_pre}config"); while ($rs = $db->fetch_array($query)) { $webdb[$rs[c_key]] = $rs[c_value]; } } if ($job == "label" && ck_power('center_label')) { echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL={$Murl}/index.php?jobs=show'>"; exit; } elseif ($job == "config" && ck_power('center_config')) { $module_close[intval($webdb[module_close])] = " checked "; get_admin_html('config'); } elseif ($action == "config" && ck_power('center_config')) { module_write_config_cache($webdbs); refreshto($FROMURL, "Ð޸ijɹ¦"); }
<?php !function_exists('html') && exit('ERR'); ck_power('collection'); if ($job == "list") { $mid = 2; $rows = 20; if ($page < 1) { $page = 1; } $min = ($page - 1) * $rows; $query = $db->query("SELECT A.id AS meid,A.memberuid,A.companyuid,C.*,D.title AS companyname FROM {$_pre}collection A LEFT JOIN {$_pre}content_2 C ON A.memberuid=C.uid LEFT JOIN {$pre}hy_company D ON A.companyuid=D.uid ORDER BY A.id DESC LIMIT {$min},{$rows}"); while ($rs = $db->fetch_array($query)) { $Module_db->showfield($module_DB[2]['field'], $rs, 'list'); $rs[posttime] = date('m-d H:i', $rs[posttime]); $listdb[] = $rs; } $showpage = getpage("{$_pre}collection", "", "{$admin_path}&job={$job}", $rows); get_admin_html('list'); } if ($action == "del") { foreach ($iddb as $key => $value) { $db->query("DELETE FROM {$_pre}collection WHERE id='{$value}'"); } jump("ɾ³ý³É¹¦", $FROMURL, 0); }